Subversion Repositories SmartDukaan

Rev

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

Rev 6414 Rev 6467
Line 99... Line 99...
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 
  <insert id="scanForPurchaseReturn" parameterType="scan" useGeneratedKeys="true" keyProperty="id">
- 
 
 105 
    INSERT INTO scanNew
- 
 
 106 
      (inventoryItemId, warehouseId, type, scannedAt, quantity)
- 
 
 107 
    VALUES
- 
 
 108 
      (#{inventoryItemId}, #{warehouseId}, #{type}, NOW(), #{quantity})
- 
 
 109 
  </insert>
- 
 
 110
104 
</mapper>
 111 
</mapper>