package com.fdkankan.manage.vo.response; import com.alibaba.excel.annotation.ExcelIgnore; import com.alibaba.excel.annotation.ExcelProperty; import com.baomidou.mybatisplus.annotation.TableField; import com.fdkankan.manage.util.DateUtils; import lombok.Data; import org.apache.commons.lang3.StringUtils; import java.math.BigDecimal; import java.util.Date; @Data public class IncrementOrderVo { @ExcelIgnore private Long id; @ExcelIgnore private String createTime; //下单时间 @ExcelProperty("下单时间") private String tradeTime; //下单时间 @ExcelProperty("订单号") private String orderSn; //订单号 @ExcelProperty("用户账号") private String userName; //用户账号 @ExcelProperty("合同所属公司") private String companyName; @ExcelProperty("业务部门") private String businessDept; @ExcelProperty("业务员") private String businessName; @ExcelProperty("客户付款时间") private String customerPayTime; @ExcelIgnore private String nickName; //昵称 @ExcelProperty("客户名称") private String customerName; /** * 客户类别0直销,1经销 */ @ExcelIgnore private Integer customerType; @ExcelProperty("客户类别") private String customerTypeStr; @ExcelProperty("终端客户") private String endCustomer; @ExcelProperty("经销商名称") private String agentName; @ExcelIgnore private Integer useType; @ExcelProperty("使用类型") private String useTypeStr; @ExcelProperty("权益类型") private String memberLevels; @ExcelProperty("订单金额") private BigDecimal amount; //订单金额 @ExcelProperty("币种") private String currencySymbol; //订单金额 @ExcelProperty("数量") private BigDecimal count; //数量 @ExcelProperty("支付方式") private String payType; //支付方式 付款方式,0表示微信,1表示支付宝,2表示paypal,3表示其他,4表示货到付款 @ExcelProperty("交易号") private String number; //交易号 @ExcelProperty("付款状态") private String payStatus; //付款状态(状态,0或-1表示未付款,-2表示已退款,1表示已付款 @ExcelIgnore private Integer timeZoneOff; @ExcelProperty("充值方式") private String payMethod; @ExcelProperty("会员服务期限") private String incrementTime; @ExcelProperty("SN码") private String snCode; @ExcelProperty("项目号") private String projectNum; @ExcelProperty("备注") private String remark; @ExcelIgnore private Date incrementStartTime; @ExcelIgnore private Date incrementEndTime; @ExcelIgnore private Integer incrementId; public String getPayType() { if(payType == null){ return ""; } switch (payType){ case "0" : return "微信"; case "1" : return "支付宝"; case "2" : return "paypal"; case "3" : return "其他"; case "4" : return "货到付款"; default: return ""; } } public String getPayStatus() { if(payStatus == null){ return ""; } switch (payStatus){ case "-1" : case "0" : return "未付款"; case "-2" : return "已退款"; case "1" : return "已付款"; default: return ""; } } public String getCustomerTypeStr() { if(customerType == null){ return ""; } switch (customerType){ case 0 : return "直销"; case 1 : return "经销"; default: return ""; } } public String getUseTypeStr() { if(useType == null){ return ""; } switch (useType){ case 1 : return "项目实施"; case 2 : return "客户试用"; case 3 : return "内部测试"; case 4 : return "正常销售"; case 5 : return "渠道推广"; case 6 : return "其它"; default: return ""; } } public String getIncrementTime() { if(incrementStartTime==null || incrementEndTime == null){ return ""; } return DateUtils.getDayDate(incrementStartTime) +"~" + DateUtils.getDayDate(incrementEndTime); } public String getMemberLevels() { if(StringUtils.isNotBlank(memberLevels)){ switch (memberLevels){ case "PR" : return "专业会员"; case "SE" : return "高级会员"; } } return memberLevels; } }