ERP_override.git

New file
			@@ -0,0 +1,162 @@
			package com.example.erp.mapper.mm;

			import com.baomidou.mybatisplus.core.mapper.BaseMapper;
			import com.example.erp.dto.otherSystem.GlassDetailList;
			import com.example.erp.entity.mm.FinishedGoodsInventory;
			import com.example.erp.entity.mm.FinishedOperateLog;
			import com.example.erp.entity.pp.FlowCard;
			import com.example.erp.entity.sd.*;
			import org.apache.ibatis.annotations.Mapper;
			import org.apache.ibatis.annotations.Param;
			import org.springframework.data.repository.CrudRepository;

			import java.util.List;
			import java.util.Map;

			@Mapper
			public interface FinishedGoodsInventoryMapper extends BaseMapper<FinishedGoodsInventory> {



			List<FinishedGoodsInventory> defaultfinishedGoods(@Param("offset") Integer offset,
			@Param("pageSize") Integer pageSize,
			@Param("finishedGoodsInventory") FinishedGoodsInventory finishedGoodsInventory);

			Map<String,Integer> getPageTotal(@Param("offset") Integer offset,
			@Param("pageSize") Integer pageSize,
			@Param("finishedGoodsInventory") FinishedGoodsInventory finishedGoodsInventory);

			FlowCard getSelectWarehousingByProcessId(@Param("order_id") String order_id,
			@Param("order_number") Integer order_number,
			@Param("process_id") String process_id);
			List<FlowCard> getSelectWarehousing(@Param("offset") Integer offset,
			@Param("pageSize") Integer pageSize,
			@Param("flowCard") FlowCard flowCard);

			Map<String,Integer> getSelectWarehousingPageTotal(Integer offset, Integer pageSize,FlowCard flowCard);

			Integer findOrderNumberdcount(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber, String boxNo);

			FinishedGoodsInventory findOrderNumberd(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber);

			OrderDetail findOrderDetailNumberd(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber);

			Integer finishedGoodsInventorybycount(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber);

			Integer findOrderQuantity(String orderId);

			Delivery findOrderDelivery(String orderId);

			Integer findOrderNumberdsum(String orderId);

			Integer findOrderDeliveryQuantitySum(String orderId);

			Integer findDeliveryQuantity(String deliveryId);

			Integer findDeliverydetailsum(String deliveryId,Integer deliveryDetailState);

			Integer findFinishedOperateLogQuantity(String orderId);

			Boolean updateInventory(@Param("flowCard") FlowCard flowCard,
			@Param("storageRegion") String storageRegion,
			@Param("remark") String remark, @Param("container") String container);

			Boolean updateInventoryOut(@Param("finishedOperateLog") FinishedOperateLog finishedOperateLog);

			Boolean updateInventoryquantityavailable(@Param("orderDetail") OrderDetail orderDetail);
			Boolean updateflowcard(FlowCard flowCard);

			Boolean updateflowcardOut(@Param("finishedOperateLog") FinishedOperateLog finishedOperateLog);

			Boolean updateIntOrderNumberConut( @Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber,
			@Param("quantity") Long quantity);

			Boolean updateOutOrderNumberConut( @Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber,
			@Param("quantity") Integer quantity);

			Boolean updateOrderNumberConut( @Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber,
			@Param("quantity") Long quantity);


			Boolean updateOrderWarehousingState(String orderId,Integer state);

			Boolean updateOrderDeliveryState(String orderId,Integer state);

			Boolean updateDeliveryDeliveryState(String deliveryId,Integer state);

			Boolean updateDeliveryDetailState(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber, @Param("deliveryId") String deliveryId, Integer state, String remarks);

			Boolean insertFinishedGoodsInventory(@Param("flowCard") FlowCard flowCard,
			@Param("storageRegion") String storageRegion,
			@Param("remark") String remark, @Param("container") String container);


			List<OrderDetail> getSelectDeliveryDetail(@Param("offset") Integer offset,
			@Param("pageSize") Integer pageSize,
			@Param("orderDetail") OrderDetail orderDetail);

			List<OrderDetail> getSelectDeliveryDetailDeliveryId(@Param("deliveryId") String deliveryId);

			Map<String,Integer> getSelectDeliveryDetailPageTotal(Integer offset, Integer pageSize,OrderDetail orderDetail);

			List<OrderDetail> getSelectAllocate(@Param("offset") Integer offset,
			@Param("pageSize") Integer pageSize,
			@Param("orderDetail") OrderDetail orderDetail);

			Map<String,Integer> getSelectAllocatePageTotal(Integer offset, Integer pageSize,OrderDetail orderDetail);

			Boolean updateInventoryquantityAllocateOut(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber,
			@Param("quantity") Integer quantity);
			Boolean updateInventoryquantityAllocateInt(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber,
			@Param("quantity") Integer quantity);

			Boolean updateInventoryquantityOut(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber,
			@Param("quantity") Integer quantity,
			@Param("boxNo") String boxNo);
			Boolean updateInventoryquantityInt(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber,
			@Param("quantity") Integer quantity);
			Boolean updateInventoryquantityIntBybox(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber,
			@Param("quantity") Integer quantity, String boxNo);

			Boolean updateInventoryInventoryOut(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber,
			@Param("quantity") Integer quantity, String boxNo);
			Boolean updateInventoryInventoryInt(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber,
			@Param("quantity") Integer quantity, String remarks);

			List<OrderDetail> getSelectOrderDetail(String orderId);

			Boolean insertOrderFinishedGoodsInventory(@Param("orderDetail") OrderDetail orderDetail);

			Boolean updateOrderInventory(@Param("orderDetail") OrderDetail orderDetail);

			FlowCard findFlowCard(FlowCard flowCard);

			DeliveryDetail findDeliverydetail(@Param("orderId") String orderId,
			@Param("orderNumber") Integer orderNumber, @Param("deliveryId") String deliveryId, String boxNo);


			Integer findOrderNumberdContainercount(String orderId, Integer orderNumber, String container);

			List<Map<String, String>> getPrintTitleByBox(Integer customerId, String project, String boxNo,String orderId);

			List<Map<String, Object>> getorderProductByBoxNo(String orderId, String boxNo);

			List<Map<String, Object>> getPrintDetail(String orderId, String boxNo, Integer productId, String thickness);
			}