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, 0 insertions, 1370 deletions
diff --git a/dbdocs/bower/datatables.net-buttons/buttons.html5.js b/dbdocs/bower/datatables.net-buttons/buttons.html5.js deleted file mode 100644 index f27aadf..0000000 --- a/dbdocs/bower/datatables.net-buttons/buttons.html5.js +++ /dev/null @@ -1,1370 +0,0 @@ -/*! - * 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; -})); |