Skip to content

Instantly share code, notes, and snippets.

@michaeljymsgutierrez
Last active July 10, 2018 03:54
Show Gist options
  • Save michaeljymsgutierrez/ee83c416acb6ce9c17de76b2b774dacc to your computer and use it in GitHub Desktop.
Save michaeljymsgutierrez/ee83c416acb6ce9c17de76b2b774dacc to your computer and use it in GitHub Desktop.
/*!
* HTML5 export buttons for Buttons and DataTables.
* 2015 SpryMedia Ltd - datatables.net/license
*
* FileSaver.js (2015-05-07.2) - MIT license
* Copyright © 2015 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, $) {
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;
/** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* FileSaver.js dependency
*/
/*jslint bitwise: true, indent: 4, laxbreak: true, laxcomma: true, smarttabs: true, plusplus: true */
var _saveAs = (function(view) {
// IE <10 is explicitly unsupported
if (
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 = doc.createEvent("MouseEvents");
event.initMouseEvent(
"click",
true,
false,
view,
0,
0,
0,
0,
0,
false,
false,
false,
false,
0,
null
);
node.dispatchEvent(event);
},
webkit_req_fs = view.webkitRequestFileSystem,
req_fs =
view.requestFileSystem || webkit_req_fs || view.mozRequestFileSystem,
throw_outside = function(ex) {
(view.setImmediate || view.setTimeout)(function() {
throw ex;
}, 0);
},
force_saveable_type = "application/octet-stream",
fs_min_size = 0,
// See https://code.google.com/p/chromium/issues/detail?id=375297#c7 and
// https://github.com/eligrey/FileSaver.js/commit/485930a#commitcomment-8768047
// for the reasoning behind the timeout and revocation flow
arbitrary_revoke_timeout = 500, // 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();
}
};
if (view.chrome) {
revoker();
} else {
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)
if (
/^\s*(?:text\/\S*|application\/xml|\S*\/\S*\+xml)\s*;.*charset\s*=\s*utf-8/i.test(
blob.type
)
) {
return new Blob(["\ufeff", blob], { type: blob.type });
}
return blob;
},
FileSaver = function(blob, name) {
blob = auto_bom(blob);
// First try a.download, then web filesystem, then object URLs
var filesaver = this,
type = blob.type,
blob_changed = false,
object_url,
target_view,
dispatch_all = function() {
dispatch(
filesaver,
"writestart progress write writeend".split(" ")
);
},
// on any filesys errors revert to saving with object URLs
fs_error = function() {
// don't create more object URLs than needed
if (blob_changed || !object_url) {
object_url = get_URL().createObjectURL(blob);
}
if (target_view) {
target_view.location.href = object_url;
} else {
var new_tab = view.open(object_url, "_blank");
if (new_tab === undefined && typeof safari !== "undefined") {
//Apple do not allow window.open, see http://bit.ly/1kZffRI
view.location.href = object_url;
}
}
filesaver.readyState = filesaver.DONE;
dispatch_all();
revoke(object_url);
},
abortable = function(func) {
return function() {
if (filesaver.readyState !== filesaver.DONE) {
return func.apply(this, arguments);
}
};
},
create_if_not_found = { create: true, exclusive: false },
slice;
filesaver.readyState = filesaver.INIT;
if (!name) {
name = "download";
}
if (can_use_save_link) {
object_url = get_URL().createObjectURL(blob);
save_link.href = object_url;
save_link.download = name;
click(save_link);
filesaver.readyState = filesaver.DONE;
dispatch_all();
revoke(object_url);
return;
}
// Object and web filesystem URLs have a problem saving in Google Chrome when
// viewed in a tab, so I force save with application/octet-stream
// http://code.google.com/p/chromium/issues/detail?id=91158
// Update: Google errantly closed 91158, I submitted it again:
// https://code.google.com/p/chromium/issues/detail?id=389642
if (view.chrome && type && type !== force_saveable_type) {
slice = blob.slice || blob.webkitSlice;
blob = slice.call(blob, 0, blob.size, force_saveable_type);
blob_changed = true;
}
// Since I can't be sure that the guessed media type will trigger a download
// in WebKit, I append .download to the filename.
// https://bugs.webkit.org/show_bug.cgi?id=65440
if (webkit_req_fs && name !== "download") {
name += ".download";
}
if (type === force_saveable_type || webkit_req_fs) {
target_view = view;
}
if (!req_fs) {
fs_error();
return;
}
fs_min_size += blob.size;
req_fs(
view.TEMPORARY,
fs_min_size,
abortable(function(fs) {
fs.root.getDirectory(
"saved",
create_if_not_found,
abortable(function(dir) {
var save = function() {
dir.getFile(
name,
create_if_not_found,
abortable(function(file) {
file.createWriter(
abortable(function(writer) {
writer.onwriteend = function(event) {
target_view.location.href = file.toURL();
filesaver.readyState = filesaver.DONE;
dispatch(filesaver, "writeend", event);
revoke(file);
};
writer.onerror = function() {
var error = writer.error;
if (error.code !== error.ABORT_ERR) {
fs_error();
}
};
"writestart progress write abort"
.split(" ")
.forEach(function(event) {
writer["on" + event] = filesaver["on" + event];
});
writer.write(blob);
filesaver.abort = function() {
writer.abort();
filesaver.readyState = filesaver.DONE;
};
filesaver.readyState = filesaver.WRITING;
}),
fs_error
);
}),
fs_error
);
};
dir.getFile(
name,
{ create: false },
abortable(function(file) {
// delete file if it already exists
file.remove();
save();
}),
abortable(function(ex) {
if (ex.code === ex.NOT_FOUND_ERR) {
save();
} else {
fs_error();
}
})
);
}),
fs_error
);
}),
fs_error
);
},
FS_proto = FileSaver.prototype,
saveAs = function(blob, name) {
return new FileSaver(blob, name);
};
// IE 10+ (native saveAs)
if (typeof navigator !== "undefined" && navigator.msSaveOrOpenBlob) {
return function(blob, name) {
return navigator.msSaveOrOpenBlob(auto_bom(blob), name);
};
}
FS_proto.abort = function() {
var filesaver = this;
filesaver.readyState = filesaver.DONE;
dispatch(filesaver, "abort");
};
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;
})(window);
/** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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 = 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())
: 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
};
};
/**
* Safari's data: support for creating and downloading files is really poor, so
* various options need to be disabled in it. See
* https://bugs.webkit.org/show_bug.cgi?id=102914
*
* @return {Boolean} `true` if Safari
*/
var _isSafari = function() {
return (
navigator.userAgent.indexOf("Safari") !== -1 &&
navigator.userAgent.indexOf("Chrome") === -1 &&
navigator.userAgent.indexOf("Opera") === -1
);
};
// Excel - Pre-defined strings to build a minimal 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"/>\
</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"/>\
</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="__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>\
__DATA__\
</sheetData>\
</worksheet>'
};
/** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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) {
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 {
document.execCommand("copy");
hiddenDiv.remove();
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
);
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();
}
})
.on("copy.buttons-copy cut.buttons-copy", function() {
close();
});
},
exportOptions: {},
fieldSeparator: "\t",
fieldBoundary: "",
header: true,
footer: false
};
//
// CSV export
//
DataTable.ext.buttons.csvHtml5 = {
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) {
// Set the text
var newLine = _newLine(config);
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 = "";
}
_saveAs(
new Blob([output], { type: "text/csv" + charset }),
_filename(config)
);
},
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 &&
window.JSZip !== undefined &&
!_isSafari()
);
},
text: function(dt) {
return dt.i18n("buttons.excel", "Excel");
},
action: function(e, dt, button, config) {
// Set the text
var xml = "";
var data = dt.buttons.exportData(config.exportOptions);
var addRow = function(row) {
var cells = [];
try {
for (var i = 0, ien = row.length; i < ien; i++) {
if (row[i] === null || row[i] === undefined) {
row[i] = "";
}
// Don't match numbers with leading zeros or a negative anywhere
// but the start
cells.push(
typeof row[i] === "number" ||
(row[i].match &&
$.trim(row[i]).match(/^-?\d+(\.\d+)?$/) &&
row[i].charAt(0) !== "0")
? '<c t="n"><v>' + row[i] + "</v></c>"
: '<c t="inlineStr"><is><t>' +
(!row[i].replace
? row[i]
: row[i]
.replace(/&(?!amp;)/g, "&amp;")
.replace(/</g, "&lt;")
.replace(/>/g, "&gt;")
.replace(
/[\x00-\x09\x0B\x0C\x0E-\x1F\x7F-\x9F]/g,
""
)) + // remove control characters
"</t></is></c>" // they are not valid in XML
);
}
} catch (err) {}
return "<row>" + cells.join("") + "</row>";
};
// Load Report headers
var get_title = window.localStorage.getItem("report_headers");
// Convert string to json headers
var title = JSON.parse(get_title);
// Set Filename from custom configuration
config.filename = title.company_name;
// Insert custom headers using addRow() function
var detail_1 = [title.store_name];
xml = addRow(detail_1);
var detail_2 = [title.store_details];
xml += addRow(detail_2);
// Check if tab name exist
if (title.profile_tab != "") {
var detail_3 = [title.profile_tab];
xml += addRow(detail_3);
}
var detail_4 = [title.date_print];
xml += addRow(detail_4);
xml += addRow(" ");
if (config.header) {
xml += addRow(data.header);
}
for (var i = 0, ien = data.body.length; i < ien; i++) {
xml += addRow(data.body[i]);
}
if (config.footer) {
xml += addRow(data.footer);
}
/*
CG - Implement Multiple Footer Excel
*/
if (config.customFooter === true) {
var _get_excel_footer = window.localStorage.getItem("excelFooter");
var _write_excel_footer = JSON.parse(_get_excel_footer);
_write_excel_footer.forEach(function(excelData) {
xml += addRow(excelData);
});
}
var zip = new window.JSZip();
var _rels = zip.folder("_rels");
var xl = zip.folder("xl");
var xl_rels = zip.folder("xl/_rels");
var xl_worksheets = zip.folder("xl/worksheets");
zip.file("[Content_Types].xml", excelStrings["[Content_Types].xml"]);
_rels.file(".rels", excelStrings["_rels/.rels"]);
xl.file(
"workbook.xml",
excelStrings["xl/workbook.xml"].replace(
"__SHEET_NAME__",
_sheetname(config)
)
);
xl_rels.file(
"workbook.xml.rels",
excelStrings["xl/_rels/workbook.xml.rels"]
);
xl_worksheets.file(
"sheet1.xml",
excelStrings["xl/worksheets/sheet1.xml"].replace("__DATA__", xml)
);
_saveAs(
zip.generate({
type: "blob",
mimeType:
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
}),
_filename(config)
);
},
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 && window.pdfMake;
},
text: function(dt) {
return dt.i18n("buttons.pdf", "PDF");
},
action: function(e, dt, button, config) {
var newLine = _newLine(config);
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) {
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: 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 = window.pdfMake.createPdf(doc);
if (config.download === "open" && !_isSafari()) {
pdf.open();
} else {
pdf.getBuffer(function(buffer) {
var blob = new Blob([buffer], { type: "application/pdf" });
_saveAs(blob, _filename(config));
});
}
},
title: "*",
filename: "*",
extension: ".pdf",
exportOptions: {},
orientation: "portrait",
pageSize: "A4",
header: true,
footer: false,
message: null,
customize: null,
download: "download"
};
return DataTable.Buttons;
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment