| | |
|---|
| | | |
|---|
| | | @TableId(type = IdType.AUTO) |
|---|
| | | @ApiModelProperty(value = "主键") |
|---|
| | | @ExcelColumn(name="主键") |
|---|
| | | private Integer id; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "创建人编码") |
|---|
| | | @ExcelColumn(name="创建人编码") |
|---|
| | | private Integer creator; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "创建时间") |
|---|
| | | @ExcelColumn(name="创建时间") |
|---|
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
|---|
| | | private Date createDate; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "更新人编码") |
|---|
| | | @ExcelColumn(name="更新人编码") |
|---|
| | | private Integer editor; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "更新时间") |
|---|
| | | @ExcelColumn(name="更新时间") |
|---|
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
|---|
| | | private Date editDate; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "是否删除0否 1是") |
|---|
| | | @ExcelColumn(name="是否删除0否 1是") |
|---|
| | | private Integer isdeleted; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "备注") |
|---|
| | | @ExcelColumn(name="备注") |
|---|
| | | private String remark; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "所属组织编码(关联company表)") |
|---|
| | | @ExcelColumn(name="所属组织编码(关联company表)") |
|---|
| | | private Integer companyId; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "人脸照片") |
|---|
| | | @ExcelColumn(name="人脸照片") |
|---|
| | | private String faceImg; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "健康码") |
|---|
| | | @ExcelColumn(name="健康码") |
|---|
| | | private String imgurl; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "类型 0劳务访客 1普通访客 2内部员工") |
|---|
| | | @ExcelColumn(name="类型 0劳务访客 1普通访客 2内部员工") |
|---|
| | | @ApiModelProperty(value = "类型 0劳务访客 1普通访客 2内部员工 3车辆信息") |
|---|
| | | @ExcelColumn(name="人员类型" ,index = 2, valueMapping="0=劳务访客;1=普通访客;2=内部员工;3=车辆信息;",width = 8) |
|---|
| | | private Integer type; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "访客名称") |
|---|
| | | @ExcelColumn(name="访客名称") |
|---|
| | | @ExcelColumn(name="姓名" ,index = 3,width = 6) |
|---|
| | | private String name; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "访客年龄") |
|---|
| | | @ExcelColumn(name="访客年龄") |
|---|
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
|---|
| | | private Date birthday; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "手机号") |
|---|
| | | @ExcelColumn(name="手机号") |
|---|
| | | @ExcelColumn(name="手机号" ,index = 4,width = 12) |
|---|
| | | private String phone; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "身份证号（MD4加密）") |
|---|
| | | @ExcelColumn(name="身份证号（MD4加密）") |
|---|
| | | private String idcardNo; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "证件显示信息") |
|---|
| | | @ExcelColumn(name="证件显示信息") |
|---|
| | | @ExcelColumn(name="身份证号" ,index = 5,width = 12) |
|---|
| | | private String idcardDecode; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "工号") |
|---|
| | | @ExcelColumn(name="工号") |
|---|
| | | private String code; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "班次") |
|---|
| | | @ExcelColumn(name="班次") |
|---|
| | | private String classes; |
|---|
| | | private Integer classes; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "海康门禁名称") |
|---|
| | | @ExcelColumn(name="海康门禁名称") |
|---|
| | | @ExcelColumn(name="进厂门禁" ,index = 6,width = 12) |
|---|
| | | private String deviceName; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "海康门禁编码") |
|---|
| | | @ExcelColumn(name="海康门禁编码") |
|---|
| | | private String deviceIndex; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "入厂时间") |
|---|
| | | @ExcelColumn(name="入厂时间") |
|---|
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
|---|
| | | @ExcelColumn(name="进场时间" ,index = 7,width = 12,dateFormat = "yyyy-MM-dd HH:mm:ss") |
|---|
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
|---|
| | | private Date eventDate; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "访客ID(关联member)") |
|---|
| | | @ExcelColumn(name="访客ID(关联member)") |
|---|
| | | private Integer memberId; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "事件类型码") |
|---|
| | | @ExcelColumn(name="事件类型码") |
|---|
| | | private String eventCode; |
|---|
| | | |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "车牌号（type=3使用）") |
|---|
| | | private String carNo; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "公司组织") |
|---|
| | | @ExcelColumn(name="公司组织") |
|---|
| | | @TableField(exist = false) |
|---|
| | | public String companyName; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "访客组织名称") |
|---|
| | | @TableField(exist = false) |
|---|
| | | public String visitCompanyName; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "姓名/手机号") |
|---|
| | | @TableField(exist = false) |
|---|
| | | private String keyWords; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "开始时间") |
|---|
| | | @TableField(exist = false) |
|---|
| | | private Date startTime; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "结束时间") |
|---|
| | | @TableField(exist = false) |
|---|
| | | private Date endTime; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "人脸照片") |
|---|
| | | @TableField(exist = false) |
|---|
| | | private String faceImgFull; |
|---|
| | | |
|---|
| | | @ApiModelProperty(value = "导出公司名称",hidden = true) |
|---|
| | | @ExcelColumn(name="公司/组织" ,index = 1,width = 12) |
|---|
| | | @TableField(exist = false) |
|---|
| | | public String excelCompanyName; |
|---|
| | | |
|---|
| | | } |
|---|
