@extends('layouts.app')
@section('title', 'LoanCount Monthwise 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-3">
                <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>Count By Year-Month Report</h5>
                            <div class="row p-0 m-0">
                                <div class="col-lg-4 col-sm-12 col-xl-4 col-md-4">
                                    <select class="form-control" id="year" name="year" onchange="getloans();">
                                        <option>2024</option>
                                                   <option>2025</option>                                    </select>
                                </div>
                                <div class="col-lg-4 col-sm-12 col-xl-4 col-md-4">
                                <select class="form-control" id="month" name="month" onchange="getloans();">
                                    <option value="">Choose Month</option>
                                    <option value="All">All</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-4 col-sm-12 col-xl-4 col-md-4">
                                </div>
                            </div>
                            <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>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();
    if(month != "")
    {
        $.ajax({
            type: "POST",
            url: "{{route('filterreportsmonthwise')}}",
            data: {
                    "_token": "{{ csrf_token() }}",
                    "year":year,
                    "month":month
                },
                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("#tab2").addClass('btn-outline-secondary');
		$("#tab2").addClass('btn-secondary');
	});
</script>
@endsection