@extends('layouts.app')

@section('content')
<div class="min-h-screen bg-gradient-to-br from-slate-50 to-slate-100 py-8 px-4 md:px-8">
    <div class="max-w-7xl mx-auto">
        <div class="mb-8">
            <div class="flex items-center justify-between mb-6">
                <div>
                    <h1 class="text-3xl font-bold text-black mb-2">تقرير ربحية الأصناف التفصيلي</h1>
                    <p class="text-black">تحليل الربحية على مستوى الفواتير (سعر البيع - سعر الشراء)</p>
                </div>
                <div class="flex gap-2">
                    <a href="{{ route('reports.sales.item-profitability', ['from_date' => $fromDate, 'to_date' => $toDate]) }}" 
                       class="bg-gray-600 hover:bg-gray-700 text-white font-semibold py-2 px-4 rounded-lg transition-colors">
                        <i class="fas fa-list ml-1"></i> عرض ملخص حسب الصنف
                    </a>
                </div>
            </div>
        </div>

        <div class="bg-white rounded-xl shadow-lg overflow-hidden border border-gray-200 p-6 mb-6">
            <h2 class="text-xl font-bold text-black mb-6">فلاتر البحث</h2>
            
            <form method="GET" class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-5 gap-4">
                <div>
                    <label class="block text-sm font-medium text-black mb-2">من التاريخ</label>
                    <input type="date" name="from_date" value="{{ \Carbon\Carbon::parse($fromDate)->format('Y-m-d') }}" 
                           class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500">
                </div>
                <div>
                    <label class="block text-sm font-medium text-black mb-2">إلى التاريخ</label>
                    <input type="date" name="to_date" value="{{ \Carbon\Carbon::parse($toDate)->format('Y-m-d') }}" 
                           class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500">
                </div>
                <div>
                    <label class="block text-sm font-medium text-black mb-2">العميل</label>
                    <select name="customer_id" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 select2">
                        <option value="">كل العملاء</option>
                        @foreach($customers as $customer)
                            <option value="{{ $customer->id }}" {{ $customerId == $customer->id ? 'selected' : '' }}>
                                {{ $customer->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div>
                    <label class="block text-sm font-medium text-black mb-2">الصنف</label>
                    <select name="item_id" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 select2">
                        <option value="">كل الأصناف</option>
                        @foreach($items as $item)
                            <option value="{{ $item->id }}" {{ $itemId == $item->id ? 'selected' : '' }}>
                                {{ $item->name }} ({{ $item->code }})
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="flex items-end">
                    <button type="submit" class="w-full bg-blue-600 hover:bg-blue-700 text-white font-semibold py-2 px-4 rounded-lg transition-colors">
                        <i class="fas fa-search ml-1"></i> بحث
                    </button>
                </div>
            </form>
        </div>

        <div class="grid grid-cols-1 md:grid-cols-4 gap-6 mb-6">
            <div class="bg-white rounded-xl shadow-lg p-6 border-l-4 border-blue-500">
                <p class="text-black text-sm">إجمالي المبيعات</p>
                <p class="text-3xl font-bold text-blue-600">{{ number_format($data['total_sales'], 2) }}</p>
            </div>

            <div class="bg-white rounded-xl shadow-lg p-6 border-l-4 border-amber-500">
                <p class="text-black text-sm">إجمالي التكلفة</p>
                <p class="text-3xl font-bold text-amber-600">{{ number_format($data['total_cost'], 2) }}</p>
            </div>

            <div class="bg-white rounded-xl shadow-lg p-6 border-l-4 border-green-500">
                <p class="text-black text-sm">إجمالي الربح</p>
                <p class="text-3xl font-bold text-green-600">{{ number_format($data['total_profit'], 2) }}</p>
            </div>

            <div class="bg-white rounded-xl shadow-lg p-6 border-l-4 border-purple-500">
                <p class="text-black text-sm">متوسط هامش الربح</p>
                <p class="text-3xl font-bold text-purple-600">{{ $data['average_margin'] }}%</p>
            </div>
        </div>

        <div class="bg-white rounded-xl shadow-lg overflow-hidden border border-gray-200">
            <div class="overflow-x-auto">
                <table class="w-full">
                    <thead class="bg-gradient-to-r from-gray-800 to-gray-900 text-white">
                        <tr>
                            <th class="px-4 py-4 text-right font-semibold text-sm">التاريخ</th>
                            <th class="px-4 py-4 text-right font-semibold text-sm">رقم الفاتورة</th>
                            <th class="px-4 py-4 text-right font-semibold text-sm">العميل</th>
                            <th class="px-4 py-4 text-right font-semibold text-sm">كود الصنف</th>
                            <th class="px-4 py-4 text-right font-semibold text-sm">اسم الصنف</th>
                            <th class="px-4 py-4 text-right font-semibold text-sm">الكمية</th>
                            <th class="px-4 py-4 text-right font-semibold text-sm">المبيعات</th>
                            <th class="px-4 py-4 text-right font-semibold text-sm">التكلفة</th>
                            <th class="px-4 py-4 text-right font-semibold text-sm">الربح</th>
                            <th class="px-4 py-4 text-center font-semibold text-sm">هامش الربح</th>
                        </tr>
                    </thead>
                    <tbody class="divide-y divide-gray-200">
                        @forelse($data['items'] as $item)
                        <tr class="hover:bg-blue-50 transition-colors text-sm">
                            <td class="px-4 py-4 text-black">{{ $item->invoice_date }}</td>
                            <td class="px-4 py-4 text-black font-medium">{{ $item->invoice_number }}</td>
                            <td class="px-4 py-4 text-black">{{ $item->customer_name }}</td>
                            <td class="px-4 py-4 text-black">{{ $item->code }}</td>
                            <td class="px-4 py-4 text-black font-medium">{{ $item->item_name }}</td>
                            <td class="px-4 py-4 text-black">{{ number_format($item->quantity, 2) }}</td>
                            <td class="px-4 py-4 font-semibold text-black">{{ number_format($item->sales_amount, 2) }}</td>
                            <td class="px-4 py-4 text-amber-600">{{ number_format($item->cost_amount, 2) }}</td>
                            <td class="px-4 py-4 font-bold {{ $item->profit_amount >= 0 ? 'text-green-600' : 'text-red-600' }}">
                                {{ number_format($item->profit_amount, 2) }}
                            </td>
                            <td class="px-4 py-4 text-center">
                                @php
                                    $margin = $item->sales_amount > 0 ? round(($item->profit_amount / $item->sales_amount) * 100, 2) : 0;
                                @endphp
                                <span class="inline-flex items-center px-2 py-0.5 rounded-full text-xs font-medium {{ $margin >= 0 ? 'bg-green-100 text-green-700' : 'bg-red-100 text-red-700' }}">
                                    {{ $margin }}%
                                </span>
                            </td>
                        </tr>
                        @empty
                        <tr>
                            <td colspan="10" class="px-6 py-12 text-center">
                                <div class="flex flex-col items-center justify-center">
                                    <i class="fas fa-inbox text-black text-4xl mb-3"></i>
                                    <p class="text-black font-medium">لا توجد بيانات حالياً للفترة المختارة</p>
                                </div>
                            </td>
                        </tr>
                        @endforelse
                    </tbody>
                    @if(count($data['items']) > 0)
                    <tfoot class="bg-gray-50 font-bold">
                        <tr>
                            <td colspan="5" class="px-4 py-4 text-black text-left">الإجمالي</td>
                            <td class="px-4 py-4 text-black">{{ number_format($data['items']->sum('quantity'), 2) }}</td>
                            <td class="px-4 py-4 text-blue-600">{{ number_format($data['total_sales'], 2) }}</td>
                            <td class="px-4 py-4 text-amber-600">{{ number_format($data['total_cost'], 2) }}</td>
                            <td class="px-4 py-4 text-green-600">{{ number_format($data['total_profit'], 2) }}</td>
                            <td class="px-4 py-4 text-center">
                                <span class="inline-flex items-center px-3 py-1 rounded-full text-sm font-bold bg-blue-100 text-blue-700">
                                    {{ $data['average_margin'] }}%
                                </span>
                            </td>
                        </tr>
                    </tfoot>
                    @endif
                </table>
            </div>
        </div>
    </div>
</div>
@endsection