@extends('account_manager.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 Request</h6>
                        <h4>230000</h4>
                    </div> --}}

                    <div class="c-box">
                        <h6>Total Paid</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('account-manager.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 acnt-mngr">
                        <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">Approval Cost</th>
                                    <th scope="col">Total Cost</th>
                                    <th scope="col">Approved By</th>
                                    <th scope="col">Status</th>
                                    <th scope="col">View Details</th>
                                </tr>
                            </thead>
                            <tbody>

                                @forelse ($conferenceLists as $conferenceList)
                                <tr>
                                    <td>{{ '#' . substr(md5(microtime()), 0, 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->lodgingApproval?->sum('lodging') + $conferenceList->mealsApproval?->sum('meal') + $conferenceList->milagesApproval?->sum('milage') + $conferenceList->miscellaneousApproval?->sum('miscellaneous') + $conferenceList->parkingApproval?->sum('parking') + $conferenceList->tollApproval?->sum('tolls'), 2) }}
                                    </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_principal_approved == 1 &&
                                                $conferenceList->is_sup_approved == 1 &&
                                                $conferenceList->principal_id != null &&
                                                $conferenceList->superentiend_id != null)
                                            <span>{{ $conferenceList->principals?->first_name . ' ' . $conferenceList->principals?->last_name . '(' . 'Principal' . ')' }}</span><br>
                                            <span>{{ $conferenceList->superentiends?->first_name . ' ' . $conferenceList->superentiends?->last_name . '(' . 'Superentiend' . ')' }}</span>
                                        @elseif(
                                            $conferenceList->is_approved == 1 &&
                                                $conferenceList->is_principal_approved == 1 &&
                                                $conferenceList->principal_id != null)
                                            <span>{{ $conferenceList->principals?->first_name . ' ' . $conferenceList->principals?->last_name . '(' . 'Principal' . ')' }}</span>
                                        @elseif(
                                            $conferenceList->is_approved == 1 &&
                                                $conferenceList->is_sup_approved == 1 &&
                                                $conferenceList->superentiend_id != null)
                                            <span>{{ $conferenceList->superentiends?->first_name . ' ' . $conferenceList->superentiends?->last_name . '(' . 'Superentiend' . ')' }}</span>
                                            {{-- @elseif($conferenceList->is_approved == 2)
                                            {{ 'rejected' }} --}}
                                        @else
                                            {{ 'Pending' }}
                                        @endif
                                    </td>
                                    <td>
                                        @if (
                                            $conferenceList->is_mark_as_paid == 1 &&
                                                $conferenceList->account_manager_id == auth()->user()->id &&
                                                $conferenceList->is_all_approved == 1)
                                            {{ 'Finalized' }}
                                        @elseif (
                                            $conferenceList->is_mark_as_paid == 1 &&
                                                $conferenceList->account_manager_id == auth()->user()->id &&
                                                $conferenceList->is_all_approved == 0)
                                            {{ 'Mark As Paid' }}
                                        {{-- @elseif (
                                            $employee_conferences->is_mark_as_paid == 0 &&
                                                $employee_conferences->account_manager_id == auth()->user()->id &&
                                                $employee_conferences->is_all_approved == 0)
                                            {{ 'Mark As Paid' }} --}}
                                        @elseif($conferenceList->is_approved == 2 && $conferenceList->account_manager_id == auth()->user()->id)
                                            {{ 'Rejected' }}
                                        @else
                                            {{ 'Pending' }}
                                        @endif
                                    </td>

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

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

            </div>
        </div>
    </section>
@endsection
@push('scripts')
    {{-- <script>
        $(document).ready(function() {
            loadData();
            loadDataSchoolAdmin();
            loadDataconferenceTable();
        })
        const loadData = () => {

            var dataTable = $('#districtsDatatable').DataTable({
                dom: 'Bfrtip',
                processing: true,
                serverSide: false,
                autoWidth: false,
                responsive: true,
                searching: true,
                buttons: [{
                        extend: 'pdf',
                        footer: true,
                        exportOptions: {
                            columns: "thead th:not(.noExport)"
                        }
                    },
                    {
                        extend: 'csv',
                        footer: true,
                        exportOptions: {
                            columns: "thead th:not(.noExport)"
                        }

                    },
                    {
                        extend: 'excel',
                        footer: true,
                        exportOptions: {
                            columns: "thead th:not(.noExport)"
                        }
                    }
                ]


            });
        }
        const loadDataSchoolAdmin = () => {

            var dataTable = $('#newShowsssDatatable').DataTable({
                dom: 'Bfrtip',
                processing: true,
                serverSide: false,
                autoWidth: false,
                responsive: true,
                searching: true,
                buttons: [{
                        extend: 'pdf',
                        footer: true,
                        exportOptions: {
                            columns: "thead th:not(.noExport)"
                        }
                    },
                    {
                        extend: 'csv',
                        footer: true,
                        exportOptions: {
                            columns: "thead th:not(.noExport)"
                        }

                    },
                    {
                        extend: 'excel',
                        footer: true,
                        exportOptions: {
                            columns: "thead th:not(.noExport)"
                        }
                    }
                ]


            });
        }

        const loadDataconferenceTable = () => {

            var dataTable = $('#conferencessDatatable').DataTable({
                dom: 'Bfrtip',
                processing: true,
                serverSide: false,
                autoWidth: false,
                responsive: true,
                searching: true,
                buttons: [{
                        extend: 'pdf',
                        footer: true,
                        exportOptions: {
                            columns: "thead th:not(.noExport)"
                        }
                    },
                    {
                        extend: 'csv',
                        footer: true,
                        exportOptions: {
                            columns: "thead th:not(.noExport)"
                        }

                    },
                    {
                        extend: 'excel',
                        footer: true,
                        exportOptions: {
                            columns: "thead th:not(.noExport)"
                        }
                    }
                ]


            });
        }
    </script> --}}
@endpush