@extends('supertiendent.layouts.app')
@push('style')
@endpush
@section('content')
    <section class="section dashboard">
        <div class="inner-sec-dashboard">
            <div class="row ">
                <div class="line-hdr">
                    <h4>Request</h4>
                </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-4 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.conference.list') }}" 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" id="conferenceTwoDatatable">
                            <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>{{ '#' .  substr(md5(microtime()), 0, 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')
    <script src="{{ asset('assets/admin/tinymce/tinymce.min.js') }}"></script>
    <script src="{{ asset('assets/admin/js/editor.js') }}"></script>
    <script src="{{ asset('assets/plugins/bootstrap-tagsinput.js') }}"></script>
    <script>
        $(document).ready(function() {
            loadData();
        })
        const loadData = () => {
            //   $('#bannerTable').DataTable().destroy();
            var dataTable = $('#conferenceTwoDatatable').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>
    <script>
        $(document).on("click", "#viewDetail", function() {
            const registratiion_no = $("#registratiion_no").val();
            console.log(registratiion_no);
        });
    </script>

    <script>
        $(document).on("click", ".editButton", function() {
            console.log("test");
            const allvalue = JSON.parse($(this).attr('data-value'));
            console.log(allvalue);
            const {
                id,
                name,
                position,
                conference_title,
                conference_url,
                location,
                conference_date,
                conference_phone_number,
                conference_account_number,
                conference_po_number,
                attend_reason,
            } = allvalue;
            $('#name').val(name);
            $('#id').val(id);
            $('#position').val(position);
            $('#conferenceTitle').val(conference_title);
            $('#conference_url').val(conference_url);
            $('#location').val(location);

            $('#conference_date').val(conference_date);
            $('#conference_phone_number').val(conference_phone_number);
            $('#conference_account_number').val(conference_account_number);
            $('#attend_reason').val(attend_reason);

            $('#conferenceDetailModal').show();
            //console.log(profile_image)
        });
    </script>
@endpush

@section('modal')
@endsection