Subversion Repositories SmartDukaan

Rev

Rev 7957 | Rev 8603 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 7957 Rev 8580
Line 44... Line 44...
44
44
45
45
46 
  <select id="getPurchaseScans" parameterType="map" resultType="detailedPurchaseScan">
 46 
  <select id="getPurchaseScans" parameterType="map" resultType="detailedPurchaseScan">
47 
    SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
 47 
    SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
48 
        GROUP_CONCAT(DISTINCT(p.invoiceNumber)) AS invoiceNumbers, GROUP_CONCAT(DISTINCT(inv.receivedFrom)) AS receivedBy, i.itemId,
 48 
        GROUP_CONCAT(DISTINCT(p.invoiceNumber)) AS invoiceNumbers, GROUP_CONCAT(DISTINCT(inv.receivedFrom)) AS receivedBy, i.itemId,
49 
        brand, modelName, modelNumber, color, unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt, p.id as purchaseId, nlc
49 
        brand, modelName, modelNumber, color, unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt,
- 
 
 50 
        p.id as purchaseId, nlc, po.warehouseId
50 
    FROM purchase p
 51 
    FROM purchase p
51 
    JOIN purchaseorder po
52 
    JOIN purchaseorder po
52 
        ON (po.id = p.purchaseOrder_id)
 53 
        ON (po.id = p.purchaseOrder_id)
53 
    JOIN inventoryItem i
 54 
    JOIN inventoryItem i
54 
        ON (p.id = i.purchaseId)
 55 
        ON (p.id = i.purchaseId)
Line 65... Line 66...
65 
  </select>
 66 
  </select>
66
67
67 
  <select id="getPurchaseScansByGrnDate" parameterType="map" resultType="detailedPurchaseScan">
 68 
  <select id="getPurchaseScansByGrnDate" parameterType="map" resultType="detailedPurchaseScan">
68 
    SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
 69 
    SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
69 
        p.invoiceNumber AS invoiceNumbers, inv.receivedFrom AS receivedBy, i.itemId,brand, modelName, modelNumber, color,
70 
        p.invoiceNumber AS invoiceNumbers, inv.receivedFrom AS receivedBy, i.itemId,brand, modelName, modelNumber, color,
70 
        unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt, p.id as purchaseId, nlc
71 
        unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt, p.id as purchaseId,
- 
 
 72 
        nlc, po.warehouseId
71 
    FROM purchase p
 73 
    FROM purchase p
72 
    JOIN purchaseorder po
74 
    JOIN purchaseorder po
73 
        ON (po.id = p.purchaseOrder_id)
 75 
        ON (po.id = p.purchaseOrder_id)
74 
    JOIN inventoryItem i
 76 
    JOIN inventoryItem i
75 
        ON (p.id = i.purchaseId)
 77 
        ON (p.id = i.purchaseId)