snd-escloud/src/main/java/platform/modules/carrier/dto/ExcelBuildingImport.java

package platform.modules.carrier.dto;

import lombok.Data;
import platform.common.annotation.ExcelField;
import platform.common.base.model.BaseEntity;

import javax.persistence.Table;
import javax.persistence.Transient;

/**
 * @author kevin
 * @since 2019/5/7 10:58 AM
 */
@Data
//@Table(name = "ic_building")
public class ExcelBuildingImport extends BaseEntity {

    private String no;                              //编号

//    private Integer park_id;                        //园区id

    @ExcelField(title="厂房属性（电子/机械/其他）", align=2, sort=5)
    private String carrier_attriute;

    private Integer carrier_nature;                 //载体性质

    private Integer carrier_structure;

    private String build_num;                       //楼栋编号（名称）

    private Integer build_use;

    @ExcelField(title="楼栋名称", align=2, sort=3)
    private String build_name;

    @ExcelField(title="建筑面积（㎡）", align=2, sort=14)
    private Double area;

    @ExcelField(title = "剩余租赁面积（㎡）", align=2, sort=17)

    private Double remain_area;
    @ExcelField(title="长（m）", align=2, sort=10)
    private Double length;

    @ExcelField(title="宽（m）", align=2, sort=11)
    private Double width;

    @ExcelField(title="高（m）", align=2, sort=12)
    private Double height;

    @ExcelField(title="层高（m）", align=2, sort=13)
    private Double floor_height;

    private Boolean is_use;                         //是否可用0否1是

    private Double pay;                             //租金

    @ExcelField(title="总层数（层）", align=2, sort=9)
    private Integer floor_count;

    @ExcelField(title="跨度(柱间距)（m）", align=2, sort=21)
    private Double intercolumniation;

    @ExcelField(title="货梯承重（kg）", align=2, sort=24)
    private Double lift_load_bearing;

    @ExcelField(title="卸货平台数（个）", align=2, sort=23)
    private Integer landing_platform_count;

    private Integer spqn;

    private String land_block_number;               //国家土地编号

    private String longitude;                       //经度

    private String latitude;                        //纬度

    private Integer status;                         //状态

    private String capacity;                        //荷载量

    @ExcelField(title = "厂房分配的电力容量（KVA）", align=2, sort=25)
    private String kva_capacity;                    //电力容量

    private Integer fire_rating;

    private Integer driving_type;

    private Integer driving_spqn;

    @ExcelField(title = "行车吨位（1吨/2吨/5吨/10吨/20吨/30吨）", align=2, sort=20)
    private Integer driving_load;

    @ExcelField(title = "厂房年限", align=2, sort=7)
    private String factory_years;

    @ExcelField(title = "厂房建设时间", align=2, sort=8)
    private String build_time;

    @ExcelField(title = "已租赁面积（㎡）", align=2, sort=16)
    private Double rent_area;

    private String remark;

    private String reason;

    private Integer  is_empty;


    @ExcelField(title="楼栋结构（砖木/框架/砖混/钢筋混凝土/钢机构/其他结构）", align=2, sort=6)
    @Transient
    private String carrier_atructure_str;

    @ExcelField(title="楼栋用途（工业生产/仓库/办公）", align=2, sort=4)
    @Transient
    private String build_use_str;

    @ExcelField(title="跨数（单连跨/双连跨/三连跨)", align=2, sort=22)
    @Transient
    private String spqn_str;

    @ExcelField(title = "消防等级（甲乙丙丁）", align=2, sort=26)
    @Transient
    private String fire_rating_str;

    @ExcelField(title = "行车类型（单梁/双梁/门式起重机/电动单梁/电动双梁/防爆/冶金式）", align=2, sort=18)
    @Transient
    private String driving_type_str;

    @ExcelField(title = "行车跨度（双跨/16米跨/32米跨）", align=2, sort=19)
    @Transient
    private String driving_spqn_str;

    @ExcelField(title = "是否空置（无空置/部分空置/全空置）", align=2, sort=15)
    private String  is_empty_str;

    @ExcelField(title="序号", align=2, sort=1)
    @Transient
    private Integer serial_number;

    @ExcelField(title="楼栋/厂房编号", align=2, sort=2)
    @Transient
    private String build_no;
}