Subversion Repositories SmartDukaan

Rev

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

Rev 6322 Rev 6361
Line 32... Line 32...
32 
  </select>
 32 
  </select>
33
33
34 
  <select id="getPurchaseScans" parameterType="map" resultType="detailedPurchaseScan">
 34 
  <select id="getPurchaseScans" parameterType="map" resultType="detailedPurchaseScan">
35 
    SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
 35 
    SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
36 
        GROUP_CONCAT(DISTINCT(invoiceNumber)) AS invoiceNumbers, i.itemId,
 36 
        GROUP_CONCAT(DISTINCT(invoiceNumber)) AS invoiceNumbers, i.itemId,
37 
        brand, modelName, modelNumber, color, unitPrice, SUM(initialQuantity) AS quantity
 37 
        brand, modelName, modelNumber, color, unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt, p.id as purchaseId
38 
    FROM purchase p
 38 
    FROM purchase p
39 
    JOIN purchaseorder po
39 
    JOIN purchaseorder po
40 
        ON (po.id = p.purchaseOrder_id)
 40 
        ON (po.id = p.purchaseOrder_id)
41 
    JOIN inventoryItem i
 41 
    JOIN inventoryItem i
42 
        ON (p.id = i.purchaseId)
 42 
        ON (p.id = i.purchaseId)