@php
    use App\Helpers\CommonHelper;

    $companyId = $companyId ?? Session::get('run_company');
    $printDate = date('d-M-y h:i A');
    $deliveryDate = !empty($row->due_date)
        ? strtoupper(date('d-M-y', strtotime($row->due_date)))
        : strtoupper(date('d-M-y', strtotime($row->purchase_request_date)));

    $orderNo = $row->purchase_request_no ?? '';
    $numericOrderNo = ltrim(preg_replace('/\D/', '', (string) $orderNo), '0');
    $orderNoDisplay = $numericOrderNo !== '' ? $numericOrderNo : $orderNo;

    $soNo = trim($row->s_order_no ?? '');
    if ($soNo === '' && !empty($row->sales_order_id)) {
        CommonHelper::companyDatabaseConnection($companyId);
        $soNo = DB::table('sales_order')->where('id', $row->sales_order_id)->value('so_no') ?? '';
        CommonHelper::reconnectMasterDatabase();
    }

    $productCount = count($purchaseRequestDataDetail);
    $lineTotal = 0;
    foreach ($purchaseRequestDataDetail as $lineRow) {
        $lineTotal += (float) ($lineRow->net_amount ?? 0);
    }
    $grandTotal = $lineTotal + (float) ($row->sales_tax_amount ?? 0);
    if ($grandTotal <= 0 && !empty($row->total_amount)) {
        $grandTotal = (float) $row->total_amount;
    }

    $paymentContact = trim($letterhead->footer_text ?? '');
    if ($paymentContact === '') {
        $paymentContact = 'FOR PAYMENTS PLEASE CONTACT ACCOUNTS DEPARTMENT.';
    }
@endphp

<table class="no-border" style="margin-bottom: 12px;">
    <tr>
        <td style="width: 50%; padding-right: 8px; border: 0;">
            <div class="po-info-box">
                <table class="po-info-table">
                    <tr>
                        <td class="lbl">Supplier :</td>
                        <td class="val upper">{{ strtoupper($supplier->name ?? '') }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Address :</td>
                        <td class="val upper">{{ strtoupper(trim($supplier->address ?? '')) }}</td>
                    </tr>
                </table>
            </div>
        </td>
        <td style="width: 50%; padding-left: 8px; border: 0;">
            <div class="po-info-box">
                <table class="po-info-table">
                    <tr>
                        <td class="lbl">Order No. :</td>
                        <td class="val">{{ $orderNoDisplay }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Delivery Date :</td>
                        <td class="val">{{ $deliveryDate }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Prepared By :</td>
                        <td class="val upper">{{ strtoupper($row->username ?? '') }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Print Date :</td>
                        <td class="val">{{ strtoupper($printDate) }}</td>
                    </tr>
                </table>
            </div>
        </td>
    </tr>
</table>

<table class="po-items-table">
    <thead>
        <tr>
            <th colspan="4" class="particulars-head">Particulars</th>
            <th style="width: 18%;">Remarks</th>
        </tr>
        <tr>
            <th style="width: 18%;">Quantity</th>
            <th style="width: 12%;">Unit</th>
            <th style="width: 18%;">Rate</th>
            <th style="width: 18%;">Amount</th>
            <th></th>
        </tr>
    </thead>
    <tbody>
        @foreach($purchaseRequestDataDetail as $row1)
            @php
                $subIcDetail = explode(',', CommonHelper::get_subitem_detail($row1->sub_item_id));
                $itemName = CommonHelper::get_item_name($row1->sub_item_id);
                if (!empty($row1->description) && !is_numeric($row1->description)) {
                    $itemName = $row1->description;
                }
                $uomId = $row1->uom_id ?? ($subIcDetail[0] ?? '');
                $uomName = CommonHelper::get_uom_name($uomId);
                $qty = $row1->display_qty ?? $row1->purchase_approve_qty ?? 0;
                $remarksText = trim($qty . ' ' . $uomName);
            @endphp
            <tr>
                <td colspan="4">
                    <div class="item-desc upper">{{ strtoupper($itemName) }}</div>
                    <table class="item-values">
                        <tr>
                            <td style="width: 25%;">{{ number_format((float) $qty, 4, '.', '') }}</td>
                            <td style="width: 20%;">{{ $uomName }}</td>
                            <td style="width: 25%;">{{ number_format((float) ($row1->rate ?? 0), 4, '.', '') }}</td>
                            <td class="amount-val" style="width: 30%;">{{ number_format((float) ($row1->net_amount ?? 0), 2) }}</td>
                        </tr>
                    </table>
                </td>
                <td class="center">{{ $remarksText }}</td>
            </tr>
        @endforeach
    </tbody>
</table>

<div class="po-product-count">Total No of Products : {{ $productCount }}</div>
<hr class="po-hr-double">

<div class="po-payment-contact">{{ strtoupper($paymentContact) }}</div>

<table class="no-border po-totals-row">
    <tr>
        <td class="po-amount-words">
            <span class="bold">Amount In Words :</span>
            {{ $row->amount_in_words ?? '' }}
        </td>
        <td class="po-total-amount">
            <span class="bold">Total Amount :</span>
            {{ number_format($grandTotal, 2) }}
        </td>
    </tr>
</table>

<hr class="po-hr">

@if($soNo !== '')
    <div class="po-so-no"><span class="bold">S.O. No. :</span> {{ strtoupper($soNo) }}</div>
@endif

<div class="po-footer-note">
    <div class="note-title">"اہم نوٹ"</div>
    <div class="note-line">یہ آرڈر صرف اس صورت میں قبول کیا جائے گا جب مسٹر مصطفیٰ لوکھنڈوالا اور مسٹر طاہر لوکھنڈوالا</div>
    <div class="note-line">اسے آپ کو اپنے واٹس ایپ کے ذریعے بھیجیں گے۔</div>
    <div class="note-line">آرڈر کی ہارڈ کاپی موصول کرنا ادائیگی کے عمل کے لیے کافی نہیں ہے۔</div>
</div>