整合版集中部署流程

一、整理部门信息数据

1、相关表:

1)原部门数据表：co_institue、co_department、co_compus、co_user

2)需生成的表：bg_department、bg_department_type

2、整理规范

1）一般，校区对应 co_compus表，部门对应co_department或者co_institue

2）所以，先整理bg_department_type ,一般有这些类型：校区、学院、职能部门、科研团队、党政机构、直属单位、其他,如图

3) 然后生成bg_department，这个表是支持层级设置的，有校区的，校区设为一级，没校区的，直接设为一级，具体效果如下图：

TIP

由于这块地方每个学校的数据都不一样，需要人手动去生成

二、导入资源菜单

1、相关表： co_resource

2、删除目的学校原有资源数据，这里以汕头大学第二附属医院为例

DELETE FROM co_resource WHERE COLLEGE_ID='ST120'

3、从已部署的学校复制资源进目标学校，这里以呼和浩特民族学院为样本复制,复制到汕头大学第二附属医院

INSERT INTO co_resource (
SELECT
	RESOURCE_ID,
	RESOURCE_NAME,
	RESOURCE_PATH,
	RESOURCE_TYPE,
	P_RESOURCE_ID,
	'ST120' AS COLLEGE_ID,  //此处替换目标学校ID
	PT_TYPE,
	REQUEST_API,
	OP_CODE,
	ORDER_NUM,
	RESOURCE_LEVEL,
	NAVTAB_NAME,
	REMARK,
	IS_SHOW,
	TARGET_PROCEES,
	PERMISSION_CODE,
	now( ) AS CREATE_TIME,
	'system' as CREATE_USERID,
	'管理员' as CREATE_USERNAME,
	IS_DX_CENTER,
	IS_DX_COLLEGE,
	now( ) AS LAST_UPDATE_TIME,
	'system' as LAST_UPDATE_USERID,
	'管理员' as LAST_UPDATE_USERNAME 
FROM
	co_resource 
WHERE
	COLLEGE_ID = 'IMNC11709' //此处替换模板学校ID
	)

4、刷新资源缓存

由于这里的资源有做缓存，直接进行的数据库操作不会直接应用到已登录过的账户，这里可以通过直接修改系统管理菜单下资源管理的任意一个资源备注来刷新缓存，改完记得改回来，如下图:

三、 授权

1、相关表：

• co_user_role 用户角色关系表
• co_user_department 用户部门关系表
• co_role 角色表

2、将这些表的 DEL_FLAG 字段设置一个默认值 1，因为整合版加了这个字段的筛选，没有的话很多地方会报错

操作sql ,这里依旧以 汕头大学第二附属医院 为例，该校高校ID为ST120

1）用户角色关系表

    UPDATE co_user_role set DEL_FLAG='1' WHERE COLLEGE_ID='ST120'

2）用户部门关系表

    UPDATE co_user_department set DEL_FLAG='1' WHERE COLLEGE_ID='ST120'

3）角色表

    UPDATE co_role set DEL_FLAG='1' WHERE CO_COLLEGE_ID='ST120'

3、角色授权，因为整合版新增了许多菜单，这里需要手动做个授权，一般就改两个角色，高校二审角色和高校普通角色,两个角色的资源授权如下图：

1) 高校普通角色

2) 高校二审角色

四、合同模板配置

相关表 ct_contract_template

参考呼和浩特民族学院的配置，由于各个学校的模板不一样，这里没有所谓的通用模板，呼和浩特民族学院配置如下图

快速复制的SQL（仅限集中部署使用）

INSERT INTO ct_contract_template (
SELECT
	substring(MD5(RAND()),1,20) as TEMPLATE_ID,
	'ST120' AS COLLEGE_ID, //此处替换目标学校ID
	TEMPLATE_TYPE,
	TEMPLATE_NAME,
	`STATUS`,
	TEMPLATE_CONTENT,
	DEL_FLAG,
	PROCUREMENT_MODE,
	CONTRACT_TYPE,
	IS_CONTRACT,
	IS_AUTO_SUBMIT,
	FILE_TYPE,
	PROCUREMENT_CONTEXT,
	NULL AS FLOW_ID,
	IS_DX_CENTER,
	IS_DX_COLLEGE,
	REVISION,
	REMARK,
	'system' AS CREATE_USERID,
	'管理员' AS CREATE_USERNAME,
	now( ) AS CREATE_TIME,
	'system' AS LAST_UPDATE_USERID,
	'管理员' AS LAST_UPDATE_USERNAME,
	now( ) AS LAST_UPDATE_TIME 
FROM
	ct_contract_template 
WHERE
	COLLEGE_ID = 'ALL'  // 此次为默认配置ID
	)

五、快采准则层参数配置

相关表： zc_ratio

标准数据

    
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all11f2706865704786a2bba32b1f17ad61', NULL, NULL, NULL, 'ALL', '通用', '装修装饰工程', '2', 5, 2, 1, 7, NULL, NULL, 3, '{\"project\":{\"remark\":\"项目自定义配置\",\"price\":{\"remark\":\"价格评分自定义配置\",\"userScore\":0},\"credit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"userScoreByWin\":1,\"national\":50,\"provincial\":35,\"local\":10,\"userScoreByEvaluate\":1,\"excellent\":40,\"good\":25,\"ordinary\":10,\"poor\":0,\"none\":20},\"quality\":{\"remark\":\"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\"userScoreByDeposit\":1,\"userScoreByWarranty\":1,\"warrantyPeriod\":5},\"construction\":{\"remark\":\"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\"userScoreByPunctual\":1,\"advance\":50,\"punctual\":10,\"timeweight\":0.8,\"userScoreByOnSite\":1,\"yes\":\"1\",\"no\":0,\"managerweight\":0.2},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"userScoreByRegister\":1,\"registeredCapitalOne\":500,\"registeredCapitalTwo\":1000,\"registeredCapitalThree\":2000,\"userScoreByPeopleNum\":1,\"PeopleNumOne\":20,\"PeopleNumTwo\":50,\"PeopleNumThree\":100,\"PeopleNumFour\":200,\"userScoreByQualification\":1,\"FixedAssetsOne\":100,\"FixedAssetsTwo\":300,\"FixedAssetsThree\":600,\"FixedAssetsFour\":1000,\"userScoreByFixedAssets\":1}}}', NULL, 'Y', 'N', '2020-04-27 16:16:40', '01d29be1f10d4931a57097a4119c6983', '邓涛', '2021-07-09 12:20:53', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all1f08980030f6450f864070f51f1e6b89', NULL, NULL, NULL, 'ALL', '通用', '物业服务', '3', 5, 4, 0, 9, 0, 0, 1, '{\"service\":{\"remark\":\"项目自定义配置是否启用参数userScore（0启用；1不启用）\",\"price\":{\"remark\":\"价格评分自定义配置\",\"userScore\":1},\"credit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"userScoreByWin\":1,\"national\":50,\"provincial\":30,\"local\":10,\"userScoreByEvaluate\":1,\"excellent\":40,\"good\":25,\"ordinary\":10,\"poor\":0,\"none\":15},\"quality\":{\"remark\":\"服务质量层面的配置,下面分别为负偏离参数扣分、正偏离参数加分\",\"userScore\":1,\"negativeDeviation\":10,\"positiveDeviation\":0},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"userScoreByRegister\":1,\"registeredCapitalOne\":500,\"registeredCapitalTwo\":1000,\"registeredCapitalThree\":2000,\"userScoreByPeopleNum\":1,\"PeopleNumOne\":20,\"PeopleNumTwo\":50,\"PeopleNumThree\":100,\"PeopleNumFour\":200,\"userScoreByFixedAssets\":1,\"FixedAssetsOne\":100,\"FixedAssetsTwo\":300,\"FixedAssetsThree\":600,\"FixedAssetsFour\":1000,\"userScoreByQualification\":1}}}', NULL, 'Y', 'N', '2021-07-09 12:47:10', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '2021-07-09 14:29:01', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all236f22d974604730a7c621b973c99c13', NULL, NULL, NULL, 'ALL', '通用', '行政设备', '1', NULL, NULL, NULL, 7, 5, 3, 1, '{\"device\":{\"remark\":\"设备配置\",\"price\":{\"remark\":\"设备价格层面的配置\"},\"function\":{\"remark\":\"设备性能层面的配置,下面分别为不符合参数扣分、参数权重、品牌分权重\",\"negativeDeviation\":\"10\",\"positiveDeviation\":\"0\",\"deviateRatio\":\"0.7\",\"brandRatio\":\"0.3\"},\"afterSale\":{\"remark\":\"设备售后层面的配置,下面分别为符合质保期加分、额外质保期最多加分、额外质保期每个月加分、安装方式加分\",\"warrantyPeriod\":\"50\",\"notWarrantyPeriod\":\"0\",\"warrantyPeriodTop\":\"30\",\"warrantyPeriodAdd\":\"1\",\"installWay\":\"2\"},\"credit\":{\"remark\":\"设备信用层面的配置，下面分别是供应商优秀、良好、一般、较差、差、没有评价、违约、拉黑、弃标、自产、代理\",\"excellentEvaluate\":\"100\",\"goodEvaluate\":\"85\",\"commonEvaluate\":\"60\",\"poorEvaluate\":\"35\",\"badEvaluate\":\"0\",\"noEvaluate\":\"60\",\"breakContract\":\"10\",\"black\":\"20\",\"abandon\":\"5\",\"selfProduced\":\"5\",\"agent\":\"2\"}},\"project\":{\"remark\":\"项目自定义配置\",\"creadit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"national\":\"50\",\"provincial\":\"35\",\"local\":\"10\",\"excellent\":\"40\",\"good\":\"25\",\"ordinary\":\"10\",\"poor\":\"0\",\"none\":\"20\"},\"quality\":{\"remark\":\"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\"warrantyPeriod\":\"5\"},\"construction\":{\"remark\":\"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\"advance\":\"50\",\"punctual\":\"10\",\"timeweight\":\"0.8\",\"yes\":\"1\",\"no\":\"0\",\"managerweight\":\"0.2\"},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"registeredCapitalOne\":\"500\",\"registeredCapitalTwo\":\"1000\",\"registeredCapitalThree\":\"2000\",\"PeopleNumOne\":\"20\",\"PeopleNumTwo\":\"50\",\"PeopleNumThree\":\"100\",\"PeopleNumFour\":\"200\",\"FixedAssetsOne\":\"100\",\"FixedAssetsTwo\":\"300\",\"FixedAssetsThree\":\"600\",\"FixedAssetsFour\":\"1000\"}},\"service\":{\"remark\":\"服务配置\"}}', NULL, 'Y', 'N', '2020-04-21 10:31:48', '01d29be1f10d4931a57097a4119c6983', '邓涛', '2021-07-09 12:26:16', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all2c7b93a23f004f1eaa5ed9781a059e78', NULL, NULL, NULL, 'ALL', '通用', '医疗服务', '3', 6, 3, NULL, 7, NULL, NULL, 1, '{\"service\":{\"remark\":\"项目自定义配置是否启用参数userScore（0启用；1不启用）\",\"price\":{\"remark\":\"价格评分自定义配置\",\"userScore\":1},\"credit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"userScoreByWin\":1,\"national\":50,\"provincial\":30,\"local\":10,\"userScoreByEvaluate\":1,\"excellent\":40,\"good\":25,\"ordinary\":10,\"poor\":0,\"none\":15},\"quality\":{\"remark\":\"服务质量层面的配置,下面分别为负偏离参数扣分、正偏离参数加分\",\"userScore\":1,\"negativeDeviation\":10,\"positiveDeviation\":0},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"userScoreByRegister\":1,\"registeredCapitalOne\":500,\"registeredCapitalTwo\":1000,\"registeredCapitalThree\":2000,\"userScoreByPeopleNum\":1,\"PeopleNumOne\":20,\"PeopleNumTwo\":50,\"PeopleNumThree\":100,\"PeopleNumFour\":200,\"userScoreByFixedAssets\":1,\"FixedAssetsOne\":100,\"FixedAssetsTwo\":300,\"FixedAssetsThree\":600,\"FixedAssetsFour\":1000,\"userScoreByQualification\":1}}}', NULL, 'Y', 'N', '2021-07-09 10:16:40', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '2021-07-09 14:29:39', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all36361fc7bdad4da0ac214d3a8c57413f', NULL, NULL, '', 'ALL', '通用', '教学仪器', '1', NULL, NULL, NULL, 8, 7, 2, 1, '{\r\n    \"device\": {\r\n        \"remark\": \"设备配置\",\r\n        \"price\": {\r\n            \"remark\": \"设备价格层面的配置\"\r\n        },\r\n        \"function\": {\r\n            \"remark\": \"设备性能层面的配置,下面分别为不符合参数扣分、参数权重、品牌分权重\",\r\n            \"negativeDeviation\": \"20\",\r\n            \"positiveDeviation\": \"0\",\r\n            \"deviateRatio\": \"0.7\",\r\n            \"brandRatio\": \"0.3\"\r\n        },\r\n        \"afterSale\": {\r\n            \"remark\": \"设备售后层面的配置,下面分别为符合质保期加分、额外质保期最多加分、额外质保期每个月加分、安装方式加分\",\r\n            \"warrantyPeriod\": \"50\",\r\n            \"notWarrantyPeriod\": \"0\",   \r\n            \"warrantyPeriodTop\": \"30\",\r\n            \"warrantyPeriodAdd\": \"1\",\r\n            \"installWay\": \"2\"\r\n        },\r\n        \"credit\": {\r\n            \"remark\": \"设备信用层面的配置，下面分别是供应商优秀、良好、一般、较差、差、没有评价、违约、拉黑、弃标、自产、代理\",\r\n            \"excellentEvaluate\": \"100\",\r\n            \"goodEvaluate\": \"85\",\r\n            \"commonEvaluate\": \"60\",\r\n            \"poorEvaluate\": \"35\",\r\n            \"badEvaluate\": \"0\",\r\n            \"noEvaluate\": \"60\",\r\n            \"breakContract\": \"10\",\r\n            \"black\": \"20\",\r\n            \"abandon\": \"5\",\r\n            \"selfProduced\": \"10\",\r\n            \"agent\": \"5\"\r\n        }\r\n    },\r\n    \"project\": {\r\n        \"remark\": \"项目自定义配置\",\r\n        \"creadit\": {\r\n            \"remark\": \"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\r\n            \"national\": \"50\",\r\n            \"provincial\": \"35\",\r\n            \"local\": \"10\",\r\n            \"excellent\": \"40\",\r\n            \"good\": \"25\",\r\n            \"ordinary\": \"10\",\r\n            \"poor\": \"0\",\r\n            \"none\": \"20\"\r\n        },\r\n        \"quality\": {\r\n            \"remark\": \"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\r\n            \"warrantyPeriod\": \"5\"\r\n        },\r\n        \"construction\": {\r\n            \"remark\": \"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\r\n            \"advance\": \"50\",\r\n            \"punctual\": \"10\",\r\n            \"timeweight\": \"0.8\",\r\n            \"yes\": \"1\",\r\n            \"no\": \"0\",\r\n            \"managerweight\": \"0.2\"\r\n        },\r\n        \"strength\": {\r\n            \"remark\": \"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\r\n            \"registeredCapitalOne\": \"500\",\r\n            \"registeredCapitalTwo\": \"1000\",\r\n            \"registeredCapitalThree\": \"2000\",\r\n            \"PeopleNumOne\": \"20\",\r\n            \"PeopleNumTwo\": \"50\",\r\n            \"PeopleNumThree\": \"100\",\r\n            \"PeopleNumFour\": \"200\",\r\n            \"FixedAssetsOne\": \"100\",\r\n            \"FixedAssetsTwo\": \"300\",\r\n            \"FixedAssetsThree\": \"600\",\r\n            \"FixedAssetsFour\": \"1000\"\r\n        }\r\n    },\r\n    \"service\": {\r\n        \"remark\": \"服务配置\"\r\n    }\r\n}', NULL, 'N', 'Y', '2020-03-09 17:21:55', '01d29be1f10d4931a57097a4119c6983', '邓涛', '2020-04-21 09:44:00', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '-1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all4f24a8ced32b44f79e56bc1fe274bf9f', NULL, NULL, NULL, 'ALL', '通用', '修缮工程', '2', 6, 2, 1, 7, 2, 1, 3, '{\"project\":{\"remark\":\"项目自定义配置\",\"price\":{\"remark\":\"价格评分自定义配置\",\"userScore\":1},\"credit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"userScoreByWin\":1,\"national\":50,\"provincial\":35,\"local\":10,\"userScoreByEvaluate\":1,\"excellent\":40,\"good\":25,\"ordinary\":10,\"poor\":0,\"none\":20},\"quality\":{\"remark\":\"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\"userScoreByDeposit\":1,\"userScoreByWarranty\":1,\"warrantyPeriod\":5},\"construction\":{\"remark\":\"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\"userScoreByPunctual\":1,\"advance\":50,\"punctual\":10,\"timeweight\":0.8,\"userScoreByOnSite\":1,\"yes\":\"2\",\"no\":0,\"managerweight\":0.2},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"userScoreByRegister\":1,\"registeredCapitalOne\":500,\"registeredCapitalTwo\":1000,\"registeredCapitalThree\":2000,\"userScoreByPeopleNum\":1,\"PeopleNumOne\":20,\"PeopleNumTwo\":50,\"PeopleNumThree\":100,\"PeopleNumFour\":200,\"userScoreByQualification\":1,\"FixedAssetsOne\":100,\"FixedAssetsTwo\":300,\"FixedAssetsThree\":600,\"FixedAssetsFour\":1000,\"userScoreByFixedAssets\":1}}}', NULL, 'Y', 'N', '2020-04-09 10:58:26', '01d29be1f10d4931a57097a4119c6983', '邓涛', '2021-07-09 12:21:21', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all571024496c62456a98bb5ae7f6777ada', NULL, NULL, NULL, 'ALL', '通用', '后勤设备', '1', NULL, NULL, NULL, 8, 5, 4, 1, '{\"device\":{\"remark\":\"设备配置\",\"price\":{\"remark\":\"设备价格层面的配置\"},\"function\":{\"remark\":\"设备性能层面的配置,下面分别为不符合参数扣分、参数权重、品牌分权重\",\"negativeDeviation\":10,\"positiveDeviation\":0,\"deviateRatio\":0.7,\"brandRatio\":0.3},\"afterSale\":{\"remark\":\"设备售后层面的配置,下面分别为符合质保期加分、额外质保期最多加分、额外质保期每个月加分、安装方式加分\",\"warrantyPeriod\":50,\"warrantyPeriodTop\":30,\"warrantyPeriodAdd\":1,\"notWarrantyPeriod\":0,\"installWay\":2},\"credit\":{\"remark\":\"设备信用层面的配置，下面分别是供应商优秀、良好、一般、较差、差、没有评价、违约、拉黑、弃标、自产、代理\",\"excellentEvaluate\":100,\"goodEvaluate\":85,\"commonEvaluate\":60,\"poorEvaluate\":35,\"badEvaluate\":0,\"noEvaluate\":20,\"breakContract\":10,\"black\":20,\"abandon\":5,\"selfProduced\":\"5\",\"agent\":\"2\"}}}', NULL, 'Y', 'N', '2021-07-09 12:27:34', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '2021-07-09 12:28:13', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all58116e156a3944398800c150a53b85de', NULL, NULL, NULL, 'ALL', '通用', '专业技术服务', '3', 6, 4, 0, 7, 0, 0, 1, '{\"service\":{\"remark\":\"项目自定义配置是否启用参数userScore（0启用；1不启用）\",\"price\":{\"remark\":\"价格评分自定义配置\",\"userScore\":1},\"credit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"userScoreByWin\":1,\"national\":50,\"provincial\":30,\"local\":10,\"userScoreByEvaluate\":1,\"excellent\":40,\"good\":25,\"ordinary\":10,\"poor\":0,\"none\":15},\"quality\":{\"remark\":\"服务质量层面的配置,下面分别为负偏离参数扣分、正偏离参数加分\",\"userScore\":1,\"negativeDeviation\":10,\"positiveDeviation\":0},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"userScoreByRegister\":1,\"registeredCapitalOne\":500,\"registeredCapitalTwo\":1000,\"registeredCapitalThree\":2000,\"userScoreByPeopleNum\":1,\"PeopleNumOne\":20,\"PeopleNumTwo\":50,\"PeopleNumThree\":100,\"PeopleNumFour\":200,\"userScoreByFixedAssets\":1,\"FixedAssetsOne\":100,\"FixedAssetsTwo\":300,\"FixedAssetsThree\":600,\"FixedAssetsFour\":1000,\"userScoreByQualification\":1}}}', NULL, 'Y', 'N', '2021-07-09 12:41:18', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '2021-07-09 14:29:46', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all726b7ff396a3440cadc2a9d69cb0364d', NULL, NULL, NULL, 'ALL', '通用', '家政服务', '3', 5, 3, 0, 9, 0, 0, 1, '{\"service\":{\"remark\":\"项目自定义配置是否启用参数userScore（0启用；1不启用）\",\"price\":{\"remark\":\"价格评分自定义配置\",\"userScore\":1},\"credit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"userScoreByWin\":1,\"national\":50,\"provincial\":30,\"local\":10,\"userScoreByEvaluate\":1,\"excellent\":40,\"good\":25,\"ordinary\":10,\"poor\":0,\"none\":15},\"quality\":{\"remark\":\"服务质量层面的配置,下面分别为负偏离参数扣分、正偏离参数加分\",\"userScore\":1,\"negativeDeviation\":10,\"positiveDeviation\":0},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"userScoreByRegister\":1,\"registeredCapitalOne\":500,\"registeredCapitalTwo\":1000,\"registeredCapitalThree\":2000,\"userScoreByPeopleNum\":1,\"PeopleNumOne\":20,\"PeopleNumTwo\":50,\"PeopleNumThree\":100,\"PeopleNumFour\":200,\"userScoreByFixedAssets\":1,\"FixedAssetsOne\":100,\"FixedAssetsTwo\":300,\"FixedAssetsThree\":600,\"FixedAssetsFour\":1000,\"userScoreByQualification\":1}}}', NULL, 'Y', 'N', '2021-07-09 12:44:51', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '2021-07-09 14:29:08', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all76814399af6a49cb899edc3a54575327', NULL, NULL, NULL, 'ALL', '通用', '123', '1', NULL, NULL, NULL, 123, 123, 123, 123, '{\"device\":{\"remark\":\"设备配置\",\"price\":{\"remark\":\"设备价格层面的配置\"},\"function\":{\"remark\":\"设备性能层面的配置,下面分别为不符合参数扣分、参数权重、品牌分权重\",\"negativeDeviation\":\"-3\",\"positiveDeviation\":\"\",\"deviateRatio\":0.7,\"brandRatio\":0.3},\"afterSale\":{\"remark\":\"设备售后层面的配置,下面分别为符合质保期加分、额外质保期最多加分、额外质保期每个月加分、安装方式加分\",\"warrantyPeriod\":50,\"warrantyPeriodTop\":30,\"warrantyPeriodAdd\":1,\"notWarrantyPeriod\":0,\"installWay\":2},\"credit\":{\"remark\":\"设备信用层面的配置，下面分别是供应商优秀、良好、一般、较差、差、没有评价、违约、拉黑、弃标、自产、代理\",\"excellentEvaluate\":100,\"goodEvaluate\":85,\"commonEvaluate\":60,\"poorEvaluate\":35,\"badEvaluate\":0,\"noEvaluate\":20,\"breakContract\":10,\"black\":20,\"abandon\":5,\"selfProduced\":10,\"agent\":5}}}', NULL, 'N', 'Y', '2020-11-03 09:25:31', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '2020-11-03 09:27:55', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '-1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all78383cec4bc044d2a2cce619ff3cd590', NULL, NULL, NULL, 'ALL', '通用', '园林服务', '3', 5, 3, 0, 9, 0, 0, 1, '{\"service\":{\"remark\":\"项目自定义配置是否启用参数userScore（0启用；1不启用）\",\"price\":{\"remark\":\"价格评分自定义配置\",\"userScore\":1},\"credit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"userScoreByWin\":1,\"national\":50,\"provincial\":30,\"local\":10,\"userScoreByEvaluate\":1,\"excellent\":40,\"good\":25,\"ordinary\":10,\"poor\":0,\"none\":15},\"quality\":{\"remark\":\"服务质量层面的配置,下面分别为负偏离参数扣分、正偏离参数加分\",\"userScore\":1,\"negativeDeviation\":10,\"positiveDeviation\":0},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"userScoreByRegister\":1,\"registeredCapitalOne\":500,\"registeredCapitalTwo\":1000,\"registeredCapitalThree\":2000,\"userScoreByPeopleNum\":1,\"PeopleNumOne\":20,\"PeopleNumTwo\":50,\"PeopleNumThree\":100,\"PeopleNumFour\":200,\"userScoreByFixedAssets\":1,\"FixedAssetsOne\":100,\"FixedAssetsTwo\":300,\"FixedAssetsThree\":600,\"FixedAssetsFour\":1000,\"userScoreByQualification\":1}}}', NULL, 'Y', 'N', '2021-07-09 12:45:43', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '2021-07-09 14:29:15', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all86131808b822486195ac271f03c3295d', NULL, NULL, NULL, 'ALL', '通用', '测试', '2', -11, 1, 1, 1, NULL, NULL, 1, '{\r\n    \"project\": {\r\n        \"remark\": \"项目自定义配置\",\r\n		\"price\":{\r\n			\"remark\":\"价格评分自定义配置\",\r\n			\"userScore\":\"0\"\r\n		},\r\n        \"credit\": {\r\n            \"remark\": \"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\r\n			\"userScoreByWin\":\"0\",\r\n            \"national\": 50,\r\n            \"provincial\": 35,\r\n            \"local\": 10,\r\n			\"userScoreByEvaluate\":\"0\",\r\n            \"excellent\": 40,\r\n            \"good\": 25,\r\n            \"ordinary\": 10,\r\n            \"poor\": 0,\r\n            \"none\": 20\r\n        },\r\n        \"quality\": {\r\n            \"remark\": \"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\r\n			\"userScoreByDeposit\":\"0\",\r\n			\"userScoreByWarranty\":\"0\",\r\n            \"warrantyPeriod\": 5\r\n        },\r\n        \"construction\": {\r\n            \"remark\": \"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\r\n			\"userScoreByPunctual\":\"0\",\r\n            \"advance\": 50,\r\n            \"punctual\": 10,\r\n            \"timeweight\": 0.8,\r\n			\"userScoreByOnSite\":\"0\",\r\n            \"yes\": 1,\r\n            \"no\": 0,\r\n            \"managerweight\": 0.2\r\n        },\r\n        \"strength\": {\r\n            \"remark\": \"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\r\n			\"userScoreByRegister\":\"0\",\r\n            \"registeredCapitalOne\": 500,\r\n            \"registeredCapitalTwo\": 1000,\r\n            \"registeredCapitalThree\": 2000,\r\n			\"userScoreByPeopleNum\":\"0\",\r\n            \"PeopleNumOne\": 20,\r\n            \"PeopleNumTwo\": 50,\r\n            \"PeopleNumThree\": 100,\r\n            \"PeopleNumFour\": 200,\r\n			\"userScoreByQualification\":\"0\",\r\n            \"FixedAssetsOne\": 100,\r\n            \"FixedAssetsTwo\": 300,\r\n            \"FixedAssetsThree\": 600,\r\n            \"FixedAssetsFour\": 1000,\r\n			\"userScoreByFixedAssets\":\"0\"\r\n        }\r\n    }\r\n}', NULL, 'Y', 'N', '2021-01-27 15:07:00', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '2021-01-27 15:07:00', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '-1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all8b1a631cc3a147a3974cf06a868df75a', NULL, NULL, NULL, 'ALL', '通用', '运输服务', '3', 5, 3, 0, 9, 0, 0, 1, '{\"service\":{\"remark\":\"项目自定义配置是否启用参数userScore（0启用；1不启用）\",\"price\":{\"remark\":\"价格评分自定义配置\",\"userScore\":1},\"credit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"userScoreByWin\":1,\"national\":50,\"provincial\":30,\"local\":10,\"userScoreByEvaluate\":1,\"excellent\":40,\"good\":25,\"ordinary\":10,\"poor\":0,\"none\":15},\"quality\":{\"remark\":\"服务质量层面的配置,下面分别为负偏离参数扣分、正偏离参数加分\",\"userScore\":1,\"negativeDeviation\":10,\"positiveDeviation\":0},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"userScoreByRegister\":1,\"registeredCapitalOne\":500,\"registeredCapitalTwo\":1000,\"registeredCapitalThree\":2000,\"userScoreByPeopleNum\":1,\"PeopleNumOne\":20,\"PeopleNumTwo\":50,\"PeopleNumThree\":100,\"PeopleNumFour\":200,\"userScoreByFixedAssets\":1,\"FixedAssetsOne\":100,\"FixedAssetsTwo\":300,\"FixedAssetsThree\":600,\"FixedAssetsFour\":1000,\"userScoreByQualification\":1}}}', NULL, 'Y', 'N', '2021-07-09 12:47:38', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '2021-07-09 14:28:50', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all8bc7ecba298d40bba2f6a35cb7e2b72d', NULL, NULL, NULL, 'ALL', '通用', '土建工程', '2', 8, 3, 1, 7, 0, 0, 3, '{\"project\":{\"remark\":\"项目自定义配置\",\"price\":{\"remark\":\"价格评分自定义配置\",\"userScore\":1},\"credit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"userScoreByWin\":1,\"national\":50,\"provincial\":35,\"local\":10,\"userScoreByEvaluate\":1,\"excellent\":40,\"good\":25,\"ordinary\":10,\"poor\":0,\"none\":20},\"quality\":{\"remark\":\"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\"userScoreByDeposit\":1,\"userScoreByWarranty\":1,\"warrantyPeriod\":5},\"construction\":{\"remark\":\"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\"userScoreByPunctual\":1,\"advance\":50,\"punctual\":10,\"timeweight\":0.8,\"userScoreByOnSite\":1,\"yes\":\"5\",\"no\":0,\"managerweight\":0.2},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"userScoreByRegister\":1,\"registeredCapitalOne\":500,\"registeredCapitalTwo\":1000,\"registeredCapitalThree\":2000,\"userScoreByPeopleNum\":1,\"PeopleNumOne\":20,\"PeopleNumTwo\":50,\"PeopleNumThree\":100,\"PeopleNumFour\":200,\"userScoreByQualification\":1,\"FixedAssetsOne\":100,\"FixedAssetsTwo\":300,\"FixedAssetsThree\":600,\"FixedAssetsFour\":1000,\"userScoreByFixedAssets\":1}}}', NULL, 'Y', 'N', '2020-04-17 16:45:32', '01d29be1f10d4931a57097a4119c6983', '邓涛', '2021-07-09 12:18:02', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all8dad2c6674714a48863bfb86186b6467', NULL, NULL, NULL, 'ALL', '通用', '科研设备', '1', NULL, NULL, NULL, 5, 8, 3, 1, '{\"device\":{\"remark\":\"设备配置\",\"price\":{\"remark\":\"设备价格层面的配置\"},\"function\":{\"remark\":\"设备性能层面的配置,下面分别为不符合参数扣分、参数权重、品牌分权重\",\"negativeDeviation\":\"10\",\"positiveDeviation\":\"0\",\"deviateRatio\":\"0.7\",\"brandRatio\":\"0.3\"},\"afterSale\":{\"remark\":\"设备售后层面的配置,下面分别为符合质保期加分、额外质保期最多加分、额外质保期每个月加分、安装方式加分\",\"warrantyPeriod\":\"50\",\"notWarrantyPeriod\":\"0\",\"warrantyPeriodTop\":\"30\",\"warrantyPeriodAdd\":\"1\",\"installWay\":\"2\"},\"credit\":{\"remark\":\"设备信用层面的配置，下面分别是供应商优秀、良好、一般、较差、差、没有评价、违约、拉黑、弃标、自产、代理\",\"excellentEvaluate\":\"100\",\"goodEvaluate\":\"85\",\"commonEvaluate\":\"60\",\"poorEvaluate\":\"35\",\"badEvaluate\":\"0\",\"noEvaluate\":\"60\",\"breakContract\":\"10\",\"black\":\"20\",\"abandon\":\"5\",\"selfProduced\":\"5\",\"agent\":\"2\"}},\"project\":{\"remark\":\"项目自定义配置\",\"creadit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"national\":\"50\",\"provincial\":\"35\",\"local\":\"10\",\"excellent\":\"40\",\"good\":\"25\",\"ordinary\":\"10\",\"poor\":\"0\",\"none\":\"20\"},\"quality\":{\"remark\":\"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\"warrantyPeriod\":\"5\"},\"construction\":{\"remark\":\"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\"advance\":\"50\",\"punctual\":\"10\",\"timeweight\":\"0.8\",\"yes\":\"1\",\"no\":\"0\",\"managerweight\":\"0.2\"},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"registeredCapitalOne\":\"500\",\"registeredCapitalTwo\":\"1000\",\"registeredCapitalThree\":\"2000\",\"PeopleNumOne\":\"20\",\"PeopleNumTwo\":\"50\",\"PeopleNumThree\":\"100\",\"PeopleNumFour\":\"200\",\"FixedAssetsOne\":\"100\",\"FixedAssetsTwo\":\"300\",\"FixedAssetsThree\":\"600\",\"FixedAssetsFour\":\"1000\"}},\"service\":{\"remark\":\"服务配置\"}}', NULL, 'Y', 'N', '2020-04-21 10:32:32', '01d29be1f10d4931a57097a4119c6983', '邓涛', '2021-07-09 14:31:25', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all9513deef2bfd4df897ea0f903e2b1099', NULL, NULL, '', 'ALL', '通用', '科研仪器', '1', NULL, NULL, NULL, 7, 8, 3, 1, '{\r\n    \"device\": {\r\n        \"remark\": \"设备配置\",\r\n        \"price\": {\r\n            \"remark\": \"设备价格层面的配置\"\r\n        },\r\n        \"function\": {\r\n            \"remark\": \"设备性能层面的配置,下面分别为不符合参数扣分、参数权重、品牌分权重\",\r\n            \"negativeDeviation\": \"20\",\r\n            \"positiveDeviation\": \"0\",\r\n            \"deviateRatio\": \"0.7\",\r\n            \"brandRatio\": \"0.3\"\r\n        },\r\n        \"afterSale\": {\r\n            \"remark\": \"设备售后层面的配置,下面分别为符合质保期加分、额外质保期最多加分、额外质保期每个月加分、安装方式加分\",\r\n            \"warrantyPeriod\": \"50\",\r\n            \"notWarrantyPeriod\": \"0\",   \r\n            \"warrantyPeriodTop\": \"30\",\r\n            \"warrantyPeriodAdd\": \"1\",\r\n            \"installWay\": \"2\"\r\n        },\r\n        \"credit\": {\r\n            \"remark\": \"设备信用层面的配置，下面分别是供应商优秀、良好、一般、较差、差、没有评价、违约、拉黑、弃标、自产、代理\",\r\n            \"excellentEvaluate\": \"100\",\r\n            \"goodEvaluate\": \"85\",\r\n            \"commonEvaluate\": \"60\",\r\n            \"poorEvaluate\": \"35\",\r\n            \"badEvaluate\": \"0\",\r\n            \"noEvaluate\": \"60\",\r\n            \"breakContract\": \"10\",\r\n            \"black\": \"20\",\r\n            \"abandon\": \"5\",\r\n            \"selfProduced\": \"10\",\r\n            \"agent\": \"5\"\r\n        }\r\n    },\r\n    \"project\": {\r\n        \"remark\": \"项目自定义配置\",\r\n        \"creadit\": {\r\n            \"remark\": \"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\r\n            \"national\": \"50\",\r\n            \"provincial\": \"35\",\r\n            \"local\": \"10\",\r\n            \"excellent\": \"40\",\r\n            \"good\": \"25\",\r\n            \"ordinary\": \"10\",\r\n            \"poor\": \"0\",\r\n            \"none\": \"20\"\r\n        },\r\n        \"quality\": {\r\n            \"remark\": \"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\r\n            \"warrantyPeriod\": \"5\"\r\n        },\r\n        \"construction\": {\r\n            \"remark\": \"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\r\n            \"advance\": \"50\",\r\n            \"punctual\": \"10\",\r\n            \"timeweight\": \"0.8\",\r\n            \"yes\": \"1\",\r\n            \"no\": \"0\",\r\n            \"managerweight\": \"0.2\"\r\n        },\r\n        \"strength\": {\r\n            \"remark\": \"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\r\n            \"registeredCapitalOne\": \"500\",\r\n            \"registeredCapitalTwo\": \"1000\",\r\n            \"registeredCapitalThree\": \"2000\",\r\n            \"PeopleNumOne\": \"20\",\r\n            \"PeopleNumTwo\": \"50\",\r\n            \"PeopleNumThree\": \"100\",\r\n            \"PeopleNumFour\": \"200\",\r\n            \"FixedAssetsOne\": \"100\",\r\n            \"FixedAssetsTwo\": \"300\",\r\n            \"FixedAssetsThree\": \"600\",\r\n            \"FixedAssetsFour\": \"1000\"\r\n        }\r\n    },\r\n    \"service\": {\r\n        \"remark\": \"服务配置\"\r\n    }\r\n}', NULL, 'N', 'Y', '2020-03-13 15:11:13', '01d29be1f10d4931a57097a4119c6983', '邓涛', '2020-04-21 09:44:15', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '-1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all9f2ed2d44e3a497fa8b8a85699ac5b7c', NULL, NULL, NULL, 'ALL', '通用', '其他工程', '2', 4, 3, 1, 8, 0, 0, 5, '{\r\n    \"project\": {\r\n        \"remark\": \"项目自定义配置\",\r\n		\"price\":{\r\n			\"remark\":\"价格评分自定义配置\",\r\n			\"userScore\":\"0\"\r\n		},\r\n        \"credit\": {\r\n            \"remark\": \"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\r\n			\"userScoreByWin\":\"0\",\r\n            \"national\": 50,\r\n            \"provincial\": 35,\r\n            \"local\": 10,\r\n			\"userScoreByEvaluate\":\"0\",\r\n            \"excellent\": 40,\r\n            \"good\": 25,\r\n            \"ordinary\": 10,\r\n            \"poor\": 0,\r\n            \"none\": 20\r\n        },\r\n        \"quality\": {\r\n            \"remark\": \"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\r\n			\"userScoreByDeposit\":\"0\",\r\n			\"userScoreByWarranty\":\"0\",\r\n            \"warrantyPeriod\": 5\r\n        },\r\n        \"construction\": {\r\n            \"remark\": \"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\r\n			\"userScoreByPunctual\":\"0\",\r\n            \"advance\": 50,\r\n            \"punctual\": 10,\r\n            \"timeweight\": 0.8,\r\n			\"userScoreByOnSite\":\"0\",\r\n            \"yes\": 1,\r\n            \"no\": 0,\r\n            \"managerweight\": 0.2\r\n        },\r\n        \"strength\": {\r\n            \"remark\": \"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\r\n			\"userScoreByRegister\":\"0\",\r\n            \"registeredCapitalOne\": 500,\r\n            \"registeredCapitalTwo\": 1000,\r\n            \"registeredCapitalThree\": 2000,\r\n			\"userScoreByPeopleNum\":\"0\",\r\n            \"PeopleNumOne\": 20,\r\n            \"PeopleNumTwo\": 50,\r\n            \"PeopleNumThree\": 100,\r\n            \"PeopleNumFour\": 200,\r\n			\"userScoreByQualification\":\"0\",\r\n            \"FixedAssetsOne\": 100,\r\n            \"FixedAssetsTwo\": 300,\r\n            \"FixedAssetsThree\": 600,\r\n            \"FixedAssetsFour\": 1000,\r\n			\"userScoreByFixedAssets\":\"0\"\r\n        }\r\n    }\r\n}', NULL, 'N', 'Y', '2020-04-19 09:36:38', 'e4577af2be9d45d8993ddbad74160dd3', '林明河', '2020-04-19 09:36:38', 'e4577af2be9d45d8993ddbad74160dd3', '林明河', '-1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('alla25cc5eaf5ce4d59b31a31240dbf956c', NULL, NULL, NULL, 'ALL', '通用', '医疗设备', '1', NULL, NULL, NULL, 6, 9, 4, 1, '{\"device\":{\"remark\":\"设备配置\",\"price\":{\"remark\":\"设备价格层面的配置\"},\"function\":{\"remark\":\"设备性能层面的配置,下面分别为不符合参数扣分、参数权重、品牌分权重\",\"negativeDeviation\":\"10\",\"positiveDeviation\":\"0\",\"deviateRatio\":\"0.7\",\"brandRatio\":\"0.3\"},\"afterSale\":{\"remark\":\"设备售后层面的配置,下面分别为符合质保期加分、额外质保期最多加分、额外质保期每个月加分、安装方式加分\",\"warrantyPeriod\":\"50\",\"notWarrantyPeriod\":\"0\",\"warrantyPeriodTop\":\"30\",\"warrantyPeriodAdd\":\"1\",\"installWay\":\"2\"},\"credit\":{\"remark\":\"设备信用层面的配置，下面分别是供应商优秀、良好、一般、较差、差、没有评价、违约、拉黑、弃标、自产、代理\",\"excellentEvaluate\":\"100\",\"goodEvaluate\":\"85\",\"commonEvaluate\":\"60\",\"poorEvaluate\":\"35\",\"badEvaluate\":\"0\",\"noEvaluate\":\"60\",\"breakContract\":\"10\",\"black\":\"20\",\"abandon\":\"5\",\"selfProduced\":\"5\",\"agent\":\"2\"}},\"project\":{\"remark\":\"项目自定义配置\",\"creadit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"national\":\"50\",\"provincial\":\"35\",\"local\":\"10\",\"excellent\":\"40\",\"good\":\"25\",\"ordinary\":\"10\",\"poor\":\"0\",\"none\":\"20\"},\"quality\":{\"remark\":\"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\"warrantyPeriod\":\"5\"},\"construction\":{\"remark\":\"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\"advance\":\"50\",\"punctual\":\"10\",\"timeweight\":\"0.8\",\"yes\":\"1\",\"no\":\"0\",\"managerweight\":\"0.2\"},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"registeredCapitalOne\":\"500\",\"registeredCapitalTwo\":\"1000\",\"registeredCapitalThree\":\"2000\",\"PeopleNumOne\":\"20\",\"PeopleNumTwo\":\"50\",\"PeopleNumThree\":\"100\",\"PeopleNumFour\":\"200\",\"FixedAssetsOne\":\"100\",\"FixedAssetsTwo\":\"300\",\"FixedAssetsThree\":\"600\",\"FixedAssetsFour\":\"1000\"}},\"service\":{\"remark\":\"服务配置\"}}', NULL, 'Y', 'N', '2020-04-21 10:31:28', '01d29be1f10d4931a57097a4119c6983', '邓涛', '2021-07-09 14:31:17', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('all11f2706865704786a2bba3121f17ad61', NULL, NULL, '', 'ALL', '通用', '设备方案', '1', NULL, NULL, NULL, 6, 7, 1, 2, '{\r\n    \"device\": {\r\n        \"remark\": \"设备配置\",\r\n        \"price\": {\r\n            \"remark\": \"设备价格层面的配置\"\r\n        },\r\n        \"function\": {\r\n            \"remark\": \"设备性能层面的配置,下面分别为不符合参数扣分、参数权重、品牌分权重\",\r\n            \"negativeDeviation\": \"20\",\r\n            \"positiveDeviation\": \"0\",\r\n            \"deviateRatio\": \"0.7\",\r\n            \"brandRatio\": \"0.3\"\r\n        },\r\n        \"afterSale\": {\r\n            \"remark\": \"设备售后层面的配置,下面分别为符合质保期加分、额外质保期最多加分、额外质保期每个月加分、安装方式加分\",\r\n            \"warrantyPeriod\": \"50\",\r\n            \"notWarrantyPeriod\": \"0\",   \r\n            \"warrantyPeriodTop\": \"30\",\r\n            \"warrantyPeriodAdd\": \"1\",\r\n            \"installWay\": \"2\"\r\n        },\r\n        \"credit\": {\r\n            \"remark\": \"设备信用层面的配置，下面分别是供应商优秀、良好、一般、较差、差、没有评价、违约、拉黑、弃标、自产、代理\",\r\n            \"excellentEvaluate\": \"100\",\r\n            \"goodEvaluate\": \"85\",\r\n            \"commonEvaluate\": \"60\",\r\n            \"poorEvaluate\": \"35\",\r\n            \"badEvaluate\": \"0\",\r\n            \"noEvaluate\": \"60\",\r\n            \"breakContract\": \"10\",\r\n            \"black\": \"20\",\r\n            \"abandon\": \"5\",\r\n            \"selfProduced\": \"10\",\r\n            \"agent\": \"5\"\r\n        }\r\n    },\r\n    \"project\": {\r\n        \"remark\": \"项目自定义配置\",\r\n        \"creadit\": {\r\n            \"remark\": \"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\r\n            \"national\": \"50\",\r\n            \"provincial\": \"35\",\r\n            \"local\": \"10\",\r\n            \"excellent\": \"40\",\r\n            \"good\": \"25\",\r\n            \"ordinary\": \"10\",\r\n            \"poor\": \"0\",\r\n            \"none\": \"20\"\r\n        },\r\n        \"quality\": {\r\n            \"remark\": \"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\r\n            \"warrantyPeriod\": \"5\"\r\n        },\r\n        \"construction\": {\r\n            \"remark\": \"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\r\n            \"advance\": \"50\",\r\n            \"punctual\": \"10\",\r\n            \"timeweight\": \"0.8\",\r\n            \"yes\": \"1\",\r\n            \"no\": \"0\",\r\n            \"managerweight\": \"0.2\"\r\n        },\r\n        \"strength\": {\r\n            \"remark\": \"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\r\n            \"registeredCapitalOne\": \"500\",\r\n            \"registeredCapitalTwo\": \"1000\",\r\n            \"registeredCapitalThree\": \"2000\",\r\n            \"PeopleNumOne\": \"20\",\r\n            \"PeopleNumTwo\": \"50\",\r\n            \"PeopleNumThree\": \"100\",\r\n            \"PeopleNumFour\": \"200\",\r\n            \"FixedAssetsOne\": \"100\",\r\n            \"FixedAssetsTwo\": \"300\",\r\n            \"FixedAssetsThree\": \"600\",\r\n            \"FixedAssetsFour\": \"1000\"\r\n        }\r\n    },\r\n    \"service\": {\r\n        \"remark\": \"服务配置\"\r\n    }\r\n}', NULL, NULL, NULL, '2020-03-06 17:03:21', NULL, NULL, '2020-03-06 17:03:27', NULL, NULL, '-1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('allb5ae18cdd5d64b709eaa28143e512761', NULL, NULL, NULL, 'ALL', '通用', '教学设备', '1', 0, 0, 0, 7, 5, 3, 1, '{\"device\":{\"remark\":\"设备配置\",\"price\":{\"remark\":\"设备价格层面的配置\"},\"function\":{\"remark\":\"设备性能层面的配置,下面分别为不符合参数扣分、参数权重、品牌分权重\",\"negativeDeviation\":\"10\",\"positiveDeviation\":\"0\",\"deviateRatio\":\"0.7\",\"brandRatio\":\"0.3\"},\"afterSale\":{\"remark\":\"设备售后层面的配置,下面分别为符合质保期加分、额外质保期最多加分、额外质保期每个月加分、安装方式加分\",\"warrantyPeriod\":\"50\",\"notWarrantyPeriod\":\"0\",\"warrantyPeriodTop\":\"30\",\"warrantyPeriodAdd\":\"1\",\"installWay\":\"2\"},\"credit\":{\"remark\":\"设备信用层面的配置，下面分别是供应商优秀、良好、一般、较差、差、没有评价、违约、拉黑、弃标、自产、代理\",\"excellentEvaluate\":\"100\",\"goodEvaluate\":\"85\",\"commonEvaluate\":\"60\",\"poorEvaluate\":\"35\",\"badEvaluate\":\"0\",\"noEvaluate\":\"60\",\"breakContract\":\"10\",\"black\":\"20\",\"abandon\":\"5\",\"selfProduced\":\"5\",\"agent\":\"2\"}},\"project\":{\"remark\":\"项目自定义配置\",\"creadit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"national\":\"50\",\"provincial\":\"35\",\"local\":\"10\",\"excellent\":\"40\",\"good\":\"25\",\"ordinary\":\"10\",\"poor\":\"0\",\"none\":\"20\"},\"quality\":{\"remark\":\"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\"warrantyPeriod\":\"5\"},\"construction\":{\"remark\":\"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\"advance\":\"50\",\"punctual\":\"10\",\"timeweight\":\"0.8\",\"yes\":\"1\",\"no\":\"0\",\"managerweight\":\"0.2\"},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"registeredCapitalOne\":\"500\",\"registeredCapitalTwo\":\"1000\",\"registeredCapitalThree\":\"2000\",\"PeopleNumOne\":\"20\",\"PeopleNumTwo\":\"50\",\"PeopleNumThree\":\"100\",\"PeopleNumFour\":\"200\",\"FixedAssetsOne\":\"100\",\"FixedAssetsTwo\":\"300\",\"FixedAssetsThree\":\"600\",\"FixedAssetsFour\":\"1000\"}},\"service\":{\"remark\":\"服务配置\"}}', NULL, 'Y', 'N', '2020-04-21 10:35:24', '01d29be1f10d4931a57097a4119c6983', '邓涛', '2021-07-09 14:31:32', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('allb5ae18cdd5d64b709eaa28143e52221', NULL, NULL, NULL, 'ALL', '通用', '商务服务', '3', 5, 3, 0, 9, 0, 0, 1, '{\"service\":{\"remark\":\"项目自定义配置是否启用参数userScore（0启用；1不启用）\",\"price\":{\"remark\":\"价格评分自定义配置\",\"userScore\":1},\"credit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"userScoreByWin\":1,\"national\":50,\"provincial\":\"30\",\"local\":10,\"userScoreByEvaluate\":1,\"excellent\":40,\"good\":25,\"ordinary\":10,\"poor\":0,\"none\":\"15\"},\"quality\":{\"remark\":\"服务质量层面的配置,下面分别为负偏离参数扣分、正偏离参数加分\",\"userScore\":1,\"negativeDeviation\":\"10\",\"positiveDeviation\":\"0\"},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"userScoreByRegister\":1,\"registeredCapitalOne\":500,\"registeredCapitalTwo\":1000,\"registeredCapitalThree\":2000,\"userScoreByPeopleNum\":1,\"PeopleNumOne\":20,\"PeopleNumTwo\":50,\"PeopleNumThree\":100,\"PeopleNumFour\":200,\"userScoreByFixedAssets\":\"0\",\"FixedAssetsOne\":100,\"FixedAssetsTwo\":300,\"FixedAssetsThree\":600,\"FixedAssetsFour\":1000,\"userScoreByQualification\":\"0\"}}}', NULL, 'Y', 'N', '2020-04-21 10:35:24', '01d29be1f10d4931a57097a4119c6983', '邓涛', '2021-07-09 14:29:32', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('allc000afa9c64648299d44087be37fe8aa', NULL, NULL, '', 'ALL', '通用', '行政后勤设备', '1', NULL, NULL, NULL, 9, 7, 3, 1, '{\r\n    \"device\": {\r\n        \"remark\": \"设备配置\",\r\n        \"price\": {\r\n            \"remark\": \"设备价格层面的配置\"\r\n        },\r\n        \"function\": {\r\n            \"remark\": \"设备性能层面的配置,下面分别为不符合参数扣分、参数权重、品牌分权重\",\r\n            \"negativeDeviation\": \"20\",\r\n            \"positiveDeviation\": \"0\",\r\n            \"deviateRatio\": \"0.7\",\r\n            \"brandRatio\": \"0.3\"\r\n        },\r\n        \"afterSale\": {\r\n            \"remark\": \"设备售后层面的配置,下面分别为符合质保期加分、额外质保期最多加分、额外质保期每个月加分、安装方式加分\",\r\n            \"warrantyPeriod\": \"50\",\r\n            \"notWarrantyPeriod\": \"0\",   \r\n            \"warrantyPeriodTop\": \"30\",\r\n            \"warrantyPeriodAdd\": \"1\",\r\n            \"installWay\": \"2\"\r\n        },\r\n        \"credit\": {\r\n            \"remark\": \"设备信用层面的配置，下面分别是供应商优秀、良好、一般、较差、差、没有评价、违约、拉黑、弃标、自产、代理\",\r\n            \"excellentEvaluate\": \"100\",\r\n            \"goodEvaluate\": \"85\",\r\n            \"commonEvaluate\": \"60\",\r\n            \"poorEvaluate\": \"35\",\r\n            \"badEvaluate\": \"0\",\r\n            \"noEvaluate\": \"60\",\r\n            \"breakContract\": \"10\",\r\n            \"black\": \"20\",\r\n            \"abandon\": \"5\",\r\n            \"selfProduced\": \"10\",\r\n            \"agent\": \"5\"\r\n        }\r\n    },\r\n    \"project\": {\r\n        \"remark\": \"项目自定义配置\",\r\n        \"creadit\": {\r\n            \"remark\": \"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\r\n            \"national\": \"50\",\r\n            \"provincial\": \"35\",\r\n            \"local\": \"10\",\r\n            \"excellent\": \"40\",\r\n            \"good\": \"25\",\r\n            \"ordinary\": \"10\",\r\n            \"poor\": \"0\",\r\n            \"none\": \"20\"\r\n        },\r\n        \"quality\": {\r\n            \"remark\": \"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\r\n            \"warrantyPeriod\": \"5\"\r\n        },\r\n        \"construction\": {\r\n            \"remark\": \"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\r\n            \"advance\": \"50\",\r\n            \"punctual\": \"10\",\r\n            \"timeweight\": \"0.8\",\r\n            \"yes\": \"1\",\r\n            \"no\": \"0\",\r\n            \"managerweight\": \"0.2\"\r\n        },\r\n        \"strength\": {\r\n            \"remark\": \"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\r\n            \"registeredCapitalOne\": \"500\",\r\n            \"registeredCapitalTwo\": \"1000\",\r\n            \"registeredCapitalThree\": \"2000\",\r\n            \"PeopleNumOne\": \"20\",\r\n            \"PeopleNumTwo\": \"50\",\r\n            \"PeopleNumThree\": \"100\",\r\n            \"PeopleNumFour\": \"200\",\r\n            \"FixedAssetsOne\": \"100\",\r\n            \"FixedAssetsTwo\": \"300\",\r\n            \"FixedAssetsThree\": \"600\",\r\n            \"FixedAssetsFour\": \"1000\"\r\n        }\r\n    },\r\n    \"service\": {\r\n        \"remark\": \"服务配置\"\r\n    }\r\n}', NULL, 'N', 'Y', '2020-03-18 17:02:53', '2267a28b2199467681f3921a4592233c', '测试用户1', '2020-04-21 09:43:15', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '-1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('allc612d48122254204bf0e75ed4a847709', NULL, NULL, NULL, 'ALL', '通用', '翻译服务', '3', 5, 3, 0, 9, 0, 0, 1, '{\"service\":{\"remark\":\"项目自定义配置是否启用参数userScore（0启用；1不启用）\",\"price\":{\"remark\":\"价格评分自定义配置\",\"userScore\":1},\"credit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"userScoreByWin\":1,\"national\":50,\"provincial\":30,\"local\":10,\"userScoreByEvaluate\":1,\"excellent\":40,\"good\":25,\"ordinary\":10,\"poor\":0,\"none\":15},\"quality\":{\"remark\":\"服务质量层面的配置,下面分别为负偏离参数扣分、正偏离参数加分\",\"userScore\":1,\"negativeDeviation\":10,\"positiveDeviation\":0},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"userScoreByRegister\":1,\"registeredCapitalOne\":500,\"registeredCapitalTwo\":1000,\"registeredCapitalThree\":2000,\"userScoreByPeopleNum\":1,\"PeopleNumOne\":20,\"PeopleNumTwo\":50,\"PeopleNumThree\":100,\"PeopleNumFour\":200,\"userScoreByFixedAssets\":1,\"FixedAssetsOne\":100,\"FixedAssetsTwo\":300,\"FixedAssetsThree\":600,\"FixedAssetsFour\":1000,\"userScoreByQualification\":1}}}', NULL, 'Y', 'N', '2021-07-09 12:43:20', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '2021-07-09 14:29:23', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('alle1a637cb6a444e7fb2e6e773a1c74369', NULL, NULL, '', 'ALL', '通用', '临床仪器', '1', NULL, NULL, NULL, 5, 8, 2, 1, '{\r\n    \"device\": {\r\n        \"remark\": \"设备配置\",\r\n        \"price\": {\r\n            \"remark\": \"设备价格层面的配置\"\r\n        },\r\n        \"function\": {\r\n            \"remark\": \"设备性能层面的配置,下面分别为不符合参数扣分、参数权重、品牌分权重\",\r\n            \"negativeDeviation\": \"20\",\r\n            \"positiveDeviation\": \"0\",\r\n            \"deviateRatio\": \"0.7\",\r\n            \"brandRatio\": \"0.3\"\r\n        },\r\n        \"afterSale\": {\r\n            \"remark\": \"设备售后层面的配置,下面分别为符合质保期加分、额外质保期最多加分、额外质保期每个月加分、安装方式加分\",\r\n            \"warrantyPeriod\": \"50\",\r\n            \"notWarrantyPeriod\": \"0\",   \r\n            \"warrantyPeriodTop\": \"30\",\r\n            \"warrantyPeriodAdd\": \"1\",\r\n            \"installWay\": \"2\"\r\n        },\r\n        \"credit\": {\r\n            \"remark\": \"设备信用层面的配置，下面分别是供应商优秀、良好、一般、较差、差、没有评价、违约、拉黑、弃标、自产、代理\",\r\n            \"excellentEvaluate\": \"100\",\r\n            \"goodEvaluate\": \"85\",\r\n            \"commonEvaluate\": \"60\",\r\n            \"poorEvaluate\": \"35\",\r\n            \"badEvaluate\": \"0\",\r\n            \"noEvaluate\": \"60\",\r\n            \"breakContract\": \"10\",\r\n            \"black\": \"20\",\r\n            \"abandon\": \"5\",\r\n            \"selfProduced\": \"10\",\r\n            \"agent\": \"5\"\r\n        }\r\n    },\r\n    \"project\": {\r\n        \"remark\": \"项目自定义配置\",\r\n        \"creadit\": {\r\n            \"remark\": \"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\r\n            \"national\": \"50\",\r\n            \"provincial\": \"35\",\r\n            \"local\": \"10\",\r\n            \"excellent\": \"40\",\r\n            \"good\": \"25\",\r\n            \"ordinary\": \"10\",\r\n            \"poor\": \"0\",\r\n            \"none\": \"20\"\r\n        },\r\n        \"quality\": {\r\n            \"remark\": \"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\r\n            \"warrantyPeriod\": \"5\"\r\n        },\r\n        \"construction\": {\r\n            \"remark\": \"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\r\n            \"advance\": \"50\",\r\n            \"punctual\": \"10\",\r\n            \"timeweight\": \"0.8\",\r\n            \"yes\": \"1\",\r\n            \"no\": \"0\",\r\n            \"managerweight\": \"0.2\"\r\n        },\r\n        \"strength\": {\r\n            \"remark\": \"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\r\n            \"registeredCapitalOne\": \"500\",\r\n            \"registeredCapitalTwo\": \"1000\",\r\n            \"registeredCapitalThree\": \"2000\",\r\n            \"PeopleNumOne\": \"20\",\r\n            \"PeopleNumTwo\": \"50\",\r\n            \"PeopleNumThree\": \"100\",\r\n            \"PeopleNumFour\": \"200\",\r\n            \"FixedAssetsOne\": \"100\",\r\n            \"FixedAssetsTwo\": \"300\",\r\n            \"FixedAssetsThree\": \"600\",\r\n            \"FixedAssetsFour\": \"1000\"\r\n        }\r\n    },\r\n    \"service\": {\r\n        \"remark\": \"服务配置\"\r\n    }\r\n}', NULL, 'N', 'Y', '2020-03-18 17:03:41', '2267a28b2199467681f3921a4592233c', '测试用户1', '2020-04-21 09:43:23', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '-1', NULL);
        INSERT INTO `zc_ratio`(`ZC_RATIO_ID`, `RATIO_TYPE`, `RATIO_STATUS`, `ZC_PROJECT_ID`, `COLLEGE_ID`, `COLLEGE_NAME`, `RATIO_NAME`, `PROJECT_TYPE`, `QUALITY_RATIO`, `STRENGTH_RATIO`, `CONSTRUCTION_RATIO`, `PRICE_RATIO`, `PERFORMANCE_RATIO`, `AFTERSALE_RATIO`, `CREDIT_RATIO`, `JSON_CONFIG`, `REMARK`, `IS_DX_CENTER`, `IS_DX_COLLEGE`, `CREATE_TIME`, `CREATE_USERID`, `CREATE_USERNAME`, `LAST_UPDATE_TIME`, `LAST_UPDATE_USERID`, `LAST_UPDATE_USERNAME`, `IS_DELETE`, `REVISION`) VALUES ('alle6b1689c98da4e1ca74142afd8cec102', NULL, NULL, NULL, 'ALL', '通用', '其他工程', '2', 5, 2, 1, 8, 0, 0, 4, '{\"project\":{\"remark\":\"项目自定义配置\",\"price\":{\"remark\":\"价格评分自定义配置\",\"userScore\":1},\"credit\":{\"remark\":\"信用评分自定义配置，下面分别为国家级加分，省级加分，地方级加分，优秀评论加分，良好评论加分，一般评论加分，差评论得分，无评论得分\",\"userScoreByWin\":1,\"national\":50,\"provincial\":35,\"local\":10,\"userScoreByEvaluate\":1,\"excellent\":40,\"good\":25,\"ordinary\":10,\"poor\":0,\"none\":20},\"quality\":{\"remark\":\"质量保障自定义配置，warrantyPeriod为保修期限每年加分\",\"userScoreByDeposit\":1,\"userScoreByWarranty\":1,\"warrantyPeriod\":5},\"construction\":{\"remark\":\"施工评分自定义配置，下面分别为工期提前加分，准时得分，工期权重，项目经理到位得分，未到位得分，项目经理权重\",\"userScoreByPunctual\":1,\"advance\":50,\"punctual\":10,\"timeweight\":0.8,\"userScoreByOnSite\":1,\"yes\":\"1\",\"no\":0,\"managerweight\":0.2},\"strength\":{\"remark\":\"资质实力自定义配置，registeredCapitalOne代表注册资金级别1（小于此值为级别1），PeopleNumLevelOne代表公司人数级别1（小于此值为级别1），FixedAssetsLevelOne代表固定资产级别1（小于此值为级别1）\",\"userScoreByRegister\":1,\"registeredCapitalOne\":500,\"registeredCapitalTwo\":1000,\"registeredCapitalThree\":2000,\"userScoreByPeopleNum\":1,\"PeopleNumOne\":20,\"PeopleNumTwo\":50,\"PeopleNumThree\":100,\"PeopleNumFour\":200,\"userScoreByQualification\":1,\"FixedAssetsOne\":100,\"FixedAssetsTwo\":300,\"FixedAssetsThree\":600,\"FixedAssetsFour\":1000,\"userScoreByFixedAssets\":1}}}', NULL, 'Y', 'N', '2020-04-19 09:36:51', 'e4577af2be9d45d8993ddbad74160dd3', '林明河', '2021-07-09 12:21:01', 'ebb18c8278354411b0ff3409d73eb0c9', '吴东梅', '-1', NULL);

快速生成

INSERT INTO `zc_ratio` (
SELECT
	substring( MD5( RAND( ) ), 1, 20 ) AS `ZC_RATIO_ID`,
	`RATIO_TYPE`,
	`RATIO_STATUS`,
	`ZC_PROJECT_ID`,
	'ST120' AS `COLLEGE_ID`, // 这里替换成目标大学ID
	'汕头大学医学院第二附属医院' AS `COLLEGE_NAME`, //这里替换成目标大学名称
	`RATIO_NAME`,
	`PROJECT_TYPE`,
	`QUALITY_RATIO`,
	`STRENGTH_RATIO`,
	`CONSTRUCTION_RATIO`,
	`PRICE_RATIO`,
	`PERFORMANCE_RATIO`,
	`AFTERSALE_RATIO`,
	`CREDIT_RATIO`,
	`JSON_CONFIG`,
	`REMARK`,
	`IS_DX_CENTER`,
	`IS_DX_COLLEGE`,
		now( ) AS CREATE_TIME,
	'system' AS CREATE_USERID,
	'管理员' AS CREATE_USERNAME,
	now( ) AS LAST_UPDATE_TIME,
	'system' AS LAST_UPDATE_USERID,
	'管理员' AS LAST_UPDATE_USERNAME,
	`IS_DELETE`,
	`REVISION` 
FROM
	zc_ratio 
WHERE
	COLLEGE_ID = 'ALL' 
	)

六、交换

相关表：

• co_user_role 用户角色关系表
• co_user_department 用户部门关系表
• co_role 角色表
• bg_department 部门表
• bg_department_type 部门类型表
• co_college_info 部门类型表

因为调用快采及其他系统需要以用户信息统一为先决条件，因此，至少这三种表得配置交换

重置交换位SQL

UPDATE co_role SET IS_DX_CENTER='N', LAST_UPDATE_TIME=now() WHERE CO_COLLEGE_ID='ST120' // 这里替换成目标大学ID

UPDATE co_user_department SET IS_DX_CENTER='N', LAST_UPDATE_TIME=now() WHERE COLLEGE_ID='ST120' // 这里替换成目标大学ID

UPDATE co_user_role SET IS_DX_CENTER='N', LAST_UPDATE_TIME=now() WHERE COLLEGE_ID='ST120' // 这里替换成目标大学ID

UPDATE bg_department SET IS_DX_CENTER='N', LAST_UPDATE_TIME=now() WHERE COLLEGE_ID='ST120' // 这里替换成目标大学ID

UPDATE bg_department_type SET IS_DX_CENTER='N', LAST_UPDATE_TIME=now() WHERE COLLEGE_ID='ST120' // 这里替换成目标大学ID

更新交换地址sql

UPDATE co_college_info SET DXSERVICE_PATH='https://cu.easyjcx.com/college', LAST_UPDATE_TIME=now() WHERE COLLEGE_ID='SXXRMYY29' // 这里替换成目标大学ID

TIP

记得刷新高校信息redis缓存