jnpf-java-boot-v6x/jnpf-permission/jnpf-permission-entity/target/classes/jnpf/permission/constant/UserColumnMap.java

package jnpf.permission.constant;

import jnpf.model.ExcelColumnAttr;
import org.apache.poi.ss.usermodel.IndexedColors;

import java.util.*;

public class UserColumnMap {

    String excelName = "用户信息";

    Map<String, String> keyMap = new LinkedHashMap() {{
        put("positionId", "岗位");
        put("roleId", "角色");

        put("account", "账户");
        put("realName", "姓名");
        put("gender", "性别");
        put("enabledMark", "状态");
        put("email", "电子邮箱");
//        put("organizeId", "所属组织");
//        put("managerId", "直属主管");
        put("ranks", "职级");
        put("nation", "民族");
        put("nativePlace", "籍贯");
        put("entryDate", "入职时间");
        put("certificatesType", "证件类型");
        put("certificatesNumber", "证件号码");
        put("education", "文化程度");
        put("birthday", "出生年月");
        put("telePhone", "办公电话");
        put("landline", "办公座机");
        put("mobilePhone", "手机号码");
        put("urgentContacts", "紧急联系");
        put("urgentTelePhone", "紧急电话");
        put("postalAddress", "通讯地址");
        put("sortCode", "排序");
        put("description", "说明");
    }};

    /**
     * 表格名称
     *
     * @return
     */
    public String getExcelName() {
        return excelName;
    }

    /**
     * 根据类型获取excel表头字段
     *
     * @param type
     * @return
     */
    public Map<String, String> getColumnByType(Integer type) {
        return keyMap;
    }

    /**
     * 获取字段列表
     *
     * @param isError
     * @return
     */
    public List<ExcelColumnAttr> getFieldsModel(boolean isError) {
        List<ExcelColumnAttr> models = new ArrayList<>();
        //异常原因
        if (isError) {
            ExcelColumnAttr attr = ExcelColumnAttr.builder().key("errorsInfo").name("异常原因").build();
            models.add(attr);
        }
        List<String> requireFields = Arrays.asList("account", "realName", "gender", "enabledMark");
        for (String key : keyMap.keySet()) {
            ExcelColumnAttr attr = ExcelColumnAttr.builder().key(key).name(keyMap.get(key)).build();
            if (requireFields.contains(key)) {
                attr.setRequire(true);
                attr.setFontColor(IndexedColors.RED.getIndex());
            }
            models.add(attr);
        }
        return models;
    }

    /**
     * 获取默认值
     */
    public List<Map<String, Object>> getDefaultList() {
        List<Map<String, Object>> list = new ArrayList<>();
        Map<String, Object> map = new HashMap<>();
//        map.put("organizeId", "公司名称/公司名称1/部门名称,公司名称/公司名称1/部门名称1");
//        map.put("managerId", "姓名/账号");
        map.put("positionId", "岗位名称/岗位编码,岗位名称1/岗位编码1");
        map.put("roleId", "角色名称,角色名称1");
        map.put("entryDate", "yyyy-MM-dd");
        map.put("birthday", "yyyy-MM-dd");
        list.add(map);
        return list;
    }
}