| 4500 |
mandeep.dh |
1 |
<?xml version="1.0" encoding="UTF-8"?>
|
|
|
2 |
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
|
|
|
3 |
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
|
|
|
4 |
|
|
|
5 |
<mapper namespace="in.shop2020.warehouse.persistence.InventoryItemMapper">
|
|
|
6 |
<resultMap type="inventoryItem" id="inventoryItemResult">
|
|
|
7 |
<id property="id" column="id"/>
|
|
|
8 |
</resultMap>
|
|
|
9 |
|
|
|
10 |
<insert id="insertInventoryItem" parameterType="inventoryItem" useGeneratedKeys="true" keyProperty="id">
|
|
|
11 |
INSERT INTO inventoryItem
|
|
|
12 |
(itemId, itemNumber, serialNumber, initialQuantity, currentQuantity, purchaseId)
|
|
|
13 |
VALUES
|
|
|
14 |
(#{itemId}, #{itemNumber}, #{serialNumber}, #{initialQuantity}, #{currentQuantity}, #{purchaseId})
|
|
|
15 |
</insert>
|
|
|
16 |
|
|
|
17 |
<select id="getInventoryItemFromSerialNumber" resultType="inventoryItem" parameterType="java.lang.String">
|
|
|
18 |
SELECT *
|
|
|
19 |
FROM inventoryItem
|
|
|
20 |
WHERE serialNumber = #{serialNumber}
|
|
|
21 |
</select>
|
|
|
22 |
|
|
|
23 |
<select id="getInventoryItem" resultType="inventoryItem" parameterType="java.lang.Long">
|
|
|
24 |
SELECT *
|
|
|
25 |
FROM inventoryItem
|
|
|
26 |
WHERE id = #{id}
|
|
|
27 |
</select>
|
|
|
28 |
</mapper>
|