bootstrap-table-print.js 7.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149
  1. (function ($) {
  2. 'use strict';
  3. var sprintf = $.fn.bootstrapTable.utils.sprintf;
  4. function printPageBuilderDefault(table) {
  5. return '<html><head>' +
  6. '<style type="text/css" media="print">' +
  7. ' @page { size: auto; margin: 25px 0 25px 0; }' +
  8. '</style>' +
  9. '<style type="text/css" media="all">' +
  10. 'table{border-collapse: collapse; font-size: 12px; }\n' +
  11. 'table, th, td {border: 1px solid grey}\n' +
  12. 'th, td {text-align: center; vertical-align: middle;}\n' +
  13. 'p {font-weight: bold; margin-left:20px }\n' +
  14. 'table { width:94%; margin-left:3%; margin-right:3%}\n' +
  15. 'div.bs-table-print { text-align:center;}\n' +
  16. '</style></head><title>Print Table</title><body>' +
  17. '<p>Printed on: ' + new Date + ' </p>' +
  18. '<div class="bs-table-print">' + table + "</div></body></html>";
  19. }
  20. $.extend($.fn.bootstrapTable.defaults, {
  21. showPrint: false,
  22. printAsFilteredAndSortedOnUI: true, //boolean, when true - print table as sorted and filtered on UI.
  23. //Please note that if true is set, along with explicit predefined print options for filtering and sorting (printFilter, printSortOrder, printSortColumn)- then they will be applied on data already filtered and sorted by UI controls.
  24. //For printing data as filtered and sorted on UI - do not set these 3 options:printFilter, printSortOrder, printSortColumn
  25. printSortColumn: undefined , //String, set column field name to be sorted by
  26. printSortOrder: 'asc', //String: 'asc' , 'desc' - relevant only if printSortColumn is set
  27. printPageBuilder: function(table){return printPageBuilderDefault(table)} // function, receive html <table> element as string, returns html string for printing. by default delegates to function printPageBuilderDefault(table). used for styling and adding header or footer
  28. });
  29. $.extend($.fn.bootstrapTable.COLUMN_DEFAULTS, {
  30. printFilter: undefined, //set value to filter by in print page
  31. printIgnore: false, //boolean, set true to ignore this column in the print page
  32. printFormatter:undefined //function(value, row, index), formats the cell value for this column in the printed table. Function behaviour is similar to the 'formatter' column option
  33. });
  34. $.extend($.fn.bootstrapTable.defaults.icons, {
  35. print: 'glyphicon-print icon-share'
  36. });
  37. var BootstrapTable = $.fn.bootstrapTable.Constructor,
  38. _initToolbar = BootstrapTable.prototype.initToolbar;
  39. BootstrapTable.prototype.initToolbar = function () {
  40. this.showToolbar = this.showToolbar || this.options.showPrint;
  41. _initToolbar.apply(this, Array.prototype.slice.apply(arguments));
  42. if (this.options.showPrint) {
  43. var that = this,
  44. $btnGroup = this.$toolbar.find('>.btn-group'),
  45. $print = $btnGroup.find('button.bs-print');
  46. if (!$print.length) {
  47. $print = $([
  48. '<button class="bs-print btn btn-default' + sprintf(' btn-%s"', this.options.iconSize) + ' name="print" title="print" type="button">',
  49. sprintf('<i class="%s %s"></i> ', this.options.iconsPrefix, this.options.icons.print),
  50. '</button>'].join('')).appendTo($btnGroup);
  51. $print.click(function () {
  52. function formatValue(row, i, column ) {
  53. var value = row[column.field];
  54. if (typeof column.printFormatter === 'function') {
  55. return column.printFormatter.apply(column, [value, row, i]);
  56. }
  57. else {
  58. return typeof value === 'undefined' ? "-" : value;
  59. }
  60. }
  61. function buildTable(data, columnsArray) {
  62. var html = ['<table><thead>'];
  63. for (var k = 0; k < columnsArray.length; k++) {
  64. var columns = columnsArray[k];
  65. html.push('<tr>');
  66. for (var h = 0; h < columns.length; h++) {
  67. if (!columns[h].printIgnore) {
  68. html.push(
  69. '<th',
  70. sprintf(' rowspan="%s"', columns[h].rowspan),
  71. sprintf(' colspan="%s"', columns[h].colspan),
  72. sprintf('>%s</th>', columns[h].title)
  73. );
  74. }
  75. }
  76. html.push('</tr>');
  77. }
  78. html.push('</thead><tbody>');
  79. for (var i = 0; i < data.length; i++) {
  80. html.push('<tr>');
  81. for(var l = 0; l < columnsArray.length; l++) {
  82. var columns = columnsArray[l];
  83. for(var j = 0; j < columns.length; j++) {
  84. if (!columns[j].printIgnore && columns[j].field) {
  85. html.push('<td>', formatValue(data[i], i, columns[j]), '</td>');
  86. }
  87. }
  88. }
  89. html.push('</tr>');
  90. }
  91. html.push('</tbody></table>');
  92. return html.join('');
  93. }
  94. function sortRows(data,colName,sortOrder) {
  95. if(!colName){
  96. return data;
  97. }
  98. var reverse = sortOrder != 'asc';
  99. reverse = -((+reverse) || -1);
  100. return data.sort(function (a, b) {
  101. return reverse * (a[colName].localeCompare(b[colName]));
  102. });
  103. }
  104. function filterRow(row,filters) {
  105. for (var index = 0; index < filters.length; ++index) {
  106. if(row[filters[index].colName]!=filters[index].value) {
  107. return false;
  108. }
  109. }
  110. return true;
  111. }
  112. function filterRows(data,filters) {
  113. return data.filter(function (row) {
  114. return filterRow(row,filters)
  115. });
  116. }
  117. function getColumnFilters(columns) {
  118. return !columns || !columns[0] ? [] : columns[0].filter(function (col) {
  119. return col.printFilter;
  120. }).map(function (col) {
  121. return {colName:col.field, value:col.printFilter};
  122. });
  123. }
  124. var doPrint = function (data) {
  125. data=filterRows(data,getColumnFilters(that.options.columns));
  126. data=sortRows(data,that.options.printSortColumn,that.options.printSortOrder);
  127. var table=buildTable(data,that.options.columns);
  128. var newWin = window.open("");
  129. newWin.document.write(that.options.printPageBuilder.call(this, table));
  130. newWin.print();
  131. newWin.close();
  132. };
  133. doPrint(that.options.printAsFilteredAndSortedOnUI? that.getData() : that.options.data.slice(0));
  134. });
  135. }
  136. }
  137. };
  138. })(jQuery);