Adam / gulu-admin

Blame view

src/views/excel/merge-header.vue 2.83 KB
edit raw normal view history
d7d9c38c2   Adam   auto commit the c... 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
 
  <template>
    <div class="app-container">
  
      <el-button :loading="downloadLoading" style="margin-bottom:20px" type="primary" icon="el-icon-document" @click="handleDownload">Export</el-button>
  
      <el-table
        ref="multipleTable"
        v-loading="listLoading"
        :data="list"
        element-loading-text="Loading"
        border
        fit
        highlight-current-row
      >
        <el-table-column align="center" label="Id" width="95">
          <template slot-scope="scope">
            {{ scope.$index }}
          </template>
        </el-table-column>
        <el-table-column label="Main Information" align="center">
          <el-table-column label="Title">
            <template slot-scope="scope">
              {{ scope.row.title }}
            </template>
          </el-table-column>
          <el-table-column label="Author" width="110" align="center">
            <template slot-scope="scope">
              <el-tag>{{ scope.row.author }}</el-tag>
            </template>
          </el-table-column>
          <el-table-column label="Readings" width="115" align="center">
            <template slot-scope="scope">
              {{ scope.row.pageviews }}
            </template>
          </el-table-column>
        </el-table-column>
        <el-table-column align="center" label="Date" width="220">
          <template slot-scope="scope">
            <i class="el-icon-time" />
            <span>{{ scope.row.timestamp | parseTime('{y}-{m}-{d} {h}:{i}') }}</span>
          </template>
        </el-table-column>
      </el-table>
  
    </div>
  </template>
  
  <script>
  import { fetchList } from '@/api/article'
  import { parseTime } from '@/utils'
  
  export default {
    name: 'MergeHeader',
    data() {
      return {
        list: null,
        listLoading: true,
        downloadLoading: false
      }
    },
    created() {
      this.fetchData()
    },
    methods: {
      fetchData() {
        this.listLoading = true
        fetchList(this.listQuery).then(response => {
          this.list = response.data.items
          this.listLoading = false
        })
      },
      handleDownload() {
        this.downloadLoading = true
          import('@/vendor/Export2Excel').then(excel => {
            const multiHeader = [['Id', 'Main Information', '', '', 'Date']]
            const header = ['', 'Title', 'Author', 'Readings', '']
            const filterVal = ['id', 'title', 'author', 'pageviews', 'display_time']
            const list = this.list
            const data = this.formatJson(filterVal, list)
            const merges = ['A1:A2', 'B1:D1', 'E1:E2']
            excel.export_json_to_excel({
              multiHeader,
              header,
              merges,
              data
            })
            this.downloadLoading = false
          })
      },
      formatJson(filterVal, jsonData) {
        return jsonData.map(v => filterVal.map(j => {
          if (j === 'timestamp') {
            return parseTime(v[j])
          } else {
            return v[j]
          }
        }))
      }
    }
  }
  </script>