特殊号码处理

linwei

2024-01-02 d3d9ae322dbf77dfc4731b785474f2449bb7f929

特殊号码处理

 src/main/java/org/springblade/modules/task/mapper/TaskMapper.xml

@@ -45,9 +45,10 @@
        LEFT JOIN jczz_task jt ON jgr.house_code = jt.house_code
        LEFT JOIN jczz_doorplate_address jda ON jda.address_code = jt.house_code
        LEFT JOIN jczz_place jp on jp.house_code=jgr.house_code
        WHERE
        jgm.user_id = #{task.userId}
        and jt.report_type in(2,3,4,5,6)
        <where>
            <if test="task.userId != null and task.userId != ''">
                and jgm.user_id = #{task.userId}
            </if>
        <if test="task.communityCode != null and task.communityCode != ''">
            and jg.community_code = #{task.communityCode}
        </if>
@@ -82,7 +83,11 @@
        <if test="task.reportType != null and task.reportType == 2 ">
            and jt.report_type in (2,3,4,5,6)
        </if>
            <if test="task.reportType == null">
                and jt.report_type in (2,3,4,5,6)
            </if>
        order by jt.create_time desc
        </where>
    </select>



 src/main/java/org/springblade/modules/task/service/impl/TaskServiceImpl.java

@@ -65,6 +65,10 @@
            task.setUserId(AuthUtil.getUserId());
            return page.setRecords(baseMapper.selectTaskPageBy(page, task));
        } else {
            if (AuthUtil.getUserAccount().equals("18879306957")) {
                task.setCommunityCode("361102003027");
                task.setUserId(null);
            }
            // 非民警角色
            List<TaskVO> taskVOS = baseMapper.selectTaskPage(page, task);
            return page.setRecords(taskVOS);