@extends('layouts/microfin_layout')
@section('title', '| Periodical Progress Report')
@section('content')

    @include('microfin/reports/branchManagerReportViews/BranchManagerReportAjax')

    <style media="screen">
        .hide {
            display: none;
        }

        table tr td {
            padding: 3px !important;
        }

        .table-container {
            width: 100%;
            overflow-x: auto;
            -webkit-overflow-scrolling: touch;
        }

        .scrollable-table {
            width: 100%;
            table-layout: auto;
            border-collapse: collapse;
        }

        .scrollable-table th,
        .scrollable-table td {
            padding: 8px;
            border: 1px solid #ddd;
        }
    </style>

    <div class="container-fluid">

        <!-- Start of the Dropdown form -->
        <div class="row">
            <div class="col-md-12">
                <div class="" style="">
                    <div class="">
                        <div class="panel panel-default" style="background-color:#708090;">
                            <div class="panel-heading" style="padding-bottom:0px">
                                <div class="panel-options">
                                    {{-- <button id="excellIcon" class="btn btn-info pull-right print-icon"  target="_blank"
                                        style="">
                                        <i class="fa fa-print fa-lg" aria-hidden="true"> Excell</i>
                                    </button> --}}
                                </div>
                                <h3 style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">
                                    {{-- Periodical Progress Report --}}
                                </h3>
                            </div>

                            <div class="panel-body panelBodyView">

                            </div>
                            <div class="row table-container" id="reportingDiv">
                                <table id="depositColelctionTransactionReport" class="table table-bordered"
                                    border="1pt solid ash"
                                    style=" text-align: center; font-family: arial; color:black; border-collapse: collapse; font-size: 10px !important;"
                                    width="100%">
                                    <thead valign="center">
                                        <tr>
                                            <td style="min-width: 50px ">Sl No</td>
                                            <td style="min-width: 100px ">Branch</td>
                                            <td style="min-width: 80px ">Designation</td>
                                            <td style="min-width: 70px ">Employee Name</td>
                                            <td style="min-width: 60px">Joining Date</td>
                                            @foreach ($dateRange as $date)
                                                <td style="min-width: 45px">
                                                    {{ \Carbon\Carbon::parse($date)->format('d-M') }}</td>
                                            @endforeach
                                        </tr>

                                    </thead>
                                    <tbody>


                                        @foreach ($getCurrentOfficers as $key => $employeeCollection)
                                            @php

                                                $branchInfo = DB::table('gnr_branch')
                                                    ->select('branchCode', 'name')
                                                    ->where('id', $employeeCollection->branch_id_fk)
                                                    ->first();

                                                $employeepositionIdFk = DB::table('hr_emp_org_info')
                                                    ->where('emp_id_fk', $employeeCollection->emp_id_fk)
                                                    ->pluck('position_id_fk')
                                                    ->first();
                                                $employeeDesignation = DB::table('hr_settings_position')
                                                    ->where('id', $employeepositionIdFk)
                                                    ->pluck('name')
                                                    ->first();

                                                $employeeInfo = DB::table('hr_emp_general_info')
                                                    ->where('id', $employeeCollection->emp_id_fk)
                                                    ->select('emp_id', 'emp_name_english')
                                                    ->first();

                                                $employJoiningDate = DB::table('hr_emp_org_info')
                                                    ->where('emp_id_fk', $employeeCollection->emp_id_fk)
                                                    ->select('joining_date')
                                                    ->value('joining_date');

                                            @endphp
                                            <tr>
                                                <td>{{ $loop->iteration }}</td>
                                                <td style="text-align: left">
                                                    {{ str_pad($branchInfo->branchCode, 3, 0, STR_PAD_LEFT) }}-{{ $branchInfo->name }}
                                                <td>{{ $employeeDesignation }}</td>
                                                <td style="text-align: left">
                                                    {{ strtok($employeeInfo->emp_id, '-') }}-{{ $employeeInfo->emp_name_english }}
                                                <td style="text-align: left;">
                                                    {{ \Carbon\Carbon::parse($employJoiningDate)->format('Y-m-d') }}</td>

                                                @foreach ($dateRange as $date)
                                                    @php
                                                        // Format the date if needed to match actionDate format
                                                        $formattedDate = \Carbon\Carbon::parse($date)->format('Y-m-d');

                                                        // Get the data based on emp_id_fk, branch_id_fk, and actionDate
                                                        $data = optional(
                                                            $groupCollectionData[$employeeCollection->emp_id_fk][
                                                                $employeeCollection->branch_id_fk
                                                            ] ?? collect(),
                                                        )
                                                            ->where('actionDate', $formattedDate)
                                                            ->first();
                                                    @endphp

                                                    <!-- Display the status or 0 if data is not found -->
                                                    <td>{{ $data ? $data->status : 0 }}</td>
                                                @endforeach
                                            </tr>
                                        @endforeach

                                    </tbody>
                                </table>

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

    </div>

    <script type="text/javascript"></script>


@endsection