LaravelTest
1441 строка · 44.5 Кб
1/*!2* Flash export buttons for Buttons and DataTables.3* 2015 SpryMedia Ltd - datatables.net/license4*5* ZeroClipbaord - MIT license6* Copyright (c) 2012 Joseph Huckaby7*/8/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *44* ZeroClipboard dependency45*/46/*48* ZeroClipboard 1.0.4 with modifications49* Author: Joseph Huckaby50* License: MIT51*52* Copyright (c) 2012 Joseph Huckaby53*/54var ZeroClipboard_TableTools = {55version: "1.0.4-TableTools2",56clients: {}, // registered upload clients on page, indexed by id57moviePath: '', // URL to movie58nextId: 1, // ID of next movie59{443try {444var fo = new ActiveXObject('ShockwaveFlash.ShockwaveFlash');445if (fo) {446return true;447}448}449catch (e) {450if (451navigator.mimeTypes &&452navigator.mimeTypes['application/x-shockwave-flash'] !== undefined &&453navigator.mimeTypes['application/x-shockwave-flash'].enabledPlugin454) {455return true;456}457}458// For the Flash binding to work, ZeroClipboard_TableTools must be on the global463// object list464window.ZeroClipboard_TableTools = ZeroClipboard_TableTools;465/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *469* Local (private) functions470*/471/**473* If a Buttons instance is initlaised before it is placed into the DOM, Flash474* won't be able to bind to it, so we need to wait until it is available, this475* method abstracts that out.476*477* @param {ZeroClipboard} flash ZeroClipboard instance478* @param {jQuery} node Button479*/480var _glue = function ( flash, node )481{482var id = node.attr('id');483/**495* Get the file name for an exported file.496*497* @param {object} config Button configuration498* @param {boolean} incExtension Include the file name extension499*/500var _filename = function ( config, incExtension )501{502// Backwards compatibility503var filename = config.filename === '*' && config.title !== '*' && config.title !== undefined ?504config.title :505config.filename;506/**524* Get the sheet name for Excel exports.525*526* @param {object} config Button configuration527*/528var _sheetname = function ( config )529{530var sheetName = 'Sheet1';531/**540* Get the title for an exported file.541*542* @param {object} config Button configuration543*/544var _title = function ( config )545{546var title = config.title;547/**558* Set the flash text. This has to be broken up into chunks as the Javascript /559* Flash bridge has a size limit. There is no indication in the Flash560* documentation what this is, and it probably depends upon the browser.561* Experimentation shows that the point is around 50k when data starts to get562* lost, so an 8K limit used here is safe.563*564* @param {ZeroClipboard} flash ZeroClipboard instance565* @param {string} data Data to send to Flash566*/567var _setText = function ( flash, data )568{569var parts = data.match(/[\s\S]{1,8192}/g) || [];570/**579* Get the newline character(s)580*581* @param {object} config Button configuration582* @return {string} Newline character583*/584var _newLine = function ( config )585{586return config.newline ?587config.newline :588navigator.userAgent.match(/Windows/) ?589'\r\n' :590'\n';591};592/**594* Combine the data from the `buttons.exportData` method into a string that595* will be used in the export file.596*597* @param {DataTable.Api} dt DataTables API instance598* @param {object} config Button configuration599* @return {object} The data to export600*/601var _exportData = function ( dt, config )602{603var newLine = _newLine( config );604var data = dt.buttons.exportData( config.exportOptions );605var boundary = config.fieldBoundary;606var separator = config.fieldSeparator;607var reBoundary = new RegExp( boundary, 'g' );608var escapeChar = config.escapeChar !== undefined ?609config.escapeChar :610'\\';611var join = function ( a ) {612var s = '';613// Basic initialisation for the buttons is common between them645var flashButton = {646available: function () {647return ZeroClipboard_TableTools.hasFlash();648},649/**690* Convert from numeric position to letter for column names in Excel691* @param {int} n Column number692* @return {string} Column letter(s) name693*/694function createCellPos( n ){695var ordA = 'A'.charCodeAt(0);696var ordZ = 'Z'.charCodeAt(0);697var len = ordZ - ordA + 1;698var s = "";699}707/**709* Create an XML node and add any children, attributes, etc without needing to710* be verbose in the DOM.711*712* @param {object} doc XML document713* @param {string} nodeName Node name714* @param {object} opts Options - can be `attr` (attributes), `children`715* (child nodes) and `text` (text content)716* @return {node} Created node717*/718function _createNode( doc, nodeName, opts ){719var tempNode = doc.createElement( nodeName );720}739/**741* Get the width for an Excel column based on the contents of that column742* @param {object} data Data for export743* @param {int} col Column index744* @return {int} Column width745*/746function _excelColWidth( data, col ) {747var max = data.header[col].length;748var len, lineSplit, str;749}789/**805* Convert XML documents in an object to strings806* @param {object} obj XLSX document object807*/808function _xlsxToStrings( obj ) {809if ( _ieExcel === undefined ) {810// Detect if we are dealing with IE's _awful_ serialiser by seeing if it811// drop attributes812_ieExcel = _serialiser813.serializeToString(814$.parseXML( excelStrings['xl/worksheets/sheet1.xml'] )815)816.indexOf( 'xmlns:r' ) === -1;817}818}873// Excel - Pre-defined strings to build a basic XLSX file875var excelStrings = {876"_rels/.rels":877'<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+878'<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">'+879'<Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/>'+880'</Relationships>',881// Note we could use 3 `for` loops for the styles, but when gzipped there is1100// virtually no difference in size, since the above can be easily compressed1101// Pattern matching for special number formats. Perhaps this should be exposed1103// via an API in future?1104var _excelSpecials = [1105{ match: /^\-?\d+\.\d%$/, style: 60, fmt: function (d) { return d/100; } }, // Precent with d.p.1106{ match: /^\-?\d+\.?\d*%$/, style: 56, fmt: function (d) { return d/100; } }, // Percent1107{ match: /^\-?\$[\d,]+.?\d*$/, style: 57 }, // Dollars1108{ match: /^\-?£[\d,]+.?\d*$/, style: 58 }, // Pounds1109{ match: /^\-?€[\d,]+.?\d*$/, style: 59 }, // Euros1110{ match: /^\([\d,]+\)$/, style: 61, fmt: function (d) { return -1 * d.replace(/[\(\)]/g, ''); } }, // Negative numbers indicated by brackets1111{ match: /^\([\d,]+\.\d{2}\)$/, style: 62, fmt: function (d) { return -1 * d.replace(/[\(\)]/g, ''); } }, // Negative numbers indicated by brackets - 2d.p.1112{ match: /^[\d,]+$/, style: 63 }, // Numbers with thousand separators1113{ match: /^[\d,]+\.\d{2}$/, style: 64 } // Numbers with 2d.p. and thousands separators1114];1115/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *1119* DataTables options and methods1120*/1121// Set the default SWF path1123DataTable.Buttons.swfPath = '//cdn.datatables.net/buttons/1.2.4/swf/flashExport.swf';1124// Method to allow Flash buttons to be resized when made visible - as they are1126// of zero height and width if initialised hidden1127DataTable.Api.register( 'buttons.resize()', function () {1128$.each( ZeroClipboard_TableTools.clients, function ( i, client ) {1129if ( client.domElement !== undefined && client.domElement.parentNode ) {1130client.positionElement();1131}1132} );1133} );1134/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *1137* Button definitions1138*/1139// Copy to clipboard1141DataTable.ext.buttons.copyFlash = $.extend( {}, flashButton, {1142className: 'buttons-copy buttons-flash',1143// CSV save file1183DataTable.ext.buttons.csvFlash = $.extend( {}, flashButton, {1184className: 'buttons-csv buttons-flash',1185// Excel save file - this is really a CSV file using UTF-8 that Excel can read1207DataTable.ext.buttons.excelFlash = $.extend( {}, flashButton, {1208className: 'buttons-excel buttons-flash',1209// PDF export1391DataTable.ext.buttons.pdfFlash = $.extend( {}, flashButton, {1392className: 'buttons-pdf buttons-flash',1393