| | |
| | | + "<if test='pageComMngRealAssetsDTO.name != null and pageComMngRealAssetsDTO.name.trim() != ""'>" |
| | | + " and t.name LIKE concat( #{pageComMngRealAssetsDTO.name}, '%' ) " + " </if> " |
| | | + "<if test='pageComMngRealAssetsDTO.communityId != null and pageComMngRealAssetsDTO.communityId != 0'>" |
| | | + " and t.community_id = #{pageComMngRealAssetsDTO.communityId} " + " </if> " + " order by t.create_at desc" |
| | | + " and t.community_id = ${pageComMngRealAssetsDTO.communityId} " + " </if> " + " order by t.create_at desc" |
| | | + "</script>") |
| | | IPage<ComMngRealAssetsVO> pageQueryComMngRealAssets(Page page, |
| | | @Param(value = "pageComMngRealAssetsDTO") PageComMngRealAssetsDTO pageComMngRealAssetsDTO); |
| | |
| | | + " case t.floor_type when 1 then '高层' when 2 then '中层' when 3 then '低层' else '/' end floorType, " |
| | | + " t.num, " + " t.square, " + " t.address " + "FROM " + " com_mng_real_assets t " |
| | | + " LEFT JOIN com_mng_struct_build_type t2 ON t.build_type_id = t2.id" |
| | | + " WHERE 1= 1 " |
| | | + "<if test='exportRealAssetsExcelDTO.name != null and exportRealAssetsExcelDTO.name.trim() != ""'>" |
| | | + " and t.name LIKE concat( #{exportRealAssetsExcelDTO.name}, '%' ) " + " </if> " |
| | | + "<if test='exportRealAssetsExcelDTO.communityId != null and exportRealAssetsExcelDTO.communityId != 0'>" |
| | | + " and t.community_id = #{exportRealAssetsExcelDTO.communityId} " + " </if> " + " order by t.create_at desc" |
| | | + " and t.community_id = ${exportRealAssetsExcelDTO.communityId} " + " </if> " + " order by t.create_at desc" |
| | | + "</script>") |
| | | List<ComMngRealAssetsExcelVO> exportRealAssetsExcel( |
| | | @Param(value = "exportRealAssetsExcelDTO") ExportRealAssetsExcelDTO exportRealAssetsExcelDTO); |