ALTER TABLE `risk_se_user` ADD COLUMN `companyPhone` varchar(255) NULL DEFAULT NULL COMMENT '企业联系方式' AFTER `phone`; UPDATE `config_materialformattrtemplate` SET `script` = 'function clickA88(value) {\r\n if(value == \"1\") {\r\n $(\"#A3-box\").addClass(\"hide\");\r\n $(\"#A98-box\").addClass(\"hide\");\r\n $(\"#A89-box\").addClass(\"hide\");\r\n $(\"#A106-box\").addClass(\"hide\");\r\n $(\"#A3-h\").val(\'default-value\');\r\n $(\"#A98-h\").val(\'default-value\');\r\n $(\"#A89-h\").val(\'default-value\'); \r\n $(\"#A106-h\").val(\'default-value\'); \r\n } else if(value == \"2\"){\r\n $(\"#A3-box\").addClass(\"hide\");\r\n $(\"#A98-box\").removeClass(\"hide\");\r\n $(\"#A89-box\").addClass(\"hide\");\r\n $(\"#A106-box\").addClass(\"hide\");\r\n $(\"#A3-h\").val(\'default-value\');\r\n $(\"#A89-h\").val(\'default-value\');\r\n $(\"#A106-h\").val(\'default-value\'); \r\n if ($(\"#A98-h\").val()==\'default-value\'){\r\n $(\"#A98-h\").val(\'\');\r\n }\r\n } else if(value == \"3\") {\r\n $(\"#A3-box\").addClass(\"hide\");\r\n $(\"#A89-box\").removeClass(\"hide\");\r\n $(\"#A98-box\").addClass(\"hide\");\r\n $(\"#A106-box\").addClass(\"hide\");\r\n $(\"#A3-h\").val(\'default-value\');\r\n $(\"#A98-h\").val(\'default-value\');\r\n $(\"#A106-h\").val(\'default-value\'); \r\n if ($(\"#A89-h\").val()==\'default-value\'){\r\n $(\"#A89-h\").val(\'\');\r\n }\r\n } else if(value == \"4\") {\r\n $(\"#A3-box\").removeClass(\"hide\");\r\n $(\"#A89-box\").addClass(\"hide\");\r\n $(\"#A98-box\").addClass(\"hide\");\r\n $(\"#A106-box\").addClass(\"hide\");\r\n $(\"#A98-h\").val(\'default-value\');\r\n $(\"#A89-h\").val(\'default-value\');\r\n $(\"#A106-h\").val(\'default-value\'); \r\n if ($(\"#A3-h\").val()==\'default-value\'){\r\n $(\"#A3-h\").val(\'\');\r\n }\r\n } else if(value == \"5\") {\r\n $(\"#A3-box\").addClass(\"hide\");\r\n $(\"#A89-box\").addClass(\"hide\");\r\n $(\"#A98-box\").addClass(\"hide\");\r\n $(\"#A106-box\").removeClass(\"hide\");\r\n $(\"#A98-h\").val(\'default-value\');\r\n $(\"#A89-h\").val(\'default-value\');\r\n $(\"#A3-h\").val(\'default-value\');\r\n if ($(\"#A106-h\").val()==\'default-value\'){\r\n $(\"#A106-h\").val(\'\');\r\n }\r\n } \r\n }' WHERE `attrCode` = 'A88'; INSERT INTO `config_materialformattrtemplate`(`createOn`, `updateOn`, `optionType`, `attrCode`, `attrName`, `events`, `isPageHidden`, `isRequired`, `script`, `seq`, `tips`, `type`, `mainEle`, `menuTemplate_id`, `activityType`, `supportProvince`, `maxFileSize`, `locked`) VALUES ('2016-12-22 21:26:48', '2016-12-22 21:26:48', NULL, 'A106', '组织单位的资质证明文件', '', '0', b'1', '', 13, '需加盖公章', 'pic', '0', 1, NULL, NULL, NULL, NULL); update config_systemconfig set sysvalue = 'http://59.110.22.100:8099/document/indexOut?document_id=24' where syskey = 'cbdw_helpdoc_url'; update config_systemconfig set sysvalue = 'http://59.110.22.100:8099/document/indexOut?document_id=8' where syskey = 'zfdw_helpdoc_url'; update config_materialformattrtemplate set isRequired = 0 where attrCode = 'Z01';