@extends('layouts.admin')
@section('title', 'Order')
@section('content')
<section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1>Orders</h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="{{url('admin/home')}}">Home</a></li>
              <li class="breadcrumb-item active">Orders</li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>
<!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row">
          <div class="col-12">
            <div class="card">
              <div class="card-header">
                <h3 class="card-title">All Orders listing</h3>
              </div>

              <!-- /.card-header -->
              <div class="card-body">
                <!-- will be used to show any messages -->
                @if (Session::has('message'))
                    <div class="alert alert-info">{{ Session::get('message') }}</div>
                @endif
                <table id="example1" class="table table-bordered table-striped">
                  <thead>
                  <tr>
                    <th>ID</th>
                    <th>Invoice Code</th>
                    <th>Caterer Name</th>
                    <th>Customer</th>
                    <th>Payment Type</th>
                    <th>Invoice Date</th>
                    <th>No Of Products</th>
                    <th>Order Status</th>
                    <th>Action</th>
                  </tr>
                  </thead>
                  <tbody>
                  @foreach($data as $datas) 
                  @php $caterer=DB::table('caterers')->where('id',$datas->caterer_id)->first(); 
                   $user=DB::table('users')->where('id',$datas->customer_id)->first(); 
                   $order_items_count=DB::table('order_items')->where('order_id',$datas->id)->count(); @endphp 
                  <tr>
                    <td>{{$datas->id}}</td>
                    <td>{{$datas->invoice_id}}</td>
                    <td>{{$caterer->name}}</td>
                    <td>{{$user->first_name}} {{$user->last_name}}</td>
                    <td>{{$datas->payment_type}}</td>
                    <td>{{$datas->invoice_date}}</td>
                    <td>{{$order_items_count}}</td>
                    <td><a href="#" class="btn btn-success">{{$datas->order_status}}</a></td>
                    
                     <td><a href="{{url('admin/orders/'.$datas->id.'/edit')}}"><i class="nav-icon fas fa-eye"></i></a></td>
                  </tr>
                  @endforeach
                  </tbody>
                  <tfoot>
                  <tr>
                    <th>ID</th>
                    <th>Invoice Code</th>
                    <th>Caterer Name</th>
                    <th>Customer</th>
                    <th>Payment Type</th>
                    <th>Invoice Date</th>
                    <th>No Of Products</th>
                    <th>Order Status</th>
                    <th>Action</th>
                  </tr>
                  </tfoot>
                </table>
              </div>
              <!-- /.card-body -->
            </div>
            <!-- /.card -->
          </div>
          <!-- /.col -->
        </div>
        <!-- /.row -->
      </div>
      <!-- /.container-fluid -->
    </section>
    <!-- /.content -->
@endsection