@extends('layouts.app')
@section('title', 'Bill Request')
@section('content')
<style>
    th, td
    {
      padding: 10px;
    }
    .headingtd {
        background-color: var(--color) !important;
    }
    .correctionheader
    {
        background-color:#303e67;
    }
    .dropdown-item.active, .dropdown-item:active {
    color: #000 !important;
    text-decoration: none;
    background-color: #ccc !important;
}
    </style>
<div class="container-fluid mt-1">
    <div class="row">
        <x-escrowtabs/>
    </div>
        <div class="row p-1" id="viewloandetails">
        <x-escrowbillreleasetabs/>
        <div class="col-12 text-center">
            <table style="width:100%">
                <tr>
                    <td width="100%">
                        <a id="1" type="button" class="btn btn-primary mr-1 statustabs" href="/escrow/billrequest/2/1"> Bill Request To be Sent Queue</a>
                        <a id="2" type="button" class="btn statustabs btn-outline-primary mr-1" href="/escrow/billrequest/2/2"> Bill Request Sent Queue</a>
                    </td>
                </tr>
            </table>
        </div>
        <div id="billrequestbtn" class="col-12" style="display:none">
            <div class="row">
                <div class="col-4"></div>
                <div class="col-1 p-2"><b>Bill Sent Date: </b></div>
                <div class="col-2">
                    <input class="form-control" type="date" name="sentdate" id="sentdate" value="2025-10-09">
                </div>
                <div class="col-3">
                    <button class="btn btn-warning"  onclick="billrequestsentupdated();">Update Bill Request Sent</button>
                </div>
                <div class="col-2"></div>
            </div>
        </div>
        <div class="row mt-2" id="filterbillrequestdiv">
            <div class="col-12 text-center">
                <div class="row">
                    <div class="col-3">
                        <select class="form-control" name="lenderid" id="lenderid" onchange="getstatesoflender();">
                            <option value="All">All Lenders</option>
                                                    </select>
                    </div>
                    <div class="col-3">
                        <select class="form-control" name="stateid" id="stateid" onchange="getstatesoflender();">
                            <option value="All">All States</option>
                                                    </select>
                    </div>
                    <div class="col-3">
                        <select class="form-control" name="countyid" id="countyid" onchange="getstatesoflender();">
                            <option value="All">All Counties</option>
                                                    </select>
                    </div>
                    <div class="col-3">
                        <select class="form-control" name="agencyid" id="agencyid" onchange="getstatesoflender();">
                            <option value="All">All Agencies</option>
                                                    </select>
                    </div>
                </div>
            </div>
            <div class="col-12 table-responsive">
                <table id="datatable1" class="table table-bordered mb-0">
                    <thead>
                        <tr>
                            <th style="color:#fff !important"> All <input type="checkbox" name="selectall" id="selectall"></th>
                            <th>Lender</th>
                            <th>State</th>
                            <th>County</th>
                            <th>Agency</th>
                            <th>Bill Req</th>
                            <th>Loan No.</th>
                            <th>Parcel No</th>
                            <th>Year</th>
                            <th>Installment</th>
                            <th>Borrower Name</th>
                            <th>Property Address</th>
                            <th>City</th>
                            <th>Zip</th>
                            <th>Bill Request Sent On</th>
                        </tr>
                    </thead>
                    <tbody>
                                            </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection
@section('script')
<x-alert/>
<script type="text/javascript">
	$(document).ready(function() {
        var filter = 2;
		$(".odtabs").not("#tab3").addClass('btn-outline-secondary');
		$("#tab5").addClass('btn-secondary');
        $(".odsecondtabs").not("#secondtab"+filter).addClass('btn-outline-secondary');
        $("#secondtab"+filter).addClass('btn-secondary');
        var table = $('#datatable1').DataTable({
            "dom": 'lBfrtip',
            "paging": true,
            "info": true,
            "searching": true,
            "buttons": [
                {
                    "extend": 'excelHtml5',
                    "exportOptions": {
                        "columns": ':visible'
                    }
                },
                'colvis'
            ],
            "lengthMenu": [10,50,100,200,500,750,1000,2500],
            'columnDefs': [ {
               'targets': [0], // column index (start from 0)
               'orderable': false, // set orderable false for selected columns
            }],
                    columnDefs: [
                    {
                        "defaultContent": "-",
                        "targets": "_all"
                    },]
        });
	});
    function getstatesoflender()
    {
        var lenderid = $("#lenderid").val();
        var stateid = $("#stateid").val();
        var countyid = $("#countyid").val();
        var agencyid = $("#agencyid").val();
        var filter = 2;
        var sentfilter = 1;
        $.ajax({
                type:'POST',
                url:"{{route('filterbillrequest')}}",
                data: {
                    "_token": "{{ csrf_token() }}",
                        "lenderid":lenderid,
                        "stateid": stateid,
                        "countyid":countyid,
                        "agencyid":agencyid,
                        "filter":filter,
                        "sentfilter":sentfilter
                },
                success: function(html)
                {
                    $("#filterbillrequestdiv").html("");
                    $("#filterbillrequestdiv").html(html);
                    $('#datatable1').DataTable({
                    "dom": 'lBfrtip',
                    "paging": true,
                    "info": true,
                    "searching": true,
                    "buttons": [
                        {
                            "extend": 'excelHtml5',
                            "exportOptions": {
                                "columns": ':visible'
                            }
                        },
                        'colvis'
                    ],
                    "lengthMenu": [10,50,100,200,500,750,1000,2500],
                    'columnDefs': [ {
                    'targets': [0], // column index (start from 0)
                    'orderable': false, // set orderable false for selected columns
                    }],
                });
                }
            });
    }
    $("#selectall").on('change', function()
    {
        if($("#selectall").is(':checked'))
        {
            $(".checkloanclass").prop("checked", true).addClass('checkclass');

            $("#billrequestbtn").show();
        }
        else
        {
            $(".checkloanclass").prop("checked", false).removeClass('checkclass');

        }
    });
function updatecheckclass(id)
    {
        if($("#"+id).is(':checked'))
        {
            $("#"+id).prop("checked", true).addClass('checkclass');
            $("#billrequestbtn").show();
        }
        else
        {
            $("#"+id).prop("checked", false).removeClass('checkclass');
            var totallength = $('.checkloanclass').length;
            var numberOfChecked = $('.checkloanclass:checked').length;
            if(numberOfChecked < totallength)
            {
                $("#selectall").prop("checked", false);
                $("#billrequestbtn").show();
            }
            if(numberOfChecked == 0)
            {
                $("#selectall").prop("checked", false);
                $("#billrequestbtn").hide();
            }
        }
    }
    function billrequestsentupdated()
    {
        let lienids = $(".checkloanclass:checked")
                .map(function (){
                return $(this).val();
            }).toArray();
        var lenderid = $("#lenderid").val();
        var stateid = $("#stateid").val();
        var countyid = $("#countyid").val();
        var agencyid = $("#agencyid").val();
        var sentdate = $("#sentdate").val();
        var filter = 2;
        var sentfilter = 1;
        $.ajax({
            type: "POST",
            url: "{{route('updatebillrequestsent')}}",
            data: { "_token": "{{ csrf_token() }}",
                    "lienids":lienids,
                    "lenderid":lenderid,
                    "stateid": stateid,
                    "countyid":countyid,
                    "agencyid":agencyid,
                    "filter":filter,
                    "sentfilter":sentfilter,
                    "sentdate":sentdate
                },
                success: function(html)
                {
                    new PNotify({
                            title: 'Success',
                            text:  "Bill Request Sent details Updated",
                            type: 'success'
                        });
                        setTimeout(function()
                    {
                        $("#filterbillrequestdiv").html("");
                        $("#filterbillrequestdiv").html(html);
                        $('#datatable1').DataTable({
                        "dom": 'lBfrtip',
                        "paging": true,
                        "info": true,
                        "searching": true,
                        "buttons": [
                            {
                                "extend": 'excelHtml5',
                                "exportOptions": {
                                    "columns": ':visible'
                                }
                            },
                            'colvis'
                        ],
                        "lengthMenu": [10,50,100,200,500,750,1000,2500],
                        'columnDefs': [ {
                        'targets': [0], // column index (start from 0)
                        'orderable': false, // set orderable false for selected columns
                        }],
                        });
                    },100);
                }
        });
    }
</script>
@endsection