@extends('admin/layouts/default')

{{-- Page title --}}
@section('title')
    Experts with Tasks
    @parent
@stop

{{-- Page content --}}
@section('content')
    <section class="content-header">
        <h1>Your Request Lists</h1>
        <ol class="breadcrumb">
            <li><a href="{{ route('dashboard') }}"><i class="livicon" data-name="home" data-size="16" data-color="#000"></i> Dashboard</a></li>
            <li>Staff Requests</li>
            <li class="active">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" data-size="16" data-loop="true" data-c="#fff" data-hc="white"></i>
                        Staff Requests List
                    </h4>
                </div>
                <br />

                <div class="panel-body">
                    <div style="overflow-x:auto;">
                        @php
                            // Get all network staff requests as a Collection
                            $staffrequestsCollection = DB::table('staffrequests as s')
                                ->leftJoin('dmuemployee2s as e', 's.assignedexpert', '=', 'e.email')
                                ->where('s.requestcategory', 'network')
                                ->orderBy('s.assignedexpert')
                                ->select('s.*', 'e.firstname', 'e.lastname') // get names from dmuemployee2s
                                ->get();

                            // Manually group by expert email
                            $staffrequests = [];
                            foreach ($staffrequestsCollection as $task) {
                                $email = $task->assignedexpert ?? 'Unassigned';
                                if (!isset($staffrequests[$email])) {
                                    $staffrequests[$email] = [];
                                }
                                $staffrequests[$email][] = $task;
                            }
                        @endphp

                        <table class="table table-bordered">
                            <thead>
                            <tr>
                                <th>Expert Name</th>
                                <th>Task Count</th>
                                <th>Action</th>
                            </tr>
                            </thead>
                            <tbody>
                            @foreach($staffrequests as $email => $tasks)
                                @php
                                    // Get full name from first task (all tasks have same email)
                                    $fullName = $tasks[0]->firstname && $tasks[0]->lastname
                                        ? $tasks[0]->firstname . ' ' . $tasks[0]->lastname
                                        : $email;
                                @endphp

                                {{-- Collapsible row header --}}
                                <tr>
                                    <td>
                                        <a class="btn btn-link" data-toggle="collapse" href="#tasks-{{ md5($email) }}">
                                            {{ $fullName }}
                                        </a>
                                    </td>
                                    <td><strong>{{ count($tasks) }}</strong></td>
                                    <td>
                                        <button class="btn btn-primary btn-sm" data-toggle="collapse" data-target="#tasks-{{ md5($email) }}">
                                            View Tasks
                                        </button>
                                    </td>
                                </tr>

                                {{-- Collapsible tasks --}}
                                <tr class="collapse" id="tasks-{{ md5($email) }}">
                                    <td colspan="3" style="padding:0;">
                                        <table class="table table-sm table-bordered" style="margin:0;">
                                            <thead>
                                            <tr>
                                                <th>Task ID</th>
                                                <th>Firstname</th>
                                                <th>Lastname</th>
                                                <th>Phone</th>
                                                <th>College</th>
                                                <th>Department</th>
                                                <th>Description</th>

                                            </tr>
                                            </thead>
                                            <tbody>
                                            @foreach($tasks as $task)
                                                <tr>
                                                    <td>{{ $task->id }}</td>
                                                    <td>{{ $task->firstname }}</td>
                                                    <td>{{ $task->lastname }}</td>
                                                    <td>{{ $task->phone }}</td>
                                                    <td>{{ $task->college }}</td>
                                                    <td>{{ $task->department }}</td>
                                                    <td>{{ $task->description }}</td>

                                                </tr>
                                            @endforeach
                                            </tbody>
                                        </table>
                                    </td>
                                </tr>
                            @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </section>
@stop

@section('footer_scripts')
    <script>
        $('.collapse').on('show.bs.collapse', function () {
            $('html, body').animate({
                scrollTop: $(this).offset().top - 100
            }, 300);
        });

        function printTicket(id, fullname, college, department, description) {
            const ticketContent = `
        <html>
            <head>
                <title>Maintenance Ticket</title>
                <style>
                    body { font-family: 'Courier New', monospace; }
                    .ticket { width: 80mm; border: 2px solid #000; padding: 12px; }
                    h4 { margin: 5px 0; font-weight: bold; }
                    hr { border: 0; border-top: 1px dashed #000; margin: 8px 0; }
                    p { margin: 3px 0; font-size: 13px; }
                    .desc { font-size: 12px; margin-top: 8px; border-top: 1px solid #000; padding-top: 5px; }
                    .footer { margin-top: 10px; font-size: 11px; font-style: italic; border-top: 2px solid #000; padding-top: 5px; }
                    @media print { @page { size: 80mm auto; margin: 0; } }
                </style>
            </head>
            <body>
                <div class="ticket">
                    <h4>Maintenance Request Ticket</h4>
                    <hr/>
                    <p><strong>Ticket ID:</strong> ${id}</p>
                    <p><strong>Name:</strong> ${fullname}</p>
                    <p><strong>College:</strong> ${college}</p>
                    <p><strong>Department:</strong> ${department}</p>
                    <div class="desc"><strong>Description:</strong><br>${description}</div>
                    <hr/>
                    <small>Printed: ${new Date().toLocaleString()}</small>
                    <div class="footer">Developed by: <strong>ICT Directorate</strong></div>
                </div>
                <script>
                    window.onload = function() { window.print(); setTimeout(() => window.close(), 500); };
                </script>
    </body>
    </html>
    `;
    const ticketWindow = window.open('', '_blank', 'width=400,height=600');
    ticketWindow.document.open();
    ticketWindow.document.write(ticketContent);
    ticketWindow.document.close();
    }
    </script>
@stop