@extends('frontend.vendor_dashboard.dashboard.layouts.app')

@section('content')
    <div class="container-fluid">
        <div class="row">
            <div class="col-12">
                <!-- Print Controls -->
                <div class="card no-print mb-3">
                    <div class="card-body py-2">
                        <div class="d-flex justify-content-end">
                            <button onclick="window.print()" class="btn btn-warning btn-sm btn-icon icon-left mr-2">
                                <i class="fas fa-print"></i> Print
                            </button>
                            <a href="{{ url()->previous() }}" class="btn btn-secondary btn-sm">
                                <i class="fas fa-arrow-left"></i> Back
                            </a>
                        </div>
                    </div>
                </div>

                <!-- Document Container -->
                <div class="card printable-document">
                    <div class="card-body p-4">
                        <div class="document-container">
                            <!-- Header Section -->
                            <div class="document-header mb-3">
                                <div class="row">
                                    <div class="col-md-9">
                                        <div style="font-size: 16px;">
                                            Dispatch no.: {{ $VerRelation->chalani_no ?? '' }}
                                        </div>
                                    </div>
                                    <div class="col-md-3" style="text-align: right;">
                                        <div style="font-size: 16px; font-weight: bold;">
                                            Date: {{ \Carbon\Carbon::parse($VerRelation->date ?? now())->format('d F, Y') }}
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <!-- Title Section -->
                            <div class="title-section mb-3" style="text-align: center;">
                                <h3
                                    style="font-size: 20px; font-weight: bold; margin-bottom: 15px; text-decoration: underline;">
                                    {{ $VerRelation->subject ?? 'Annual Income Verification' }}
                                </h3>
                            </div>

                            <!-- Content Section -->
                            <div class="content-section" style="font-size: 14px; line-height: 1.5; text-align: justify;">
                                <div class="paragraph">
                                    <p style="margin-bottom: 10px;">
                                        <span class="p-4"></span>This is to verify that applicant
                                        <span style="font-weight: bold;">
                                            @if ($VerRelation->gender == 'Male')
                                                Mr.
                                            @elseif ($VerRelation->gender == 'Female' && $VerRelation->marital_status == 'Married')
                                                Mrs.
                                            @else
                                                Ms.
                                            @endif
                                            {{ $VerRelation->applicant_name ?? '' }}
                                        </span>
                                        holder of Nepali Citizenship Certificate No.
                                        {{ $VerRelation->applicant_citizen ?? '' }}
                                        @if ($VerRelation->applicant_id_no != null)
                                            and National ID No. {{ $VerRelation->applicant_id_no }}
                                        @endif
                                        @if ($VerRelation->applicant_passport != null)
                                            and Passport No. {{ $VerRelation->applicant_passport }}
                                        @endif
                                        @if ($VerRelation->gender == 'Male')
                                            grandson
                                        @else
                                            granddaughter
                                        @endif
                                        of Mr. {{ $VerRelation->applicant_grandfather ?? '' }},
                                        @if ($VerRelation->gender == 'Male')
                                            son
                                        @else
                                            daughter
                                        @endif
                                        of Mr. {{ $VerRelation->applicant_father ?? '' }} and
                                        Mrs. {{ $VerRelation->applicant_mother ?? '' }},
                                        permanent resident of
                                        <span style="font-weight: bold;">
                                            ward No.
                                            {{ $VerRelation->ward->name ?? ($VerRelation->previous_ward_no ?? '') }}
                                            @if ($VerRelation->previous_ward_no !== null)
                                                (Previous ward No. {{ $VerRelation->previous_ward_no ?? '' }}),
                                            @else
                                            @endif
                                            {{ $VerRelation->municipality->name ?? '' }},
                                            {{ $VerRelation->district ?? '' }},
                                            {{ $VerRelation->provinance ?? '' }}, Nepal.
                                        </span>
                                        has annual income from various source as below:
                                    </p>

                                    <!-- Relations Table with Proper Sum Calculation -->
                                    @php
                                        // Get currency symbol based on currency code
                                        $currencySymbols = [
                                            'ALL' => 'Lek',
                                            'DZD' => 'دج',
                                            'AOA' => 'Kz',
                                            'ARS' => "$",
                                            'AMD' => '֏',
                                            'AWG' => 'ƒ',
                                            'AUD' => "$",
                                            'AZN' => 'm',
                                            'BSD' => "B$",
                                            'BHD' => '.د.ب',
                                            'BDT' => '৳',
                                            'BBD' => "Bds$",
                                            'BYR' => 'Br',
                                            'BEF' => 'fr',
                                            'BZD' => "$",
                                            'BMD' => "$",
                                            'BTN' => 'Nu.',
                                            'BTC' => '฿',
                                            'BOB' => 'Bs.',
                                            'BAM' => 'KM',
                                            'BWP' => 'P',
                                            'BRL' => "R$",
                                            'GBP' => '£',
                                            'BND' => "B$",
                                            'BGN' => 'Лв.',
                                            'BIF' => 'FBu',
                                            'KHR' => 'KHR',
                                            'CAD' => "$",
                                            'CVE' => "$",
                                            'KYD' => "$",
                                            'XOF' => 'CFA',
                                            'XAF' => 'FCFA',
                                            'XPF' => '₣',
                                            'CLP' => "$",
                                            'CLF' => 'CLF',
                                            'CNY' => '¥',
                                            'COP' => "$",
                                            'KMF' => 'CF',
                                            'CDF' => 'FC',
                                            'CRC' => '₡',
                                            'HRK' => 'kn',
                                            'CUC' => "$, CUC",
                                            'CZK' => 'Kč',
                                            'DKK' => 'Kr.',
                                            'DJF' => 'Fdj',
                                            'DOP' => "$",
                                            'XCD' => "$",
                                            'EGP' => 'ج.م',
                                            'ERN' => 'Nfk',
                                            'EEK' => 'kr',
                                            'ETB' => 'Nkf',
                                            'EUR' => '€',
                                            'FKP' => '£',
                                            'FJD' => "FJ$",
                                            'GMD' => 'D',
                                            'GEL' => 'ლ',
                                            'DEM' => 'DM',
                                            'GHS' => 'GH₵',
                                            'GIP' => '£',
                                            'GRD' => '₯, Δρχ, Δρ',
                                            'GTQ' => 'Q',
                                            'GNF' => 'FG',
                                            'GYD' => "$",
                                            'HTG' => 'G',
                                            'HNL' => 'L',
                                            'HKD' => "$",
                                            'HUF' => 'Ft',
                                            'ISK' => 'kr',
                                            'INR' => '₹',
                                            'IDR' => 'Rp',
                                            'IRR' => '﷼',
                                            'IQD' => 'د.ع',
                                            'ILS' => '₪',
                                            'ITL' => 'L,£',
                                            'JMD' => "J$",
                                            'JPY' => '¥',
                                            'JOD' => 'ا.د',
                                            'KZT' => 'лв',
                                            'KES' => 'KSh',
                                            'KWD' => 'ك.د',
                                            'KGS' => 'лв',
                                            'LAK' => '₭',
                                            'LVL' => 'Ls',
                                            'LBP' => '£',
                                            'LSL' => 'L',
                                            'LRD' => "$",
                                            'LYD' => 'د.ل',
                                            'LTC' => 'Ł',
                                            'LTL' => 'Lt',
                                            'MOP' => "$",
                                            'MKD' => 'ден',
                                            'MGA' => 'Ar',
                                            'MWK' => 'MK',
                                            'MYR' => 'RM',
                                            'MVR' => 'Rf',
                                            'MRO' => 'MRU',
                                            'MUR' => '₨',
                                            'MXN' => "$",
                                            'MDL' => 'L',
                                            'MNT' => '₮',
                                            'MAD' => 'MAD',
                                            'MZM' => 'MT',
                                            'MMK' => 'K',
                                            'NAD' => "$",
                                            'NPR' => '₨',
                                            'ANG' => 'ƒ',
                                            'TWD' => "$",
                                            'NZD' => "$",
                                            'NIO' => "C$",
                                            'NGN' => '₦',
                                            'KPW' => '₩',
                                            'NOK' => 'kr',
                                            'OMR' => '.ع.ر',
                                            'PKR' => '₨',
                                            'PAB' => 'B/.',
                                            'PGK' => 'K',
                                            'PYG' => '₲',
                                            'PEN' => 'S/.',
                                            'PHP' => '₱',
                                            'PLN' => 'zł',
                                            'QAR' => 'ق.ر',
                                            'RON' => 'lei',
                                            'RUB' => '₽',
                                            'RWF' => 'FRw',
                                            'SVC' => '₡',
                                            'WST' => 'SAT',
                                            'STD' => 'Db',
                                            'SAR' => '﷼',
                                            'RSD' => 'din',
                                            'SCR' => 'SRe',
                                            'SLL' => 'Le',
                                            'SGD' => "$",
                                            'SKK' => 'Sk',
                                            'SBD' => "Si$",
                                            'SOS' => 'Sh.so.',
                                            'ZAR' => 'R',
                                            'KRW' => '₩',
                                            'SSP' => '£',
                                            'XDR' => 'SDR',
                                            'LKR' => 'Rs',
                                            'SHP' => '£',
                                            'SDG' => '.س.ج',
                                            'SRD' => "$",
                                            'SZL' => 'E',
                                            'SEK' => 'kr',
                                            'CHF' => 'CHf',
                                            'SYP' => 'LS',
                                            'TJS' => 'SM',
                                            'TZS' => 'TSh',
                                            'THB' => '฿',
                                            'TOP' => "$",
                                            'TTD' => "$",
                                            'TND' => 'ت.د',
                                            'TRY' => '₺',
                                            'TMT' => 'T',
                                            'UGX' => 'USh',
                                            'UAH' => '₴',
                                            'AED' => 'إ.د',
                                            'UYU' => "$",
                                            'USD' => "$",
                                            'UZS' => 'лв',
                                            'VUV' => 'VT',
                                            'VEF' => 'Bs',
                                            'VND' => '₫',
                                            'YER' => '﷼',
                                            'ZMK' => 'ZK',
                                        ];

                                        $currencyCode = $VerRelation->currency_code ?? 'NPR';
                                        $currencySymbol = $currencySymbols[$currencyCode] ?? $currencyCode;

                                        // Decode relations data
                                        $relations = is_string($VerRelation->relations)
                                            ? json_decode($VerRelation->relations, true)
                                            : $VerRelation->relations;

                                        // Calculate total income from all sources
                                        $totalIncome = 0;

                                        // Check if applicant has income field
                                        $applicantIncome = $VerRelation->applicant_income ?? 0;

                                        // Add applicant's income to total
$totalIncome += $applicantIncome;

// Create array to store all income sources for display

// Process family relations
// Process family relations
if (isset($relations) && is_array($relations) && count($relations) > 0) {
    foreach ($relations as $relation) {
        if (
            isset($relation['income_price']) &&
            is_numeric($relation['income_price'])
        ) {
            $incomeAmount = floatval($relation['income_price']);
            $totalIncome += $incomeAmount;

            $allIncomeSources[] = [
                'earned_by' => $relation['relation_name'] ?? '',
                'relation_with_applicant' => $relation['relation'] ?? '',
                'gender' => $relation['gender'] ?? 'Male', // Add this
                'married_status' => $relation['married_status'] ?? null, // Add this
                'source_of_income' =>
                    ($relation['income_source'] ?? '') .
                    ($relation['income_place']
                        ? ' (' . $relation['income_place'] . ')'
                        : ''),
                'annual_income' => $incomeAmount,
                'remarks' => $relation['income_remark'] ?? '',
            ];
        }
    }
}

// Calculate total in foreign currency if applicable
$totalInForeignCurrency = 0;
$exchangeRate = 0;
if (
    isset($VerRelation->currency_code) &&
    $VerRelation->currency_code != 'NPR' &&
    isset($VerRelation->currency_rupee) &&
    $VerRelation->currency_rupee > 0
) {
    $exchangeRate = $VerRelation->currency_rupee;
    $totalInForeignCurrency = $totalIncome / $exchangeRate;
}

// Function to convert number to words in Millions (International System)
function convertNumberToWords($number)
{
    if ($number == 0) {
        return 'Zero';
    }

    $words = [
        0 => '',
        1 => 'One',
        2 => 'Two',
        3 => 'Three',
        4 => 'Four',
        5 => 'Five',
        6 => 'Six',
        7 => 'Seven',
        8 => 'Eight',
        9 => 'Nine',
        10 => 'Ten',
        11 => 'Eleven',
        12 => 'Twelve',
        13 => 'Thirteen',
        14 => 'Fourteen',
        15 => 'Fifteen',
        16 => 'Sixteen',
        17 => 'Seventeen',
        18 => 'Eighteen',
        19 => 'Nineteen',
        20 => 'Twenty',
        30 => 'Thirty',
        40 => 'Forty',
        50 => 'Fifty',
        60 => 'Sixty',
        70 => 'Seventy',
        80 => 'Eighty',
        90 => 'Ninety',
    ];

    $number = round($number, 2);
    $dollars = floor($number);
    $cents = round(($number - $dollars) * 100);

    $dollarsInWords = '';

    // Billions
    if ($dollars >= 1000000000) {
        $billions = floor($dollars / 1000000000);
        $dollarsInWords .= convertNumberToWords($billions) . ' Billion ';
        $dollars %= 1000000000;
    }

    // Millions
    if ($dollars >= 1000000) {
        $millions = floor($dollars / 1000000);
        $dollarsInWords .= convertNumberToWords($millions) . ' Million ';
        $dollars %= 1000000;
    }

    // Thousands
    if ($dollars >= 1000) {
        $thousands = floor($dollars / 1000);
        $dollarsInWords .= convertNumberToWords($thousands) . ' Thousand ';
        $dollars %= 1000;
    }

    // Hundreds
    if ($dollars >= 100) {
        $hundreds = floor($dollars / 100);
        $dollarsInWords .= $words[$hundreds] . ' Hundred ';
        $dollars %= 100;
    }

    // Tens and Units
    if ($dollars > 0) {
        if ($dollars <= 20) {
            $dollarsInWords .= $words[$dollars] . ' ';
        } else {
            $tens = floor($dollars / 10) * 10;
            $units = $dollars % 10;
            $dollarsInWords .=
                $words[$tens] . ($units ? ' ' . $words[$units] : '') . ' ';
        }
    }

    $result = trim($dollarsInWords);
    $result = $result ? $result : 'Zero';

    if ($cents > 0) {
        if ($cents <= 20) {
            $result .= ' and ' . $words[$cents] . ' Paise';
        } else {
            $tens = floor($cents / 10) * 10;
            $units = $cents % 10;
            $result .=
                ' and ' .
                $words[$tens] .
                ($units ? ' ' . $words[$units] : '') .
                ' Paise';
        }
    }

    return $result;
}

$totalIncomeInWords = convertNumberToWords($totalIncome);
$totalForeignInWords =
    $totalInForeignCurrency > 0
        ? convertNumberToWords($totalInForeignCurrency)
        : '';
                                    @endphp

                                    <div class="card-body p-0 mt-3">
                                        <table class="table table-bordered card-table" style="font-size: 12px;">
                                            <thead class="thead-light">
                                                <tr style="background-color: #f8f9fa;">
                                                    <th style="width: 5%; padding: 6px;">S.N</th>
                                                    <th style="width: 25%; padding: 6px;">Earned By</th>
                                                    <th style="width: 15%; padding: 6px;">Relation</th>
                                                    <th style="width: 30%; padding: 6px;">Source of Income</th>
                                                    <th style="width: 15%; padding: 6px;">Income (NRs.)</th>
                                                    <th style="width: 10%; padding: 6px;">Remarks</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach ($allIncomeSources as $index => $source)
                                                    <tr>
                                                        <td class="text-center" style="padding: 5px;">{{ $index + 1 }}
                                                        </td>
                                                        <td style="padding: 5px;">
                                                            {{ getTitle($source['gender'] ?? 'Male', $source['married_status'] ?? null) }}
                                                            {{ $source['earned_by'] ?? '' }}
                                                        </td>

                                                        <td style="padding: 5px;">{{ $source['relation_with_applicant'] }}
                                                        </td>
                                                        <td style="padding: 5px;">{{ $source['source_of_income'] }}</td>
                                                        <td class="text-right" style="padding: 5px;">
                                                            {{ $source['annual_income'] > 0 ? number_format($source['annual_income'], 2) : '-' }}
                                                        </td>
                                                        <td style="padding: 5px;">{{ $source['remarks'] }}</td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                            <tfoot>
                                                <tr style="background-color: #f8f9fa; font-weight: bold;">
                                                    <td class="text-center" colspan="4" style="padding: 6px;">
                                                        <strong>TOTAL</strong>
                                                    </td>
                                                    <td class="text-right" style="padding: 6px;">
                                                        <strong>{{ number_format($totalIncome, 2) }}</strong>
                                                    </td>
                                                    <td style="padding: 6px;"></td>
                                                </tr>
                                                <tr style="background-color: #f8f9fa; font-weight: bold;">
                                                    <td class="text-center" colspan="4" style="padding: 6px;">
                                                        <strong>TOTAL in {{ $VerRelation->currency_code }}</strong>
                                                    </td>
                                                    <td class="text-right" style="padding: 6px;">
                                                        <strong>{{ $currencySymbol }}
                                                            {{ number_format($totalInForeignCurrency, 2) }}</strong>
                                                    </td>
                                                    <td style="padding: 6px;"></td>
                                                </tr>
                                            </tfoot>
                                        </table>
                                    </div>

                                    <div style="margin-top: 15px;">
                                        <p style="margin-bottom: 8px; font-size: 13px; line-height: 1.6;">
                                            <strong>Total Annual Income in Words:</strong>
                                            <span
                                                style="text-transform: capitalize; font-weight: normal;">{{ $totalIncomeInWords }}
                                                Rupees Only</span>
                                        </p>
                                        @if ($VerRelation->currency_code && $VerRelation->currency_rupee == null)
                                        @else
                                            @if (isset($VerRelation->currency_code) && $VerRelation->currency_code != 'NPR')
                                                <p style="margin-bottom: 8px; font-size: 13px; line-height: 1.6;">
                                                    <strong>Equivalent Total Annual Income in {{ $currencyCode }}
                                                        ({{ $currencySymbol }}):</strong>
                                                    <span style="font-weight: normal;">{{ $currencySymbol }}
                                                        {{ number_format($totalInForeignCurrency, 2) }}</span>

                                                </p>
                                                <p style="margin-bottom: 5px; font-size: 12px;">
                                                    Exchange Rate (Selling Rate) as per Nepal Rastra Bank on
                                                    {{ \Carbon\Carbon::parse($VerRelation->date ?? now())->format('d F, Y') }}:<br>
                                                    1 {{ $currencyCode }} = Rs. {{ number_format($exchangeRate, 2) }}
                                                </p>
                                            @endif
                                        @endif

                                        <p style="font-size: 12px; margin-top: 12px; font-style: italic;">
                                            This letter is hereby issued in accordance with the Section 12 of the Local
                                            Government Operation Act, 2074 BS (2017 AD).
                                        </p>
                                    </div>

                                    <!-- Signature Section - Right Corner -->
                                    <div style="float: right; width: 45%; text-align: right; margin-top: 5px;">
                                        <div style="height: 40px;"></div>
                                        <div style="font-size: 14px; font-weight: bold; margin-bottom: 2px;">
                                            {{ $Wardchairman->name ?? '' }}
                                        </div>
                                        <div style="font-size: 11px; margin-bottom: 2px;">
                                            {{ $Wardchairman->position ?? 'Ward Chairman' }}
                                        </div>
                                        <div style="font-size: 11px;">
                                            {{ $Wardchairman->municipality->name ?? 'Bhaktapur Municipality' }},
                                            Ward {{ $Wardchairman->ward->name ?? '2' }}
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <style>
        /* Print Styles - EXACT MARGINS: 2.5" top, 1" left, 0.5" right */
        @media print {

            /* Reset all margins and padding */
            * {
                margin: 0;
                padding: 0;
                box-sizing: border-box;
            }

            body,
            html {
                margin: 0 !important;
                padding: 0 !important;
                width: 100%;
                background: white;
            }

            /* Hide print controls */
            .no-print,
            .no-print * {
                display: none !important;
            }

            /* Show only document */
            body * {
                visibility: hidden;
            }

            .printable-document,
            .printable-document * {
                visibility: visible;
            }

            .printable-document {
                position: absolute;
                top: 0;
                left: 0;
                width: 100%;
                margin: 0 !important;
                padding: 0 !important;
                border: none !important;
                box-shadow: none !important;
                background: white;
                /* Remove the margin-top from here */
            }

            /* Set EXACT margins: 2.5" top, 1" left, 0.5" right */
            @page {
                size: A4;
                margin: 2.2in 0.5in 0in 0.5in !important;
                /* top: 2.5in, right: 0.5in, bottom: 0in, left: 1in */
            }

            /* Add top margin to content for better positioning */
            .document-container {
                padding-top: 0;
                margin-top: 0;
            }

            /* Compact card body */
            .card-body.p-4 {
                padding: 0 !important;
                margin: 0 !important;
            }

            /* Reduce spacing between elements to fit content */
            .mb-1,
            .mt-1 {
                margin-bottom: 1mm !important;
                margin-top: 1mm !important;
            }

            .mb-2,
            .mt-2 {
                margin-bottom: 2mm !important;
                margin-top: 2mm !important;
            }

            /* Font sizes optimized for print */
            .document-header div {
                font-size: 10pt !important;
            }

            .title-section h3 {
                font-size: 12pt !important;
                margin: 1mm 0 !important;
            }

            .content-section {
                font-size: 9.5pt !important;
                line-height: 1.25 !important;
            }

            .table {
                font-size: 8.5pt !important;
            }

            .table th,
            .table td {
                padding: 1.5mm !important;
            }

            .relation-info {
                font-size: 7.5pt !important;
            }

            .passport-photo-frame {
                width: 22mm !important;
                height: 30mm !important;
            }

            .photo-col {
                flex: 0 0 20% !important;
                max-width: 20% !important;
                padding: 0 0.5mm !important;
            }

            /* Prevent page breaks inside elements */
            .photo-section,
            .table,
            .signature-section,
            .documents-section,
            .passport-photo-box,
            .content-section {
                page-break-inside: avoid;
                break-inside: avoid;
            }

            /* Ensure table doesn't break */
            table {
                page-break-inside: avoid;
                break-inside: avoid;
            }

            /* Remove any background colors for clean print */
            .table th {
                background-color: #f5f5f5 !important;
                -webkit-print-color-adjust: exact;
                print-color-adjust: exact;
            }

            .passport-photo-frame {
                border: 0.5pt solid #000 !important;
            }
        }

        /* Screen styles with minimum margins */
        .container-fluid {
            padding: 0 5px;
        }

        .photo-col {
            flex: 0 0 20%;
            max-width: 20%;
            text-align: center;
            padding: 0 1px;
        }

        #photo-container {
            display: flex;
            flex-wrap: wrap;
            align-items: center;
        }

        .passport-photo-frame {
            width: 60px;
            height: 80px;
            margin: 0 auto;
            border: 1px solid #ddd;
            background: #fff;
            display: flex;
            align-items: center;
            justify-content: center;
        }

        .table-sm th,
        .table-sm td {
            padding: 4px;
            font-size: 12px;
        }

        .card-body.p-4 {
            padding: 10px !important;
        }

        @media (max-width: 768px) {
            .photo-col {
                flex: 0 0 50%;
                max-width: 50%;
                margin-bottom: 5px;
            }

            .passport-photo-frame {
                width: 80px;
                height: 100px;
            }

            .relation-info {
                font-size: 10px;
            }
        }
    </style>

@endsection