<template>
|
<div class="analyseAir">
|
<!-- 头部-->
|
<div class="exTop">
|
<div class="cascader-demo">
|
<el-select v-model="value" clearable placeholder="请选择地区">
|
<el-option
|
v-for="item in options"
|
:key="item.value"
|
:label="item.label"
|
:value="item.value"
|
>
|
</el-option>
|
</el-select>
|
</div>
|
<el-date-picker
|
v-model="value3"
|
style="margin-right: 5%"
|
align="right"
|
type="date"
|
placeholder="选择日期"
|
>
|
</el-date-picker>
|
<el-upload
|
v-if="value === 'gx'"
|
class="upload-demo"
|
ref="upload1"
|
action=""
|
accept="xlsx"
|
:on-change="handleChange"
|
:on-remove="handleRemove"
|
:file-list="fileList"
|
: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" v-if="value === 'gx'">
|
上传四国控及市区均值
|
</div>
|
<div slot="tip" class="el-upload__tip" v-else></div>
|
</el-upload>
|
<el-upload
|
v-if="value === 'gx'"
|
class="upload-demo"
|
ref="upload2"
|
action=""
|
accept="xlsx"
|
:on-change="handleChange2"
|
:on-remove="handleRemove2"
|
:file-list="fileList2"
|
: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" v-if="value === 'gx'">
|
上传乡镇街道日数据
|
</div>
|
<div slot="tip" class="el-upload__tip" v-else></div>
|
</el-upload>
|
<el-upload
|
v-if="value === 'gx'"
|
class="upload-demo"
|
ref="upload3"
|
action=""
|
accept="xlsx"
|
:on-change="handleChange3"
|
:on-remove="handleRemove3"
|
:file-list="fileList3"
|
: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" v-if="value === 'gx'">
|
上传乡镇街道月累计
|
</div>
|
<div slot="tip" class="el-upload__tip" v-else></div>
|
</el-upload>
|
<el-upload
|
v-if="value === 'gx'"
|
class="upload-demo"
|
ref="upload4"
|
action=""
|
accept="xlsx"
|
:on-change="handleChange4"
|
:on-remove="handleRemove4"
|
:file-list="fileList4"
|
: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" v-if="value === 'gx'">
|
上传乡镇街道改善数据
|
</div>
|
<div slot="tip" class="el-upload__tip" v-else></div>
|
</el-upload>
|
<el-upload
|
v-if="value === 'gx'"
|
class="upload-demo"
|
ref="upload5"
|
action=""
|
accept="xlsx"
|
:on-change="handleChange5"
|
:on-remove="handleRemove5"
|
:file-list="fileList5"
|
: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" v-if="value === 'gx'">
|
上传国控改善数据
|
</div>
|
<div slot="tip" class="el-upload__tip" v-else></div>
|
</el-upload>
|
<el-upload
|
v-if="value === 'gx'"
|
class="upload-demo"
|
ref="upload6"
|
action=""
|
accept="xlsx"
|
:on-change="handleChange6"
|
:on-remove="handleRemove6"
|
:file-list="fileList6"
|
: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>
|
<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="upload8"
|
action=""
|
accept="xlsx"
|
:on-change="handleChange8"
|
:on-remove="handleRemove8"
|
:file-list="fileList8"
|
: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>-->
|
<!-- <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">
|
<el-card class="box-card" style="position: relative">
|
<div class="block" style="margin-bottom: 30px">
|
<el-date-picker
|
v-model="value2"
|
type="daterange"
|
align="right"
|
unlink-panels
|
range-separator="至"
|
start-placeholder="开始日期"
|
end-placeholder="结束日期"
|
:picker-options="pickerOptions"
|
>
|
</el-date-picker>
|
<el-select v-model="valueSelect" clearable placeholder="请选择地区">
|
<el-option
|
v-for="item in optionsSelect"
|
:key="item.valueSelect"
|
:label="item.label"
|
:value="item.valueSelect"
|
>
|
</el-option>
|
</el-select>
|
<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>
|
<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 {
|
fileList: [],
|
fileList2: [],
|
fileList3: [],
|
fileList4: [],
|
fileList5: [],
|
fileList6: [],
|
fileList7: [],
|
fileList8: [],
|
file1: null,
|
file2: null,
|
file3: null,
|
file4: null,
|
file5: null,
|
file6: null,
|
file7: null,
|
file8: null,
|
pickerOptions: {
|
shortcuts: [
|
{
|
text: '最近一周',
|
onClick(picker) {
|
const end = new Date()
|
const start = new Date()
|
start.setTime(start.getTime() - 3600 * 1000 * 24 * 7)
|
picker.$emit('pick', [start, end])
|
},
|
},
|
{
|
text: '最近一个月',
|
onClick(picker) {
|
const end = new Date()
|
const start = new Date()
|
start.setTime(start.getTime() - 3600 * 1000 * 24 * 30)
|
picker.$emit('pick', [start, end])
|
},
|
},
|
{
|
text: '最近三个月',
|
onClick(picker) {
|
const end = new Date()
|
const start = new Date()
|
start.setTime(start.getTime() - 3600 * 1000 * 24 * 90)
|
picker.$emit('pick', [start, end])
|
},
|
},
|
],
|
},
|
value2: [new Date(), new Date()], // 查询报告日期时间
|
value3: new Date(), // 提交文件的时间日期
|
options: [
|
{
|
value: 'hn',
|
label: '浑南区',
|
},
|
{
|
value: 'gx',
|
label: '高新区',
|
},
|
],
|
value: 'gx', // 地区
|
valueSelect: 'gx',
|
valueSelect2: 'hn',
|
optionsSelect: [
|
{
|
valueSelect: 'hn',
|
label: '浑南区',
|
},
|
{
|
valueSelect: 'gx',
|
label: '高新区',
|
},
|
],
|
tableData: [],
|
sensorTime: [], // 提交文件的日期
|
sensorTime2: [], // 查看报告的日期
|
formData2: [],
|
isInfo: false,
|
checkAll: false,
|
isIndeterminate: true,
|
dateArr: [], // 存储多选的日期
|
airData: {},
|
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.upload1.handleRemove(file)
|
this.$message.warning(`上传文件格式不符合`)
|
return
|
}
|
this.fileList = fileList
|
this.file1 = fileList[0]
|
},
|
handleRemove(file, fileList) {
|
this.fileList = fileList
|
this.file1 = fileList[0]
|
},
|
handleChange2(file, fileList) {
|
if (
|
file.raw.type !==
|
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
|
) {
|
this.$refs.upload2.handleRemove(file)
|
this.$message.warning(`上传文件格式不符合`)
|
return
|
}
|
this.fileList2 = fileList
|
this.file2 = fileList[0]
|
},
|
handleRemove2(file, fileList) {
|
this.fileList2 = fileList
|
this.file2 = fileList[0]
|
},
|
handleChange3(file, fileList) {
|
if (
|
file.raw.type !==
|
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
|
) {
|
this.$refs.upload3.handleRemove(file)
|
this.$message.warning(`上传文件格式不符合`)
|
return
|
}
|
this.fileList3 = fileList
|
this.file3 = fileList[0]
|
},
|
handleRemove3(file, fileList) {
|
this.fileList3 = fileList
|
this.file3 = fileList[0]
|
},
|
handleChange4(file, fileList) {
|
if (
|
file.raw.type !==
|
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
|
) {
|
this.$refs.upload4.handleRemove(file)
|
this.$message.warning(`上传文件格式不符合`)
|
return
|
}
|
this.fileList4 = fileList
|
this.file4 = fileList[0]
|
},
|
handleRemove4(file, fileList) {
|
this.fileList4 = fileList
|
this.file4 = fileList[0]
|
},
|
handleChange5(file, fileList) {
|
if (
|
file.raw.type !==
|
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
|
) {
|
this.$refs.upload5.handleRemove(file)
|
this.$message.warning(`上传文件格式不符合`)
|
return
|
}
|
this.fileList5 = fileList
|
this.file5 = fileList[0]
|
},
|
handleRemove5(file, fileList) {
|
this.fileList5 = fileList
|
this.file5 = fileList[0]
|
},
|
handleChange6(file, fileList) {
|
if (
|
file.raw.type !==
|
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' &&
|
file.raw.type !== 'application/vnd.ms-excel'
|
) {
|
this.$refs.upload6.handleRemove(file)
|
this.$message.warning(`上传文件格式不符合`)
|
return
|
}
|
this.fileList6 = fileList
|
this.file6 = fileList[0]
|
},
|
handleRemove6(file, fileList) {
|
this.fileList6 = fileList
|
this.file6 = fileList[0]
|
},
|
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
|
}
|
this.fileList7 = fileList
|
this.file7 = fileList[0]
|
},
|
handleRemove7(file, fileList) {
|
this.fileList7 = fileList
|
this.file7 = fileList[0]
|
},
|
handleExceed(files, fileList) {
|
this.$message.warning(
|
`当前限制选择 1 个文件，本次选择了 ${files.length} 个文件，共选择了 ${
|
files.length + fileList.length
|
} 个文件`
|
)
|
},
|
submitUpload() {
|
this.formData2 = []
|
if (!this.value3) {
|
this.$message({
|
message: '请选择时间',
|
type: 'warning',
|
})
|
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)
|
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.file1.raw)
|
formData.append(`files`, this.file2.raw)
|
formData.append(`files`, this.file3.raw)
|
formData.append(`files`, this.file4.raw)
|
formData.append(`files`, this.file5.raw)
|
formData.append(`files`, this.file6.raw)
|
// formData.append(`file7`, this.file7.raw)
|
// formData.append(`file8`, this.file8.raw)
|
// 后端上传接口
|
this.MultipartFile(formData)
|
.then((res) => {
|
if (res.code === 0) {
|
var reportInfo = res.data
|
this.value2 = [this.value3, this.value3]
|
reportInfo.name =
|
'高新区空气质量研判总结报告' +
|
reportInfo.time.split('-').join('')
|
this.tableData = [reportInfo]
|
}
|
})
|
.catch((err) => {
|
console.log(err)
|
})
|
} else {
|
this.$message({
|
message: '提交文件数量不符合',
|
type: 'warning',
|
})
|
}
|
},
|
// 提交浑南区表格数据
|
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)
|
var y = date.getFullYear()
|
var m = date.getMonth() + 1
|
m = m < 10 ? '0' + m : m
|
var d = date.getDate()
|
d = d < 10 ? '0' + d : d
|
return y + '-' + m + '-' + d
|
} else {
|
var arr = []
|
timeArr.map((v) => {
|
var date = new Date(v)
|
var y = date.getFullYear()
|
var m = date.getMonth() + 1
|
m = m < 10 ? '0' + m : m
|
var d = date.getDate()
|
d = d < 10 ? '0' + d : d
|
// var h = date.getHours()
|
// h = h < 10 ? '0' + h : h
|
// var minute = date.getMinutes()
|
// minute = minute < 10 ? '0' + minute : minute
|
// var s = date.getSeconds()
|
// s = s < 10 ? '0' + s : s
|
// arr.push(y + '-' + m + '-' + d + ' ' + h + ':' + minute + ':' + s)
|
arr.push(y + '-' + m + '-' + d)
|
})
|
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) {
|
// console.info('check all change is ', val)
|
this.isIndeterminate = false
|
this.tableData.forEach((item) => {
|
item.checked = val
|
this.dateArr.push(item.date)
|
})
|
if (val === false) {
|
this.dateArr = []
|
} else {
|
// console.log(this.dateArr, '全选')
|
this.dateArr = Array.from(new Set(this.dateArr))
|
}
|
},
|
// 选择
|
handleCheckOneChange(obj) {
|
// console.info('check one change is ', obj)
|
if (obj.checked === false) {
|
this.dateArr = this.dateArr.filter((v) => {
|
return v !== obj.date
|
})
|
} else {
|
this.dateArr.push(obj.date)
|
}
|
var totalCount = this.tableData.length
|
let someStatusCount = 0
|
this.tableData.forEach((item) => {
|
if (item.checked === obj.checked) {
|
someStatusCount++
|
}
|
})
|
this.count = someStatusCount
|
this.checkAll =
|
totalCount === someStatusCount ? obj.checked : !obj.checked
|
this.isIndeterminate = someStatusCount > 0 && someStatusCount < totalCount
|
},
|
// 高新区报告下载
|
expReport(obj) {
|
this.$request({
|
url: '/excel/excelExport',
|
method: 'get',
|
params: {
|
id: obj.id,
|
},
|
})
|
.then((res) => {
|
console.log(res, 'xia')
|
var getData = {}
|
getData = res.data
|
// 苏州市区放最后
|
getData.list1 = this.cityLast(getData.list1)
|
getData.list5 = this.cityLast(getData.list5)
|
// 高新区/国控站放最前边
|
getData.list2 = this.cityFirst2(getData.list2)
|
getData.list3 = this.cityFirst2(getData.list3)
|
getData.list4 = this.cityFirst(getData.list4)
|
this.airData = getData
|
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(
|
'/airQuality1.docx',
|
this.airData,
|
`${obj.name}.docx`
|
)
|
})
|
.catch((err) => {
|
console.log(err)
|
})
|
},
|
// 苏州市区放最后
|
cityLast(list) {
|
var obj = {}
|
list.map((v, i) => {
|
if (v.place === '苏州市区') {
|
obj = v
|
list.splice(i, 1)
|
}
|
})
|
if (obj.place) {
|
list.push(obj)
|
}
|
return list
|
},
|
// 高新区放最前边
|
cityFirst(list) {
|
var obj = {}
|
list.map((v, i) => {
|
if (v.place === '高新区') {
|
obj = v
|
list.splice(i, 1)
|
}
|
})
|
if (obj.place) {
|
list.unshift(obj)
|
}
|
return list
|
},
|
// 第二个和第三个表格是国控站/高新区
|
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/hnExcelExport',
|
method: 'get',
|
params: {
|
id: obj.id,
|
// id: 68
|
},
|
})
|
.then((res) => {
|
// 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)
|
})
|
},
|
// 浑南区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(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',
|
method: 'get',
|
params: {
|
startTime: this.sensorTime2[0],
|
endTime: this.sensorTime2[1],
|
code: this.valueSelect,
|
pageCount: page,
|
},
|
})
|
.then((res) => {
|
if (res.code === 0) {
|
var info = []
|
if (this.isDisplay) {
|
this.totalNumber = res.data.total
|
info = res.data.item
|
} else {
|
info = res.data
|
}
|
info.map((v) => {
|
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
|
}
|
})
|
.catch((err) => {
|
console.log(err)
|
})
|
},
|
},
|
}
|
</script>
|
|
<style scoped>
|
.analyseAir {
|
width: 100%;
|
height: 100%;
|
display: flex;
|
padding-top: 22px;
|
}
|
.exTop {
|
width: 30%;
|
/*height: 95%;*/
|
position: relative;
|
overflow: auto;
|
margin-bottom: 2%;
|
}
|
.cascader-demo {
|
float: left;
|
padding: 0% 2%;
|
}
|
.upload-demo {
|
margin-left: 2%;
|
/*float: left;*/
|
margin-top: 4%;
|
height: 65px;
|
}
|
.upload-demo /deep/ .el-upload-list__item {
|
font-size: 15px;
|
}
|
.upload-demo /deep/ .el-upload-list__item:first-child {
|
margin-top: 2px;
|
}
|
.exDown {
|
width: 50%;
|
height: 95%;
|
margin-left: 2%;
|
font-size: 18px;
|
}
|
.exDown /deep/ .el-card {
|
width: 100%;
|
height: 100%;
|
}
|
.divPadding {
|
width: 80%;
|
margin: auto;
|
}
|
.textCenter {
|
text-align: center;
|
}
|
.fontS14 {
|
font-size: 14px;
|
}
|
.upload-demo button {
|
margin-right: 10%;
|
}
|
.upload-demo /deep/ .el-upload {
|
margin-right: 10%;
|
}
|
.selectBtn {
|
margin-left: 5%;
|
}
|
.el-card /deep/ .el-card__body {
|
height: 815px;
|
}
|
.paginationDemo {
|
position: absolute;
|
left: 0;
|
bottom: 3%;
|
}
|
.el-upload__tip {
|
color: red;
|
}
|
</style>
|
