"use script"; //开发环境建议开启严格模式
|
|
//对应widget.js中MyWidget实例化后的对象
|
var thisWidget;
|
|
//当前选择的图层
|
var selectedLayer;
|
|
//where条件的配置
|
var whereCfg;
|
|
//当前页面业务
|
function initWidgetView(_thisWidget) {
|
thisWidget = _thisWidget;
|
|
$.getJSON("config.json", function (data) {
|
whereCfg = data.where; //记录查询条件配置
|
|
var layersCfg = data.layers;
|
var overlayLayers = {};
|
|
var zNodes = [];
|
var defSelected;
|
for (var i = 0; i < layersCfg.length; i++) {
|
var item = layersCfg[i];
|
|
if (item.name == null || item.name == "") {
|
continue;
|
}
|
|
var node = {
|
text: item.name,
|
id: item.id || 999 + i,
|
pId: item.pid || -1,
|
};
|
|
if (item.url == null) {
|
node.iconCls = "icon-muyao-folder";
|
node.state = item.open == "true" ? "open" : "closed";
|
} else {
|
if (defSelected == null) {
|
defSelected = node.id;
|
} //默认选择第一个
|
|
node.iconCls = "icon-muyao-shape_move_forwards";
|
overlayLayers[node.id] = item;
|
}
|
zNodes.push(node);
|
}
|
|
$("#queryonewhere_cmb_layer").combotree({
|
width: 308,
|
data: zNodes,
|
loadFilter: function (rows) {
|
return convertTree(rows);
|
},
|
onChange: function (newValue, oldValue) {
|
selectedLayer = null;
|
var layer = overlayLayers[newValue];
|
if (layer == null) {
|
alert("请不要选择分组，请重新选择图层!");
|
$("#queryonewhere_cmb_layer").combotree("setValue", oldValue);
|
return;
|
}
|
|
selectedLayer = layer;
|
|
var hasCfgWhere = selectedLayer.columnsShow && selectedLayer.columnsShow.where;
|
var hasCfgTable = selectedLayer.columnsShow && selectedLayer.columnsShow.table;
|
|
var columnsTbl = [];
|
var columnsWhere = [];
|
|
//设置查询结果面板
|
var idcol = {};
|
idcol["name"] = "序号";
|
idcol["field"] = "rowIndex";
|
columnsTbl.push(idcol);
|
|
for (var i = 0; i < selectedLayer.columns.length; i++) {
|
var column = selectedLayer.columns[i];
|
if (!column.field) {
|
continue;
|
}
|
column.editable = true;
|
|
if (!hasCfgTable || selectedLayer.columnsShow.table.indexOf(column["field"]) != -1) {
|
column.title = column.name;
|
columnsTbl.push(column);
|
}
|
|
if (!hasCfgWhere || selectedLayer.columnsShow.where.indexOf(column["field"]) != -1) {
|
columnsWhere.push(column);
|
}
|
}
|
|
if (columnsTbl.length == 2) {
|
columnsTbl[1].width = "100%";
|
}
|
|
thisWidget.changeSelectedLayer(selectedLayer);
|
|
$("#queryonewhere_table").datagrid({
|
columns: [columnsTbl],
|
data: [],
|
});
|
|
//设置字段列表
|
$("#queryonewhere_cmb_col_name").combobox({
|
data: columnsWhere,
|
valueField: "field",
|
textField: "name",
|
multiple: false, //不允许多选
|
editable: true, //禁止编辑
|
onChange: function (value) {
|
var item = getColumnCfgItem(value);
|
if (item == null) {
|
return;
|
}
|
|
var type = item.type || "text";
|
$("#queryonewhere_cmb_col_where").combobox({
|
data: whereCfg[type],
|
multiple: false, //不允许多选
|
editable: false, //禁止编辑
|
width: 100,
|
valueField: "field",
|
textField: "name",
|
});
|
$("#queryonewhere_cmb_col_where").combobox("setValue", whereCfg[type][0]["field"]); //默认选择第1项
|
},
|
});
|
$("#queryonewhere_cmb_col_name").combobox("setValue", selectedLayer.columns[0]["field"]); //默认选择第1项
|
|
//设置完成
|
},
|
});
|
$("#queryonewhere_cmb_layer").combotree("setValue", defSelected);
|
});
|
$("#queryonewhere_cmb_col_name").combobox({
|
width: 100,
|
});
|
|
$("#queryonewhere_txt_col_val").textbox({
|
width: 100,
|
});
|
|
//切换选择区域方式
|
$('input:radio[name="queryonewhere_drawtype"]').change(function () {
|
var drawtype = $('input:radio[name="queryonewhere_drawtype"]:checked').val();
|
switch (drawtype) {
|
default:
|
break;
|
case "0":
|
$("#drawPolyView").hide();
|
thisWidget.clearDraw();
|
break;
|
case "1":
|
$("#drawPolyView").hide();
|
thisWidget.clearDraw();
|
break;
|
case "2":
|
$("#drawPolyView").show();
|
break;
|
}
|
});
|
//框选查询 矩形
|
$("#drawRectangle").click(function () {
|
thisWidget.drawRectangle();
|
});
|
//框选查询 多边
|
$("#drawPolygon").click(function () {
|
thisWidget.drawPolygon();
|
});
|
//框选查询 圆
|
$("#drawCircle").click(function () {
|
thisWidget.drawCircle();
|
});
|
|
$("#queryonewhere_table").datagrid({
|
singleSelect: true,
|
pagination: true,
|
rownumbers: false,
|
height: getHeight(),
|
fitColumns: true,
|
onClickRow: function (rowIndex, rowData) {
|
thisWidget.flyTo(rowData);
|
},
|
});
|
|
$("#btnExQueryOneWhere").click(function () {
|
excuteSqlQuery();
|
});
|
}
|
|
//获取指定字段的配置信息
|
function getColumnCfgItem(fieldvalue) {
|
if (selectedLayer == null) {
|
return null;
|
}
|
|
for (var i = 0; i < selectedLayer.columns.length; i++) {
|
var thisfield = selectedLayer.columns[i];
|
if (thisfield.field == fieldvalue) {
|
return thisfield;
|
}
|
}
|
return null;
|
}
|
|
function convertTree(rows) {
|
function exists(rows, parentId) {
|
for (let i = 0; i < rows.length; i++) {
|
if (rows[i].id == parentId) {
|
return true;
|
}
|
}
|
return false;
|
}
|
|
var nodes = [];
|
// get the top level nodes
|
for (let i = 0; i < rows.length; i++) {
|
let row = rows[i];
|
if (!exists(rows, row.pId)) {
|
nodes.push({
|
id: row.id,
|
text: row.text,
|
});
|
}
|
}
|
|
let toDo = [];
|
for (let i = 0; i < nodes.length; i++) {
|
toDo.push(nodes[i]);
|
}
|
while (toDo.length) {
|
let node = toDo.shift(); // the parent node
|
// get the children nodes
|
for (let i = 0; i < rows.length; i++) {
|
let row = rows[i];
|
if (row.pId == node.id) {
|
let child = { id: row.id, text: row.text };
|
if (node.children) {
|
node.children.push(child);
|
} else {
|
node.children = [child];
|
}
|
toDo.push(child);
|
}
|
}
|
}
|
return nodes;
|
}
|
|
function excuteSqlQuery() {
|
thisWidget.clearShowFeature();
|
|
if (selectedLayer == null) {
|
toastr.warning("请选择图层");
|
return;
|
}
|
var drawtype = $('input:radio[name="queryonewhere_drawtype"]:checked').val();
|
|
var col_name = $("#queryonewhere_cmb_col_name").combobox("getValue");
|
var col_where = $("#queryonewhere_cmb_col_where").combobox("getValue");
|
var col_val = $("#queryonewhere_txt_col_val").textbox("getValue");
|
|
if (!thisWidget.hasDraw() && drawtype == "2") {
|
toastr.warning("请在地图上鼠标单击绘制限定范围！");
|
return;
|
}
|
|
var sqlstring;
|
if (col_val != null && col_val.length > 0) {
|
if (col_name == null || col_name.length == 0) {
|
toastr.warning("请选择需要查询的字段");
|
return;
|
}
|
if (col_where == null || col_where.length == 0) {
|
toastr.warning("请选择查询条件方式");
|
return;
|
}
|
|
var fieldtype = "text";
|
var item = getColumnCfgItem(col_name);
|
if (item != null && item.type) {
|
fieldtype = item.type;
|
}
|
|
if (fieldtype == "number") {
|
sqlstring = col_name + " " + col_where + " " + col_val + " ";
|
} else {
|
if (col_where == "like") {
|
sqlstring = col_name + " " + col_where + " '%" + col_val + "%' ";
|
} else {
|
sqlstring = col_name + " " + col_where + " '" + col_val + "' ";
|
}
|
}
|
}
|
|
thisWidget.query({
|
url: selectedLayer.url,
|
where: sqlstring,
|
extenttype: drawtype,
|
});
|
}
|
|
function clearResult() {
|
$("#queryonewhere_table").datagrid("loadData", { total: 0, rows: [] });
|
}
|
|
function showResult(arrResultData) {
|
$("#queryonewhere_table").datagrid("loadData", arrResultData.slice(0, 10));
|
var pager = $("#queryonewhere_table").datagrid("getPager");
|
pager.pagination({
|
total: arrResultData.length,
|
onSelectPage: function (pageNo, pageSize) {
|
var start = (pageNo - 1) * pageSize;
|
var end = start + pageSize;
|
$("#queryonewhere_table").datagrid("loadData", arrResultData.slice(start, end));
|
pager.pagination("refresh", {
|
total: arrResultData.length,
|
pageNumber: pageNo,
|
});
|
},
|
});
|
}
|
|
function getHeight() {
|
return $(window).height() - 90;
|
}
|
