@extends('layouts.main')

@section('content')
<div class="content-wrapper">
    <div class="content-header">
        <div class="container-fluid p-0">
            <h1 class="h3 mb-3">Brick Production Report</h1>
        </div>
    </div>

    <div class="container-fluid">

        <!-- Filter Section -->
        <div class="card mb-4">
            <div class="card-header">
                <h5 class="card-title mb-0">Filter Production Report</h5>
            </div>

            <div class="card-body">
                <form action="{{ route('reports.brick_production') }}" method="GET">

                    {{-- FILTER FIELDS ROW --}}
                    <div class="row">
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="start_date">Start Date</label>
                                <input type="date"
                                       class="form-control"
                                       id="start_date"
                                       name="start_date"
                                       value="{{ request('start_date') ?? $startDate->format('Y-m-01') }}"
                                       required>
                            </div>
                        </div>

                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="end_date">End Date</label>
                                <input type="date"
                                       class="form-control"
                                       id="end_date"
                                       name="end_date"
                                       value="{{ request('end_date') ?? $endDate->format('Y-m-t') }}"
                                       required>
                            </div>
                        </div>

                        {{-- ✅ NEW: Work Station --}}
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="work_station_id">Work Station</label>
                                <select name="work_station_id" id="work_station_id" class="form-control">
                                    <option value="">-- All Work Stations --</option>
                                    @foreach(($workStations ?? collect()) as $ws)
                                        <option value="{{ $ws->id }}"
                                            {{ (string)request('work_station_id') === (string)$ws->id ? 'selected' : '' }}>
                                            {{ $ws->name ?? ('Work Station #' . $ws->id) }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>

                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="brick_type_id">Brick Type</label>
                                <select name="brick_type_id" id="brick_type_id" class="form-control">
                                    <option value="">-- All Brick Types --</option>
                                    @foreach(($brickTypes ?? collect()) as $t)
                                        <option value="{{ $t->id }}"
                                            {{ (string)request('brick_type_id') === (string)$t->id ? 'selected' : '' }}>
                                            {{ $t->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                    </div>

                    {{-- ACTIONS ROW (perfect alignment) --}}
                    <div class="row mt-2">
                        <div class="col-12 d-flex justify-content-between align-items-center flex-wrap gap-2">
                            <div class="d-flex gap-2">
                                <button type="submit" class="btn btn-primary">
                                    <i class="fa fa-filter"></i> Filter
                                </button>

                                <a href="{{ route('reports.brick_production') }}" class="btn btn-secondary">
                                    <i class="fa fa-sync"></i> Reset
                                </a>
                            </div>

                            {{-- Export route should exist --}}
                            <a href="{{ route('reports.brick_production.export_excel', request()->query()) }}"
                               class="btn btn-success">
                                <i class="fa fa-file-excel"></i> Export
                            </a>
                        </div>
                    </div>

                </form>
            </div>
        </div>


        @if(($production ?? collect())->isEmpty())
            <div class="alert alert-warning">No brick production data found for the selected filters.</div>
        @else

            <!-- Production Report -->
            <div class="card mb-4">
                <div class="card-header">
                    <h5 class="card-title mb-0">
                        Brick Production Summary ({{ $startDate->format('d M Y') }} - {{ $endDate->format('d M Y') }})
                        @if(request()->filled('work_station_id'))
                            <span class="text-muted"> | Work Station: {{ optional(($workStations ?? collect())->firstWhere('id', (int)request('work_station_id')))->name ?? request('work_station_id') }}</span>
                        @else
                            <span class="text-muted"> | All Work Stations</span>
                        @endif
                    </h5>
                </div>

                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th class="text-center">Date</th>
                                    <th class="text-center">Brick Type</th>
                                    <th class="text-end">Cement Used (Bags)</th>
                                    <th class="text-end">Good Bricks</th>
                                    <th class="text-end">Expected Output</th>
                                    <th class="text-center">Variance</th>
                                    <th class="text-center">Status</th>
                                </tr>
                            </thead>

                            <tbody>
                                @php
                                    $totalCement = 0;
                                    $totalGoodBricks = 0;
                                    $totalExpected = 0;
                                @endphp

                                @foreach($production as $prod)
                                    @php
                                        $cementUsed = (int) ($prod->total ?? 0);

                                        // ✅ Use eager loaded relationship (NO extra queries)
                                        $stockBricks = collect($prod->stockBricks ?? []);

                                        // If filter selected, keep only that type
                                        if (request()->filled('brick_type_id')) {
                                            $stockBricks = $stockBricks->where('brick_type_id', (int) request('brick_type_id'));
                                        }

                                        // Remove empty ones
                                        $stockBricks = $stockBricks->filter(function ($sb) {
                                            return (int)($sb->actual_output ?? 0) > 0
                                                || (int)($sb->expected_output ?? 0) > 0
                                                || (int)($sb->total_bricks_without_fault ?? 0) > 0;
                                        })->values();

                                        // If none remain, show ONE row with "Not Recorded"
                                        $rowspan = max(1, $stockBricks->count());

                                        $totalCement += $cementUsed;

                                        $sumGood = (int) $stockBricks->sum(fn($sb) => (int)($sb->total_bricks_without_fault ?? 0));
                                        $sumExpected = (int) $stockBricks->sum(fn($sb) => (int)($sb->expected_output ?? 0));

                                        $totalGoodBricks += $sumGood;
                                        $totalExpected += $sumExpected;
                                    @endphp

                                    @if($stockBricks->isEmpty())
                                        @php
                                            $good = 0;
                                            $expected = 0;
                                            $variance = 0;
                                            $status = 'Missing Output';
                                        @endphp

                                        <tr>
                                            <td class="text-center">{{ optional($prod->created_at)->format('d M Y') }}</td>
                                            <td class="text-center text-danger">Not Recorded</td>
                                            <td class="text-end">{{ number_format($cementUsed) }}</td>
                                            <td class="text-end">{{ number_format($good) }}</td>
                                            <td class="text-end">{{ number_format($expected) }}</td>
                                            <td class="text-end">0</td>
                                            <td class="text-center">
                                                <span class="badge bg-danger">{{ $status }}</span>
                                            </td>
                                        </tr>
                                    @else
                                        @foreach($stockBricks as $i => $sb)
                                            @php
                                                $good     = (int) ($sb->total_bricks_without_fault ?? 0);
                                                $expected = (int) ($sb->expected_output ?? 0);
                                                $variance = $good - $expected;

                                                $status = ($expected > 0 && $good == 0)
                                                    ? 'Missing Output'
                                                    : ($good < $expected ? 'Below Expectation' : 'Met Target');

                                                $brickTypeName = $sb->brickType->name ?? 'Unknown';
                                            @endphp

                                            <tr>
                                                {{-- Date shown once per stock --}}
                                                @if($i === 0)
                                                    <td class="text-center align-middle" rowspan="{{ $rowspan }}">
                                                        {{ optional($prod->created_at)->format('d M Y') }}
                                                    </td>
                                                @endif

                                                <td class="text-center">{{ $brickTypeName }}</td>

                                                {{-- Cement used shown once per stock --}}
                                                @if($i === 0)
                                                    <td class="text-end align-middle" rowspan="{{ $rowspan }}">
                                                        {{ number_format($cementUsed) }}
                                                    </td>
                                                @endif

                                                <td class="text-end">{{ number_format($good) }}</td>
                                                <td class="text-end">{{ number_format($expected) }}</td>

                                                <td class="text-end {{ $variance < 0 ? 'text-danger' : ($variance > 0 ? 'text-success' : '') }}">
                                                    {{ $variance >= 0 ? '+' : '' }}{{ number_format($variance) }}
                                                </td>

                                                <td class="text-center">
                                                    <span class="badge bg-{{ $status === 'Met Target' ? 'success' : 'danger' }}">
                                                        {{ $status }}
                                                    </span>
                                                </td>
                                            </tr>
                                        @endforeach
                                    @endif
                                @endforeach
                            </tbody>

                            <tfoot>
                                @php
                                    $totalVariance = $totalGoodBricks - $totalExpected;
                                @endphp

                                <tr style="border-top: 2px solid #000;">
                                    <th class="text-end">TOTALS</th>
                                    <th class="text-center">-</th>
                                    <th class="text-end" style="border-top: 2px solid #000; border-bottom: 2px solid #000;">
                                        {{ number_format($totalCement) }}
                                    </th>
                                    <th class="text-end" style="border-top: 2px solid #000; border-bottom: 2px solid #000;">
                                        {{ number_format($totalGoodBricks) }}
                                    </th>
                                    <th class="text-end" style="border-top: 2px solid #000; border-bottom: 2px solid #000;">
                                        {{ number_format($totalExpected) }}
                                    </th>
                                    <th class="text-end {{ $totalVariance < 0 ? 'text-danger' : 'text-success' }}"
                                        style="border-top: 2px solid #000; border-bottom: 2px solid #000;">
                                        {{ $totalVariance >= 0 ? '+' : '' }}{{ number_format($totalVariance) }}
                                    </th>
                                    <th class="text-center">
                                        <span class="badge bg-{{ $totalGoodBricks >= $totalExpected ? 'success' : 'danger' }}">
                                            {{ $totalGoodBricks >= $totalExpected ? 'Target Achieved' : 'Below Target' }}
                                        </span>
                                    </th>
                                </tr>
                            </tfoot>

                        </table>
                    </div>
                </div>
            </div>

        @endif
    </div>
</div>
@endsection

@section('scripts')
<script>
    $(function () {
        $('#start_date').change(function () {
            $('#end_date').attr('min', $(this).val());
        });

        $('#end_date').change(function () {
            $('#start_date').attr('max', $(this).val());
        });
    });
</script>
@endsection