房屋租售

hhhyyq

2021-03-17 9d627907c3db735a0671fc8fdd5ae8483be775a2

房屋租售

 springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/HouseApi.java

New file
@@ -0,0 +1,78 @@
package com.panzhihua.applets.api;

import com.panzhihua.applets.weixin.CheckService;
import com.panzhihua.common.controller.BaseController;
import com.panzhihua.common.model.dtos.community.ComOpsHouseDTO;
import com.panzhihua.common.model.dtos.community.PageComOpsHouseDTO;
import com.panzhihua.common.model.vos.LoginUserInfoVO;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.ComOpsHouseVO;
import com.panzhihua.common.service.community.CommunityService;
import com.panzhihua.common.validated.AddGroup;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 房屋租售
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2021-01-22 15:30
 **/
@Slf4j
@Api(tags = {"房屋租售"})
@RestController
@RequestMapping("/")
public class HouseApi extends BaseController {
    @Resource
    private CommunityService communityService;
    @Resource
    private CheckService checkService;


    @ApiOperation(value = "房屋租售-新增")
    @PostMapping("house")
    public R addHouse(@RequestBody @Validated(AddGroup.class) ComOpsHouseDTO comOpsHouseDTO) {
//        微信内容审核
        String introduction = comOpsHouseDTO.getIntroduction();
        if (!checkService.checkMessage(introduction)) {
            return R.fail("内容违规");
        }
        LoginUserInfoVO loginUserInfo = this.getLoginUserInfo();
        Long userId = loginUserInfo.getUserId();
        Long communityId = loginUserInfo.getCommunityId();
        comOpsHouseDTO.setUserId(userId);
        comOpsHouseDTO.setCommunityId(communityId);
        return communityService.addOpsHouse(comOpsHouseDTO);
    }


    @ApiOperation(value = "房屋租售-分页查询",response = ComOpsHouseVO.class)
    @PostMapping("pagehouse")
    public R pageHouse(@RequestBody PageComOpsHouseDTO pageComOpsHouseDTO) {
        LoginUserInfoVO loginUserInfo = this.getLoginUserInfo();
        Integer isMy = pageComOpsHouseDTO.getIsMy();
        if (null!=isMy&&isMy.intValue()==1) {
            pageComOpsHouseDTO.setUserId(loginUserInfo.getUserId());
        }
        return communityService.pageOpsHouse(pageComOpsHouseDTO);
    }


    @ApiOperation(value = "房屋租售-详情",response = ComOpsHouseVO.class)
    @GetMapping("house")
    @ApiImplicitParam(name = "id",value = "房屋租售主键",required = true)
    public R detailHouse(@RequestParam("id") Long id) {
        return communityService.detailOpsHouse(id);
    }





}

 springcloud_k8s_panzhihuazhihuishequ/applets_backstage/src/main/java/com/panzhihua/applets_backstage/api/HouseApi.java

New file
@@ -0,0 +1,74 @@
package com.panzhihua.applets_backstage.api;

import com.panzhihua.common.controller.BaseController;
import com.panzhihua.common.model.dtos.community.ComOpsHouseDTO;
import com.panzhihua.common.model.dtos.community.PageComOpsHouseDTO;
import com.panzhihua.common.model.vos.LoginUserInfoVO;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.ComOpsHouseVO;
import com.panzhihua.common.service.community.CommunityService;
import com.panzhihua.common.validated.AddGroup;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.util.ObjectUtils;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 房屋租售
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2021-01-22 15:30
 **/
@Slf4j
@Api(tags = {"房屋租售"})
@RestController
@RequestMapping("/")
public class HouseApi extends BaseController {
    @Resource
    private CommunityService communityService;

    @ApiOperation(value = "房屋租售-新增")
    @PostMapping("house")
    public R addHouse(@RequestBody @Validated(AddGroup.class) ComOpsHouseDTO comOpsHouseDTO) {
        LoginUserInfoVO loginUserInfo = this.getLoginUserInfo();
        Long userId = loginUserInfo.getUserId();
        Long communityId = loginUserInfo.getCommunityId();
        comOpsHouseDTO.setUserId(userId);
        comOpsHouseDTO.setCommunityId(communityId);
        return communityService.addOpsHouse(comOpsHouseDTO);
    }

    @ApiOperation(value = "房屋租售-详情",response = ComOpsHouseVO.class)
    @GetMapping("house")
    public R detailHouse(@RequestParam("id") Long id) {
        return communityService.detailOpsHouse(id);
    }

    @ApiOperation(value = "编辑/审核房屋租售")
    @PutMapping("activity")
    public R putActivity(@RequestBody ComOpsHouseVO comOpsHouseVO) {
        Long id = comOpsHouseVO.getId();
        if (ObjectUtils.isEmpty(id)) {
            return R.fail("房屋租售id主键不能为空");
        }
        return communityService.putOpsHouse(comOpsHouseVO);
    }

    @ApiOperation(value = "房屋租售-删除")
    @DeleteMapping("house")
    public R deleteHouse(@RequestParam("id") Long id) {
        return communityService.deleteOpsHouse(id);
    }


    @ApiOperation(value = "房屋租售-分页查询",response = ComOpsHouseVO.class)
    @PostMapping("pagehouse")
    public R pageHouse(@RequestBody PageComOpsHouseDTO pageComOpsHouseDTO) {
        return communityService.pageOpsHouse(pageComOpsHouseDTO);
    }

}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/community/ComOpsHouseDTO.java

New file
@@ -0,0 +1,126 @@
package com.panzhihua.common.model.dtos.community;

import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.io.Serializable;

/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 房屋租售
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2021-01-22 14:48
 **/
@Data
public class ComOpsHouseDTO implements Serializable {
    private static final long serialVersionUID = 1L;

    /**
     * 主键
     */
    @ApiModelProperty(value="主键")
    private Long id;
    /**
     * 状态  0待审核 1已上架 2已驳回 3已下架
     */
    @ApiModelProperty(value="状态  0待审核 1已上架 2已驳回 3已下架")
    private Integer status;
    /**
     * 房屋所在社区id
     */
    @ApiModelProperty(value="房屋所在社区id")
    private Long houseCommunityId;
    /**
     * 房屋所在社区名字
     */
    @ApiModelProperty(value="房屋所在社区名字")
    private String houseCommunityName;
    /**
     * 房屋标题
     */
    @ApiModelProperty(value="房屋标题")
    private String title;
    /**
     * 租售类型 1 出租 2 出售
     */
    @ApiModelProperty(value="租售类型 1 出租 2 出售")
    private Integer houseType;
    /**
     * 租房类型 1 整租 2 合租
     */
    @ApiModelProperty(value="租房类型 1 整租 2 合租")
    private Integer rentType;
    /**
     * 价格
     */
    @ApiModelProperty(value="价格")
    private Integer amount;
    /**
     * 面积
     */
    @ApiModelProperty(value="面积")
    private Integer area;
    /**
     * 室数量
     */
    @ApiModelProperty(value="室数量")
    private Integer brn;
    /**
     * 厅数量
     */
    @ApiModelProperty(value="厅数量")
    private Integer lrn;
    /**
     * 卫数量
     */
    @ApiModelProperty(value="卫数量")
    private Integer wcn;
    /**
     * 所在楼层
     */
    @ApiModelProperty(value="所在楼层")
    private Integer floor;
    /**
     * 总楼层
     */
    @ApiModelProperty(value="总楼层")
    private Integer totalFloor;
    /**
     * 朝向 0无1东2南3西4北5东南6东北7西南8西北9南北10东西
     */
    @ApiModelProperty(value="朝向 0无1东2南3西4北5东南6东北7西南8西北9南北10东西")
    private Integer orient;
    /**
     * 装修情况
     */
    @ApiModelProperty(value="装修情况")
    private String decoration;
    /**
     * 房屋简介
     */
    @ApiModelProperty(value="房屋简介")
    private String introduction;
    /**
     * 联系方式
     */
    @ApiModelProperty(value="联系方式")
    private String mobile;
    /**
     * 拒绝原因
     */
    @ApiModelProperty(value="拒绝原因")
    private String reason;
    /**
     * 图片地址 多个用逗号隔开
     */
    @ApiModelProperty(value="图片地址 多个用逗号隔开")
    private String photoPah;

    @ApiModelProperty(value = "发布人主键",hidden = true)
    private Long userId;

    @ApiModelProperty(value = "社区主键",hidden = true)
    private Long communityId;


}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/community/PageComOpsHouseDTO.java

New file
@@ -0,0 +1,50 @@
package com.panzhihua.common.model.dtos.community;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.Date;

/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 分页查询房屋租售
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2021-01-23 11:11
 **/
@Data
@ApiModel("分页查询房屋租售")
public class PageComOpsHouseDTO {
    @ApiModelProperty(value = "分页-当前页数",example = "1")
    private Long pageNum;

    @ApiModelProperty(value = "分页-每页记录数",example = "10")
    private Long pageSize;

    @ApiModelProperty(value="房屋所在社区id")
    private Long houseCommunityId;

    @ApiModelProperty(value="房屋所在社区名字")
    private String houseCommunityName;

    @ApiModelProperty(value = "社区id",hidden = true)
    private Long communityId;

    @ApiModelProperty("查询开始时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date begin;

    @ApiModelProperty("查询结束时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date end;

    @ApiModelProperty(value = "发布人id")
    private Long userId;

    @ApiModelProperty(value = "状态  0待审核 1已上架 2已驳回 3已下架")
    private Integer status;

    @ApiModelProperty("小程序使用 1 表示查询我的")
    private Integer isMy;
}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComOpsHouseVO.java

New file
@@ -0,0 +1,154 @@
package com.panzhihua.common.model.vos.community;

import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.io.Serializable;
import java.time.LocalDateTime;
import java.util.Date;

/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 房屋租售
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2021-01-22 14:48
 **/
@Data
public class ComOpsHouseVO implements Serializable {
    private static final long serialVersionUID = 1L;

    /**
     * 主键
     */
    @ApiModelProperty(value="主键")
    private Long id;
    /**
     * 状态  0待审核 1已上架 2已驳回 3已下架
     */
    @ApiModelProperty(value="状态  0待审核 1已上架 2已驳回 3已下架")
    private Integer status;
    /**
     * 房屋所在社区id
     */
    @ApiModelProperty(value="房屋所在社区id")
    private Long houseCommunityId;
    /**
     * 房屋所在社区名字
     */
    @ApiModelProperty(value="房屋所在社区名字")
    private String houseCommunityName;
    /**
     * 房屋标题
     */
    @ApiModelProperty(value="房屋标题")
    private String title;
    /**
     * 租售类型 1 出租 2 出售
     */
    @ApiModelProperty(value="租售类型 1 出租 2 出售")
    private Integer houseType;
    /**
     * 租房类型 1 整租 2 合租
     */
    @ApiModelProperty(value="租房类型 1 整租 2 合租")
    private Integer rentType;
    /**
     * 价格
     */
    @ApiModelProperty(value="价格")
    private Integer amount;
    /**
     * 面积
     */
    @ApiModelProperty(value="面积")
    private Integer area;
    /**
     * 室数量
     */
    @ApiModelProperty(value="室数量")
    private Integer brn;
    /**
     * 厅数量
     */
    @ApiModelProperty(value="厅数量")
    private Integer lrn;
    /**
     * 卫数量
     */
    @ApiModelProperty(value="卫数量")
    private Integer wcn;
    /**
     * 所在楼层
     */
    @ApiModelProperty(value="所在楼层")
    private Integer floor;
    /**
     * 总楼层
     */
    @ApiModelProperty(value="总楼层")
    private Integer totalFloor;
    /**
     * 朝向 0无1东2南3西4北5东南6东北7西南8西北9南北10东西
     */
    @ApiModelProperty(value="朝向 0无1东2南3西4北5东南6东北7西南8西北9南北10东西")
    private Integer orient;
    /**
     * 装修情况
     */
    @ApiModelProperty(value="装修情况")
    private String decoration;
    /**
     * 房屋简介
     */
    @ApiModelProperty(value="房屋简介")
    private String introduction;
    /**
     * 联系方式
     */
    @ApiModelProperty(value="联系方式")
    private String mobile;
    /**
     * 拒绝原因
     */
    @ApiModelProperty(value="拒绝原因")
    private String reason;
    /**
     * 图片地址 多个用逗号隔开
     */
    @ApiModelProperty(value="图片地址 多个用逗号隔开")
    private String photoPah;
    /**
     * 发布人id
     */
    @ApiModelProperty(value="发布人id")
    private Long userId;
    /**
     * 用户类型 1 小程序 2 运营平台 3 社区平台
     */
    @ApiModelProperty(value="用户类型 1 小程序 2 运营平台 3 社区平台")
    private Integer userType;
    /**
     * 社区主键
     */
    @ApiModelProperty(value="社区主键")
    private Long communityId;
    /**
     *
     */
    @ApiModelProperty(value="")
    private LocalDateTime approveAt;
    /**
     * 审核人id
     */
    @ApiModelProperty(value="审核人id")
    private Long approveBy;

    /**
     * create_at
     */
    private Date createAt;

    @ApiModelProperty("发布人名字")
    private String userName;

}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java

@@ -867,4 +867,39 @@
    R checkAreaHouse(@RequestParam("id")Long id);


    /**
     * 一起议-新增
     * @param comOpsHouseDTO 新增参数
     * @return 新增结果
     */
    @PostMapping("addOpsHouse")
    R addOpsHouse(@RequestBody ComOpsHouseDTO comOpsHouseDTO);

    /**
     * 一起议-详情
     * @param id 主键
     * @return ComOpsHouseVO
     */
    @PostMapping("detailOpsHouse")
    R detailOpsHouse(@RequestParam("id") Long id);

    @PostMapping("/putOpsHouse")
    R putOpsHouse(@RequestBody ComOpsHouseVO comOpsHouseVO);

    /**
     * 一起议-删除
     * @param id 主键
     * @return 删除结果
     */
    @PostMapping("deleteOpsHouse")
    R deleteOpsHouse(@RequestParam("id") Long id);

    /**
     * 一起议-分页查询
     * @param pageComOpsHouseDTO 查询参数
     * @return ComOpsHouseVO
     */
    @PostMapping("pageOpsHouse")
    R pageOpsHouse(@RequestBody PageComOpsHouseDTO pageComOpsHouseDTO);

}

 springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/HouseApi.java

New file
@@ -0,0 +1,75 @@
package com.panzhihua.community_backstage.api;

import com.panzhihua.common.controller.BaseController;
import com.panzhihua.common.model.dtos.community.ComOpsHouseDTO;
import com.panzhihua.common.model.dtos.community.PageComOpsHouseDTO;
import com.panzhihua.common.model.vos.LoginUserInfoVO;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.ComOpsHouseVO;
import com.panzhihua.common.service.community.CommunityService;
import com.panzhihua.common.validated.AddGroup;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.util.ObjectUtils;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 房屋租售
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2021-01-22 15:30
 **/
@Slf4j
@Api(tags = {"房屋租售"})
@RestController
@RequestMapping("/")
public class HouseApi extends BaseController {
    @Resource
    private CommunityService communityService;

    @ApiOperation(value = "房屋租售-新增")
    @PostMapping("house")
    public R addHouse(@RequestBody @Validated(AddGroup.class) ComOpsHouseDTO comOpsHouseDTO) {
        LoginUserInfoVO loginUserInfo = this.getLoginUserInfo();
        Long userId = loginUserInfo.getUserId();
        Long communityId = loginUserInfo.getCommunityId();
        comOpsHouseDTO.setUserId(userId);
        comOpsHouseDTO.setCommunityId(communityId);
        return communityService.addOpsHouse(comOpsHouseDTO);
    }

    @ApiOperation(value = "房屋租售-详情",response = ComOpsHouseVO.class)
    @GetMapping("house")
    public R detailHouse(@RequestParam("id") Long id) {
        return communityService.detailOpsHouse(id);
    }

    @ApiOperation(value = "编辑/审核房屋租售")
    @PutMapping("house")
    public R putputOpsHouse(@RequestBody ComOpsHouseVO comOpsHouseVO) {
        Long id = comOpsHouseVO.getId();
        if (ObjectUtils.isEmpty(id)) {
            return R.fail("房屋租售id主键不能为空");
        }
        return communityService.putOpsHouse(comOpsHouseVO);
    }

    @ApiOperation(value = "房屋租售-删除")
    @DeleteMapping("house")
    public R deleteHouse(@RequestParam("id") Long id) {
        return communityService.deleteOpsHouse(id);
    }


    @ApiOperation(value = "房屋租售-分页查询",response = ComOpsHouseVO.class)
    @PostMapping("pagehouse")
    public R pageHouse(@RequestBody PageComOpsHouseDTO pageComOpsHouseDTO) {
        pageComOpsHouseDTO.setCommunityId(this.getCommunityId());
        return communityService.pageOpsHouse(pageComOpsHouseDTO);
    }

}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/HouseApi.java

New file
@@ -0,0 +1,74 @@
package com.panzhihua.service_community.api;

import com.panzhihua.common.model.dtos.community.ComOpsHouseDTO;
import com.panzhihua.common.model.dtos.community.PageComOpsHouseDTO;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.ComOpsHouseVO;
import com.panzhihua.service_community.service.ComOpsHouseService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 房屋租售
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2021-01-22 14:52
 **/
@Slf4j
@RestController
@RequestMapping("/")
public class HouseApi {
    @Resource
    private ComOpsHouseService comOpsHouseService;

    /**
     * 房屋租售-新增
     * @param comOpsHouseDTO 新增参数
     * @return 新增结果
     */
    @PostMapping("addOpsHouse")
    public R addOpsHouse(@RequestBody ComOpsHouseDTO comOpsHouseDTO){
        return comOpsHouseService.addHouse(comOpsHouseDTO);
    }

    /**
     * 房屋租售-详情
     * @param id 主键
     * @return ComOpsHouseVO
     */
    @PostMapping("detailOpsHouse")
    public R detailOpsHouse(@RequestParam("id") Long id){
        return comOpsHouseService.detailHouse(id);
    }

    @PostMapping("putOpsHouse")
    @Transactional(rollbackFor = Exception.class)
    public R putOpsHouse(@RequestBody ComOpsHouseVO comOpsHouseVO){
        R r = comOpsHouseService.putHouse(comOpsHouseVO);
        return r;
    }

    /**
     * 房屋租售-删除
     * @param id 主键
     * @return 删除结果
     */
    @PostMapping("deleteOpsHouse")
    public R deleteHouse(@RequestParam("id") Long id){
        return comOpsHouseService.deleteHouse(id);
    }

    /**
     * 房屋租售-分页查询
     * @param pageComOpsHouseDTO 查询参数
     * @return ComOpsHouseVO
     */
    @PostMapping("pageOpsHouse")
    public R pageOpsHouse(@RequestBody PageComOpsHouseDTO pageComOpsHouseDTO){
        return comOpsHouseService.pageHouse(pageComOpsHouseDTO);
    }

}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComOpsHouseDAO.java

New file
@@ -0,0 +1,56 @@
package com.panzhihua.service_community.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.dtos.community.PageComOpsHouseDTO;
import com.panzhihua.common.model.vos.LoginUserInfoVO;
import com.panzhihua.common.model.vos.community.ComOpsHouseVO;
import com.panzhihua.common.model.vos.community.ComActVO;
import com.panzhihua.service_community.model.dos.ComOpsHouseDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 房屋租售
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2021-01-22 14:49
 **/
@Mapper
public interface ComOpsHouseDAO extends BaseMapper<ComOpsHouseDO> {
    @Select("select name,address from com_act where community_id=#{communityId}")
    ComActVO selectCommunity(Long communityId);

    @Select("select type,name,phone,image_url from sys_user where user_id=#{userId}")
    LoginUserInfoVO selectUserByUserId(Long userId);

    @Select("<script> " +
            "SELECT d.*,\n" +
            "u.name userName\n" +
            "FROM\n" +
            "com_ops_house d\n" +
            "JOIN sys_user u ON d.user_id = u.user_id\n" +
            "where 1=1 " +
            "<if test='pageComOpsHouseDTO.communityId != null '>" +
            "AND d.community_id=#{pageComOpsHouseDTO.communityId} \n" +
            " </if> " +
            "<if test='pageComOpsHouseDTO.houseCommunityId != null '>" +
            "AND d.house_community_id=#{pageComOpsHouseDTO.houseCommunityId} \n" +
            " </if> " +
            "<if test='pageComOpsHouseDTO.status != null '>" +
            "AND d.status=#{pageComOpsHouseDTO.status} \n" +
            " </if> " +
            "<if test='pageComOpsHouseDTO.houseCommunityName != null and pageComOpsHouseDTO.houseCommunityName.trim() != &quot;&quot;'>" +
            " and d.`house_community_name` LIKE concat( #{pageComOpsHouseDTO.houseCommunityName}, '%' ) \n" +
            " </if> " +
            "<if test='pageComOpsHouseDTO.begin != null '>" +
            "AND d.create_at BETWEEN #{pageComOpsHouseDTO.begin} \n" +
            "AND #{pageComOpsHouseDTO.end} \n" +
            " </if> " +
            " order by d.id desc "+
            "</script>")
    IPage<ComOpsHouseVO> pageHouse(Page page, @Param("pageComOpsHouseDTO") PageComOpsHouseDTO pageComOpsHouseDTO);

}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComOpsHouseDO.java

New file
@@ -0,0 +1,155 @@
package com.panzhihua.service_community.model.dos;

import com.baomidou.mybatisplus.annotation.*;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.io.Serializable;
import java.time.LocalDateTime;
import java.util.Date;

/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 房屋租售
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2021-01-22 14:48
 **/
@Data
@TableName(value = "com_ops_house")
public class ComOpsHouseDO implements Serializable {
    private static final long serialVersionUID = 1L;

    /**
     * 主键
     */
    @TableId(type = IdType.AUTO)
    @ApiModelProperty(value="主键")
    private Long id;
    /**
     * 状态  0待审核 1已上架 2已驳回 3已下架
     */
    @ApiModelProperty(value="状态  0待审核 1已上架 2已驳回 3已下架")
    private Integer status;
    /**
     * 房屋所在社区id
     */
    @ApiModelProperty(value="房屋所在社区id")
    private Long houseCommunityId;
    /**
     * 房屋所在社区名字
     */
    @ApiModelProperty(value="房屋所在社区名字")
    private String houseCommunityName;
    /**
     * 房屋标题
     */
    @ApiModelProperty(value="房屋标题")
    private String title;
    /**
     * 租售类型 1 出租 2 出售
     */
    @ApiModelProperty(value="租售类型 1 出租 2 出售")
    private Integer houseType;
    /**
     * 租房类型 1 整租 2 合租
     */
    @ApiModelProperty(value="租房类型 1 整租 2 合租")
    private Integer rentType;
    /**
     * 价格
     */
    @ApiModelProperty(value="价格")
    private Integer amount;
    /**
     * 面积
     */
    @ApiModelProperty(value="面积")
    private Integer area;
    /**
     * 室数量
     */
    @ApiModelProperty(value="室数量")
    private Integer brn;
    /**
     * 厅数量
     */
    @ApiModelProperty(value="厅数量")
    private Integer lrn;
    /**
     * 卫数量
     */
    @ApiModelProperty(value="卫数量")
    private Integer wcn;
    /**
     * 所在楼层
     */
    @ApiModelProperty(value="所在楼层")
    private Integer floor;
    /**
     * 总楼层
     */
    @ApiModelProperty(value="总楼层")
    private Integer totalFloor;
    /**
     * 朝向 0无1东2南3西4北5东南6东北7西南8西北9南北10东西
     */
    @ApiModelProperty(value="朝向 0无1东2南3西4北5东南6东北7西南8西北9南北10东西")
    private Integer orient;
    /**
     * 装修情况
     */
    @ApiModelProperty(value="装修情况")
    private String decoration;
    /**
     * 房屋简介
     */
    @ApiModelProperty(value="房屋简介")
    private String introduction;
    /**
     * 联系方式
     */
    @ApiModelProperty(value="联系方式")
    private String mobile;
    /**
     * 拒绝原因
     */
    @ApiModelProperty(value="拒绝原因")
    private String reason;
    /**
     * 图片地址 多个用逗号隔开
     */
    @ApiModelProperty(value="图片地址 多个用逗号隔开")
    private String photoPah;
    /**
     * 发布人id
     */
    @ApiModelProperty(value="发布人id")
    private Long userId;
    /**
     * 用户类型 1 小程序 2 运营平台 3 社区平台
     */
    @ApiModelProperty(value="用户类型 1 小程序 2 运营平台 3 社区平台")
    private Integer userType;
    /**
     * 社区主键
     */
    @ApiModelProperty(value="社区主键")
    private Long communityId;
    /**
     *
     */
    @ApiModelProperty(value="")
    private LocalDateTime approveAt;
    /**
     * 审核人id
     */
    @ApiModelProperty(value="审核人id")
    private Long approveBy;

    /**
     * create_at
     */
    @TableField(fill = FieldFill.INSERT)
    private Date createAt;

}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComOpsHouseService.java

New file
@@ -0,0 +1,41 @@
package com.panzhihua.service_community.service;

import com.panzhihua.common.model.dtos.community.ComOpsHouseDTO;
import com.panzhihua.common.model.dtos.community.PageComOpsHouseDTO;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.ComOpsHouseVO;

/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 房屋租售
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2021-01-22 14:50
 **/
public interface ComOpsHouseService {
    /**
     * 房屋租售-新增
     * @param comOpsHouseDTO 新增参数
     * @return 新增结果
     */
    R addHouse(ComOpsHouseDTO comOpsHouseDTO);
    /**
     * 房屋租售-详情
     * @param id 主键
     * @return ComOpsHouseVO
     */
    R detailHouse(Long id);

    R putHouse(ComOpsHouseVO comOpsHouseVO);
    /**
     * 房屋租售-删除
     * @param id 主键
     * @return 删除结果
     */
    R deleteHouse(Long id);
    /**
     * 房屋租售-分页查询
     * @param pageComOpsHouseDTO 查询参数
     * @return ComOpsHouseVO
     */
    R pageHouse(PageComOpsHouseDTO pageComOpsHouseDTO);
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComOpsHouseServiceImpl.java

New file
@@ -0,0 +1,114 @@
package com.panzhihua.service_community.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.dtos.community.ComOpsHouseDTO;
import com.panzhihua.common.model.dtos.community.PageComOpsHouseDTO;
import com.panzhihua.common.model.vos.LoginUserInfoVO;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.ComOpsHouseVO;
import com.panzhihua.service_community.dao.ComOpsHouseDAO;
import com.panzhihua.service_community.model.dos.ComOpsHouseDO;
import com.panzhihua.service_community.service.ComOpsHouseService;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.ObjectUtils;

import javax.annotation.Resource;

/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 房屋租售
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2021-01-22 14:51
 **/
@Service
public class ComOpsHouseServiceImpl implements ComOpsHouseService {
    @Resource
    private ComOpsHouseDAO comOpsHouseDAO;

    /**
     * 房屋租售-新增
     *
     * @param comOpsHouseDTO 新增参数
     * @return 新增结果
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public R addHouse(ComOpsHouseDTO comOpsHouseDTO) {
        ComOpsHouseDO comOpsHouseDO=new ComOpsHouseDO();
        BeanUtils.copyProperties(comOpsHouseDTO,comOpsHouseDO);
        comOpsHouseDAO.insert(comOpsHouseDO);
        return R.ok();
    }

    /**
     * 房屋租售-详情
     *
     * @param id 主键
     * @return ComOpsHouseVO
     */
    @Override
    public R detailHouse(Long id) {
        ComOpsHouseDO comOpsHouseDO = comOpsHouseDAO.selectById(id);
        if (ObjectUtils.isEmpty(comOpsHouseDO)) {
            return R.fail("房屋租售不存在");
        }
        ComOpsHouseVO comOpsHouseVO=new ComOpsHouseVO();
        BeanUtils.copyProperties(comOpsHouseDO,comOpsHouseVO);
        Long userId = comOpsHouseDO.getUserId();
        LoginUserInfoVO loginUserInfoVO=comOpsHouseDAO.selectUserByUserId(userId);
        comOpsHouseVO.setUserName(loginUserInfoVO.getName());

        return R.ok(comOpsHouseVO);
    }

    @Override
    public R putHouse(ComOpsHouseVO comOpsHouseVO) {
        ComOpsHouseDO comOpsHouseDO=new ComOpsHouseDO();
        BeanUtils.copyProperties(comOpsHouseVO,comOpsHouseDO);
        comOpsHouseDAO.updateById(comOpsHouseDO);
        return R.ok();
    }

    /**
     * 房屋租售-删除
     *
     * @param id 主键
     * @return 删除结果
     */
    @Override
    public R deleteHouse(Long id) {
        int delete = comOpsHouseDAO.deleteById(id);
        if (delete>0) {
            return R.ok();
        }
        return R.fail();
    }

    /**
     * 房屋租售-分页查询
     *
     * @param pageComOpsHouseDTO 查询参数
     * @return ComOpsHouseVO
     */
    @Override
    public R pageHouse(PageComOpsHouseDTO pageComOpsHouseDTO) {
        Page page = new Page<>();
        Long pageNum = pageComOpsHouseDTO.getPageNum();
        Long pageSize = pageComOpsHouseDTO.getPageSize();
        if (null==pageNum||0==pageNum) {
            pageNum = 1l;
        }
        if (null==pageSize||0==pageSize) {
            pageSize = 10l;
        }
        page.setSize(pageSize);
        page.setCurrent(pageNum);
        IPage<ComOpsHouseVO> iPage = comOpsHouseDAO.pageHouse(page, pageComOpsHouseDTO);
        return R.ok(iPage);

    }

}