Subversion Repositories SmartDukaan

Rev

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

Rev 5437 Rev 5496
Line 46... Line 46...
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, i.itemId
49 
    ORDER BY p.purchaseOrder_id, i.itemId
 49 
    ORDER BY p.purchaseOrder_id, i.itemId
50 
  </select>
 50 
  </select>
- 
 
 51
- 
 
 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
- 
 
 54 
    FROM invoice i
- 
 
 55 
    JOIN supplier s
- 
 
 56 
        ON (s.id = i.supplierId)
- 
 
 57 
    LEFT JOIN purchase p
- 
 
 58 
        ON (p.invoiceNumber = i.invoiceNumber)
- 
 
 59 
    LEFT JOIN inventoryItem ii ON (ii.purchaseId = p.id)
- 
 
 60 
    WHERE i.date = #{date}
- 
 
 61 
    GROUP BY i.invoiceNumber, i.numItems
- 
 
 62 
    HAVING SUM(initialQuantity) != i.numItems
- 
 
 63 
  </select>
51 
 
 64 
 
52 
</mapper>
 65 
</mapper>