@include('styles.pdfs')
@include('_partials.letterhead-pdf')

<style>
    body {
        font-family: 'Arial', sans-serif;
        font-size: 10px;
    }

    .report-header {
        text-align: center;
        margin: 20px 0;
        padding-bottom: 15px;
        border-bottom: 2px solid #007cbf;
    }

    .report-header h1 {
        font-size: 24px;
        color: #007cbf;
        margin: 0 0 10px 0;
        font-weight: bold;
    }

    .report-header .report-meta {
        font-size: 12px;
        color: #666;
        margin: 5px 0;
    }

    .content {
        margin-top: 20px;
    }

    .table {
        width: 100%;
        border-collapse: collapse;
        margin-top: 10px;
    }

    .table thead {
        background-color: #007cbf;
        color: white;
    }

    .table th {
        padding: 10px 8px;
        text-align: left;
        font-weight: bold;
        font-size: 11px;
        border: 1px solid #005a8f;
    }

    .table td {
        padding: 8px;
        border: 1px solid #ddd;
        font-size: 10px;
    }

    .table tbody tr:nth-child(even) {
        background-color: #f8f9fa;
    }

    .category-header {
        background-color: #e9ecef !important;
        font-weight: bold;
        color: #007cbf;
        font-size: 11px;
    }

    .category-header td {
        border-top: 2px solid #007cbf;
        border-bottom: 1px solid #007cbf;
        padding: 10px 8px;
    }

    .quantity {
        text-align: right;
        font-weight: 500;
    }

    .text-right {
        text-align: right;
    }

    .text-center {
        text-align: center;
    }

    .summary {
        margin-top: 20px;
        padding: 15px;
        background-color: #f8f9fa;
        border: 1px solid #dee2e6;
        border-radius: 5px;
    }

    .summary-row {
        display: flex;
        justify-content: space-between;
        padding: 5px 0;
        border-bottom: 1px solid #dee2e6;
    }

    .summary-row:last-child {
        border-bottom: none;
        font-weight: bold;
        font-size: 12px;
        margin-top: 10px;
        padding-top: 10px;
        border-top: 2px solid #007cbf;
    }

    .page-break {
        page-break-after: always;
    }
</style>

<div class="report-header">
    <h1>Stock Sheet</h1>
    <div class="report-meta">
        Generated on: {{ Carbon\Carbon::now()->format('F d, Y \a\t h:i A') }}
    </div>
    @if(isset($warehouse_name) && $warehouse_name)
        <div class="report-meta">
            <strong>Warehouse:</strong> {{ $warehouse_name }}
        </div>
    @elseif(isset($warehouse_names) && !empty($warehouse_names) && count($warehouse_names) > 1)
        <div class="report-meta">
            <strong>Warehouses:</strong> {{ implode(', ', $warehouse_names) }}
        </div>
    @else
        <div class="report-meta">
            <strong>Scope:</strong> All Active Warehouses
        </div>
    @endif
</div>

<div class="content">
    <table class="table">
        <thead>
        <tr>
            <th style="width: 25%;">Category</th>
            <th style="width: 35%;">Product</th>
            <th style="width: 15%;">SKU</th>
            <th style="width: 15%;">Warehouse</th>
            <th style="width: 10%;" class="text-right">Quantity</th>
        </tr>
        </thead>
        <tbody>
        @php
            $currentCategory = null;
            $categoryTotal = 0;
            $grandTotal = 0;
        @endphp

        @foreach($stockData as $row)
            @if($currentCategory !== $row['category'])
                @if($currentCategory !== null)
                    <tr class="category-total">
                        <td colspan="4" class="text-right" style="font-weight: bold; background-color: #fff3cd;">
                            Category Total:
                        </td>
                        <td class="quantity" style="font-weight: bold; background-color: #fff3cd;">
                            {{ number_format($categoryTotal, 2) }}
                        </td>
                    </tr>
                    @php
                        $grandTotal += $categoryTotal;
                        $categoryTotal = 0;
                    @endphp
                @endif

                <tr class="category-header">
                    <td colspan="5">
                        {{ $row['category'] }}
                    </td>
                </tr>
                @php
                    $currentCategory = $row['category'];
                @endphp
            @endif

            <tr>
                <td>{{ $row['category'] }}</td>
                <td>{{ $row['product'] }}</td>
                <td>{{ $row['sku'] ?? 'N/A' }}</td>
                <td>{{ $row['warehouse'] }}</td>
                <td class="quantity">{{ number_format($row['quantity'], 2) }}</td>
            </tr>

            @php
                $categoryTotal += $row['quantity'];
            @endphp
        @endforeach

        @if($currentCategory !== null)
            <tr class="category-total">
                <td colspan="4" class="text-right" style="font-weight: bold; background-color: #fff3cd;">
                    Category Total:
                </td>
                <td class="quantity" style="font-weight: bold; background-color: #fff3cd;">
                    {{ number_format($categoryTotal, 2) }}
                </td>
            </tr>
            @php
                $grandTotal += $categoryTotal;
            @endphp
        @endif

        <tr style="background-color: #d4edda; border-top: 3px solid #28a745;">
            <td colspan="4" class="text-right" style="font-weight: bold; font-size: 12px; padding: 12px;">
                GRAND TOTAL:
            </td>
            <td class="quantity" style="font-weight: bold; font-size: 12px; padding: 12px;">
                {{ number_format($grandTotal, 2) }}
            </td>
        </tr>
        </tbody>
    </table>
</div>

<div class="summary">
    <div class="summary-row">
        <span><strong>Total Items:</strong></span>
        <span>{{ count($stockData) }}</span>
    </div>
    <div class="summary-row">
        <span><strong>Total Categories:</strong></span>
        <span>{{ $totalCategories ?? collect($stockData)->pluck('category')->unique()->count() }}</span>
    </div>
    <div class="summary-row">
        <span><strong>Total Warehouses:</strong></span>
        <span>{{ $totalWarehouses ?? collect($stockData)->pluck('warehouse')->unique()->count() }}</span>
    </div>
</div>