导出数据

whychdw

2021-04-15 e2171af9c51851ec75777f34314dff3b8f96289f

导出数据

 package.json

@@ -1,6 +1,6 @@
{
  "name": "admin_manage",
  "version": "2.2.1",
  "version": "2.2.3",
  "private": true,
  "scripts": {
    "serve": "vue-cli-service serve --mode dev",

 src/pages/dataMager/battGroupMager.vue

@@ -48,7 +48,8 @@
                <div class="table-cell w360">
                    <el-select 
                    v-model="filters.values.home"
                    @click="changeHome"  
                    @click="changeHome"
                    filterable
                    size="small" placeholder="请选择机房名称">
                        <el-option
                        v-for="item in filters.data.home"

 src/pages/reportStatistics/eleAnalyse.vue

@@ -74,9 +74,15 @@
        <div class="flex-page-footer" slot="footer">
            <div class="el-pagination-btns">
                <el-button type="primary" round size="mini" @click="serchLowData" icon="el-icon-search">查询</el-button>
                <el-button type="primary" round size="mini" icon="el-icon-wallet">导出</el-button>
                <el-button type="primary" round size="mini" @click="exportExcel" icon="el-icon-wallet">导出</el-button>
            </div>
        </div>
        <form :action="exportUrl" method="post" ref="Export_Excel">
            <input type="hidden" name="PageName"   value="eleAnalyse.jsp"/>
            <input type="hidden" ref="arr_Th"      name="arr_Th"/>
            <input type="hidden" ref="arr_Td"      name="arr_Td"/>
            <input type="hidden" ref="echart_url"  name="echart_url"/>
        </form>
    </flex-layout>
</template>

@@ -108,7 +114,10 @@
            let MM = thistime.getMonth() + 1;
            let dd = thistime.getDate();
            let day1 = yy + "-" + MM + "-" + dd + ' 23:59:59';
            let baseURL = this.$axios.defaults.baseURL;
            baseURL = baseURL?baseURL:"";
            return {
                exportUrl: baseURL+"ExportTable.servlet",
                allSelected: true,
                eleAnalysetable: {
                    headers: [{
@@ -494,7 +503,41 @@
                });
                this.chartData = allData;
                this.initChart();
            }
            },
            exportExcel() {
                let tableData = this.eleAnalysetable.datas;
                if(tableData.length == 0) {
                    this.$layer.msg('暂无数据');
                    return;
                }
                // 图表数据
                let chartImage = this.$G.chartManage.get('eleAnalyseChart').getDataURL({
                    pixelRatio: 1,
                    backgroundColor: '#fff'
                });

                // 表格数据
                let tableHeaders = this.eleAnalysetable.headers;
                let arrTh = tableHeaders.map(item=>{
                    return item.label;
                });


                let arrTd = new Array();
                tableData.forEach(item=>{
                    tableHeaders.forEach(header=>{
                        let prop = header.prop;
                        arrTd.push(item[prop]);
                    });
                });

                // 设置数据
                this.$refs.echart_url.value = chartImage;
                this.$refs.arr_Th.value = arrTh;
                this.$refs.arr_Td.value = arrTd;
                // 导出数据
                this.$refs.Export_Excel.submit();
            },
        }
    }
</script>

 src/pages/reportStatistics/eleMonomer.vue

@@ -96,9 +96,15 @@
        <div class="flex-page-footer" slot="footer">
            <div class="el-pagination-btns">
                <el-button type="primary" round size="mini" @click="serchLowData" icon="el-icon-search">查询</el-button>
                <el-button type="primary" round size="mini" icon="el-icon-wallet">导出</el-button>
                <el-button type="primary" round size="mini" @click="exportExcel" icon="el-icon-wallet">导出</el-button>
            </div>
        </div>
        <form :action="exportUrl" method="post" ref="Export_Excel">
            <input type="hidden" name="PageName" value="eleMonomer.jsp"/>
            <input type="hidden" ref="arr_Th"      name="arr_Th"/>
            <input type="hidden" ref="arr_Td"      name="arr_Td"/>
            <input type="hidden" ref="echart_url" name="echart_url"/>
        </form>
    </flex-layout>
</template>

@@ -140,7 +146,10 @@
            ChartWrapper
        },
        data() {
            let baseURL = this.$axios.defaults.baseURL;
            baseURL = baseURL?baseURL:"";
            return {
                exportUrl: baseURL+"ExportTable.servlet",
                allSelected: true,
                eleAnalysetable: {
                    headers: [{
@@ -869,7 +878,41 @@
                }
                this.chartData = allData;
                this.initChart();
            }
            },
            exportExcel() {
                let tableData = this.eleAnalysetable.datas;
                if(tableData.length == 0) {
                    this.$layer.msg('暂无数据');
                    return;
                }
                // 图表数据
                let chartImage = this.$G.chartManage.get('eleAnalyseChart').getDataURL({
                    pixelRatio: 1,
                    backgroundColor: '#fff'
                });

                // 表格数据
                let tableHeaders = this.eleAnalysetable.headers;
                let arrTh = tableHeaders.map(item=>{
                    return item.label;
                });


                let arrTd = new Array();
                tableData.forEach(item=>{
                    tableHeaders.forEach(header=>{
                        let prop = header.prop;
                        arrTd.push(item[prop]);
                    });
                });

                // 设置数据
                this.$refs.echart_url.value = chartImage;
                this.$refs.arr_Th.value = arrTh;
                this.$refs.arr_Td.value = arrTd;
                // 导出数据
                this.$refs.Export_Excel.submit();
            },
        }
    }
</script>

 src/pages/userMager/baojiMager.vue

@@ -329,6 +329,8 @@
        delBaojiGroup() {
            let name = this.searchParams.baoji_group_name;
            let id = this.searchParams.baoji_group_id;
            console.log(name);
            console.log(id);
            // 请求后台
            this.$apis.userMager.baojiGroup.del(id, name).then(res=>{
                let rs = JSON.parse(res.data.result);