package com.ruoyi.order.export; import cn.afterturn.easypoi.excel.annotation.Excel; import io.swagger.annotations.ApiModel; import lombok.Data; import java.io.Serializable; @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 = "支付方式",width = 30) private String paymentMethod; @Excel(name = "现金支付金额",width = 30) private String cashPayAmount; @Excel(name = "余额支付金额",width = 30) private String balancePayAmount; @Excel(name = "退款金额",width = 30) private String refundAmount; @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; @Excel(name = "是否白名单",width = 30) private String isWhitelist; @Excel(name = "白名单电费退款金额",width = 30) private String whitelistElectricRefundAmount; @Excel(name = "白名单服务费退款金额",width = 30) private String whitelistServiceRefundAmount; }