@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') - $total_sales->where('transaction_type', 4)->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>

    @foreach ($config as $key => $configItem)
        @if ($key == 'dscostofgoods')
            @continue
        @endif
        <div class="col-md-6">
            <table class="table table-bordered table-striped table-sm">
                <thead>
                    <tr>
                        <td colspan="4">
                            <h5 class="text-center">{{ $configItem['title'] ?? '' }}</h5>
                        </td>
                    </tr>
                    <tr>
                        <th class="text-start">Ledger</th>
                        @if ($configItem['dc_show'] == 1)
                            <th>Debit</th>
                            <th>Credit</th>
                        @endif
                        <th>Closing Balance</th>
                    </tr>
                </thead>
                <tbody class="text-end">
                    @php
                        $groupLedger = $configItem['type'] == 1 ? 1 : 0;
                    @endphp

                    @foreach ($ledger_data->where('type', $groupLedger)->whereIn('auto_code', explode(',', $configItem['codes'])) as $item)
                        @php
                            $beforeFirstDateDebit = 0;
                            if ($key != "dsexpenses") {
                                if (isset($item->child) && $item->type == 1) {
                                    $beforeFirstDateDebit = array_sum(
                                        $item->child
                                            ->map(function ($q) use ($startDate, $endDate) {
                                                return $q->journalsForOpening
                                                    ->where('type', 0)
                                                    ->where('date', '<', $startDate)
                                                    ->sum('amount');
                                            })
                                            ->toArray(),
                                    );
                                } else {
                                    $beforeFirstDateDebit = $item->journalsForOpening
                                        ->where('type', 0)
                                        ->where('date', '<', $startDate)
                                        ->sum('amount');
                                }
                            }

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

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

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

                            $opening = $beforeFirstDateDebit - $beforeFirstDateCredit;
                            $closingBalance = floatval($opening) + (floatval($debit) - floatval($credit));
                            if($key == "dsexpenses"){
                                $amountContainer['total_expense'] += $closingBalance;
                            }

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

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

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

                        <tr onclick="openModal({{ $params }})">
                            <td class="text-start">{{ $item->name }}</td>
                            @if ($configItem['dc_show'] == 1)
                                <td>{{ number_format($debit, 2) }}</td>
                                <td>{{ number_format($credit, 2) }}</td>
                            @endif
                            <td>{{ number_format($closingBalance, 2) }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    @endforeach

    <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
                        $ledgerType = 1;

                        if (isset($config['dscostofgoods']['type'])) {
                            $ledgerType = $config['dscostofgoods']['type'] == 1 ? 1 : 0;
                        }

                        foreach ($ledger_data->where('type', $ledgerType)->whereIn('auto_code', explode(',', $config['dscostofgoods']['codes'] ?? ''))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>