@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">Sanction 360º {{$filterShow}}</h4>
            </div>
            <div class="card-body pt-0">
               <div class="table-responsive">
                 <table id="datatable-buttons-1" class="table table-striped dt-responsive nowrap w-100">
                   <thead>
                      <tr class="bg-success">
                         <th class="text-white">Sanction Officer</th>
                         <th class="text-white">Target</th>
                         <th class="text-white">Achievement</th>
                         <th class="text-white">% Achievement</th>
                         <th class="text-white">Deficit</th>
                      </tr>
                   </thead>
                 <tbody>
                    @if(count($sanctionData) > 0)
                        @php
                            $totalTarget = 0;
                            $totalAchievement = 0;
                            $totalDeficit = 0;
                        @endphp
                        @foreach($sanctionData as $arr)
                            @php 
                                // Check if the target is zero to avoid division by zero error
                                $achievementPercentage = $arr->target > 0 ? ($arr->totalLoanAmtApproved / $arr->target) * 100 : 0;
                                $deficit = $arr->target - $arr->totalLoanAmtApproved;
                
                                $totalTarget += $arr->target;
                                $totalAchievement += $arr->totalLoanAmtApproved;
                                $totalDeficit += $deficit;
                            @endphp
                            <tr>
                                <td class="table-user">
                                    <img src="{{Storage::url($arr->profile)}}" alt="table-user" class="me-2 rounded-circle" />
                                    {{ getUserNameById('users','userID',$arr->userID,'displayName') }}
                                </td>
                                <td>
                                    <span class="font-14">{{ nf($arr->target) }}</span>
                                </td>
                                <td>
                                    <span class="font-14">{{ nf($arr->totalLoanAmtApproved) }}</span>
                                </td>
                                <td>
                                    <span class="font-14">{{ number_format($achievementPercentage, 2) }} %</span>
                                </td>
                                <td>
                                    <span class="font-14">{{ nf($deficit) }}</span>
                                </td>
                            </tr>
                        @endforeach
                
                        <!-- Last row for totals -->
                        <tr style="font-weight: bold;">
                            <td class="text-left">Total</td>
                            <td>
                                <span class="font-14">{{ nf($totalTarget) }}</span>
                            </td>
                            <td>
                                <span class="font-14">{{ nf($totalAchievement) }}</span>
                            </td>
                            <td>
                                @php 
                                    // Check if totalTarget is zero before calculating overall achievement percentage
                                    $overallAchievementPercentage = $totalTarget > 0 ? ($totalAchievement / $totalTarget) * 100 : 0;
                                @endphp
                                <span class="font-14">{{ number_format($overallAchievementPercentage, 2) }} %</span>
                            </td>
                            <td>
                                <span class="font-14">{{ nf($totalDeficit) }}</span>
                            </td>
                        </tr>
                
                    @else
                        <tr>
                            <td colspan="5" class="text-center">No Records Found</td>
                        </tr>
                    @endif
                </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">Branch 360º {{$filterShow}}</h4>
            </div>
            <div class="card-body pt-0">
               <div class="table-responsive">
                 <table id="datatable-buttons-2" class="table table-striped dt-responsive nowrap w-100">
    <thead>
        <tr class="bg-success">
            <th class="text-white">Branch</th>
            <th class="text-white">Target</th>
            <th class="text-white">Achievement</th>
            <th class="text-white">% Achievement</th>
            <th class="text-white">Deficit</th>
        </tr>
    </thead>
    <tbody>
        @php
            // Initialize total variables
            $totalTarget = 0;
            $totalAchievement = 0;
            $totalDeficit = 0;
        @endphp

        @if(count($branchData) > 0)
            @foreach($branchData as $arr)
                @php
                    // Calculate values for the row
                    $achievementPercentage = $arr->target > 0 ? ($arr->totalLoanAmtApproved / $arr->target) * 100 : 0;
                    $deficit = $arr->target - $arr->totalLoanAmtApproved;

                    // Add to totals
                    $totalTarget += $arr->target;
                    $totalAchievement += $arr->totalLoanAmtApproved;
                    $totalDeficit += $deficit;
                @endphp

                <tr>
                    <td>{{ getUserNameById('lms_cities', 'cityID', $arr->branchId, 'cityName') }}</td>
                    <td>
                        <span class="font-14">{{ nf($arr->target) }}</span>
                    </td>
                    <td>
                        <span class="font-14">{{ nf($arr->totalLoanAmtApproved) }}</span>
                    </td>
                    <td>
                        <span class="font-14">{{ number_format($achievementPercentage, 2) }} %</span>
                    </td>
                    <td>
                        <span class="font-14">{{ nf($deficit) }}</span>
                    </td>
                </tr>
            @endforeach

            <!-- Last row for totals -->
            <tr style="font-weight: bold;">
                <td class="text-left">Total</td>
                <td>
                    <span class="font-14">{{ nf($totalTarget) }}</span>
                </td>
                <td>
                    <span class="font-14">{{ nf($totalAchievement) }}</span>
                </td>
                <td>
                    @php
                        $overallAchievementPercentage = $totalTarget > 0 ? ($totalAchievement / $totalTarget) * 100 : 0;
                    @endphp
                    <span class="font-14">{{ number_format($overallAchievementPercentage, 2) }} %</span>
                </td>
                <td>
                    <span class="font-14">{{ nf($totalDeficit) }}</span>
                </td>
            </tr>

        @else
            <tr>
                <td colspan="5" class="text-center">No Records Found</td>
            </tr>
        @endif
    </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">Sanction 360º Fresh V/S Repeat Cases {{$filterShow}}</h4>
            </div>
            <div class="card-body pt-0">
               <div class="table-responsive">
                  <table class="table table-centered table-nowrap table-hover mb-0">
                   <thead>
                        <tr class="bg-success">
                           <th class="text-white">Sanction Officer</th>
                           <th class="text-white">Fresh Cases</th>
                           <th class="text-white">Fresh Loan Amount</th>
                           <th class="text-white">Repeat Cases</th>
                           <th class="text-white">Repeat Loan Amount</th>
                           <th class="text-white">Grand Total Cases</th>
                           <th class="text-white">Grand Total Loan Amount</th>
                       </tr>
                   </thead>
                   <tbody>
                       @php
                           $totalFreshCases = 0;
                           $totalFreshLoanAmount = 0;
                           $totalRepeatCases = 0;
                           $totalRepeatLoanAmount = 0;
                       @endphp

                       @if(count($sanctionFreshRepeatData) > 0)
                           @foreach($sanctionFreshRepeatData as $arr)
                               @php
                                   $grandTotalCases = $arr->freshCases + $arr->repeatCases;
                                   $grandTotalLoanAmount = $arr->freshLoanAmount + $arr->repeatLoanAmount;

                                   // Accumulate totals
                                   $totalFreshCases += $arr->freshCases;
                                   $totalFreshLoanAmount += $arr->freshLoanAmount;
                                   $totalRepeatCases += $arr->repeatCases;
                                   $totalRepeatLoanAmount += $arr->repeatLoanAmount;
                               @endphp

                               <tr>
                                   <td class="table-user">
                                       <img src="{{ Storage::url($arr->profile) }}" alt="table-user" class="me-2 rounded-circle" />
                                       {{ getUserNameById('users', 'userID', $arr->userID, 'displayName') }}
                                   </td>
                                   <td>
                                       <span class="font-14">{{ $arr->freshCases }}</span>  
                                   </td>
                                   <td>
                                       <span class="font-14">{{ nf($arr->freshLoanAmount) }}</span>  
                                   </td>
                                   <td>
                                       <span class="font-14">{{ $arr->repeatCases }}</span>  
                                   </td>
                                   <td>
                                       <span class="font-14">{{ nf($arr->repeatLoanAmount) }}</span>  
                                   </td>
                                   <td>{{ $grandTotalCases }}</td>
                                   <td>{{ nf($grandTotalLoanAmount) }}</td>
                               </tr>
                           @endforeach
                       @else
                           <tr>
                               <td colspan="7" class="text-center">No Records Found</td>
                           </tr>
                       @endif
                       @if(count($sanctionFreshRepeatData) > 0)
                          <tfoot>
                              <tr>
                                  <th>Total</th>
                                  <th>{{ $totalFreshCases }}</th>
                                  <th>{{ nf($totalFreshLoanAmount) }}</th>
                                  <th>{{ $totalRepeatCases }}</th>
                                  <th>{{ nf($totalRepeatLoanAmount) }}</th>
                                  <th>{{ $totalFreshCases + $totalRepeatCases }}</th>
                                  <th>{{ nf($totalFreshLoanAmount + $totalRepeatLoanAmount) }}</th>
                              </tr>
                          </tfoot>
                       @endif
                   </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 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>
                               @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();
        });
    });
    
  $(document).ready(function() {
    // Use the server-side role dynamically
    var userRole = '{{role()}}'; // Dynamically set role in PHP session

    $('#datatable-buttons-1, #datatable-buttons-2').DataTable({
        dom: 'Bfrtip',
        buttons: getButtonsForRole(userRole),
        pageLength: -1
    });

    function getButtonsForRole(role) {
        switch (role) {
            case 'Data Analyst Manager':
                return [
                    { extend: 'csv', className: 'btn btn-success' },
                    { extend: 'excel', className: 'btn btn-success' },
                    { extend: 'pdf', className: 'btn btn-success' },
                    { extend: 'print', className: 'btn btn-success' }
                ];
            case 'Super Admin':
                return [
                    { extend: 'csv', className: 'btn btn-success' },
                    { extend: 'excel', className: 'btn btn-success' },
                    { extend: 'pdf', className: 'btn btn-success' },
                    { extend: 'print', className: 'btn btn-success' }
                ];
             case 'Admin':
                return [
                    { extend: 'csv', className: 'btn btn-success' },
                    { extend: 'excel', className: 'btn btn-success' },
                    { extend: 'pdf', className: 'btn btn-success' },
                    { extend: 'print', className: 'btn btn-success' }
                ];    
            case 'CRM Support':
                return [
                    { extend: 'csv', className: 'btn btn-success' },
                    { extend: 'excel', className: 'btn btn-success' },
                    { extend: 'pdf', className: 'btn btn-success' },
                    { extend: 'print', className: 'btn btn-success' }
                ];    
            default:
                return [];
        }
    }
});



 </script>
@endsection