package com.example.erp.mapper.sd;
|
|
import com.example.erp.entity.pp.FlowCard;
|
import com.example.erp.entity.sd.Delivery;
|
import com.example.erp.entity.sd.DeliveryDetail;
|
import com.example.erp.entity.sd.Order;
|
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.util.List;
|
import java.util.Map;
|
|
@Mapper
|
public interface DeliveryMapper extends CrudRepository<Delivery,Long> {
|
|
List<Delivery> getSelectShippingOrder(@Param("offset") Integer offset,
|
@Param("pageSize") Integer pageSize,String startDate, String endDate,
|
@Param("delivery") Delivery delivery);
|
|
Delivery getSelectShippingOrderDetailDelivery(@Param("offset") Integer offset,
|
@Param("pageSize") Integer pageSize,
|
@Param("orderDetail") OrderDetail orderDetail);
|
|
Order getSelectShippingOrderDetailDeliverys(@Param("offset") Integer offset,
|
@Param("pageSize") Integer pageSize,
|
@Param("orderDetail") OrderDetail orderDetail);
|
Map<String,Integer> getSelectShippingOrderPageTotal(Integer offset, Integer pageSize, String startDate, String endDate, Delivery delivery);
|
|
List<Order> getSelectOrderInventory(@Param("offset") Integer offset,
|
@Param("pageSize") Integer pageSize,String startDate, String endDate,
|
@Param("order") Order order);
|
|
Map<String,Integer> getSelectOrderInventoryPageTotal(Integer offset, Integer pageSize,String startDate, String endDate, Order order);
|
|
Boolean insertDelivery(@Param("delivery") Delivery delivery,@Param("number") String number,@Param("orderId") String orderId);
|
|
Integer getDeliveryConut(@Param("deliveryId") String deliveryId);
|
|
Boolean updateDeliveryToExamine(@Param("deliveryId") String deliveryId,@Param("deliveryState") int deliveryState);
|
|
Boolean deleteDelivery(@Param("deliveryId") String deliveryId);
|
|
Integer getmaximum(@Param("type") String type);
|
|
Boolean updatedelivery(@Param("area") Double area,
|
@Param("quantity") Integer quantity,
|
@Param("money") Double money,
|
@Param("oddNumber") String oddNumber);
|
|
|
|
|
}
|
