add extjs 6.0.1 sources

[extjs.git] / extjs / build / examples / kitchensink / classic / samples / view / pivot / ExcelExport.js

/**\r
 *\r
 * This example shows how to create a pivot grid and export the results to Excel.\r
 *\r
 */\r
Ext.define('KitchenSink.view.pivot.ExcelExport', {\r
    extend: 'Ext.pivot.Grid',\r
    xtype: 'excel-pivot-grid',\r
    controller: 'pivotexport',\r
\r
    requires: [\r
        'KitchenSink.store.pivot.Sales',\r
        'Ext.pivot.plugin.Exporter'\r
    ],\r
\r
    title: 'Pivot Grid with Exporter plugin',\r
    collapsible: true,\r
    multiSelect: true,\r
    height: 350,\r
\r
    store: {\r
        type: 'sales'\r
    },\r
    selModel: {\r
        type: 'spreadsheet'\r
    },\r
\r
    plugins: [{\r
        ptype: 'pivotexporter',\r
        pluginId: 'exporter'\r
    }],\r
\r
    // Configure the aggregate dimensions. Multiple dimensions are supported.\r
    aggregate: [{\r
        dataIndex:  'value',\r
        header:     'Sum of value',\r
        aggregator: 'sum'\r
    }],\r
\r
    // Configure the left axis dimensions that will be used to generate the grid rows\r
    leftAxis: [{\r
        dataIndex:  'person',\r
        header:     'Person'\r
    },{\r
        dataIndex:  'company',\r
        header:     'Company',\r
        sortable:   false\r
    }],\r
\r
    /**\r
     * Configure the top axis dimensions that will be used to generate the columns.\r
     * When columns are generated the aggregate dimensions are also used. If multiple aggregation dimensions\r
     * are defined then each top axis result will have in the end a column header with children\r
     * columns for each aggregate dimension defined.\r
     */\r
    topAxis: [{\r
        dataIndex:  'year',\r
        header:     'Year'\r
    }, {\r
        dataIndex:  'country',\r
        header:     'Country'\r
    }],\r
\r
    header: {\r
        itemPosition: 1, // after title before collapse tool\r
        items: [{\r
            ui: 'default-toolbar',\r
            xtype: 'button',\r
            text: 'Export to Excel',\r
            handler: 'exportToExcel'\r
        }]\r
    },\r
\r
    //<example>\r
    otherContent: [{\r
        type: 'Controller',\r
        path: 'classic/samples/view/pivot/ExcelExportController.js'\r
    },{\r
        type: 'Model',\r
        path: 'classic/samples/model/pivot/Sale.js'\r
    },{\r
        type: 'Store',\r
        path: 'classic/samples/store/pivot/Sales.js'\r
    }],\r
    profiles: {\r
        classic: {\r
            width: 600\r
        },\r
        neptune: {\r
            width: 750\r
        }\r
    },\r
    //</example>\r
\r
    initComponent: function () {\r
        var me = this;\r
\r
        me.width = me.profileInfo.width;\r
\r
        me.callParent();\r
    }\r
});\r