钻孔柱状图修改

surprise

2023-10-16 cfc1abd6b855c3575d5d20646bb4dd97d8601469

 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"
      >
@@ -56,7 +94,19 @@
            @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"
@@ -84,7 +134,7 @@
              ></el-button>
            </template>
          </el-table-column>
          <el-table-column
          <!-- <el-table-column
            label="柱状图"
            width="100"
            align="center"
@@ -97,7 +147,7 @@
                @click="spaceHistogram(scope.$index, scope.row)"
              ></el-button>
            </template>
          </el-table-column>
          </el-table-column> -->
          <el-table-column
            v-for="(item, index) in attributeData"
            :key="index"
@@ -123,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>

@@ -133,7 +261,10 @@
  inquiry_selectFields,
  inquiry_selectDomains,
  decr,
  encr,
} from "../../api/api.js"
import * as turf from "@turf/turf"
import { conditions } from "../../views/Archive/Archive.js";
export default {
  computed: {
    storeTime() {
@@ -142,6 +273,13 @@
  },
  data() {
    return {
      conditionVisible: false,
      filedsOption: [],
      condOption: [],
      ruleForm: {
        fileName: "",
      },
      fromSqlflag: false,
      count: 0,
      listdata: {
        pageIndex: 1,
@@ -209,12 +347,32 @@
      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.resetForm();
      // this.getDomainsLayer()
      // this.getTableselectFields();
      // this.restSpacePopLayer();
    },
@@ -223,12 +381,43 @@
    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)
@@ -277,8 +466,14 @@
      this.formInline.region = this.options[0].value
    },
    setListDataStart() {
      this.listdata.pageSize = 10
      this.listdata.pageIndex = 1
      this.listdata = {
        pageIndex: 1,
        pageSize: 10,
        name: null,
        srid: 4326,
        wkt: null,
        filter: null,
      }
      this.tableData = []
    },
    //初始化查询条件
@@ -312,9 +507,13 @@
    async getTableselectFields() {
      const data = await inquiry_selectFields({ name: this.spaceLayer })
      if (data.code != 200) {
        this.$message.error("列表调用失败")
        this.$message.error("列表调用字段失败")
      }
      if (data.result.length == 0) {
        this.$message("列表调用字段查无数据")
      }

      this.filedsOption = [];
      this.optionx = []
      var valadata = data.result
      for (var i in valadata) {
@@ -326,10 +525,63 @@
            valadata[i].domainNa = this.getMatchDomainNa(valadata[i].domainNa)
          }
          this.optionx.push(valadata[i])
          this.filedsOption.push(valadata[i])
          this.attributeData.push(valadata[i])
        }
      }
      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
@@ -342,49 +594,84 @@
    },
    //初始化查询阈值表
    async getDomainsLayer() {
      this.$store.state.loading = true;
      const data = await inquiry_selectDomains({ name: this.spaceLayer })
      if (data.code != 200) {
        this.$message.error("列表调用失败")
        this.$message.error("列表阈值调用失败")
      }
      // 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
      } else {
        var val
        var value = this.formInline.input
        if (this.querytype == "long" || this.querytype == "integer") {
          val = parseInt(value)
        } else if (this.querytype == "double") {
          if (this.formSql.value.indexOf(".") != -1) {
            val = value
          } else {
            val = parseFloat(value).toFixed(1)
          }
        } else if (this.querytype == "date" || this.querytype == "datetime") {
          var time = new Date(value)
          var m = time.getMonth() + 1
          var d = time.getDate()
          var y = time.getFullYear()
          val = "'" + y + "-" + this.add0(m) + "-" + this.add0(d) + "'"
        } else {
          val = "'" + value + "'"
        }

        this.listdata.filter =
          this.formInline.name + " " + this.formInline.region + " " + val
      this.listdata.name = this.spaceLayer
      if (this.ruleForm.fileName != "") {
        this.listdata.filter = this.ruleForm.fileName;
      } else {
        this.listdata.filter = null;
      }
      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("列表调用失败")
      }
      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

@@ -399,10 +686,305 @@
          }
        }
      }
      this.tableData = data.result
      this.$refs.filterTable.doLayout()


      this.tableData = val
      // this.$refs.filterTable.doLayout()
    },
    async spaceHistogram(index, row) {

    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])
@@ -414,119 +996,292 @@
        )
        window.histogramHandler = null
      }
      var param = {
        gid: row.gid,
        name: this.spaceLayer,
      var entitys = Viewer.entities._entities._array;
      for (var i = 0; i < entitys.length; i++) {
        if (entitys[i]._name === "地质体模型") {
          Viewer.entities.remove(entitys[i]);
          i--;
        }
      }
      const data1 = await dataQuerySelectWktById(param)
      if (data1.code != 200) {
        this.$message.error("列表调用失败")
      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--;
        }
      }

      var val1 = decr(data1.result)
      var wkt = this.$wkt.parse(val1)
      var coord = wkt.coordinates
      var obj = {
        pageIndex: 1,
        pageSize: 10,
        name: 'sexplorationpointstratum',
        filter: "exppointid = '" + row.exppointid + "'"
      }
      var data = await dataQuerySelectByPage(obj)
      if (data.code != 200) {
      if (this.geobodyCount) {

      }

      if (data.result.length != 0) {
        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 = 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;
            }
          }
        for (var i in val) {
          gid.push(val[i].exppointid)
        }
        var outlineList = [
          'rgba(141,135,114,1)',
          'rgba(248,235,179,1)',
          'rgba(185,183,151,1)',
          'rgba(224,222,94,1)',
          'rgba(250,190,153,1)',
          'rgba(197,222,130,1)',
          'rgba(208,228,177,1)',
        ]
        var num = row.elev;
        var height = 0;
        for (var i = 0; i < val.length; i++) {
          var fill, line;
          if (i > outlineList.length) {
            var len = outlineList.length - 1;
            fill = outlineList[len];
            line = outlineList[len];
          } else {
            fill = outlineList[i];
            line = outlineList[i];
          }
          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)
          sgworld.Navigate.flyToObj(layer)
        var obj = {
          pageIndex: 1,
          pageSize: 100000000,
          name: 'sexplorationpointstratum',
          filter: "exppointid in '" + gid.toString() + "'"
        }
        window.histogramHandler = new Cesium.ScreenSpaceEventHandler(
          sgworld.Viewer.scene.canvas
        )
        var that = this;
        window.histogramHandler.setInputAction((event) => {
          // var ellipsoid = sgworld.Viewer.scene.globe.ellipsoid;
          // var cartesian = sgworld.Viewer.scene.camera.pickEllipsoid(event.endPosition, ellipsoid);
          var pick = sgworld.Viewer.scene.pick(event.endPosition);
          var selectedEntity = null;
        var data2 = await dataQuerySelectByPage(obj)

          if (Cesium.defined(pick)) {
            if (pick && pick.id && pick.id.tag && pick.id.tag == "Histogram") {
        if (data2.code == 200) {
          var val2 = data2.result;
          var std = [];
          for (var i in val) {
            var soilLayers = [];

              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,
            for (var j in val2) {
              if (val2[j].exppointid == val[i].exppointid) {
                soilLayers.push(val2[j])
              }
              that.$store.state.propertiesFlag = "2"
            } else {
              that.$store.state.propertiesFlag = null
            }
          } else {
            that.$store.state.propertiesFlag = null
            var val1 = decr(val[i].geom)
            var wkt = this.$wkt.parse(val1)
            var coord = wkt.coordinates
            var alt = val[i].elev == null ? 0 : val[i].elev;
            std.push({
              bh: val[i].exppointid,
              X: coord[0],
              Y: coord[1],
              Z: alt,
              soilLayers: soilLayers
            })
          }

        }, Cesium.ScreenSpaceEventType.MOUSE_MOVE)

          this.setLayerByZFBH(std);
        }

      } else {
        var msg = row.exppointid + " 没勘探点地层表数据，无法生成柱状图"
        this.$message.error(msg);
        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;
        var alHeight  = p.Z;
        points.features.push(turf.point([parseFloat(p.X), parseFloat(p.Y)], { alt: alHeight }));
        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(alHeight)]);
              featurePoints1.push(...[parseFloat(p.X), parseFloat(p.Y), (parseFloat(alHeight) - parseFloat(obj.botdepth))]);
            } else {
              let obj_height = this.GetRealHeight(j, layers, alHeight);
              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 = {
@@ -597,7 +1352,6 @@
          this.$store.state.queryInfo.push(point)
          sgworld.Navigate.flyToObj(point)
          this.$store.state.primitLayer = point

          break
        case "LineString":
        case "MultiLineString":
@@ -645,6 +1399,7 @@
      this.setMapHandler()
    },
    setMapHandler() {
      var that = this;
      window.propertieshandler = new Cesium.ScreenSpaceEventHandler(
        sgworld.Viewer.scene.canvas
      )
@@ -656,6 +1411,13 @@
          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
@@ -669,14 +1431,41 @@
              }
            })
          })
          if (obj['更新时间']) {
            obj['更新时间'] = that.format(obj['更新时间'])
          }
          if (obj['创建时间']) {


            obj['创建时间'] = that.format(obj['创建时间'])
          }

          this.$store.state.propertiesInfo = obj
        }
      }, Cesium.ScreenSpaceEventType.LEFT_CLICK)
    },
    //格式化时间
    format(shijianchuo) {
      //shijianchuo是整数，否则要parseInt转换
      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 (propertieshandler != null && Cesium.defined(propertieshandler)) {
    if (window.propertieshandler != null && Cesium.defined(window.propertieshandler)) {
      window.propertieshandler.removeInputAction(
        Cesium.ScreenSpaceEventType.LEFT_CLICK
      )
@@ -711,7 +1500,7 @@
  }
  .bottomPage {
    position: absolute;
    bottom: 3%;
    bottom: 10px;
  }
  /deep/.el-form-item {
    margin-bottom: 0px;