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

<div class="pagetitle">
    <h1>Dashboard</h1>
    <nav>
      <ol class="breadcrumb">
        <li class="breadcrumb-item"><a href="{{ route('admin.dashboard') }}">Home</a></li>
        <li class="breadcrumb-item active">Dashboard</li>
      </ol>
    </nav>
  </div><!-- End Page Title -->

  <section class="section dashboard">
    <div class="row">

      <!-- Left side columns -->
      <div class="col-lg-12">
        <div class="row">

        @if(Auth::guard('admin')->user()->type == 'admin')
          <!-- Sales Card -->
          <div class="col-xxl-4 col-md-6">
            <div class="card info-card sales-card">
              <div class="card-body">
                <h5 class="card-title">Total Invested</h5>

                <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                        <span>xaf</span>
                    </div>
                  <div class="ps-3">
                    <h6>
                        <span>{{
                            number_format(array_sum(\App\Models\Item::get()->pluck("total_buying_price")->toArray()), 2)
                        }}</span>
                    </h6>
                  </div>
                </div>
              </div>

        </div>
          </div><!-- End Sales Card -->

          <!-- Revenue Card -->
          <div class="col-xxl-4 col-md-6">
            <div class="card info-card revenue-card">
              <div class="card-body">
                <h5 class="card-title">Expected Sales</h5>

                <div class="d-flex align-items-center">
                  <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                    <span>xaf</span>
                  </div>
                  <div class="ps-3">
                    <h6>
                        <span>{{
                            number_format(array_sum(\App\Models\Item::get()->pluck("total_selling_price")->toArray()), 2)
                        }}</span>
                    </h6>
                  </div>
                </div>
              </div>

            </div>
          </div><!-- End Revenue Card -->

          <div class="col-xxl-4 col-md-6">
            <div class="card info-card revenue-card">
              <div class="card-body">
                <h5 class="card-title">Total Discount</h5>

                <div class="d-flex align-items-center">
                  <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                    <span>xaf</span>
                  </div>
                  <div class="ps-3">
                    <h6>
                        <span>{{
                            number_format(array_sum(\App\Models\Order::get()->pluck("discount")->toArray()), 2)
                        }}</span>
                    </h6>
                  </div>
                </div>
              </div>

            </div>
          </div><!-- End Revenue Card -->

          <div class="col-xxl-4 col-md-6">
            <div class="card info-card revenue-card">
              <div class="card-body">
                <h5 class="card-title">Total Expenses</h5>

                <div class="d-flex align-items-center">
                  <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                    <span>xaf</span>
                  </div>
                  <div class="ps-3">
                    <h6>
                        <span>{{
                            number_format(array_sum(\App\Models\Expense::get()->pluck("amount")->toArray()), 2)
                        }}</span>
                    </h6>
                  </div>
                </div>
              </div>

            </div>
          </div><!-- End Revenue Card -->

          <!-- Customers Card -->
          <div class="col-xxl-4 col-xl-6">

            <div class="card info-card customers-card">

              <div class="card-body">
                <h5 class="card-title">Total After Discount</h5>

                <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                        <span>xaf</span>
                    </div>
                  <div class="ps-3">
                    <h6>
                        @php
                            $expectedSales = array_sum(\App\Models\Item::get()->pluck("total_selling_price")->toArray());
                            $discount = array_sum(\App\Models\Order::get()->pluck("discount")->toArray());
                            $expense = array_sum(\App\Models\Expense::get()->pluck("amount")->toArray());
                            $discountPlusExpense = $discount + $expense;

                            $remainingBalance = $expectedSales - $discountPlusExpense;
                        @endphp

                        {{ number_format($remainingBalance, 2) }}
                    </h6>
                  </div>
                </div>

              </div>
            </div>

          </div><!-- End Customers Card -->
          @endif
          <!-- Recent Sales -->
          <div class="col-12">
            <div class="card recent-sales overflow-auto">

              <div class="card-body">
                <div class="d-flex justify-content-between">
                    {{-- <h5 class="card-title">All System Orders</h5> --}}
                <h5 class="card-title">Recent Sales</h5>

                {{-- <p>Add lightweight datatables to your project with using the <a href="https://github.com/fiduswriter/Simple-DataTables" target="_blank">Simple DataTables</a> library. Just add <code>.datatable</code> class name to any table you wish to conver to a datatable. Check for <a href="https://fiduswriter.github.io/simple-datatables/demos/" target="_blank">more examples</a>.</p> --}}

                <!-- Table with stripped rows -->
                <div>
                    <form action="{{ route('admin.dashboard') }}" method="GET" id="filterForm" class="mt-5">
                        {{-- @csrf --}}
                        <label for="filter">Filter Order By Date</label>
                        <select name="date" id="" class="form-control">
                            <option value="">---Select Date---</option>
                            <option class="filterItem" value="all">All</option>
                            <option class="filterItem" value="today">Today</option>
                            <option class="filterItem" value="yesterday">Yesterday</option>
                            {{-- <option class="filterItem" value="last7days">Last 7 Days</option>
                            <option class="filterItem" value="last30days">Last 30 Days</option>
                            <option class="filterItem" value="lastyear">Last Year</option> --}}
                        </select>
                    </form>
                </div>
                </div>
                @if(Auth::guard('admin')->user()->type == 'admin')

                    <table class="table table-borderless datatable">
                        <thead>
                            <tr>
                                <th>Customer Name</th>
                                <th>Discount</th>
                                <th>Date Ordered</th>
                                <th>Status</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($orders as $order)
                            <tr>
                                <td>
                                    <span>
                                        {{-- <img width="50px" height="50px" src="{{ $order->item->image ? route('item.image',['file_name'=>$order->item->image]) : '#' }}" alt="."> --}}
                                    </span>
                                    <span>{{ $order->customer_name }}</span>
                                </td>
                                <td>
                                    {{ number_format($order->discount, 2) }}
                                </td>
                                <td>{{ $order->created_at->format('D-M-Y') }}</td>
                                <td>
                                    <x-adminstatus :status='$order->status' />
                                </td>
                                <td>
                                    <a href="{{ route('admin.orders.show',['order'=>$order->id]) }}" class="btn btn-primary">Details</a>
                                </td>
                            </tr>

                        @empty
                            <tr>
                                <td class="colspan-12">
                                    No Orders Yet.
                                    Please   <a href="{{ route('admin.orders.create') }}" class="btn border">PROCESS AN ORDER <span class="bi bi-arrow-right"></span> </a>
                                </td>
                            </tr>
                        @endforelse
                        </tbody>
                    </table>
                @else
                    <table class="table table-borderless datatable">
                        <thead>
                            <tr>
                                <th>Customer Name</th>
                                <th>Discount</th>
                                <th>Date Ordered</th>
                                <th>Status</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($workerOrders as $order)
                            <tr>
                                <td>
                                    <span>
                                        {{-- <img width="50px" height="50px" src="{{ $order->item->image ? route('item.image',['file_name'=>$order->item->image]) : '#' }}" alt="."> --}}
                                    </span>
                                    <span>{{ $order->customer_name }}</span>
                                </td>
                                <td>
                                    {{ number_format($order->discount, 2) }}
                                </td>
                                <td>{{ $order->created_at->format('D-M-Y') }}</td>
                                <td>
                                    <x-adminstatus :status='$order->status' />
                                </td>
                                <td>
                                    <a href="{{ route('admin.orders.show',['order'=>$order->id]) }}" class="btn btn-primary">Details</a>
                                </td>
                            </tr>

                        @empty
                            <tr>
                                <td class="colspan-12">
                                    No Orders Yet. @if(isset($date)) For: {{ $date }} @endif
                                    Please   <a href="{{ route('admin.orders.create') }}" class="btn border">PROCESS AN ORDER <span class="bi bi-arrow-right"></span> </a>
                                </td>
                            </tr>
                        @endforelse
                        </tbody>
                    </table>

                  <p>
                    Total Sales
                    @if(isset($date)) For: {{ $date }} @endif
                    <b class="text-success">{{ number_format($totalWorkerSale) }} </b>
                 </p>
                @endif

              </div>

            </div>
          </div><!-- End Recent Sales -->

        </div>
      </div><!-- End Left side columns -->
    </div>
  </section>

@endsection
@section('footer_scripts')

<script>
    $(function(){
        $(".filterItem").click(function(){
            $('#filterForm').submit();
        })
    })
</script>

@endsection