Файловый менеджер - Редактировать - /var/www/portal.bdu.ac.bd/public_html/wp-content/plugins/secure-copy-content-protection/admin/js/jhxlsx.js
Назад
/* * #################################################################################################### * https://www.npmjs.com/package/xlsx-style * #################################################################################################### */ var Jhxlsx = { config: { fileName: "report", extension: ".xlsx", sheetName: "Sheet", fileFullName: "report.xlsx", header: true, createEmptyRow: true, maxCellWidth: 20 }, worksheetObj: {}, rowCount: 0, wsColswidth: [], merges: [], worksheet: {}, range: {}, init: function (options) { this.reset(); if (options) { for (var key in this.config) { if (options.hasOwnProperty(key)) { this.config[key] = options[key]; } } } this.config['fileFullName'] = this.config.fileName + this.config.extension; }, reset: function () { this.range = {s: {c: 10000000, r: 10000000}, e: {c: 0, r: 0}}; this.worksheetObj = {}; this.rowCount = 0; this.wsColswidth = []; this.merges = []; this.worksheet = {}; }, parse2Int0: function (num) { num = parseInt(num); num = Number.isNaN(num) ? 0 : num; return num; }, cellWidth: function (cellText, pos) { var max = (cellText && cellText.length * 1.3); if (this.wsColswidth[pos]) { if (max > this.wsColswidth[pos].wch) { this.wsColswidth[pos] = {wch: max}; } } else { this.wsColswidth[pos] = {wch: max}; } }, cellWidthValidate: function () { for (var i in this.wsColswidth) { if (this.wsColswidth[i].wch > this.config.maxCellWidth) { this.wsColswidth[i].wch = this.config.maxCellWidth; } } }, datenum: function (v, date1904) { if (date1904) v += 1462; var epoch = Date.parse(v); return (epoch - new Date(Date.UTC(1899, 11, 30))) / (24 * 60 * 60 * 1000); }, setCellDataType: function (cell) { if (typeof cell.v === 'number') { cell.t = 'n'; } else if (typeof cell.v === 'boolean') { cell.t = 'b'; } else if (cell.v instanceof Date) { cell.t = 'n'; cell.z = XLSX.SSF._table[14]; cell.v = this.datenum(cell.v); } else { cell.t = 's'; } }, jhAddRow: function (rowObj) { for (var c in rowObj) { c = this.parse2Int0(c); var cellObj = rowObj[c]; if (this.range.s.r > this.rowCount) this.range.s.r = this.rowCount; if (this.range.s.c > c) this.range.s.c = c; if (this.range.e.r < this.rowCount) this.range.e.r = this.rowCount; if (this.range.e.c < c) this.range.e.c = c; var cellText = null; if (cellObj.hasOwnProperty('text')) { cellText = cellObj.text; } var cell = {v: cellText}; var calColWidth = true; if (cellObj.hasOwnProperty('merge')) { var mergeObj = cellObj.merge; calColWidth = false; //var colStartEnd = cellObj.merge.split('-'); var ec = c; var er = this.rowCount; if (mergeObj.hasOwnProperty('c')) { ec = (c + parseInt(mergeObj.c)); } if (mergeObj.hasOwnProperty('r')) { er = (this.rowCount + parseInt(mergeObj.r)); } this.merges.push({s: {r: this.rowCount, c: c}, e: {r: er, c: ec}}); //this.merges.push({s: {r: this.rowCount, c: c}, e: {r: (this.rowCount + 1), c: (c + 2)}}); } if (calColWidth) { this.cellWidth(cell.v, c); } if (cell.v === null) continue; var cell_ref = XLSX.utils.encode_cell({c: c, r: this.rowCount}); this.setCellDataType(cell); if (cellObj.hasOwnProperty('style')) { cell.s = cellObj.style; } this.worksheet[cell_ref] = cell; } this.rowCount++; }, createWorkSheet: function () { for (var i in this.worksheetObj.data) { this.jhAddRow(this.worksheetObj.data[i]); } this.cellWidthValidate(); //console.log(this.merges); //this.worksheet['!merges'] = [{s: {r: 0, c: 0}, e: {r: 0, c: 4}},{s: {r: 5, c: 0}, e: {r: 6, c: 3}}];//this.merges; this.worksheet['!merges'] = this.merges; this.worksheet['!cols'] = this.wsColswidth; if (this.range.s.c < 10000000) this.worksheet['!ref'] = XLSX.utils.encode_range(this.range); return this.worksheet; }, s2ab: function (s) { var buf = new ArrayBuffer(s.length); var view = new Uint8Array(buf); for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF; return buf; }, getBlob: function (workbookObj, options) { this.init(options); var workbook = new Workbook(); /* add worksheet to workbook */ for (var i in workbookObj) { this.reset(); this.worksheetObj = workbookObj[i]; var sheetName = this.config.sheetName + i; if (this.worksheetObj.hasOwnProperty('sheetName')) { sheetName = this.worksheetObj.sheetName; } this.createWorkSheet(); workbook.SheetNames.push(sheetName); workbook.Sheets[sheetName] = this.worksheet; } var wbout = XLSX.write(workbook, {bookType: 'xlsx', bookSST: true, type: 'binary'}); var blobData = new Blob([this.s2ab(wbout)], {type: "application/octet-stream"}); return blobData; }, export: function (workbookObj, options) { saveAs(this.getBlob(workbookObj, options), this.config.fileFullName); }, } function Workbook() { if (!(this instanceof Workbook)) return new Workbook(); this.SheetNames = []; this.Sheets = {}; }
| ver. 1.4 |
Github
|
.
| PHP 7.4.3-4ubuntu2.28 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка