*

lsh

4 天以前 49f306cb470a8ee824204b701796d1d8f63ff223

 src/main/java/com/zy/common/model/enumUtils/OrderInAndOutType.java

@@ -7,23 +7,24 @@
import com.zy.asrs.service.OrderDetlPakoutService;
import com.zy.asrs.service.OrderPakinService;
import com.zy.asrs.service.OrderPakoutService;
import com.zy.asrs.utils.OrderTransFormationUtil;
import lombok.Setter;
import org.apache.poi.ss.formula.functions.T;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;

import javax.annotation.PostConstruct;
import java.util.ArrayList;
import java.util.EnumSet;
import java.util.List;

/**
 * Created by IX on 2024/12/16
 */
public enum OrderInAndOutType {
    PAKIN{
        @Transactional
        public void implement(Class<T> tClass, Object param) {
        public void implement() {}

        }
        @Transactional
        public void query(String orderNo) {
            OrderPakin orderPakin = orderPakinService.selectByNo(orderNo);
@@ -32,27 +33,35 @@
            }
        }
        @Transactional
        public Order selectOrder(String orderNo) {
        public Order selectByNo(String orderNo) {
            OrderPakin orderPakin = orderPakinService.selectByNo(orderNo);
            if (Cools.isEmpty(orderPakin)) {
                return null;
            }
            Order order = new Order();
            order.sync(orderPakin);
            return order;
            return OrderTransFormationUtil.transformationOrderPakin(orderPakin);
        }
        @Transactional
        public List<OrderDetl> selectOrderDetl(Long orderId) {
            List<OrderDetl> orderDetlList = new ArrayList<>();
        public List<Order> selectBySettle(Long settle) {
            List<OrderPakin> orderPakinList = orderPakinService.selectBySettle(settle);
            return OrderTransFormationUtil.transformationOrderListPakin(orderPakinList);
        }
        @Transactional
        public List<OrderDetl> selectByOrderId(Long orderId) {
            List<OrderDetlPakin> orderDetlPakinList = orderDetlPakinService.selectByOrderId(orderId);
            if (!orderDetlPakinList.isEmpty()) {
                for (OrderDetlPakin orderDetlPakin : orderDetlPakinList){
                    OrderDetl orderDetl = new OrderDetl();
                    orderDetl.sync(orderDetlPakin);
                    orderDetlList.add(orderDetl);
                }
            }
            return orderDetlList;
            return OrderTransFormationUtil.transformationOrderDetlListPakin(orderDetlPakinList);
        }
        @Transactional
        public List<OrderDetl> selectWorkingDetls(Long orderId) {
            List<OrderDetlPakin> orderDetlPakinList = orderPakinService.selectWorkingDetls(orderId);
            return OrderTransFormationUtil.transformationOrderDetlListPakin(orderDetlPakinList);
        }
        @Transactional
        public void checkComplete(String orderNo) {
            orderPakinService.checkComplete(orderNo);
        }
        @Transactional
        public boolean saveHandlerOrder(Boolean pakin, WrkMast wrkMast, List<WrkDetl> wrkDetls) {
            return orderPakinService.saveHandlerOrder(pakin,wrkMast,wrkDetls);
        }
        @Transactional
        public void insertOrder(Order order) {
@@ -90,12 +99,98 @@
                throw new CoolException("生成单据明细失败，请联系管理员");
            }
        }
        @Transactional
        public void remove(Long orderId) {
            try{
                orderPakinService.remove(orderId);
            } catch (Exception e){
                throw new CoolException("删除单据失败");
            }
        }
        @Transactional
        public List<Order> selectComplete() {
            List<OrderPakin> orderPakinList = orderPakinService.selectComplete();
            return OrderTransFormationUtil.transformationOrderListPakin(orderPakinList);
        }

        @Transactional
        public List<Order> selectComplete8() {
            List<OrderPakin> orderPakinList = orderPakinService.selectComplete8();
            return OrderTransFormationUtil.transformationOrderListPakin(orderPakinList);
        }

        @Transactional
        public boolean addToLogTableOrder(Order order) {
            OrderPakin orderPakin = OrderTransFormationUtil.transformationPakin(order);
            return orderPakinService.addToLogTable(orderPakin);
        }

        @Transactional
        public List<Order> selectOrderNoL(String orderNo) {
            List<OrderPakin> orderPakinList = orderPakinService.selectorderNoL(orderNo);
            return OrderTransFormationUtil.transformationOrderListPakin(orderPakinList);
        }

        @Transactional
        public Order selectOrderMoveStatus() {
            OrderPakin orderPakin = orderPakinService.selectOrderMoveStatus();
            return OrderTransFormationUtil.transformationOrderPakin(orderPakin);
        }

        @Transactional
        public Order selectOrderMoveStatusInitial() {
            OrderPakin orderPakin = orderPakinService.selectOrderMoveStatusInitial();
            return OrderTransFormationUtil.transformationOrderPakin(orderPakin);
        }

        @Transactional
        public OrderDetl selectItem(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3) {
            OrderDetlPakin orderDetlPakin = orderDetlPakinService.selectItem(orderId, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3);
            return OrderTransFormationUtil.transformationOrderDetlPakin(orderDetlPakin);
        }

        @Transactional
        public OrderDetl selectItem(String orderNo, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3) {
            OrderDetlPakin orderDetlPakin = orderDetlPakinService.selectItem(orderNo, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3);
            return OrderTransFormationUtil.transformationOrderDetlPakin(orderDetlPakin);
        }

        @Transactional
        public OrderDetl findByLook(List<OrderDetl> orderDetls, Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3) {
            List<OrderDetlPakin> orderDetlPakins = OrderTransFormationUtil.transformationDetlListPakin(orderDetls);
            OrderDetlPakin orderDetlPakin = orderDetlPakinService.findByLook(orderDetlPakins, orderId, matnr,batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3);
            return OrderTransFormationUtil.transformationOrderDetlPakin(orderDetlPakin);
        }
        @Transactional
        public boolean increase(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double qty) {
            return orderDetlPakinService.increase(orderId, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3, qty);
        }
        @Transactional
        public boolean decrease(String orderNo, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double qty) {
            return orderDetlPakinService.decrease(orderNo, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3, qty);
        }
        @Transactional
        public boolean modifyStatus(Long orderId, Integer status) {
            return orderDetlPakinService.modifyStatus(orderId, status);
        }
        @Transactional
        public boolean addToLogTableOrderDetl(OrderDetl orderDetl) {
            OrderDetlPakin orderDetlPakin = OrderTransFormationUtil.transformationDetlPakin(orderDetl);
            return orderDetlPakinService.addToLogTable(orderDetlPakin);
        }
        @Transactional
        public boolean increaseQtyByOrderNo(String orderNo, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double qty) {
            return orderDetlPakinService.increaseQtyByOrderNo(orderNo, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3, qty);
        }
        @Transactional
        public boolean increaseWorkQty(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double workQty) {
            return orderDetlPakinService.increaseWorkQty(orderId, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3, workQty);
        }
    },
    PAKOUT{
        @Transactional
        public void implement(Class<T> tClass, Object param) {
        public void implement() {}

        }
        @Transactional
        public void query(String orderNo) {
            OrderPakout orderPakout = orderPakoutService.selectByNo(orderNo);
@@ -104,27 +199,35 @@
            }
        }
        @Transactional
        public Order selectOrder(String orderNo) {
        public Order selectByNo(String orderNo) {
            OrderPakout orderPakout = orderPakoutService.selectByNo(orderNo);
            if (Cools.isEmpty(orderPakout)) {
                return null;
            }
            Order order = new Order();
            order.sync(orderPakout);
            return order;
            return OrderTransFormationUtil.transformationOrderPakout(orderPakout);
        }
        @Transactional
        public List<OrderDetl> selectOrderDetl(Long orderId) {
            List<OrderDetl> orderDetlList = new ArrayList<>();
        public List<Order> selectBySettle(Long settle) {
            List<OrderPakout> orderPakoutList = orderPakoutService.selectBySettle(settle);
            return OrderTransFormationUtil.transformationOrderListPakout(orderPakoutList);
        }
        @Transactional
        public List<OrderDetl> selectByOrderId(Long orderId) {
            List<OrderDetlPakout> orderDetlPakoutList = orderDetlPakoutService.selectByOrderId(orderId);
            if (!orderDetlPakoutList.isEmpty()) {
                for (OrderDetlPakout orderDetlPakout : orderDetlPakoutList){
                    OrderDetl orderDetl = new OrderDetl();
                    orderDetl.sync(orderDetlPakout);
                    orderDetlList.add(orderDetl);
                }
            }
            return orderDetlList;
            return OrderTransFormationUtil.transformationOrderDetlListPakout(orderDetlPakoutList);
        }
        @Transactional
        public List<OrderDetl> selectWorkingDetls(Long orderId) {
            List<OrderDetlPakout> orderDetlPakoutList = orderPakoutService.selectWorkingDetls(orderId);
            return OrderTransFormationUtil.transformationOrderDetlListPakout(orderDetlPakoutList);
        }
        @Transactional
        public void checkComplete(String orderNo) {
            orderPakoutService.checkComplete(orderNo);
        }
        @Transactional
        public boolean saveHandlerOrder(Boolean Pakout, WrkMast wrkMast, List<WrkDetl> wrkDetls) {
            return orderPakoutService.saveHandlerOrder(Pakout,wrkMast,wrkDetls);
        }
        @Transactional
        public void insertOrder(Order order) {
@@ -162,15 +265,312 @@
                throw new CoolException("生成单据明细失败，请联系管理员");
            }
        }
    };
        @Transactional
        public void remove(Long orderId) {
            try{
                orderPakoutService.remove(orderId);
            } catch (Exception e){
                throw new CoolException("删除单据失败");
            }
        }

    public abstract void implement(Class<T> tClass, Object param);

        @Transactional
        public List<Order> selectComplete8() {
            List<OrderPakout> orderPakoutList = orderPakoutService.selectComplete8();
            return OrderTransFormationUtil.transformationOrderListPakout(orderPakoutList);
        }

        @Transactional
        public boolean addToLogTableOrder(Order order) {
            OrderPakout orderPakout = OrderTransFormationUtil.transformationPakout(order);
            return orderPakoutService.addToLogTable(orderPakout);
        }

        @Transactional
        public List<Order> selectOrderNoL(String orderNo) {
            List<OrderPakout> orderPakoutList = orderPakoutService.selectorderNoL(orderNo);
            return OrderTransFormationUtil.transformationOrderListPakout(orderPakoutList);
        }

        @Transactional
        public Order selectOrderMoveStatus() {
            OrderPakout orderPakout = orderPakoutService.selectOrderMoveStatus();
            return OrderTransFormationUtil.transformationOrderPakout(orderPakout);
        }

        @Transactional
        public Order selectOrderMoveStatusInitial() {
            OrderPakout orderPakout = orderPakoutService.selectOrderMoveStatusInitial();
            return OrderTransFormationUtil.transformationOrderPakout(orderPakout);
        }

        @Transactional
        public List<Order> selectComplete() {
            List<OrderPakout> orderPakoutList = orderPakoutService.selectComplete();
            return OrderTransFormationUtil.transformationOrderListPakout(orderPakoutList);
        }

        @Transactional
        public OrderDetl selectItem(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3) {
            OrderDetlPakout orderDetlPakout = orderDetlPakoutService.selectItem(orderId, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3);
            return OrderTransFormationUtil.transformationOrderDetlPakout(orderDetlPakout);
        }

        @Transactional
        public OrderDetl selectItem(String orderNo, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3) {
            OrderDetlPakout orderDetlPakout = orderDetlPakoutService.selectItem(orderNo, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3);
            return OrderTransFormationUtil.transformationOrderDetlPakout(orderDetlPakout);
        }

        @Transactional
        public OrderDetl findByLook(List<OrderDetl> orderDetls, Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3) {
            List<OrderDetlPakout> orderDetlPakouts = OrderTransFormationUtil.transformationDetlListPakout(orderDetls);
            OrderDetlPakout orderDetlPakout = orderDetlPakoutService.findByLook(orderDetlPakouts, orderId, matnr,batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3);
            return OrderTransFormationUtil.transformationOrderDetlPakout(orderDetlPakout);
        }
        @Transactional
        public boolean increase(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double qty) {
            return orderDetlPakoutService.increase(orderId, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3, qty);
        }
        @Transactional
        public boolean decrease(String orderNo, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double qty) {
            return orderDetlPakoutService.decrease(orderNo, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3, qty);
        }
        @Transactional
        public boolean modifyStatus(Long orderId, Integer status) {
            return orderDetlPakoutService.modifyStatus(orderId, status);
        }
        @Transactional
        public boolean addToLogTableOrderDetl(OrderDetl orderDetl) {
            OrderDetlPakout orderDetlPakout = OrderTransFormationUtil.transformationDetlPakout(orderDetl);
            return orderDetlPakoutService.addToLogTable(orderDetlPakout);
        }
        @Transactional
        public boolean increaseQtyByOrderNo(String orderNo, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double qty) {
            return orderDetlPakoutService.increaseQtyByOrderNo(orderNo, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3, qty);
        }
        @Transactional
        public boolean increaseWorkQty(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double workQty) {
            return orderDetlPakoutService.increaseWorkQty(orderId, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3, workQty);
        }



    },
    PAKALL{
        @Transactional
        public void implement() {}

        @Transactional
        public void query(String orderNo) {
            OrderPakout orderPakout = orderPakoutService.selectByNo(orderNo);
            if (!Cools.isEmpty(orderPakout)) {
                throw new CoolException(orderNo + "单据已存在，请勿重复提交");
            }
        }
        @Transactional
        public Order selectByNo(String orderNo) {
            OrderPakin orderPakin = orderPakinService.selectByNo(orderNo);
            if (Cools.isEmpty(orderPakin)) {
                OrderPakout orderPakout = orderPakoutService.selectByNo(orderNo);
                if (Cools.isEmpty(orderPakout)) {
                    return null;
                }
                return OrderTransFormationUtil.transformationOrder(null,orderPakout);
            }
            return OrderTransFormationUtil.transformationOrder(orderPakin,null);

        }
        @Transactional
        public List<Order> selectBySettle(Long settle) {
            List<OrderPakin> orderPakinList = orderPakinService.selectBySettle(settle);
            List<OrderPakout> orderPakoutList = orderPakoutService.selectBySettle(settle);
            return OrderTransFormationUtil.transformationOrderList(orderPakinList,orderPakoutList);
        }
        @Transactional
        public List<OrderDetl> selectByOrderId(Long orderId) {
            List<OrderDetlPakin> orderDetlPakinList = orderDetlPakinService.selectByOrderId(orderId);
            List<OrderDetlPakout> orderDetlPakoutList = orderDetlPakoutService.selectByOrderId(orderId);
            return OrderTransFormationUtil.transformationOrderDetlList(orderDetlPakinList,orderDetlPakoutList);
        }
        @Transactional
        public List<OrderDetl> selectWorkingDetls(Long orderId) {
            List<OrderDetlPakin> orderDetlPakinList = orderPakinService.selectWorkingDetls(orderId);
            List<OrderDetlPakout> orderDetlPakoutList = orderPakoutService.selectWorkingDetls(orderId);
            return OrderTransFormationUtil.transformationOrderDetlList(orderDetlPakinList,orderDetlPakoutList);
        }
        @Transactional
        public void checkComplete(String orderNo) {
            throw new CoolException("此方法无用！请好好写程序！！！403");
        }
        @Transactional
        public boolean saveHandlerOrder(Boolean Pakout, WrkMast wrkMast, List<WrkDetl> wrkDetls) {
            throw new CoolException("此方法无用！请好好写程序！！！407");
        }
        @Transactional
        public void insertOrder(Order order) {
            throw new CoolException("此方法无用！请好好写程序！！！411");
        }
        @Transactional
        public void insertOrderDetl(Order order, OrderDetl orderDetl) {
            throw new CoolException("此方法无用！请好好写程序！！！415");
        }
        @Transactional
        public void updateOrder(Long id, Long settle, Long userId) {
            throw new CoolException("此方法无用！请好好写程序！！！419");
        }
        @Transactional
        public void updateOrderDetl(Order order, OrderDetl orderDetl) {
            throw new CoolException("此方法无用！请好好写程序！！！423");
        }
        @Transactional
        public void remove(Long orderId) {
            throw new CoolException("此方法无用！请好好写程序！！！427");
        }


        @Transactional
        public List<Order> selectComplete8() {
            List<OrderPakin> orderPakinList = orderPakinService.selectComplete8();
            List<OrderPakout> orderPakoutList = orderPakoutService.selectComplete8();
            return OrderTransFormationUtil.transformationOrderList(orderPakinList,orderPakoutList);
        }

        @Transactional
        public boolean addToLogTableOrder(Order order) {
            throw new CoolException("此方法无用！请好好写程序！！！440");
        }

        @Transactional
        public List<Order> selectOrderNoL(String orderNo) {
            List<OrderPakin> orderPakinList = orderPakinService.selectorderNoL(orderNo);
            List<OrderPakout> orderPakoutList = orderPakoutService.selectorderNoL(orderNo);
            return OrderTransFormationUtil.transformationOrderList(orderPakinList,orderPakoutList);
        }

        @Transactional
        public Order selectOrderMoveStatus() {
            OrderPakin orderPakin = orderPakinService.selectOrderMoveStatus();
            OrderPakout orderPakout = orderPakoutService.selectOrderMoveStatus();
            return OrderTransFormationUtil.transformationOrder(orderPakin,orderPakout);
        }

        @Transactional
        public Order selectOrderMoveStatusInitial() {
            OrderPakin orderPakin = orderPakinService.selectOrderMoveStatusInitial();
            OrderPakout orderPakout = orderPakoutService.selectOrderMoveStatusInitial();
            return OrderTransFormationUtil.transformationOrder(orderPakin,orderPakout);
        }

        @Transactional
        public List<Order> selectComplete() {
            List<OrderPakin> orderPakinList = orderPakinService.selectComplete();
            List<OrderPakout> orderPakoutList = orderPakoutService.selectComplete();
            return OrderTransFormationUtil.transformationOrderList(orderPakinList,orderPakoutList);
        }

        @Transactional
        public OrderDetl selectItem(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3) {
            OrderDetlPakin orderDetlPakin = orderDetlPakinService.selectItem(orderId, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3);
            OrderDetlPakout orderDetlPakout = orderDetlPakoutService.selectItem(orderId, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3);
            return OrderTransFormationUtil.transformationOrderDetl(orderDetlPakin,orderDetlPakout);
        }

        @Transactional
        public OrderDetl selectItem(String orderNo, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3) {
            OrderDetlPakin orderDetlPakin = orderDetlPakinService.selectItem(orderNo, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3);
            OrderDetlPakout orderDetlPakout = orderDetlPakoutService.selectItem(orderNo, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3);
            return OrderTransFormationUtil.transformationOrderDetl(orderDetlPakin,orderDetlPakout);
        }

        @Transactional
        public OrderDetl findByLook(List<OrderDetl> orderDetls, Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3) {
            throw new CoolException("此方法无用！请好好写程序！！！487");
        }
        @Transactional
        public boolean increase(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double qty) {
            throw new CoolException("此方法无用！请好好写程序！！！491");
        }
        @Transactional
        public boolean decrease(String orderNo, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double qty) {
            throw new CoolException("此方法无用！请好好写程序！！！495");
        }
        @Transactional
        public boolean modifyStatus(Long orderId, Integer status) {
            throw new CoolException("此方法无用！请好好写程序！！！499");
        }
        @Transactional
        public boolean addToLogTableOrderDetl(OrderDetl orderDetl) {
            throw new CoolException("此方法无用！请好好写程序！！！503");
        }
        @Transactional
        public boolean increaseQtyByOrderNo(String orderNo, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double qty) {
            throw new CoolException("此方法无用！请好好写程序！！！507");
        }
        @Transactional
        public boolean increaseWorkQty(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double workQty) {
            throw new CoolException("此方法无用！请好好写程序！！！511");
        }
    },
    ;

    public abstract void implement();

    public abstract void query(String orderNo);

    public abstract Order selectByNo(String orderNo);

    public abstract List<Order> selectBySettle(Long settle);

    public abstract List<OrderDetl> selectByOrderId(Long orderId);

    public abstract List<OrderDetl> selectWorkingDetls(Long orderId);

    public abstract void checkComplete(String orderNo);

    public abstract boolean saveHandlerOrder(Boolean pakin, WrkMast wrkMast, List<WrkDetl> wrkDetls);

    public abstract void insertOrder(Order order);

    public abstract void insertOrderDetl(Order order, OrderDetl orderDetl);

    public abstract void updateOrder(Long id, Long settle, Long userId);

    public abstract void updateOrderDetl(Order order, OrderDetl orderDetl);

    public abstract void remove(Long orderId);

    public abstract List<Order> selectComplete();

    public abstract List<Order> selectComplete8();

    public abstract boolean addToLogTableOrder(Order order);

    public abstract List<Order> selectOrderNoL(String orderNo);

    public abstract Order selectOrderMoveStatus();

    public abstract Order selectOrderMoveStatusInitial();

    public abstract OrderDetl selectItem(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3);

    public abstract OrderDetl selectItem(String orderNo, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3);

    public abstract OrderDetl findByLook(List<OrderDetl> orderDetls, Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3);

    public abstract boolean increase(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double qty);

    public abstract boolean decrease(String orderNo, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double qty);

    public abstract boolean modifyStatus(Long orderId, Integer status);

    public abstract boolean addToLogTableOrderDetl(OrderDetl orderDetl);

    public abstract boolean increaseQtyByOrderNo(String orderNo, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double qty);

    public abstract boolean increaseWorkQty(Long orderId, String matnr, String batch, String brand, String standby1, String standby2, String standby3, String boxType1, String boxType2, String boxType3, Double workQty);

    @Setter
    OrderPakinService orderPakinService;
    @Setter