Subversion Repositories SmartDukaan

Rev

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

Rev 6364 Rev 6414
Line 94... Line 94...
94 
	  SELECT s.id, s.inventoryItemId, s.warehouseId, s.type, s.scannedAt,
94 
	  SELECT s.id, s.inventoryItemId, s.warehouseId, s.type, s.scannedAt,
95 
	  s.quantity, s.orderId from scanNew s JOIN inventoryItem i
95 
	  s.quantity, s.orderId from scanNew s JOIN inventoryItem i
96 
	  ON
96 
	  ON
97 
	  s.inventoryItemId = i.id
97 
	  s.inventoryItemId = i.id
98 
	  AND
 98 
	  AND
99 
	  i.itemId = itemId
99 
	  i.itemId = #{itemId}
100 
	  AND
 100 
	  AND
101 
	  s.scannedAt BETWEEN #{fromDate} AND #{toDate};
 101 
	  s.scannedAt BETWEEN #{fromDate} AND #{toDate};
102 
  </select>
 102 
  </select>
103
103
104 
</mapper>
 104 
</mapper>