@extends('layouts.main')

@section('content')
<div class="content-wrapper">
    <div class="content-header">
        <h1 class="h3 mb-3">Brick Production, Stock, Sales & Profit Report</h1>
    </div>

    <div class="container-fluid">

        {{-- FILTER --}}
        <div class="card mb-4">
            <div class="card-body">
                <form method="GET" action="{{ route('reports.brick_report') }}">
                    <div class="row">

                        {{-- Start Date --}}
                        <div class="col-md-3">
                            <label>Start Date</label>
                            <input type="date" name="start_date" class="form-control"
                                   value="{{ request('start_date', $startDate->format('Y-m-d')) }}">
                        </div>

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

                        {{-- Month Filter --}}
                        <div class="col-md-3">
                            <label>Month</label>
                            <input type="month" name="month" class="form-control"
                                   value="{{ request('month') }}">
                        </div>

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

                    </div>

                    {{-- ✅ ADDED: Workstation dropdown row --}}
                    <div class="row mt-3">
                        <div class="col-md-3">
                            <label>Work Station (Optional)</label>
                            <select name="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 ?? ('WorkStation #'.$ws->id) }}
                                    </option>
                                @endforeach
                            </select>
                        </div>

                        <div class="col-md-9 d-flex align-items-end gap-2 flex-wrap">
                            <button class="btn btn-primary">
                                <i class="fa fa-filter"></i> Filter
                            </button>

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

                            <a class="btn btn-danger"
                               target="_blank"
                               href="">
                                <i class="fa fa-file-pdf"></i> Export PDF
                            </a>

                            <a href="{{ route('reports.brick_report') }}"
                               class="btn btn-outline-secondary">
                                Reset
                            </a>
                        </div>
                    </div>

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

        {{-- SUMMARY --}}
        <div class="row mb-4">
            <div class="col-md-3">
                <div class="p-3 border rounded bg-light">
                    <small>Total Produced</small>
                    <h4>{{ number_format($totalProduced) }}</h4>
                </div>
            </div>

            <div class="col-md-3">
                <div class="p-3 border rounded bg-light">
                    <small>Total In Stock</small>
                    <h4>{{ number_format($totalInStock) }}</h4>
                </div>
            </div>

            <div class="col-md-3">
                <div class="p-3 border rounded bg-light">
                    <small>Total Sold</small>
                    <h4>{{ number_format($totalSold) }}</h4>
                </div>
            </div>

            <div class="col-md-3">
                <div class="p-3 border rounded {{ $profit < 0 ? 'bg-danger text-white' : 'bg-success text-white' }}">
                    <small>Net Profit</small>
                    <h4>{{ number_format($profit, 2) }}</h4>
                </div>
            </div>
        </div>

        {{-- PRODUCTION --}}
        <div class="card mb-4">
            <div class="card-header bg-info text-white">
                <h5>Bricks Produced</h5>
            </div>

            <div class="card-body table-responsive">
                <table class="table table-bordered">
                    <thead>
                        <tr>
                            <th>Date</th>
                            <th>Brick Type</th>
                            <th class="text-end">Actual Output</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($productionRows as $r)
                            <tr>
                                <td>{{ optional($r->created_at)->format('d M Y') }}</td>
                                <td>{{ $r->brickType->name ?? 'Unknown' }}</td>
                                <td class="text-end">{{ number_format($r->actual_out) }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>

        {{-- STOCK --}}
        <div class="card mb-4">
            <div class="card-header bg-secondary text-white">
                <h5>Current Stock</h5>
            </div>

            <div class="card-body table-responsive">
                <table class="table table-bordered">
                    <thead>
                        <tr>
                            <th>Brick Type</th>
                            <th class="text-end">In Stock</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($brickTypes as $t)
                            <tr>
                                <td>{{ $t->name }}</td>
                                <td class="text-end">{{ number_format($currentStockByType[$t->id] ?? 0) }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>

        {{-- SALES DETAILS --}}
        <div class="card mb-4">
            <div class="card-header bg-dark text-white">
                <h5>Sales Details</h5>
            </div>

            <div class="card-body table-responsive">
                @php $totalDiscount = 0; @endphp

                <table class="table table-bordered">
                    <thead>
                        <tr>
                            <th>Date</th>
                            <th>Brick Type</th>
                            <th class="text-end">Qty</th>
                            <th class="text-end">Subtotal</th>
                            <th class="text-end">Final</th>
                            <th class="text-end">Discount</th>
                        </tr>
                    </thead>

                    <tbody>
                        @foreach($salesDetails as $s)
                            @php
                                $sub = (float)($s->subtotal_num ?? 0);
                                $final = (float)($s->amount_num ?? 0);
                                $discount = max(0, $sub - $final);
                                $totalDiscount += $discount;
                            @endphp
                            <tr>
                                <td>{{ \Carbon\Carbon::parse($s->item_created_at)->format('d M Y') }}</td>
                                <td>{{ $brickTypes->firstWhere('id', $s->brick_type_id)->name ?? 'Unknown' }}</td>
                                <td class="text-end">{{ number_format($s->sold_qty) }}</td>
                                <td class="text-end">{{ number_format($sub, 2) }}</td>
                                <td class="text-end">{{ number_format($final, 2) }}</td>
                                <td class="text-end text-danger">{{ number_format($discount, 2) }}</td>
                            </tr>
                        @endforeach
                    </tbody>

                    <tfoot>
                        <tr>
                            <th colspan="5" class="text-end">Total Discount</th>
                            <th class="text-end text-danger">{{ number_format($totalDiscount, 2) }}</th>
                        </tr>
                        <tr>
                            <th colspan="5" class="text-end">Total Revenue</th>
                            <th class="text-end">{{ number_format($totalRevenue, 2) }}</th>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>

        {{-- PROFIT --}}
        <div class="card mb-5">
            <div class="card-header bg-primary text-white">
                <h5>Profit & Loss</h5>
            </div>

            <div class="card-body">
                <table class="table table-bordered">
                    <tr>
                        <th>Total Revenue</th>
                        <td class="text-end">{{ number_format($totalRevenue, 2) }}</td>
                    </tr>
                    <tr>
                        <th>Total Cost</th>
                        <td class="text-end">{{ number_format($totalCost, 2) }}</td>
                    </tr>
                    <tr class="{{ $profit < 0 ? 'table-danger' : 'table-success' }}">
                        <th>Net Profit</th>
                        <td class="text-end">{{ number_format($profit, 2) }}</td>
                    </tr>
                </table>
            </div>
        </div>

    </div>
</div>
@endsection