Subversion Repositories SmartDukaan

Rev

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

Rev 5496 Rev 5545
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 
        CONCAT_WS(" ", brand, modelName, modelNumber, color) AS itemName, unitPrice, SUM(initialQuantity) AS quantity
 37 
        brand, modelName, modelNumber, color, unitPrice, SUM(initialQuantity) AS quantity
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)