@extends('admin/layouts/default')

{{-- Page title --}}
@section('title')
    Assign Expert
    @parent
@stop

{{-- Page content --}}
@section('content')
    <section class="content-header">
        <h1>Network  Expert</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>Maintenance Requests</li>
            <li class="active">Assign Expert</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>
                        Assign Expert
                    </h4>
                </div>
                <br />

                @php
                    // ✅ Get experts with role_id = 43 and join both users & dmuemployee2s tables
                    $experts = DB::table('role_users')
                        ->join('users', 'role_users.user_id', '=', 'users.id')
                        ->leftJoin('dmuemployee2s', 'users.email', '=', 'dmuemployee2s.email')
                        ->where('role_users.role_id', 43)
                        ->select(
                            'users.email',
                            'users.id as user_id',
                            'dmuemployee2s.firstname',
                            'dmuemployee2s.lastname'
                        )
                        ->get();
                @endphp

                <div class="container">
                    <form action="{{ route('admin.networkrequests.assignexpert2', $id) }}" method="POST" style="display:inline;">
                        {{--<form action="{{ route('admin.maintenancerequests.assignexpert1', $id) }}" method="POST" style="display:inline;">--}}
                          

                            <div class="form-group">
                                <label for="cat_id">Select Expert:</label>
                                <select name="cat_id" class="form-control" id="cat_id" required>
                                    <option value="">Select Expert</option>

                                    @foreach($experts as $expert)
                                        @php
                                            $email = $expert->email ?? null;
                                            $taskCount = 0;

                                            if ($email) {
                                                // ✅ Count tasks assigned to this expert where maintenancestatus = 0 or NULL
                                                $taskCount = DB::table('staffrequests')
                                                    ->where('assignedexpert', $email)
                                                    ->where(function($query) {
                                                        $query->where('maintenancestatus', 0)
                                                              ->orWhereNull('maintenancestatus');
                                                    })
                                                    ->count();
                                            }
                                        @endphp

                                        @if($email)
                                            <option value="{{ $email }}">
                                                {{ $expert->firstname ?? 'N/A' }} {{ $expert->lastname ?? '' }} – {{ $email }}
                                                (<strong>{{ $taskCount }}</strong> tasks)
                                            </option>
                                        @endif
                                    @endforeach
                                </select>
                            </div>

                        <div class="form-group">
                            <label for="message">Message:</label>
                            <textarea id="message" name="message" rows="4" required
                                      style="width: 100%; max-width: 100%; min-width: 100%; resize: vertical; padding: 10px; border: 1px solid #ccc; border-radius: 6px;">
    </textarea>
                        </div>


                        <button type="button" class="btn btn-sm btn-default" style="background-color: green; color: white;" onclick="assignExpert()">
                                <span class="glyphicon glyphicon-user"></span> @lang('Assign Expert')
                            </button>
                        </form>
                </div>

                <script>
                    function assignExpert() {
                        var catId = document.getElementById('cat_id').value;
                        var id = '{{ $id }}'; // Ensure this is correctly set in your server-side code

                        if (catId) {
                            window.location.href = 'assignexpert2?id=' + id + '&cat_id=' + catId;
                        } else {
                            alert('Please select an expert.');
                        }
                    }
                </script>
            </div>
        </div>
    </section>
@stop

{{-- Footer scripts --}}
@section('footer_scripts')
    <script>
        $(function () {
            $('body').on('hidden.bs.modal', '.modal', function () {
                $(this).removeData('bs.modal');
            });
        });
    </script>
@stop