@extends('layouts.app')
@section('title', 'Admin Timesheet Report')
@section('breadcrumb')
    <a href="{{ route('reports.index') }}" class="text-slate-400 hover:text-white">Reports</a>
    <span class="text-slate-600 mx-2">/</span>
    <span class="text-white">Employee Timesheet Report</span>
@endsection

@section('content')
<div class="space-y-6">

    <!-- Header -->
    <div class="flex flex-col sm:flex-row sm:items-center justify-between gap-3">
        <div>
            <h1>Employee Timesheet Report</h1>
            <p class="text-sm text-slate-400 mt-1">Full time log, task details, rate &amp; earnings — filterable by date, job, and employee</p>
        </div>
        <div class="flex gap-2">
            <a href="{{ request()->fullUrlWithQuery(['export'=>'csv']) }}" class="btn btn-secondary">
                <i class="fas fa-download mr-2"></i>Export CSV
            </a>
            <a href="{{ request()->fullUrlWithQuery(['export'=>'job_excel']) }}" class="btn btn-secondary">
                <i class="fas fa-file-excel mr-2"></i>Job Report (Excel)
            </a>
        </div>
    </div>

    <!-- Filters -->
    <form method="GET" class="card p-4">
        <div class="grid grid-cols-1 md:grid-cols-5 gap-4">
            <div>
                <label class="block text-sm text-slate-400 mb-1">From Date</label>
                <input type="date" name="from" class="input" value="{{ request('from', $from->toDateString()) }}">
            </div>
            <div>
                <label class="block text-sm text-slate-400 mb-1">To Date</label>
                <input type="date" name="to" class="input" value="{{ request('to', $to->toDateString()) }}">
            </div>
            <div>
                <label class="block text-sm text-slate-400 mb-1">Employee</label>
                <select name="employee_id" class="input">
                    <option value="">All Employees</option>
                    @foreach($employees as $emp)
                    <option value="{{ $emp->id }}" {{ request('employee_id') == $emp->id ? 'selected' : '' }}>{{ $emp->name }}</option>
                    @endforeach
                </select>
            </div>
            <div>
                <label class="block text-sm text-slate-400 mb-1">Job Number</label>
                <input type="text" name="job_number" class="input" placeholder="e.g. J-0022" value="{{ request('job_number') }}">
            </div>
            <div class="flex gap-2 items-end">
                <button type="submit" class="btn btn-primary flex-1">Apply</button>
                <a href="{{ route('reports.admin-timesheet') }}" class="btn btn-secondary">Reset</a>
            </div>
        </div>
    </form>

    <!-- Summary KPI cards -->
    <div class="grid grid-cols-2 lg:grid-cols-5 gap-4">
        <div class="card p-4 text-center">
            <div class="text-xs text-slate-400 mb-1">Total Entries</div>
            <div class="text-2xl font-bold text-white">{{ $totalEntries }}</div>
        </div>
        <div class="card p-4 text-center">
            <div class="text-xs text-slate-400 mb-1">Total Hours</div>
            <div class="text-2xl font-bold text-blue-400">{{ number_format($totalHours, 2) }}h</div>
        </div>
        <div class="card p-4 text-center">
            <div class="text-xs text-slate-400 mb-1">Total Earnings</div>
            <div class="text-2xl font-bold text-green-400">${{ number_format($totalEarnings, 2) }}</div>
        </div>
        <div class="card p-4 text-center">
            <div class="text-xs text-slate-400 mb-1">Employees</div>
            <div class="text-2xl font-bold text-purple-400">{{ $employees->count() }}</div>
        </div>
        <div class="card p-4 text-center">
            <div class="text-xs text-slate-400 mb-1">Jobs Covered</div>
            <div class="text-2xl font-bold text-yellow-400">{{ $jobsCoveredCount }}</div>
        </div>
    </div>

    <!-- Per-Employee Summary Table -->
    @if($employeeSummary->count() > 0)
    <div class="card overflow-hidden">
        <div class="p-5 border-b border-slate-700">
            <h3>Employee Summary</h3>
        </div>
        <div class="overflow-x-auto">
            <table class="w-full">
                <thead>
                    <tr class="text-xs text-slate-400 uppercase border-b border-slate-700" style="background:#0f172a;">
                        <th class="px-5 py-3 text-left">Employee</th>
                        <th class="px-5 py-3 text-left">Role</th>
                        <th class="px-5 py-3 text-right">Hourly Rate</th>
                        <th class="px-5 py-3 text-right">Entries</th>
                        <th class="px-5 py-3 text-right">Hours</th>
                        <th class="px-5 py-3 text-right">Earnings</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($employeeSummary as $summary)
                    <tr class="table-row">
                        <td class="px-5 py-3">
                            <div class="flex items-center gap-2">
                                <div class="w-7 h-7 rounded-full bg-blue-900 flex items-center justify-center text-xs font-bold text-blue-300">{{ strtoupper(substr($summary['name'],0,2)) }}</div>
                                <span class="text-sm text-white font-medium">{{ $summary['name'] }}</span>
                            </div>
                        </td>
                        <td class="px-5 py-3 text-sm text-slate-400">{{ $summary['role'] }}</td>
                        <td class="px-5 py-3 text-sm text-slate-300 text-right">${{ number_format($summary['rate'], 2) }}/hr</td>
                        <td class="px-5 py-3 text-sm text-white text-right">{{ $summary['entries'] }}</td>
                        <td class="px-5 py-3 text-sm text-blue-400 font-medium text-right">{{ number_format($summary['hours'], 2) }}h</td>
                        <td class="px-5 py-3 text-sm text-green-400 font-bold text-right">${{ number_format($summary['earnings'], 2) }}</td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot>
                    <tr class="border-t border-slate-600" style="background:#0f172a;">
                        <td colspan="4" class="px-5 py-3 text-sm font-bold text-white">Total</td>
                        <td class="px-5 py-3 text-sm font-bold text-blue-400 text-right">{{ number_format($totalHours, 2) }}h</td>
                        <td class="px-5 py-3 text-sm font-bold text-green-400 text-right">${{ number_format($totalEarnings, 2) }}</td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
    @endif

    <!-- Job-wise Detail Table -->
    <div class="card overflow-hidden">
        <div class="p-5 border-b border-slate-700 flex items-center justify-between">
            <h3>Job-wise Time Log Detail</h3>
            <span class="text-xs text-slate-400">{{ $totalEntries }} entries</span>
        </div>
        <div class="overflow-x-auto">
            <table class="w-full">
                <thead>
                    <tr class="text-xs text-slate-400 uppercase border-b border-slate-700" style="background:#0f172a;">
                        <th class="px-4 py-3 text-left">Date</th>
                        <th class="px-4 py-3 text-left">Employee</th>
                        <th class="px-4 py-3 text-left">Job</th>
                        <th class="px-4 py-3 text-left">Task</th>
                        <th class="px-4 py-3 text-left">Stage</th>
                        <th class="px-4 py-3 text-right">Start</th>
                        <th class="px-4 py-3 text-right">Stop</th>
                        <th class="px-4 py-3 text-right">Hours</th>
                        <th class="px-4 py-3 text-right">Rate</th>
                        <th class="px-4 py-3 text-right">Amount</th>
                        <th class="px-4 py-3 text-center">Status</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($entries as $entry)
                    @php
                        $hrs = round($entry->duration_minutes / 60, 2);
                        $rate = (float)($entry->user?->hourly_rate ?? 0);
                        $amount = round($hrs * $rate, 2);
                    @endphp
                    <tr class="table-row">
                        <td class="px-4 py-3 text-xs text-slate-400">{{ $entry->started_at?->format('d M Y') }}</td>
                        <td class="px-4 py-3">
                            <div class="text-sm text-white">{{ $entry->user?->name ?? '—' }}</div>
                            <div class="text-xs text-slate-500">{{ $entry->user?->role?->display_name ?? '' }}</div>
                        </td>
                        <td class="px-4 py-3 text-sm font-mono text-blue-300">{{ $entry->job?->job_number ?? '—' }}</td>
                        <td class="px-4 py-3 text-sm text-slate-300">{{ $entry->taskType?->name ?? '—' }}</td>
                        <td class="px-4 py-3">
                            @if($entry->job)
                            <span class="badge badge-{{ $entry->job->stageColor() }} text-xs">{{ $entry->job->stageLabel() }}</span>
                            @else
                            <span class="text-slate-600 text-xs">—</span>
                            @endif
                        </td>
                        <td class="px-4 py-3 text-xs text-slate-400 text-right">{{ $entry->started_at?->format('H:i') }}</td>
                        <td class="px-4 py-3 text-xs text-slate-400 text-right">{{ $entry->stopped_at?->format('H:i') ?? '—' }}</td>
                        <td class="px-4 py-3 text-sm text-blue-400 font-medium text-right">{{ number_format($hrs, 2) }}h</td>
                        <td class="px-4 py-3 text-sm text-slate-300 text-right">${{ number_format($rate, 2) }}</td>
                        <td class="px-4 py-3 text-sm text-green-400 font-bold text-right">${{ number_format($amount, 2) }}</td>
                        <td class="px-4 py-3 text-center">
                            @php
                                $badge = match($entry->status) {
                                    'completed' => 'badge-green',
                                    'running'   => 'badge-blue',
                                    'paused'    => 'badge-yellow',
                                    default     => 'badge-gray',
                                };
                            @endphp
                            <span class="badge {{ $badge }} text-xs">{{ ucfirst($entry->status) }}</span>
                        </td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="11" class="px-4 py-12 text-center text-slate-500">
                            <i class="fas fa-clock text-3xl text-slate-700 block mb-3"></i>No time entries found for the selected filters.
                        </td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
        @if(method_exists($entries, 'hasPages') && $entries->hasPages())
        <div class="px-4 py-3 border-t border-slate-700">{{ $entries->appends(request()->query())->links() }}</div>
        @endif
    </div>

    <!-- Job-wise Stage Report -->
    <div class="card overflow-hidden">
        <div class="p-5 border-b border-slate-700 flex items-center justify-between">
            <div>
                <h3>Job-wise Stage Report</h3>
                <p class="text-xs text-slate-400 mt-0.5">Task completion by employee per job, with time taken, rate and price</p>
            </div>
        </div>
        <div class="overflow-x-auto">
            <table class="w-full">
                <thead>
                    <tr class="text-xs text-slate-400 uppercase border-b border-slate-700" style="background:#0f172a;">
                        <th class="px-4 py-3 text-left">Job</th>
                        <th class="px-4 py-3 text-left">Client</th>
                        <th class="px-4 py-3 text-left">Stage</th>
                        <th class="px-4 py-3 text-left">Employee</th>
                        <th class="px-4 py-3 text-left">Task</th>
                        <th class="px-4 py-3 text-center">Task Status</th>
                        <th class="px-4 py-3 text-right">Hours Logged</th>
                        <th class="px-4 py-3 text-right">Hourly Rate</th>
                        <th class="px-4 py-3 text-right">Total Price</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($jobStageRows as $row)
                    <tr class="table-row">
                        <td class="px-4 py-3 text-sm font-mono text-blue-300">{{ $row['job_number'] }}</td>
                        <td class="px-4 py-3 text-sm text-slate-300">{{ $row['client'] }}</td>
                        <td class="px-4 py-3">
                            <span class="badge badge-{{ $row['stage_color'] }} text-xs">{{ $row['stage_label'] }}</span>
                        </td>
                        <td class="px-4 py-3 text-sm text-white">{{ $row['employee'] }}</td>
                        <td class="px-4 py-3 text-sm text-slate-300">{{ $row['task'] }}</td>
                        <td class="px-4 py-3 text-center">
                            @php
                                $badge = match($row['task_status']) {
                                    'completed'   => 'badge-green',
                                    'in_progress' => 'badge-blue',
                                    'paused'      => 'badge-yellow',
                                    default       => 'badge-gray',
                                };
                            @endphp
                            <span class="badge {{ $badge }} text-xs">{{ ucfirst(str_replace('_',' ',$row['task_status'])) }}</span>
                        </td>
                        <td class="px-4 py-3 text-sm text-blue-400 font-medium text-right">{{ number_format($row['hours'], 2) }}h</td>
                        <td class="px-4 py-3 text-sm text-slate-300 text-right">${{ number_format($row['rate'], 2) }}</td>
                        <td class="px-4 py-3 text-sm text-green-400 font-bold text-right">${{ number_format($row['total_price'], 2) }}</td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="9" class="px-4 py-12 text-center text-slate-500">
                            <i class="fas fa-tasks text-3xl text-slate-700 block mb-3"></i>No task assignments found for the selected period.
                        </td>
                    </tr>
                    @endforelse
                </tbody>
                @if(count($jobStageRows) > 0)
                <tfoot>
                    <tr class="border-t border-slate-600" style="background:#0f172a;">
                        <td colspan="6" class="px-4 py-3 text-sm font-bold text-white">Total</td>
                        <td class="px-4 py-3 text-sm font-bold text-blue-400 text-right">{{ number_format(collect($jobStageRows)->sum('hours'), 2) }}h</td>
                        <td></td>
                        <td class="px-4 py-3 text-sm font-bold text-green-400 text-right">${{ number_format(collect($jobStageRows)->sum('total_price'), 2) }}</td>
                    </tr>
                </tfoot>
                @endif
            </table>
        </div>
    </div>

</div>
@endsection