bootstrap table export的使用，bootstrap table表格前端导出

if (defaults.exportHiddenCells === false) {

$hiddenTableElements = $table.find('tr, th, td').filter(':hidden');

checkCellVisibility = $hiddenTableElements.length > 0;

}

rowIndex = 0;

colNames = GetColumnNames(this);

docData = '

function CollectXmlssData ($rows, rowselector, length) {

const spans = [];

$($rows).each(function () {

let ssIndex = 0;

let nCols = 0;

trData = '';

ForEachVisibleCell(this, 'td,th', rowIndex, length + $rows.length,

function (cell, row, col) {

if (cell !== null) {

let style = '';

let data = parseString(cell, row, col);

let type = 'String';

if (jQuery.isNumeric(data) !== false) {

type = 'Number';

} else {

const number = parsePercent(data);

if (number !== false) {

data = number;

type = 'Number';

style += ' ss:StyleID="pct1"';

}

}

if (type !== 'Number')

data = data.replace(/\n/g, '
');

let colspan = getColspan(cell);

let rowspan = getRowspan(cell);

// Skip spans

$.each(spans, function () {

const range = this;

if (rowIndex >= range.s.r && rowIndex <= range.e.r && nCols >= range.s.c && nCols <= range.e.c) {

for (let i = 0; i <= range.e.c - range.s.c; ++i) {

nCols++;

ssIndex++;

}

}

});

// Handle Row Span

if (rowspan || colspan) {

rowspan = rowspan || 1;

colspan = colspan || 1;

spans.push({

s: {r: rowIndex, c: nCols},

e: {r: rowIndex + rowspan - 1, c: nCols + colspan - 1}

});

}

// Handle Colspan

if (colspan > 1) {

style += ' ss:MergeAcross="' + (colspan - 1) + '"';

nCols += (colspan - 1);

}

if (rowspan > 1) {

style += ' ss:MergeDown="' + (rowspan - 1) + '" ss:StyleID="rsp1"';

}

if (ssIndex > 0) {

style += ' ss:Index="' + (nCols + 1) + '"';

ssIndex = 0;

}

trData += '' +

$('

sheetData.push(docData);

});

const count = {};

const firstOccurrences = {};

let item, itemCount;

for (let n = 0, c = docNames.length; n < c; n++) {

item = docNames[n];

itemCount = count[item];

itemCount = count[item] = (itemCount == null ? 1 : itemCount + 1);

if (itemCount === 2)

docNames[firstOccurrences[item]] = docNames[firstOccurrences[item]].substring(0, 29) + '-1';

if (count[item] > 1)

docNames[n] = docNames[n].substring(0, 29) + '-' + count[item];

else

firstOccurrences[item] = n;

}

const CreationDate = new Date().toISOString();

let xmlssDocFile = '\r' +

'\r' +

'

' xmlns:o="urn:schemas-microsoft-com:office:office"\r' +

' xmlns:x="urn:schemas-microsoft-com:office:excel"\r' +

' xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"\r' +

' xmlns:html="http://www.w3.org/TR/REC-html40">\r' +

'\r' +

' ' + CreationDate + '\r' +

'\r' +

'\r' +

' \r' +

'\r' +

'\r' +

' 9000\r' +

' 13860\r' +

' 0\r' +

' 0\r' +

' False\r' +

' False\r' +

'\r' +

'\r' +

' \r' +

' \r' +

' \r' +

'\r';

for (let j = 0; j < sheetData.length; j++) {

xmlssDocFile += '\r' +

sheetData[j];

if (defaults.mso.rtl) {

xmlssDocFile += '\r' +

'\r' +

'\r';

} else

xmlssDocFile += '\r';

xmlssDocFile += '\r';

}

xmlssDocFile += '\r';

if (defaults.outputMode === 'string')

return xmlssDocFile;

if (defaults.outputMode === 'base64')

return base64encode(xmlssDocFile);

saveToFile(xmlssDocFile, defaults.fileName + '.xml', 'application/xml', 'utf-8', 'base64', false);

} else if (defaults.type === 'excel' && defaults.mso.fileFormat === 'xlsx') {

const sheetNames = [];

const workbook = XLSX.utils.book_new();

// Multiple worksheets and .xlsx file extension #202

$(el).filter(function () {

return isVisible($(this));

}).each(function () {

const $table = $(this);

const ws = xlsxTableToSheet(this);

let sheetName = '';

if (typeof defaults.mso.worksheetName === 'string' && defaults.mso.worksheetName.length)

sheetName = defaults.mso.worksheetName + ' ' + (sheetNames.length + 1);

else if (typeof defaults.mso.worksheetName[sheetNames.length] !== 'undefined')

sheetName = defaults.mso.worksheetName[sheetNames.length];

if (!sheetName.length)

sheetName = $table.find('caption').text() || '';

if (!sheetName.length)

sheetName = 'Table ' + (sheetNames.length + 1);

sheetName = $.trim(sheetName.replace(/[\\\/[\]*:?'"]/g, '').substring(0, 31));

sheetNames.push(sheetName);

XLSX.utils.book_append_sheet(workbook, ws, sheetName);

});

// add worksheet to workbook

const wbData = XLSX.write(workbook, {type: 'binary', bookType: defaults.mso.fileFormat, bookSST: false});

saveToFile(xlsxWorkbookToArrayBuffer(wbData),

defaults.fileName + '.' + defaults.mso.fileFormat,

'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',

'UTF-8', '', false);

} else if (defaults.type === 'excel' || defaults.type === 'xls' || defaults.type === 'word' || defaults.type === 'doc') {

const MSDocType = (defaults.type === 'excel' || defaults.type === 'xls') ? 'excel' : 'word';

const MSDocExt = (MSDocType === 'excel') ? 'xls' : 'doc';

const MSDocSchema = 'xmlns:x="urn:schemas-microsoft-com:office:' + MSDocType + '"';

docData = '';

let docName = '';

$(el).filter(function () {

return isVisible($(this));

}).each(function () {

const $table = $(this);

if (docName === '') {

docName = defaults.mso.worksheetName || $table.find('caption').text() || 'Table';

docName = $.trim(docName.replace(/[\\\/[\]*:?'"]/g, '').substring(0, 31));

}

if (defaults.exportHiddenCells === false) {

$hiddenTableElements = $table.find('tr, th, td').filter(':hidden');

checkCellVisibility = $hiddenTableElements.length > 0;

}

rowIndex = 0;

ranges = [];

colNames = GetColumnNames(this);

// Header

docData += '

$head_rows = collectHeadRows($table);

$($head_rows).each(function () {

const $row = $(this);

const rowStyles = document.defaultView.getComputedStyle($row[0], null);

trData = '';

ForEachVisibleCell(this, 'th,td', rowIndex, $head_rows.length,

function (cell, row, col) {

if (cell !== null) {

let thStyle = '';

trData += '

if (defaults.mso.styles.length) {

const cellStyles = document.defaultView.getComputedStyle(cell, null);

for (let cssStyle in defaults.mso.styles) {

const stylePropertyName = defaults.mso.styles[cssStyle];

let thCss = getStyle(cellStyles, stylePropertyName);

if (thCss === '')

thCss = getStyle(rowStyles, stylePropertyName);

if (thCss !== '' && thCss !== '0px none rgb(0, 0, 0)' && thCss !== 'rgba(0, 0, 0, 0)') {

thStyle += (thStyle === '') ? 'style="' : ';';

thStyle += stylePropertyName + ':' + thCss;

}

}

}

if (thStyle !== '')

trData += ' ' + thStyle + '"';

const tdColspan = getColspan(cell);

if (tdColspan > 0)

trData += ' colspan="' + tdColspan + '"';

const tdRowspan = getRowspan(cell);

if (tdRowspan > 0)

trData += ' rowspan="' + tdRowspan + '"';

trData += '>' + parseString(cell, row, col) + '';

}

});

if (trData.length > 0)

docData += '

rowIndex++;

});

docData += '

// Data

$rows = collectRows($table);

$($rows).each(function () {

const $row = $(this);

let cellStyles = null;

let rowStyles = null;

trData = '';

ForEachVisibleCell(this, 'td,th', rowIndex, $head_rows.length + $rows.length,

function (cell, row, col) {

if (cell !== null) {

let tdValue = parseString(cell, row, col);

let tdStyle = '';

let tdCss = $(cell).attr('data-tableexport-msonumberformat');

if (typeof tdCss === 'undefined' && typeof defaults.mso.onMsoNumberFormat === 'function')

tdCss = defaults.mso.onMsoNumberFormat(cell, row, col);

if (typeof tdCss !== 'undefined' && tdCss !== '')

tdStyle = 'style="mso-number-format:\'' + tdCss + '\'';

if (defaults.mso.styles.length) {

cellStyles = document.defaultView.getComputedStyle(cell, null);

rowStyles = null;

for (let cssStyle in defaults.mso.styles) {

const stylePropertyName = defaults.mso.styles[cssStyle];

tdCss = getStyle(cellStyles, stylePropertyName);

if (tdCss === '') {

if (rowStyles === null)

rowStyles = document.defaultView.getComputedStyle($row[0], null);

tdCss = getStyle(rowStyles, stylePropertyName);

}

if (tdCss !== '' && tdCss !== '0px none rgb(0, 0, 0)' && tdCss !== 'rgba(0, 0, 0, 0)') {

tdStyle += (tdStyle === '') ? 'style="' : ';';

tdStyle += stylePropertyName + ':' + tdCss;

}

}

}

trData += '

if (tdStyle !== '')

trData += ' ' + tdStyle + '"';

const tdColspan = getColspan(cell);

if (tdColspan > 0)

trData += ' colspan="' + tdColspan + '"';

const tdRowspan = getRowspan(cell);

if (tdRowspan > 0)

trData += ' rowspan="' + tdRowspan + '"';

if (typeof tdValue === 'string' && tdValue !== '') {

tdValue = preventInjection(tdValue);

tdValue = tdValue.replace(/\n/g, '
');

}

trData += '>' + tdValue + '';

}

});

if (trData.length > 0)

docData += '

rowIndex++;

});

if (defaults.displayTableName)

docData += '

docData += '

});

//noinspection XmlUnusedNamespaceDeclaration

let docFile = '';

docFile += '';

docFile += '';

if (MSDocType === 'excel') {

docFile += '';

}

docFile += '';

docFile += '';

docFile += '';

docFile += '

docFile += '';

docFile += '';

if (defaults.outputMode === 'string')

return docFile;

if (defaults.outputMode === 'base64')

return base64encode(docFile);

saveToFile(docFile, defaults.fileName + '.' + MSDocExt, 'application/vnd.ms-' + MSDocType, '', 'base64', false);

} else if (defaults.type === 'png') {

html2canvas($(el)[0]).then(

function (canvas) {

const image = canvas.toDataURL();

const byteString = atob(image.substring(22)); // remove data stuff

const buffer = new ArrayBuffer(byteString.length);

const intArray = new Uint8Array(buffer);

for (let i = 0; i < byteString.length; i++)

intArray[i] = byteString.charCodeAt(i);

if (defaults.outputMode === 'string')

return byteString;

if (defaults.outputMode === 'base64')

return base64encode(image);

if (defaults.outputMode === 'window') {

window.open(image);

return;

}

saveToFile(buffer, defaults.fileName + '.png', 'image/png', '', '', false);

});

} else if (defaults.type === 'pdf') {

if (defaults.pdfmake.enabled === true) {

// pdf output using pdfmake

// https://github.com/bpampuch/pdfmake

const docDefinition = {

content: []

};

$.extend(true, docDefinition, defaults.pdfmake.docDefinition);

ranges = [];

$(el).filter(function () {

return isVisible($(this));

}).each(function () {

const $table = $(this);

const widths = [];

const body = [];

rowIndex = 0;

/**

* @return {number}

*/

const CollectPdfmakeData = function ($rows, colselector, length) {

let rLength = 0;

$($rows).each(function () {

const r = [];

ForEachVisibleCell(this, colselector, rowIndex, length,

function (cell, row, col) {

let cellContent;

if (typeof cell !== 'undefined' && cell !== null) {

const colspan = getColspan(cell);

const rowspan = getRowspan(cell);

cellContent = {text: parseString(cell, row, col) || ' '};

if (colspan > 1 || rowspan > 1) {

cellContent['colSpan'] = colspan || 1;

cellContent['rowSpan'] = rowspan || 1;

}

} else

cellContent = {text: ' '};

if (colselector.indexOf('th') >= 0)

cellContent['style'] = 'header';

r.push(cellContent);

});

if (r.length)

body.push(r);

if (rLength < r.length)

rLength = r.length;

rowIndex++;

});

return rLength;

};

$head_rows = collectHeadRows($table);

let colcount = CollectPdfmakeData($head_rows, 'th,td', $head_rows.length);

for (let i = widths.length; i < colcount; i++)

widths.push('*');

// Data

$rows = collectRows($table);

colcount = CollectPdfmakeData($rows, 'td', $head_rows.length + $rows.length);

for (let i = widths.length; i < colcount; i++)

widths.push('*');

docDefinition.content.push({ table: {

headerRows: $head_rows.length ? $head_rows.length : null,

widths: widths,

body: body

},

layout: {

layout: 'noBorders',

hLineStyle: function (i, node) { return 0; },

vLineWidth: function (i, node) { return 0; },

hLineColor: function (i, node) { return i < node.table.headerRows ?

defaults.pdfmake.docDefinition.styles.header.background :

defaults.pdfmake.docDefinition.styles.alternateRow.fillColor; },

vLineColor: function (i, node) { return i < node.table.headerRows ?

defaults.pdfmake.docDefinition.styles.header.background :

defaults.pdfmake.docDefinition.styles.alternateRow.fillColor; },

fillColor: function (rowIndex, node, columnIndex) { return (rowIndex % 2 === 0) ?

defaults.pdfmake.docDefinition.styles.alternateRow.fillColor :

null; }

},

pageBreak: docDefinition.content.length ? "before" : undefined

});

}); // ...for each table

if (typeof pdfMake !== 'undefined' && typeof pdfMake.createPdf !== 'undefined') {

pdfMake.fonts = {

Roboto: {

normal: 'Roboto-Regular.ttf',

bold: 'Roboto-Medium.ttf',

italics: 'Roboto-Italic.ttf',

bolditalics: 'Roboto-MediumItalic.ttf'

}

};

// pdfmake >= 0.2.0 - replace pdfMake.vfs with pdfMake.virtualfs

if (pdfMake.vfs.hasOwnProperty ('Mirza-Regular.ttf')) {

docDefinition.defaultStyle.font = 'Mirza';

$.extend(true, pdfMake.fonts, {Mirza: {normal: 'Mirza-Regular.ttf',

bold: 'Mirza-Bold.ttf',

italics: 'Mirza-Medium.ttf',

bolditalics: 'Mirza-SemiBold.ttf'

}});

}

else if (pdfMake.vfs.hasOwnProperty ('gbsn00lp.ttf')) {

docDefinition.defaultStyle.font = 'gbsn00lp';

$.extend(true, pdfMake.fonts, {gbsn00lp: {normal: 'gbsn00lp.ttf',

bold: 'gbsn00lp.ttf',

italics: 'gbsn00lp.ttf',

bolditalics: 'gbsn00lp.ttf'

}});

}

else if (pdfMake.vfs.hasOwnProperty ('ZCOOLXiaoWei-Regular.ttf')) {

docDefinition.defaultStyle.font = 'ZCOOLXiaoWei';

$.extend(true, pdfMake.fonts, {ZCOOLXiaoWei: {normal: 'ZCOOLXiaoWei-Regular.ttf',

bold: 'ZCOOLXiaoWei-Regular.ttf',

italics: 'ZCOOLXiaoWei-Regular.ttf',

bolditalics: 'ZCOOLXiaoWei-Regular.ttf'

}});

}

$.extend(true, pdfMake.fonts, defaults.pdfmake.fonts);

// pdfmake <= 0.1.71

pdfMake.createPdf(docDefinition).getBuffer(function (buffer) {

saveToFile(buffer, defaults.fileName + '.pdf', 'application/pdf', '', '', false);

});

// pdfmake >= 0.2.0 - replace above code with:

//pdfMake.createPdf(docDefinition).download(defaults.fileName);

}

} else if (defaults.jspdf.autotable === false) {

// pdf output using jsPDF's core html support

let doc = new jspdf.jsPDF({orientation: defaults.jspdf.orientation,

unit: defaults.jspdf.unit,

format: defaults.jspdf.format});

doc.html(el[0], {

callback: function () {

jsPdfOutput(doc, false);

},

html2canvas: {scale: ((doc.internal.pageSize.width - defaults.jspdf.margins.left * 2) / el[0].scrollWidth)},

x: defaults.jspdf.margins.left,

y: defaults.jspdf.margins.top

/*

margin: [

defaults.jspdf.margins.left,

defaults.jspdf.margins.top,

getPropertyUnitValue($(el).first().get(0), 'width', 'mm'),

getPropertyUnitValue($(el).first().get(0), 'height', 'mm')

]

*/

});

} else {

// pdf output using jsPDF AutoTable plugin

// https://github.com/simonbengtsson/jsPDF-AutoTable

let teOptions = defaults.jspdf.autotable.tableExport;

// When setting jspdf.format to 'bestfit' tableExport tries to choose

// the minimum required paper format and orientation in which the table

// (or tables in multitable mode) completely fits without column adjustment

if (typeof defaults.jspdf.format === 'string' && defaults.jspdf.format.toLowerCase() === 'bestfit') {

let rk = '', ro = '';

let mw = 0;

$(el).each(function () {

if (isVisible($(this))) {

const w = getPropertyUnitValue($(this).get(0), 'width', 'pt');

if (w > mw) {

if (w > pageFormats.a0[0]) {

rk = 'a0';

ro = 'l';

}

for (let key in pageFormats) {

if (pageFormats.hasOwnProperty(key)) {

if (pageFormats[key][1] > w) {

rk = key;

ro = 'l';

if (pageFormats[key][0] > w)

ro = 'p';

}

}

}

mw = w;

}

}

});

defaults.jspdf.format = (rk === '' ? 'a4' : rk);

defaults.jspdf.orientation = (ro === '' ? 'w' : ro);

}

// The jsPDF doc object is stored in defaults.jspdf.autotable.tableExport,

// thus it can be accessed from any callback function

if (teOptions.doc == null) {

teOptions.doc = new jspdf.jsPDF(defaults.jspdf.orientation,

defaults.jspdf.unit,

defaults.jspdf.format);

teOptions.wScaleFactor = 1;

teOptions.hScaleFactor = 1;

if (typeof defaults.jspdf.onDocCreated === 'function')

defaults.jspdf.onDocCreated(teOptions.doc);

}

jsPdfDefaultStyles.fontName = teOptions.doc.getFont().fontName;

if (teOptions.outputImages === true)

teOptions.images = {};

if (typeof teOptions.images !== 'undefined') {

$(el).filter(function () {

return isVisible($(this));

}).each(function () {

let rowCount = 0;

ranges = [];

if (defaults.exportHiddenCells === false) {

$hiddenTableElements = $(this).find('tr, th, td').filter(':hidden');

checkCellVisibility = $hiddenTableElements.length > 0;

}

$head_rows = collectHeadRows($(this));

$rows = collectRows($(this));

$($rows).each(function () {

ForEachVisibleCell(this, 'td,th', $head_rows.length + rowCount, $head_rows.length + $rows.length,

function (cell) {

collectImages(cell, $(cell).children(), teOptions);

});

rowCount++;

});

});

$head_rows = [];

$rows = [];

}

loadImages(teOptions, function () {

$(el).filter(function () {

return isVisible($(this));

}).each(function () {

let colKey;

rowIndex = 0;

ranges = [];

if (defaults.exportHiddenCells === false) {

$hiddenTableElements = $(this).find('tr, th, td').filter(':hidden');

checkCellVisibility = $hiddenTableElements.length > 0;

}

colNames = GetColumnNames(this);

teOptions.columns = [];

teOptions.rows = [];

teOptions.teCells = {};

// onTable: optional callback function for every matching table that can be used

// to modify the tableExport options or to skip the output of a particular table

// if the table selector targets multiple tables

if (typeof teOptions.onTable === 'function')

if (teOptions.onTable($(this), defaults) === false)

return true; // continue to next iteration step (table)

// each table works with an own copy of AutoTable options

defaults.jspdf.autotable.tableExport = null; // avoid deep recursion error

const atOptions = $.extend(true, {}, defaults.jspdf.autotable);

defaults.jspdf.autotable.tableExport = teOptions;

atOptions.margin = {};

$.extend(true, atOptions.margin, defaults.jspdf.margins);

atOptions.tableExport = teOptions;

if (typeof atOptions.createdHeaderCell !== 'function') {

// apply some original css styles to pdf header cells

atOptions.createdHeaderCell = function (cell, data) {

if (typeof teOptions.columns [data.column.dataKey] !== 'undefined') {

const col = teOptions.columns [data.column.dataKey];

if (typeof col.rect !== 'undefined') {

let rh;

cell.contentWidth = col.rect.width;

if (typeof teOptions.heightRatio === 'undefined' || teOptions.heightRatio === 0) {

if (data.row.raw [data.column.dataKey].rowspan)

rh = data.row.raw [data.column.dataKey].rect.height / data.row.raw [data.column.dataKey].rowspan;

else

rh = data.row.raw [data.column.dataKey].rect.height;

teOptions.heightRatio = cell.styles.rowHeight / rh;

}

rh = data.row.raw [data.column.dataKey].rect.height * teOptions.heightRatio;

if (rh > cell.styles.rowHeight)

cell.styles.rowHeight = rh;

}

cell.styles.halign = (atOptions.headerStyles.halign === 'inherit') ? 'center' : atOptions.headerStyles.halign;

cell.styles.valign = atOptions.headerStyles.valign;

if (typeof col.style !== 'undefined' && col.style.hidden !== true) {

if (atOptions.headerStyles.halign === 'inherit')

cell.styles.halign = col.style.align;

if (atOptions.styles.fillColor === 'inherit')

cell.styles.fillColor = col.style.bcolor;

if (atOptions.styles.textColor === 'inherit')

cell.styles.textColor = col.style.color;

if (atOptions.styles.fontStyle === 'inherit')

cell.styles.fontStyle = col.style.fstyle;

}

}

};

}

if (typeof atOptions.createdCell !== 'function') {

// apply some original css styles to pdf table cells

atOptions.createdCell = function (cell, data) {

const tecell = teOptions.teCells [data.row.index + ':' + data.column.dataKey];

cell.styles.halign = (atOptions.styles.halign === 'inherit') ? 'center' : atOptions.styles.halign;

cell.styles.valign = atOptions.styles.valign;

if (typeof tecell !== 'undefined' && typeof tecell.style !== 'undefined' && tecell.style.hidden !== true) {

if (atOptions.styles.halign === 'inherit')

cell.styles.halign = tecell.style.align;

if (atOptions.styles.fillColor === 'inherit')

cell.styles.fillColor = tecell.style.bcolor;

if (atOptions.styles.textColor === 'inherit')

cell.styles.textColor = tecell.style.color;

if (atOptions.styles.fontStyle === 'inherit')

cell.styles.fontStyle = tecell.style.fstyle;

}

};

}

if (typeof atOptions.drawHeaderCell !== 'function') {

atOptions.drawHeaderCell = function (cell, data) {

const colopt = teOptions.columns [data.column.dataKey];

if ((colopt.style.hasOwnProperty('hidden') !== true || colopt.style.hidden !== true) &&

colopt.rowIndex >= 0)

return prepareAutoTableText(cell, data, colopt);

else

return false; // cell is hidden

};

}

if (typeof atOptions.drawCell !== 'function') {

atOptions.drawCell = function (cell, data) {

const teCell = teOptions.teCells [data.row.index + ':' + data.column.dataKey];

const draw2canvas = (typeof teCell !== 'undefined' && teCell.isCanvas);

if (draw2canvas !== true) {

if (prepareAutoTableText(cell, data, teCell)) {

teOptions.doc.rect(cell.x, cell.y, cell.width, cell.height, cell.styles.fillStyle);

if (typeof teCell !== 'undefined' &&

(typeof teCell.hasUserDefText === 'undefined' || teCell.hasUserDefText !== true) &&

typeof teCell.elements !== 'undefined' && teCell.elements.length) {

const hScale = cell.height / teCell.rect.height;

if (hScale > teOptions.hScaleFactor)

teOptions.hScaleFactor = hScale;

teOptions.wScaleFactor = cell.width / teCell.rect.width;

const ySave = cell.textPos.y;

drawAutotableElements(cell, teCell.elements, teOptions);

cell.textPos.y = ySave;

drawAutotableText(cell, teCell.elements, teOptions);

} else

drawAutotableText(cell, {}, teOptions);

}

} else {

const container = teCell.elements[0];

const imgId = $(container).attr('data-tableexport-canvas');

const r = container.getBoundingClientRect();

cell.width = r.width * teOptions.wScaleFactor;

cell.height = r.height * teOptions.hScaleFactor;

data.row.height = cell.height;

jsPdfDrawImage(cell, container, imgId, teOptions);

}

return false;

};

}

// collect header and data rows

teOptions.headerrows = [];

$head_rows = collectHeadRows($(this));

$($head_rows).each(function () {

colKey = 0;

teOptions.headerrows[rowIndex] = [];

ForEachVisibleCell(this, 'th,td', rowIndex, $head_rows.length,

function (cell, row, col) {

const obj = getCellStyles(cell);

obj.title = parseString(cell, row, col);

obj.key = colKey++;

obj.rowIndex = rowIndex;

teOptions.headerrows[rowIndex].push(obj);

});

rowIndex++;

});

if (rowIndex > 0) {

// iterate through last row

let lastrow = rowIndex - 1;

while (lastrow >= 0) {

$.each(teOptions.headerrows[lastrow], function () {

let obj = this;

if (lastrow > 0 && this.rect === null)

obj = teOptions.headerrows[lastrow - 1][this.key];

if (obj !== null && obj.rowIndex >= 0 &&

(obj.style.hasOwnProperty('hidden') !== true || obj.style.hidden !== true))

teOptions.columns.push(obj);

});

lastrow = (teOptions.columns.length > 0) ? -1 : lastrow - 1;

}

}

let rowCount = 0;

$rows = [];

$rows = collectRows($(this));

$($rows).each(function () {

const rowData = [];

colKey = 0;

ForEachVisibleCell(this, 'td,th', rowIndex, $head_rows.length + $rows.length,

function (cell, row, col) {

let obj;

if (typeof teOptions.columns[colKey] === 'undefined') {

// jsPDF-Autotable needs columns. Thus define hidden ones for tables without thead

obj = {

title: '',

key: colKey,

style: {

hidden: true

}

};

teOptions.columns.push(obj);

}

rowData.push(parseString(cell, row, col));

if (typeof cell !== 'undefined' && cell !== null) {

obj = getCellStyles(cell);

obj.isCanvas = cell.hasAttribute('data-tableexport-canvas');

obj.elements = obj.isCanvas ? $(cell) : $(cell).children();

if(typeof $(cell).data('teUserDefText') !== 'undefined')

obj.hasUserDefText = true;

teOptions.teCells [rowCount + ':' + colKey++] = obj;

} else {

obj = $.extend(true, {}, teOptions.teCells [rowCount + ':' + (colKey - 1)]);

obj.colspan = -1;

teOptions.teCells [rowCount + ':' + colKey++] = obj;

}

});

if (rowData.length) {

teOptions.rows.push(rowData);

rowCount++;

}

rowIndex++;

});

// onBeforeAutotable: optional callback function before calling

// jsPDF AutoTable that can be used to modify the AutoTable options

if (typeof teOptions.onBeforeAutotable === 'function')

teOptions.onBeforeAutotable($(this), teOptions.columns, teOptions.rows, atOptions);

jsPdfAutoTable(atOptions.tableExport.doc, teOptions.columns, teOptions.rows, atOptions);

// onAfterAutotable: optional callback function after returning

// from jsPDF AutoTable that can be used to modify the AutoTable options

if (typeof teOptions.onAfterAutotable === 'function')

teOptions.onAfterAutotable($(this), atOptions);

// set the start position for the next table (in case there is one)

defaults.jspdf.autotable.startY = jsPdfAutoTableEndPosY() + atOptions.margin.top;

});

jsPdfOutput(teOptions.doc, (typeof teOptions.images !== 'undefined' && jQuery.isEmptyObject(teOptions.images) === false));

if (typeof teOptions.headerrows !== 'undefined')

teOptions.headerrows.length = 0;

if (typeof teOptions.columns !== 'undefined')

teOptions.columns.length = 0;

if (typeof teOptions.rows !== 'undefined')

teOptions.rows.length = 0;

delete teOptions.doc;

teOptions.doc = null;

});

}

}

function collectHeadRows ($table) {

const result = [];

findTableElements($table, 'thead').each(function () {

result.push.apply(result, findTableElements($(this), defaults.theadSelector).toArray());

});

return result;

}

function collectRows ($table) {

const result = [];

findTableElements($table, 'tbody').each(function () {

result.push.apply(result, findTableElements($(this), defaults.tbodySelector).toArray());

});

if (defaults.tfootSelector.length) {

findTableElements($table, 'tfoot').each(function () {

result.push.apply(result, findTableElements($(this), defaults.tfootSelector).toArray());

});

}

return result;

}

function findTableElements ($parent, selector) {

const parentSelector = $parent[0].tagName;

const parentLevel = $parent.parents(parentSelector).length;

return $parent.find(selector).filter(function () {

return parentLevel === $(this).closest(parentSelector).parents(parentSelector).length;

});

}

function GetColumnNames (table) {

const result = [];

let maxCols = 0;

let row = 0;

let col = 0;

$(table).find('thead').first().find('th').each(function (index, el) {

const hasDataField = $(el).attr('data-field') !== undefined;

if (typeof el.parentNode.rowIndex !== 'undefined' && row !== el.parentNode.rowIndex) {

row = el.parentNode.rowIndex;

col = 0;

maxCols = 0;

}

const colSpan = getColspan(el);

maxCols += (colSpan ? colSpan : 1);

while (col < maxCols) {

result[col] = (hasDataField ? $(el).attr('data-field') : col.toString());

col++;

}

});

return result;

}

function isVisible ($element) {

let isRow = typeof $element[0].rowIndex !== 'undefined';

const isCell = isRow === false && typeof $element[0].cellIndex !== 'undefined';

const isElementVisible = (isCell || isRow) ? isTableElementVisible($element) : $element.is(':visible');

let tableexportDisplay = $element.attr('data-tableexport-display');

if (isCell && tableexportDisplay !== 'none' && tableexportDisplay !== 'always') {

$element = $($element[0].parentNode);

isRow = typeof $element[0].rowIndex !== 'undefined';

tableexportDisplay = $element.attr('data-tableexport-display');

}

if (isRow && tableexportDisplay !== 'none' && tableexportDisplay !== 'always') {

tableexportDisplay = $element.closest('table').attr('data-tableexport-display');

}

return tableexportDisplay !== 'none' && (isElementVisible === true || tableexportDisplay === 'always');

}

function isTableElementVisible ($element) {

let hiddenEls = [];

if (checkCellVisibility) {

hiddenEls = $hiddenTableElements.filter(function () {

let found = false;

if (this.nodeType === $element[0].nodeType) {

if (typeof this.rowIndex !== 'undefined' && this.rowIndex === $element[0].rowIndex)

found = true;

else if (typeof this.cellIndex !== 'undefined' && this.cellIndex === $element[0].cellIndex &&

typeof this.parentNode.rowIndex !== 'undefined' &&

typeof $element[0].parentNode.rowIndex !== 'undefined' &&

this.parentNode.rowIndex === $element[0].parentNode.rowIndex)

found = true;

}

return found;

});

}

return (checkCellVisibility === false || hiddenEls.length === 0);

}

function isColumnIgnored ($cell, rowLength, colIndex) {

let result = false;

if (isVisible($cell)) {

if (defaults.ignoreColumn.length > 0) {

if ($.inArray(colIndex, defaults.ignoreColumn) !== -1 ||

$.inArray(colIndex - rowLength, defaults.ignoreColumn) !== -1 ||

(colNames.length > colIndex && typeof colNames[colIndex] !== 'undefined' &&

$.inArray(colNames[colIndex], defaults.ignoreColumn) !== -1))

result = true;

}

} else

result = true;

return result;

}

function ForEachVisibleCell (tableRow, selector, rowIndex, rowCount, cellcallback) {

if (typeof (cellcallback) === 'function') {

let ignoreRow = false;

if (typeof defaults.onIgnoreRow === 'function')

ignoreRow = defaults.onIgnoreRow($(tableRow), rowIndex);

if (ignoreRow === false &&

(defaults.ignoreRow.length === 0 ||

($.inArray(rowIndex, defaults.ignoreRow) === -1 &&

$.inArray(rowIndex - rowCount, defaults.ignoreRow) === -1)) &&

isVisible($(tableRow))) {

const $cells = findTableElements($(tableRow), selector);

let cellsCount = $cells.length;

let colCount = 0;

let colIndex = 0;

$cells.each(function () {

const $cell = $(this);

let colspan = getColspan(this);

let rowspan = getRowspan(this);

let c;

// Skip ranges

$.each(ranges, function () {

const range = this;

if (rowIndex > range.s.r && rowIndex <= range.e.r && colCount >= range.s.c && colCount <= range.e.c) {

for (c = 0; c <= range.e.c - range.s.c; ++c) {

cellsCount++;

colIndex++;

cellcallback(null, rowIndex, colCount++);

}

}

});

// Handle span's

if (rowspan || colspan) {

rowspan = rowspan || 1;

colspan = colspan || 1;

ranges.push({

s: {r: rowIndex, c: colCount},

e: {r: rowIndex + rowspan - 1, c: colCount + colspan - 1}

});

}

if (isColumnIgnored($cell, cellsCount, colIndex++) === false) {

// Handle value

cellcallback(this, rowIndex, colCount++);

}

// Handle colspan

if (colspan > 1) {

for (c = 0; c < colspan - 1; ++c) {

colIndex++;

cellcallback(null, rowIndex, colCount++);

}

}

});

// Skip ranges

$.each(ranges, function () {

const range = this;

if (rowIndex >= range.s.r && rowIndex <= range.e.r && colCount >= range.s.c && colCount <= range.e.c) {

for (let c = 0; c <= range.e.c - range.s.c; ++c) {

cellcallback(null, rowIndex, colCount++);

}

}

});

}

}

}

function jsPdfDrawImage (cell, container, imgId, teOptions) {

if (typeof teOptions.images !== 'undefined') {

const image = teOptions.images[imgId];

if (typeof image !== 'undefined') {

const r = container.getBoundingClientRect();

const arCell = cell.width / cell.height;

const arImg = r.width / r.height;

let imgWidth = cell.width;

let imgHeight = cell.height;

const px2pt = 0.264583 * 72 / 25.4;

let uy = 0;

if (arImg <= arCell) {

imgHeight = Math.min(cell.height, r.height);

imgWidth = r.width * imgHeight / r.height;

} else if (arImg > arCell) {

imgWidth = Math.min(cell.width, r.width);

imgHeight = r.height * imgWidth / r.width;

}

imgWidth *= px2pt;

imgHeight *= px2pt;

if (imgHeight < cell.height)

uy = (cell.height - imgHeight) / 2;

try {

teOptions.doc.addImage(image.src, cell.textPos.x, cell.y + uy, imgWidth, imgHeight);

} catch (e) {

// TODO: IE -> convert png to jpeg

}

cell.textPos.x += imgWidth;

}

}

}

function jsPdfOutput (doc, hasimages) {

if (defaults.outputMode === 'string')

return doc.output();

if (defaults.outputMode === 'base64')

return base64encode(doc.output());

if (defaults.outputMode === 'window') {

window.URL = window.URL || window.webkitURL;

window.open(window.URL.createObjectURL(doc.output('blob')));

return;

}

const fileName = defaults.fileName + '.pdf';

try {

const blob = doc.output('blob')

saveAs(blob, fileName);

if (typeof defaults.onAfterSaveToFile === 'function')

defaults.onAfterSaveToFile(blob, fileName);

} catch (e) {

downloadFile(fileName,

'data:application/pdf' + (hasimages ? '' : ';base64') + ',',

hasimages ? doc.output('blob') : doc.output());

}

}

function prepareAutoTableText (cell, data, cellopt) {

let cs = 0

if (typeof cellopt !== 'undefined')

cs = cellopt.colspan;

if (cs >= 0) {

// colspan handling

let cellWidth = cell.width

let textPosX = cell.textPos.x

const i = data.table.columns.indexOf(data.column)

for (let c = 1; c < cs; c++) {

const column = data.table.columns[i + c]

cellWidth += column.width;

}

if (cs > 1) {

if (cell.styles.halign === 'right')

textPosX = cell.textPos.x + cellWidth - cell.width;

else if (cell.styles.halign === 'center')

textPosX = cell.textPos.x + (cellWidth - cell.width) / 2;

}

cell.width = cellWidth;

cell.textPos.x = textPosX;

if (typeof cellopt !== 'undefined' && cellopt.rowspan > 1)

cell.height = cell.height * cellopt.rowspan;

// fix jsPDF's calculation of text position

if (cell.styles.valign === 'middle' || cell.styles.valign === 'bottom') {

const splittedText = typeof cell.text === 'string' ? cell.text.split(/\r\n|\r|\n/g) : cell.text;

const lineCount = splittedText.length || 1;

if (lineCount > 2)

cell.textPos.y -= ((2 - FONT_ROW_RATIO) / 2 * data.row.styles.fontSize) * (lineCount - 2) / 3;

}

return true;

} else

return false; // cell is hidden (colspan = -1), don't draw it

}

function collectImages (cell, elements, teOptions) {

if (typeof cell !== 'undefined' && cell !== null) {

if (cell.hasAttribute('data-tableexport-canvas')) {

const imgId = new Date().getTime();

$(cell).attr('data-tableexport-canvas', imgId);

teOptions.images[imgId] = {

url: '[data-tableexport-canvas="' + imgId + '"]',

src: null

};

} else if (elements !== 'undefined' && elements != null) {

elements.each(function () {

if ($(this).is('img')) {

const imgId = strHashCode(this.src);

teOptions.images[imgId] = {

url: this.src,

src: this.src

};

}

collectImages(cell, $(this).children(), teOptions);

});

}

}

}

function loadImages (teOptions, callback) {

let imageCount = 0;

let pendingCount = 0;

function done () {

callback(imageCount);

}

function loadImage (image) {

if (image.url) {

if (!image.src) {

const $imgContainer = $(image.url);

if ($imgContainer.length) {

imageCount = ++pendingCount;

html2canvas($imgContainer[0]).then(function (canvas) {

image.src = canvas.toDataURL('image/png');

if (!--pendingCount)

done();

});

}

} else {

const img = new Image();

imageCount = ++pendingCount;

img.crossOrigin = 'Anonymous';

img.onerror = img.onload = function () {

if (img.complete) {

if (img.src.indexOf('data:image/') === 0) {

img.width = image.width || img.width || 0;

img.height = image.height || img.height || 0;

}

if (img.width + img.height) {

const canvas = document.createElement('canvas');

const ctx = canvas.getContext('2d');

canvas.width = img.width;

canvas.height = img.height;

ctx.drawImage(img, 0, 0);

image.src = canvas.toDataURL('image/png');

}

}

if (!--pendingCount)

done();

};

img.src = image.url;

}

}

}

if (typeof teOptions.images !== 'undefined') {

for (let i in teOptions.images)

if (teOptions.images.hasOwnProperty(i))

loadImage(teOptions.images[i]);

}

return pendingCount || done();

}

function drawAutotableElements (cell, elements, teOptions) {

elements.each(function () {

if ($(this).is('div')) {

const bColor = rgb2array(getStyle(this, 'background-color'), [255, 255, 255]);

const lColor = rgb2array(getStyle(this, 'border-top-color'), [0, 0, 0]);

const lWidth = getPropertyUnitValue(this, 'border-top-width', defaults.jspdf.unit);

const r = this.getBoundingClientRect();

const ux = this.offsetLeft * teOptions.wScaleFactor;

const uy = this.offsetTop * teOptions.hScaleFactor;

const uw = r.width * teOptions.wScaleFactor;

const uh = r.height * teOptions.hScaleFactor;

teOptions.doc.setDrawColor.apply(undefined, lColor);

teOptions.doc.setFillColor.apply(undefined, bColor);

teOptions.doc.setLineWidth(lWidth);

teOptions.doc.rect(cell.x + ux, cell.y + uy, uw, uh, lWidth ? 'FD' : 'F');

} else if ($(this).is('img')) {

const imgId = strHashCode(this.src);

jsPdfDrawImage(cell, this, imgId, teOptions);

}

drawAutotableElements(cell, $(this).children(), teOptions);

});

}

function drawAutotableText (cell, texttags, teOptions) {

if (typeof teOptions.onAutotableText === 'function') {

teOptions.onAutotableText(teOptions.doc, cell, texttags);

} else {

let x = cell.textPos.x;

let y = cell.textPos.y;

const style = {halign: cell.styles.halign, valign: cell.styles.valign};

if (texttags.length) {

let tag = texttags[0];

while (tag.previousSibling)

tag = tag.previousSibling;

let b = false, i = false;

while (tag) {

let txt = tag.innerText || tag.textContent || '';

const leadingSpace = (txt.length && txt[0] === ' ') ? ' ' : '';

const trailingSpace = (txt.length > 1 && txt[txt.length - 1] === ' ') ? ' ' : '';

if (defaults.preserve.leadingWS !== true)

txt = leadingSpace + trimLeft(txt);

if (defaults.preserve.trailingWS !== true)

txt = trimRight(txt) + trailingSpace;

if ($(tag).is('br')) {

x = cell.textPos.x;

y += teOptions.doc.internal.getFontSize();

}

if ($(tag).is('b'))

b = true;

else if ($(tag).is('i'))

i = true;

if (b || i)

teOptions.doc.setFont('undefined ', (b && i) ? 'bolditalic' : b ? 'bold' : 'italic');

let w = teOptions.doc.getStringUnitWidth(txt) * teOptions.doc.internal.getFontSize();

if (w) {

if (cell.styles.overflow === 'linebreak' &&

x > cell.textPos.x && (x + w) > (cell.textPos.x + cell.width)) {

const chars = '.,!%*;:=-';

if (chars.indexOf(txt.charAt(0)) >= 0) {

const s = txt.charAt(0);

w = teOptions.doc.getStringUnitWidth(s) * teOptions.doc.internal.getFontSize();

if ((x + w) <= (cell.textPos.x + cell.width)) {

jsPdfAutoTableText(s, x, y, style);

txt = txt.substring(1, txt.length);

}

w = teOptions.doc.getStringUnitWidth(txt) * teOptions.doc.internal.getFontSize();

}

x = cell.textPos.x;

y += teOptions.doc.internal.getFontSize();

}

if (cell.styles.overflow !== 'visible') {

while (txt.length && (x + w) > (cell.textPos.x + cell.width)) {

txt = txt.substring(0, txt.length - 1);

w = teOptions.doc.getStringUnitWidth(txt) * teOptions.doc.internal.getFontSize();

}

}

jsPdfAutoTableText(txt, x, y, style);

x += w;

}

if (b || i) {

if ($(tag).is('b'))

b = false;

else if ($(tag).is('i'))

i = false;

teOptions.doc.setFont('undefined ', (!b && !i) ? 'normal' : b ? 'bold' : 'italic');

}

tag = tag.nextSibling;

}

cell.textPos.x = x;

cell.textPos.y = y;

} else {

jsPdfAutoTableText(cell.text, cell.textPos.x, cell.textPos.y, style);

}

}

}

function escapeRegExp (string) {

return string == null ? '' : string.toString().replace(/([.*+?^=!:${}()|\[\]\/\\])/g, '\\$1');

}

function replaceAll (string, find, replace) {

return string == null ? '' : string.toString().replace(new RegExp(escapeRegExp(find), 'g'), replace);

}

function trimLeft (string) {

return string == null ? '' : string.toString().replace(/^\s+/, '');

}

function trimRight (string) {

return string == null ? '' : string.toString().replace(/\s+$/, '');

}

function parseDateUTC (s) {

if (defaults.date.html.length === 0)

return false;

defaults.date.pattern.lastIndex = 0;

const match = defaults.date.pattern.exec(s);

if (match == null)

return false;

const y = +match[defaults.date.match_y];

if (y < 0 || y > 8099) return false;

const m = match[defaults.date.match_m] * 1;

const d = match[defaults.date.match_d] * 1;

if (!isFinite(d)) return false;

const o = new Date(y, m - 1, d, 0, 0, 0);

if (o.getFullYear() === y && o.getMonth() === (m - 1) && o.getDate() === d)

return new Date(Date.UTC(y, m - 1, d, 0, 0, 0));

else

return false;

}

function parseNumber (value) {

value = value || '0';

if ('' !== defaults.numbers.html.thousandsSeparator)

value = replaceAll(value, defaults.numbers.html.thousandsSeparator, '');

if ('.' !== defaults.numbers.html.decimalMark)

value = replaceAll(value, defaults.numbers.html.decimalMark, '.');

return typeof value === 'number' || jQuery.isNumeric(value) !== false ? value : false;

}

function parsePercent (value) {

if (value.indexOf('%') > -1) {

value = parseNumber(value.replace(/%/g, ''));

if (value !== false)

value = value / 100;

} else

value = false;

return value;

}

function parseString (cell, rowIndex, colIndex, cellInfo) {

let result = '';

let cellType = 'text';

if (cell !== null) {

const $cell = $(cell);

let htmlData;

$cell.removeData('teUserDefText');

if ($cell[0].hasAttribute('data-tableexport-canvas')) {

htmlData = '';

} else if ($cell[0].hasAttribute('data-tableexport-value')) {

htmlData = $cell.attr('data-tableexport-value');

htmlData = htmlData ? htmlData + '' : '';

$cell.data('teUserDefText', 1);

} else {

htmlData = $cell.html();

if (typeof defaults.onCellHtmlData === 'function') {

htmlData = defaults.onCellHtmlData($cell, rowIndex, colIndex, htmlData);

$cell.data('teUserDefText', 1);

}

else if (htmlData !== '') {

const html = $.parseHTML('

let inputIndex = 0;

let selectIndex = 0;

htmlData = '';

$.each(html, function () {

if ($(this).is('input')) {

htmlData += $cell.find('input').eq(inputIndex++).val();

}

else if ($(this).is('select')) {

htmlData += $cell.find('select option:selected').eq(selectIndex++).text();

}

else if ($(this).is('br')) {

htmlData += '
';

}

else {

if (typeof $(this).html() === 'undefined')

htmlData += $(this).text();

else if (jQuery().bootstrapTable === undefined ||

($(this).hasClass('fht-cell') === false && // BT 4

$(this).hasClass('filterControl') === false &&

$cell.parents('.detail-view').length === 0))

htmlData += $(this).html();

if ($(this).is('a')) {

const href = $cell.find('a').attr('href') || '';

if (typeof defaults.onCellHtmlHyperlink === 'function') {

result += defaults.onCellHtmlHyperlink($cell, rowIndex, colIndex, href, htmlData);

}

else if (defaults.htmlHyperlink === 'href') {

result += href;

}

else { // 'content'

result += htmlData;

}

htmlData = '';

}

}

});

}

}

if (htmlData && htmlData !== '' && defaults.htmlContent === true) {

result = $.trim(htmlData);

} else if (htmlData && htmlData !== '') {

const cellFormat = $cell.attr('data-tableexport-cellformat');

if (cellFormat !== '') {

let text = htmlData.replace(/\n/g, '\u2028').replace(/(<\s*br([^>]*)>)/gi, '\u2060');

const obj = $('