@extends('layouts.app')
@section('title', 'Loan Details Report')
@section('content')
<style>
    thead {
        background-color: #7680ff !important;
        color: #fff !important;
    }
    th {
        color:#fff !important;
    }
</style>
<div class="m-0 p-0">
    <div class="container-fluid">
        <x-reporttabs/>
        <div id="dashboarddiv" class="p-0 m-0">
            <div class="row pr-2 pl-2 pt-0 mt-1">
                <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 p-0 m-0" style="justify-content:center;">
                                <input type="hidden" class="filter_section_date" value="0">
                                <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                                    <select id="clientsdrop" class="form-control float-right fnSize">
                                        <option value="">Filter By Client</option>
                                        @foreach($clientDt as $client_details)
                                            <option value="{{ $client_details->id }}" Selected>{{ $client_details->client_name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                                    <select id="lendersdrop" class="form-control float-right fnSize">
                                        @if($lendersDt != NULL)
                                            <option value="">Filter By Lender</option>
                                            <option value="All" >All Lenders</option>
                                            @foreach($lendersDt as $lenders_details)
                                                <option value="{{ $lenders_details->id }}" Selected>{{ $lenders_details->lender_name }}</option>
                                            @endforeach
                                        @else
                                            <option value="">Select Client First</option>
                                        @endif
                                    </select>
                                </div>
                                <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                                    <select id="servicedrop" class="form-control float-right fnSize">
                                        <option value="">Filter By Service Type</option>
                                        <option value="1" >B - Non Escrow</option>
                                        <option value="2" >C -  Escrow</option>
                                        <option value="3" >B & C</option>
                                    </select>
                                </div>
                                <div class="col-lg-2 col-sm-12 col-xl-2 col-md-2 my-auto">
                                    <div class="custom-control custom-switch mb-2 mx-2">
                                        <input type="hidden" id="switchvalue" value="0">
                                        <input type="checkbox"  class="custom-control-input" id="customSwitch" >
                                        <label class="custom-control-label" id="customSwitchlabel" for="customSwitch">Advance Search</label>
                                    </div>
                                </div>
                            </div>
                            <div class="advancedDt mt-2">
                                <div class="row" style="justify-content:center;">
                                    <div class="col-md-3 col-lg-3 text-right advance_search d-none"> 
                                        <input required type="text" id="datefilter" name="datefilter" class="form-control datepick datefilter fnSize" onkeydown="return false" style="height:35px;" value="">
                                    </div>
                                    <div class="col-md-3 col-lg-3 text-right advance_search d-none">
                                        <select id="portfoliotype" class="form-control float-right fnSize">
                                            <option value="">Filter By Portfolio Type</option>
                                            @foreach($portfolio_type as $portfolio_details)
                                                <option value="{{ $portfolio_details->id }}" Selected>{{ $portfolio_details->portfolio_type_name }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="row serviceTypeSection d-none" style="justify-content:center;">
                                <div class="row py-3">
                                    <div class="col-lg-12 col-md-12 col-xl-12 col-sm-12">
                                        <table align="center" class="nonescrow_table_status d-none">
                                            <tr>
                                                <td>
                                                    <button id="statusAll" class="btn btn-outline-primary nonescrowtab taxstatustabs tabbtn" value="All">All</button>
                                                    <button id="status3" class="btn btn-outline-primary nonescrowtab taxstatustabs tabbtn" value="3">Paid</button>
                                                    <button id="status2" class="btn nonescrowtab btn-outline-primary taxstatustabs tabbtn" value="2">Delinquent In Process</button>
                                                    <button id="status5" class="btn nonescrowtab btn-outline-primary taxstatustabs tabbtn" value="5">Delinquent</button>
                                                    <button id="status6" class="btn nonescrowtab btn-outline-primary taxstatustabs tabbtn" value="6">Tax Sale</button>
                                                    <button id="status7" class="btn nonescrowtab btn-outline-primary taxstatustabs tabbtn" value="7">Redemption</button>
                                                </td>
                                            </tr>
                                        </table>
                                        <table align="center" class="escrow_table_status d-none">
                                            <tr>
                                                <td>
                                                    <button id="status1All" class="btn taxstatustabs escrowtab btn-outline-primary" value="All">All</button>
                                                    <button id="status1Inprocess" class="btn taxstatustabs escrowtab btn-outline-primary" value="Inprocess">Inprocess</button>
                                                    @foreach($ztpTaxStatus as $ztp_tax_status)
                                                        <button id="status1{{ $ztp_tax_status->id }}" class="btn taxstatustabs escrowtab btn-outline-primary me-1"  value="{{ $ztp_tax_status->id }}">{{ $ztp_tax_status->tax_status }}</button>
                                                    @endforeach
                                                </td>
                                            </tr>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            <div class="row">
                                <div class="col-lg-12 col-md-12 col-xl-12 col-sm-12">
                                    <table class="table" id="loan_details_table">
                                        <thead>
                                            <tr>
                                                <th>Loan No.</th>
                                                <th>Lender</th>
                                                <th>Portfolio</th>
                                                <th>Branch</th>
                                                <th>Borrower Name</th>
                                                <th>Property Address</th>
                                                <th>City</th>
                                                <th>State</th>
                                                <th>Zip</th>
                                                <th>County</th>
                                                <th>Service</th>
                                                <th>Parcel No</th>
                                                <th>Tax Status</th>
                                                <!-- <th>Parcel Count</th> -->
                                                <th>Created On</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<style>
    div.dt-buttons {
        float: right;
        margin-top: -1px;
        margin-left: 11px;
    }
    .tabbtn {
        width:180px !important;
    }
    .btn-primary {
        background-color: #0b5ed7 !important;
        border-color: #0a58ca !important;
    }
    .fnSize {
        font-size: 11px !important;
        height: 30px !important;
    }
</style>
<script src="{{asset('/plugins/daterangepicker/daterangepicker.js')}}"></script>
<script>
    $(document).ready(function() {
		$(".odtabs").not("#tab6").addClass('btn-outline-secondary');
		$("#tab6").addClass('btn-secondary');

        $.ajaxSetup({
            headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf_token"]').attr('content')
            }
        });

        var loanDetailTb = $('#loan_details_table').DataTable({
            processing: true,
            serverSide: true,
            ajax: {
                url: "{{ route('fetchloandetailTb') }}",
            },
            dom: 'lBfrtip',
            order: [],
            buttons:['excel'],
            language: {
                "processing": "Loading Loan Details"
            },
            "lengthMenu": [10,50,100,200,500,1000,2000,5000],
            columns: [
                {
                    data: 'loan_no',
                    name: 'loan_no',
                    defaultContent: "--"
                },
                {
                    data: 'lender_name',
                    name: 'ztp_lenders.lender_name',
                    defaultContent: "--"
                },
                {
                    data: 'portfolio_id',
                    name: 'ztp_newloan_setup.portfolio_id',
                    defaultContent: "--"
                },
                {
                    data: 'branch',
                    name: 'ztp_portfolio_loanlist.branch_code',
                    defaultContent: "--"
                },
                {
                    data: 'borrower_name',
                    name: 'borrower_name',
                    defaultContent: "--"
                },
                {
                    data: 'property_address',
                    name: 'property_address',
                    defaultContent: "--"
                },
                {
                    data: 'city',
                    name: 'city',
                    defaultContent: "--"
                },
                {
                    data: 'short_code',
                    name: 'state.short_code',
                    defaultContent: "--"
                },
                {
                    data: 'zip',
                    name: 'zip',
                    defaultContent: "--"
                },
                {
                    data: 'county_name',
                    name: 'county.county_name',
                    defaultContent: "--"
                },
                {
                    data: 'service_type',
                    name: 'ztp_portfolio_loanlist.service_type',
                    defaultContent: "--"
                },
                {
                    data: 'parcel_no',
                    name: 'parcel_no',
                    defaultContent: "--"
                },
                {
                    data: 'tax_status',
                    name: 'ztp_tax_status.tax_status',
                    defaultContent: "--"
                },
                // {
                //     data: 'count_of_liens',
                //     name: 'count_of_liens',
                //     defaultContent: "--"
                // },
                {
                    data: 'added_datetime',
                    name: 'ztp_portfolio_loanlist.addeddatetime',
                    defaultContent: "--"
                },
            ],
        });

        $('#clientsdrop').on('change', function(){
            var clientid = $(this).val(); 
            if (clientid) {
                $.ajax({
                    url: '/get_lenders/' + clientid,
                    type: "GET",
                    dataType: "json",
                    success: function(data) {
                        $('#lendersdrop').empty();
                        if(data[0] == undefined) {
                            $('#lendersdrop').html('<option value="">No Lenders Associated with Client</option>');
                            loanDetailTb.draw();
                        } else {
                            if (data[0].length == 0)
                            {
                                $('#lendersdrop').append('<option value="">No Lenders Associated with Client</option>');
                                loanDetailTb.draw();
                            } else {
                                $('#lendersdrop').append('<option value="">Filter By Lender</option>');
                                $('#lendersdrop').append('<option value="All">All Lenders</option>');
                                $.each(data[0], function(key, value) {
                                    $('#lendersdrop').append(
                                        '<option value="' + value['id'] + '">' + value[
                                            'lender_name'] + '</option>');
                                });
                                loanDetailTb.draw();
                            }
                        }
                    }
                });
            } else {
                $.ajax({
                    url: '/get_lenders/' + clientid,
                    type: "GET",
                    dataType: "json",
                    success: function(data) {
                        $('#lendersdrop').html('<option value="">Select Lender first</option>');
                        loanDetailTb.draw();
                    }
                });
            }
        });

        $('#lendersdrop').on('change', function() {
            var lenderid = $(this).val(); 
            $.ajax({
                url: '/update_lenderDt/',
                type: "GET",
                data: {"_token":"{{ csrf_token() }}","lenderId":lenderid},
                success: function() {
                    loanDetailTb.draw();
                }
            });
        });

        $('#servicedrop').on('change', function() {
            var servicetypeid = $(this).val(); 
            $.ajax({
                url: '/update_serviceTypeDt/',
                type: "GET",
                data: {"_token":"{{ csrf_token() }}","servicetypeId":servicetypeid},
                success: function() {
                    if(servicetypeid == '' || servicetypeid == undefined) {
                        $('.serviceTypeSection').addClass('d-none');
                    } else {
                        $('.serviceTypeSection').removeClass('d-none');
                        if(servicetypeid == 1) {
                            $('.nonescrow_table_status').removeClass('d-none');
                            $('.escrow_table_status').addClass('d-none');
                            $('.nonescrowtab').removeClass('btn-primary');
                            $('.nonescrowtab').addClass('btn-outline-primary');
                            $('#statusAll').removeClass('btn-outline-primary');
                            $('#statusAll').addClass('btn-primary');
                        } else {
                            $('.nonescrow_table_status').addClass('d-none');
                            $('.escrow_table_status').removeClass('d-none');
                            $('.escrowtab').removeClass('btn-primary');
                            $('.escrowtab').addClass('btn-outline-primary');
                            $('#status1All').removeClass('btn-outline-primary');
                            $('#status1All').addClass('btn-primary');
                        }
                    }
                    loanDetailTb.draw();
                }
            });
        });

        $('#customSwitch').on('click', function() {
            var vl = $('#switchvalue').val();
            $(".ajaxloader").show();
            if(vl == 0) {
                $('#switchvalue').val(1);
                var checkedId = 1;
                $.ajax({
                    url: '/update_switchVl/',
                    type: "GET",
                    data: {"_token":"{{ csrf_token() }}","checkedId":checkedId},
                    success: function() {
                        $('#customSwitch').attr('checked', true);
                        $('.advance_search').removeClass('d-none');
                        $('#datefilter').prop('selectedIndex', 0);
                        $('#portfoliotype').prop('selectedIndex', 0);
                        loanDetailTb.draw();
                        $(".ajaxloader").hide();
                    }
                });
                $('.datepick').daterangepicker({
                    singleDatePicker: false,
                    showDropdowns: true,
                    startDate: '01/01/2023',
                    endDate: moment(),
                    ranges: {
                        'Last Week': [moment().subtract(1, 'weeks').startOf('isoWeek'), moment().subtract(1, 'weeks').endOf('isoWeek')],
                        'Current Week': [moment().startOf('isoWeek'), moment()],
                        'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')], // Working Fine
                        'Current Month': [moment().startOf('month'), moment().endOf('month')], // Working Fine
                        'Yearly': [moment().startOf('year'), moment().endOf('year')],
                    }
                });
            } else {
                $('#switchvalue').val(0);
                var checkedId = 0;
                $.ajax({
                    url: '/update_switchVl/',
                    type: "GET",
                    data: {"_token":"{{ csrf_token() }}","checkedId":checkedId},
                    success: function() {
                        $('#customSwitch').attr('checked', false);
                        $('.advance_search').addClass('d-none');
                        $('#datefilter').prop('selectedIndex', 0);
                        $('#portfoliotype').prop('selectedIndex', 0);
                        loanDetailTb.draw();
                        $(".ajaxloader").hide();
                    }
                });
            }
            $('.filter_section_date').val(0);
        });

        var filterSec = $('.filter_section_date').val();
        if(filterSec == 0) {
            $('.datepick').daterangepicker({
                singleDatePicker: false,
                showDropdowns: true,
                startDate: moment().subtract(1, 'weeks').startOf('isoWeek'),
                endDate: moment().subtract(1, 'weeks').endOf('isoWeek'),
                ranges: {
                    'Last Week': [moment().subtract(1, 'weeks').startOf('isoWeek'), moment().subtract(1, 'weeks').endOf('isoWeek')],
                    'Current Week': [moment().startOf('isoWeek'), moment()],
                    'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')], // Working Fine
                    'Current Month': [moment().startOf('month'), moment().endOf('month')], // Working Fine
                    'Yearly': [moment().startOf('year'), moment().endOf('year')],
                }
            });
        } else {
            var splitDate = filterSec.split(' - ');
            $('.datepick').daterangepicker({
                singleDatePicker: false,
                showDropdowns: true,
                startDate: splitDate[0],
                endDate: splitDate[1],
                ranges: {
                    'Last Week': [moment().subtract(1, 'weeks').startOf('isoWeek'), moment().subtract(1, 'weeks').endOf('isoWeek')],
                    'Current Week': [moment().startOf('isoWeek'), moment()],
                    'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')], // Working Fine
                    'Current Month': [moment().startOf('month'), moment().endOf('month')], // Working Fine
                    'Yearly': [moment().startOf('year'), moment().endOf('year')],
                }
            });
        }

        $('#datefilter').on('change', function() {
            var datefilter = $(this).val(); 
            $(".ajaxloader").show();
            $.ajax({
                url: '/update_datefiltersDt/',
                type: "GET",
                data: {"_token":"{{ csrf_token() }}","datefilter":datefilter},
                success: function() {
                    loanDetailTb.draw();
                    $(".ajaxloader").hide();
                }
            });
        });

        $('#portfoliotype').on('change', function() {
            var portfoliotype = $(this).val(); 
            $(".ajaxloader").show();
            $.ajax({
                url: '/update_portfoliotypesDt/',
                type: "GET",
                data: {"_token":"{{ csrf_token() }}","portfoliotype":portfoliotype},
                success: function() {
                    loanDetailTb.draw();
                    $(".ajaxloader").hide();
                }
            });
        });

        $('.taxstatustabs').on('click', function() {
            var statustabId = $(this).val(); 
            var serviceTypeId = $('#servicedrop').val();
            if(serviceTypeId == 1) {
                $('.nonescrowtab').removeClass('btn-primary');
                $('.nonescrowtab').addClass('btn-outline-primary');
            } else {
                $('.escrowtab').removeClass('btn-primary');
                $('.escrowtab').addClass('btn-outline-primary');
            }
            $.ajax({
                url: '/statustabDt/',
                type: "GET",
                data: {"_token":"{{ csrf_token() }}","statustabId":statustabId},
                success: function() {
                    if(serviceTypeId == 1) {
                        $('#status' + statustabId).removeClass('btn-outline-primary');
                        $('#status' + statustabId).addClass('btn-primary');
                    } else {
                        $('#status1' + statustabId).removeClass('btn-outline-primary');
                        $('#status1' + statustabId).addClass('btn-primary');
                    }
                    loanDetailTb.draw();
                }
            });
        });
	});
</script>
@endsection