<%@ page language="java" import="java.util.*" pageEncoding="UTF-8" %>
|
<%
|
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>
|
<!--[if !IE]><!-->
|
<link href="static/plugins/font-awesome/css/font-awesome.css" rel="stylesheet" type="text/css">
|
<!--<![endif]-->
|
<!--[if gt IE 8]>
|
<link href="static/plugins/font-awesome/css/font-awesome.css" rel="stylesheet" type="text/css">
|
<![endif]-->
|
<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/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/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>
|
<style>
|
.combobox-group {
|
clear: both;
|
}
|
|
.combobox-gitem {
|
float: left;
|
padding-right: 10px;
|
}
|
</style>
|
|
</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-newspaper-o"></i></span>
|
<div class="pt-title">
|
<div>
|
<h4>批量修改信息</h4>
|
</div>
|
</div>
|
</div>
|
</div>
|
<div class="pt-form">
|
<div class="ptbody">
|
<form id="updateForm">
|
<table style="width: 100%;">
|
<tr>
|
<td class="tbtitle">字段选择：</td>
|
<td>
|
<div>
|
<select name="colunm" id="column" style="width: 450px;" class="easyui-combobox"
|
data-options="required:true,editable:false,panelHeight:'auto'"></select>
|
</div>
|
</td>
|
</tr>
|
<tr>
|
<td class="tbtitle">修改方式：</td>
|
<td>
|
<div>
|
<input class="easyui-radiobutton" name="updateType" value="0"
|
data-options="onChange:updateTypeOnChange" label="更新">
|
<input class="easyui-radiobutton" name="updateType" value="1"
|
data-options="onChange:updateTypeOnChange" label="替换">
|
<input class="easyui-radiobutton" name="updateType" value="2"
|
data-options="onChange:updateTypeOnChange" label="合并">
|
|
</div>
|
</td>
|
</tr>
|
<tr id="updateVlaue_css">
|
<td class="tbtitle">更新值：</td>
|
<td>
|
<input id="updateVlaue" name="updateVlaue" class="easyui-textbox" type="text"
|
style="width:100%;" placeholder="若设为空值，请填写:空"/><br/><br/>
|
<font style="color: red">注：若想更新为空值，请填写文字:空。</font>
|
</td>
|
</tr>
|
<tr id="primaryData_css">
|
<td class="tbtitle">查找内容：</td>
|
<td>
|
<input id="primaryData" name="primaryData" class="easyui-textbox" type="text"
|
style="width:100%;"/>
|
</td>
|
</tr>
|
<tr id="replaceData_css">
|
<td class="tbtitle">替换内容：</td>
|
<td>
|
<input id="replaceData" name="replaceData" class="easyui-textbox" type="text"
|
placeholder="若设为空值，请填写:空"
|
style="width:100%;"/><br/><br/>
|
<font style="color: red">注：若想替换为空值，请填写文字:空。</font>
|
</td>
|
</tr>
|
<tr id="mergeData_css">
|
<td class="tbtitle">合并数据：</td>
|
<td>
|
<input id="mergeData" name="mergeData" class="easyui-textbox" type="text"
|
style="width:100%;" data-options="buttonText:'选字段',onClickButton:selectColumn"/>
|
</td>
|
</tr>
|
<tr id="separate_css">
|
<td class="tbtitle">分隔符：</td>
|
<td>
|
<input id="separate" name="separate" class="easyui-textbox" type="text"
|
style="width:100%;"/>
|
</td>
|
</tr>
|
<tr id="numType_css">
|
<td class="tbtitle">增加流水号：</td>
|
<td>
|
<div>
|
<input class="easyui-radiobutton" name="numType" value="0" label="否">
|
<input class="easyui-radiobutton" name="numType" value="1"
|
data-options="onChange:numTypeOnChange" label="是 ">
|
</div>
|
</td>
|
</tr>
|
<tr id="numData_css">
|
<td colspan="2">
|
<table>
|
<tr>
|
<td class="tbtitle">初始值：</td>
|
<td>
|
<input id="initValue" name="initValue" class="easyui-textbox" type="text"
|
style="width:100%;"/>
|
</td>
|
|
<td class="tbtitle">递增值：</td>
|
<td>
|
<input id="increaseValue" name="increaseValue" class="easyui-textbox"
|
type="text" style="width:100%;"/>
|
</td>
|
</tr>
|
<tr>
|
<td class="tbtitle">流水号长度：</td>
|
<td>
|
<input id="numLength" name="numLength" class="easyui-textbox" type="text"
|
style="width:100%;"/>
|
</td>
|
|
<td class="tbtitle">占位字符：</td>
|
<td>
|
<input id="quoteChar" name="quoteChar" class="easyui-textbox" type="text"
|
style="width:100%;"/>
|
</td>
|
</tr>
|
</table>
|
</td>
|
</tr>
|
</table>
|
</form>
|
</div>
|
<div class="pt-form-btn" style="bottom:0px;">
|
<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 = {
|
ids: null,
|
callBack: null
|
};
|
|
$(function () {
|
initColumn();
|
//初始化表单值(单选按钮)
|
$("input[radiobuttonName='updateType'][value='0']").radiobutton('check');
|
//updateTypeValue(0);
|
$("#btnSave").click(function () {
|
save();
|
});
|
|
|
$("#btnClose").click(function () {
|
closeWindow();
|
});
|
|
new ResizeScroll({
|
"id": ".ptbody",
|
fun: function () {
|
var wh = $(window).height();
|
return (wh - 69 - 62);
|
|
}
|
});
|
});
|
|
function updateTypeOnChange(checked) {
|
if (checked) {
|
var val = $(this).val();
|
updateTypeValue(val);
|
}
|
|
}
|
|
function updateTypeValue(val) {
|
if (val == "0") {
|
$("#updateVlaue_css").show();
|
$("#primaryData_css").hide();
|
$("#replaceData_css").hide();
|
$("#mergeData_css").hide();
|
$("#numType_css").hide();
|
$("#numData_css").hide();
|
$("#separate_css").hide();
|
//$("#initValue_css").hide();
|
//$("#increaseValue_css").hide();
|
//$("#numLength_css").hide();
|
//$("#quoteChar_css").hide();
|
$("#updateVlaue").textbox({
|
required: true,
|
});
|
$("#replaceData").textbox({
|
required: false,
|
});
|
$("#primaryData").textbox({
|
required: false,
|
});
|
$("#mergeData").textbox({
|
required: false,
|
});
|
} else if (val == "1") {
|
$("#updateVlaue_css").hide();
|
$("#primaryData_css").show();
|
$("#replaceData_css").show();
|
$("#mergeData_css").hide();
|
$("#numType_css").hide();
|
$("#numData_css").hide();
|
$("#separate_css").hide();
|
//$("#initValue_css").hide();
|
//$("#increaseValue_css").hide();
|
//$("#numLength_css").hide();
|
//$("#quoteChar_css").hide();
|
$("#updateVlaue").textbox({
|
required: false,
|
});
|
$("#replaceData").textbox({
|
required: true,
|
});
|
$("#primaryData").textbox({
|
required: true,
|
});
|
$("#mergeData").textbox({
|
required: false,
|
});
|
} else if (val == "2") {
|
$("#updateVlaue_css").hide();
|
$("#primaryData_css").hide();
|
$("#replaceData_css").hide();
|
$("#mergeData_css").show();
|
$("#numType_css").show();
|
$("#numData_css").hide();
|
$("#separate_css").show();
|
//$("#initValue_css").hide();
|
//$("#increaseValue_css").hide();
|
//$("#numLength_css").hide();
|
//$("#quoteChar_css").hide();
|
$("#updateVlaue").textbox({
|
required: false,
|
});
|
$("#replaceData").textbox({
|
required: false,
|
});
|
$("#primaryData").textbox({
|
required: false,
|
});
|
$("#mergeData").textbox({
|
required: true,
|
});
|
$("input[radiobuttonName='numType'][value='0']").radiobutton('check');
|
}
|
}
|
|
var mergeStr = "";
|
|
function numTypeOnChange(checked) {
|
if (checked) {
|
//$("#initValue_css").show();
|
//$("#increaseValue_css").show();
|
//$("#numLength_css").show();
|
//$("#quoteChar_css").show();
|
$("#numData_css").show();
|
var merge = mergeStr + "," + "[流水号]";
|
$('#mergeData').textbox("setValue", merge);
|
} else {
|
//$("#initValue_css").hide();
|
//$("#increaseValue_css").hide();
|
//$("#numLength_css").hide();
|
//$("#quoteChar_css").hide();
|
$("#numData_css").hide();
|
$('#mergeData').textbox("setValue", mergeStr);
|
}
|
}
|
|
function initColumn() {
|
$("#column").empty();
|
var tableName = "${view.mainTableName}";
|
var tableId = "${view.mainTableId}";
|
var data = [];
|
wcp.ui.setBusy("body", wcp.ajax({
|
url: "general/selectColumnList?tableId=" + tableId + "&tableName=" + tableName,
|
}).done(function (result) {
|
for (var i = 0; i < result.length; i++) {
|
if (i == 0) {
|
data.push({
|
"id": result[i].columnName,
|
"text": result[i].displayName,
|
"selected": true
|
});
|
} else {
|
data.push({
|
"id": result[i].columnName,
|
"text": result[i].displayName
|
});
|
}
|
|
}
|
//下拉框设置点击事件
|
$("#column").combobox({
|
panelHeight: 270,
|
data: data,
|
valueField: 'id',
|
textField: 'text'
|
});
|
}));
|
}
|
|
//目标模块选择字段
|
function selectColumn() {
|
var tableId = "${view.mainTableId}";
|
var idName = this.id;
|
var mergeData = $('#' + idName).textbox("getValue");
|
wcp.picker.selectTableColumn({
|
title: "请选择字段",
|
tableId: tableId,
|
multiSelect: true,
|
layerOpener: window
|
}, function (rows) {
|
var selectedColumns = "";
|
var selectedDisplayName = "";
|
$.each(rows, function (index, value) {
|
selectedColumns += value.columnName + ',';
|
selectedDisplayName += value.displayName + ',';
|
});
|
selectedColumns = selectedColumns.substr(0, selectedColumns.length - 1);
|
selectedDisplayName = selectedDisplayName.substr(0, selectedDisplayName.length - 1);
|
if (mergeData != "") {
|
selectedColumns = mergeData + "," + selectedColumns;
|
}
|
mergeStr = selectedColumns;
|
$('#' + idName).textbox("setValue", selectedColumns);
|
|
});
|
}
|
|
function save(val) {
|
var idList = params.ids;
|
var selText = $("#column").combobox("getText");
|
//验证表单信息
|
var isValid = $('#updateForm').form('validate');
|
if (!isValid) {
|
wcp.notify.warn('表单验证有误，请检查表单输入项！');
|
return;
|
}
|
|
var obj = $("#updateForm").serializeObject();
|
layer.confirm("确定要修改 [" + selText + "] 该字段数据吗？", {
|
icon: 3,
|
title: '提示'
|
}, function (index) {
|
wcp.ui.setBusy("body", wcp.ajax({
|
url: "general/save?tableName=" + "${view.mainTableName}",
|
data: JSON.stringify({
|
updateDate: obj,
|
idList: idList
|
}),
|
}).done(function (result) {
|
|
//判断是否需要执行回调函数
|
if (params.callBack) {
|
params.callBack();
|
}
|
closeWindow()
|
|
top.wcp.notify.success("保存成功！");
|
|
}));
|
});
|
}
|
|
function closeWindow() {
|
var index = top.layer.getFrameIndex(window.name); //获取窗口索引
|
top.layer.close(index);
|
}
|
</script>
|
|
</html>
|
