| | |
| | | br.NAME AS communityName, |
| | | jpag.pcs_name pcsName, |
| | | jda.aoi_name, |
| | | CONCAT( jda.building_name, '-', jda.unit_name, '-', jda.house_name ) houseName, |
| | | CONCAT( IF(jda.building_name,jda.building_name,''), '-', IF(jda.unit_name,jda.unit_name,''), '-', IF(jda.house_name,jda.house_name,'') ) houseName, |
| | | bd.dept_name |
| | | from jczz_backblast_pub_record jbpr |
| | | LEFT JOIN jczz_grid jg on jg.grid_code = jbpr.grid_code and jg.is_deleted = 0 |
| | |
| | | br.NAME AS communityName, |
| | | jpag.pcs_name pcsName, |
| | | jda.aoi_name, |
| | | CONCAT( jda.building_name, '-', jda.unit_name, '-', jda.house_name ) houseName, |
| | | CONCAT( IF(jda.building_name,jda.building_name,''), '-', IF(jda.unit_name,jda.unit_name,''), '-', IF(jda.house_name,jda.house_name,'') ) houseName, |
| | | bd.dept_name |
| | | from jczz_backblast_pub_record jbpr |
| | | LEFT JOIN jczz_grid jg on jg.grid_code = jbpr.grid_code and jg.is_deleted = 0 |
| | |
| | | @TableField(value = "create_time",fill = FieldFill.INSERT) |
| | | private Date createTime; |
| | | |
| | | private String taskRange; |
| | | |
| | | } |
| | |
| | | public class UserHouseLabelVO extends UserHouseLabelEntity { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | private String taskRange; |
| | | |
| | | |
| | | } |