Subversion Repositories SmartDukaan

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="in.shop2020.warehouse.persistence.ScanMapper">

  <resultMap type="scan" id="scanResult">

    <id property="id" column="id"/>

  </resultMap>

  <insert id="insert" parameterType="scan" useGeneratedKeys="true" keyProperty="id">

    INSERT INTO scanNew

      (inventoryItemId, warehouseId, type, scannedAt, quantity, orderId)

    VALUES

      (#{inventoryItemId}, #{warehouseId}, #{type}, NOW(), #{quantity}, #{orderId})

  </insert>

  <select id="get" parameterType="map" resultType="scan">

    SELECT * 

    FROM scanNew

    WHERE inventoryItemId = #{inventoryItemId}

    <if test="scanType != null">

        AND type = #{scanType}

    </if>

    ORDER BY scannedAt

  </select>

  <select id="getScansFromOrderId" parameterType="java.lang.Long" resultType="scan">

    SELECT * 

    FROM scanNew

    WHERE orderId = #{orderId}

    ORDER BY scannedAt

  </select>

</mapper>