<%@ 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 rel="stylesheet" href="static/plugins/jquery-steps/css/main.css" type="text/css">
|
<link rel="stylesheet" href="static/plugins/jquery-steps/css/jquery.steps.css" type="text/css">
|
<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">
|
<link rel="stylesheet" href="static/plugins/webuploader/webuploader.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/scripts/ResizeScroll.js"></script>
|
<script type="text/javascript" src="static/plugins/jquery-easyui-edatagrid/jquery.edatagrid.js"></script>
|
<script type="text/javascript" src="static/plugins/jquery-easyui-datagrid-dnd/datagrid-dnd.js"></script>
|
<script src="static/plugins/ace/src-noconflict/ace.js" type="text/javascript"></script>
|
<script type="text/javascript" src="static/plugins/webuploader/webuploader.js"></script>
|
<!-- 弹窗加载组件 -->
|
<script type="text/javascript" src="static/plugins/layer/layer.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>
|
<div class="margin-lr">
|
<div class="pt-main-top clear">
|
<div class="pt-nav">
|
<span class="pt-title-icon">
|
<i class="fa fa-file-o"></i>
|
</span>
|
<div class="pt-title">
|
<div>
|
<h4>级联删除配置信息</h4>
|
</div>
|
</div>
|
</div>
|
</div>
|
<div class="pt-form">
|
<form id="formCasecadingDelete" method="post">
|
<div class="ptbody">
|
<input type="hidden" id="id" name="id" value="${cascadingDelete.id }" />
|
<input type="hidden" id="moduleId" name="moduleId" value="${cascadingDelete.moduleId }" />
|
<table style="width: 100%;">
|
<tr>
|
<td class="tbtitle" style="width:160px;">
|
<em class="pt-color-danger">*</em>本模块关联主表：
|
</td>
|
<td>
|
<div>
|
<input id="tableName" name="tableName" class="easyui-textbox" type="text" style="width:450px" data-options="required:true,buttonText:'选',onClickButton:selectTable" value="${cascadingDelete.tableName}" />
|
<input type="hidden" id="tableId" name="tableId" value="${cascadingDelete.tableId }" />
|
</div>
|
</td>
|
</tr>
|
<tr>
|
<td class="tbtitle">
|
<em class="pt-color-danger">*</em>级联模块名称：
|
</td>
|
<td>
|
<input id="cascadingModuleName" name="cascadingModuleName" class="easyui-textbox" type="text" style="width:450px" data-options="required:true,buttonText:'选',onClickButton:selectModule" value="${cascadingDelete.cascadingModuleName}" />
|
<input type="hidden" id="cascadingModuleId" name="cascadingModuleId" value="${cascadingDelete.cascadingModuleId }" />
|
</td>
|
</tr>
|
<tr>
|
<td class="tbtitle">
|
<em class="pt-color-danger">*</em>级联删除表名：
|
</td>
|
<td>
|
<input id="cascadingTableName" name="cascadingTableName" class="easyui-textbox" type="text" style="width:450px" data-options="required:true,buttonText:'选',onClickButton:selectCascadingTable" value="${cascadingDelete.cascadingTableName}" />
|
<input type="hidden" id="cascadingTableId" name="cascadingTableId" value="${cascadingDelete.cascadingTableId }" />
|
</td>
|
</tr>
|
<tr>
|
<td class="tbtitle">级联删除条件：</td>
|
<td>
|
<input id="cascadingCondition" name="cascadingCondition" class="easyui-textbox" type="text" style="width:450px;height:50px;" value="${cascadingDelete.cascadingCondition }" data-options="required:true,buttonText:'选',multiline:true,onClickButton:selectFields" />
|
<span class="pt-text-color">注：在条件中请将本模块主表字段加上“a.”前缀，级联模块表字段加上“b.”前缀</span>
|
</td>
|
</tr>
|
</table>
|
</div>
|
</form>
|
<div class="pt-form-btn">
|
<div class="form-group">
|
<shiro:hasPermission name="SYS_CONFIG.MODULE.OPERATION.CONFIG.CASCADINGDELETE.SAVE">
|
<button id="btnSave" class="pt-btn pt-btn-primary">保存</button>
|
</shiro:hasPermission>
|
<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 - 61);
|
|
}
|
});
|
|
$("#btnSave").click(function() {
|
//验证表单信息
|
var isValid = $('#formCasecadingDelete').form('validate');
|
if (!isValid) {
|
wcp.notify.warn('表单验证有误，请检查表单输入项！');
|
return false;
|
}
|
|
var obj = $("#formCasecadingDelete").serializeObject();
|
|
wcp.ui.setBusy("body", wcp.ajax({
|
url : "config/cascadingDelete/saveCascadingDelete",
|
data : JSON.stringify(obj),
|
}).done(function(result) {
|
//判断是否需要执行回调函数
|
if (params.callBack) {
|
params.callBack();
|
}
|
|
//关闭窗口
|
closeWindow();
|
|
top.wcp.notify.success("保存成功！");
|
}));
|
});
|
|
$("#btnClose").click(function() {
|
closeWindow();
|
});
|
});
|
|
function selectTable() {
|
wcp.picker.selectTable({
|
title : "请选择表",
|
multiSelect : false,
|
moduleId : $("#moduleId").val(),
|
idElement : "tableId",
|
nameElement : "tableName",
|
layerOpener : window
|
});
|
}
|
|
function selectCascadingTable() {
|
var moduleId = $("#cascadingModuleId").val();
|
if (moduleId == "") {
|
wcp.message.warn("请先选择级联删除模块！");
|
return;
|
}
|
|
wcp.picker.selectTable({
|
title : "请选择表",
|
multiSelect : false,
|
moduleId : moduleId,
|
idElement : "cascadingTableId",
|
nameElement : "cascadingTableName",
|
layerOpener : window
|
});
|
}
|
|
function selectModule() {
|
wcp.picker.selectModule({
|
title : "请选择模块",
|
multiSelect : false,
|
idElement : "cascadingModuleId",
|
nameElement : "cascadingModuleName",
|
layerOpener : window
|
});
|
}
|
|
function selectFields() {
|
var tableId = $("#tableId").val();
|
var cascadingTableId = $("#cascadingTableId").val();
|
var tableIds = tableId + "," + cascadingTableId;
|
wcp.picker.selectTableColumn({
|
title : "请选择字段",
|
tableId : tableIds,
|
multiSelect : true,
|
layerOpener : window
|
}, function(rows) {
|
var sql = $("#cascadingCondition").val();
|
var condition = "";
|
$.each(rows, function(index, value) {
|
if (index % 2 == 0 && condition != "") {
|
condition += " and ";
|
} else if (index % 2 == 1) {
|
condition += "=";
|
}
|
if (value.tableId == tableId) {
|
condition += "a.";
|
} else {
|
condition += "b.";
|
}
|
|
condition += value.columnName;
|
});
|
|
if (sql != "") {
|
condition = " and " + condition;
|
}
|
|
sql += condition;
|
|
$("#cascadingCondition").textbox("setValue", sql);
|
});
|
}
|
|
//关闭窗口事件
|
function closeWindow() {
|
var index = top.layer.getFrameIndex(window.name); //获取窗口索引
|
top.layer.close(index);
|
}
|
</script>
|
</html>
|
