package com.doumee.dao.business.model; import com.baomidou.mybatisplus.annotation.TableField; import com.doumee.core.annotation.excel.ExcelColumn; import com.doumee.service.business.third.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; //用户类型 0访客 1内部人员 2相关方人员 3货运司机 @ApiModelProperty(value = "类型 0劳务访客 1普通访客 2内部员工 3车辆信息 4相关方人员 5货运司机 ") // @ExcelColumn(name="人员类型" ,index = 5, valueMapping="0=劳务访客;1=普通访客;2=内部员工;3=车辆信息;4=相关方人员;5=货运司机",width = 8) private Integer type; @ApiModelProperty(value = " 类型 0相关方组织 1内部人员 2访客") @TableField(exist = false) // @ExcelColumn(name="人员类型" ,index = 5, valueMapping="0=劳务访客;1=普通访客;2=内部员工;3=车辆信息;",width = 8) private String typeName; @ApiModelProperty(value = "访客名称") @ExcelColumn(name="姓名" ,index = 1,width = 6) private String name; @ApiModelProperty(value = "访客年龄") private Date birthday; @ApiModelProperty(value = "手机号") @ExcelColumn(name="手机号" ,index = 2,width = 12) private String phone; @ApiModelProperty(value = "身份证号(MD4加密)") private String idcardNo; @ApiModelProperty(value = "证件显示信息") @ExcelColumn(name="身份证号" ,index = 3,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 = "车辆类型 0内部车辆 1相关方车辆 2访客车辆 3内运物流车 4外协车辆 5市公司卸货车 6未登记车辆 ") private Integer carType ; @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 = "类型 0访客 1内部人员") @TableField(exist = false) private Integer memberType; @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 = 4,width = 12) @TableField(exist = false) public String excelCompanyName; @ApiModelProperty(value = "人数") @TableField(exist = false) private Integer num; @ApiModelProperty(value = "查询人员类型") @TableField(exist = false) private Integer queryUserType; @ApiModelProperty(value = "关联分类编码(关联category)", example = "1") @ExcelColumn(name="关联分类编码(关联category)") private Integer categoryId; @ApiModelProperty(value = "关联分类名称") private String categoryName; @ApiModelProperty(value = "关联父级分类编码(关联category)", example = "1") private Integer categoryParentId; @ApiModelProperty(value = "关联分类名称") @ExcelColumn(name="关联分类名称") private String categoryParentName; @ApiModelProperty(value = "0=访客车辆;1=外协运输车辆;2=市公司卸货车辆;3=加工烟卸货车辆;4=安泰物流公务用车;5=安泰物流货运车辆;6=未知车辆 ") @ExcelColumn(name="车辆分类" ,index = 8,width = 16,valueMapping ="0=访客车辆;1=外协运输车辆;2=市公司卸货车辆;3=加工烟卸货车辆;4=安泰物流公务用车;5=安泰物流货运车辆;6=未知车辆;" ) @TableField(exist = false) private Integer bizType; }