| | |
| | | <mapper namespace="org.springblade.modules.property.mapper.PropertyCapitalApplyMapper"> |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="propertyCapitalApplyResultMap" type="org.springblade.modules.property.entity.PropertyCapitalApplyEntity"> |
| | | <resultMap id="propertyCapitalApplyResultMap" |
| | | type="org.springblade.modules.property.entity.PropertyCapitalApplyEntity"> |
| | | <result column="id" property="id"/> |
| | | <result column="property_company_id" property="propertyCompanyId"/> |
| | | <result column="district_id" property="districtId"/> |
| | |
| | | <if test="propertyCapitalApply.districtName!=null and propertyCapitalApply.districtName!=''"> |
| | | and jd.name like concat('%',#{propertyCapitalApply.districtName},'%') |
| | | </if> |
| | | <if test="propertyCapitalApply.districtIdList!=null and propertyCapitalApply.districtIdList!=''"> |
| | | <if test="propertyCapitalApply.districtIdList!=null and propertyCapitalApply.districtIdList.size()>0"> |
| | | and jpca.district_id in |
| | | <foreach collection="propertyCapitalApply.districtIdList" item="item" separator ="," open="(" close=")"> |
| | | <foreach collection="propertyCapitalApply.districtIdList" item="item" separator="," open="(" close=")"> |
| | | #{item} |
| | | </foreach> |
| | | </if> |