@extends('supertiendent.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">
                <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('district-admin.dashboard') }}" class="btn btn-warning"> Reset</a>
                        </div>
                    </div>
                </form>
            </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">School</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->schools?->school_name }}</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->is_sup_approved == 1 &&
                                                    $conferenceList->superentiend_id == auth()->user()->id)
                                                {{ 'Approved' }}
                                            @elseif(
                                                $conferenceList->is_approved == 2 &&
                                                    $conferenceList->is_sup_approved == 2 &&
                                                    $conferenceList->superentiend_id == auth()->user()->id)
                                                {{ 'Rejected' }}
                                            @else
                                                {{ 'Pending' }}
                                            @endif
                                        </td>
                                        <td><a class="icon show"
                                                href="{{ route('district-admin.conference.detail', ['id' => $conferenceList->id]) }}"
                                                aria-expanded="true"><i class="fa-solid fa-eye"></i></a></td>
                                    @empty
                                    <tr>
                                        <td colspan="7">No conferences found.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>

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