@extends('layouts.app')
@section('title', 'C Planning Report')
@section('content')
<div id="displayloandiv" class="p-0 m-0">
    <div class="container-fluid mt-5 pt-2">
        <div class="row py-2">
        <h6 class="text-center">C- Planning Report</h6>
            <form id="filterform">
                <div class="row p-1 m-1">
                    <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                    </div>
                    <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                        <select required id="lenderfilter" class="form-select forminputfields float-end">
                            <option value="">Filter By Lender</option>
                                                    </select>
                    </div>
                    <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                        <select required id="statefilter" class="form-select forminputfields float-end">
                            <option value="">Filter By State</option>
                                                    </select>
                    </div>
                    <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                        <button type="button" class="btn btn-primary" onclick="filter_loans();"> Submit</button>
                    </div>
                </div>
            </form>
        </div>
            <div id="displaystate" class="col-lg-12 col-md-12 col-xl-12 col-sm-12 table-responsive">
                <table id="taxsevicetable" class="table table-bordered nowrap table-striped mb-0 mt-2" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                    <thead>
                        <tr>
                            <th>Customer No</th>
                            <th>Customer</th>
                            <th>Client</th>
                            <th>Servicing Platform</th>
                            <th>Escrow Processing</th>
                            <th>Total Liens</th>
                            <th>No ELD Liens</th>
                            <th>Liens - Oct-2025</th>
                            <th>
                                            Liens - Nov-2025
                                         </th><th>
                                            Liens - Dec-2025
                                         </th><th>
                                            Liens - Jan-2026
                                         </th><th>
                                            Liens - Feb-2026
                                         </th><th>
                                            Liens - Mar-2026
                                         </th><th>
                                            Liens - Apr-2026
                                         </th><th>
                                            Liens - May-2026
                                         </th><th>
                                            Liens - Jun-2026
                                         </th><th>
                                            Liens - Jul-2026
                                         </th><th>
                                            Liens - Aug-2026
                                         </th><th>
                                            Liens - Sep-2026
                                         </th>                        </tr>
                    </thead>
                    <tbody>
                                            </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection
@section('page_script')
<script>
    $(function() {
        var setup1 = $('#taxsevicetable').DataTable({
            // responsive: true,
            dom: 'lBfrtip',
            "paging": true,
            "info": false,
            searching:true,
            buttons: [
             'excel'
        ]
        });

    });
    function filter_loans()
    {
        if ($("#filterform").parsley())
        {
            if ($("#filterform").parsley().validate())
            {
                event.preventDefault();
                if ($("#filterform").parsley().isValid())
                {
                    if($("#statefilter").val() != "")
                    {
                        var stateid = $("#statefilter").val();
                    }
                    else
                    {
                        var stateid ="";
                    }
                    if($("#lenderfilter").val() != "")
                    {
                        var lenderid = $("#lenderfilter").val();
                    }
                    else
                    {
                        var lenderid ="";
                    }
                    $.ajax({
                            url: '{{ route("getcplanningbylender") }}',
                            type: "POST",
                            data: {
                                    "_token": "{{ csrf_token() }}",
                                    "lenderid":lenderid,
                                    "stateid":stateid
                                },
                            success: function (html)
                            {
                                $("#displaystate").html(html);
                                $('#taxsevicetable').DataTable({
                                dom: 'lBfrtip',
                                "paging": true,
                                "info": true,
                                searching:true,
                                buttons:['excel']
                            });

                            }
                        });
                }
            }
        }
    }

</script>
@endsection