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 map = new HashMap(); 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); } }