From 54837b203b8d23c01e0e6cf716cb6a3829ae60f6 Mon Sep 17 00:00:00 2001
From: Surpriseplus <845948745@qq.com>
Date: 星期四, 22 十二月 2022 19:48:07 +0800
Subject: [PATCH] 数据检索，关键字查询，空间查询，专题图添加mpt,
---
src/views/datamanage/SpatialData.vue | 507 ++++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 417 insertions(+), 90 deletions(-)
diff --git a/src/views/datamanage/SpatialData.vue b/src/views/datamanage/SpatialData.vue
index ed4f8a5..a6712b5 100644
--- a/src/views/datamanage/SpatialData.vue
+++ b/src/views/datamanage/SpatialData.vue
@@ -1,50 +1,68 @@
<template>
<div class="Spatialbox">
- <My-bread
- :list="[
+ <My-bread :list="[
`${$t('dataManage.dataManage')}`,
`${$t('dataManage.dataRetrieval')}`,
- ]"
- ></My-bread>
+ ]"></My-bread>
<el-divider />
<div class="spatialContent">
<div class="spatial_leftTree">
<el-tree
+ ref="treeDay"
:data="tree"
:props="defaultProps"
:default-expanded-keys="[1]"
node-key="id"
+ :current-node-key="10"
@node-click="handleNodeClick"
></el-tree>
</div>
<div class="spatial_rightContent">
- <el-form ref="ruleForm" :model="ruleForm" :inline="true">
- <el-form-item :label="$t('dataManage.vmobj.keyword')" prop="name">
- <el-input v-model="ruleForm.name" :placeholder="$t('common.choose')" />
+ <el-form
+ ref="ruleForm"
+ :model="ruleForm"
+ :inline="true"
+ >
+
+ <el-form-item>
+ <el-input
+ type="textarea"
+ v-model="ruleForm.fileName"
+ class="nm-skin-pretty"
+ show-word-limit
+ :rows="2"
+ resize='none'
+ disabled
+ style="width: 650px;"
+ ></el-input>
</el-form-item>
<el-form-item>
<el-button
- @click="submitForm('ruleForm')"
- icon="el-icon-search"
- class="primary"
- size="small"
- >{{$t('common.iquery')}}</el-button
- >
+ @click="conditionVisible = true"
+ class="primaries"
+ icon="el-icon-plus"
+ >{{$t('common.append')}}</el-button>
+ </el-form-item>
+ <el-form-item>
<el-button
- @click="resetForm('ruleForm')"
+ @click="submitForm"
+ class="primaries"
+ icon="el-icon-search"
+ >{{$t('common.iquery')}}</el-button>
+ </el-form-item>
+ <el-form-item>
+ <el-button
+ @click="resetForm"
icon="el-icon-refresh"
- type="info"
- size="small"
- >{{$t('common.reset')}}</el-button
- >
-
- <!-- <el-button
- v-if="btnStatus.download"
- icon="el-icon-position"
- type="success"
- size="small"
- >{{$t('common.download')}}</el-button
- > -->
+ >{{$t('common.reset')}}</el-button>
+ </el-form-item>
+ <el-form-item>
+ <el-button
+ @click="getSpaceMapVisibale"
+ class="primaries"
+ >{{
+ $t('synthesis.rangequery')
+ }}</el-button>
</el-form-item>
</el-form>
<el-divider class="eldivider" />
@@ -55,11 +73,17 @@
height="500px"
border
style="width: 100%"
-
@selection-change="handleSelectionChange"
>
- <el-table-column type="selection" width="55" />
- <el-table-column width="60" type="index" :label="$t('common.index')" />
+ <el-table-column
+ type="selection"
+ width="55"
+ />
+ <el-table-column
+ width="60"
+ type="index"
+ :label="$t('common.index')"
+ />
<el-table-column
v-for="(item, index) in attributeData"
:key="index"
@@ -68,22 +92,27 @@
show-overflow-tooltip
align="center"
></el-table-column>
- <el-table-column min-width="80" :label="$t('common.operate')">
+ <el-table-column
+ min-width="80"
+ :label="$t('common.operate')"
+ >
<template slot-scope="scope">
- <el-link class="elLink"
-
+ <el-link
+ class="elLink"
@click="showDetail(scope.$index, scope.row)"
- >{{$t('common.details')}}</el-link
- >
- <el-link class="elLink"
+ >{{$t('common.details')}}</el-link>
+ <el-link
+ class="elLink"
@click="getAttachTable(scope.$index, scope.row)"
style="margin-left: 20px; "
- >{{$t('common.enclosure')}}</el-link
- >
+ >{{$t('common.enclosure')}}</el-link>
</template>
</el-table-column>
</el-table>
- <div style="margin-top: 20px" class="pagination_box">
+ <div
+ style="margin-top: 20px"
+ class="pagination_box"
+ >
<el-pagination
v-if="changePag"
@size-change="handleSizeChange"
@@ -99,11 +128,20 @@
</div>
</div>
</div>
- <div class="infoBox" v-show="showinfoBox">
+ <div
+ class="infoBox"
+ v-show="showinfoBox"
+ >
<el-card class="box-card">
- <div slot="header" class="clearfix">
+ <div
+ slot="header"
+ class="clearfix"
+ >
<span>{{$t('common.details')}}</span>
- <div style="float: right; cursor: pointer" @click="closeDetial">
+ <div
+ style="float: right; cursor: pointer"
+ @click="closeDetial"
+ >
<i class="el-icon-close"></i>
</div>
</div>
@@ -120,9 +158,16 @@
</div>
</el-card>
</div>
- <el-dialog :title="$t('common.attachinform')" width="30%" :visible.sync="dialogFormVisible">
- <el-form :model="formInline" class="demo-form-inline">
- <el-form-item >
+ <el-dialog
+ :title="$t('common.attachinform')"
+ width="30%"
+ :visible.sync="dialogFormVisible"
+ >
+ <el-form
+ :model="formInline"
+ class="demo-form-inline"
+ >
+ <el-form-item>
<el-input
v-model="formInline.file"
style="width: 300px; margin-right: 20px"
@@ -135,55 +180,161 @@
id="insertFile"
multiple="multiple"
style="display: none"
- @change="insertFile( )"
+ @change="insertFile( )"
/>
- <el-link @click="getInsertFile( )" :underline="false"
- ><i class="el-icon-folder-opened"></i
- ></el-link>
+ <el-link
+ @click="getInsertFile( )"
+ :underline="false"
+ ><i class="el-icon-folder-opened"></i></el-link>
</el-form-item>
<el-form-item>
- <el-row >
- <el-col :span="3"> <el-link class="elLink" :underline="false" @click="setAttachInsert" >{{$t('common.append')}}</i></el-link></el-col>
- <el-col :span="3"> <el-link class="elLink" :underline="false" @click="setAttachDel" >{{$t('common.delete')}}</i></el-link></el-col>
+ <el-row>
+ <el-col :span="3">
+ <el-link
+ class="elLink"
+ :underline="false"
+ @click="setAttachInsert"
+ >{{$t('common.append')}}</i></el-link>
+ </el-col>
+ <el-col :span="3">
+ <el-link
+ class="elLink"
+ :underline="false"
+ @click="setAttachDel"
+ >{{$t('common.delete')}}</i></el-link>
+ </el-col>
<!-- <el-col :span="3"> <el-link class="elLink" :underline="false" >{{$t('common.reset')}}</i></el-link></el-col> -->
</el-row>
</el-form-item>
<el-form-item>
- <el-table
- :data="tableAttach"
+ <el-table
+ :data="tableAttach"
ref="filterTable"
height="99%"
border
style="width: 100%"
@selection-change="handleAttatchChange"
>
- <el-table-column type="selection" width="55" />
- <el-table-column width="60" type="index" :label="$t('common.index')" />
- <el-table-column prop="date"
- :label="$t('common.fileNme')"
- />
+ <el-table-column
+ type="selection"
+ width="55"
+ />
+ <el-table-column
+ width="60"
+ type="index"
+ :label="$t('common.index')"
+ />
+ <el-table-column
+ prop="date"
+ :label="$t('common.fileNme')"
+ />
- <el-table-column
- prop="name"
- :label="$t('common.filePath')"
- />
+ <el-table-column
+ prop="name"
+ :label="$t('common.filePath')"
+ />
- </el-table>
+ </el-table>
</el-form-item>
<el-form-item>
-<el-row :gutter="20">
- <el-col :span="12" :offset="8"> <el-button class="primary" @click="dialogFormVisible = false">纭</el-button> <el-button type="info" @click="dialogFormVisible = false">鍙栨秷</el-button></el-col>
-</el-row>
+ <el-row :gutter="20">
+ <el-col
+ :span="12"
+ :offset="8"
+ >
+ <el-button
+ class="primary"
+ @click="dialogFormVisible = false"
+ >纭</el-button>
+ <el-button
+ type="info"
+ @click="dialogFormVisible = false"
+ >鍙栨秷</el-button>
+ </el-col>
+ </el-row>
</el-form-item>
</el-form>
+ </el-dialog>
+ <el-dialog
+ width="37%"
+ :visible.sync="conditionVisible"
+ append-to-body
+ title="鏌ヨ鏉′欢"
+ :before-close="handleconditionClose"
+ >
+ <el-form
+ :inline="true"
+ :model="formSql"
+ class="demo-form-inline"
+ >
+ <el-form-item>
+ <el-select
+ @change="fieldChange($event)"
+ v-model="formSql.field"
+ >
+ <el-option
+ v-for="item in filedsOption"
+ :key="item.field"
+ :label="item.alias"
+ :value="item.field"
+ >
+ </el-option>
+ </el-select>
+ </el-form-item>
+ <el-form-item>
+ <el-select v-model="formSql.condition">
+ <el-option
+ v-for="item in condOption"
+ :key="item.value"
+ :label="item.label"
+ :value="item.value"
+ >
+ </el-option>
+ </el-select>
+ </el-form-item>
+ <el-form-item v-show="!fromSqlflag">
+ <el-input v-model="formSql.value"></el-input>
+ </el-form-item>
+ <el-form-item v-show="fromSqlflag">
+ <el-date-picker
+ v-model="formSql.date"
+ type="date"
+ placeholder="閫夋嫨鏃ユ湡"
+ value-format="yyyy-MM-dd"
+ >
+ </el-date-picker>
+ </el-form-item>
+ </el-form>
+ <span
+ slot="footer"
+ class="dialog-footer"
+ >
+ <el-button @click="startFiledAndcondition">鍙� 娑�</el-button>
+ <el-button
+ class="primaries"
+ @click="appendQueryFilter"
+ >纭� 瀹�</el-button>
+ </span>
+ </el-dialog>
+ <el-dialog
+ :title=" $t('synthesis.rangequery')"
+ :visible.sync="dialogMapVisible"
+ width="90%"
+ :before-close="handleMapClose"
+ >
+ <div style="height:700px">
+ <map-sdk v-if='showMapVisible'></map-sdk>
+ </div>
</el-dialog>
</div>
</template>
<script>
+import MapSdk from '../../components/mapsdk.vue'
import $ from 'jquery';
+import { conditions } from '../Archive/Archive.js'
import {
dataQuery_selectTabs,
dataQuery_selectDomains,
@@ -199,21 +350,32 @@
export default {
//import寮曞叆鐨勭粍浠堕渶瑕佹敞鍏ュ埌瀵硅薄涓墠鑳戒娇鐢�
name: 'dataSearch',
- components: { MyBread, catalogueTree },
+ components: { MyBread, catalogueTree, MapSdk },
data() {
return {
attachtable: ['b_pac_geologic_hazard', 'b_hydrogeology', 'b_pac_meteorological', 'b_pac_marine_meteorological', 'b_pac_frozensoil', 's_borehole', 'm_marker', 'm_hydraulic_protection', 'm_equipment_nameplate'],
formInline: {
file: '',
},
+ formSql: {
+ field: '',
+ condition: '',
+ value: '',
+ type: '',
+ date: '',
+
+ },
+ fromSqlflag: false,
tree: [
{
tabDesc: '鍩虹鏁版嵁',
label: '鍩虹鏁版嵁',
value: 'BD',
+ id: 1,
children: [],
},
{
+ id: 2,
tabDesc: '涓氬姟鏁版嵁',
label: '涓氬姟鏁版嵁',
value: 'BS',
@@ -221,6 +383,9 @@
},
],
tableAttach: [],
+ filedsOption: [],
+ condOption: [],
+
defaultProps: {
children: 'children',
label: 'label',
@@ -235,7 +400,7 @@
},
tableType: null,
ruleForm: {
- name: null,
+ fileName: ''
},
FBtest: false,
tableData: [],
@@ -272,10 +437,14 @@
},
getClickTable: null,
attacgSelection: [],
- upAttach:{
- tabName:null,
- eventid:null,
+ conditionVisible: false,
+ dialogMapVisible: false,
+ showMapVisible: false,
+ upAttach: {
+ tabName: null,
+ eventid: null,
}
+
};
},
created() {
@@ -285,16 +454,43 @@
this.getTreeDataAll();
},
methods: {
- async setAttachDel() {
- var std = [];
+
+ getSpaceMapVisibale() {
+ this.dialogMapVisible = true;
+ this.showMapVisible = true;
+ this.$store.state.mapMenuBoolean = true;
+ this.$store.state.mapMenuBoxFlag = '1';
+ this.$store.state.mapPopBoolean = false;
+ this.$store.state.mapPopBoxFlag = null;
+ this.$store.state.download = true;
+
+ },
+ handleMapClose() {
+ this.$confirm('纭鍏抽棴锛�')
+ .then((_) => {
+ this.closeMapDown();
+ })
+ .catch((_) => { });
+ },
+ closeMapDown() {
+ this.dialogMapVisible = false;
+ this.showMapVisible = false;
+ this.$store.state.mapMenuBoolean = false;
+ this.$store.state.mapMenuBoxFlag = null;
+ this.$store.state.download = false;
+ this.$store.state.mapPopBoolean = false;
+ this.$store.state.mapPopBoxFlag = null;
+ },
+ async setAttachDel() {
+ var std = [];
for (var i in this.attacgSelection) {
std.push(this.attacgSelection[i].id);
}
const res = await dataQuery_deletes({ ids: std.toString() });
- if(res.code != 200){
+ if (res.code != 200) {
this.$message.error('鏂囦欢鍒犻櫎澶辫触');
}
- this.getAttacthFlieList();
+ this.getAttacthFlieList();
},
setAttachInsert() {
var token = getToken();
@@ -309,7 +505,7 @@
formData.append('file', fs.files[i]); // fs.files[i].name,file
}
- $.ajax(BASE_URL + "/dataQuery/uploadFiles?token=" + token + "&tabName= "+this.upAttach.tabName+"&eventid="+this.upAttach.eventid, {
+ $.ajax(BASE_URL + "/dataQuery/uploadFiles?token=" + token + "&tabName= " + this.upAttach.tabName + "&eventid=" + this.upAttach.eventid, {
type: "post",
data: formData,
async: true,
@@ -334,7 +530,7 @@
});
},
async getAttacthFlieList() {
- var obj =this.upAttach
+ var obj = this.upAttach
const res = await dataQuery_selectFiles(obj);
if (res.code != 200) {
this.$message.error('鍒楄〃璋冪敤澶辫触');
@@ -345,10 +541,10 @@
getAttachTable(index, row) {
- if(row.eventid != null){
+ if (row.eventid != null) {
this.upAttach.eventid = row.eventid;
- }else{
- this.upAttach.eventid = '';
+ } else {
+ this.upAttach.eventid = '';
}
this.getAttacthFlieList();
this.dialogFormVisible = true;
@@ -374,13 +570,16 @@
for (var i in option) {
var val_Data = option[i];
val_Data.id = '1' + i;
- val_Data.label= val_Data.tabDesc+"("+val_Data.tab+")"
+ val_Data.label = val_Data.tabDesc + "(" + val_Data.tab + ")"
+ option[i].id = parseInt(option[i].id)
if (option[i].ns == 'bd') {
+
this.tree[0].children.push(val_Data);
} else {
this.tree[1].children.push(val_Data);
}
}
+ this.handleNodeClick(this.tree[0].children[0])
},
//鎺堟潈绠＄悊
showPermsBtn() {
@@ -399,10 +598,10 @@
if (data.children != null) return;
this.listData.name = data.entity; //瑕佹煡璇㈣〃鏍肩被鍨嬶紱
this.getClickTable = data;
- this.listData.pageIndex =1;
- this.listData.pageSize=10;
+ this.listData.pageIndex = 1;
+ this.listData.pageSize = 10;
this.count = 0;
-this.upAttach.tabName= data.ns+"."+data.tab;
+ this.upAttach.tabName = data.ns + "." + data.tab;
this.filedsLayer = this.getCollapseDomFiled(); //鑾峰彇姣忎釜琛ㄥ瓧娈靛悕绉板強闃堝��
//鑾峰彇table淇℃伅
@@ -413,8 +612,8 @@
res.then((val) => {
this.attributeData = val;
});
- if (this.ruleForm.name != null) {
- this.listData.filter = 'name like ' + this.ruleForm.name;
+ if (this.ruleForm.fileName != '') {
+ this.listData.filter = this.ruleForm.fileName;
} else {
this.listData.filter = null;
}
@@ -462,6 +661,9 @@
var data2 = domains.result;
var std = [];
for (var i in data1) {
+ if (data1[i].type != 'geomtry' && data1[i].type != 'null') {
+ this.filedsOption.push(data1[i])
+ }
if (data1[i].showtype == 1) {
if (data1[i].domainNa != null) {
data1[i].domainNa = this.getDomainNaFild(data1[i].domainNa, data2);
@@ -469,8 +671,104 @@
std.push(data1[i]);
}
}
+ this.startFiledAndcondition();
return std;
},
+ startFiledAndcondition() {
+ this.conditionVisible = false;
+ this.conditionChange(this.filedsOption[0]);
+ this.formSql.value = "";
+ this.formSql.date = new Date();
+ },
+ handleconditionClose() {
+ this.$confirm('纭鍏抽棴锛�')
+ .then(_ => {
+ this.startFiledAndcondition();
+ })
+ .catch(_ => { });
+ },
+
+ fieldChange(value) {
+ var obj = {}
+ obj = this.filedsOption.find(function (item) {
+ return item.field === value;
+ })
+ this.conditionChange(obj)
+
+ },
+ conditionChange(res) {
+ this.formSql.field = res.field;
+ this.formSql.type = res.type;
+ if (res.type == "date" || res.type == "datetime") {
+ this.fromSqlflag = true
+ } else {
+ this.fromSqlflag = false
+ }
+ var std = [];
+ this.condOption = [];
+ if (res.type == 'text' || res.type == 'blob') {
+ std = conditions[0]
+ } else if (res.type == 'date' || res.type == 'datetime') {
+ std = conditions[2]
+ } else {
+ std = conditions[1]
+ }
+ for (var i in std) {
+ this.condOption.push({
+ label: std[i],
+ value: std[i],
+ })
+ }
+ this.formSql.condition = this.condOption[0].value
+ },
+ appendQueryFilter() {
+ if (this.formSql.type == "date" || this.formSql.type == "datetime") {
+ if (this.formSql.date == null) {
+ this.$message.error('璇疯緭鍏ヨ鏌ヨ鐨勪俊鎭�!');
+ return;
+ }
+ } else {
+ if (this.formSql.value == "") {
+ this.$message.error('璇疯緭鍏ヨ鏌ヨ鐨勪俊鎭�!');
+ return;
+ }
+ }
+
+ if (this.ruleForm.fileName != "") {
+ this.ruleForm.fileName += " and ";
+ }
+ var val;
+
+ if (this.formSql.type == "long" || this.formSql.type == "integer") {
+
+ val = parseInt(this.formSql.value);
+ } else if (this.formSql.type == 'double') {
+
+ if (this.formSql.value.indexOf(".") != -1) {
+ val = this.formSql.value;
+ } else {
+ val = parseFloat(this.formSql.value).toFixed(1)
+ }
+ } else if (this.formSql.type == "date" || this.formSql.type == "datetime") {
+ var time = new Date(this.formSql.date);
+ var m = time.getMonth() + 1;
+ var d = time.getDate();
+ var y = time.getFullYear();
+ val = "'" + y +
+ '-' +
+ this.add0(m) +
+ '-' +
+ this.add0(d) + "'";
+ } else {
+ val = "'" + this.formSql.value + "'";
+ }
+ this.ruleForm.fileName += this.formSql.field + " " + this.formSql.condition + " " + val;
+
+ this.startFiledAndcondition();
+ },
+
+
+
//鍊煎煙瀛楁鍖归厤
getDomainNaFild(res, result) {
for (var i in result) {
@@ -538,11 +836,13 @@
this.getCollapseTable(this.filedsLayer);
},
// 閲嶇疆鏌ヨ
- resetForm(formName) {
- this.searchName = '';
- this.$refs[formName].resetFields();
+ resetForm() {
+ this.ruleForm.fileName = '';
+ this.listData.pageIndex = 1;
+ this.listData.pageSize = 10;
//鑾峰彇table淇℃伅
this.getCollapseTable(this.filedsLayer);
+
},
// 鍙戝竷鎸夐挳
@@ -767,7 +1067,7 @@
border-radius: 5px;
padding: 1%;
max-height: 670px;
- overflow : auto;
+ overflow: auto;
}
.spatial_rightContent {
width: 80%;
@@ -938,5 +1238,32 @@
/deep/.el-dialog__title {
color: white;
}
+ /deep/.el-textarea__inner {
+ background: transparent !important;
+ border-color: #fff !important;
+ color: white;
+ }
+}
+/deep/ .el-dialog {
+ background: #303030;
+}
+/deep/.el-range-editor.is-active,
+.el-range-editor.is-active:hover,
+.el-select .el-input.is-focus .el-input__inner {
+ border: 1px solid;
+}
+/deep/.el-dialog__title {
+ color: white;
+}
+/deep/ .el-dialog__body {
+ padding: 10px;
+}
+/deep/.el-input__inner {
+ background-color: transparent !important ;
+ color: #fff;
+ border: 1px solid white !important;
+}
+/deep/.el-dialog__wrapper {
+ overflow: hidden !important;
}
</style>
--
Gitblit v1.9.3