@extends('layouts.app')
@section('title', 'Dashboard')
@section('content')
<style>
th
{
    font-size:13px !important;
}
td
{
    font-size:13px !important;
}
</style>
<div id="dashboarddiv" class="m-0 p-0">
    <div class="container-fluid mt-1 pt-2">
        <div class="row p-0 m-0">
            <div class="col-lg-6 col-sm-12 col-xl-6 col-md-6">
                <h5>Dashboard</h5>
            </div>
            <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                <select id="client_id" class="form-select form-control float-end forminputfields" onchange="get_lenders(this.value);">
                    <option value="">Filter By Client</option>
                    @foreach($clientlist as $clients)
                    <option value="{{$clients->id}}" Selected>{{$clients->client_name}}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                <select id="lender_id" class="form-select form-control float-end forminputfields" onchange="filter_dashboard(this.value);">
                    <option value="">Filter By Lender</option>

                </select>
            </div>
        </div>
        <div class="row pr-2 pl-2 pt-2 pb-0 mt-1">
            <div class="col-lg-6 col-md-6 col-xl-6 col-sm-12">
                <div class="card dashboardcard">
                    <div class="card-body">
                        <h5 class="dashboardheadings"> Portfolio Summary</h5>
                        <div class="row py-2" style="margin-left:0px !important;">
                            <div class="col-lg-4 col-sm-6 col-xl-4 col-md-4 dashboardtotalloanheadingdiv">
                                <div class="row">
                                    <div class="col-lg-3 col-md-3 col-xl-3 col-sm-12 m-auto">
                                        <img class="dashboardicon" src="{{asset('app-assets/assets/images/loan.svg')}}" alt="">
                                    </div>
                                    {{-- {{dd($statewiseescrowloans)}} --}}
                                    <div class="col-lg-9 col-md-9 col-xl-9 col-sm-12">
                                        <span class="dashboardtotalloanheading">Total Loans</span><br>
                                        <span><strong>{{($statewisenonescrowloans->count()) + ($statewiseescrowloans->count())}}</strong></span>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-4 col-sm-4 col-xl-4 col-md-4 text-center">
                                <span class="dashboardotherlabels">Escrow</span><br>
                                <span><strong>{{($statewiseescrowloans->count())}}</strong></span>
                            </div>
                            <div class="col-lg-4 col-sm-6 col-xl-4 col-md-4 text-center">
                                <span class="dashboardotherlabels">Non Escrow</span><br>
                                <span><strong>{{($statewisenonescrowloans->count())}}</strong></span>
                            </div>
                        </div>
                        <div class="row pt-2" style="margin-left:0px !important;">
                            <div class="col-lg-4 col-sm-6 col-xl-4 col-md-4 dashboardtotallienheadingdiv">
                                <div class="row">
                                    <div class="col-lg-3 col-md-3 col-xl-3 col-sm-12 m-auto">
                                        <img class="dashboardicon" src="{{asset('app-assets/assets/images/money-bag.svg')}}" alt="">
                                    </div>
                                    <div class="col-lg-9 col-md-9 col-xl-9 col-sm-12">
                                        <span class="dashboardtotallienheading">Total Liens</span><br>
                                        <span><strong>{{($totalliensnonescrow) + ($totalliensescrow)}}</strong></span>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-4 col-sm-6 col-xl-4 col-md-4 text-center">
                                <span class="dashboardotherlabels">Escrow</span><br>
                                <span><strong>{{$totalliensescrow}}</strong></span>
                            </div>
                            <div class="col-lg-4 col-sm-6 col-xl-4 col-md-4 text-center">
                                <span class="dashboardotherlabels">Non Escrow</span><br>
                                <span><strong>{{$totalliensnonescrow}}</strong></span>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-lg-6 col-md-6 col-xl-6 col-sm-12">
                <div class="card dashboardcard">
                    <div class="card-body">
                        <h5 class="dashboardheadings"> New Orders </h5>
                        <div class="row py-2" style="margin-left:0px !important;">
                            <div class="col-lg-4 col-sm-6 col-xl-4 col-md-4 dashboardtotalmtdheadingdiv">
                                <div class="row">
                                    <div class="col-lg-3 col-md-3 col-xl-3 col-sm-12 m-auto">
                                        <img class="dashboardicon" src="{{asset('app-assets/assets/images/calendar.svg')}}" alt="">
                                    </div>
                                    <div class="col-lg-9 col-md-9 col-xl-9 col-sm-12">
                                        <span class="dashboardtotalmtdheading">Total MTD</span><br>
                                        <span><strong>{{$mtdnonescrow->count() + $mtdescrow->count()}}</strong></span>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-4 col-sm-6 col-xl-4 col-md-4 text-center">
                                <span class="dashboardotherlabels">Escrow</span><br>
                                <span><strong>{{$mtdescrow->count()}}</strong></span>
                            </div>
                            <div class="col-lg-4 col-sm-6 col-xl-4 col-md-4 text-center">
                                <span class="dashboardotherlabels">Non Escrow</span><br>
                                <span><strong>{{$mtdnonescrow->count()}}</strong></span>
                            </div>
                        </div>
                        <div class="row pt-2" style="margin-left:0px !important;">
                            <div class="col-lg-4 col-sm-6 col-xl-4 col-md-4 dashboardtotalytdheadingdiv">
                                <div class="row">
                                    <div class="col-lg-3 col-md-3 col-xl-3 col-sm-12 m-auto">
                                        <img class="dashboardicon" src="{{asset('app-assets/assets/images/due-date.svg')}}" alt="">
                                    </div>
                                    <div class="col-lg-9 col-md-9 col-xl-9 col-sm-12">
                                        <span class="dashboardtotalytdheading">Total YTD</span><br>
                                        <span><strong>{{$ytdnonescrow->count() + $ytdescrow->count()}}</strong></span>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-4 col-sm-6 col-xl-4 col-md-4 text-center">
                                <span class="dashboardotherlabels">Escrow</span><br>
                                <span><strong>{{$ytdescrow->count()}}</strong></span>
                            </div>
                            <div class="col-lg-4 col-sm-6 col-xl-4 col-md-4 text-center">
                                <span class="dashboardotherlabels">Non Escrow</span><br>
                                <span><strong>{{$ytdnonescrow->count()}}</strong></span>
                            </div>
                            {{-- <div class="col-lg-3 col-sm-6 col-xl-3 col-md-3">
                                <span class="dashboardotherlabels">Total</span><br>
                                <span><strong>70</strong></span>
                            </div> --}}
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="row pr-2 pl-2 pt-0 mt-3">
            <div class="col-lg-12 col-md-12 col-xl-12 col-sm-12">
                <div class="card dashboardcard">
                    <div class="card-body pt-0">
                        <div class="row py-2">
                            <div class="col-lg-12 col-md-12 col-xl-12 col-sm-12">
                                <ul class="nav nav-tabs mb-3" id="pills-tab" role="tablist">
                                    <li class="nav-item" role="presentation">
                                        <button class="nav-link active" id="pills-home-tab" data-bs-toggle="pill" data-bs-target="#setup" type="button" role="tab" aria-controls="setup" aria-selected="true"><strong>Setup</strong></button>
                                    </li>
                                    <li class="nav-item" role="presentation">
                                        <button class="nav-link" id="pills-profile-tab" data-bs-toggle="pill" data-bs-target="#csrresponse" type="button" role="tab" aria-controls="csrresponse" aria-selected="false"><strong>CSR Response</strong></button>
                                    </li>
                                    <li class="nav-item" role="presentation">
                                        <button class="nav-link" id="pills-contact-tab" data-bs-toggle="pill" data-bs-target="#escorwreporting" type="button" role="tab" aria-controls="escorwreporting" aria-selected="false"><strong>Escrow Reporting</strong></button>
                                    </li>
                                    <li class="nav-item" role="presentation">
                                        <button class="nav-link" id="pills-non-escrow-tab" data-bs-toggle="pill" data-bs-target="#nonescorwreporting" type="button" role="tab" aria-controls="nonescorwreporting" aria-selected="false"><strong>Non Escrow Reporting</strong></button>
                                    </li>
                                </ul>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-lg-12 col-md-12 col-xl-12 col-sm-12">
                                <div class="tab-content">
                                    <div class="tab-content" id="pills-tabContent">
                                        <div class="tab-pane fade show active" id="setup" role="tabpanel" aria-labelledby="pills-home-tab">
                                            <div class="row">
                                                <div class="col-lg-12 col-md-12 col-xl-12 col-sm-12">
                                                    <table id="datatable" class="table table-bordered mb-0"  >
                                                        <thead>
                                                            <tr>
                                                                <th>State</th>
                                                                <th>Escrow</th>
                                                                <th>Non-Escrow</th>
                                                                <th>Total</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            @if(isset($tablearray))
                                                            @foreach ($tablearray as $statesdata)
                                                            {{-- {{dd($statesdata['state']['state_name'])}} --}}
                                                                <tr>
                                                                    <td style="cursor:pointer;">{{$statesdata['state']['state_name']}}</td>
                                                                    <td>{{$statesdata['nonescrowcount']}}</td>
                                                                    <td>{{$statesdata['escrowcount']}}</td>
                                                                    <td>{{$statesdata['nonescrowcount'] + $statesdata['escrowcount']}}</td>
                                                                </tr>
                                                                @endforeach
                                                            @endif
                                                        </tbody>
                                                    </table>
                                                </div>
                                                <div class="col-lg-6 col-md-6 col-xl-6 col-sm-12">
                                                </div>
                                            </div>
                                        </div>
                                        <div class="tab-pane fade" id="csrresponse" role="tabpanel" aria-labelledby="pills-profile-tab">
                                            <div class="row">
                                                <div class="col-lg-6 col-md-6 col-xl-6 col-sm-12">
                                                    <table class="table" id="csrtable1">
                                                        <thead>
                                                            <tr>
                                                                <th>State</th>
                                                                <th>Escrow</th>
                                                                <th>Non-Escrow</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <tr>
                                                                <td>Alabama</td>
                                                                <td>40</td>
                                                                <td>30</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Alaska</td>
                                                                <td>40</td>
                                                                <td>40</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Arizona</td>
                                                                <td>60</td>
                                                                <td>50</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Arkansas</td>
                                                                <td>50</td>
                                                                <td>60</td>
                                                            </tr>
                                                            <tr>
                                                                <td>California</td>
                                                                <td>80</td>
                                                                <td>50</td>
                                                            </tr>
                                                        </tbody>
                                                    </table>
                                                </div>
                                                <div class="col-lg-6 col-md-6 col-xl-6 col-sm-12">
                                                    <table class="table" id="csrtable2">
                                                        <thead>
                                                            <tr>
                                                                <th>State</th>
                                                                <th>Escrow</th>
                                                                <th>Non-Escrow</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <tr>
                                                                <td>Colorado</td>
                                                                <td>40</td>
                                                                <td>30</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Connecticut</td>
                                                                <td>40</td>
                                                                <td>40</td>
                                                            </tr>
                                                            <tr>
                                                                <td>New Hampshire</td>
                                                                <td>60</td>
                                                                <td>50</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Pennsylvania</td>
                                                                <td>50</td>
                                                                <td>60</td>
                                                            </tr>
                                                            <tr>
                                                                <td>South Carolina</td>
                                                                <td>80</td>
                                                                <td>50</td>
                                                            </tr>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="tab-pane fade" id="escorwreporting" role="tabpanel" aria-labelledby="pills-contact-tab">
                                            <div class="row">
                                                <div class="col-lg-6 col-md-6 col-xl-6 col-sm-12">
                                                    <table class="table" id="escrowtable1">
                                                        <thead>
                                                            <tr>
                                                                <th>State</th>
                                                                <th>Escrow</th>
                                                                <th>Non-Escrow</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <tr>
                                                                <td>Alabama</td>
                                                                <td>40</td>
                                                                <td>30</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Alaska</td>
                                                                <td>40</td>
                                                                <td>40</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Arizona</td>
                                                                <td>60</td>
                                                                <td>50</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Arkansas</td>
                                                                <td>50</td>
                                                                <td>60</td>
                                                            </tr>
                                                            <tr>
                                                                <td>California</td>
                                                                <td>80</td>
                                                                <td>50</td>
                                                            </tr>
                                                        </tbody>
                                                    </table>
                                                </div>
                                                <div class="col-lg-6 col-md-6 col-xl-6 col-sm-12">
                                                    <table class="table" id="escrowtable2">
                                                        <thead>
                                                            <tr>
                                                                <th>State</th>
                                                                <th>Escrow</th>
                                                                <th>Non-Escrow</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <tr>
                                                                <td>Colorado</td>
                                                                <td>40</td>
                                                                <td>30</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Connecticut</td>
                                                                <td>40</td>
                                                                <td>40</td>
                                                            </tr>
                                                            <tr>
                                                                <td>New Hampshire</td>
                                                                <td>60</td>
                                                                <td>50</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Pennsylvania</td>
                                                                <td>50</td>
                                                                <td>60</td>
                                                            </tr>
                                                            <tr>
                                                                <td>South Carolina</td>
                                                                <td>80</td>
                                                                <td>50</td>
                                                            </tr>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="tab-pane fade" id="nonescorwreporting" role="tabpanel" aria-labelledby="pills-non-escrow-tab">
                                            <div class="row">
                                                <div class="col-lg-6 col-md-6 col-xl-6 col-sm-12">
                                                    <table class="table" id="nonescrowtable1">
                                                        <thead>
                                                            <tr>
                                                                <th>State</th>
                                                                <th>Escrow</th>
                                                                <th>Non-Escrow</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <tr>
                                                                <td>Alabama</td>
                                                                <td>40</td>
                                                                <td>30</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Alaska</td>
                                                                <td>40</td>
                                                                <td>40</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Arizona</td>
                                                                <td>60</td>
                                                                <td>50</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Arkansas</td>
                                                                <td>50</td>
                                                                <td>60</td>
                                                            </tr>
                                                            <tr>
                                                                <td>California</td>
                                                                <td>80</td>
                                                                <td>50</td>
                                                            </tr>
                                                        </tbody>
                                                    </table>
                                                </div>
                                                <div class="col-lg-6 col-md-6 col-xl-6 col-sm-12">
                                                    <table class="table" id="nonescrowtable2">
                                                        <thead>
                                                            <tr>
                                                                <th>State</th>
                                                                <th>Escrow</th>
                                                                <th>Non-Escrow</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <tr>
                                                                <td>Colorado</td>
                                                                <td>40</td>
                                                                <td>30</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Connecticut</td>
                                                                <td>40</td>
                                                                <td>40</td>
                                                            </tr>
                                                            <tr>
                                                                <td>New Hampshire</td>
                                                                <td>60</td>
                                                                <td>50</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Pennsylvania</td>
                                                                <td>50</td>
                                                                <td>60</td>
                                                            </tr>
                                                            <tr>
                                                                <td>South Carolina</td>
                                                                <td>80</td>
                                                                <td>50</td>
                                                            </tr>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<script>
    $(document).ready(function () {
        $('#datatable').DataTable({});
    });
    function filter_dashboard(lenderid)
    {
        var clientid = $("#client_id").val();
        $.ajax({
                type: "POST",
                url: "{{route('clientLenderDashboard')}}",
                data: { "_token": "{{ csrf_token() }}",
                        "lenderid":lenderid,
                        "clientid":clientid
                    },
                success: function(html)
                {
                    $("#dashboarddiv").html(html);
                    $('#datatable').DataTable({});
                }
            });
    }
    function get_lenders(clientid)
    {
        $.ajax({
                type: "POST",
                url: "{{route('getlenders')}}",
                data: { "_token": "{{ csrf_token() }}",
                        "clientid":clientid
                    },
                success: function(html)
                {
                    $("#lender_id").html(html);
                }
            });
    }
    function get_statesloans(stateid)
    {
        location.href = "/loandetail/"+stateid;
    }
</script>
@endsection