import $ from 'jquery'; import { defaults } from 'lodash'; import { ComponentType } from 'react'; import { isTableData, PanelEvents, PanelPlugin, PanelProps } from '@grafana/data'; import config from 'app/core/config'; import { applyFilterFromTable } from 'app/features/variables/adhoc/actions'; import { MetricsPanelCtrl } from 'app/plugins/sdk'; import { dispatch } from 'app/store/store'; import { columnOptionsTab } from './column_options'; import { tablePanelEditor } from './editor'; import { TableRenderer } from './renderer'; import { transformDataToTable } from './transformers'; export class TablePanelCtrl extends MetricsPanelCtrl { static templateUrl = 'module.html'; pageIndex: number; dataRaw: any; table: any; renderer: any; panelHasRowColorMode: boolean; panelHasLinks: boolean; panelDefaults: any = { targets: [{}], transform: 'timeseries_to_columns', pageSize: null, showHeader: true, styles: [ { type: 'date', pattern: 'Time', alias: 'Time', dateFormat: 'YYYY-MM-DD HH:mm:ss', align: 'auto', }, { unit: 'short', type: 'number', alias: '', decimals: 2, colors: ['rgba(245, 54, 54, 0.9)', 'rgba(237, 129, 40, 0.89)', 'rgba(50, 172, 45, 0.97)'], colorMode: null, pattern: '/.*/', thresholds: [], align: 'right', }, ], columns: [], fontSize: '100%', sort: { col: 0, desc: true }, }; /** @ngInject */ constructor($scope: any, $injector: any, private annotationsSrv: any, private $sanitize: any) { super($scope, $injector); this.pageIndex = 0; if (this.panel.styles === void 0) { this.panel.styles = this.panel.columns; this.panel.columns = this.panel.fields; delete this.panel.columns; delete this.panel.fields; } defaults(this.panel, this.panelDefaults); this.panelHasRowColorMode = Boolean(this.panel.styles.find((style: any) => style.colorMode === 'row')); this.panelHasLinks = Boolean(this.panel.styles.find((style: any) => style.link)); this.events.on(PanelEvents.dataReceived, this.onDataReceived.bind(this)); this.events.on(PanelEvents.dataSnapshotLoad, this.onDataReceived.bind(this)); this.events.on(PanelEvents.editModeInitialized, this.onInitEditMode.bind(this)); } onInitEditMode() { this.addEditorTab('Options', tablePanelEditor, 2); this.addEditorTab('Column Styles', columnOptionsTab, 3); } migrateToPanel(type: string) { this.onPluginTypeChange(config.panels[type]); } issueQueries(datasource: any) { this.pageIndex = 0; if (this.panel.transform === 'annotations') { return this.annotationsSrv .getAnnotations({ dashboard: this.dashboard, panel: this.panel, range: this.range, }) .then((anno: any) => { this.loading = false; this.dataRaw = anno; this.pageIndex = 0; this.render(); return { data: this.dataRaw }; // Not used }); } return super.issueQueries(datasource); } onDataReceived(dataList: any) { this.dataRaw = dataList; this.pageIndex = 0; // automatically correct transform mode based on data if (this.dataRaw && this.dataRaw.length) { if (isTableData(this.dataRaw[0])) { this.panel.transform = 'table'; } else { if (this.dataRaw[0].type === 'docs') { this.panel.transform = 'json'; } else { if (this.panel.transform === 'table' || this.panel.transform === 'json') { this.panel.transform = 'timeseries_to_rows'; } } } } this.render(); } render() { this.table = transformDataToTable(this.dataRaw, this.panel); this.table.sort(this.panel.sort); this.renderer = new TableRenderer( this.panel, this.table, this.dashboard.getTimezone(), this.$sanitize, this.templateSrv, config.theme ); return super.render(this.table); } toggleColumnSort(col: any, colIndex: any) { // remove sort flag from current column if (this.table.columns[this.panel.sort.col]) { this.table.columns[this.panel.sort.col].sort = false; } if (this.panel.sort.col === colIndex) { if (this.panel.sort.desc) { this.panel.sort.desc = false; } else { this.panel.sort.col = null; } } else { this.panel.sort.col = colIndex; this.panel.sort.desc = true; } this.render(); } link(scope: any, elem: JQuery, attrs: any, ctrl: TablePanelCtrl) { let data: any; const panel = ctrl.panel; let pageCount = 0; function getTableHeight() { let panelHeight = ctrl.height; if (pageCount > 1) { panelHeight -= 26; } return panelHeight - 31 + 'px'; } function appendTableRows(tbodyElem: JQuery) { ctrl.renderer.setTable(data); tbodyElem.empty(); tbodyElem.html(ctrl.renderer.render(ctrl.pageIndex)); } function switchPage(e: any) { const el = $(e.currentTarget); ctrl.pageIndex = parseInt(el.text(), 10) - 1; renderPanel(); } function appendPaginationControls(footerElem: JQuery) { footerElem.empty(); const pageSize = panel.pageSize || 100; pageCount = Math.ceil(data.rows.length / pageSize); if (pageCount === 1) { return; } const startPage = Math.max(ctrl.pageIndex - 3, 0); const endPage = Math.min(pageCount, startPage + 9); const paginationList = $('