Subversion Repositories SmartDukaan

Rev

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

Rev 6361 Rev 6362
Line 43... Line 43...
43 
    JOIN lineitem l
 43 
    JOIN lineitem l
44 
        ON (l.itemId = i.itemId AND l.purchaseOrder_id = po.id)
 44 
        ON (l.itemId = i.itemId AND l.purchaseOrder_id = po.id)
45 
    JOIN supplier s
 45 
    JOIN supplier s
46 
        ON (s.id = po.supplierId)
 46 
        ON (s.id = po.supplierId)
47 
    WHERE po.createdAt BETWEEN #{startDate} AND #{endDate}
47 
    WHERE po.createdAt BETWEEN #{startDate} AND #{endDate}
48 
    GROUP BY p.purchaseOrder_id, i.itemId
 48 
    GROUP BY p.purchaseOrder_id, p.id, i.itemId
49 
    ORDER BY p.purchaseOrder_id, i.itemId
 49 
    ORDER BY p.purchaseOrder_id, p.id, i.itemId
50 
  </select>
 50 
  </select>
51
51
52 
  <select id="fetchMismatchScansPerInvoiceNumber" parameterType="java.util.Date" resultType="invoiceScan" >
 52 
  <select id="fetchMismatchScansPerInvoiceNumber" parameterType="java.util.Date" resultType="invoiceScan" >
53 
    SELECT i.invoiceNumber, i.numItems, sum(initialQuantity) as scannedQuantity, i.date, s.name as supplierName
 53 
    SELECT i.invoiceNumber, i.numItems, sum(initialQuantity) as scannedQuantity, i.date, s.name as supplierName
54 
    FROM invoice i
 54 
    FROM invoice i