File
Add library
Share
Login or Register
Help
HTMLSaved
 
​
​
<!doctype html>
<html lang="en">
<head>
    <title>Loans to Review by Date Range</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>
<body onload="getParamVal()">
<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>&nbsp;
        <button onclick="printContent('p1')">Print Report</button>&nbsp;
        <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>&nbsp;&nbsp;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"> &nbsp;<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"> &nbsp;<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">&nbsp; </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">&nbsp; </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">&nbsp; </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">&nbsp; </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">&nbsp; </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">&nbsp; </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">&nbsp; </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">&nbsp; </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">&nbsp;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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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"> &nbsp;<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">&nbsp; </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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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"> &nbsp;<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> &nbsp;</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></td>
                <td style="text-align:right;">9/22/2022&nbsp;<br />4:52:15 PM&nbsp;</td>
            </tr>
​
    <tr>
        <td style="text-align:center">&nbsp;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">&nbsp;&nbsp;Overdraft Protection LOC</td>
    </tr>
​
    <tr style="background-color:lightyellow;border:1px solid black">
        <td style="text-align:left">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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>
           <td></td>
​
    </tr>
        </tbody>
</table>
​
  <p> &nbsp;</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 style="text-align:right">9/22/2022&nbsp;<br />4:52:15 PM&nbsp;</td>
    </tr>
​
    <tr>
        <td style="text-align:center">&nbsp;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">&nbsp;&nbsp;Credit Card VISA</td>
    </tr>
​
    <tr style="background-color:lightgreen">
        <td style="text-align:center">&nbsp; </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">&nbsp;&nbsp;Credit Card VISA</td>
    </tr>
​
    <tr>
        <td style="text-align:center">&nbsp; </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">&nbsp;&nbsp;Credit Card VISA</td>
    </tr>
​
    <tr style="background-color:lightyellow;border:1px solid black">
        <td style="text-align:left">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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>
           <td></td>
​
    </tr>
        </tbody>
</table>
​
</div>
​
</div>
​
    <script type="text/javascript">
        var urlStr = document.URL;
        var n = urlStr.indexOf("?");
        var urlParam = urlStr.slice(n);
        var rFromDate = getParameterByName('from_date'); // d2
        var rToDate = getParameterByName('to_date'); // d3
        if (rFromDate === null) {
            document.getElementById('qselect').style.display = "block";
            document.getElementById('qresults').style.display = "none";
        } else {
            document.getElementById('qselect').style.display = "none";
            document.getElementById('qresults').style.display = "block";
        }
            
​
    </script>
<p> &nbsp;</p>
<p> &nbsp;</p>
</body>
</html>
CSSSaved
 
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}
JavaScriptSaved
 
 $(document).ready( function () {
  var table = $('table.display').DataTable({
    dom: 'Bftrip',
    buttons: ['excel', 'csv', 'pdf'],
    paging: false,
    bSort: false
  });
} );
​
$(function () {
        $("#from_date").datepicker({
            autoclose: true,
            todayHighlight: true,
            clearBtn: true,
            startView: 0
        }).datepicker('update', new Date());
    });
    $(function () {
        $("#to_date").datepicker({
            autoclose: true,
            todayHighlight: true,
            clearBtn: true
    }).datepicker('update', new Date());
    });
​
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();
    }
Output 300px

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers