| | |
| | | <if test="house.districtName != null and house.districtName != ''"> |
| | | and district_name like concat('%',#{house.districtName},'%') |
| | | </if> |
| | | <if test="house.houseName != null and house.houseName != ''"> and house_name like concat('%',#{house.houseName},'%')</if> |
| | | <if test="house.houseName != null and house.houseName != ''"> and jh.house_name like concat('%',#{house.houseName},'%')</if> |
| | | <if test="house.phone != null and house.phone != ''"> and phone = #{house.phone}</if> |
| | | <if test="house.area != null "> and area = #{house.area}</if> |
| | | <if test="house.propertyPrice != null "> and property_price = #{house.propertyPrice}</if> |