@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">
                    <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') ?? date('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') ?? date('Y-m-t') }}" required>
                            </div>
                        </div>
                        <div class="col-md-3 d-flex align-items-end">
                            <button type="submit" class="btn btn-primary mr-2">
                                <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>
                    </div>
                </form>
            </div>
        </div>

        @if($production->isEmpty())
            <div class="alert">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') }})</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-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
                                        $stockBrick = App\Models\StockBrick::where('stock_id', $prod->id)->first();
                                        $goodBricks = $stockBrick?->total_bricks_without_fault ?? 0;
                                        $expected = $stockBrick?->expected_output ?? 0;
                                        $variance = $goodBricks - $expected;

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

                                        $totalCement += $prod->total;
                                        $totalGoodBricks += $goodBricks;
                                        $totalExpected += $expected;
                                    @endphp
                                    <tr>
                                        <td class="text-center">{{ $prod->created_at->format('d M Y') }}</td>
                                        <td class="text-end">{{ number_format($prod->total) }}</td>
                                        <td class="text-end">{{ number_format($goodBricks) }}</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
                            </tbody>
                            <tfoot>
                                <tr style="border-top: 2px solid #000;">
                                    <th class="text-end">Totals:</th>
                                    <th class="text-end" style="border-top: 2px solid #000; border-bottom: 2px solid #000">
                                        {{ number_format($totalCement) }} bags
                                    </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 {{ ($totalGoodBricks - $totalExpected) < 0 ? 'text-danger' : 'text-success' }}"
                                        style="border-top: 2px solid #000; border-bottom: 2px solid #000">
                                        {{ ($totalGoodBricks - $totalExpected) >= 0 ? '+' : '' }}{{ number_format($totalGoodBricks - $totalExpected) }}
                                    </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 () {
        // Date validation
        $('#start_date').change(function () {
            $('#end_date').attr('min', $(this).val());
        });

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