@php
    use Carbon\Carbon;

    function capitalizeFirstChar($itemType): string
    {
        if ($itemType === null || $itemType === "") {
            return "";
        }
        if ($itemType === "BED") {
            return "Accommodation";
        }
        return ucfirst(strtolower($itemType));
    }

    function compareDate($createdDate): string
    {
        if ($createdDate == null) {
            return "";
        }
        $createdDate = Carbon::parse($createdDate)->format('Y-m-d');
        $currentDate = Carbon::now()->format('Y-m-d');
        if ($createdDate == $currentDate) {
            return "";
        }
        return "(Reprint)";
    }

    function dateFormatter($createdDate)
    {
        if ($createdDate == null || $createdDate == "") {
            return "";
        }
        $dateTime = substr($createdDate, 0, 23);
        return Carbon::parse($dateTime)->timezone('Asia/Dhaka')->format('d-M-Y');
    }

    function getDeliveryTime($deliveryTime, $deliveryUom, $createdDate)
    {
        if ($deliveryUom == null || $deliveryTime == null || $createdDate == null) {
            return "";
        }

        $dateTime = substr($createdDate, 0, 23);
        $date = Carbon::parse($dateTime)->timezone('Asia/Dhaka');

        if ($deliveryUom === "minute") {
            return $date->addMinutes($deliveryTime);
        }

        if ($deliveryUom === "hour") {
            return $date->addHours($deliveryTime);
        }

        if ($deliveryUom === "day") {
            return $date->addDays($deliveryTime);
        }

        if ($deliveryUom === "week") {
            return $date->addWeeks($deliveryTime);
        }

        if ($deliveryUom === "month") {
            return $date->addMonths($deliveryTime);
        }

        if ($deliveryUom === "year") {
            return $date->addYears($deliveryTime);
        }
        return "";
    }

    function getLineDiscountAmount($item): float
    {
        // Prefer explicit line total discount when available
        $totalDiscount = (float)($item->totalDiscount ?? 0);
        if ($totalDiscount > 0) {
            return (float) round($totalDiscount, 2);
        }

        $quantity = (float)($item->quantity ?? 0);
        $unitPrice = (float)($item->unitPrice ?? $item->saleAmount ?? 0);

        // If discountAmount exists, decide whether it's per-unit or already a line total
        if (isset($item->discountAmount) && $item->discountAmount !== null && $item->discountAmount !== '') {
            $disc = (float)$item->discountAmount;
            if ($disc <= 0) {
                // explicitly zero
                // fall through to percentage fallback
            } else {
                // If discount amount is larger than unit price, assume it's a line total
                if ($disc > ($unitPrice * 1.01) || $disc > ($unitPrice * $quantity * 0.5)) {
                    return (float) round($disc, 2);
                }

                // Otherwise treat as per-unit discount
                return (float) round($disc * $quantity, 2);
            }
        }

        // Fallback to percentage of total sales amount
        $totalSales = (float)($item->totalSalesAmount ?? ($unitPrice * $quantity));
        $percent = (float)($item->overAllDiscountPercentage ?? 0);
        $calc = ($totalSales * $percent) / 100;
        return (float) round($calc, 2);
    }

    function getLineNetAmount($item): float
    {
        // Compute gross as unit price * quantity, then subtract the line discount
        $unitPrice = (float)($item->unitPrice ?? $item->saleAmount ?? 0);
        $quantity = (float)($item->quantity ?? 0);
        $gross = $unitPrice * $quantity;
        $lineDiscount = getLineDiscountAmount($item);
        return (float) round($gross - $lineDiscount, 2);
    }

    function groupItemsByName(array $items): array
    {
        $grouped = [];

        foreach ($items as $item) {
            $itemName = $item->productItem->name ?? $item->itemName;
            $lineDiscountAmount = getLineDiscountAmount($item);
            $lineNetAmount = getLineNetAmount($item);

            if (!isset($grouped[$itemName])) {
                $grouped[$itemName] = json_decode(json_encode($item));
                $grouped[$itemName]->quantity = (float)($item->quantity ?? 0);
                $grouped[$itemName]->netSales = $lineNetAmount;
                $grouped[$itemName]->totalSalesAmount = (float)($item->totalSalesAmount ?? 0);
                $grouped[$itemName]->discountAmount = $lineDiscountAmount;
                $grouped[$itemName]->totalDiscount = $lineDiscountAmount;
                $grouped[$itemName]->totalVat = (float)(($item->vatAmount ?? 0) * ($item->quantity ?? 0));
                $grouped[$itemName]->totalSd = (float)(($item->sdAmount ?? 0) * ($item->quantity ?? 0));
            } else {
                $grouped[$itemName]->quantity += (float)($item->quantity ?? 0);
                $grouped[$itemName]->netSales += $lineNetAmount;
                $grouped[$itemName]->totalSalesAmount += (float)($item->totalSalesAmount ?? 0);
                $grouped[$itemName]->discountAmount += $lineDiscountAmount;
                $grouped[$itemName]->totalDiscount += $lineDiscountAmount;
                $grouped[$itemName]->totalVat += (float)(($item->vatAmount ?? 0) * ($item->quantity ?? 0));
                $grouped[$itemName]->totalSd += (float)(($item->sdAmount ?? 0) * ($item->quantity ?? 0));
            }
        }

        return array_values($grouped);
    }
@endphp

        <!DOCTYPE html>
<html lang="bn">

<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title></title>
    <link href="{{ asset('style/report-style.css') }}" rel="stylesheet">
    <style>
        @page {
            header: html_myHeader;
            footer: html_myFooter;
            margin-top: 17%; !important;
            margin-bottom: 8%;
        }

        @media print {
            .page-break {
                page-break-after: always;
            }
        }

        body {
            writing-mode: tb-rl;
        }

        table {
            font-size: 10.5px;
            margin-left: auto;
            margin-right: auto;
            width: 100% !important;
        }

        .table-border {
            border: 1px solid;
            border-collapse: collapse;
        }

        .rotated-div {
            width: 200px;
            height: 100px;
            background-color: lightblue;
            border: 1px solid #000;
            text-align: center;
            line-height: 100px;
            transform: rotate(45deg);
        }

        .watermark {
            position: fixed;
            top: 50%;
            left: 50%;
            transform: translate(-50%, -50%) rotate(-45deg);
            font-size: 90px;
            font-weight: bold;
            color: rgba(0, 0, 0, 0.08);
            z-index: -1;
            white-space: nowrap;
            pointer-events: none;
        }
    </style>
</head>

<body style="font-size: 15px;">

<htmlpageheader name="myHeader" style="display:none;">
    <table width="100%">
        <tr>
            <td>
                <banner style="height: {{$data->bannerHeight}}; width: 100%">
                    @if(isset($data->bannerUrl) && $data->bannerUrl != "")
                        <img src="{{$data->bannerUrl}}" alt="">
                    @endif
                </banner>
            </td>
        </tr>
    </table>
</htmlpageheader>

<div style="width: 100%;">
    <div>
        <table width="100%">
            <tr>
                <td style="width: 13%">Name</td>
                <td style="width: 2%">:</td>
                <td style="width: 35%;">
                    @if(isset($data->customerModel->patient->dob))
                        {{$data->customerModel->patient->name}}
                    @endif
                </td>
                <td style="width: 13%">Reg</td>
                <td style="width: 2%">:</td>
                <td style="width: 35%;">
                    @if(isset($data->customerModel->patient->registrationNo))
                        {{$data->customerModel->patient->registrationNo}}
                    @endif
                </td>
            </tr>
            <tr>
                <td style="width: 13%">Gender</td>
                <td style="width: 2%">:</td>
                <td style="width: 35%;">
                    @if(isset($data->customerModel->patient->gender))
                        {{$data->customerModel->patient->gender}}
                    @endif
                </td>
                <td style="width: 13%">Age</td>
                <td style="width: 2%">:</td>
                <td style="width: 35%;">
                    @if(isset($data->customerModel->patient->dob))
                        {{\Carbon\Carbon::parse($data->customerModel->patient->dob)->diff(\Carbon\Carbon::now())->format('%y Years, %m Months')}}
                    @endif
                </td>
            </tr>
            <tr>
                <td style="width: 13%">Admission Date</td>
                <td style="width: 2%">:</td>
                <td style="width: 35%;">
                    @if(isset($data->customerModel->admissionDate))
                        {{dateFormatter($data->customerModel->admissionDate)}}
                    @endif
                </td>
                <td style="width: 13%">Admission ID</td>
                <td style="width: 2%">:</td>
                <td style="width: 35%;">
                    @if(isset($data->customerModel->admissionId))
                        {{($data->customerModel->admissionId)}}
                    @endif
                </td>
            </tr>
            <tr>
                <td style="width: 13%">Bed/Cabin</td>
                <td style="width: 2%">:</td>
                <td colspan="4" style="width: 85%;">
                    @if(isset($data->customerModel->bed->bedNo))
                        {{($data->customerModel->bed->bedNo)}}
                    @endif
                </td>
            </tr>
        </table>
    </div>

    <div style="text-align: center;">
        <h4><span style="border-bottom: 1px solid; font-weight: bold;">Consolidate Billing Summary</span></h4>
    </div>

    <div style=" width: 100%; display: flex;">
        <div style="width: 50%; float: left; padding-top: 2%">
            <div style="font-size: 90px; color: #f8e8e8; font-weight: bold; text-align: center; display: inline-block; transform: rotate(-90deg); transform-origin: left top">
                @if($data->netPayable > 0)
                    <span style="color: #fcf5f5">Draft</span>
                @else
                    <span style="color: #e9f8e2">Paid</span>
                @endif
            </div>
        </div>
        <div style="width: 50%; float: left;">
            <table width="100%">
                <tr>
                    <td style="width: 65%; text-align: right">Total Bill Amount</td>
                    <td style="width: 5%">:</td>
                    <td style="width: 30%; text-align: right"> {{number_format($data->totalBillAmount, 2)}} </td>
                </tr>
                <tr>
                    <td style="width: 65%; text-align: right">Refund Amount</td>
                    <td style="width: 5%">:</td>
                    <td style="width: 30%; text-align: right"> {{number_format($data->totalRefundAmount, 2)}} </td>
                </tr>
                <tr>
                    <td style="width: 65%; text-align: right">Discount Amount</td>
                    <td style="width: 5%">:</td>
                    <td style="width: 30%; text-align: right"> {{number_format($data->totalDiscountAmount, 2)}} </td>
                </tr>
                <tr>
                    <td style="width: 65%; text-align: right">Net Bill Amount</td>
                    <td style="width: 5%">:</td>
                    <td style="width: 30%; text-align: right"> {{number_format($data->netBillAmount, 2)}} </td>
                </tr>
                <tr>
                    <td style="width: 65%; text-align: right">Paid Amount</td>
                    <td style="width: 5%">:</td>
                    <td style="width: 30%; text-align: right"> {{number_format($data->paidAmount, 2)}} </td>
                </tr>
                <tr>
                    <td style="width: 65%; text-align: right">Deposit Amount</td>
                    <td style="width: 5%">:</td>
                    <td style="width: 30%; text-align: right"> {{number_format($data->depositAmount, 2)}} </td>
                </tr>
                @if($data->netPayable >= 0)
                    <tr>
                        <td style="width: 65%; text-align: right; font-weight: bold">Payable</td>
                        <td style="width: 5%">:</td>
                        <td style="width: 30%; text-align: right; font-weight: bold"> {{number_format($data->netPayable, 2)}} </td>
                    </tr>
                @endif
                @if($data->netPayable < 0)
                    <tr>
                        <td style="width: 65%; text-align: right; font-weight: bold">Return</td>
                        <td style="width: 5%">:</td>
                        <td style="width: 30%; text-align: right; font-weight: bold"> {{number_format($data->returnAmount, 2)}} </td>
                    </tr>
                @endif
            </table>
        </div>
    </div>

    <br>
    <br>

    <div>
        <div><span style="font-size: 12px; font-weight: bold;">Category Wise Summary</span></div>

        @php
            $calculatedSummary = [];
            foreach ($data->billingDetails as $billingType => $items) {
                $catTotal = 0;
                foreach ($items as $it) {
                    $catTotal += getLineNetAmount($it);
                }
                $calculatedSummary[] = (object)[ 'billingType' => $billingType, 'amount' => $catTotal ];
            }
            $zoneTotal = array_reduce($calculatedSummary, function ($carry, $c) { return $carry + ($c->amount ?? 0); }, 0);
        @endphp

        <table width="100%" class="table-border">
            <tr>
                <td style="width: 10%" class="text-center table-border">SL</td>
                <td style="width: 75%" class="table-border">Revenue Head</td>
                <td style="width: 15%;" class="text-center table-border">Amount</td>
            </tr>
            @foreach($calculatedSummary as $index => $item)
                <tr>
                    <td class="text-center table-border">{{$index + 1}}</td>
                    <td class="text-left table-border">{{capitalizeFirstChar($item->billingType)}}</td>
                    <td class="text-right table-border">{{number_format($item->amount, 2)}}</td>
                </tr>
            @endforeach
            <tr>
                <td></td>
                <td style="text-align: right">
                    <b>Zone Total:</b>
                </td>
                <td class="text-right">
                    <b>{{ number_format($zoneTotal, 2) }}</b>
                </td>
            </tr>
        </table>
    </div>

    <br>
    <br>

    <div>
        <div><span style="font-size: 12px; font-weight: bold;">Category Wise Details</span></div>
        <table width="100%" class="table-border">
            <thead>
            <tr>
                <th width="5%" class="table-border">SL</th>
                <th width="45%" class="table-border">Item Name</th>
                <th width="8%" class="table-border text-center">Qty</th>
                <th width="13%" class="table-border text-right">Unit Price</th>
                <th width="14%" class="table-border text-right">Discount</th>
                <th width="15%" class="table-border text-right">Net Amount</th>
            </tr>
            </thead>

            <tbody>
            @foreach($data->billingDetails as $billingType => $items)
                <tr>
                    <td colspan="6" class="table-border" style="font-weight:bold; background:#f2f2f2;">
                        {{ ucfirst(strtolower($billingType)) }}
                    </td>
                </tr>

                @php
                    $sl = 1;
                    $categoryTotal = 0;
                    $groupedItems = groupItemsByName($items);
                @endphp

                @foreach($groupedItems as $item)
                    @php
                        $lineDiscountAmount = getLineDiscountAmount($item);
                        $lineNetAmount = getLineNetAmount($item);
                        $categoryTotal += $lineNetAmount;
                    @endphp
                    <tr>
                        <td class="table-border text-center">{{ $sl++ }}</td>
                        <td class="table-border">
                            {{ $item->productItem->name ?? $item->itemName }}
                        </td>
                        <td class="table-border text-center">
                            {{ $item->quantity }}
                        </td>
                        <td class="table-border text-right">
                            {{ number_format($item->unitPrice, 2) }}
                        </td>
                        <td class="table-border text-right">
                            {{ number_format($lineDiscountAmount, 2) }}
                        </td>
                        <td class="table-border text-right">
                            {{ number_format($lineNetAmount, 2) }}
                        </td>
                    </tr>
                @endforeach

                <tr>
                    <td colspan="5" class="table-border text-right">
                        <b>{{ ucfirst(strtolower($billingType)) }} Total :</b>
                    </td>
                    <td class="table-border text-right">
                        <b>{{ number_format($categoryTotal, 2) }}</b>
                    </td>
                </tr>
            @endforeach
            </tbody>
        </table>
    </div>
</div>

<footer style="position: fixed; width: 100%; font-size: 13px; text-align: left">
    <div style=" width: 100%; display: flex;">
        <div style="width: 20%; float: left; padding-top: 15%">
            @if($data->netPayable <= 0)
                <span style="border-top: 1px solid; font-size: 12px;">Cashier Signature</span>
            @endif
        </div>
    </div>
</footer>

<htmlpagefooter name="myFooter" style="display:none">
    <table style="border-top: 1px solid black">
        <tr>
            <td>
                <span>D&T - {{ now()->timezone('Asia/Dhaka')->format('d-M-Y g:i A') }}</span>&nbsp;&nbsp;&nbsp;
                <span>Powered By - {{$data->poweredBy}}&nbsp;</span>
                <span style="text-align: right; float: right!important;">{PAGENO}/{nbpg}</span>
            </td>
        </tr>
    </table>
</htmlpagefooter>
</body>
</html>