Subversion Repositories SmartDukaan

Rev

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

Rev 6362 Rev 6364
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 
    AND lastScanType != 'DOA_REPLACED'
48 
    GROUP BY p.purchaseOrder_id, p.id, i.itemId
 49 
    GROUP BY p.purchaseOrder_id, p.id, i.itemId
49 
    ORDER BY p.purchaseOrder_id, p.id, i.itemId
 50 
    ORDER BY p.purchaseOrder_id, p.id, i.itemId
50 
  </select>
 51 
  </select>
51
52
52 
  <select id="fetchMismatchScansPerInvoiceNumber" parameterType="java.util.Date" resultType="invoiceScan" >
 53 
  <select id="fetchMismatchScansPerInvoiceNumber" parameterType="java.util.Date" resultType="invoiceScan" >