package cn.iocoder.yudao.module.crm.framework.excel.core;

import cn.idev.excel.converters.Converter;
import cn.idev.excel.enums.CellDataTypeEnum;
import cn.idev.excel.metadata.GlobalConfiguration;
import cn.idev.excel.metadata.data.ReadCellData;
import cn.idev.excel.metadata.data.WriteCellData;
import cn.idev.excel.metadata.property.ExcelContentProperty;

/** 是否流入公海的 Excel 转换；非法值必须报错，避免意外开放公海可见度。 */
public class AutoPoolEnabledConvert implements Converter<Boolean> {

    @Override
    public Class<?> supportJavaTypeKey() {
        return Boolean.class;
    }

    @Override
    public CellDataTypeEnum supportExcelTypeKey() {
        return CellDataTypeEnum.STRING;
    }

    @Override
    public Boolean convertToJavaData(ReadCellData<?> cell, ExcelContentProperty property,
                                     GlobalConfiguration configuration) {
        if (cell.getType() == CellDataTypeEnum.EMPTY) {
            return null;
        }
        if (cell.getType() == CellDataTypeEnum.BOOLEAN) {
            return cell.getBooleanValue();
        }
        String value = cell.getType() == CellDataTypeEnum.NUMBER
                ? cell.getNumberValue().stripTrailingZeros().toPlainString() : cell.getStringValue();
        if (value == null || value.isBlank()) {
            return null;
        }
        return switch (value.trim().toLowerCase(java.util.Locale.ROOT)) {
            case "是", "true", "1" -> true;
            case "否", "false", "0" -> false;
            default -> throw new IllegalArgumentException("是否流入公海请填写是或否");
        };
    }

    @Override
    public WriteCellData<String> convertToExcelData(Boolean value, ExcelContentProperty property,
                                                    GlobalConfiguration configuration) {
        return new WriteCellData<>(value == null ? "" : value ? "是" : "否");
    }
}