diff options
Diffstat (limited to 'dbdocs/bower/datatables.net-buttons/buttons.html5.js')
| -rw-r--r-- | dbdocs/bower/datatables.net-buttons/buttons.html5.js | 1370 |
1 files changed, 1370 insertions, 0 deletions
diff --git a/dbdocs/bower/datatables.net-buttons/buttons.html5.js b/dbdocs/bower/datatables.net-buttons/buttons.html5.js new file mode 100644 index 0000000..f27aadf --- /dev/null +++ b/dbdocs/bower/datatables.net-buttons/buttons.html5.js @@ -0,0 +1,1370 @@ +/*! + * HTML5 export buttons for Buttons and DataTables. + * 2016 SpryMedia Ltd - datatables.net/license + * + * FileSaver.js (1.3.3) - MIT license + * Copyright © 2016 Eli Grey - http://eligrey.com + */ + +(function( factory ){ + if ( typeof define === 'function' && define.amd ) { + // AMD + define( ['jquery', 'datatables.net', 'datatables.net-buttons'], function ( $ ) { + return factory( $, window, document ); + } ); + } + else if ( typeof exports === 'object' ) { + // CommonJS + module.exports = function (root, $, jszip, pdfmake) { + if ( ! root ) { + root = window; + } + + if ( ! $ || ! $.fn.dataTable ) { + $ = require('datatables.net')(root, $).$; + } + + if ( ! $.fn.dataTable.Buttons ) { + require('datatables.net-buttons')(root, $); + } + + return factory( $, root, root.document, jszip, pdfmake ); + }; + } + else { + // Browser + factory( jQuery, window, document ); + } +}(function( $, window, document, jszip, pdfmake, undefined ) { +'use strict'; +var DataTable = $.fn.dataTable; + +// Allow the constructor to pass in JSZip and PDFMake from external requires. +// Otherwise, use globally defined variables, if they are available. +function _jsZip () { + return jszip || window.JSZip; +} +function _pdfMake () { + return pdfmake || window.pdfMake; +} + + +/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + * FileSaver.js dependency + */ + +/*jslint bitwise: true, indent: 4, laxbreak: true, laxcomma: true, smarttabs: true, plusplus: true */ + +var _saveAs = (function(view) { + "use strict"; + // IE <10 is explicitly unsupported + if (typeof view === "undefined" || typeof navigator !== "undefined" && /MSIE [1-9]\./.test(navigator.userAgent)) { + return; + } + var + doc = view.document + // only get URL when necessary in case Blob.js hasn't overridden it yet + , get_URL = function() { + return view.URL || view.webkitURL || view; + } + , save_link = doc.createElementNS("http://www.w3.org/1999/xhtml", "a") + , can_use_save_link = "download" in save_link + , click = function(node) { + var event = new MouseEvent("click"); + node.dispatchEvent(event); + } + , is_safari = /constructor/i.test(view.HTMLElement) || view.safari + , is_chrome_ios =/CriOS\/[\d]+/.test(navigator.userAgent) + , throw_outside = function(ex) { + (view.setImmediate || view.setTimeout)(function() { + throw ex; + }, 0); + } + , force_saveable_type = "application/octet-stream" + // the Blob API is fundamentally broken as there is no "downloadfinished" event to subscribe to + , arbitrary_revoke_timeout = 1000 * 40 // in ms + , revoke = function(file) { + var revoker = function() { + if (typeof file === "string") { // file is an object URL + get_URL().revokeObjectURL(file); + } else { // file is a File + file.remove(); + } + }; + setTimeout(revoker, arbitrary_revoke_timeout); + } + , dispatch = function(filesaver, event_types, event) { + event_types = [].concat(event_types); + var i = event_types.length; + while (i--) { + var listener = filesaver["on" + event_types[i]]; + if (typeof listener === "function") { + try { + listener.call(filesaver, event || filesaver); + } catch (ex) { + throw_outside(ex); + } + } + } + } + , auto_bom = function(blob) { + // prepend BOM for UTF-8 XML and text/* types (including HTML) + // note: your browser will automatically convert UTF-16 U+FEFF to EF BB BF + if (/^\s*(?:text\/\S*|application\/xml|\S*\/\S*\+xml)\s*;.*charset\s*=\s*utf-8/i.test(blob.type)) { + return new Blob([String.fromCharCode(0xFEFF), blob], {type: blob.type}); + } + return blob; + } + , FileSaver = function(blob, name, no_auto_bom) { + if (!no_auto_bom) { + blob = auto_bom(blob); + } + // First try a.download, then web filesystem, then object URLs + var + filesaver = this + , type = blob.type + , force = type === force_saveable_type + , object_url + , dispatch_all = function() { + dispatch(filesaver, "writestart progress write writeend".split(" ")); + } + // on any filesys errors revert to saving with object URLs + , fs_error = function() { + if ((is_chrome_ios || (force && is_safari)) && view.FileReader) { + // Safari doesn't allow downloading of blob urls + var reader = new FileReader(); + reader.onloadend = function() { + var url = is_chrome_ios ? reader.result : reader.result.replace(/^data:[^;]*;/, 'data:attachment/file;'); + var popup = view.open(url, '_blank'); + if(!popup) view.location.href = url; + url=undefined; // release reference before dispatching + filesaver.readyState = filesaver.DONE; + dispatch_all(); + }; + reader.readAsDataURL(blob); + filesaver.readyState = filesaver.INIT; + return; + } + // don't create more object URLs than needed + if (!object_url) { + object_url = get_URL().createObjectURL(blob); + } + if (force) { + view.location.href = object_url; + } else { + var opened = view.open(object_url, "_blank"); + if (!opened) { + // Apple does not allow window.open, see https://developer.apple.com/library/safari/documentation/Tools/Conceptual/SafariExtensionGuide/WorkingwithWindowsandTabs/WorkingwithWindowsandTabs.html + view.location.href = object_url; + } + } + filesaver.readyState = filesaver.DONE; + dispatch_all(); + revoke(object_url); + } + ; + filesaver.readyState = filesaver.INIT; + + if (can_use_save_link) { + object_url = get_URL().createObjectURL(blob); + setTimeout(function() { + save_link.href = object_url; + save_link.download = name; + click(save_link); + dispatch_all(); + revoke(object_url); + filesaver.readyState = filesaver.DONE; + }); + return; + } + + fs_error(); + } + , FS_proto = FileSaver.prototype + , saveAs = function(blob, name, no_auto_bom) { + return new FileSaver(blob, name || blob.name || "download", no_auto_bom); + } + ; + // IE 10+ (native saveAs) + if (typeof navigator !== "undefined" && navigator.msSaveOrOpenBlob) { + return function(blob, name, no_auto_bom) { + name = name || blob.name || "download"; + + if (!no_auto_bom) { + blob = auto_bom(blob); + } + return navigator.msSaveOrOpenBlob(blob, name); + }; + } + + FS_proto.abort = function(){}; + FS_proto.readyState = FS_proto.INIT = 0; + FS_proto.WRITING = 1; + FS_proto.DONE = 2; + + FS_proto.error = + FS_proto.onwritestart = + FS_proto.onprogress = + FS_proto.onwrite = + FS_proto.onabort = + FS_proto.onerror = + FS_proto.onwriteend = + null; + + return saveAs; +}( + typeof self !== "undefined" && self + || typeof window !== "undefined" && window + || this.content +)); + + +// Expose file saver on the DataTables API. Can't attach to `DataTables.Buttons` +// since this file can be loaded before Button's core! +DataTable.fileSave = _saveAs; + + +/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + * Local (private) functions + */ + +/** + * Get the file name for an exported file. + * + * @param {object} config Button configuration + * @param {boolean} incExtension Include the file name extension + */ +var _filename = function ( config, incExtension ) +{ + // Backwards compatibility + var filename = config.filename === '*' && config.title !== '*' && config.title !== undefined ? + config.title : + config.filename; + + if ( typeof filename === 'function' ) { + filename = filename(); + } + + if ( filename.indexOf( '*' ) !== -1 ) { + filename = $.trim( filename.replace( '*', $('title').text() ) ); + } + + // Strip characters which the OS will object to + filename = filename.replace(/[^a-zA-Z0-9_\u00A1-\uFFFF\.,\-_ !\(\)]/g, ""); + + return incExtension === undefined || incExtension === true ? + filename+config.extension : + filename; +}; + +/** + * Get the sheet name for Excel exports. + * + * @param {object} config Button configuration + */ +var _sheetname = function ( config ) +{ + var sheetName = 'Sheet1'; + + if ( config.sheetName ) { + sheetName = config.sheetName.replace(/[\[\]\*\/\\\?\:]/g, ''); + } + +return sheetName; +}; + +/** + * Get the title for an exported file. + * + * @param {object} config Button configuration + */ +var _title = function ( config ) +{ + var title = config.title; + + if ( typeof title === 'function' ) { + title = title(); + } + + return title.indexOf( '*' ) !== -1 ? + title.replace( '*', $('title').text() || 'Exported data' ) : + title; +}; + +/** + * Get the newline character(s) + * + * @param {object} config Button configuration + * @return {string} Newline character + */ +var _newLine = function ( config ) +{ + return config.newline ? + config.newline : + navigator.userAgent.match(/Windows/) ? + '\r\n' : + '\n'; +}; + +/** + * Combine the data from the `buttons.exportData` method into a string that + * will be used in the export file. + * + * @param {DataTable.Api} dt DataTables API instance + * @param {object} config Button configuration + * @return {object} The data to export + */ +var _exportData = function ( dt, config ) +{ + var newLine = _newLine( config ); + var data = dt.buttons.exportData( config.exportOptions ); + var boundary = config.fieldBoundary; + var separator = config.fieldSeparator; + var reBoundary = new RegExp( boundary, 'g' ); + var escapeChar = config.escapeChar !== undefined ? + config.escapeChar : + '\\'; + var join = function ( a ) { + var s = ''; + + // If there is a field boundary, then we might need to escape it in + // the source data + for ( var i=0, ien=a.length ; i<ien ; i++ ) { + if ( i > 0 ) { + s += separator; + } + + s += boundary ? + boundary + ('' + a[i]).replace( reBoundary, escapeChar+boundary ) + boundary : + a[i]; + } + + return s; + }; + + var header = config.header ? join( data.header )+newLine : ''; + var footer = config.footer && data.footer ? newLine+join( data.footer ) : ''; + var body = []; + + for ( var i=0, ien=data.body.length ; i<ien ; i++ ) { + body.push( join( data.body[i] ) ); + } + + return { + str: header + body.join( newLine ) + footer, + rows: body.length + }; +}; + +/** + * Older versions of Safari (prior to tech preview 18) don't support the + * download option required. + * + * @return {Boolean} `true` if old Safari + */ +var _isDuffSafari = function () +{ + var safari = navigator.userAgent.indexOf('Safari') !== -1 && + navigator.userAgent.indexOf('Chrome') === -1 && + navigator.userAgent.indexOf('Opera') === -1; + + if ( ! safari ) { + return false; + } + + var version = navigator.userAgent.match( /AppleWebKit\/(\d+\.\d+)/ ); + if ( version && version.length > 1 && version[1]*1 < 603.1 ) { + return true; + } + + return false; +}; + +/** + * Convert from numeric position to letter for column names in Excel + * @param {int} n Column number + * @return {string} Column letter(s) name + */ +function createCellPos( n ){ + var ordA = 'A'.charCodeAt(0); + var ordZ = 'Z'.charCodeAt(0); + var len = ordZ - ordA + 1; + var s = ""; + + while( n >= 0 ) { + s = String.fromCharCode(n % len + ordA) + s; + n = Math.floor(n / len) - 1; + } + + return s; +} + +try { + var _serialiser = new XMLSerializer(); + var _ieExcel; +} +catch (t) {} + +/** + * Recursively add XML files from an object's structure to a ZIP file. This + * allows the XSLX file to be easily defined with an object's structure matching + * the files structure. + * + * @param {JSZip} zip ZIP package + * @param {object} obj Object to add (recursive) + */ +function _addToZip( zip, obj ) { + if ( _ieExcel === undefined ) { + // Detect if we are dealing with IE's _awful_ serialiser by seeing if it + // drop attributes + _ieExcel = _serialiser + .serializeToString( + $.parseXML( excelStrings['xl/worksheets/sheet1.xml'] ) + ) + .indexOf( 'xmlns:r' ) === -1; + } + + $.each( obj, function ( name, val ) { + if ( $.isPlainObject( val ) ) { + var newDir = zip.folder( name ); + _addToZip( newDir, val ); + } + else { + if ( _ieExcel ) { + // IE's XML serialiser will drop some name space attributes from + // from the root node, so we need to save them. Do this by + // replacing the namespace nodes with a regular attribute that + // we convert back when serialised. Edge does not have this + // issue + var worksheet = val.childNodes[0]; + var i, ien; + var attrs = []; + + for ( i=worksheet.attributes.length-1 ; i>=0 ; i-- ) { + var attrName = worksheet.attributes[i].nodeName; + var attrValue = worksheet.attributes[i].nodeValue; + + if ( attrName.indexOf( ':' ) !== -1 ) { + attrs.push( { name: attrName, value: attrValue } ); + + worksheet.removeAttribute( attrName ); + } + } + + for ( i=0, ien=attrs.length ; i<ien ; i++ ) { + var attr = val.createAttribute( attrs[i].name.replace( ':', '_dt_b_namespace_token_' ) ); + attr.value = attrs[i].value; + worksheet.setAttributeNode( attr ); + } + } + + var str = _serialiser.serializeToString(val); + + // Fix IE's XML + if ( _ieExcel ) { + // IE doesn't include the XML declaration + if ( str.indexOf( '<?xml' ) === -1 ) { + str = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+str; + } + + // Return namespace attributes to being as such + str = str.replace( /_dt_b_namespace_token_/g, ':' ); + } + + // Safari, IE and Edge will put empty name space attributes onto + // various elements making them useless. This strips them out + str = str.replace( /<([^<>]*?) xmlns=""([^<>]*?)>/g, '<$1 $2>' ); + + zip.file( name, str ); + } + } ); +} + +/** + * Create an XML node and add any children, attributes, etc without needing to + * be verbose in the DOM. + * + * @param {object} doc XML document + * @param {string} nodeName Node name + * @param {object} opts Options - can be `attr` (attributes), `children` + * (child nodes) and `text` (text content) + * @return {node} Created node + */ +function _createNode( doc, nodeName, opts ) { + var tempNode = doc.createElement( nodeName ); + + if ( opts ) { + if ( opts.attr ) { + $(tempNode).attr( opts.attr ); + } + + if( opts.children ) { + $.each( opts.children, function ( key, value ) { + tempNode.appendChild( value ); + }); + } + + if( opts.text ) { + tempNode.appendChild( doc.createTextNode( opts.text ) ); + } + } + + return tempNode; +} + +/** + * Get the width for an Excel column based on the contents of that column + * @param {object} data Data for export + * @param {int} col Column index + * @return {int} Column width + */ +function _excelColWidth( data, col ) { + var max = data.header[col].length; + var len, lineSplit, str; + + if ( data.footer && data.footer[col].length > max ) { + max = data.footer[col].length; + } + + for ( var i=0, ien=data.body.length ; i<ien ; i++ ) { + var point = data.body[i][col]; + str = point !== null && point !== undefined ? + point.toString() : + ''; + + // If there is a newline character, workout the width of the column + // based on the longest line in the string + if ( str.indexOf('\n') !== -1 ) { + lineSplit = str.split('\n'); + lineSplit.sort( function (a, b) { + return b.length - a.length; + } ); + + len = lineSplit[0].length; + } + else { + len = str.length; + } + + if ( len > max ) { + max = len; + } + + // Max width rather than having potentially massive column widths + if ( max > 40 ) { + return 52; // 40 * 1.3 + } + } + + max *= 1.3; + + // And a min width + return max > 6 ? max : 6; +} + +// Excel - Pre-defined strings to build a basic XLSX file +var excelStrings = { + "_rels/.rels": + '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ + '<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">'+ + '<Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/>'+ + '</Relationships>', + + "xl/_rels/workbook.xml.rels": + '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ + '<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">'+ + '<Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml"/>'+ + '<Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" Target="styles.xml"/>'+ + '</Relationships>', + + "[Content_Types].xml": + '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ + '<Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types">'+ + '<Default Extension="xml" ContentType="application/xml" />'+ + '<Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml" />'+ + '<Default Extension="jpeg" ContentType="image/jpeg" />'+ + '<Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml" />'+ + '<Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml" />'+ + '<Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml" />'+ + '</Types>', + + "xl/workbook.xml": + '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ + '<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">'+ + '<fileVersion appName="xl" lastEdited="5" lowestEdited="5" rupBuild="24816"/>'+ + '<workbookPr showInkAnnotation="0" autoCompressPictures="0"/>'+ + '<bookViews>'+ + '<workbookView xWindow="0" yWindow="0" windowWidth="25600" windowHeight="19020" tabRatio="500"/>'+ + '</bookViews>'+ + '<sheets>'+ + '<sheet name="" sheetId="1" r:id="rId1"/>'+ + '</sheets>'+ + '</workbook>', + + "xl/worksheets/sheet1.xml": + '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ + '<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">'+ + '<sheetData/>'+ + '</worksheet>', + + "xl/styles.xml": + '<?xml version="1.0" encoding="UTF-8"?>'+ + '<styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">'+ + '<numFmts count="6">'+ + '<numFmt numFmtId="164" formatCode="#,##0.00_-\ [$$-45C]"/>'+ + '<numFmt numFmtId="165" formatCode=""£"#,##0.00"/>'+ + '<numFmt numFmtId="166" formatCode="[$€-2]\ #,##0.00"/>'+ + '<numFmt numFmtId="167" formatCode="0.0%"/>'+ + '<numFmt numFmtId="168" formatCode="#,##0;(#,##0)"/>'+ + '<numFmt numFmtId="169" formatCode="#,##0.00;(#,##0.00)"/>'+ + '</numFmts>'+ + '<fonts count="5" x14ac:knownFonts="1">'+ + '<font>'+ + '<sz val="11" />'+ + '<name val="Calibri" />'+ + '</font>'+ + '<font>'+ + '<sz val="11" />'+ + '<name val="Calibri" />'+ + '<color rgb="FFFFFFFF" />'+ + '</font>'+ + '<font>'+ + '<sz val="11" />'+ + '<name val="Calibri" />'+ + '<b />'+ + '</font>'+ + '<font>'+ + '<sz val="11" />'+ + '<name val="Calibri" />'+ + '<i />'+ + '</font>'+ + '<font>'+ + '<sz val="11" />'+ + '<name val="Calibri" />'+ + '<u />'+ + '</font>'+ + '</fonts>'+ + '<fills count="6">'+ + '<fill>'+ + '<patternFill patternType="none" />'+ + '</fill>'+ + '<fill/>'+ // Excel appears to use this as a dotted background regardless of values + '<fill>'+ + '<patternFill patternType="solid">'+ + '<fgColor rgb="FFD9D9D9" />'+ + '<bgColor indexed="64" />'+ + '</patternFill>'+ + '</fill>'+ + '<fill>'+ + '<patternFill patternType="solid">'+ + '<fgColor rgb="FFD99795" />'+ + '<bgColor indexed="64" />'+ + '</patternFill>'+ + '</fill>'+ + '<fill>'+ + '<patternFill patternType="solid">'+ + '<fgColor rgb="ffc6efce" />'+ + '<bgColor indexed="64" />'+ + '</patternFill>'+ + '</fill>'+ + '<fill>'+ + '<patternFill patternType="solid">'+ + '<fgColor rgb="ffc6cfef" />'+ + '<bgColor indexed="64" />'+ + '</patternFill>'+ + '</fill>'+ + '</fills>'+ + '<borders count="2">'+ + '<border>'+ + '<left />'+ + '<right />'+ + '<top />'+ + '<bottom />'+ + '<diagonal />'+ + '</border>'+ + '<border diagonalUp="false" diagonalDown="false">'+ + '<left style="thin">'+ + '<color auto="1" />'+ + '</left>'+ + '<right style="thin">'+ + '<color auto="1" />'+ + '</right>'+ + '<top style="thin">'+ + '<color auto="1" />'+ + '</top>'+ + '<bottom style="thin">'+ + '<color auto="1" />'+ + '</bottom>'+ + '<diagonal />'+ + '</border>'+ + '</borders>'+ + '<cellStyleXfs count="1">'+ + '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" />'+ + '</cellStyleXfs>'+ + '<cellXfs count="67">'+ + '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="1" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="2" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="3" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="4" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="0" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="1" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="2" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="3" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="4" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="0" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="1" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="2" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="3" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="4" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="0" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="1" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="2" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="3" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="4" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="0" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="1" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="2" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="3" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="4" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="0" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="1" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="2" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="3" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="4" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="0" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="1" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="2" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="3" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="4" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="0" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="1" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="2" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="3" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="4" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="0" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="1" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="2" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="3" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="4" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="0" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="1" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="2" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="3" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="4" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ + '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ + '<alignment horizontal="left"/>'+ + '</xf>'+ + '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ + '<alignment horizontal="center"/>'+ + '</xf>'+ + '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ + '<alignment horizontal="right"/>'+ + '</xf>'+ + '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ + '<alignment horizontal="fill"/>'+ + '</xf>'+ + '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ + '<alignment textRotation="90"/>'+ + '</xf>'+ + '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ + '<alignment wrapText="1"/>'+ + '</xf>'+ + '<xf numFmtId="9" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ + '<xf numFmtId="164" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ + '<xf numFmtId="165" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ + '<xf numFmtId="166" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ + '<xf numFmtId="167" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ + '<xf numFmtId="168" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ + '<xf numFmtId="169" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ + '<xf numFmtId="3" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ + '<xf numFmtId="4" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ + '<xf numFmtId="1" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ + '<xf numFmtId="2" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ + '</cellXfs>'+ + '<cellStyles count="1">'+ + '<cellStyle name="Normal" xfId="0" builtinId="0" />'+ + '</cellStyles>'+ + '<dxfs count="0" />'+ + '<tableStyles count="0" defaultTableStyle="TableStyleMedium9" defaultPivotStyle="PivotStyleMedium4" />'+ + '</styleSheet>' +}; +// Note we could use 3 `for` loops for the styles, but when gzipped there is +// virtually no difference in size, since the above can be easily compressed + +// Pattern matching for special number formats. Perhaps this should be exposed +// via an API in future? +// Ref: section 3.8.30 - built in formatters in open spreadsheet +// https://www.ecma-international.org/news/TC45_current_work/Office%20Open%20XML%20Part%204%20-%20Markup%20Language%20Reference.pdf +var _excelSpecials = [ + { match: /^\-?\d+\.\d%$/, style: 60, fmt: function (d) { return d/100; } }, // Precent with d.p. + { match: /^\-?\d+\.?\d*%$/, style: 56, fmt: function (d) { return d/100; } }, // Percent + { match: /^\-?\$[\d,]+.?\d*$/, style: 57 }, // Dollars + { match: /^\-?£[\d,]+.?\d*$/, style: 58 }, // Pounds + { match: /^\-?€[\d,]+.?\d*$/, style: 59 }, // Euros + { match: /^\-?\d+$/, style: 65 }, // Numbers without thousand separators + { match: /^\-?\d+\.\d{2}$/, style: 66 }, // Numbers 2 d.p. without thousands separators + { match: /^\([\d,]+\)$/, style: 61, fmt: function (d) { return -1 * d.replace(/[\(\)]/g, ''); } }, // Negative numbers indicated by brackets + { match: /^\([\d,]+\.\d{2}\)$/, style: 62, fmt: function (d) { return -1 * d.replace(/[\(\)]/g, ''); } }, // Negative numbers indicated by brackets - 2d.p. + { match: /^\-?[\d,]+$/, style: 63 }, // Numbers with thousand separators + { match: /^\-?[\d,]+\.\d{2}$/, style: 64 } // Numbers with 2 d.p. and thousands separators +]; + + + +/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + * Buttons + */ + +// +// Copy to clipboard +// +DataTable.ext.buttons.copyHtml5 = { + className: 'buttons-copy buttons-html5', + + text: function ( dt ) { + return dt.i18n( 'buttons.copy', 'Copy' ); + }, + + action: function ( e, dt, button, config ) { + this.processing( true ); + + var that = this; + var exportData = _exportData( dt, config ); + var output = exportData.str; + var hiddenDiv = $('<div/>') + .css( { + height: 1, + width: 1, + overflow: 'hidden', + position: 'fixed', + top: 0, + left: 0 + } ); + + if ( config.customize ) { + output = config.customize( output, config ); + } + + var textarea = $('<textarea readonly/>') + .val( output ) + .appendTo( hiddenDiv ); + + // For browsers that support the copy execCommand, try to use it + if ( document.queryCommandSupported('copy') ) { + hiddenDiv.appendTo( dt.table().container() ); + textarea[0].focus(); + textarea[0].select(); + + try { + var successful = document.execCommand( 'copy' ); + hiddenDiv.remove(); + + if (successful) { + dt.buttons.info( + dt.i18n( 'buttons.copyTitle', 'Copy to clipboard' ), + dt.i18n( 'buttons.copySuccess', { + 1: 'Copied one row to clipboard', + _: 'Copied %d rows to clipboard' + }, exportData.rows ), + 2000 + ); + + this.processing( false ); + return; + } + } + catch (t) {} + } + + // Otherwise we show the text box and instruct the user to use it + var message = $('<span>'+dt.i18n( 'buttons.copyKeys', + 'Press <i>ctrl</i> or <i>\u2318</i> + <i>C</i> to copy the table data<br>to your system clipboard.<br><br>'+ + 'To cancel, click this message or press escape.' )+'</span>' + ) + .append( hiddenDiv ); + + dt.buttons.info( dt.i18n( 'buttons.copyTitle', 'Copy to clipboard' ), message, 0 ); + + // Select the text so when the user activates their system clipboard + // it will copy that text + textarea[0].focus(); + textarea[0].select(); + + // Event to hide the message when the user is done + var container = $(message).closest('.dt-button-info'); + var close = function () { + container.off( 'click.buttons-copy' ); + $(document).off( '.buttons-copy' ); + dt.buttons.info( false ); + }; + + container.on( 'click.buttons-copy', close ); + $(document) + .on( 'keydown.buttons-copy', function (e) { + if ( e.keyCode === 27 ) { // esc + close(); + that.processing( false ); + } + } ) + .on( 'copy.buttons-copy cut.buttons-copy', function () { + close(); + that.processing( false ); + } ); + }, + + exportOptions: {}, + + fieldSeparator: '\t', + + fieldBoundary: '', + + header: true, + + footer: false +}; + +// +// CSV export +// +DataTable.ext.buttons.csvHtml5 = { + bom: false, + + className: 'buttons-csv buttons-html5', + + available: function () { + return window.FileReader !== undefined && window.Blob; + }, + + text: function ( dt ) { + return dt.i18n( 'buttons.csv', 'CSV' ); + }, + + action: function ( e, dt, button, config ) { + this.processing( true ); + + // Set the text + var output = _exportData( dt, config ).str; + var charset = config.charset; + + if ( config.customize ) { + output = config.customize( output, config ); + } + + if ( charset !== false ) { + if ( ! charset ) { + charset = document.characterSet || document.charset; + } + + if ( charset ) { + charset = ';charset='+charset; + } + } + else { + charset = ''; + } + + if ( config.bom ) { + output = '\ufeff' + output; + } + + _saveAs( + new Blob( [output], {type: 'text/csv'+charset} ), + _filename( config ), + true + ); + + this.processing( false ); + }, + + filename: '*', + + extension: '.csv', + + exportOptions: {}, + + fieldSeparator: ',', + + fieldBoundary: '"', + + escapeChar: '"', + + charset: null, + + header: true, + + footer: false +}; + +// +// Excel (xlsx) export +// +DataTable.ext.buttons.excelHtml5 = { + className: 'buttons-excel buttons-html5', + + available: function () { + return window.FileReader !== undefined && _jsZip() !== undefined && ! _isDuffSafari() && _serialiser; + }, + + text: function ( dt ) { + return dt.i18n( 'buttons.excel', 'Excel' ); + }, + + action: function ( e, dt, button, config ) { + this.processing( true ); + + var that = this; + var rowPos = 0; + var getXml = function ( type ) { + var str = excelStrings[ type ]; + + //str = str.replace( /xmlns:/g, 'xmlns_' ).replace( /mc:/g, 'mc_' ); + + return $.parseXML( str ); + }; + var rels = getXml('xl/worksheets/sheet1.xml'); + var relsGet = rels.getElementsByTagName( "sheetData" )[0]; + + var xlsx = { + _rels: { + ".rels": getXml('_rels/.rels') + }, + xl: { + _rels: { + "workbook.xml.rels": getXml('xl/_rels/workbook.xml.rels') + }, + "workbook.xml": getXml('xl/workbook.xml'), + "styles.xml": getXml('xl/styles.xml'), + "worksheets": { + "sheet1.xml": rels + } + + }, + "[Content_Types].xml": getXml('[Content_Types].xml') + }; + + var data = dt.buttons.exportData( config.exportOptions ); + var currentRow, rowNode; + var addRow = function ( row ) { + currentRow = rowPos+1; + rowNode = _createNode( rels, "row", { attr: {r:currentRow} } ); + + for ( var i=0, ien=row.length ; i<ien ; i++ ) { + // Concat both the Cell Columns as a letter and the Row of the cell. + var cellId = createCellPos(i) + '' + currentRow; + var cell = null; + + // For null, undefined of blank cell, continue so it doesn't create the _createNode + if ( row[i] === null || row[i] === undefined || row[i] === '' ) { + continue; + } + + row[i] = $.trim( row[i] ); + + // Special number formatting options + for ( var j=0, jen=_excelSpecials.length ; j<jen ; j++ ) { + var special = _excelSpecials[j]; + + // TODO Need to provide the ability for the specials to say + // if they are returning a string, since at the moment it is + // assumed to be a number + if ( row[i].match && ! row[i].match(/^0\d+/) && row[i].match( special.match ) ) { + var val = row[i].replace(/[^\d\.\-]/g, ''); + + if ( special.fmt ) { + val = special.fmt( val ); + } + + cell = _createNode( rels, 'c', { + attr: { + r: cellId, + s: special.style + }, + children: [ + _createNode( rels, 'v', { text: val } ) + ] + } ); + + break; + } + } + + if ( ! cell ) { + if ( typeof row[i] === 'number' || ( + row[i].match && + row[i].match(/^-?\d+(\.\d+)?$/) && + ! row[i].match(/^0\d+/) ) + ) { + // Detect numbers - don't match numbers with leading zeros + // or a negative anywhere but the start + cell = _createNode( rels, 'c', { + attr: { + t: 'n', + r: cellId + }, + children: [ + _createNode( rels, 'v', { text: row[i] } ) + ] + } ); + } + else { + // String output - replace non standard characters for text output + var text = ! row[i].replace ? + row[i] : + row[i].replace(/[\x00-\x09\x0B\x0C\x0E-\x1F\x7F-\x9F]/g, ''); + + cell = _createNode( rels, 'c', { + attr: { + t: 'inlineStr', + r: cellId + }, + children:{ + row: _createNode( rels, 'is', { + children: { + row: _createNode( rels, 't', { + text: text + } ) + } + } ) + } + } ); + } + } + + rowNode.appendChild( cell ); + } + + relsGet.appendChild(rowNode); + rowPos++; + }; + + $( 'sheets sheet', xlsx.xl['workbook.xml'] ).attr( 'name', _sheetname( config ) ); + + if ( config.customizeData ) { + config.customizeData( data ); + } + + if ( config.header ) { + addRow( data.header, rowPos ); + $('row c', rels).attr( 's', '2' ); // bold + } + + for ( var n=0, ie=data.body.length ; n<ie ; n++ ) { + addRow( data.body[n], rowPos ); + } + + if ( config.footer && data.footer ) { + addRow( data.footer, rowPos); + $('row:last c', rels).attr( 's', '2' ); // bold + } + + // Set column widths + var cols = _createNode( rels, 'cols' ); + $('worksheet', rels).prepend( cols ); + + for ( var i=0, ien=data.header.length ; i<ien ; i++ ) { + cols.appendChild( _createNode( rels, 'col', { + attr: { + min: i+1, + max: i+1, + width: _excelColWidth( data, i ), + customWidth: 1 + } + } ) ); + } + + // Let the developer customise the document if they want to + if ( config.customize ) { + config.customize( xlsx ); + } + + var jszip = _jsZip(); + var zip = new jszip(); + var zipConfig = { + type: 'blob', + mimeType: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' + }; + + _addToZip( zip, xlsx ); + + if ( zip.generateAsync ) { + // JSZip 3+ + zip + .generateAsync( zipConfig ) + .then( function ( blob ) { + _saveAs( blob, _filename( config ) ); + that.processing( false ); + } ); + } + else { + // JSZip 2.5 + _saveAs( + zip.generate( zipConfig ), + _filename( config ) + ); + this.processing( false ); + } + }, + + filename: '*', + + extension: '.xlsx', + + exportOptions: {}, + + header: true, + + footer: false +}; + +// +// PDF export - using pdfMake - http://pdfmake.org +// +DataTable.ext.buttons.pdfHtml5 = { + className: 'buttons-pdf buttons-html5', + + available: function () { + return window.FileReader !== undefined && _pdfMake(); + }, + + text: function ( dt ) { + return dt.i18n( 'buttons.pdf', 'PDF' ); + }, + + action: function ( e, dt, button, config ) { + this.processing( true ); + + var that = this; + var data = dt.buttons.exportData( config.exportOptions ); + var rows = []; + + if ( config.header ) { + rows.push( $.map( data.header, function ( d ) { + return { + text: typeof d === 'string' ? d : d+'', + style: 'tableHeader' + }; + } ) ); + } + + for ( var i=0, ien=data.body.length ; i<ien ; i++ ) { + rows.push( $.map( data.body[i], function ( d ) { + return { + text: typeof d === 'string' ? d : d+'', + style: i % 2 ? 'tableBodyEven' : 'tableBodyOdd' + }; + } ) ); + } + + if ( config.footer && data.footer) { + rows.push( $.map( data.footer, function ( d ) { + return { + text: typeof d === 'string' ? d : d+'', + style: 'tableFooter' + }; + } ) ); + } + + var doc = { + pageSize: config.pageSize, + pageOrientation: config.orientation, + content: [ + { + table: { + headerRows: 1, + body: rows + }, + layout: 'noBorders' + } + ], + styles: { + tableHeader: { + bold: true, + fontSize: 11, + color: 'white', + fillColor: '#2d4154', + alignment: 'center' + }, + tableBodyEven: {}, + tableBodyOdd: { + fillColor: '#f3f3f3' + }, + tableFooter: { + bold: true, + fontSize: 11, + color: 'white', + fillColor: '#2d4154' + }, + title: { + alignment: 'center', + fontSize: 15 + }, + message: {} + }, + defaultStyle: { + fontSize: 10 + } + }; + + if ( config.message ) { + doc.content.unshift( { + text: typeof config.message == 'function' ? config.message(dt, button, config) : config.message, + style: 'message', + margin: [ 0, 0, 0, 12 ] + } ); + } + + if ( config.title ) { + doc.content.unshift( { + text: _title( config, false ), + style: 'title', + margin: [ 0, 0, 0, 12 ] + } ); + } + + if ( config.customize ) { + config.customize( doc, config ); + } + + var pdf = _pdfMake().createPdf( doc ); + + if ( config.download === 'open' && ! _isDuffSafari() ) { + pdf.open(); + this.processing( false ); + } + else { + pdf.getBuffer( function (buffer) { + var blob = new Blob( [buffer], {type:'application/pdf'} ); + + _saveAs( blob, _filename( config ) ); + that.processing( false ); + } ); + } + }, + + title: '*', + + filename: '*', + + extension: '.pdf', + + exportOptions: {}, + + orientation: 'portrait', + + pageSize: 'A4', + + header: true, + + footer: false, + + message: null, + + customize: null, + + download: 'download' +}; + + +return DataTable.Buttons; +})); |