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;



}