package cn.exrick.xboot.your.entity;

import cn.exrick.xboot.core.base.XbootBaseEntity;
import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentLoopMerge;
import com.alibaba.excel.annotation.write.style.OnceAbsoluteMerge;
import com.baomidou.mybatisplus.annotation.TableField;
import lombok.Data;
import org.hibernate.annotations.DynamicInsert;
import org.hibernate.annotations.DynamicUpdate;

import javax.persistence.Entity;

@Data
//@Excel("签收状态统计报表")
@ExcelIgnoreUnannotated
public class OrderStatusCount {
    @ExcelProperty(value = "车号")
    @TableField(value = "carName")
    private String carName;

    //@ContentLoopMerge(eachRow = 5)
    @ExcelProperty("姓名")
    @TableField(value = "userName")
    //@ExcelIgnore
    private String userName;
    //    @ContentLoopMerge(eachRow = 5)
    //@ContentLoopMerge(eachRow = 5)
    @ExcelProperty("线路")
    @TableField(value = "line")
    private String line;

    @ExcelProperty("批次")
    @TableField(value = "batch")
    private String batch;
    @ExcelProperty("总数量")
    @TableField(value = "amount")
    private String amount;
    @ExcelProperty("未签收")
    @TableField(value = "notSignCount")
    private String notSignCount;
    @ExcelProperty("签收")
    @TableField(value = "signCount")
    private String signCount;
    @ExcelProperty("异常签收")
    @TableField(value = "abnormalSign")
    private String abnormalSign;
    @ExcelProperty("签收率")
    @TableField(value = "proportion")
    private String proportion;

   // @ContentLoopMerge(eachRow = 5)
    @ExcelProperty("平均签收率")
    @TableField(value = "name")
    //@ExcelIgnore
    private String name;
    //@ExcelProperty("日期")
    @ExcelIgnore
    @ColumnWidth(20)
    private String sendDate;
    //    1 按日查询   3按月查询
    @ExcelIgnore
    private String StatisticalType;
    //开始时间
    @ExcelIgnore
    private String sendDateStart;
    //    结束时间
    @ExcelIgnore
    private String sendDateEnd;
    @ExcelIgnore
    private String id;
    @ExcelIgnore
    private String taskId;
    @ExcelIgnore
    private String carId;
    @ExcelIgnore
    private String carNo;
   /* @ExcelIgnore
    private String name;*/


    @ExcelIgnore
    private String carTime;
    @ExcelIgnore
    private String oneBatch;
    @ExcelIgnore
    private String twoBatch;
    @ExcelIgnore
    private String threeBatch;
    @ExcelIgnore
    private String fourBatch;
    @ExcelIgnore
    private String fiveBatch;
    @ExcelIgnore
    private String sendMonth;
    @ExcelIgnore
    private Integer proportionInt;
}