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;
|
}
|
