Subversion Repositories SmartDukaan

Rev

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

Rev 5768 Rev 6322
Line 86... Line 86...
86 
    JOIN lineitem l
86 
    JOIN lineitem l
87 
        ON (l.purchaseOrder_id = p.purchaseOrder_id AND l.itemId = t.itemId)
 87 
        ON (l.purchaseOrder_id = p.purchaseOrder_id AND l.itemId = t.itemId)
88 
    GROUP BY t.itemId
88 
    GROUP BY t.itemId
89 
    HAVING SUM(currentQuantity) != 0
 89 
    HAVING SUM(currentQuantity) != 0
90 
  </select>
 90 
  </select>
- 
 
 91
- 
 
 92 
  <select id = "getScansForItem" parameterType = "map" resultType = "scan">
- 
 
 93 
	  SELECT s.id, s.inventoryItemId, s.warehouseId, s.type, s.scannedAt,
- 
 
 94 
	  s.quantity, s.orderId from scanNew s JOIN inventoryItem i
- 
 
 95 
	  ON
- 
 
 96 
	  s.inventoryItemId = i.id
- 
 
 97 
	  AND
- 
 
 98 
	  i.itemId = itemId
- 
 
 99 
	  AND
- 
 
 100 
	  s.scannedAt BETWEEN #{fromDate} AND #{toDate};
- 
 
 101 
  </select>
- 
 
 102
91 
</mapper>
 103 
</mapper>