@extends('layouts.app', ['title' => 'الرحلات'])

@section('content')
    <div class="trips-page">
    <div class="page-header">
        <div>
            <h1 class="page-title">سجل الرحلات - وضع Excel</h1>
            <p class="muted">تبويبات محاسبية مطابقة لتقسيم ملف الإكسل مع إجماليات مباشرة.</p>
        </div>
        <div class="actions">
            <a href="{{ route('trips.create') }}" class="btn btn-primary">إضافة رحلة</a>
            <a href="{{ route('exports.trips', request()->query()) }}" class="btn btn-success">تصدير CSV</a>
        </div>
    </div>

    <div class="card">
        <form method="GET" action="{{ route('trips.index') }}" class="filters-form">
            <div class="form-group">
                <label>بحث</label>
                <input type="text" name="search" value="{{ $filters['search'] ?? '' }}" placeholder="السائق / الشركة / المصنع...">
            </div>
            <div class="form-group">
                <label>السائق</label>
                <select name="driver_id">
                    <option value="">كل السائقين</option>
                    @foreach($drivers as $driver)
                        <option value="{{ $driver->id }}" @selected(($filters['driver_id'] ?? '') == $driver->id)>{{ $driver->name }}</option>
                    @endforeach
                </select>
            </div>
            <div class="form-group">
                <label>الشركة</label>
                <select name="company_name">
                    <option value="">كل الشركات</option>
                    @foreach($companies as $company)
                        <option value="{{ $company }}" @selected(($filters['company_name'] ?? '') === $company)>{{ $company }}</option>
                    @endforeach
                </select>
            </div>
            <div class="form-group">
                <label>نوع النقل</label>
                <select name="transport_type">
                    <option value="">كل الأنواع</option>
                    @foreach($transportTypes as $transportType)
                        <option value="{{ $transportType }}" @selected(($filters['transport_type'] ?? '') === $transportType)>{{ $transportType }}</option>
                    @endforeach
                </select>
            </div>
            <div class="form-group">
                <label>الفترة</label>
                <select name="date_filter">
                    <option value="">كل الفترات</option>
                    <option value="today" @selected(($filters['date_filter'] ?? '') === 'today')>اليوم</option>
                    <option value="month" @selected(($filters['date_filter'] ?? '') === 'month')>هذا الشهر</option>
                    <option value="custom" @selected(($filters['date_filter'] ?? '') === 'custom')>فترة مخصصة</option>
                </select>
            </div>
            <div class="actions">
                <button class="btn btn-primary" type="submit">تطبيق</button>
                <a class="btn btn-secondary" href="{{ route('trips.index') }}">إعادة</a>
            </div>
            <div class="form-group">
                <label>من</label>
                <input type="date" name="date_from" value="{{ $filters['date_from'] ?? '' }}">
            </div>
            <div class="form-group">
                <label>إلى</label>
                <input type="date" name="date_to" value="{{ $filters['date_to'] ?? '' }}">
            </div>
        </form>
    </div>

    <div class="excel-tabs" data-tabs-root>
        <div class="excel-tab-head">
            <button type="button" class="excel-tab-btn active" data-tab-target="tab-ledger-basic">الأساسي</button>
            <button type="button" class="excel-tab-btn" data-tab-target="tab-ledger-driver">السائق</button>
            <button type="button" class="excel-tab-btn" data-tab-target="tab-ledger-factory">المصنع</button>
            <button type="button" class="excel-tab-btn" data-tab-target="tab-ledger-company">الشركة والضرائب</button>
        </div>

        <section class="excel-tab-panel active" data-tab-panel="tab-ledger-basic">
            <div class="card">
                <div class="table-wrap allow-x-scroll">
                    <table>
                        <thead>
                            <tr>
                                <th>التاريخ</th>
                                <th>تاريخ الفاتورة</th>
                                <th>أمر التوريد</th>
                                <th>السائق</th>
                                <th>السائق البديل</th>
                                <th>الشركة</th>
                                <th>المصنع</th>
                                <th>المكان</th>
                                <th>النوع</th>
                                <th>الكمية</th>
                                <th>سعر الوحدة</th>
                                <th>التكلفة/وحدة</th>
                                <th>الإيراد</th>
                                <th>التكلفة</th>
                                <th>الربح</th>
                                <th>إجراءات</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($trips as $trip)
                                <tr>
                                    <td>{{ $trip->created_at?->format('Y-m-d') }}</td>
                                    <td>{{ $trip->invoice_date?->format('Y-m-d') ?? '-' }}</td>
                                    <td>{{ $trip->supply_order_number ?: '-' }}</td>
                                    <td>{{ $trip->driver?->name ?? '-' }}</td>
                                    <td>{{ $trip->alternate_driver_name ?: '-' }}</td>
                                    <td>{{ $trip->company_name }}</td>
                                    <td>{{ $trip->factory_name ?: '-' }}</td>
                                    <td>{{ $trip->location ?: '-' }}</td>
                                    <td>{{ $trip->transport_type }}</td>
                                    <td>{{ number_format((float)$trip->quantity, 2) }}</td>
                                    <td>{{ number_format((float)$trip->price_per_unit, 2) }}</td>
                                    <td>{{ number_format((float)$trip->cost_per_unit, 2) }}</td>
                                    <td>{{ number_format((float)$trip->total_revenue, 2) }}</td>
                                    <td>{{ number_format((float)$trip->total_cost, 2) }}</td>
                                    <td>{{ number_format((float)$trip->profit, 2) }}</td>
                                    <td>
                                        <div class="actions">
                                            <a class="btn btn-secondary" href="{{ route('trips.edit', $trip) }}">تعديل</a>
                                            <form method="POST" action="{{ route('trips.destroy', $trip) }}" onsubmit="return confirm('حذف هذا السطر؟');">
                                                @csrf
                                                @method('DELETE')
                                                <button class="btn btn-danger" type="submit">حذف</button>
                                            </form>
                                        </div>
                                    </td>
                                </tr>
                            @empty
                                <tr><td colspan="16">لا توجد بيانات</td></tr>
                            @endforelse
                            <tr class="sticky-footer">
                                <td colspan="9">إجماليات الأساسي</td>
                                <td>{{ number_format((float)$totals->total_quantity, 2) }}</td>
                                <td colspan="2">عدد الرحلات: {{ number_format((float)$totals->total_trips) }}</td>
                                <td>{{ number_format((float)$totals->total_revenue, 2) }}</td>
                                <td>{{ number_format((float)$totals->total_cost, 2) }}</td>
                                <td>{{ number_format((float)$totals->total_profit, 2) }}</td>
                                <td></td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </section>

        <section class="excel-tab-panel" data-tab-panel="tab-ledger-driver">
            <div class="card">
                <div class="table-wrap">
                    <table>
                        <thead>
                            <tr>
                                <th>السائق</th>
                                <th>تكلفة السائق</th>
                                <th>مدفوعات</th>
                                <th>زيادات</th>
                                <th>خصومات</th>
                                <th>رصيد أول المدة</th>
                                <th>رصيد نهائي</th>
                                <th>ملاحظات</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($trips as $trip)
                                <tr>
                                    <td>{{ $trip->driver?->name ?? '-' }}</td>
                                    <td>{{ number_format((float)$trip->driver_cost, 2) }}</td>
                                    <td>{{ number_format((float)$trip->driver_payments, 2) }}</td>
                                    <td>{{ number_format((float)$trip->driver_increases, 2) }}</td>
                                    <td>{{ number_format((float)$trip->driver_deductions, 2) }}</td>
                                    <td>{{ number_format((float)$trip->driver_opening_balance, 2) }}</td>
                                    <td>{{ number_format((float)$trip->driver_closing_balance, 2) }}</td>
                                    <td>{{ $trip->driver_notes ?: '-' }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="8">لا توجد بيانات</td></tr>
                            @endforelse
                            <tr class="sticky-footer">
                                <td>إجماليات السائق</td>
                                <td></td>
                                <td>{{ number_format((float)$tabTotals->driver_payments, 2) }}</td>
                                <td>{{ number_format((float)$tabTotals->driver_increases, 2) }}</td>
                                <td>{{ number_format((float)$tabTotals->driver_deductions, 2) }}</td>
                                <td></td>
                                <td>{{ number_format((float)$tabTotals->driver_closing_balance, 2) }}</td>
                                <td></td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </section>

        <section class="excel-tab-panel" data-tab-panel="tab-ledger-factory">
            <div class="card">
                <div class="table-wrap">
                    <table>
                        <thead>
                            <tr>
                                <th>المصنع</th>
                                <th>نقلات أسمنت</th>
                                <th>مدفوعات</th>
                                <th>زيادات</th>
                                <th>خصومات</th>
                                <th>رصيد أول المدة</th>
                                <th>رصيد نهائي</th>
                                <th>ملاحظات</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($trips as $trip)
                                <tr>
                                    <td>{{ $trip->factory_name ?: '-' }}</td>
                                    <td>{{ number_format((float)$trip->factory_transport_count, 2) }}</td>
                                    <td>{{ number_format((float)$trip->factory_payments, 2) }}</td>
                                    <td>{{ number_format((float)$trip->factory_increases, 2) }}</td>
                                    <td>{{ number_format((float)$trip->factory_deductions, 2) }}</td>
                                    <td>{{ number_format((float)$trip->factory_opening_balance, 2) }}</td>
                                    <td>{{ number_format((float)$trip->factory_closing_balance, 2) }}</td>
                                    <td>{{ $trip->factory_notes ?: '-' }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="8">لا توجد بيانات</td></tr>
                            @endforelse
                            <tr class="sticky-footer">
                                <td>إجماليات المصنع</td>
                                <td></td>
                                <td>{{ number_format((float)$tabTotals->factory_payments, 2) }}</td>
                                <td>{{ number_format((float)$tabTotals->factory_increases, 2) }}</td>
                                <td>{{ number_format((float)$tabTotals->factory_deductions, 2) }}</td>
                                <td></td>
                                <td>{{ number_format((float)$tabTotals->factory_closing_balance, 2) }}</td>
                                <td></td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </section>

        <section class="excel-tab-panel" data-tab-panel="tab-ledger-company">
            <div class="card">
                <div class="table-wrap">
                    <table>
                        <thead>
                            <tr>
                                <th>الشركة</th>
                                <th>مدفوعات</th>
                                <th>شيكات تحت التحصيل</th>
                                <th>خصومات</th>
                                <th>خصم 1%</th>
                                <th>ضريبة السعر</th>
                                <th>صافي الربح بعد الضريبة</th>
                                <th>إجمالي صافي ربح</th>
                                <th>رصيد نهائي</th>
                                <th>عمر الفاتورة</th>
                                <th>عمر الإيصال</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($trips as $trip)
                                <tr>
                                    <td>{{ $trip->company_name }}</td>
                                    <td>{{ number_format((float)$trip->company_payments, 2) }}</td>
                                    <td>{{ number_format((float)$trip->company_checks_under_collection, 2) }}</td>
                                    <td>{{ number_format((float)$trip->company_deductions, 2) }}</td>
                                    <td>{{ number_format((float)$trip->company_discount_one_percent, 2) }}</td>
                                    <td>{{ number_format((float)$trip->tax_amount, 2) }}</td>
                                    <td>{{ number_format((float)$trip->net_profit_after_tax, 2) }}</td>
                                    <td>{{ number_format((float)$trip->total_net_profit_after_tax, 2) }}</td>
                                    <td>{{ number_format((float)$trip->company_closing_balance, 2) }}</td>
                                    <td>{{ $trip->invoice_age_days ?? '-' }}</td>
                                    <td>{{ $trip->receipt_age_days ?? '-' }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="11">لا توجد بيانات</td></tr>
                            @endforelse
                            <tr class="sticky-footer">
                                <td>إجماليات الشركة</td>
                                <td>{{ number_format((float)$tabTotals->company_payments, 2) }}</td>
                                <td>{{ number_format((float)$tabTotals->company_checks_under_collection, 2) }}</td>
                                <td>{{ number_format((float)$tabTotals->company_deductions, 2) }}</td>
                                <td>{{ number_format((float)$tabTotals->company_discount_one_percent, 2) }}</td>
                                <td>{{ number_format((float)$tabTotals->tax_amount, 2) }}</td>
                                <td>{{ number_format((float)$tabTotals->net_profit_after_tax, 2) }}</td>
                                <td>{{ number_format((float)$tabTotals->total_net_profit_after_tax, 2) }}</td>
                                <td>{{ number_format((float)$tabTotals->company_closing_balance, 2) }}</td>
                                <td></td>
                                <td></td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </section>
    </div>

    <div class="pagination">{{ $trips->links('partials.pagination') }}</div>

    <script>
        (() => {
            const root = document.querySelector('[data-tabs-root]');
            if (!root) return;
            const buttons = root.querySelectorAll('[data-tab-target]');
            const panels = root.querySelectorAll('[data-tab-panel]');
            const tables = root.querySelectorAll('table');

            tables.forEach((table) => {
                const headers = Array.from(table.querySelectorAll('thead th')).map((th) => th.textContent.trim());
                const rows = table.querySelectorAll('tbody tr:not(.sticky-footer)');
                rows.forEach((row) => {
                    row.querySelectorAll('td').forEach((td, index) => {
                        td.setAttribute('data-label', headers[index] ?? 'البيان');
                    });
                });
            });

            buttons.forEach((btn) => {
                btn.addEventListener('click', () => {
                    const target = btn.getAttribute('data-tab-target');
                    buttons.forEach((b) => b.classList.remove('active'));
                    btn.classList.add('active');
                    panels.forEach((panel) => {
                        panel.classList.toggle('active', panel.getAttribute('data-tab-panel') === target);
                    });
                });
            });
        })();
    </script>
    </div>
@endsection