sooka_maintenance
/
bsdsjj_siping


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273
							<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@include file="/commons/include/html_doctype.html"%>
<html ng-app="sysQuerySqlApp">
<head>
	<title>数据模板设置</title>
	<%@include file="/commons/include/form.jsp"%>
	<script type="text/javascript" src="${ctx}/js/lang/view/platform/form/zh_CN.js"></script>
	<link href="${ctx}/styles/default/css/hotent/dataRights.css" rel="stylesheet" />
	<script type="text/javascript" src="${ctx}/js/hotent/CustomValid.js"></script>
	<script type="text/javascript" src="${ctx}/js/hotent/platform/system/Share.js"></script>
	<script type="text/javascript" src="${ctx}/js/angular/angular.min.js"></script>
	<script type="text/javascript"src="${ctx}/js/angular/service/baseServices.js"></script>
	<script type="text/javascript" src="${ctx}/js/angular/module/DataRightsApp.js"></script>
	<script type="text/javascript" src="${ctx}/js/angular/service/sysQuerySqlService.js"></script>
	<script type="text/javascript" src="${ctx}/js/angular/controller/sysQuerySqlController.js"></script>
	<script>
		var dsList = ${dsList};
		var sysQuerySql = ${sysQuerySql};
		var globalTypesDICList = ${globalTypesDICList};
		var sysQueryFields = ${sysQueryFields};
	</script>
</head>
<body ng-controller="sysQuerySqlDefCtrl">
	<div class="panel" ng-show="hasInitTab">
		<div class="hide-panel">
			<div class="panel-top">
				<div class="panel-top">
					<div class="tbar-title">
						<span class="tbar-label">数据模板设置</span>
					</div>
					<div class="panel-toolbar">
						<div class="toolBar">
							<div class="group">
								<a class="link save" ng-click="save()" href="javascript:;">
									<span></span>
									保存
								</a>
							</div>
							<div class="group">
								<a class="link back" href="list.ht">
									<span></span>
									返回
								</a>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
		<div class="panel-body">
			<form id="sysQuerySqlForm">
				<div id="tab">
					<!-- 基本信息  start-->
					<div tabid="baseSetting" id="table" title="基本信息">
						<div>
							<div class="tbar-title">
								<span class="tbar-label">基本信息</span>
							</div>
							<table class="table-detail" cellpadding="0" cellspacing="0" border="0" type="main" style="border-width: 0 !important;">
								<tr>
									<th width="20%">
										名称：
										<span class="required">*</span>
									</th>
									<td>
										<input type="text" ng-model="sysQuerySql.name" validate="{required:true}" class="ht-input" ng-change="service.util.setPingyin(this,'sysQuerySql.name','sysQuerySql.alias')"/>
									</td>
									<th width="20%">别名：</th>
									<td >
										<input type="text" ng-model="sysQuerySql.alias" validate="{required:true}" class="ht-input" />
									</td>
								</tr>
								<tr>
									<th width="20%">数据源:</th>
									<td>
										<select ng-model="sysQuerySql.dsname"  class="ht-input">
											<option value="">请选择</option>
											<option ng-repeat="c in dsList" value="{{c.alias}}">
										        {{c.name}}
										    </option>
										</select>
									</td>
									<th width="20%">是否支持tab:</th>
									<td colspan="3">
										<input type="checkbox" ng-model="sysQuerySql.supportTab" ng-true-value=1 ng-false-value=0 ng-checked="sysQuerySql.supportTab==1" />
									</td>
								</tr>
								<tr>
									<th width="20%">
										SQL语句：
										<span class="required">*</span>
									</th>
									<td colspan="3" valign="top">
										<textarea ng-model="sysQuerySql.sql"
											rows="12" style="width: 80%;resize: none" validate="{required:true}" class="ht-input"></textarea>
										<br>
										<a class="button" ng-click="service.validSql(true)">
											<span class="icon valid"></span>
											<span>验证查询语句</span>
										</a>
									</td>
								</tr>
							</table>
						</div>
					</div>
					<!-- 基本信息  end-->
					<!-- 设置按钮  start-->
					<div tabid="urlSetting" id="table" title="设置按钮" ng-if="sysQuerySql.id">
						<div class="table-top-left">
							<div class="toolBar" style="margin: 0;">
								<div class="group">
									<a class="link add" ng-click="service.addUrl()">
										<span></span>
										添加
									</a>
								</div>
								<div class="l-bar-separator"></div>
								<div class="group">
									<a class="link del " ng-click="service.delUrl(sysQuerySql.buttonDef);">
										<span></span>
										删除
									</a>
								</div>
							</div>
						</div>
						<table class="table-grid fieldSetting">
							<thead>
								<tr>
									<th width="50">选择</th>
									<th width="100">行内按钮</th>
									<th width="250">名称</th>
									<th width="250">事件类型</th>
									<th >url路径
										<div class="tipbox">
											<a href="javascript:;" class="tipinfo">
												<span>URL路径可以使用列表的字段对象，例如：/platform/system/sysQueryView.ht?userid={USERID}&staus={STATUS},这里可以使用多个参数,每个参数使用大括号将字段名括起来。</span>
											</a>
										</div>
									</th>
									<th width="100">管理</th>
								</tr>
							</thead>
							<tbody>
								<tr ng-repeat="sq in sysQuerySql.buttonDef track by $index"  ng-class="{even:$index%2==0,odd:$index%2!=0}">
									<td >
										<input class="pk" type="checkbox" ng-model="sq.checked" ng-if="!sq.isDefault"></td>
									<td >
										<input ng-model="sq.inRow" type="checkbox"  ng-true-value=1 ng-false-value=0 ng-checked="sq.inRow == 1" ng-if="!sq.isDefault"/>
										<span ng-if="sq.isDefault" class="red">是</span>
									</td>
									<td>
										<input type="text" class="ht-input w100" ng-model="sq.name" validate="{required:true}" ng-if="!sq.isDefault" >
										<span ng-if="sq.isDefault" class="green">{{sq.name}}</span>
									</td>
									<td>
										<select ng-model="sq.triggerType" class="ht-input" ng-if="!sq.isDefault" >
											<option value="onclick">onclick</option>
											<option value="href">href</option>
										</select>
										<span ng-if="sq.isDefault" class="green">{{sq.triggerType}}</span>
									</td>
									<td>
										<input type="text" class="ht-input w100" ng-model="sq.urlPath" validate="{required:true}" ng-if="!sq.isDefault">
										<span ng-if="sq.isDefault" class="green" style="font-weight:bolder;">{{sq.urlPath}}</span>
									</td>
									<td>
										<a class="link del" href="javascript:;" ng-click="service.util.delTr(sysQuerySql.buttonDef,$index)" ng-if="!sq.isDefault"></a>
									</td>
								</tr>
							</tbody>
						</table>
					</div>
					<!-- 设置url  end-->
					<!-- 设置field start -->
					<div tabid="fieldSetting" id="table" title="设置字段" ng-if="sysQuerySql.id">
						<table cellpadding="1" cellspacing="1" class="table-detail fieldSetting">
							<thead>
								<tr>
									<th width="1%">序号</th>
									<th width="2%">顺序</th>
									<th width="2%">列名</th>
									<th width="2%">类型</th>
									<th width="5%">实际列名</th>
									<th width="5%">描叙</th>
									<th width="5%">宽度(%)
										<div class="tipbox" style="position: absolute;  margin: -2px 0px;"> 
											<a href="javascript:;" class="tipinfo">
												<span>为0表示自适应</span>
											</a>
										</div>
									</th>
									<th width="5%">控件类型</th>
									<th width="7%">
										<span>URL<div class="tipbox" style="position: absolute;  margin: -2px 0px;"> 
												<a href="javascript:;" class="tipinfo">
													<span>url 写法规则如下/platform/system/sysQueryView.ht?USERID={USERID},当前字段为USERID使用大括号括起来。</span>
												</a>
											</div>
										</span>
									</th>
									<th width="3%">
										<span><input type="checkbox" ng-model="isAllShow" 
												ng-click="service.changeCheckBox(sysQueryFields,'isShow',isAllShow)"/><br>是否显示
											</span>
									</th>
									<th width="3%">
										<span><input type="checkbox" ng-model="isAllSearch" 
												ng-click="service.changeCheckBox(sysQueryFields,'isSearch',isAllSearch)"/><br>是否查询</span>
									</th>
									<th width="3%">虚拟列
									</th>
									<th width="5%">管理</th>
								</tr>
							</thead>
							<tr ng-repeat="field in sysQueryFields" ng-class="{even:$index%2==0,odd:$index%2!=0}">
								<td  class="sequence" ng-class="{virtual_field:field.isVirtual==1}">{{$index+1}}</td>
								<td class="padding-none">
									<input type="text" ng-model="field.sn" field-sort class="ht-input" style="width: 40px;"/>
								</td>
								<td >{{field.name }}</td>
								<td >
									{{field.dataType}}
								</td>
								<td class="padding-none">
									<span ng-if="field.isVirtual==1">{{field.fieldName}}</span>
									<textarea ng-if="field.isVirtual==0" type="text" ng-model="field.fieldName" style="padding: 15px 0 0 0px;text-align: center;resize: none;width: 100px;" class="h100 border-none margin-none "></textarea>
								</td>
								<td class="padding-none">
									<textarea type="text" ng-model="field.fieldDesc" style="padding: 15px 0 0 0px;text-align: center;resize: none;width: 100px;" class="h100 border-none margin-none "></textarea>
								</td>
								<td class="padding-none">
									<input type="text" ng-model="field.width" class="ht-input" style="width: 50px;"/>
								</td>
								<td>
									{{service.getControlType(field.controlType,field.dataType)}}
								</td>
								<td class="padding-none">
									<input type="text" ng-model="field.url" class="ht-input" style="width: 100px;"/>
								</td>
								<td >
									<input ng-model="field.isShow"  type="checkbox" ng-true-value=1 ng-false-value=0 ng-checked="field.isShow==1"/>
								</td>
								<td  >
									<input ng-model="field.isSearch" type="checkbox" ng-if="field.isVirtual==0" ng-true-value=1 ng-false-value=0 ng-checked="field.isSearch==1" />
								</td>
								<td >
									<span style='color:red;cursor: auto;' ng-if="field.isVirtual==0">否</span>
									<span style='color:green;cursor: auto;' ng-if="field.isVirtual==1">是</span>
								</td>
								<td >
									<div >
										<span class="plus_button_info pull-left" style="margin-left:5px;"
											ng-if="field.isVirtual!=1" ng-click="service.ctrlTypeSetting(field,'sysQueryMetaField')" title="控件类型设置">控</span>
										<span class=" pull-left" ng-class="{plus_button_gray:!field.alarmSetting,plus_button_warning:field.alarmSetting}" style="margin-left:5px;"
											 ng-click="service.alarmSetting(field,'sysQueryMetaField')" title="报警与格式化设置">报</span>
										<span class="plus_button_success pull-left" style="margin-left:5px;"
											 ng-if="!service.hasVirtual(field)" ng-click="service.virtualSetting(field,'sysQueryMetaField',$index)" title="虚拟字段设置">虚</span>
										<span class="plus_button_success pull-left" style="margin-left: 5px; font-size: 10px; height: 20px; padding-top: 5px; padding-right: 4px;"
											 ng-if="field.isVirtual==1&&field.controlType==1" ng-click="service.sqlSetting(field,'sysQueryMetaField')" title="数据来源设置">SQL</span>
										<span class="pull-left plus_button_danger" style="margin-left:5px;"
											ng-if="field.isVirtual==1" ng-click="service.util.delTr(sysQueryFields,$index)" title="删除">X</span>
									</div>
								</td>
							</tr>
						</table>
					</div>
					<!-- 设置field end -->
				</div>
			</form>
		</div>
	</div>
</body>
</html>