META-INF.resources.bower_components.datatables.net-buttons.js.buttons.flash.js Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of jwebmp-data-tables Show documentation
Show all versions of jwebmp-data-tables Show documentation
The JWebSwing implementation for Data Tables
The newest version!
/*!
* Flash export buttons for Buttons and DataTables.
* 2015-2017 SpryMedia Ltd - datatables.net/license
*
* ZeroClipbaord - MIT license
* Copyright (c) 2012 Joseph Huckaby
*/
(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, $) {
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);
};
}
else {
// Browser
factory(jQuery, window, document);
}
}(function ($, window, document, undefined) {
'use strict';
var DataTable = $.fn.dataTable;
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* ZeroClipboard dependency
*/
/*
* ZeroClipboard 1.0.4 with modifications
* Author: Joseph Huckaby
* License: MIT
*
* Copyright (c) 2012 Joseph Huckaby
*/
var ZeroClipboard_TableTools = {
version: "1.0.4-TableTools2",
clients: {}, // registered upload clients on page, indexed by id
moviePath: '', // URL to movie
nextId: 1, // ID of next movie
$: function (thingy) {
// simple DOM lookup utility function
if (typeof(thingy) == 'string') {
thingy = document.getElementById(thingy);
}
if (!thingy.addClass) {
// extend element with a few useful methods
thingy.hide = function () {
this.style.display = 'none';
};
thingy.show = function () {
this.style.display = '';
};
thingy.addClass = function (name) {
this.removeClass(name);
this.className += ' ' + name;
};
thingy.removeClass = function (name) {
this.className = this.className.replace(new RegExp("\\s*" + name + "\\s*"), " ").replace(/^\s+/, '').replace(/\s+$/, '');
};
thingy.hasClass = function (name) {
return !!this.className.match(new RegExp("\\s*" + name + "\\s*"));
};
}
return thingy;
},
setMoviePath: function (path) {
// set path to ZeroClipboard.swf
this.moviePath = path;
},
dispatch: function (id, eventName, args) {
// receive event from flash movie, send to client
var client = this.clients[id];
if (client) {
client.receiveEvent(eventName, args);
}
},
log: function (str) {
console.log('Flash: ' + str);
},
register: function (id, client) {
// register new client to receive events
this.clients[id] = client;
},
getDOMObjectPosition: function (obj) {
// get absolute coordinates for dom element
var info = {
left: 0,
top: 0,
width: obj.width ? obj.width : obj.offsetWidth,
height: obj.height ? obj.height : obj.offsetHeight
};
if (obj.style.width !== "") {
info.width = obj.style.width.replace("px", "");
}
if (obj.style.height !== "") {
info.height = obj.style.height.replace("px", "");
}
while (obj) {
info.left += obj.offsetLeft;
info.top += obj.offsetTop;
obj = obj.offsetParent;
}
return info;
},
Client: function (elem) {
// constructor for new simple upload client
this.handlers = {};
// unique ID
this.id = ZeroClipboard_TableTools.nextId++;
this.movieId = 'ZeroClipboard_TableToolsMovie_' + this.id;
// register client with singleton to receive flash events
ZeroClipboard_TableTools.register(this.id, this);
// create movie
if (elem) {
this.glue(elem);
}
}
};
ZeroClipboard_TableTools.Client.prototype = {
id: 0, // unique ID for us
ready: false, // whether movie is ready to receive events or not
movie: null, // reference to movie object
clipText: '', // text to copy to clipboard
fileName: '', // default file save name
action: 'copy', // action to perform
handCursorEnabled: true, // whether to show hand cursor, or default pointer cursor
cssEffects: true, // enable CSS mouse effects on dom container
handlers: null, // user event handlers
sized: false,
sheetName: '', // default sheet name for excel export
glue: function (elem, title) {
// glue to DOM element
// elem can be ID or actual DOM element object
this.domElement = ZeroClipboard_TableTools.$(elem);
// float just above object, or zIndex 99 if dom element isn't set
var zIndex = 99;
if (this.domElement.style.zIndex) {
zIndex = parseInt(this.domElement.style.zIndex, 10) + 1;
}
// find X/Y position of domElement
var box = ZeroClipboard_TableTools.getDOMObjectPosition(this.domElement);
// create floating DIV above element
this.div = document.createElement('div');
var style = this.div.style;
style.position = 'absolute';
style.left = '0px';
style.top = '0px';
style.width = (box.width) + 'px';
style.height = box.height + 'px';
style.zIndex = zIndex;
if (typeof title != "undefined" && title !== "") {
this.div.title = title;
}
if (box.width !== 0 && box.height !== 0) {
this.sized = true;
}
// style.backgroundColor = '#f00'; // debug
if (this.domElement) {
this.domElement.appendChild(this.div);
this.div.innerHTML = this.getHTML(box.width, box.height).replace(/&/g, '&');
}
},
positionElement: function () {
var box = ZeroClipboard_TableTools.getDOMObjectPosition(this.domElement);
var style = this.div.style;
style.position = 'absolute';
//style.left = (this.domElement.offsetLeft)+'px';
//style.top = this.domElement.offsetTop+'px';
style.width = box.width + 'px';
style.height = box.height + 'px';
if (box.width !== 0 && box.height !== 0) {
this.sized = true;
} else {
return;
}
var flash = this.div.childNodes[0];
flash.width = box.width;
flash.height = box.height;
},
getHTML: function (width, height) {
// return HTML for movie
var html = '';
var flashvars = 'id=' + this.id +
'&width=' + width +
'&height=' + height;
if (navigator.userAgent.match(/MSIE/)) {
// IE gets an OBJECT tag
var protocol = location.href.match(/^https/i) ? 'https://' : 'http://';
html += '';
}
else {
// all other browsers get an EMBED tag
html += '';
}
return html;
},
hide: function () {
// temporarily hide floater offscreen
if (this.div) {
this.div.style.left = '-2000px';
}
},
show: function () {
// show ourselves after a call to hide()
this.reposition();
},
destroy: function () {
// destroy control and floater
var that = this;
if (this.domElement && this.div) {
$(this.div).remove();
this.domElement = null;
this.div = null;
$.each(ZeroClipboard_TableTools.clients, function (id, client) {
if (client === that) {
delete ZeroClipboard_TableTools.clients[id];
}
});
}
},
reposition: function (elem) {
// reposition our floating div, optionally to new container
// warning: container CANNOT change size, only position
if (elem) {
this.domElement = ZeroClipboard_TableTools.$(elem);
if (!this.domElement) {
this.hide();
}
}
if (this.domElement && this.div) {
var box = ZeroClipboard_TableTools.getDOMObjectPosition(this.domElement);
var style = this.div.style;
style.left = '' + box.left + 'px';
style.top = '' + box.top + 'px';
}
},
clearText: function () {
// clear the text to be copy / saved
this.clipText = '';
if (this.ready) {
this.movie.clearText();
}
},
appendText: function (newText) {
// append text to that which is to be copied / saved
this.clipText += newText;
if (this.ready) {
this.movie.appendText(newText);
}
},
setText: function (newText) {
// set text to be copied to be copied / saved
this.clipText = newText;
if (this.ready) {
this.movie.setText(newText);
}
},
setFileName: function (newText) {
// set the file name
this.fileName = newText;
if (this.ready) {
this.movie.setFileName(newText);
}
},
setSheetData: function (data) {
// set the xlsx sheet data
if (this.ready) {
this.movie.setSheetData(JSON.stringify(data));
}
},
setAction: function (newText) {
// set action (save or copy)
this.action = newText;
if (this.ready) {
this.movie.setAction(newText);
}
},
addEventListener: function (eventName, func) {
// add user event listener for event
// event types: load, queueStart, fileStart, fileComplete, queueComplete, progress, error, cancel
eventName = eventName.toString().toLowerCase().replace(/^on/, '');
if (!this.handlers[eventName]) {
this.handlers[eventName] = [];
}
this.handlers[eventName].push(func);
},
setHandCursor: function (enabled) {
// enable hand cursor (true), or default arrow cursor (false)
this.handCursorEnabled = enabled;
if (this.ready) {
this.movie.setHandCursor(enabled);
}
},
setCSSEffects: function (enabled) {
// enable or disable CSS effects on DOM container
this.cssEffects = !!enabled;
},
receiveEvent: function (eventName, args) {
var self;
// receive event from flash
eventName = eventName.toString().toLowerCase().replace(/^on/, '');
// special behavior for certain events
switch (eventName) {
case 'load':
// movie claims it is ready, but in IE this isn't always the case...
// bug fix: Cannot extend EMBED DOM elements in Firefox, must use traditional function
this.movie = document.getElementById(this.movieId);
if (!this.movie) {
self = this;
setTimeout(function () {
self.receiveEvent('load', null);
}, 1);
return;
}
// firefox on pc needs a "kick" in order to set these in certain cases
if (!this.ready && navigator.userAgent.match(/Firefox/) && navigator.userAgent.match(/Windows/)) {
self = this;
setTimeout(function () {
self.receiveEvent('load', null);
}, 100);
this.ready = true;
return;
}
this.ready = true;
this.movie.clearText();
this.movie.appendText(this.clipText);
this.movie.setFileName(this.fileName);
this.movie.setAction(this.action);
this.movie.setHandCursor(this.handCursorEnabled);
break;
case 'mouseover':
if (this.domElement && this.cssEffects) {
//this.domElement.addClass('hover');
if (this.recoverActive) {
this.domElement.addClass('active');
}
}
break;
case 'mouseout':
if (this.domElement && this.cssEffects) {
this.recoverActive = false;
if (this.domElement.hasClass('active')) {
this.domElement.removeClass('active');
this.recoverActive = true;
}
//this.domElement.removeClass('hover');
}
break;
case 'mousedown':
if (this.domElement && this.cssEffects) {
this.domElement.addClass('active');
}
break;
case 'mouseup':
if (this.domElement && this.cssEffects) {
this.domElement.removeClass('active');
this.recoverActive = false;
}
break;
} // switch eventName
if (this.handlers[eventName]) {
for (var idx = 0, len = this.handlers[eventName].length; idx < len; idx++) {
var func = this.handlers[eventName][idx];
if (typeof(func) == 'function') {
// actual function reference
func(this, args);
}
else if ((typeof(func) == 'object') && (func.length == 2)) {
// PHP style object + method, i.e. [myObject, 'myMethod']
func[0][func[1]](this, args);
}
else if (typeof(func) == 'string') {
// name of function
window[func](this, args);
}
} // foreach event handler defined
} // user defined handler for event
}
};
ZeroClipboard_TableTools.hasFlash = function () {
try {
var fo = new ActiveXObject('ShockwaveFlash.ShockwaveFlash');
if (fo) {
return true;
}
}
catch (e) {
if (
navigator.mimeTypes &&
navigator.mimeTypes['application/x-shockwave-flash'] !== undefined &&
navigator.mimeTypes['application/x-shockwave-flash'].enabledPlugin
) {
return true;
}
}
return false;
};
// For the Flash binding to work, ZeroClipboard_TableTools must be on the global
// object list
window.ZeroClipboard_TableTools = ZeroClipboard_TableTools;
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Local (private) functions
*/
/**
* If a Buttons instance is initlaised before it is placed into the DOM, Flash
* won't be able to bind to it, so we need to wait until it is available, this
* method abstracts that out.
*
* @param {ZeroClipboard} flash ZeroClipboard instance
* @param {jQuery} node Button
*/
var _glue = function (flash, node) {
var id = node.attr('id');
if (node.parents('html').length) {
flash.glue(node[0], '');
}
else {
setTimeout(function () {
_glue(flash, node);
}, 500);
}
};
/**
* 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;
};
/**
* Set the flash text. This has to be broken up into chunks as the Javascript /
* Flash bridge has a size limit. There is no indication in the Flash
* documentation what this is, and it probably depends upon the browser.
* Experimentation shows that the point is around 50k when data starts to get
* lost, so an 8K limit used here is safe.
*
* @param {ZeroClipboard} flash ZeroClipboard instance
* @param {string} data Data to send to Flash
*/
var _setText = function (flash, data) {
var parts = data.match(/[\s\S]{1,8192}/g) || [];
flash.clearText();
for (var i = 0, len = parts.length; i < len; i++) {
flash.appendText(parts[i]);
}
};
/**
* 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
};
};
// Basic initialisation for the buttons is common between them
var flashButton = {
available: function () {
return ZeroClipboard_TableTools.hasFlash();
},
init: function (dt, button, config) {
// Insert the Flash movie
ZeroClipboard_TableTools.moviePath = DataTable.Buttons.swfPath;
var flash = new ZeroClipboard_TableTools.Client();
flash.setHandCursor(true);
flash.addEventListener('mouseDown', function (client) {
config._fromFlash = true;
dt.button(button[0]).trigger();
config._fromFlash = false;
});
_glue(flash, button);
config._flash = flash;
},
destroy: function (dt, button, config) {
config._flash.destroy();
},
fieldSeparator: ',',
fieldBoundary: '"',
exportOptions: {},
title: '*',
messageTop: '*',
messageBottom: '*',
filename: '*',
extension: '.csv',
header: true,
footer: 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;
}
/**
* 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 !== null && opts.text !== undefined) {
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;
}
var _serialiser = "";
if (typeof window.XMLSerializer === 'undefined') {
_serialiser = new function () {
this.serializeToString = function (input) {
return input.xml
}
};
} else {
_serialiser = new XMLSerializer();
}
var _ieExcel;
/**
* Convert XML documents in an object to strings
* @param {object} obj XLSX document object
*/
function _xlsxToStrings(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)) {
_xlsxToStrings(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('' + 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>');
obj[name] = str;
}
});
}
// Excel - Pre-defined strings to build a basic XLSX file
var excelStrings = {
"_rels/.rels":
'' +
'' +
' ',
"xl/_rels/workbook.xml.rels":
'' +
'' +
' ',
"[Content_Types].xml":
'' +
'' +
' ',
"xl/workbook.xml":
'' +
'' +
'' +
' ' +
'' +
' ' +
' ',
"xl/worksheets/sheet1.xml":
'' +
'' +
' ',
"xl/styles.xml":
'' +
'' +
'' +
' ' +
'' +
'' +
' ' +
'' +
'' +
' ' +
'' + // Excel appears to use this as a dotted background regardless of values but
' ' +
'' +
'' +
' ' +
' ' +
'' +
'' +
' ' +
' ' +
'' +
'' +
' ' +
' ' +
'' +
'' +
' ' +
' ' +
' ' +
'' +
'' +
' ' +
'' +
'' +
' ' +
'' +
' ' +
'' +
' ' +
'' +
' ' +
' ' +
' ' +
'' +
' ' +
'' +
'' +
' ' +
'' +
' ' +
'' +
' ' +
'' +
' ' +
'' +
' ' +
'' +
' ' +
' ' +
'' +
' ' +
' '
};
// 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?
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: 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 2d.p. and thousands separators
];
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* DataTables options and methods
*/
// Set the default SWF path
DataTable.Buttons.swfPath = '//cdn.datatables.net/buttons/' + DataTable.Buttons.version + '/swf/flashExport.swf';
// Method to allow Flash buttons to be resized when made visible - as they are
// of zero height and width if initialised hidden
DataTable.Api.register('buttons.resize()', function () {
$.each(ZeroClipboard_TableTools.clients, function (i, client) {
if (client.domElement !== undefined && client.domElement.parentNode) {
client.positionElement();
}
});
});
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Button definitions
*/
// Copy to clipboard
DataTable.ext.buttons.copyFlash = $.extend({}, flashButton, {
className: 'buttons-copy buttons-flash',
text: function (dt) {
return dt.i18n('buttons.copy', 'Copy');
},
action: function (e, dt, button, config) {
// Check that the trigger did actually occur due to a Flash activation
if (!config._fromFlash) {
return;
}
this.processing(true);
var flash = config._flash;
var exportData = _exportData(dt, config);
var info = dt.buttons.exportInfo(config);
var newline = _newLine(config);
var output = exportData.str;
if (info.title) {
output = info.title + newline + newline + output;
}
if (info.messageTop) {
output = info.messageTop + newline + newline + output;
}
if (info.messageBottom) {
output = output + newline + newline + info.messageBottom;
}
if (config.customize) {
output = config.customize(output, config, dt);
}
flash.setAction('copy');
_setText(flash, output);
this.processing(false);
dt.buttons.info(
dt.i18n('buttons.copyTitle', 'Copy to clipboard'),
dt.i18n('buttons.copySuccess', {
_: 'Copied %d rows to clipboard',
1: 'Copied 1 row to clipboard'
}, data.rows),
3000
);
},
fieldSeparator: '\t',
fieldBoundary: ''
});
// CSV save file
DataTable.ext.buttons.csvFlash = $.extend({}, flashButton, {
className: 'buttons-csv buttons-flash',
text: function (dt) {
return dt.i18n('buttons.csv', 'CSV');
},
action: function (e, dt, button, config) {
// Set the text
var flash = config._flash;
var data = _exportData(dt, config);
var info = dt.buttons.exportInfo(config);
var output = config.customize ?
config.customize(data.str, config, dt) :
data.str;
flash.setAction('csv');
flash.setFileName(info.filename);
_setText(flash, output);
},
escapeChar: '"'
});
// Excel save file - this is really a CSV file using UTF-8 that Excel can read
DataTable.ext.buttons.excelFlash = $.extend({}, flashButton, {
className: 'buttons-excel buttons-flash',
text: function (dt) {
return dt.i18n('buttons.excel', 'Excel');
},
action: function (e, dt, button, config) {
this.processing(true);
var flash = config._flash;
var rowPos = 0;
var rels = $.parseXML(excelStrings['xl/worksheets/sheet1.xml']); //Parses xml
var relsGet = rels.getElementsByTagName("sheetData")[0];
var xlsx = {
_rels: {
".rels": $.parseXML(excelStrings['_rels/.rels'])
},
xl: {
_rels: {
"workbook.xml.rels": $.parseXML(excelStrings['xl/_rels/workbook.xml.rels'])
},
"workbook.xml": $.parseXML(excelStrings['xl/workbook.xml']),
"styles.xml": $.parseXML(excelStrings['xl/styles.xml']),
"worksheets": {
"sheet1.xml": rels
}
},
"[Content_Types].xml": $.parseXML(excelStrings['[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] === '') {
if (config.createEmptyCells === true) {
row[i] = '';
}
else {
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);
}
var mergeCells = function (row, colspan) {
var mergeCells = $('mergeCells', rels);
mergeCells[0].appendChild(_createNode(rels, 'mergeCell', {
attr: {
ref: 'A' + row + ':' + createCellPos(colspan) + row
}
}));
mergeCells.attr('count', mergeCells.attr('count') + 1);
$('row:eq(' + (row - 1) + ') c', rels).attr('s', '51'); // centre
};
// Title and top messages
var exportInfo = dt.buttons.exportInfo(config);
if (exportInfo.title) {
addRow([exportInfo.title], rowPos);
mergeCells(rowPos, data.header.length - 1);
}
if (exportInfo.messageTop) {
addRow([exportInfo.messageTop], rowPos);
mergeCells(rowPos, data.header.length - 1);
}
// Table itself
if (config.header) {
addRow(data.header, rowPos);
$('row:last 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
}
// Below the table
if (exportInfo.messageBottom) {
addRow([exportInfo.messageBottom], rowPos);
mergeCells(rowPos, data.header.length - 1);
}
// 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, config, dt);
}
_xlsxToStrings(xlsx);
flash.setAction('excel');
flash.setFileName(exportInfo.filename);
flash.setSheetData(xlsx);
_setText(flash, '');
this.processing(false);
},
extension: '.xlsx',
createEmptyCells: false
});
// PDF export
DataTable.ext.buttons.pdfFlash = $.extend({}, flashButton, {
className: 'buttons-pdf buttons-flash',
text: function (dt) {
return dt.i18n('buttons.pdf', 'PDF');
},
action: function (e, dt, button, config) {
this.processing(true);
// Set the text
var flash = config._flash;
var data = dt.buttons.exportData(config.exportOptions);
var info = dt.buttons.exportInfo(config);
var totalWidth = dt.table().node().offsetWidth;
// Calculate the column width ratios for layout of the table in the PDF
var ratios = dt.columns(config.columns).indexes().map(function (idx) {
return dt.column(idx).header().offsetWidth / totalWidth;
});
flash.setAction('pdf');
flash.setFileName(info.filename);
_setText(flash, JSON.stringify({
title: info.title || '',
messageTop: info.messageTop || '',
messageBottom: info.messageBottom || '',
colWidth: ratios.toArray(),
orientation: config.orientation,
size: config.pageSize,
header: config.header ? data.header : null,
footer: config.footer ? data.footer : null,
body: data.body
}));
this.processing(false);
},
extension: '.pdf',
orientation: 'portrait',
pageSize: 'A4',
newline: '\n'
});
return DataTable.Buttons;
}));
© 2015 - 2025 Weber Informatics LLC | Privacy Policy