productDev/dmvisit.git

			@@ -1,5 +1,6 @@
			package com.doumee.dao.business.model;

			import com.baomidou.mybatisplus.annotation.TableField;
			import com.doumee.core.annotation.excel.ExcelColumn;
			import io.swagger.annotations.ApiModel;
			import io.swagger.annotations.ApiModelProperty;
			@@ -22,95 +23,141 @@

			@TableId(type = IdType.AUTO)
			@ApiModelProperty(value = "主键", example = "1")
			@ExcelColumn(name="主键")
			private Integer id;

			@ApiModelProperty(value = "创建人编码")
			@ExcelColumn(name="创建人编码")
			private String creator;

			@ApiModelProperty(value = "创建时间")
			@ExcelColumn(name="创建时间")
			@JsonFormat(pattern = "yyyy-MM-dd")
			private Date createDate;


			@ApiModelProperty(value = "更新人编码")
			@ExcelColumn(name="更新人编码")
			private String edirot;

			@ApiModelProperty(value = "更新时间")
			@ExcelColumn(name="更新时间")
			@JsonFormat(pattern = "yyyy-MM-dd")
			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 = "预约标识", example = "1")
			@ExcelColumn(name="预约标识")
			private Integer hkId;
			private String hkId;

			@ApiModelProperty(value = "排序码", example = "1")
			@ExcelColumn(name="排序码")
			private Integer sortnum;

			@ApiModelProperty(value = "人员编码", example = "1")
			@ExcelColumn(name="人员编码")
			private Integer memberId;
			@ApiModelProperty(value = "设备编码", example = "1")
			private Integer deviceId;

			@ApiModelProperty(value = "门禁有效期开始")
			@ExcelColumn(name="门禁有效期开始")
			private String startTime;

			@ApiModelProperty(value = "门禁有效期结束", example = "1")
			@ExcelColumn(name="门禁有效期结束")
			private Integer endTime;

			@ApiModelProperty(value = "导入状态", example = "1")
			@ExcelColumn(name="导入状态")
			private Integer importStatus;

			@ApiModelProperty(value = "导入备注")
			@ExcelColumn(name="导入备注")
			private String importInfo;

			@ApiModelProperty(value = "下发状态 0待下发 1已下发 2已取消", example = "1")
			@ExcelColumn(name="下发状态 0待下发 1已下发 2已取消")
			private Integer sendStatus;

			@ApiModelProperty(value = "下发类型 0实时 1定时 ", example = "1")
			@ExcelColumn(name="下发类型 0实时 1定时 ")
			private Integer sendType;

			@ApiModelProperty(value = "下发备注")
			@ExcelColumn(name="下发备注")
			private String sendInfo;

			@ApiModelProperty(value = "下发时间")
			@ExcelColumn(name="下发时间")
			@JsonFormat(pattern = "yyyy-MM-dd")
			private Date sendDate;

			@ApiModelProperty(value = "下发人员", example = "1")
			@ExcelColumn(name="下发人员")
			private Integer sendUserId;

			@ApiModelProperty(value = "取消人员", example = "1")
			@ExcelColumn(name="取消人员")
			private Integer cancelUserId;

			@ApiModelProperty(value = "取消时间")
			@ExcelColumn(name="取消时间")
			@JsonFormat(pattern = "yyyy-MM-dd")
			private Date cancelDate;

			@ApiModelProperty(value = "取消备注")
			@ExcelColumn(name="取消备注")
			private String cANCElInfo;
			private String cancelInfo;

			@ApiModelProperty(value = "所属公司编码")
			@TableField(exist = false)
			private String companyId;

			@ApiModelProperty(value = "姓名")
			@ExcelColumn(name="姓名",index = 1)
			@TableField(exist = false)
			private String memberName;

			@ApiModelProperty(value = "手机号")
			@ExcelColumn(name="手机号" ,index = 2)
			@TableField(exist = false)
			private String memberPhone;

			@ApiModelProperty(value = "身份证")
			@ExcelColumn(name="身份证",index= 3)
			@TableField(exist = false)
			private String memberidCard;

			@ApiModelProperty(value = "所属公司")
			@ExcelColumn(name="所属公司",index= 4)
			@TableField(exist = false)
			private String companyName;

			@ApiModelProperty(value = "门禁有效期开始")
			@ExcelColumn(name="门禁有效期开始",index= 5,dateFormat = "yyyy-MM-dd")
			private Date startTime;

			@ApiModelProperty(value = "门禁有效期结束", example = "1")
			@ExcelColumn(name="门禁有效期结束",index= 6,dateFormat = "yyyy-MM-dd")
			private Date endTime;

			@ApiModelProperty(value = "创建时间")
			@ExcelColumn(name="创建时间",index= 7,dateFormat = "yyyy-MM-dd")
			@JsonFormat(pattern = "yyyy-MM-dd")
			private Date createDate;

			@ApiModelProperty(value = "操作人")
			@ExcelColumn(name="操作人",index= 7)
			@TableField(exist = false)
			private String createrName;

			@ApiModelProperty(value = "一卡通授权下发状态 0待下发 1任务执行 2下发成功 3已取消 4下发失败 5任务下载已结束 ", example = "1")
			@ExcelColumn(name="下发状态",index= 8,valueMapping ="0=待下发;1=已下发;2=下发成功;3=已取消;4=下发失败;5=任务下载已结束" )
			private Integer sendStatus;

			@ApiModelProperty(value = "下发类型 0实时 1定时 ", example = "1")
			@ExcelColumn(name="下发类型",index= 9,valueMapping ="0=实时;1=定时" )
			private Integer sendType;



			@ApiModelProperty(value = "下发时间")
			@ExcelColumn(name="下发时间",index= 10,dateFormat = "yyyy-MM-dd")
			@JsonFormat(pattern = "yyyy-MM-dd")
			private Date sendDate;

			@ApiModelProperty(value = "下发备注")
			@ExcelColumn(name="下发备注",index= 11)
			private String sendInfo;

			@ApiModelProperty(value = "下发开始时间")
			@TableField(exist = false)
			private String sendStartDate;
			@ApiModelProperty(value = "下发结束时间")
			@TableField(exist = false)
			private String sendEndDate;

			@ApiModelProperty(value = "时间段0，7,30")
			@TableField(exist = false)
			private Integer timeDn;
			@ApiModelProperty(value = "时间段0，7,30")
			@TableField(exist = false)
			private String deviceChannelNo;
			@ApiModelProperty(value = "海康设备类型code")
			@TableField(exist = false)
			private String deviceType;
			@ApiModelProperty(value = "海康设备ode")
			@TableField(exist = false)
			private String deviceIndexCode;
			@ApiModelProperty(value = "人员海康编码")
			@TableField(exist = false)
			private String memberHkId;

			}