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, @Param("ids") List<Long> ids);
|
|
|
Map<String,Integer> getSelectMaterialInventoryPageTotal(Integer offset, Integer pageSize, MaterialInventory materialInventory, @Param("ids") List<Long> ids);
|
|
List<Map<String,Object>> getSelectMaterialInventoryEngineering(@Param("offset") Integer offset,
|
@Param("pageSize") Integer pageSize,
|
@Param("optimizeUse") OptimizeUse optimizeUse, @Param("ids") List<Long> ids);
|
|
|
Map<String,Integer> getSelectMaterialInventoryEngineeringPageTotal(Integer offset, Integer pageSize, OptimizeUse optimizeUse, @Param("ids") List<Long> ids);
|
|
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);
|
|
Boolean updateMaterialInventoryArea(@Param("materialCode") Long materialCode,@Param("singlePieceArea") Double singlePieceArea);
|
|
}
|
