@extends('admin/layouts/default')

@section('title')
    Maintenance Requests List
    @parent
@stop

@section('content')
    <section class="content-header">
        <h1>Request History</h1>
        <ol class="breadcrumb">
            <li><a href="{{ route('dashboard') }}"><i class="livicon" data-name="home"></i> Dashboard</a></li>
            <li>Maintenance Requests</li>
            <li class="active">Maintenance Requests</li>
        </ol>
    </section>

    <section class="content paddingleft_right15">
        <div class="row">
            <div class="panel panel-primary">
                <div class="panel-heading clearfix">
                    <h4 class="panel-title pull-left">
                        <i class="livicon" data-name="list-ul"></i> Maintenance Requests List
                    </h4>
                </div>

                <div class="panel-body">

                    <ul class="nav nav-tabs">
                        <li class="active"><a href="#tab1" data-toggle="tab">Maintenance Requests</a></li>
                        <li><a href="#tab2" data-toggle="tab">Feedback</a></li>
                    </ul>

                    <div class="tab-content">

                        <!-- TAB 1 -->
                        <div class="tab-pane fade in active" id="tab1">
                            @php
                                $email = Sentinel::getUser()->email;
                                $maintenancerequest = DB::table('staffrequests')
                                    ->where('feedback', '0')
                                    ->where('email', $email)
                                    ->get();
                            @endphp

                            <br>

                            <div style="overflow-x:auto;">
                                <table class="table table-bordered">
                                    <thead>
                                    <tr>
                                        <th>Ticket No.</th>
                                        <th>Firstname</th>
                                        <th>Lastname</th>
                                        <th>Phone</th>
                                        <th>Idnumber</th>
                                        <th>College</th>
                                        <th>Department</th>
                                        <th>Buildingno</th>
                                        <th>Office</th>
                                        <th>Requestcategory</th>
                                        <th>Description</th>
                                        <th>Assigned Expert</th>
                                        <th>Feedback</th>
                                    </tr>
                                    </thead>

                                    <tbody>
                                    @forelse($maintenancerequest as $row)
                                        <tr>
                                            <td>{{ $row->id }}</td>
                                            <td>{{ $row->firstname }}</td>
                                            <td>{{ $row->lastname }}</td>
                                            <td>{{ $row->phone }}</td>
                                            <td>{{ $row->idnumber }}</td>
                                            <td>{{ $row->college }}</td>
                                            <td>{{ $row->department }}</td>
                                            <td>{{ $row->buildingno }}</td>
                                            <td>{{ $row->office }}</td>
                                            <td>{{ $row->requestcategory }}</td>

                                            <td>
                                                <button class="btn btn-info btn-sm"
                                                        onclick="openDescriptionModal(`{!! nl2br(e($row->description)) !!}`)">
                                                    View Description
                                                </button>
                                            </td>

                                            @php
                                                $expert = DB::table('dmuemployee2s')
                                                    ->where('email', $row->assignedexpert)
                                                    ->first();
                                            @endphp

                                            <td>
                                                @if($expert)
                                                    {{ $expert->firstname }} {{ $expert->lastname }} <br>
                                                    <small>{{ $expert->phone }}</small>
                                                @else
                                                    {{ $row->assignedexpert }} <br>
                                                    <small>N/A</small>
                                                @endif
                                            </td>

                                            <td>
                                                <button class="btn btn-success btn-sm"
                                                        onclick="window.location.href='responsefeedback?id={{ $row->id }}'">
                                                    Send Feedback
                                                </button>
                                            </td>
                                        </tr>
                                    @empty
                                        <tr><td colspan="13" class="text-center">No data recently added.</td></tr>
                                    @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>

                        <!-- TAB 2 -->
                        <div class="tab-pane fade" id="tab2">
                            @php
                                $feedbackRequests = DB::table('staffrequests')
                                    ->where('email', $email)
                                    ->whereIn('feedback', [0,1,2])
                                    ->get();
                            @endphp

                            <br>
                            <h4>Feedback Report</h4>

                            <div style="overflow-x:auto;">
                                <table class="table table-bordered">
                                    <thead>
                                    <tr>
                                        <th>Ticket No.</th>
                                        <th>Firstname</th>
                                        <th>Lastname</th>
                                        <th>Phone</th>
                                        <th>Idnumber</th>
                                        <th>College</th>
                                        <th>Department</th>
                                        <th>Buildingno</th>
                                        <th>Office</th>
                                        <th>Requestcategory</th>
                                        <th>Description</th>
                                        <th>Assigned Expert</th>
                                        <th>Feedback</th>
                                    </tr>
                                    </thead>

                                    <tbody>
                                    @forelse($feedbackRequests as $req)
                                        <tr>
                                            <td>{{ $req->id }}</td>
                                            <td>{{ $req->firstname }}</td>
                                            <td>{{ $req->lastname }}</td>
                                            <td>{{ $req->phone }}</td>
                                            <td>{{ $req->idnumber }}</td>
                                            <td>{{ $req->college }}</td>
                                            <td>{{ $req->department }}</td>
                                            <td>{{ $req->buildingno }}</td>
                                            <td>{{ $req->office }}</td>
                                            <td>{{ $req->requestcategory }}</td>

                                            <td>
                                                <button class="btn btn-info btn-sm"
                                                        onclick="openDescriptionModal(`{!! nl2br(e($req->description)) !!}`)">
                                                    View Description
                                                </button>
                                            </td>

                                            @php
                                                $expert = DB::table('dmuemployee2s')
                                                    ->where('email', $req->assignedexpert)
                                                    ->first();
                                            @endphp

                                            <td>
                                                @if($expert)
                                                    {{ $expert->firstname }} {{ $expert->lastname }} <br>
                                                    <small>{{ $expert->phone }}</small>
                                                @else
                                                    {{ $req->assignedexpert }} <br>
                                                    <small>N/A</small>
                                                @endif
                                            </td>

                                            <td>
                                                @if($req->feedback == 2)
                                                    <span class="label label-success">Completed</span>
                                                @elseif ($req->feedback == 1)
                                                    <span class="label label-danger">Not Fixed</span>
                                                @else
                                                    <span class="label label-info">Under Maintenance</span>
                                                @endif
                                            </td>
                                        </tr>
                                    @empty
                                        <tr><td colspan="12" class="text-center">No feedback found.</td></tr>
                                    @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>

                    </div>
                </div>
            </div>
        </div>
    </section>

    <!-- DESCRIPTION MODAL -->
    <div id="descriptionModal" class="modal-custom">
        <div class="modal-content-custom">
            <span class="close-btn" onclick="closeDescriptionModal()">&times;</span>
            <h3>Description</h3>
            <div id="descriptionText"></div>
        </div>
    </div>

    <style>
        .modal-custom {
            display:none;
            position:fixed;
            left:0; top:0;
            width:100%; height:100%;
            background:rgba(0,0,0,0.6);
            z-index:9999;
        }

        .modal-content-custom {
            background:#fff;
            margin:8% auto;
            padding:20px;
            width:60%;
            border-radius:8px;
        }

        .close-btn {
            float:right;
            font-size:25px;
            cursor:pointer;
        }
    </style>

    <script>
        function openDescriptionModal(text) {
            document.getElementById('descriptionText').innerHTML = text;
            document.getElementById('descriptionModal').style.display = 'block';
        }

        function closeDescriptionModal() {
            document.getElementById('descriptionModal').style.display = 'none';
        }

        window.onclick = function(e) {
            if (e.target == document.getElementById('descriptionModal')) {
                closeDescriptionModal();
            }
        }
    </script>

@stop