fj-dc/.svn/pristine/8c/8c04a9462af4b9a6e247f18b7e586b5e51d535f1.svn-base

package cn.com.goldenwater.dcproj.utils.export;

import java.util.HashMap;
import java.util.Map;

/**
 * @ClassName TableFieldUtil
 * @Description 字段配置工具类
 * @Author liyz
 * @Date 2019/3/7 17:49
 * @Version 1.0
 **/
public class TableFieldUtil {


    //字段名，中文名，字典表，类型
    public static String[] T1 = {
            "adNm,行政村名(*县*乡镇*村),200,VARCHAR2",
            "isPoverty,是否贫困村,,VARCHAR2",
            "isFluexc,是否氟超标地区,100,VARCHAR2",
            "isMtarea,是否山区,,VARCHAR2",
            "isCenwtSupply,是否集中供水村,100,VARCHAR2",
            "watersupplyPer,集中供水人口比例,120,VARCHAR2",
            "visitDate,暗访日期,,TIMESTAMP"
    };

    public static String[] T2 = {
            "adnm,行政村名(*县*乡镇*村),200,VARCHAR2",
            "isNdAdmin,是否需要设置管水员,120,VARCHAR2",
            "isAdmin,是否设置管水员,120,VARCHAR2",
            "adminNm,管水员姓名,100,VARCHAR2",
            "adminAge,管水员年龄,100,NUMBER",
            "adminPro,管水员性质,100,VARCHAR2",
            "salary,管水员工资（元/年）,140,NUMBER",
            "operFee,运行维护费用（元/年）,140,NUMBER",
            "otherFeeOrg,除水费收入外的运行维护费用来源,200,NUMBER",
            "feeCommons,费用说明,120,NUMBER",
            "visitDate,暗访日期,,TIMESTAMP"
    };
    public static String[] T3 = {
            "villageNm,调查地点（*县*乡镇*村）,200,VARCHAR2",
            "userNm,户主姓名,,VARCHAR2",
            "telphone,电话,,VARCHAR2",
            "cwsName,对应工程名称,120,VARCHAR2",
            "isQualityGood,水质是否良好,120,VARCHAR2",
            "isQualityProblem,是否存在问题,120,VARCHAR2",
            "isSplyHome,是否供水入户,120,VARCHAR2",
            "is24hSupply,是否24小时供水,120,VARCHAR2",
            "isWaterProblem,是否存在供水问题,120,VARCHAR2",
            "isCalFee,是否计量收费,,VARCHAR2",
            "isFeeProblem,是否存在计费问题,,VARCHAR2",
            "isSplyProblem,供水服务是否存在问题,150,VARCHAR2",
            "evaluate,总体评价,,VARCHAR2",
            "visitDate,暗访日期,,TIMESTAMP"
    };
    public static String[] T4 = {
            "pjnm,工程名称,,VARCHAR2",
            "villageNm,所在地,,VARCHAR2",
            "buildYear,建成年份,,VARCHAR2",
            "planSupplyScale,设计供水规模(m³/d),,VARCHAR2",
            "supplyScale,实际供水规模（m³/d),,VARCHAR2",
            "personNum,覆盖人口(人),,VARCHAR2",
            "pipeDamagePer,管网漏损率（%）,,VARCHAR2",
            "projectType,工程类别,,VARCHAR2",
            "is24hSupply,是否24小时不间断供水,,VARCHAR2",
            "isHavecleanEqui,净化设施设备是否配备,,VARCHAR2",
            "isCleanequiG,是否正常运行,,VARCHAR2",
            "isHavedisinfect,消毒设备是否配备,,VARCHAR2",
            "disinfectType,消毒方式,,VARCHAR2",
            "isDisinfectGood,是否正常运行,,VARCHAR2",
            "isHavereport,水质检测报告有无报告,,VARCHAR2",
            "isQuailtyGood,水质检测报告是否达标,,VARCHAR2",
            "isHaveLab,千吨万人水厂水质化验室是否配备,,VARCHAR2",
            "isDailyCheck,千吨万人水厂水质化验室是否开展日检,,VARCHAR2",
            "isDailycheckGood,千吨万人水厂水质化验室水质是否达标,,VARCHAR2",
            "isInsLicence,有无取水许可证,,VARCHAR2",
            "isSanLicence,有无卫生许可证,,VARCHAR2",
            "isAutosystem,自动化控制系统是否配备,,VARCHAR2",
            "isAutosysGood,自动化控制系统是否正常运行,,VARCHAR2",
            "isVideoSystem,视频安防系统是否配备,,VARCHAR2",
            "isVideosysGood,视频安防系统是否正常运行,,VARCHAR2",
            "waterFee,执行水价（元/m³）,,VARCHAR2",
            "waterCost,全成本（元/m³）,,VARCHAR2",
            "operCost,运行成本（元/m³）,,VARCHAR2",
            "feeRecyclePer,水费回收率（%）,,VARCHAR2",
            "manager,管理主体,,VARCHAR2",
            "isHaveHotline,是否配备供水服务热线电话,,VARCHAR2",
            "status,填报状态,,VARCHAR2",
            "visitDate,暗访日期,,TIMESTAMP",
            "recPers2,记录人员,,VARCHAR2",
            "recPersTel,记录人员电话,,VARCHAR2"
    };
    public static String[] T5 = {
            "waterSourceNm,水源地名称,100,VARCHAR2",
            "villageNm,所在地（*县*乡镇*村）,200,VARCHAR2",
            "cwsCode,供水工程名称,130,VARCHAR2",
            "planInsAmount,设计取水规模（m³/d）,130,VARCHAR2",
            "sourceType,水源类型,100,VARCHAR2",
            "waterQuality,水源水质评价,100,VARCHAR2",
            "isProtectArea,是否划定水源保护区或保护范围,180,VARCHAR2",
            "isProtectMark,是否有水源保护标志,130,VARCHAR2",
            "isPollSource,周边是否有污染源,130,VARCHAR2",
            "isSpare,是否有应急备用水源,130,VARCHAR2",
            "visitDate,暗访日期,100,VARCHAR2"
    };
    public static String[] T6 = {
            "personAmount,农村人口（万人）,,VARCHAR2",
            "focusSupplyPerc,集中供水率,,VARCHAR2",
            "waterSupplyPerc,自来水普及率,,VARCHAR2",
            "isGovRes,地方人民政府主体责任是否明确,,VARCHAR2",
            "isCntyDept,是否建立县级运行管理机构,,VARCHAR2",
            "isCntyFunc,是否建立县级运行管理办法,,VARCHAR2",
            "isCntyFee,是否落实县级运行管理经费,,VARCHAR2",
            "isQuailtyChk,是否正常开展水质巡检,,VARCHAR2",
            "pracFee,2018年落实运行经费（万元）,,VARCHAR2",
            "visitDate,暗访日期,,VARCHAR2",
            "accompany,县级水行政主管部门参加人员,,VARCHAR2",
            "visitorIds,暗访组（人）,,VARCHAR2",
            "recPers2,记录人员,,VARCHAR2",
            "recPersTel,记录人员电话,,VARCHAR2",
            "status,填报状态,,VARCHAR2"
    };
    public static String[] T7 = {
            "province,所在省,,VARCHAR2",
            "city,所在市,,VARCHAR2",
            "county,所在县,,VARCHAR2",
            "wtdstNm,项目名称,,VARCHAR2",
            "locNm,所在地点,,VARCHAR2",
            "wtdstType,项目类别,,VARCHAR2",
            "mangNm,主管单位,,VARCHAR2",
            "loac,位置,,VARCHAR2",
            "disContent,水毁情况,,VARCHAR2",
            "wkstate,项目进度,,VARCHAR2",
            "planTm,计划完成日期,,VARCHAR2",
            "problmNum,问题数量,,VARCHAR2",
            "adNm,建议措施,,VARCHAR2",
            "note,备注,,VARCHAR2"
    };
    public static String[] T8 = {

            "nm,水库名称,,VARCHAR2",
//            "engScal,工程规模,,VARCHAR2",
//            "hystSite,水库所在位置,,VARCHAR2",
//            "rsAdmName,管理单位,,VARCHAR2",
//            "totCap,总库容(万m³),,VARCHAR2",
//            "state,督查状态,,VARCHAR2",
//            "baseStat,基本信息状态,,VARCHAR2",
//            "presStat,责任人状态,,VARCHAR2",
//            "resRunStat,安全管理运行状态,,VARCHAR2",
//            "viewStat,走访用户状态,,VARCHAR2"
            // 1基础信息

//            "rsName,水库名称,,VARCHAR2",
//            "rsAdmName,管理机构,,VARCHAR2",
            "rsCode,水库代码,,VARCHAR2",
            "rsLoc,所在地点,,VARCHAR2",
            "compDate,建成时间,,VARCHAR2",
            "engScal1,工程规模,,VARCHAR2",
            "totCap,总库容(万m³),,VARCHAR2",
            "damSizeHig,最大坝高(m),,VARCHAR2",
            "damTypeStr1,主坝坝型,,VARCHAR2",
            "regCode,注册登记号,,VARCHAR2",
//            "longitude,经度,,NUMBER",
//            "latitude,纬度,,NUMBER",
            "regCode2,未注册,,VARCHAR2",


            // 2重点环节落实情况
            "emerPlanSameExta,是否编制,,VARCHAR2",
            "emerPlanSameAppr,是否批复或备案,,VARCHAR2",
            "emerPlanSameSpeed,是否具备操作性,,VARCHAR2",
            "emerPlanSameEme,是否进行演练,,VARCHAR2",
            "schPlanSameExta,是否编制,,VARCHAR2",
            "schPlanSameAppr,是否批复,,VARCHAR2",
            "schPlanSameSpeed,是否具备操作性,,VARCHAR2",
            "rainForc,是否具有能力开展,,VARCHAR2",

            // 履行责任情况总体评价
            "hasWiunWaoLegPers1,履行责任情况总体评价,,VARCHAR2",

            //管理机构
            "hasSpeManage,是否有专门管理机构,,VARCHAR2",
            "hasSpeManage2,管理机构名称,,VARCHAR2",
            "hasSpeManage3,管理机构性质,,VARCHAR2",
            "hasSpeManage4,管理经费来源,,VARCHAR2",
            "hasSpeManage5,管理经费数额（万元/年）,,VARCHAR2",
            "hasManagePers,是否有管护人员,,VARCHAR2",


            // 3.责任人落实情况
            // 行政责任人情况
            "hasWiunWaoLegPers,是否有行政责任人,,VARCHAR2",
            "wiunWaoLegPers,责任人名称,,VARCHAR2",
            "wiunWaoLegPersTel,责任人电话,,VARCHAR2",
            "wiunWaoLegPersDuty,责任人职务,,VARCHAR2",
            "wiunWaoLegPersResu,履职情况,,VARCHAR2",

            // 技术责任人情况
            "hasTechPers,是否有技术责任人,,VARCHAR2",
            "techPers,责任人名称,,VARCHAR2",
            "techPersTel,责任人电话,,VARCHAR2",
            "techPersDuty,责任人职务,,VARCHAR2",
            "techPersResu,履职情况,,VARCHAR2",

            // 巡查责任人情况
            "hasPatrolPers,是否有巡查责任人,,VARCHAR2",
            "patrolPers,责任人名称,,VARCHAR2",
            "patrolPersDuty,责任人职务,,VARCHAR2",
            "patrolPersDuty2,是否参加过培训,,VARCHAR2",
//            "patrolPersTel,责任人电话,,VARCHAR2",
            "patrolPersResu,履职情况,,VARCHAR2",
            "patrolPersResu2,管护报酬（万元/年）,,VARCHAR2",
            "patrolPersResu3,经费来源,,VARCHAR2"

            // 4.水库工程实体和运行管理情况
//            "safeComment,安全评价,,VARCHAR2",
//            "hasSpeManage,是否有专门管理机构,,VARCHAR2",
//            "hasManagePers,是否有管护人员,,VARCHAR2",
//            "hasWdEmnic,是否有稳定经济来源,,VARCHAR2",
//            "retainRegular,正常运行,,VARCHAR2",
//            "hasRetainRegular,不具备正常蓄水运行条件,,VARCHAR2",
//            "dikeHasLeak,是否正常运行,,VARCHAR2",
//            "leakMakeSafe,是否明显漏水影响安全,,VARCHAR2",
//            "hasAstable,是否有变形或不稳定情况,,VARCHAR2",
//            "hasSetMainFl,是否设置泄洪建筑物,,VARCHAR2",
//            "isMainFlNormal,运行情况,,VARCHAR2",
//            "havFlLowLimLev,是否设置防洪限制水位,,VARCHAR2",
//            "gtFlLowLimLev,超汛限水位运行,,VARCHAR2",
//            "hasSetPourFl,是否设置放水建筑物,,VARCHAR2",
//            "pourFyIsNormal,运行情况,,VARCHAR2",
//            "manageRegRelNote,是否注册登记,,VARCHAR2",
//            "ifManageRegRel,注册信息真实,,VARCHAR2",
//            "extDamSafeAppr,安全鉴定,,VARCHAR2",
//            "ifReinForce,是否实施,,VARCHAR2",
//            "ifComplateAccAll,实施情况,,VARCHAR2",
//            "ifDamWarnLogo,是否设置水库公示牌,,VARCHAR2",
            /*
                       // 5 走访情况
                       "viewPreName,走访人员名称,,VARCHAR2"
           //            "knowResManager,是否知晓水库管护人员,,VARCHAR2",
           //            "managerComment,对管护责任人的评价,,VARCHAR2",
           //            "note,备注,,VARCHAR2"
           */

//            "rgstrId,水库编码,,VARCHAR2",
//            "objId,对象ID,,VARCHAR2",
//            "rsvrNm",
//            "adCode",
//            "resCreateTime",
//            "damRegCode",
//            "damType",
//            "hasDamRegCode",
//            "resCreateTimeNote",
//            "engScalNote",
//            "groupLeader",
//            "groupLeaderTel",
//            "recPersId",
//            "recPers",
//            "recPersTel",
//            "uptm",
//            "intm",
//            "note",
//            "dataStat",
//            "inspGroupId",
//            "rsvrLong",
//            "rsvrLat",
//            "damMaxHigh",
//            "rsCode",
//            "code",
//            "id",
//            "ptype",
//            "lgtd",
//            "lttd",
//            "wtdstState",
    };
    public static Map<String, String[]> map = new HashMap<String, String[]>();

    static {
        map.put("T1", T1);
        map.put("T2", T2);
        map.put("T3", T3);
        map.put("T4", T4);
        map.put("T5", T5);
        map.put("T6", T6);
        map.put("T7", T7);
        map.put("T8", T8);
    }


}