package com.chuanghai.ihotel.conver.aliexcel; import com.alibaba.excel.converters.Converter; import com.alibaba.excel.enums.CellDataTypeEnum; import com.alibaba.excel.metadata.CellData; import com.alibaba.excel.metadata.GlobalConfiguration; import com.alibaba.excel.metadata.property.ExcelContentProperty; /** * @Author: binguo * @Date: 2022/11/10 星期四 11:30 * @Description: 转换支付状态 * @Version: 1.0 */ public class PayStatuConverter implements Converter { @Override public Class supportJavaTypeKey() { return String.class; } @Override public CellDataTypeEnum supportExcelTypeKey() { return CellDataTypeEnum.STRING; } @Override public String convertToJavaData(CellData cellData, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) throws Exception { return cellData.getStringValue(); } @Override public CellData convertToExcelData(String value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) throws Exception { String orderStatu; // 0已取消、1待支付、2待入住、3已入住、4待结账、5已完成 if ("0".equals(value)) { orderStatu = "已取消"; } else if ("1".equals(value)) { orderStatu = "待支付"; } else if ("2".equals(value)) { orderStatu = "待入住"; } else if ("3".equals(value)) { orderStatu = "已入住"; } else if ("4".equals(value)) { orderStatu = "待结账"; } else if ("5".equals(value)){ orderStatu = "已完成"; }else { orderStatu = "未知状态"; } return new CellData<>(orderStatu); } }