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 com.doumee.dao.business.vo.ApproveDataVO; 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 org.springframework.format.annotation.DateTimeFormat; import java.util.Date; import java.util.List; /** * 访客申请信息表 * @author 江蹄蹄 * @date 2023/11/30 15:33 */ @Data @ApiModel("访客申请信息表") @TableName("`visits`") public class Visits extends LoginUserModel { @TableId(type = IdType.AUTO) @ApiModelProperty(value = "主键", example = "1") @ExcelColumn(name="主键") private Integer id; @ApiModelProperty(value = "创建人编码", example = "1") @ExcelColumn(name="创建人编码") private Integer creator; @ApiModelProperty(value = "创建时间") @ExcelColumn(name="创建时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date createDate; @ApiModelProperty(value = "更新人编码", example = "1") @ExcelColumn(name="更新人编码") private Integer editor; @ApiModelProperty(value = "更新时间") @ExcelColumn(name="更新时间") private Date editDate; @ApiModelProperty(value = "是否删除0否 1是", example = "1") @ExcelColumn(name="是否删除0否 1是") private Integer isdeleted; @ApiModelProperty(value = "备注") @ExcelColumn(name="备注") private String remark; @ApiModelProperty(value = "申请人编码(关联member表)", example = "1") @ExcelColumn(name="申请人编码(关联member表)") private Integer memberId; @ApiModelProperty(value = "所属组织编码(关联company表)", example = "1") @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访客报备", example = "1") @ExcelColumn(name="类型 0非施工人员访客申请 1施工人员访客申请 2访客报备") private Integer type; @ApiModelProperty(value = "访客名称") @ExcelColumn(name="访客名称") private String name; @ApiModelProperty(value = "访客年龄") @ExcelColumn(name="访客年龄") private Date birthday; @ApiModelProperty(value = "手机号") @ExcelColumn(name="手机号") private String phone; @ApiModelProperty(value = "企业名称") @ExcelColumn(name="企业名称") private String companyName; @ApiModelProperty(value = "身份证号") @ExcelColumn(name="身份证号") private String idcardNo; @ApiModelProperty(value = "工号") @ExcelColumn(name="工号") private String code; @ApiModelProperty(value = "班次 0白班 1夜班", example = "1") @ExcelColumn(name="班次 0白班 1夜班") private Integer classes; @ApiModelProperty(value = "随程人员数", example = "1") @ExcelColumn(name="随程人员数") private Integer memberNum; @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") @ApiModelProperty(value = "门禁有效期开始") @ExcelColumn(name="门禁有效期开始") private Date starttime; @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") @ApiModelProperty(value = "门禁有效期截止") @ExcelColumn(name="门禁有效期截止") private Date endtime; @ApiModelProperty(value = "进厂时间") @ExcelColumn(name="进厂时间") private Date inDate; @ApiModelProperty(value = "离场时间") @ExcelColumn(name="离场时间") private Date outDate; @ApiModelProperty(value = "离场方式 0正常签离 1管理员手动签离") @ExcelColumn(name="离场方式 0正常签离 1管理员手动签离") private Integer outType; @ApiModelProperty(value = "强制签离管理员编码") @ExcelColumn(name="强制签离管理员编码") private Integer outUserId; @ApiModelProperty(value = "签离备注") @ExcelColumn(name="签离备注") private String outInfo; @ApiModelProperty(value = "来访事由") @ExcelColumn(name="来访事由") private String reason; @ApiModelProperty(value = "是否需要选择门禁 0不需要 1需要", example = "1") @ExcelColumn(name="是否需要选择门禁 0不需要 1需要") private Integer doorSelect; @ApiModelProperty(value = "门禁编码,多个用英文逗号隔开") @ExcelColumn(name="门禁编码,多个用英文逗号隔开") private String doors; @ApiModelProperty(value = "接待人员", example = "1") @ExcelColumn(name="接待人员") private Integer receptMemberId; @ApiModelProperty(value = "审核状态 0待审核 1审批中 2审核通过 3审核不通过 4取消 5下发成功 6下发失败 7拜访中 8已签离 9已失效", example = "1") @ExcelColumn(name="审核状态 0待审核 1审批中 2审核通过 3审核不通过 4取消 5下发成功 6下发失败 7拜访中 8已签离 9已失效") private Integer status; @ApiModelProperty(value = "初审人编码", example = "1") @ExcelColumn(name="初审人编码") private Integer checkorId; @ApiModelProperty(value = "初审时间") @ExcelColumn(name="初审时间") private Date checkDate; @ApiModelProperty(value = "初审备注") @ExcelColumn(name="初审备注") private String checkInfo; @ApiModelProperty(value = "终审人编码", example = "1") @ExcelColumn(name="终审人编码") private Integer endCheckorId; @ApiModelProperty(value = "终审时间") @ExcelColumn(name="终审时间") private Date endCheckDate; @ApiModelProperty(value = "终审备注") @ExcelColumn(name="终审备注") private String endCheckInfo; @ApiModelProperty(value = "证件显示信息") @ExcelColumn(name="证件显示信息") private String idcardDecode; @ApiModelProperty(value = "证件类型 0身份证 1港澳证件 2护照", example = "1") @ExcelColumn(name="证件类型 0身份证 1港澳证件 2护照") private Integer idcardType; @ApiModelProperty(value = "性别 1男 2女 ", example = "1") @ExcelColumn(name="性别 1男 2女") private Integer sex; @ApiModelProperty(value = "车牌号,多个用英文逗号隔开") @ExcelColumn(name="车牌号,多个用英文逗号隔开") private String carNos; @ApiModelProperty(value = "父级申请编码(自关联)", example = "1") @ExcelColumn(name="父级申请编码(自关联)") private Integer parentId; @ApiModelProperty(value = "答题记录编码(关联user_answer)", example = "1") @ExcelColumn(name="答题记录编码(关联user_answer)") private Integer userAnswerId; @ApiModelProperty(value = "海康标识") @ExcelColumn(name="海康标识") private String hkId; @ApiModelProperty(value = "openid") @ExcelColumn(name="openid") private String openid; @ApiModelProperty(value = "访客二维码") @ExcelColumn(name="访客二维码") private String qrcode; @ApiModelProperty(value = "访客预约方式:0登记预约 1免登记预约", example = "1") @ExcelColumn(name="访客预约方式:0登记预约 1免登记预约") private Integer visitType; @ApiModelProperty(value = "海康同步状态 0未同步 1已同步 ", example = "1") @ExcelColumn(name="海康同步状态 0未同步 1已同步") private Integer hkStatus; @ApiModelProperty(value = "海康最近同步时间") @ExcelColumn(name="海康最近同步时间") private Date hkDate; @ApiModelProperty(value = "ERP申请记录编码") @ExcelColumn(name="ERP申请记录编码") private String erpId; @ApiModelProperty(value = "是否发送超时通知 0:未发送;1=已发送") private Integer sendTimeOutNotice; @ApiModelProperty(value = "统计数量 ") @TableField(exist = false) private int num ; @ApiModelProperty(value = "创建人编码(关联member表)", example = "1") @ExcelColumn(name="创建人编码(关联member表)") private Integer createMemberId; @ApiModelProperty(value = "来源类型:0=本系统;1=ERP", example = "1") private Integer sourceType; @ApiModelProperty(value = "施工事由") @ExcelColumn(name="施工事由") private String constructionReason; @ApiModelProperty(value = "普通访客申请随访人员") @TableField(exist = false) private List withUserList; // @ApiModelProperty(value = "班次") // private String memberClasses; @ApiModelProperty(value = "类型 0劳务访客 1普通访客 2内部人员", example = "1") @TableField(exist = false) private Integer memberType; @ApiModelProperty(value = "劳务访客申请随访人员") @TableField(exist = false) private List lwWithUserList; @ApiModelProperty(value = "图片前缀") @TableField(exist = false) private String prefixUrl; @ApiModelProperty(value = "被访人员姓名", example = "1") @ExcelColumn(name="被访人员姓名") @TableField(exist = false) private String receptMemberName; @ApiModelProperty(value = "被访人员海康编码", example = "1") @ExcelColumn(name="被访人员姓名") @TableField(exist = false) private String receptMemberHkId; @ApiModelProperty(value = "被访人员部门", example = "1") @ExcelColumn(name="被访人员部门") @TableField(exist = false) private String receptMemberDepartment; @ApiModelProperty(value = "门禁组集合", example = "1") @ExcelColumn(name="门禁组集合") @TableField(exist = false) private List deviceRoleList; @ApiModelProperty(value = "随访人员列表", example = "1") @ExcelColumn(name="随访人员列表") @TableField(exist = false) private List visitsList; @ApiModelProperty(value = "超时时长", example = "1") @TableField(exist = false) private Integer timeOut; @ApiModelProperty(value = "随访车辆数量", example = "1") @TableField(exist = false) private Integer carNum; @ApiModelProperty(value = "超时状态0未超时,1已超时,2即将超时", example = "1") @TableField(exist = false) private Integer outStatus; @ApiModelProperty(value = "离场状态;0=未离场", example = "1",hidden = true) @TableField(exist = false) private Integer levelStatus; @ApiModelProperty(value = "业务审核状态 0待审核 1审批中 2审核通过 3审核不通过 4取消 ", example = "1") @TableField(exist = false) private Integer businessStatus; @ApiModelProperty(value = "创建人姓名", example = "1") @TableField(exist = false) private String createMemberName; @ApiModelProperty(value = "审批信息数据") @TableField(exist = false) private ApproveDataVO approveDateVO; }