From b267af1b816f646fa02c6f4983ebb3f9825cc192 Mon Sep 17 00:00:00 2001 From: pang.jiabao <pang_jiabao@163.com> Date: 星期六, 13 四月 2024 15:00:44 +0800 Subject: [PATCH] 单据管理:1.销售账号,在系统里面单据管理这里A销售员做的单子,在它的账号只显示自己的客户信息,不同的账号,看不到别人的信息,管理员是可以全部看的 2.增加客户名称,操作员搜索 --- src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java b/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java index 85cc3fa..c0e231d 100644 --- a/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java +++ b/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java @@ -23,7 +23,7 @@ @Transactional public ReturnT<String> start() { try { - String sql = "SELECT distinct a.loc_no as locNo FROM asr_loc_mast a,asr_loc_detl b where a.loc_no=b.loc_no and (a.loc_type ='O' or a.loc_type ='D')"; + String sql = "SELECT distinct a.loc_no as locNo FROM asr_loc_mast a,asr_loc_detl b where a.loc_no=b.loc_no and (a.loc_sts ='O' or a.loc_sts ='D')"; List<Map<String, Object>> result = jdbcTemplate.queryForList(sql); if (!result.isEmpty()) { for (Map<String, Object> map : result) { -- Gitblit v1.9.1