Subversion Repositories SmartDukaan

  <insert id="createRemovalStockShipmentReference" parameterType="removalStockShipmentReference" useGeneratedKeys="true" keyProperty="id">

    INSERT INTO removalStockShipmentReference 

    (id, shipmentReference, createdOn, source, inventoryType, quantity, unfulfilQuantity, completed)

    VALUES

    (#{id}, #{shipmentReference}, #{createdOn}, #{source}, #{inventoryType}, #{quantity}, #{unfulfilQuantity}, #{completed})

  </insert>

  <update id="updateStockShipment" parameterType="map" >

    UPDATE removalStockShipmentReference

    SET 

    unfulfilQuantity = unfulfilQuantity - #{lineItemQuantity} 

    WHERE id= #{id}

  </update>

  <update id="markStockShipmentComplete" parameterType= "java.lang.Long" >

  	UPDATE removalStockShipmentReference

  	SET 

  	completed =1 

  	WHERE id= #{id}

  </update>

  <select id="getAllUnCompletedStockShipments" parameterType="java.lang.String" resultType= "removalStockShipmentReference">

  	SELECT * FROM 

  	removalStockShipmentReference 

  	WHERE source= #{source} 

  	AND completed = 0 

  </select>

  <update id="updateShipmentReferenceTransferLot" parameterType="map">

  	UPDATE transferLot

  	SET 

  	shipmentReference = #{shipmentReference}

  	WHERE id= #{id}

  </update>

  <select id="getRemovalStockShipmentReferenceById" parameterType="java.lang.Long" resultType= "removalStockShipmentReference">

  	SELECT * FROM

  	removalStockShipmentReference 

  	WHERE id= #{id}

  </select>