@extends('layouts.app_booking')
@section('title', __('restaurant.bookings'))

@section('content')
    <section class="content-header no-print">
        <nav aria-label="breadcrumb">
            <ol class="breadcrumb breadcrumb-style1">
                <li class="breadcrumb-item">
                    <a href="#">{{__('home.home')}}</a>
                </li>
                <li class="breadcrumb-item">
                    <a href="#">{{__('restaurant.bookings')}}</a>
                </li>
                <li class="breadcrumb-item active">{{__('new.day_details')}} ({{$selected_date}})</li>
            </ol>
        </nav>

    </section>
    <!-- Main content -->
    <section class="content no-print">
        @component('components.widget', ['class' => 'card'])
            <div class="table-responsive text-nowrap"  style="max-height: 600px; overflow: auto;">
                <table class="table table-bordered content-table" >
                    <thead>
                    <tr >
                        <td class="text-white"> </td>
                        @foreach($availableTimes as $times)
                            <td class="text-white"> {{$times}} 🕒 </td>
                        @endforeach

                    </tr>
                    </thead>
                    <tbody>
                    @foreach($waiters as $waiter)
                        @php
                          $count =  DB::table('transaction_sell_lines as tsl')
                                       ->join('bookings as b', 'tsl.booking_id', '=', 'b.id')
                                       ->join('transactions as t', 'b.id', '=', 't.booking_id')
                                       ->join('contacts as c', 't.contact_id', '=', 'c.id') // 👤 العميل
                                       ->join('products as p', 'tsl.product_id', '=', 'p.id') // 📦 المنتج
                                       ->join('users as u', 'tsl.res_service_staff_id', '=', 'u.id') // 👨‍💼 الموظف
                                        ->whereDate('tsl.booking_start_time', $selected_date)
                                       ->where('tsl.res_service_staff_id', $waiter->id)->count();
                        @endphp
                        <tr>
                            <td  class="table-primary ">
                                {{$waiter->surname ??  $waiter->first_name .' '.$waiter->last_name}}
                                <br>
                                <small class="text-muted"> {{__('new.total_bookings') .' : ' . $count }}</small>
                            </td>
                            @foreach($availableTimes as $time)
                                @php
                                    $staff_id =$waiter->id;
                                    $fullDateTime = Carbon::createFromFormat('Y-m-d H:i', $selected_date . ' ' . $time)->format('Y-m-d H:i:s');

                                              // 📌 تنفيذ الاستعلام لجلب جميع تفاصيل الحجز
                                   $booking = DB::table('transaction_sell_lines as tsl')
                                       ->join('bookings as b', 'tsl.booking_id', '=', 'b.id')
                                       ->join('transactions as t', 'b.id', '=', 't.booking_id')
                                       ->join('contacts as c', 't.contact_id', '=', 'c.id') // 👤 العميل
                                       ->join('products as p', 'tsl.product_id', '=', 'p.id') // 📦 المنتج
                                       ->join('users as u', 'tsl.res_service_staff_id', '=', 'u.id') // 👨‍💼 الموظف
                                        ->whereTime('tsl.booking_start_time', $time)
                                         ->where('tsl.booking_start_time', '=', $fullDateTime) // ✅ البحث بتاريخ + وقت معًا
                                       ->where('b.location_id', $location_id)
                                       ->where('tsl.res_service_staff_id', $staff_id)
                                       ->select(
                                           't.id as transaction_id',
                                           'b.id as booking_id',
                                           'b.created_by as booking_by',
                                           'b.booking_status as booking_status',
                                           'b.created_by as booking_created_by',
                                           'tsl.res_service_staff_id as staff_id',
                                           'u.first_name as staff_first_name',
                                           'u.last_name as staff_last_name',
                                           't.location_id as branch_id',
                                           't.invoice_no as invoice_no',
                                           'c.id as customer_id',
                                           'c.name as customer_name',
                                           'c.mobile as customer_phone',
                                           'p.id as product_id',
                                           'p.name as product_name',
                                           'tsl.booking_start_time as start_time',
                                           'tsl.booking_end_time as end_time'
                                       )
                                       ->first(); // ✅ جلب أول سجل فقط
                                @endphp
                                <td @if($booking && $booking->booking_status == 'waiting') class="bg-warning"
                                    @elseif($booking && $booking->booking_status == 'completed') class="bg-success"
                                    @elseif($booking && $booking->booking_status == 'cancelled') class="bg-danger"
                                        @endif>
                                    @if($booking)
                                        <a href="javascript:void(0);" class="  btn-modal d-flex justify-content-between"
                                           data-href="{{ action([\App\Http\Controllers\SellController::class, 'show'], [$booking->transaction_id]) }}"
                                           data-container=".view_modal"
                                        >
                                            <div class="li-wrapper d-flex justify-content-start align-items-center">
                                                <div class="avatar me-3">
                                                                 <span class="avatar-initial rounded-circle bg-label-success">
                                                                     @if($booking->customer_name)
                                                                         {{mb_substr($booking->customer_name, 0, 1, 'utf-8')}}
                                                                     @endif
                                                                 </span>
                                                </div>
                                                <div class="list-content">
                                                    <h6 class="mb-0 fw-normal">{{$booking->customer_name ?? ""}}</h6>
                                                    <small class="text-body">{{$booking->product_name ?? ""}}</small><br>
                                                    <small  > {{ __('new.booking_no') .' : '. $booking->invoice_no ?? ""}}</small><br>
                                                    <small  > {{ __('new.booking_by') .' : '. \App\User::find($booking->booking_by)->first_name .' ' .\App\User::find($booking->booking_by)->last_name
                                                            }}</small>
                                                </div>
                                            </div>

                                        </a>

                                    @endif
                                </td>
                            @endforeach
                        </tr>
                    @endforeach
                    </tbody>
                </table>
            </div>
        @endcomponent

    </section>
    <!-- /.content -->
    <section class="invoice print_section" id="receipt_section">
    </section>
@endsection

@section('css')
    <style>


        /* أمثلة تحسينات عامة للجدول */
        .content-table {
            border-collapse: separate;
            border-spacing: 0;
        }

        .content-table th,
        .content-table td {
            text-align: center;
            vertical-align: middle;
            padding: 0.75rem 1rem;
        }

        /* تغيير خلفية الثيود */
        .content-table thead {
            background-color: #2c3e50; /* لون غامق */
        }
        .content-table thead td,
        .content-table thead th {
            color: #fff;
            font-weight: 600;
        }

        /* حدود الخلايا */
        .content-table th,
        .content-table td {
            border: 1px solid #dee2e6;
        }

        /* لون خلفية الموظف (العمود الأول) */
        .content-table .table-primary {
            background-color: #f0f8ff !important; /* لون قريب من الأزرق الفاتح */
            color: #333;
            font-weight: 600;
        }

        /* لون مختلف عند التمرير على الصف */
        .content-table tbody tr:hover {
            background-color: #f8f9fa;
        }

        /* تنسيق خاص بالخلايا التي تحتوي على حجز */
        .content-table td .btn-modal {
            text-decoration: none;
            display: block;
            color: #333;
            padding: 0.4rem 0.6rem;
            border-radius: 0.3rem;
            transition: background-color 0.2s ease-in-out;
        }

        .content-table td .btn-modal:hover {
            background-color: #e9ecef; /* لون خفيف عند المرور */
        }

        /* تنسيق مخصص لحالة الانتظار (waiting) */
        .content-table td.bg-warning {
            background-color: #ffefc2 !important; /* درجة من الأصفر */
        }

        /* تنسيق مخصص لحالة المنتهية (completed) */
        .content-table td.bg-success {
            background-color: #d2f8d2 !important; /* درجة من الأخضر الفاتح */
        }
        content-table thead th,
        .content-table thead td {
            position: sticky;
            top: 0;
            z-index: 10; /* تأكد من أنه أعلى من الخلايا الأخرى */
            background-color: #2c3e50; /* أو أي لون تريد */
            color: #fff;
        }

        /* اجعل العمود الأول sticky */
        .content-table tbody th.table-primary,
        .content-table tbody td:first-child {
            position: sticky;
        {{app()->getLocale() == 'ar' ? 'right' : 'left' }} : 0;
            z-index: 9; /* أقل من الـ thead بقليل, أو أعلى إن لزم */
            background-color: #f0f8ff; /* اللون الخلفي للعمود الأول */
        }
    </style>

    @endsection