From 368b6c77a9516bfe76faf845dd77d92bb45c95d8 Mon Sep 17 00:00:00 2001 From: Surpriseplus <845948745@qq.com> Date: 星期五, 22 九月 2023 14:12:07 +0800 Subject: [PATCH] 空间查询,地名定位修改 --- src/components/MapView/mapSpacePop.vue | 1482 +++++++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 1,231 insertions(+), 251 deletions(-) diff --git a/src/components/MapView/mapSpacePop.vue b/src/components/MapView/mapSpacePop.vue index 5404709..ea93012 100644 --- a/src/components/MapView/mapSpacePop.vue +++ b/src/components/MapView/mapSpacePop.vue @@ -3,6 +3,44 @@ <div style="padding: 5px"> <el-form :inline="true" + :model="ruleForm" + class="demo-form-inline" + > + <el-form-item> + <el-input + size="small" + style="width:30vh" + v-model="ruleForm.fileName" + disabled + placeholder="璇疯緭鍏�..." + ></el-input> + </el-form-item> + <el-form-item> + <el-button + @click="conditionVisible = true" + size="small" + type="success" + >{{$t('common.lable6')}}</el-button> + <el-button + size="small" + @click="resetForm" + >閲嶇疆</el-button> + </el-form-item> + <el-form-item v-if="spaceLayer == 'sexplorationpoint'"> + <el-button + size="small" + @click="spaceHistogram()" + plain + >鏌辩姸鍥�</el-button> + <el-button + plain + size="small" + @click="spaceGeobody()" + >鍦拌川浣�</el-button> + </el-form-item> + </el-form> + <!-- <el-form + :inline="true" :model="formInline" class="demo-form-inline" > @@ -45,20 +83,35 @@ ></el-input> </el-form-item> <el-form-item> - <el-button size="small" + <el-button + size="small" plain @click="setSpaceTableLayer" >鏌ヨ</el-button> <el-button - plain size="small" + plain + size="small" @click="restSpacePopLayer" >閲嶇疆</el-button> </el-form-item> - </el-form> + + <el-form-item v-if="spaceLayer == 'sexplorationpoint'"> + <el-button + size="small" + @click="spaceHistogram( )" + plain + >鏌辩姸鍥�</el-button> + <!-- <el-button + plain + size="small" + >鍓栧垏鍥�</el-button> + </el-form-item> + </el-form> --> <div class="centTable"> <el-table :data="tableData" - height="260px" + border + height="100%" ref="filterTable" style="width: 100%" > @@ -81,6 +134,20 @@ ></el-button> </template> </el-table-column> + <!-- <el-table-column + label="鏌辩姸鍥�" + width="100" + align="center" + v-if="spaceLayer == 'sexplorationpoint'" + > + <template slot-scope="scope"> + <el-button + icon="el-icon-map-location" + size="small" + @click="spaceHistogram(scope.$index, scope.row)" + ></el-button> + </template> + </el-table-column> --> <el-table-column v-for="(item, index) in attributeData" :key="index" @@ -88,6 +155,7 @@ :prop="item.field" show-overflow-tooltip align="center" + :fit="true" ></el-table-column> </el-table> </div> @@ -97,7 +165,7 @@ @size-change="handleSizeChange" @current-change="handleCurrentChange" :current-page="listdata.pageIndex" - :page-sizes="[10, 20, 30, 40]" + :page-sizes="[10, 20, 50, 100]" :page-size="listdata.pageSize" layout="total, sizes, prev, pager, next, jumper" :total="count" @@ -105,6 +173,84 @@ </el-pagination> </div> </div> + <el-dialog + :visible.sync="conditionVisible" + title="楂樼骇鏌ヨ" + width="44%" + :close-on-click-modal="false" + :modal="false" + > + + <el-form + :inline=" true" + :model="formSql" + class="demo-form-inline" + label-position="top" + > + + <el-form-item> + <el-select + @change="fieldChange($event)" + v-model="formSql.field" + :popper-append-to-body="false" + > + <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 + :popper-append-to-body="false" + 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" + :placeholder="$t('shuJuGuanLi.shuJuJianSuo.queryContent')" + > </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 + size="small" + @click="startFiledAndcondition" + >鍙� 娑�</el-button> + <el-button + class="primaries" + size="small" + @click="appendQueryFilter" + >纭� 瀹�</el-button> + </span> + </el-dialog> + </div> </template> @@ -115,15 +261,25 @@ inquiry_selectFields, inquiry_selectDomains, decr, -} from '../../api/api.js'; + encr, +} from "../../api/api.js" +import * as turf from "@turf/turf" +import { conditions } from "../../views/Archive/Archive.js"; export default { computed: { storeTime() { - return this.$store.state.mapSpaceQueryLayer; + return this.$store.state.mapSpaceQueryLayer }, }, data() { return { + conditionVisible: false, + filedsOption: [], + condOption: [], + ruleForm: { + fileName: "", + }, + fromSqlflag: false, count: 0, listdata: { pageIndex: 1, @@ -134,268 +290,1189 @@ filter: null, }, formInline: { - name: '', - region: '', + name: "", + region: "", }, attributeData: [], optionx: [], options: [], + conditions: [ + ["=", "<>", "like"], + [">=", ">", " =", "<=", "<", "<>"], + [">=", ">", " =", "<=", "<", "<>"], + ], options1: [ { - value: '=', - label: '=', + value: "=", + label: "=", }, { - value: 'like', - label: 'like', + value: "like", + label: "like", }, { - value: '<>', - label: '<>', + value: "<>", + label: "<>", }, ], options2: [ { - value: '=', - label: '=', + value: "=", + label: "=", }, { - value: '<>', - label: '<>', + value: "<>", + label: "<>", }, { - value: '<=', - label: '<=', + value: "<=", + label: "<=", }, { - value: '<', - label: '<', + value: "<", + label: "<", }, { - value: '>=', - label: '>=', + value: ">=", + label: ">=", }, { - value: '>', - label: '>', + value: ">", + label: ">", }, ], - value: '', + value: "", tableData: [], - spaceLayer: '', + spaceLayer: "", imagePoint: null, domainsLayer: null, - }; + querytype: null, + formSql: { + field: "", + condition: "", + value: "", + type: "", + date: "", + }, + geobodyCount: null, + outlineList: [ + { 'name': '绮夎川榛忓湡', 'color': 'rgba(139,106,77,1)' }, + { 'name': '娣ゆ偿璐ㄧ矇鍦�', 'color': 'rgba(141,85,69,1)' }, + { 'name': '鍦嗙牼', 'color': 'rgba(102,166,184,1)' }, + { 'name': '鍗电煶', 'color': 'rgba(54,83,173,1)' }, + { 'name': '娉ュ博', 'color': 'rgba(47,30,13,1)' }, + { 'name': '缁嗙爞', 'color': 'rgba(93,88,15,1)' }, + { 'name': '涓爞', 'color': 'rgba(164,140,21,1)' }, + { 'name': '娣ゆ偿璐ㄥ湡', 'color': 'rgba(75,74,78,1)' }, + { 'name': '鍏朵粬', 'color': 'rgba(225,225,225,1)' }, + ] + } }, watch: { async storeTime(index) { - this.spaceLayer = index; - this.getDomainsLayer(); + this.spaceLayer = index + this.resetForm(); + // this.getDomainsLayer() // this.getTableselectFields(); // this.restSpacePopLayer(); }, }, created() { - this.spaceLayer = this.$store.state.mapSpaceQueryLayer; + this.spaceLayer = this.$store.state.mapSpaceQueryLayer // this.showSpacePopLayer(); // this.getTableselectFields(); - this.getDomainsLayer(); + this.resetForm(); + // this.getDomainsLayer() }, methods: { + 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; + }, closeSpaceBox() { if (this.imagePoint != null) { - sgworld.Creator.DeleteObject(this.imagePoint); - this.imagePoint = null; + sgworld.Creator.DeleteObject(this.imagePoint) + this.imagePoint = null } - this.$store.state.mapPopBoolean = false; - this.$store.state.mapPopBoxFlag = null; + this.$store.state.mapPopBoolean = false + this.$store.state.mapPopBoxFlag = null }, setSpaceTableLayer() { - this.setListDataStart(); - this.getSpaceTableLayer(); + this.setListDataStart() + this.getSpaceTableLayer() }, restSpacePopLayer() { - this.formInline.input = null; - this.showSpacePopLayer(); + this.formInline.input = null + this.showSpacePopLayer() }, changeValue(value) { - var obj = {}; + var obj = {} obj = this.optionx.find(function (item) { - return item.value === value; - }); - if (obj.type == 'serial' || obj.type == 'int') { - this.options = this.options2; + return item.field === value + }) + + // if (obj.type == 'serial' || obj.type == 'int') { + // this.options = this.options2; + // } else { + // this.options = this.options1; + // } + this.options = [] + + var std = [] + this.querytype = obj.type + if (obj.type == "text" || obj.type == "blob") { + std = this.conditions[0] + } else if (obj.type == "date" || obj.type == "datetime") { + std = this.conditions[2] } else { - this.options = this.options1; + std = this.conditions[1] } - this.formInline.region = this.options[0].value; + for (var i in std) { + this.options.push({ + label: std[i], + value: std[i], + }) + } + + this.formInline.region = this.options[0].value }, setListDataStart() { - this.listdata.pageSize = 10; - this.listdata.pageIndex = 1; - this.tableData = []; + this.listdata = { + pageIndex: 1, + pageSize: 10, + name: null, + srid: 4326, + wkt: null, + filter: null, + } + this.tableData = [] }, //鍒濆鍖栨煡璇㈡潯浠� showSpacePopLayer() { - let val_date = this.optionx[0]; - this.formInline.name = val_date.field; - if (val_date.type == 'serial' || val_date.type == 'int') { - this.options = this.options2; - } else { - this.options = this.options1; + let val_date = this.optionx[0] + if (val_date == null || val_date == undefined) { + return } - this.formInline.region = this.options[0].value; - this.getSpaceTableLayer(); + this.formInline.name = val_date.field + this.options = [] + var std = [] + this.querytype = val_date.type + if (val_date.type == "text" || val_date.type == "blob") { + std = this.conditions[0] + } else if (val_date.type == "date" || val_date.type == "datetime") { + std = this.conditions[2] + } else { + std = this.conditions[1] + } + for (var i in std) { + this.options.push({ + label: std[i], + value: std[i], + }) + } + + this.formInline.region = this.options[0].value + this.getSpaceTableLayer() }, //鍒濆鍖栨煡璇㈣〃鐨勫瓧娈� async getTableselectFields() { - const data = await inquiry_selectFields({ name: this.spaceLayer }); + const data = await inquiry_selectFields({ name: this.spaceLayer }) if (data.code != 200) { - this.$message.error('鍒楄〃璋冪敤澶辫触'); + this.$message.error("鍒楄〃璋冪敤瀛楁澶辫触") } - this.optionx = []; - var valadata = data.result; + if (data.result.length == 0) { + this.$message("鍒楄〃璋冪敤瀛楁鏌ユ棤鏁版嵁") + } + + this.filedsOption = []; + this.optionx = [] + var valadata = data.result for (var i in valadata) { if (valadata[i].showtype == 1) { if ( valadata[i].domainNa != null && valadata[i].domainNa != undefined ) { - valadata[i].domainNa = this.getMatchDomainNa(valadata[i].domainNa); + valadata[i].domainNa = this.getMatchDomainNa(valadata[i].domainNa) } - this.optionx.push(valadata[i]); - this.attributeData.push(valadata[i]); + this.optionx.push(valadata[i]) + this.filedsOption.push(valadata[i]) + this.attributeData.push(valadata[i]) } } - this.showSpacePopLayer(); + this.startFiledAndcondition(); + this.showSpacePopLayer() + }, + 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(); + this.getSpaceTableLayer(); + }, + + startFiledAndcondition() { + this.conditionVisible = false; + this.conditionChange(this.filedsOption[0]); + this.formSql.value = ""; + this.formSql.date = new Date(); }, getMatchDomainNa(res) { - var std = null; + var std = null for (var i in this.domainsLayer) { if (this.domainsLayer[i].domName == res) { - return (std = this.domainsLayer[i].codeDesc); + return (std = this.domainsLayer[i].codeDesc) } } - return std; + return std }, //鍒濆鍖栨煡璇㈤槇鍊艰〃 async getDomainsLayer() { - const data = await inquiry_selectDomains({ name: this.spaceLayer }); + this.$store.state.loading = true; + const data = await inquiry_selectDomains({ name: this.spaceLayer }) if (data.code != 200) { - this.$message.error('鍒楄〃璋冪敤澶辫触'); + this.$message.error("鍒楄〃闃堝�艰皟鐢ㄥけ璐�") } - this.domainsLayer = data.result; - this.setListDataStart(); - this.getTableselectFields(); + // if (data.result.length == 0) { + // this.$message("鍒楄〃闃堝�兼煡鏃犳暟鎹�") + // } + this.domainsLayer = data.result + + this.setListDataStart() + this.getTableselectFields() }, + + + + resetForm() { + this.ruleForm.fileName = ""; + this.listdata.pageIndex = 1; + this.listdata.pageSize = 10; + //鑾峰彇table淇℃伅 + this.getDomainsLayer() + }, + //鍒濆鍖栨煡璇㈣〃鏍间俊鎭� async getSpaceTableLayer() { - this.listdata.name = this.spaceLayer; - if (this.formInline.input == undefined || this.formInline.input == null) { - this.listdata.filter = null; + + this.listdata.name = this.spaceLayer + if (this.ruleForm.fileName != "") { + this.listdata.filter = this.ruleForm.fileName; } else { - this.listdata.filter = - this.formInline.name + - ' ' + - this.formInline.region + - ' ' + - this.formInline.input; + this.listdata.filter = null; } - const data = await dataQuerySelectByPage(this.listdata); + if (this.$store.state.pigCode) { + this.listdata.dirs = this.$store.state.pigCode; + + } + + const data = await dataQuerySelectByPage(this.listdata) + this.$store.state.loading = false; if (data.code != 200) { - this.$message.error('鍒楄〃璋冪敤澶辫触'); + return this.$message.error("鍒楄〃璋冪敤澶辫触") } - var val_Data = data.result; - this.count = data.count; + if (data.result.length == 0) { + return this.$message("鍒楄〃鏌ユ棤鏁版嵁") + } + + + + var val = data.result; + val = val.filter((res) => { + + if (res.dirName) { + res.dirid = res.dirName + } + if (res.depName) { + res.depid = res.depName + } + if (res.verName) { + res.verid = res.verName + } + if (res.updateName) { + res.updateuser = res.updateName + } + if (res.createName) { + res.createuser = res.createName + } + + if (res.createtime) { + res.createtime = this.format(res.createtime) + } + if (res.updatetime) { + res.createtime = this.format(res.updatetime) + } + return res + }) + + + var val_Data = data.result + this.count = data.count for (var i in val_Data) { - var valste = val_Data[i]; + var valste = val_Data[i] for (var j in this.optionx) { if ( this.optionx[j].domainNa != null && this.optionx[j].domainNa != undefined ) { - valste[this.optionx[j].field] = this.optionx[j].domainNa; + valste[this.optionx[j].field] = this.optionx[j].domainNa } } } - this.tableData = data.result; - this.$refs.filterTable.doLayout(); + + + this.tableData = val + // this.$refs.filterTable.doLayout() + }, + + async setCartesianToEightFour(entities) { + var east = Cesium.Math.toDegrees( + entities.rectangle.coordinates.getValue().east + ); + var north = Cesium.Math.toDegrees( + entities.rectangle.coordinates.getValue().north + ); + var west = Cesium.Math.toDegrees( + entities.rectangle.coordinates.getValue().west + ); + var south = Cesium.Math.toDegrees( + entities.rectangle.coordinates.getValue().south + ); + var line = turf.polygon([ + [ + [east, north], + [west, north], + [west, south], + [east, south], + [east, north], + ], + ]); + var wkt = this.$wkt.convert(line.geometry); + this.listdata.pageIndex = 1; + this.listdata.pageSize = 10; + this.listdata.wkt = encr(wkt) + + const data = await dataQuerySelectByPage(this.listdata) + + if (data.code != 200) { + return this.$message.error("鍒楄〃璋冪敤澶辫触") + } + + this.count = data.count; + if (data.result.length == 0) { + return this.$message({ + message: '鏈煡璇㈠埌杞瓟鐐规暟鎹�', + type: 'warning' + }); + } else { + this.$message({ + message: '鏌辩姸鍥炬煡璇㈡垚鍔�', + type: 'success' + }); + setTimeout(() => { + var val = data.result; + val = val.filter((res) => { + + if (res.dirName) { + res.dirid = res.dirName + } + if (res.depName) { + res.depid = res.depName + } + if (res.verName) { + res.verid = res.verName + } + if (res.updateName) { + res.updateuser = res.updateName + } + if (res.createName) { + res.createuser = res.createName + } + + if (res.createtime) { + res.createtime = this.format(res.createtime) + } + if (res.updatetime) { + res.createtime = this.format(res.updatetime) + } + return res + }) + + + + this.tableData = val; + this.geobodyCount = data.count; + this.showHistogramLayer(data.count) + this.$refs.filterTable.doLayout(); + var that = this; + + window.histogramHandler = new Cesium.ScreenSpaceEventHandler( + sgworld.Viewer.scene.canvas + ) + window.histogramHandler.setInputAction((event) => { + var pick = sgworld.Viewer.scene.pick(event.endPosition); + if (pick) { + + var propertiesFlag = that.$store.state.propertiesFlag + + if (Cesium.defined(pick)) { + if (pick && pick.id && pick.id.tag && pick.id.tag == "Histogram") { + that.$store.state.propertiesInfo = { + title: pick.id.properties._exppointid._value, + name: pick.id.properties._geoname._value, + type: pick.id.properties.geotype._value, + botdepth: pick.id.properties._botdepth._value, + describe: pick.id.properties._describe._value, + } + that.$store.state.propertiesFlag = "2" + } else { + if (propertiesFlag == 1) { + that.$store.state.propertiesFlag = propertiesFlag + } else { + that.$store.state.propertiesFlag = null + } + } + } else { + if (propertiesFlag == 1) { + that.$store.state.propertiesFlag = propertiesFlag + } else { + that.$store.state.propertiesFlag = null + } + } + } + + }, Cesium.ScreenSpaceEventType.MOUSE_MOVE) + }, 500); + } + + + }, + async showHistogramLayer(res) { + var obj = { + pageIndex: 1, + pageSize: res, + wkt: this.listdata.wkt, + name: this.listdata.name, + hasGeom: 1, + } + const data = await dataQuerySelectByPage(obj) + if (data.code != 200) { + return + } + var val = data.result; + // for (var i in val) { + this.setShowHistogramLayer(val) + // } + }, + async setShowHistogramLayer(res) { + var gid = []; + for (var i in res) { + + gid.push(res[i].exppointid) + } + // var param = { + // gid: res.gid, + // name: this.spaceLayer, + // } + + + // const data1 = await dataQuerySelectWktById(param) + // if (data1.code != 200) { + // this.$message.error("鍒楄〃璋冪敤澶辫触") + // } + // var val1 = decr(data1.result) + // var wkt = this.$wkt.parse(val1) + // var coord = wkt.coordinates + var obj = { + pageIndex: 1, + pageSize: 100000000, + name: 'sexplorationpointstratum', + filter: "exppointid in '" + gid.toString() + "'" + } + var data = await dataQuerySelectByPage(obj) + if (data.code != 200) { return } + if (data.result.length == 0) { + return this.$message('鏌ユ棤鏁版嵁'); + } + for (var i in res) { + this.setHistogramLayer(res[i], data.result) + } + // if (data.result.length != 0) { + // var val = data.result; + // //鍐掓场鎺掑簭 + // for (var i = 0; i < val.length; i++) { + // for (var u = i + 1; u < val.length; u++) { + // if (val[i].botdepth > val[u].botdepth) { + // var num = val[i]; + // val[i] = val[u]; + // val[u] = num; + // } + // } + // } + + + // var num = res.elev; + // var height = 0; + // for (var i = 0; i < val.length; i++) { + // var line; + + // var geoname = val[i].geoname; + // var col = outlineList.filter((res) => { + // if (res.name == geoname) { + // return res + // } + // }) + // line = col[0].color + // var height = num - val[i].botdepth + // var layer = Viewer.entities.add({ + // position: Cesium.Cartesian3.fromDegrees(coord[0], coord[1]), + // tag: 'Histogram', + // properties: val[i], + // ellipse: { + // semiMinorAxis: 1.0, //鐭酱 + // semiMajorAxis: 1.0, //闀胯酱 + // height: height, //鎷変几楂樺害 elev gwaterdep + // extrudedHeight: num, //绂诲湴楂樺害 + // rotation: Cesium.Math.toRadians(0), //鏃嬭浆 + // fill: true, //鏄惁鏄剧ず鍦嗙殑濉厖 + // material: Cesium.Color.fromCssColorString(line), //鍦嗙殑棰滆壊, + // outline: false, //鏄惁鏄剧ず鍦嗚疆寤� + + // }, + // }); + // num -= val[i].botdepth; + // this.$store.state.histogramLayer.push(layer) + // } + // } else { + // + // } + // + }, + setHistogramLayer(res, data) { + + var exppointid = res.exppointid; + + var val1 = decr(res.geom) + var wkt = this.$wkt.parse(val1) + var coord = wkt.coordinates; + + var std = []; + var num = res.elev == null ? 0 : res.elev; + + var height = 0; + for (var i in data) { + if (data[i].exppointid == exppointid) { + std.push(data[i]) + } + } + + var outlineList = this.outlineList; + if (std.length > 0) { + for (var i in std) { + var line; + var geoname = std[i].geoname; + var col = outlineList.filter((ste) => { + if (ste.name == geoname) { + return res + } + }) + + if (col.length == 0) { + col = outlineList.filter((ste) => { + if (ste.name == '鍏朵粬') { + return res + } + }) + } + line = col[0].color + + var height = num - std[i].botdepth + // console.log(num, std[i].botdepth) + var layer = Viewer.entities.add({ + position: Cesium.Cartesian3.fromDegrees(coord[0], coord[1]), + tag: 'Histogram', + properties: std[i], + ellipse: { + semiMinorAxis: 2.0, //鐭酱 + semiMajorAxis: 2.0, //闀胯酱 + height: height, //鎷変几楂樺害 elev gwaterdep + extrudedHeight: num, //绂诲湴楂樺害 + rotation: Cesium.Math.toRadians(0), //鏃嬭浆 + fill: true, //鏄惁鏄剧ず鍦嗙殑濉厖 + material: Cesium.Color.fromCssColorString(line), //鍦嗙殑棰滆壊, + outline: false, //鏄惁鏄剧ず鍦嗚疆寤� + + }, + }); + num -= std[i].botdepth; + this.$store.state.histogramLayer.push(layer) + } + this.$store.state.histLenged = true; + } + + + + }, + + + + spaceHistogram() { + this.resetForm(); + if (this.$store.state.histogramLayer.length != 0) { + for (var i in this.$store.state.histogramLayer) { + Viewer.entities.remove(this.$store.state.histogramLayer[i]) + } + } + if (window.histogramHandler != null && Cesium.defined(window.histogramHandler)) { + window.histogramHandler.removeInputAction( + Cesium.ScreenSpaceEventType.MOUSE_MOVE + ) + window.histogramHandler = null + } + var entitys = Viewer.entities._entities._array; + for (var i = 0; i < entitys.length; i++) { + if (entitys[i]._name === "鍦拌川浣撴ā鍨�") { + Viewer.entities.remove(entitys[i]); + i--; + } + } + this.geobodyCount = null; + var that = this; + sgworld.Creator.createSimpleGraphic('rectangle', { showSize: false }, function (entity) { + sgworld.Creator.SimpleGraphic.remove(entity.id); + that.setCartesianToEightFour(entity) + }); + + }, + async spaceGeobody() { + var entitys = Viewer.entities._entities._array; + for (var i = 0; i < entitys.length; i++) { + if (entitys[i]._name === "鍦拌川浣撴ā鍨�") { + Viewer.entities.remove(entitys[i]); + i--; + } + } + + if (this.geobodyCount) { + + var obj = { + pageIndex: 1, + pageSize: this.geobodyCount, + wkt: this.listdata.wkt, + name: this.listdata.name, + hasGeom: 1, + } + const data = await dataQuerySelectByPage(obj) + if (data.code != 200) { + return + } + var gid = []; + var val = data.result; + for (var i in val) { + gid.push(val[i].exppointid) + } + var obj = { + pageIndex: 1, + pageSize: 100000000, + name: 'sexplorationpointstratum', + filter: "exppointid in '" + gid.toString() + "'" + } + var data2 = await dataQuerySelectByPage(obj) + + if (data2.code == 200) { + var val2 = data2.result; + var std = []; + for (var i in val) { + var soilLayers = []; + + for (var j in val2) { + if (val2[j].exppointid == val[i].exppointid) { + soilLayers.push(val2[j]) + } + } + var val1 = decr(val[i].geom) + var wkt = this.$wkt.parse(val1) + var coord = wkt.coordinates + std.push({ + bh: val[i].exppointid, + X: coord[0], + Y: coord[1], + Z: val[i].elev, + soilLayers: soilLayers + }) + } + this.setLayerByZFBH(std); + } + + } else { + return this.$message('鏈煡璇㈠埌杞瓟鐐规暟鎹�,鏃犳硶鐢熸垚鍦拌川浣�'); + } + }, + setLayerByZFBH(res) { + var list = [ + { 'name': '绮夎川榛忓湡', 'color': [139, 106, 77, 1] }, + { 'name': '娣ゆ偿璐ㄧ矇鍦�', 'color': [141, 85, 69, 1] }, + { 'name': '鍦嗙牼', 'color': [102, 166, 184, 1] }, + { 'name': '鍗电煶', 'color': [54, 83, 173, 1] }, + { 'name': '娉ュ博', 'color': [47, 30, 13, 1] }, + { 'name': '缁嗙爞', 'color': [93, 88, 15, 1] }, + { 'name': '涓爞', 'color': [164, 140, 21, 1] }, + { 'name': '娣ゆ偿璐ㄥ湡', 'color': [75, 74, 78, 1] }, + { 'name': '鍏朵粬', 'color': [225, 225, 225, 1] } + ] + for (var i = 0; i < list.length; i++) { + var out_color = list[i].color + var color = new Cesium.Color(out_color[0] / 255.0, out_color[1] / 255.0, out_color[2] / 255.0).withAlpha(0.9) + this.CreateLayerByZFBH(list[i].name, res, color) + + } + // var color = new Cesium.Color(139 / 255, 106 / 255, 77 / 255).withAlpha(0.9) + // this.CreateLayerByZFBH("娣ゆ偿璐ㄧ矇鍦�", res, color) + + }, + CreateLayerByZFBH(zfbh, jsonObj, materialColor) { + + var featurePoints = []; + var featurePoints1 = []; + let points = turf.featureCollection([]); + for (let i = 0; i < jsonObj.length; i++) { + var p = jsonObj[i]; + var layers = p.soilLayers; + points.features.push(turf.point([parseFloat(p.X), parseFloat(p.Y)], { alt: p.Z })); + for (let j = 0; j < layers.length; j++) { + let obj = layers[j]; + + if (obj.geoname == zfbh) { + if (j == 0) { + + featurePoints.push(...[parseFloat(p.X), parseFloat(p.Y), parseFloat(p.Z)]); + featurePoints1.push(...[parseFloat(p.X), parseFloat(p.Y), (parseFloat(p.Z) - parseFloat(obj.botdepth))]); + } else { + let obj_height = this.GetRealHeight(j, layers, p.Z); + + featurePoints.push(...[parseFloat(p.X), parseFloat(p.Y), parseFloat(obj_height.topHeight)]); + featurePoints1.push(...[parseFloat(p.X), parseFloat(p.Y), parseFloat(obj_height.bottomHeight)]); + + } + + } + } + } + this.CreateSoilLayer(featurePoints, featurePoints1, materialColor); + }, + CreateSoilLayer(abovePoints, underPoints, materialColor) { + let aboveCollection = this.CreateCollectionByArray(abovePoints); + let underCollection = this.CreateCollectionByArray(underPoints); + //璁$畻鎻掑�� + let options = { gridType: "points", property: "alt", units: "miles" }; + let aboveGrid = turf.interpolate(aboveCollection, 0.01, options); + let underGrid = turf.interpolate(underCollection, 0.01, options); + //鍒涘缓tin闈� + let aboveTin = turf.tin(aboveGrid, "alt"); + let underTin = turf.tin(underGrid, "alt"); + //鑾峰彇tin闈㈢殑鍑犱釜椤剁偣 + let aboveHull = turf.convex(aboveTin); + let underHull = turf.convex(underTin); + + //缁勮椤跺簳闈㈠洓涓《鐐� + this.CreateRoundMian(aboveTin, aboveHull, underTin, underHull, materialColor); + //鍒涘缓闈� + this.CreateTin(aboveTin, materialColor); + this.CreateTin(underTin, materialColor); + }, + + CreateRoundMian(tinArr, hull, tinArr1, hull1, materialColor) { + if (!hull) { + return; + } + let left = turf.lineIntersect(tinArr, turf.lineString([[hull.geometry.coordinates[0][0][0], hull.geometry.coordinates[0][0][1]], [hull.geometry.coordinates[0][1][0], hull.geometry.coordinates[0][1][1]]])); + let right = turf.lineIntersect(tinArr, turf.lineString([[hull.geometry.coordinates[0][1][0], hull.geometry.coordinates[0][1][1]], [hull.geometry.coordinates[0][2][0], hull.geometry.coordinates[0][2][1]]])); + let top = turf.lineIntersect(tinArr, turf.lineString([[hull.geometry.coordinates[0][2][0], hull.geometry.coordinates[0][2][1]], [hull.geometry.coordinates[0][3][0], hull.geometry.coordinates[0][3][1]]])); + let bottom = turf.lineIntersect(tinArr, turf.lineString([[hull.geometry.coordinates[0][3][0], hull.geometry.coordinates[0][3][1]], [hull.geometry.coordinates[0][4][0], hull.geometry.coordinates[0][4][1]]])); + let left1 = turf.lineIntersect(tinArr1, turf.lineString([[hull1.geometry.coordinates[0][0][0], hull1.geometry.coordinates[0][0][1]], [hull1.geometry.coordinates[0][1][0], hull1.geometry.coordinates[0][1][1]]])); + let right1 = turf.lineIntersect(tinArr1, turf.lineString([[hull1.geometry.coordinates[0][1][0], hull1.geometry.coordinates[0][1][1]], [hull1.geometry.coordinates[0][2][0], hull1.geometry.coordinates[0][2][1]]])); + let top1 = turf.lineIntersect(tinArr1, turf.lineString([[hull1.geometry.coordinates[0][2][0], hull1.geometry.coordinates[0][2][1]], [hull1.geometry.coordinates[0][3][0], hull1.geometry.coordinates[0][3][1]]])); + let bottom1 = turf.lineIntersect(tinArr1, turf.lineString([[hull1.geometry.coordinates[0][3][0], hull1.geometry.coordinates[0][3][1]], [hull1.geometry.coordinates[0][4][0], hull1.geometry.coordinates[0][4][1]]])); + // console.log(left); + // console.log(intPoints); + // console.log(tinArr); + this.SetAltAttribut(tinArr, left); + this.SetAltAttribut(tinArr, right); + this.SetAltAttribut(tinArr, top); + this.SetAltAttribut(tinArr, bottom); + this.SetAltAttribut(tinArr1, left1); + this.SetAltAttribut(tinArr1, right1); + this.SetAltAttribut(tinArr1, top1); + this.SetAltAttribut(tinArr1, bottom1); + ///缁樺埗闈� + this.CreateSoilLayerRound(left, left1, materialColor); + this.CreateSoilLayerRound(right, right1, materialColor); + this.CreateSoilLayerRound(top, top1, materialColor); + this.CreateSoilLayerRound(bottom, bottom1, materialColor); + }, + SetAltAttribut(tinarr, points) { + for (let i = 0; i < tinarr.features.length; i++) { + for (let j = 0; j < points.features.length; j++) { + if (!turf.booleanDisjoint(tinarr.features[i].geometry, points.features[j].geometry)) { + for (let n = 0; n < tinarr.features[i].geometry.coordinates[0].length; n++) { + if (tinarr.features[i].geometry.coordinates[0][n][0] == points.features[j].geometry.coordinates[0] && tinarr.features[i].geometry.coordinates[0][n][1] == points.features[j].geometry.coordinates[1]) { + if (n == 0) { + points.features[j].properties.alt = tinarr.features[i].properties.a; + break; + } + if (n == 1) { + points.features[j].properties.alt = tinarr.features[i].properties.b; + break; + } + if (n == 2) { + points.features[j].properties.alt = tinarr.features[i].properties.c; + break; + } + } + + } + } + } + } + }, + CreateCollectionByArray(arr) { + let newCollection = turf.featureCollection([]); + for (let i = 0; i < arr.length; i += 3) { + let tmpPoint = turf.point([arr[i], arr[i + 1]], { + alt: arr[i + 2] + }); + newCollection.features.push(tmpPoint); + } + return newCollection; + }, + + CreateTin(tin, materialColor) { + for (let n = 0; n < tin.features.length; n++) { + let geoms = tin.features[n].geometry.coordinates[0]; + + let points = []; + let p1 = new Cesium.Cartesian3.fromDegrees(geoms[0][0], geoms[0][1], tin.features[n].properties.a); + let p2 = new Cesium.Cartesian3.fromDegrees(geoms[1][0], geoms[1][1], tin.features[n].properties.b); + let p3 = new Cesium.Cartesian3.fromDegrees(geoms[2][0], geoms[2][1], tin.features[n].properties.c); + points.push(p1) + points.push(p2) + points.push(p3) + let aa = Viewer.entities.add({ + name: '鍦拌川浣撴ā鍨�', + polygon: { + hierarchy: new Cesium.PolygonHierarchy(points), + material: materialColor, + // material: new Cesium.Color(Math.random() * 255, Math.random() * 255, Math.random() * 255), + perPositionHeight: true + } + }); + Viewer.flyTo(aa) + } + }, + CreateSoilLayerRound(above, under, materialColor) { + for (let i = 0; i < under.features.length; i++) { + above.features.push(under.features[under.features.length - 1 - i]); + } + + let points = []; + for (let j = 0; j < above.features.length; j++) { + let geo = above.features[j].geometry.coordinates; + let alt = above.features[j].properties.alt; + let p = new Cesium.Cartesian3.fromDegrees(geo[0], geo[1], alt); + points.push(p); + } + Viewer.entities.add({ + name: '鍦拌川浣撴ā鍨�', + polygon: { + hierarchy: new Cesium.PolygonHierarchy(points), + material: materialColor, + + perPositionHeight: true + } + }); + }, + GetRealHeight(index, arr, parentZ) { + + var top = 0; + var bottom = 0; + var std = 0; + var start = index + 1 + var end = index - 1; + for (let i = 0; i < start; i++) { + std += parseFloat(arr[i].botdepth) + + if (i == end) { + + top = parseFloat(parentZ - std).toFixed(6); + + } + + bottom = parseFloat(parentZ - std).toFixed(6); + } + + + return { + topHeight: top, + bottomHeight: bottom + }; }, async spaceLocation(index, row) { var param = { gid: row.gid, name: this.spaceLayer, - }; - const data = await dataQuerySelectWktById(param); + } + const data = await dataQuerySelectWktById(param) if (data.code != 200) { - this.$message.error('鍒楄〃璋冪敤澶辫触'); + this.$message.error("鍒楄〃璋冪敤澶辫触") } - var val1 = decr(data.result); + var val1 = decr(data.result) if (val1) { if (this.$store.state.primitLayer != null) { - sgworld.Creator.DeleteObject(this.$store.state.primitLayer); - this.$store.state.primitLayer = null; + sgworld.Viewer.entities.remove(this.$store.state.primitLayer) + sgworld.Creator.DeleteObject(this.$store.state.primitLayer) + this.$store.state.primitLayer = null } - var wkt = this.$wkt.parse(val1); - this.setMapLoaction(wkt); + var wkt = this.$wkt.parse(val1) + + this.setMapLoaction(wkt, row) } }, handleSizeChange(val) { - this.listdata.pageSize = val; - this.getSpaceTableLayer(); + this.listdata.pageSize = val + this.getSpaceTableLayer() }, handleCurrentChange(val) { - this.listdata.pageIndex = val; - this.getSpaceTableLayer(); + this.listdata.pageIndex = val + this.getSpaceTableLayer() }, - setMapLoaction(res) { - if (this.$store.state.primitLayer != null) { - sgworld.Creator.DeleteObject(this.$store.state.primitLayer); - this.$store.state.primitLayer = null; - } - var coord = res.coordinates; - if (res.type == 'Point') { - this.$store.state.primitLayer = sgworld.Creator.CreateLabel( - { X: coord[0], Y: coord[1], Altitude: 2000 }, - '', - SmartEarthRootUrl + 'Workers/image/mark.png', - { - disableDepthTestDistance: Infinity, - scale: 0.8, - }, - 0, - '宸℃鐐�' - ); - sgworld.Navigate.flyToObj(this.$store.state.primitLayer.item); - } else if (res.type == 'MultiPolygon') { - var val = res.coordinates[0][0]; - var std = []; - for (var i in val) { - - std.push({ x: val[i][0], y: val[i][1], z: 1000 }) - } - this.$store.state.primitLayer = sgworld.Creator.createPolygon(std, { - fillColor: '#ffff00', - outlineColor: '#fff', - outlineWidth: 2 - }, 1, 0, "闈�"); - sgworld.Navigate.flyToObj(this.$store.state.primitLayer.item); - } else if (res.type == 'MultiLineString') { - var line = res.coordinates[0]; - var std = []; - for (var i in line) { - - std.push({ x: line[i][0], y: line[i][1], z: 1000 }) - } - this.$store.state.primitLayer = sgworld.Creator.createPolyline(std, "#ffff00", 1, 0, "绾�"); - sgworld.Navigate.flyToObj(this.$store.state.primitLayer.item); + setMapLoaction(res, properties) { + if (this.$store.state.primitLayer != null) { + sgworld.Creator.DeleteObject(this.$store.state.primitLayer) + // this.$store.state.primitLayer = null; + sgworld.Viewer.entities.remove(this.$store.state.primitLayer) + this.$store.state.primitLayer = null } + var coord = res.coordinates + + switch (res.type) { + case "Point": + var val = Cesium.Cartesian3.fromDegrees( + res.coordinates[0], + res.coordinates[1] + ) + var point = Viewer.entities.add({ + properties: properties, + tag: "properties_point", + position: val, + billboard: { + // 鍥惧儚鍦板潃锛孶RI鎴朇anvas鐨勫睘鎬� + image: SmartEarthRootUrl + "Workers/image/mark.png", + heightReference: Cesium.HeightReference.CLAMP_TO_GROUND, + // 澶у皬鏄惁浠ョ背涓哄崟浣� + sizeInMeters: false, + // 鐩稿浜庡潗鏍囩殑鍨傜洿浣嶇疆 + verticalOrigin: Cesium.VerticalOrigin.CENTER, + // 鐩稿浜庡潗鏍囩殑姘村钩浣嶇疆 + horizontalOrigin: Cesium.HorizontalOrigin.LEFT, + // 搴旂敤浜庡浘鍍忕殑缁熶竴姣斾緥銆傛瘮渚嬪ぇ浜庝細1.0鏀惧ぇ鏍囩锛岃�屾瘮渚嬪皬浜庝細1.0缂╁皬鏍囩銆� + scale: 1.0, + // 鏄惁鏄剧ず + show: true, + }, + }) + point.billboard.disableDepthTestDistance = Number.POSITIVE_INFINITY + this.$store.state.queryInfo.push(point) + sgworld.Navigate.flyToObj(point) + this.$store.state.primitLayer = point + break + case "LineString": + case "MultiLineString": + var line = res.coordinates[0] + var std = [] + for (var i in line) { + std.push(line[i][0], line[i][1]) + } + var polyline = Viewer.entities.add({ + properties: properties, + tag: "properties_line", + polyline: { + positions: Cesium.Cartesian3.fromDegreesArray(std), + width: 5, + material: new Cesium.Color(1.0, 0.0, 0.0, 0.3), + clampToGround: true, + }, + }) + this.$store.state.queryInfo.push(polyline) + sgworld.Navigate.flyToObj(polyline) + this.$store.state.primitLayer = polyline + break + case "MultiPolygon": + var val = res.coordinates[0][0] + var std = [] + for (var i in val) { + std.push(val[i][0], val[i][1]) + } + var entity = Viewer.entities.add({ + properties: properties, + tag: "properties_polygon", + polygon: { + hierarchy: Cesium.Cartesian3.fromDegreesArray(std), + //height : 100000, + material: new Cesium.Color(1.0, 0.0, 0.0, 0.3), + outline: true, + outlineColor: new Cesium.Color(1.0, 0.0, 0.0, 0.3), + }, + }) + this.$store.state.queryInfo.push(entity) + sgworld.Navigate.flyToObj(entity) + this.$store.state.primitLayer = entity + break + } + this.setMapHandler() }, + setMapHandler() { + var that = this; + window.propertieshandler = new Cesium.ScreenSpaceEventHandler( + sgworld.Viewer.scene.canvas + ) + window.propertieshandler.setInputAction(event => { + let pick = sgworld.Viewer.scene.pick(event.position) + if ( + pick && + pick.id && + pick.id.tag && + pick.id.tag.includes("properties_") + ) { + if (this.spaceLayer == 'msurfacedeformationdata') { + this.$store.state.surfaceDeForm.flag = true; + this.$store.state.surfaceDeForm.gid = pick.id.properties.gid._value; + } else { + this.$store.state.surfaceDeForm.flag = false; + this.$store.state.surfaceDeForm.gid = null; + } + this.$store.state.propertiesFlag = "1" + let properties = pick.id.properties + let propertyNames = pick.id.properties.propertyNames + let obj = {} + obj["eventid"] = properties["_eventid"]._value + // + this.attributeData.forEach(item => { + propertyNames.forEach(itemElement => { + if (itemElement == item.field) { + obj[item.alias] = properties[itemElement]._value + } + }) + }) + if (obj['鏇存柊鏃堕棿']) { + obj['鏇存柊鏃堕棿'] = that.format(obj['鏇存柊鏃堕棿']) + } + if (obj['鍒涘缓鏃堕棿']) { + + + obj['鍒涘缓鏃堕棿'] = that.format(obj['鍒涘缓鏃堕棿']) + } + + this.$store.state.propertiesInfo = obj + } + }, Cesium.ScreenSpaceEventType.LEFT_CLICK) + }, + //鏍煎紡鍖栨椂闂� + format(shijianchuo) { + //shijianchuo鏄暣鏁帮紝鍚﹀垯瑕乸arseInt杞崲 + var time = new Date(shijianchuo); + var y = time.getFullYear(); + var m = time.getMonth() + 1; + var d = time.getDate(); + var h = time.getHours(); + var mm = time.getMinutes(); + var s = time.getSeconds(); + return y + "-" + this.add0(m) + "-" + this.add0(d); + }, + //鏍煎紡鍖栨椂闂� + add0(m) { + return m < 10 ? "0" + m : m; + }, + }, -}; + + destroyed() { + this.$store.state.propertiesFlag = null + if (window.propertieshandler != null && Cesium.defined(window.propertieshandler)) { + window.propertieshandler.removeInputAction( + Cesium.ScreenSpaceEventType.LEFT_CLICK + ) + window.propertieshandler = null + } + }, +} </script> <style lang="less" scoped> @@ -408,122 +1485,25 @@ border: 1px solid gray; float: left; .centTable { - height: 230px; + position: absolute; + height: 66%; + width: 98%; } .rightTitle { padding: 5px; - color: white; + width: 100%; .boxClose { float: right; margin-right: 20px; - color: white; } } .bottomPage { position: absolute; - bottom: 1%; + bottom: 10px; } - // 璁剧疆杈撳叆妗嗙殑鑳屾櫙鑹层�佸瓧浣撻鑹层�佽竟妗嗗睘鎬ц缃紱 - /deep/.el-input__inner { - background-color: transparent !important ; - color: #fff; - border: 1px solid; - } - /deep/ .el-select .el-input__inner { - border-color: #fff !important; - } - /deep/ .el-table { - background-color: transparent; - th, - td { - background-color: transparent; - } - .el-table__expanded-cell { - background-color: transparent !important; - } - - // 琛ㄥご鑳屾櫙鑹� - th.el-table__cell { - background-color: #303030; - color: #fff; - } - tr > td { - background-color: #303030; - color: #fff; - } - - // hover鏁堟灉 - tr:hover > td { - background-color: rgba(255, 255, 255, 0.3) !important; - } - - tbody tr:hover { - background-color: rgba(255, 255, 255, 0.3) !important; - // text-align: center; - } - - // 婊氬姩鏉″楂� - .el-table__body-wrapper::-webkit-scrollbar { - width: 5px; - height: 5px; - } - - .el-table__body-wrapper::-webkit-scrollbar { - width: 5px; - /*婊氬姩鏉″搴�*/ - height: 5px; - /*婊氬姩鏉¢珮搴�*/ - } - /*瀹氫箟婊氬姩鏉¤建閬� 鍐呴槾褰�+鍦嗚*/ - .el-table__body-wrapper::-webkit-scrollbar-track { - box-shadow: 0px 1px 3px #216fe6 inset; - /*婊氬姩鏉$殑鑳屾櫙鍖哄煙鐨勫唴闃村奖*/ - border-radius: 10px; - } - - /*瀹氫箟婊戝潡 鍐呴槾褰�+鍦嗚*/ - .el-table__body-wrapper::-webkit-scrollbar-thumb { - box-shadow: 0px 1px 3px #216fe6 inset; - border-radius: 6px; - background-color: #216fe6; - } - } - .pagination_box { - margin-top: 20px; - /deep/.el-input__inner { - background-color: transparent !important; - border: 1px solid; - color: white; - } - /deep/.el-pagination__total { - color: white; - } - /deep/.el-pagination__jump { - color: white; - } - /deep/.el-pager li.active { - color: #409eff; - } - /deep/.el-pager li { - color: white; - background: transparent; - } - /deep/.el-pager li { - color: white; - } - /deep/.btn-prev { - background: transparent; - } - /deep/.btn-next { - background: transparent; - } - /deep/.btn-next i { - color: white; - } - /deep/.btn-prev i { - color: white; - } + /deep/.el-form-item { + margin-bottom: 0px; } } </style> -- Gitblit v1.9.3