package com.example.erp.mapper.mm;
|
|
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.Order;
|
import com.example.erp.entity.sd.OrderDetail;
|
import com.example.erp.entity.sd.Product;
|
import com.example.erp.entity.userInfo.User;
|
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 FinishedGoodsInventoryMapper extends CrudRepository<FinishedGoodsInventory,Long> {
|
|
|
|
List<FinishedGoodsInventory> defaultfinishedGoods(@Param("offset") Integer offset,
|
@Param("pageSize") Integer pageSize,
|
@Param("finishedGoodsInventory") FinishedGoodsInventory finishedGoodsInventory);
|
|
Map<String,Integer> getPageTotal(Integer offset, Integer pageSize, FinishedGoodsInventory finishedGoodsInventory);
|
|
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);
|
|
Integer finishedGoodsInventorybycount(@Param("orderId") String orderId,
|
@Param("orderNumber") Integer orderNumber);
|
|
Integer findOrderQuantity(String orderId);
|
|
Integer findOrderNumberdsum(String orderId);
|
|
Integer findOrderDeliveryQuantitySum(String orderId);
|
|
Integer findDeliveryQuantity(String deliveryId);
|
|
Integer findDeliverydetailsum(String deliveryId,Integer deliveryDetailState);
|
|
Boolean updateInventory(@Param("flowCard") FlowCard flowCard,
|
@Param("storageRegion") String storageRegion,
|
@Param("remark") String remark);
|
|
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") Integer quantity);
|
|
Boolean updateOutOrderNumberConut( @Param("orderId") String orderId,
|
@Param("orderNumber") Integer orderNumber,
|
@Param("quantity") Integer 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);
|
|
Boolean insertFinishedGoodsInventory(@Param("flowCard") FlowCard flowCard,
|
@Param("storageRegion") String storageRegion,
|
@Param("remark") String remark);
|
|
|
List<OrderDetail> getSelectDeliveryDetail(@Param("offset") Integer offset,
|
@Param("pageSize") Integer pageSize,
|
@Param("orderDetail") OrderDetail orderDetail);
|
|
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);
|
Boolean updateInventoryquantityInt(@Param("orderId") String orderId,
|
@Param("orderNumber") Integer orderNumber,
|
@Param("quantity") Integer quantity);
|
|
Boolean updateInventoryInventoryOut(@Param("orderId") String orderId,
|
@Param("orderNumber") Integer orderNumber,
|
@Param("quantity") Integer quantity);
|
Boolean updateInventoryInventoryInt(@Param("orderId") String orderId,
|
@Param("orderNumber") Integer orderNumber,
|
@Param("quantity") Integer quantity);
|
|
|
}
|
