/** * @author zhixin wen * extensions: https://github.com/hhurz/tableExport.jquery.plugin */ const Utils = $.fn.bootstrapTable.utils const TYPE_NAME = { json: 'JSON', xml: 'XML', png: 'PNG', csv: 'CSV', txt: 'TXT', sql: 'SQL', doc: 'MS-Word', excel: 'MS-Excel', xlsx: 'MS-Excel (OpenXML)', powerpoint: 'MS-Powerpoint', pdf: 'PDF' } $.extend($.fn.bootstrapTable.defaults, { showExport: false, exportDataType: 'basic', // basic, all, selected exportTypes: ['json', 'xml', 'csv', 'txt', 'sql', 'excel'], exportOptions: { onCellHtmlData: function (cell, rowIndex, colIndex, htmlData) { if (cell.is('th')) { return cell.find('.th-inner').text() } return htmlData } }, exportFooter: false }) $.extend($.fn.bootstrapTable.defaults.icons, { export: { bootstrap3: 'glyphicon-export icon-share', materialize: 'file_download' }[$.fn.bootstrapTable.theme] || 'fa-download' }) $.extend($.fn.bootstrapTable.locales, { formatExport () { return 'Export data' } }) $.extend($.fn.bootstrapTable.defaults, $.fn.bootstrapTable.locales) $.fn.bootstrapTable.methods.push('exportTable') $.extend($.fn.bootstrapTable.defaults, { onExportSaved (exportedRows) { return false } }) $.extend($.fn.bootstrapTable.Constructor.EVENTS, { 'export-saved.bs.table': 'onExportSaved' }) $.BootstrapTable = class extends $.BootstrapTable { initToolbar (...args) { const o = this.options this.showToolbar = this.showToolbar || o.showExport super.initToolbar(...args) if (!this.options.showExport) { return } const $btnGroup = this.$toolbar.find('>.columns') this.$export = $btnGroup.find('div.export') if (this.$export.length) { this.updateExportButton() return } let $menu = $(this.constants.html.pageDropdown.join('')) this.$export = $(`
`).appendTo($btnGroup) this.$export.append($menu) this.updateExportButton() let exportTypes = o.exportTypes if (typeof exportTypes === 'string') { const types = exportTypes.slice(1, -1).replace(/ /g, '').split(',') exportTypes = types.map(t => t.slice(1, -1)) } // themes support if ($menu.children().length) { $menu = $menu.children().eq(0) } for (const type of exportTypes) { if (TYPE_NAME.hasOwnProperty(type)) { const $item = $(Utils.sprintf(this.constants.html.pageDropdownItem, '', TYPE_NAME[type])) $item.attr('data-type', type) $menu.append($item) } } $menu.children().click(e => { e.preventDefault() const type = $(e.currentTarget).data('type') const exportOptions = { type, escape: false } this.exportTable(exportOptions) }) this.handleToolbar() } handleToolbar () { if (!this.$export) { return } if ($.fn.bootstrapTable.theme === 'foundation') { this.$export.find('.dropdown-pane').attr('id', 'toolbar-export-id') } else if ($.fn.bootstrapTable.theme === 'materialize') { this.$export.find('.dropdown-content').attr('id', 'toolbar-export-id') } if (super.handleToolbar) { super.handleToolbar() } } exportTable (options) { const o = this.options const stateField = this.header.stateField const isCardView = o.cardView const doExport = callback => { if (stateField) { this.hideColumn(stateField) } if (isCardView) { this.toggleView() } const data = this.getData() if (o.exportFooter) { const $footerRow = this.$tableFooter.find('tr').first() const footerData = {} const footerHtml = [] $.each($footerRow.children(), (index, footerCell) => { const footerCellHtml = $(footerCell).children('.th-inner').first().html() footerData[this.columns[index].field] = footerCellHtml === ' ' ? null : footerCellHtml // grab footer cell text into cell index-based array footerHtml.push(footerCellHtml) }) this.append(footerData) const $lastTableRow = this.$body.children().last() $.each($lastTableRow.children(), (index, lastTableRowCell) => { $(lastTableRowCell).html(footerHtml[index]) }) } this.$el.tableExport($.extend({ onAfterSaveToFile: () => { if (o.exportFooter) { this.load(data) } if (stateField) { this.showColumn(stateField) } if (isCardView) { this.toggleView() } if (callback) callback() } }, o.exportOptions, options)) } if (o.exportDataType === 'all' && o.pagination) { const eventName = o.sidePagination === 'server' ? 'post-body.bs.table' : 'page-change.bs.table' this.$el.one(eventName, () => { doExport(() => { this.virtualScrollDisabled = false this.togglePagination() }) }) this.virtualScrollDisabled = true this.togglePagination() this.trigger('export-saved', this.getData()) } else if (o.exportDataType === 'selected') { let data = this.getData() let selectedData = this.getSelections() if (!selectedData.length) { return } if (o.sidePagination === 'server') { data = { total: o.totalRows, [this.options.dataField]: data } selectedData = { total: selectedData.length, [this.options.dataField]: selectedData } } this.load(selectedData) doExport(() => { this.load(data) }) this.trigger('export-saved', selectedData) } else { doExport() this.trigger('export-saved', this.getData(true)) } } updateSelected () { super.updateSelected() this.updateExportButton() } updateExportButton () { if (this.options.exportDataType === 'selected') { this.$export.find('> button') .prop('disabled', !this.getSelections().length) } } }