项目管理代码生成，案件分类

无关风月

3 天以前 110809db132446d2fa5ed2986f1ec2ce755b5b13

项目管理代码生成，案件分类

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/CaseMainController.java

@@ -93,7 +93,7 @@
    }
    @Log(title = "案件-删除", businessType = BusinessType.DELETE)
    @Transactional
    @ApiOperation(value = "案件分类-删除")
    @ApiOperation(value = "案件-删除")
    @DeleteMapping(value = "/delete")
    public R delete(@RequestParam String ids) {
        caseMainService.removeBatchByIds(Arrays.asList(ids.split(",")));

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/DrDisplacementController.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.web.controller.api;


import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * <p>
 * 拆迁情况 前端控制器
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@RestController
@RequestMapping("/dr-displacement")
public class DrDisplacementController {

}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/DrDisplacementHouseController.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.web.controller.api;


import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * <p>
 * 拆迁情况房屋面积明细 前端控制器
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@RestController
@RequestMapping("/dr-displacement-house")
public class DrDisplacementHouseController {

}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/DrDisplacementReturnHouseController.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.web.controller.api;


import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * <p>
 * 拆迁情况房屋还房种类 前端控制器
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@RestController
@RequestMapping("/dr-displacement-return-house")
public class DrDisplacementReturnHouseController {

}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/DrResettlementController.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.web.controller.api;


import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * <p>
 * 安置办证表 前端控制器
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@RestController
@RequestMapping("/dr-resettlement")
public class DrResettlementController {

}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/LandAcquiringController.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.web.controller.api;


import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * <p>
 * 下征土地 前端控制器
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@RestController
@RequestMapping("/land-acquiring")
public class LandAcquiringController {

}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/LandCertifiedController.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.web.controller.api;


import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * <p>
 * 已办证土地 前端控制器
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@RestController
@RequestMapping("/land-certified")
public class LandCertifiedController {

}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/LandReportedController.java

New file
@@ -0,0 +1,70 @@
package com.ruoyi.web.controller.api;


import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.common.core.domain.R;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.framework.web.service.TokenService;
import com.ruoyi.system.model.LandReported;
import com.ruoyi.system.model.LandReportedFile;
import com.ruoyi.system.model.LandReported;
import com.ruoyi.system.query.LandReportedListQuery;
import com.ruoyi.system.service.*;
import io.swagger.annotations.ApiOperation;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.time.LocalDateTime;
import java.util.Arrays;
import java.util.List;

/**
 * <p>
 * 已办证土地 前端控制器
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@RestController
@RequestMapping("/land-reported")
public class LandReportedController {
    @Resource
    private LandReportedService landReportedService;
    @ApiOperation(value = "已办证土地分页列表")
    @PostMapping(value = "/pageList")
    public R<PageInfo<LandReported>> pageList(@RequestBody LandReportedListQuery query) {
//        landReportedService.pageList(query)
        return R.ok();
    }
    @ApiOperation(value = "添加")
    @Transactional
    @Log(title = "已办证土地-添加", businessType = BusinessType.INSERT)
    @PostMapping(value = "/add")
    public R<Boolean> save(@RequestBody LandReported entity) {
        landReportedService.save( entity);
        return R.ok();
    }
    @ApiOperation(value = "修改")
    @Transactional
    @Log(title = "已办证土地-修改", businessType = BusinessType.UPDATE)
    @PostMapping(value = "/edit")
    public R<Boolean> edit(@RequestBody LandReported entity) {
        landReportedService.updateById(entity);

        return R.ok();
    }
    @Log(title = "已办证土地-删除", businessType = BusinessType.DELETE)
    @Transactional
    @ApiOperation(value = "已办证土地-删除")
    @DeleteMapping(value = "/delete")
    public R delete(@RequestParam String ids) {
        landReportedService.removeBatchByIds(Arrays.asList(ids.split(",")));
        return R.ok();
    }
}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/LandReservedController.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.web.controller.api;


import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * <p>
 * 收储土地 前端控制器
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@RestController
@RequestMapping("/land-reserved")
public class LandReservedController {

}


 ruoyi-system/src/main/java/com/ruoyi/system/mapper/DrDisplacementHouseMapper.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.system.model.DrDisplacementHouse;

/**
 * <p>
 * 拆迁情况房屋面积明细 Mapper 接口
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface DrDisplacementHouseMapper extends BaseMapper<DrDisplacementHouse> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/DrDisplacementMapper.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.system.model.DrDisplacement;

/**
 * <p>
 * 拆迁情况 Mapper 接口
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface DrDisplacementMapper extends BaseMapper<DrDisplacement> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/DrDisplacementReturnHouseMapper.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.system.model.DrDisplacementReturnHouse;

/**
 * <p>
 * 拆迁情况房屋还房种类 Mapper 接口
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface DrDisplacementReturnHouseMapper extends BaseMapper<DrDisplacementReturnHouse> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/DrResettlementMapper.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.system.model.DrResettlement;

/**
 * <p>
 * 安置办证表 Mapper 接口
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface DrResettlementMapper extends BaseMapper<DrResettlement> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/LandAcquiringMapper.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.system.model.LandAcquiring;

/**
 * <p>
 * 下征土地 Mapper 接口
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface LandAcquiringMapper extends BaseMapper<LandAcquiring> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/LandCertifiedMapper.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.system.model.LandCertified;

/**
 * <p>
 * 已办证土地 Mapper 接口
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface LandCertifiedMapper extends BaseMapper<LandCertified> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/LandReportedMapper.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.system.model.LandReported;

/**
 * <p>
 * 已办证土地 Mapper 接口
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface LandReportedMapper extends BaseMapper<LandReported> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/LandReservedMapper.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.system.model.LandReserved;

/**
 * <p>
 * 收储土地 Mapper 接口
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface LandReservedMapper extends BaseMapper<LandReserved> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/model/DrDisplacement.java

New file
@@ -0,0 +1,143 @@
package com.ruoyi.system.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.LocalDateTime;

/**
 * <p>
 * 拆迁情况
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("dr_displacement")
@ApiModel(value="DrDisplacement对象", description="拆迁情况")
public class DrDisplacement implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "主键")
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    @ApiModelProperty(value = "姓名")
    @TableField("name")
    private String name;

    @ApiModelProperty(value = "联系电话")
    @TableField("phone")
    private String phone;

    @ApiModelProperty(value = "村社ID")
    @TableField("community_id")
    private Integer communityId;

    @ApiModelProperty(value = "村社名称")
    @TableField("community_name")
    private String communityName;

    @ApiModelProperty(value = "身份证")
    @TableField("id_card")
    private String idCard;

    @ApiModelProperty(value = "坐落地点")
    @TableField("address")
    private String address;

    @ApiModelProperty(value = "房屋总面积（㎡）")
    @TableField("total_area")
    private Double totalArea;

    @ApiModelProperty(value = "是否安置")
    @TableField("is_settlement")
    private Integer isSettlement;

    @ApiModelProperty(value = "房屋用途 0：住宅；1：商业")
    @TableField("house_type")
    private Integer houseType;

    @ApiModelProperty(value = "拆迁安置方式 0：产权调换；1：限量还房；2：货币安置；")
    @TableField("resettlement_mode")
    private Integer resettlementMode;

    @ApiModelProperty(value = "房屋补偿金额")
    @TableField("house_compensation")
    private BigDecimal houseCompensation;

    @ApiModelProperty(value = "附属设施补偿金额  ")
    @TableField("facility_compensation")
    private BigDecimal facilityCompensation;

    @ApiModelProperty(value = "其他金额")
    @TableField("other_compensation")
    private BigDecimal otherCompensation;

    @ApiModelProperty(value = "过渡费")
    @TableField("transition_allowance")
    private BigDecimal transitionAllowance;

    @ApiModelProperty(value = "搬家费")
    @TableField("moving_fee")
    private BigDecimal movingFee;

    @ApiModelProperty(value = "补偿合计")
    @TableField("total_compensation")
    private BigDecimal totalCompensation;

    @ApiModelProperty(value = "协议签订时间")
    @TableField("agreement_date")
    private LocalDate agreementDate;

    @ApiModelProperty(value = "安置小区")
    @TableField("settlement_community")
    private byte[] settlementCommunity;

    @ApiModelProperty(value = "人数")
    @TableField("person_count")
    private Integer personCount;

    @ApiModelProperty(value = "附件，多个使用英文逗号拼接")
    @TableField("attachment_urls")
    private String attachmentUrls;

    @ApiModelProperty(value = "创建时间")
    @TableField("create_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime createTime;

    @ApiModelProperty(value = "创建人")
    @TableField("create_by")
    private String createBy;

    @ApiModelProperty(value = "更新时间")
    @TableField("update_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime updateTime;

    @ApiModelProperty(value = "更新人")
    @TableField("update_by")
    private String updateBy;

    @ApiModelProperty(value = "是否删除 0-否，1-是")
    @TableField("disabled")
    private Boolean disabled;


}

 ruoyi-system/src/main/java/com/ruoyi/system/model/DrDisplacementHouse.java

New file
@@ -0,0 +1,47 @@
package com.ruoyi.system.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serializable;

/**
 * <p>
 * 拆迁情况房屋面积明细
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("dr_displacement_house")
@ApiModel(value="DrDisplacementHouse对象", description="拆迁情况房屋面积明细")
public class DrDisplacementHouse implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "主键")
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    @ApiModelProperty(value = "拆迁ID")
    @TableField("displacement_id")
    private Integer displacementId;

    @ApiModelProperty(value = "结构 0：砖混；1：砖木；2：瓦木；3：垮塌；4：预制现浇；5：其他；")
    @TableField("construction_type")
    private Integer constructionType;

    @ApiModelProperty(value = "面积（㎡）")
    @TableField("area")
    private Double area;


}

 ruoyi-system/src/main/java/com/ruoyi/system/model/DrDisplacementReturnHouse.java

New file
@@ -0,0 +1,51 @@
package com.ruoyi.system.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serializable;

/**
 * <p>
 * 拆迁情况房屋还房种类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("dr_displacement_return_house")
@ApiModel(value="DrDisplacementReturnHouse对象", description="拆迁情况房屋还房种类")
public class DrDisplacementReturnHouse implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "主键")
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    @ApiModelProperty(value = "拆迁ID")
    @TableField("displacement_id")
    private Integer displacementId;

    @ApiModelProperty(value = "结构 0：营业房；1：住房；2：库房；")
    @TableField("return_type")
    private Integer returnType;

    @ApiModelProperty(value = "户型（㎡）")
    @TableField("area")
    private Double area;

    @ApiModelProperty(value = "套数")
    @TableField("quantity")
    private Integer quantity;


}

 ruoyi-system/src/main/java/com/ruoyi/system/model/DrResettlement.java

New file
@@ -0,0 +1,105 @@
package com.ruoyi.system.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;

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

/**
 * <p>
 * 安置办证表
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("dr_resettlement")
@ApiModel(value="DrResettlement对象", description="安置办证表")
public class DrResettlement implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "主键")
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    @ApiModelProperty(value = "拆迁情况ID")
    @TableField("displacement_id")
    private Integer displacementId;

    @ApiModelProperty(value = "小区ID")
    @TableField("community_id")
    private Integer communityId;

    @ApiModelProperty(value = "拆迁协议")
    @TableField("displacement_agreement_url")
    private String displacementAgreementUrl;

    @ApiModelProperty(value = "结算清单")
    @TableField("settlement_list_url")
    private String settlementListUrl;

    @ApiModelProperty(value = "缴费收据")
    @TableField("payment_receipt_url")
    private String paymentReceiptUrl;

    @ApiModelProperty(value = "身份证")
    @TableField("id_card_url")
    private String idCardUrl;

    @ApiModelProperty(value = "结婚证")
    @TableField("marriage_certificate_url")
    private String marriageCertificateUrl;

    @ApiModelProperty(value = "户口本复印件")
    @TableField("household_register_url")
    private String householdRegisterUrl;

    @ApiModelProperty(value = "旧房产证")
    @TableField("old_property_certificate_url")
    private String oldPropertyCertificateUrl;

    @ApiModelProperty(value = "土地证")
    @TableField("land_certificate_url")
    private String landCertificateUrl;

    @ApiModelProperty(value = "其他")
    @TableField("other_documents_url")
    private String otherDocumentsUrl;

    @ApiModelProperty(value = "创建时间")
    @TableField("create_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime createTime;

    @ApiModelProperty(value = "创建人")
    @TableField("create_by")
    private String createBy;

    @ApiModelProperty(value = "更新时间")
    @TableField("update_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime updateTime;

    @ApiModelProperty(value = "更新人")
    @TableField("update_by")
    private String updateBy;

    @ApiModelProperty(value = "是否删除 0-否，1-是")
    @TableField("disabled")
    private Boolean disabled;


}

 ruoyi-system/src/main/java/com/ruoyi/system/model/LandAcquiring.java

New file
@@ -0,0 +1,108 @@
package com.ruoyi.system.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;

/**
 * <p>
 * 下征土地
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("land_acquiring")
@ApiModel(value="LandAcquiring对象", description="下征土地")
public class LandAcquiring implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "主键")
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    @ApiModelProperty(value = "地块名称")
    @TableField("land_name")
    private String landName;

    @ApiModelProperty(value = "辖区名称")
    @TableField("street_name")
    private String streetName;

    @ApiModelProperty(value = "镇街ID")
    @TableField("street_id")
    private Integer streetId;

    @ApiModelProperty(value = "面积（㎡）")
    @TableField("area")
    private Double area;

    @ApiModelProperty(value = "性质 0：商业用地；1：综合用地；2：住宅用地；3：工业用地；4：其他用地；")
    @TableField("type")
    private Integer type;

    @ApiModelProperty(value = "现状 0：闲置；1：出租；2：置换；3：抵押；")
    @TableField("status")
    private Integer status;

    @ApiModelProperty(value = "抵押银行")
    @TableField("mortgage_bank")
    private String mortgageBank;

    @ApiModelProperty(value = "抵押时间")
    @TableField("mortgage_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime mortgageTime;

    @ApiModelProperty(value = "抵押金额")
    @TableField("mortgage_amount")
    private BigDecimal mortgageAmount;

    @ApiModelProperty(value = "备注")
    @TableField("remark")
    private String remark;

    @ApiModelProperty(value = "是否出让")
    @TableField("is_sell")
    private Boolean isSell;

    @ApiModelProperty(value = "创建时间")
    @TableField("create_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime createTime;

    @ApiModelProperty(value = "创建人")
    @TableField("create_by")
    private String createBy;

    @ApiModelProperty(value = "更新时间")
    @TableField("update_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime updateTime;

    @ApiModelProperty(value = "更新人")
    @TableField("update_by")
    private String updateBy;

    @ApiModelProperty(value = "是否删除 0-否，1-是")
    @TableField("disabled")
    private Boolean disabled;


}

 ruoyi-system/src/main/java/com/ruoyi/system/model/LandCertified.java

New file
@@ -0,0 +1,135 @@
package com.ruoyi.system.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.LocalDateTime;

/**
 * <p>
 * 已办证土地
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("land_certified")
@ApiModel(value="LandCertified对象", description="已办证土地")
public class LandCertified implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "主键")
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    @ApiModelProperty(value = "地块名称")
    @TableField("land_name")
    private String landName;

    @ApiModelProperty(value = "辖区名称")
    @TableField("street_name")
    private String streetName;

    @ApiModelProperty(value = "镇街ID")
    @TableField("street_id")
    private Integer streetId;

    @ApiModelProperty(value = "详细地址")
    @TableField("address")
    private String address;

    @ApiModelProperty(value = "面积（㎡）")
    @TableField("area")
    private Double area;

    @ApiModelProperty(value = "性质 0：商业用地；1：综合用地；2：住宅用地；3：工业用地；4：其他用地；")
    @TableField("type")
    private Integer type;

    @ApiModelProperty(value = "现状 0：闲置；1：出租；2：置换；3：抵押；")
    @TableField("status")
    private Integer status;

    @ApiModelProperty(value = "权属人")
    @TableField("owner")
    private String owner;

    @ApiModelProperty(value = "证号")
    @TableField("certificate_number")
    private String certificateNumber;

    @ApiModelProperty(value = "发证时间")
    @TableField("certificate_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime certificateTime;

    @ApiModelProperty(value = "终止日期")
    @TableField("terminal_date")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")

    private LocalDate terminalDate;

    @ApiModelProperty(value = "抵押银行")
    @TableField("mortgage_bank")
    private String mortgageBank;

    @ApiModelProperty(value = "抵押时间")
    @TableField("mortgage_time")
    private LocalDateTime mortgageTime;

    @ApiModelProperty(value = "抵押金额")
    @TableField("mortgage_amount")
    private BigDecimal mortgageAmount;

    @ApiModelProperty(value = "备注")
    @TableField("remark")
    private String remark;

    @ApiModelProperty(value = "是否出让")
    @TableField("is_sell")
    private Boolean isSell;

    @ApiModelProperty(value = "相关附件，多个附件使用英文逗号拼接")
    @TableField("attachment_urls")
    private String attachmentUrls;

    @ApiModelProperty(value = "创建时间")
    @TableField("create_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime createTime;

    @ApiModelProperty(value = "创建人")
    @TableField("create_by")
    private String createBy;

    @ApiModelProperty(value = "更新时间")
    @TableField("update_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime updateTime;

    @ApiModelProperty(value = "更新人")
    @TableField("update_by")
    private String updateBy;

    @ApiModelProperty(value = "是否删除 0-否，1-是")
    @TableField("disabled")
    private Boolean disabled;


}

 ruoyi-system/src/main/java/com/ruoyi/system/model/LandReported.java

New file
@@ -0,0 +1,118 @@
package com.ruoyi.system.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;

/**
 * <p>
 * 已办证土地
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("land_reported")
@ApiModel(value="LandReported对象", description="已办证土地")
public class LandReported implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "主键")
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    @ApiModelProperty(value = "地块名称")
    @TableField("land_name")
    private String landName;

    @ApiModelProperty(value = "辖区名称")
    @TableField("street_name")
    private String streetName;

    @ApiModelProperty(value = "镇街ID")
    @TableField("street_id")
    private Integer streetId;
    @ApiModelProperty(value = "权属人")
    @TableField("user_name")
    private String userName;
    @ApiModelProperty(value = "详细地址")
    @TableField("address")
    private String address;

    @ApiModelProperty(value = "面积（㎡）")
    @TableField("area")
    private Double area;

    @ApiModelProperty(value = "性质 0：商业用地；1：综合用地；2：住宅用地；3：工业用地；4：其他用地；")
    @TableField("type")
    private Integer type;

    @ApiModelProperty(value = "现状 0：闲置；1：出租；2：置换；3：抵押；")
    @TableField("status")
    private Integer status;

    @ApiModelProperty(value = "抵押银行")
    @TableField("mortgage_bank")
    private String mortgageBank;

    @ApiModelProperty(value = "抵押时间")
    @TableField("mortgage_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime mortgageTime;

    @ApiModelProperty(value = "抵押金额")
    @TableField("mortgage_amount")
    private BigDecimal mortgageAmount;

    @ApiModelProperty(value = "证号")
    @TableField("certificate_number")
    private String certificateNumber;

    @ApiModelProperty(value = "备注")
    @TableField("remark")
    private String remark;

    @ApiModelProperty(value = "是否出让")
    @TableField("is_sell")
    private Boolean isSell;

    @ApiModelProperty(value = "创建时间")
    @TableField("create_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime createTime;

    @ApiModelProperty(value = "创建人")
    @TableField("create_by")
    private String createBy;

    @ApiModelProperty(value = "更新时间")
    @TableField("update_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime updateTime;

    @ApiModelProperty(value = "更新人")
    @TableField("update_by")
    private String updateBy;

    @ApiModelProperty(value = "是否删除 0-否，1-是")
    @TableField("disabled")
    private Boolean disabled;


}

 ruoyi-system/src/main/java/com/ruoyi/system/model/LandReserved.java

New file
@@ -0,0 +1,138 @@
package com.ruoyi.system.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;

/**
 * <p>
 * 收储土地
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("land_reserved")
@ApiModel(value="LandReserved对象", description="收储土地")
public class LandReserved implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "主键")
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    @ApiModelProperty(value = "地块名称")
    @TableField("land_name")
    private String landName;

    @ApiModelProperty(value = "辖区名称")
    @TableField("street_name")
    private String streetName;

    @ApiModelProperty(value = "镇街ID")
    @TableField("street_id")
    private Integer streetId;

    @ApiModelProperty(value = "详细地址")
    @TableField("address")
    private String address;

    @ApiModelProperty(value = "性质 0：商业用地；1：综合用地；2：住宅用地；3：工业用地；4：其他用地；")
    @TableField("type")
    private Integer type;

    @ApiModelProperty(value = "面积（㎡）")
    @TableField("area")
    private Double area;

    @ApiModelProperty(value = "是否注销")
    @TableField("is_write_off")
    private Boolean isWriteOff;

    @ApiModelProperty(value = "原权属人")
    @TableField("orignal_owner")
    private String orignalOwner;

    @ApiModelProperty(value = "现管理单位")
    @TableField("current_institution")
    private String currentInstitution;

    @ApiModelProperty(value = "备注说明")
    @TableField("remark")
    private String remark;

    @ApiModelProperty(value = "拆迁情况")
    @TableField("demolition_situation")
    private String demolitionSituation;

    @ApiModelProperty(value = "收储金额")
    @TableField("reserved_money_amount")
    private BigDecimal reservedMoneyAmount;

    @ApiModelProperty(value = "收储时间")
    @TableField("reserved_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime reservedTime;

    @ApiModelProperty(value = "支付情况")
    @TableField("payment_situation")
    private String paymentSituation;

    @ApiModelProperty(value = "抵押银行")
    @TableField("mortgage_bank")
    private String mortgageBank;

    @ApiModelProperty(value = "抵押时间")
    @TableField("mortgage_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime mortgageTime;

    @ApiModelProperty(value = "抵押金额")
    @TableField("mortgage_amount")
    private BigDecimal mortgageAmount;

    @ApiModelProperty(value = "是否出让")
    @TableField("is_sell")
    private Boolean isSell;

    @ApiModelProperty(value = "创建时间")
    @TableField("create_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime createTime;

    @ApiModelProperty(value = "创建人")
    @TableField("create_by")
    private String createBy;

    @ApiModelProperty(value = "更新时间")
    @TableField("update_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")

    private LocalDateTime updateTime;

    @ApiModelProperty(value = "更新人")
    @TableField("update_by")
    private String updateBy;

    @ApiModelProperty(value = "是否删除 0-否，1-是")
    @TableField("disabled")
    private Boolean disabled;


}

 ruoyi-system/src/main/java/com/ruoyi/system/query/LandReportedListQuery.java

New file
@@ -0,0 +1,24 @@
package com.ruoyi.system.query;

import com.ruoyi.common.core.domain.BasePage;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
@ApiModel(value = "已办证土地分页列表query")
public class LandReportedListQuery extends BasePage {


    @ApiModelProperty(value = "地块名称")
    private String landName;
    @ApiModelProperty(value = "辖区")
    private String streetName;
    @ApiModelProperty(value = "权属人")
    private String userName;
    @ApiModelProperty(value = "证号")
    private String certificateNumber;
    @ApiModelProperty(value = "现状 0：闲置；1：出租；2：置换；3：抵押；")
    private Integer status;

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/DrDisplacementHouseService.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.system.model.DrDisplacementHouse;

/**
 * <p>
 * 拆迁情况房屋面积明细 服务类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface DrDisplacementHouseService extends IService<DrDisplacementHouse> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/DrDisplacementReturnHouseService.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.system.model.DrDisplacementReturnHouse;

/**
 * <p>
 * 拆迁情况房屋还房种类 服务类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface DrDisplacementReturnHouseService extends IService<DrDisplacementReturnHouse> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/DrDisplacementService.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.system.model.DrDisplacement;

/**
 * <p>
 * 拆迁情况 服务类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface DrDisplacementService extends IService<DrDisplacement> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/DrResettlementService.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.system.model.DrResettlement;

/**
 * <p>
 * 安置办证表 服务类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface DrResettlementService extends IService<DrResettlement> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/LandAcquiringService.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.system.model.LandAcquiring;

/**
 * <p>
 * 下征土地 服务类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface LandAcquiringService extends IService<LandAcquiring> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/LandCertifiedService.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.system.model.LandCertified;

/**
 * <p>
 * 已办证土地 服务类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface LandCertifiedService extends IService<LandCertified> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/LandReportedService.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.system.model.LandReported;

/**
 * <p>
 * 已办证土地 服务类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface LandReportedService extends IService<LandReported> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/LandReservedService.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.system.model.LandReserved;

/**
 * <p>
 * 收储土地 服务类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
public interface LandReservedService extends IService<LandReserved> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/DrDisplacementHouseServiceImpl.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.system.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.system.mapper.DrDisplacementHouseMapper;
import com.ruoyi.system.model.DrDisplacementHouse;
import com.ruoyi.system.service.DrDisplacementHouseService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * 拆迁情况房屋面积明细 服务实现类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Service
public class DrDisplacementHouseServiceImpl extends ServiceImpl<DrDisplacementHouseMapper, DrDisplacementHouse> implements DrDisplacementHouseService {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/DrDisplacementReturnHouseServiceImpl.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.system.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.system.mapper.DrDisplacementReturnHouseMapper;
import com.ruoyi.system.model.DrDisplacementReturnHouse;
import com.ruoyi.system.service.DrDisplacementReturnHouseService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * 拆迁情况房屋还房种类 服务实现类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Service
public class DrDisplacementReturnHouseServiceImpl extends ServiceImpl<DrDisplacementReturnHouseMapper, DrDisplacementReturnHouse> implements DrDisplacementReturnHouseService {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/DrDisplacementServiceImpl.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.system.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.system.mapper.DrDisplacementMapper;
import com.ruoyi.system.model.DrDisplacement;
import com.ruoyi.system.service.DrDisplacementService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * 拆迁情况 服务实现类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Service
public class DrDisplacementServiceImpl extends ServiceImpl<DrDisplacementMapper, DrDisplacement> implements DrDisplacementService {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/DrResettlementServiceImpl.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.system.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.system.mapper.DrResettlementMapper;
import com.ruoyi.system.model.DrResettlement;
import com.ruoyi.system.service.DrResettlementService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * 安置办证表 服务实现类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Service
public class DrResettlementServiceImpl extends ServiceImpl<DrResettlementMapper, DrResettlement> implements DrResettlementService {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/LandAcquiringServiceImpl.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.system.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.system.mapper.LandAcquiringMapper;
import com.ruoyi.system.model.LandAcquiring;
import com.ruoyi.system.service.LandAcquiringService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * 下征土地 服务实现类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Service
public class LandAcquiringServiceImpl extends ServiceImpl<LandAcquiringMapper, LandAcquiring> implements LandAcquiringService {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/LandCertifiedServiceImpl.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.system.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.system.mapper.LandCertifiedMapper;
import com.ruoyi.system.model.LandCertified;
import com.ruoyi.system.service.LandCertifiedService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * 已办证土地 服务实现类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Service
public class LandCertifiedServiceImpl extends ServiceImpl<LandCertifiedMapper, LandCertified> implements LandCertifiedService {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/LandReportedServiceImpl.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.system.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.system.mapper.LandReportedMapper;
import com.ruoyi.system.model.LandReported;
import com.ruoyi.system.service.LandReportedService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * 已办证土地 服务实现类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Service
public class LandReportedServiceImpl extends ServiceImpl<LandReportedMapper, LandReported> implements LandReportedService {

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/LandReservedServiceImpl.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.system.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.system.mapper.LandReservedMapper;
import com.ruoyi.system.model.LandReserved;
import com.ruoyi.system.service.LandReservedService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * 收储土地 服务实现类
 * </p>
 *
 * @author WuGuanFengYue
 * @since 2025-10-17
 */
@Service
public class LandReservedServiceImpl extends ServiceImpl<LandReservedMapper, LandReserved> implements LandReservedService {

}

 ruoyi-system/src/main/resources/mapper/system/DrDisplacementHouseMapper.xml

New file
@@ -0,0 +1,18 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.system.mapper.DrDisplacementHouseMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.system.model.DrDisplacementHouse">
        <id column="id" property="id" />
        <result column="displacement_id" property="displacementId" />
        <result column="construction_type" property="constructionType" />
        <result column="area" property="area" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, displacement_id, construction_type, area
    </sql>

</mapper>

 ruoyi-system/src/main/resources/mapper/system/DrDisplacementMapper.xml

New file
@@ -0,0 +1,40 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.system.mapper.DrDisplacementMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.system.model.DrDisplacement">
        <id column="id" property="id" />
        <result column="name" property="name" />
        <result column="phone" property="phone" />
        <result column="community_id" property="communityId" />
        <result column="community_name" property="communityName" />
        <result column="id_card" property="idCard" />
        <result column="address" property="address" />
        <result column="total_area" property="totalArea" />
        <result column="is_settlement" property="isSettlement" />
        <result column="house_type" property="houseType" />
        <result column="resettlement_mode" property="resettlementMode" />
        <result column="house_compensation" property="houseCompensation" />
        <result column="facility_compensation" property="facilityCompensation" />
        <result column="other_compensation" property="otherCompensation" />
        <result column="transition_allowance" property="transitionAllowance" />
        <result column="moving_fee" property="movingFee" />
        <result column="total_compensation" property="totalCompensation" />
        <result column="agreement_date" property="agreementDate" />
        <result column="settlement_community" property="settlementCommunity" />
        <result column="person_count" property="personCount" />
        <result column="attachment_urls" property="attachmentUrls" />
        <result column="create_time" property="createTime" />
        <result column="create_by" property="createBy" />
        <result column="update_time" property="updateTime" />
        <result column="update_by" property="updateBy" />
        <result column="disabled" property="disabled" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, name, phone, community_id, community_name, id_card, address, total_area, is_settlement, house_type, resettlement_mode, house_compensation, facility_compensation, other_compensation, transition_allowance, moving_fee, total_compensation, agreement_date, settlement_community, person_count, attachment_urls, create_time, create_by, update_time, update_by, disabled
    </sql>

</mapper>

 ruoyi-system/src/main/resources/mapper/system/DrDisplacementReturnHouseMapper.xml

New file
@@ -0,0 +1,19 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.system.mapper.DrDisplacementReturnHouseMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.system.model.DrDisplacementReturnHouse">
        <id column="id" property="id" />
        <result column="displacement_id" property="displacementId" />
        <result column="return_type" property="returnType" />
        <result column="area" property="area" />
        <result column="quantity" property="quantity" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, displacement_id, return_type, area, quantity
    </sql>

</mapper>

 ruoyi-system/src/main/resources/mapper/system/DrResettlementMapper.xml

New file
@@ -0,0 +1,31 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.system.mapper.DrResettlementMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.system.model.DrResettlement">
        <id column="id" property="id" />
        <result column="displacement_id" property="displacementId" />
        <result column="community_id" property="communityId" />
        <result column="displacement_agreement_url" property="displacementAgreementUrl" />
        <result column="settlement_list_url" property="settlementListUrl" />
        <result column="payment_receipt_url" property="paymentReceiptUrl" />
        <result column="id_card_url" property="idCardUrl" />
        <result column="marriage_certificate_url" property="marriageCertificateUrl" />
        <result column="household_register_url" property="householdRegisterUrl" />
        <result column="old_property_certificate_url" property="oldPropertyCertificateUrl" />
        <result column="land_certificate_url" property="landCertificateUrl" />
        <result column="other_documents_url" property="otherDocumentsUrl" />
        <result column="create_time" property="createTime" />
        <result column="create_by" property="createBy" />
        <result column="update_time" property="updateTime" />
        <result column="update_by" property="updateBy" />
        <result column="disabled" property="disabled" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, displacement_id, community_id, displacement_agreement_url, settlement_list_url, payment_receipt_url, id_card_url, marriage_certificate_url, household_register_url, old_property_certificate_url, land_certificate_url, other_documents_url, create_time, create_by, update_time, update_by, disabled
    </sql>

</mapper>

 ruoyi-system/src/main/resources/mapper/system/LandAcquiringMapper.xml

New file
@@ -0,0 +1,31 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.system.mapper.LandAcquiringMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.system.model.LandAcquiring">
        <id column="id" property="id" />
        <result column="land_name" property="landName" />
        <result column="street_name" property="streetName" />
        <result column="street_id" property="streetId" />
        <result column="area" property="area" />
        <result column="type" property="type" />
        <result column="status" property="status" />
        <result column="mortgage_bank" property="mortgageBank" />
        <result column="mortgage_time" property="mortgageTime" />
        <result column="mortgage_amount" property="mortgageAmount" />
        <result column="remark" property="remark" />
        <result column="is_sell" property="isSell" />
        <result column="create_time" property="createTime" />
        <result column="create_by" property="createBy" />
        <result column="update_time" property="updateTime" />
        <result column="update_by" property="updateBy" />
        <result column="disabled" property="disabled" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, land_name, street_name, street_id, area, type, status, mortgage_bank, mortgage_time, mortgage_amount, remark, is_sell, create_time, create_by, update_time, update_by, disabled
    </sql>

</mapper>

 ruoyi-system/src/main/resources/mapper/system/LandCertifiedMapper.xml

New file
@@ -0,0 +1,37 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.system.mapper.LandCertifiedMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.system.model.LandCertified">
        <id column="id" property="id" />
        <result column="land_name" property="landName" />
        <result column="street_name" property="streetName" />
        <result column="street_id" property="streetId" />
        <result column="address" property="address" />
        <result column="area" property="area" />
        <result column="type" property="type" />
        <result column="status" property="status" />
        <result column="owner" property="owner" />
        <result column="certificate_number" property="certificateNumber" />
        <result column="certificate_time" property="certificateTime" />
        <result column="terminal_date" property="terminalDate" />
        <result column="mortgage_bank" property="mortgageBank" />
        <result column="mortgage_time" property="mortgageTime" />
        <result column="mortgage_amount" property="mortgageAmount" />
        <result column="remark" property="remark" />
        <result column="is_sell" property="isSell" />
        <result column="attachment_urls" property="attachmentUrls" />
        <result column="create_time" property="createTime" />
        <result column="create_by" property="createBy" />
        <result column="update_time" property="updateTime" />
        <result column="update_by" property="updateBy" />
        <result column="disabled" property="disabled" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, land_name, street_name, street_id, address, area, type, status, owner, certificate_number, certificate_time, terminal_date, mortgage_bank, mortgage_time, mortgage_amount, remark, is_sell, attachment_urls, create_time, create_by, update_time, update_by, disabled
    </sql>

</mapper>

 ruoyi-system/src/main/resources/mapper/system/LandReportedMapper.xml

New file
@@ -0,0 +1,33 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.system.mapper.LandReportedMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.system.model.LandReported">
        <id column="id" property="id" />
        <result column="land_name" property="landName" />
        <result column="street_name" property="streetName" />
        <result column="street_id" property="streetId" />
        <result column="address" property="address" />
        <result column="area" property="area" />
        <result column="type" property="type" />
        <result column="status" property="status" />
        <result column="mortgage_bank" property="mortgageBank" />
        <result column="mortgage_time" property="mortgageTime" />
        <result column="mortgage_amount" property="mortgageAmount" />
        <result column="certificate_number" property="certificateNumber" />
        <result column="remark" property="remark" />
        <result column="is_sell" property="isSell" />
        <result column="create_time" property="createTime" />
        <result column="create_by" property="createBy" />
        <result column="update_time" property="updateTime" />
        <result column="update_by" property="updateBy" />
        <result column="disabled" property="disabled" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, land_name, street_name, street_id, address, area, type, status, mortgage_bank, mortgage_time, mortgage_amount, certificate_number, remark, is_sell, create_time, create_by, update_time, update_by, disabled
    </sql>

</mapper>

 ruoyi-system/src/main/resources/mapper/system/LandReservedMapper.xml

New file
@@ -0,0 +1,38 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.system.mapper.LandReservedMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.system.model.LandReserved">
        <id column="id" property="id" />
        <result column="land_name" property="landName" />
        <result column="street_name" property="streetName" />
        <result column="street_id" property="streetId" />
        <result column="address" property="address" />
        <result column="type" property="type" />
        <result column="area" property="area" />
        <result column="is_write_off" property="isWriteOff" />
        <result column="orignal_owner" property="orignalOwner" />
        <result column="current_institution" property="currentInstitution" />
        <result column="remark" property="remark" />
        <result column="demolition_situation" property="demolitionSituation" />
        <result column="reserved_money_amount" property="reservedMoneyAmount" />
        <result column="reserved_time" property="reservedTime" />
        <result column="payment_situation" property="paymentSituation" />
        <result column="mortgage_bank" property="mortgageBank" />
        <result column="mortgage_time" property="mortgageTime" />
        <result column="mortgage_amount" property="mortgageAmount" />
        <result column="is_sell" property="isSell" />
        <result column="create_time" property="createTime" />
        <result column="create_by" property="createBy" />
        <result column="update_time" property="updateTime" />
        <result column="update_by" property="updateBy" />
        <result column="disabled" property="disabled" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, land_name, street_name, street_id, address, type, area, is_write_off, orignal_owner, current_institution, remark, demolition_situation, reserved_money_amount, reserved_time, payment_situation, mortgage_bank, mortgage_time, mortgage_amount, is_sell, create_time, create_by, update_time, update_by, disabled
    </sql>

</mapper>