File manager - Edit - /home/newsbmcs.com/public_html/static/img/logo/chart.js.tar
Back
usr/local/CyberCP/public/phpmyadmin/js/dist/chart.js 0000644 00000041240 15030147167 0016405 0 ustar 00 /** * Chart type enumerations */ var ChartType = { LINE: 'line', SPLINE: 'spline', AREA: 'area', BAR: 'bar', COLUMN: 'column', PIE: 'pie', TIMELINE: 'timeline', SCATTER: 'scatter' }; /** * Column type enumeration */ var ColumnType = { STRING: 'string', NUMBER: 'number', BOOLEAN: 'boolean', DATE: 'date' }; /** * Abstract chart factory which defines the contract for chart factories */ var ChartFactory = function () {}; ChartFactory.prototype = { createChart: function () { throw new Error('createChart must be implemented by a subclass'); } }; /** * Abstract chart which defines the contract for charts * * @param elementId * id of the div element the chart is drawn in */ var Chart = function (elementId) { this.elementId = elementId; }; Chart.prototype = { draw: function () { throw new Error('draw must be implemented by a subclass'); }, redraw: function () { throw new Error('redraw must be implemented by a subclass'); }, destroy: function () { throw new Error('destroy must be implemented by a subclass'); }, toImageString: function () { throw new Error('toImageString must be implemented by a subclass'); } }; /** * Abstract representation of charts that operates on DataTable where,<br> * <ul> * <li>First column provides index to the data.</li> * <li>Each subsequent columns are of type * <code>ColumnType.NUMBER<code> and represents a data series.</li> * </ul> * Line chart, area chart, bar chart, column chart are typical examples. * * @param elementId * id of the div element the chart is drawn in */ var BaseChart = function (elementId) { Chart.call(this, elementId); }; BaseChart.prototype = new Chart(); BaseChart.prototype.constructor = BaseChart; BaseChart.prototype.validateColumns = function (dataTable) { var columns = dataTable.getColumns(); if (columns.length < 2) { throw new Error('Minimum of two columns are required for this chart'); } for (var i = 1; i < columns.length; i++) { if (columns[i].type !== ColumnType.NUMBER) { throw new Error('Column ' + (i + 1) + ' should be of type \'Number\''); } } return true; }; /** * Abstract pie chart * * @param elementId * id of the div element the chart is drawn in */ var PieChart = function (elementId) { BaseChart.call(this, elementId); }; PieChart.prototype = new BaseChart(); PieChart.prototype.constructor = PieChart; PieChart.prototype.validateColumns = function (dataTable) { var columns = dataTable.getColumns(); if (columns.length > 2) { throw new Error('Pie charts can draw only one series'); } return BaseChart.prototype.validateColumns.call(this, dataTable); }; /** * Abstract timeline chart * * @param elementId * id of the div element the chart is drawn in */ var TimelineChart = function (elementId) { BaseChart.call(this, elementId); }; TimelineChart.prototype = new BaseChart(); TimelineChart.prototype.constructor = TimelineChart; TimelineChart.prototype.validateColumns = function (dataTable) { var result = BaseChart.prototype.validateColumns.call(this, dataTable); if (result) { var columns = dataTable.getColumns(); if (columns[0].type !== ColumnType.DATE) { throw new Error('First column of timeline chart need to be a date column'); } } return result; }; /** * Abstract scatter chart * * @param elementId * id of the div element the chart is drawn in */ var ScatterChart = function (elementId) { BaseChart.call(this, elementId); }; ScatterChart.prototype = new BaseChart(); ScatterChart.prototype.constructor = ScatterChart; ScatterChart.prototype.validateColumns = function (dataTable) { var result = BaseChart.prototype.validateColumns.call(this, dataTable); if (result) { var columns = dataTable.getColumns(); if (columns[0].type !== ColumnType.NUMBER) { throw new Error('First column of scatter chart need to be a numeric column'); } } return result; }; /** * The data table contains column information and data for the chart. */ // eslint-disable-next-line no-unused-vars var DataTable = function () { var columns = []; var data = null; this.addColumn = function (type, name) { columns.push({ 'type': type, 'name': name }); }; this.getColumns = function () { return columns; }; this.setData = function (rows) { data = rows; fillMissingValues(); }; this.getData = function () { return data; }; var fillMissingValues = function () { if (columns.length === 0) { throw new Error('Set columns first'); } var row; for (var i = 0; i < data.length; i++) { row = data[i]; if (row.length > columns.length) { row.splice(columns.length - 1, row.length - columns.length); } else if (row.length < columns.length) { for (var j = row.length; j < columns.length; j++) { row.push(null); } } } }; }; /** ***************************************************************************** * JQPlot specific code ******************************************************************************/ /** * Abstract JQplot chart * * @param elementId * id of the div element the chart is drawn in */ var JQPlotChart = function (elementId) { Chart.call(this, elementId); this.plot = null; this.validator = null; }; JQPlotChart.prototype = new Chart(); JQPlotChart.prototype.constructor = JQPlotChart; JQPlotChart.prototype.draw = function (data, options) { if (this.validator.validateColumns(data)) { this.plot = $.jqplot(this.elementId, this.prepareData(data), this.populateOptions(data, options)); } }; JQPlotChart.prototype.destroy = function () { if (this.plot !== null) { this.plot.destroy(); } }; JQPlotChart.prototype.redraw = function (options) { if (this.plot !== null) { this.plot.replot(options); } }; JQPlotChart.prototype.toImageString = function () { if (this.plot !== null) { return $('#' + this.elementId).jqplotToImageStr({}); } }; JQPlotChart.prototype.populateOptions = function () { throw new Error('populateOptions must be implemented by a subclass'); }; JQPlotChart.prototype.prepareData = function () { throw new Error('prepareData must be implemented by a subclass'); }; /** * JQPlot line chart * * @param elementId * id of the div element the chart is drawn in */ var JQPlotLineChart = function (elementId) { JQPlotChart.call(this, elementId); this.validator = BaseChart.prototype; }; JQPlotLineChart.prototype = new JQPlotChart(); JQPlotLineChart.prototype.constructor = JQPlotLineChart; JQPlotLineChart.prototype.populateOptions = function (dataTable, options) { var columns = dataTable.getColumns(); var optional = { axes: { xaxis: { label: columns[0].name, renderer: $.jqplot.CategoryAxisRenderer, ticks: [] }, yaxis: { label: columns.length === 2 ? columns[1].name : 'Values', labelRenderer: $.jqplot.CanvasAxisLabelRenderer } }, highlighter: { show: true, tooltipAxes: 'y', formatString: '%d' }, series: [] }; $.extend(true, optional, options); if (optional.series.length === 0) { for (var i = 1; i < columns.length; i++) { optional.series.push({ label: columns[i].name.toString() }); } } if (optional.axes.xaxis.ticks.length === 0) { var data = dataTable.getData(); for (var j = 0; j < data.length; j++) { optional.axes.xaxis.ticks.push(data[j][0].toString()); } } return optional; }; JQPlotLineChart.prototype.prepareData = function (dataTable) { var data = dataTable.getData(); var row; var retData = []; var retRow; for (var i = 0; i < data.length; i++) { row = data[i]; for (var j = 1; j < row.length; j++) { retRow = retData[j - 1]; if (retRow === undefined) { retRow = []; retData[j - 1] = retRow; } retRow.push(row[j]); } } return retData; }; /** * JQPlot spline chart * * @param elementId * id of the div element the chart is drawn in */ var JQPlotSplineChart = function (elementId) { JQPlotLineChart.call(this, elementId); }; JQPlotSplineChart.prototype = new JQPlotLineChart(); JQPlotSplineChart.prototype.constructor = JQPlotSplineChart; JQPlotSplineChart.prototype.populateOptions = function (dataTable, options) { var optional = {}; var opt = JQPlotLineChart.prototype.populateOptions.call(this, dataTable, options); var compulsory = { seriesDefaults: { rendererOptions: { smooth: true } } }; $.extend(true, optional, opt, compulsory); return optional; }; /** * JQPlot scatter chart * * @param elementId * id of the div element the chart is drawn in */ var JQPlotScatterChart = function (elementId) { JQPlotChart.call(this, elementId); this.validator = ScatterChart.prototype; }; JQPlotScatterChart.prototype = new JQPlotChart(); JQPlotScatterChart.prototype.constructor = JQPlotScatterChart; JQPlotScatterChart.prototype.populateOptions = function (dataTable, options) { var columns = dataTable.getColumns(); var optional = { axes: { xaxis: { label: columns[0].name }, yaxis: { label: columns.length === 2 ? columns[1].name : 'Values', labelRenderer: $.jqplot.CanvasAxisLabelRenderer } }, highlighter: { show: true, tooltipAxes: 'xy', formatString: '%d, %d' }, series: [] }; for (var i = 1; i < columns.length; i++) { optional.series.push({ label: columns[i].name.toString() }); } var compulsory = { seriesDefaults: { showLine: false, markerOptions: { size: 7, style: 'x' } } }; $.extend(true, optional, options, compulsory); return optional; }; JQPlotScatterChart.prototype.prepareData = function (dataTable) { var data = dataTable.getData(); var row; var retData = []; var retRow; for (var i = 0; i < data.length; i++) { row = data[i]; if (row[0]) { for (var j = 1; j < row.length; j++) { retRow = retData[j - 1]; if (retRow === undefined) { retRow = []; retData[j - 1] = retRow; } retRow.push([row[0], row[j]]); } } } return retData; }; /** * JQPlot timeline chart * * @param elementId * id of the div element the chart is drawn in */ var JQPlotTimelineChart = function (elementId) { JQPlotLineChart.call(this, elementId); this.validator = TimelineChart.prototype; }; JQPlotTimelineChart.prototype = new JQPlotLineChart(); JQPlotTimelineChart.prototype.constructor = JQPlotTimelineChart; JQPlotTimelineChart.prototype.populateOptions = function (dataTable, options) { var optional = { axes: { xaxis: { tickOptions: { formatString: '%b %#d, %y' } } } }; var opt = JQPlotLineChart.prototype.populateOptions.call(this, dataTable, options); var compulsory = { axes: { xaxis: { renderer: $.jqplot.DateAxisRenderer } } }; $.extend(true, optional, opt, compulsory); return optional; }; JQPlotTimelineChart.prototype.prepareData = function (dataTable) { var data = dataTable.getData(); var row; var d; var retData = []; var retRow; for (var i = 0; i < data.length; i++) { row = data[i]; d = row[0]; for (var j = 1; j < row.length; j++) { retRow = retData[j - 1]; if (retRow === undefined) { retRow = []; retData[j - 1] = retRow; } // See https://github.com/phpmyadmin/phpmyadmin/issues/14395 for the block if (d !== null && typeof d === 'object') { retRow.push([d.getTime(), row[j]]); } else if (typeof d === 'string') { d = new Date(d); retRow.push([d.getTime(), row[j]]); } } } return retData; }; /** * JQPlot area chart * * @param elementId * id of the div element the chart is drawn in */ var JQPlotAreaChart = function (elementId) { JQPlotLineChart.call(this, elementId); }; JQPlotAreaChart.prototype = new JQPlotLineChart(); JQPlotAreaChart.prototype.constructor = JQPlotAreaChart; JQPlotAreaChart.prototype.populateOptions = function (dataTable, options) { var optional = { seriesDefaults: { fillToZero: true } }; var opt = JQPlotLineChart.prototype.populateOptions.call(this, dataTable, options); var compulsory = { seriesDefaults: { fill: true } }; $.extend(true, optional, opt, compulsory); return optional; }; /** * JQPlot column chart * * @param elementId * id of the div element the chart is drawn in */ var JQPlotColumnChart = function (elementId) { JQPlotLineChart.call(this, elementId); }; JQPlotColumnChart.prototype = new JQPlotLineChart(); JQPlotColumnChart.prototype.constructor = JQPlotColumnChart; JQPlotColumnChart.prototype.populateOptions = function (dataTable, options) { var optional = { seriesDefaults: { fillToZero: true } }; var opt = JQPlotLineChart.prototype.populateOptions.call(this, dataTable, options); var compulsory = { seriesDefaults: { renderer: $.jqplot.BarRenderer } }; $.extend(true, optional, opt, compulsory); return optional; }; /** * JQPlot bar chart * * @param elementId * id of the div element the chart is drawn in */ var JQPlotBarChart = function (elementId) { JQPlotLineChart.call(this, elementId); }; JQPlotBarChart.prototype = new JQPlotLineChart(); JQPlotBarChart.prototype.constructor = JQPlotBarChart; JQPlotBarChart.prototype.populateOptions = function (dataTable, options) { var columns = dataTable.getColumns(); var optional = { axes: { yaxis: { label: columns[0].name, labelRenderer: $.jqplot.CanvasAxisLabelRenderer, renderer: $.jqplot.CategoryAxisRenderer, ticks: [] }, xaxis: { label: columns.length === 2 ? columns[1].name : 'Values', labelRenderer: $.jqplot.CanvasAxisLabelRenderer } }, highlighter: { show: true, tooltipAxes: 'x', formatString: '%d' }, series: [], seriesDefaults: { fillToZero: true } }; var compulsory = { seriesDefaults: { renderer: $.jqplot.BarRenderer, rendererOptions: { barDirection: 'horizontal' } } }; $.extend(true, optional, options, compulsory); if (optional.axes.yaxis.ticks.length === 0) { var data = dataTable.getData(); for (var i = 0; i < data.length; i++) { optional.axes.yaxis.ticks.push(data[i][0].toString()); } } if (optional.series.length === 0) { for (var j = 1; j < columns.length; j++) { optional.series.push({ label: columns[j].name.toString() }); } } return optional; }; /** * JQPlot pie chart * * @param elementId * id of the div element the chart is drawn in */ var JQPlotPieChart = function (elementId) { JQPlotChart.call(this, elementId); this.validator = PieChart.prototype; }; JQPlotPieChart.prototype = new JQPlotChart(); JQPlotPieChart.prototype.constructor = JQPlotPieChart; JQPlotPieChart.prototype.populateOptions = function (dataTable, options) { var optional = { highlighter: { show: true, tooltipAxes: 'xy', formatString: '%s, %d', useAxesFormatters: false }, legend: { renderer: $.jqplot.EnhancedPieLegendRenderer } }; var compulsory = { seriesDefaults: { shadow: false, renderer: $.jqplot.PieRenderer, rendererOptions: { sliceMargin: 1, showDataLabels: true } } }; $.extend(true, optional, options, compulsory); return optional; }; JQPlotPieChart.prototype.prepareData = function (dataTable) { var data = dataTable.getData(); var row; var retData = []; for (var i = 0; i < data.length; i++) { row = data[i]; retData.push([row[0], row[1]]); } return [retData]; }; /** * Chart factory that returns JQPlotCharts */ var JQPlotChartFactory = function () {}; JQPlotChartFactory.prototype = new ChartFactory(); JQPlotChartFactory.prototype.createChart = function (type, elementId) { var chart = null; switch (type) { case ChartType.LINE: chart = new JQPlotLineChart(elementId); break; case ChartType.SPLINE: chart = new JQPlotSplineChart(elementId); break; case ChartType.TIMELINE: chart = new JQPlotTimelineChart(elementId); break; case ChartType.AREA: chart = new JQPlotAreaChart(elementId); break; case ChartType.BAR: chart = new JQPlotBarChart(elementId); break; case ChartType.COLUMN: chart = new JQPlotColumnChart(elementId); break; case ChartType.PIE: chart = new JQPlotPieChart(elementId); break; case ChartType.SCATTER: chart = new JQPlotScatterChart(elementId); break; } return chart; }; usr/local/CyberCP/public/phpmyadmin/js/dist/table/chart.js 0000644 00000031051 15030164001 0017455 0 ustar 00 /* global ColumnType, DataTable, JQPlotChartFactory */ // js/chart.js /* global codeMirrorEditor */ // js/functions.js var chartData = {}; var tempChartTitle; var currentChart = null; var currentSettings = null; var dateTimeCols = []; var numericCols = []; function extractDate(dateString) { var matches; var match; var dateTimeRegExp = /[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}/; var dateRegExp = /[0-9]{4}-[0-9]{2}-[0-9]{2}/; matches = dateTimeRegExp.exec(dateString); if (matches !== null && matches.length > 0) { match = matches[0]; return new Date(match.substr(0, 4), parseInt(match.substr(5, 2), 10) - 1, match.substr(8, 2), match.substr(11, 2), match.substr(14, 2), match.substr(17, 2)); } else { matches = dateRegExp.exec(dateString); if (matches !== null && matches.length > 0) { match = matches[0]; return new Date(match.substr(0, 4), parseInt(match.substr(5, 2), 10) - 1, match.substr(8, 2)); } } return null; } function queryChart(data, columnNames, settings) { if ($('#querychart').length === 0) { return; } var plotSettings = { title: { text: settings.title, escapeHtml: true }, grid: { drawBorder: false, shadow: false, background: 'rgba(0,0,0,0)' }, legend: { show: true, placement: 'outsideGrid', location: 'e', rendererOptions: { numberColumns: 2 } }, axes: { xaxis: { label: Functions.escapeHtml(settings.xaxisLabel) }, yaxis: { label: settings.yaxisLabel } }, stackSeries: settings.stackSeries }; // create the chart var factory = new JQPlotChartFactory(); var chart = factory.createChart(settings.type, 'querychart'); // create the data table and add columns var dataTable = new DataTable(); if (settings.type === 'timeline') { dataTable.addColumn(ColumnType.DATE, columnNames[settings.mainAxis]); } else if (settings.type === 'scatter') { dataTable.addColumn(ColumnType.NUMBER, columnNames[settings.mainAxis]); } else { dataTable.addColumn(ColumnType.STRING, columnNames[settings.mainAxis]); } var i; var values = []; if (settings.seriesColumn === null) { $.each(settings.selectedSeries, function (index, element) { dataTable.addColumn(ColumnType.NUMBER, columnNames[element]); }); // set data to the data table var columnsToExtract = [settings.mainAxis]; $.each(settings.selectedSeries, function (index, element) { columnsToExtract.push(element); }); var newRow; var row; var col; for (i = 0; i < data.length; i++) { row = data[i]; newRow = []; for (var j = 0; j < columnsToExtract.length; j++) { col = columnNames[columnsToExtract[j]]; if (j === 0) { if (settings.type === 'timeline') { // first column is date type newRow.push(extractDate(row[col])); } else if (settings.type === 'scatter') { newRow.push(parseFloat(row[col])); } else { // first column is string type newRow.push(row[col]); } } else { // subsequent columns are of type, number newRow.push(parseFloat(row[col])); } } values.push(newRow); } dataTable.setData(values); } else { var seriesNames = {}; var seriesNumber = 1; var seriesColumnName = columnNames[settings.seriesColumn]; for (i = 0; i < data.length; i++) { if (!seriesNames[data[i][seriesColumnName]]) { seriesNames[data[i][seriesColumnName]] = seriesNumber; seriesNumber++; } } $.each(seriesNames, function (seriesName) { dataTable.addColumn(ColumnType.NUMBER, seriesName); }); var valueMap = {}; var xValue; var value; var mainAxisName = columnNames[settings.mainAxis]; var valueColumnName = columnNames[settings.valueColumn]; for (i = 0; i < data.length; i++) { xValue = data[i][mainAxisName]; value = valueMap[xValue]; if (!value) { value = [xValue]; valueMap[xValue] = value; } seriesNumber = seriesNames[data[i][seriesColumnName]]; value[seriesNumber] = parseFloat(data[i][valueColumnName]); } $.each(valueMap, function (index, value) { values.push(value); }); dataTable.setData(values); } // draw the chart and return the chart object chart.draw(dataTable, plotSettings); return chart; } function drawChart() { currentSettings.width = $('#resizer').width() - 20; currentSettings.height = $('#resizer').height() - 20; // TODO: a better way using .redraw() ? if (currentChart !== null) { currentChart.destroy(); } var columnNames = []; $('#chartXAxisSelect option').each(function () { columnNames.push(Functions.escapeHtml($(this).text())); }); try { currentChart = queryChart(chartData, columnNames, currentSettings); if (currentChart !== null) { $('#saveChart').attr('href', currentChart.toImageString()); } } catch (err) { Functions.ajaxShowMessage(err.message, false); } } function getSelectedSeries() { var val = $('#chartSeriesSelect').val() || []; var ret = []; $.each(val, function (i, v) { ret.push(parseInt(v, 10)); }); return ret; } function onXAxisChange() { var $xAxisSelect = $('#chartXAxisSelect'); currentSettings.mainAxis = parseInt($xAxisSelect.val(), 10); if (dateTimeCols.indexOf(currentSettings.mainAxis) !== -1) { document.getElementById('timelineChartType').classList.remove('d-none'); } else { document.getElementById('timelineChartType').classList.add('d-none'); if (currentSettings.type === 'timeline') { $('#lineChartTypeRadio').prop('checked', true); currentSettings.type = 'line'; } } if (numericCols.indexOf(currentSettings.mainAxis) !== -1) { document.getElementById('scatterChartType').classList.remove('d-none'); } else { document.getElementById('scatterChartType').classList.add('d-none'); if (currentSettings.type === 'scatter') { $('#lineChartTypeRadio').prop('checked', true); currentSettings.type = 'line'; } } var xAxisTitle = $xAxisSelect.children('option:selected').text(); $('#xAxisLabelInput').val(xAxisTitle); currentSettings.xaxisLabel = xAxisTitle; } function onDataSeriesChange() { var $seriesSelect = $('#chartSeriesSelect'); currentSettings.selectedSeries = getSelectedSeries(); var yAxisTitle; if (currentSettings.selectedSeries.length === 1) { document.getElementById('pieChartType').classList.remove('d-none'); yAxisTitle = $seriesSelect.children('option:selected').text(); } else { document.getElementById('pieChartType').classList.add('d-none'); if (currentSettings.type === 'pie') { $('#lineChartTypeRadio').prop('checked', true); currentSettings.type = 'line'; } yAxisTitle = Messages.strYValues; } $('#yAxisLabelInput').val(yAxisTitle); currentSettings.yaxisLabel = yAxisTitle; } /** * Unbind all event handlers before tearing down a page */ AJAX.registerTeardown('table/chart.js', function () { $('input[name="chartType"]').off('click'); $('#barStackedCheckbox').off('click'); $('#seriesColumnCheckbox').off('click'); $('#chartTitleInput').off('focus').off('keyup').off('blur'); $('#chartXAxisSelect').off('change'); $('#chartSeriesSelect').off('change'); $('#chartSeriesColumnSelect').off('change'); $('#chartValueColumnSelect').off('change'); $('#xAxisLabelInput').off('keyup'); $('#yAxisLabelInput').off('keyup'); $('#resizer').off('resizestop'); $('#tblchartform').off('submit'); }); AJAX.registerOnload('table/chart.js', function () { // handle manual resize $('#resizer').on('resizestop', function () { // make room so that the handle will still appear $('#querychart').height($('#resizer').height() * 0.96); $('#querychart').width($('#resizer').width() * 0.96); if (currentChart !== null) { currentChart.redraw({ resetAxes: true }); } }); // handle chart type changes $('input[name="chartType"]').on('click', function () { var type = currentSettings.type = $(this).val(); if (type === 'bar' || type === 'column' || type === 'area') { document.getElementById('barStacked').classList.remove('d-none'); } else { $('#barStackedCheckbox').prop('checked', false); $.extend(true, currentSettings, { stackSeries: false }); document.getElementById('barStacked').classList.add('d-none'); } drawChart(); }); // handle chosing alternative data format $('#seriesColumnCheckbox').on('click', function () { var $seriesColumn = $('#chartSeriesColumnSelect'); var $valueColumn = $('#chartValueColumnSelect'); var $chartSeries = $('#chartSeriesSelect'); if ($(this).is(':checked')) { $seriesColumn.prop('disabled', false); $valueColumn.prop('disabled', false); $chartSeries.prop('disabled', true); currentSettings.seriesColumn = parseInt($seriesColumn.val(), 10); currentSettings.valueColumn = parseInt($valueColumn.val(), 10); } else { $seriesColumn.prop('disabled', true); $valueColumn.prop('disabled', true); $chartSeries.prop('disabled', false); currentSettings.seriesColumn = null; currentSettings.valueColumn = null; } drawChart(); }); // handle stacking for bar, column and area charts $('#barStackedCheckbox').on('click', function () { if ($(this).is(':checked')) { $.extend(true, currentSettings, { stackSeries: true }); } else { $.extend(true, currentSettings, { stackSeries: false }); } drawChart(); }); // handle changes in chart title $('#chartTitleInput').on('focus', function () { tempChartTitle = $(this).val(); }).on('keyup', function () { currentSettings.title = $('#chartTitleInput').val(); drawChart(); }).on('blur', function () { if ($(this).val() !== tempChartTitle) { drawChart(); } }); // handle changing the x-axis $('#chartXAxisSelect').on('change', function () { onXAxisChange(); drawChart(); }); // handle changing the selected data series $('#chartSeriesSelect').on('change', function () { onDataSeriesChange(); drawChart(); }); // handle changing the series column $('#chartSeriesColumnSelect').on('change', function () { currentSettings.seriesColumn = parseInt($(this).val(), 10); drawChart(); }); // handle changing the value column $('#chartValueColumnSelect').on('change', function () { currentSettings.valueColumn = parseInt($(this).val(), 10); drawChart(); }); // handle manual changes to the chart x-axis labels $('#xAxisLabelInput').on('keyup', function () { currentSettings.xaxisLabel = $(this).val(); drawChart(); }); // handle manual changes to the chart y-axis labels $('#yAxisLabelInput').on('keyup', function () { currentSettings.yaxisLabel = $(this).val(); drawChart(); }); // handler for ajax form submission $('#tblchartform').on('submit', function () { var $form = $(this); if (codeMirrorEditor) { $form[0].elements.sql_query.value = codeMirrorEditor.getValue(); } if (!Functions.checkSqlQuery($form[0])) { return false; } var $msgbox = Functions.ajaxShowMessage(); Functions.prepareForAjaxRequest($form); $.post($form.attr('action'), $form.serialize(), function (data) { if (typeof data !== 'undefined' && data.success === true && typeof data.chartData !== 'undefined') { chartData = JSON.parse(data.chartData); drawChart(); Functions.ajaxRemoveMessage($msgbox); } else { Functions.ajaxShowMessage(data.error, false); } }, 'json'); // end $.post() return false; }); // from jQuery UI $('#resizer').resizable({ minHeight: 240, minWidth: 300 }).width($('#div_view_options').width() - 50).trigger('resizestop'); currentSettings = { type: 'line', width: $('#resizer').width() - 20, height: $('#resizer').height() - 20, xaxisLabel: $('#xAxisLabelInput').val(), yaxisLabel: $('#yAxisLabelInput').val(), title: $('#chartTitleInput').val(), stackSeries: false, mainAxis: parseInt($('#chartXAxisSelect').val(), 10), selectedSeries: getSelectedSeries(), seriesColumn: null }; var vals = $('input[name="dateTimeCols"]').val().split(' '); $.each(vals, function (i, v) { dateTimeCols.push(parseInt(v, 10)); }); vals = $('input[name="numericCols"]').val().split(' '); $.each(vals, function (i, v) { numericCols.push(parseInt(v, 10)); }); onXAxisChange(); onDataSeriesChange(); $('#tblchartform').trigger('submit'); });
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings