1、尘负荷走航路段多个时间添加

yichenxi

2022-12-16 d16162b2c87381fab991e288f34b52a956a6456c

 src/views/air/index.vue

@@ -13,7 +13,6 @@
        </el-select>
      </div>
      <el-date-picker
          v-if="value==='gx'"
          v-model="value3"
          style="margin-right: 5%"
          align="right"
@@ -34,7 +33,8 @@
          multiple
          :auto-upload="false">
        <el-button slot="trigger" type="primary" size="small">选取文件</el-button>
        <div slot="tip" class="el-upload__tip">上传四国控及市区均值</div>
        <div slot="tip" class="el-upload__tip" v-if="value==='gx'">上传四国控及市区均值</div>
        <div slot="tip" class="el-upload__tip" v-else></div>
      </el-upload>
      <el-upload
          v-if="value==='gx'"
@@ -50,7 +50,8 @@
          multiple
          :auto-upload="false">
        <el-button slot="trigger" type="primary" size="small">选取文件</el-button>
        <div slot="tip" class="el-upload__tip">上传乡镇街道日数据</div>
        <div slot="tip" class="el-upload__tip" v-if="value==='gx'">上传乡镇街道日数据</div>
        <div slot="tip" class="el-upload__tip" v-else></div>
      </el-upload>
      <el-upload
          v-if="value==='gx'"
@@ -66,7 +67,8 @@
          multiple
          :auto-upload="false">
        <el-button slot="trigger" type="primary" size="small">选取文件</el-button>
        <div slot="tip" class="el-upload__tip">上传乡镇街道月累计</div>
        <div slot="tip" class="el-upload__tip" v-if="value==='gx'">上传乡镇街道月累计</div>
        <div slot="tip" class="el-upload__tip" v-else></div>
      </el-upload>
      <el-upload
          v-if="value==='gx'"
@@ -82,7 +84,8 @@
          multiple
          :auto-upload="false">
        <el-button slot="trigger" type="primary" size="small">选取文件</el-button>
        <div slot="tip" class="el-upload__tip">上传乡镇街道改善数据</div>
        <div slot="tip" class="el-upload__tip" v-if="value==='gx'">上传乡镇街道改善数据</div>
        <div slot="tip" class="el-upload__tip" v-else></div>
      </el-upload>
      <el-upload
          v-if="value==='gx'"
@@ -98,7 +101,8 @@
          multiple
          :auto-upload="false">
        <el-button slot="trigger" type="primary" size="small">选取文件</el-button>
        <div slot="tip" class="el-upload__tip">上传国控改善数据</div>
        <div slot="tip" class="el-upload__tip" v-if="value==='gx'">上传国控改善数据</div>
        <div slot="tip" class="el-upload__tip" v-else></div>
      </el-upload>
      <el-upload
          v-if="value==='gx'"
@@ -116,23 +120,25 @@
        <el-button slot="trigger" type="primary" size="small">选取文件</el-button>
        <div slot="tip" class="el-upload__tip">上传餐饮油烟超标数据</div>
      </el-upload>
      <div v-if="value==='hn'" style="position: relative">
        <el-upload
            class="upload-demo"
            ref="upload7"
            action=""
            accept="xlsx"
            :on-change="handleChange7"
            :on-remove="handleRemove7"
            :file-list="fileList7"
            :limit="1"
            :on-exceed="handleExceed"
            multiple
            :auto-upload="false">
          <el-button slot="trigger" type="primary" size="small">选取文件</el-button>
          <div slot="tip" class="el-upload__tip">请上传国控点位日污染物浓度及AQI文件</div>
        </el-upload>
        <el-button type="success" @click="submitUpload" :disabled="idDisabled" size="small" style="position: absolute;right: 20%;bottom: -100%">提交文件</el-button>
      </div>
<!--      <el-upload
          v-if="value==='gx'"
          class="upload-demo"
          ref="upload7"
          action=""
          accept="xlsx"
          :on-change="handleChange7"
          :on-remove="handleRemove7"
          :file-list="fileList7"
          :limit="1"
          :on-exceed="handleExceed"
          multiple
          :auto-upload="false">
        <el-button slot="trigger" type="primary" size="small">选取文件</el-button>
        <div slot="tip" class="el-upload__tip">上传数据</div>
      </el-upload>
      <el-upload
          v-if="value==='gx'"
          class="upload-demo"
          ref="upload8"
@@ -148,12 +154,12 @@
        <el-button slot="trigger" type="primary" size="small">选取文件</el-button>
        <div slot="tip" class="el-upload__tip">上传数据</div>
      </el-upload>-->
      <div style="position: absolute; bottom: 2%; right: 20%" v-if="value==='gx'">
        <el-button type="success" @click="submitUpload" size="small">提交文件</el-button>
<!--        <el-button type="primary" @click="exportReport" size="small">下载报告</el-button>-->
<!--      <div style="position: absolute; bottom: 2%; right: 20%">-->
      <div style="position: absolute; right: 20%;padding-top: 20px;">
        <el-button v-if="value==='gx'" type="success" @click="submitUpload" size="small">提交文件</el-button>
      </div>
    </div>
    <div class="exDown" v-if="value==='gx'">
    <div class="exDown">
      <el-card class="box-card" style="position: relative">
        <div class="block" style="margin-bottom: 30px;">
          <el-date-picker
@@ -174,60 +180,72 @@
                :value="item.valueSelect">
            </el-option>
          </el-select>
          <el-button type="primary" @click="selectReport" size="small" class="selectBtn">查询</el-button>
          <el-button type="primary" @click="selectReport(1)" size="small" class="selectBtn">查询</el-button>
<!--          <el-button type="primary" @click="selectReport" size="small" class="selectBtn">下载多个</el-button>-->
        </div>
        <el-table
            :data="tableData"
            style="width: 100%">
<!--          <el-table-column
          width="100"
          align="center">
            <template slot="header">
              <el-checkbox
                  :indeterminate="isIndeterminate"
                  v-model="checkAll"
                  @change="handleCheckAllChange">全选</el-checkbox>
            </template>
            <template slot-scope="scope">
              <el-checkbox
                  v-model="scope.row.checked"
                  @change="handleCheckOneChange(scope.row)"></el-checkbox>
            </template>
          </el-table-column>-->
          <el-table-column
              prop="name"
              label="报告名称"
             >
          </el-table-column>
          <el-table-column
              prop="time"
              label="提交时间"
           >
          </el-table-column>
          <el-table-column
              prop="date"
              label="创建时间"
          >
          </el-table-column>
          <el-table-column label="操作">
            <template slot-scope="scope">
              <el-button type="text" size="medium" @click="expReport(scope.row)">下载</el-button>
            </template>
          </el-table-column>
        </el-table>
<!--        <el-pagination
            class="paginationDemo"
            background
            layout="prev, pager, next"
            :total="100">
        </el-pagination>-->
        <div style="overflow-y: auto; height: 82%;margin-bottom: 2%;">
          <el-table
              :data="tableData"
              style="width: 100%">
            <!--          <el-table-column
                      width="100"
                      align="center">
                        <template slot="header">
                          <el-checkbox
                              :indeterminate="isIndeterminate"
                              v-model="checkAll"
                              @change="handleCheckAllChange">全选</el-checkbox>
                        </template>
                        <template slot-scope="scope">
                          <el-checkbox
                              v-model="scope.row.checked"
                              @change="handleCheckOneChange(scope.row)"></el-checkbox>
                        </template>
                      </el-table-column>-->
            <el-table-column
                prop="name"
                label="报告名称"
            >
            </el-table-column>
            <el-table-column
                prop="time"
                label="提交时间"
            >
            </el-table-column>
            <el-table-column
                prop="date"
                label="创建时间"
            >
            </el-table-column>
            <el-table-column label="操作">
              <template slot-scope="scope">
                <el-button type="text" size="medium" v-if="valueSelect==='gx'" @click="expReport(scope.row)">下载</el-button>
                <!--导出excel-->
                <img src="../../assets/icon/hn_excel.png" alt="蓝天计划excel" v-if="valueSelect==='hn'" @click="hnExcel(scope.row)" style="margin-left:0; cursor:pointer;">
                <!--导出word -->
                              <img src="../../assets/icon/hn_word.png" alt="浑南区环境空气质量报告" v-if="valueSelect==='hn'" @click="hnExpReport(scope.row)" style="cursor:pointer;">
              </template>
            </el-table-column>
          </el-table>
        </div>
        <div class="block" v-if="isDisplay">
          <el-pagination
              background
              @size-change="handleSizeChange"
              @current-change="handleCurrentChange"
              :current-page.sync="currentPage3"
              :page-size="onePageCount"
              layout="total, prev, pager, next, jumper"
              :total="totalNumber">
          </el-pagination>
        </div>
      </el-card>
    </div>
  </div>
</template>
<script>
import { ExportBriefDataDocx } from '@/utils/exportBriefDataDocx'
import { ExportHunnanExcel } from '@/utils/ExportHunnanExcel'
export default {
  data() {
    return {
@@ -278,8 +296,8 @@
      value3: new Date(), // 提交文件的时间日期
      options: [
        {
          value: 'sy',
          label: '沈阳'
          value: 'hn',
          label: '浑南区'
        }, {
          value: 'gx',
          label: '高新区'
@@ -287,10 +305,11 @@
      ],
      value: 'gx', // 地区
      valueSelect: 'gx',
      valueSelect2: 'hn',
      optionsSelect: [
        {
          valueSelect: 'sy',
          label: '沈阳'
          valueSelect: 'hn',
          label: '浑南区'
        }, {
          valueSelect: 'gx',
          label: '高新区'
@@ -305,13 +324,39 @@
      isIndeterminate: true,
      dateArr: [], // 存储多选的日期
      airData: {},
      reportInfo: {}
      reportInfo: {},
      hunNanAirData: [], // 浑南区word报告数据
      hnexcelID: '',
      idDisabled: false,
      currentPage3: 1, // 前往第几页
      totalNumber: 0, // 总条数
      onePageCount: 8, // 一页多少条
      isDisplay: false // 是否显示分页
    }
  },
  watch: {
    value(newName, oldName) {
      this.valueSelect = newName
      this.tableData = []
      this.value2 = [new Date(), new Date()]
    },
    valueSelect(newName, oldName) {
      this.tableData = []
    }
  },
  methods: {
    // 分页
    handleSizeChange(val) {
      console.log(`每页 ${val} 条`)
    },
    handleCurrentChange(val) {
      console.log(`当前页: ${val}`)
      this.selectReport(val)
    },
    // 上传
    handleChange(file, fileList) {
      if (file.raw.type !== 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet') {
        this.$refs.upload.handleRemove(file)
        this.$refs.upload1.handleRemove(file)
        this.$message.warning(`上传文件格式不符合`)
        return
      }
@@ -387,8 +432,8 @@
      this.fileList6 = fileList
      this.file6 = fileList[0]
    },
    /* handleChange7(file, fileList) {
      if (file.raw.type !== 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet') {
    handleChange7(file, fileList) {
      if (file.raw.type !== 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' && file.raw.type !== 'application/vnd.ms-excel') {
        this.$refs.upload7.handleRemove(file)
        this.$message.warning(`上传文件格式不符合`)
        return
@@ -400,25 +445,11 @@
      this.fileList7 = fileList
      this.file7 = fileList[0]
    },
    handleChange8(file, fileList) {
      if (file.raw.type !== 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet') {
        this.$refs.upload8.handleRemove(file)
        this.$message.warning(`上传文件格式不符合`)
        return
      }
      this.fileList8 = fileList
      this.file8 = fileList[0]
    },
    handleRemove8(file, fileList) {
      this.fileList8 = fileList
      this.file8 = fileList[0]
    },*/
    handleExceed(files, fileList) {
      this.$message.warning(`当前限制选择 1 个文件，本次选择了 ${files.length} 个文件，共选择了 ${files.length + fileList.length} 个文件`)
    },
    submitUpload() {
      this.formData2 = []

      if (!this.value3) {
        this.$message({
          message: '请选择时间',
@@ -426,6 +457,14 @@
        })
        return
      }
      if (this.value === 'gx') { // 高新区表格导入
        this.gxSubmit()
      } else { // 浑南区表格导入
        this.hnSubmit()
      }
    },
    // 提交高新区表格数据
    gxSubmit() {
      if (this.file1 && this.file2 && this.file3 && this.file4 && this.file5 && this.file6) {
        const formData = new FormData()
        formData.append(`code`, this.value)
@@ -447,7 +486,7 @@
          if (res.code === 0) {
            var reportInfo = res.data
            this.value2 = [this.value3, this.value3]
            reportInfo.name = '高新区空气质量分析报告' + reportInfo.time.split('-').join('')
            reportInfo.name = '高新区空气质量研判总结报告' + reportInfo.time.split('-').join('')
            this.tableData = [reportInfo]
          }
        }).catch(err => {
@@ -460,16 +499,62 @@
        })
      }
    },
    // 后端上传接口
    MultipartFile(data) {
      return this.$request({
        url: '/excel/excelImport',
        method: 'post',
        headers: { 'Content-Type': 'multipart/form-data' }, // 多文件上传这一句必须加
        data
      })
    // 提交浑南区表格数据
    hnSubmit() {
      if (this.file7) {
        const formData = new FormData()
        formData.append(`code`, this.value)
        this.sensorTime = this.newTime(this.value3, 'submit')
        var date = new Date()
        date = this.newTime(date, 'submit')
        formData.append(`time`, this.sensorTime)
        formData.append(`date`, date)
        formData.append(`files`, this.file7.raw)
        // 后端上传接口
        this.MultipartFile(formData).then(res => {
          this.idDisabled = false
          if (res.code === 0) {
            this.$message({
              message: '提交成功！',
              type: 'success'
            })
            var reportInfo = res.data
            this.value2 = [this.value3, this.value3]
            reportInfo.name = '浑南区报告' + reportInfo.time.split('-').join('')
            this.tableData = [reportInfo]
          } else {
            this.$message.error('提交失败！')
          }
        }).catch(err => {
          console.log(err)
        })
      } else {
        this.$message({
          message: '提交文件数量不符合',
          type: 'warning'
        })
      }
    },
    // 时间处理函数
    // 文件上传接口
    MultipartFile(data) {
      this.idDisabled = true
      if (this.value === 'gx') {
        return this.$request({
          url: '/excel/excelImport',
          method: 'post',
          headers: { 'Content-Type': 'multipart/form-data' }, // 多文件上传这一句必须加
          data
        })
      } else {
        return this.$request({
          url: '/excel/syExcelImport',
          method: 'post',
          headers: { 'Content-Type': 'multipart/form-data' }, // 多文件上传这一句必须加
          data
        })
      }
    },
    // 时间处理函数（日期带0）
    newTime(timeArr, name) {
      if (name === 'submit') {
        var date = new Date(timeArr)
@@ -499,6 +584,14 @@
        })
        return arr
      }
    },
    // 时间处理函数（日期不包括0）
    newTimeNotZero(time) {
      var date = new Date(time)
      var y = date.getFullYear()
      var m = date.getMonth() + 1
      var d = date.getDate()
      return y + '-' + m + '-' + d
    },
    // 全选
    handleCheckAllChange(val) {
@@ -536,7 +629,7 @@
      this.checkAll = totalCount === someStatusCount ? obj.checked : !obj.checked
      this.isIndeterminate = someStatusCount > 0 && someStatusCount < totalCount
    },
    // 下载
    // 高新区报告下载
    expReport(obj) {
      this.$request({
        url: '/excel/excelExport',
@@ -550,15 +643,46 @@
        // 苏州市区放最后
        getData.list1 = this.cityLast(getData.list1)
        getData.list5 = this.cityLast(getData.list5)
        // 高新区放最前边
        getData.list2 = this.cityFirst(getData.list2)
        getData.list3 = this.cityFirst(getData.list3)
        // 高新区/国控站放最前边
        getData.list2 = this.cityFirst2(getData.list2)
        getData.list3 = this.cityFirst2(getData.list3)
        getData.list4 = this.cityFirst(getData.list4)
        this.airData = getData
        this.airData.month = res.data.time.split('月')[0]
        this.airData.day = res.data.time.split('月')[1].split('日')[0]
        var arr = obj.time.split('-')
        var monthZero = res.data.time.split('月')[0]
        if (monthZero.substr(0, 1) === '0') {
          this.airData.month = monthZero.substr(1)
        } else {
          this.airData.month = res.data.time.split('月')[0]
        }
        var dayZero = res.data.time.split('月')[1].split('日')[0]
        if (dayZero.substr(0, 1) === '0') {
          this.airData.day = dayZero.substr(1)
        } else {
          this.airData.day = dayZero
        }
        var arr = obj.date.split('-')
        if (arr[2].substr(0, 1) === '0') {
          arr[2] = arr[2].substr(1)
        }
        if (arr[1].substr(0, 1) === '0') {
          arr[1] = arr[1].substr(1)
        }
        this.airData.currentTime = arr[0] + '年' + arr[1] + '月' + arr[2] + '日'
        this.airData.currentYear = arr[0]
        var time1DayZero = ''
        var time1MonthZero = ''
        if (res.data.time1.split('年')[1].split('月')[0].substr(0, 1) === '0') {
          time1MonthZero = res.data.time1.split('年')[1].split('月')[0].substr(1)
        } else {
          time1MonthZero = res.data.time1.split('年')[1].split('月')[0]
        }

        if (res.data.time1.split('月')[1].split('日')[0].substr(0, 1) === '0') {
          time1DayZero = res.data.time1.split('月')[1].split('日')[0].substr(1)
        } else {
          time1DayZero = res.data.time1.split('月')[1].split('日')[0]
        }
        this.airData.time1 = res.data.time1.split('年')[0] + '年' + time1MonthZero + '月' + time1DayZero + '日'
        ExportBriefDataDocx('/airQuality.docx', this.airData, `${obj.name}.docx`)
      }).catch(err => {
        console.log(err)
@@ -573,7 +697,9 @@
          list.splice(i, 1)
        }
      })
      list.push(obj)
      if (obj.place) {
        list.push(obj)
      }
      return list
    },
    // 高新区放最前边
@@ -585,53 +711,126 @@
          list.splice(i, 1)
        }
      })
      list.unshift(obj)
      if (obj.place) {
        list.unshift(obj)
      }
      return list
    },
    // 导出报告
    exportReport() {
      // ExportBriefDataDocx('/airQuality.docx', this.airData, `空气质量报告.docx`)
    // 第二个和第三个表格是国控站/高新区
    cityFirst2(list) {
      var obj = {}
      list.map((v, i) => {
        if (v.place === '国控站') {
          obj = v
          list.splice(i, 1)
        }
        if (v.place === '高新区') {
          obj = v
          list.splice(i, 1)
        }
      })
      if (obj.place) {
        list.unshift(obj)
      }
      return list
    },
    // 浑南区报告下载
    hnExpReport(obj) {
      this.$request({
        url: '/excel/excelExport',
        url: '/excel/hnExcelExport',
        method: 'get',
        params: {
          id: 23
          id: obj.id
          // id: 68
        }
      }).then(res => {
        console.log(res)
        this.airData = res.data
        this.airData.month = res.data.time.split('月')[0]
        this.airData.day = res.data.time.split('月')[1].split('日')[0]
        ExportBriefDataDocx('/airQuality.docx', this.airData, `空气质量报告.docx`)
        // console.log(res)
        this.hunNanAirData = res.data
        // currentTime时间
        var arr = res.data.time2.split('-')
        var currentTime = arr[0] + '年' + arr[1] + '月' + arr[2] + '日'
        var currentYear = arr[0]
        this.hunNanAirData.currentTime = currentTime
        this.hunNanAirData.currentYear = currentYear
        // 对后端传来的09月26日,yearDate进行分割
        var month = res.data.time.split('-')[0]
        if (month.substr(0, 1) === '0') {
          month = month.substr(1)
        }
        this.hunNanAirData.month = month
        var day = res.data.time.split('-')[1]
        if (day.substr(0, 1) === '0') {
          day = day.substr(1)
        }
        this.hunNanAirData.day = day
        ExportBriefDataDocx('/hunnan.docx', this.hunNanAirData, `浑南区${arr[1]}月${arr[2]}日环境空气质量报告.docx`)
      }).catch(err => {
        console.log(err)
      })

      // if (this.isInfo) {
      //   // ExportBriefDataDocx('/airQ.docx', this.airData, `空气质量报告.docx`)
      // } else {
      //   this.$message({
      //     message: '请先提交文件',
      //     type: 'warning'
      //   })
      // }
    },
    // 浑南区excel下载
    hnExcel(obj) {
      this.$request({
        url: '/excel/syExcelExport',
        method: 'get',
        params: {
          id: obj.id
        }
      }).then(res => {
        var code2 = res.data.code2.substr(0, 2) + '\n' + res.data.code2.substr(2)
        var code4 = res.data.code4.substr(0, 2) + '\n' + res.data.code4.substr(2)
        var table1Data = [['', '目标值', '进度', '进度', '同比'], ['', '', '', '', ''], ['优良天', '300', res.data.code1, '', code2], ['', '', '', '', ''], ['PM2.5', '41', res.data.code3, '', code4], ['', '', '', '', '']]
        var table3Data = [['', '目标值', '目标值', '进度', '进度'], ['', '目标值', '目标值', '进度', '进度'], ['优良天', '69', '69', res.data.code5, ''], ['', '', '', '', ''], ['PM2.5', '40', '40', res.data.code6, ''], ['', '', '', '', '']]
        var table2Data = [
          res.data.list.sy1,
          res.data.list.sy2,
          res.data.list.hnd1,
          res.data.list.hnd2,
          res.data.list.xxj1,
          res.data.list.xxj2,
          res.data.list.hnq1,
          res.data.list.hnq2
        ]
        var data = new Date()
        var currentYearData = data.getFullYear()
        var jd = res.data.season
        ExportHunnanExcel(`蓝天计划挂图作战${obj.time.split('-').join('')}`, table1Data, table3Data, table2Data, currentYearData, jd)
      }).catch(err => {
        console.log(err)
      })
    },
    // 查询报告
    selectReport() {
    selectReport(val) {
      var page = val
      if (this.isDisplay === false) {
        page = 0
      }
      this.sensorTime2 = this.newTime(this.value2, 'select')
      this.$request({
        url: '/excel/selectExcel',
        // url: '/excel/selectExcel',
        url: 'excel/selectExcel',
        method: 'get',
        params: {
          startTime: this.sensorTime2[0],
          endTime: this.sensorTime2[1],
          code: this.valueSelect
          code: this.valueSelect,
          pageCount: page
        }
      }).then(res => {
        if (res.code === 0) {
          var info = res.data
          var info = []
          if (this.isDisplay) {
            this.totalNumber = res.data.total
            info = res.data.item
          } else {
            info = res.data
          }
          info.map(v => {
            v.name = '高新区空气质量分析报告' + v.time.split('-').join('')
            if (this.valueSelect === 'gx') {
              v.name = '高新区空气质量分析报告' + v.time.split('-').join('')
            } else {
              v.name = '浑南区报告' + v.time.split('-').join('')
            }
          })
          info.sort((a, b) => { return b.time.split('-').join('') - a.time.split('-').join('') })
          this.tableData = info
@@ -653,8 +852,10 @@
}
  .exTop{
    width: 30%;
    height: 95%;
    /*height: 95%;*/
    position: relative;
    overflow: auto;
    margin-bottom: 2%;
  }
  .cascader-demo{
    float: left;