lsh#

1

2 天以前 34285b5911b582c00f9f5c9cd3bb78b96126b5b3

lsh#

 rsf-server/src/main/java/com/vincent/rsf/server/manager/schedules/WaveSchedules.java

@@ -54,7 +54,7 @@
     * @description 自动下发波次任务
     * @time 2025/6/23 13:52
     */
    @Scheduled(cron = "0/15 * * * * ?")
    @Scheduled(cron = "0/5 * * * * ?")
//    @Transactional(rollbackFor = Exception.class)
    public void autoGenerateTask() {
        Config config = configService.getOne(new LambdaQueryWrapper<Config>().eq(Config::getFlag, GlobalConfigCode.WAVE_AUTO_EXCE_TASK));

 rsf-server/src/main/resources/mapper/manager/WarehouseStockMapper.xml

@@ -2,29 +2,26 @@
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.vincent.rsf.server.manager.mapper.WarehouseStockMapper">
    <select id="pageByStock" resultType="com.vincent.rsf.server.manager.entity.ViewStockManage">
        SELECT id,
               loc_id,
               loc_code,
               warehouse,
               type,
               order_item_id,
               wk_type,
              SELECT
               matnr_id,
               maktx,
               matnr_code,
               splr_id,
               unit,
               SUM(anfme)    anfme,
               SUM(qty)      qty,
               SUM(work_qty) work_qty,
               batch,
               spec,
               model,
               fields_index,
               update_by,
               create_by,
               update_time,
               create_time
                     MAX(id) as id,
                     MAX(loc_code) as loc_code,
                     MAX(warehouse) as warehouse,
                     MAX(type) as type,
                     MAX(maktx) as maktx,
                     MAX(matnr_code) as matnr_code,
                     MAX(unit) as unit,
                     MAX(spec) as spec,
                     MAX(model) as model,
                     MAX(batch) as batch,
                     MAX(fields_index) as fields_index,
                     MAX(update_by) as update_by,
                     MAX(create_by) as create_by,
                     MAX(update_time) as update_time,
                     MAX(create_time) as create_time,
                     SUM(anfme) as anfme,
                     SUM(qty) as qty,
                     SUM(work_qty) as work_qty
        FROM view_stock_manage
            ${ew.customSqlSegment}
    </select>