@extends('principal.layouts.app')
@push('style')
    <link rel="stylesheet" href="//cdn.datatables.net/1.13.1/css/jquery.dataTables.min.css">
@endpush
@section('content')
    <section class="section dashboard">
        <div class="inner-sec-dashboard">
            <div class="row ">
              <div class="line-hdr">
                <h4>Dashboard</h4>
              </div>
              <div class="conter-top-sec">

                {{-- <div class="c-box active">
                  <h6>Total User</h6>
                  <h4>230000</h4>
                </div> --}}

                <div class="c-box">
                  <h6>Apporved Request</h6>
                  <h4>{{ $approvedtotalTransaction ?? 0}}</h4>
                </div>

                <div class="c-box">
                  <h6>Rejected Request</h6>
                  <h4>{{ $rejrejectedtotalTransaction ?? 0 }}</h4>
                </div>


                <div class="c-box">
                  <h6>Pending Request</h6>
                  <h4>{{ $pendingtotalTransaction ?? 0 }}</h4>
                </div>


              </div>
      </div>

      <div class="pagetitle-row">
        <div class="row">
       <div class="col-lg-10 ">
        <form form action="" method="GET">
            <div class="row">
                <div class="col-lg-3 col-sm-4 col-12">
                    <input type="date" class="form-control" id="startDate" name="startDate"
                        value="{{ !empty($_REQUEST['startDate']) ? $_REQUEST['startDate'] : '' }}">
                </div>

                <div class="col-lg-3 col-sm-4 col-12">
                    <input type="date" class="form-control" id="endDate" name="endDate"
                        value="{{ !empty($_REQUEST['endDate']) ? $_REQUEST['endDate'] : '' }}">
                </div>

                <div class="col-lg-3 col-sm-4 col-12">
                    <select class="form-select" aria-label="Default select example" id="status"
                        name="status">
                        <option selected="">Status</option>
                        <option value="1">Approved</option>
                        <option value="2">Rejected</option>
                        <option value="3">Pending</option>
                    </select>
                </div>
                <div class="col-lg-2 col-sm-2 col-12">
                    <button type="submit"><i class="fa-solid fa-magnifying-glass"></i> Search</button>
                </div>
                <div class="col-lg-1 col-sm-2 col-12">
                    <a href="{{ route('principal.dashboard') }}" class="btn btn-warning"> Reset</a>
                </div>
            </div>
        </form>
          </div>

          <div class="col-lg-2"></div>

        </div>
      </div>
              <div class="row">

                <div class="col-lg-12 col-sm-12 col-12">
                  <div class="performance-statistics row">
                    <table class="table table-borderless">
                        <thead>
                            <tr>
                                <th scope="col">Request ID</th>
                                <th scope="col">Conference Name</th>
                                <th scope="col">Conference Date</th>
                                <th scope="col">Total Cost</th>
                                <th scope="col">Status</th>
                                <th scope="col">View Details</th>
                            </tr>
                        </thead>
                        <tbody>

                            @forelse ($conferenceLists as $conferenceList)

                                <tr>
                                    <td>{{'REQ' . '_' . Str::random(8) }}</td>
                                    <td>{{ $conferenceList->conference_title }}</td>
                                     <td>{{ date('d-m-Y', strtotime($conferenceList->created_at)) }}</td>
                                     <td><i class="fa-solid fa-dollar-sign"></i>&nbsp; {{number_format($conferenceList->registratiion_no + $conferenceList->lodging?->sum('lodging') + $conferenceList->meals?->sum('meal') + $conferenceList->milages?->sum('milage') + $conferenceList->miscellaneous?->sum('miscellaneous') + $conferenceList->parking?->sum('parking') + $conferenceList->toll?->sum('tolls'), 2) }}
                                     </td>
                                    <td>@if($conferenceList->is_approved==1 &&
                                        $conferenceList->principal_id == auth()->user()->id){{ "Approved" }}
                                    @elseif($conferenceList->is_approved==2 &&
                                    $conferenceList->principal_id == auth()->user()->id){{ "Rejected" }}
                                    @else {{ "Pending" }}
                                    @endif

                                </td>
                                    <td><a class="icon show" href="{{ route('principal.conference.detail', ['id' => $conferenceList->id]) }}"
                                            aria-expanded="true"><i class="fa-solid fa-eye"></i></a></td>

                                @empty
                                <tr>
                                    <td colspan="6">No conferences found.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                  </div>
                </div>

              </div>
          </div>
    </section>
@endsection
@push('scripts')
@endpush