| | |
| | | |
| | | IPage<StockUninventoryDto> pageStockUninventory(Page page, @Param("ew") StockUninventoryDto stockUninventoryDto); |
| | | |
| | | int updateSubtractStockUnInventory(StockUninventoryDto stockUninventoryDto); |
| | | int updateSubtractStockUnInventory(@Param("ew") StockUninventoryDto stockUninventoryDto); |
| | | |
| | | int updateAddStockUnInventory(StockUninventoryDto stockUninventoryDto); |
| | | int updateAddStockUnInventory(@Param("ew") StockUninventoryDto stockUninventoryDto); |
| | | |
| | | List<StockInventoryExportData> listStockInventoryExportData(@Param("ew") StockUninventoryDto stockUninventoryDto); |
| | | } |
| | |
| | | <result column="version" property="version" /> |
| | | </resultMap> |
| | | <update id="updateSubtractStockUnInventory"> |
| | | update stock_inventory |
| | | update stock_uninventory |
| | | <set> |
| | | <if test="ew.qualitity != null"> |
| | | qualitity = qualitity - #{ew.qualitity}, |
| | |
| | | where product_model_id = #{ew.productModelId} and qualitity >= #{ew.qualitity} |
| | | </update> |
| | | <update id="updateAddStockUnInventory"> |
| | | update stock_inventory |
| | | update stock_uninventory |
| | | <set> |
| | | <if test="ew.qualitity != null"> |
| | | qualitity = qualitity + #{ew.qualitity}, |