@extends('layouts.app')
@section('title', 'Non Escrow Lien Detail Tax Report')
@section('content')
<style>
    thead
    {
        background-color: rgb(23, 25, 104) !important;
        color: #fff !important;
        border-color:rgb(23, 25, 104) !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">
                            <input type="hidden" class="selectedStatusId1" id="selectedStatusId1" name="selectedStatusId1" value="2">
                            <div class="row p-0 m-0">
                                <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                                    <select id="lien_clientsdrops" class="form-control float-right">
                                        <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="lien_lendersdrops" class="form-control float-right">
                                        @if($lendersDt != NULL)
                                            <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="lien_tax_year" class="form-control float-right">
                                        @if($taxyearDetails != NULL)
                                            <option value="">Select Tax Year</option>
                                            @foreach($taxyearDetails as $tax_yearDetails)
                                                <option value="{{ $tax_yearDetails }}" Selected>{{ $tax_yearDetails }}</option>
                                            @endforeach
                                        @else
                                            <option value="">Select Lender First</option>
                                        @endif
                                    </select>
                                </div>
                                <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                                    <select id="lien_statusdrop" class="form-control float-right">
                                        @foreach($statusDetails as $status_details)
                                            <option value="{{ $status_details['id'] }}" >{{ $status_details['name'] }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="row">
                                <div class="col-lg-12 col-md-12 col-xl-12 col-sm-12">
                                    <table id="lien_details_tax_report_table" class="table mb-2 mt-4">
                                        <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>Agency</th>
                                                <th>Parcel No</th>
                                                <th>Tax Status</th>
                                                <th>Tax Year</th>
                                                <th>ELD Date</th>
                                                <th>Time Calculation</th>
                                                <th>Total Due Amount ($)</th>
                                                <th>Updated On</th>
                                                <th>Created On</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<script>
    $(document).ready(function() {
		$(".odtabs").not("#tab9").addClass('btn-outline-secondary');
		$("#tab9").addClass('btn-secondary');

        $('#lien_clientsdrops').on('change', function(){
            var clientid = $(this).val(); 
            $(".ajaxloader").show();
            if (clientid) {
                $.ajax({
                    url: '/get_lenders/' + clientid,
                    type: "GET",
                    dataType: "json",
                    success: function(data) {
                        $('#lien_lendersdrops').empty();
                        $('#lien_tax_year').html('<option value="">Select Lender first</option>');
                        if(data[0] == undefined) {
                            $('#lien_lendersdrops').html('<option value="">No Lenders Associated with Client</option>');
                            var value = $('.selectedStatusId1').val();
                            load_lien_report_tax_data(value.toLowerCase());
                            $(".ajaxloader").hide();
                        } else {
                            if (data[0].length == 0)
                            {
                                $('#lien_lendersdrops').append('<option value="">No Lenders Associated with Client</option>');
                            } else {
                                $('#lien_lendersdrops').append('<option value="All">All Lenders</option>');
                                $.each(data[0], function(key, value) {
                                    $('#lien_lendersdrops').append(
                                        '<option value="' + value['id'] + '">' + value[
                                            'lender_name'] + '</option>');
                                });
                            }
                            var value = $('.selectedStatusId1').val();
                            load_lien_report_tax_data(value.toLowerCase());
                            $(".ajaxloader").hide();
                        }
                    }
                });
            } else {
                $.ajax({
                    url: '/get_lenders/' + clientid,
                    type: "GET",
                    dataType: "json",
                    success: function(data) {
                        $('#lien_lendersdrops').html('<option value="">Select Client first</option>');
                        $('#lien_tax_year').html('<option value="">Select Lender first</option>');
                        var value = $('.selectedStatusId1').val();
                        load_lien_report_tax_data(value.toLowerCase());
                        $(".ajaxloader").hide();
                    }
                });
            }
        });

        $('#lien_lendersdrops').on('change', function(){
            var lenderid = $(this).val(); 
            $(".ajaxloader").show();
            if (lenderid != 'All') {
                $.ajax({
                    url: '/update_lien_lenderDt',
                    type: "GET",
                    data: {"_token":"{{ csrf_token() }}","lenderId":lenderid},
                    success: function(data) {
                        $('#lien_tax_year').empty();
                        if(data == undefined) {
                            $('#lien_tax_year').html('<option value="">No Tax Year Associated with Lender</option>');
                            $('.hidetb').addClass('d-none');
                            var value = $('.selectedStatusId1').val();
                            $('.tb_' + value.toLowerCase()).removeClass('d-none');
                            if($('.tb_' + value.toLowerCase()).hasClass('tblientaxreport')) {
                            } else {
                                $('.tb_' + value.toLowerCase()).addClass('tblientaxreport');
                                load_lien_report_tax_data(value.toLowerCase());
                            }
                            $(".ajaxloader").hide();
                        } else {
                            if (data.length == 0)
                            {
                                $('#lien_tax_year').append('<option value="">No Tax Year Associated with Lender</option>');
                            } else {
                                $('#lien_tax_year').append('<option value="">Select Tax Year</option>');
                                $.each(data, function(key, value) {
                                    $('#lien_tax_year').append(
                                        '<option value="' + value + '">' + value + '</option>');
                                });
                            }
                            var value = $('.selectedStatusId1').val();
                            load_lien_report_tax_data(value.toLowerCase());
                            $(".ajaxloader").hide();
                        }
                    }
                });
            } else {
                $.ajax({
                    url: '/update_lien_lenderDt',
                    type: "GET",
                    data: {"_token":"{{ csrf_token() }}","lenderId":lenderid},
                    success: function(data) {
                        $('#lien_tax_year').html('<option value="">Select Lender first</option>');
                        var value = $('.selectedStatusId1').val();
                        load_lien_report_tax_data(value.toLowerCase());
                        $(".ajaxloader").hide();
                    }
                });
            }
        });

        $('#lien_tax_year').on('change', function() {
            var taxYear = $(this).val(); 
            $(".ajaxloader").show();
            $.ajax({
                url: '/update_lienYearDt/',
                type: "GET",
                data: {"_token":"{{ csrf_token() }}","taxYear":taxYear},
                success: function() {
                    var value = $('.selectedStatusId1').val();
                    load_lien_report_tax_data(value.toLowerCase());
                    $(".ajaxloader").hide();
                }
            });
        });

        $('#lien_statusdrop').on('change', function(){
            var value = $(this).val();
            $('.selectedStatusId1').val(value.toLowerCase());
            load_lien_report_tax_data(value.toLowerCase());
        });

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

        var selectedStatusId1 = $('.selectedStatusId1').val();
        function load_lien_report_tax_data(selectedStatusId1) {
            if ($.fn.DataTable.isDataTable('#lien_details_tax_report_table')) {
                $('#lien_details_tax_report_table').DataTable().clear().destroy();
            }

            $('#lien_details_tax_report_table').DataTable({
                dom: 'lBfrtip',
                scrollX: true,
                "order": [],
                "processing": true,
                "serverSide": false,
                "buttons":['excel'],
                "lengthMenu": [10,50,100,200,500,1000,2000,5000],
                "ajax": {
                    url: "{{ url('/fetchtaxliendetailreport') }}",
                    method: "POST",
                    data: {
                        _token: '{!! csrf_token() !!}',
                        'selectedStatusId1' : selectedStatusId1
                    },
                },
                columns: [
                    {
                        data: 'loan_no',
                        name: 'ztp_portfolio_loanlist.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: 'ztp_portfolio_loanlist.borrower_name',
                        defaultContent: "--"
                    },
                    {
                        data: 'property_address',
                        name: 'ztp_portfolio_loanlist.property_address',
                        defaultContent: "--"
                    },
                    {
                        data: 'city',
                        name: 'ztp_portfolio_loanlist.city',
                        defaultContent: "--"
                    },
                    {
                        data: 'short_code',
                        name: 'state.short_code',
                        defaultContent: "--"
                    },
                    {
                        "data": null,
                        "render": function(data)
                        {
                            return '\u200C' +data.zip;
                        }
                    },
                    {
                        data: 'county_name',
                        name: 'county.county_name',
                        defaultContent: "--"
                    },
                    {
                        data: 'service_type',
                        name: 'ztp_portfolio_loanlist.service_type',
                        defaultContent: "--"
                    },
                    {
                        data: 'agency_details',
                        name: 'agency_details.agency_name',
                        defaultContent: "--"
                    },
                    {
                        "data": null,
                        "render": function(data)
                        {
                            return '\u200C' +data.parcel_no;
                        }
                    },
                    {
                        data: 'tax_status',
                        name: 'ztp_tax_status.tax_status',
                        defaultContent: "--",
                    },
                    {
                        "data": null,
                        "render": function(data)
                        {
                            return '\u200C' +data.year;
                        }
                    },
                    {
                        data: 'eld_date',
                        name: 'ztp_loantax_tracking.eld_date',
                        defaultContent: "--",
                    },
                    {
                        data: 'time_calculation',
                        name: 'time_calculation',
                        defaultContent: "--",
                    },
                    {
                        data: 'total_due_amount',
                        name: 'balance_amount',
                        defaultContent: "--"
                    },
                    {
                        data: 'updated_datetime',
                        name: 'ztp_portfolio_loanlist.last_updated_on',
                        defaultContent: "--"
                    },
                    {
                        data: 'added_datetime',
                        name: 'ztp_portfolio_loanlist.addeddatetime',
                        defaultContent: "--"
                    },
                ],
            });
        }
        
        load_lien_report_tax_data(selectedStatusId1);
	});
    

</script>
    @endsection