commit 8eaf0de1bea2eeb09a0cf6e8477e735c95b96165 parent 4626b72edbfb108642582b1d87061f166b17c4ed Author: Felicitus <felicitus@felicitus.org> Date: Tue, 13 Oct 2015 13:12:44 +0200 Removed obsolete exporter Diffstat:
17 files changed, 0 insertions(+), 1196 deletions(-)
diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/Base64.js b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/Base64.js @@ -1,64 +0,0 @@ -/** -* -* Base64 encode / decode -* http://www.webtoolkit.info/ -* -**/ - -(function() { - - // private property - var keyStr = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/="; - - // private method for UTF-8 encoding - function utf8Encode(string) { - string = string.replace(/\r\n/g,"\n"); - var utftext = ""; - for (var n = 0; n < string.length; n++) { - var c = string.charCodeAt(n); - if (c < 128) { - utftext += String.fromCharCode(c); - } - else if((c > 127) && (c < 2048)) { - utftext += String.fromCharCode((c >> 6) | 192); - utftext += String.fromCharCode((c & 63) | 128); - } - else { - utftext += String.fromCharCode((c >> 12) | 224); - utftext += String.fromCharCode(((c >> 6) & 63) | 128); - utftext += String.fromCharCode((c & 63) | 128); - } - } - return utftext; - } - - Ext.define("Ext.ux.exporter.Base64", { - statics: { - //This was the original line, which tries to use Firefox's built in Base64 encoder, but this kept throwing exceptions.... - // encode : (typeof btoa == 'function') ? function(input) { return btoa(input); } : function (input) { - encode : function (input) { - var output = ""; - var chr1, chr2, chr3, enc1, enc2, enc3, enc4; - var i = 0; - input = utf8Encode(input); - while (i < input.length) { - chr1 = input.charCodeAt(i++); - chr2 = input.charCodeAt(i++); - chr3 = input.charCodeAt(i++); - enc1 = chr1 >> 2; - enc2 = ((chr1 & 3) << 4) | (chr2 >> 4); - enc3 = ((chr2 & 15) << 2) | (chr3 >> 6); - enc4 = chr3 & 63; - if (isNaN(chr2)) { - enc3 = enc4 = 64; - } else if (isNaN(chr3)) { - enc4 = 64; - } - output = output + - keyStr.charAt(enc1) + keyStr.charAt(enc2) + - keyStr.charAt(enc3) + keyStr.charAt(enc4); - } - return output; - }} - }); -})();- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/Button.js b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/Button.js @@ -1,61 +0,0 @@ -/** - * @class Ext.ux.Exporter.Button - * @extends Ext.Component - * @author Nige White, with modifications from Ed Spencer, with modifications from iwiznia. - * Specialised Button class that allows downloading of data via data: urls. - * Internally, this is just a link. - * Pass it either an Ext.Component subclass with a 'store' property, or just a store or nothing and it will try to grab the first parent of this button that is a grid or tree panel: - * new Ext.ux.Exporter.Button({component: someGrid}); - * new Ext.ux.Exporter.Button({store: someStore}); - * @cfg {Ext.Component} component The component the store is bound to - * @cfg {Ext.data.Store} store The store to export (alternatively, pass a component with a getStore method) - */ -Ext.define("Ext.ux.exporter.Button", { - extend: "Ext.Component", - alias: "widget.exporterbutton", - html: '<p></p>', - config: { - swfPath: '/flash/downloadify.swf', - downloadImage: '/images/ext_reports/download.png', - width: 62, - height: 22, - downloadName: "download" - }, - - constructor: function(config) { - config = config || {}; - - this.initConfig(); - Ext.ux.exporter.Button.superclass.constructor.call(this, config); - - var self = this; - this.on("afterrender", function() { // We wait for the combo to be rendered, so we can look up to grab the component containing it - self.setComponent(self.store || self.component || self.up("gridpanel") || self.up("treepanel"), config); - }); - }, - - setComponent: function(component, config) { - this.component = component; - this.store = !component.is ? component : component.getStore(); // only components or stores, if it doesn't respond to is method, it's a store - this.setDownloadify(config); - }, - - setDownloadify: function(config) { - var self = this; - Downloadify.create(this.el.down('p').id,{ - filename: function() { - return self.getDownloadName() + "." + Ext.ux.exporter.Exporter.getFormatterByName(self.formatter).extension; - }, - data: function() { - return Ext.ux.exporter.Exporter.exportAny(self.component, self.formatter, config); - }, - transparent: false, - swf: this.getSwfPath(), - downloadImage: this.getDownloadImage(), - width: this.getWidth(), - height: this.getHeight(), - transparent: true, - append: false - }); - } -});- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/Exporter.js b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/Exporter.js @@ -1,83 +0,0 @@ -/** - * @class Ext.ux.Exporter - * @author Ed Spencer (http://edspencer.net), with modifications from iwiznia. - * Class providing a common way of downloading data in .xls or .csv format - */ -Ext.define("Ext.ux.exporter.Exporter", { - uses: [ - "Ext.ux.exporter.Base64", - "Ext.ux.exporter.Button", - "Ext.ux.exporter.csvFormatter.CsvFormatter", - "Ext.ux.exporter.wikiFormatter.WikiFormatter", - "Ext.ux.exporter.excelFormatter.ExcelFormatter" - ], - - statics: { - exportAny: function(component, formatter, config) { - var func = "export"; - if(!component.is) { - func = func + "Store"; - } else if(component.is("gridpanel")) { - func = func + "Grid"; - } else if (component.is("treepanel")) { - func = func + "Tree"; - } else { - func = func + "Store"; - component = component.getStore(); - } - - return this[func](component, this.getFormatterByName(formatter), config); - }, - - /** - * Exports a grid, using the .xls formatter by default - * @param {Ext.grid.GridPanel} grid The grid to export from - * @param {Object} config Optional config settings for the formatter - */ - exportGrid: function(grid, formatter, config) { - config = config || {}; - formatter = this.getFormatterByName(formatter); - - var columns = Ext.Array.filter(grid.columns, function(col) { - return !col.hidden; // && (!col.xtype || col.xtype != "actioncolumn"); - }); - - Ext.applyIf(config, { - title : grid.title, - columns: columns - }); - - return formatter.format(grid.store, config); - }, - - exportStore: function(store, formatter, config) { - config = config || {}; - formatter = this.getFormatterByName(formatter); - - Ext.applyIf(config, { - columns: store.fields ? store.fields.items : store.model.prototype.fields.items - }); - - return formatter.format(store, config); - }, - - exportTree: function(tree, formatter, config) { - config = config || {}; - formatter = this.getFormatterByName(formatter); - - var store = tree.store || config.store; - - Ext.applyIf(config, { - title: tree.title - }); - - return formatter.format(store, config); - }, - - getFormatterByName: function(formatter) { - formatter = formatter ? formatter : "excel"; - formatter = !Ext.isString(formatter) ? formatter : Ext.create("Ext.ux.exporter." + formatter + "Formatter." + Ext.String.capitalize(formatter) + "Formatter"); - return formatter; - } - } -});- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/Ext.ux.Exporter.jsb b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/Ext.ux.Exporter.jsb @@ -1,37 +0,0 @@ -{ - "projectName": "Ext.ux.Exporter", - "packages": [{ - "name": "Ext.ux.Exporter", - "id": "ext-ux-exporter", - "files": [ - {"path": "", "name": "Formatter.js"}, - {"path": "", "name": "Base64.js"}, - {"path": "", "name": "Exporter.js"}, - {"path": "", "name": "Button.js"}, - {"path": "csvFormatter/", "name": "CsvFormatter.js"}, - {"path": "wikiFormatter/", "name": "WikiFormatter.js"}, - {"path": "excelFormatter/", "name": "Cell.js"}, - {"path": "excelFormatter/", "name": "Style.js"}, - {"path": "excelFormatter/", "name": "ExcelFormatter.js"}, - {"path": "excelFormatter/", "name": "Workbook.js"}, - {"path": "excelFormatter/", "name": "Worksheet.js"} - ] - }], - "builds": [ - { - "name": "All", - "target": "Ext.ux.formatter-all.js", - "compress": true, - "packages": [ - "ext-ux-exporter" - ] - }, - { - "name": "Debug", - "target": "Ext.ux.formatter-all-debug.js", - "compress": false, - "packages": [ - "ext-ux-exporter" - ] - }] -}- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/Formatter.js b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/Formatter.js @@ -1,18 +0,0 @@ -/** - * @class Ext.ux.Exporter.Formatter - * @author Ed Spencer (http://edspencer.net) - * @cfg {Ext.data.Store} store The store to export - */ -Ext.define("Ext.ux.exporter.Formatter", { - /** - * Performs the actual formatting. This must be overridden by a subclass - */ - format: Ext.emptyFn, - constructor: function(config) { - config = config || {}; - - Ext.applyIf(config, { - - }); - } -});- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/README.textile b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/README.textile @@ -1,9 +0,0 @@ -h1. Ext.ux.Exporter - -h2. About - -p. Exporter is a generic export class which takes any Ext.data.Store-based component (e.g. grids and similar) and exports the data in any format. - -p. Exporter works completely client-side. It uses a Formatter class to generate a document (.xls, .csv etc) and then uses the donwloadify library so that the user can view or download it. - -p. Right now, there isn't a readme or example. You can check this post for more info for now: http://www.sencha.com/forum/showthread.php?136598-Export-store-to-Excel diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/build b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/build @@ -1,21 +0,0 @@ -# This file defines the order in which the plugin files must be loaded. -# It is used by the Ext MVC's ruby plugin builder, which which can be invoked from your application's base directory like this: - -# ruby script/plugin build Exporter - -# This will generate a file named Exporter-all.js in this directory, which is just a concatenation of all the files you list here -# NOTE: This is only used by the plugin builder, not the app itself. You must always ensure that your plugin is compiled to -# Exporter-all.js by some other means if you do not use the plugin builder, as it is that file that will be loaded by your app - -Base64.js - -Exporter.js -Button.js - -Formatter.js - -excelFormatter/ExcelFormatter.js -excelFormatter/Workbook.js -excelFormatter/Worksheet.js -excelFormatter/Cell.js -excelFormatter/Style.js- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/csvFormatter/CsvFormatter.js b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/csvFormatter/CsvFormatter.js @@ -1,112 +0,0 @@ -/** - * @class Ext.ux.Exporter.CSVFormatter - * @extends Ext.ux.Exporter.Formatter - * Specialised Format class for outputting .csv files - */ -Ext.define("Ext.ux.exporter.csvFormatter.CsvFormatter", { - extend: "Ext.ux.exporter.Formatter", - - /** - * @cfg {String} contentType The content type to use. Defaults to 'data:text/csv;base64,' - */ - contentType: 'data:text/csv;base64,', - - /** - * @cfg {String} separator The separator to use. Defaults to ';' - */ - separator: ";", - - /** - * @cfg {String} extension The extension to use. Defaults to 'csv' - */ - extension: "csv", - - /** - * @cfg {String} lineSeparator The line separator to use. Defaults to "\n" - */ - lineSeparator: "\n", - - /** - * @cfg {Boolean} capitalizeHeaders Capitalizes the header fields. Defaults to false - */ - capitalizeHeaders: false, - - /** - * Formats the store to the CSV format. - * @param store The store to export - * @param config {Object} [config] Config object. Contains the "columns" property, which is an array of field names. - */ - format: function(store, config) { - this.columns = config.columns || (store.fields ? store.fields.items : store.model.prototype.fields.items); - return this.getHeaders() + this.lineSeparator + this.getRows(store); - }, - - /** - * Returns the headers for the specific store. - * - * @param {Object} store The store to process - * @returns {String} The header line - */ - getHeaders: function(store) { - var columns = []; - - Ext.each(this.columns, function(col) { - var title; - if (col.text != undefined) { - title = col.text; - } else if(col.name) { - title = col.name.replace(/_/g, " "); - } else { - title = ""; - } - - if (this.capitalizeHeaders) { - title = Ext.String.capitalize(title); - } - - columns.push(title); - }, this); - - return columns.join(this.separator); - }, - /** - * Returns all rows for the store - * - * @param {Object} store The store to use - * @returns {String} - */ - getRows: function(store) { - var rows = []; - store.each(function(record) { - rows.push(this.getCells(record)); - }, this); - - return rows.join(this.lineSeparator); - }, - /** - * Returns the cells for a specific row - * @param {Object} record The record - * @returns {String} The cells of the record - */ - getCells: function(record) { - var cells = []; - - Ext.each(this.columns, function(col) { - var name = col.name || col.dataIndex; - var value = ""; - - if(typeof name !== 'undefined') { - if (Ext.isFunction(col.renderer)) { - value = col.renderer(record.get(name), null, record); - } else { - value = record.get(name); - } - - value = '"' + value + '"'; - cells.push(value); - } - }); - - return cells.join(this.separator); - } -});- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/download.png b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/download.png Binary files differ. diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/downloadify.min.js b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/downloadify.min.js @@ -1,3 +0,0 @@ -/* Downloadify 0.2 (c) 2009 by Douglas Neiner. Licensed under the MIT license */ -/* See http://github.com/dcneiner/Downloadify for license and more info */ -(function(){Downloadify=window.Downloadify={queue:{},uid:new Date().getTime(),getTextForSave:function(a){var b=Downloadify.queue[a];if(b)return b.getData();return""},getFileNameForSave:function(a){var b=Downloadify.queue[a];if(b)return b.getFilename();return""},getDataTypeForSave:function(a){var b=Downloadify.queue[a];if(b)return b.getDataType();return""},saveComplete:function(a){var b=Downloadify.queue[a];if(b)b.complete();return true},saveCancel:function(a){var b=Downloadify.queue[a];if(b)b.cancel();return true},saveError:function(a){var b=Downloadify.queue[a];if(b)b.error();return true},addToQueue:function(a){Downloadify.queue[a.queue_name]=a},getUID:function(a){if(a.id=="")a.id='downloadify_'+Downloadify.uid++;return a.id}};Downloadify.create=function(a,b){var c=(typeof(a)=="string"?document.getElementById(a):a);return new Downloadify.Container(c,b)};Downloadify.Container=function(d,e){var f=this;f.el=d;f.enabled=true;f.dataCallback=null;f.filenameCallback=null;f.data=null;f.filename=null;var g=function(){f.options=e;if(!f.options.append)f.el.innerHTML="";f.flashContainer=document.createElement('span');f.el.appendChild(f.flashContainer);f.queue_name=Downloadify.getUID(f.flashContainer);if(typeof(f.options.filename)==="function")f.filenameCallback=f.options.filename;else if(f.options.filename)f.filename=f.options.filename;if(typeof(f.options.data)==="function")f.dataCallback=f.options.data;else if(f.options.data)f.data=f.options.data;var a={queue_name:f.queue_name,width:f.options.width,height:f.options.height};var b={allowScriptAccess:'always'};var c={id:f.flashContainer.id,name:f.flashContainer.id};if(f.options.enabled===false)f.enabled=false;if(f.options.transparent===true)b.wmode="transparent";if(f.options.downloadImage)a.downloadImage=f.options.downloadImage;swfobject.embedSWF(f.options.swf,f.flashContainer.id,f.options.width,f.options.height,"10",null,a,b,c);Downloadify.addToQueue(f)};f.enable=function(){var a=document.getElementById(f.flashContainer.id);a.setEnabled(true);f.enabled=true};f.disable=function(){var a=document.getElementById(f.flashContainer.id);a.setEnabled(false);f.enabled=false};f.getData=function(){if(!f.enabled)return"";if(f.dataCallback)return f.dataCallback();else if(f.data)return f.data;else return""};f.getFilename=function(){if(f.filenameCallback)return f.filenameCallback();else if(f.filename)return f.filename;else return""};f.getDataType=function(){if(f.options.dataType)return f.options.dataType;return"string"};f.complete=function(){if(typeof(f.options.onComplete)==="function")f.options.onComplete()};f.cancel=function(){if(typeof(f.options.onCancel)==="function")f.options.onCancel()};f.error=function(){if(typeof(f.options.onError)==="function")f.options.onError()};g()};Downloadify.defaultOptions={swf:'media/downloadify.swf',downloadImage:'images/download.png',width:100,height:30,transparent:true,append:false,dataType:"string"}})();if(typeof(jQuery)!="undefined"){(function($){$.fn.downloadify=function(b){return this.each(function(){b=$.extend({},Downloadify.defaultOptions,b);var a=Downloadify.create(this,b);$(this).data('Downloadify',a)})}})(jQuery)};if(typeof(MooTools)!='undefined'){Element.implement({downloadify:function(a){a=$merge(Downloadify.defaultOptions,a);return this.store('Downloadify',Downloadify.create(this,a))}})};- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/downloadify.swf b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/downloadify.swf Binary files differ. diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/excelFormatter/Cell.js b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/excelFormatter/Cell.js @@ -1,27 +0,0 @@ -/** - * @class Ext.ux.Exporter.ExcelFormatter.Cell - * @extends Object - * Represents a single cell in a worksheet - */ - -Ext.define("Ext.ux.exporter.excelFormatter.Cell", { - constructor: function(config) { - Ext.applyIf(config, { - type: "String" - }); - - Ext.apply(this, config); - - Ext.ux.exporter.excelFormatter.Cell.superclass.constructor.apply(this, arguments); - }, - - render: function() { - return this.tpl.apply(this); - }, - - tpl: new Ext.XTemplate( - '<ss:Cell ss:StyleID="{style}">', - '<ss:Data ss:Type="{type}"><![CDATA[{value}]]></ss:Data>', - '</ss:Cell>' - ) -});- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/excelFormatter/ExcelFormatter.js b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/excelFormatter/ExcelFormatter.js @@ -1,23 +0,0 @@ -/** - * @class Ext.ux.Exporter.ExcelFormatter - * @extends Ext.ux.Exporter.Formatter - * Specialised Format class for outputting .xls files - */ -Ext.define("Ext.ux.exporter.excelFormatter.ExcelFormatter", { - extend: "Ext.ux.exporter.Formatter", - uses: [ - "Ext.ux.exporter.excelFormatter.Cell", - "Ext.ux.exporter.excelFormatter.Style", - "Ext.ux.exporter.excelFormatter.Worksheet", - "Ext.ux.exporter.excelFormatter.Workbook" - ], - contentType: 'data:application/vnd.ms-excel;base64,', - extension: "xls", - - format: function(store, config) { - var workbook = new Ext.ux.exporter.excelFormatter.Workbook(config); - workbook.addWorksheet(store, config || {}); - - return workbook.render(); - } -});- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/excelFormatter/Style.js b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/excelFormatter/Style.js @@ -1,101 +0,0 @@ -/** - * @class Ext.ux.Exporter.ExcelFormatter.Style - * @extends Object - * Represents a style declaration for a Workbook (this is like defining CSS rules). Example: - * - * new Ext.ux.Exporter.ExcelFormatter.Style({ - * attributes: [ - * { - * name: "Alignment", - * properties: [ - * {name: "Vertical", value: "Top"}, - * {name: "WrapText", value: "1"} - * ] - * }, - * { - * name: "Borders", - * children: [ - * name: "Border", - * properties: [ - * {name: "Color", value: "#e4e4e4"}, - * {name: "Weight", value: "1"} - * ] - * ] - * } - * ] - * }) - * - * @cfg {String} id The ID of this style (required) - * @cfg {Array} attributes The attributes for this style - * @cfg {String} parentStyle The (optional parentStyle ID) - */ -Ext.define("Ext.ux.exporter.excelFormatter.Style", { - constructor: function(config) { - config = config || {}; - - Ext.apply(this, config, { - parentStyle: '', - attributes : [] - }); - - Ext.ux.exporter.excelFormatter.Style.superclass.constructor.apply(this, arguments); - - if (this.id == undefined) throw new Error("An ID must be provided to Style"); - - this.preparePropertyStrings(); - }, - - /** - * Iterates over the attributes in this style, and any children they may have, creating property - * strings on each suitable for use in the XTemplate - */ - preparePropertyStrings: function() { - Ext.each(this.attributes, function(attr, index) { - this.attributes[index].propertiesString = this.buildPropertyString(attr); - this.attributes[index].children = attr.children || []; - - Ext.each(attr.children, function(child, childIndex) { - this.attributes[index].children[childIndex].propertiesString = this.buildPropertyString(child); - }, this); - }, this); - }, - - /** - * Builds a concatenated property string for a given attribute, suitable for use in the XTemplate - */ - buildPropertyString: function(attribute) { - var propertiesString = ""; - - Ext.each(attribute.properties || [], function(property) { - propertiesString += Ext.String.format('ss:{0}="{1}" ', property.name, property.value); - }, this); - - return propertiesString; - }, - - render: function() { - return this.tpl.apply(this); - }, - - tpl: new Ext.XTemplate( - '<tpl if="parentStyle.length == 0">', - '<ss:Style ss:ID="{id}">', - '</tpl>', - '<tpl if="parentStyle.length != 0">', - '<ss:Style ss:ID="{id}" ss:Parent="{parentStyle}">', - '</tpl>', - '<tpl for="attributes">', - '<tpl if="children.length == 0">', - '<ss:{name} {propertiesString} />', - '</tpl>', - '<tpl if="children.length > 0">', - '<ss:{name} {propertiesString}>', - '<tpl for="children">', - '<ss:{name} {propertiesString} />', - '</tpl>', - '</ss:{name}>', - '</tpl>', - '</tpl>', - '</ss:Style>' - ) -});- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/excelFormatter/Workbook.js b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/excelFormatter/Workbook.js @@ -1,325 +0,0 @@ -/** - * @class Ext.ux.Exporter.ExcelFormatter.Workbook - * @extends Object - * Represents an Excel workbook - */ -Ext.define("Ext.ux.exporter.excelFormatter.Workbook", { - - constructor: function(config) { - config = config || {}; - - Ext.apply(this, config, { - /** - * @property title - * @type String - * The title of the workbook (defaults to "Workbook") - */ - title: "Workbook", - - /** - * @property worksheets - * @type Array - * The array of worksheets inside this workbook - */ - worksheets: [], - - /** - * @property compileWorksheets - * @type Array - * Array of all rendered Worksheets - */ - compiledWorksheets: [], - - /** - * @property cellBorderColor - * @type String - * The colour of border to use for each Cell - */ - cellBorderColor: "#e4e4e4", - - /** - * @property styles - * @type Array - * The array of Ext.ux.Exporter.ExcelFormatter.Style objects attached to this workbook - */ - styles: [], - - /** - * @property compiledStyles - * @type Array - * Array of all rendered Ext.ux.Exporter.ExcelFormatter.Style objects for this workbook - */ - compiledStyles: [], - - /** - * @property hasDefaultStyle - * @type Boolean - * True to add the default styling options to all cells (defaults to true) - */ - hasDefaultStyle: true, - - /** - * @property hasStripeStyles - * @type Boolean - * True to add the striping styles (defaults to true) - */ - hasStripeStyles: true, - - windowHeight : 9000, - windowWidth : 50000, - protectStructure: false, - protectWindows : false - }); - - if (this.hasDefaultStyle) this.addDefaultStyle(); - if (this.hasStripeStyles) this.addStripedStyles(); - - this.addTitleStyle(); - this.addHeaderStyle(); - }, - - render: function() { - this.compileStyles(); - this.joinedCompiledStyles = this.compiledStyles.join(""); - - this.compileWorksheets(); - this.joinedWorksheets = this.compiledWorksheets.join(""); - - return this.tpl.apply(this); - }, - - /** - * Adds a worksheet to this workbook based on a store and optional config - * @param {Ext.data.Store} store The store to initialize the worksheet with - * @param {Object} config Optional config object - * @return {Ext.ux.Exporter.ExcelFormatter.Worksheet} The worksheet - */ - addWorksheet: function(store, config) { - var worksheet = new Ext.ux.exporter.excelFormatter.Worksheet(store, config); - - this.worksheets.push(worksheet); - - return worksheet; - }, - - /** - * Adds a new Ext.ux.Exporter.ExcelFormatter.Style to this Workbook - * @param {Object} config The style config, passed to the Style constructor (required) - */ - addStyle: function(config) { - var style = new Ext.ux.exporter.excelFormatter.Style(config || {}); - - this.styles.push(style); - - return style; - }, - - /** - * Compiles each Style attached to this Workbook by rendering it - * @return {Array} The compiled styles array - */ - compileStyles: function() { - this.compiledStyles = []; - - Ext.each(this.styles, function(style) { - this.compiledStyles.push(style.render()); - }, this); - - return this.compiledStyles; - }, - - /** - * Compiles each Worksheet attached to this Workbook by rendering it - * @return {Array} The compiled worksheets array - */ - compileWorksheets: function() { - this.compiledWorksheets = []; - - Ext.each(this.worksheets, function(worksheet) { - this.compiledWorksheets.push(worksheet.render()); - }, this); - - return this.compiledWorksheets; - }, - - tpl: new Ext.XTemplate( - '<?xml version="1.0" encoding="utf-8"?>', - '<ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:o="urn:schemas-microsoft-com:office:office">', - '<o:DocumentProperties>', - '<o:Title>{title}</o:Title>', - '</o:DocumentProperties>', - '<ss:ExcelWorkbook>', - '<ss:WindowHeight>{windowHeight}</ss:WindowHeight>', - '<ss:WindowWidth>{windowWidth}</ss:WindowWidth>', - '<ss:ProtectStructure>{protectStructure}</ss:ProtectStructure>', - '<ss:ProtectWindows>{protectWindows}</ss:ProtectWindows>', - '</ss:ExcelWorkbook>', - '<ss:Styles>', - '{joinedCompiledStyles}', - '</ss:Styles>', - '{joinedWorksheets}', - '</ss:Workbook>' - ), - - /** - * Adds the default Style to this workbook. This sets the default font face and size, as well as cell borders - */ - addDefaultStyle: function() { - var borderProperties = [ - {name: "Color", value: this.cellBorderColor}, - {name: "Weight", value: "1"}, - {name: "LineStyle", value: "Continuous"} - ]; - - this.addStyle({ - id: 'Default', - attributes: [ - { - name: "Alignment", - properties: [ - {name: "Vertical", value: "Top"}, - {name: "WrapText", value: "1"} - ] - }, - { - name: "Font", - properties: [ - {name: "FontName", value: "arial"}, - {name: "Size", value: "10"} - ] - }, - {name: "Interior"}, {name: "NumberFormat"}, {name: "Protection"}, - { - name: "Borders", - children: [ - { - name: "Border", - properties: [{name: "Position", value: "Top"}].concat(borderProperties) - }, - { - name: "Border", - properties: [{name: "Position", value: "Bottom"}].concat(borderProperties) - }, - { - name: "Border", - properties: [{name: "Position", value: "Left"}].concat(borderProperties) - }, - { - name: "Border", - properties: [{name: "Position", value: "Right"}].concat(borderProperties) - } - ] - } - ] - }); - }, - - addTitleStyle: function() { - this.addStyle({ - id: "title", - attributes: [ - {name: "Borders"}, - {name: "Font"}, - { - name: "NumberFormat", - properties: [ - {name: "Format", value: "@"} - ] - }, - { - name: "Alignment", - properties: [ - {name: "WrapText", value: "1"}, - {name: "Horizontal", value: "Center"}, - {name: "Vertical", value: "Center"} - ] - } - ] - }); - }, - - addHeaderStyle: function() { - this.addStyle({ - id: "headercell", - attributes: [ - { - name: "Font", - properties: [ - {name: "Bold", value: "1"}, - {name: "Size", value: "10"} - ] - }, - { - name: "Interior", - properties: [ - {name: "Pattern", value: "Solid"}, - {name: "Color", value: "#A3C9F1"} - ] - }, - { - name: "Alignment", - properties: [ - {name: "WrapText", value: "1"}, - {name: "Horizontal", value: "Center"} - ] - } - ] - }); - }, - - /** - * Adds the default striping styles to this workbook - */ - addStripedStyles: function() { - this.addStyle({ - id: "even", - attributes: [ - { - name: "Interior", - properties: [ - {name: "Pattern", value: "Solid"}, - {name: "Color", value: "#CCFFFF"} - ] - } - ] - }); - - this.addStyle({ - id: "odd", - attributes: [ - { - name: "Interior", - properties: [ - {name: "Pattern", value: "Solid"}, - {name: "Color", value: "#CCCCFF"} - ] - } - ] - }); - - Ext.each(['even', 'odd'], function(parentStyle) { - this.addChildNumberFormatStyle(parentStyle, parentStyle + 'date', "[ENG][$-409]dd\-mmm\-yyyy;@"); - this.addChildNumberFormatStyle(parentStyle, parentStyle + 'int', "0"); - this.addChildNumberFormatStyle(parentStyle, parentStyle + 'float', "0.00"); - }, this); - }, - - /** - * Private convenience function to easily add a NumberFormat style for a given parentStyle - * @param {String} parentStyle The ID of the parentStyle Style - * @param {String} id The ID of the new style - * @param {String} value The value of the NumberFormat's Format property - */ - addChildNumberFormatStyle: function(parentStyle, id, value) { - this.addStyle({ - id: id, - parentStyle: "even", - attributes: [ - { - name: "NumberFormat", - properties: [{name: "Format", value: value}] - } - ] - }); - } -});- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/excelFormatter/Worksheet.js b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/excelFormatter/Worksheet.js @@ -1,183 +0,0 @@ -/** - * @class Ext.ux.Exporter.ExcelFormatter.Worksheet - * @extends Object - * Represents an Excel worksheet - * @cfg {Ext.data.Store} store The store to use (required) - */ -Ext.define("Ext.ux.exporter.excelFormatter.Worksheet", { - - constructor: function(store, config) { - config = config || {}; - - this.store = store; - - Ext.applyIf(config, { - hasTitle : true, - hasHeadings: true, - stripeRows : true, - - title : "Workbook", - columns : store.fields == undefined ? {} : store.fields.items - }); - - Ext.apply(this, config); - - Ext.ux.exporter.excelFormatter.Worksheet.superclass.constructor.apply(this, arguments); - }, - - /** - * @property dateFormatString - * @type String - * String used to format dates (defaults to "Y-m-d"). All other data types are left unmolested - */ - dateFormatString: "Y-m-d", - - worksheetTpl: new Ext.XTemplate( - '<ss:Worksheet ss:Name="{title}">', - '<ss:Names>', - '<ss:NamedRange ss:Name="Print_Titles" ss:RefersTo="=\'{title}\'!R1:R2" />', - '</ss:Names>', - '<ss:Table x:FullRows="1" x:FullColumns="1" ss:ExpandedColumnCount="{colCount}" ss:ExpandedRowCount="{rowCount}">', - '{columns}', - '<ss:Row ss:Height="38">', - '<ss:Cell ss:StyleID="title" ss:MergeAcross="{colCount - 1}">', - '<ss:Data xmlns:html="http://www.w3.org/TR/REC-html40" ss:Type="String">', - '<html:B><html:U><html:Font html:Size="15">{title}', - '</html:Font></html:U></html:B></ss:Data><ss:NamedCell ss:Name="Print_Titles" />', - '</ss:Cell>', - '</ss:Row>', - '<ss:Row ss:AutoFitHeight="1">', - '{header}', - '</ss:Row>', - '{rows}', - '</ss:Table>', - '<x:WorksheetOptions>', - '<x:PageSetup>', - '<x:Layout x:CenterHorizontal="1" x:Orientation="Landscape" />', - '<x:Footer x:Data="Page &P of &N" x:Margin="0.5" />', - '<x:PageMargins x:Top="0.5" x:Right="0.5" x:Left="0.5" x:Bottom="0.8" />', - '</x:PageSetup>', - '<x:FitToPage />', - '<x:Print>', - '<x:PrintErrors>Blank</x:PrintErrors>', - '<x:FitWidth>1</x:FitWidth>', - '<x:FitHeight>32767</x:FitHeight>', - '<x:ValidPrinterInfo />', - '<x:VerticalResolution>600</x:VerticalResolution>', - '</x:Print>', - '<x:Selected />', - '<x:DoNotDisplayGridlines />', - '<x:ProtectObjects>False</x:ProtectObjects>', - '<x:ProtectScenarios>False</x:ProtectScenarios>', - '</x:WorksheetOptions>', - '</ss:Worksheet>' - ), - - /** - * Builds the Worksheet XML - * @param {Ext.data.Store} store The store to build from - */ - render: function(store) { - return this.worksheetTpl.apply({ - header : this.buildHeader(), - columns : this.buildColumns().join(""), - rows : this.buildRows().join(""), - colCount: this.columns.length, - rowCount: this.store.getCount() + 2, - title : this.title - }); - }, - - buildColumns: function() { - var cols = []; - - Ext.each(this.columns, function(column) { - cols.push(this.buildColumn()); - }, this); - - return cols; - }, - - buildColumn: function(width) { - return Ext.String.format('<ss:Column ss:AutoFitWidth="1" ss:Width="{0}" />', width || 164); - }, - - buildRows: function() { - var rows = []; - - this.store.each(function(record, index) { - rows.push(this.buildRow(record, index)); - }, this); - - return rows; - }, - - buildHeader: function() { - var cells = []; - - Ext.each(this.columns, function(col) { - var title; - - //if(col.dataIndex) { - if (col.text != undefined) { - title = col.text; - } else if(col.name) { - //make columns taken from Record fields (e.g. with a col.name) human-readable - title = col.name.replace(/_/g, " "); - title = Ext.String.capitalize(title); - } - - cells.push(Ext.String.format('<ss:Cell ss:StyleID="headercell"><ss:Data ss:Type="String">{0}</ss:Data><ss:NamedCell ss:Name="Print_Titles" /></ss:Cell>', title)); - //} - }, this); - - return cells.join(""); - }, - - buildRow: function(record, index) { - var style, - cells = []; - if (this.stripeRows === true) style = index % 2 == 0 ? 'even' : 'odd'; - - Ext.each(this.columns, function(col) { - var name = col.name || col.dataIndex; - - if(typeof name !== 'undefined') { - //if given a renderer via a ColumnModel, use it and ensure data type is set to String - if (Ext.isFunction(col.renderer)) { - var value = col.renderer(record.get(name), null, record), - type = "String"; - } else { - var value = record.get(name), - type = this.typeMappings[col.type || record.fields.get(name).type.type]; - } - - cells.push(this.buildCell(value, type, style).render()); - } - }, this); - - return Ext.String.format("<ss:Row>{0}</ss:Row>", cells.join("")); - }, - - buildCell: function(value, type, style) { - if (type == "DateTime" && Ext.isFunction(value.format)) value = value.format(this.dateFormatString); - - return new Ext.ux.exporter.excelFormatter.Cell({ - value: value, - type : type, - style: style - }); - }, - - /** - * @property typeMappings - * @type Object - * Mappings from Ext.data.Record types to Excel types - */ - typeMappings: { - 'int' : "Number", - 'string': "String", - 'float' : "Number", - 'date' : "DateTime" - } -});- \ No newline at end of file diff --git a/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/wikiFormatter/WikiFormatter.js b/src/PartKeepr/FrontendBundle/Resources/public/js/Ext.ux/Ext.ux.Exporter/wikiFormatter/WikiFormatter.js @@ -1,115 +0,0 @@ -/** - * @class Ext.ux.Exporter.WikiFormatter - * @extends Ext.ux.Exporter.Formatter - * Specialised Format class for outputting mediawiki tables - */ -Ext.define("Ext.ux.exporter.wikiFormatter.WikiFormatter", { - extend: "Ext.ux.exporter.Formatter", - - /** - * @cfg {String} contentType The content type to use. Defaults to 'data:text/plain;base64,' - */ - contentType: 'data:text/plain;base64,', - - /** - * @cfg {String} cls The table class. Defaults to "wikitable" - */ - cls: "wikitable", - - /** - * @cfg {String} extension The extension to use. Defaults to 'txt' - */ - extension: "txt", - - /** - * @cfg {String} lineSeparator The line separator to use. Defaults to "\n" - */ - lineSeparator: "\n", - - /** - * @cfg {Boolean} capitalizeHeaders Capitalizes the header fields. Defaults to false - */ - capitalizeHeaders: false, - - /** - * Formats the store to the wiki table format. - * @param store The store to export - * @param config {Object} [config] Config object. Contains the "columns" property, which is an array of field names. - */ - format: function(store, config) { - this.columns = config.columns || (store.fields ? store.fields.items : store.model.prototype.fields.items); - return "{|" + this.getHeaders() + this.lineSeparator + - this.getRows(store) + this.lineSeparator + "|}"; - }, - - /** - * Returns the headers for the specific store. - * - * @param {Object} store The store to process - * @returns {String} The header line - */ - getHeaders: function(store) { - var columns = []; - - Ext.each(this.columns, function(col) { - var title; - if (col.text != undefined) { - title = col.text; - } else if(col.name) { - title = col.name.replace(/_/g, " "); - } else { - title = ""; - } - - if (this.capitalizeHeaders) { - title = Ext.String.capitalize(title); - } - - columns.push("! " + title); - }, this); - - var retVal = ' class="'+ this.cls + '" valign="top"' + this.lineSeparator; - retVal += columns.join(this.lineSeparator); - - return retVal; - }, - /** - * Returns all rows for the store - * - * @param {Object} store The store to use - * @returns {String} - */ - getRows: function(store) { - var rows = []; - store.each(function(record) { - rows.push("|-" + this.lineSeparator + this.getCells(record)); - }, this); - - return rows.join(this.lineSeparator); - }, - /** - * Returns the cells for a specific row - * @param {Object} record The record - * @returns {String} The cells of the record - */ - getCells: function(record) { - var cells = []; - - Ext.each(this.columns, function(col) { - var name = col.name || col.dataIndex; - var value = ""; - - if(typeof name !== 'undefined') { - if (Ext.isFunction(col.renderer)) { - value = col.renderer(record.get(name), null, record); - } else { - value = record.get(name); - } - - cells.push("| " + value); - } - }); - - return cells.join(this.lineSeparator); - } -});- \ No newline at end of file
