<style>
|
.wizard > .content > .body ul > li {
|
line-height: 1;
|
}
|
|
.controls .chosen-container {
|
width: 75% !important;
|
}
|
</style>
|
<form class="form-horizontal" id="sjkbform" method="post" xmlns:th="http://www.w3.org/1999/xhtml">
|
<div class="portlet box ltblue">
|
<div class="portlet-title">
|
数据库表信息
|
<div class="caption">
|
<i class="fa fa-reorder"></i>
|
</div>
|
<div class="tools">
|
<a class="collapse" onclick="portlet_body_ShowOrHide(this);"></a>
|
</div>
|
</div>
|
<div class="portlet-body" style="margin-top:10px;">
|
<div class="row">
|
<div class="col-sm-6">
|
<div class="control-group">
|
<input type="hidden" class="form-control col-sm-11" id="tabletype" name="tabletype" />
|
<label class="control-label">数据源<span style="color: red;">*</span></label>
|
<div class="controls input-icon">
|
<input type="hidden" class="form-control col-sm-11" id="databasetype" name="databasetype" />
|
<input id="datasourceid" name="datasourceid" class="form-control col-sm-8" type="hidden" required="" />
|
<input id="databasename" class="form-control col-sm-7" style="width:57%" readonly="readonly" onpropertychange="" />
|
<button title="选择数据源" type="button" class="btn btn-primary" id="ShowDataBase" style="vertical-align:baseline; padding: 0.375em 0.7em;">选择</button>
|
<button title="新增数据源" type="button" class="btn btn-primary" onclick="addShuJuYuan();" style="vertical-align:baseline;padding: 0.375em 0.7em;">新增</button>
|
<span class="input-warning tooltips" data-original-title="">
|
<i class="fa-warning-sign" style="display: none;margin-left:30px;"></i>
|
</span>
|
</div>
|
</div>
|
</div>
|
<div class="col-sm-6" id="space">
|
<div class="control-group">
|
<label class="control-label">表空间</label>
|
<div class="controls input-icon">
|
<input id="spacename" name="spacename" class="form-control col-sm-9" />
|
</div>
|
</div>
|
</div>
|
</div>
|
<div class="row">
|
<div class="col-sm-6">
|
<div class="control-group">
|
<label class="control-label">表名称</label>
|
<div class="controls input-icon">
|
<select class="form-control col-sm-9" id="tablename" name="tablename" onchange="changeFieldConfig(this.value);">
|
<option value="">选择数据库表</option>
|
</select>
|
</div>
|
</div>
|
</div>
|
<div class="col-sm-6">
|
<div class="control-group">
|
<label class="control-label">主键<span style="color: red;">*</span></label>
|
<div class="controls input-icon">
|
<select id="primarykey" name="primarykey" class="form-control col-sm-9 form-control-chosen" multiple data-placeholder="请选择主键……" required="">
|
</select>
|
</div>
|
</div>
|
</div>
|
</div>
|
<div class="row">
|
<div class="col-sm-6">
|
<div class="control-group">
|
<label class="control-label">时间戳字段</label>
|
<div id="div_timefield" class="controls input-icon">
|
<input id="timestampfield" name="timestampfield" class="form-control col-sm-9" />
|
</div>
|
<div id="timefield" class="controls input-icon"></div>
|
</div>
|
</div>
|
</div>
|
<div class="row">
|
<div class="col-sm-12">
|
<div class="control-group">
|
<label class="control-label">字段配置<span style="color: red;">*</span></label>
|
<div class="controls input-icon">
|
<textarea required="" readonly="readonly" id="fieldconfig" name="fieldconfig" class="form-control col-sm-10" cols="20" style="height: 300px;float: left;"></textarea>
|
<button title="配置" type="button" class="btn btn-primary" onclick="peizhi()" style="padding: 0.375em 0.7em;float: left;margin: 266px 0px 0px 6px;">配置</button>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
</form>
|
<script th:inline="javascript">
|
$(function () {
|
cheackForm("sjkbform");
|
spaceShowOrHide();
|
zhujian();
|
$('#primarykey').chosen();
|
});
|
|
//弹出数据源页面
|
$("#ShowDataBase").on("click", function () {
|
layer.open({
|
type: 2,
|
title: "选择数据源",
|
shadeClose: true,
|
area: ["950px", "590px"],
|
content: "../../manage/datasource/panel_select"
|
})
|
})
|
|
function spaceShowOrHide() {
|
if ($("#databasetype").val() == "Oracle") {
|
$("#space").css("display", "");
|
} else {
|
$("#space").css("display", "none");
|
$("#spacename").val("");
|
}
|
}
|
|
//配置按钮 弹出窗口
|
function peizhi() {
|
var datasourceid = $("#datasourceid").val();
|
var primarykey = $("#primarykey").val();
|
//数据库表参数
|
var tablename = $("#tablename option:selected").val();
|
if (tablename == "") {
|
alert("请选择要打开的表");
|
return;
|
}
|
if (primarykey == null || primarykey == '') {
|
alert("请选择主键");
|
return;
|
}
|
window.open("/res/ResManage/ResRegister/ZiDuanBieMingBasic?datasourceid=" + datasourceid + "&tablename=" + tablename + "&resMainInfoId=0&primarykey=" + primarykey);
|
}
|
|
//当表名称改变时，获取表的主键
|
//var primarykeys = [[${keys}]];
|
function zhujian() {
|
var datasourceid = $("#datasourceid").val();
|
//数据库表参数
|
var tablename = $("#tablename option:selected").val();
|
if (tablename == "") {
|
//alert("请选择要打开的表")
|
} else {
|
var tabletype = $("#tabletype").val();
|
$.ajax({
|
url: '/res/ZiYuan/selectTabFileds',
|
type: 'post',
|
dataType: 'json',
|
data: {'datasourceid': datasourceid, 'tablename': tablename, 'tabletype': tabletype},
|
success: function (result) {
|
var option = "";
|
for (var i = 0; i < result.length; i++) {
|
var flag = false;
|
// for(var j=0;j<primarykeys.length;j++){
|
// if(result[i]==primarykeys[j]){
|
// option+="<option value='" + result[i] + "' selected='true' '>" + result[i] + "</option>";
|
// flag=true;
|
// break;
|
// }
|
// }
|
if (!flag) {
|
option += "<option value='" + result[i] + "'>" + result[i] + "</option>";
|
}
|
}
|
$("#primarykey").empty().append(option).trigger("chosen:updated");
|
$.ajax({
|
url: '/res/ZiYuan/selectDataField',
|
type: 'post',
|
dataType: 'json',
|
data: {'datasourceid': datasourceid, 'tablename': tablename},
|
success: function (result) {
|
if (result.length > 0) {
|
var div = document.getElementById("new_div");
|
if (div) {
|
div.parentNode.removeChild(div);
|
}
|
var new_div = document.createElement("div");
|
new_div.id = "new_div";
|
$("#timefield").append(new_div);
|
var select = "<select id='select_name' class='form-control col-sm-9' onchange='setTimeStampField(this)'><option value=''>请选择</option>";
|
for (var m = 0; m < result.length; m++) {
|
if ($("#timestampfield").val() == result[m]) {
|
select += "<option value='" + result[m] + "' selected='true'>" + result[m] + "</option>";
|
} else {
|
select += "<option value='" + result[m] + "'>" + result[m] + "</option>";
|
}
|
}
|
select += "</select>";
|
$("#timestampfield").attr("type", "hidden");
|
$("#new_div").append(select);
|
} else {
|
var div = document.getElementById("new_div");
|
if (div) {
|
div.parentNode.removeChild(div);
|
}
|
$("#timestampfield").attr("type", "text");
|
}
|
}
|
});
|
},
|
error: function (e) {
|
alert(e.message);
|
}
|
})
|
}
|
}
|
|
function setTimeStampField(obj) {
|
$("#timestampfield").val(obj.value);
|
}
|
|
$("#tablename").change(function () {
|
zhujian();
|
});
|
|
/*<![CDATA[*/
|
|
$("#databasename").change(function () {
|
$("#tablename").empty();
|
selectSqlTablt();
|
});
|
|
function selectSqlTablt() {
|
//获取选个数据库类型
|
var sqlType = $("#databasetype").val();
|
var datasourceid = $("#datasourceid").val();
|
$.ajax({
|
url: '/res/ZiYuan/selectSqlTable',
|
type: 'post',
|
dataType: 'json',
|
data: {'datasourceid': datasourceid},
|
success: function (data) {
|
var json = eval(data);
|
$("#tablename").append("<option value=\"\">选择数据库表</option>");
|
for (var i = 0; i < json.length; i++) {
|
$("#tablename").append("<option value='" + json[i].TABLENAME + "'>" + json[i].TABLENAME + "</option>");
|
}
|
},
|
error: function (e) {
|
alert(e.message);
|
}
|
})
|
}
|
|
/*]]>*/
|
|
function changeFieldConfig(tablename) {
|
$.ajax({
|
url: '/res/ResManage/ResRegister/changeFieldConfig?resMainInfoId=0&tablename=' + tablename,
|
type: 'post',
|
dataType: 'text',
|
success: function (data) {
|
$("#fieldconfig").val(data);
|
},
|
error: function () {
|
alert("请求失败,网络异常！");
|
}
|
});
|
}
|
|
function addShuJuYuan() {
|
layer.open({
|
type: 2,
|
title: "新增数据源",
|
shadeClose: true,
|
area: ["900px", "590px"],
|
content: "../../manage/datasource/edit"
|
})
|
}
|
</script>
|
