text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : UCKeFu
  Source Server Version : 50717
  Source Host           : localhost:3306
  Source Database       : uckefu
  
  Target Server Type    : MYSQL
  Target Server Version : 50717
  File Encoding         : 65001
  
  Date: 2018-11-29 22:00:00
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for `uk_templet`
  -- ----------------------------
  DROP TABLE IF EXISTS `uk_templet`;
  CREATE TABLE `uk_templet` (
    `ID` varchar(32) NOT NULL COMMENT '主键ID',
    `NAME` varchar(255) DEFAULT NULL COMMENT '模板名称',
    `DESCRIPTION` longtext COMMENT '描述',
    `CODE` varchar(255) DEFAULT NULL COMMENT '代码',
    `GROUPID` varchar(255) DEFAULT NULL COMMENT '组ID',
    `CREATETIME` datetime DEFAULT NULL COMMENT '创建时间',
    `USERID` varchar(255) DEFAULT NULL COMMENT '创建人ID',
    `TEMPLETTITLE` varchar(500) DEFAULT NULL COMMENT '模板标题内容',
    `TEMPLETTEXT` longtext COMMENT '模板内容',
    `TEMPLETTYPE` varchar(255) DEFAULT NULL COMMENT '模板类型',
    `ORGI` varchar(32) DEFAULT NULL COMMENT '租户ID',
    `ICONSTR` varchar(255) DEFAULT NULL COMMENT '自定义样式',
    `MEMO` varchar(255) DEFAULT NULL COMMENT '备注',
    `ORDERINDEX` int(11) DEFAULT NULL COMMENT '排序位置',
    `TYPEID` varchar(32) DEFAULT NULL COMMENT '分类ID',
    `SELDATA` tinyint(4) DEFAULT NULL COMMENT '启用外键',
    `layoutcols` int(11) DEFAULT '0' COMMENT '布局列数',
    `datatype` varchar(32) DEFAULT NULL COMMENT '数据类型',
    `charttype` varchar(32) DEFAULT NULL COMMENT '图表类型',
    PRIMARY KEY (`ID`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='模板表';
  
  -- ----------------------------
  -- Records of uk_templet
  -- ----------------------------
  INSERT INTO `uk_templet` VALUES ('4028811b618d0dca01618f99e056035c', '四列布局', null, 'layout', null, '2018-02-13 22:38:01', null, null, '<div class=\"layui-col-md3 ukefu-col\" data-colspan=\"3\" data-index=\"1\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 1>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>\r\n<div class=\"layui-col-md3 ukefu-col\" data-colspan=\"3\" data-index=\"2\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 2>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>\r\n<div class=\"layui-col-md3 ukefu-col\" data-colspan=\"3\" data-index=\"3\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 3>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>\r\n<div class=\"layui-col-md3 ukefu-col\" data-colspan=\"3\" data-index=\"4\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 4>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>', '4028811b618d0dca01618d5a5fd10349', 'ukewo', '/images/design/four.png', null, null, null, null, '4', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b618d0dca01618f99f175035d', '三列布局', null, 'layout', null, '2018-02-13 22:38:06', null, null, '<div class=\"layui-col-md4 ukefu-col\" data-colspan=\"4\" data-index=\"1\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 1>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>\r\n<div class=\"layui-col-md4 ukefu-col\" data-colspan=\"4\" data-index=\"2\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 2>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>\r\n<div class=\"layui-col-md4 ukefu-col\" data-colspan=\"4\" data-index=\"3\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 3>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>', '4028811b618d0dca01618d5a5fd10349', 'ukewo', '/images/design/three.png', null, null, null, null, '3', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b618d0dca01618f9a08c5035e', '两列布局', null, 'layout', null, '2018-02-13 22:38:12', null, null, '<div class=\"layui-col-md6 ukefu-col\" data-colspan=\"6\" data-index=\"1\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 1>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>\r\n<div class=\"layui-col-md6 ukefu-col\" data-colspan=\"6\" data-index=\"2\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 2>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>', '4028811b618d0dca01618d5a5fd10349', 'ukewo', '/images/design/two.png', null, null, null, null, '2', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b618d0dca01618f9a1aee035f', '一列布局', null, 'layout', null, '2018-02-13 22:38:16', null, null, '<div class=\"layui-col-md12 ukefu-col\" data-colspan=\"12\" data-index=\"1\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 1>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>', '4028811b618d0dca01618d5a5fd10349', 'ukewo', '/images/design/one.png', null, null, null, null, '1', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191e4721c033d', '数据表', null, 'report', null, '2018-02-14 09:18:43', null, null, '<#if reportData??>\r\n<table class=\"layui-table ukefu-report\">\r\n  <thead>\r\n	<#if reportData?? && reportData.col?? && reportData.col.title??>\r\n	  <#list reportData.col.title as tlist>\r\n		<tr class=\"sortableTr\">\r\n		  <#if reportData.col.title?size gt 1 && tlist_index==0 && reportData.row.title?size gt 0>\r\n			<td align=\"center\" colspan=\"${reportData.row.title?size}\" rowspan=\"${reportData.col.title?size-1}\" class=\"s_blue\"></td>\r\n		  </#if>\r\n		  <#if (tlist_index+1)==reportData.col.title?size && reportData.row?? && reportData.row.firstTitle??>\r\n			<#list reportData.row.firstTitle as first>\r\n			  <td align=\"center\" data-title=\"${first.name?url}\" data-flag=\"dim\">${first.rename!first.name!\'\'}				\r\n			</#list>\r\n		  </#if>\r\n		  <#if tlist??>\r\n			<#list tlist as tl>\r\n			  <td align=\"center\" <#if tl.leveltype?? && tl.leveltype==\"newcol\">rowspan=\"${reportData.col.title?size}\"</#if>colspan=\"${tl.colspan}\" > ${tl.rename!tl.name!\"\"}\r\n				</td>\r\n			</#list>\r\n			</#if>\r\n	</tr>\r\n	</#list>\r\n	</#if>\r\n  </thead>\r\n  <tbody>\r\n	<#if reportData?? && reportData.data??>\r\n	  <#list reportData.data as values>\r\n		<tr class=\"rowcell\">\r\n		  <#if reportData.row?? && reportData.row.title?? && reportData.row.title?size gt 0>\r\n			<#list reportData.row.title as tl>\r\n			  <#assign rows=0>\r\n				<#list tl as title>\r\n				  <#if title??>\r\n					<#if rows==values_index && title.name !=\"TOTAL_TEMP\">\r\n					  	<#if title.leveltype !=\"newrow_extend_sum\">\r\n						<td nowrap=\"nowrap\" align=\"center\" class=\"blue_k <#if title.total == true>total</#if>\" rowspan=\"${title.rowspan!\'0\'}\" <#if title.colspan gt 1>colspan=\"${title.colspan}\"</#if>>\r\n						  ${title.formatName!\'\'}</td>\r\n						</#if>\r\n						<#if title.valueData??>\r\n						  <#list title.valueData as value>\r\n							<#if value.merge==false>\r\n							  <td rowspan=\"${value.rowspan}\" colspan=\"${value.colspan}\" align=\"center\" class=\"measure ${value.vtclass!\'\'}\" nowrap=\"nowrap\" <#if value.cellmergeid??>data-cellmerge=\"${value.cellmergeid}\"</#if>>\r\n							${value.valueStyle!value.foramatValue!\'\'}</td>\r\n							</#if>\r\n							</#list>\r\n						  </#if>\r\n					  </#if>\r\n					  <#assign rows=rows + title.rowspan>\r\n				  </#if>\r\n			</#list>\r\n	</#list>\r\n	<#else>\r\n	  <#list values as value>\r\n		<td class=\"row \" style=\"text-align: right;<#if value.valueType?? && value.valueType == \'total\'>background-color:#c5daed;</#if>\">\r\n		  ${value.valueStyle!value.foramatValue!\'\'}</td>\r\n	  </#list>\r\n	  </#if>\r\n	  </tr>\r\n	  </#list>\r\n	  </#if>\r\n  </tbody>\r\n</table>\r\n<#if reportModel?? && reportModel.isloadfulldata == \'true\'>\r\n<#if reportData?? && reportData.total gt reportData.pageSize>\r\n<div class=\"row\" style=\"padding:5px;\">\r\n	<div class=\"col-lg-12\" id=\"page_${reportModel.id!\'\'}\" style=\"text-align:center;\"></div>\r\n</div>\r\n</#if>\r\n<script>\r\n	layui.use([\'laypage\', \'layer\',\'form\'], function(){\r\n		  var laypage = layui.laypage\r\n		  ,layer = layui.layer;\r\n		  laypage.render({\r\n			  elem:\'page_${reportModel.id!\'\'}\'\r\n				,count: <#if reportData??>${reportData.total}<#else>0</#if> \r\n				,curr:<#if reportData??>${reportData.page}<#else>0</#if>\r\n				,groups: 5 \r\n				,limit:<#if reportData?? && reportData.pageSize gt 0>${reportData.pageSize}<#else>20</#if>\r\n				,jump:function(data , first){\r\n					if(!first){\r\n						loadURL(\"/apps/report/design/getelement.html?id=<#if reportModel??>${reportModel.id!\'\'}</#if>&p=\"+data.curr,\"#${reportModel.id!\'\'}\");\r\n					}\r\n				}\r\n		   });\r\n		});\r\n</script>\r\n</#if>\r\n<#else>\r\n<div class=\"layui-form\">\r\n  <table class=\"layui-table\">\r\n    <thead>\r\n      <tr><th>标题一</th><th>标题二</th><th>标题三</th></tr> \r\n    </thead>\r\n    <tbody>\r\n      <tr><td>样例数据</td><td>样例数据</td><td>样例数据</td>\r\n      </tr>\r\n      <tr><td>样例数据</td><td>样例数据</td><td>样例数据</td></tr>\r\n      <tr><td>样例数据</td><td>样例数据</td><td>样例数据</td></tr>\r\n    </tbody>\r\n  </table>\r\n</div>\r\n</#if>', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/table.png', null, null, null, null, '0', 'simple', null);
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191e76714033e', '金字塔图', null, 'report', null, '2018-02-14 09:21:57', null, null, '	<script>\r\n	<#if reportData??>\r\n	var data_${element.mid!\'\'} = [];\r\n		<#if reportData.row??>\r\n			<#list reportData.row.title as title>\r\n				<#if (title_index+1) == reportData.row.title?size>\r\n					<#list title as rowtl>\r\n						var obj_${element.mid!\'\'} = new Object();\r\n						obj_${element.mid!\'\'}[\"_name\"] = \"${rowtl.rename!rowtl.name!\'\'}\";\r\n						<#if reportData.col??>\r\n						<#list reportData.col.title as coltlist>\r\n							<#list coltlist as coltl>\r\n								<#if reportData?? && reportData.data??>\r\n									<#list reportData.data as values>\r\n										<#if rowtl_index == values_index>\r\n											<#list values as val>	\r\n												<#if coltl_index == val_index && val_index == 0>\r\n													obj_${element.mid!\'\'}[\'key\'] = ${val.valueStyle!val.foramatValue!\'\'}\r\n												</#if>\r\n												<#if coltl_index == val_index && val_index == 1>\r\n													obj_${element.mid!\'\'}[\'value\'] = ${val.valueStyle!val.foramatValue!\'\'}\r\n												</#if>\r\n											</#list>\r\n										</#if>\r\n									</#list>\r\n								</#if>\r\n							</#list>\r\n						</#list>	\r\n						</#if>\r\n						data_${element.mid!\'\'}.push(obj_${element.mid!\'\'})						\r\n					</#list>			\r\n				</#if>\r\n			</#list>\r\n		</#if>\r\n		<#else>\r\n		const data_${element.mid!\'\'} = [\r\n					{ key: \'浏览网站\', value: 50000 },\r\n					{ key: \'放入购物车\', value: 35000 },\r\n					{ key: \'生成订单\', value: 25000 },\r\n					{ key: \'支付订单\', value: 15000 },\r\n					{ key: \'完成交易\', value: 8000 }\r\n				  ];		\r\n		</#if>	\r\n	  const dv_${element.mid!\'\'} = data_${element.mid!\'\'};\r\n	var json_${element.mid!\'\'} =  $.parseJSON( $(\"#json_${element.mid!\'\'}\").text() );\r\n	  $(\"#json_${element.mid!\'\'}\").remove();\r\n	  ChartAction.renderChart(\'${element.mid!\'\'}\',dv_${element.mid!\'\'},json_${element.mid!\'\'})\r\n	</script>\r\n', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/jzt.png', null, null, null, null, '0', null, 'pyramid');
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191e7c554033f', '地图', null, 'report', null, '2018-02-14 09:22:21', null, null, '	<script>\r\n	<#if reportData??>\r\n	var data_${element.mid!\'\'} = [];\r\n	<#if reportData.row??>\r\n		<#list reportData.row.title as title>\r\n			<#if (title_index+1) == reportData.row.title?size>\r\n				<#list title as rowtl>	\r\n					var obj_${element.mid!\'\'} = new Object();\r\n					obj_${element.mid!\'\'}[\"key\"] = \'${rowtl.rename!rowtl.name!\'\'}\';\r\n					<#if reportData.col??>\r\n						<#list reportData.col.title as coltlist>\r\n							<#list coltlist as coltl>\r\n								<#if coltl_index == 0>	\r\n									<#list reportData.data as values>\r\n										<#if rowtl_index == values_index>\r\n											<#list values as val>	\r\n												<#if coltl_index == 0>\r\n													obj_${element.mid!\'\'}[\"value\"] = ${val.valueStyle!val.foramatValue!\'\'}\r\n												</#if>\r\n											</#list>\r\n										</#if>\r\n									</#list>									\r\n								</#if>																			\r\n							</#list>\r\n						</#list>\r\n					</#if>	\r\n					data_${element.mid!\'\'}.push(obj_${element.mid!\'\'});		\r\n				</#list>										\r\n			</#if>\r\n		</#list>\r\n	</#if>		\r\n	</#if>	\r\n	let func_${element.mid!\'\'} = function(geoJson){\r\n	<#if !reportData??>\r\n		const data1_${element.mid!\'\'} = [];\r\n		  for (let i = 0; i < geoJson.length; i++) {\r\n	  	      let name = geoJson[i].properties.name;\r\n	  	      data1_${element.mid!\'\'}.push({\r\n	  	        key: name,\r\n	  	        value: Math.round(Math.random() * 1000),\r\n	  	      });\r\n	  	    }\r\n	<#else>\r\n		const data1_${element.mid!\'\'} = [];\r\n		for (let i = 0; i < geoJson.length; i++) {\r\n			let name = geoJson[i].properties.name;\r\n			let value = 0;\r\n			for (let j = 0; j < data_${element.mid!\'\'}.length;j++) {				  	      \r\n			  let name2 = data_${element.mid!\'\'}[j][\"key\"];\r\n			  if(name == name2){\r\n				value = data_${element.mid!\'\'}[j].value;\r\n			  }	      \r\n	  	    }\r\n			data1_${element.mid!\'\'}.push({\r\n	  	        key: name,\r\n	  	        value: value,\r\n	  	      });\r\n	  	    }\r\n	</#if>\r\n	\r\n		let mapData_${element.mid!\'\'} = {\r\n	      type: \'FeatureCollection\',\r\n	      features: geoJson\r\n		};\r\n	    let ds_${element.mid!\'\'} = new DataSet();\r\n	    let geoDataView_${element.mid!\'\'} = ds_${element.mid!\'\'}.createView().source(mapData_${element.mid!\'\'}, {\r\n	      type: \'GeoJSON\',\r\n	    });\r\n\r\n	    // 用户数据\r\n	    let dvData_${element.mid!\'\'} = ds_${element.mid!\'\'}.createView().source(data1_${element.mid!\'\'});\r\n	    dvData_${element.mid!\'\'}.transform({\r\n	      type: \'geo.region\',\r\n	      field: \'key\',\r\n	      geoDataView: geoDataView_${element.mid!\'\'},\r\n	      as: [\'longitude\', \'lantitude\'],\r\n	    });\r\n	   var json_${element.mid!\'\'} =  $.parseJSON( $(\"#json_${element.mid!\'\'}\").text() );\r\n	  $(\"#json_${element.mid!\'\'}\").remove();\r\n	  ChartAction.renderChart(\'${element.mid!\'\'}\',dvData_${element.mid!\'\'},json_${element.mid!\'\'})\r\n	}\r\n	    mapLoad(func_${element.mid!\'\'});\r\n	</script>', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/map.png', null, null, null, null, '0', null, 'map');
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191ea38620340', '漏斗图', null, 'report', null, '2018-02-14 09:25:01', null, null, '	<script>\r\n	<#if reportData??>\r\n	var data_${element.mid!\'\'} = [];\r\n		<#if reportData.row??>\r\n			<#list reportData.row.title as title>\r\n				<#if (title_index+1) == reportData.row.title?size>\r\n					<#list title as rowtl>\r\n						var obj_${element.mid!\'\'} = new Object();\r\n						obj_${element.mid!\'\'}[\"_name\"] = \"${rowtl.rename!rowtl.name!\'\'}\";\r\n						<#if reportData.col??>\r\n						<#list reportData.col.title as coltlist>\r\n							<#list coltlist as coltl>\r\n								<#if reportData?? && reportData.data??>\r\n									<#list reportData.data as values>\r\n										<#if rowtl_index == values_index>\r\n											<#list values as val>	\r\n												<#if coltl_index == val_index && val_index == 0>\r\n													obj_${element.mid!\'\'}[\'key\'] = ${val.valueStyle!val.foramatValue!\'\'}\r\n												</#if>\r\n												<#if coltl_index == val_index && val_index == 1>\r\n													obj_${element.mid!\'\'}[\'value\'] = ${val.valueStyle!val.foramatValue!\'\'}\r\n												</#if>\r\n											</#list>\r\n										</#if>\r\n									</#list>\r\n								</#if>\r\n							</#list>\r\n						</#list>	\r\n						</#if>\r\n						data_${element.mid!\'\'}.push(obj_${element.mid!\'\'})						\r\n					</#list>			\r\n				</#if>\r\n			</#list>\r\n		</#if>\r\n		<#else>\r\n		const data_${element.mid!\'\'} = [\r\n					{ key: \'浏览网站\', value: 50000 },\r\n					{ key: \'放入购物车\', value: 35000 },\r\n					{ key: \'生成订单\', value: 25000 },\r\n					{ key: \'支付订单\', value: 15000 },\r\n					{ key: \'完成交易\', value: 8000 }\r\n				  ];		\r\n		</#if>	\r\n	  const dv_${element.mid!\'\'} = data_${element.mid!\'\'};\r\n	var json_${element.mid!\'\'} =  $.parseJSON( $(\"#json_${element.mid!\'\'}\").text() );\r\n	  $(\"#json_${element.mid!\'\'}\").remove();\r\n	  ChartAction.renderChart(\'${element.mid!\'\'}\',dv_${element.mid!\'\'},json_${element.mid!\'\'})\r\n	</script>\r\n', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/loudou.png', null, null, null, null, '0', null, 'funnel');
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191eba2190341', '折线图', null, 'report', null, '2018-02-14 09:26:34', null, null, '	<script>\r\n	<#if reportData??>\r\n	var data_${element.mid!\'\'} = [];\r\n	var mea_${element.mid!\'\'} = [];\r\n		<#if reportData.row??>\r\n			<#list reportData.row.title as title>\r\n				<#if (title_index+1) == reportData.row.title?size>\r\n					<#if reportData.col??>\r\n						<#list reportData.col.title as coltlist>\r\n							<#list coltlist as coltl>\r\n									var obj_${element.mid!\'\'} = new Object();\r\n									obj_${element.mid!\'\'}[\"_name\"] = \"${coltl.rename!coltl.name!\'\'}\";\r\n									<#list title as rowtl2>							\r\n									<#if reportData?? && reportData.data??>\r\n										<#list reportData.data as values>\r\n											<#if rowtl2_index == values_index>\r\n												<#list values as val>	\r\n													<#if coltl_index == val_index>\r\n														obj_${element.mid!\'\'}[\"${rowtl2.rename!rowtl2.name!\'\'}\"] = ${val.valueStyle!val.foramatValue!\'\'}\r\n													</#if>\r\n												</#list>\r\n											</#if>\r\n										</#list>\r\n									</#if>\r\n									</#list>\r\n									data_${element.mid!\'\'}.push(obj_${element.mid!\'\'});						\r\n							</#list>\r\n						</#list>\r\n					</#if>\r\n					<#list title as rowtl>						\r\n						mea_${element.mid!\'\'}.push(\'${rowtl.rename!rowtl.name!\'\'}\');						\r\n					</#list>\r\n				</#if>\r\n			</#list>\r\n		</#if>\r\n	<#else>\r\n		const data_${element.mid!\'\'} = [\r\n			{ _name:\'London\', \'Jan.\': 18.9, \'Feb.\': 28.8, \'Mar.\' :39.3, \'Apr.\': 81.4, \'May\': 47, \'Jun.\': 20.3, \'Jul.\': 24, \'Aug.\': 35.6 },\r\n			{ _name:\'Berlin\', \'Jan.\': 12.4, \'Feb.\': 23.2, \'Mar.\' :34.5, \'Apr.\': 99.7, \'May\': 52.6, \'Jun.\': 35.5, \'Jul.\': 37.4, \'Aug.\': 42.4}\r\n		  ];\r\n		const mea_${element.mid!\'\'} =  [ \'Jan.\',\'Feb.\',\'Mar.\',\'Apr.\',\'May\',\'Jun.\',\'Jul.\',\'Aug.\' ];\r\n	</#if>\r\n	const ds_${element.mid!\'\'} = new DataSet();\r\n	  const dv_${element.mid!\'\'} = ds_${element.mid!\'\'}.createView().source(data_${element.mid!\'\'});\r\n	  dv_${element.mid!\'\'}.transform({\r\n		type: \'fold\',\r\n		fields: mea_${element.mid!\'\'}, // 展开字段集\r\n		key: \'key\', // key字段\r\n		value: \'value\', // value字段\r\n	  });\r\n		var json_${element.mid!\'\'} =  $.parseJSON( $(\"#json_${element.mid!\'\'}\").text() );\r\n	  $(\"#json_${element.mid!\'\'}\").remove();\r\n	  ChartAction.renderChart(\'${element.mid!\'\'}\',dv_${element.mid!\'\'},json_${element.mid!\'\'})\r\n	</script>\r\n', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/line.gif', null, null, null, null, '0', null, 'line');
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191ebf9ae0342', '柱形图', null, 'report', null, '2018-02-14 09:26:56', null, null, '	<script>\r\n	<#if reportData??>\r\n	var data_${element.mid!\'\'} = [];\r\n	var mea_${element.mid!\'\'} = [];\r\n		<#if reportData.row??>\r\n			<#list reportData.row.title as title>\r\n				<#if (title_index+1) == reportData.row.title?size>\r\n					<#if reportData.col??>\r\n						<#list reportData.col.title as coltlist>\r\n							<#list coltlist as coltl>\r\n									var obj_${element.mid!\'\'} = new Object();\r\n									obj_${element.mid!\'\'}[\"_name\"] = \"${coltl.rename!coltl.name!\'\'}\";\r\n									<#list title as rowtl2>							\r\n									<#if reportData?? && reportData.data??>\r\n										<#list reportData.data as values>\r\n											<#if rowtl2_index == values_index>\r\n												<#list values as val>	\r\n													<#if coltl_index == val_index>\r\n														obj_${element.mid!\'\'}[\"${rowtl2.rename!rowtl2.name!\'\'}\"] = ${val.valueStyle!val.foramatValue!\'\'}\r\n													</#if>\r\n												</#list>\r\n											</#if>\r\n										</#list>\r\n									</#if>\r\n									</#list>\r\n									data_${element.mid!\'\'}.push(obj_${element.mid!\'\'});						\r\n							</#list>\r\n						</#list>\r\n					</#if>\r\n					<#list title as rowtl>						\r\n						mea_${element.mid!\'\'}.push(\'${rowtl.rename!rowtl.name!\'\'}\');						\r\n					</#list>\r\n				</#if>\r\n			</#list>\r\n		</#if>\r\n	<#else>\r\n		const data_${element.mid!\'\'} = [\r\n			{ _name:\'London\', \'Jan.\': 18.9, \'Feb.\': 28.8, \'Mar.\' :39.3, \'Apr.\': 81.4, \'May\': 47, \'Jun.\': 20.3, \'Jul.\': 24, \'Aug.\': 35.6 },\r\n			{ _name:\'Berlin\', \'Jan.\': 12.4, \'Feb.\': 23.2, \'Mar.\' :34.5, \'Apr.\': 99.7, \'May\': 52.6, \'Jun.\': 35.5, \'Jul.\': 37.4, \'Aug.\': 42.4}\r\n		  ];\r\n		const mea_${element.mid!\'\'} =  [ \'Jan.\',\'Feb.\',\'Mar.\',\'Apr.\',\'May\',\'Jun.\',\'Jul.\',\'Aug.\' ];\r\n	</#if>\r\n	const ds_${element.mid!\'\'} = new DataSet();\r\n	  const dv_${element.mid!\'\'} = ds_${element.mid!\'\'}.createView().source(data_${element.mid!\'\'});\r\n	  dv_${element.mid!\'\'}.transform({\r\n		type: \'fold\',\r\n		fields: mea_${element.mid!\'\'}, // 展开字段集\r\n		key: \'key\', // key字段	\r\n		value: \'value\', // value字段\r\n	  });\r\n	  var json_${element.mid!\'\'} =  $.parseJSON( $(\"#json_${element.mid!\'\'}\").text() );\r\n	  $(\"#json_${element.mid!\'\'}\").remove();\r\n	  ChartAction.renderChart(\'${element.mid!\'\'}\',dv_${element.mid!\'\'},json_${element.mid!\'\'})\r\n	</script>\r\n\r\n\r\n', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/bar.gif', null, null, null, null, '0', null, 'histogram');
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191ec3c900343', '饼形图', null, 'report', null, '2018-02-14 09:27:13', null, null, '	<script>\r\n	<#if reportData??>\r\n	var data_${element.mid!\'\'} = [];\r\n	var field_${element.mid!\'\'}  = \"\";\r\n	<#if reportData.row??>\r\n		<#list reportData.row.title as title>\r\n			<#if (title_index+1) == reportData.row.title?size>\r\n				<#list title as rowtl>	\r\n					var obj_${element.mid!\'\'} = new Object();\r\n					obj_${element.mid!\'\'}[\"key\"] = \'${rowtl.rename!rowtl.name!\'\'}\';\r\n					<#if reportData.col??>\r\n						<#list reportData.col.title as coltlist>\r\n							<#list coltlist as coltl>\r\n								<#if coltl_index == 0>	\r\n									<#list reportData.data as values>\r\n										<#if rowtl_index == values_index>\r\n											<#list values as val>	\r\n												<#if coltl_index == 0>\r\n													obj_${element.mid!\'\'}[\"${coltl.rename!coltl.name!\'\'}\"] = ${val.valueStyle!val.foramatValue!\'\'}\r\n													field_${element.mid!\'\'}  = \'${coltl.rename!coltl.name!\'\'}\';\r\n												</#if>\r\n											</#list>\r\n										</#if>\r\n									</#list>									\r\n								</#if>																			\r\n							</#list>\r\n						</#list>\r\n					</#if>	\r\n					data_${element.mid!\'\'}.push(obj_${element.mid!\'\'});		\r\n				</#list>										\r\n			</#if>\r\n		</#list>\r\n	</#if>\r\n	<#else>\r\n		const data_${element.mid!\'\'} = [\r\n			{ key: \'事例一\', count: 40 },\r\n			{ key: \'事例二\', count: 21 },\r\n			{ key: \'事例三\', count: 17 },\r\n			{ key: \'事例四\', count: 13 },\r\n			{ key: \'事例五\', count: 9 }\r\n		  ];\r\n		  var field_${element.mid!\'\'}  = \"count\";\r\n	</#if>\r\n		console.info(data_${element.mid!\'\'})\r\n		console.info(field_${element.mid!\'\'})\r\n		const { DataView } = DataSet;\r\n	  const dv_${element.mid!\'\'} = new DataView();\r\n	  dv_${element.mid!\'\'}.source(data_${element.mid!\'\'}).transform({\r\n		type: \'percent\',\r\n		field: field_${element.mid!\'\'},\r\n		dimension: \'key\',\r\n		as: \'value\'\r\n	  });\r\n	   var json_${element.mid!\'\'} =  $.parseJSON( $(\"#json_${element.mid!\'\'}\").text() );\r\n	  $(\"#json_${element.mid!\'\'}\").remove();\r\n	  ChartAction.renderChart(\'${element.mid!\'\'}\',dv_${element.mid!\'\'},json_${element.mid!\'\'})\r\n	</script>', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/pie.gif', null, null, null, null, '0', null, 'pie');
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191ec901f0344', '面积图', null, 'report', null, '2018-02-14 09:27:35', null, null, '	<script>\r\n	<#if reportData??>\r\n	var data_${element.mid!\'\'} = [];\r\n	var mea_${element.mid!\'\'} = [];\r\n		<#if reportData.row??>\r\n			<#list reportData.row.title as title>\r\n				<#if (title_index+1) == reportData.row.title?size>\r\n					<#if reportData.col??>\r\n						<#list reportData.col.title as coltlist>\r\n							<#list coltlist as coltl>\r\n									var obj_${element.mid!\'\'} = new Object();\r\n									obj_${element.mid!\'\'}[\"_name\"] = \"${coltl.rename!coltl.name!\'\'}\";\r\n									<#list title as rowtl2>							\r\n									<#if reportData?? && reportData.data??>\r\n										<#list reportData.data as values>\r\n											<#if rowtl2_index == values_index>\r\n												<#list values as val>	\r\n													<#if coltl_index == val_index>\r\n														obj_${element.mid!\'\'}[\"${rowtl2.rename!rowtl2.name!\'\'}\"] = ${val.valueStyle!val.foramatValue!\'\'}\r\n													</#if>\r\n												</#list>\r\n											</#if>\r\n										</#list>\r\n									</#if>\r\n									</#list>\r\n									data_${element.mid!\'\'}.push(obj_${element.mid!\'\'});						\r\n							</#list>\r\n						</#list>\r\n					</#if>\r\n					<#list title as rowtl>						\r\n						mea_${element.mid!\'\'}.push(\'${rowtl.rename!rowtl.name!\'\'}\');						\r\n					</#list>\r\n				</#if>\r\n			</#list>\r\n		</#if>		\r\n	<#else>\r\n		const data_${element.mid!\'\'} = [\r\n			{ _name:\'London\', \'Jan.\': 18.9, \'Feb.\': 28.8, \'Mar.\' :39.3, \'Apr.\': 81.4, \'May\': 47, \'Jun.\': 20.3, \'Jul.\': 24, \'Aug.\': 35.6 },\r\n			{ _name:\'Berlin\', \'Jan.\': 12.4, \'Feb.\': 23.2, \'Mar.\' :34.5, \'Apr.\': 99.7, \'May\': 52.6, \'Jun.\': 35.5, \'Jul.\': 37.4, \'Aug.\': 42.4}\r\n		  ];\r\n		const mea_${element.mid!\'\'} =  [ \'Jan.\',\'Feb.\',\'Mar.\',\'Apr.\',\'May\',\'Jun.\',\'Jul.\',\'Aug.\' ];\r\n	</#if>	\r\n	const { DataView } = DataSet;	\r\n	const ds_${element.mid!\'\'} = new DataSet();\r\n	const dv_${element.mid!\'\'} = new DataView().source(data_${element.mid!\'\'});\r\n	  dv_${element.mid!\'\'}.transform({\r\n		type: \'fold\',\r\n		fields: mea_${element.mid!\'\'}, // 展开字段集\r\n		key: \'key\', // key字段\r\n		value: \'value\', // value字段\r\n	  });  \r\n	   var json_${element.mid!\'\'} =  $.parseJSON( $(\"#json_${element.mid!\'\'}\").text() );\r\n	  $(\"#json_${element.mid!\'\'}\").remove();\r\n	  ChartAction.renderChart(\'${element.mid!\'\'}\',dv_${element.mid!\'\'},json_${element.mid!\'\'})\r\n	</script>', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/area.gif', null, null, null, null, '0', null, 'area');
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191ed0e160345', '条形图', null, 'report', null, '2018-02-14 09:28:07', null, null, '	<script>\r\n	<#if reportData??>\r\n	var data_${element.mid!\'\'} = [];\r\n	var mea_${element.mid!\'\'} = [];\r\n		<#if reportData.row??>\r\n			<#list reportData.row.title as title>\r\n				<#if (title_index+1) == reportData.row.title?size>\r\n					<#if reportData.col??>\r\n						<#list reportData.col.title as coltlist>\r\n							<#list coltlist as coltl>\r\n									var obj_${element.mid!\'\'} = new Object();\r\n									obj_${element.mid!\'\'}[\"_name\"] = \"${coltl.rename!coltl.name!\'\'}\";\r\n									<#list title as rowtl2>							\r\n									<#if reportData?? && reportData.data??>\r\n										<#list reportData.data as values>\r\n											<#if rowtl2_index == values_index>\r\n												<#list values as val>	\r\n													<#if coltl_index == val_index>\r\n														obj_${element.mid!\'\'}[\"${rowtl2.rename!rowtl2.name!\'\'}\"] = ${val.valueStyle!val.foramatValue!\'\'}\r\n													</#if>\r\n												</#list>\r\n											</#if>\r\n										</#list>\r\n									</#if>\r\n									</#list>\r\n									data_${element.mid!\'\'}.push(obj_${element.mid!\'\'});						\r\n							</#list>\r\n						</#list>\r\n					</#if>\r\n					<#list title as rowtl>						\r\n						mea_${element.mid!\'\'}.push(\'${rowtl.rename!rowtl.name!\'\'}\');						\r\n					</#list>\r\n				</#if>\r\n			</#list>\r\n		</#if>\r\n	<#else>\r\n		const data_${element.mid!\'\'} = [\r\n			{ _name:\'London\', \'Jan.\': 18.9, \'Feb.\': 28.8, \'Mar.\' :39.3, \'Apr.\': 81.4, \'May\': 47, \'Jun.\': 20.3, \'Jul.\': 24, \'Aug.\': 35.6 },\r\n			{ _name:\'Berlin\', \'Jan.\': 12.4, \'Feb.\': 23.2, \'Mar.\' :34.5, \'Apr.\': 99.7, \'May\': 52.6, \'Jun.\': 35.5, \'Jul.\': 37.4, \'Aug.\': 42.4}\r\n		  ];\r\n		const mea_${element.mid!\'\'} =  [ \'Jan.\',\'Feb.\',\'Mar.\',\'Apr.\',\'May\',\'Jun.\',\'Jul.\',\'Aug.\' ];\r\n	</#if>\r\n	const ds_${element.mid!\'\'} = new DataSet();\r\n	  const dv_${element.mid!\'\'} = ds_${element.mid!\'\'}.createView().source(data_${element.mid!\'\'});\r\n	  dv_${element.mid!\'\'}.transform({\r\n		type: \'fold\',\r\n		fields: mea_${element.mid!\'\'}, // 展开字段集\r\n		key: \'key\', // key字段\r\n		value: \'value\', // value字段\r\n	  });\r\n	  \r\n	   var json_${element.mid!\'\'} =  $.parseJSON( $(\"#json_${element.mid!\'\'}\").text() );\r\n	  $(\"#json_${element.mid!\'\'}\").remove();\r\n	  ChartAction.renderChart(\'${element.mid!\'\'}\',dv_${element.mid!\'\'},json_${element.mid!\'\'})\r\n	</script>', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/flat.gif', null, null, null, null, '0', null, 'bar');
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191ed46550346', '环形图', null, 'report', null, '2018-02-14 09:28:21', null, null, '	<script>\r\n	<#if reportData??>\r\n	var data_${element.mid!\'\'} = [];\r\n	var field_${element.mid!\'\'}  = \"\";\r\n	<#if reportData.row??>\r\n		<#list reportData.row.title as title>\r\n			<#if (title_index+1) == reportData.row.title?size>\r\n				<#list title as rowtl>	\r\n					var obj_${element.mid!\'\'} = new Object();\r\n					obj_${element.mid!\'\'}[\"item\"] = \'${rowtl.rename!rowtl.name!\'\'}\';\r\n					<#if reportData.col??>\r\n						<#list reportData.col.title as coltlist>\r\n							<#list coltlist as coltl>\r\n								<#if coltl_index == 0>	\r\n									<#list reportData.data as values>\r\n										<#if rowtl_index == values_index>\r\n											<#list values as val>	\r\n												<#if coltl_index == 0>\r\n													obj_${element.mid!\'\'}[\"${coltl.rename!coltl.name!\'\'}\"] = ${val.valueStyle!val.foramatValue!\'\'}\r\n													field_${element.mid!\'\'}  = \'${coltl.rename!coltl.name!\'\'}\';\r\n												</#if>\r\n											</#list>\r\n										</#if>\r\n									</#list>									\r\n								</#if>																			\r\n							</#list>\r\n						</#list>\r\n					</#if>	\r\n					data_${element.mid!\'\'}.push(obj_${element.mid!\'\'});		\r\n				</#list>										\r\n			</#if>\r\n		</#list>\r\n	</#if>\r\n	<#else>\r\n		const data_${element.mid!\'\'} = [\r\n			{ key: \'事例一\', count: 40 },\r\n			{ key: \'事例二\', count: 21 },\r\n			{ key: \'事例三\', count: 17 },\r\n			{ key: \'事例四\', count: 13 },\r\n			{ key: \'事例五\', count: 9 }\r\n		  ];\r\n		  var field_${element.mid!\'\'}  = \"count\";\r\n	</#if>\r\n		const { DataView } = DataSet;\r\n	  const dv_${element.mid!\'\'} = new DataView();\r\n	  dv_${element.mid!\'\'}.source(data_${element.mid!\'\'}).transform({\r\n		type: \'percent\',\r\n		field: field_${element.mid!\'\'},\r\n		dimension: \'key\',\r\n		as: \'value\'\r\n	  });\r\n	   var json_${element.mid!\'\'} =  $.parseJSON( $(\"#json_${element.mid!\'\'}\").text() );\r\n	  $(\"#json_${element.mid!\'\'}\").remove();\r\n	  ChartAction.renderChart(\'${element.mid!\'\'}\',dv_${element.mid!\'\'},json_${element.mid!\'\'})\r\n	</script>', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/hole.gif', null, null, null, null, '0', null, 'ring');
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191ed97a80347', '点状图', null, 'report', null, '2018-02-14 09:28:42', null, null, '	<script>\r\n	<#if reportData??>\r\n	var data_${element.mid!\'\'} = [];\r\n		<#if reportData.row??>\r\n			<#list reportData.row.title as title>\r\n				<#if (title_index+1) == reportData.row.title?size>\r\n					<#list title as rowtl>\r\n						var obj_${element.mid!\'\'} = new Object();\r\n						obj_${element.mid!\'\'}[\"_name\"] = \"${rowtl.rename!rowtl.name!\'\'}\";\r\n						<#if reportData.col??>\r\n						<#list reportData.col.title as coltlist>\r\n							<#list coltlist as coltl>\r\n								<#if reportData?? && reportData.data??>\r\n									<#list reportData.data as values>\r\n										<#if rowtl_index == values_index>\r\n											<#list values as val>	\r\n												<#if coltl_index == val_index && val_index == 0>\r\n													obj_${element.mid!\'\'}[\'key\'] = ${val.valueStyle!val.foramatValue!\'\'}\r\n												</#if>\r\n												<#if coltl_index == val_index && val_index == 1>\r\n													obj_${element.mid!\'\'}[\'value\'] = ${val.valueStyle!val.foramatValue!\'\'}\r\n												</#if>\r\n											</#list>\r\n										</#if>\r\n									</#list>\r\n								</#if>\r\n							</#list>\r\n						</#list>	\r\n						</#if>\r\n						data_${element.mid!\'\'}.push(obj_${element.mid!\'\'})						\r\n					</#list>			\r\n				</#if>\r\n			</#list>\r\n		</#if>\r\n		<#else>\r\n		const data_${element.mid!\'\'} = [{\"_name\":\"female\",\"key\":161.2,\"value\":51.6},{\"_name\":\"female\",\"key\":167.5,\"value\":59},{\"_name\":\"female\",\"key\":159.5,\"value\":49.2},{\"_name\":\"female\",\"key\":157,\"value\":63},{\"_name\":\"female\",\"key\":155.8,\"value\":53.6},{\"_name\":\"female\",\"key\":170,\"value\":59},{\"_name\":\"female\",\"key\":159.1,\"value\":47.6},{\"_name\":\"female\",\"key\":166,\"value\":69.8},{\"_name\":\"female\",\"key\":176.2,\"value\":66.8},{\"_name\":\"female\",\"key\":160.2,\"value\":75.2},{\"_name\":\"female\",\"key\":172.5,\"value\":55.2},{\"_name\":\"female\",\"key\":170.9,\"value\":54.2},{\"_name\":\"female\",\"key\":172.9,\"value\":62.5},{\"_name\":\"female\",\"key\":153.4,\"value\":42},{\"_name\":\"female\",\"key\":160,\"value\":50},{\"_name\":\"female\",\"key\":147.2,\"value\":49.8},{\"_name\":\"female\",\"key\":168.2,\"value\":49.2},{\"_name\":\"female\",\"key\":175,\"value\":73.2},{\"_name\":\"female\",\"key\":157,\"value\":47.8},{\"_name\":\"female\",\"key\":167.6,\"value\":68.8},{\"_name\":\"female\",\"key\":159.5,\"value\":50.6},{\"_name\":\"female\",\"key\":175,\"value\":82.5},{\"_name\":\"female\",\"key\":166.8,\"value\":57.2},{\"_name\":\"female\",\"key\":176.5,\"value\":87.8},{\"_name\":\"female\",\"key\":170.2,\"value\":72.8},{\"_name\":\"female\",\"key\":174,\"value\":54.5},{\"_name\":\"female\",\"key\":173,\"value\":59.8},{\"_name\":\"female\",\"key\":179.9,\"value\":67.3},{\"_name\":\"female\",\"key\":170.5,\"value\":67.8},{\"_name\":\"female\",\"key\":160,\"value\":47},{\"_name\":\"female\",\"key\":154.4,\"value\":46.2},{\"_name\":\"female\",\"key\":162,\"value\":55},{\"_name\":\"female\",\"key\":176.5,\"value\":83},{\"_name\":\"female\",\"key\":160,\"value\":54.4},{\"_name\":\"female\",\"key\":152,\"value\":45.8},{\"_name\":\"female\",\"key\":162.1,\"value\":53.6},{\"_name\":\"female\",\"key\":170,\"value\":73.2},{\"_name\":\"male\",\"key\":160.2,\"value\":52.1},{\"_name\":\"female\",\"key\":161.3,\"value\":67.9}]		\r\n		</#if>	\r\n	  const dv_${element.mid!\'\'} = data_${element.mid!\'\'};\r\n	var json_${element.mid!\'\'} =  $.parseJSON( $(\"#json_${element.mid!\'\'}\").text() );\r\n	  $(\"#json_${element.mid!\'\'}\").remove();\r\n	  ChartAction.renderChart(\'${element.mid!\'\'}\',dv_${element.mid!\'\'},json_${element.mid!\'\'})\r\n	</script>\r\n', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/point.gif', null, null, null, null, '0', null, 'dotplot');
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191edc7b50348', '雷达图', null, 'report', null, '2018-02-14 09:28:54', null, null, '	<script>\r\n	<#if reportData??>\r\n	var data_${element.mid!\'\'} = [];\r\n	var mea_${element.mid!\'\'} = [];\r\n		<#if reportData.row??>\r\n			<#list reportData.row.title as title>\r\n				<#if (title_index+1) == reportData.row.title?size>\r\n					<#if reportData.col??>\r\n						<#list reportData.col.title as coltlist>\r\n							<#list coltlist as coltl>\r\n									var obj_${element.mid!\'\'} = new Object();\r\n									obj_${element.mid!\'\'}[\"_name\"] = \"${coltl.rename!coltl.name!\'\'}\";\r\n									<#list title as rowtl2>							\r\n									<#if reportData?? && reportData.data??>\r\n										<#list reportData.data as values>\r\n											<#if rowtl2_index == values_index>\r\n												<#list values as val>	\r\n													<#if coltl_index == val_index>\r\n														obj_${element.mid!\'\'}[\"${rowtl2.rename!rowtl2.name!\'\'}\"] = ${val.valueStyle!val.foramatValue!\'\'}\r\n													</#if>\r\n												</#list>\r\n											</#if>\r\n										</#list>\r\n									</#if>\r\n									</#list>\r\n									data_${element.mid!\'\'}.push(obj_${element.mid!\'\'});						\r\n							</#list>\r\n						</#list>\r\n					</#if>\r\n					<#list title as rowtl>						\r\n						mea_${element.mid!\'\'}.push(\'${rowtl.rename!rowtl.name!\'\'}\');						\r\n					</#list>\r\n				</#if>\r\n			</#list>\r\n		</#if>\r\n	<#else>\r\n		const data_${element.mid!\'\'} = [\r\n			{ _name:\'London\', \'Jan.\': 18.9, \'Feb.\': 28.8, \'Mar.\' :39.3, \'Apr.\': 81.4, \'May\': 47, \'Jun.\': 20.3, \'Jul.\': 24, \'Aug.\': 35.6 },\r\n			{ _name:\'Berlin\', \'Jan.\': 12.4, \'Feb.\': 23.2, \'Mar.\' :34.5, \'Apr.\': 99.7, \'May\': 52.6, \'Jun.\': 35.5, \'Jul.\': 37.4, \'Aug.\': 42.4}\r\n		  ];\r\n		const mea_${element.mid!\'\'} =  [ \'Jan.\',\'Feb.\',\'Mar.\',\'Apr.\',\'May\',\'Jun.\',\'Jul.\',\'Aug.\' ];\r\n	</#if>\r\n	const ds_${element.mid!\'\'} = new DataSet();\r\n	const dv_${element.mid!\'\'} = ds_${element.mid!\'\'}.createView().source(data_${element.mid!\'\'});\r\n	  dv_${element.mid!\'\'}.transform({\r\n		type: \'fold\',\r\n		fields: mea_${element.mid!\'\'}, // 展开字段集\r\n		key: \'key\', // key字段\r\n		value: \'value\', // value字段\r\n	  });\r\n	   var json_${element.mid!\'\'} =  $.parseJSON( $(\"#json_${element.mid!\'\'}\").text() );\r\n	  $(\"#json_${element.mid!\'\'}\").remove();\r\n	  ChartAction.renderChart(\'${element.mid!\'\'}\',dv_${element.mid!\'\'},json_${element.mid!\'\'})\r\n	</script>\r\n', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/radar.gif', null, null, null, null, '0', null, 'radar');
  INSERT INTO `uk_templet` VALUES ('4028811b6191e289016191ee589c0349', 'KPI图', null, 'report', null, '2018-02-14 09:29:32', null, null, '<div id=\"element_${reportModel.id!\'\'}\" class=\"r3-data-element\" style=\"min-width:100px;min-height:65px;\">\r\n	<#assign disdata = false >\r\n    <#if reportModel.reportData?? && reportModel.reportData.data??>\r\n    	<#list reportModel.reportData.data as values>\r\n    		<#if values_index == 0>\r\n    			<#list values as value>\r\n    				<#if value_index ==0>\r\n					<#assign disdata = true >\r\n    				<h1 class=\"no-margins\" <#if value.value lt 0>style=\"color:red;\"</#if>>\r\n                		${value.foramatValue!\'\'}\r\n                	</h1>\r\n                	<div class=\"stat-percent font-bold text-success\">\r\n                		<#if value.row?? && value.row.name?? && value.row.name!= \'root\' >${value.row.name!\'\'}</#if>\r\n						<small>\r\n							<#if value.name??>${value.name!\'\'}</#if>\r\n						</small>\r\n                	</div>\r\n    				</#if>\r\n    			</#list>\r\n    		</#if>\r\n    	</#list>\r\n    </#if> 	\r\n	<#if disdata == false>\r\n	<h1 class=\"no-margins\">\r\n		1000.00\r\n	</h1>\r\n	<div class=\"stat-percent font-bold text-success\">\r\n		测试占比\r\n		<small>\r\n			20%\r\n		</small>\r\n	</div>\r\n	</#if>\r\n</div>', '4028811b618d0dca01618d5a5fe6034a', 'ukewo', '/images/design/kpi.png', null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b6418c59701641b65e21c075b', 'sff', null, 'ffff', null, '2018-06-20 12:13:39', null, null, 'asdfasdf', '4028811b6109050201610928ed6a030d', 'ukewo', null, null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b642af06f01642afa426804cd', 'InQuery', null, 'otheraiinput', null, '2018-06-23 12:50:01', null, null, '{\r\n\"webid\": \"${appid!\'\'}\",\r\n\"aiid\": \"${aiuser.aiid!\'\'}\",\r\n\"label\": \"${aiuser.skill!\'\'}\",\r\n\"userid\": \"${chat.userid!\'\'}\",\r\n\"datatype\": \"${chat.msgtype!\'text\'}\",\r\n\"data\": \"${(chat.message!\'\')?replace(\'\\n\',\'\')?replace(\'\\\"\',\'\\\'\')}\"\r\n}', '4028811b642af06f01642af9cfa304c6', 'ukewo', null, null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b642af06f01642afaae4f04d3', '外部机器人输出参数', null, 'otheraioutputparam', null, '2018-06-23 12:50:29', null, null, '{\r\n\"msgtype\":\"${data.data_type!\'text\'}\"\r\n,\"code\":\"${data.code!\'\'}\"\r\n<#if data.code?? && data.code != \'E0000\'>,\"trans\":true</#if>\r\n<#if data?? && data.candidates?? && data.candidates?size gt 0>\r\n	<#assign suggest = \"[\">\r\n	<#list data.candidates as item>\r\n		<#if suggest?length gt 1>\r\n			<#assign suggest = suggest + \",\">\r\n		</#if>\r\n		<#if item.question??>\r\n			<#assign suggest = suggest + \'{\"id\":\"\'+item.kbid+\'\",\"title\":\"\'+item.question + \'\"}\'>\r\n		</#if>\r\n	</#list>\r\n	<#assign suggest = suggest + \"]\">\r\n	,\"items\":${suggest}\r\n</#if>\r\n<#if data?? && data.data??>\r\n	,\"title\":\"${data.data.title!\'\'}\"\r\n</#if>\r\n<#if data?? && data.data??>\r\n	,\"score\":\"${data.data.score!\'\'}\"\r\n	<#if data.data.score?? && data.data.score gt 0.8>\r\n	,\"matchtype\":\"hight\"\r\n	</#if>\r\n</#if>\r\n<#if data?? && data.data?? && data.data.answer??>\r\n	,\"message\":\"${data.data.answer!\'\'}\"\r\n<#elseif data?? && data.data?? && data.data.kbid??>\r\n	,\"id\":\"${data.data.kbid!\'\'}\"\r\n	,\"detail\":true\r\n<#else>\r\n	,\"message\":\"${data.message!\'\'}\"\r\n</#if>\r\n<#if data.data?? && data.data.type?? && data.data.type == 3>\r\n	,\"type\":\"voice\"\r\n	,\"duration\":${data.data.duration!\'0\'}\r\n</#if>\r\n}', '4028811b642af06f01642af9cfaf04c7', 'ukewo', null, null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b644983b60164498da54a040f', 'InKeyword', null, 'opsearh', null, '2018-06-29 11:19:37', null, null, '{\r\n\"label\": \"${skill!\'\'}\",\r\n\"keyword\": \"${q!\'\'}\",\r\n\"webid\": \"${appid!\'\'}\"\r\n}', '4028811b642af06f01642af9cfa304c6', 'ukewo', null, null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b644983b60164498e06570416', 'InKbid', null, 'oqrdetail', null, '2018-06-29 11:20:01', null, null, '{\r\n\"kbid\": \"${id!\'\'}\",\r\n\"aiid\": \"${aiid!\'\'}\",\r\n\"webid\": \"${appid!\'\'}\"\r\n}', '4028811b642af06f01642af9cfa304c6', 'ukewo', null, null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b644a2d2e01644a2ea6770400', '搜索输出接口', null, 'searchoutput', null, '2018-06-29 14:15:28', null, null, '[<#if data?? && data.data??><#list data.data as kb><#if kb_index gt 0>,</#if>\r\n{\r\n	\"id\":\"${kb.kbid!\'\'}\",\r\n	\"title\":\"${(kb.title!\'\')?replace(\'\\n\',\'\')}\"\r\n}</#list></#if>\r\n]', '4028811b642af06f01642af9cfaf04c7', 'ukewo', null, null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b644a2d2e01644a334a650422', '详情输出接口', null, 'detailinput', null, '2018-06-29 14:20:32', null, null, '<#if data?? && data.data??>\r\n{\r\n	\"id\":\"${data.data.kbid!\'\'}\",\r\n	\"title\":\"${(data.data.title!\'\')?replace(\'\\n\',\'\')}\",\r\n	\"content\":\"${((((data.data.content!\'\')?replace(\'\\n\',\'\'))?replace(\'\\\\\\\"\' , \'\\\'\'))?replace(\'\"\' , \'\\\\\"\'))?replace(\'\\\\/\' , \'/\')}\",\r\n	<#if data.data.type?? && data.data.type == 2>\r\n	\"type\":\"news\",\r\n	<#elseif data.data.type?? && data.data.type == 3>\r\n	\"type\":\"voice\",\r\n	\"duration\":<#if data.data.duration??>${data.data.duration!\'0\'}<#else>0</#if>,\r\n	</#if>\r\n	<#if data.data.url?? && data.data.url != \'\'>\r\n	\"url\":\"${data.data.url}\",\r\n	</#if>\r\n	\"headimg\":\"${data.data.first_image!\'\'}\",\r\n	\"clabel\":\"${data.data.labelcount!\'\'}\",\r\n	\"clabelname\":\"${data.data.label!\'\'}\",\r\n	\"ckind\":\"${data.data.directorylevel!\'\'}\",\r\n	\"ckindname\":\"${data.data.directory!\'\'}\"\r\n}</#if>', '4028811b642af06f01642af9cfaf04c7', 'ukewo', null, null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b64f8d62b0164f948f98a040e', 'InForcast', null, 'clientinput', null, '2018-08-02 14:17:46', null, null, '{\r\n\"data\": \"${q!\'\'}\",\r\n\"label\": \"${skill!\'\'}\",\r\n\"datatype\": \"text\",\r\n\"webid\": \"${appid!\'\'}\",\r\n\"aiid\": \"${aiid!\'\'}\",\r\n\"userid\": \"${userid!\'\'}\"\r\n}', '4028811b642af06f01642af9cfa304c6', 'ukewo', null, null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b64f8d62b0164f94f2f01041f', '访客端推荐输出结构', null, 'clientoutput', null, '2018-08-02 14:24:33', null, null, '[<#if data?? && data.candidates?? && data.candidates?size gt 0><#list data.candidates as kb><#if kb_index gt 0>,</#if>\r\n{\r\n	\"id\":\"${kb.kbid!\'\'}\",\r\n	\"title\":\"${(kb.title!\'\')?replace(\'\\n\',\'\')}\",\r\n	\"content\":\"${(kb.question!\'\')?replace(\'\\n\',\'\')}\"\r\n}</#list></#if>\r\n]', '4028811b642af06f01642af9cfaf04c7', 'ukewo', null, null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b655f56f501655fd402f305ad', '组织机构', null, 'organ', null, '2018-08-22 12:10:54', null, null, '<div class=\"layui-form-item\">\r\n	<div class=\"layui-inline\"> \r\n		<div class=\"layui-input-inline\" style=\"position: relative;\">\r\n			<input type=\"hidden\" name=\"${filter.code!\'\'}\"  id=\"${filter.code!\'\'}\" value=\"\">\r\n			<input type=\"text\" name=\"${filter.code!\'\'}_name\"  id=\"${filter.code!\'\'}_name\" required value=\"\" lay-verify=\"required\" autocomplete=\"off\" readOnly=\"readonly\" onClick=\"showMenu();\"\r\n				class=\"layui-input\">\r\n			<i class=\"layui-icon\" style=\"position: absolute;right: 3px;top: 6px;font-size: 25px;${systemConfig.color!\'color:#0096C4;\'}\" onClick=\"showMenu()\">&#xe631;</i>\r\n			<div id=\"menuContent\" style=\"display:none; position: absolute;z-index:10000;\" class=\"ukefu-ztree\">\r\n				<ul id=\"${filter.code!\'\'}_Tree\" class=\"ztree\" style=\"width:208px;\"></ul>\r\n			</div>\r\n		</div>\r\n	</div>\r\n</div>\r\n<SCRIPT type=\"text/javascript\">\r\n	var setting = {\r\n		data: {\r\n			simpleData: {\r\n				enable: true\r\n			}\r\n		},\r\n		callback: {\r\n			onClick: onClick,\r\n			beforeClick: beforeClick\r\n		}\r\n	};\r\n	\r\n	function beforeClick(treeId, treeNode) {\r\n		var zTree = $.fn.zTree.getZTreeObj(\"${filter.code!\'\'}_Tree\")\r\n		nodes = zTree.getSelectedNodes();\r\n		var allow = true , lastnode ;\r\n		for (var i=0, l=nodes.length; i<l; i++) {\r\n			lastnode = nodes[i].type ;\r\n			if(nodes[i].organ && (nodes.length >= 1 && (event.ctrlKey || event.shiftKey))){\r\n				allow = false ; break ;\r\n			}\r\n		}\r\n		if(lastnode != treeNode.type && (event.ctrlKey || event.shiftKey)){\r\n			allow = false ;\r\n		}\r\n		\r\n		if (allow == false) {\r\n			top.layer.alert(\"组织机构不能点选多个上级机构，也不能同时选择地区和机构\", {icon: 3});\r\n			return false;\r\n		} else {\r\n			return true;\r\n			\r\n		}\r\n	}\r\n	function onClick(e, treeId, treeNode) {\r\n		var zTree = $.fn.zTree.getZTreeObj(\"${filter.code!\'\'}_Tree\"),\r\n		nodes = zTree.getSelectedNodes(),\r\n		v = \"\" , value = \"\";\r\n		nodes.sort(function compare(a,b){return a.id-b.id;});\r\n		for (var i=0, l=nodes.length; i<l; i++) {\r\n			v += nodes[i].name + \"\";\r\n			if(value != \"\"){\r\n				value = value + \",\" ;\r\n			}\r\n			value = nodes[i].id ;\r\n		}\r\n		$(\"#${filter.code!\'\'}_name\").attr(\"value\", v);\r\n		$(\"#${filter.code!\'\'}\").attr(\"value\", value);\r\n		if (!event.ctrlKey && !event.shiftKey) {\r\n			hideMenu() ;\r\n		}\r\n	}\r\n\r\n	var zNodes =[\r\n	    { id:\'0\', pId:\'00\', name:\"${filter.name!\'\'}\", open:true , organ : true, type : \"organ\"}\r\n	    <#if organList??>\r\n	    <#list organList as organ>\r\n	    ,{ id:\'${organ.id!\'\'}\', pId:\'${organ.parent!\'0\'}\', name:\"${organ.name!\'\'}\", open:true , organ : true , type : \"organ\",  icon:\"/images/dept.png\" }\r\n	    </#list>\r\n	    </#if>\r\n	];\r\n	$(document).ready(function(){\r\n		var ztree = $.fn.zTree.init($(\"#${filter.code!\'\'}_Tree\"), setting, zNodes);\r\n		<#if organ??>\r\n		var node = ztree.getNodeByParam(\'id\', \'${organ.id!\'\'}\');//获取id为1的点\r\n		ztree.selectNode(node);//选择点  \r\n		</#if>\r\n	 \r\n	});\r\n	function showMenu() {\r\n		$(\"#menuContent\").css({left:\"0px\", top:\"38px\"}).show();\r\n\r\n		$(\"body\").bind(\"mousedown\", onBodyDown);\r\n	}\r\n	function hideMenu() {\r\n		$(\"#menuContent\").hide();\r\n		$(\"body\").unbind(\"mousedown\", onBodyDown);\r\n	}\r\n	function onBodyDown(event) {\r\n		if (!(event.target.id == \"menuBtn\" || event.target.id == \"menuContent\" || $(event.target).parents(\"#menuContent\").length>0)) {\r\n			hideMenu();\r\n		}\r\n	}\r\n</SCRIPT>', '4028811b618d0dca01618d5a5ff6034b', 'ukewo', '/images/design/select.png', null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('4028811b657e067301657fe068b70822', '六列布局', null, 'six', null, '2018-08-28 17:32:17', null, null, '<div class=\"layui-col-md2 ukefu-col\" data-colspan=\"2\" data-index=\"1\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 1>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>\r\n<div class=\"layui-col-md2 ukefu-col\" data-colspan=\"2\" data-index=\"2\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 2>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>\r\n<div class=\"layui-col-md2 ukefu-col\" data-colspan=\"2\" data-index=\"3\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 3>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>\r\n<div class=\"layui-col-md2 ukefu-col\" data-colspan=\"2\" data-index=\"4\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 4>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>\r\n<div class=\"layui-col-md2 ukefu-col\" data-colspan=\"2\" data-index=\"5\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 5>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>\r\n<div class=\"layui-col-md2 ukefu-col\" data-colspan=\"2\" data-index=\"6\" data-mid=\"${model.id}\">\r\n	<#list reportModels as element>\r\n	<#if element.parentid?? && element.parentid == model.id && element.colindex == 6>\r\n	<#assign eltemplet = element.templet()>\r\n	<#include \"/apps/business/report/design/element.html\">\r\n	</#if>\r\n	</#list>\r\n</div>', '4028811b618d0dca01618d5a5fd10349', 'ukewo', '/images/design/four.png', null, null, null, null, '6', null, null);
  INSERT INTO `uk_templet` VALUES ('402881e861da4c960161da74a89e0386', '报表XML模板', null, 'reportquery', null, '2018-02-28 11:28:53', null, null, '<?xml version=\'1.0\' ?>\r\n<Schema name=\'ukefu\'>\r\n    <#if !cube.modeltype?? || cube.modeltype!=\"1\">\r\n    <Cube name=\'${cube.name}\'>\r\n		<#if cube.sql?? && cube.sql?length gt 0>\r\n		<View alias=\'${cube.table}\'>\r\n                        <SQL>                              \r\n							${(cube.sql!\'\')?html}\r\n                        </SQL>\r\n                </View>\r\n		<#else>\r\n		<Table name=\'${cube.table}\' />\r\n                </#if>\r\n		\r\n		<#if reportModel.properties?? && reportModel.properties?size gt 0 >\r\n			<Dimension name=\'${reportModel.name}\'>\r\n				<Hierarchy hasAll=\'true\' allMemberName=\'\'>						\r\n					<#list reportModel.properties as property>\r\n						<#list cube.dimension as dimension>\r\n							<#list dimension.cubeLevel as level>\r\n							<#if property.dataid == level.id>\r\n							<Level name=\'${level.name}\'  column=\'<#if dimension.fktable?? && dimension.fktable!= \"\">${level.tableproperty.key}<#else>${level.nameAlias}</#if>\' uniqueMembers=\'${level.uniquemembers?string}\'  <#if level.parameters??>${level.parameters!\"\"}</#if>>\r\n								<#if level.attribue?? && level.attribue?length gt 0>${level.attribue!\"\"}</#if>\r\n								</Level>	\r\n							</#if>						\r\n							</#list>	\r\n						</#list>					\r\n					</#list>			\r\n				</Hierarchy>\r\n			</Dimension>        \r\n		</#if>\r\n		<#if istable?? && istable && reportModel.colproperties?? && reportModel.colproperties?size gt 0>\r\n			<Dimension name=\'${reportModel.name}_col\'>\r\n				<Hierarchy hasAll=\'true\' allMemberName=\'\'>\r\n					<#if reportModel.colproperties??>\r\n					<#list reportModel.colproperties as property>\r\n						<#list cube.dimension as dimension>\r\n							<#list dimension.cubeLevel as level>\r\n							<#if property.dataid == level.id>\r\n							<Level name=\'${level.name}\'  column=\'<#if dimension.fktable?? && dimension.fktable!= \"\">${level.tableproperty.key}<#else>${level.nameAlias}</#if>\' uniqueMembers=\'${level.uniquemembers?string}\'  <#if level.parameters??>${level.parameters!\"\"}</#if>>\r\n								<#if level.attribue?? && level.attribue?length gt 0>${level.attribue!\"\"}</#if>\r\n								</Level>	\r\n							</#if>						\r\n							</#list>	\r\n						</#list>					\r\n					</#list>\r\n					</#if>\r\n				</Hierarchy>\r\n			</Dimension>\r\n		</#if>\r\n\r\n		<#if cube.measure??>\r\n			<#list cube.measure as measure>				\r\n				<#if measure.calculatedmember != true>\r\n				<Measure name=\'${measure.name}\' <#if measure.attribue?? && measure.attribue?length gt 0><#else>column=\'${measure.nameAlias}\'</#if> aggregator=\'${measure.aggregator}\' <#if measure.formatstring != \'\'>formatString=\'${measure.formatstring!\"####\"}\'<#else>formatString=\'####\'</#if>>\r\n						<#if measure.attribue?? && measure.attribue?length gt 0>\r\n						${measure.attribue!\"\"}\r\n						</#if>\r\n				</Measure>\r\n				</#if>\r\n			</#list>\r\n        </#if>\r\n		\r\n\r\n		<#if cube.measure??>\r\n			<#list cube.measure as measure>				\r\n				<#if measure.calculatedmember == true>\r\n					<CalculatedMember name=\'${measure.name}\' dimension=\'Measures\' <#if measure.parameters??>${measure.parameters!\"\"}</#if> <#if measure.formatstring?? && measure.formatstring?length gt 0>formatString=\"${measure.formatstring!\"\"}\"</#if>>\r\n                             <#if measure.attribue?? && measure.attribue?length gt 0>${measure.attribue!\"\"}</#if>\r\n                        </CalculatedMember>\r\n				</#if>\r\n			</#list>\r\n		</#if>\r\n\r\n		</Cube>	\r\n	</#if>\r\n</Schema>', '402881e861da4c960161da7040bc0385', 'ukewo', null, null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('402881e861da4c960161da74a89e0387', '过滤器XML模板', '', 'filterquery', '', '2018-02-28 11:28:53', '', null, '<?xml version=\'1.0\' ?>\r\n<Schema name=\'ukefu\'>\r\n    <Cube name=\'filterquery\'>\r\n		<#if sql?? && sql?length gt 0>\r\n		<View alias=\'filter\'>\r\n                        <SQL>                              \r\n							${(sql!\'\')?html}\r\n                        </SQL>\r\n                </View>\r\n		</#if>		\r\n		<Dimension name=\'KEYVAL\'>\r\n			<Hierarchy hasAll=\'true\' allMemberName=\'\'>						\r\n				<Level name=\'KEYVAL\'  column=\'KEYVAL\' uniqueMembers=\'\' />	\r\n				<Level name=\'VAL\'  column=\'VAL\' uniqueMembers=\'\' />						\r\n			</Hierarchy>\r\n		</Dimension>		\r\n		</Cube>	\r\n</Schema>\r\n', '402881e861da4c960161da7040bc0385', 'ukewo', null, '', null, '', null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('402881fb62084b98016208652dea0393', '文本框', null, 'text', null, '2018-03-09 09:34:31', null, null, '<#if filter?? && filter.modeltype == \'text\'>\r\n	<#if filter.valuefiltertype ==\'range\'>\r\n		<div class=\"layui-inline\">\r\n		    <div class=\"layui-input-inline\" style=\"width: 80px;\">\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}_startvalue\" id=\"${filter.code!\'\'}_startvalue\"  class=\"layui-input\" value=\"${filter.requeststartvalue!\'\'}\" <#if filter.mustvalue?? && filter.mustvalue==\'mustvalue\'>lay-verify=required</#if> >\r\n		    </div>\r\n		    <div class=\"layui-form-mid\">-</div>\r\n		    <div class=\"layui-input-inline\" style=\"width: 80px;\">\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}_endvalue\" id=\"${filter.code!\'\'}_endvalue\"  class=\"layui-input\"  value=\"${filter.requestendvalue!\'\'}\" <#if filter.mustvalue?? && filter.mustvalue==\'mustvalue\'>lay-verify=required</#if>>\r\n		    </div>\r\n		  </div>\r\n	<#else>\r\n		<div class=\"layui-input-inline\" >\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}\"  id=\"${filter.code!\'\'}\"  class=\"layui-input\" value=\"${filter.requestvalue!\'\'}\" <#if filter.mustvalue?? && filter.mustvalue==\'mustvalue\'>lay-verify=required</#if>>\r\n		    </div>\r\n	</#if>\r\n</#if>\r\n<#if filter?? && filter.modeltype == \'date\'>\r\n	<#if filter.valuefiltertype ==\'range\'>\r\n		<div class=\"layui-inline\" style=\"margin-right:0px;\">\r\n		    <div class=\"layui-input-inline\" style=\"width: 98px;\">\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}\" class=\"layui-input\" value=\"${filter.requeststartvalue!\'\'}\" id=\"${filter.code!\'\'}_startvalue\" >\r\n		    </div>\r\n		    <div class=\"layui-form-mid\">-</div>\r\n		    <div class=\"layui-input-inline\" style=\"width: 98px;\">\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}_endvalue\"  class=\"layui-input\"  value=\"${filter.requestendvalue!\'\'}\" id=\"${filter.code!\'\'}_endvalue\" >\r\n		    </div>\r\n		  </div>\r\n		  <script>\r\n			   	layui.use(\'laydate\', function(){\r\n			  	  	var laydate = layui.laydate;\r\n			  		laydate.render({ \r\n			   	  		elem: document.getElementById(\'${filter.code!\'\'}_startvalue\'),\r\n			   		  	value: \'${filter.startvalue!\'\'}\',\r\n			   		  	type:UKHelper.getLayDateType(\'${filter.formatstr!\'\'}\'),\r\n			   		 	format: \'${filter.formatstr!\'\'}\'\r\n			   		});\r\n			  		laydate.render({ \r\n			   	  		elem: document.getElementById(\'${filter.code!\'\'}_endvalue\'),\r\n			   		  	value: \'${filter.endvalue!\'\'}\',\r\n			   		  	type:UKHelper.getLayDateType(\'${filter.formatstr!\'\'}\'),\r\n			   		 	format: \'${filter.formatstr!\'\'}\'\r\n			   		});\r\n			  	});\r\n		   	</script>\r\n	<#else>\r\n		<div class=\"layui-input-inline\" >\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}\" id=\"${filter.code!\'\'}\"  class=\"layui-input\" >\r\n		    </div>\r\n		   	<script>\r\n			   	layui.use(\'laydate\', function(){\r\n			  	  	var laydate = layui.laydate;\r\n			  		laydate.render({ \r\n			   	  		elem: document.getElementById(\'${filter.code!\'\'}\'),\r\n			   		  	value: \'${filter.requestvalue!\'\'}\',\r\n			   		  	type:UKHelper.getLayDateType(\'${filter.formatstr!\'\'}\'),\r\n			   		 	format: \'${filter.formatstr!\'\'}\'\r\n			   		});\r\n			  	});\r\n		   	</script>\r\n	</#if>\r\n</#if>\r\n<#if filter?? && filter.modeltype == \'sigsel\'>\r\n	<#if filter.valuefiltertype ==\'range\'>\r\n	<#else>\r\n		<div class=\"layui-input-inline\" >\r\n		 	<select  <#if filter.mustvalue?? && filter.mustvalue==\'mustvalue\'>lay-verify=required</#if>  name=\"${filter.code!\'\'}\" lay-filter=${filter.code!\'\'} id=\"${filter.code!\'\'}\">\r\n				<option value=\"\" <#if !(filter.requestvalue??)>selected=selected</#if> >请选择</option>\r\n				  <#if  filter.reportData.col?? && filter.reportData.col.childeren ??>\r\n					<#list filter.reportData.col.childeren as val>\r\n		  				<option value=\"${val.name!\'\'}\" <#if filter.requestvalue == val.name>selected=selected</#if> ><#list val.childeren as key><#if key_index ==1>${key.name!\'\'}</#if></#list></option>\r\n			  		</#list>\r\n				  </#if>\r\n			</select>\r\n		 </div>\r\n		 <script>\r\n			layui.use(\'form\', function(){\r\n			  var form = layui.form;\r\n			  <#if filter?? && filter.childFilter??>\r\n			  form.on(\'select(${filter.code!\'\'})\', function(data){\r\n				  if($(\'#item_${filter.childFilter.code}\')){\r\n					  loadURL(\'/apps/report/design/filtervalchange.html?id=${filter.modelid}&fid=${filter.childFilter.id!\'\'}&publishedid=<#if publishedReport??>${publishedReport.id!\'\'}<#else></#if>&${filter.code!\'\'}=\'+data.value, \'#item_${filter.childFilter.code}\'); \r\n				  }\r\n			  });\r\n			  </#if>\r\n			  form.render();\r\n			});\r\n			</script>\r\n	</#if>\r\n</#if>\r\n', '4028811b618d0dca01618d5a5ff6034b', 'ukewo', '/images/design/table.png', null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('402881fb6208a81f016208b1f59d038e', '日期选择', null, 'date', null, '2018-03-09 10:58:23', null, null, '<#if filter?? && filter.modeltype == \'text\'>\r\n	<#if filter.valuefiltertype ==\'range\'>\r\n		<div class=\"layui-inline\">\r\n		    <div class=\"layui-input-inline\" style=\"width: 80px;\">\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}_startvalue\" id=\"${filter.code!\'\'}_startvalue\"  class=\"layui-input\" value=\"${filter.requeststartvalue!\'\'}\" <#if filter.mustvalue?? && filter.mustvalue==\'mustvalue\'>lay-verify=required</#if> >\r\n		    </div>\r\n		    <div class=\"layui-form-mid\">-</div>\r\n		    <div class=\"layui-input-inline\" style=\"width: 80px;\">\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}_endvalue\" id=\"${filter.code!\'\'}_endvalue\"  class=\"layui-input\"  value=\"${filter.requestendvalue!\'\'}\" <#if filter.mustvalue?? && filter.mustvalue==\'mustvalue\'>lay-verify=required</#if>>\r\n		    </div>\r\n		  </div>\r\n	<#else>\r\n		<div class=\"layui-input-inline\" >\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}\"  id=\"${filter.code!\'\'}\"  class=\"layui-input\" value=\"${filter.requestvalue!\'\'}\" <#if filter.mustvalue?? && filter.mustvalue==\'mustvalue\'>lay-verify=required</#if>>\r\n		    </div>\r\n	</#if>\r\n</#if>\r\n<#if filter?? && filter.modeltype == \'date\'>\r\n	<#if filter.valuefiltertype ==\'range\'>\r\n		<div class=\"layui-inline\" style=\"margin-right:0px;\">\r\n		    <div class=\"layui-input-inline\" style=\"width: 98px;\">\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}\" class=\"layui-input\" value=\"${filter.requeststartvalue!\'\'}\" id=\"${filter.code!\'\'}_startvalue\" >\r\n		    </div>\r\n		    <div class=\"layui-form-mid\">-</div>\r\n		    <div class=\"layui-input-inline\" style=\"width: 98px;\">\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}_endvalue\"  class=\"layui-input\"  value=\"${filter.requestendvalue!\'\'}\" id=\"${filter.code!\'\'}_endvalue\" >\r\n		    </div>\r\n		  </div>\r\n		  <script>\r\n			   	layui.use(\'laydate\', function(){\r\n			  	  	var laydate = layui.laydate;\r\n			  		laydate.render({ \r\n			   	  		elem: document.getElementById(\'${filter.code!\'\'}_startvalue\'),\r\n			   		  	value: \'${filter.requeststartvalue!\'\'}\',\r\n			   		  	type:UKHelper.getLayDateType(\'${filter.formatstr!\'\'}\'),\r\n			   		 	format: \'${filter.formatstr!\'\'}\'\r\n			   		});\r\n			  		laydate.render({ \r\n			   	  		elem: document.getElementById(\'${filter.code!\'\'}_endvalue\'),\r\n			   		  	value: \'${filter.requestendvalue!\'\'}\',\r\n			   		  	type:UKHelper.getLayDateType(\'${filter.formatstr!\'\'}\'),\r\n			   		 	format: \'${filter.formatstr!\'\'}\'\r\n			   		});\r\n			  	});\r\n		   	</script>\r\n	<#else>\r\n		<div class=\"layui-input-inline\" >\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}\" id=\"${filter.code!\'\'}\"  class=\"layui-input\" >\r\n		    </div>\r\n		   	<script>\r\n			   	layui.use(\'laydate\', function(){\r\n			  	  	var laydate = layui.laydate;\r\n			  		laydate.render({ \r\n			   	  		elem: document.getElementById(\'${filter.code!\'\'}\'),\r\n			   		  	value: \'${filter.requeststartvalue!\'\'}\',\r\n			   		  	type:UKHelper.getLayDateType(\'${filter.formatstr!\'\'}\'),\r\n			   		 	format: \'${filter.formatstr!\'\'}\'\r\n			   		});\r\n			  	});\r\n		   	</script>\r\n	</#if>\r\n</#if>\r\n<#if filter?? && filter.modeltype == \'sigsel\'>\r\n	<#if filter.valuefiltertype ==\'range\'>\r\n	<#else>\r\n		<div class=\"layui-input-inline\" >\r\n		 	<select  <#if filter.mustvalue?? && filter.mustvalue==\'mustvalue\'>lay-verify=required</#if>  name=\"${filter.code!\'\'}\" lay-filter=${filter.code!\'\'} id=\"${filter.code!\'\'}\">\r\n				<option value=\"\" <#if !(filter.requestvalue??)>selected=selected</#if> >请选择</option>\r\n				  <#if  filter.reportData.col?? && filter.reportData.col.childeren ??>\r\n					<#list filter.reportData.col.childeren as val>\r\n		  				<option value=\"${val.name!\'\'}\" <#if filter.requestvalue == val.name>selected=selected</#if> ><#list val.childeren as key><#if key_index ==1>${key.name!\'\'}</#if></#list></option>\r\n			  		</#list>\r\n				  </#if>\r\n			</select>\r\n		 </div>\r\n		 <script>\r\n			layui.use(\'form\', function(){\r\n			  var form = layui.form;\r\n			  <#if filter?? && filter.childFilter??>\r\n			  form.on(\'select(${filter.code!\'\'})\', function(data){\r\n				  if($(\'#item_${filter.childFilter.code}\')){\r\n					  loadURL(\'/apps/report/design/filtervalchange.html?id=${filter.modelid}&fid=${filter.childFilter.id!\'\'}&publishedid=<#if publishedReport??>${publishedReport.id!\'\'}<#else></#if>&${filter.code!\'\'}=\'+data.value, \'#item_${filter.childFilter.code}\'); \r\n				  }\r\n			  });\r\n			  </#if>\r\n			  form.render();\r\n			});\r\n			</script>\r\n	</#if>\r\n</#if>', '4028811b618d0dca01618d5a5ff6034b', 'ukewo', '/images/design/calendar.png', null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('402881fb6208a81f016208b2491e038f', '单选下拉', null, 'sigsel', null, '2018-03-09 10:58:44', null, null, '<#if filter?? && filter.modeltype == \'text\'>\r\n	<#if filter.valuefiltertype ==\'range\'>\r\n		<div class=\"layui-inline\">\r\n		    <div class=\"layui-input-inline\" style=\"width: 80px;\">\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}_startvalue\" id=\"${filter.code!\'\'}_startvalue\"  class=\"layui-input\" value=\"${filter.requeststartvalue!\'\'}\" <#if filter.mustvalue?? && filter.mustvalue==\'mustvalue\'>lay-verify=required</#if> >\r\n		    </div>\r\n		    <div class=\"layui-form-mid\">-</div>\r\n		    <div class=\"layui-input-inline\" style=\"width: 80px;\">\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}_endvalue\" id=\"${filter.code!\'\'}_endvalue\"  class=\"layui-input\"  value=\"${filter.requestendvalue!\'\'}\" <#if filter.mustvalue?? && filter.mustvalue==\'mustvalue\'>lay-verify=required</#if>>\r\n		    </div>\r\n		  </div>\r\n	<#else>\r\n		<div class=\"layui-input-inline\" >\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}\"  id=\"${filter.code!\'\'}\"  class=\"layui-input\" value=\"${filter.requestvalue!\'\'}\" <#if filter.mustvalue?? && filter.mustvalue==\'mustvalue\'>lay-verify=required</#if>>\r\n		    </div>\r\n	</#if>\r\n</#if>\r\n<#if filter?? && filter.modeltype == \'date\'>\r\n	<#if filter.valuefiltertype ==\'range\'>\r\n		<div class=\"layui-inline\" style=\"margin-right:0px;\">\r\n		    <div class=\"layui-input-inline\" style=\"width: 98px;\">\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}\" class=\"layui-input\" value=\"${filter.requeststartvalue!\'\'}\" id=\"${filter.code!\'\'}_startvalue\" >\r\n		    </div>\r\n		    <div class=\"layui-form-mid\">-</div>\r\n		    <div class=\"layui-input-inline\" style=\"width: 98px;\">\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}_endvalue\"  class=\"layui-input\"  value=\"${filter.requestendvalue!\'\'}\" id=\"${filter.code!\'\'}_endvalue\" >\r\n		    </div>\r\n		  </div>\r\n		  <script>\r\n			   	layui.use(\'laydate\', function(){\r\n			  	  	var laydate = layui.laydate;\r\n			  		laydate.render({ \r\n			   	  		elem: document.getElementById(\'${filter.code!\'\'}_startvalue\'),\r\n			   		  	value: \'${filter.startvalue!\'\'}\',\r\n			   		  	type:UKHelper.getLayDateType(\'${filter.formatstr!\'\'}\'),\r\n			   		 	format: \'${filter.formatstr!\'\'}\'\r\n			   		});\r\n			  		laydate.render({ \r\n			   	  		elem: document.getElementById(\'${filter.code!\'\'}_endvalue\'),\r\n			   		  	value: \'${filter.endvalue!\'\'}\',\r\n			   		  	type:UKHelper.getLayDateType(\'${filter.formatstr!\'\'}\'),\r\n			   		 	format: \'${filter.formatstr!\'\'}\'\r\n			   		});\r\n			  	});\r\n		   	</script>\r\n	<#else>\r\n		<div class=\"layui-input-inline\" >\r\n		      <input type=\"text\" name=\"${filter.code!\'\'}\" id=\"${filter.code!\'\'}\"  class=\"layui-input\" >\r\n		    </div>\r\n		   	<script>\r\n			   	layui.use(\'laydate\', function(){\r\n			  	  	var laydate = layui.laydate;\r\n			  		laydate.render({ \r\n			   	  		elem: document.getElementById(\'${filter.code!\'\'}\'),\r\n			   		  	value: \'${filter.requestvalue!\'\'}\',\r\n			   		  	type:UKHelper.getLayDateType(\'${filter.formatstr!\'\'}\'),\r\n			   		 	format: \'${filter.formatstr!\'\'}\'\r\n			   		});\r\n			  	});\r\n		   	</script>\r\n	</#if>\r\n</#if>\r\n<#if filter?? && filter.modeltype == \'sigsel\'>\r\n	<#if filter.valuefiltertype ==\'range\'>\r\n	<#else>\r\n		<div class=\"layui-input-inline\" >\r\n		 	<select  <#if filter.mustvalue?? && filter.mustvalue==\'mustvalue\'>lay-verify=required</#if>  name=\"${filter.code!\'\'}\" lay-filter=${filter.code!\'\'} id=\"${filter.code!\'\'}\">\r\n				<option value=\"\" <#if !(filter.requestvalue??)>selected=selected</#if> >请选择</option>\r\n				  <#if  filter.reportData.col?? && filter.reportData.col.childeren ??>\r\n					<#list filter.reportData.col.childeren as val>\r\n		  				<option value=\"${val.name!\'\'}\" <#if filter.requestvalue == val.name>selected=selected</#if> ><#list val.childeren as key><#if key_index ==1>${key.name!\'\'}</#if></#list></option>\r\n			  		</#list>\r\n				  </#if>\r\n			</select>\r\n		 </div>\r\n		 <script>\r\n			layui.use(\'form\', function(){\r\n			  var form = layui.form;\r\n			  <#if filter?? && filter.childFilter??>\r\n			  form.on(\'select(${filter.code!\'\'})\', function(data){\r\n				  if($(\'#item_${filter.childFilter.code}\')){\r\n					  loadURL(\'/apps/report/design/filtervalchange.html?id=${filter.modelid}&fid=${filter.childFilter.id!\'\'}&publishedid=<#if publishedReport??>${publishedReport.id!\'\'}<#else></#if>&${filter.code!\'\'}=\'+data.value, \'#item_${filter.childFilter.code}\'); \r\n				  }\r\n			  });\r\n			  </#if>\r\n			  form.render();\r\n			});\r\n			</script>\r\n	</#if>\r\n</#if>\r\n', '4028811b618d0dca01618d5a5ff6034b', 'ukewo', '/images/design/select.png', null, null, null, null, '0', null, null);
  INSERT INTO `uk_templet` VALUES ('402881fb6266dcf0016266dfab860395', '短信模板', null, '111', null, '2018-03-27 17:52:37', null, null, '{\"name\":\"${patient_name!\'\'}\",\"desc\":\"${patient_desc!\'\'}\",\"othername\":\"${patient_g_name!\'\'}\"}\r\n', '402881fb6266c1bd016266c3d4070394', 'ukewo', null, null, null, null, null, '0', null, null);
  