@php
    use App\Helpers\CommonHelper;
    use Illuminate\Support\Facades\Auth;
    use Illuminate\Support\Facades\DB;

    $companyId = $companyId ?? Session::get('run_company');
    $printDate = strtoupper(date('d-M-y h:i A'));
    $orderDate = strtoupper(date('d-M-y', strtotime($sale_quotations->quotation_date)));
    $validityDate = !empty($sale_quotations->q_valid_up_to)
        ? strtoupper(date('d-M-y', strtotime($sale_quotations->q_valid_up_to)))
        : '';

    $saleOrderNo = DB::connection('mysql2')->table('sales_order')
        ->where('purchase_order_contract', $sale_quotations->id)
        ->where('status', 1)
        ->value('so_no');
    if (empty($saleOrderNo)) {
        $numericSo = ltrim(preg_replace('/\D/', '', (string) ($sale_quotations->quotation_no ?? '')), '0');
        $saleOrderNo = $numericSo !== '' ? $numericSo : ($sale_quotations->quotation_no ?? '');
    }

    $paymentTerm = trim($sale_quotations->delivery_term ?? '');
    $preparedBy = strtoupper(trim($sale_quotations->created_by ?? ''));
    $printBy = strtoupper(trim(Auth::user()->name ?? ''));

    $customerPhone = '';
    $customerEmail = '';
    if (($sale_quotations->customer_type ?? '') === 'customer') {
        $customerRow = DB::connection('mysql2')->table('customers')
            ->where('id', $sale_quotations->customer_id)
            ->select('name', 'address', 'contact', 'email')
            ->first();
        $customerName = strtoupper($customerRow->name ?? '');
        $customerAddress = strtoupper(trim($customerRow->address ?? ''));
        $customerPhone = trim($customerRow->contact ?? '');
        $customerEmail = trim($customerRow->email ?? '');
        $kindAtt = strtoupper(trim($sale_quotations->attention ?: ($customerRow->name ?? '')));
    } else {
        $prospect = CommonHelper::get_prospect($sale_quotations->prospect_id);
        $customerName = strtoupper($prospect->company_name ?? '');
        $customerAddress = strtoupper(trim($prospect->company_address ?? ''));
        $kindAtt = strtoupper(trim($sale_quotations->attention ?? ''));
        if (!empty($prospect->contact_id)) {
            $contact = CommonHelper::get_contacts($prospect->contact_id);
            $customerPhone = trim($contact->phone ?? '');
            $customerEmail = trim($contact->email ?? '');
        }
    }

    $productCount = count($sale_quotation_data);
    $grossTotal = 0;
    $taxTotal = 0;
    $netTotal = 0;
@endphp

<table class="no-border" style="margin-bottom: 12px;">
    <tr>
        <td style="width: 50%; padding-right: 8px; border: 0;">
            <div class="sq-info-box">
                <table class="sq-info-table">
                    <tr>
                        <td class="lbl">Kind Att. :</td>
                        <td class="val">{{ $kindAtt }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Messers. :</td>
                        <td class="val">{{ $customerName }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Address :</td>
                        <td class="val">{{ $customerAddress }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Phone :</td>
                        <td class="val">{{ $customerPhone }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">E-Mail. :</td>
                        <td class="val">{{ $customerEmail }}</td>
                    </tr>
                </table>
            </div>
        </td>
        <td style="width: 50%; padding-left: 8px; border: 0;">
            <div class="sq-info-box">
                <table class="sq-info-table">
                    <tr>
                        <td class="lbl">Enquiry No. :</td>
                        <td class="val">{{ $sale_quotations->enquiry_no ?? '' }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Sale Order No. :</td>
                        <td class="val">{{ $saleOrderNo }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Order Date :</td>
                        <td class="val">{{ $orderDate }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Validity Date :</td>
                        <td class="val">{{ $validityDate }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Payment Term :</td>
                        <td class="val upper">{{ strtoupper($paymentTerm) }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Prepared By :</td>
                        <td class="val">{{ $preparedBy }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Print Date :</td>
                        <td class="val">{{ $printDate }}</td>
                    </tr>
                    <tr>
                        <td class="lbl">Print By :</td>
                        <td class="val">{{ $printBy }}</td>
                    </tr>
                </table>
            </div>
        </td>
    </tr>
</table>

<table class="sq-items-table">
    <thead>
        <tr>
            <th style="width: 24%;">Particulars</th>
            <th style="width: 7%;">Unit</th>
            <th style="width: 10%;">Quantity</th>
            <th style="width: 10%;">Rate</th>
            <th style="width: 12%;">Gross Amt.</th>
            <th style="width: 7%;">Tax</th>
            <th style="width: 10%;">Tax Amt.</th>
            <th style="width: 12%;">Net Amt.</th>
            <th style="width: 8%;">Remarks</th>
        </tr>
    </thead>
    <tbody>
        @foreach ($sale_quotation_data as $value)
            @php
                $item = DB::connection('mysql2')->table('subitem as s')
                    ->leftJoin(env('DB_DATABASE') . '.uom as u', 's.uom', '=', 'u.id')
                    ->where('s.id', $value->item_id)
                    ->select('s.sub_ic', 'u.uom_name')
                    ->first();
                $itemName = strtoupper(trim($item->sub_ic ?? ''));
                if (!empty($value->item_description)) {
                    $itemName = strtoupper(trim(strip_tags($value->item_description)));
                }
                $uomName = strtoupper(CommonHelper::get_uom_name($value->uom_id) ?: ($item->uom_name ?? ''));
                $qty = (float) ($value->qty ?? 0);
                $rate = (float) ($value->unit_price ?? 0);
                $grossAmt = (float) ($value->total_amount ?? 0);
                $lineTaxRate = (float) ($value->sales_tax_rate ?? $gstRate ?? 0);
                $lineTaxAmt = ($grossAmt / 100) * $lineTaxRate;
                $lineNetAmt = (float) ($value->amount_after_sale_tax ?? ($grossAmt + $lineTaxAmt));
                $remarksText = trim(number_format($qty, 4, '.', '') . ' ' . $uomName);

                $grossTotal += $grossAmt;
                $taxTotal += $lineTaxAmt;
                $netTotal += $lineNetAmt;
            @endphp
            <tr>
                <td>{{ $itemName }}</td>
                <td class="center">{{ $uomName }}</td>
                <td class="right">{{ number_format($qty, 4, '.', '') }}</td>
                <td class="right">{{ number_format($rate, 4, '.', '') }}</td>
                <td class="right">{{ number_format($grossAmt, 2) }}</td>
                <td class="center">{{ $lineTaxRate > 0 ? rtrim(rtrim(number_format($lineTaxRate, 2), '0'), '.') . '%' : '' }}</td>
                <td class="right">{{ $lineTaxAmt > 0 ? number_format($lineTaxAmt, 2) : '' }}</td>
                <td class="right">{{ number_format($lineNetAmt, 2) }}</td>
                <td class="center">{{ $remarksText }}</td>
            </tr>
        @endforeach
    </tbody>
</table>

@php
    $cartageAmount = (float) ($sale_quotations->cartage_amount ?? 0);
    $finalNetTotal = $netTotal + $cartageAmount;
    if ($finalNetTotal <= 0 && !empty($sale_quotations->total_amount_after_sale_tax)) {
        $finalNetTotal = (float) $sale_quotations->total_amount_after_sale_tax;
    }
    $amountWords = strtoupper(saleQuotationAmountInWords($finalNetTotal));
@endphp

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

<table class="no-border sq-totals-wrap">
    <tr>
        <td class="sq-amount-words">
            <span class="bold">Amount In Words :</span>
            {{ $amountWords }} Rupees Only.
        </td>
        <td class="sq-totals-block">
            <table>
                <tr>
                    <td class="lbl">Gross Amount :</td>
                    <td class="val">{{ number_format($grossTotal, 2) }}</td>
                </tr>
                <tr>
                    <td class="lbl">Tax Amount :</td>
                    <td class="val">{{ $taxTotal > 0 ? number_format($taxTotal, 2) : '' }}</td>
                </tr>
                <tr>
                    <td class="lbl">Cartage Charges :</td>
                    <td class="val">{{ number_format($cartageAmount, 2) }}</td>
                </tr>
                <tr>
                    <td class="lbl bold">Net Amount :</td>
                    <td class="val bold">{{ number_format($finalNetTotal, 2) }}</td>
                </tr>
            </table>
        </td>
    </tr>
</table>

<hr class="sq-hr">

<div class="sq-company-footer upper">{{ CommonHelper::formatLetterheadCompanyName($letterhead->name ?? '') }}</div>