ihotel-backend/src/main/java/com/chuanghai/ihotel/conver/aliexcel/PayStatuConverter.java

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<String> {
    @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);
    }
}