@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">
                    <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">
                            <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 as $supplier)
                                        <option value="{{ $supplier->id }}" {{ request('supplier_id') == $supplier->id ? 'selected' : '' }}>
                                            {{ $supplier->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </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.cement_stock') }}" class="btn btn-secondary">
                                <i class="fa fa-sync"></i> Reset
                            </a>
                        </div>
                    </div>
                </form>
            </div>
        </div>

        @if($purchases->isEmpty() && $production->isEmpty() && $sales->isEmpty())
            <div class="alert alert-info">No data found for the selected filters.</div>
        @else
            <!-- Export Button -->
            <div class="mb-3 text-end">
                <a href="" class="btn btn-success">
                    <i class="fa fa-download"></i> Export to Excel
                </a>
            </div>

            <!-- Purchases Section -->
            <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-right">Quantity (Bags)</th>
                                    <th class="text-right">Price per Bag</th>
                                    <th class="text-right">Total Amount</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($purchases as $purchase)
                                <tr>
                                    <td>{{ $purchase->created_at->format('d M Y') }}</td>
                                    <td>{{ $purchase->supplier->name }}</td>
                                    <td class="text-right">{{ number_format($purchase->total) }}</td>
                                    <td class="text-right">{{ number_format($purchase->bought_price, 2) }}</td>
                                    <td class="text-right">{{ number_format($purchase->bought_price * $purchase->total, 2) }}</td>
                                </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th colspan="2" class="text-right">Total Purchases</th>
                                    <th class="text-right" style="border-top: 2px solid #000; border-bottom: 2px solid #000">{{ number_format($purchases->sum('total')) }}</th>
                                    <th class="text-right" style="border-top: 2px solid #000; border-bottom: 2px solid #000">{{ number_format($purchases->sum('bought_price'), 2) }}</th>
                                    <th class="text-right" style="border-top: 2px solid #000; border-bottom: 2px solid #000">{{ number_format($purchases->sum(function($item) {
                                        return $item->bought_price * $item->total;
                                    }), 2) }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>

            <!-- Production Section -->
            <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>
                                @php
                                    $totalCement = 0;
                                    $totalBricks = 0;
                                @endphp

                                @foreach($production as $prod)
                                    @php
                                        $stock_bricks = App\Models\StockBrick::where('stock_id', $prod->id)->first();
                                        $bricks_produced = $stock_bricks ? $stock_bricks->total_bricks_without_fault : 0;
                                        $status = $stock_bricks && $stock_bricks->expected_output != 0
                                                ? 'Actual Output Not Given'
                                                : '';

                                        $totalCement += $prod->total;
                                        $totalBricks += $bricks_produced;
                                    @endphp
                                    <tr>
                                        <td>{{ $prod->created_at->format('d M Y') }}</td>
                                        <td class="text-end">{{ number_format($prod->total) }}</td>
                                        <td class="text-end">{{ number_format($bricks_produced) }}</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($totalCement) }} 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($totalBricks) }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>

            <!-- Sales Section -->
            <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">Unit Price</th>
                                    <th class="text-end">Total Amount</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $totalQuantity = 0;
                                    $totalAmount = 0;
                                    $totalUnitPrice = 0;
                                @endphp
                                @foreach($sales as $sale)
                                    @php
                                        $unitPrice = str_replace(',', '', $sale->selling_price);
                                        $saleAmount = $sale->quantity * $unitPrice;
                                        $totalQuantity += $sale->quantity;
                                        $totalAmount += $saleAmount;
                                        $totalUnitPrice += $unitPrice;
                                    @endphp
                                    <tr>
                                        <td class="text-center">{{ \Carbon\Carbon::parse($sale->created_at)->format('d M Y') }}</td>
                                        <td class="text-end">{{ number_format($sale->quantity) }}</td>
                                        <td class="text-end">{{ number_format($unitPrice, 2) }}</td>
                                        <td class="text-end">{{ number_format($saleAmount, 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($totalUnitPrice, 2) }}
                                    </td>

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

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

            <!-- Stock Summary Section -->
            <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->sum('total')) }} bags</td>
                                        </tr>
                                        <tr>
                                            <th>Total Used in Production</th>
                                            <td class="text-end">{{ number_format($production->sum('total')) }} bags</td>
                                        </tr>
                                        <tr>
                                            <th>Total Sold</th>
                                            <td class="text-end">{{ number_format($sales->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() {
        // Initialize select2
        $('.select2').select2({
            theme: 'bootstrap4'
        });

        // Set max date for end date based on start date
        $('#start_date').change(function() {
            $('#end_date').attr('min', $(this).val());
        });

        // Set min date for start date based on end date
        $('#end_date').change(function() {
            $('#start_date').attr('max', $(this).val());
        });
    });
</script>
@endsection