springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/CommunityApi.java
@@ -3,11 +3,11 @@ import com.alibaba.fastjson.JSONObject; import com.panzhihua.common.controller.BaseController; import com.panzhihua.common.model.dtos.community.ComMngCarAppletDTO; import com.panzhihua.common.model.dtos.community.PageComActDTO; import com.panzhihua.common.model.dtos.community.PageVolunteerDTO; import com.panzhihua.common.model.vos.LoginUserInfoVO; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.community.*; import com.panzhihua.common.model.vos.partybuilding.PartyBuildingActivityVO; import com.panzhihua.common.model.vos.user.SysUserNoticeVO; import com.panzhihua.common.service.community.CommunityService; import com.panzhihua.common.service.user.UserService; @@ -40,6 +40,12 @@ @Resource private UserService userService; @ApiOperation(value = "分页查询社区",response = ComActVO.class) @PostMapping("pagecommunity") public R pageCommunity(@RequestBody PageComActDTO pageComActDTO){ return communityService.pageCommunity(pageComActDTO); } @ApiOperation(value = "分页获取社区动态",response = ComActDynVO.class) @PostMapping("pagedynamic") public R pageDynamic(@RequestBody ComActDynVO comActDynVO){ springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/community/PageComOpsHouseDTO.java
@@ -47,4 +47,15 @@ @ApiModelProperty("小程序使用 1 表示查询我的") private Integer isMy; @ApiModelProperty(value="朝向 0无1东2南3西4北5东南6东北7西南8西北9南北10东西") private Integer orient; @ApiModelProperty(value="租售类型 1 出租 2 出售") private Integer houseType; @ApiModelProperty(value="租房类型 1 整租 2 合租") private Integer rentType; @ApiModelProperty(value="室数量,1 一室 2 二室 3 三室 4 四室以上") private Integer brn; @ApiModelProperty(value="1 价格从低到高 2 价格从高到底 ") private Integer priceOrder; } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComOpsHouseDAO.java
@@ -36,6 +36,26 @@ "<if test='pageComOpsHouseDTO.communityId != null '>" + "AND d.community_id=#{pageComOpsHouseDTO.communityId} \n" + " </if> " + "<if test='pageComOpsHouseDTO.orient != null '>" + "AND d.orient=#{pageComOpsHouseDTO.orient} \n" + " </if> " + "<if test='pageComOpsHouseDTO.houseType != null '>" + "AND d.house_type=#{pageComOpsHouseDTO.houseType} \n" + " </if> " + "<if test='pageComOpsHouseDTO.rentType != null '>" + "AND d.rent_type=#{pageComOpsHouseDTO.rentType} \n" + " </if> " + "<if test='pageComOpsHouseDTO.brn != null and pageComOpsHouseDTO.brn !=4 '>" + "AND d.brn=#{pageComOpsHouseDTO.brn} \n" + " </if> " + "<if test='pageComOpsHouseDTO.brn != null and pageComOpsHouseDTO.brn ==4 '>" + "AND d.brn <![CDATA[ >= ]]> 4 \n" + " </if> " + "<if test='pageComOpsHouseDTO.houseCommunityId != null '>" + "AND d.house_community_id=#{pageComOpsHouseDTO.houseCommunityId} \n" + " </if> " + @@ -49,7 +69,14 @@ "AND d.create_at BETWEEN #{pageComOpsHouseDTO.begin} \n" + "AND #{pageComOpsHouseDTO.end} \n" + " </if> " + " order by d.id desc "+ " order by " + "<if test='pageComOpsHouseDTO.priceOrder != null and pageComOpsHouseDTO.priceOrder ==1 '>" + "d.amount asc," + " </if> " + "<if test='pageComOpsHouseDTO.priceOrder != null and pageComOpsHouseDTO.priceOrder ==2 '>" + "d.amount desc," + " </if> " + "d.id desc "+ "</script>") IPage<ComOpsHouseVO> pageHouse(Page page, @Param("pageComOpsHouseDTO") PageComOpsHouseDTO pageComOpsHouseDTO);