修改【导办人员管理】无法搜索 bug

lidongdong

2022-10-19 9b76904a6dd7e452bf01ccb2a0902bbbce29e1aa

修改【导办人员管理】无法搜索  bug

 flower_city/src/main/java/com/dg/core/controller/GuideDoController.java

@@ -42,14 +42,15 @@
    @GetMapping("/getlist")
    @Authorization
    public TableDataInfo selectConfigList(@RequestParam(value = "pageNum",required = false) Integer pageNum,
                                          @RequestParam(value = "pageSize",required = false) Integer pageSize)
                                          @RequestParam(value = "pageSize",required = false) Integer pageSize,
                                          @RequestParam(value = "name",required = false) String name)
    {
        Assert.notNull(pageNum, "pageNum can not be empty");
        Assert.notNull(pageSize, "pageSize can not be empty");
        Page<SysUser> pageParam = new Page<>(pageNum,pageSize);
        List<SysUser> list = IUserService.selectConfigList(pageParam,pageSize,"2",null);
        List<SysUser> list = IUserService.selectConfigList(pageParam,pageSize,"2",name);

        int num=IUserService.selectNum("2",null);
        int num=IUserService.selectNum("2",name);
        return getDataTable(list,num);
    }


 flower_city/src/main/resources/mapper/SysUserMapper.xml

@@ -92,7 +92,10 @@
        select count(user_id) from automessage_sys_user
        <where>
            <if test="userName != null and userName != ''">
                AND user_name like concat('%', #{userName}, '%')
                AND user_name like concat('%', #{userName}, '%') or
                (department_id in (SELECT id FROM automessage_organization_chart
                WHERE organization_name like concat('%', #{userName}, '%')))

            </if>
            <if test="userType != null and userType != ''">
                AND user_type=#{userType}
@@ -115,7 +118,10 @@
        <include refid="selectSysUserVo"/>
        <where>
            <if test="userName != null and userName != ''">
                AND user_name like concat('%', #{userName}, '%')
                AND user_name like concat('%', #{userName}, '%') or
                (department_id in (SELECT id FROM automessage_organization_chart
                WHERE organization_name like concat('%', #{userName}, '%')))

            </if>
            <if test="userType != null and userType != ''">
                AND user_type=#{userType}