skyversation
/
meidu2021


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390
							<html>
	<head>
		<title>动态报表配置抬头</title>
        <script type="text/javascript" src="plug-in/mutiLang/zh-cn.js"></script>
        <script type="text/javascript" src="plug-in/jquery/jquery-1.9.0.js"></script>
        <script type="text/javascript" src="plug-in/jquery/jquery.cookie.js"></script>
        <script type="text/javascript" src="plug-in/jquery-plugs/storage/jquery.storageapi.min.js"></script>
        <script type="text/javascript" src="plug-in/tools/dataformat.js"></script>
        <link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/metrole/easyui.css" type="text/css"></link>
        <link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/metrole/main.css" type="text/css"></link>
        <link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/metrole/icon.css" type="text/css"></link>
        <link rel="stylesheet" type="text/css" href="plug-in/accordion/css/accordion.css">
        <link rel="stylesheet" type="text/css" href="plug-in/accordion/css/icons.css">
        <script type="text/javascript" src="plug-in/easyui/jquery.easyui.min.1.3.2.js"></script>
        <script type="text/javascript" src="plug-in/easyui/locale/zh-cn.js"></script>
        <script type="text/javascript" src="plug-in/tools/syUtil.js"></script>
        <script type="text/javascript" src="plug-in/easyui/extends/datagrid-scrollview.js"></script>
        <link rel="stylesheet" href="plug-in/tools/css/metrole/common.css" type="text/css"></link>
        <link rel="stylesheet" href="plug-in/ace/css/font-awesome.css" type="text/css"></link>
        <script type="text/javascript" src="plug-in/lhgDialog/lhgdialog.min.js?skin=metrole"></script>
        <script type="text/javascript" src="plug-in/ace/js/bootstrap-tab.js"></script>
        <script type="text/javascript" src="plug-in/tools/curdtools_zh-cn.js"></script>
        <script type="text/javascript" src="plug-in/tools/easyuiextend.js"></script>
        <script type="text/javascript" src="plug-in/jquery-plugs/hftable/jquery-hftable.js"></script>
        <script type="text/javascript" src="plug-in/tools/json2.js"></script>
        <link rel="stylesheet" href="plug-in/Validform/css/style.css" type="text/css">
        <link rel="stylesheet" href="plug-in/Validform/css/tablefrom.css" type="text/css">
        <script type="text/javascript" src="plug-in/Validform/js/Validform_v5.3.1_min_zh-cn.js"></script>
        <script type="text/javascript" src="plug-in/Validform/js/Validform_Datatype_zh-cn.js"></script>
        <script type="text/javascript" src="plug-in/Validform/js/datatype_zh-cn.js"></script>
        <script src="plug-in/clipboard/ZeroClipboard.js"></script>
		<script type="text/javascript">
    		jQuery(function() {
    			storage = jQuery.localStorage;
    			if (!storage) storage = jQuery.cookieStorage;
    			jQuery('#cgreportConfigHeadList').datagrid({
    				idField: 'id',
    				title: '动态表头',
    				url: 'cgreportConfigHeadController.do?datagrid&field=id,code,name,cgrSql,dbSource,createBy,createDate,updateBy,updateDate,content,',
    				fit: true,
    				queryParams: {},
    				loadMsg: '数据加载中...',
    				pageSize: 10,
    				pagination: true,
    				pageList: [10, 20, 30],
    				sortName: 'createDate',
    				sortOrder: 'desc',
    				rownumbers: true,
    				singleSelect: false,
    				fitColumns: false,
    				striped: true,
    				showFooter: true,
    				frozenColumns: [[{
    					field: 'ck',
    					checkbox: 'true'
    				},
    				]],
    				columns: [[{
    					field: 'id',
    					title: '',
    					width: 120,
    					hidden: true,
    					sortable: true
    				},
    				{
    					field: 'code',
    					title: '编码',
    					width: 120,
    					sortable: true
    				},
    				{
    					field: 'name',
    					title: '名称',
    					width: 120,
    					sortable: true
    				},
    				{
    					field: 'cgrSql',
    					title: '查询sql',
    					width: 120,
    					sortable: true
    				},
    				{
    					field: 'dbSource',
    					title: '数据源',
    					width: 120,
    					sortable: true
    				},
    				{
    					field: 'createBy',
    					title: '创建人',
    					sortable: true
    				},
    				{
    					field: 'createDate',
    					title: '创建时间',
    					sortable: true,
    					formatter: function(value, rec, index) {
    						return new Date().format('yyyy-MM-dd', value);
    					}
    				},
    				{
    					field: 'updateBy',
    					title: '修改人',
    					sortable: true
    				},
    				{
    					field: 'updateDate',
    					title: '修改时间',
    					sortable: true,
    					formatter: function(value, rec, index) {
    						return new Date().format('yyyy-MM-dd', value);
    					}
    				},
    				{
    					field: 'content',
    					title: '描述',
    					width: 120,
    					sortable: true
    				},
    				{
    					field: 'opt',
    					title: '操作',
    					width: 100,
    					formatter: function(value, rec, index) {
    						if (!rec.id) {
    							return '';
    						}
    						var href = '';
    						href += "[<a href='#'  onclick=delObj('cgreportConfigHeadController.do?doDel&id=" + rec.id + "','cgreportConfigHeadList')>";
    						href += "删除</a>]";
    						href += "[<a href='#'   onclick=popMenuLink('" + rec.code + "','" + rec.name + "','" + index + "')>";
    						href += "配置地址</a>]";
    						return href;
    					}
    				}]],
    				onLoadSuccess: function(data) {
    					jQuery("#cgreportConfigHeadList").datagrid("clearSelections");
    				},
    				onClickRow: function(rowIndex, rowData) {
    					rowid = rowData.id;
    					gridname = 'cgreportConfigHeadList';
    				}
    			});
    			jQuery('#cgreportConfigHeadList').datagrid('getPager').pagination({
    				beforePageText: '',
    				afterPageText: '/{pages}',
    				displayMsg: '{from}-{to}共 {total}条',
    				showPageList: true,
    				showRefresh: true
    			});
    			jQuery('#cgreportConfigHeadList').datagrid('getPager').pagination({
    				onBeforeRefresh: function(pageNumber, pageSize) {
    					jQuery(this).pagination('loading');
    					jQuery(this).pagination('loaded');
    				}
    			});
    			try {
    				restoreheader();
    			} catch(ex) {}
    		});
    		function reloadTable() {
    			try {
    				jQuery('#' + gridname).datagrid('reload');
    				jQuery('#' + gridname).treegrid('reload');
    			} catch(ex) {}
    		}
    		function reloadcgreportConfigHeadList() {
    			jQuery('#cgreportConfigHeadList').datagrid('reload');
    		}
    		function getcgreportConfigHeadListSelected(field) {
    			return getSelected(field);
    		}
    		function getSelected(field) {
    			var row = jQuery('#' + gridname).datagrid('getSelected');
    			if (row != null) {
    				value = row[field];
    			} else {
    				value = '';
    			}
    			return value;
    		}
    		function getcgreportConfigHeadListSelections(field) {
    			var ids = [];
    			var rows = jQuery('#cgreportConfigHeadList').datagrid('getSelections');
    			for (var i = 0; i < rows.length; i++) {
    				ids.push(rows[i][field]);
    			}
    			ids.join(',');
    			return ids
    		};
    		function getSelectRows() {
    			return jQuery('#cgreportConfigHeadList').datagrid('getChecked');
    		}
    		function saveHeader() {
    			var columnsFields = null;
    			var easyextends = false;
    			try {
    				columnsFields = jQuery('#cgreportConfigHeadList').datagrid('getColumns');
    				easyextends = true;
    			} catch(e) {
    				columnsFields = jQuery('#cgreportConfigHeadList').datagrid('getColumnFields');
    			}
    			var cols = storage.get('cgreportConfigHeadListhiddenColumns');
    			var init = true;
    			if (cols) {
    				init = false;
    			}
    			var hiddencolumns = [];
    			for (var i = 0; i < columnsFields.length; i++) {
    				if (easyextends) {
    					hiddencolumns.push({
    						field: columnsFields[i].field,
    						hidden: columnsFields[i].hidden
    					});
    				} else {
    					var columsDetail = jQuery('#cgreportConfigHeadList').datagrid("getColumnOption", columnsFields[i]);
    					if (init) {
    						hiddencolumns.push({
    							field: columsDetail.field,
    							hidden: columsDetail.hidden,
    							visible: (columsDetail.hidden == true ? false: true)
    						});
    					} else {
    						for (var j = 0; j < cols.length; j++) {
    							if (cols[j].field == columsDetail.field) {
    								hiddencolumns.push({
    									field: columsDetail.field,
    									hidden: columsDetail.hidden,
    									visible: cols[j].visible
    								});
    							}
    						}
    					}
    				}
    			}
    			storage.set('cgreportConfigHeadListhiddenColumns', JSON.stringify(hiddencolumns));
    		}
    		function isShowBut() {
    			var isShowSearchId = jQuery('#isShowSearchId').val();
    			if (isShowSearchId == "true") {
    				jQuery("#searchColums").hide();
    				jQuery('#isShowSearchId').val("false");
    				jQuery('#columsShow').remove("src");
    				jQuery('#columsShow').attr("src", "plug-in/easyui/themes/default/images/accordion_expand.png");
    			} else {
    				jQuery("#searchColums").show();
    				jQuery('#isShowSearchId').val("true");
    				jQuery('#columsShow').remove("src");
    				jQuery('#columsShow').attr("src", "plug-in/easyui/themes/default/images/accordion_collapse.png");
    			}
    		}
    		function restoreheader() {
    			var cols = storage.get('cgreportConfigHeadListhiddenColumns');
    			if (!cols) return;
    			for (var i = 0; i < cols.length; i++) {
    				try {
    					if (cols.visible != false) jQuery('#cgreportConfigHeadList').datagrid((cols[i].hidden == true ? 'hideColumn': 'showColumn'), cols[i].field);
    				} catch(e) {}
    			}
    		}
    		function resetheader() {
    			var cols = storage.get('cgreportConfigHeadListhiddenColumns');
    			if (!cols) return;
    			for (var i = 0; i < cols.length; i++) {
    				try {
    					jQuery('#cgreportConfigHeadList').datagrid((cols.visible == false ? 'hideColumn': 'showColumn'), cols[i].field);
    				} catch(e) {}
    			}
    		}
    		function cgreportConfigHeadListsearch() {
    			try {
    				if (!jQuery("#cgreportConfigHeadListForm").Validform({
    					tiptype: 3
    				}).check()) {
    					return false;
    				}
    			} catch(e) {}
    			if (true) {
    				var queryParams = jQuery('#cgreportConfigHeadList').datagrid('options').queryParams;
    				jQuery('#cgreportConfigHeadListtb').find('*').each(function() {
    					queryParams[jQuery(this).attr('name')] = jQuery(this).val();
    				});
    				jQuery('#cgreportConfigHeadList').datagrid({
    					url: 'cgreportConfigHeadController.do?datagrid&field=id,code,name,cgrSql,dbSource,createBy,createDate,updateBy,updateDate,content,',
    					pageNumber: 1
    				});
    			}
    		}
    		function dosearch(params) {
    			var jsonparams = jQuery.parseJSON(params);
    			jQuery('#cgreportConfigHeadList').datagrid({
    				url: 'cgreportConfigHeadController.do?datagrid&field=id,code,name,cgrSql,dbSource,createBy,createDate,updateBy,updateDate,content,',
    				queryParams: jsonparams
    			});
    		}
    		function cgreportConfigHeadListsearchbox(value, name) {
    			var queryParams = jQuery('#cgreportConfigHeadList').datagrid('options').queryParams;
    			queryParams[name] = value;
    			queryParams.searchfield = name;
    			jQuery('#cgreportConfigHeadList').datagrid('reload');
    		}
    		jQuery('#cgreportConfigHeadListsearchbox').searchbox({
    			searcher: function(value, name) {
    				cgreportConfigHeadListsearchbox(value, name);
    			},
    			menu: '#cgreportConfigHeadListmm',
    			prompt: '请输入查询关键字'
    		});
    		function EnterPress(e) {
    			var e = e || window.event;
    			if (e.keyCode == 13) {
    				cgreportConfigHeadListsearch();
    			}
    		}
    		function searchReset(name) {
    			jQuery("#" + name + "tb").find(":input").val("");
    			var queryParams = jQuery('#cgreportConfigHeadList').datagrid('options').queryParams;
    			jQuery('#cgreportConfigHeadListtb').find('*').each(function() {
    				queryParams[jQuery(this).attr('name')] = jQuery(this).val();
    			});
    			jQuery('#cgreportConfigHeadList').datagrid({
    				url: 'cgreportConfigHeadController.do?datagrid&field=id,code,name,cgrSql,dbSource,createBy,createDate,updateBy,updateDate,content,',
    				pageNumber: 1
    			});
    		}
    		function popMenuLink(tableName, content) {
    			jQuery.dialog({
    				content: "url:cgreportConfigHeadController.do?popmenulink_vm&url=cgReportController.do?list&title=" + tableName,
    				drag: false,
    				lock: true,
    				title: '菜单链接[' + content + ']',
    				opacity: 0.3,
    				width: 400,
    				height: 80,
    				drag: false,
    				min: false,
    				max: false
    			}).zindex();
    		}
    	</script>
	</head>
	<body>
        <div class="easyui-layout" fit="true">
        	<div region="center" style="padding:0px;border:0px">
        		<table width="100%" id="cgreportConfigHeadList" toolbar="#cgreportConfigHeadListtb"></table>
        		<div id="cgreportConfigHeadListtb" style="padding:3px; height: auto">
        			<div name="searchColums" id="searchColums">
        				<input id="isShowSearchId" type="hidden" value="false" />
        				<input id="_sqlbuilder" name="sqlbuilder" type="hidden" />
        				<form id='cgreportConfigHeadListForm'>
        					<span style="display:-moz-inline-box;display:inline-block;">
        						<span style="vertical-align:middle;display:-moz-inline-box;display:inline-block;width: 80px;text-align:right;text-overflow:ellipsis;-o-text-overflow:ellipsis; overflow: hidden;white-space:nowrap; " title="编码">编码：</span>
        						<input onkeypress="EnterPress(event)" onkeydown="EnterPress()" type="text" name="code" class="inuptxt" style="width: 100px" />
        					</span>
        					<span style="display:-moz-inline-box;display:inline-block;">
        						<span style="vertical-align:middle;display:-moz-inline-box;display:inline-block;width: 80px;text-align:right;text-overflow:ellipsis;-o-text-overflow:ellipsis; overflow: hidden;white-space:nowrap; " title="名称">名称：</span>
        						<input onkeypress="EnterPress(event)" onkeydown="EnterPress()" type="text" name="name" class="inuptxt" style="width: 100px" />
        					</span>
        					<span style="display:-moz-inline-box;display:inline-block;">
        						<span style="vertical-align:middle;display:-moz-inline-box;display:inline-block;width: 80px;text-align:right;text-overflow:ellipsis;-o-text-overflow:ellipsis; overflow: hidden;white-space:nowrap; " title="查询sql">查询sql：</span>
        						<input onkeypress="EnterPress(event)" onkeydown="EnterPress()" type="text" name="cgrSql" class="inuptxt" style="width: 100px" />
        					</span>
        					<span style="display:-moz-inline-box;display:inline-block;">
        						<span style="vertical-align:middle;display:-moz-inline-box;display:inline-block;width: 80px;text-align:right;text-overflow:ellipsis;-o-text-overflow:ellipsis; overflow: hidden;white-space:nowrap; " title="数据源">数据源：</span>
        						<input onkeypress="EnterPress(event)" onkeydown="EnterPress()" type="text" name="dbSource" class="inuptxt" style="width: 100px" />
        					</span>
        					<span style="display:-moz-inline-box;display:inline-block;">
        						<span style="vertical-align:middle;display:-moz-inline-box;display:inline-block;width: 80px;text-align:right;text-overflow:ellipsis;-o-text-overflow:ellipsis; overflow: hidden;white-space:nowrap; " title="描述">描述：</span>
        						<input onkeypress="EnterPress(event)" onkeydown="EnterPress()" type="text" name="content" class="inuptxt" style="width: 100px" />
        					</span>
        				</form>
        			</div>
        			<div style="height:30px;" class="datagrid-toolbar">
        				<span style="float:left;">
        					<a href="#" class="easyui-linkbutton" plain="true" icon="icon-add" onclick="add('录入','cgreportConfigHeadController.do?goAdd_vm','cgreportConfigHeadList',1200,450)">录入</a>
        					<a href="#" class="easyui-linkbutton" plain="true" icon="icon-edit" onclick="update('编辑','cgreportConfigHeadController.do?goUpdate_vm','cgreportConfigHeadList',1200,450)">编辑</a>
        					<a href="#" class="easyui-linkbutton" plain="true" icon="icon-remove" onclick="deleteALLSelect('批量删除','cgreportConfigHeadController.do?doBatchDel','cgreportConfigHeadList',null,null)">批量删除</a>
        					<a href="#" class="easyui-linkbutton" plain="true" icon="icon-search" onclick="detail('查看','cgreportConfigHeadController.do?goUpdate_vm','cgreportConfigHeadList',1200,450)">查看</a>
        				</span>
        				<span style="float:right">
        					<a href="#" class="easyui-linkbutton" iconCls="icon-search" onclick="cgreportConfigHeadListsearch()">查询</a>
        					<a href="#" class="easyui-linkbutton" iconCls="icon-reload" onclick="searchReset('cgreportConfigHeadList')">重置</a>
        				</span>
        			</div>
        		</div>
        	</div>
		</div>
	</body>
</html>