From 34285b5911b582c00f9f5c9cd3bb78b96126b5b3 Mon Sep 17 00:00:00 2001
From: 1 <1@123>
Date: 星期五, 13 三月 2026 14:59:36 +0800
Subject: [PATCH] lsh#
---
rsf-server/src/main/java/com/vincent/rsf/server/manager/schedules/WaveSchedules.java | 2 +-
rsf-server/src/main/resources/mapper/manager/WarehouseStockMapper.xml | 51 ++++++++++++++++++++++++---------------------------
2 files changed, 25 insertions(+), 28 deletions(-)
diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/schedules/WaveSchedules.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/schedules/WaveSchedules.java
index 7c4d065..f87e541 100644
--- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/schedules/WaveSchedules.java
+++ b/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));
diff --git a/rsf-server/src/main/resources/mapper/manager/WarehouseStockMapper.xml b/rsf-server/src/main/resources/mapper/manager/WarehouseStockMapper.xml
index 1f3ada5..bb45b61 100644
--- a/rsf-server/src/main/resources/mapper/manager/WarehouseStockMapper.xml
+++ b/rsf-server/src/main/resources/mapper/manager/WarehouseStockMapper.xml
@@ -1,31 +1,28 @@
<?xml version="1.0" encoding="UTF-8"?>
<!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,
- 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
- FROM view_stock_manage
- ${ew.customSqlSegment}
- </select>
+ <select id="pageByStock" resultType="com.vincent.rsf.server.manager.entity.ViewStockManage">
+ SELECT
+ matnr_id,
+ 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>
</mapper>
--
Gitblit v1.9.1