@extends('layouts.master')
@section('page-title', $page_info['page_title'])
@section('main-section')

    <div class="content-page">
        <div class="content">
            <!-- Start Content-->
            <div class="container-fluid">
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box">
                            <div class="page-title-right">
                                <form class="d-flex">
                                    <a href="{{route('dashboard')}}" class="btn btn-primary ms-2">
                                        <i class="mdi mdi-autorenew"></i>
                                    </a>
                                    <a href="javascript: void(0);" class="btn btn-primary ms-1" data-bs-toggle="modal"
                                        data-bs-target="#dashboard-modal">
                                        <i class="mdi mdi-filter-variant"></i>
                                    </a>
                                </form>
                            </div>
                            <h4 class="page-title">{{$page_info['page_name']}}</h4>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="d-flex card-header justify-content-between align-items-center">
                                <h4 class="header-title mb-3">Fresh Cases Disbursed on
                                    {{ date('jS F Y', strtotime("-1 days")) }}</h4>
                            </div>
                            <div class="card-body pt-0">
                                <div class="table-responsive">
                                    <table class="table table-centered table-bordered table-hover mb-0">
                                        <thead>
                                            <tr class="bg-success">
                                                <th class="text-white">Credit Wise</th>
                                                <th class="text-white">Count of Cases</th>
                                                <th class="text-white">Loan Amount</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $totalCases = 0;
                                                $totalAmount = 0;
                                            @endphp

                                            @foreach ($FreshCaseDisbursed_of_lastday as $data)
                                                @php
                                                    $cases = $data->FreshCases ?? 0;
                                                    $amount = $data->LoanAmount ?? 0;
                                                    $totalCases += $cases;
                                                    $totalAmount += $amount;
                                                @endphp
                                                <tr>
                                                    <td>{{ $data->SanctionOfficer ?? 'N/A' }}</td>
                                                    <td>{{ $cases }}</td>
                                                    <td>{{ number_format($amount, 2) }}</td>
                                                </tr>
                                            @endforeach

                                            <!-- Total Row -->
                                            <tr class="bg-light">
                                                <th>Total</th>
                                                <th>{{ $totalCases }}</th>
                                                <th>{{ number_format($totalAmount, 2) }}</th>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-lg-12">
                        <div class="card">
                            <div class="d-flex card-header justify-content-between align-items-center">
                                <h4 class="header-title mb-3">Fresh And Repeated Disbursement Comparison ({{ date('01') }} -
                                    {{ date('jS M Y', strtotime("-1 days")) }}) CM</h4>
                            </div>
                            <div class="card-body pt-0">
                                <div class="table-responsive">
                                    <table class="table table-centered table-bordered table-hover mb-0">
                                        <thead>
                                            <tr>
                                                <th class="sub-heading" style="vertical-align: middle;">Credit Wise</th>
                                                <th colspan="2" class="sub-heading" style="text-align:center;">
                                                    {{ date("M Y", strtotime('m')) }}</th>
                                                <th colspan="2" class="sub-heading" style="text-align:center;">
                                                    {{ date("M Y", strtotime(date('Y-m') . " -1 month")) }}</th>
                                            </tr>
                                            <tr class="bg-success">
                                                <th class="text-white">Credit Manager</th>
                                                <th class="text-white">Cases</th>
                                                <th class="text-white">Loan Amount</th>
                                                <th class="text-white">Cases</th>
                                                <th class="text-white">Loan Amount</th>
                                                <th class="text-white" style="vertical-align: middle;" rowspan="2">Deficit
                                                    Amount</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                        @php
                                        $totalCurrMonthFreshCases = 0;
                                        $totalCurrMonthLoanAmount = 0;
                                        $totalLastMonthFreshCases = 0;
                                        $totalLastMonthLoanAmount = 0;
                                    @endphp

                                    <tbody>
                                        @foreach ($FreshRepeatCaseComparison as $data)
                                            @php
                                                $totalCurrMonthFreshCases += $data->CurrMonthFreshCases;
                                                $totalCurrMonthLoanAmount += $data->CurrMonthLoanAmount;
                                                $totalLastMonthFreshCases += $data->LastMonthFreshCases;
                                                $totalLastMonthLoanAmount += $data->LastMonthLoanAmount;
                                            @endphp
                                            <tr>
                                                <td>{{ $data->SanctionOfficer }}</td>
                                                <td>{{ $data->CurrMonthFreshCases }}</td>
                                                <td>{{ number_format($data->CurrMonthLoanAmount, 2) }}</td>
                                                <td>{{ $data->LastMonthFreshCases }}</td>
                                                <td>{{ number_format($data->LastMonthLoanAmount, 2) }}</td>
                                                <td>{{ number_format($data->LastMonthLoanAmount - $data->CurrMonthLoanAmount, 2) }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr class="fw-bold bg-light">
                                            <td>Total</td>
                                            <td>{{ $totalCurrMonthFreshCases }}</td>
                                            <td>{{ number_format($totalCurrMonthLoanAmount, 2) }}</td>
                                            <td>{{ $totalLastMonthFreshCases }}</td>
                                            <td>{{ number_format($totalLastMonthLoanAmount, 2) }}</td>
                                            <td>{{ number_format($totalLastMonthLoanAmount - $totalCurrMonthLoanAmount, 2) }}</td>
                                        </tr>
                                    </tfoot>

                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-lg-12">
                        <div class="card">
                            <div class="d-flex card-header justify-content-between align-items-center">
                                <h4 class="header-title mb-3">Fresh Cases comparison -
                                    {{ date("M Y", strtotime('m')) }} / {{ date("M Y", strtotime("-1 month")) }} CM</h4>
                            </div>
                            <div class="card-body pt-0">
                                <div class="table-responsive">
                                    <table class="table table-centered table-bordered table-hover mb-0">
                                    <thead>
                                            <tr>
                                                <th class="sub-heading" style="vertical-align: middle;">Credit Wise</th>
                                                <th colspan="2" class="sub-heading" style="text-align:center;">
                                                    {{ date("M Y", strtotime('m')) }}</th>
                                                <th colspan="2" class="sub-heading" style="text-align:center;">
                                                    {{ date("M Y", strtotime(date('Y-m') . " -1 month")) }}</th>
                                                
                                            </tr>
                                            <tr class="bg-success">
                                                <th class="text-white">Credit Manager</th>
                                                <th class="text-white">Cases</th>
                                                <th class="text-white">Loan Amount</th>
                                                <th class="text-white">Cases</th>
                                                <th class="text-white">Loan Amount</th>
                                                <th class="text-white" style="vertical-align: middle;" rowspan="2">Deficit
                                                    Amount</th>
                                            </tr>
                                        </thead>
                                        @php
                                        $totalLastMonthCases = 0;
                                        $totalLastLoanAmount = 0;
                                        $totalCurrentMonthCases = 0;
                                        $totalCurrentLoanAmount = 0;
                                    @endphp
                                    
                                    <tbody>
                                        @foreach ($FreshCaseComparison_lastmonth_tilldate as $data)
                                            @php
                                                $totalLastMonthCases += $data->LastMonthCases;
                                                $totalLastLoanAmount += $data->LastLoanAmount;
                                                $totalCurrentMonthCases += $data->CurrentMonthCases;
                                                $totalCurrentLoanAmount += $data->CurrentLoanAmount;
                                            @endphp
                                            <tr>
                                                <td>{{ $data->SanctionOfficer }}</td>
                                                <td>{{ $data->CurrentMonthCases }}</td>
                                                <td>{{ number_format($data->CurrentLoanAmount, 2) }}</td>
                                                <td>{{ $data->LastMonthCases }}</td>
                                                <td>{{ number_format($data->LastLoanAmount, 2) }}</td>
                                                <td>{{ number_format($data->CurrentLoanAmount - $data->LastLoanAmount, 2) }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr style="font-weight: bold; background-color: #f0f0f0;">
                                            <td>Total</td>
                                            <td>{{ $totalCurrentMonthCases }}</td>
                                            <td>{{ number_format($totalCurrentLoanAmount, 2) }}</td>
                                            <td>{{ $totalLastMonthCases }}</td>
                                            <td>{{ number_format($totalLastLoanAmount, 2) }}</td>
                                            <td>{{ number_format($totalCurrentLoanAmount - $totalLastLoanAmount, 2) }}</td>
                                        </tr>
                                    </tfoot>
                                    
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-lg-12">
                        <div class="card">
                            <div class="d-flex card-header justify-content-between align-items-center">
                                <h4 class="header-title mb-3">Disbursment comparison
                                    {{ date("M Y", strtotime('m')) }} / {{ date("M Y", strtotime("-1 month")) }}</h4>
                            </div>
                            <div class="card-body pt-0">
                                <div class="table-responsive">
                                    <table class="table table-centered table-bordered table-hover mb-0">
                                    <thead>
                                            <tr>
                                                <th colspan="2" class="sub-heading" style="text-align:center;">
                                                    {{ date("M Y", strtotime('m')) }}</th>
                                                <th colspan="2" class="sub-heading" style="text-align:center;">
                                                    {{ date("M Y", strtotime(date('Y-m') . " -1 month")) }}</th>
                                                
                                            </tr>
                                            <tr class="bg-success">
                                                <th class="text-white">Date</th>
                                                <th class="text-white">Loan Amount</th>
                                                <th class="text-white">Date</th>
                                                <th class="text-white">Loan Amount</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                                <tr>
                                                <td>{{ '1-' . date('j') . ' ' . date('M') }}</td>
                                                    <td>{{ $finaldisburseComparisonQuery->CurrentMonthLoanAmount ?? 0 }}</td>
                                                    <td>{{ '1-' . date('j', strtotime('-1 month')) . ' ' . date('M', strtotime('-1 month')) }}</td>
                                                    <td>{{ $finaldisburseComparisonQuery->LastMonthLoanAmount }}</td>
                                                </tr>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>


            </div>
            <!-- container -->
            <div id="dashboard-modal" class="modal fade dashboard-update-modal" tabindex="-1" role="dialog"
                aria-hidden="true">
                <div class="modal-dialog modal-right">
                    <div class="modal-content align-item-start">
                        <div class="modal-header border-0 text-center">
                            <h4 class="modal-title" style="color:#0acf97; margin: 0 auto;" id="primary-header-modalLabel">
                                Dashboard Filter</h4>
                            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-hidden="true"></button>
                        </div>
                        <div class="modal-body">
                            <form class="ps-1 pe-1 mb-5" action="{{route('dashboard')}}" method="GET">
                                <div class="row mb-5">
                                    <!--<div class="col-md-12">-->
                                    <!--   <div class="mb-2">-->
                                    <!--      <label class="form-label">Loan Type</label><br>-->
                                    <!--      <div class="form-check form-check-inline">-->
                                    <!--         <input class="form-check-input" type="radio" name="loanType" id="payday" value="Payday" checked>-->
                                    <!--         <label class="form-check-label" for="payday">Payday</label>-->
                                    <!--      </div>-->
                                    <!--      <div class="form-check form-check-inline">-->
                                    <!--         <input class="form-check-input" type="radio" name="loanType" id="emi" value="EMI">-->
                                    <!--         <label class="form-check-label" for="emi">EMI</label>-->
                                    <!--      </div>-->
                                    <!--      <span class="loanTypeErr"></span>-->
                                    <!--   </div>-->
                                    <!--</div>-->
                                    <div class="col-md-12">
                                        <div class="mb-2">
                                            <label for="reportType" class="form-label">Report Type</label>
                                            <select class="form-select" name="reportType" id="reportType">
                                                <option value="">Select Report Type</option>
                                                @if(isSuperAdmin() || isAdmin() || role() == 'CRM Support' || role() == 'Sr. Recovery Manager' || role() == 'Recovery Manager' || role() == 'Recovery Executive')
                                                    <option value="Business Overview" {{ $reportType === 'Business Overview' ? 'selected' : '' }}>Business Overview</option>
                                                    <option value="Recovery Value" {{ $reportType === 'Recovery Value' ? 'selected' : '' }}>Recovery Value</option>
                                                    <option value="Recovery Volume" {{ $reportType === 'Recovery Volume' ? 'selected' : '' }}>Recovery Volume</option>
                                                    <option value="Daily MIS" {{ $reportType === 'Daily MIS' ? 'selected' : '' }}>
                                                        Daily MIS</option>
                                                @endif
                                                <option value="Sanction 360" {{ $reportType === 'Sanction 360' ? 'selected' : '' }}>Sanction 360<sup>°</sup></option>
                                            </select>
                                            <span class="reportTypeErr"></span>
                                        </div>
                                    </div>

                                    <div class="col-md-12">
                                        <div class="mb-2">
                                            <div class="input-group">
                                                <span class="input-group-text">
                                                    <i class="uil uil-filter"></i>
                                                </span>
                                                <select class="form-select exportSelect" name="filter" id="filter">
                                                    <option value="sortByToday" {{ $filter === 'sortByToday' ? 'selected' : '' }}>Sort by Today</option>
                                                    <option value="sortByWeek" {{ $filter === 'sortByWeek' ? 'selected' : '' }}>Sort by Week</option>
                                                    <option value="sortByThisMonth" {{ $filter === 'sortByThisMonth' || empty($filter) ? 'selected' : '' }}>Sort by This Month</option>
                                                    <option value="sortByLastMonth" {{ $filter === 'sortByLastMonth' ? 'selected' : '' }}>Sort by Prev Month</option>
                                                    <option value="sortByDate" {{ $filter === 'sortByDate' ? 'selected' : '' }}>Sort by Date</option>
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-12" id="dateRange" style="display: none;">
                                        <div class="mb-3">
                                            <div class="input-group">
                                                <span class="input-group-text">
                                                    <i class="uil uil-calender"></i>
                                                </span>
                                                <input type="text" class="form-control date" name="searchRange"
                                                    data-toggle="date-picker" data-cancel-class="btn-warning">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-12 mb-5">
                                        <div class="mb-5 text-center">
                                            <input type="submit" class="btn btn-primary form-control" value="Apply">
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                    <!-- /.modal-content -->
                </div>
                <!-- /.modal-dialog -->
            </div>
@endsection
        @section('custom-js')
            <script>
                $(document).ready(function () {
                    // Function to toggle date range visibility
                    function toggleDateRange() {
                        if ($('#filter').val() === 'sortByDate') {
                            $('#dateRange').show();
                        } else {
                            $('#dateRange').hide();
                        }
                    }

                    // Initial check on page load
                    toggleDateRange();

                    // Event listener for filter change
                    $('#filter').change(function () {
                        toggleDateRange();
                    });
                });
            </script>
        @endsection