1.根据区域进行模糊查询

wjli

2023-05-17 5fe820b18055b317cd5928d8fecd056f4c9e0115

 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/OrderStatusCount.java

@@ -2,9 +2,11 @@

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;
@@ -14,19 +16,19 @@

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

    @ContentLoopMerge(eachRow = 5)
    //@ContentLoopMerge(eachRow = 5)
    @ExcelProperty("姓名")
    @TableField(value = "userName")
    //@ExcelIgnore
    private String userName;
    //    @ContentLoopMerge(eachRow = 5)
    @ContentLoopMerge(eachRow = 5)
    //@ContentLoopMerge(eachRow = 5)
    @ExcelProperty("线路")
    @TableField(value = "line")
    private String line;
@@ -50,7 +52,7 @@
    @TableField(value = "proportion")
    private String proportion;

    @ContentLoopMerge(eachRow = 5)
   // @ContentLoopMerge(eachRow = 5)
    @ExcelProperty("平均签收率")
    @TableField(value = "name")
    //@ExcelIgnore