package com.doumee.dao.business.model; import com.baomidou.mybatisplus.annotation.TableField; import com.doumee.core.annotation.excel.ExcelColumn; import com.doumee.core.model.LoginUserModel; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import com.fasterxml.jackson.annotation.JsonFormat; import java.util.Date; /** * 在厂人员信息 表(滞留) * @author 江蹄蹄 * @date 2023/11/30 15:33 */ @Data @ApiModel("在厂人员信息 表(滞留)") @TableName("`retention`") public class Retention extends LoginUserModel { @TableId(type = IdType.AUTO) @ApiModelProperty(value = "主键") private Integer id; @ApiModelProperty(value = "创建人编码") private Integer creator; @ApiModelProperty(value = "创建时间") private Date createDate; @ApiModelProperty(value = "更新人编码") private Integer editor; @ApiModelProperty(value = "更新时间") private Date editDate; @ApiModelProperty(value = "是否删除0否 1是") private Integer isdeleted; @ApiModelProperty(value = "备注") private String remark; @ApiModelProperty(value = "所属组织编码(关联company表)") private Integer companyId; @ApiModelProperty(value = "人脸照片") private String faceImg; @ApiModelProperty(value = "健康码") private String imgurl; @ApiModelProperty(value = "类型 0劳务访客 1普通访客 2内部员工 3车辆信息") @ExcelColumn(name="人员类型" ,index = 2, valueMapping="0=劳务访客;1=普通访客;2=内部员工;3=车辆信息;",width = 8) private Integer type; @ApiModelProperty(value = "访客名称") @ExcelColumn(name="姓名" ,index = 3,width = 6) private String name; @ApiModelProperty(value = "访客年龄") private Date birthday; @ApiModelProperty(value = "手机号") @ExcelColumn(name="手机号" ,index = 4,width = 12) private String phone; @ApiModelProperty(value = "身份证号(MD4加密)") private String idcardNo; @ApiModelProperty(value = "证件显示信息") @ExcelColumn(name="身份证号" ,index = 5,width = 12) private String idcardDecode; @ApiModelProperty(value = "工号") private String code; @ApiModelProperty(value = "班次") private Integer classes; @ApiModelProperty(value = "海康门禁名称") @ExcelColumn(name="进厂门禁" ,index = 6,width = 12) private String deviceName; @ApiModelProperty(value = "海康门禁编码") private String deviceIndex; @ApiModelProperty(value = "入厂时间") @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)") private Integer memberId; @ApiModelProperty(value = "访客1门禁事件2车辆事件") private String accessType; @ApiModelProperty(value = "事件类型码") private String eventCode; @ApiModelProperty(value = "车牌号(type=3使用)") private String carNo; @ApiModelProperty(value = "公司组织") @TableField(exist = false) public String companyName; @ApiModelProperty(value = "访客组织名称") @TableField(exist = false) public String visitCompanyName; @ApiModelProperty(value = "姓名/手机号") @TableField(exist = false) private String keyWords; @ApiModelProperty(value = "类型 0劳务公司 1内部组织") @TableField(exist = false) private Integer companyType; @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; @ApiModelProperty(value = "人数") @TableField(exist = false) private Integer num; }