九小场所优化

linwei

2024-01-31 744b1814bfc28159e8f2a31288a29115ad0f5253

九小场所优化

 src/main/java/org/springblade/modules/place/mapper/PlaceCheckMapper.xml

@@ -21,7 +21,7 @@
        <result column="village_name" property="communityName"/>

        <collection property="placePoiLabelVOList" column="jpid" javaType="java.util.List" select="selectPlacePoiLabelList"
                    ofType="org.springblade.modules.place.entity.PlacePoiLabel"
                    ofType="org.springblade.modules.place.vo.PlacePoiLabelVO"
                    autoMapping="true">
        </collection>

@@ -32,16 +32,21 @@
    </resultMap>

    <select id="selectPlacePoiLabelList" parameterType="Long"
            resultType="org.springblade.modules.place.entity.PlacePoiLabel">
            select
            id,
            place_id,
            poi_code,
            type,
            color,
            remark
            from
            jczz_place_poi_label where place_id = #{jpid}
            resultType="org.springblade.modules.place.vo.PlacePoiLabelVO">
            SELECT
            jppl.id,
            jppl.place_id,
            jppl.poi_code,
            jppl.type,
            jppl.color,
            jppl.remark,
            jc.category_name labelName
        FROM
            jczz_place_poi_label jppl
            LEFT JOIN jczz_category jc ON jppl.poi_code = jc.category_no
        WHERE
            jppl.type = '3'
             and  place_id = #{jpid}
        </select>



 src/main/java/org/springblade/modules/place/vo/PlaceCheckVO.java

@@ -55,7 +55,7 @@

    private List<PatrolRecord> patrolRecordVOList;

    private List<PlacePoiLabel> placePoiLabelVOList ;
    private List<PlacePoiLabelVO> placePoiLabelVOList ;

    @ApiModelProperty(value = "场所名称", example = "")
    private String placeName;