<%@ page language="java" import="java.util.*" pageEncoding="UTF-8" trimDirectiveWhitespaces="true"%>
|
<%@ taglib uri="http://shiro.apache.org/tags" prefix="shiro"%>
|
<%
|
String path = request.getContextPath();
|
String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
|
+ path + "/";
|
%>
|
|
<!DOCTYPE HTML>
|
<html>
|
<head>
|
<base href="<%=basePath%>">
|
<meta name="viewport" charset="width=device-width, initial-scale=1.0">
|
<meta http-equiv="X-UA-Compatible" content="ie=edge">
|
<title>模块数据条件</title>
|
<link href="static/plugins/font-awesome/css/font-awesome.css" rel="stylesheet" type="text/css">
|
<link href="static/plugins/jquery-easyui/themes/bootstrap/easyui.css" rel="stylesheet" type="text/css">
|
<link rel="stylesheet" href="static/styles/initialize.css" type="text/css">
|
<link rel="stylesheet" href="static/styles/common.css" type="text/css">
|
<link rel="stylesheet" href="static/plugins/layer/skin/default/layer.css" type="text/css">
|
|
<script type="text/javascript" src="static/plugins/jquery/jquery.min.js"></script>
|
<script type="text/javascript" src="static/plugins/jquery-easyui/jquery.easyui.min.js"></script>
|
<script type="text/javascript" src="static/plugins/jquery-easyui/locale/easyui-lang-zh_CN.js"></script>
|
<script type="text/javascript" src="static/scripts/easyuiExtend.js"></script>
|
<script type="text/javascript" src="static/scripts/jquery-extend.js"></script>
|
<script type="text/javascript" src="static/plugins/layer/layer.js"></script>
|
<script type="text/javascript" src="static/plugins/slimScroll/jquery.slimscroll.min.js"></script>
|
|
<script type="text/javascript" src="static/plugins/spinjs/spin.js"></script>
|
<script type="text/javascript" src="static/plugins/spinjs/jquery.spin.js"></script>
|
<script type="text/javascript" src="static/plugins/jquery.blockUI.js"></script>
|
|
<!-- wcp组件 -->
|
<script type="text/javascript" src="static/wcp/scripts/wcp.js"></script>
|
<script type="text/javascript" src="static/wcp/scripts/libs/wcp.layer.js"></script>
|
<script type="text/javascript" src="static/wcp/scripts/libs/wcp.blockUI.js"></script>
|
<script type="text/javascript" src="static/wcp/scripts/libs/wcp.spin.js"></script>
|
<script type="text/javascript" src="static/wcp/scripts/libs/wcp.jquery.js"></script>
|
|
<!--[if lt IE 9]>
|
<script type="text/javascript" src="static/plugins/json2.js"></script>
|
<![endif]-->
|
<script type="text/javascript" src="static/wcp/scripts/libs/wcp.infoPicker.js"></script>
|
</head>
|
<body class="pt-tree">
|
<div class="margin-lr">
|
<div class="pt-main-top clear">
|
<div class="pt-nav">
|
<span class="pt-title-icon"><i class="fa fa-key"></i></span>
|
<div class="pt-title">
|
<div>
|
<h4>条件信息</h4>
|
</div>
|
</div>
|
</div>
|
</div>
|
<div class="pt-form">
|
<form id="formCondition" method="post">
|
<div class="ptbody">
|
<table style="width: 100%;">
|
<tr>
|
<td class="tbtitle" style="width: 140px;"><em class="pt-color-danger">*</em> 名称：</td>
|
<td>
|
<input id="conditionName" name="conditionName" class="easyui-textbox" type="text" data-options="required:true" style="width:100%" value="${moduleDataCondition.conditionName}" />
|
<input id="moduleId" name="moduleId" type="hidden" value="${module.moduleId}"/>
|
<input id="moduleName" name="moduleName" type="hidden" value="${module.moduleName}"/>
|
<input id="conditionId" name="conditionId" type="hidden" value="${moduleDataCondition.conditionId}"/>
|
</td>
|
</tr>
|
<tr>
|
<td class="tbtitle" style="width: 140px;">条件：</td>
|
<td>
|
<div style="margin-bottom:5px;">
|
<input id="unionKeyWord" class="easyui-combobox" style="margin-left:5px;"
|
data-options="
|
panelHeight: 'auto',
|
valueField: 'label',
|
textField: 'value',
|
editable: false,
|
width:80,
|
data: [{
|
label: 'and',
|
value: '[并且]',
|
selected: true
|
},{
|
label: 'or',
|
value: '[或者]'
|
}]" />
|
<input id="columnName" class="easyui-textbox" type="text" style="width:120px;" data-options="buttonText:'选字段',onClickButton:selectColumn"/>
|
<input id="compareKeyWord" class="easyui-combobox" style="margin-left:5px;"
|
data-options="
|
panelHeight: 'auto',
|
valueField: 'label',
|
textField: 'value',
|
editable: false,
|
width:80,
|
data: [{
|
label: '=',
|
value: '[等于]',
|
selected: true
|
},{
|
label: '>',
|
value: '[大于]'
|
},{
|
label: '<',
|
value: '[小于]'
|
}]" />
|
<input id="columnValue" class="easyui-textbox" type="text" style="width:150px;"/>
|
<a class="pt-btn pt-btn-default" onclick="confirmSql()"><i class="fa fa-check"></i>添加</a>
|
<a class="pt-btn pt-btn-default" onclick="clearSql()"><i class="fa fa-close"></i>清除</a>
|
</div>
|
<input id="conditionSql" name="conditionSql" class="easyui-textbox" type="text" class="easyui-textbox" data-options="required:true,multiline:true" style="height:70px;width:100%"
|
value="${moduleDataCondition.conditionSql}" />
|
|
</td>
|
</tr>
|
<tr>
|
<td class="tbtitle" style="width: 140px;">备注：</td>
|
<td><input id="remark" name="remark" class="easyui-textbox" type="text" class="easyui-textbox" data-options="multiline:true" style="height:100px;width:100%"
|
value="${moduleDataCondition.remark}" /></td>
|
</tr>
|
</table>
|
|
</div>
|
</form>
|
<div class="pt-form-btn">
|
<div class="form-group">
|
<button id="btnSave" class="pt-btn pt-btn-primary">保存</button>
|
<button id="btnClose" class="pt-btn pt-btn-default">关闭</button>
|
</div>
|
</div>
|
</div>
|
</div>
|
</body>
|
<script type="text/javascript" src="static/scripts/ResizeScroll.js"></script>
|
<script>
|
//窗口参数，用于弹窗传递
|
var params = {
|
callBack : null
|
};
|
|
$(function() {
|
//初始化表单值
|
new ResizeScroll({
|
"id" : ".ptbody",
|
fun : function() {
|
var wh = $(window).height();
|
return (wh - 69 - 62);
|
}
|
});
|
|
//绑定按钮事件
|
$("#btnSave").click(function() {
|
//验证表单信息
|
var isValid = $('#formCondition').form('validate');
|
if (!isValid) {
|
wcp.notify.warn('表单验证有误，请检查表单输入项！');
|
return false;
|
}
|
|
var obj = $("#formCondition").serializeObject();
|
|
wcp.ui.setBusy("body", wcp.ajax({
|
url : "config/moduleDataCondition/saveModuleDataCondition",
|
data : JSON.stringify(obj),
|
}).done(function(result) {
|
//判断是否需要执行回调函数
|
if (params.callBack) {
|
params.callBack();
|
}
|
//关闭窗口
|
closeWindow();
|
top.wcp.notify.success("保存成功！");
|
}));
|
});
|
|
$("#btnClose").click(function() {
|
closeWindow();
|
});
|
})
|
//选择字段
|
function selectColumn()
|
{
|
wcp.picker.selectTableColumn({
|
title : "请选择字段",
|
moduleId : '${module.moduleId}',
|
multiSelect : false,
|
layerOpener : window
|
}, function(rows) {
|
var columnName ="";
|
$.each(rows, function(index, value) {
|
columnName+=value.columnName+',';
|
});
|
columnName = columnName.substr(0, columnName.length - 1);
|
$('#columnName').textbox("setValue", columnName);
|
});
|
}
|
//确定
|
function confirmSql()
|
{
|
var unionKeyWord=$('#unionKeyWord').val();
|
var compareKeyWord=$('#compareKeyWord').val();
|
var columnName=$('#columnName').val();
|
var columnValue=$('#columnValue').val();
|
if(columnName=='')
|
{
|
wcp.notify.error("请选择字段！");
|
return;
|
}
|
if(columnValue=='')
|
{
|
wcp.notify.error("请请输入比较值！");
|
return;
|
}
|
var oldSql= $('#conditionSql').val();
|
if(oldSql.replace(/(^\s*)|(\s*$)/g, "")=="")
|
{
|
oldSql="";
|
sql=columnName+' '+compareKeyWord+" '"+columnValue+"'";
|
}else{
|
sql=unionKeyWord+' '+columnName+' '+compareKeyWord+" '"+columnValue+"'";
|
}
|
$('#conditionSql').textbox("setValue", oldSql+' '+sql);
|
}
|
//清除
|
function clearSql()
|
{
|
$('#conditionSql').textbox("setValue", '');
|
}
|
function closeWindow() {
|
var index = top.layer.getFrameIndex(window.name); //获取窗口索引
|
top.layer.close(index);
|
}
|
</script>
|
</html>
|
