| | |
|---|
| | | <select id="pageRentingHouseApplet" |
|---|
| | | resultType="com.panzhihua.common.model.vos.community.rentingHouses.RentingHouseRegisterVO"> |
|---|
| | | SELECT t.id, t.title, t.brn, t.construct_area, t.floor, t.orientation, t.decoration, t.label, t.address, t.monthly_rent_money, |
|---|
| | | t.`status`, t.detail_status, t.auth_status,t1.url, t2.phone AS tenantTelephone, t.update_at |
|---|
| | | t.`status`, t.detail_status, t.auth_status,t1.url, t2.phone AS tenantTelephone, t.see_hourse_telephone, t.update_at |
|---|
| | | <if test="pageRegisterDTO.longitude !=null and pageRegisterDTO.longitude !=''"> |
|---|
| | | ,(POWER(MOD(ABS(longitude - #{pageRegisterDTO.longitude}),360),2) + POWER(ABS(latitude - #{pageRegisterDTO.latitude}),2)) AS distance |
|---|
| | | </if> |
|---|
| | |
|---|
| | | LEFT JOIN (SELECT * FROM renting_hourse_file WHERE classification = 1 AND `type` = 1) t1 ON t.id = t1.ref_id |
|---|
| | | LEFT JOIN sys_user t2 ON t.tenant_user_id = t2.user_id |
|---|
| | | WHERE t.community_id = #{pageRegisterDTO.communityId} |
|---|
| | | <if test="pageRegisterDTO.status == null"> |
|---|
| | | <if test="pageRegisterDTO.status == null and pageRegisterDTO.isMy == null"> |
|---|
| | | AND t.`status` = 2 |
|---|
| | | </if> |
|---|
| | | <if test="pageRegisterDTO.status != null"> |
|---|
