package com.ruoyi.order.export;
|
|
import cn.afterturn.easypoi.excel.annotation.Excel;
|
import io.swagger.annotations.ApiModel;
|
import lombok.Data;
|
|
import java.io.Serializable;
|
import java.math.BigDecimal;
|
|
@Data
|
@ApiModel(value = "充电时段统计-导出")
|
public class TChargingOrderExport implements Serializable {
|
@Excel(name = "序号",width = 30)
|
private Integer id;
|
@Excel(name = "订单编号",width = 30)
|
private String code;
|
@Excel(name = "电站编号",width = 30)
|
private String siteCode;
|
@Excel(name = "电站名称",width = 30)
|
private String siteName;
|
|
@Excel(name = "终端名称",width = 30)
|
private String terminalName;
|
@Excel(name = "所属城市",width = 30)
|
private String city;
|
@Excel(name = "市区名称",width = 30)
|
private String cityName;
|
@Excel(name = "所属合作商",width = 30)
|
private String partner;
|
@Excel(name = "电站类型",width = 30,replace = {"其他_0","公共_1","个人_2","公交_3","环卫_4","物流_5","出租车_6"})
|
private Integer siteType;
|
@Excel(name = "售电模式",width = 30,replace = {"正常使用_1","维修中_2","关闭下线_3"})
|
private String saleType;
|
@Excel(name = "站点状态",width = 30,replace = {"正常使用_1","维修中_2","关闭下线_3"})
|
private String status;
|
@Excel(name = "运营类型",width = 30,replace = {"直营_1","非直营_2"})
|
private String businessCategory;
|
@Excel(name = "计费模板",width = 30)
|
private String name;
|
@Excel(name = "收款方式",width = 30,replace = {"线上_1","线下_2"})
|
private String orderClassification;
|
@Excel(name = "充电启动方式",width = 30)
|
private String startType;
|
@Excel(name = "一级来源",width = 30)
|
private String one;
|
@Excel(name = "二级来源",width = 30)
|
private String two;
|
@Excel(name = "订单创建时间",width = 30)
|
private String createTime;
|
@Excel(name = "充电开始时间",width = 30)
|
private String startTime;
|
@Excel(name = "充电结束时间",width = 30)
|
private String endTime;
|
@Excel(name = "订单状态",width = 30,replace = {"待支付_1","已支付_2"})
|
private String rechargePaymentStatus;
|
@Excel(name = "订单类型",width = 30)
|
private String type;
|
@Excel(name = "充电形式",width = 30)
|
private String chargingType;
|
@Excel(name = "判定结束原因",width = 30,replace = {"异常终止_0","主动终止_1","满电终止_2","费用不足终止_3"})
|
private String endmode;
|
@Excel(name = "充电结束账号",width = 30)
|
private String chargingEndAccount;
|
@Excel(name = "是否是免费订单",width = 30)
|
private String isFree;
|
@Excel(name = "充电电费(元)",width = 30)
|
private String electrovalence;
|
@Excel(name = "充电服务费(元)",width = 30)
|
private String serviceCharge;
|
@Excel(name = "充电费用(元)",width = 30)
|
private String total;
|
@Excel(name = "充电电量(度)",width = 30)
|
private String chargingCapacity;
|
@Excel(name = "平均电费单价(元)",width = 30)
|
private String electrovalencePrice;
|
@Excel(name = "平均服务费实际单价(元)",width = 30)
|
private String serviceChargePrice;
|
@Excel(name = "平均服务费挂牌单价(元)",width = 30)
|
private String serviceChargePriceLook;
|
@Excel(name = "充电时长(分钟)",width = 30)
|
private String cumulativeChargingTime;
|
@Excel(name = "充电前面soc",width = 30)
|
private String startSoc;
|
@Excel(name = "充电后soc",width = 30)
|
private String endtSoc;
|
@Excel(name = "是否限制soc",width = 30)
|
private String isSoc;
|
@Excel(name = "限制soc方式",width = 30)
|
private String isSocType;
|
@Excel(name = "限制soc值",width = 30)
|
private String isSocNum;
|
@Excel(name = "客户类型",width = 30)
|
private String userType;
|
@Excel(name = "会员类型",width = 30)
|
private String vipType;
|
@Excel(name = "是否PLUS订单",width = 30)
|
private String isPlus;
|
@Excel(name = "客户编号",width = 30)
|
private String userCode;
|
@Excel(name = "真实姓名",width = 30)
|
private String realName;
|
@Excel(name = "设备号",width = 30)
|
private String deviceCode;
|
@Excel(name = "手机号",width = 30)
|
private String phone;
|
@Excel(name = "昵称",width = 30)
|
private String nickName;
|
@Excel(name = "企业编号",width = 30)
|
private String companyCode;
|
@Excel(name = "企业名称",width = 30)
|
private String companyName;
|
@Excel(name = "扣费账户类型",width = 30)
|
private String accountType;
|
@Excel(name = "使用人",width = 30)
|
private String useUser;
|
@Excel(name = "卡号",width = 30)
|
private String bankCard;
|
@Excel(name = "代充使用人",width = 30)
|
private String replaceUser;
|
@Excel(name = "车架号",width = 30)
|
private String carSiteName;
|
@Excel(name = "车架号来源",width = 30)
|
private String carSiteSource;
|
@Excel(name = "车牌号",width = 30)
|
private String carNumber;
|
@Excel(name = "发动机号",width = 30)
|
private String carEngineNumber;
|
@Excel(name = "车辆自编号",width = 30)
|
private String carNumberCode;
|
@Excel(name = "第三方商户订单",width = 30)
|
private String orderCode;
|
@Excel(name = "判定车牌号",width = 30)
|
private String carNumberSource;
|
@Excel(name = "是否单枪",width = 30)
|
private String isSingle;
|
@Excel(name = "选择车型",width = 30)
|
private String carType;
|
@Excel(name = "车辆品牌",width = 30)
|
private String carBrand;
|
@Excel(name = "判定车系",width = 30)
|
private String carSeries;
|
@Excel(name = "判定车系来源",width = 30)
|
private String carSeriesSource;
|
@Excel(name = "收款时间",width = 30)
|
private String payTime;
|
@Excel(name = "电费结算方编码",width = 30)
|
private String electrovalenceSiteCode;
|
@Excel(name = "电费结算方名称",width = 30)
|
private String electrovalenceSiteName;
|
@Excel(name = "管理公司",width = 30)
|
private String companyNameAdmin;
|
@Excel(name = "计费方式",width = 30)
|
private String moneyType;
|
@Excel(name = "设备接入方式",width = 30)
|
private String deviceType;
|
@Excel(name = "核算公司",width = 30)
|
private String settlementCompanyName;
|
@Excel(name = "预支付类型",width = 30)
|
private String prePaymentType;
|
@Excel(name = "是否安全防护订单",width = 30)
|
private String isSecurity;
|
}
|
