phpmyadmin working

1 files changed, 425 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/js/table/chart.js b/srcs/phpmyadmin/js/table/chart.js
new file mode 100644
index 0000000..2a6f43f
--- /dev/null
+++ b/srcs/phpmyadmin/js/table/chart.js
@@ -0,0 +1,425 @@
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+
+/* 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 = [];
+    $('select[name="chartXAxis"] 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 = $('select[name="chartSeries"]').val() || [];
+    var ret = [];
+    $.each(val, function (i, v) {
+        ret.push(parseInt(v, 10));
+    });
+    return ret;
+}
+
+function onXAxisChange () {
+    var $xAxisSelect = $('select[name="chartXAxis"]');
+    currentSettings.mainAxis = parseInt($xAxisSelect.val(), 10);
+    if (dateTimeCols.indexOf(currentSettings.mainAxis) !== -1) {
+        $('span.span_timeline').show();
+    } else {
+        $('span.span_timeline').hide();
+        if (currentSettings.type === 'timeline') {
+            $('input#radio_line').prop('checked', true);
+            currentSettings.type = 'line';
+        }
+    }
+    if (numericCols.indexOf(currentSettings.mainAxis) !== -1) {
+        $('span.span_scatter').show();
+    } else {
+        $('span.span_scatter').hide();
+        if (currentSettings.type === 'scatter') {
+            $('input#radio_line').prop('checked', true);
+            currentSettings.type = 'line';
+        }
+    }
+    var xAxisTitle = $xAxisSelect.children('option:selected').text();
+    $('input[name="xaxis_label"]').val(xAxisTitle);
+    currentSettings.xaxisLabel = xAxisTitle;
+}
+
+function onDataSeriesChange () {
+    var $seriesSelect = $('select[name="chartSeries"]');
+    currentSettings.selectedSeries = getSelectedSeries();
+    var yAxisTitle;
+    if (currentSettings.selectedSeries.length === 1) {
+        $('span.span_pie').show();
+        yAxisTitle = $seriesSelect.children('option:selected').text();
+    } else {
+        $('span.span_pie').hide();
+        if (currentSettings.type === 'pie') {
+            $('input#radio_line').prop('checked', true);
+            currentSettings.type = 'line';
+        }
+        yAxisTitle = Messages.strYValues;
+    }
+    $('input[name="yaxis_label"]').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');
+    $('input[name="barStacked"]').off('click');
+    $('input[name="chkAlternative"]').off('click');
+    $('input[name="chartTitle"]').off('focus').off('keyup').off('blur');
+    $('select[name="chartXAxis"]').off('change');
+    $('select[name="chartSeries"]').off('change');
+    $('select[name="chartSeriesColumn"]').off('change');
+    $('select[name="chartValueColumn"]').off('change');
+    $('input[name="xaxis_label"]').off('keyup');
+    $('input[name="yaxis_label"]').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') {
+            $('span.barStacked').show();
+        } else {
+            $('input[name="barStacked"]').prop('checked', false);
+            $.extend(true, currentSettings, { stackSeries : false });
+            $('span.barStacked').hide();
+        }
+        drawChart();
+    });
+
+    // handle chosing alternative data format
+    $('input[name="chkAlternative"]').on('click', function () {
+        var $seriesColumn = $('select[name="chartSeriesColumn"]');
+        var $valueColumn  = $('select[name="chartValueColumn"]');
+        var $chartSeries  = $('select[name="chartSeries"]');
+        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
+    $('input[name="barStacked"]').on('click', function () {
+        if ($(this).is(':checked')) {
+            $.extend(true, currentSettings, { stackSeries : true });
+        } else {
+            $.extend(true, currentSettings, { stackSeries : false });
+        }
+        drawChart();
+    });
+
+    // handle changes in chart title
+    $('input[name="chartTitle"]')
+        .on('focus', function () {
+            tempChartTitle = $(this).val();
+        })
+        .on('keyup', function () {
+            currentSettings.title = $('input[name="chartTitle"]').val();
+            drawChart();
+        })
+        .on('blur', function () {
+            if ($(this).val() !== tempChartTitle) {
+                drawChart();
+            }
+        });
+
+    // handle changing the x-axis
+    $('select[name="chartXAxis"]').on('change', function () {
+        onXAxisChange();
+        drawChart();
+    });
+
+    // handle changing the selected data series
+    $('select[name="chartSeries"]').on('change', function () {
+        onDataSeriesChange();
+        drawChart();
+    });
+
+    // handle changing the series column
+    $('select[name="chartSeriesColumn"]').on('change', function () {
+        currentSettings.seriesColumn = parseInt($(this).val(), 10);
+        drawChart();
+    });
+
+    // handle changing the value column
+    $('select[name="chartValueColumn"]').on('change', function () {
+        currentSettings.valueColumn = parseInt($(this).val(), 10);
+        drawChart();
+    });
+
+    // handle manual changes to the chart x-axis labels
+    $('input[name="xaxis_label"]').on('keyup', function () {
+        currentSettings.xaxisLabel = $(this).val();
+        drawChart();
+    });
+
+    // handle manual changes to the chart y-axis labels
+    $('input[name="yaxis_label"]').on('keyup', function () {
+        currentSettings.yaxisLabel = $(this).val();
+        drawChart();
+    });
+
+    // handler for ajax form submission
+    $('#tblchartform').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 : $('input[name="xaxis_label"]').val(),
+        yaxisLabel : $('input[name="yaxis_label"]').val(),
+        title : $('input[name="chartTitle"]').val(),
+        stackSeries : false,
+        mainAxis : parseInt($('select[name="chartXAxis"]').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');
+});