重点人群标签查询

lin

2024-03-16 7859dc22f82ff90aca3c0cebbab6fde0423290f9

重点人群标签查询

 src/main/java/org/springblade/modules/house/controller/UserHouseLabelController.java

@@ -189,7 +189,10 @@


    /**
     *
     * 街道重点人员标签统计
     * @param householdLabel
     * @param query
     * @return
     */
    @GetMapping("/getRegionStatisticalLabels")
    @ApiOperation(value = "统计标签", notes = "")
@@ -199,7 +202,10 @@
    }

    /**
     *
     * 社区重点人员标签统计
     * @param householdLabel
     * @param query
     * @return
     */
    @GetMapping("/getCommunityStatisticalLabels")
    @ApiOperation(value = "统计标签", notes = "")

 src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml

@@ -199,12 +199,24 @@
        LEFT JOIN jczz_doorplate_address jda ON jda.address_code = jh.house_code
        LEFT JOIN jczz_grid jg on jg.grid_code = jhs.grid_code and jg.is_deleted = 0
        LEFT JOIN jczz_police_affairs_grid jpag on jhs.jw_grid_code= jpag.jw_grid_code and jpag.is_deleted = 0
        LEFT JOIN jczz_user_house_label juhl ON juhl.household_id = jh.id
        LEFT JOIN jczz_label jl ON juhl.label_id = jl.id
        <where>
            <if test="household.labelIdList !=null and household.labelIdList.size() >0 ">
                and juhl.lable_type = 1
                AND juhl.household_id IS NOT NULL
                AND jl.id in
                <foreach collection="household.labelIdList" item="code" open="(" close=")" separator=",">
                    #{code}
                </foreach>
            </if>
            <if test="household.userId!=null">
                AND jg.grid_code IN ( SELECT DISTINCT jgm.grid_code FROM jczz_gridman jgm WHERE jgm.user_id =
                #{household.userId}
                )
            </if>


            <if test="household.name!=null and household.name !=''">
                and jh.name like concat('%',#{household.name},'%')
            </if>

 src/main/java/org/springblade/modules/house/vo/HouseholdVO.java

@@ -40,6 +40,9 @@
     */
    private String roleRelationName;

    @ApiModelProperty(value = "标签")
    private List<Integer> labelIdList;

    /**
     * 小区名称
     */