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 = "车辆类型 0内部车辆 1相关方车辆 2访客车辆 3内运物流车 4外协车辆 5市公司卸货车 ")
|
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 = 1,width = 12)
|
@TableField(exist = false)
|
public String excelCompanyName;
|
|
|
@ApiModelProperty(value = "人数")
|
@TableField(exist = false)
|
private Integer num;
|
|
|
@ApiModelProperty(value = "查询人员类型")
|
@TableField(exist = false)
|
private Integer queryUserType;
|
|
|
|
}
|
