@extends('layouts.app')

@section('title', 'Inventory Value Report')

@section('content')
<div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 py-8" x-data="reportFilter()">
    <div class="sm:flex sm:items-center justify-between mb-6">
        <div>
            <h1 class="text-3xl font-bold tracking-tight text-gray-900 dark:text-white">Inventory Value Report</h1>
            <p class="mt-2 text-sm text-gray-700 dark:text-gray-300">{{ $reportPeriod }}</p>
        </div>
        <div class="flex gap-2 mt-4 sm:mt-0">
            <a href="{{ route('inventory.index') }}" class="inline-flex items-center px-4 py-2 bg-gray-600 text-white rounded-md hover:bg-gray-700 dark:bg-gray-700 dark:hover:bg-gray-600">
                <svg class="w-5 h-5 mr-2" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M10 19l-7-7m0 0l7-7m-7 7h18"/>
                </svg>
                Back to Inventory
            </a>
            <a :href="printUrl" target="_blank" class="inline-flex items-center px-4 py-2 bg-purple-600 text-white rounded-md hover:bg-purple-700 dark:bg-purple-700 dark:hover:bg-purple-600">
                <svg class="w-5 h-5 mr-2" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M17 17h2a2 2 0 002-2v-4a2 2 0 00-2-2H5a2 2 0 00-2 2v4a2 2 0 002 2h2m2 4h6a2 2 0 002-2v-4a2 2 0 00-2-2H9a2 2 0 00-2 2v4a2 2 0 002 2zm8-12V5a2 2 0 00-2-2H9a2 2 0 00-2 2v4h10z"/>
                </svg>
                Print Report
            </a>
        </div>
    </div>

    <!-- Filter Section -->
    <div class="bg-white dark:bg-gray-800 shadow rounded-lg p-6 mb-6">
        <form method="GET" action="{{ route('inventory.value-report') }}">
            <div class="grid grid-cols-1 md:grid-cols-4 gap-4">
                <!-- Filter Type -->
                <div>
                    <label for="filter_type" class="block text-sm font-medium text-gray-700 dark:text-gray-300 mb-2">Report Period</label>
                    <select name="filter_type" id="filter_type" x-model="filterType"
                            class="block w-full px-3 py-2 bg-white dark:bg-gray-700 text-gray-900 dark:text-white border border-gray-300 dark:border-gray-600 rounded-md shadow-sm focus:ring-indigo-500 focus:border-indigo-500 dark:focus:ring-offset-gray-800">
                        <option value="current">Current Inventory</option>
                        <option value="month">Monthly Report</option>
                        <option value="custom">Custom Date Range</option>
                    </select>
                </div>

                <!-- Month Picker -->
                <div x-show="filterType === 'month'" x-transition>
                    <label for="month" class="block text-sm font-medium text-gray-700 dark:text-gray-300 mb-2">Select Month</label>
                    <input type="month" name="month" id="month" x-model="month"
                           class="block w-full px-3 py-2 bg-white dark:bg-gray-700 text-gray-900 dark:text-white border border-gray-300 dark:border-gray-600 rounded-md shadow-sm focus:ring-indigo-500 focus:border-indigo-500 dark:focus:ring-offset-gray-800">
                </div>

                <!-- Custom Date Range -->
                <div x-show="filterType === 'custom'" x-transition>
                    <label for="start_date" class="block text-sm font-medium text-gray-700 dark:text-gray-300 mb-2">Start Date</label>
                    <input type="date" name="start_date" id="start_date" x-model="startDate"
                           class="block w-full px-3 py-2 bg-white dark:bg-gray-700 text-gray-900 dark:text-white border border-gray-300 dark:border-gray-600 rounded-md shadow-sm focus:ring-indigo-500 focus:border-indigo-500 dark:focus:ring-offset-gray-800">
                </div>

                <div x-show="filterType === 'custom'" x-transition>
                    <label for="end_date" class="block text-sm font-medium text-gray-700 dark:text-gray-300 mb-2">End Date</label>
                    <input type="date" name="end_date" id="end_date" x-model="endDate"
                           class="block w-full px-3 py-2 bg-white dark:bg-gray-700 text-gray-900 dark:text-white border border-gray-300 dark:border-gray-600 rounded-md shadow-sm focus:ring-indigo-500 focus:border-indigo-500 dark:focus:ring-offset-gray-800">
                </div>

                <!-- Apply Button -->
                <div class="flex items-end">
                    <button type="submit" class="w-full px-4 py-2 bg-indigo-600 text-white rounded-md hover:bg-indigo-700 dark:bg-indigo-700 dark:hover:bg-indigo-600 font-medium dark:focus:ring-offset-gray-800">
                        Apply Filter
                    </button>
                </div>
            </div>
        </form>
    </div>

    <!-- Warehouse Breakdown -->
    @if($warehouseBreakdown->count() > 0)
    <div class="bg-white dark:bg-gray-800 shadow rounded-lg p-6 mb-6">
        <h2 class="text-lg font-semibold text-gray-900 dark:text-white mb-4">Warehouse Breakdown</h2>
        <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-4">
            @foreach($warehouseBreakdown as $warehouse)
                <div class="border border-gray-200 dark:border-gray-700 rounded-lg p-4 hover:shadow-md dark:hover:shadow-gray-900/50 transition-shadow bg-white dark:bg-gray-800">
                    <div class="flex items-center justify-between mb-2">
                        <h3 class="font-medium text-gray-900 dark:text-white">
                            {{ $warehouse->warehouse_name ?? 'Unassigned' }}
                        </h3>
                        @if($warehouse->warehouse_code)
                            <span class="text-xs text-gray-500 dark:text-gray-400 bg-gray-100 dark:bg-gray-700 px-2 py-1 rounded">{{ $warehouse->warehouse_code }}</span>
                        @endif
                    </div>
                    <div class="space-y-2">
                        <div class="flex justify-between text-sm">
                            <span class="text-gray-600 dark:text-gray-400">SKUs:</span>
                            <span class="font-semibold text-gray-900 dark:text-white">{{ $warehouse->sku_count }}</span>
                        </div>
                        <div class="flex justify-between text-sm">
                            <span class="text-gray-600 dark:text-gray-400">Total Items:</span>
                            <span class="font-semibold text-gray-900 dark:text-white">{{ number_format($warehouse->total_quantity) }}</span>
                        </div>
                        <div class="flex justify-between text-sm pt-2 border-t border-gray-200 dark:border-gray-700">
                            <span class="text-gray-600 dark:text-gray-400">Total Value:</span>
                            <span class="font-bold text-green-600 dark:text-green-400">RM {{ number_format($warehouse->total_value, 2) }}</span>
                        </div>
                    </div>
                </div>
            @endforeach
        </div>
    </div>
    @endif

    <!-- Summary Cards -->
    <div class="grid grid-cols-1 md:grid-cols-3 gap-6 mb-6">
        <div class="bg-white dark:bg-gray-800 shadow rounded-lg p-6">
            <div class="flex items-center">
                <div class="flex-shrink-0">
                    <svg class="h-10 w-10 text-blue-600 dark:text-blue-400" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                        <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M20 7l-8-4-8 4m16 0l-8 4m8-4v10l-8 4m0-10L4 7m8 4v10M4 7v10l8 4"/>
                    </svg>
                </div>
                <div class="ml-5 w-0 flex-1">
                    <dl>
                        <dt class="text-sm font-medium text-gray-500 dark:text-gray-400 truncate">Total Items</dt>
                        <dd class="text-3xl font-semibold text-gray-900 dark:text-white">{{ number_format($totalItems) }}</dd>
                    </dl>
                </div>
            </div>
        </div>

        <div class="bg-white dark:bg-gray-800 shadow rounded-lg p-6">
            <div class="flex items-center">
                <div class="flex-shrink-0">
                    <svg class="h-10 w-10 text-purple-600 dark:text-purple-400" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                        <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2"/>
                    </svg>
                </div>
                <div class="ml-5 w-0 flex-1">
                    <dl>
                        <dt class="text-sm font-medium text-gray-500 dark:text-gray-400 truncate">Total SKUs</dt>
                        <dd class="text-3xl font-semibold text-gray-900 dark:text-white">{{ $inventory->count() }}</dd>
                    </dl>
                </div>
            </div>
        </div>

        <div class="bg-white dark:bg-gray-800 shadow rounded-lg p-6">
            <div class="flex items-center">
                <div class="flex-shrink-0">
                    <svg class="h-10 w-10 text-green-600 dark:text-green-400" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                        <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M12 8c-1.657 0-3 .895-3 2s1.343 2 3 2 3 .895 3 2-1.343 2-3 2m0-8c1.11 0 2.08.402 2.599 1M12 8V7m0 1v8m0 0v1m0-1c-1.11 0-2.08-.402-2.599-1M21 12a9 9 0 11-18 0 9 9 0 0118 0z"/>
                    </svg>
                </div>
                <div class="ml-5 w-0 flex-1">
                    <dl>
                        <dt class="text-sm font-medium text-gray-500 dark:text-gray-400 truncate">Total Inventory Value</dt>
                        <dd class="text-3xl font-semibold text-green-600 dark:text-green-400">RM {{ number_format($totalValue, 2) }}</dd>
                    </dl>
                </div>
            </div>
        </div>
    </div>

    <!-- Inventory Table -->
    <div class="bg-white dark:bg-gray-800 shadow rounded-lg overflow-hidden">
        @if($inventory->count() > 0)
            <div class="overflow-x-auto">
                <table class="min-w-full divide-y divide-gray-200 dark:divide-gray-700">
                    <thead class="bg-gray-50 dark:bg-gray-700">
                        <tr>
                            <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">SKU</th>
                            <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">Product Name</th>
                            <th class="px-6 py-3 text-center text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">Quantity</th>
                            <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">Warehouse</th>
                            <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">Location</th>
                            <th class="px-6 py-3 text-right text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">Avg Cost</th>
                            <th class="px-6 py-3 text-right text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">Total Value</th>
                        </tr>
                    </thead>
                    <tbody class="bg-white dark:bg-gray-800 divide-y divide-gray-200 dark:divide-gray-700">
                        @foreach($inventory as $item)
                            <tr class="hover:bg-gray-50 dark:hover:bg-gray-700/50">
                                <td class="px-6 py-4 whitespace-nowrap">
                                    <div class="text-sm font-medium text-gray-900 dark:text-white">{{ $item->sku }}</div>
                                </td>
                                <td class="px-6 py-4">
                                    <div class="text-sm text-gray-900 dark:text-white">{{ $item->product_name }}</div>
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap text-center">
                                    <span class="text-sm font-semibold text-gray-900 dark:text-white">
                                        {{ $item->quantity }}
                                    </span>
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 dark:text-white">
                                    @if($item->warehouse_name)
                                        <div>{{ $item->warehouse_name }}</div>
                                        <div class="text-xs text-gray-500 dark:text-gray-400">{{ $item->warehouse_code }}</div>
                                    @else
                                        <span class="text-gray-400 dark:text-gray-500">-</span>
                                    @endif
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500 dark:text-gray-400">
                                    {{ $item->location ?? '-' }}
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap text-right text-sm text-gray-900 dark:text-white">
                                    @if($item->avg_cost > 0)
                                        RM {{ number_format($item->avg_cost, 2) }}
                                    @else
                                        <span class="text-gray-400 dark:text-gray-500">-</span>
                                    @endif
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap text-right">
                                    @if($item->total_value > 0)
                                        <span class="text-sm font-bold text-green-600 dark:text-green-400">
                                            RM {{ number_format($item->total_value, 2) }}
                                        </span>
                                    @else
                                        <span class="text-sm text-gray-400 dark:text-gray-500">RM 0.00</span>
                                    @endif
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr class="bg-gray-50 dark:bg-gray-700 font-bold">
                            <td colspan="6" class="px-6 py-4 text-right text-gray-900 dark:text-white">TOTAL INVENTORY VALUE:</td>
                            <td class="px-6 py-4 text-right text-lg font-bold text-green-600 dark:text-green-400">
                                RM {{ number_format($totalValue, 2) }}
                            </td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        @else
            <div class="text-center py-12">
                <svg class="mx-auto h-12 w-12 text-gray-400 dark:text-gray-500" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M20 7l-8-4-8 4m16 0l-8 4m8-4v10l-8 4m0-10L4 7m8 4v10M4 7v10l8 4"/>
                </svg>
                <h3 class="mt-2 text-sm font-medium text-gray-900 dark:text-white">No inventory items found</h3>
                <p class="mt-1 text-sm text-gray-500 dark:text-gray-400">Start by creating a purchase order to add inventory.</p>
            </div>
        @endif
    </div>

    <!-- Stock Out Summary -->
    <div class="bg-white dark:bg-gray-800 shadow rounded-lg overflow-hidden mt-6">
        <div class="px-6 py-4 border-b border-gray-200 dark:border-gray-700 bg-red-50 dark:bg-red-900/20 flex items-center justify-between">
            <h2 class="text-lg font-semibold text-red-800 dark:text-red-300 flex items-center">
                <svg class="w-5 h-5 mr-2" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M17 16l4-4m0 0l-4-4m4 4H7m6 4v1a3 3 0 01-3 3H6a3 3 0 01-3-3V7a3 3 0 013-3h4a3 3 0 013 3v1"/>
                </svg>
                Stock Out Summary
                <span class="ml-2 text-sm font-normal text-red-600 dark:text-red-400">({{ $reportPeriod }})</span>
            </h2>
            @if($stockOutSummary->count() > 0)
            <a :href="exportStockOutUrl" class="inline-flex items-center px-3 py-1.5 bg-red-600 text-white text-sm rounded-md hover:bg-red-700">
                <svg class="w-4 h-4 mr-1" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M12 10v6m0 0l-3-3m3 3l3-3m2 8H7a2 2 0 01-2-2V5a2 2 0 012-2h5.586a1 1 0 01.707.293l5.414 5.414a1 1 0 01.293.707V19a2 2 0 01-2 2z"/>
                </svg>
                Export CSV
            </a>
            @endif
        </div>

        @if($stockOutSummary->count() > 0)
            <div class="overflow-x-auto">
                <table class="min-w-full divide-y divide-gray-200 dark:divide-gray-700">
                    <thead class="bg-red-50 dark:bg-red-900/10">
                        <tr>
                            <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">SKU</th>
                            <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">Product Name</th>
                            <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">Warehouse</th>
                            <th class="px-6 py-3 text-center text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">Qty Out</th>
                            <th class="px-6 py-3 text-center text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">Transactions</th>
                            <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-400 uppercase">Type</th>
                        </tr>
                    </thead>
                    <tbody class="bg-white dark:bg-gray-800 divide-y divide-gray-200 dark:divide-gray-700">
                        @foreach($stockOutSummary as $item)
                            <tr class="hover:bg-gray-50 dark:hover:bg-gray-700/50">
                                <td class="px-6 py-4 whitespace-nowrap">
                                    <div class="text-sm font-medium text-gray-900 dark:text-white">{{ $item->sku }}</div>
                                </td>
                                <td class="px-6 py-4">
                                    <div class="text-sm text-gray-900 dark:text-white">{{ $item->product_name ?? '-' }}</div>
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap">
                                    @if($item->warehouse_name)
                                        <div class="text-sm font-medium text-gray-900 dark:text-white">{{ $item->warehouse_name }}</div>
                                        <div class="text-xs text-gray-500 dark:text-gray-400">{{ $item->warehouse_code }}</div>
                                    @else
                                        <span class="text-gray-400">-</span>
                                    @endif
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap text-center">
                                    <span class="text-sm font-bold text-red-600 dark:text-red-400">
                                        {{ number_format($item->total_out) }}
                                    </span>
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap text-center text-sm text-gray-500 dark:text-gray-400">
                                    {{ $item->transaction_count }}
                                </td>
                                <td class="px-6 py-4 whitespace-nowrap">
                                    @php
                                        $types = explode(', ', $item->out_types ?? '');
                                        $typeLabels = [
                                            'agent_sale' => 'Sales',
                                            'order' => 'Order',
                                            'transfer' => 'Transfer',
                                            'adjustment' => 'Adjustment',
                                        ];
                                    @endphp
                                    @foreach($types as $type)
                                        <span class="inline-flex items-center px-2 py-0.5 rounded text-xs font-medium bg-red-100 text-red-800 dark:bg-red-900/30 dark:text-red-300 mr-1">
                                            {{ $typeLabels[$type] ?? ucfirst($type) }}
                                        </span>
                                    @endforeach
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr class="bg-red-50 dark:bg-red-900/20 font-bold">
                            <td colspan="3" class="px-6 py-4 text-right text-gray-900 dark:text-white">TOTAL STOCK OUT:</td>
                            <td class="px-6 py-4 text-center text-lg font-bold text-red-600 dark:text-red-400">
                                {{ number_format($totalStockOut) }}
                            </td>
                            <td colspan="2"></td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        @else
            <div class="text-center py-12">
                <svg class="mx-auto h-12 w-12 text-gray-400 dark:text-gray-500" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M9 12l2 2 4-4m6 2a9 9 0 11-18 0 9 9 0 0118 0z"/>
                </svg>
                <h3 class="mt-2 text-sm font-medium text-gray-900 dark:text-white">No stock out recorded</h3>
                <p class="mt-1 text-sm text-gray-500 dark:text-gray-400">No stock out transactions found for this period.</p>
            </div>
        @endif
    </div>

    <!-- Value Notes -->
    <div class="mt-6 bg-blue-50 dark:bg-blue-900/30 border-l-4 border-blue-400 dark:border-blue-500 p-4">
        <div class="flex">
            <div class="flex-shrink-0">
                <svg class="h-5 w-5 text-blue-400 dark:text-blue-300" fill="currentColor" viewBox="0 0 20 20">
                    <path fill-rule="evenodd" d="M18 10a8 8 0 11-16 0 8 8 0 0116 0zm-7-4a1 1 0 11-2 0 1 1 0 012 0zM9 9a1 1 0 000 2v3a1 1 0 001 1h1a1 1 0 100-2v-3a1 1 0 00-1-1H9z" clip-rule="evenodd"/>
                </svg>
            </div>
            <div class="ml-3">
                <p class="text-sm text-blue-700 dark:text-blue-300">
                    <strong>Note:</strong> Values are calculated based on the average unit cost from all purchase orders. Items without purchase history show as RM 0.00.
                </p>
            </div>
        </div>
    </div>
</div>

<script>
function reportFilter() {
    return {
        filterType: '{{ $filterType ?? 'current' }}',
        month: '{{ $month ?? '' }}',
        startDate: '{{ $startDate ?? '' }}',
        endDate: '{{ $endDate ?? '' }}',

        get printUrl() {
            return this.buildUrl('{{ route('inventory.print-value-report') }}');
        },

        get exportStockOutUrl() {
            return this.buildUrl('{{ route('inventory.export-stock-out') }}');
        },

        buildUrl(baseUrl) {
            let params = [];

            if (this.filterType) {
                params.push('filter_type=' + this.filterType);
            }

            if (this.filterType === 'month' && this.month) {
                params.push('month=' + this.month);
            }

            if (this.filterType === 'custom' && this.startDate && this.endDate) {
                params.push('start_date=' + this.startDate);
                params.push('end_date=' + this.endDate);
            }

            return params.length > 0 ? baseUrl + '?' + params.join('&') : baseUrl;
        }
    }
}
</script>
@endsection