diff --git a/src/api/data/data.js b/src/api/data/data.js index 7dcc6c7..9d23a3e 100644 --- a/src/api/data/data.js +++ b/src/api/data/data.js @@ -13,7 +13,7 @@ // 井盖数据查询 export function getWellData(params) { return request({ - url: 'welldata/list', + url: 'welldata/list-page', method: 'get', params }) @@ -40,6 +40,15 @@ // 液位数据查询 export function getLiquidData(params) { return request({ + url: 'liquiddata/list-page', + method: 'get', + params + }) +} + +// 液位数据查询-不分页 +export function getLiquidDataSingle(params) { + return request({ url: 'liquiddata/list', method: 'get', params @@ -60,6 +69,14 @@ // 燃气数据查询 export function getGasData(params) { return request({ + url: 'gasdata/list-page', + method: 'get', + params + }) +} +// 燃气数据查询-不分页 +export function getGasDataSingle(params) { + return request({ url: 'gasdata/list', method: 'get', params @@ -85,6 +102,16 @@ params }) } + +// 管盯数据查询-不分页 +export function getTubeDataSingle(params) { + return request({ + url: 'tubedata/list', + method: 'get', + params + }) +} + // 批量导出管盯数据 export function batchExportTubeData(params) { return request({ @@ -98,11 +125,21 @@ // 开挖数据查询 export function getDigData(params) { return request({ + url: 'digdata/list-page', + method: 'get', + params + }) +} + +// 开挖数据查询,不分页 +export function getDigDataSingle(params) { + return request({ url: 'digdata/list', method: 'get', params }) } + // 批量导出开挖数据 export function batchExportDigData(params) { return request({ @@ -116,11 +153,20 @@ // 有害气体数据查询 export function getHarmfulData(params) { return request({ + url: 'harmfuldata/list-page', + method: 'get', + params + }) +} +// 有害气体数据查询,不分页 +export function getHarmfulDataSingle(params) { + return request({ url: 'harmfuldata/list', method: 'get', params }) } + // 批量导出有害气体数据 export function batchExportHarmfulData(params) { return request({ @@ -134,6 +180,14 @@ // 温湿度数据查询 export function getTempData(params) { return request({ + url: 'tempdata/list-page', + method: 'get', + params + }) +} +// 温湿度数据查询,不分页 +export function getTempDataSimple(params) { + return request({ url: 'tempdata/list', method: 'get', params @@ -153,6 +207,14 @@ // 井盖定位监测仪数据查询 export function getWellLocaData(params) { return request({ + url: 'welllocadata/list-page', + method: 'get', + params + }) +} +// 井盖定位监测仪数据查询,不分页 +export function getWellLocaDataSingle(params) { + return request({ url: 'welllocadata/list', method: 'get', params @@ -172,6 +234,14 @@ // 噪声记录仪数据查询 export function getNoiseData(params) { return request({ + url: 'noisedata/list-page', + method: 'get', + params + }) +} +// 噪声记录仪数据查询,不分页 +export function getNoiseDataSingle(params) { + return request({ url: 'noisedata/list', method: 'get', params @@ -190,6 +260,14 @@ // 液位燃气一体化设备数据查询 export function getLiquidGasData(params) { return request({ + url: 'liquidGasData/list-page', + method: 'get', + params + }) +} +// 液位燃气一体化设备数据查询,不分页 +export function getLiquidGasDataSingle(params) { + return request({ url: 'liquidGasData/list', method: 'get', params @@ -209,7 +287,15 @@ // 可燃气体外协数据查询 export function getGasdectorData(params) { return request({ - url: '/gasdector/listpage', + url: '/gasdector/list-page', + method: 'get', + params + }) +} +// 可燃气体外协数据查询,不分页 +export function getGasdectorDataSingle(params) { + return request({ + url: '/gasdector/list', method: 'get', params }) @@ -228,7 +314,15 @@ // 激甲云台数据查询-章丘 export function getPantiltData(params) { return request({ - url: '/pantilt/listpage', + url: '/pantilt/list-page', + method: 'get', + params + }) +} +// 激甲云台数据查询-章丘 +export function getPantiltDataSingle(params) { + return request({ + url: '/pantilt/list', method: 'get', params }) @@ -248,6 +342,14 @@ // 消防栓数据查询 export function getHydrantData(params) { return request({ + url: 'hydrant/list-page', + method: 'get', + params + }) +} +// 消防栓数据查询,不分页 +export function getHydrantDataSingle(params) { + return request({ url: 'hydrant/list', method: 'get', params diff --git a/src/api/data/data.js b/src/api/data/data.js index 7dcc6c7..9d23a3e 100644 --- a/src/api/data/data.js +++ b/src/api/data/data.js @@ -13,7 +13,7 @@ // 井盖数据查询 export function getWellData(params) { return request({ - url: 'welldata/list', + url: 'welldata/list-page', method: 'get', params }) @@ -40,6 +40,15 @@ // 液位数据查询 export function getLiquidData(params) { return request({ + url: 'liquiddata/list-page', + method: 'get', + params + }) +} + +// 液位数据查询-不分页 +export function getLiquidDataSingle(params) { + return request({ url: 'liquiddata/list', method: 'get', params @@ -60,6 +69,14 @@ // 燃气数据查询 export function getGasData(params) { return request({ + url: 'gasdata/list-page', + method: 'get', + params + }) +} +// 燃气数据查询-不分页 +export function getGasDataSingle(params) { + return request({ url: 'gasdata/list', method: 'get', params @@ -85,6 +102,16 @@ params }) } + +// 管盯数据查询-不分页 +export function getTubeDataSingle(params) { + return request({ + url: 'tubedata/list', + method: 'get', + params + }) +} + // 批量导出管盯数据 export function batchExportTubeData(params) { return request({ @@ -98,11 +125,21 @@ // 开挖数据查询 export function getDigData(params) { return request({ + url: 'digdata/list-page', + method: 'get', + params + }) +} + +// 开挖数据查询,不分页 +export function getDigDataSingle(params) { + return request({ url: 'digdata/list', method: 'get', params }) } + // 批量导出开挖数据 export function batchExportDigData(params) { return request({ @@ -116,11 +153,20 @@ // 有害气体数据查询 export function getHarmfulData(params) { return request({ + url: 'harmfuldata/list-page', + method: 'get', + params + }) +} +// 有害气体数据查询,不分页 +export function getHarmfulDataSingle(params) { + return request({ url: 'harmfuldata/list', method: 'get', params }) } + // 批量导出有害气体数据 export function batchExportHarmfulData(params) { return request({ @@ -134,6 +180,14 @@ // 温湿度数据查询 export function getTempData(params) { return request({ + url: 'tempdata/list-page', + method: 'get', + params + }) +} +// 温湿度数据查询,不分页 +export function getTempDataSimple(params) { + return request({ url: 'tempdata/list', method: 'get', params @@ -153,6 +207,14 @@ // 井盖定位监测仪数据查询 export function getWellLocaData(params) { return request({ + url: 'welllocadata/list-page', + method: 'get', + params + }) +} +// 井盖定位监测仪数据查询,不分页 +export function getWellLocaDataSingle(params) { + return request({ url: 'welllocadata/list', method: 'get', params @@ -172,6 +234,14 @@ // 噪声记录仪数据查询 export function getNoiseData(params) { return request({ + url: 'noisedata/list-page', + method: 'get', + params + }) +} +// 噪声记录仪数据查询,不分页 +export function getNoiseDataSingle(params) { + return request({ url: 'noisedata/list', method: 'get', params @@ -190,6 +260,14 @@ // 液位燃气一体化设备数据查询 export function getLiquidGasData(params) { return request({ + url: 'liquidGasData/list-page', + method: 'get', + params + }) +} +// 液位燃气一体化设备数据查询,不分页 +export function getLiquidGasDataSingle(params) { + return request({ url: 'liquidGasData/list', method: 'get', params @@ -209,7 +287,15 @@ // 可燃气体外协数据查询 export function getGasdectorData(params) { return request({ - url: '/gasdector/listpage', + url: '/gasdector/list-page', + method: 'get', + params + }) +} +// 可燃气体外协数据查询,不分页 +export function getGasdectorDataSingle(params) { + return request({ + url: '/gasdector/list', method: 'get', params }) @@ -228,7 +314,15 @@ // 激甲云台数据查询-章丘 export function getPantiltData(params) { return request({ - url: '/pantilt/listpage', + url: '/pantilt/list-page', + method: 'get', + params + }) +} +// 激甲云台数据查询-章丘 +export function getPantiltDataSingle(params) { + return request({ + url: '/pantilt/list', method: 'get', params }) @@ -248,6 +342,14 @@ // 消防栓数据查询 export function getHydrantData(params) { return request({ + url: 'hydrant/list-page', + method: 'get', + params + }) +} +// 消防栓数据查询,不分页 +export function getHydrantDataSingle(params) { + return request({ url: 'hydrant/list', method: 'get', params diff --git a/src/api/data/dataStatics.js b/src/api/data/dataStatics.js index e79dea3..d6b7a72 100644 --- a/src/api/data/dataStatics.js +++ b/src/api/data/dataStatics.js @@ -90,6 +90,15 @@ }) } +// 统计某段时间每种类型的报警数 +export function alarmStaticByContent(params) { + return request({ + url: 'statics/alarmStaticsByContent', + method: 'get', + params + }) +} + // 根据权属单位进行报警统计查询 export function alarmStaticByDept(params) { return request({ @@ -108,3 +117,12 @@ }) } +// 获取数据总数 +export function dataCount(params) { + return request({ + url: '/dataStatics/upLoadCountByTime', + method: 'get', + params + }) +} + diff --git a/src/api/data/data.js b/src/api/data/data.js index 7dcc6c7..9d23a3e 100644 --- a/src/api/data/data.js +++ b/src/api/data/data.js @@ -13,7 +13,7 @@ // 井盖数据查询 export function getWellData(params) { return request({ - url: 'welldata/list', + url: 'welldata/list-page', method: 'get', params }) @@ -40,6 +40,15 @@ // 液位数据查询 export function getLiquidData(params) { return request({ + url: 'liquiddata/list-page', + method: 'get', + params + }) +} + +// 液位数据查询-不分页 +export function getLiquidDataSingle(params) { + return request({ url: 'liquiddata/list', method: 'get', params @@ -60,6 +69,14 @@ // 燃气数据查询 export function getGasData(params) { return request({ + url: 'gasdata/list-page', + method: 'get', + params + }) +} +// 燃气数据查询-不分页 +export function getGasDataSingle(params) { + return request({ url: 'gasdata/list', method: 'get', params @@ -85,6 +102,16 @@ params }) } + +// 管盯数据查询-不分页 +export function getTubeDataSingle(params) { + return request({ + url: 'tubedata/list', + method: 'get', + params + }) +} + // 批量导出管盯数据 export function batchExportTubeData(params) { return request({ @@ -98,11 +125,21 @@ // 开挖数据查询 export function getDigData(params) { return request({ + url: 'digdata/list-page', + method: 'get', + params + }) +} + +// 开挖数据查询,不分页 +export function getDigDataSingle(params) { + return request({ url: 'digdata/list', method: 'get', params }) } + // 批量导出开挖数据 export function batchExportDigData(params) { return request({ @@ -116,11 +153,20 @@ // 有害气体数据查询 export function getHarmfulData(params) { return request({ + url: 'harmfuldata/list-page', + method: 'get', + params + }) +} +// 有害气体数据查询,不分页 +export function getHarmfulDataSingle(params) { + return request({ url: 'harmfuldata/list', method: 'get', params }) } + // 批量导出有害气体数据 export function batchExportHarmfulData(params) { return request({ @@ -134,6 +180,14 @@ // 温湿度数据查询 export function getTempData(params) { return request({ + url: 'tempdata/list-page', + method: 'get', + params + }) +} +// 温湿度数据查询,不分页 +export function getTempDataSimple(params) { + return request({ url: 'tempdata/list', method: 'get', params @@ -153,6 +207,14 @@ // 井盖定位监测仪数据查询 export function getWellLocaData(params) { return request({ + url: 'welllocadata/list-page', + method: 'get', + params + }) +} +// 井盖定位监测仪数据查询,不分页 +export function getWellLocaDataSingle(params) { + return request({ url: 'welllocadata/list', method: 'get', params @@ -172,6 +234,14 @@ // 噪声记录仪数据查询 export function getNoiseData(params) { return request({ + url: 'noisedata/list-page', + method: 'get', + params + }) +} +// 噪声记录仪数据查询,不分页 +export function getNoiseDataSingle(params) { + return request({ url: 'noisedata/list', method: 'get', params @@ -190,6 +260,14 @@ // 液位燃气一体化设备数据查询 export function getLiquidGasData(params) { return request({ + url: 'liquidGasData/list-page', + method: 'get', + params + }) +} +// 液位燃气一体化设备数据查询,不分页 +export function getLiquidGasDataSingle(params) { + return request({ url: 'liquidGasData/list', method: 'get', params @@ -209,7 +287,15 @@ // 可燃气体外协数据查询 export function getGasdectorData(params) { return request({ - url: '/gasdector/listpage', + url: '/gasdector/list-page', + method: 'get', + params + }) +} +// 可燃气体外协数据查询,不分页 +export function getGasdectorDataSingle(params) { + return request({ + url: '/gasdector/list', method: 'get', params }) @@ -228,7 +314,15 @@ // 激甲云台数据查询-章丘 export function getPantiltData(params) { return request({ - url: '/pantilt/listpage', + url: '/pantilt/list-page', + method: 'get', + params + }) +} +// 激甲云台数据查询-章丘 +export function getPantiltDataSingle(params) { + return request({ + url: '/pantilt/list', method: 'get', params }) @@ -248,6 +342,14 @@ // 消防栓数据查询 export function getHydrantData(params) { return request({ + url: 'hydrant/list-page', + method: 'get', + params + }) +} +// 消防栓数据查询,不分页 +export function getHydrantDataSingle(params) { + return request({ url: 'hydrant/list', method: 'get', params diff --git a/src/api/data/dataStatics.js b/src/api/data/dataStatics.js index e79dea3..d6b7a72 100644 --- a/src/api/data/dataStatics.js +++ b/src/api/data/dataStatics.js @@ -90,6 +90,15 @@ }) } +// 统计某段时间每种类型的报警数 +export function alarmStaticByContent(params) { + return request({ + url: 'statics/alarmStaticsByContent', + method: 'get', + params + }) +} + // 根据权属单位进行报警统计查询 export function alarmStaticByDept(params) { return request({ @@ -108,3 +117,12 @@ }) } +// 获取数据总数 +export function dataCount(params) { + return request({ + url: '/dataStatics/upLoadCountByTime', + method: 'get', + params + }) +} + diff --git a/src/components/BigData/Card/index.vue b/src/components/BigData/Card/index.vue index b9e5ee6..09fb191 100644 --- a/src/components/BigData/Card/index.vue +++ b/src/components/BigData/Card/index.vue @@ -1,6 +1,6 @@ @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/icons/svg/icon-database.svg b/src/icons/svg/icon-database.svg new file mode 100644 index 0000000..d3dd1c8 --- /dev/null +++ b/src/icons/svg/icon-database.svg @@ -0,0 +1,2 @@ + \ No newline at end of file diff --git a/src/views/dataManage/dataManage.vue b/src/views/dataManage/dataManage.vue index 71be03f..0564cdd 100644 --- a/src/views/dataManage/dataManage.vue +++ b/src/views/dataManage/dataManage.vue @@ -31,19 +31,19 @@ return { activeName: 'wellcover', tabList: [ - { permission: '/welldata/list', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, - { permission: '/liquiddata/list', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, - { permission: '/gasdata/list', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, - { permission: '/digdata/list', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, - { permission: '/noisedata/list', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, - { permission: '/harmfuldata/list', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, - { permission: '/tempdata/list', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, - { permission: '/welllocadata/list', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, - { permission: '/liquidGasData/list', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, - { permission: '/tubedata/list', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, - { permission: '/gasdector/listPage', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, - { permission: '/pantilt/listPage', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, - { permission: '/hydrantdata/list', label: '消防栓数据列表', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } + { permission: '/welldata/list-page', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, + { permission: '/liquiddata/list-page', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, + { permission: '/gasdata/list-page', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, + { permission: '/digdata/list-page', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, + { permission: '/noisedata/list-page', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, + { permission: '/harmfuldata/list-page', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, + { permission: '/tempdata/list-page', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, + { permission: '/welllocadata/list-page', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, + { permission: '/liquidGasData/list-page', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, + { permission: '/tubedata/list-page', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, + { permission: '/gasdector/list-page', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, + { permission: '/pantilt/list-page', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, + { permission: '/hydrantdata/list-page', label: '消防栓防盗水监测仪', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } ] // 所有tab列表 } }, diff --git a/src/views/dataManage/deviceData/listDigData.vue b/src/views/dataManage/deviceData/listDigData.vue index fa4bbc7..3cb74ad 100644 --- a/src/views/dataManage/deviceData/listDigData.vue +++ b/src/views/dataManage/deviceData/listDigData.vue @@ -8,8 +8,9 @@ @@ -26,44 +27,30 @@ -
- - -
- 数据列表 -
-
- - - 导出记录 - - -
- - - + + + + @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/icons/svg/icon-database.svg b/src/icons/svg/icon-database.svg new file mode 100644 index 0000000..d3dd1c8 --- /dev/null +++ b/src/icons/svg/icon-database.svg @@ -0,0 +1,2 @@ + \ No newline at end of file diff --git a/src/views/dataManage/dataManage.vue b/src/views/dataManage/dataManage.vue index 71be03f..0564cdd 100644 --- a/src/views/dataManage/dataManage.vue +++ b/src/views/dataManage/dataManage.vue @@ -31,19 +31,19 @@ return { activeName: 'wellcover', tabList: [ - { permission: '/welldata/list', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, - { permission: '/liquiddata/list', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, - { permission: '/gasdata/list', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, - { permission: '/digdata/list', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, - { permission: '/noisedata/list', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, - { permission: '/harmfuldata/list', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, - { permission: '/tempdata/list', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, - { permission: '/welllocadata/list', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, - { permission: '/liquidGasData/list', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, - { permission: '/tubedata/list', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, - { permission: '/gasdector/listPage', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, - { permission: '/pantilt/listPage', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, - { permission: '/hydrantdata/list', label: '消防栓数据列表', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } + { permission: '/welldata/list-page', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, + { permission: '/liquiddata/list-page', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, + { permission: '/gasdata/list-page', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, + { permission: '/digdata/list-page', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, + { permission: '/noisedata/list-page', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, + { permission: '/harmfuldata/list-page', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, + { permission: '/tempdata/list-page', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, + { permission: '/welllocadata/list-page', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, + { permission: '/liquidGasData/list-page', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, + { permission: '/tubedata/list-page', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, + { permission: '/gasdector/list-page', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, + { permission: '/pantilt/list-page', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, + { permission: '/hydrantdata/list-page', label: '消防栓防盗水监测仪', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } ] // 所有tab列表 } }, diff --git a/src/views/dataManage/deviceData/listDigData.vue b/src/views/dataManage/deviceData/listDigData.vue index fa4bbc7..3cb74ad 100644 --- a/src/views/dataManage/deviceData/listDigData.vue +++ b/src/views/dataManage/deviceData/listDigData.vue @@ -8,8 +8,9 @@ @@ -26,44 +27,30 @@ -
- - -
- 数据列表 -
-
- - - 导出记录 - - -
- - - + + + + @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/icons/svg/icon-database.svg b/src/icons/svg/icon-database.svg new file mode 100644 index 0000000..d3dd1c8 --- /dev/null +++ b/src/icons/svg/icon-database.svg @@ -0,0 +1,2 @@ + \ No newline at end of file diff --git a/src/views/dataManage/dataManage.vue b/src/views/dataManage/dataManage.vue index 71be03f..0564cdd 100644 --- a/src/views/dataManage/dataManage.vue +++ b/src/views/dataManage/dataManage.vue @@ -31,19 +31,19 @@ return { activeName: 'wellcover', tabList: [ - { permission: '/welldata/list', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, - { permission: '/liquiddata/list', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, - { permission: '/gasdata/list', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, - { permission: '/digdata/list', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, - { permission: '/noisedata/list', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, - { permission: '/harmfuldata/list', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, - { permission: '/tempdata/list', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, - { permission: '/welllocadata/list', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, - { permission: '/liquidGasData/list', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, - { permission: '/tubedata/list', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, - { permission: '/gasdector/listPage', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, - { permission: '/pantilt/listPage', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, - { permission: '/hydrantdata/list', label: '消防栓数据列表', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } + { permission: '/welldata/list-page', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, + { permission: '/liquiddata/list-page', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, + { permission: '/gasdata/list-page', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, + { permission: '/digdata/list-page', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, + { permission: '/noisedata/list-page', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, + { permission: '/harmfuldata/list-page', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, + { permission: '/tempdata/list-page', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, + { permission: '/welllocadata/list-page', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, + { permission: '/liquidGasData/list-page', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, + { permission: '/tubedata/list-page', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, + { permission: '/gasdector/list-page', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, + { permission: '/pantilt/list-page', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, + { permission: '/hydrantdata/list-page', label: '消防栓防盗水监测仪', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } ] // 所有tab列表 } }, diff --git a/src/views/dataManage/deviceData/listDigData.vue b/src/views/dataManage/deviceData/listDigData.vue index fa4bbc7..3cb74ad 100644 --- a/src/views/dataManage/deviceData/listDigData.vue +++ b/src/views/dataManage/deviceData/listDigData.vue @@ -8,8 +8,9 @@ @@ -26,44 +27,30 @@ -
- - -
- 数据列表 -
-
- - - 导出记录 - - -
- - - + + + + @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/icons/svg/icon-database.svg b/src/icons/svg/icon-database.svg new file mode 100644 index 0000000..d3dd1c8 --- /dev/null +++ b/src/icons/svg/icon-database.svg @@ -0,0 +1,2 @@ + \ No newline at end of file diff --git a/src/views/dataManage/dataManage.vue b/src/views/dataManage/dataManage.vue index 71be03f..0564cdd 100644 --- a/src/views/dataManage/dataManage.vue +++ b/src/views/dataManage/dataManage.vue @@ -31,19 +31,19 @@ return { activeName: 'wellcover', tabList: [ - { permission: '/welldata/list', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, - { permission: '/liquiddata/list', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, - { permission: '/gasdata/list', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, - { permission: '/digdata/list', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, - { permission: '/noisedata/list', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, - { permission: '/harmfuldata/list', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, - { permission: '/tempdata/list', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, - { permission: '/welllocadata/list', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, - { permission: '/liquidGasData/list', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, - { permission: '/tubedata/list', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, - { permission: '/gasdector/listPage', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, - { permission: '/pantilt/listPage', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, - { permission: '/hydrantdata/list', label: '消防栓数据列表', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } + { permission: '/welldata/list-page', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, + { permission: '/liquiddata/list-page', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, + { permission: '/gasdata/list-page', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, + { permission: '/digdata/list-page', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, + { permission: '/noisedata/list-page', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, + { permission: '/harmfuldata/list-page', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, + { permission: '/tempdata/list-page', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, + { permission: '/welllocadata/list-page', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, + { permission: '/liquidGasData/list-page', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, + { permission: '/tubedata/list-page', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, + { permission: '/gasdector/list-page', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, + { permission: '/pantilt/list-page', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, + { permission: '/hydrantdata/list-page', label: '消防栓防盗水监测仪', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } ] // 所有tab列表 } }, diff --git a/src/views/dataManage/deviceData/listDigData.vue b/src/views/dataManage/deviceData/listDigData.vue index fa4bbc7..3cb74ad 100644 --- a/src/views/dataManage/deviceData/listDigData.vue +++ b/src/views/dataManage/deviceData/listDigData.vue @@ -8,8 +8,9 @@ @@ -26,44 +27,30 @@ -
- - -
- 数据列表 -
-
- - - 导出记录 - - -
- - - + + + + @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/icons/svg/icon-database.svg b/src/icons/svg/icon-database.svg new file mode 100644 index 0000000..d3dd1c8 --- /dev/null +++ b/src/icons/svg/icon-database.svg @@ -0,0 +1,2 @@ + \ No newline at end of file diff --git a/src/views/dataManage/dataManage.vue b/src/views/dataManage/dataManage.vue index 71be03f..0564cdd 100644 --- a/src/views/dataManage/dataManage.vue +++ b/src/views/dataManage/dataManage.vue @@ -31,19 +31,19 @@ return { activeName: 'wellcover', tabList: [ - { permission: '/welldata/list', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, - { permission: '/liquiddata/list', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, - { permission: '/gasdata/list', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, - { permission: '/digdata/list', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, - { permission: '/noisedata/list', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, - { permission: '/harmfuldata/list', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, - { permission: '/tempdata/list', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, - { permission: '/welllocadata/list', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, - { permission: '/liquidGasData/list', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, - { permission: '/tubedata/list', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, - { permission: '/gasdector/listPage', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, - { permission: '/pantilt/listPage', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, - { permission: '/hydrantdata/list', label: '消防栓数据列表', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } + { permission: '/welldata/list-page', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, + { permission: '/liquiddata/list-page', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, + { permission: '/gasdata/list-page', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, + { permission: '/digdata/list-page', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, + { permission: '/noisedata/list-page', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, + { permission: '/harmfuldata/list-page', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, + { permission: '/tempdata/list-page', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, + { permission: '/welllocadata/list-page', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, + { permission: '/liquidGasData/list-page', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, + { permission: '/tubedata/list-page', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, + { permission: '/gasdector/list-page', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, + { permission: '/pantilt/list-page', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, + { permission: '/hydrantdata/list-page', label: '消防栓防盗水监测仪', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } ] // 所有tab列表 } }, diff --git a/src/views/dataManage/deviceData/listDigData.vue b/src/views/dataManage/deviceData/listDigData.vue index fa4bbc7..3cb74ad 100644 --- a/src/views/dataManage/deviceData/listDigData.vue +++ b/src/views/dataManage/deviceData/listDigData.vue @@ -8,8 +8,9 @@ @@ -26,44 +27,30 @@ -
- - -
- 数据列表 -
-
- - - 导出记录 - - -
- - - + + + + @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/icons/svg/icon-database.svg b/src/icons/svg/icon-database.svg new file mode 100644 index 0000000..d3dd1c8 --- /dev/null +++ b/src/icons/svg/icon-database.svg @@ -0,0 +1,2 @@ + \ No newline at end of file diff --git a/src/views/dataManage/dataManage.vue b/src/views/dataManage/dataManage.vue index 71be03f..0564cdd 100644 --- a/src/views/dataManage/dataManage.vue +++ b/src/views/dataManage/dataManage.vue @@ -31,19 +31,19 @@ return { activeName: 'wellcover', tabList: [ - { permission: '/welldata/list', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, - { permission: '/liquiddata/list', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, - { permission: '/gasdata/list', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, - { permission: '/digdata/list', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, - { permission: '/noisedata/list', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, - { permission: '/harmfuldata/list', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, - { permission: '/tempdata/list', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, - { permission: '/welllocadata/list', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, - { permission: '/liquidGasData/list', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, - { permission: '/tubedata/list', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, - { permission: '/gasdector/listPage', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, - { permission: '/pantilt/listPage', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, - { permission: '/hydrantdata/list', label: '消防栓数据列表', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } + { permission: '/welldata/list-page', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, + { permission: '/liquiddata/list-page', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, + { permission: '/gasdata/list-page', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, + { permission: '/digdata/list-page', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, + { permission: '/noisedata/list-page', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, + { permission: '/harmfuldata/list-page', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, + { permission: '/tempdata/list-page', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, + { permission: '/welllocadata/list-page', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, + { permission: '/liquidGasData/list-page', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, + { permission: '/tubedata/list-page', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, + { permission: '/gasdector/list-page', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, + { permission: '/pantilt/list-page', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, + { permission: '/hydrantdata/list-page', label: '消防栓防盗水监测仪', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } ] // 所有tab列表 } }, diff --git a/src/views/dataManage/deviceData/listDigData.vue b/src/views/dataManage/deviceData/listDigData.vue index fa4bbc7..3cb74ad 100644 --- a/src/views/dataManage/deviceData/listDigData.vue +++ b/src/views/dataManage/deviceData/listDigData.vue @@ -8,8 +8,9 @@ @@ -26,44 +27,30 @@ -
- - -
- 数据列表 -
-
- - - 导出记录 - - -
- - - + + + + @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/icons/svg/icon-database.svg b/src/icons/svg/icon-database.svg new file mode 100644 index 0000000..d3dd1c8 --- /dev/null +++ b/src/icons/svg/icon-database.svg @@ -0,0 +1,2 @@ + \ No newline at end of file diff --git a/src/views/dataManage/dataManage.vue b/src/views/dataManage/dataManage.vue index 71be03f..0564cdd 100644 --- a/src/views/dataManage/dataManage.vue +++ b/src/views/dataManage/dataManage.vue @@ -31,19 +31,19 @@ return { activeName: 'wellcover', tabList: [ - { permission: '/welldata/list', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, - { permission: '/liquiddata/list', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, - { permission: '/gasdata/list', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, - { permission: '/digdata/list', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, - { permission: '/noisedata/list', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, - { permission: '/harmfuldata/list', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, - { permission: '/tempdata/list', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, - { permission: '/welllocadata/list', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, - { permission: '/liquidGasData/list', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, - { permission: '/tubedata/list', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, - { permission: '/gasdector/listPage', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, - { permission: '/pantilt/listPage', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, - { permission: '/hydrantdata/list', label: '消防栓数据列表', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } + { permission: '/welldata/list-page', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, + { permission: '/liquiddata/list-page', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, + { permission: '/gasdata/list-page', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, + { permission: '/digdata/list-page', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, + { permission: '/noisedata/list-page', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, + { permission: '/harmfuldata/list-page', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, + { permission: '/tempdata/list-page', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, + { permission: '/welllocadata/list-page', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, + { permission: '/liquidGasData/list-page', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, + { permission: '/tubedata/list-page', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, + { permission: '/gasdector/list-page', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, + { permission: '/pantilt/list-page', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, + { permission: '/hydrantdata/list-page', label: '消防栓防盗水监测仪', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } ] // 所有tab列表 } }, diff --git a/src/views/dataManage/deviceData/listDigData.vue b/src/views/dataManage/deviceData/listDigData.vue index fa4bbc7..3cb74ad 100644 --- a/src/views/dataManage/deviceData/listDigData.vue +++ b/src/views/dataManage/deviceData/listDigData.vue @@ -8,8 +8,9 @@ @@ -26,44 +27,30 @@ -
- - -
- 数据列表 -
-
- - - 导出记录 - - -
- - - + + + + @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/api/data/data.js b/src/api/data/data.js index 7dcc6c7..9d23a3e 100644 --- a/src/api/data/data.js +++ b/src/api/data/data.js @@ -13,7 +13,7 @@ // 井盖数据查询 export function getWellData(params) { return request({ - url: 'welldata/list', + url: 'welldata/list-page', method: 'get', params }) @@ -40,6 +40,15 @@ // 液位数据查询 export function getLiquidData(params) { return request({ + url: 'liquiddata/list-page', + method: 'get', + params + }) +} + +// 液位数据查询-不分页 +export function getLiquidDataSingle(params) { + return request({ url: 'liquiddata/list', method: 'get', params @@ -60,6 +69,14 @@ // 燃气数据查询 export function getGasData(params) { return request({ + url: 'gasdata/list-page', + method: 'get', + params + }) +} +// 燃气数据查询-不分页 +export function getGasDataSingle(params) { + return request({ url: 'gasdata/list', method: 'get', params @@ -85,6 +102,16 @@ params }) } + +// 管盯数据查询-不分页 +export function getTubeDataSingle(params) { + return request({ + url: 'tubedata/list', + method: 'get', + params + }) +} + // 批量导出管盯数据 export function batchExportTubeData(params) { return request({ @@ -98,11 +125,21 @@ // 开挖数据查询 export function getDigData(params) { return request({ + url: 'digdata/list-page', + method: 'get', + params + }) +} + +// 开挖数据查询,不分页 +export function getDigDataSingle(params) { + return request({ url: 'digdata/list', method: 'get', params }) } + // 批量导出开挖数据 export function batchExportDigData(params) { return request({ @@ -116,11 +153,20 @@ // 有害气体数据查询 export function getHarmfulData(params) { return request({ + url: 'harmfuldata/list-page', + method: 'get', + params + }) +} +// 有害气体数据查询,不分页 +export function getHarmfulDataSingle(params) { + return request({ url: 'harmfuldata/list', method: 'get', params }) } + // 批量导出有害气体数据 export function batchExportHarmfulData(params) { return request({ @@ -134,6 +180,14 @@ // 温湿度数据查询 export function getTempData(params) { return request({ + url: 'tempdata/list-page', + method: 'get', + params + }) +} +// 温湿度数据查询,不分页 +export function getTempDataSimple(params) { + return request({ url: 'tempdata/list', method: 'get', params @@ -153,6 +207,14 @@ // 井盖定位监测仪数据查询 export function getWellLocaData(params) { return request({ + url: 'welllocadata/list-page', + method: 'get', + params + }) +} +// 井盖定位监测仪数据查询,不分页 +export function getWellLocaDataSingle(params) { + return request({ url: 'welllocadata/list', method: 'get', params @@ -172,6 +234,14 @@ // 噪声记录仪数据查询 export function getNoiseData(params) { return request({ + url: 'noisedata/list-page', + method: 'get', + params + }) +} +// 噪声记录仪数据查询,不分页 +export function getNoiseDataSingle(params) { + return request({ url: 'noisedata/list', method: 'get', params @@ -190,6 +260,14 @@ // 液位燃气一体化设备数据查询 export function getLiquidGasData(params) { return request({ + url: 'liquidGasData/list-page', + method: 'get', + params + }) +} +// 液位燃气一体化设备数据查询,不分页 +export function getLiquidGasDataSingle(params) { + return request({ url: 'liquidGasData/list', method: 'get', params @@ -209,7 +287,15 @@ // 可燃气体外协数据查询 export function getGasdectorData(params) { return request({ - url: '/gasdector/listpage', + url: '/gasdector/list-page', + method: 'get', + params + }) +} +// 可燃气体外协数据查询,不分页 +export function getGasdectorDataSingle(params) { + return request({ + url: '/gasdector/list', method: 'get', params }) @@ -228,7 +314,15 @@ // 激甲云台数据查询-章丘 export function getPantiltData(params) { return request({ - url: '/pantilt/listpage', + url: '/pantilt/list-page', + method: 'get', + params + }) +} +// 激甲云台数据查询-章丘 +export function getPantiltDataSingle(params) { + return request({ + url: '/pantilt/list', method: 'get', params }) @@ -248,6 +342,14 @@ // 消防栓数据查询 export function getHydrantData(params) { return request({ + url: 'hydrant/list-page', + method: 'get', + params + }) +} +// 消防栓数据查询,不分页 +export function getHydrantDataSingle(params) { + return request({ url: 'hydrant/list', method: 'get', params diff --git a/src/api/data/dataStatics.js b/src/api/data/dataStatics.js index e79dea3..d6b7a72 100644 --- a/src/api/data/dataStatics.js +++ b/src/api/data/dataStatics.js @@ -90,6 +90,15 @@ }) } +// 统计某段时间每种类型的报警数 +export function alarmStaticByContent(params) { + return request({ + url: 'statics/alarmStaticsByContent', + method: 'get', + params + }) +} + // 根据权属单位进行报警统计查询 export function alarmStaticByDept(params) { return request({ @@ -108,3 +117,12 @@ }) } +// 获取数据总数 +export function dataCount(params) { + return request({ + url: '/dataStatics/upLoadCountByTime', + method: 'get', + params + }) +} + diff --git a/src/components/BigData/Card/index.vue b/src/components/BigData/Card/index.vue index b9e5ee6..09fb191 100644 --- a/src/components/BigData/Card/index.vue +++ b/src/components/BigData/Card/index.vue @@ -1,6 +1,6 @@ @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/views/dataView/components/alarmView.vue b/src/views/dataView/components/alarmView.vue index 5c02f41..e13f811 100644 --- a/src/views/dataView/components/alarmView.vue +++ b/src/views/dataView/components/alarmView.vue @@ -1,106 +1,124 @@ + diff --git a/src/api/data/data.js b/src/api/data/data.js index 7dcc6c7..9d23a3e 100644 --- a/src/api/data/data.js +++ b/src/api/data/data.js @@ -13,7 +13,7 @@ // 井盖数据查询 export function getWellData(params) { return request({ - url: 'welldata/list', + url: 'welldata/list-page', method: 'get', params }) @@ -40,6 +40,15 @@ // 液位数据查询 export function getLiquidData(params) { return request({ + url: 'liquiddata/list-page', + method: 'get', + params + }) +} + +// 液位数据查询-不分页 +export function getLiquidDataSingle(params) { + return request({ url: 'liquiddata/list', method: 'get', params @@ -60,6 +69,14 @@ // 燃气数据查询 export function getGasData(params) { return request({ + url: 'gasdata/list-page', + method: 'get', + params + }) +} +// 燃气数据查询-不分页 +export function getGasDataSingle(params) { + return request({ url: 'gasdata/list', method: 'get', params @@ -85,6 +102,16 @@ params }) } + +// 管盯数据查询-不分页 +export function getTubeDataSingle(params) { + return request({ + url: 'tubedata/list', + method: 'get', + params + }) +} + // 批量导出管盯数据 export function batchExportTubeData(params) { return request({ @@ -98,11 +125,21 @@ // 开挖数据查询 export function getDigData(params) { return request({ + url: 'digdata/list-page', + method: 'get', + params + }) +} + +// 开挖数据查询,不分页 +export function getDigDataSingle(params) { + return request({ url: 'digdata/list', method: 'get', params }) } + // 批量导出开挖数据 export function batchExportDigData(params) { return request({ @@ -116,11 +153,20 @@ // 有害气体数据查询 export function getHarmfulData(params) { return request({ + url: 'harmfuldata/list-page', + method: 'get', + params + }) +} +// 有害气体数据查询,不分页 +export function getHarmfulDataSingle(params) { + return request({ url: 'harmfuldata/list', method: 'get', params }) } + // 批量导出有害气体数据 export function batchExportHarmfulData(params) { return request({ @@ -134,6 +180,14 @@ // 温湿度数据查询 export function getTempData(params) { return request({ + url: 'tempdata/list-page', + method: 'get', + params + }) +} +// 温湿度数据查询,不分页 +export function getTempDataSimple(params) { + return request({ url: 'tempdata/list', method: 'get', params @@ -153,6 +207,14 @@ // 井盖定位监测仪数据查询 export function getWellLocaData(params) { return request({ + url: 'welllocadata/list-page', + method: 'get', + params + }) +} +// 井盖定位监测仪数据查询,不分页 +export function getWellLocaDataSingle(params) { + return request({ url: 'welllocadata/list', method: 'get', params @@ -172,6 +234,14 @@ // 噪声记录仪数据查询 export function getNoiseData(params) { return request({ + url: 'noisedata/list-page', + method: 'get', + params + }) +} +// 噪声记录仪数据查询,不分页 +export function getNoiseDataSingle(params) { + return request({ url: 'noisedata/list', method: 'get', params @@ -190,6 +260,14 @@ // 液位燃气一体化设备数据查询 export function getLiquidGasData(params) { return request({ + url: 'liquidGasData/list-page', + method: 'get', + params + }) +} +// 液位燃气一体化设备数据查询,不分页 +export function getLiquidGasDataSingle(params) { + return request({ url: 'liquidGasData/list', method: 'get', params @@ -209,7 +287,15 @@ // 可燃气体外协数据查询 export function getGasdectorData(params) { return request({ - url: '/gasdector/listpage', + url: '/gasdector/list-page', + method: 'get', + params + }) +} +// 可燃气体外协数据查询,不分页 +export function getGasdectorDataSingle(params) { + return request({ + url: '/gasdector/list', method: 'get', params }) @@ -228,7 +314,15 @@ // 激甲云台数据查询-章丘 export function getPantiltData(params) { return request({ - url: '/pantilt/listpage', + url: '/pantilt/list-page', + method: 'get', + params + }) +} +// 激甲云台数据查询-章丘 +export function getPantiltDataSingle(params) { + return request({ + url: '/pantilt/list', method: 'get', params }) @@ -248,6 +342,14 @@ // 消防栓数据查询 export function getHydrantData(params) { return request({ + url: 'hydrant/list-page', + method: 'get', + params + }) +} +// 消防栓数据查询,不分页 +export function getHydrantDataSingle(params) { + return request({ url: 'hydrant/list', method: 'get', params diff --git a/src/api/data/dataStatics.js b/src/api/data/dataStatics.js index e79dea3..d6b7a72 100644 --- a/src/api/data/dataStatics.js +++ b/src/api/data/dataStatics.js @@ -90,6 +90,15 @@ }) } +// 统计某段时间每种类型的报警数 +export function alarmStaticByContent(params) { + return request({ + url: 'statics/alarmStaticsByContent', + method: 'get', + params + }) +} + // 根据权属单位进行报警统计查询 export function alarmStaticByDept(params) { return request({ @@ -108,3 +117,12 @@ }) } +// 获取数据总数 +export function dataCount(params) { + return request({ + url: '/dataStatics/upLoadCountByTime', + method: 'get', + params + }) +} + diff --git a/src/components/BigData/Card/index.vue b/src/components/BigData/Card/index.vue index b9e5ee6..09fb191 100644 --- a/src/components/BigData/Card/index.vue +++ b/src/components/BigData/Card/index.vue @@ -1,6 +1,6 @@ @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/views/dataView/components/alarmView.vue b/src/views/dataView/components/alarmView.vue index 5c02f41..e13f811 100644 --- a/src/views/dataView/components/alarmView.vue +++ b/src/views/dataView/components/alarmView.vue @@ -1,106 +1,124 @@ + diff --git a/src/views/dataView/components/jobAnalysis.vue b/src/views/dataView/components/jobAnalysis.vue new file mode 100644 index 0000000..483e652 --- /dev/null +++ b/src/views/dataView/components/jobAnalysis.vue @@ -0,0 +1,106 @@ + + + + + + diff --git a/src/api/data/data.js b/src/api/data/data.js index 7dcc6c7..9d23a3e 100644 --- a/src/api/data/data.js +++ b/src/api/data/data.js @@ -13,7 +13,7 @@ // 井盖数据查询 export function getWellData(params) { return request({ - url: 'welldata/list', + url: 'welldata/list-page', method: 'get', params }) @@ -40,6 +40,15 @@ // 液位数据查询 export function getLiquidData(params) { return request({ + url: 'liquiddata/list-page', + method: 'get', + params + }) +} + +// 液位数据查询-不分页 +export function getLiquidDataSingle(params) { + return request({ url: 'liquiddata/list', method: 'get', params @@ -60,6 +69,14 @@ // 燃气数据查询 export function getGasData(params) { return request({ + url: 'gasdata/list-page', + method: 'get', + params + }) +} +// 燃气数据查询-不分页 +export function getGasDataSingle(params) { + return request({ url: 'gasdata/list', method: 'get', params @@ -85,6 +102,16 @@ params }) } + +// 管盯数据查询-不分页 +export function getTubeDataSingle(params) { + return request({ + url: 'tubedata/list', + method: 'get', + params + }) +} + // 批量导出管盯数据 export function batchExportTubeData(params) { return request({ @@ -98,11 +125,21 @@ // 开挖数据查询 export function getDigData(params) { return request({ + url: 'digdata/list-page', + method: 'get', + params + }) +} + +// 开挖数据查询,不分页 +export function getDigDataSingle(params) { + return request({ url: 'digdata/list', method: 'get', params }) } + // 批量导出开挖数据 export function batchExportDigData(params) { return request({ @@ -116,11 +153,20 @@ // 有害气体数据查询 export function getHarmfulData(params) { return request({ + url: 'harmfuldata/list-page', + method: 'get', + params + }) +} +// 有害气体数据查询,不分页 +export function getHarmfulDataSingle(params) { + return request({ url: 'harmfuldata/list', method: 'get', params }) } + // 批量导出有害气体数据 export function batchExportHarmfulData(params) { return request({ @@ -134,6 +180,14 @@ // 温湿度数据查询 export function getTempData(params) { return request({ + url: 'tempdata/list-page', + method: 'get', + params + }) +} +// 温湿度数据查询,不分页 +export function getTempDataSimple(params) { + return request({ url: 'tempdata/list', method: 'get', params @@ -153,6 +207,14 @@ // 井盖定位监测仪数据查询 export function getWellLocaData(params) { return request({ + url: 'welllocadata/list-page', + method: 'get', + params + }) +} +// 井盖定位监测仪数据查询,不分页 +export function getWellLocaDataSingle(params) { + return request({ url: 'welllocadata/list', method: 'get', params @@ -172,6 +234,14 @@ // 噪声记录仪数据查询 export function getNoiseData(params) { return request({ + url: 'noisedata/list-page', + method: 'get', + params + }) +} +// 噪声记录仪数据查询,不分页 +export function getNoiseDataSingle(params) { + return request({ url: 'noisedata/list', method: 'get', params @@ -190,6 +260,14 @@ // 液位燃气一体化设备数据查询 export function getLiquidGasData(params) { return request({ + url: 'liquidGasData/list-page', + method: 'get', + params + }) +} +// 液位燃气一体化设备数据查询,不分页 +export function getLiquidGasDataSingle(params) { + return request({ url: 'liquidGasData/list', method: 'get', params @@ -209,7 +287,15 @@ // 可燃气体外协数据查询 export function getGasdectorData(params) { return request({ - url: '/gasdector/listpage', + url: '/gasdector/list-page', + method: 'get', + params + }) +} +// 可燃气体外协数据查询,不分页 +export function getGasdectorDataSingle(params) { + return request({ + url: '/gasdector/list', method: 'get', params }) @@ -228,7 +314,15 @@ // 激甲云台数据查询-章丘 export function getPantiltData(params) { return request({ - url: '/pantilt/listpage', + url: '/pantilt/list-page', + method: 'get', + params + }) +} +// 激甲云台数据查询-章丘 +export function getPantiltDataSingle(params) { + return request({ + url: '/pantilt/list', method: 'get', params }) @@ -248,6 +342,14 @@ // 消防栓数据查询 export function getHydrantData(params) { return request({ + url: 'hydrant/list-page', + method: 'get', + params + }) +} +// 消防栓数据查询,不分页 +export function getHydrantDataSingle(params) { + return request({ url: 'hydrant/list', method: 'get', params diff --git a/src/api/data/dataStatics.js b/src/api/data/dataStatics.js index e79dea3..d6b7a72 100644 --- a/src/api/data/dataStatics.js +++ b/src/api/data/dataStatics.js @@ -90,6 +90,15 @@ }) } +// 统计某段时间每种类型的报警数 +export function alarmStaticByContent(params) { + return request({ + url: 'statics/alarmStaticsByContent', + method: 'get', + params + }) +} + // 根据权属单位进行报警统计查询 export function alarmStaticByDept(params) { return request({ @@ -108,3 +117,12 @@ }) } +// 获取数据总数 +export function dataCount(params) { + return request({ + url: '/dataStatics/upLoadCountByTime', + method: 'get', + params + }) +} + diff --git a/src/components/BigData/Card/index.vue b/src/components/BigData/Card/index.vue index b9e5ee6..09fb191 100644 --- a/src/components/BigData/Card/index.vue +++ b/src/components/BigData/Card/index.vue @@ -1,6 +1,6 @@ @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/views/dataView/components/alarmView.vue b/src/views/dataView/components/alarmView.vue index 5c02f41..e13f811 100644 --- a/src/views/dataView/components/alarmView.vue +++ b/src/views/dataView/components/alarmView.vue @@ -1,106 +1,124 @@ + diff --git a/src/views/dataView/components/jobAnalysis.vue b/src/views/dataView/components/jobAnalysis.vue new file mode 100644 index 0000000..483e652 --- /dev/null +++ b/src/views/dataView/components/jobAnalysis.vue @@ -0,0 +1,106 @@ + + + + + + diff --git a/src/views/dataView/components/panelGroup.vue b/src/views/dataView/components/panelGroup.vue index cdb9180..7cae96f 100644 --- a/src/views/dataView/components/panelGroup.vue +++ b/src/views/dataView/components/panelGroup.vue @@ -1,82 +1,54 @@ diff --git a/src/api/data/data.js b/src/api/data/data.js index 7dcc6c7..9d23a3e 100644 --- a/src/api/data/data.js +++ b/src/api/data/data.js @@ -13,7 +13,7 @@ // 井盖数据查询 export function getWellData(params) { return request({ - url: 'welldata/list', + url: 'welldata/list-page', method: 'get', params }) @@ -40,6 +40,15 @@ // 液位数据查询 export function getLiquidData(params) { return request({ + url: 'liquiddata/list-page', + method: 'get', + params + }) +} + +// 液位数据查询-不分页 +export function getLiquidDataSingle(params) { + return request({ url: 'liquiddata/list', method: 'get', params @@ -60,6 +69,14 @@ // 燃气数据查询 export function getGasData(params) { return request({ + url: 'gasdata/list-page', + method: 'get', + params + }) +} +// 燃气数据查询-不分页 +export function getGasDataSingle(params) { + return request({ url: 'gasdata/list', method: 'get', params @@ -85,6 +102,16 @@ params }) } + +// 管盯数据查询-不分页 +export function getTubeDataSingle(params) { + return request({ + url: 'tubedata/list', + method: 'get', + params + }) +} + // 批量导出管盯数据 export function batchExportTubeData(params) { return request({ @@ -98,11 +125,21 @@ // 开挖数据查询 export function getDigData(params) { return request({ + url: 'digdata/list-page', + method: 'get', + params + }) +} + +// 开挖数据查询,不分页 +export function getDigDataSingle(params) { + return request({ url: 'digdata/list', method: 'get', params }) } + // 批量导出开挖数据 export function batchExportDigData(params) { return request({ @@ -116,11 +153,20 @@ // 有害气体数据查询 export function getHarmfulData(params) { return request({ + url: 'harmfuldata/list-page', + method: 'get', + params + }) +} +// 有害气体数据查询,不分页 +export function getHarmfulDataSingle(params) { + return request({ url: 'harmfuldata/list', method: 'get', params }) } + // 批量导出有害气体数据 export function batchExportHarmfulData(params) { return request({ @@ -134,6 +180,14 @@ // 温湿度数据查询 export function getTempData(params) { return request({ + url: 'tempdata/list-page', + method: 'get', + params + }) +} +// 温湿度数据查询,不分页 +export function getTempDataSimple(params) { + return request({ url: 'tempdata/list', method: 'get', params @@ -153,6 +207,14 @@ // 井盖定位监测仪数据查询 export function getWellLocaData(params) { return request({ + url: 'welllocadata/list-page', + method: 'get', + params + }) +} +// 井盖定位监测仪数据查询,不分页 +export function getWellLocaDataSingle(params) { + return request({ url: 'welllocadata/list', method: 'get', params @@ -172,6 +234,14 @@ // 噪声记录仪数据查询 export function getNoiseData(params) { return request({ + url: 'noisedata/list-page', + method: 'get', + params + }) +} +// 噪声记录仪数据查询,不分页 +export function getNoiseDataSingle(params) { + return request({ url: 'noisedata/list', method: 'get', params @@ -190,6 +260,14 @@ // 液位燃气一体化设备数据查询 export function getLiquidGasData(params) { return request({ + url: 'liquidGasData/list-page', + method: 'get', + params + }) +} +// 液位燃气一体化设备数据查询,不分页 +export function getLiquidGasDataSingle(params) { + return request({ url: 'liquidGasData/list', method: 'get', params @@ -209,7 +287,15 @@ // 可燃气体外协数据查询 export function getGasdectorData(params) { return request({ - url: '/gasdector/listpage', + url: '/gasdector/list-page', + method: 'get', + params + }) +} +// 可燃气体外协数据查询,不分页 +export function getGasdectorDataSingle(params) { + return request({ + url: '/gasdector/list', method: 'get', params }) @@ -228,7 +314,15 @@ // 激甲云台数据查询-章丘 export function getPantiltData(params) { return request({ - url: '/pantilt/listpage', + url: '/pantilt/list-page', + method: 'get', + params + }) +} +// 激甲云台数据查询-章丘 +export function getPantiltDataSingle(params) { + return request({ + url: '/pantilt/list', method: 'get', params }) @@ -248,6 +342,14 @@ // 消防栓数据查询 export function getHydrantData(params) { return request({ + url: 'hydrant/list-page', + method: 'get', + params + }) +} +// 消防栓数据查询,不分页 +export function getHydrantDataSingle(params) { + return request({ url: 'hydrant/list', method: 'get', params diff --git a/src/api/data/dataStatics.js b/src/api/data/dataStatics.js index e79dea3..d6b7a72 100644 --- a/src/api/data/dataStatics.js +++ b/src/api/data/dataStatics.js @@ -90,6 +90,15 @@ }) } +// 统计某段时间每种类型的报警数 +export function alarmStaticByContent(params) { + return request({ + url: 'statics/alarmStaticsByContent', + method: 'get', + params + }) +} + // 根据权属单位进行报警统计查询 export function alarmStaticByDept(params) { return request({ @@ -108,3 +117,12 @@ }) } +// 获取数据总数 +export function dataCount(params) { + return request({ + url: '/dataStatics/upLoadCountByTime', + method: 'get', + params + }) +} + diff --git a/src/components/BigData/Card/index.vue b/src/components/BigData/Card/index.vue index b9e5ee6..09fb191 100644 --- a/src/components/BigData/Card/index.vue +++ b/src/components/BigData/Card/index.vue @@ -1,6 +1,6 @@ @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/views/dataView/components/alarmView.vue b/src/views/dataView/components/alarmView.vue index 5c02f41..e13f811 100644 --- a/src/views/dataView/components/alarmView.vue +++ b/src/views/dataView/components/alarmView.vue @@ -1,106 +1,124 @@ + diff --git a/src/views/dataView/components/jobAnalysis.vue b/src/views/dataView/components/jobAnalysis.vue new file mode 100644 index 0000000..483e652 --- /dev/null +++ b/src/views/dataView/components/jobAnalysis.vue @@ -0,0 +1,106 @@ + + + + + + diff --git a/src/views/dataView/components/panelGroup.vue b/src/views/dataView/components/panelGroup.vue index cdb9180..7cae96f 100644 --- a/src/views/dataView/components/panelGroup.vue +++ b/src/views/dataView/components/panelGroup.vue @@ -1,82 +1,54 @@ diff --git a/src/views/dataView/components/wellCountView.vue b/src/views/dataView/components/wellCountView.vue index 82fe878..5c0e2d7 100644 --- a/src/views/dataView/components/wellCountView.vue +++ b/src/views/dataView/components/wellCountView.vue @@ -1,61 +1,70 @@ + + diff --git a/src/icons/svg/icon-database.svg b/src/icons/svg/icon-database.svg new file mode 100644 index 0000000..d3dd1c8 --- /dev/null +++ b/src/icons/svg/icon-database.svg @@ -0,0 +1,2 @@ + \ No newline at end of file diff --git a/src/views/dataManage/dataManage.vue b/src/views/dataManage/dataManage.vue index 71be03f..0564cdd 100644 --- a/src/views/dataManage/dataManage.vue +++ b/src/views/dataManage/dataManage.vue @@ -31,19 +31,19 @@ return { activeName: 'wellcover', tabList: [ - { permission: '/welldata/list', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, - { permission: '/liquiddata/list', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, - { permission: '/gasdata/list', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, - { permission: '/digdata/list', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, - { permission: '/noisedata/list', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, - { permission: '/harmfuldata/list', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, - { permission: '/tempdata/list', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, - { permission: '/welllocadata/list', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, - { permission: '/liquidGasData/list', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, - { permission: '/tubedata/list', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, - { permission: '/gasdector/listPage', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, - { permission: '/pantilt/listPage', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, - { permission: '/hydrantdata/list', label: '消防栓数据列表', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } + { permission: '/welldata/list-page', label: '井盖状态监测仪', name: 'wellcover', type: '1', comp: 'list-well-cover-data' }, + { permission: '/liquiddata/list-page', label: '液位监测仪', name: 'liquid', type: '2', comp: 'list-liquid-data' }, + { permission: '/gasdata/list-page', label: '燃气智能监测终端', name: 'gas', type: '4', comp: 'list-gas-data' }, + { permission: '/digdata/list-page', label: '开挖监测仪', name: 'dig', type: '6', comp: 'list-dig-data' }, + { permission: '/noisedata/list-page', label: '噪声记录仪', name: 'noise', type: '8', comp: 'list-noise-data' }, + { permission: '/harmfuldata/list-page', label: '有害气体监测仪', name: 'harmful', type: '3', comp: 'list-harmful-data' }, + { permission: '/tempdata/list-page', label: '温湿度监测仪', name: 'temp', type: '5', comp: 'list-temp-data' }, + { permission: '/welllocadata/list-page', label: '井盖定位监测仪', name: 'wellloca', type: '7', comp: 'list-well-loca-data' }, + { permission: '/liquidGasData/list-page', label: '燃气智能终端(一体化)', name: 'liquidgas', type: '10', comp: 'list-liquid-gas-data' }, + { permission: '/tubedata/list-page', label: '管盯', name: 'tube', type: '12', comp: 'list-tube-data' }, + { permission: '/gasdector/list-page', label: '可燃气体智能监测终端', name: 'gasdector', type: '1', comp: 'list-gasdector-data' }, + { permission: '/pantilt/list-page', label: '激光甲烷遥测云台', name: 'pantilt', type: '1', comp: 'list-pantilt-data' }, + { permission: '/hydrantdata/list-page', label: '消防栓防盗水监测仪', name: 'hydrant', type: '11', comp: 'list-hydrant-data' } ] // 所有tab列表 } }, diff --git a/src/views/dataManage/deviceData/listDigData.vue b/src/views/dataManage/deviceData/listDigData.vue index fa4bbc7..3cb74ad 100644 --- a/src/views/dataManage/deviceData/listDigData.vue +++ b/src/views/dataManage/deviceData/listDigData.vue @@ -8,8 +8,9 @@ @@ -26,44 +27,30 @@ -
- - -
- 数据列表 -
-
- - - 导出记录 - - -
- - - + + + + @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/views/dataView/components/alarmView.vue b/src/views/dataView/components/alarmView.vue index 5c02f41..e13f811 100644 --- a/src/views/dataView/components/alarmView.vue +++ b/src/views/dataView/components/alarmView.vue @@ -1,106 +1,124 @@ + diff --git a/src/views/dataView/components/jobAnalysis.vue b/src/views/dataView/components/jobAnalysis.vue new file mode 100644 index 0000000..483e652 --- /dev/null +++ b/src/views/dataView/components/jobAnalysis.vue @@ -0,0 +1,106 @@ + + + + + + diff --git a/src/views/dataView/components/panelGroup.vue b/src/views/dataView/components/panelGroup.vue index cdb9180..7cae96f 100644 --- a/src/views/dataView/components/panelGroup.vue +++ b/src/views/dataView/components/panelGroup.vue @@ -1,82 +1,54 @@ diff --git a/src/views/dataView/components/wellCountView.vue b/src/views/dataView/components/wellCountView.vue index 82fe878..5c0e2d7 100644 --- a/src/views/dataView/components/wellCountView.vue +++ b/src/views/dataView/components/wellCountView.vue @@ -1,61 +1,70 @@ diff --git a/src/api/data/data.js b/src/api/data/data.js index 7dcc6c7..9d23a3e 100644 --- a/src/api/data/data.js +++ b/src/api/data/data.js @@ -13,7 +13,7 @@ // 井盖数据查询 export function getWellData(params) { return request({ - url: 'welldata/list', + url: 'welldata/list-page', method: 'get', params }) @@ -40,6 +40,15 @@ // 液位数据查询 export function getLiquidData(params) { return request({ + url: 'liquiddata/list-page', + method: 'get', + params + }) +} + +// 液位数据查询-不分页 +export function getLiquidDataSingle(params) { + return request({ url: 'liquiddata/list', method: 'get', params @@ -60,6 +69,14 @@ // 燃气数据查询 export function getGasData(params) { return request({ + url: 'gasdata/list-page', + method: 'get', + params + }) +} +// 燃气数据查询-不分页 +export function getGasDataSingle(params) { + return request({ url: 'gasdata/list', method: 'get', params @@ -85,6 +102,16 @@ params }) } + +// 管盯数据查询-不分页 +export function getTubeDataSingle(params) { + return request({ + url: 'tubedata/list', + method: 'get', + params + }) +} + // 批量导出管盯数据 export function batchExportTubeData(params) { return request({ @@ -98,11 +125,21 @@ // 开挖数据查询 export function getDigData(params) { return request({ + url: 'digdata/list-page', + method: 'get', + params + }) +} + +// 开挖数据查询,不分页 +export function getDigDataSingle(params) { + return request({ url: 'digdata/list', method: 'get', params }) } + // 批量导出开挖数据 export function batchExportDigData(params) { return request({ @@ -116,11 +153,20 @@ // 有害气体数据查询 export function getHarmfulData(params) { return request({ + url: 'harmfuldata/list-page', + method: 'get', + params + }) +} +// 有害气体数据查询,不分页 +export function getHarmfulDataSingle(params) { + return request({ url: 'harmfuldata/list', method: 'get', params }) } + // 批量导出有害气体数据 export function batchExportHarmfulData(params) { return request({ @@ -134,6 +180,14 @@ // 温湿度数据查询 export function getTempData(params) { return request({ + url: 'tempdata/list-page', + method: 'get', + params + }) +} +// 温湿度数据查询,不分页 +export function getTempDataSimple(params) { + return request({ url: 'tempdata/list', method: 'get', params @@ -153,6 +207,14 @@ // 井盖定位监测仪数据查询 export function getWellLocaData(params) { return request({ + url: 'welllocadata/list-page', + method: 'get', + params + }) +} +// 井盖定位监测仪数据查询,不分页 +export function getWellLocaDataSingle(params) { + return request({ url: 'welllocadata/list', method: 'get', params @@ -172,6 +234,14 @@ // 噪声记录仪数据查询 export function getNoiseData(params) { return request({ + url: 'noisedata/list-page', + method: 'get', + params + }) +} +// 噪声记录仪数据查询,不分页 +export function getNoiseDataSingle(params) { + return request({ url: 'noisedata/list', method: 'get', params @@ -190,6 +260,14 @@ // 液位燃气一体化设备数据查询 export function getLiquidGasData(params) { return request({ + url: 'liquidGasData/list-page', + method: 'get', + params + }) +} +// 液位燃气一体化设备数据查询,不分页 +export function getLiquidGasDataSingle(params) { + return request({ url: 'liquidGasData/list', method: 'get', params @@ -209,7 +287,15 @@ // 可燃气体外协数据查询 export function getGasdectorData(params) { return request({ - url: '/gasdector/listpage', + url: '/gasdector/list-page', + method: 'get', + params + }) +} +// 可燃气体外协数据查询,不分页 +export function getGasdectorDataSingle(params) { + return request({ + url: '/gasdector/list', method: 'get', params }) @@ -228,7 +314,15 @@ // 激甲云台数据查询-章丘 export function getPantiltData(params) { return request({ - url: '/pantilt/listpage', + url: '/pantilt/list-page', + method: 'get', + params + }) +} +// 激甲云台数据查询-章丘 +export function getPantiltDataSingle(params) { + return request({ + url: '/pantilt/list', method: 'get', params }) @@ -248,6 +342,14 @@ // 消防栓数据查询 export function getHydrantData(params) { return request({ + url: 'hydrant/list-page', + method: 'get', + params + }) +} +// 消防栓数据查询,不分页 +export function getHydrantDataSingle(params) { + return request({ url: 'hydrant/list', method: 'get', params diff --git a/src/api/data/dataStatics.js b/src/api/data/dataStatics.js index e79dea3..d6b7a72 100644 --- a/src/api/data/dataStatics.js +++ b/src/api/data/dataStatics.js @@ -90,6 +90,15 @@ }) } +// 统计某段时间每种类型的报警数 +export function alarmStaticByContent(params) { + return request({ + url: 'statics/alarmStaticsByContent', + method: 'get', + params + }) +} + // 根据权属单位进行报警统计查询 export function alarmStaticByDept(params) { return request({ @@ -108,3 +117,12 @@ }) } +// 获取数据总数 +export function dataCount(params) { + return request({ + url: '/dataStatics/upLoadCountByTime', + method: 'get', + params + }) +} + diff --git a/src/components/BigData/Card/index.vue b/src/components/BigData/Card/index.vue index b9e5ee6..09fb191 100644 --- a/src/components/BigData/Card/index.vue +++ b/src/components/BigData/Card/index.vue @@ -1,6 +1,6 @@ @@ -72,6 +59,7 @@ import DeptSelect from '../../../components/DeptSelect/index' import { parseUrl } from '@/utils/parseutils' import { getSearchLastWeekTime } from '@/utils/dateutils' +import { exportFile } from '@/utils/exportutils' export default { name: 'ListDigData', @@ -83,7 +71,7 @@ }, // 设备类型 name: { type: String, - default: '激光甲烷遥测云台' + default: '' } // 设备名称 }, data() { @@ -100,81 +88,24 @@ }, // 筛选条件 timeRange: [], // 时间范围 columns: [ - { - text: '设备编号', - value: 'devcode', - align: 'center' - }, - { - text: '点位编号', - value: 'wellCode', - align: 'center' - }, - { - text: '设备类型', - value: 'deviceTypeName', - align: 'center' - }, - { - text: '噪声值(mg)', - value: 'ddata', - align: 'center' - }, - { - text: '电量(%)', - value: 'cell', - width: 80, - align: 'center', - checkCell: true - }, - // { - // text: '状态描述', - // value: 'descn', - // width: 80, - // align: 'center', - // checkCell: true - // }, - { - text: '权属单位', - value: 'deptName', - align: 'center' - }, - { - text: '上传时间', - value: 'uptime', - width: 170, - align: 'center' - } + { text: '设备编号', value: 'devcode', align: 'center' }, + { text: '点位编号', value: 'wellCode', align: 'center' }, + { text: '设备类型', value: 'deviceTypeName', align: 'center' }, + { text: '噪声值(mg)', value: 'ddata', align: 'center' }, + { text: '电量(%)', value: 'cell', width: 80, align: 'center', checkCell: true }, + { text: '权属单位', value: 'deptName', align: 'center' }, + { text: '上传时间', value: 'uptime', width: 170, align: 'center' } ], // 显示列 - multipleSelection: [], // 多选选中项 + // multipleSelection: [], // 多选选中项 list: [], // 列表数据 total: 0, // 数据总数 - deviceTypeList: [], // 开挖配置类型列表 - deptProps: { - parent: 'pid', - value: 'id', - label: 'name', - children: 'children' - }, // 权属单位树形下拉菜单 - deptTreeList: null, // 组织树列表数据 - showDeptTree: 0, // 是否显示权属单位下拉 - showDeviceType: true, // 是否显示设备类型下拉 + options: { + needIndex: true, // 是否需要序号列 + border: true // 是否需要上方边框 + }, listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 - editShow: false, // 是否显示编辑框 - detailShow: false, // 是否显示编辑框 - deptShowTop: false - } - }, - watch: { - timeRange(val) { - if (val && val.length > 0) { - this.listQuery.beginTime = val[0] - this.listQuery.endTime = val[1] - } else { - this.listQuery.beginTime = '' - this.listQuery.endTime = '' - } + editShow: false // 是否显示编辑框 } }, mounted() { @@ -185,6 +116,8 @@ if (params && params.deviceType === this.type && params.devcode) { this.listQuery.keywords = params.devcode this.fetchData() + } else { + this.fetchData() } } }, @@ -203,21 +136,16 @@ // 全屏加载动画 const loading = this.$loading({ lock: true, - text: '数据处理中,请稍后...', + text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDigData(this.listQuery).then(res => { loading.close() // 关闭加载动画 + let fileName = `${this.name}数据-${this.listQuery.beginTime}-${this.listQuery.endTime}.xlsx` + fileName = fileName.replace(/-|:| /g, '') const blob = new Blob([res.data]) - const downloadElement = document.createElement('a') - const href = window.URL.createObjectURL(blob) // 创建下载的链接 - downloadElement.href = href - downloadElement.download = `开挖监测仪数据.xlsx` // 下载后文件名 - document.body.appendChild(downloadElement) - downloadElement.click() // 点击下载 - document.body.removeChild(downloadElement) // 下载完成移除元素 - window.URL.revokeObjectURL(href) // 释放blob对象 + exportFile(blob, fileName) }).catch((res) => { loading.close() }) @@ -232,69 +160,50 @@ if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } + this.handleDateTime() getDigData(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, + // 处理时间 + handleDateTime() { + if (this.timeRange && this.timeRange.length > 0) { + this.listQuery.beginTime = this.timeRange[0] + this.listQuery.endTime = this.timeRange[1] + } else { + this.listQuery.beginTime = '' + this.listQuery.endTime = '' + } + }, checkCell(value) { var cell = parseFloat(value) if (cell < 10) { return 'warning-state' } }, - indexMethod(index) { - return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 - }, - // 改变页容量 - handleSizeChange(val) { - this.listQuery.limit = val + // checkState(row) { + // if (row.status !== '0') { + // return 'warning-state' + // } + // }, + // 页数发生变化后的操作,可能是页码变化,可能是每页容量变化,此函数必写 + changePage(val) { + if (val && val.size) { + this.listQuery.limit = val.size + } + if (val && val.page) { + this.listQuery.offset = val.page + } this.fetchData() - }, - // 改变当前页 - handleCurrentChange(val) { - this.listQuery.offset = val - this.fetchData() - }, - // 多选触发方法 - handleSelectionChange(val) { - this.multipleSelection = val + // }, } } } diff --git a/src/views/dataView/components/alarmView.vue b/src/views/dataView/components/alarmView.vue index 5c02f41..e13f811 100644 --- a/src/views/dataView/components/alarmView.vue +++ b/src/views/dataView/components/alarmView.vue @@ -1,106 +1,124 @@ + diff --git a/src/views/dataView/components/jobAnalysis.vue b/src/views/dataView/components/jobAnalysis.vue new file mode 100644 index 0000000..483e652 --- /dev/null +++ b/src/views/dataView/components/jobAnalysis.vue @@ -0,0 +1,106 @@ + + + + + + diff --git a/src/views/dataView/components/panelGroup.vue b/src/views/dataView/components/panelGroup.vue index cdb9180..7cae96f 100644 --- a/src/views/dataView/components/panelGroup.vue +++ b/src/views/dataView/components/panelGroup.vue @@ -1,82 +1,54 @@ diff --git a/src/views/dataView/components/wellCountView.vue b/src/views/dataView/components/wellCountView.vue index 82fe878..5c0e2d7 100644 --- a/src/views/dataView/components/wellCountView.vue +++ b/src/views/dataView/components/wellCountView.vue @@ -1,61 +1,70 @@ diff --git a/src/views/system/resource/editResource.vue b/src/views/system/resource/editResource.vue index 5f88a36..74e6363 100644 --- a/src/views/system/resource/editResource.vue +++ b/src/views/system/resource/editResource.vue @@ -27,7 +27,7 @@ - +