<%@ page language="java" import="java.util.*" pageEncoding="UTF-8" trimDirectiveWhitespaces="true"%>
|
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
|
<%
|
String path = request.getContextPath();
|
String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
|
+ path + "/";
|
%>
|
|
<!DOCTYPE HTML>
|
<html>
|
<head>
|
<base href="<%=basePath%>">
|
|
<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/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]-->
|
<style>
|
.combobox-group {
|
clear: both;
|
}
|
</style>
|
|
</head>
|
<body>
|
<div class="margin-lr">
|
<div class="pt-form">
|
<form id="formCombinationQuery" method="post">
|
<div class="ptbody">
|
<table id="dg" style="width: 100%;">
|
<thead>
|
<tr>
|
<td>字段名称</td>
|
<td>查询条件</td>
|
<td>查询值</td>
|
</tr>
|
</thead>
|
<tbody>
|
<c:forEach var="column" items="${columnList}" varStatus="staturs">
|
<c:if test="${column.isNotForQuery==null || column.isNotForQuery=='0'}">
|
<tr>
|
<td>${column.displayName}
|
<input type="hidden" name="columnName" value="${column.columnName }" />
|
</td>
|
<td>
|
<select class="easyui-combobox" name="selectCondition" cname="${column.columnName }" style="width:150px" data-options="editable:false,panelHeight:'auto'">
|
<option value="=">等于</option>
|
<option value=">">大于</option>
|
<option value="<">小于</option>
|
<option value="!=">不等于</option>
|
<c:if test="${column.dataType=='varchar'||column.dataType=='text'}">
|
<option value="like">包含</option>
|
</c:if>
|
<c:if test="${column.dataType=='varchar'||column.dataType=='text'}">
|
<option value="not like">不包含</option>
|
</c:if>
|
</select>
|
</td>
|
<td>
|
<input class="easyui-textbox" type="text" name="searchValue" cname="${column.columnName }" style="width:200px" />
|
</td>
|
</tr>
|
</c:if>
|
</c:forEach>
|
</tbody>
|
</table>
|
|
</div>
|
</form>
|
<div class="pt-form-btn">
|
<div class="form-group">
|
<button id="btnSearch" 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,
|
parentName : null,
|
};
|
|
$(function() {
|
new ResizeScroll({
|
"id" : ".ptbody",
|
fun : function() {
|
var wh = $(window).height();
|
return (wh - -9 - 62);
|
}
|
});
|
|
//绑定按钮事件
|
$("#btnSearch").click(function() {
|
var obj = $("#formCombinationQuery").serializeObject2();
|
|
var ret = new Array();
|
for (var i = 0; i < obj.columnName.length; i++) {
|
if (obj.searchValue[i] != "") {
|
var item = {};
|
item.columnName = obj.columnName[i];
|
item.selectCondition = obj.selectCondition[i];
|
item.searchValue = obj.searchValue[i];
|
|
ret.push(item);
|
}
|
}
|
|
if (params.callBack) {
|
params.callBack(ret);
|
}
|
|
closeWindow();
|
});
|
|
$("#btnClose").click(function() {
|
closeWindow();
|
});
|
|
|
});
|
|
//加载已有条件
|
function loadCondition(conditions) {
|
if (conditions != null && conditions.length > 0) {
|
for (var i = 0; i < conditions.length; i++) {
|
$("select[cname='" + conditions[i].columnName + "']").combobox("setValue", conditions[i].selectCondition);
|
$("input[cname='" + conditions[i].columnName + "']").textbox("setValue", conditions[i].searchValue);
|
}
|
}
|
}
|
|
function closeWindow() {
|
var index = top.layer.getFrameIndex(window.name); //获取窗口索引
|
top.layer.close(index);
|
}
|
</script>
|
</html>
|
