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; import java.util.List; /** * 人员信息表 * @author 江蹄蹄 * @date 2023/11/30 15:33 */ @Data @ApiModel("人员信息表") @TableName("`member`") public class Member extends LoginUserModel { @TableId(type = IdType.AUTO) @ApiModelProperty(value = "主键", example = "1") private Integer id; @ApiModelProperty(value = "创建人编码", example = "1") private Integer creator; @ApiModelProperty(value = "创建时间") private Date createDate; @ApiModelProperty(value = "更新人编码", example = "1") private Integer editor; @ApiModelProperty(value = "更新时间") private Date editDate; @ApiModelProperty(value = "是否删除0否 1是", example = "1") private Integer isdeleted; @ApiModelProperty(value = "备注") private String remark; @ApiModelProperty(value = "所属组织编码(关联company表)", example = "1") private Integer companyId; @ApiModelProperty(value = "人脸照片") private String faceImg; @ApiModelProperty(value = "人脸存储服务器标识(海康)") private String faceServerIndexCode; @ApiModelProperty(value = "人脸编码(海康)") private String faceId; @ApiModelProperty(value = "人脸同步状态(海康) 0未同步 1已同步 2同步失败 3不合格") private Integer faceStatus; @ApiModelProperty(value = "人脸同步信息(海康)") private String faceInfo; @ApiModelProperty(value = "健康码") private String imgurl; @ApiModelProperty(value = "类型 0司机人员 1普通访客 2内部人员", example = "1") private Integer type; @ApiModelProperty(value = "访客名称/内部人员") @ExcelColumn(name="姓名",index = 1,width = 8) private String name; @ApiModelProperty(value = "是否有人脸 ", example = "1") @TableField(exist = false) @ExcelColumn(name="是否有人脸",index = 2,width = 6,valueMapping = "0=无;1=有;") private Integer hasFace; @ApiModelProperty(value = "手机号") @ExcelColumn(name="手机号",index =3 ,width = 9) private String phone; @ApiModelProperty(value = "证件显示信息") @ExcelColumn(name="身份证号",index = 4,width = 12) private String idcardDecode; @ApiModelProperty(value = "性别 1男 2女 ", example = "1") @ExcelColumn(name="性别",index = 5,width = 5,valueMapping = "0=未知;1=男;2=女;") private Integer sex; @ApiModelProperty(value = "组织名称") @ExcelColumn(name="所属部门",index = 6,width = 12) @TableField(exist = false) private String companyName; @ApiModelProperty(value = "岗位名称") @ExcelColumn(name="岗位名称",index = 7,width = 8) @TableField(exist = false) private String positionName; @ApiModelProperty(value = "是否党员 0否 1是", example = "1") // @ExcelColumn(name="是否党员",index = 8,width = 12,valueMapping = "1=党员;2=非党员;") private Integer isDangyuan; @ApiModelProperty(value = "入职如期") @JsonFormat(pattern = "yyyy-MM-dd") @ExcelColumn(name="入职日期",index =9,width = 10, dateFormat = "yyyy-MM-dd") private Date jobDate; @ApiModelProperty(value = "姓名拼音首字母") private String pinyin; @ApiModelProperty(value = "培训结束时间") @TableField(exist = false) @ExcelColumn(name="培训结束时间",index =10,width = 10, dateFormat = "yyyy-MM-dd") private Date trainEndTime; @ApiModelProperty(value = "组织类型 0劳务公司 1内部组织") @ExcelColumn(name="部门类型",index = 11,width = 8, valueMapping = "0=相关方组织;1=内部组织;") @TableField(exist = false) private Integer companyType; @ApiModelProperty(value = "在职状态 0在职 1离职", example = "1") @ExcelColumn(name="在职状态",index = 12,width = 8, valueMapping = "0=在职;1=离职;") private Integer workStatus; @ApiModelProperty(value = "是否可拜访人 0否 1是", example = "1") @ExcelColumn(name="是否可拜访人",index = 13,width = 8, valueMapping = "0=否;1=是;") private Integer canVisit; @ApiModelProperty(value = "海康同步状态 0未同步 1已同步 2同步失败 3不符合下发条件 4等待删除权限 ", example = "1") @ExcelColumn(name="海康同步状态",index = 14,width = 8, valueMapping = "0=未同步;1=已同步;2=同步失败;3=不符合下发条件;4=等待删除权限") private Integer hkStatus; @ApiModelProperty(value = "海康授权状态 0未授权 1已授权 ", example = "1") @ExcelColumn(name="海康授权状态",index = 15,width = 8, valueMapping = "0=未授权;1=已授权;") private Integer authStatus; @ApiModelProperty(value = "门禁有效期", example = "1") @TableField(exist = false) @ExcelColumn(name="门禁有效期",index = 16,width = 15 ) private String roleTimeInfo; @ApiModelProperty(value = "持卡数量") @ExcelColumn(name="持卡数量",index = 17,width = 5) @TableField(exist = false) private int memberCardCount; @ExcelColumn(name="工号",index = 18,width = 8) private String code; @ApiModelProperty(value = "访客年龄") private Date birthday; @ApiModelProperty(value = "身份证号(MD4加密)") private String idcardNo; @ApiModelProperty(value = "修改的身份证号 ") @TableField(exist = false) private String idcardNoNew; @ApiModelProperty(value = "证件类型 0身份证 1港澳证件 2护照", example = "1") private Integer idcardType; @ApiModelProperty(value = "是否是物流司机 0不是 1是", example = "1") private Integer isDriver; @ApiModelProperty(value = "班次 0白班 1夜班") private Integer classes; @ApiModelProperty(value = "状态 0正常 1禁用 2拉黑/冻结", example = "1") private Integer status; @ApiModelProperty(value = "添加人编码(自关联)", example = "1") private Integer parentId; @ApiModelProperty(value = "微信openid") private String openid; @ApiModelProperty(value = "飞书标识") private String fsId; @ApiModelProperty(value = "飞书同步状态 0未同步 1已同步", example = "1") private Integer fsStatus; @ApiModelProperty(value = "飞书最近同步时间") private Date fsDate; @ApiModelProperty(value = "海康标识", example = "1") private String hkId; @ApiModelProperty(value = "海康最近同步时间") private Date hkDate; @ApiModelProperty(value = "岗位编码,关联positionbiao", example = "1") private Integer positionId; @ApiModelProperty(value = "ERP标识", example = "1") private String erpId; @ApiModelProperty(value = "ERP同步时间") private Date erpDate; @ApiModelProperty(value = "ERP同步状态 0未同步 1已同步", example = "1") private Integer erpStatus; @ApiModelProperty(value = "钉钉标识", example = "1") private String ddId; @ApiModelProperty(value = "钉钉同步时间") private Date ddDate; @ApiModelProperty(value = "钉钉P同步状态 0未同步 1已同步", example = "1") private Integer ddStatus; @ApiModelProperty(value = "登陆密码") private String passward; @ApiModelProperty(value = "是否高级审批人 0否 1是", example = "1") private Integer highCheckor; @ApiModelProperty(value = "门禁角色编码(关联device_role),多个英文逗号隔开", example = "1") private String roleId; @ApiModelProperty(value = "门禁角色授权时间") private Date roleDate; @ApiModelProperty(value = "ERP组织编码") private String erpOrgId; @ApiModelProperty(value = "访客公司名称") private String visitCompanyName; @ApiModelProperty(value = "最后操作人") @TableField(exist = false) private String editorName; @ApiModelProperty(value = "组织类型 0劳务公司 1内部组织 多个以,分割") @TableField(exist = false) private String companyTypes; @ApiModelProperty(value = "组织编码路径") @TableField(exist = false) private String companyPath; @ApiModelProperty(value = "负责人编码(关联member)") @TableField(exist = false) private Integer headId; @ApiModelProperty(value = "组织路径") @TableField(exist = false) private String companyNamePath; @ApiModelProperty(value = "组织海康编码") @TableField(exist = false) private String hkOrgId; @ApiModelProperty(value = "角色编码查询") @TableField(exist = false) private String roleIdParam; @ApiModelProperty(value = "前缀地址") @TableField(exist = false) private String prefixUrl; @ApiModelProperty(value = "授权门禁组编码集合,【访客端】唯一标识",hidden = true ) @TableField(exist = false) private Integer[] roleIds; @ApiModelProperty(value = "人员编码集合,【访客端】唯一标识",hidden = true ) @TableField(exist = false) private List ids; @ApiModelProperty(value = "有效期类型 0长期有效 1自定义",hidden = true ) @TableField(exist = false) private Integer timeType; @ApiModelProperty(value = "姓名/手机号/工号") @TableField(exist = false) private String keyword; @ApiModelProperty(value = "是否有人脸:0=无;1=有;") @TableField(exist = false) private Integer isFace; @ApiModelProperty(value = "访问次数") @TableField(exist = false) private Integer visitTimes; @ApiModelProperty(value = "最后访问时间") private Date lastVisitDate; @ApiModelProperty(value = "门禁有效期开始") private Date startTime; @ApiModelProperty(value = "编码集合") @TableField(exist = false) private List idList; @ApiModelProperty(value = "门禁有效期结束", example = "1") private Date endTime; @ApiModelProperty(value = "人脸照片完整地址") @TableField(exist = false) private String faceImgFull; @ApiModelProperty(value = "人脸照片完整地址") @TableField(exist = false) private String imgurlFull; @ApiModelProperty(value = "是否主管 0否 1是", example = "1") @TableField(exist = false) private Integer headStatus; @ApiModelProperty(value = "门禁角色名称") @TableField(exist = false) private String roleName; @ApiModelProperty(value = "最后操作内容") @TableField(exist = false) private String optRemark; @ApiModelProperty(value = "system openid" , hidden = true) @TableField(exist = false) private String systemOpenid; @ApiModelProperty(value = "培训开始时间") @TableField(exist = false) private Date trainStartTime; @ApiModelProperty(value = "门禁组名称集合") @TableField(exist = false) private List roleNames; @ApiModelProperty(value = "是否查询固定人员:0=否;1=是" ) @TableField(exist = false) private Integer querySpecial; @ApiModelProperty(value = "是否查询钥匙柜校验人员:0=否;1=是" ) @TableField(exist = false) private Integer queryAuth; }