@extends('includes.main')

@section('main-container')
    <main>
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <h1>Stock Report</h1>
                    <div class="separator mb-5"></div>
                </div>
            </div>

            {{-- Supply form --}}
            <div class="card mb-4">
                <div class="card-body">
                    <h5 class="mb-4">Report Filter</h5>
                    <form method="POST" id="frm-supply" action="{{ route('report.income') }}">
                        @csrf
                        <div class="form-row">
                            <div class="form-group col-md-6">
                                <label>Select Year & Month</label>
                                <input type="date" class="form-control datepicker" name="from_date" id="date"
                                    autocomplete="off" placeholder="Date">
                            </div>
                        </div>
                        <button type="submit" id="" class="btn btn-primary d-block mt-3">Generate</button>
                    </form>
                </div>
            </div>

            @if ($grand_total_profit > 0)
                {{-- Table form --}}
                <div class="row mb-4">
                    <div class="col-lg-12 col-md-12 mb-4">
                        <div class="card">
                            @if (session()->has('type'))
                                <div class="alert alert-{{ session()->get('type') }}" role="alert">
                                    <p>{{ session()->get('message') }}</p>
                                </div>
                            @endif
                            @if ($errors->any())
                                <div class="alert alert-danger" role="alert">
                                    <ul>
                                        @foreach ($errors->all() as $error)
                                            <li>{{ $error }}</li>
                                        @endforeach
                                    </ul>
                                </div>
                            @endif
                            <div class="card-body">
                                <h5 class="card-title float-left">Stock Report</h5>
                                <table class="table">
                                    <thead>
                                        <!-- Section: Products, Total Later, and Total Profits -->
                                        <tr class="bg-success text-white">
                                            <th colspan="2">Products</th>
                                            <th>Oogra Total Later</th>
                                            <th>Oogra Total Profits</th>
                                            <th>Total Later</th>
                                            <th>Total Profits</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <!-- Loop: Product Data -->
                                        @php
                                            $adjusted_grand_total_profit = 0; // Initialize adjusted grand total
                                            $totalProfit = 0; // Initialize adjusted grand total
                                        @endphp
                                        @foreach ($product_data as $item)
                                            @php
                                                // Calculate totalLaters using the loop
                                                $totalLaters = 0;
                                                foreach ($productTotalLaters as $productLater) {
                                                    if ($productLater['product_id'] == $item->product_id) {
                                                        $totalLaters = $productLater['total_laters'];
                                                        break;
                                                    }
                                                }

                                                $totalProfit = $item->total_profit - $item->ogra_profit - $item->extra_profit;
                                                // Calculate adjusted profit by deducting 0.40 for each 'later'
                                                $adjusted_profit = $totalProfit - ($totalLaters - $item->total_ogra_quantity)* 0.4;
                                                $adjusted_grand_total_profit += $adjusted_profit; // Add to grand total
                                                $adjusted_grand_total_profit += $item->ogra_profit; // Add to grand total
                                            @endphp
                                            <tr>
                                                <td colspan="2">{{ $item->title }}</td>
                                                <td>{{ $item->total_ogra_quantity }}</td>
                                                <td>{{ $item->ogra_profit }}</td>
                                                <td>{{ $totalLaters }}</td>
                                                <td>{{ number_format($adjusted_profit, 2) }}</td>
                                            </tr>
                                        @endforeach
                                        <tr>
                                            <td colspan="5"><strong>Total</strong></td>
                                            <td><strong>{{ number_format($adjusted_grand_total_profit, 2) }}</strong></td>
                                        </tr>

                                        <!-- Section: Total Profits and Loss -->
                                        <tr class="bg-success text-white">
                                            <th colspan="5">Products</th>
                                            <th>Total Profits and Loss</th>
                                        </tr>
                                        <!-- Loop: Profit and Loss By Product -->
                                        @foreach ($profitAndLossByProduct as $profit)
                                            <tr>
                                                <td colspan="5">{{ $profit->title }}</td>
                                                <td>{{ $profit->total_profit_loss }}</td>
                                            </tr>
                                        @endforeach
                                        <tr>
                                            <td colspan="5"><strong>Total Profit and Loss</strong></td>
                                            <td><strong>{{ $grandTotalProfitLoss }}</strong></td>
                                        </tr>

                                        <!-- Section: Expense Type and Amount -->
                                        <tr class="bg-success text-white">
                                            <th colspan="3">Products</th>
                                            <th>Sale Price</th>
                                            <th>Quantity</th>
                                            <th>Total</th>
                                        </tr>
                                        <!-- Loop: Expenses By Type -->
                                        @if (is_iterable($extraStock))
                                            @php $totalExtraStock = 0; @endphp
                                            @foreach ($extraStock as $extra)
                                                @php
                                                    $subtotal = ($extra->quantity ?? 0) * ($extra->sale_price ?? 0);
                                                    $totalExtraStock += $subtotal;
                                                @endphp
                                                <tr>
                                                    <td colspan="3">
                                                        @if ($extra->product_id == 1)
                                                            Petrol
                                                        @elseif ($extra->product_id == 2)
                                                            Diesel
                                                        @else
                                                            N/A
                                                        @endif
                                                    </td>
                                                    <td>{{ $extra->sale_price ?? 0 }}</td>
                                                    <td>{{ $extra->quantity ?? 0 }}</td>
                                                    <td>{{ $subtotal }}</td>
                                                </tr>
                                            @endforeach
                                        @else
                                            <tr>
                                                <td colspan="8">No extra stock available.</td>
                                            </tr>
                                        @endif
                                        <tr>
                                            <td colspan="5"><strong>Total Extra Stock</strong></td>
                                            <td><strong>{{ $totalExtraStock + $grandTotalProfitLoss + $adjusted_grand_total_profit }}</strong></td>
                                        </tr>
                                        <!-- Section: Expense Type and Amount -->
                                        <tr class="bg-success text-white">
                                            <th colspan="5">Expense Type</th>
                                            <th>Expense Amount</th>
                                        </tr>
                                        <!-- Loop: Expenses By Type -->
                                        @foreach ($expensesByType as $expense)
                                            <tr>
                                                <td colspan="5">{{ $expense->expense_type_name }}</td>
                                                <td>{{ $expense->total_expense }}</td>
                                            </tr>
                                        @endforeach
                                        <tr>
                                            <td colspan="5"><strong>Total Expenses</strong></td>
                                            <td><strong>{{ $totalExpenses }}</strong></td>
                                        </tr>

                                        <!-- Section: Net Total Calculation -->
                                        <tr class="bg-primary text-white">
                                            <td colspan="5"><strong>Net Total</strong></td>
                                            <td><strong>{{ $adjusted_grand_total_profit + $grandTotalProfitLoss + $totalExtraStock - $totalExpenses }}</strong>
                                            </td>
                                        </tr>

                                        <!-- Section: Stock, Sale Later, and Remaining Stock -->
                                        <table class="table table-striped">
                                            <thead>
                                                <tr class="bg-success text-white">
                                                    <th>Products</th>
                                                    <th>Total Stock Coming</th>
                                                    <th>Old Stock</th>
                                                    <th>Total Stock</th>
                                                    <th>Sale Later</th>
                                                    <th>Remaining Later</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <!-- Loop: Product Quantities -->
                                                @foreach ($product_quantities as $quantity)
                                                    @php
                                                        // Extract previous remaining stock for the current product_id
                                                        $remainingStockPrevious = 0;

                                                        foreach ($previousMonthStock as $previousStock) {
                                                            if ($previousStock->product_id == $quantity->product_id) {
                                                                $remainingStockPrevious =
                                                                    $previousStock->remaining_stock;
                                                                break;
                                                            }
                                                        }

                                                        // Calculate total stock including previous remaining stock
                                                        $totalWithPreviousStock =
                                                            $quantity->total_quantity + $remainingStockPrevious;

                                                        // Get total sale later for the current product from productTotalLaters
                                                        $totalLaters = 0;

                                                        foreach ($productTotalLaters as $productLater) {
                                                            if ($productLater['product_id'] == $quantity->product_id) {
                                                                $totalLaters = $productLater['total_laters'];
                                                                break;
                                                            }
                                                        }

                                                        // Get extra stock for the current product_id
                                                        $extraStocks = 0;
                                                        foreach ($extraStock as $extra) {
                                                            if ($extra->product_id == $quantity->product_id) {
                                                                $extraStocks = $extra->total_quantity; // Use 'total_quantity' if you need the sum
                                                                break;
                                                            }
                                                        }

                                                        // Calculate the remaining stock for the current month, including extra stock
                                                        $remainingStockCurrent =
                                                            $totalWithPreviousStock - $totalLaters + $extraStocks;
                                                    @endphp

                                                    <tr>
                                                        <td>{{ $quantity->title }}</td>
                                                        <td>{{ $quantity->total_quantity }}</td>
                                                        <td>{{ $remainingStockPrevious }}</td>
                                                        <!-- Previous remaining stock -->
                                                        <td>{{ $totalWithPreviousStock }}</td>
                                                        <!-- Sum of current total quantity and previous remaining stock -->
                                                        <td>{{ $totalLaters }}</td>
                                                        <!-- Total sale later from productTotalLaters -->
                                                        <td>{{ $remainingStockCurrent }}</td>
                                                        <!-- Remaining stock for the current month, including extra stock -->
                                                    </tr>
                                                @endforeach
                                            </tbody>

                                        </table>

                                    </tbody>
                                </table>

                            </div>

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

                <div class="card mb-5">
                    <div class="card-body">
                        <h5 class="card-title float-left">Customer Transaction List</h5>
                        <table class="table">
                            <thead>
                                <tr class="bg-success text-white">
                                    <th>Customer Name</th>
                                    <th>Credit</th>
                                    <th>Debit</th>
                                    <th>Detail</th>
                                    <th>Remaining</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $totalCredit = 0;
                                    $totalDebit = 0;
                                    $totalRemaining = 0;
                                @endphp
                
                                @foreach ($customerTransactions as $transaction)
                                    @php
                                        $remaining = $transaction->credit - $transaction->debit;
                                        $totalCredit += $transaction->credit;
                                        $totalDebit += $transaction->debit;
                                        $totalRemaining += $remaining;
                                    @endphp
                
                                    <tr>
                                        <td>{{ $transaction->customer->name }}</td>
                                        <td>{{ $transaction->credit }}</td>
                                        <td>{{ $transaction->debit }}</td>
                                        <td>{{ $transaction->detail }}</td>
                                        <td>{{ $remaining }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                <tr class="bg-primary text-white">
                                    <th>Total</th>
                                    <th>{{ $totalCredit }}</th>
                                    <th>{{ $totalDebit }}</th>
                                    <th></th>
                                    <th>{{ $totalRemaining }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
                
        </div>
        @endif
    </main>
@endsection