| 19601 |
amit.gupta |
1 |
/*The MIT License (MIT)
|
|
|
2 |
|
|
|
3 |
Copyright (c) 2014 https://github.com/kayalshri/
|
|
|
4 |
|
|
|
5 |
Permission is hereby granted, free of charge, to any person obtaining a copy
|
|
|
6 |
of this software and associated documentation files (the "Software"), to deal
|
|
|
7 |
in the Software without restriction, including without limitation the rights
|
|
|
8 |
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
|
|
|
9 |
copies of the Software, and to permit persons to whom the Software is
|
|
|
10 |
furnished to do so, subject to the following conditions:
|
|
|
11 |
|
|
|
12 |
The above copyright notice and this permission notice shall be included in
|
|
|
13 |
all copies or substantial portions of the Software.
|
|
|
14 |
|
|
|
15 |
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
|
|
|
16 |
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
|
|
|
17 |
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
|
|
|
18 |
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
|
|
|
19 |
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
|
|
|
20 |
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
|
|
|
21 |
THE SOFTWARE.*/
|
|
|
22 |
|
|
|
23 |
(function($){
|
|
|
24 |
$.fn.extend({
|
|
|
25 |
tableExport: function(options) {
|
|
|
26 |
var defaults = {
|
|
|
27 |
separator: ',',
|
|
|
28 |
ignoreColumn: [],
|
|
|
29 |
tableName:'yourTableName',
|
|
|
30 |
type:'csv',
|
|
|
31 |
pdfFontSize:14,
|
|
|
32 |
pdfLeftMargin:20,
|
|
|
33 |
escape:'true',
|
|
|
34 |
htmlContent:'false',
|
|
|
35 |
consoleLog:'false'
|
|
|
36 |
};
|
|
|
37 |
|
|
|
38 |
var options = $.extend(defaults, options);
|
|
|
39 |
var el = this;
|
|
|
40 |
|
|
|
41 |
if(defaults.type == 'csv' || defaults.type == 'txt'){
|
|
|
42 |
|
|
|
43 |
// Header
|
|
|
44 |
var tdData ="";
|
|
|
45 |
$(el).find('thead').find('tr').each(function() {
|
|
|
46 |
tdData += "\n";
|
|
|
47 |
$(this).filter(':visible').find('th').each(function(index,data) {
|
|
|
48 |
if ($(this).css('display') != 'none'){
|
|
|
49 |
if(defaults.ignoreColumn.indexOf(index) == -1){
|
|
|
50 |
tdData += '"' + parseString($(this)) + '"' + defaults.separator;
|
|
|
51 |
}
|
|
|
52 |
}
|
|
|
53 |
|
|
|
54 |
});
|
|
|
55 |
tdData = $.trim(tdData);
|
|
|
56 |
tdData = $.trim(tdData).substring(0, tdData.length -1);
|
|
|
57 |
});
|
|
|
58 |
|
|
|
59 |
// Row vs Column
|
|
|
60 |
$(el).find('tbody').find('tr').each(function() {
|
|
|
61 |
tdData += "\n";
|
|
|
62 |
$(this).filter(':visible').find('td').each(function(index,data) {
|
|
|
63 |
if ($(this).css('display') != 'none'){
|
|
|
64 |
if(defaults.ignoreColumn.indexOf(index) == -1){
|
|
|
65 |
tdData += '"'+ parseString($(this)) + '"'+ defaults.separator;
|
|
|
66 |
}
|
|
|
67 |
}
|
|
|
68 |
});
|
|
|
69 |
//tdData = $.trim(tdData);
|
|
|
70 |
tdData = $.trim(tdData).substring(0, tdData.length -1);
|
|
|
71 |
});
|
|
|
72 |
|
|
|
73 |
//output
|
|
|
74 |
if(defaults.consoleLog == 'true'){
|
|
|
75 |
console.log(tdData);
|
|
|
76 |
}
|
|
|
77 |
var base64data = "base64," + $.base64.encode(tdData);
|
|
|
78 |
window.open('data:application/'+defaults.type+';filename=exportData;' + base64data);
|
|
|
79 |
}else if(defaults.type == 'sql'){
|
|
|
80 |
|
|
|
81 |
// Header
|
|
|
82 |
var tdData ="INSERT INTO `"+defaults.tableName+"` (";
|
|
|
83 |
$(el).find('thead').find('tr').each(function() {
|
|
|
84 |
|
|
|
85 |
$(this).filter(':visible').find('th').each(function(index,data) {
|
|
|
86 |
if ($(this).css('display') != 'none'){
|
|
|
87 |
if(defaults.ignoreColumn.indexOf(index) == -1){
|
|
|
88 |
tdData += '`' + parseString($(this)) + '`,' ;
|
|
|
89 |
}
|
|
|
90 |
}
|
|
|
91 |
|
|
|
92 |
});
|
|
|
93 |
tdData = $.trim(tdData);
|
|
|
94 |
tdData = $.trim(tdData).substring(0, tdData.length -1);
|
|
|
95 |
});
|
|
|
96 |
tdData += ") VALUES ";
|
|
|
97 |
// Row vs Column
|
|
|
98 |
$(el).find('tbody').find('tr').each(function() {
|
|
|
99 |
tdData += "(";
|
|
|
100 |
$(this).filter(':visible').find('td').each(function(index,data) {
|
|
|
101 |
if ($(this).css('display') != 'none'){
|
|
|
102 |
if(defaults.ignoreColumn.indexOf(index) == -1){
|
|
|
103 |
tdData += '"'+ parseString($(this)) + '",';
|
|
|
104 |
}
|
|
|
105 |
}
|
|
|
106 |
});
|
|
|
107 |
|
|
|
108 |
tdData = $.trim(tdData).substring(0, tdData.length -1);
|
|
|
109 |
tdData += "),";
|
|
|
110 |
});
|
|
|
111 |
tdData = $.trim(tdData).substring(0, tdData.length -1);
|
|
|
112 |
tdData += ";";
|
|
|
113 |
|
|
|
114 |
//output
|
|
|
115 |
//console.log(tdData);
|
|
|
116 |
|
|
|
117 |
if(defaults.consoleLog == 'true'){
|
|
|
118 |
console.log(tdData);
|
|
|
119 |
}
|
|
|
120 |
|
|
|
121 |
var base64data = "base64," + $.base64.encode(tdData);
|
|
|
122 |
window.open('data:application/sql;filename=exportData;' + base64data);
|
|
|
123 |
|
|
|
124 |
|
|
|
125 |
}else if(defaults.type == 'json'){
|
|
|
126 |
|
|
|
127 |
var jsonHeaderArray = [];
|
|
|
128 |
$(el).find('thead').find('tr').each(function() {
|
|
|
129 |
var tdData ="";
|
|
|
130 |
var jsonArrayTd = [];
|
|
|
131 |
|
|
|
132 |
$(this).filter(':visible').find('th').each(function(index,data) {
|
|
|
133 |
if ($(this).css('display') != 'none'){
|
|
|
134 |
if(defaults.ignoreColumn.indexOf(index) == -1){
|
|
|
135 |
jsonArrayTd.push(parseString($(this)));
|
|
|
136 |
}
|
|
|
137 |
}
|
|
|
138 |
});
|
|
|
139 |
jsonHeaderArray.push(jsonArrayTd);
|
|
|
140 |
|
|
|
141 |
});
|
|
|
142 |
|
|
|
143 |
var jsonArray = [];
|
|
|
144 |
$(el).find('tbody').find('tr').each(function() {
|
|
|
145 |
var tdData ="";
|
|
|
146 |
var jsonArrayTd = [];
|
|
|
147 |
|
|
|
148 |
$(this).filter(':visible').find('td').each(function(index,data) {
|
|
|
149 |
if ($(this).css('display') != 'none'){
|
|
|
150 |
if(defaults.ignoreColumn.indexOf(index) == -1){
|
|
|
151 |
jsonArrayTd.push(parseString($(this)));
|
|
|
152 |
}
|
|
|
153 |
}
|
|
|
154 |
});
|
|
|
155 |
jsonArray.push(jsonArrayTd);
|
|
|
156 |
|
|
|
157 |
});
|
|
|
158 |
|
|
|
159 |
var jsonExportArray =[];
|
|
|
160 |
jsonExportArray.push({header:jsonHeaderArray,data:jsonArray});
|
|
|
161 |
|
|
|
162 |
//Return as JSON
|
|
|
163 |
//console.log(JSON.stringify(jsonExportArray));
|
|
|
164 |
|
|
|
165 |
//Return as Array
|
|
|
166 |
//console.log(jsonExportArray);
|
|
|
167 |
if(defaults.consoleLog == 'true'){
|
|
|
168 |
console.log(JSON.stringify(jsonExportArray));
|
|
|
169 |
}
|
|
|
170 |
var base64data = "base64," + $.base64.encode(JSON.stringify(jsonExportArray));
|
|
|
171 |
window.open('data:application/json;filename=exportData;' + base64data);
|
|
|
172 |
}else if(defaults.type == 'xml'){
|
|
|
173 |
|
|
|
174 |
var xml = '<?xml version="1.0" encoding="utf-8"?>';
|
|
|
175 |
xml += '<tabledata><fields>';
|
|
|
176 |
|
|
|
177 |
// Header
|
|
|
178 |
$(el).find('thead').find('tr').each(function() {
|
|
|
179 |
$(this).filter(':visible').find('th').each(function(index,data) {
|
|
|
180 |
if ($(this).css('display') != 'none'){
|
|
|
181 |
if(defaults.ignoreColumn.indexOf(index) == -1){
|
|
|
182 |
xml += "<field>" + parseString($(this)) + "</field>";
|
|
|
183 |
}
|
|
|
184 |
}
|
|
|
185 |
});
|
|
|
186 |
});
|
|
|
187 |
xml += '</fields><data>';
|
|
|
188 |
|
|
|
189 |
// Row Vs Column
|
|
|
190 |
var rowCount=1;
|
|
|
191 |
$(el).find('tbody').find('tr').each(function() {
|
|
|
192 |
xml += '<row id="'+rowCount+'">';
|
|
|
193 |
var colCount=0;
|
|
|
194 |
$(this).filter(':visible').find('td').each(function(index,data) {
|
|
|
195 |
if ($(this).css('display') != 'none'){
|
|
|
196 |
if(defaults.ignoreColumn.indexOf(index) == -1){
|
|
|
197 |
xml += "<column-"+colCount+">"+parseString($(this))+"</column-"+colCount+">";
|
|
|
198 |
}
|
|
|
199 |
}
|
|
|
200 |
colCount++;
|
|
|
201 |
});
|
|
|
202 |
rowCount++;
|
|
|
203 |
xml += '</row>';
|
|
|
204 |
});
|
|
|
205 |
xml += '</data></tabledata>'
|
|
|
206 |
|
|
|
207 |
if(defaults.consoleLog == 'true'){
|
|
|
208 |
console.log(xml);
|
|
|
209 |
}
|
|
|
210 |
|
|
|
211 |
var base64data = "base64," + $.base64.encode(xml);
|
|
|
212 |
window.open('data:application/xml;filename=exportData;' + base64data);
|
|
|
213 |
|
|
|
214 |
}else if(defaults.type == 'excel' || defaults.type == 'doc'|| defaults.type == 'powerpoint' ){
|
|
|
215 |
//console.log($(this).html());
|
|
|
216 |
var excel="<table>";
|
|
|
217 |
// Header
|
|
|
218 |
$(el).find('thead').find('tr').each(function() {
|
|
|
219 |
excel += "<tr>";
|
|
|
220 |
$(this).filter(':visible').find('th').each(function(index,data) {
|
|
|
221 |
if ($(this).css('display') != 'none'){
|
|
|
222 |
if(defaults.ignoreColumn.indexOf(index) == -1){
|
|
|
223 |
excel += "<td>" + parseString($(this))+ "</td>";
|
|
|
224 |
}
|
|
|
225 |
}
|
|
|
226 |
});
|
|
|
227 |
excel += '</tr>';
|
|
|
228 |
|
|
|
229 |
});
|
|
|
230 |
|
|
|
231 |
|
|
|
232 |
// Row Vs Column
|
|
|
233 |
var rowCount=1;
|
|
|
234 |
$(el).find('tbody').find('tr').each(function() {
|
|
|
235 |
excel += "<tr>";
|
|
|
236 |
var colCount=0;
|
|
|
237 |
$(this).filter(':visible').find('td').each(function(index,data) {
|
|
|
238 |
if ($(this).css('display') != 'none'){
|
|
|
239 |
if(defaults.ignoreColumn.indexOf(index) == -1){
|
|
|
240 |
excel += "<td>"+parseString($(this))+"</td>";
|
|
|
241 |
}
|
|
|
242 |
}
|
|
|
243 |
colCount++;
|
|
|
244 |
});
|
|
|
245 |
rowCount++;
|
|
|
246 |
excel += '</tr>';
|
|
|
247 |
});
|
|
|
248 |
excel += '</table>'
|
|
|
249 |
|
|
|
250 |
if(defaults.consoleLog == 'true'){
|
|
|
251 |
console.log(excel);
|
|
|
252 |
}
|
|
|
253 |
|
|
|
254 |
var excelFile = "<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:"+defaults.type+"' xmlns='http://www.w3.org/TR/REC-html40'>";
|
|
|
255 |
excelFile += "<head>";
|
|
|
256 |
excelFile += "<!--[if gte mso 9]>";
|
|
|
257 |
excelFile += "<xml>";
|
|
|
258 |
excelFile += "<x:ExcelWorkbook>";
|
|
|
259 |
excelFile += "<x:ExcelWorksheets>";
|
|
|
260 |
excelFile += "<x:ExcelWorksheet>";
|
|
|
261 |
excelFile += "<x:Name>";
|
|
|
262 |
excelFile += "{worksheet}";
|
|
|
263 |
excelFile += "</x:Name>";
|
|
|
264 |
excelFile += "<x:WorksheetOptions>";
|
|
|
265 |
excelFile += "<x:DisplayGridlines/>";
|
|
|
266 |
excelFile += "</x:WorksheetOptions>";
|
|
|
267 |
excelFile += "</x:ExcelWorksheet>";
|
|
|
268 |
excelFile += "</x:ExcelWorksheets>";
|
|
|
269 |
excelFile += "</x:ExcelWorkbook>";
|
|
|
270 |
excelFile += "</xml>";
|
|
|
271 |
excelFile += "<![endif]-->";
|
|
|
272 |
excelFile += "</head>";
|
|
|
273 |
excelFile += "<body>";
|
|
|
274 |
excelFile += excel;
|
|
|
275 |
excelFile += "</body>";
|
|
|
276 |
excelFile += "</html>";
|
|
|
277 |
|
|
|
278 |
var base64data = "base64," + $.base64.encode(excelFile);
|
|
|
279 |
window.open('data:application/vnd.ms-'+defaults.type+';filename=exportData.doc;' + base64data);
|
|
|
280 |
|
|
|
281 |
}else if(defaults.type == 'png'){
|
|
|
282 |
html2canvas($(el), {
|
|
|
283 |
onrendered: function(canvas) {
|
|
|
284 |
var img = canvas.toDataURL("image/png");
|
|
|
285 |
window.open(img);
|
|
|
286 |
|
|
|
287 |
|
|
|
288 |
}
|
|
|
289 |
});
|
|
|
290 |
}else if(defaults.type == 'pdf'){
|
|
|
291 |
|
|
|
292 |
var doc = new jsPDF('p','pt', 'a4', true);
|
|
|
293 |
doc.setFontSize(defaults.pdfFontSize);
|
|
|
294 |
|
|
|
295 |
// Header
|
|
|
296 |
var startColPosition=defaults.pdfLeftMargin;
|
|
|
297 |
$(el).find('thead').find('tr').each(function() {
|
|
|
298 |
$(this).filter(':visible').find('th').each(function(index,data) {
|
|
|
299 |
if ($(this).css('display') != 'none'){
|
|
|
300 |
if(defaults.ignoreColumn.indexOf(index) == -1){
|
|
|
301 |
var colPosition = startColPosition+ (index * 50);
|
|
|
302 |
doc.text(colPosition,20, parseString($(this)));
|
|
|
303 |
}
|
|
|
304 |
}
|
|
|
305 |
});
|
|
|
306 |
});
|
|
|
307 |
|
|
|
308 |
|
|
|
309 |
// Row Vs Column
|
|
|
310 |
var startRowPosition = 20; var page =1;var rowPosition=0;
|
|
|
311 |
$(el).find('tbody').find('tr').each(function(index,data) {
|
|
|
312 |
rowCalc = index+1;
|
|
|
313 |
|
|
|
314 |
if (rowCalc % 26 == 0){
|
|
|
315 |
doc.addPage();
|
|
|
316 |
page++;
|
|
|
317 |
startRowPosition=startRowPosition+10;
|
|
|
318 |
}
|
|
|
319 |
rowPosition=(startRowPosition + (rowCalc * 10)) - ((page -1) * 280);
|
|
|
320 |
|
|
|
321 |
$(this).filter(':visible').find('td').each(function(index,data) {
|
|
|
322 |
if ($(this).css('display') != 'none'){
|
|
|
323 |
if(defaults.ignoreColumn.indexOf(index) == -1){
|
|
|
324 |
var colPosition = startColPosition+ (index * 50);
|
|
|
325 |
doc.text(colPosition,rowPosition, parseString($(this)));
|
|
|
326 |
}
|
|
|
327 |
}
|
|
|
328 |
|
|
|
329 |
});
|
|
|
330 |
|
|
|
331 |
});
|
|
|
332 |
|
|
|
333 |
// Output as Data URI
|
|
|
334 |
doc.output('datauri');
|
|
|
335 |
|
|
|
336 |
}
|
|
|
337 |
|
|
|
338 |
|
|
|
339 |
function parseString(data){
|
|
|
340 |
|
|
|
341 |
if(defaults.htmlContent == 'true'){
|
|
|
342 |
content_data = data.html().trim();
|
|
|
343 |
}else{
|
|
|
344 |
content_data = data.text().trim();
|
|
|
345 |
}
|
|
|
346 |
|
|
|
347 |
if(defaults.escape == 'true'){
|
|
|
348 |
content_data = escape(content_data);
|
|
|
349 |
}
|
|
|
350 |
|
|
|
351 |
|
|
|
352 |
|
|
|
353 |
return content_data;
|
|
|
354 |
}
|
|
|
355 |
|
|
|
356 |
}
|
|
|
357 |
});
|
|
|
358 |
})(jQuery);
|
|
|
359 |
|