| New file |
| | |
|---|
| | | package com.example.erp.mapper.mm; |
|---|
| | | |
|---|
| | | import com.example.erp.entity.mm.*; |
|---|
| | | import com.example.erp.entity.pp.OptimizeUse; |
|---|
| | | import com.example.erp.entity.sd.Delivery; |
|---|
| | | import com.example.erp.entity.sd.DeliveryDetail; |
|---|
| | | import com.example.erp.entity.sd.OrderDetail; |
|---|
| | | import org.apache.ibatis.annotations.Mapper; |
|---|
| | | import org.apache.ibatis.annotations.Param; |
|---|
| | | import org.springframework.data.repository.CrudRepository; |
|---|
| | | |
|---|
| | | import java.time.LocalDate; |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.Map; |
|---|
| | | |
|---|
| | | @Mapper |
|---|
| | | public interface MaterialInventoryMapper extends CrudRepository<MaterialInventory,Long> { |
|---|
| | | |
|---|
| | | List<Map<String,Object>> getSelectMaterialInventoryDate(@Param("offset") Integer offset, |
|---|
| | | @Param("pageSize") Integer pageSize,String startDate, String endDate, |
|---|
| | | @Param("materialInventory") MaterialInventory materialInventory); |
|---|
| | | |
|---|
| | | |
|---|
| | | Map<String,Integer> getSelectMaterialInventoryDatePageTotal(Integer offset, Integer pageSize,String startDate, String endDate, MaterialInventory materialInventory); |
|---|
| | | |
|---|
| | | List<Map<String,Object>> getSelectMaterialInventoryEngineeringDate(@Param("offset") Integer offset, |
|---|
| | | @Param("pageSize") Integer pageSize,String startDate, String endDate, |
|---|
| | | @Param("materialInventory") MaterialInventory materialInventory); |
|---|
| | | |
|---|
| | | |
|---|
| | | Map<String,Integer> getSelectMaterialInventoryEngineeringDatePageTotal(Integer offset, Integer pageSize,String startDate, String endDate, MaterialInventory materialInventory); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | List<Map<String,Object>> getSelectMaterialInventory(@Param("offset") Integer offset, |
|---|
| | | @Param("pageSize") Integer pageSize, |
|---|
| | | @Param("materialInventory") MaterialInventory materialInventory); |
|---|
| | | |
|---|
| | | |
|---|
| | | Map<String,Integer> getSelectMaterialInventoryPageTotal(Integer offset, Integer pageSize, MaterialInventory materialInventory); |
|---|
| | | |
|---|
| | | List<Map<String,Object>> getSelectMaterialInventoryEngineering(@Param("offset") Integer offset, |
|---|
| | | @Param("pageSize") Integer pageSize, |
|---|
| | | @Param("optimizeUse") OptimizeUse optimizeUse); |
|---|
| | | |
|---|
| | | |
|---|
| | | Map<String,Integer> getSelectMaterialInventoryEngineeringPageTotal(Integer offset, Integer pageSize, OptimizeUse optimizeUse); |
|---|
| | | |
|---|
| | | Boolean insertMaterialStore(@Param("type") String type, |
|---|
| | | @Param("json") String json); |
|---|
| | | |
|---|
| | | Boolean updateMaterialStore(@Param("type") String type, |
|---|
| | | @Param("json") String json, @Param("id") Long id); |
|---|
| | | |
|---|
| | | Boolean deleteMaterialOutbound(@Param("materialOutboundId") String materialOutboundId); |
|---|
| | | |
|---|
| | | Integer getMaximum(@Param("type") String type); |
|---|
| | | |
|---|
| | | Integer getMaximums(@Param("type") String type); |
|---|
| | | |
|---|
| | | Integer getMaterialOutboundCount(@Param("materialOutboundId") String materialOutboundId); |
|---|
| | | |
|---|
| | | Integer getReturningWarehouseCount(@Param("returningId") String returningId); |
|---|
| | | |
|---|
| | | Integer getMaterialInventoryCount(@Param("materialCode") Long materialCode,@Param("dateOfManufacture") LocalDate dateOfManufacture); |
|---|
| | | |
|---|
| | | Integer getMaterialInventoryCountNull(@Param("materialCode") Long materialCode); |
|---|
| | | |
|---|
| | | |
|---|
| | | List<MaterialInventory> getMaterialInventoryCountId(@Param("materialCode") Long materialCode,@Param("dateOfManufacture") LocalDate dateOfManufacture); |
|---|
| | | |
|---|
| | | List<MaterialInventory> getMaterialInventoryCountNullId(@Param("materialCode") Long materialCode); |
|---|
| | | |
|---|
| | | List<MaterialOutboundDetail> getIsNotMaterialOutboundDetail( @Param("materialOutboundId") String materialOutboundId); |
|---|
| | | |
|---|
| | | List<ReturningWarehouseDetail> getIsNotReturningWarehouseDetail(@Param("returningId") String returningId); |
|---|
| | | |
|---|
| | | Boolean insertMaterialOutbound(@Param("materialOutbound") MaterialOutbound materialOutbound, @Param("number") String number); |
|---|
| | | |
|---|
| | | Boolean insertReturningWarehouse(@Param("returningWarehouse") ReturningWarehouse returningWarehouse, @Param("number") String number); |
|---|
| | | |
|---|
| | | Integer getMaterialOutboundDetailMaximum(@Param("materialOutboundId") String materialOutboundId); |
|---|
| | | |
|---|
| | | Integer getReturningWarehouseDetailMaximum(@Param("returningId") String returningId); |
|---|
| | | |
|---|
| | | Boolean insertMaterialOutboundDetail(@Param("materialOutboundDetail") MaterialOutboundDetail materialOutboundDetail, |
|---|
| | | @Param("number") String number, @Param("materialOutboundNumber") Integer materialOutboundNumber); |
|---|
| | | |
|---|
| | | Boolean insertReturningWarehouseDetail(@Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail, |
|---|
| | | @Param("number") String number, @Param("returningWarehouseNumber") Integer returningWarehouseNumber); |
|---|
| | | |
|---|
| | | Boolean updateReturningWarehouseDetail(@Param("number") String number, @Param("returningWarehouseNumber") Integer returningWarehouseNumber, |
|---|
| | | @Param("materialInventoryId") Long materialInventoryId); |
|---|
| | | |
|---|
| | | Boolean updateMaterialInventoryAvailableOptOut(@Param("useId") Integer useId, |
|---|
| | | @Param("quantity") Integer quantity); |
|---|
| | | Boolean updateMaterialInventoryAvailableOptInt(@Param("useId") Integer useId, |
|---|
| | | @Param("quantity") Integer quantity); |
|---|
| | | |
|---|
| | | Boolean updateMaterialInventoryAvailableOut(@Param("inventoryId") Long inventoryId, |
|---|
| | | @Param("quantity") Integer quantity); |
|---|
| | | Boolean updateMaterialInventoryAvailableInt(@Param("inventoryId") Long inventoryId, |
|---|
| | | @Param("quantity") Integer quantity); |
|---|
| | | Boolean updateMaterialInventoryInventoryOut(@Param("inventoryId") Long inventoryId, |
|---|
| | | @Param("quantity") Integer quantity); |
|---|
| | | Boolean updateMaterialInventoryInventoryInt(@Param("inventoryId") Long inventoryId, |
|---|
| | | @Param("quantity") Integer quantity); |
|---|
| | | |
|---|
| | | Boolean updateMaterialInventoryAvailableInventoryOut(@Param("inventoryId") Long inventoryId, |
|---|
| | | @Param("quantity") Integer quantity); |
|---|
| | | Boolean updateMaterialInventoryAvailableInventoryInt(@Param("inventoryId") Long inventoryId, |
|---|
| | | @Param("quantity") Integer quantity); |
|---|
| | | |
|---|
| | | Boolean deleteMaterialOutboundDetail(@Param("materialOutboundId") String materialOutboundId); |
|---|
| | | |
|---|
| | | Boolean deleteReturningWarehouseDetail(@Param("returningId") String returningId); |
|---|
| | | |
|---|
| | | List<MaterialOutbound> getSelectMaterialOutboundDate(@Param("offset") Integer offset, |
|---|
| | | @Param("pageSize") Integer pageSize,String startDate, String endDate, |
|---|
| | | @Param("materialOutbound") MaterialOutbound materialOutbound); |
|---|
| | | |
|---|
| | | Map<String,Integer> getSelectMaterialOutboundDatePageTotal(Integer offset, Integer pageSize,String startDate, String endDate,MaterialOutbound materialOutbound); |
|---|
| | | |
|---|
| | | |
|---|
| | | List<ReturningWarehouse> getSelectReturningWarehouseDate(@Param("offset") Integer offset, |
|---|
| | | @Param("pageSize") Integer pageSize,String startDate, String endDate, |
|---|
| | | @Param("returningWarehouse") ReturningWarehouse returningWarehouse); |
|---|
| | | |
|---|
| | | Map<String,Integer> getSelectReturningWarehouseDatePageTotal(Integer offset, Integer pageSize,String startDate, String endDate,ReturningWarehouse returningWarehouse); |
|---|
| | | |
|---|
| | | |
|---|
| | | MaterialOutbound getSelectMaterialOutbound(@Param("offset") Integer offset, |
|---|
| | | @Param("pageSize") Integer pageSize, |
|---|
| | | @Param("materialOutboundDetail") MaterialOutboundDetail materialOutboundDetail); |
|---|
| | | |
|---|
| | | List<MaterialOutboundDetail> SelectMaterialOutboundDetail(@Param("offset") Integer offset, |
|---|
| | | @Param("pageSize") Integer pageSize, |
|---|
| | | @Param("materialOutboundDetail") MaterialOutboundDetail materialOutboundDetail); |
|---|
| | | List<Map<String,Object>> getSelectMaterialOutboundDetail(@Param("offset") Integer offset, |
|---|
| | | @Param("pageSize") Integer pageSize, |
|---|
| | | @Param("materialOutboundDetail") MaterialOutboundDetail materialOutboundDetail); |
|---|
| | | |
|---|
| | | List<Map<String,Object>> getSelectMaterialOutboundEngineering(@Param("offset") Integer offset, |
|---|
| | | @Param("pageSize") Integer pageSize, |
|---|
| | | @Param("materialOutboundDetail") MaterialOutboundDetail materialOutboundDetail); |
|---|
| | | |
|---|
| | | Map<String,Integer> getSelectMaterialOutboundDetailPageTotal(Integer offset, Integer pageSize,MaterialOutboundDetail materialOutboundDetail); |
|---|
| | | |
|---|
| | | ReturningWarehouse getSelectReturningWarehouse(@Param("offset") Integer offset, |
|---|
| | | @Param("pageSize") Integer pageSize, |
|---|
| | | @Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail); |
|---|
| | | |
|---|
| | | List<Map<String,Object>> getSelectReturningWarehouseDetail(@Param("offset") Integer offset, |
|---|
| | | @Param("pageSize") Integer pageSize, |
|---|
| | | @Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail); |
|---|
| | | |
|---|
| | | Map<String,Integer> getSelectReturningWarehouseDetailPageTotal(Integer offset, Integer pageSize,ReturningWarehouseDetail returningWarehouseDetail); |
|---|
| | | |
|---|
| | | Boolean updateMaterialOutboundToExamine(@Param("materialOutboundId") String materialOutboundId,@Param("reviewedState") int reviewedState,@Param("reviewed") String reviewed); |
|---|
| | | |
|---|
| | | Boolean updateMaterialOutboundCounterExamination(@Param("materialOutboundId") String materialOutboundId,@Param("reviewedState") int reviewedState,@Param("reviewed") String reviewed); |
|---|
| | | |
|---|
| | | Boolean updateReturningWarehouseToExamine(@Param("returningId") String returningId,@Param("reviewedState") int reviewedState,@Param("reviewed") String reviewed); |
|---|
| | | |
|---|
| | | Boolean updateReturningWarehouseCounterExamination(@Param("returningId") String returningId,@Param("reviewedState") int reviewedState,@Param("reviewed") String reviewed); |
|---|
| | | |
|---|
| | | Boolean updateMaterialInventory(@Param("materialCode") Long materialCode,@Param("singlePieceArea") Double singlePieceArea, |
|---|
| | | @Param("totalArea") Double totalArea, |
|---|
| | | @Param("materialInventory") MaterialInventory materialInventory); |
|---|
| | | |
|---|
| | | Boolean insertMaterialInventory(@Param("materialCode") Long materialCode,@Param("singlePieceArea") Double singlePieceArea, |
|---|
| | | @Param("totalArea") Double totalArea, |
|---|
| | | @Param("materialInventory") MaterialInventory materialInventory); |
|---|
| | | |
|---|
| | | Boolean updateMaterialInventoryReturning(@Param("materialCode") Long materialCode,@Param("singlePieceArea") Double singlePieceArea, |
|---|
| | | @Param("totalArea") Double totalArea, |
|---|
| | | @Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail); |
|---|
| | | |
|---|
| | | Boolean updateMaterialInventoryReturningNull(@Param("materialCode") Long materialCode,@Param("singlePieceArea") Double singlePieceArea, |
|---|
| | | @Param("totalArea") Double totalArea, |
|---|
| | | @Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail); |
|---|
| | | |
|---|
| | | Boolean insertMaterialInventoryReturning(@Param("materialCode") Long materialCode,@Param("singlePieceArea") Double singlePieceArea, |
|---|
| | | @Param("totalArea") Double totalArea, |
|---|
| | | @Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail); |
|---|
| | | |
|---|
| | | } |
|---|
