﻿<template>
    <JqxPivotGrid :source="pivotDataSource"
                  :treeStyleRows="true"
                  :autoResize="true"
                  :multipleSelectionEnabled="true">
    </JqxPivotGrid>
</template>

<script>
    import JqxPivotGrid from 'jqwidgets-scripts/jqwidgets-vue/vue_jqxpivotgrid.vue';

    export default {
        components: {
            JqxPivotGrid
        },
        data: function () {
            return {
                pivotDataSource: this.pivotDataSource
            }
        },
        beforeCreate: function () {
            const createPivotDataSource = function () {
                // prepare sample data
                let data = new Array();

                let countries = [
                    "Germany", "France", "United States", "Italy", "Spain", "Finland", "Canada", "Japan", "Brazil", "United Kingdom", "China", "India", "South Korea", "Romania", "Greece"
                ];

                let dataPoints = [
                    "2.25", "1.5", "3.0", "3.3", "4.5", "3.6", "3.8", "2.5", "5.0", "1.75", "3.25", "4.0"
                ];

                for (let i = 0; i < countries.length * 2; i++) {
                    let row = {};
                    let value = parseFloat(dataPoints[Math.round((Math.random() * 100)) % dataPoints.length]);

                    row["country"] = countries[i % countries.length];
                    row["value"] = value;

                    data[i] = row;
                }

                // create a data source and data adapter
                let source =
                    {
                        localdata: data,
                        datatype: "array",
                        datafields:
                            [
                                { name: 'country', type: 'string' },
                                { name: 'value', type: 'number' }
                            ]
                    };

                let dataAdapter = new jqx.dataAdapter(source);
                dataAdapter.dataBind();

                // create a pivot data source from the dataAdapter
                let pivotDataSource = new jqx.pivot(
                    dataAdapter,
                    {
                        pivotValuesOnRows: false,
                        rows: [{ dataField: 'country', width: 190 }],
                        columns: [],
                        values: [
                            { dataField: 'value', width: 200, 'function': 'min', text: 'cells left alignment', formatSettings: { align: 'left', prefix: '', decimalPlaces: 2 } },
                            { dataField: 'value', width: 200, 'function': 'max', text: 'cells center alignment', formatSettings: { align: 'center', prefix: '', decimalPlaces: 2 } },
                            { dataField: 'value', width: 200, 'function': 'average', text: 'cells right alignment', formatSettings: { align: 'right', prefix: '', decimalPlaces: 2 } }
                        ]
                    }
                );
                return pivotDataSource;
            }

            this.pivotDataSource = createPivotDataSource();
        }
    }
</script>