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;
|
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 2025/04/28 16:19
|
*/
|
@Data
|
@ApiModel("出入场人次车次每日统计表")
|
@TableName("`inout_record`")
|
public class InoutRecord {
|
|
@TableId(type = IdType.AUTO)
|
@ApiModelProperty(value = "主键", example = "1")
|
private Integer id;
|
|
@ApiModelProperty(value = "创建人编码", example = "1")
|
private Integer creator;
|
|
@ApiModelProperty(value = "创建时间")
|
@ExcelColumn(name="创建时间",index = 9,width = 18,dateFormat = "yyyy-MM-dd HH:mm:ss")
|
private Date createDate;
|
|
@ApiModelProperty(value = "更新人编码", example = "1")
|
private Integer editor;
|
|
@ApiModelProperty(value = "更新时间")
|
@JsonFormat(pattern = "yyyy-MM-dd")
|
private Date editDate;
|
|
@ApiModelProperty(value = "是否删除0否 1是", example = "1")
|
private Integer isdeleted;
|
|
@ApiModelProperty(value = "备注")
|
@ExcelColumn(name="备注",index = 10,width = 16)
|
private String remark;
|
|
@ApiModelProperty(value = "对象类型 0车辆 1人员", example = "1")
|
private Integer type;
|
|
@ApiModelProperty(value = "海康事件编码")
|
private String hkEventId;
|
|
@ApiModelProperty(value = "海康事件对象编码")
|
private String hkId;
|
|
@ApiModelProperty(value = "关联人员编码（关联member)", example = "1")
|
private Integer memberId;
|
|
@ApiModelProperty(value = "关联人员编码（关联cars)", example = "1")
|
private Integer carId;
|
|
@ApiModelProperty(value = "关联分类编码（关联category)", example = "1")
|
private Integer categoryId;
|
|
@ApiModelProperty(value = "关联分类名称")
|
@ExcelColumn(name="车辆分类",index = 6,width = 16)
|
private String categoryName;
|
|
@ApiModelProperty(value = "关联父级分类编码（关联category)", example = "1")
|
private Integer categoryParentId;
|
|
@ApiModelProperty(value = "关联分类名称")
|
private String categoryParentName;
|
|
@ApiModelProperty(value = "业务类型 业务类型 0=访客车辆-访客车辆 ;" +
|
"1=wms推送的物流车辆（非自有车）：货运车辆-外协运输车辆 ;" +
|
"2=wms市公司的预约入园车辆：货运车辆-市公司卸货车辆;" +
|
"3=wms、安泰的预约入园车辆：货运车辆-加工烟卸货车辆 ;" +
|
"4=wms安泰公务车：公务车-安泰物流公务用车;" +
|
"5=wms安泰自有车：货运车辆-安泰物流货运车辆;" +
|
"6=未知车辆; ", example = "1")
|
// @ExcelColumn(name="车辆业务类型",index = 5,width = 16,valueMapping = "0=访客车辆-访客车辆;1=货运车辆-外协运输车辆;2=货运车辆-市公司卸货车辆;3=货运车辆-加工烟卸货车辆;4=公务车-安泰物流公务用车;5=货运车辆-安泰物流货运车辆;6=未知车辆;")
|
private Integer carBizType;
|
|
@ApiModelProperty(value = "用户类型 0劳务访客 1普通访客 2内部员工 3车辆信息 4相关方人员 5货运司机 ", example = "1")
|
@ExcelColumn(name="用户类型",index = 3,width = 16,valueMapping = "0=劳务访客;1=普通访客;2=内部员工;3=车辆信息;4=相关方人员;5=货运司机;")
|
private Integer memberType;
|
|
@ApiModelProperty(value = "人员名称")
|
@ExcelColumn(name="人员名称",index = 0,width = 16)
|
private String memberName;
|
@ApiModelProperty(value = "人员手机号")
|
@ExcelColumn(name="人员手机号",index = 1,width = 16)
|
private String memberPhone;
|
@ApiModelProperty(value = "组织名称")
|
@ExcelColumn(name="组织名称",index = 2,width = 16)
|
private String companyName;
|
@ApiModelProperty(value = "关联组织编码")
|
private Integer companyId;
|
|
@ApiModelProperty(value = "车牌号")
|
@ExcelColumn(name="车牌号",index = 4,width = 16)
|
private String carCode;
|
|
@ApiModelProperty(value = "关联对象类型 0车辆 1人员 2访客申请记录 3访客报备申请记录 4月台作业记录", example = "1")
|
private Integer objType;
|
@ApiModelProperty(value = "统计日期（2024-10-12 00:00:00）")
|
@JsonFormat(pattern = "yyyy-MM-dd")
|
private Date timeInfo;
|
|
@ApiModelProperty(value = "关联对象编码", example = "1")
|
private Integer objId;
|
|
@ApiModelProperty(value = "进出类型 0进 1出", example = "1")
|
@ExcelColumn(name="进出类型",index = 7,width = 10,valueMapping = "0=进;1=出;")
|
private Integer inOrOut;
|
|
@ApiModelProperty(value = "进出设备名称")
|
@ExcelColumn(name="进出类型",index = 8,width = 10)
|
private String deviceName;
|
|
@ApiModelProperty(value = "人脸照片")
|
@TableField(exist = false)
|
private String faceImg;
|
@ApiModelProperty(value = "身份证号（MD4加密）")
|
@TableField(exist = false)
|
private String idcardNo;
|
@ApiModelProperty(value = "证件显示信息")
|
@TableField(exist = false)
|
private String idcardDecode;
|
@ApiModelProperty(value = "证件显示信息")
|
@TableField(exist = false)
|
private String memberCode;
|
|
@ApiModelProperty(value = "创建时间 开始")
|
@TableField(exist = false)
|
@JsonFormat(pattern = "yyyy-MM-dd")
|
private Date startDate;
|
|
@ApiModelProperty(value = "创建时间 结束")
|
@TableField(exist = false)
|
@JsonFormat(pattern = "yyyy-MM-dd")
|
private Date endDate;
|
|
@TableField(exist = false)
|
private String createDateStr;
|
|
|
|
}
|
