API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
98
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.19 KB | None | 0 0
raw download clone embed print report
  1. <link href="/tooltip/themes/4/style_rh_rp09.css" rel="stylesheet" type="text/css" id="" media="print, projection, screen" />
  2. <script type="text/javascript" src="/JQuery_tablesorter/jquery-latest.js"></script>
  3. <script type="text/javascript" src="/JQuery_tablesorter/jquery.tablesorter.min.js"></script>
  4. <script type="text/javascript" src="/JQuery_tablesorter/jquery.tablesorter.js"></script>
  5. <link rel="stylesheet" type="text/css" href="/css/jquery.datatables.yadcf.css">
  6. <link rel="stylesheet" href="/yadcf-master/jquery.datatables.yadcf.css">
  7. <script src="/js/jquery.dataTables.yadcf.js"></script>
  8. <script type="text/javascript" src="/js/jquery.dataTables.min.js"></script>
  9. <link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.2/themes/base/jquery-ui.css" rel="stylesheet" type="text/css" />
  10. <script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/jquery-ui.min.js"></script>
  11. <script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
  12. <script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/jquery-ui.min.js"></script>
  13. <script type="text/javascript" src="/js/jquery.dataTables.min.js"></script>
  14. <link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.2/themes/base/jquery-ui.css" rel="stylesheet" type="text/css" />
  15. <link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/datatables/1.10.7/css/jquery.dataTables.css" />
  16. <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/datatables/1.10.7/js/jquery.dataTables.js"></script>
  17. <script type="text/javascript" src="//code.jquery.com/jquery-2.1.3.js"></script>
  18. <script type="text/javascript" charset="utf8" src="//cdn.datatables.net/1.10.2/js/jquery.dataTables.js"></script>
  19. <script type="text/javascript" src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>
  20. <script type="text/javascript" src="/JQuery/js/jquery.floatThead.js"></script>
  21. <script type="text/javascript" src="/JQuery/js/jquery.floatThead.min.js"></script>
  22. <script type="text/javascript" src="/JQuery/js/jquery.floatThead-slim.min.js"></script>
  23. <script type="text/javascript" src="/JQuery/js/jquery.floatThead-slim.js"></script>
  24. <script type="text/javascript" src="/JQuery/js/jquery.mask.js"></script>
  25.  
  26. var oTable;
  27.  
  28. $(document).ready(function() {
  29.  
  30.  
  31. $("#example tbody tr").click( function( e ) {
  32. if ( $(this).hasClass(''row_selected'') ) {
  33. $(this).removeClass(''row_selected'');
  34. }
  35. else {
  36. oTable.$(''tr.row_selected'').removeClass(''row_selected'');
  37. $(this).addClass(''row_selected'');
  38. }
  39. });
  40.  
  41. /* Add a click handler for the delete row */
  42. $(''#boton'').click( function() {
  43. var anSelected = fnGetSelected( oTable );
  44. if ( anSelected.length !== 0 ) {
  45. oTable.fnDeleteRow( anSelected[0] );
  46. }
  47. } );
  48.  
  49. //$(''#example'').children().eq(1).empty.css("border","trick solid red");
  50.  
  51. oTable = $(''#example'').DataTable( {
  52. scrollY: 300,
  53. scrollX: true,
  54. paging: false,
  55. keys: true,
  56. processing: true,
  57. //"ajax": "/custom/data-tables/process.php",
  58. aaSorting: [[2,''asc'']],
  59.  
  60. //fnRowCallback: function( nRow, aData, iDisplayIndex, iDisplayIndexFull ) {
  61. //if ( aData[0] == "5" )
  62. //{
  63. // $(''td:eq(10)'', nRow).css(''background-color'', ''Red'');
  64. //}
  65. //else if ( aData[2] == "4" )
  66. //{
  67. // $(''td:eq(10)'', nRow).css(''background-color'', ''Orange'');
  68. //}
  69. //},
  70.  
  71. fnRowCallback: function( nRow, aData, iDisplayIndex, iDisplayIndexFull ) {
  72. if ( aData[0] == "10" )
  73. {
  74. $(''td:eq(10)'', nRow).css(''background-color'', ''#FF0000'');
  75. }
  76. /*else if ( aData[2] >="1" && aData[2] <="10" )
  77. {
  78. $(''td:eq(10)'', nRow).css(''background-color'', ''#FFFF00'');
  79. }
  80. else if ( aData[2] = "0" && aData[2] < "10" )
  81. {
  82. $(''td:eq(10)'', nRow).css(''background-color'', ''#38D765'');
  83. } else
  84. {
  85. $(''td:eq(10)'', nRow).css(''background-color'', ''#FFFFFF'');
  86. }*/
  87. },
  88.  
  89. initComplete: function () {
  90. this.api().columns(2).every( function () {
  91. var column = this;
  92. var select = $(''<select><option value=""></option></select>'')
  93. .appendTo( $(column.header()).empty() )
  94. .on( ''change'', function () {
  95. var val = $.fn.dataTable.util.escapeRegex(
  96. $(this).val()
  97. );
  98. column
  99. .search( val ? ''^''+val+''$'' : '''', true, false )
  100. .draw();
  101. } );
  102. column.data().unique().sort().each( function ( d, j ) {
  103. select.append( ''<option value="''+d+''">''+d+''</option>'')
  104. } );
  105. } );
  106. },
  107.  
  108.  
  109. footerCallback: function ( row, data, start, end, display ) {
  110. var api = this.api(), data;
  111.  
  112. // Remove the formatting to get integer data for summation
  113. var intVal = function ( i ) {
  114. return typeof i === ''string'' ?
  115. i.replace(/[$,]/g, '''')*1 :
  116. typeof i === ''number'' ?
  117. i : 0;
  118. };
  119. //----------------------------------------------------------------
  120. // MD -Total over all pages
  121. total1 = api
  122. .column(8)
  123. .data()
  124. .reduce( function (a, b) {
  125. return intVal(a) + intVal(b);
  126. } );
  127. // Total over this page
  128. pageTotal1 = api
  129. .column(8, { page: ''current''} )
  130. .data()
  131. .reduce( function (a, b) {
  132. return intVal(a) + intVal(b);
  133. }, 0 );
  134. // Update footer
  135. //$( api.column( 8 ).footer() ).html(''$''+pageTotal1 +'' ( $''+ total1 +'' total)'');
  136. $(api.column(8).footer()).html(''$''+ Number(pageTotal1).toLocaleString(''en'')+''<br>($ '' + Number(total1).toLocaleString(''en'')+'' total)'' );
  137.  
  138. }
  139.  
  140.  
  141. // fin de datatable
  142. } );
  143.  
  144. $(''#example tbody'').on(''click'', ''tr'', function () {
  145. $(this).toggleClass(''selected'');
  146. var totalSUM=0;
  147. $("tbody tr.selected").each(function () {
  148. var getValue = $(this).find("td:eq(10)").html().replace("$", "");
  149. var filteresValue=getValue.replace(/,/g, '''');
  150. totalSUM += Number(filteresValue);
  151. //console.log(filteresValue);
  152. });
  153.  
  154. //$(''#selectedtotal'').html(totalSUM);
  155. //console.log(Number(totalSUM).toLocaleString(''en''));
  156. //console.log($(''tfoot tr > th'').eq(1).html( ''$''+ $(''#selectedtotal'').html()));
  157.  
  158. $("span#selectedtotal1").html(Number(totalSUM).toLocaleString(''en''));
  159.  
  160.  
  161. });
  162.  
  163.  
  164. // fin de ready
  165. } );
  166.  
  167.  
  168. /* Get the rows which are currently selected */
  169. function fnGetSelected( oTableLocal )
  170. {
  171. return oTableLocal.$(''tr.row_selected'');
  172. }
  173.  
  174. <TR role="row">
  175. <TH ROWSPAN="1">No.</TH>
  176. <TH ROWSPAN="1">Código</TH>
  177. <TH ROWSPAN="1">Proveedor</TH>
  178. <TH ROWSPAN="1">No. Documento</TH>
  179. <TH ROWSPAN="1">Cta Mayor</TH>
  180. <TH ROWSPAN="1">Fecha Doc.</TH>
  181. <TH ROWSPAN="1">Fecha Pago</TH>
  182. <TH ROWSPAN="1">Vencimiento</TH>
  183. <TH ROWSPAN="1">Importe MD</TH>
  184. <TH ROWSPAN="1">MD</TH>
  185. <TH ROWSPAN="1">Importe ML</TH>
  186. <TH ROWSPAN="1">ML</TH>
  187. <TH ROWSPAN="1">PROPUESTA</TH>
  188. <TH ROWSPAN="1">Observaciones</TH>
  189. <TH ROWSPAN="1">Usuario SAP</TH>
  190.  
  191. <TH ROWSPAN="1" BGCOLOR="#DF0101" > > 90 </TH>
  192. <TH ROWSPAN="1" >61 - 90</TH>
  193. <TH ROWSPAN="1" >31 - 60</TH>
  194. <TH ROWSPAN="1" >1 -30</TH>
  195. <TH ROWSPAN="1">1-7</TH>
  196. <TH ROWSPAN="1">8-14</TH>
  197. <TH ROWSPAN="1">15-21</TH>
  198. <TH ROWSPAN="1">22-28</TH>
  199. <TH ROWSPAN="1">29-35</TH>
  200. <TH ROWSPAN="1">36-42</TH>
  201. <TH ROWSPAN="1">43-49</TH>
  202. <TH ROWSPAN="1">50-56</TH>
  203. <TH ROWSPAN="1" >57</TH>
  204. <TH ROWSPAN="1" >Tipo Pago</TH>
  205. </TR>
  206. </thead>
  207.  
  208. <tfoot>
  209. <tr>
  210. <th colspan="8" style="text-align:right;">Total:</th>
  211. <th ></th>
  212. <th ></th>
  213. <th ></th>
  214. <th colspan="4"></th>
  215. <th ></th>
  216. <th ></th>
  217. <th ></th>
  218. <th ></th>
  219. <th ></th>
  220. <th ></th>
  221. <th ></th>
  222. <th ></th>
  223. <th ></th>
  224. <th ></th>
  225. <th ></th>
  226. <th ></th>
  227. <th ></th>
  228. <th ></th>
  229. </tr>
  230. </tfoot>
  231. <tbody>
  232.  
  233. <TR id="TH1">
  234. <TH ROWSPAN="1">270</TH>
  235. <TH ROWSPAN="1" >20792</TH>
  236. <TH ROWSPAN="1">JUANA ESCUTIA</TH>
  237. <TH ROWSPAN="1">1900113645-1</TH>
  238. <TH ROWSPAN="1">201201</TH>
  239. <TH ROWSPAN="1">27/10/2016&nbsp;</TH>
  240. <TH ROWSPAN="1">11/12/2016&nbsp;</TH>
  241. <TH ROWSPAN="1">-10&nbsp;</TH>
  242. <TH ROWSPAN="1"> 2,476</TH>
  243. <TH ROWSPAN="1">MXN</TH>
  244. <TH ROWSPAN="1"> 2,476</TH>
  245. <TH ROWSPAN="1">MXN</TH>
  246. <TH ROWSPAN="1">&nbsp;</TH>
  247. <TH ROWSPAN="1">6258396</TH>
  248. <TH ROWSPAN="1">KBENITEZ</TH>
  249. <TH ROWSPAN="1"></TH>
  250. <TH ROWSPAN="1"></TH>
  251. <TH ROWSPAN="1"></TH>
  252. <TH ROWSPAN="1"></TH>
  253. <TH ROWSPAN="1"></TH>
  254. <TH ROWSPAN="1">2,476</TH>
  255. <TH ROWSPAN="1"></TH>
  256. <TH ROWSPAN="1"></TH>
  257. <TH ROWSPAN="1"></TH>
  258. <TH ROWSPAN="1"></TH>
  259. <TH ROWSPAN="1"></TH>
  260. <TH ROWSPAN="1"></TH>
  261. <TH ROWSPAN="1"></TH>
  262. <TH ROWSPAN="1"></TH>
  263. </TR>
  264. </tbody>
  265. </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!