File
Login or Register via GitHub
<html lang="en"><head> <title>Test</title> <meta charset="utf-8" http-equiv="X-UA-Compatible" content="IE=edge;chrome=1" /> <meta name="viewport" content="width=device-width, initial-scale=1"> <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script> <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/dt/jszip-2.5.0/dt-1.12.1/b-2.2.3/b-html5-2.2.3/datatables.min.css"/> <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script> <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script> <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet" /> <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.3.0/js/bootstrap-datepicker.js"></script> <script type="text/javascript" src="https://cdn.datatables.net/v/dt/jszip-2.5.0/dt-1.12.1/b-2.2.3/b-html5-2.2.3/datatables.min.js"></script> </head><div style="visibility:collapse"><table><tr><td id="d1"></td></tr><tr><td id="d2"></td></tr><tr><td id="d3"></td></tr></table></div><div class="container-fluid" id="qselect"> </div><div id="qresults" class="container-fluid"><table style="width: 98%"> <tr> <td style="text-align:left"><h5>Loans for Review</h5></td> <td style="text-align:right"> <button onclick="goBack()">Back</button> <button onclick="printContent('p1')">Print Report</button> <button onclick="self.close()">Close</button> </td> </tr></table><div class="container-fluid" id="p1"> <table style="width: 99%"><tr> <td style="text-align:center"> <b>Loans for Review</b> Booked Between 2022-09-01 and 2022-09-22 <br />D = Detailed Review of 10% of New Loans and All Real Estate Loans </td> <td style="text-align:right;width: 75px">9/22/2022<br />4:52:14 PM</td></tr> </table> <table id="1" class="display" style="width:100%"> <thead> <tr style="background-color:lightblue"> <th style="text-align:center"></th> <th style="text-align:center">Review</th> <th style="text-align:center">Member</th> <th style="text-align:center">Name</th> <th style="text-align:center">Booked</th> <th>OrigAmt</th> <th>Balance</th> <th>APR</th> <th style="text-align:center">Term</th> <th style="text-align:center">Loan Officer</th> </tr> </thead> <tbody> <tr style="background-color:lightblue;border:1px solid black"> <td style="text-align:left"><b> Branch: 1 - Boise </b></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr style="background-color:bisque;border-top:1px solid black"> <td style="text-align:left"> <b>New Vehicle</b></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr style="background-color:bisque;border-top:1px solid black"> <td style="text-align:left"> <b>Used Vehicle</b></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="text-align:center"> </td> <td style="text-align:center">3</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:center">9/14/2022</td> <td style="text-align:right">6109.54</td> <td style="text-align:right">6109.54</td> <td style="text-align:right">3.63</td> <td style="text-align:center">36</td> <td style="text-align:left;white-space:nowrap">123 </td> </tr> <tr style="background-color:lightgreen"> <td style="text-align:center"> </td> <td style="text-align:center">4</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:center">9/9/2022</td> <td style="text-align:right">10400.00</td> <td style="text-align:right">10400.00</td> <td style="text-align:right">3.49</td> <td style="text-align:center">48</td> <td style="text-align:left;white-space:nowrap">107-123 123 </td> </tr> <tr> <td style="text-align:center"> </td> <td style="text-align:center">5</td> <td style="text-align:left;white-space:nowrap">123-123</td> <td style="text-align:left;white-space:nowrap">123 123 123</td> <td style="text-align:center">9/8/2022</td> <td style="text-align:right">28018.64</td> <td style="text-align:right">28018.64</td> <td style="text-align:right">3.49</td> <td style="text-align:center">72</td> <td style="text-align:left;white-space:nowrap">106-123 123 </td> </tr> <tr style="background-color:lightgreen"> <td style="text-align:center"> </td> <td style="text-align:center">6</td> <td style="text-align:left;white-space:nowrap">123-123</td> <td style="text-align:left;white-space:nowrap">123 123</td> <td style="text-align:center">9/19/2022</td> <td style="text-align:right">37000.00</td> <td style="text-align:right">37000.00</td> <td style="text-align:right">3.49</td> <td style="text-align:center">48</td> <td style="text-align:left;white-space:nowrap">123 </td> </tr> <tr> <td style="text-align:center"> </td> <td style="text-align:center">7</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:center">9/7/2022</td> <td style="text-align:right">37878.49</td> <td style="text-align:right">37878.49</td> <td style="text-align:right">2.99</td> <td style="text-align:center">48</td> <td style="text-align:left;white-space:nowrap">123 </td> </tr> <tr style="background-color:lightgreen"> <td style="text-align:center"> </td> <td style="text-align:center">8</td> <td style="text-align:left;white-space:nowrap">1232</td> <td style="text-align:left;white-space:nowrap">123n</td> <td style="text-align:center">9/2/2022</td> <td style="text-align:right">40438.75</td> <td style="text-align:right">40438.75</td> <td style="text-align:right">3.99</td> <td style="text-align:center">84</td> <td style="text-align:left;white-space:nowrap">5123 </td> </tr> <tr> <td style="text-align:center"> </td> <td style="text-align:center">9</td> <td style="text-align:left;white-space:nowrap">123-150</td> <td style="text-align:left;white-space:nowrap">123ki</td> <td style="text-align:center">9/13/2022</td> <td style="text-align:right">45400.00</td> <td style="text-align:right">45400.00</td> <td style="text-align:right">4.98</td> <td style="text-align:center">84</td> <td style="text-align:left;white-space:nowrap">5123 </td> </tr> <tr style="background-color:lightgreen"> <td style="text-align:center"> </td> <td style="text-align:center">10</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:left;white-space:nowrap">123x</td> <td style="text-align:center">9/1/2022</td> <td style="text-align:right">46822.54</td> <td style="text-align:right">46822.54</td> <td style="text-align:right">3.99</td> <td style="text-align:center">84</td> <td style="text-align:left;white-space:nowrap">5123 </td> </tr> <tr> <td style="text-align:center"> D</td> <td style="text-align:center">11</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:left;white-space:nowrap">D123</td> <td style="text-align:center">9/16/2022</td> <td style="text-align:right">47087.70</td> <td style="text-align:right">47087.70</td> <td style="text-align:right">4.19</td> <td style="text-align:center">84</td> <td style="text-align:left;white-space:nowrap">5123 </td> </tr> <tr style="background-color:lightyellow"> <td style="text-align:left"> <b>Last 2 Above</b> Qualifies for General Review (25%)</td> <td style="text-align:left"> </td> <td></td> <td></td> <td></td> <td style="text-align:right;border-top-style:double">299155.66</td> <td style="text-align:right;border-top-style:double">299155.66</td> <td></td> <td></td> <td></td> </tr> <tr style="background-color:bisque;border-top:1px solid black"> <td style="text-align:left"> <b>Recreational Vehicle</b></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr style="background-color:lightgreen"> <td style="text-align:center"> </td> <td style="text-align:center">12</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:center">9/9/2022</td> <td style="text-align:right">61011.00</td> <td style="text-align:right">61011.00</td> <td style="text-align:right">4.74</td> <td style="text-align:center">120</td> <td style="text-align:left;white-space:nowrap">123 </td> </tr> <tr style="background-color:lightyellow"> <td style="text-align:left"> <b>Last 0 Above</b> Qualifies for General Review (25%)</td> <td style="text-align:left"> </td> <td></td> <td></td> <td></td> <td style="text-align:right;border-top-style:double">61011.00</td> <td style="text-align:right;border-top-style:double">61011.00</td> <td></td> <td></td> <td></td> </tr> <tr style="background-color:bisque;border-top:1px solid black"> <td style="text-align:left"> <b>Personal Loan</b></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> </tbody> </table> <p> </p> <table id="2" class="display"> <thead> <tr style="background-color:lightblue"> <th style="text-align:center"> </th> <th style="text-align:center">Review</th> <th style="text-align:center">Member</th> <th style="text-align:center">Name</th> <th style="text-align:center">Booked</th> <th>Amount</th> <th style="text-align:center">Br</th> <th style="text-align:center">Loan Officer</th> <th style="text-align:center">Description</th> </tr> </thead> <tbody> <tr style="border:1px solid black"> <td style="text-align:center"> <b>Overdraft LOC Limit Changes </b>done Between 2022-09-01 and 2022-09-22 <br />D = Review 10% of Limit Changes </td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td style="text-align:right;">9/22/2022 <br />4:52:15 PM </td> </tr> <tr> <td style="text-align:center"> D</td> <td style="text-align:center">1</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:left;white-space:nowrap">123o</td> <td style="text-align:center">9/5/2022</td> <td style="text-align:right">2000.00</td> <td style="text-align:center">4</td> <td style="text-align:left;white-space:nowrap">123 </td> <td style="text-align:left;white-space:nowrap"> Overdraft Protection LOC</td> </tr> <tr style="background-color:lightyellow;border:1px solid black"> <td style="text-align:left"> <b>Last 0 Above</b> Qualifies for General Review (25%)</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> </tbody></table> <p> </p> <table id="3" class="display"> <thead> <tr style="background-color:lightblue"> <th style="text-align:center"> </th> <th style="text-align:center">Review</th> <th style="text-align:center">Member</th> <th style="text-align:center">Name</th> <th style="text-align:center">Booked</th> <th>Amount</th> <th style="text-align:center">Br</th> <th style="text-align:center">Loan Officer</th> <th style="text-align:center">Description</th> </tr> </thead> <tbody> <tr style="border:1px solid black"> <td style="text-align:center"> <b>VISA Credit Card Approvals </b>done Between 2022-09-01 and 2022-09-22 <br />D = Review 10% of VISA Credit Card Approvals </td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td style="text-align:right">9/22/2022 <br />4:52:15 PM </td> </tr> <tr> <td style="text-align:center"> D</td> <td style="text-align:center">1</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:center">9/16/2022</td> <td style="text-align:right">2,500.00</td> <td style="text-align:center">3</td> <td style="text-align:left;white-space:nowrap">123 </td> <td style="text-align:left;white-space:nowrap"> Credit Card VISA</td> </tr> <tr style="background-color:lightgreen"> <td style="text-align:center"> </td> <td style="text-align:center">2</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:left;white-space:nowrap">J123</td> <td style="text-align:center">9/21/2022</td> <td style="text-align:right">2,500.00</td> <td style="text-align:center">7</td> <td style="text-align:left;white-space:nowrap">123 </td> <td style="text-align:left;white-space:nowrap"> Credit Card VISA</td> </tr> <tr> <td style="text-align:center"> </td> <td style="text-align:center">3</td> <td style="text-align:left;white-space:nowrap">123</td> <td style="text-align:left;white-space:nowrap">123r</td> <td style="text-align:center">9/16/2022</td> <td style="text-align:right">15,000.00</td> <td style="text-align:center">5</td> <td style="text-align:left;white-space:nowrap">123a </td> <td style="text-align:left;white-space:nowrap"> Credit Card VISA</td> </tr> <tr style="background-color:lightyellow;border:1px solid black"> <td style="text-align:left"> <b>Last 1 Above</b> Qualifies for General Review (25%)</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> </tbody></table></div></div><p> </p><p> </p></body></html>table { border-spacing: 2px; text-align: right; vertical-align: text-top; border: 0.2px solid white; vertical-align: text-top } th { font-family:Tahoma; font-size:12px; text-align: right } tr { vertical-align: text-top } td {font-family:Tahoma;font-size:12px} a {font-family:Tahoma;font-size:12px} a:link {color:blue} a:visited {color:darkred} a:hover {color:darkblue} a:active {color:red} .inline {display: inline} .container { width: 98%; margin: 15px auto; } #caption{margin-left: 25px} button:hover {color:Highlight}// Based on example from:// https://datatables.net/forums/discussion/49457$(document).ready( function () { function getHeaderNames(table) { // Gets header names. //params: // table: table ID. //Returns: // Array of column header names. var header = $(table).DataTable().columns().header().toArray(); var names = []; header.forEach(function(th) { names.push($(th).html()); }); return names; } function buildCols(data) { // Builds cols XML. //To do: deifne widths for each column. //Params: // data: row data. //Returns: // String of XML formatted column widths. var cols = '<cols>'; for (i=0; i<data.length; i++) { colNum = i + 1; cols += '<col min="' + colNum + '" max="' + colNum + '" width="20" customWidth="1"/>'; } cols += '</cols>'; return cols; } function buildRow(data, rowNum, styleNum) { // Builds row XML. //Params: // data: Row data. // rowNum: Excel row number. // styleNum: style number or empty string for no style. //Returns: // String of XML formatted row. var style = styleNum ? ' s="' + styleNum + '"' : ''; var row = '<row r="' + rowNum + '">'; for (i=0; i<data.length; i++) { colNum = (i + 10).toString(36).toUpperCase(); // Convert to alpha var cr = colNum + rowNum; row += '<c t="inlineStr" r="' + cr + '"' + style + '>' + '<is>' + '<t>' + data[i] + '</t>' + '</is>' + '</c>'; } row += '</row>'; return row; } function getTableData(table, title) { // Processes Datatable row data to build sheet. //Params: // table: table ID. // title: Title displayed at top of SS or empty str for no title. //Returns: // String of XML formatted worksheet. var header = getHeaderNames(table); var table = $(table).DataTable(); var rowNum = 1; var mergeCells = ''; var ws = ''; ws += buildCols(header); ws += '<sheetData>'; if (title.length > 0) { ws += buildRow([title], rowNum, 51); rowNum++; mergeCol = ((header.length - 1) + 10).toString(36).toUpperCase(); mergeCells = '<mergeCells count="1">'+ '<mergeCell ref="A1:' + mergeCol + '1"/>' + '</mergeCells>'; } ws += buildRow(header, rowNum, 2); rowNum++; // Loop through each row to append to sheet. table.rows().every( function ( rowIdx, tableLoop, rowLoop ) { var data = this.data(); // If data is object based then it needs to be converted // to an array before sending to buildRow() ws += buildRow(data, rowNum, ''); rowNum++; } ); ws += '</sheetData>' + mergeCells; return ws; } function setSheetName(xlsx, name) { // Changes tab title for sheet. //Params: // xlsx: xlxs worksheet object. // name: name for sheet. if (name.length > 0) { var source = xlsx.xl['workbook.xml'].getElementsByTagName('sheet')[0]; source.setAttribute('name', name); } } function addSheet(xlsx, table, title, name, sheetId) { //Clones sheet from Sheet1 to build new sheet. //Params: // xlsx: xlsx object. // table: table ID. // title: Title for top row or blank if no title. // name: Name of new sheet. // sheetId: string containing sheetId for new sheet. //Returns: // Updated sheet object. //Add sheet2 to [Content_Types].xml => <Types> //============================================ var source = xlsx['[Content_Types].xml'].getElementsByTagName('Override')[1]; var clone = source.cloneNode(true); clone.setAttribute('PartName','/xl/worksheets/sheet' + sheetId + '.xml'); xlsx['[Content_Types].xml'].getElementsByTagName('Types')[0].appendChild(clone); //Add sheet relationship to xl/_rels/workbook.xml.rels => Relationships //===================================================================== var source = xlsx.xl._rels['workbook.xml.rels'].getElementsByTagName('Relationship')[0]; var clone = source.cloneNode(true); clone.setAttribute('Id','rId'+sheetId+1); clone.setAttribute('Target','worksheets/sheet' + sheetId + '.xml'); xlsx.xl._rels['workbook.xml.rels'].getElementsByTagName('Relationships')[0].appendChild(clone); //Add second sheet to xl/workbook.xml => <workbook><sheets> //========================================================= var source = xlsx.xl['workbook.xml'].getElementsByTagName('sheet')[0]; var clone = source.cloneNode(true); clone.setAttribute('name', name); clone.setAttribute('sheetId', sheetId); clone.setAttribute('r:id','rId'+sheetId+1); xlsx.xl['workbook.xml'].getElementsByTagName('sheets')[0].appendChild(clone); //Add sheet2.xml to xl/worksheets //=============================== var newSheet = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ '<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" mc:Ignorable="x14ac">'+ getTableData(table, title) + '</worksheet>'; xlsx.xl.worksheets['sheet' + sheetId + '.xml'] = $.parseXML(newSheet); } var table = $('#1').DataTable({ dom: 'Bftrip', buttons: [ { extend: 'excelHtml5', text: 'Excel', customize: function( xlsx ) { setSheetName(xlsx, 'Calls'); addSheet(xlsx, '#2', 'My Sheet2', 'Summary2', '2'); addSheet(xlsx, '#3', 'My Sheet3', 'Summary3', '3'); } } ], paging: false, bSort: false }); $('#2').DataTable(); $('#3').DataTable(); } ); function getParameterByName(name) { name = name.replace(/[\[\]]/g, "\\$&"); var regex = new RegExp("[?&]" + name + "(=([^&#]*)|&|#|$)"), results = regex.exec(urlStr); if (!results) return null; if (!results[2]) return ''; return decodeURIComponent(results[2].replace(/\+/g, " ")); } function getParamVal() { document.getElementById("d2").innerHTML = rFromDate; document.getElementById("d3").innerHTML = rToDate; } function goBack() { window.history.back(); } function printContent(el) { var restorepage = document.body.innerHTML; var printcontent = document.getElementById(el).innerHTML; document.body.innerHTML = printcontent; window.print(); document.body.innerHTML = restorepage; location.reload(); }
300px
You can jump to the latest bin by adding /latest to your URL
| Shortcut | Action |
|---|---|
| ctrl + [num] | Toggle nth panel |
| ctrl + 0 | Close focused panel |
| ctrl + enter | Re-render output. If console visible: run JS in console |
| Ctrl + l | Clear the console |
| ctrl + / | Toggle comment on selected lines |
| ctrl + [ | Indents selected lines |
| ctrl + ] | Unindents selected lines |
| tab | Code complete & Emmet expand |
| ctrl + s | Save & lock current Bin from further changes |
| ctrl + shift + s | Clone Bin |
| ctrl + y | Archive Bin |
Complete list of JS Bin shortcuts | |
| URL | Action |
|---|---|
| / | Show the full rendered output. This content will update in real time as it's updated from the /edit url. |
| /edit | Edit the current bin |
| /watch | Follow a Code Casting session |
| /embed | Create an embeddable version of the bin |
| /latest | Load the very latest bin (/latest goes in place of the revision) |
| /[username]/last | View the last edited bin for this user |
| /[username]/last/edit | Edit the last edited bin for this user |
| /[username]/last/watch | Follow the Code Casting session for the latest bin for this user |
| /quiet | Remove analytics and edit button from rendered output |
| .js | Load only the JavaScript for a bin |
| .css | Load only the CSS for a bin |
Except for username prefixed urls, the url may start with http://jsbin.com/abc and the url fragments can be added to the url to view it differently. | |