@extends('admin.layouts.master')
@section('title', 'Dashboard')
@section('content')

    <div class="content-header">
        <div class="container-fluid">
            <div class="row">
                <div class="col-sm-6">
                    <h1 class="m-0 text-dark">{{ __('Welcome back,') }} {{ Auth::user()->name }}!</h1>
                </div>
            </div>
        </div>
    </div>

    <div class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <h4>Today Orders</h4>
                </div>

                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.orders') }}">
                    <div class="info-box bg-info">
                      <span class="info-box-icon"><i class="fas fa-shopping-cart"></i></span>
                      <div class="info-box-content">
                        <span class="info-box-text">Total Orders</span>
                        <span class="info-box-number">{{ \App\Models\Order::whereDate('created_at', today())->count() }}</span>
                      </div>
                    </div>
                  </a>
                </div>

                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.packingOrders') }}">
                    <div class="info-box bg-success">
                      <span class="info-box-icon"><i class="fas fa-box"></i></span>
                      <div class="info-box-content">
                        <span class="info-box-text">Packing Orders</span>
                        <span class="info-box-number">{{ \App\Models\Order::where('delivery_status', 'packing')->whereDate('created_at', today())->count() }} -- Packed {{ \App\Models\Order::where('delivery_status', 'packed')->where('created_at', today())->count() }}</span>
                      </div>
                    </div>
                  </a>
                </div>

                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.dispatchOrders') }}">
                    <div class="info-box bg-warning">
                      <span class="info-box-icon"><i class="fas fa-truck"></i></span>
                      <div class="info-box-content">
                        <span class="info-box-text">Dispatch Orders</span>
                        <span class="info-box-number">{{ \App\Models\Order::where('delivery_status', 'dispatched')->whereDate('created_at', today())->count() }}</span>
                      </div>
                    </div>
                  </a>
                </div>

                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.completedOrders') }}">
                    <div class="info-box bg-danger">
                      <span class="info-box-icon"><i class="fas fa-check-circle"></i></span>
                      <div class="info-box-content">
                        <span class="info-box-text">Completed Orders</span>
                        <span class="info-box-number">{{ \App\Models\Order::where('delivery_status', 'completed')->whereDate('created_at', today())->count() }}</span>
                      </div>
                    </div>
                  </a>
                </div>

                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.pendingOrders') }}">
                    <div class="info-box bg-warning">
                      <span class="info-box-icon"><i class="fas fa-clock"></i></span>
                      <div class="info-box-content">
                        <span class="info-box-text">Pending Orders</span>
                        <span class="info-box-number">{{ \App\Models\Order::where('approval_status', 'pending')->whereDate('created_at', today())->count() }}</span>
                      </div>
                    </div>
                  </a>
                </div>

                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.approvedOrders') }}">
                    <div class="info-box bg-success">
                      <span class="info-box-icon"><i class="fas fa-thumbs-up"></i></span>
                      <div class="info-box-content">
                        <span class="info-box-text">Approved Orders</span>
                        <span class="info-box-number">{{ \App\Models\Order::where('approval_status', 'approved')->whereDate('created_at', today())->count() }}</span>
                      </div>
                    </div>
                  </a>
                </div>

                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.declinedOrders') }}">
                    <div class="info-box bg-danger">
                      <span class="info-box-icon"><i class="fas fa-times-circle"></i></span>
                      <div class="info-box-content">
                        <span class="info-box-text">Declined Orders</span>
                        <span class="info-box-number">{{ \App\Models\Order::where('approval_status', 'decline')->whereDate('created_at', today())->count() }}</span>
                      </div>
                    </div>
                  </a>
                </div>

                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.cancelledOrders') }}">
                    <div class="info-box bg-info">
                      <span class="info-box-icon"><i class="fas fa-ban"></i></span>
                      <div class="info-box-content">
                        <span class="info-box-text">Cancelled Orders</span>
                        <span class="info-box-number">{{ \App\Models\Order::where('approval_status', 'canceled')->whereDate('created_at', today())->count() }}</span>
                      </div>
                    </div>
                  </a>
                </div>

                <div class="col-12">
                    <h4>Today Invoices</h4>
                </div>

                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.invoices') }}">
                    <div class="info-box bg-info">
                      <span class="info-box-icon"><i class="fas fa-file-invoice-dollar"></i></span>
                      <div class="info-box-content">
                        <span class="info-box-text">Total Invoices</span>
                        <span class="info-box-number">{{ \App\Models\Invoice::whereDate('created_at', today())->count() }}</span>
                      </div>
                    </div>
                  </a>
                </div>

                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.draftInvoices') }}">
                    <div class="info-box bg-secondary">
                      <span class="info-box-icon"><i class="fas fa-edit"></i></span>
                      <div class="info-box-content">
                        <span class="info-box-text">Draft Invoices</span>
                        <span class="info-box-number">{{ \App\Models\Order::where('invoice_status', 'draft')->whereDate('created_at', today())->count() }}</span>
                      </div>
                    </div>
                  </a>
                </div>

                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.performaInvoices') }}">
                    <div class="info-box bg-dark">
                      <span class="info-box-icon"><i class="fas fa-file-alt"></i></span>
                      <div class="info-box-content">
                        <span class="info-box-text">Proforma Invoices</span>
                        <span class="info-box-number">{{ \App\Models\Order::where('invoice_status', 'performa')->whereDate('created_at', today())->count() }}</span>
                      </div>
                    </div>
                  </a>
                </div>

                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.invoicedInvoices') }}">
                    <div class="info-box bg-success">
                      <span class="info-box-icon"><i class="fas fa-receipt"></i></span>
                      <div class="info-box-content">
                        <span class="info-box-text">Invoiced</span>
                        <span class="info-box-number">{{ \App\Models\Order::where('invoice_status', 'invoiced')->whereDate('created_at', today())->count() }}</span>
                      </div>
                    </div>
                  </a>
                </div>

                <div class="col-12">
                    <h4>Today Customers</h4>
                </div>
                
                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.customers') }}">
                    <div class="info-box bg-info">
                        <span class="info-box-icon"><i class="fas fa-users"></i></span>
                        <div class="info-box-content">
                            <span class="info-box-text">Total Customers</span>
                            <span class="info-box-number">
                              {{ \App\Models\User::whereHas('roles', function ($query) {
                              $query->where('name', 'customer');
                          })->whereDate('created_at', operator: today())->count() }}</span>
                        </div>
                    </div>
                  </a>
                </div>
                
                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.activeCustomers') }}">
                    <div class="info-box bg-success">
                        <span class="info-box-icon"><i class="fas fa-user-check"></i></span>
                        <div class="info-box-content">
                            <span class="info-box-text">Active Customers</span>
                            <span class="info-box-number">{{ \App\Models\User::whereHas('roles', function ($query) {
                              $query->where('name', 'customer');
                          })->whereDate('created_at', operator: today())->where('status', 'active')->count() }}</span>
                        </div>
                    </div>
                  </a>
                </div>
                
                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.blockedCustomers') }}">
                    <div class="info-box bg-danger">
                        <span class="info-box-icon"><i class="fas fa-user-times"></i></span>
                        <div class="info-box-content">
                            <span class="info-box-text">Blocked Customers</span>
                            <span class="info-box-number">{{ \App\Models\User::whereHas('roles', function ($query) {
                              $query->where('name', 'customer');
                          })->whereDate('created_at', operator: today())->where('status', 'blocked')->count() }}</span>
                        </div>
                    </div>
                  </a>
                </div>
                
                <div class="col-md-3 col-sm-6 col-12">
                  <a href="{{ route('admin.today.pendingCustomers') }}">
                    <div class="info-box bg-warning">
                        <span class="info-box-icon"><i class="fas fa-user-clock"></i></span>
                        <div class="info-box-content">
                            <span class="info-box-text">Pending Customers</span>
                            <span class="info-box-number">{{ \App\Models\User::whereHas('roles', function ($query) {
                              $query->where('name', 'customer');
                          })->whereDate('created_at', operator: today())->where('status', 'pending')->count() }}</span>
                        </div>
                    </div>
                  </a>
                </div>
                

            </div>
        </div>
    </div>

@endsection