complex-table.vue 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378
  1. <template>
  2. <div class="app-container">
  3. <div class="filter-container">
  4. <el-input v-model="listQuery.title" :placeholder="$t('table.title')" style="width: 200px;" class="filter-item" @keyup.enter.native="handleFilter" />
  5. <el-select v-model="listQuery.importance" :placeholder="$t('table.importance')" clearable style="width: 90px" class="filter-item">
  6. <el-option v-for="item in importanceOptions" :key="item" :label="item" :value="item" />
  7. </el-select>
  8. <el-select v-model="listQuery.type" :placeholder="$t('table.type')" clearable class="filter-item" style="width: 130px">
  9. <el-option v-for="item in calendarTypeOptions" :key="item.key" :label="item.display_name+'('+item.key+')'" :value="item.key" />
  10. </el-select>
  11. <el-select v-model="listQuery.sort" style="width: 140px" class="filter-item" @change="handleFilter">
  12. <el-option v-for="item in sortOptions" :key="item.key" :label="item.label" :value="item.key" />
  13. </el-select>
  14. <el-button v-waves class="filter-item" type="primary" icon="el-icon-search" @click="handleFilter">
  15. {{ $t('table.search') }}
  16. </el-button>
  17. <el-button class="filter-item" style="margin-left: 10px;" type="primary" icon="el-icon-edit" @click="handleCreate">
  18. {{ $t('table.add') }}
  19. </el-button>
  20. <el-button v-waves :loading="downloadLoading" class="filter-item" type="primary" icon="el-icon-download" @click="handleDownload">
  21. {{ $t('table.export') }}
  22. </el-button>
  23. <el-checkbox v-model="showReviewer" class="filter-item" style="margin-left:15px;" @change="tableKey=tableKey+1">
  24. {{ $t('table.reviewer') }}
  25. </el-checkbox>
  26. </div>
  27. <el-table
  28. :key="tableKey"
  29. v-loading="listLoading"
  30. :data="list"
  31. border
  32. fit
  33. highlight-current-row
  34. style="width: 100%;"
  35. @sort-change="sortChange"
  36. >
  37. <el-table-column :label="$t('table.id')" prop="id" sortable="custom" align="center" width="80" :class-name="getSortClass('id')">
  38. <template slot-scope="{row}">
  39. <span>{{ row.id }}</span>
  40. </template>
  41. </el-table-column>
  42. <el-table-column :label="$t('table.date')" width="150px" align="center">
  43. <template slot-scope="{row}">
  44. <span>{{ row.timestamp | parseTime('{y}-{m}-{d} {h}:{i}') }}</span>
  45. </template>
  46. </el-table-column>
  47. <el-table-column :label="$t('table.title')" min-width="150px">
  48. <template slot-scope="{row}">
  49. <span class="link-type" @click="handleUpdate(row)">{{ row.title }}</span>
  50. <el-tag>{{ row.type | typeFilter }}</el-tag>
  51. </template>
  52. </el-table-column>
  53. <el-table-column :label="$t('table.author')" width="110px" align="center">
  54. <template slot-scope="{row}">
  55. <span>{{ row.author }}</span>
  56. </template>
  57. </el-table-column>
  58. <el-table-column v-if="showReviewer" :label="$t('table.reviewer')" width="110px" align="center">
  59. <template slot-scope="{row}">
  60. <span style="color:red;">{{ row.reviewer }}</span>
  61. </template>
  62. </el-table-column>
  63. <el-table-column :label="$t('table.importance')" width="80px">
  64. <template slot-scope="{row}">
  65. <svg-icon v-for="n in +row.importance" :key="n" icon-class="star" class="meta-item__icon" />
  66. </template>
  67. </el-table-column>
  68. <el-table-column :label="$t('table.readings')" align="center" width="95">
  69. <template slot-scope="{row}">
  70. <span v-if="row.pageviews" class="link-type" @click="handleFetchPv(row.pageviews)">{{ row.pageviews }}</span>
  71. <span v-else>0</span>
  72. </template>
  73. </el-table-column>
  74. <el-table-column :label="$t('table.status')" class-name="status-col" width="100">
  75. <template slot-scope="{row}">
  76. <el-tag :type="row.status | statusFilter">
  77. {{ row.status }}
  78. </el-tag>
  79. </template>
  80. </el-table-column>
  81. <el-table-column :label="$t('table.actions')" align="center" width="230" class-name="small-padding fixed-width">
  82. <template slot-scope="{row,$index}">
  83. <el-button type="primary" size="mini" @click="handleUpdate(row)">
  84. {{ $t('table.edit') }}
  85. </el-button>
  86. <el-button v-if="row.status!='published'" size="mini" type="success" @click="handleModifyStatus(row,'published')">
  87. {{ $t('table.publish') }}
  88. </el-button>
  89. <el-button v-if="row.status!='draft'" size="mini" @click="handleModifyStatus(row,'draft')">
  90. {{ $t('table.draft') }}
  91. </el-button>
  92. <el-button v-if="row.status!='deleted'" size="mini" type="danger" @click="handleDelete(row,$index)">
  93. {{ $t('table.delete') }}
  94. </el-button>
  95. </template>
  96. </el-table-column>
  97. </el-table>
  98. <pagination v-show="total>0" :total="total" :page.sync="listQuery.page" :limit.sync="listQuery.limit" @pagination="getList" />
  99. <el-dialog :title="textMap[dialogStatus]" :visible.sync="dialogFormVisible">
  100. <el-form ref="dataForm" :rules="rules" :model="temp" label-position="left" label-width="70px" style="width: 400px; margin-left:50px;">
  101. <el-form-item :label="$t('table.type')" prop="type">
  102. <el-select v-model="temp.type" class="filter-item" placeholder="Please select">
  103. <el-option v-for="item in calendarTypeOptions" :key="item.key" :label="item.display_name" :value="item.key" />
  104. </el-select>
  105. </el-form-item>
  106. <el-form-item :label="$t('table.date')" prop="timestamp">
  107. <el-date-picker v-model="temp.timestamp" type="datetime" placeholder="Please pick a date" />
  108. </el-form-item>
  109. <el-form-item :label="$t('table.title')" prop="title">
  110. <el-input v-model="temp.title" />
  111. </el-form-item>
  112. <el-form-item :label="$t('table.status')">
  113. <el-select v-model="temp.status" class="filter-item" placeholder="Please select">
  114. <el-option v-for="item in statusOptions" :key="item" :label="item" :value="item" />
  115. </el-select>
  116. </el-form-item>
  117. <el-form-item :label="$t('table.importance')">
  118. <el-rate v-model="temp.importance" :colors="['#99A9BF', '#F7BA2A', '#FF9900']" :max="3" style="margin-top:8px;" />
  119. </el-form-item>
  120. <el-form-item :label="$t('table.remark')">
  121. <el-input v-model="temp.remark" :autosize="{ minRows: 2, maxRows: 4}" type="textarea" placeholder="Please input" />
  122. </el-form-item>
  123. </el-form>
  124. <div slot="footer" class="dialog-footer">
  125. <el-button @click="dialogFormVisible = false">
  126. {{ $t('table.cancel') }}
  127. </el-button>
  128. <el-button type="primary" @click="dialogStatus==='create'?createData():updateData()">
  129. {{ $t('table.confirm') }}
  130. </el-button>
  131. </div>
  132. </el-dialog>
  133. <el-dialog :visible.sync="dialogPvVisible" title="Reading statistics">
  134. <el-table :data="pvData" border fit highlight-current-row style="width: 100%">
  135. <el-table-column prop="key" label="Channel" />
  136. <el-table-column prop="pv" label="Pv" />
  137. </el-table>
  138. <span slot="footer" class="dialog-footer">
  139. <el-button type="primary" @click="dialogPvVisible = false">{{ $t('table.confirm') }}</el-button>
  140. </span>
  141. </el-dialog>
  142. </div>
  143. </template>
  144. <script>
  145. import waves from '@/directive/waves' // waves directive
  146. import { parseTime } from '@/utils'
  147. import Pagination from '@/components/Pagination' // secondary package based on el-pagination
  148. const calendarTypeOptions = [
  149. { key: 'CN', display_name: 'China' },
  150. { key: 'US', display_name: 'USA' },
  151. { key: 'JP', display_name: 'Japan' },
  152. { key: 'EU', display_name: 'Eurozone' }
  153. ]
  154. // arr to obj, such as { CN : "China", US : "USA" }
  155. const calendarTypeKeyValue = calendarTypeOptions.reduce((acc, cur) => {
  156. acc[cur.key] = cur.display_name
  157. return acc
  158. }, {})
  159. export default {
  160. name: 'ComplexTable',
  161. components: { Pagination },
  162. directives: { waves },
  163. filters: {
  164. statusFilter(status) {
  165. const statusMap = {
  166. published: 'success',
  167. draft: 'info',
  168. deleted: 'danger'
  169. }
  170. return statusMap[status]
  171. },
  172. typeFilter(type) {
  173. return calendarTypeKeyValue[type]
  174. }
  175. },
  176. data() {
  177. return {
  178. tableKey: 0,
  179. list: null,
  180. total: 0,
  181. listLoading: true,
  182. listQuery: {
  183. page: 1,
  184. limit: 20,
  185. importance: undefined,
  186. title: undefined,
  187. type: undefined,
  188. sort: '+id'
  189. },
  190. importanceOptions: [1, 2, 3],
  191. calendarTypeOptions,
  192. sortOptions: [{ label: 'ID Ascending', key: '+id' }, { label: 'ID Descending', key: '-id' }],
  193. statusOptions: ['published', 'draft', 'deleted'],
  194. showReviewer: false,
  195. temp: {
  196. id: undefined,
  197. importance: 1,
  198. remark: '',
  199. timestamp: new Date(),
  200. title: '',
  201. type: '',
  202. status: 'published'
  203. },
  204. dialogFormVisible: false,
  205. dialogStatus: '',
  206. textMap: {
  207. update: 'Edit',
  208. create: 'Create'
  209. },
  210. dialogPvVisible: false,
  211. pvData: [],
  212. rules: {
  213. type: [{ required: true, message: 'type is required', trigger: 'change' }],
  214. timestamp: [{ type: 'date', required: true, message: 'timestamp is required', trigger: 'change' }],
  215. title: [{ required: true, message: 'title is required', trigger: 'blur' }]
  216. },
  217. downloadLoading: false
  218. }
  219. },
  220. created() {
  221. this.getList()
  222. },
  223. methods: {
  224. getList() {
  225. this.listLoading = true
  226. // fetchList(this.listQuery).then(response => {
  227. // this.list = response.data.items
  228. // this.total = response.data.total
  229. //
  230. // // Just to simulate the time of the request
  231. // setTimeout(() => {
  232. // this.listLoading = false
  233. // }, 1.5 * 1000)
  234. // })
  235. },
  236. handleFilter() {
  237. this.listQuery.page = 1
  238. this.getList()
  239. },
  240. handleModifyStatus(row, status) {
  241. this.$message({
  242. message: '操作成功',
  243. type: 'success'
  244. })
  245. row.status = status
  246. },
  247. sortChange(data) {
  248. const { prop, order } = data
  249. if (prop === 'id') {
  250. this.sortByID(order)
  251. }
  252. },
  253. sortByID(order) {
  254. if (order === 'ascending') {
  255. this.listQuery.sort = '+id'
  256. } else {
  257. this.listQuery.sort = '-id'
  258. }
  259. this.handleFilter()
  260. },
  261. resetTemp() {
  262. this.temp = {
  263. id: undefined,
  264. importance: 1,
  265. remark: '',
  266. timestamp: new Date(),
  267. title: '',
  268. status: 'published',
  269. type: ''
  270. }
  271. },
  272. handleCreate() {
  273. this.resetTemp()
  274. this.dialogStatus = 'create'
  275. this.dialogFormVisible = true
  276. this.$nextTick(() => {
  277. this.$refs['dataForm'].clearValidate()
  278. })
  279. },
  280. createData() {
  281. this.$refs['dataForm'].validate((valid) => {
  282. if (valid) {
  283. this.temp.id = parseInt(Math.random() * 100) + 1024 // mock a id
  284. this.temp.author = 'vue-element-admin'
  285. // createArticle(this.temp).then(() => {
  286. // this.list.unshift(this.temp)
  287. // this.dialogFormVisible = false
  288. // this.$notify({
  289. // title: '成功',
  290. // message: '创建成功',
  291. // type: 'success',
  292. // duration: 2000
  293. // })
  294. // })
  295. }
  296. })
  297. },
  298. handleUpdate(row) {
  299. this.temp = Object.assign({}, row) // copy obj
  300. this.temp.timestamp = new Date(this.temp.timestamp)
  301. this.dialogStatus = 'update'
  302. this.dialogFormVisible = true
  303. this.$nextTick(() => {
  304. this.$refs['dataForm'].clearValidate()
  305. })
  306. },
  307. updateData() {
  308. this.$refs['dataForm'].validate((valid) => {
  309. if (valid) {
  310. const tempData = Object.assign({}, this.temp)
  311. tempData.timestamp = +new Date(tempData.timestamp) // change Thu Nov 30 2017 16:41:05 GMT+0800 (CST) to 1512031311464
  312. // updateArticle(tempData).then(() => {
  313. // const index = this.list.findIndex(v => v.id === this.temp.id)
  314. // this.list.splice(index, 1, this.temp)
  315. // this.dialogFormVisible = false
  316. // this.$notify({
  317. // title: '成功',
  318. // message: '更新成功',
  319. // type: 'success',
  320. // duration: 2000
  321. // })
  322. // })
  323. }
  324. })
  325. },
  326. handleDelete(row, index) {
  327. this.$notify({
  328. title: '成功',
  329. message: '删除成功',
  330. type: 'success',
  331. duration: 2000
  332. })
  333. this.list.splice(index, 1)
  334. },
  335. handleFetchPv(pv) {
  336. // fetchPv(pv).then(response => {
  337. // this.pvData = response.data.pvData
  338. // this.dialogPvVisible = true
  339. // })
  340. },
  341. handleDownload() {
  342. this.downloadLoading = true
  343. import('@/vendor/Export2Excel').then(excel => {
  344. const tHeader = ['timestamp', 'title', 'type', 'importance', 'status']
  345. const filterVal = ['timestamp', 'title', 'type', 'importance', 'status']
  346. const data = this.formatJson(filterVal)
  347. excel.export_json_to_excel({
  348. header: tHeader,
  349. data,
  350. filename: 'table-list'
  351. })
  352. this.downloadLoading = false
  353. })
  354. },
  355. formatJson(filterVal) {
  356. return this.list.map(v => filterVal.map(j => {
  357. if (j === 'timestamp') {
  358. return parseTime(v[j])
  359. } else {
  360. return v[j]
  361. }
  362. }))
  363. },
  364. getSortClass: function(key) {
  365. const sort = this.listQuery.sort
  366. return sort === `+${key}` ? 'ascending' : 'descending'
  367. }
  368. }
  369. }
  370. </script>