heheng
2024-12-11 e3241a8a2b867fb60cd63edd64744a1fbfae0d1d
更改查询方式
已修改5个文件
31 ■■■■■ 文件已修改
assess-admin/src/main/java/com/gkhy/assess/admin/controller/web/SysAgencyController.java 7 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
assess-system/src/main/java/com/gkhy/assess/system/domain/SysUser.java 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
assess-system/src/main/java/com/gkhy/assess/system/service/SysAgencyService.java 9 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
assess-system/src/main/java/com/gkhy/assess/system/service/impl/SysAgencyServiceImpl.java 5 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
assess-system/src/main/resources/mapper/SysUserMapper.xml 6 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
assess-admin/src/main/java/com/gkhy/assess/admin/controller/web/SysAgencyController.java
@@ -32,6 +32,13 @@
        return CommonResult.success(agencyService.agencyList(agency));
    }
    @ApiOperation(value = "机构列表")
    @GetMapping("/agencyLists")
    public CommonResult agencyLists(SysAgency agency){
        return CommonResult.success(agencyService.agencyLists(agency));
    }
    @RequiresPermissions(value={"system:assess:monitor","system:assess:agency"},logical = Logical.OR)
    @ApiOperation(value = "根据id获取机构详情")
    @ApiImplicitParams({
assess-system/src/main/java/com/gkhy/assess/system/domain/SysUser.java
@@ -203,4 +203,8 @@
    @TableField(exist = false)
    private String agencyName;
    @ApiModelProperty(value = "机构属性(0疆内,1疆外,默认0)",required = false)
    @TableField(exist = false)
    private Integer attribute;
}
assess-system/src/main/java/com/gkhy/assess/system/service/SysAgencyService.java
@@ -5,6 +5,8 @@
import com.baomidou.mybatisplus.extension.service.IService;
import com.gkhy.assess.system.domain.SysUser;
import java.util.List;
/**
 * <p>
 * 机构表 服务类
@@ -23,6 +25,13 @@
    CommonPage agencyList(SysAgency agency);
    /**
     * 根据条件分页查询机构列表
     * @param agency
     * @return
     */
    List<SysAgency> agencyLists(SysAgency agency);
    /**
     * 校验机构名称是否唯一
     * @param agency
     * @return
assess-system/src/main/java/com/gkhy/assess/system/service/impl/SysAgencyServiceImpl.java
@@ -36,6 +36,11 @@
    }
    @Override
    public List<SysAgency> agencyLists(SysAgency agency) {
        return baseMapper.agencyList(agency);
    }
    @Override
    public boolean checkAgencyNameUnique(SysAgency agency) {
        Long agencyId = agency.getId()==null? -1L : agency.getId();
        SysAgency info = baseMapper.checkAgencyNameUnique(agency.getName());
assess-system/src/main/resources/mapper/SysUserMapper.xml
@@ -94,6 +94,9 @@
            <if test="state != null">
                AND u.state = #{state}
            </if>
            <if test="attribute != null">
                AND a.attribute = #{attribute}
            </if>
            <if test="phone != null and phone != ''">
                AND u.phone like concat('%', #{phone}, '%')
            </if>
@@ -135,6 +138,9 @@
            <if test="post != null and post != ''">
                AND u.post =#{post}
            </if>
            <if test="agencyName != null and agencyName != ''">
                AND a.name like concat('%', #{agencyName}, '%')
            </if>
        </where>
        order by u.create_time desc