@php
    $amountContainer = [
        'total_expense' => 0,
        'cost_of_goods_sold' => 0,
    ];

    $startDate = date('Y-m-d 00:00:00', strtotime(request()->date_from));
    $endDate = date('Y-m-d 23:59:59', strtotime(request()->date_to));
@endphp

<style>
    .table {
        margin-bottom: 0;
    }
    .table th,
    .table td {
        padding: 0.15rem 0.2rem !important;
        font-size: 15px;
        line-height: 1.2;
        text-align: right;
    }
    .table-bordered {
        border-color: #000 !important;
    }
    .row {
        display: flex;
        flex-wrap: wrap;
    }
    .text-end {
        text-align: right;
    }
    .text-center {
        text-align: center;
    }
    .text-start {
        text-align: left;
    }
    @media print {
        .col-md-6, .col-lg-4 {
            width: 50%;
        }   
    }
    {!! $print['style_css'] !!}
</style>

<div class="row g-3">
    <div class="text-center">
        {!! $print['head'] !!}
    </div>

    <div class="col-md-6">
        <table class="table table-bordered table-striped table-sm">
            <thead>
                <tr>
                    <td colspan="4"><h5 class="text-center">Sales</h5></td>
                </tr>
                <tr>
                    <th>Sales</th>
                    <th>Discount</th>
                    <th>Return</th>
                    <th>Total Sales</th>
                </tr>
            </thead>
            <tbody class="text-end">
                @php
                    $totalSalesAmount = floatval($total_sales->where('transaction_type', 3)->sum('total'));
                    $totalSalesAmount =
                        floatval($totalSalesAmount) -
                        floatval($total_sales->where('transaction_type', 4)->sum('total'));
                @endphp

                <tr>
                    <td>
                        {{ number_format($total_sales->where('transaction_type', 3)->sum('sub_total') + $total_sales->where('transaction_type', 3)->sum('vat_amount'), 2) }}
                    </td>
                    <td>{{ number_format($total_sales->where('transaction_type', 3)->sum('manual_dc'), 2) }}</td>
                    <td>{{ number_format($total_sales->where('transaction_type', 4)->sum('total'), 2) }}</td>
                    <td>{{ number_format($totalSalesAmount, 2) }}</td>
                </tr>
            </tbody>
        </table>
    </div>

    <div class="col-md-6">
        <table class="table table-bordered table-striped table-sm">
            <thead>
                <tr>
                    <td colspan="4">
                        <h5 class="text-center">Cash Bank</h5>
                    </td>
                </tr>
                <tr>
                    <th class="text-start">Ledger</th>
                    <th>Debit</th>
                    <th>Credit</th>
                    <th>Closing Balance</th>
                </tr>
            </thead>
            <tbody class="text-end">
                @foreach ($cash_bank as $cashBank)
                    @php
                        $beforeFirstDateDebit = 0;
                        if (isset($cashBank->child) && $cashBank->type == 1) {
                            $beforeFirstDateDebit = array_sum(
                                $cashBank->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 0)
                                            ->where('date', '<', $startDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $beforeFirstDateDebit = $cashBank->journals
                                ->where('type', 0)
                                ->where('date', '<', $startDate)
                                ->sum('amount');
                        }

                        $beforeFirstDateCredit = 0;
                        if (isset($cashBank->child) && $cashBank->type == 1) {
                            $beforeFirstDateCredit = array_sum(
                                $cashBank->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 1)
                                            ->where('date', '<', $startDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $beforeFirstDateCredit = $cashBank->journals
                                ->where('type', 1)
                                ->where('date', '<', $startDate)
                                ->sum('amount');
                        }

                        $debit = 0;
                        if (isset($cashBank->child) && $cashBank->type == 1) {
                            $debit = array_sum(
                                $cashBank->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 0)
                                            ->where('date', '>=', $startDate)
                                            ->where('date', '<=', $endDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $debit = $cashBank->journals
                                ->where('type', 0)
                                ->where('date', '>=', $startDate)
                                ->where('date', '<=', $endDate)
                                ->sum('amount');
                        }

                        $credit = 0;
                        if (isset($cashBank->child) && $cashBank->type == 1) {
                            $credit = array_sum(
                                $cashBank->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 1)
                                            ->where('date', '>=', $startDate)
                                            ->where('date', '<=', $endDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $credit = $cashBank->journals
                                ->where('type', 1)
                                ->where('date', '>=', $startDate)
                                ->where('date', '<=', $endDate)
                                ->sum('amount');
                        }

                        $opening = $beforeFirstDateDebit - $beforeFirstDateCredit;
                        $closingBalance = floatval($opening) + (floatval($debit) - floatval($credit));

                        $startingWith2or4 = $cashBank->auto_code ?? '';
                        if ($startingWith2or4[0] == 2 || $startingWith2or4[0] == 4) {
                            $closingBalance = $closingBalance * -1;
                        }
                    @endphp
                    @if ($closingBalance == 0)
                        @continue
                    @endif

                    @php
                        $params = [];
                        $params['info'] = $cashBank;
                        $params['start_date'] = $startDate;
                        $params['end_date'] = $endDate;
                        $params['block_type'] = 'cashbank';
                        $params = json_encode($params);
                    @endphp

                    <tr onclick="openModal({{ $params }})">
                        <td class="text-start">{{ $cashBank->name }}</td>
                        <td>{{ number_format($debit, 2) }}</td>
                        <td>{{ number_format($credit, 2) }}</td>
                        <td>{{ number_format($closingBalance, 2) }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>

    <div class="col-md-6">
        <table class="table table-bordered table-striped table-sm">
            <thead>
                <tr>
                    <td colspan="4">
                        <h5 class="text-center">Supplier Balance</h5>
                    </td>
                </tr>
                <tr>
                    <th class="text-start">Group</th>
                    <th>Debit</th>
                    <th>Credit</th>
                    <th>Closing Balance</th>
                </tr>
            </thead>
            <tbody class="text-end">
                @foreach ($supplier_balance as $supplier)
                    @php
                        $beforeFirstDateDebit = 0;
                        if (isset($supplier->child) && $supplier->type == 1) {
                            $beforeFirstDateDebit = array_sum(
                                $supplier->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 0)
                                            ->where('date', '<', $startDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $beforeFirstDateDebit = $supplier->journals
                                ->where('type', 0)
                                ->where('date', '<', $startDate)
                                ->sum('amount');
                        }

                        $beforeFirstDateCredit = 0;
                        if (isset($supplier->child) && $supplier->type == 1) {
                            $beforeFirstDateCredit = array_sum(
                                $supplier->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 1)
                                            ->where('date', '<', $startDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $beforeFirstDateCredit = $supplier->journals
                                ->where('type', 1)
                                ->where('date', '<', $startDate)
                                ->sum('amount');
                        }

                        $debit = 0;
                        if (isset($supplier->child) && $supplier->type == 1) {
                            $debit = array_sum(
                                $supplier->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 0)
                                            ->where('date', '>=', $startDate)
                                            ->where('date', '<=', $endDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $debit = $supplier->journals
                                ->where('type', 0)
                                ->where('date', '>=', $startDate)
                                ->where('date', '<=', $endDate)
                                ->sum('amount');
                        }

                        $credit = 0;
                        if (isset($supplier->child) && $supplier->type == 1) {
                            $credit = array_sum(
                                $supplier->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 1)
                                            ->where('date', '>=', $startDate)
                                            ->where('date', '<=', $endDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $credit = $supplier->journals
                                ->where('type', 1)
                                ->where('date', '>=', $startDate)
                                ->where('date', '<=', $endDate)
                                ->sum('amount');
                        }

                        $opening = $beforeFirstDateDebit - $beforeFirstDateCredit;
                        $closingBalance = floatval($opening) + floatval($debit) - floatval($credit);

                        $startingWith2or4 = $supplier->auto_code ?? '';
                        if ($startingWith2or4[0] == 2 || $startingWith2or4[0] == 4) {
                            $closingBalance = $closingBalance * -1;
                        }
                    @endphp
                    @if ($closingBalance == 0)
                        @continue
                    @endif

                    @php
                        $params = [];
                        $params['info'] = $supplier;
                        $params['start_date'] = $startDate;
                        $params['end_date'] = $endDate;
                        $params['block_type'] = 'supplier';
                        $params = json_encode($params);
                    @endphp

                    <tr onclick="openModal({{ $params }})">
                        <td class="text-start">{{ $supplier->name }}</td>
                        <td>{{ number_format($debit, 2) }}</td>
                        <td>{{ number_format($credit, 2) }}</td>
                        <td>{{ number_format($closingBalance, 2) }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>

    <div class="col-md-6">
        <table class="table table-bordered table-striped table-sm">
            <thead>
                <tr>
                    <td colspan="4">
                        <h5 class="text-center">Payable</h5>
                    </td>
                </tr>
                <tr>
                    <th class="text-start">Ledger</th>
                    <th>Debit</th>
                    <th>Credit</th>
                    <th>Closing Balance</th>
                </tr>
            </thead>
            <tbody class="text-end">
                @foreach ($payable as $pay)
                    @php
                        $beforeFirstDateDebit = 0;
                        if (isset($cashBank->child) && $pay->type == 1) {
                            $beforeFirstDateDebit = array_sum(
                                $pay->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 0)
                                            ->where('date', '<', $startDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $beforeFirstDateDebit = $pay->journals
                                ->where('type', 0)
                                ->where('date', '<', $startDate)
                                ->sum('amount');
                        }

                        $beforeFirstDateCredit = 0;
                        if (isset($pay->child) && $pay->type == 1) {
                            $beforeFirstDateCredit = array_sum(
                                $pay->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 1)
                                            ->where('date', '<', $startDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $beforeFirstDateCredit = $pay->journals
                                ->where('type', 1)
                                ->where('date', '<', $startDate)
                                ->sum('amount');
                        }

                        $debit = 0;
                        if (isset($pay->child) && $pay->type == 1) {
                            $debit = array_sum(
                                $pay->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 0)
                                            ->where('date', '>=', $startDate)
                                            ->where('date', '<=', $endDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $debit = $pay->journals
                                ->where('type', 0)
                                ->where('date', '>=', $startDate)
                                ->where('date', '<=', $endDate)
                                ->sum('amount');
                        }

                        $credit = 0;
                        if (isset($pay->child) && $pay->type == 1) {
                            $credit = array_sum(
                                $pay->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 1)
                                            ->where('date', '>=', $startDate)
                                            ->where('date', '<=', $endDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $credit = $pay->journals
                                ->where('type', 1)
                                ->where('date', '>=', $startDate)
                                ->where('date', '<=', $endDate)
                                ->sum('amount');
                        }

                        $opening = $beforeFirstDateDebit - $beforeFirstDateCredit;
                        $closingBalance = floatval($opening) + floatval($debit) - floatval($credit);
                        $startingWith2or4 = $pay->auto_code ?? '';
                        if ($startingWith2or4[0] == 2 || $startingWith2or4[0] == 4) {
                            $closingBalance = $closingBalance * -1;
                        }
                    @endphp
                    @if ($closingBalance == 0)
                        @continue
                    @endif

                    @php
                        $params = [];
                        $params['info'] = $pay;
                        $params['start_date'] = $startDate;
                        $params['end_date'] = $endDate;
                        $params['block_type'] = 'payable';
                        $params = json_encode($params);
                    @endphp

                    <tr onclick="openModal({{ $params }})">
                        <td class="text-start">{{ $pay->name }}</td>
                        <td>{{ number_format($debit, 2) }}</td>
                        <td>{{ number_format($credit, 2) }}</td>
                        <td>{{ number_format($closingBalance, 2) }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>

    <div class="col-md-6">
        <table class="table table-bordered table-striped table-sm">
            <thead>
                <tr>
                    <td colspan="4">
                        <h5 class="text-center">Customer Balance</h5>
                    </td>
                </tr>
                <tr>
                    <th class="text-start">Group</th>
                    <th>Debit</th>
                    <th>Credit</th>
                    <th>Closing Balance</th>
                </tr>
            </thead>
            <tbody class="text-end">
                @foreach ($customer_balance as $customer)
                    @php
                        $beforeFirstDateDebit = 0;
                        if (isset($customer->child) && $customer->type == 1) {
                            $beforeFirstDateDebit = array_sum(
                                $customer->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 0)
                                            ->where('date', '<', $startDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $beforeFirstDateDebit = $customer->journals
                                ->where('type', 0)
                                ->where('date', '<', $startDate)
                                ->sum('amount');
                        }

                        $beforeFirstDateCredit = 0;
                        if (isset($customer->child) && $customer->type == 1) {
                            $beforeFirstDateCredit = array_sum(
                                $customer->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 1)
                                            ->where('date', '<', $startDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $beforeFirstDateCredit = $customer->journals
                                ->where('type', 1)
                                ->where('date', '<', $startDate)
                                ->sum('amount');
                        }

                        $debit = 0;
                        if (isset($customer->child) && $customer->type == 1) {
                            $debit = array_sum(
                                $customer->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 0)
                                            ->where('date', '>=', $startDate)
                                            ->where('date', '<=', $endDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $debit = $customer->journals
                                ->where('type', 0)
                                ->where('date', '>=', $startDate)
                                ->where('date', '<=', $endDate)
                                ->sum('amount');
                        }

                        $credit = 0;
                        if (isset($customer->child) && $customer->type == 1) {
                            $credit = array_sum(
                                $customer->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 1)
                                            ->where('date', '>=', $startDate)
                                            ->where('date', '<=', $endDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $credit = $customer->journals
                                ->where('type', 1)
                                ->where('date', '>=', $startDate)
                                ->where('date', '<=', $endDate)
                                ->sum('amount');
                        }

                        $opening = $beforeFirstDateDebit - $beforeFirstDateCredit;
                        $closingBalance = floatval($opening) + (floatval($debit) - floatval($credit));

                        $startingWith2or4 = $customer->auto_code ?? '';
                        if ($startingWith2or4[0] == 2 || $startingWith2or4[0] == 4) {
                            $closingBalance = $closingBalance * -1;
                        }
                    @endphp

                    @if ($closingBalance == 0)
                        @continue
                    @endif

                    @php
                        $params = [];
                        $params['info'] = $customer;
                        $params['start_date'] = $startDate;
                        $params['end_date'] = $endDate;
                        $params['block_type'] = 'customer';
                        $params = json_encode($params);
                    @endphp

                    <tr onclick="openModal({{ $params }})">
                        <td class="text-start">{{ $customer->name }}</td>
                        <td>{{ number_format($debit, 2) }}</td>
                        <td>{{ number_format($credit, 2) }}</td>
                        <td>{{ number_format($closingBalance, 2) }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>

    <div class="col-md-6">
        <table class="table table-bordered table-striped table-sm">
            <thead>
                <tr>
                    <td colspan="2">
                        <h5 class="text-center">Daily Expenses</h5>
                    </td>
                </tr>
                <tr>
                    <th class="text-start">Ledger</th>
                    <th>Closing Balance</th>
                </tr>
            </thead>
            <tbody class="text-end">
                @foreach ($daily_expense as $dailyExpense)
                    @php
                        $debit = 0;
                        if (isset($dailyExpense->child) && $dailyExpense->type == 1) {
                            $debit = array_sum(
                                $dailyExpense->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 0)
                                            ->where('date', '>=', $startDate)
                                            ->where('date', '<=', $endDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $debit = $dailyExpense->journals
                                ->where('type', 0)
                                ->where('date', '>=', $startDate)
                                ->where('date', '<=', $endDate)
                                ->sum('amount');
                        }

                        $credit = 0;
                        if (isset($dailyExpense->child) && $dailyExpense->type == 1) {
                            $credit = array_sum(
                                $dailyExpense->child
                                    ->map(function ($q) use ($startDate, $endDate) {
                                        return $q->journals
                                            ->where('type', 1)
                                            ->where('date', '>=', $startDate)
                                            ->where('date', '<=', $endDate)
                                            ->sum('amount');
                                    })
                                    ->toArray(),
                            );
                        } else {
                            $credit = $dailyExpense->journals
                                ->where('type', 1)
                                ->where('date', '>=', $startDate)
                                ->where('date', '<=', $endDate)
                                ->sum('amount');
                        }

                        $closingBalance = floatval($debit) - floatval($credit);
                        $amountContainer['total_expense'] += $closingBalance;
                    @endphp
                    @if ($closingBalance == 0)
                        @continue
                    @endif
                    <tr>
                        <td class="text-start">{{ $dailyExpense->name }}</td>
                        <td>{{ number_format($closingBalance, 2) }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>

    <div class="col-lg-4">
        <table class="table table-bordered table-striped table-sm">
            <thead>
                <tr>
                    <th colspan="2">
                        <h5 class="text-center">Profit</h5>
                    </th>
                </tr>
            </thead>
            <tbody>
                <tr>
                    <th>Total Sales</th>
                    <td class="text-end">{{ number_format($totalSalesAmount, 2) }}</td>
                </tr>
                <tr>
                    @php
                        foreach ($cost_of_goods as $key => $cgs) {
                            if (isset($cgs->child) && $cgs->type == 1) {
                                $amountContainer['cost_of_goods_sold'] += array_sum(
                                    $cgs->child
                                        ->map(function ($q) use ($startDate, $endDate) {
                                            return $q->journals
                                                ->where('date', '>=', $startDate)
                                                ->where('date', '<=', $endDate)
                                                ->sum('amount');
                                        })
                                        ->toArray(),
                                );
                            } else {
                                $cgsVal = $cgs->journals
                                    ->where('date', '>=', $startDate)
                                    ->where('date', '<=', $endDate)
                                    ->sum('amount');

                                $amountContainer['cost_of_goods_sold'] += floatval($cgsVal);
                            }
                        }

                    @endphp
                    <th>(-) Cost Of Goods Sold</th>
                    <td class="text-end">{{ number_format(floatval($amountContainer['cost_of_goods_sold']), 2) }}</td>
                </tr>
                <tr>
                    <th>(-) Expenses</th>
                    <td class="text-end">{{ number_format(floatval($amountContainer['total_expense']), 2) }}</td>
                </tr>
                <tr>
                    <th>Profit = </th>
                    <td class="text-end">
                        @php
                            $minusCostFromTotalSales =
                                floatval($totalSalesAmount) - floatval($amountContainer['cost_of_goods_sold']);
                        @endphp
                        {{ number_format($minusCostFromTotalSales - $amountContainer['total_expense'], 2) }}
                    </td>
                </tr>
            </tbody>
        </table>
    </div>
</div>