循环

Administrator

2023-08-19 ad3190e62a3e8384ab48240b5af2fccb3a734143

循环

 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();

 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