@extends('admin.layouts.app')
@section('title','Project Report')
@section('breadcrumb') <span>/</span> <a href="{{ route('admin.reports.index') }}" style="color:inherit;text-decoration:none;">Reports</a> <span>/</span> Projects @endsection

@section('content')
<div class="page-header">
    <div><h1>Project Report</h1><p class="page-subtitle">
        @if($from || $to) {{ $from?->format('d M Y') ?? 'Beginning' }} — {{ $to?->format('d M Y') ?? 'Till Date' }}
        @else All Time @endif
    </p></div>
    <button onclick="window.print()" class="btn btn-outline-secondary"><i class="fas fa-print me-2"></i>Print</button>
</div>

<div class="card mb-4">
    <div class="card-body py-3">
        <form method="GET" class="row g-2 align-items-end">
            <div class="col-md-3">
                <select name="status" class="form-select">
                    <option value="">All Status</option>
                    @foreach(['draft','pending','approved','active','completed','rejected','cancelled'] as $s)
                    <option value="{{ $s }}" {{ request('status')===$s?'selected':'' }}>{{ ucfirst($s) }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-3">
                <select name="company_id" class="form-select">
                    <option value="">All Companies</option>
                    @foreach($companies as $id => $name)
                    <option value="{{ $id }}" {{ request('company_id')==$id?'selected':'' }}>{{ $name }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-2"><input type="date" name="from" class="form-control" value="{{ request('from') }}"></div>
            <div class="col-md-2"><input type="date" name="to" class="form-control" value="{{ request('to') }}"></div>
            <div class="col-md-2 d-flex gap-1">
                <button class="btn btn-primary flex-grow-1"><i class="fas fa-filter me-1"></i>Filter</button>
                <a href="{{ route('admin.reports.projects') }}" class="btn btn-outline-secondary">Clear</a>
            </div>
        </form>
    </div>
</div>

<div class="row g-3 mb-4">
    <div class="col-6 col-md-3"><div class="card p-3 text-center" style="border-top:3px solid #0369a1;"><div style="font-size:11px;color:#64748b;font-weight:600;text-transform:uppercase;">Total Projects</div><div style="font-size:20px;font-weight:700;">{{ $summary['total'] }}</div></div></div>
    <div class="col-6 col-md-3"><div class="card p-3 text-center" style="border-top:3px solid #16a34a;"><div style="font-size:11px;color:#64748b;font-weight:600;text-transform:uppercase;">Total Budget</div><div style="font-size:18px;font-weight:700;">₹{{ number_format($summary['total_budget'],2) }}</div></div></div>
    <div class="col-6 col-md-3"><div class="card p-3 text-center" style="border-top:3px solid #dc2626;"><div style="font-size:11px;color:#64748b;font-weight:600;text-transform:uppercase;">Total Spent</div><div style="font-size:18px;font-weight:700;">₹{{ number_format($summary['total_spent'],2) }}</div></div></div>
    <div class="col-6 col-md-3"><div class="card p-3 text-center" style="border-top:3px solid #f59e0b;"><div style="font-size:11px;color:#64748b;font-weight:600;text-transform:uppercase;">Active</div><div style="font-size:20px;font-weight:700;">{{ $summary['by_status']['active'] ?? 0 }}</div></div></div>
</div>

<div class="card">
    <div class="card-header d-flex align-items-center justify-content-between">
        <h6 class="mb-0 fw-700"><i class="fas fa-project-diagram text-primary me-2"></i>Project Records</h6>
        <span class="badge bg-primary">{{ $projects->count() }} records</span>
    </div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table table-hover mb-0" id="reportTable">
                <thead style="background:#f8fafc;">
                    <tr><th class="ps-3">Code</th><th>Title</th><th>CSR Company</th><th>Category</th><th>Budget</th><th>Spent</th><th>Status</th></tr>
                </thead>
                <tbody>
                    @forelse($projects as $p)
                    <tr>
                        <td class="ps-3"><code style="font-size:11px;">{{ $p->project_code }}</code></td>
                        <td style="font-size:12px;"><a href="{{ route('admin.csr.projects.show',$p) }}">{{ Str::limit($p->project_title,30) }}</a></td>
                        <td style="font-size:12px;">{{ $p->csrCompany->company_name ?? '—' }}</td>
                        <td style="font-size:12px;">{{ $p->category->name ?? '—' }}</td>
                        <td style="font-weight:700;">₹{{ number_format($p->budget_allocation,2) }}</td>
                        <td style="font-weight:700;color:#dc2626;">₹{{ number_format($p->total_spent,2) }}</td>
                        <td><span class="badge bg-light text-dark border">{{ ucfirst($p->status) }}</span></td>
                    </tr>
                    @empty
                    <tr><td colspan="7" class="text-center py-4 text-muted">No projects found</td></tr>
                    @endforelse
                </tbody>
                @if($projects->count())
                <tfoot style="background:#f8fafc;">
                    <tr>
                        <td colspan="4" class="ps-3" style="font-weight:700;">TOTAL</td>
                        <td style="font-weight:700;">₹{{ number_format($summary['total_budget'],2) }}</td>
                        <td style="font-weight:700;color:#dc2626;">₹{{ number_format($summary['total_spent'],2) }}</td>
                        <td></td>
                    </tr>
                </tfoot>
                @endif
            </table>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
$(document).ready(function() { $('#reportTable').DataTable({ ...window.dtDefaults, paging: false, info: false }); });
</script>
@endpush