@extends('layouts.app')
@section('title', 'Material Report')

@section('content')
    <div class="d-flex align-items-center justify-content-between mb-4">
        <div>
        <h4 class="mb-0"><i class="bi bi-box-seam me-2"></i>Material Report</h4>
            <p class="text-muted mb-0 small">
                @if($projectId)
                    Project-wise stock for: <strong>{{ $projects->firstWhere('id', $projectId)->project_name ?? '' }}</strong>
                @else
                    All projects combined stock overview
                @endif
            </p>
        </div>
        <div class="d-flex gap-2">
            <a href="{{ route('reports.export', ['format' => 'pdf', 'report' => 'material'] + request()->all()) }}"
                class="btn btn-danger btn-sm" target="_blank"><i class="bi bi-file-pdf me-1"></i>PDF</a>
            <a href="{{ route('reports.export', ['format' => 'excel', 'report' => 'material'] + request()->all()) }}"
                class="btn btn-success btn-sm"><i class="bi bi-file-earmark-excel me-1"></i>Excel</a>
            <a href="{{ route('reports.export', ['format' => 'csv', 'report' => 'material'] + request()->all()) }}"
                class="btn btn-info text-white btn-sm"><i class="bi bi-filetype-csv me-1"></i>CSV</a>
            <button class="btn btn-secondary btn-sm" onclick="window.print()"><i class="bi bi-printer me-1"></i>Print</button>
        </div>
    </div>

    {{-- Filters --}}
    <div class="card mb-3">
        <div class="card-body py-2">
            <form method="GET" class="row g-2 align-items-end">
                <div class="col-md-3">
                    <label class="form-label small mb-1">Project</label>
                    <select name="project_id" class="form-select form-select-sm">
                        <option value="">All Projects</option>
                        @foreach ($projects as $p)
                            <option value="{{ $p->id }}" {{ $projectId == $p->id ? 'selected' : '' }}>{{ $p->project_name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label small mb-1">From</label>
                    <input type="date" name="from" value="{{ $from }}" class="form-control form-control-sm">
                </div>
                <div class="col-md-2">
                    <label class="form-label small mb-1">To</label>
                    <input type="date" name="to" value="{{ $to }}" class="form-control form-control-sm">
                </div>
                <div class="col-md-2">
                    <button type="submit" class="btn btn-primary btn-sm w-100"><i
                            class="bi bi-funnel me-1"></i>Filter</button>
                </div>
            </form>
        </div>
    </div>

    {{-- Summary --}}
    <div class="row g-3 mb-4">
        <div class="col-sm-3">
            <div class="stat-card stat-primary">
                <div class="stat-icon"><i class="bi bi-box-seam"></i></div>
                <div class="stat-info">
                    <h3>{{ $data->count() }}</h3>
                    <p>Total Materials</p>
                </div>
            </div>
        </div>
        <div class="col-sm-3">
            <div class="stat-card stat-success">
                <div class="stat-icon"><i class="bi bi-arrow-down-square"></i></div>
                <div class="stat-info">
                    <h3>{{ number_format($data->sum('purchased'), 2) }}</h3>
                    <p>Total Purchased</p>
                </div>
            </div>
        </div>
        <div class="col-sm-3">
            <div class="stat-card stat-warning">
                <div class="stat-icon"><i class="bi bi-arrow-up-square"></i></div>
                <div class="stat-info">
                    <h3>{{ number_format($data->sum('consumed'), 2) }}</h3>
                    <p>Total Consumed</p>
                </div>
            </div>
        </div>
        <div class="col-sm-3">
            <div class="stat-card {{ $data->where('is_low', true)->count() > 0 ? 'stat-danger' : 'stat-success' }}">
                <div class="stat-icon"><i class="bi bi-exclamation-triangle"></i></div>
                <div class="stat-info">
                    <h3>{{ $data->where('is_low', true)->count() }}</h3>
                    <p>Low Stock Items</p>
                </div>
            </div>
        </div>
    </div>

    <div class="card">
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover table-sm mb-0">
                    <thead>
                        <tr>
                            <th>Material</th>
                            <th>Category</th>
                            <th>Unit</th>
                            <th class="text-end">Purchased</th>
                            <th class="text-end">Consumed</th>
                            <th class="text-end">Current Stock</th>
                            <th class="text-end">Min Stock</th>
                            <th>Status</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($data as $row)
                            <tr class="{{ $row['is_low'] ? 'table-danger' : '' }}">
                                <td class="fw-semibold">{{ $row['material_name'] }}</td>
                                <td>{{ $row['category'] ?? '—' }}</td>
                                <td>{{ $row['unit'] }}</td>
                                <td class="text-end text-success">{{ number_format($row['purchased'], 2) }}</td>
                                <td class="text-end text-warning">{{ number_format($row['consumed'], 2) }}</td>
                                <td class="text-end fw-bold">{{ number_format($row['current_stock'], 2) }}</td>
                                <td class="text-end text-muted">{{ number_format($row['min_stock'], 2) }}</td>
                                <td>
                                    @if($row['is_low'])
                                        <span class="badge bg-danger"><i class="bi bi-exclamation-triangle me-1"></i>Low</span>
                                    @else
                                        <span class="badge bg-success">OK</span>
                                    @endif
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="8" class="text-center py-4 text-muted">No materials found.</td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection