@extends('layouts.app')
@section('title', 'Depletion Plan Status Report')

@section('content')
    <div class="fixed-action-bar d-flex align-items-center justify-content-between">
        <div class="fw-semibold fixed-nav-title">Depletion Plan Status Report</div>
        <div class="d-flex align-items-center ms-auto">
            <!-- Additional Actions (Left) -->
            <a href="{{ route('posm.depletion.import') }}" class="mx-1">
                <i class="fa-solid fa-file-import fixed-nav-btn fixed-nav-btn-active p-1 d-inline-flex align-items-center justify-content-center"
                    data-toggle="tooltip" title="Import Depletion"></i>
            </a>

            <a href="{{ route('posm.reports.depletion-status.export-pdf', request()->query()) }}" class="mx-1">
                <i class="fa-solid fa-file-pdf fixed-nav-btn fixed-nav-btn-active p-1 d-inline-flex align-items-center justify-content-center"
                    data-toggle="tooltip" title="Export PDF"></i>
            </a>

            
            <a href="{{ route('posm.reports.depletion-status.excel', request()->all()) }}">
                <i class="fa-solid fa-file-excel fixed-nav-btn fixed-nav-btn-active p-1 d-inline-flex align-items-center justify-content-center mx-1" style="color: #28a745; cursor: pointer;"
                    data-toggle="tooltip" title="Export Excel"></i>
            </a>
            <i class="fa-solid fa-file-csv fixed-nav-btn fixed-nav-btn-active p-1 d-inline-flex align-items-center justify-content-center mx-1"
                onclick="exportToCSV()" data-toggle="tooltip" title="Export CSV" style="cursor: pointer;"></i>

            <div class="ms-auto d-flex align-items-center">
                <!-- Mandatory Action Set (Right) -->
                <!-- Add -->
                <i class="fa-regular fa-plus fixed-nav-btn p-1 d-inline-flex align-items-center justify-content-center mx-1" data-toggle="tooltip" title="Add" style="cursor: default;"></i>

                <!-- Save -->
                <i class="fa-regular fa-save fixed-nav-btn p-1 d-inline-flex align-items-center justify-content-center mx-1" data-toggle="tooltip" title="Save" style="cursor: default;"></i>

                <!-- Edit -->
                <i class="fa-regular fa-edit fixed-nav-btn p-1 d-inline-flex align-items-center justify-content-center mx-1" data-toggle="tooltip" title="Edit" style="cursor: default;"></i>

                <!-- Delete -->
                <i class="fa-regular fa-trash-can fixed-nav-btn p-1 d-inline-flex align-items-center justify-content-center mx-1" data-toggle="tooltip" title="Delete" style="cursor: default;"></i>

                <!-- Close -->
                <a href="{{ route('posm.reports.dashboard') }}" class="mx-1">
                    <i class="fa-solid fa-xmark fixed-nav-btn fixed-nav-btn-active p-1 d-inline-flex align-items-center justify-content-center"
                        data-toggle="tooltip" title="Close"></i>
                </a>

                <!-- Column Visibility -->
                <div class="dropdown d-inline-block mx-1">
                    <i class="fa-solid fa-columns fixed-nav-btn fixed-nav-btn-active p-1 d-inline-flex align-items-center justify-content-center"
                        id="columnVisibilityDropdownDepletion" data-toggle="dropdown" aria-haspopup="true"
                        aria-expanded="false" title="Columns" style="cursor: pointer;"></i>
                    <div class="dropdown-menu dropdown-menu-right columns-menu shadow border-0"
                        aria-labelledby="columnVisibilityDropdownDepletion" style="min-width: 200px;">
                        <li><label class="dropdown-item"><input type="checkbox" class="columnCheckbox" data-column="job-no" checked> Job Number</label></li>
                        <li><label class="dropdown-item"><input type="checkbox" class="columnCheckbox" data-column="date" checked> Created Date</label></li>
                        <li><label class="dropdown-item"><input type="checkbox" class="columnCheckbox" data-column="status" checked> Plan Status</label></li>
                        <li><label class="dropdown-item"><input type="checkbox" class="columnCheckbox" data-column="shipment" checked> Shipment Status</label></li>
                        <li><label class="dropdown-item"><input type="checkbox" class="columnCheckbox" data-column="qr" checked> QR Status</label></li>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="card mt-4 rounded-border border-0 shadow-sm">
        <div class="card-body">
            <!-- Filters -->
            <form id="filterForm" action="{{ route('posm.reports.depletion-status') }}" method="GET">
                <div class="row g-2 align-items-end mb-4">
                    <div class="col-md-4">
                        <label for="year" class="form-label fw-bold small text-muted uppercase">Plan Created
                            Year</label>
                        <select class="form-control fw-bold" id="year" name="year" onchange="this.form.submit()"
                            style="border-color: #e2e8f0; color: #475569;">
                            <option value="">All Years</option>
                            @for ($i = date('Y'); $i >= 2023; $i--)
                                <option value="{{ $i }}" {{ request('year') == $i ? 'selected' : '' }}>
                                    {{ $i }}</option>
                            @endfor
                        </select>
                    </div>
                    <div class="col-md-4">
                        <label for="shipment_status" class="form-label fw-bold small text-muted uppercase">Shipment Status</label>
                        <select class="form-control fw-bold" id="shipment_status" name="shipment_status" onchange="this.form.submit()"
                            style="border-color: #e2e8f0; color: #475569;">
                            <option value="">All Statuses</option>
                            <option value="pending" {{ request('shipment_status') == 'pending' ? 'selected' : '' }}>Pending</option>
                            <option value="approved_for_dispatch" {{ request('shipment_status') == 'approved_for_dispatch' ? 'selected' : '' }}>Approved for Dispatch</option>
                            <option value="ready_to_dispatch" {{ request('shipment_status') == 'ready_to_dispatch' ? 'selected' : '' }}>Ready to Dispatch</option>
                            <option value="dispatched" {{ request('shipment_status') == 'dispatched' ? 'selected' : '' }}>Dispatched</option>
                            <option value="received" {{ request('shipment_status') == 'received' ? 'selected' : '' }}>Received</option>
                        </select>
                    </div>
                    <div class="col-md-4 d-flex gap-2">
                        <a href="{{ route('posm.reports.depletion-status') }}" class="btn btn-primary">
                            Clear
                        </a>
                    </div>
                </div>
            </form>

            <div class="table-responsive">
                <table class="table table-hover align-middle table-striped">
                    <thead class="bg-light text-muted uppercase fs-11 fw-bold">
                        <tr>
                            <th class="ps-4 py-3 job-no-index">Job Number</th>
                            <th class="py-3 date-index">Created Date</th>
                            <th class="py-3 text-center status-index">Plan Status</th>
                            <th class="py-3 text-center shipment-index">Shipment Status</th>
                            <th class="py-3 text-center qr-index">QR Status</th>
                            <th class="py-3 text-end pe-4">Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($jobs as $job)
                            <tr>
                                <td class="ps-4 fw-bold job-no-index">
                                    {{ $job->job_no }}
                                </td>
                                <td class="date-index">
                                    <div class="small fw-bold">{{ $job->created_at->format('d M, Y') }}</div>
                                    <small class="text-muted">{{ $job->created_at->format('h:i A') }}</small>
                                </td>
                                <td class="text-center status-index">
                                    @php
                                        $statusClass = match ($job->status) {
                                            'approved' => 'success',
                                            'rejected' => 'danger',
                                            'pending' => 'warning',
                                            default => 'secondary',
                                        };
                                    @endphp
                                    <span
                                        class="badge bg-soft-{{ $statusClass }} text-{{ $statusClass }} rounded-pill px-3">{{ ucfirst($job->status) }}</span>
                                </td>
                                <td class="text-center shipment-index">
                                    @php
                                        $shipmentClass = match (strtolower($job->shipment_status)) {
                                            'received', 'delivered' => 'success',
                                            'partially delivered' => 'info',
                                            'approved_for_dispatch', 'ready_to_dispatch', 'dispatched' => 'primary',
                                            'pending' => 'warning',
                                            default => 'secondary',
                                        };
                                        $shipmentText = strtolower($job->shipment_status) === 'received' ? 'Received to Distribution Point' : str_replace('_', ' ', ucfirst($job->shipment_status));
                                    @endphp
                                    <span
                                        class="badge bg-soft-{{ $shipmentClass }} text-{{ $shipmentClass }} rounded-pill px-3">{{ $shipmentText }}</span>
                                </td>
                                <td class="text-center qr-index">
                                    @if ($job->qr_status == 'Printed')
                                        <span class="badge bg-soft-dark text-dark rounded-pill px-3"><i
                                                class="fa-solid fa-qrcode me-1"></i> Printed</span>
                                    @else
                                        <span
                                            class="badge bg-soft-light text-muted border rounded-pill px-3">Pending</span>
                                    @endif
                                </td>
                                <td class="text-end pe-4">
                                    <a href="{{ route('posm.reports.depletion-status.show', $job->id) }}"
                                        class="btn btn-sm btn-light border rounded-circle shadow-none"
                                        title="View Job Details">
                                        <i class="fa-solid fa-eye text-primary"></i>
                                    </a>
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="6" class="text-center py-5">
                                    <div class="d-flex flex-column align-items-center">
                                        <i class="fa-solid fa-clipboard-list text-muted opacity-25"
                                            style="font-size: 48px;"></i>
                                        <p class="text-muted mt-3 mb-0">No depletion records found.</p>
                                    </div>
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>

            <div class="d-flex justify-content-between mt-4 align-items-center">
                <div class="small text-muted">
                    Showing {{ $jobs->firstItem() ?? 0 }} to {{ $jobs->lastItem() ?? 0 }} of {{ $jobs->total() }} records
                </div>
                <div>
                    {{ $jobs->appends(request()->query())->links() }}
                </div>
            </div>
        </div>
    </div>
@endsection

@push('js')
    <script>
        function exportToCSV() {
            const table = document.querySelector('table');
            let csv = [];
            const rows = table.querySelectorAll('tr');

            for (let i = 0; i < rows.length; i++) {
                const row = [],
                    cols = rows[i].querySelectorAll('td, th');

                for (let j = 0; j < cols.length - 1; j++) {
                    let data = cols[j].innerText.replace(/(\r\n|\n|\r)/gm, ' ').replace(/\s+/g, ' ').trim();
                    row.push('"' + data + '"');
                }

                csv.push(row.join(','));
            }

            const csvFile = new Blob([csv.join('\n')], {
                type: 'text/csv'
            });
            const downloadLink = document.createElement('a');
            downloadLink.download = 'depletion_status_report_' + new Date().toISOString().split('T')[0] + '.csv';
            downloadLink.href = window.URL.createObjectURL(csvFile);
            downloadLink.style.display = 'none';
            document.body.appendChild(downloadLink);
            downloadLink.click();
            document.body.removeChild(downloadLink);
        }

        $(document).ready(function() {
            // Column Visibility logic
            $('.columnCheckbox').on('change', function() {
                const col = $(this).data('column');
                const isChecked = $(this).prop('checked');

                if (isChecked) {
                    $('.' + col + '-index').show();
                } else {
                    $('.' + col + '-index').hide();
                }
            });

            // Initialize visibility
            $('.columnCheckbox').each(function() {
                const col = $(this).data('column');
                if (!$(this).prop('checked')) {
                    $('.' + col + '-index').hide();
                }
            });
        });
    </script>
@endpush