@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])

@section('content')
@include('layouts.navbars.auth.topnav', ['title' => ''])
<div class="container-fluid py-4">
  @php
            $waitApprovalPr = $dashboardPurchasing['wait_approval_pr'] ?? [];
            $outstandingPrCode = $dashboardPurchasing['outstanding_pr_code'] ?? [];
            $outstandingPrNon = $dashboardPurchasing['outstanding_pr_non'] ?? [];
            $waitApprovalPoPurch = $dashboardPurchasing['wait_approval_po_purch'] ?? [];
            $waitApprovalPoDir = $dashboardPurchasing['wait_approval_po_dir'] ?? [];
            $outstandingPo = $dashboardPurchasing['outstanding_po'] ?? [];

            $bsartList = ['ZR15', 'ZR16', 'ZR17'];
        @endphp

        <div class="row mt-4">
            <div class="col-12">
                <div class="card mb-4 shadow-sm">
                    <div class="card-header p-3 d-flex flex-wrap align-items-center justify-content-between gap-2">
                        <h6 class="mb-0">Monitoring PO Purchasing</h6>
                    </div>

                    <div class="card-body px-3 pt-0 pb-3">
                        <div class="table-responsive">
                            <table class="table table-bordered align-items-center mb-0 text-center">
                                <thead style="background-color: #b8ecec;">
                                    <tr>
                                        <th rowspan="2"
                                            class="text-center align-middle text-uppercase text-secondary text-xs font-weight-bolder opacity-7">
                                            Document Type
                                        </th>
                                        <th colspan="1"
                                            class="text-center align-middle text-uppercase text-secondary text-xs font-weight-bolder opacity-7">
                                            Wait Approval PR
                                        </th>
                                        <th colspan="2"
                                            class="text-center align-middle text-uppercase text-secondary text-xs font-weight-bolder opacity-7">
                                            Outstanding PR
                                        </th>
                                        <th colspan="2"
                                            class="text-center align-middle text-uppercase text-secondary text-xs font-weight-bolder opacity-7">
                                            Wait Approval PO
                                        </th>
                                        <th colspan="1"
                                            class="text-center align-middle text-uppercase text-secondary text-xs font-weight-bolder opacity-7">
                                            Outstanding PO
                                        </th>
                                    </tr>

                                    <tr>
                                        <th
                                            class="text-center align-middle text-uppercase text-secondary text-xs font-weight-bolder opacity-7">
                                            Jumlah
                                        </th>
                                        <th
                                            class="text-center align-middle text-uppercase text-secondary text-xs font-weight-bolder opacity-7">
                                            With Code
                                        </th>
                                        <th
                                            class="text-center align-middle text-uppercase text-secondary text-xs font-weight-bolder opacity-7">
                                            Non Code
                                        </th>
                                        <th
                                            class="text-center align-middle text-uppercase text-secondary text-xs font-weight-bolder opacity-7">
                                            Purch
                                        </th>
                                        <th
                                            class="text-center align-middle text-uppercase text-secondary text-xs font-weight-bolder opacity-7">
                                            Director
                                        </th>
                                        <th
                                            class="text-center align-middle text-uppercase text-secondary text-xs font-weight-bolder opacity-7">
                                            PO / Line
                                        </th>
                                    </tr>
                                </thead>

                                <tbody>
                                    @foreach ($bsartList as $bsart)
                                        @php
                                            $prWait = $waitApprovalPr[$bsart] ?? ['jum' => 0, 'days' => 0];
                                            $prCode = $outstandingPrCode[$bsart] ?? ['jum' => 0, 'days' => 0];
                                            $prNon = $outstandingPrNon[$bsart] ?? ['jum' => 0, 'days' => 0];
                                            $poPurch = $waitApprovalPoPurch[$bsart] ?? ['po' => 0, 'line' => 0];
                                            $poDir = $waitApprovalPoDir[$bsart] ?? ['po' => 0, 'line' => 0];
                                            $poOs = $outstandingPo[$bsart] ?? ['po' => 0, 'line' => 0];
                                        @endphp

                                        <tr>
                                            <td class="text-center align-middle">
                                                <small class="text-muted">{{ $bsart }}</small>
                                            </td>

                                            <td class="text-center align-middle">
                                                <a href="{{ url('aps002?bsart=' . $bsart) }}"
                                                    class="text-decoration-none">
                                                    <div class="fw-bold">{{ $prWait['jum'] }}</div>
                                                    <small class="text-muted">{{ $prWait['days'] }} Hari</small>
                                                </a>
                                            </td>

                                            <td class="text-center align-middle">
                                                <a  href="{{ url('aps004?bsart=' . $bsart . '&type=code') }}"
                                                    class="text-decoration-none">
                                                    <div class="fw-bold">{{ $prCode['jum'] }}</div>
                                                    <small class="text-muted">{{ $prCode['days'] }} Hari</small>
                                                </a>
                                            </td>

                                            <td class="text-center align-middle">
                                                <a  href="{{ url('aps004?bsart=' . $bsart . '&type=non') }}"
                                                    class="text-decoration-none">
                                                    <div class="fw-bold">{{ $prNon['jum'] }}</div>
                                                    <small class="text-muted">{{ $prNon['days'] }} Hari</small>
                                                </a>
                                            </td>

                                            <td class="text-center align-middle">
                                                <a  href="{{ url('aps005?bsart=' . $bsart) }}"
                                                    class="text-decoration-none">
                                                    <div class="fw-bold">{{ $poPurch['po'] }}</div>
                                                    <small class="text-muted">{{ $poPurch['line'] }} Line</small>
                                                </a>
                                            </td>

                                            <td class="text-center align-middle">
                                                <a  href="{{ url('aps006?bsart=' . $bsart) }}"
                                                    class="text-decoration-none">
                                                    <div class="fw-bold">{{ $poDir['po'] }}</div>
                                                    <small class="text-muted">{{ $poDir['line'] }} Line</small>
                                                </a>
                                            </td>

                                            <td class="text-center align-middle">
                                                <a  href="{{ url('aps007?bsart=' . $bsart) }}"
                                                    class="text-decoration-none">
                                                    <div class="fw-bold">{{ $poOs['po'] }} PO</div>
                                                    <small class="text-muted">{{ $poOs['line'] }} Line</small>
                                                </a>
                                            </td>
                                        </tr>
                                    @endforeach

                                    @php
                                        $totalWaitPr = collect($waitApprovalPr)->sum('jum');
                                        $totalWaitPrDays = collect($waitApprovalPr)->sum('days');

                                        $totalPrCode = collect($outstandingPrCode)->sum('jum');
                                        $totalPrCodeDays = collect($outstandingPrCode)->sum('days');

                                        $totalPrNon = collect($outstandingPrNon)->sum('jum');
                                        $totalPrNonDays = collect($outstandingPrNon)->sum('days');

                                        $totalPoPurchPo = collect($waitApprovalPoPurch)->sum('po');
                                        $totalPoPurchLine = collect($waitApprovalPoPurch)->sum('line');

                                        $totalPoDirPo = collect($waitApprovalPoDir)->sum('po');
                                        $totalPoDirLine = collect($waitApprovalPoDir)->sum('line');

                                        $totalPoOsPo = collect($outstandingPo)->sum('po');
                                        $totalPoOsLine = collect($outstandingPo)->sum('line');
                                    @endphp

                                    <tr class="bg-light">
                                        <td class="text-center align-middle fw-bold">TOTAL</td>

                                        <td class="text-center align-middle">
                                            <div class="fw-bold">{{ $totalWaitPr }}</div>
                                            <small class="text-muted">{{ $totalWaitPrDays }} Hari</small>
                                        </td>

                                        <td class="text-center align-middle">
                                            <div class="fw-bold">{{ $totalPrCode }}</div>
                                            <small class="text-muted">{{ $totalPrCodeDays }} Hari</small>
                                        </td>

                                        <td class="text-center align-middle">
                                            <div class="fw-bold">{{ $totalPrNon }}</div>
                                            <small class="text-muted">{{ $totalPrNonDays }} Hari</small>
                                        </td>

                                        <td class="text-center align-middle">
                                            <div class="fw-bold">{{ $totalPoPurchPo }}</div>
                                            <small class="text-muted">{{ $totalPoPurchLine }} Line</small>
                                        </td>

                                        <td class="text-center align-middle">
                                            <div class="fw-bold">{{ $totalPoDirPo }}</div>
                                            <small class="text-muted">{{ $totalPoDirLine }} Line</small>
                                        </td>

                                        <td class="text-center align-middle">
                                            <div class="fw-bold">{{ $totalPoOsPo }} PO</div>
                                            <small class="text-muted">{{ $totalPoOsLine }} Line</small>
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>

      <script src="{{ asset('assets/js/Sticky/jquery.stickytableheaders.js') }}"></script>
      <script>
        $(document).ready(function() {
          $('#my-table').stickyTableHeaders();
        });
      </script>

  </div>
</div>
@endsection