@extends('layouts.app')
@section('title', 'Loan Count Client-Lender 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">
                            <h5>Client-Lender Count Report</h5>
                            <form method="post" id="addfrm" data-parsley-validate>
                                @csrf
                                <div class="row p-0 m-0">
                                    <div class="col-lg-2 col-sm-12 col-xl-2 col-md-2">
                                        <select required class="form-control" id="year" name="year">
                                            <option>2024</option>
                                                    <option>2025</option>                                        </select>
                                    </div>
                                    <div class="col-lg-2 col-sm-12 col-xl-2 col-md-2">
                                    <select required class="form-control" id="month" name="month">
                                        <option value="">Choose Month</option>
                                        <option value="01">January</option><option value="02">February</option><option value="03">March</option><option value="04">April</option><option value="05">May</option><option value="06">June</option><option value="07">July</option><option value="08">August</option><option value="09">September</option><option value="10">October</option><option value="11">November</option><option value="12">December</option>                                    </select>
                                    </div>
                                    <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                                        <select required class="form-control" id="client" name="client" onchange="getlenders(this.value);">
                                            <option value="">Choose Client</option>
                                                                                    </select>
                                    </div>
                                    <div class="col-lg-3 col-sm-12 col-xl-3 col-md-3">
                                        <select required class="form-control" id="lender" name="lender">
                                        </select>
                                    </div>
                                    <div class="col-lg-2 col-sm-12 col-xl-2 col-md-2">
                                        <input class="btn btn-info" type="button" onclick="getloans();" value="Submit">
                                    </div>
                                </div>
                            </form>
                            <div class="row">
                                <div class="col-lg-12 col-md-12 col-xl-12 col-sm-12" id="stateloandiv">
                                    <table class="table" id="setuptable1">
                                        <thead>
                                            <tr>
                                                <th>Year</th>
                                                <th>Month</th>
                                                <th>Client</th>
                                                <th>Lender</th>
                                                <th>New Loans</th>
                                                <th>Conversion Loans</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<script>
$(function() {
         var setup1 = $('#setuptable1').DataTable({
            dom: 'lBfrtip',
        buttons: [
           'excel'
        ],
        "lengthMenu": [10,25],
             "paging": true,
             "info": true,
            searching: true,
	});
});
function getloans()
{
    var year = $("#year").val();
    var month = $("#month").val();
    var clientid = $("#client").val();
    var lenderid = $("#lender").val();
        $.ajax({
            type: "POST",
            url: "{{route('filterreportsclientmonthwise')}}",
            data: {
                    "_token": "{{ csrf_token() }}",
                    "year":year,
                    "month":month,
                    "clientid":clientid,
                    "lenderid":lenderid
                },
                success:function(html)
                {
                    $('#stateloandiv').html(html);
                    var setup1 = $('#setuptable2').DataTable({
                            dom: 'lBfrtip',
                        buttons: [
                        'excel'
                        ],
                        "lengthMenu": [10,25],
                            "paging": true,
                            "info": true,
                            searching: true,
                    });
                },
                error: function(html)
                {
                    console.log(html);
                }
        });
}
$(document).ready(function()
    {
		$(".odtabs").not("#tab3").addClass('btn-outline-secondary');
		$("#tab3").addClass('btn-secondary');
	});
    function getlenders(clientid)
    {
        $.ajax({
            type: "POST",
            url: "{{route('getlenders')}}",
            data: { "_token": "{{ csrf_token() }}",
                    "clientid":clientid
                },
            success: function(html)
            {
                $("#lender").html(html);
            }
        });
    }
</script>
@endsection