@extends('layouts.app')
@section('content')
@php
    $user= auth()->user();
@endphp

<section class="content">
    <div class="container-fluid">
        <div class="px-sm-4">
            <!-- <div class="row mt-2 mt-sm-3 justify-content-between align-items-center"> -->
                <!-- <div class="col-md-7">
                    <div class="top-head">
                        <h1>Credit Committee</h1>
                    </div>
                </div> -->

                <!-- <div class="col-md-5 col-4 text-right">
                    <a href="#">
                        <a href="{{url('/project-listing')}}" type="button" class="btn save-btn">Show All</a>
                    </a>
                </div>
            </div> -->


            <!-- New html -->
            <div class="row mt-2 mt-sm-3 align-items-center">
                        <div class="col-md-10">
                            <div class="d-sm-flex d-block align-items-center">
                                <div class="top-menuhome">
                                    <ul> 
                                        @php
                                        $permission = App\Helpers\CommonHelper::checkPermission($user, 'Home');
                                        @endphp

                                        @if($permission)
                                        <li><a href="{{url('/home')}}">Overview</a></li>
                                        @endif

                                        @php
                                        $permission = App\Helpers\CommonHelper::checkPermission($user, 'Financials');
                                        @endphp

                                        @if($permission)
                                        <li><a href="{{route('financial.home')}}">Financials</a></li>
                                        @endif

                                        @php
                                        $permission = App\Helpers\CommonHelper::checkPermission($user, 'Credit Committee');
                                        @endphp

                                        @if($permission)
                                        <li><a href="{{url('/credit-committee')}}">
                                                <div class="top-head">
                                                    <h1>Credit Committee</h1>
                                                </div>
                                            </a>
                                        </li>
                                        @endif
                                        <li><a href="{{route('investor.dashboard')}}">Investors</a></li>
                                    </ul>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2 col-3 text-right">
                            <a href="{{url('/project-listing')}}" type="button" class="btn save-btn">Show All</a>
                        </div>
                    </div>
                <!-- New HTML-->

            {{--<div class="row mt-sm-4 mt-3">
                <div class="col-md-12">
                    <div class="card">
                        <div class="row align-items-start">
                            <div class="col-md-8 col-9">
                                <div class="card-header border-0 pb-0">
                                    <h4 class="card-title float-none">Loan Applications: {{$totalLoans}}</h4>
                                </div>
                            </div>
                            <div class="col-md-4 col-3 text-right">
                                <div class="card-header border-0 pb-0">
                                    <!-- <img src="img/more.svg" class="three-dots" alt=""> -->
                                </div>
                            </div>
                        </div>

                        <div class="card-body pt-0">
                            <div class="row mt-sm-4 mt-3">
                                <div class="col-md-2 col-6 mb-3">
                                    <div class="loan-applicationsbox">
                                        <h6>{{$suggestedLoans}}</h6>
                                        <p>Suggested</p>
                                    </div>
                                </div>
                                <!-- <div class="col-md-2 col-6 mb-3">
                                    <div class="loan-applicationsbox active">
                                        <h6>{{0}}</h6>
                                        <p>Interested</p>
                                    </div>
                                </div> -->
                                <div class="col-md-2 col-6 mb-3">
                                    <div class="loan-applicationsbox active">
                                        <h6>{{$appliedLoans}}</h6>
                                        <p>Applied</p>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6 mb-3 ">
                                    <div class="loan-applicationsbox position-relative">
                                    <i class="fa fa-cc cc-icon" aria-hidden="true"></i>

                                        <h6>{{$docVerifiedLoans}}</h6>
                                        <p>KYC Verified</p>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6 mb-3">
                                    <div class="loan-applicationsbox active">
                                        <h6>{{$surveyRequestedLoans}}</h6>
                                        <p>Survey Pending</p>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6 mb-3">
                                    <div class="loan-applicationsbox">
                                        <h6>{{$surveyAcceptedLoans}}</h6>
                                        <p>Survey Accpeted</p>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6 mb-3 mb-sm-0">
                                    <div class="loan-applicationsbox active">
                                        <h6>{{$surveyCompletedLoans}}</h6>
                                        <p>Survey Completed</p>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6 mb-3 mb-sm-0">
                                    <div class="loan-applicationsbox active position-relative">
                                    <i class="fa fa-cc cc-icon" aria-hidden="true"></i>
                                        <h6>{{$verifiedLoans}}</h6>
                                        <p>Verified</p>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6 mb-3 mb-sm-0">
                                    <div class="loan-applicationsbox">
                                        <h6>{{$approvedLoans}}</h6>
                                        <p>Approved</p>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6 mb-3 mb-sm-0">
                                    <div class="loan-applicationsbox active">
                                        <h6>{{$activeLoans}}</h6>
                                        <p>Active</p>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6">
                                    <div class="loan-applicationsbox">
                                        <h6>{{$holdLoans}}</h6>
                                        <p>Hold</p>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6">
                                    <div class="loan-applicationsbox active">
                                        <h6>{{$completedLoans}}</h6>
                                        <p>Completed</p>
                                    </div>
                                </div>

                            </div>
                        </div>
                    </div>
                </div>
            </div>--}}
            <div class="row mt-sm-4 mt-3">
                <div class="col-md-12">
                    <div class="card">
                        <div class="row align-items-start">
                            <div class="col-md-8 col-9">
                                <div class="card-header border-0 pb-0">
                                    <h4 class="card-title float-none">Loan Applications: {{$appliedLoans + $docVerifiedLoans + $surveyReqLoans + $surveyAccLoans + $surveyCompLoans + $verifiedLoans + $approvedLoans}}</h4>
                                </div>
                            </div>
                            <div class="col-md-4 col-3 text-right">
                                <div class="card-header border-0 pb-0">
                                    <img src="img/more.svg" class="three-dots" alt="">
                                </div>
                            </div>
                        </div>

                        <div class="card-body pt-0">
                            <div class="row mt-sm-4 mt-3">
                                <div class="col-sm col-6 mb-sm-0 mb-3">
                                    <div class="loan-applicationsbox text-center">
                                        <h6>{{$appliedLoans}}</h6>
                                        <p>Applied</p>
                                        <small>(MCC to Verify Docs)</small>
                                    </div>
                                </div>
                                <div class="col-sm col-6 mb-sm-0 mb-3">
                                    <div class="loan-applicationsbox active text-center">
                                        <h6>{{$docVerifiedLoans}}</h6>
                                        <p>Doc Verified</p>
                                        <small>(CC to Pre-Approve)</small>
                                    </div>
                                </div>
                                <div class="col-sm col-6 mb-sm-0 mb-3">
                                    <div class="loan-applicationsbox text-center">
                                        <h6>{{$surveyReqLoans}}</h6>
                                        <p>Survey Requested</p>
                                        <small>(Supplier to Accept)</small>
                                    </div>
                                </div>
                                <div class="col-sm col-6 mb-sm-0 mb-3">
                                    <div class="loan-applicationsbox text-center">
                                        <h6>{{$surveyAccLoans}}</h6>
                                        <p>Survey Accepted</p>
                                        <small>(Survey in Progress)</small>
                                    </div>
                                </div>
                                <div class="col-sm col-6 mb-sm-0 mb-3">
                                    <div class="loan-applicationsbox text-center">
                                        <h6>{{$surveyCompLoans}}</h6>
                                        <p>Survey Completed</p>
                                        <small>(Farmer to Verify)</small>
                                    </div>
                                </div>
                                <div class="col-sm col-6">
                                    <div class="loan-applicationsbox active text-center">
                                        <h6>{{$verifiedLoans}}</h6>
                                        <p>Verified</p>
                                        <small>(CC to Final Approve)</small>
                                    </div>
                                </div>
                                <div class="col-sm col-6">
                                    <div class="loan-applicationsbox text-center">
                                        <h6>{{$approvedLoans}}</h6>
                                        <p>Approved</p>
                                        <small>(Farmer to Accept)</small>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="row mt-4">
                <div class="col-md-6 ">
                    <div class="card">
                        <div class="row align-items-start">
                            <div class="col-md-8 col-9">
                                <div class="card-header border-0 pb-0">
                                    <h4 class="card-title float-none">Suggested Projects</h4>
                                    <p class="card-titleinner">Total : {{$suggestedTotalProject}}</p>
                                    
                                </div>
                            </div>
                            <div class="col-md-4 col-3 text-right">
                                <div class="card-header border-0 pb-0">
                                    <a href="{{url('/project-listing')}}?status=suggested"><img
                                            src="{{asset('assets/img/more.svg')}}" class="three-dots" alt=""></a>
                                </div>
                            </div>
                        </div>

                        <div class="card-body pt-0">
                            <div class="row">
                                <div class="col-md-8 mb-3 mb-sm-0">
                                    <div class="row mt-3 align-items-end">
                                        <div class="col-md-6 col-6">
                                            <div class="suppliers-box">
                                                <span
                                                    class="badge target-achieved target-achieved2 d-flex align-items-center">
                                                    <span class="active-box active-boxcompleted"></span> Suggested:
                                                    <span> {{$suggestedProjects}}</span>
                                                </span>
                                                <span
                                                    class="badge target-achieved target-achieved3 d-flex align-items-center mt-2">
                                                    <span class="active-box active-boxcompleted2"></span> Interested:
                                                    <span> {{$interestedProject}}</span>
                                                </span>
                                            </div>
                                        </div>
                                        <div class="col-md-6 col-6">
                                            <div class="suppliers-box mt-3">
                                                <span
                                                    class="badge target-achieved target-achieved4 d-flex align-items-center">
                                                    <span class="active-box active-boxcompleted3"></span> Not
                                                    Interested:
                                                    <span> {{$notInteresetedProjects}}</span>
                                                </span>
                                            </div>
                                            <div class="suppliers-box">
                                                <span
                                                    class="badge target-achieved target-achieved1 d-flex align-items-center mt-2">
                                                    <span class="active-box"></span> Deferred:
                                                    <span> {{$deferredProject}}</span>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <div class="chart-content position-relative">
                                        <canvas id="zoneChart2" class="chart-margintop" width="100%" height="100px"></canvas>
                                            @if($suggestedTotalProject != 0)
                                            <p>{{round($interestedProject/$suggestedTotalProject * 100,1)}}%</p>
                                            @else
                                            <p>0%</p>
                                            @endif
                                            <h6>Interested</h6>
                                    </div>
                                </div>
                            </div>

                        </div>
                    </div>
                </div>
                <div class="col-md-6 ">
                    <div class="card">
                        <div class="row align-items-start">
                            <div class="col-md-8 col-9">
                                <div class="card-header border-0 pb-0">
                                    <h4 class="card-title float-none">Ongoing Projects</h4>
                                    <p class="card-titleinner">Total : {{$completedProject + $activeProject + $holdProject}}</p>
                                </div>
                            </div>
                            <div class="col-md-4 col-3 text-right">
                                <div class="card-header border-0 pb-0">
                                    <img src="{{asset('assets/img/more.svg')}}" class="three-dots" alt="">
                                </div>
                            </div>
                        </div>

                        <div class="card-body pt-0">
                            <div class="row">
                                <div class="col-md-8 mb-3 mb-sm-0">
                                    <div class="row mt-sm-4 mt-3 align-items-end">
                                        <div class="col-md-6 col-6 ">
                                            <div class="suppliers-box">
                                                <a href="{{url('/project-listing')}}?status=completed">
                                                    <span
                                                        class="badge target-achieved target-achieved2 mb-sm-2  d-flex align-items-center">
                                                        <span class="active-box active-boxcompleted"></span> Completed:
                                                        <span> {{$completedProject}}</span>
                                                    </span>
                                                </a>
                                                <a href="{{url('/project-listing')}}?status=active">
                                                    <span
                                                        class="badge target-achieved target-achieved3  d-flex align-items-center">
                                                        <span class="active-box active-boxcompleted2"></span> Active:
                                                        <span> {{$activeProject}}</span>
                                                    </span>
                                                </a>
                                            </div>
                                        </div>
                                        <div class="col-md-6 col-6">
                                            <div class="suppliers-box">
                                                <a href="{{url('/project-listing')}}?status=hold">
                                                    <span
                                                        class="badge target-achieved target-achieved4  d-flex align-items-center">
                                                        <span class="active-box active-boxcompleted3"></span> Hold:
                                                        <span> {{$holdProject}}</span>
                                                    </span>
                                                </a>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <div class="chart-content position-relative">
                                        <canvas id="zoneChart" class="chart-margintop" width="100%" height="100px"></canvas>
                                        @php
                                        $totalProject = $completedProject + $activeProject + $holdProject;
                                        @endphp
                                        @if($totalProject != 0)
                                        <p>{{round($completedProject/($completedProject + $activeProject + $holdProject) * 100,1)}}%</p>
                                        @else
                                        <p>0%</p>
                                        @endif
                                        <h6>Complete</h6>
                                    </div>  
                                </div>
                            </div>

                        </div>
                    </div>
                </div>
            </div>
            <div class="row mt-2 mt-sm-4">
                @php
                    $permission = App\Helpers\CommonHelper::checkPermission($user, 'Supplier');  
                @endphp
                <div class="col-md-6">
                    <div class="card">
                        <div class="row align-items-start">
                            <div class="col-md-8 col-9">
                                <div class="card-header border-0 pb-0">
                                    <h4 class="card-title float-none"> Suppliers({{$totalSupplier}}) </h4>
                                </div>
                            </div>
                            @if($permission)
                            <div class="col-md-4 col-3 text-right">
                                <div class="card-header border-0 pb-0">
                                    <a href="{{url('/suppliers')}}"> <img src="{{asset('assets/img/more.svg')}}"
                                            class="three-dots" alt=""> </a>
                                </div>
                            </div>
                            @endif
                        </div>

                        <div class="card-body pt-0">
                            <div class="row mt-2 mt-sm-3">
                                <a @if($permission) href="{{url('/suppliers')}}?status=active" @else href="" @endif>
                                    <div class="col-md-4 col-6"> 
                                        <div class="suppliers-box">
                                            <h6><span class="active-box"></span>Active: <b>{{$activeSupplier}}</b></h6>
                                        </div>
                                    </div>
                                </a>
                                <a @if($permission) href="{{url('/suppliers')}}?status=inactive" @else href="" @endif>
                                    <div class="col-md-4 col-6">
                                        <div class="suppliers-box">
                                            <h6><span class="active-box inactive-box"></span>Inactive:
                                                <b>{{$inactiveSupplier}}</b> </h6>
                                        </div>
                                    </div>
                                </a>
                            </div>

                            <div class="row mt-sm-4 mt-2">
                                <div class="col-md-12">
                                    <h5 class="new-kyctext">KYC Status</h5>
                                </div>
                            </div>

                            <div class="row align-items-center mt-3 mt-sm-4">
                                <div class="col-sm col-6">
                                    <div class="kyc-pendingbox pinkkyc-pendingbox text-center">
                                        <h5>{{$pendingSupplierKYC}}</h5>
                                        <h6>Pending</h6>
                                    </div>
                                </div>
                                <div class="col-sm col-6">
                                    <div class="kyc-pendingbox text-center">
                                        <h5>{{$appliedSupplierKYC}}</h5>
                                        <h6>Applied</h6>
                                    </div>
                                </div>
                    
                                <div class="col-sm col-6">
                                    <div class="kyc-pendingbox text-center">
                                        <h5>{{$verifiedSupplierKYC}}</h5>
                                        <h6>Verified</h6>
                                    </div>
                                </div>
                                <div class="col-sm col-6">
                                    <div class="kyc-pendingbox pinkkyc-pendingbox text-center">
                                        <h5>{{$rejectedSupplierKYC}}</h5>
                                        <h6>Rejected</h6>
                                    </div>
                                </div>
                                <div class="col-sm col-6">
                                    <div class="kyc-pendingbox text-center">
                                        <h5>{{$expiredSupplierKYC}}</h5>
                                        <h6>Expired</h6>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                @php
                    $permission = App\Helpers\CommonHelper::checkPermission($user, 'Farmers');  
                @endphp
                <div class="col-md-6">
                    <div class="card">
                        <div class="row align-items-start">
                            <div class="col-md-8 col-9">
                                <div class="card-header border-0 pb-0">
                                    <h4 class="card-title float-none"> Farmers({{$totalFarmers}}) </h4>
                                </div>
                            </div>
                            @if($permission)
                            <div class="col-md-4 col-3 text-right">
                                <div class="card-header border-0 pb-0">
                                    <a href="{{url('/farmers')}}"> <img src="{{asset('assets/img/more.svg')}}"
                                            class="three-dots" alt=""> </a>
                                </div>
                            </div>
                            @endif
                        </div>

                        <div class="card-body pt-0">
                            <div class="row mt-sm-3 mt-2">
                                <div class="col-md-4">
                                    <div class="suppliers-box">
                                        <a @if($permission) href="{{url('/farmers')}}?rag_rating=critical" @else href="" @endif>
                                            <h6><span class="active-box active-boxcompleted3"></span>Critical:
                                                <b>{{$criticalFarmers}}</b></h6>
                                        </a>
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <div class="suppliers-box">
                                        <a @if($permission) href="{{url('/farmers')}}?rag_rating=average" @else href="" @endif>
                                            <h6><span class="active-box active-boxcompleted2"></span>Average:
                                                <b>{{$averageFarmers}}</b> </h6>
                                        </a>
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <div class="suppliers-box">
                                        <a @if($permission) href="{{url('/farmers')}}?rag_rating=satisfactory" @else href="" @endif>
                                            <h6><span class="active-box"></span>Satisfactory:
                                                <b>{{$satisfactoryFarmers}}</b></h6>
                                        </a>
                                    </div>
                                </div>
                            </div>

                            <div class="row mt-sm-4 mt-2">
                                <div class="col-md-12">
                                    <h5 class="new-kyctext">KYC Status</h5>
                                </div>
                            </div>

                            <div class="row align-items-center mt-3 mt-sm-4">
                                <!-- <div class="col-md-4 mb-2 mb-sm-0">
                                            <h5 class="new-kyctext">KYC <br class="d-sm-block d-none"> Pending</h5>
                                        </div> -->
                                <div class="col-sm col-6">
                                    <div class="kyc-pendingbox pinkkyc-pendingbox text-center">
                                        <h5>{{$pendingFarmerKYC}}</h5>
                                        <h6>Pending</h6>
                                    </div>
                                </div>
                                <div class="col-sm col-6">
                                    <div class="kyc-pendingbox text-center">
                                        <h5>{{$appliedFarmerKYC}}</h5>
                                        <h6>Applied</h6>
                                    </div>
                                </div>
                                <div class="col-sm col-6">
                                    <div class="kyc-pendingbox text-center">
                                        <h5>{{$verifiedFarmerKYC}}</h5>
                                        <h6>Verified</h6>
                                    </div>
                                </div>
                                <div class="col-sm col-6">
                                    <div class="kyc-pendingbox pinkkyc-pendingbox text-center">
                                        <h5>{{$rejectedFarmerKYC}}</h5>
                                        <h6>Rejected</h6>
                                    </div>
                                </div>
                                <div class="col-sm col-6">
                                    <div class="kyc-pendingbox text-center">
                                        <h5>{{$expiredFarmerKYC}}</h5>
                                        <h6>Expired</h6>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
@endsection
@section('scripts')
<script>
    // Suggested Project Chart
    var suggestedProjects = 0;
    var notInteresetedProjects = 0;
    var interestedProject = 0;
    var deferredProject = 0;

    var s = document.getElementById('zoneChart2').getContext('2d');
    var zoneChart2 = new Chart(s, {
        type: 'doughnut',
        data: {
            labels: ['Suggested', 'Interested', 'Not Interested','Deferred'],
            datasets: [{
                data: [suggestedProjects, interestedProject, notInteresetedProjects, deferredProject],
                backgroundColor: [
                    '#6A0030',
                    '#F6B51D',
                    '#FC5E60',
                    '#4BC56F'
                ],
                hoverOffset: 1,
                
                borderWidth: 0
            }]
        },
        options: { 
            plugins: {
                legend: {
                display: false
                }
            }
        }
    });

    // Chart 2 
    var completedProject = 0;
    var activeProject = 0;
    var holdProject = 0;

    var s = document.getElementById('zoneChart').getContext('2d');
    var zoneChart = new Chart(s, {
        type: 'doughnut',
        data: {
            labels: ['Completed', 'Active', 'Hold',],
            datasets: [{
                data: [completedProject, activeProject, holdProject],
                backgroundColor: [
                    '#6A0030',
                    '#F6B51D',
                    '#FC5E60',
                   
                ],
                hoverOffset: 1,
                borderWidth: 0
            }]
        },
        options: { 
              plugins: {
                legend: {
                  display: false
                }
              }
          }
    });
</script>
@include('partials.calendar')

@endsection