@extends('layouts.main')

@section('content')
<div class="content-wrapper">
    <div class="content-header">
        <div class="container-fluid p-0">
            <h1 class="h3 mb-3">Cement Stock Movement 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 Report</h5>
            </div>
            <div class="card-body">
                <form action="{{ route('reports.cement_stock') }}" 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') ?? 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>

                        {{-- ✅ WORKSTATION DROPDOWN --}}
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="work_station_id">Work Station (Optional)</label>
                                <select class="form-control select2" id="work_station_id" name="work_station_id">
                                    <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>

                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="supplier_id">Supplier (Optional)</label>
                                <select class="form-control select2" id="supplier_id" name="supplier_id">
                                    <option value="">All Suppliers</option>
                                    @foreach(($suppliers ?? collect()) as $supplier)
                                        <option value="{{ $supplier->id }}"
                                            {{ (string)request('supplier_id') === (string)$supplier->id ? 'selected' : '' }}>
                                            {{ $supplier->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.cement_stock') }}" class="btn btn-secondary">
                                    <i class="fa fa-sync"></i> Reset
                                </a>
                            </div>

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

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

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

            {{-- =======================
                 1) Cement Purchases
                 ======================= --}}
            <div class="card mb-4">
                <div class="card-header bg-primary text-white">
                    <h5 class="card-title mb-0">1. Cement Purchases (Bought In)</h5>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th>Date</th>
                                    <th>Supplier</th>
                                    <th class="text-end">Quantity (Bags)</th>
                                    <th class="text-end">Price per Bag</th>
                                    <th class="text-end">Total Amount</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach(($purchases ?? collect()) as $purchase)
                                    @php
                                        $supplierName = $purchase->supplier_name
                                            ?? (isset($purchase->supplier) && $purchase->supplier ? $purchase->supplier->name : '');

                                        $qty = (float) ($purchase->total ?? 0);

                                        $unit = $purchase->bought_price ?? $purchase->purchase_cost_per_unit ?? 0;
                                        $unit = (float) str_replace(',', '', (string)$unit);

                                        $amount = $unit * $qty;
                                    @endphp
                                    <tr>
                                        <td>{{ optional($purchase->created_at)->format('d M Y') }}</td>
                                        <td>{{ $supplierName }}</td>
                                        <td class="text-end">{{ number_format($qty) }}</td>
                                        <td class="text-end">{{ number_format($unit, 2) }}</td>
                                        <td class="text-end">{{ number_format($amount, 2) }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                @php
                                    $totalPurchaseQty = (float) ($purchases ?? collect())->sum('total');
                                    $totalPurchaseAmount = (float) ($purchases ?? collect())->sum(function($p){
                                        $qty = (float)($p->total ?? 0);
                                        $unit = $p->bought_price ?? $p->purchase_cost_per_unit ?? 0;
                                        $unit = (float) str_replace(',', '', (string)$unit);
                                        return $qty * $unit;
                                    });
                                @endphp
                                <tr>
                                    <th colspan="2" class="text-end">Total Purchases</th>
                                    <th class="text-end" style="border-top:2px solid #000; border-bottom:2px solid #000">
                                        {{ number_format($totalPurchaseQty) }}
                                    </th>
                                    <th class="text-end" style="border-top:2px solid #000; border-bottom:2px solid #000">-</th>
                                    <th class="text-end" style="border-top:2px solid #000; border-bottom:2px solid #000">
                                        {{ number_format($totalPurchaseAmount, 2) }}
                                    </th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>

            @php
                $productionIds = ($production ?? collect())->pluck('id')->toArray();

                $stockBricksMap = \App\Models\StockBrick::whereIn('stock_id', $productionIds)
                    ->get()
                    ->keyBy('stock_id');

                $totalCementUsed = 0;
                $totalGoodBricks = 0;
            @endphp

            {{-- =======================
                 2) Cement Used in Production
                 ======================= --}}
            <div class="card mb-4">
                <div class="card-header bg-info text-white">
                    <h5 class="card-title mb-0">2. Cement Used in Production</h5>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th>Date</th>
                                    <th class="text-end">Cement (Bags)</th>
                                    <th class="text-end">Good Bricks</th>
                                    <th>Status</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach(($production ?? collect()) as $prod)
                                    @php
                                        $sb = $stockBricksMap[$prod->id] ?? null;

                                        $good = $sb ? (int)($sb->total_bricks_without_fault ?? 0) : 0;
                                        $expected = $sb ? (int)($sb->expected_output ?? 0) : 0;
                                        $actual = $sb ? (int)($sb->actual_output ?? 0) : 0;

                                        $status = ($sb && $expected > 0 && $actual <= 0) ? 'Actual Output Not Given' : '';

                                        $cement = (int)($prod->total ?? 0);

                                        $totalCementUsed += $cement;
                                        $totalGoodBricks += $good;
                                    @endphp
                                    <tr>
                                        <td>{{ optional($prod->created_at)->format('d M Y') }}</td>
                                        <td class="text-end">{{ number_format($cement) }}</td>
                                        <td class="text-end">{{ number_format($good) }}</td>
                                        <td class="text-danger">{{ $status }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                <tr style="border-top: 2px solid #000;">
                                    <th colspan="3" class="text-end">Total Cement Used:</th>
                                    <th class="text-end">{{ number_format($totalCementUsed) }} bags</th>
                                </tr>
                                <tr style="border-bottom: 2px solid #000;">
                                    <th colspan="3" class="text-end">Total Good Bricks:</th>
                                    <th class="text-end">{{ number_format($totalGoodBricks) }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>

            {{-- =======================
                 3) Cement Sales
                 ======================= --}}
            <div class="card mb-4">
                <div class="card-header bg-success text-white">
                    <h5 class="card-title mb-0">
                        3. Cement Sales ({{ \Carbon\Carbon::parse($startDate)->format('d M Y') }} - {{ \Carbon\Carbon::parse($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">Quantity (Bags)</th>
                                    <th class="text-end">Buying Price</th>
                                    <th class="text-end">Selling Price</th>
                                    <th class="text-end">Total Amount</th>
                                    <th class="text-end">Profit Gained</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $totalQuantity = 0;
                                    $totalAmount = 0;
                                    $totalBuying = 0;
                                    $totalSelling = 0;
                                    $totalProfitGained = 0;
                                @endphp

                                @foreach(($sales ?? collect()) as $sale)
                                    @php
                                        $qty = (int)($sale->quantity ?? 0);

                                        $buy  = (float) str_replace(',', '', (string)($sale->buying_price ?? 0));
                                        $sell = (float) str_replace(',', '', (string)($sale->selling_price ?? 0));

                                        $amount = $qty * $sell;
                                        $cost   = $qty * $buy;
                                        $profitGained = $amount - $cost;

                                        $totalQuantity += $qty;
                                        $totalAmount += $amount;
                                        $totalBuying += $buy;
                                        $totalSelling += $sell;
                                        $totalProfitGained += $profitGained;
                                    @endphp
                                    <tr>
                                        <td class="text-center">{{ \Carbon\Carbon::parse($sale->created_at)->format('d M Y') }}</td>
                                        <td class="text-end">{{ number_format($qty) }}</td>
                                        <td class="text-end">{{ number_format($buy, 2) }}</td>
                                        <td class="text-end">{{ number_format($sell, 2) }}</td>
                                        <td class="text-end">{{ number_format($amount, 2) }}</td>
                                        <td class="text-end {{ $profitGained < 0 ? 'text-danger' : 'text-success' }}">
                                            {{ number_format($profitGained, 2) }}
                                        </td>
                                    </tr>
                                @endforeach
                            </tbody>

                            <tfoot>
                                <tr>
                                    <td class="text-end fw-bold">Total Sales</td>
                                    <td class="text-end fw-bold" style="border-top:3px solid #000; border-bottom:2px solid #000">
                                        {{ number_format($totalQuantity) }}
                                    </td>
                                    <td class="text-end fw-bold" style="border-top:3px solid #000; border-bottom:2px solid #000">
                                        {{ number_format($totalBuying, 2) }}
                                    </td>
                                    <td class="text-end fw-bold" style="border-top:3px solid #000; border-bottom:2px solid #000">
                                        {{ number_format($totalSelling, 2) }}
                                    </td>
                                    <td class="text-end fw-bold" style="border-top:3px solid #000; border-bottom:2px solid #000">
                                        {{ number_format($totalAmount, 2) }}
                                    </td>
                                    <td class="text-end fw-bold" style="border-top:3px solid #000; border-bottom:2px solid #000">
                                        {{ number_format($totalProfitGained, 2) }}
                                    </td>
                                </tr>
                            </tfoot>

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

            {{-- =======================
                 4) Current Stock Summary
                 ======================= --}}
            <div class="card">
                <div class="card-header bg-secondary text-white">
                    <h5 class="card-title mb-0">4. Current Stock Summary</h5>
                </div>
                <div class="card-body">
                    <div class="row">
                        <!-- Stock Movement -->
                        <div class="col-md-6">
                            <div class="card">
                                <div class="card-body">
                                    <h6 class="card-title">Stock Movement</h6>
                                    <table class="table table-sm">
                                        <tr>
                                            <th>Opening Stock (as of {{ $startDate->format('d M Y') }})</th>
                                            <td class="text-end">{{ number_format($openingStock ?? 0) }} bags</td>
                                        </tr>
                                        <tr>
                                            <th>Total Purchased</th>
                                            <td class="text-end">{{ number_format(($purchases ?? collect())->sum('total')) }} bags</td>
                                        </tr>
                                        <tr>
                                            <th>Total Used in Production</th>
                                            <td class="text-end">{{ number_format(($production ?? collect())->sum('total')) }} bags</td>
                                        </tr>
                                        <tr>
                                            <th>Total Sold</th>
                                            <td class="text-end">{{ number_format(($sales ?? collect())->sum('quantity')) }} bags</td>
                                        </tr>
                                        <tr class="table-primary">
                                            <th><strong>Closing Stock (as of {{ $endDate->format('d M Y') }})</strong></th>
                                            <td class="text-end"><strong>{{ number_format($closingStock ?? 0) }} bags</strong></td>
                                        </tr>
                                    </table>
                                </div>
                            </div>
                        </div>

                        <!-- Stock Value -->
                        <div class="col-md-6">
                            <div class="card">
                                <div class="card-body">
                                    <h6 class="card-title">Stock Value</h6>
                                    <table class="table table-sm">
                                        <tr>
                                            <th>Average Purchase Rate</th>
                                            <td class="text-end">{{ number_format($averageRate ?? 0, 2) }} per bag</td>
                                        </tr>
                                        <tr>
                                            <th>Average Sale Rate</th>
                                            <td class="text-end">{{ number_format($averageSaleRate ?? 0, 2) }} per bag</td>
                                        </tr>
                                        <tr class="table-info">
                                            <th><strong>Current Stock Value</strong></th>
                                            <td class="text-end">
                                                <strong>{{ number_format(($closingStock ?? 0) * ($averageRate ?? 0), 2) }}</strong>
                                            </td>
                                        </tr>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

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

@section('scripts')
<script>
    $(document).ready(function() {
        $('.select2').select2({ theme: 'bootstrap4' });

        $('#start_date').change(function() {
            $('#end_date').attr('min', $(this).val());
        });

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