/** * This exporter produces CSV (comma separated values) files for the supplied data. */Ext.define('Ext.exporter.text.CSV', { extend: 'Ext.exporter.Base', alias: 'exporter.csv', requires: [ 'Ext.util.CSV' ], fileName: 'export.csv', getHelper: function(){ return Ext.util.CSV; }, getContent: function(){ var me = this, result = [], data = me.getData(); if(data) { me.buildHeader(result); me.buildRows(data, result, data.getColumnCount()); me.columnStyles = Ext.destroy(me.columnStyles); } return me.getHelper().encode(result); }, buildHeader: function(result){ var me = this, ret = {}, data = me.getData(), arr, lenCells, i, style; me.buildHeaderRows(data.getColumns(), ret); result.push.apply(result, Ext.Object.getValues(ret)); arr = data.getBottomColumns(); lenCells = arr.length; me.columnStyles = []; for(i = 0; i < lenCells; i++){ style = arr[i].getStyle() || {}; if(!style.id){ style.id = 'c' + i; } style.name = '.' + style.id; me.columnStyles.push(new Ext.exporter.file.Style(style)); } }, buildHeaderRows: function (columns, result) { var col, i, len, name, mAcross, mDown, j, level; if (!columns) { return; } len = columns.length; for (i = 0; i < len; i++) { col = columns.items[i]; mAcross = col._mergeAcross; mDown = col._mergeDown; level = col._level; name = 's' + level; result[name] = result[name] || []; result[name].push(col._text); for(j = 1; j <= mAcross; j++){ result[name].push(''); } for(j = 1; j <= mDown; j++){ name = 's' + (level + j); result[name] = result[name] || []; result[name].push(''); } this.buildHeaderRows(col._columns, result); } }, buildRows: function(group, result, length){ var showSummary = this._showSummary, groups, i, row, gLen, j, rLen, k, cLen, r, cells, oneLine, cell, style, text; if(!group){ return; } groups = group._groups; text = group._text; // if the group has no subgroups and no rows then show only summaries oneLine = (!groups && !group._rows); if(!Ext.isEmpty(text) && !oneLine) { row = []; row.length = length; row[group.level || 0] = text; result.push(row); } if(groups) { gLen = groups.length; for (i = 0; i < gLen; i++) { this.buildRows(groups.items[i], result, length); } } if(group._rows) { rLen = group._rows.length; for(j = 0; j < rLen; j++){ row = []; r = group._rows.items[j]; cells = r._cells; cLen = cells.length; for(k = 0; k < cLen; k++){ cell = cells.items[k]; style = this.columnStyles[k]; cell = style ? style.getFormattedValue(cell._value) : cell._value; row.push(cell); } result.push(row); } } if( group._summaries && (showSummary || oneLine) ){ rLen = group._summaries.length; for(j = 0; j < rLen; j++){ row = []; r = group._summaries.items[j]; cells = r._cells; cLen = cells.length; for(k = 0; k < cLen; k++){ cell = cells.items[k]; style = this.columnStyles[k]; cell = style ? style.getFormattedValue(cell._value) : cell._value; row.push(cell); } result.push(row); } } } });