提交按照年生成订单号程序

你好啊

2024-08-06 f11bfb56c4e183f67af576b811758b94c87d14f5

提交按照年生成订单号程序

 north-glass-erp/northglass-erp/.vscode/extensions.json

File was deleted

 north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderMapper.java

@@ -32,4 +32,6 @@
    Integer selectMaxOrderIdByMonth();

    boolean updateOrderPrintNumber(@Param("orderId") String orderId);

    Integer selectMaxOrderIdByYear();
}

 north-glass-erp/src/main/java/com/example/erp/service/sd/OrderService.java

@@ -169,6 +169,13 @@
            String formattedDate = dateFormat.format(currentDate);
            orderId =  "NG"+formattedDate+formattedNumber;

        }else if(dateType.equals("year")){
            Integer maxOrderId = orderMapper.selectMaxOrderIdByYear();
            String formattedNumber = String.format("%06d", maxOrderId+1);
            Date currentDate = new Date();
            SimpleDateFormat dateFormat = new SimpleDateFormat("yy");
            String formattedDate = dateFormat.format(currentDate);
            orderId =  "NG"+formattedDate+formattedNumber;
        }

        return orderId;

 north-glass-erp/src/main/resources/mapper/sd/OrderMapper.xml

@@ -31,7 +31,15 @@
        where
            date(a.create_time)  BETWEEN DATE_FORMAT(DATE(NOW()), '%Y-%m-01') AND DATE(NOW())
    </select>
    

    <select id="selectMaxOrderIdByYear">
        select
            ifnull(SUBSTR(max(order_id) from 5),0)
        from
            `order` as a
        where
            year(a.create_time)  = year(NOW())
    </select>

    <update id="updateOrderParameter">
        update `order` o