@extends('layouts.'.((Session::get('user')->CurrentRole === 'Firm Admin')?'admin':'filer').'-dashboard')
@section('heading')
Tyler Reconciliation
@stop
@section('content')

<div id="">
    <div class="">
        <div class="contentBlkHead clearfix">
            <span class="notification" id="notification">
                @if(isset($data['error_msg']))
                <span class='error'>{{$data['error_msg']}}</span>
                @endif
                @if(isset($success_msg))
                <span class='success'>{{$success_msg}}</span>
                @endif
            </span>
            <a href="/superadmin/tylerreconfiles" style="margin-bottom: 10px;" id="tylerreconfiles" class="btn btn-custom">View Tyler Reconciliation Files</a>
            <form id="filterByDate" action="" class="form customform ">
                <div class="addFormReport fleft">
                    <p>
                        <label for="from">Statements From:</label>
                        <input type="text" id="from" name="from" value="<br />
<b>Warning</b>:  Undefined variable $params in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>23</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on value of type null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>23</b><br />
">
                        <img src="/images/calender_icon.png" id="from_date" alt="calendar" />
                    </p>
                </div>
                <div class="addFormReport fleft">
                    <p>
                        <label for="to">Statements To:</label>
                        <input type="text" id="to" name="to" value="<br />
<b>Warning</b>:  Undefined variable $params in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>30</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on value of type null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>30</b><br />
">
                        <img src="/images/calender_icon.png" id="to_date" alt="calendar" />
                    </p>
                </div>
                <div class="addFormReport fleft">
                    <p>
                        <label class="">Jurisdiction / Location</label>
                        <select id="location" name="location" class="selectWidth">
                            <option value="">Select All</option>
                            <br />
<b>Warning</b>:  Undefined variable $locations in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>39</b><br />
<br />
<b>Warning</b>:  foreach() argument must be of type array|object, null given in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>39</b><br />
                        </select>
                    </p>
                    <p>
                        <label class="">Envelope Number</label>
                        <input type="text" id="draft" name="draft" value="<br />
<b>Warning</b>:  Undefined variable $params in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>46</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on value of type null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>46</b><br />
">
                    </p>
                    <p>
                        <label class="">Case / Cause Number</label>
                        <input type="text" id="case" name="case" value="<br />
<b>Warning</b>:  Undefined variable $params in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>50</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on value of type null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>50</b><br />
">
                    </p>
                </div>
                <div class="addFormReport fleft">
                    <p>
                        <label class="" for="email">Emails:</label>
                        <input type="text" id="email" name="email" value="<br />
<b>Warning</b>:  Undefined variable $params in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>56</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on value of type null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>56</b><br />
">
                    </p>
                    <div id="filing_msg" class="report_msg">Note: You can filter by a list of emails separated by comma.</div>
                </div>
                <p class="c-align">
                    <input type="submit" id="filter" aria-label="Filter" value="Filter" class="btn btn-bluebg btn-medium">
                    <a href="/superadmin/tylerreconciliation" style="display:table; padding-top: 8px; font-size: 12px;" class="addTmz">Reset To Default</a>
                </p>
            </form>
            <div class="clearfix"></div>

        </div>
        <div class="invoice_statement">
            <h1>Cases included in Tyler Statments but with different amount</h1>
            <table id="filing-list" class="table tablewHeader recentFilingTable my-filing-list" style="margin-top: 20px">

                <thead class="theader theaderTab">
                    <tr>
                        <th><span>Envelope Number</span></th>
                        <th><span>Firm Name</span></th>
                        <th><span>Jurisdiction</span></th>
                        <th><span>Client Reference Number</span></th>
                        <th><span>Case Name</span></th>
                        <th><span>Case Number</span></th>
                        <th><span>Processed Date</span></th>
                        <th><span>Filer</span></th>
                        <th><span>Filer Email</span></th>
                        <th><span>Filing Type</span></th>
                        <th><span>Filing Status</span></th>
                        <th><span>MFR Total Fees</span></th>
                        <th><span>MFR NFRC Total Fees</span></th>
                        <th><span>Tyler Total Fees</span></th>
                    </tr>
                </thead>

                                @if(!is_null($data['different_amounts']) && count($data['different_amounts'])>0)
                @foreach($data['different_amounts'] as $row)
                <tr>
                    <td>{{ $row->envelope_id }}</td>
                    <td> {{ $row->firm_name  }}</td>
                    <td>{{ $row->jurisdiction  }}</td>
                    <td>{{ $row->client_ref_no  }}</td>
                    <td>{{ $row->case_name  }}</td>
                    <td>{{ $row->case_no  }}</td>
                    <td class='server_datetime'>{{ date('Y/d/m H:i:s', strtotime($row->processed_date))  }}</td>
                    <td>{{ $row->filer  }}</td>
                    <td>{{ $row->filer_email  }}</td>
                    <td>{{ $row->filing_type  }}</td>
                    <td>{{ $row->filing_status  }}</td>
                    <td class="td_amount">${{ $row->total_fees  }}</td>
                    <td class="td_amount">${{ $row->nfrc_total_fees  }}</td>
                    <td class="td_amount">${{ $row->tyler_total_fees  }}</td>
                    <br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>114</b><br />
<br />
<b>Warning</b>:  Attempt to read property "total_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>114</b><br />
<br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>115</b><br />
<br />
<b>Warning</b>:  Attempt to read property "nfrc_total_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>115</b><br />
<br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>116</b><br />
<br />
<b>Warning</b>:  Attempt to read property "tyler_total_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>116</b><br />
                </tr>
                @endforeach
                <tfoot class="theader theaderTab no-padd">
                    <tr>
                        <td colspan="11"><span><b>Total:</b> <small>({{count($data['different_amounts'])}} records)</small></span></td>
                        <td class="td_amount"><span><b>${{number_format($total_fees, 2, '.', '');}}</b></span></td>
                        <td class="td_amount"><span><b>${{number_format($total_nfrc_fees, 2, '.', '');}}</b></span></td>
                        <td class="td_amount"><span><b>${{number_format(($total_tyler_fees), 2, '.', '');}}</b></span></td>
                    </tr>
                </tfoot>
                @else
                <tr>
                    <td colspan="14">No results to display</td>
                </tr>
                @endif


            </table>
        </div>

        <div class="invoice_statement">
            <h1>Cases not included in Tyler Statments</h1>
            <table id="filing-list" class="table tablewHeader recentFilingTable my-filing-list" style="margin-top: 20px">

                <thead class="theader theaderTab">
                    <tr>
                        <th><span>Envelope Number</span></th>
                        <th><span>Firm Name</span></th>
                        <th><span>Jurisdiction</span></th>
                        <th><span>Client Reference Number</span></th>
                        <th><span>Case Name</span></th>
                        <th><span>Case Number</span></th>
                        <th><span>Processed Date</span></th>
                        <th><span>Filer</span></th>
                        <th><span>Filer Email</span></th>
                        <th><span>Filing Type</span></th>
                        <th><span>Filing Status</span></th>
                        <th><span>Total Fees</span></th>
                        <th><span>NFRC Total Fees</span></th>
                        <th><span>Provider Tax Fees</span></th>
                        <th><span>Provider Service Fees</span></th>
                        <th><span>Court Service Fees</span></th>
                        <th><span>Service Tax Fees</span></th>
                        <th><span>Filing Service Fees</span></th>
                        <th><span>Court Filing Fees</span></th>
                        <th><span>Court Case Fees</span></th>
                        <th><span>Convenience Fees</span></th>
                    </tr>
                </thead>

                                @if(!is_null($data['not_in_tyler']) && count($data['not_in_tyler'])>0)
                @foreach($data['not_in_tyler'] as $row)
                <tr>
                    <td>{{ $row->envelope_id }}</td>
                    <td> {{ $row->firm_name  }}</td>
                    <td>{{ $row->jurisdiction  }}</td>
                    <td>{{ $row->client_ref_no  }}</td>
                    <td>{{ $row->case_name  }}</td>
                    <td>{{ $row->case_no  }}</td>
                    <td class='server_datetime'>{{ date('Y/d/m H:i:s', strtotime($row->processed_date))  }}</td>
                    <td>{{ $row->filer  }}</td>
                    <td>{{ $row->filer_email  }}</td>
                    <td>{{ $row->filing_type  }}</td>
                    <td>{{ $row->filing_status  }}</td>
                    <td class="td_amount">${{ $row->total_fees  }}</td>
                    <td class="td_amount">${{ $row->nfrc_total_fees  }}</td>
                    <td class="td_amount">${{ $row->provider_tax_fees  }}</td>
                    <td class="td_amount">${{ $row->provider_service_fees  }}</td>
                    <td class="td_amount">${{ $row->court_service_fees  }}</td>
                    <td class="td_amount">${{ $row->service_tax_fees  }}</td>
                    <td class="td_amount">${{ $row->filing_service_fees  }}</td>
                    <td class="td_amount">${{ $row->court_filing_fees  }}</td>
                    <td class="td_amount">${{ $row->court_case_fees  }}</td>
                    <td class="td_amount">${{ $row->convenience_fees  }}</td>
                    <br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>205</b><br />
<br />
<b>Warning</b>:  Attempt to read property "total_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>205</b><br />
<br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>206</b><br />
<br />
<b>Warning</b>:  Attempt to read property "nfrc_total_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>206</b><br />
<br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>207</b><br />
<br />
<b>Warning</b>:  Attempt to read property "provider_tax_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>207</b><br />
<br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>208</b><br />
<br />
<b>Warning</b>:  Attempt to read property "provider_service_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>208</b><br />
<br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>209</b><br />
<br />
<b>Warning</b>:  Attempt to read property "court_service_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>209</b><br />
<br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>210</b><br />
<br />
<b>Warning</b>:  Attempt to read property "service_tax_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>210</b><br />
<br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>211</b><br />
<br />
<b>Warning</b>:  Attempt to read property "filing_service_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>211</b><br />
<br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>212</b><br />
<br />
<b>Warning</b>:  Attempt to read property "court_filing_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>212</b><br />
<br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>213</b><br />
<br />
<b>Warning</b>:  Attempt to read property "court_case_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>213</b><br />
<br />
<b>Warning</b>:  Undefined variable $row in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>214</b><br />
<br />
<b>Warning</b>:  Attempt to read property "convenience_fees" on null in <b>/home/dario/Servidor/CodingIt/MyFileRunner/App/app/views/superAdmin/tylerreconciliation.blade.php</b> on line <b>214</b><br />
                </tr>
                @endforeach
                <tfoot class="theader theaderTab no-padd">
                    <tr>
                        <td colspan="11"><span><b>Total:</b> <small>({{count($data['not_in_tyler'])}} records)</small></span></td>
                        <td class="td_amount"><span><b>${{number_format($total_fees, 2, '.', '');}}</b></span></td>
                        <td class="td_amount"><span><b>${{number_format($total_nfrc_total_fees, 2, '.', '');}}</b></span></td>
                        <td class="td_amount"><span><b>${{number_format($total_provider_tax_fees, 2, '.', '');}}</b></span></td>
                        <td class="td_amount"><span><b>${{number_format($total_provider_service_fees, 2, '.', '');}}</b></span></td>
                        <td class="td_amount"><span><b>${{number_format($total_court_service_fees, 2, '.', '');}}</b></span></td>
                        <td class="td_amount"><span><b>${{number_format($total_service_tax_fees, 2, '.', '');}}</b></span></td>
                        <td class="td_amount"><span><b>${{number_format($total_filing_service_fees, 2, '.', '');}}</b></span></td>
                        <td class="td_amount"><span><b>${{number_format($total_court_filing_fees, 2, '.', '');}}</b></span></td>
                        <td class="td_amount"><span><b>${{number_format($total_court_case_fees, 2, '.', '');}}</b></span></td>
                        <td class="td_amount"><span><b>${{number_format($total_convenience_fees, 2, '.', '');}}</b></span></td>
                    </tr>
                </tfoot>
                @else
                <tr>
                    <td colspan="20">No results to display</td>
                </tr>
                @endif


            </table>
        </div>
    </div>
</div>
<style>
    #filterByDate .addFormReport {
        width: 40%;
    }

    .invoice_statement {
        overflow-x: scroll;
        padding-top: 15px;
    }

    .table.tablewHeader {
        font-size: 10px;
    }

    .table th,
    .table td.td_amount {
        text-align: center;
        line-height: 1.5;
    }
</style>
@stop
@section('scripts_bottom')
<script src="/js/jquery.quicksearch.js"></script>
<script type="text/javascript" src="/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="/js/jquery-ui-1.10.3.custom.min.js"></script>
<script src="/js/jquery.validate.min.js"></script>
<script type="text/javascript">
    var is_firm = 2;
    var checked = "";


    $(document).ready(function() {


        $(function() {
            $("#from,#to").datepicker({
                dateFormat: 'mm-dd-yy'
            });
        });

        // $(".export").on('click', function(event) {
        //     var start_date = dateFormat($('#start_date').val());
        //     var end_date = dateFormat($('#end_date').val());
        //     var rep_name = $('#rep_name').val();
        //     var tmz = new Date();
        //     tmz = tmz.getTimezoneOffset();
        //     //			var firm = '';
        //     var url = MFR.siteConfig.base_url + '/superadmin/vfareportexcel?' +
        //         'start_date=' + start_date + '&end_date=' + end_date +
        //         '&rep_name=' + rep_name + '&tmz=' + tmz;
        //     // if ($('.report table').length > 0) {
        //     window.open(url, '_blank');
        //     // } else {
        //     //     alert('No data to export.');
        //     // }

        //     // IF CSV, don't do event.preventDefault() or return false
        //     // We actually need this to be a typical hyperlink
        // });

        function dateFormat(date) {
            if (date.indexOf('/') !== -1) {
                var splits = date.split('/');
                return splits[2] + '-' + splits[0] + '-' + splits[1];
            } else {
                return date;
            }
        }

    });
</script>
@stop