From ad3190e62a3e8384ab48240b5af2fccb3a734143 Mon Sep 17 00:00:00 2001 From: Administrator <1144154118@qq.com> Date: 星期六, 19 八月 2023 16:34:40 +0800 Subject: [PATCH] 循环 --- ard-work/src/main/resources/mapper/app/ArdAppPatrolplanMapper.xml | 2 +- ard-work/src/main/java/com/ruoyi/app/patrolplan/service/impl/ArdAppPatrolpointRecordServiceImpl.java | 6 ++++-- 2 files changed, 5 insertions(+), 3 deletions(-) diff --git a/ard-work/src/main/java/com/ruoyi/app/patrolplan/service/impl/ArdAppPatrolpointRecordServiceImpl.java b/ard-work/src/main/java/com/ruoyi/app/patrolplan/service/impl/ArdAppPatrolpointRecordServiceImpl.java index 5e97915..de23385 100644 --- a/ard-work/src/main/java/com/ruoyi/app/patrolplan/service/impl/ArdAppPatrolpointRecordServiceImpl.java +++ b/ard-work/src/main/java/com/ruoyi/app/patrolplan/service/impl/ArdAppPatrolpointRecordServiceImpl.java @@ -799,8 +799,10 @@ System.out.println("鍑忓皯10绉掑悗鐨勬棩鏈熸椂闂达細" + earlier); RecordSonParam recordSonParam = new RecordSonParam(); recordSonParam.setUserId(userId); - recordSonParam.setTime(fmt.format(now)); - recordSonParam.setBeforeTime(fmt.format(earlier)); + String n = fmt.format(now); + recordSonParam.setTime(n); + String e = fmt.format(earlier); + recordSonParam.setBeforeTime(e); //鏍规嵁濮撳悕ID涓烘墽琛屼汉鑾峰彇鎵�鏈夊搴旂殑璁″垝鍚嶇О List<ArdAppPatrolplan> list = patrolplanMapper.planUser(recordSonParam); JSONArray jsonArray = new JSONArray(); diff --git a/ard-work/src/main/resources/mapper/app/ArdAppPatrolplanMapper.xml b/ard-work/src/main/resources/mapper/app/ArdAppPatrolplanMapper.xml index 89360c8..c8f1e6b 100644 --- a/ard-work/src/main/resources/mapper/app/ArdAppPatrolplanMapper.xml +++ b/ard-work/src/main/resources/mapper/app/ArdAppPatrolplanMapper.xml @@ -158,7 +158,7 @@ </select> <select id="planUser" parameterType="String" resultMap="ArdAppPatrolplanResult"> - select s.nick_name nickName, plan.plan_name from ard_app_patrolplan plan + select s.nick_name, plan.plan_name from ard_app_patrolplan plan LEFT JOIN ard_app_patroluser users on users.patrolplan_id = plan."id" left join sys_user s on users.app_user_id = s.user_id where users.app_user_id = #{userId} and son is null -- Gitblit v1.9.3