@extends('layouts.index')
@section('title')
Program
@endsection
@section('css')
<link href="{{ asset('back') }}/extra-libs/datatables.net-bs4/css/dataTables.bootstrap4.css" rel="stylesheet" />
<link rel="stylesheet" type="text/css" href="{{ asset('back') }}/libs/quill/dist/quill.snow.css" />
<style>
    label.error {
        color: #F94687;
        font-size: 13px;
        font-size: .875rem;
        font-weight: 400;
        line-height: 1.5;
        margin-top: 5px;
        padding: 0;
    }

    input.error {
        color: #F94687;
        border: 1px solid #F94687;
    }
</style>
@endsection
@section('content')
<div class="page-titles">
    <div class="row">
        <div class="col-lg-8 col-md-6 col-12 align-self-center">
            <nav aria-label="breadcrumb">
                <ol class="breadcrumb mb-0 d-flex align-items-center">
                    <li class="breadcrumb-item">
                        <a href="{{ url('home') }}" class="link"><i class="ri-home-3-line fs-5"></i></a>
                    </li>
                    <li class="breadcrumb-item active" aria-current="page">
                        Program
                    </li>
                </ol>
            </nav>
            <h1 class="mb-0 fw-bold">Program</h1>
        </div>
    </div>
</div>
<!-- ============================================================== -->
<!-- End Bread crumb and right sidebar toggle -->
<!-- ============================================================== -->
<!-- ============================================================= -->
<!-- Container fluid  -->
<!-- ============================================================= -->
<div class="container-fluid">
    <!-- ============================================================= -->
    <!-- Start Page Content -->
    <!-- ============================================================= -->
    <div class="row">
        <!-- Column -->
        <div class="col-lg-12 col-xl-12 col-md-12">
            <div class="card">
                <div class="card-body">
                    <div class="d-flex no-block align-items-center mb-4">
                        <h4>List of Program</h4>

                        @hasanyrole('admin|program_leader')
                        <div class="ms-auto">
                            <div class="btn-group">
                                <a href="{{ route('program.create') }}" class="
                      btn btn-primary
                      font-weight-medium
                      rounded-pill
                      px-4
                    " aria-controls="offcanvasRight">
                                    <i class="fa fa-plus"></i> Add Program
                                </a>
                            </div>
                        </div>
                        @endhasanyrole
                    </div>
                    <ul class="nav nav-pills p-3 bg-white border mb-3 align-items-center">
                        <li class="nav-item">
                            <a href="javascript:void(0)" class="
                              nav-link
                              rounded-pill
                              note-link
                              d-flex
                              align-items-center
                              justify-content-center
                              active
                              px-3 px-md-3
                              me-0 me-md-2
                            " id="initiation" onclick="programType('initiation')">
                                <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"
                                    fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round"
                                    stroke-linejoin="round"
                                    class="feather feather-list feather-sm fill-white me-0 me-md-1">
                                    <line x1="8" y1="6" x2="21" y2="6"></line>
                                    <line x1="8" y1="12" x2="21" y2="12"></line>
                                    <line x1="8" y1="18" x2="21" y2="18"></line>
                                    <line x1="3" y1="6" x2="3" y2="6"></line>
                                    <line x1="3" y1="12" x2="3" y2="12"></line>
                                    <line x1="3" y1="18" x2="3" y2="18"></line>
                                </svg><span class="d-none d-md-block font-weight-medium">Initiation</span></a>
                        </li>
                        <li class="nav-item">
                            <a href="javascript:void(0)" class="
                                nav-link
                                rounded-pill
                                note-link
                                d-flex
                                align-items-center
                                justify-content-center
                                px-3 px-md-3
                                me-0 me-md-2
                              " id="formulation-part" onclick="programType('formulation')">
                                <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"
                                    fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round"
                                    stroke-linejoin="round"
                                    class="feather feather-briefcase feather-sm fill-white me-0 me-md-1">
                                    <rect x="2" y="7" width="20" height="14" rx="2" ry="2"></rect>
                                    <path d="M16 21V5a2 2 0 0 0-2-2h-4a2 2 0 0 0-2 2v16"></path>
                                </svg><span class="d-none d-md-block font-weight-medium">Formulation</span></a>
                        </li>
                    </ul>

                    <div class="tab-content">
                        <div id="note-full-container" class="note-has-grid row">
                            <div class="col-md-12 single-note-item initiation">
                                <div class="card card-body">
                                    <ul class="nav nav-pills" role="tablist">
                                        <li class="nav-item">
                                            <a class="nav-link active" data-bs-toggle="tab" href="#all-program" role="tab">
                                                <span>All Program</span>
                                            </a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link" data-bs-toggle="tab" href="#reviewed" role="tab">
                                                <span>Reviewed</span>
                                            </a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link" data-bs-toggle="tab" href="#approved" role="tab">
                                                <span>Approved</span>
                                            </a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link" data-bs-toggle="tab" href="#rejected" role="tab">
                                                <span>Rejected</span>
                                            </a>
                                        </li>
                                    </ul>

                                    <div class="tab-content border mt-3">
                                        <div class="tab-pane active p-3" id="all-program" role="tabpanel">
                                            <table class="table" id="programTable">
                                                <thead>
                                                    <tr>
                                                        <th scope="col" class="px-0 text-muted">No</th>
                                                        <th scope="col" class="px-0 text-muted">Title</th>
                                                        <th scope="col" class="px-0 text-muted">Date Start</th>
                                                        <th scope="col" class="px-0 text-muted">Deadline</th>
                                                        <th scope="col" class="px-0 text-muted">PIC</th>
                                                        <th scope="col" class="px-0 text-muted">Assignee</th>
                                                        <th scope="col" class="px-0 text-muted">Approval</th>
                                                        <th>Action</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @php
                                                    $increment = 1;
                                                    @endphp

                                                    @foreach($all_program_initiation as $data)
                                                    <tr>
                                                        <td>{{ $increment++ }}</td>
                                                        <td>
                                                            {{ $data->name }}
                                                            <br><br>
                                                            @php
                                                                $totalPrograms = \App\Models\ProgramFmlActioPlan::where('program_formulation_id', $data->id)->count();

                                                                if ($totalPrograms >= 1) {
                                                                    $completedPrograms = \App\Models\ProgramFormulation::whereHas('action_plan', function ($q) {
                                                                        $q->whereHas("activity", function ($s) {
                                                                            $s->where('status', '=', 'verified');
                                                                        });
                                                                    })->where('id', $data->id)->count();

                                                                    // Calculate the percentage of completed programs
                                                                    $completionPercentage = ($completedPrograms / $totalPrograms) * 100;

                                                                    // Round the percentage to 2 decimal places
                                                                    $total_progress = round($completionPercentage, 2);
                                                                } else {
                                                                    $total_progress = 0;
                                                                }
                                                            @endphp
                                                            <div class="progress" style="height: 10px">
                                                                <div class="progress-bar {{ $total_progress < 60 ? 'bg-warning' : 'bg-success' }}" style="width: {{ $total_progress }}%" role="progressbar">
                                                                  {{ $total_progress }}%
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>{{ $data->start_date != "" ? $data->start_date : '-' }}</td>
                                                        <td>{{ $data->end_date != "" ? $data->end_date : '-' }}</td>
                                                        <td>
                                                           @if(isset($data->user->photos) && Storage::exists($data->user->photos))
                                                            <img src="{{ Storage::url($data->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                            {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                           @else
                                                            <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                            {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                           @endif
                                                        </td>
                                                        <td>
                                                            <div class="d-flex">
                                                                @foreach($data->team_limit as $item)
                                                                    @if(Storage::exists($item->pegawai->user->photos))
                                                                        <img src="{{ Storage::url($item->pegawai->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                        
                                                                        @if($data->team->count() > 4)
                                                                            @if ($loop->last)
                                                                            <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                            @endif
                                                                        @endif

                                                                        @else
                                                                    
                                                                            <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                            @if($data->team->count() > 4)
                                                                                @if ($loop->last)
                                                                                <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                                @endif
                                                                            @endif
                                                                    
                                                                        @endif
                                                                @endforeach
                                                            </div>
                                                            <div class="d-block mt-1">
                                                                <p>Total Assigne : {{ $data->team->count() }} </p>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            @if($data->progress_status == 'approved')
                                                            <span
                                                                class="badge bg-light-primary text-primary font-weight-medium">{{ ucwords($data->progress_status) }}</span>
                                                            @elseif($data->progress_status == 'rejected')
                                                            <span
                                                                class="badge bg-light-danger text-danger font-weight-medium">{{ ucwords($data->progress_status) }}</span>
                                                            @elseif($data->progress_status == '')
                                                            <span
                                                                class="badge bg-light-secondary text-secondary font-weight-medium">Reviewed</span>
                                                            @endif
                                                        </td>
                                                        
                                                        <td>
                                                            <a href="{{ url('program', $data->id) }}"
                                                                class="btn btn-outline-primary">Detail</a>
                                                        </td>
                                                    </tr>
                                                    @endforeach

                                                </tbody>
                                            </table>
                                        </div>
                                        <div class="tab-pane p-3" id="rejected" role="tabpanel">
                                            <table class="table" id="rejectedTable">
                                                <thead>
                                                    <tr>
                                                        <th scope="col" class="px-0 text-muted">No</th>
                                                        <th scope="col" class="px-0 text-muted">Title</th>
                                                        <th scope="col" class="px-0 text-muted">Date Start</th>
                                                        <th scope="col" class="px-0 text-muted">Deadline</th>
                                                        <th scope="col" class="px-0 text-muted">PIC</th>
                                                        <th scope="col" class="px-0 text-muted">Assignee</th>
                                                        <th scope="col" class="px-0 text-muted">Approval</th>
                                                        <th>Action</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @php
                                                    $increment = 1;
                                                    @endphp


                                                    @foreach($rejected_program_initiation as $data)
                                                    <tr>
                                                        <td>{{ $increment++ }}</td>
                                                        <td>
                                                            {{ $data->name }}
                                                            <br><br>
                                                            @php
                                                                $totalPrograms = \App\Models\ProgramFmlActioPlan::where('program_formulation_id', $data->id)->count();

                                                                if ($totalPrograms >= 1) {
                                                                    $completedPrograms = \App\Models\ProgramFormulation::whereHas('action_plan', function ($q) {
                                                                        $q->whereHas("activity", function ($s) {
                                                                            $s->where('status', '=', 'verified');
                                                                        });
                                                                    })->where('id', $data->id)->count();

                                                                    // Calculate the percentage of completed programs
                                                                    $completionPercentage = ($completedPrograms / $totalPrograms) * 100;

                                                                    // Round the percentage to 2 decimal places
                                                                    $total_progress = round($completionPercentage, 2);
                                                                } else {
                                                                    $total_progress = 0;
                                                                }
                                                            @endphp
                                                            <div class="progress" style="height: 10px">
                                                                <div class="progress-bar {{ $total_progress < 60 ? 'bg-warning' : 'bg-success' }}" style="width: {{ $total_progress }}%" role="progressbar">
                                                                  {{ $total_progress }}%
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>{{ $data->start_date != "" ? $data->start_date : '-' }}</td>
                                                        <td>{{ $data->end_date != "" ? $data->end_date : '-' }}</td>
                                                        <td>
                                                            @if(isset($data->user->photos) && Storage::exists($data->user->photos))
                                                             <img src="{{ Storage::url($data->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @else
                                                             <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @endif
                                                        </td>  
                                                        <td>
                                                            <div class="d-flex">
                                                                @foreach($data->team_limit as $item)
                                                                    @if(Storage::exists($item->pegawai->user->photos))
                                                                        <img src="{{ Storage::url($item->pegawai->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                        
                                                                        @if($data->team->count() > 4)
                                                                            @if ($loop->last)
                                                                            <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                            @endif
                                                                        @endif

                                                                        @else
                                                                    
                                                                            <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                            @if($data->team->count() > 4)
                                                                                @if ($loop->last)
                                                                                <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                                @endif
                                                                            @endif
                                                                    
                                                                        @endif
                                                                @endforeach
                                                            </div>
                                                            <div class="d-block mt-1">
                                                                <p>Total Assigne : {{ $data->team->count() }} </p>
                                                            </div>
                                                        </td>                                                      
                                                        <td>
                                                            @if($data->progress_status == 'approved')
                                                            <span
                                                                class="badge bg-light-primary text-primary font-weight-medium">{{ ucwords($data->progress_status) }}</span>
                                                            @elseif($data->progress_status == 'rejected')
                                                            <span
                                                                class="badge bg-light-danger text-danger font-weight-medium">{{ ucwords($data->progress_status) }}</span>
                                                            @elseif($data->progress_status == '')
                                                            <span
                                                                class="badge bg-light-secondary text-secondary font-weight-medium">Reviewed</span>
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <a href="{{ url('program', $data->id) }}"
                                                                class="btn btn-outline-primary">Detail</a>
                                                        </td>
                                                    </tr>
                                                    @endforeach

                                                </tbody>
                                            </table>

                                        </div>
                                        <div class="tab-pane p-3" id="approved" role="tabpanel">
                                            <table class="table" id="approvedTable">
                                                <thead>
                                                    <tr>
                                                        <th scope="col" class="px-0 text-muted">No</th>
                                                        <th scope="col" class="px-0 text-muted">Title</th>
                                                        <th scope="col" class="px-0 text-muted">Date Start</th>
                                                        <th scope="col" class="px-0 text-muted">Deadline</th>
                                                        <th scope="col" class="px-0 text-muted">PIC</th>
                                                        <th scope="col" class="px-0 text-muted">Assignee</th>
                                                        <th scope="col" class="px-0 text-muted">Approval</th>
                                                        <th>Action</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @php
                                                    $increment = 1;
                                                    @endphp


                                                    @foreach($approved_program_initiation as $data)
                                                    <tr>
                                                        <td>{{ $increment++ }}</td>
                                                        <td>
                                                            {{ $data->name }}
                                                            <br><br>
                                                            @php
                                                                $totalPrograms = \App\Models\ProgramFmlActioPlan::where('program_formulation_id', $data->id)->count();

                                                                if ($totalPrograms >= 1) {
                                                                    $completedPrograms = \App\Models\ProgramFormulation::whereHas('action_plan', function ($q) {
                                                                        $q->whereHas("activity", function ($s) {
                                                                            $s->where('status', '=', 'verified');
                                                                        });
                                                                    })->where('id', $data->id)->count();

                                                                    // Calculate the percentage of completed programs
                                                                    $completionPercentage = ($completedPrograms / $totalPrograms) * 100;

                                                                    // Round the percentage to 2 decimal places
                                                                    $total_progress = round($completionPercentage, 2);
                                                                } else {
                                                                    $total_progress = 0;
                                                                }
                                                            @endphp
                                                            <div class="progress" style="height: 10px">
                                                                <div class="progress-bar {{ $total_progress < 60 ? 'bg-warning' : 'bg-success' }}" style="width: {{ $total_progress }}%" role="progressbar">
                                                                  {{ $total_progress }}%
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>{{ $data->start_date != "" ? $data->start_date : '-' }}</td>
                                                        <td>{{ $data->end_date != "" ? $data->end_date : '-' }}</td>
                                                        <td>
                                                            @if(isset($data->user->photos) && Storage::exists($data->user->photos))
                                                             <img src="{{ Storage::url($data->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @else
                                                             <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <div class="d-flex">
                                                                @foreach($data->team_limit as $item)
                                                                    @if(Storage::exists($item->pegawai->user->photos))
                                                                        <img src="{{ Storage::url($item->pegawai->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                        
                                                                        @if($data->team->count() > 4)
                                                                            @if ($loop->last)
                                                                            <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                            @endif
                                                                        @endif

                                                                        @else
                                                                    
                                                                            <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                            @if($data->team->count() > 4)
                                                                                @if ($loop->last)
                                                                                <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                                @endif
                                                                            @endif
                                                                    
                                                                        @endif
                                                                @endforeach
                                                            </div>
                                                            <div class="d-block mt-1">
                                                                <p>Total Assigne : {{ $data->team->count() }} </p>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            @if($data->progress_status == 'approved')
                                                            <span
                                                                class="badge bg-light-primary text-primary font-weight-medium">{{ ucwords($data->progress_status) }}</span>
                                                            @elseif($data->progress_status == 'rejected')
                                                            <span
                                                                class="badge bg-light-danger text-danger font-weight-medium">{{ ucwords($data->progress_status) }}</span>
                                                            @elseif($data->progress_status == '')
                                                            <span
                                                                class="badge bg-light-secondary text-secondary font-weight-medium">Reviewed</span>
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <a href="{{ url('program', $data->id) }}"
                                                                class="btn btn-outline-primary">Detail</a>
                                                        </td>
                                                    </tr>
                                                    @endforeach
                                                </tbody>
                                            </table>
                                        </div>
                                        <div class="tab-pane p-3" id="reviewed" role="tabpanel">
                                            <table class="table" id="reviewedTable">
                                                <thead>
                                                    <tr>
                                                        <th scope="col" class="px-0 text-muted">No</th>
                                                        <th scope="col" class="px-0 text-muted">Title</th>
                                                        <th scope="col" class="px-0 text-muted">Date Start</th>
                                                        <th scope="col" class="px-0 text-muted">Deadline</th>
                                                        <th scope="col" class="px-0 text-muted">PIC</th>
                                                        <th scope="col" class="px-0 text-muted">Assignee</th>
                                                        <th scope="col" class="px-0 text-muted">Approval</th>
                                                        <th>Action</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @php
                                                    $increment = 1;
                                                    @endphp

                                                    @foreach($reviewed_program_initiation as $data)
                                                    <tr>
                                                        <td>{{ $increment++ }}</td>
                                                        <td>
                                                            {{ $data->name }}
                                                            <br><br>
                                                            @php
                                                                $totalPrograms = \App\Models\ProgramFmlActioPlan::where('program_formulation_id', $data->id)->count();

                                                                if ($totalPrograms >= 1) {
                                                                    $completedPrograms = \App\Models\ProgramFormulation::whereHas('action_plan', function ($q) {
                                                                        $q->whereHas("activity", function ($s) {
                                                                            $s->where('status', '=', 'verified');
                                                                        });
                                                                    })->where('id', $data->id)->count();

                                                                    // Calculate the percentage of completed programs
                                                                    $completionPercentage = ($completedPrograms / $totalPrograms) * 100;

                                                                    // Round the percentage to 2 decimal places
                                                                    $total_progress = round($completionPercentage, 2);
                                                                } else {
                                                                    $total_progress = 0;
                                                                }
                                                            @endphp
                                                            <div class="progress" style="height: 10px">
                                                                <div class="progress-bar {{ $total_progress < 60 ? 'bg-warning' : 'bg-success' }}" style="width: {{ $total_progress }}%" role="progressbar">
                                                                  {{ $total_progress }}%
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>{{ $data->start_date != "" ? $data->start_date : '-' }}</td>
                                                        <td>{{ $data->end_date != "" ? $data->end_date : '-' }}</td>
                                                        <td>
                                                            @if(isset($data->user->photos) && Storage::exists($data->user->photos))
                                                             <img src="{{ Storage::url($data->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @else
                                                             <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <div class="d-flex">
                                                                @foreach($data->team_limit as $item)
                                                                    @if(Storage::exists($item->pegawai->user->photos))
                                                                        <img src="{{ Storage::url($item->pegawai->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                        
                                                                        @if($data->team->count() > 4)
                                                                            @if ($loop->last)
                                                                            <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                            @endif
                                                                        @endif

                                                                        @else
                                                                    
                                                                            <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                            @if($data->team->count() > 4)
                                                                                @if ($loop->last)
                                                                                <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                                @endif
                                                                            @endif
                                                                    
                                                                        @endif
                                                                @endforeach
                                                            </div>
                                                            <div class="d-block mt-1">
                                                                <p>Total Assigne : {{ $data->team->count() }} </p>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <span
                                                                class="badge bg-light-secondary text-secondary font-weight-medium">Reviewed</span>
                                                        </td>
                                                        <td>
                                                            <a href="{{ url('program', $data->id) }}"
                                                                class="btn btn-outline-primary">Detail</a>
                                                        </td>
                                                    </tr>
                                                    @endforeach
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-12 formulation-part" style="display: none;">
                                <div class="card card-body">
                                    <ul class="nav nav-pills" role="tablist">
                                        <li class="nav-item">
                                            <a class="nav-link active" data-bs-toggle="tab" href="#all-program-formulation" role="tab">
                                                <span>All Program</span>
                                            </a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link" data-bs-toggle="tab" href="#reviewed-formulation" role="tab">
                                                <span>Reviewed</span>
                                            </a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link" data-bs-toggle="tab" href="#approved-formulation" role="tab">
                                                <span>Approved</span>
                                            </a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link" data-bs-toggle="tab" href="#rejected-formulation" role="tab">
                                                <span>Rejected</span>
                                            </a>
                                        </li>
                                    </ul>

                                    <div class="tab-content border mt-3">
                                        <div class="tab-pane active p-3" id="all-program-formulation" role="tabpanel">
                                            <table class="table" id="programTableFormulation">
                                                <thead>
                                                    <tr>
                                                        <th scope="col" class="px-0 text-muted">No</th>
                                                        <th scope="col" class="px-0 text-muted">Title</th>
                                                        <th scope="col" class="px-0 text-muted">Date Start</th>
                                                        <th scope="col" class="px-0 text-muted">Deadline</th>
                                                        <th scope="col" class="px-0 text-muted">PIC</th>
                                                        <th scope="col" class="px-0 text-muted">Assignee</th>
                                                        <th scope="col" class="px-0 text-muted">Approval</th>
                                                        <th>Action</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @php
                                                    $increment = 1;
                                                    @endphp

                                                    @foreach($all_program_formulation as $data)
                                                    <tr>
                                                        <td>{{ $increment++ }}</td>
                                                        <td>
                                                            {{ $data->name }}
                                                            <br><br>
                                                            @php
                                                                $totalPrograms = \App\Models\ProgramFmlActioPlan::where('program_formulation_id', $data->id)->count();

                                                                if ($totalPrograms >= 1) {
                                                                    $completedPrograms = \App\Models\ProgramFormulation::whereHas('action_plan', function ($q) {
                                                                        $q->whereHas("activity", function ($s) {
                                                                            $s->where('status', '=', 'verified');
                                                                        });
                                                                    })->where('id', $data->id)->count();

                                                                    // Calculate the percentage of completed programs
                                                                    $completionPercentage = ($completedPrograms / $totalPrograms) * 100;

                                                                    // Round the percentage to 2 decimal places
                                                                    $total_progress = round($completionPercentage, 2);
                                                                } else {
                                                                    $total_progress = 0;
                                                                }
                                                            @endphp
                                                            <div class="progress" style="height: 10px">
                                                                <div class="progress-bar {{ $total_progress < 60 ? 'bg-warning' : 'bg-success' }}" style="width: {{ $total_progress }}%" role="progressbar">
                                                                  {{ $total_progress }}%
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>{{ $data->start_date != "" ? $data->start_date : '-' }}</td>
                                                        <td>{{ $data->end_date != "" ? $data->end_date : '-' }}</td>
                                                        <td>
                                                            @if(isset($data->user->photos) && Storage::exists($data->user->photos))
                                                             <img src="{{ Storage::url($data->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @else
                                                             <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <div class="d-flex">
                                                                @foreach($data->team_limit as $item)
                                                                    @if(Storage::exists($item->pegawai->user->photos))
                                                                        <img src="{{ Storage::url($item->pegawai->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                        
                                                                        @if($data->team->count() > 4)
                                                                            @if ($loop->last)
                                                                            <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                            @endif
                                                                        @endif

                                                                        @else
                                                                    
                                                                            <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                            @if($data->team->count() > 4)
                                                                                @if ($loop->last)
                                                                                <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                                @endif
                                                                            @endif
                                                                    
                                                                        @endif
                                                                @endforeach
                                                            </div>
                                                            <div class="d-block mt-1">
                                                                <p>Total Assigne : {{ $data->team->count() }} </p>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            @if($data->progress_status == 'approved')
                                                            <span
                                                                class="badge bg-light-primary text-primary font-weight-medium">{{ ucwords($data->progress_status) }}</span>
                                                            @elseif($data->progress_status == 'rejected')
                                                            <span
                                                                class="badge bg-light-danger text-danger font-weight-medium">{{ ucwords($data->progress_status) }}</span>
                                                            @elseif($data->progress_status == '')
                                                            <span
                                                                class="badge bg-light-secondary text-secondary font-weight-medium">Reviewed</span>
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <a href="{{ url('program', $data->id) }}"
                                                                class="btn btn-outline-primary">Detail</a>
                                                        </td>
                                                    </tr>
                                                    @endforeach

                                                </tbody>
                                            </table>
                                        </div>
                                        <div class="tab-pane p-3" id="rejected-formulation" role="tabpanel">
                                            <table class="table" id="rejectedTableFormulation">
                                                <thead>
                                                    <tr>
                                                        <th scope="col" class="px-0 text-muted">No</th>
                                                        <th scope="col" class="px-0 text-muted">Title</th>
                                                        <th scope="col" class="px-0 text-muted">Date Start</th>
                                                        <th scope="col" class="px-0 text-muted">Deadline</th>
                                                        <th scope="col" class="px-0 text-muted">PIC</th>
                                                        <th scope="col" class="px-0 text-muted">Assignee</th>
                                                        <th scope="col" class="px-0 text-muted">Approval</th>
                                                        <th>Action</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @php
                                                    $increment = 1;
                                                    @endphp


                                                    @foreach($rejected_program_formulation as $data)
                                                    <tr>
                                                        <td>{{ $increment++ }}</td>
                                                        <td>
                                                            {{ $data->name }}
                                                            <br><br>
                                                            @php
                                                                $totalPrograms = \App\Models\ProgramFmlActioPlan::where('program_formulation_id', $data->id)->count();

                                                                if ($totalPrograms >= 1) {
                                                                    $completedPrograms = \App\Models\ProgramFormulation::whereHas('action_plan', function ($q) {
                                                                        $q->whereHas("activity", function ($s) {
                                                                            $s->where('status', '=', 'verified');
                                                                        });
                                                                    })->where('id', $data->id)->count();

                                                                    // Calculate the percentage of completed programs
                                                                    $completionPercentage = ($completedPrograms / $totalPrograms) * 100;

                                                                    // Round the percentage to 2 decimal places
                                                                    $total_progress = round($completionPercentage, 2);
                                                                } else {
                                                                    $total_progress = 0;
                                                                }
                                                            @endphp
                                                            <div class="progress" style="height: 10px">
                                                                <div class="progress-bar {{ $total_progress < 60 ? 'bg-warning' : 'bg-success' }}" style="width: {{ $total_progress }}%" role="progressbar">
                                                                  {{ $total_progress }}%
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>{{ $data->start_date != "" ? $data->start_date : '-' }}</td>
                                                        <td>{{ $data->end_date != "" ? $data->end_date : '-' }}</td>
                                                        <td>
                                                            @if(isset($data->user->photos) && Storage::exists($data->user->photos))
                                                             <img src="{{ Storage::url($data->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @else
                                                             <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <div class="d-flex">
                                                                @foreach($data->team_limit as $item)
                                                                    @if(Storage::exists($item->pegawai->user->photos))
                                                                        <img src="{{ Storage::url($item->pegawai->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                        
                                                                        @if($data->team->count() > 4)
                                                                            @if ($loop->last)
                                                                            <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                            @endif
                                                                        @endif

                                                                        @else
                                                                    
                                                                            <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                            @if($data->team->count() > 4)
                                                                                @if ($loop->last)
                                                                                <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                                @endif
                                                                            @endif
                                                                    
                                                                        @endif
                                                                @endforeach
                                                            </div>
                                                            <div class="d-block mt-1">
                                                                <p>Total Assigne : {{ $data->team->count() }} </p>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            @if($data->progress_status == 'approved')
                                                            <span
                                                                class="badge bg-light-primary text-primary font-weight-medium">{{ ucwords($data->progress_status) }}</span>
                                                            @elseif($data->progress_status == 'rejected')
                                                            <span
                                                                class="badge bg-light-danger text-danger font-weight-medium">{{ ucwords($data->progress_status) }}</span>
                                                            @elseif($data->progress_status == '')
                                                            <span
                                                                class="badge bg-light-secondary text-secondary font-weight-medium">Reviewed</span>
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <a href="{{ url('program', $data->id) }}"
                                                                class="btn btn-outline-primary">Detail</a>
                                                        </td>
                                                    </tr>
                                                    @endforeach

                                                </tbody>
                                            </table>

                                        </div>
                                        <div class="tab-pane p-3" id="approved-formulation" role="tabpanel">
                                            <table class="table" id="approvedTableFormulation">
                                                <thead>
                                                    <tr>
                                                        <th scope="col" class="px-0 text-muted">No</th>
                                                        <th scope="col" class="px-0 text-muted">Title</th>
                                                        <th scope="col" class="px-0 text-muted">Date Start</th>
                                                        <th scope="col" class="px-0 text-muted">Deadline</th>
                                                        <th scope="col" class="px-0 text-muted">PIC</th>
                                                        <th scope="col" class="px-0 text-muted">Assignee</th>
                                                        <th scope="col" class="px-0 text-muted">Approval</th>
                                                        <th>Action</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @php
                                                    $increment = 1;
                                                    @endphp


                                                    @foreach($approved_program_formulation as $data)
                                                    <tr>
                                                        <td>{{ $increment++ }}</td>
                                                        <td>
                                                            {{ $data->name }}
                                                            <br><br>
                                                            @php
                                                                $totalPrograms = \App\Models\ProgramFmlActioPlan::where('program_formulation_id', $data->id)->count();

                                                                if ($totalPrograms >= 1) {
                                                                    $completedPrograms = \App\Models\ProgramFormulation::whereHas('action_plan', function ($q) {
                                                                        $q->whereHas("activity", function ($s) {
                                                                            $s->where('status', '=', 'verified');
                                                                        });
                                                                    })->where('id', $data->id)->count();

                                                                    // Calculate the percentage of completed programs
                                                                    $completionPercentage = ($completedPrograms / $totalPrograms) * 100;

                                                                    // Round the percentage to 2 decimal places
                                                                    $total_progress = round($completionPercentage, 2);
                                                                } else {
                                                                    $total_progress = 0;
                                                                }
                                                            @endphp
                                                            <div class="progress" style="height: 10px">
                                                                <div class="progress-bar {{ $total_progress < 60 ? 'bg-warning' : 'bg-success' }}" style="width: {{ $total_progress }}%" role="progressbar">
                                                                  {{ $total_progress }}%
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>{{ $data->start_date != "" ? $data->start_date : '-' }}</td>
                                                        <td>{{ $data->end_date != "" ? $data->end_date : '-' }}</td>
                                                        <td>
                                                            @if(isset($data->user->photos) && Storage::exists($data->user->photos))
                                                             <img src="{{ Storage::url($data->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @else
                                                             <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <div class="d-flex">
                                                                @foreach($data->team_limit as $item)
                                                                    @if(Storage::exists($item->pegawai->user->photos))
                                                                        <img src="{{ Storage::url($item->pegawai->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                        
                                                                        @if($data->team->count() > 4)
                                                                            @if ($loop->last)
                                                                            <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                            @endif
                                                                        @endif

                                                                        @else
                                                                    
                                                                            <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                            @if($data->team->count() > 4)
                                                                                @if ($loop->last)
                                                                                <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                                @endif
                                                                            @endif
                                                                    
                                                                        @endif
                                                                @endforeach
                                                            </div>
                                                            <div class="d-block mt-1">
                                                                <p>Total Assigne : {{ $data->team->count() }} </p>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            @if($data->progress_status == 'approved')
                                                            <span
                                                                class="badge bg-light-primary text-primary font-weight-medium">{{ ucwords($data->progress_status) }}</span>
                                                            @elseif($data->progress_status == 'rejected')
                                                            <span
                                                                class="badge bg-light-danger text-danger font-weight-medium">{{ ucwords($data->progress_status) }}</span>
                                                            @elseif($data->progress_status == '')
                                                            <span
                                                                class="badge bg-light-secondary text-secondary font-weight-medium">Reviewed</span>
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <a href="{{ url('program', $data->id) }}"
                                                                class="btn btn-outline-primary">Detail</a>
                                                        </td>
                                                    </tr>
                                                    @endforeach
                                                </tbody>
                                            </table>
                                        </div>
                                        <div class="tab-pane p-3" id="reviewed-formulation" role="tabpanel">
                                            <table class="table" id="reviewedTableFormulation">
                                                <thead>
                                                    <tr>
                                                        <th scope="col" class="px-0 text-muted">No</th>
                                                        <th scope="col" class="px-0 text-muted">Title</th>
                                                        <th scope="col" class="px-0 text-muted">Date Start</th>
                                                        <th scope="col" class="px-0 text-muted">Deadline</th>
                                                        <th scope="col" class="px-0 text-muted">PIC</th>
                                                        <th scope="col" class="px-0 text-muted">Assignee</th>
                                                        <th scope="col" class="px-0 text-muted">Approval</th>
                                                        <th>Action</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @php
                                                    $increment = 1;
                                                    @endphp

                                                    @foreach($reviewed_program_formulation as $data)
                                                    <tr>
                                                        <td>{{ $increment++ }}</td>
                                                        <td>
                                                            {{ $data->name }}
                                                            <br><br>
                                                            @php
                                                                $totalPrograms = \App\Models\ProgramFmlActioPlan::where('program_formulation_id', $data->id)->count();

                                                                if ($totalPrograms >= 1) {
                                                                    $completedPrograms = \App\Models\ProgramFormulation::whereHas('action_plan', function ($q) {
                                                                        $q->whereHas("activity", function ($s) {
                                                                            $s->where('status', '=', 'verified');
                                                                        });
                                                                    })->where('id', $data->id)->count();

                                                                    // Calculate the percentage of completed programs
                                                                    $completionPercentage = ($completedPrograms / $totalPrograms) * 100;

                                                                    // Round the percentage to 2 decimal places
                                                                    $total_progress = round($completionPercentage, 2);
                                                                } else {
                                                                    $total_progress = 0;
                                                                }
                                                            @endphp
                                                            <div class="progress" style="height: 10px">
                                                                <div class="progress-bar {{ $total_progress < 60 ? 'bg-warning' : 'bg-success' }}" style="width: {{ $total_progress }}%" role="progressbar">
                                                                  {{ $total_progress }}%
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>{{ $data->start_date != "" ? $data->start_date : '-' }}</td>
                                                        <td>{{ $data->end_date != "" ? $data->end_date : '-' }}</td>
                                                        <td>
                                                            @if(isset($data->user->photos) && Storage::exists($data->user->photos))
                                                             <img src="{{ Storage::url($data->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @else
                                                             <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}" aria-label="{{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}">
                                                             {{ $data->person_in_charge_relation ? $data->person_in_charge_relation->nama_lengkap : '-'}}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <div class="d-flex">
                                                                @foreach($data->team_limit as $item)
                                                                    @if(Storage::exists($item->pegawai->user->photos))
                                                                        <img src="{{ Storage::url($item->pegawai->user->photos) }}" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                        
                                                                        @if($data->team->count() > 4)
                                                                            @if ($loop->last)
                                                                            <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                            @endif
                                                                        @endif

                                                                        @else
                                                                    
                                                                            <img src="{{ asset('back') }}/images/users/3.jpg" data-bs-toggle="tooltip" data-bs-placement="top" title="" class="rounded-circle p-1" width="35" height="38" data-bs-original-title="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}" aria-label="{{ $item->pegawai->nama_lengkap ? $item->pegawai->nama_lengkap : '-'}}">
                                                                            @if($data->team->count() > 4)
                                                                                @if ($loop->last)
                                                                                <a href="#"
                                                                                    class="
                                                                                    p-1
                                                                                    round-md
                                                                                    rounded-circle
                                                                                    d-flex
                                                                                    align-items-center
                                                                                    justify-content-center
                                                                                    bg-light-secondary
                                                                                    text-secondary
                                                                                    "
                                                                                    ><i data-feather="plus" class="feather-sm" style="width: 12px; height: 12px; font-weight: bold !important;"></i
                                                                                ><span style="font-size: 13px; font-weight: bold;">{{ $data->team->count() - 4 }}</span></a>
                                                                                @endif
                                                                            @endif
                                                                    
                                                                        @endif
                                                                @endforeach
                                                            </div>
                                                            <div class="d-block mt-1">
                                                                <p>Total Assigne : {{ $data->team->count() }} </p>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <span
                                                                class="badge bg-light-secondary text-secondary font-weight-medium">Reviewed</span>
                                                        </td>
                                                        <td>
                                                            <a href="{{ url('program', $data->id) }}"
                                                                class="btn btn-outline-primary">Detail</a>
                                                        </td>
                                                    </tr>
                                                    @endforeach
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                </div>
            </div>
        </div>
        <!-- Column -->
    </div>
    <!-- ============================================================= -->
    <!-- End PAge Content -->
    <!-- ============================================================= -->
</div>

{{-- 
<div class="offcanvas offcanvas-end" tabindex="-1" id="tambah" aria-labelledby="offcanvasRightLabel">
    <div class="offcanvas-header">
        <h5 class="offcanvas-title" id="offcanvasExampleLabel">
            Tambah Program
        </h5>
        <hr>
        <button type="button" class="btn-close text-reset" data-bs-dismiss="offcanvas" aria-label="Close"></button>
    </div>
    <div class="offcanvas-body">

        <form action="{{ route('ref-kategori-program.store') }}" method="POST" id="tambahForm">
@csrf
<div class="card">
    <div class="card-body">

        <div class="mb-3">
            <label for="formFile" class="form-label">Nama Kategori</label>
            <input type="text" name="nama" class="form-control" placeholder="Masukkan Nama Kategori">
        </div>

        <div class="mb-3">
            <label for="formFile" class="form-label">Status</label>
            <select class="form-select" name="status">
                <option value="Y">Aktif</option>
                <option value="T">Nonaktif</option>
            </select>
        </div>

        <div class="form-actions">
            <div class="card-body border-top">
                <button type="button" class="btn btn-outline-secondary rounded-pill px-4 ms-2"
                    data-bs-dismiss="offcanvas">
                    Batal
                </button>

                <button type="submit" class="btn btn-primary rounded-pill px-4" id="tambahModalButton">
                    <div class="d-flex align-items-center">
                        Simpan
                    </div>
                </button>
            </div>
        </div>
    </div>
</div>

</form>
</div>
</div>

<div class="offcanvas offcanvas-end" tabindex="-1" id="editModal" aria-labelledby="offcanvasRightLabel">
    <div class="offcanvas-header">
        <h5 class="offcanvas-title" id="offcanvasExampleLabel">
            Edit Program
        </h5>
        <hr>
        <button type="button" class="btn-close text-reset" data-bs-dismiss="offcanvas" aria-label="Close"></button>
    </div>
    <div class="offcanvas-body">

        <form action="{{ route('ref-kategori-program.update', '') }}" method="POST" id="editModalForm">
            @csrf
            @method('PUT')

            <input type="hidden" id="checkNama">
            <div class="card">
                <div class="card-body">

                    <div class="mb-3">
                        <label for="formFile" class="form-label">Nama Kategori Program</label>
                        <input type="text" name="edit_nama" class="form-control"
                            placeholder="Masukkan Nama Kategori Program">
                    </div>


                    <div class="mb-3">
                        <label for="formFile" class="form-label">Status</label>
                        <select class="form-select" name="edit_status">
                            <option value="Y">Aktif</option>
                            <option value="T">Nonaktif</option>
                        </select>
                    </div>



                    <div class="form-actions">
                        <div class="card-body border-top">
                            <button type="button" class="btn btn-outline-secondary rounded-pill px-4 ms-2"
                                data-bs-dismiss="offcanvas">
                                Batal
                            </button>

                            <button type="submit" class="btn btn-primary rounded-pill px-4" id="editModalButton">
                                <div class="d-flex align-items-center">
                                    Simpan
                                </div>
                            </button>
                        </div>
                    </div>
                </div>
            </div>

        </form>
    </div>
</div> --}}
@endsection
@section('js')
<!--This page plugins -->
<script src="{{ asset('back') }}/extra-libs/datatables.net/js/jquery.dataTables.min.js"></script>
<!-- start - This is for export functionality only -->
<script src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.flash.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.print.min.js"></script>
<script src="{{ asset('back') }}/js/pages/datatable/datatable-advanced.init.js"></script>
<script src="https://cdn.jsdelivr.net/npm/jquery-validation@1.19.3/dist/jquery.validate.js"></script>
<script src="{{ asset('back') }}/js/pages/notes/notes.js"></script>

<script>
    $(document).ready(function () {
        $('#programTable').DataTable();
        $('#rejectedTable').DataTable();
        $('#approvedTable').DataTable();
        $('#reviewedTable').DataTable();

        $('#programTableFormulation').DataTable();
        $('#rejectedTableFormulation').DataTable();
        $('#approvedTableFormulation').DataTable();
        $('#reviewedTableFormulation').DataTable();

        getStatusProgram();
    });

    function programType(value) {
        localStorage.setItem('status', value);
    }

    function getStatusProgram() {
        var statusData = localStorage.getItem('status');
        console.log(statusData);

        if(statusData == 'initiation') {
            $("#initiation").removeClass("active");
            $("#initiation").addClass("active");
            $(".formulation-part").css('display', 'none');
            $(".initiation").css('display', 'flex');
        } else if(statusData == 'formulation') {
            $("#initiation").removeClass("active");
            $("#formulation-part").removeClass("active");
            $("#formulation-part").addClass("active");
            $(".initiation").css('display', 'none');
            $(".formulation-part").css('display', 'flex');
        }
    }
</script>

<script>
    $(document).ready(function () {
        $.ajaxSetup({
            headers: {
                'X-CSRF-TOKEN': "{{ csrf_token() }}"
            }
        });
        $("#tambahForm").validate({
            rules: {
                nama: {
                    required: true,
                    remote: {
                        url: "{{ route('ref-kategori-program.check-nama') }}",
                        type: "post",
                    }
                },
                status: {
                    required: true,

                }
            },
            messages: {
                nama: {
                    required: "Nama harus di isi",
                    remote: "Nama sudah tersedia"
                },
                status: {
                    required: "Status harus di isi"
                }
            },
            submitHandler: function (form) {
                $("#tambahModalButton").prop('disabled', true);
                form.submit();
            }
        });
    });

    function validateEdit(dataId) {
        $("#editModalForm" + dataId).validate({
            rules: {
                edit_nama: {
                    required: true,
                    remote: {
                        param: {
                            url: "{{ route('ref-kategori-program.check-nama') }}",
                            type: "post",
                        },
                        depends: function (element) {
                            // compare name in form to hidden field
                            return ($(element).val() !== $('#checkNama').val());
                        },

                    }
                },
                edit_status: {
                    required: true
                }
            },
            messages: {
                edit_nama: {
                    required: "Nama harus di isi",
                    remote: "Nama sudah tersedia"
                },
                edit_status: {
                    required: "Status harus di isi"
                }
            },
            submitHandler: function (form) {
                $("#editModalButton").prop('disabled', true);
                form.submit();
            }
        });
    }
</script>

<script>
    function deleteData(id) {
        Swal.fire({
            title: "Hapus Ref. Program?",
            text: `Apakah kamu yakin untuk menghapus ref ini?`,
            icon: "warning",
            showCancelButton: !0,
            confirmButtonColor: "rgb(11, 42, 151)",
            cancelButtonColor: "rgb(209, 207, 207)",
            confirmButtonText: "Ya, hapus!",
            cancelButtonText: "Batal"
        }).then(function (t) {
            if (t.value) {
                $.ajax({
                    url: "{{ route('ref-kategori-program.hapus') }}",
                    method: "POST",
                    data: {
                        "_token": "{{ csrf_token() }}",
                        id: id
                    },
                    success: function (data) {
                        Swal.fire({
                            icon: 'success',
                            title: 'Berhasil',
                            text: 'Program telah berhasil dihapus!',
                        }).then(function () {
                            location.reload();
                        });
                    }
                });
            }
        })
    }
</script>

<script>
    const update = $('#editModalForm').attr('action');
    const idForm = $('#editModalForm').attr('id');

    function editData(data) {
        $('#editModalForm').attr('id', `${idForm}${data.id}`);
        $('#editModalForm' + data.id).attr('action', `${update}/${data.id}`);

        $('#checkNama').val(data.nama);

        $('[name="edit_nama"]').val(data.nama);
        $('[name="edit_status"]').val(data.status);

        validateEdit(data.id);
    }
</script>
@endsection