@extends('frontend.vendor_dashboard.dashboard.layouts.app') @section('content')
This is to certify that @if ($VerRelation->gender == 'Male') Mr. @elseif ($VerRelation->gender == 'Female' && $VerRelation->marital_status == 'Married') Mrs. @else Ms. @endif {{ $VerRelation->applicant_name ?? '' }} grandson of Mr. {{ $VerRelation->applicant_grandfather ?? '' }}, son of Mr. {{ $VerRelation->applicant_father ?? '' }} and Mrs. {{ $VerRelation->applicant_mother ?? '' }}, holder of Nepali Citizenship Certificate No. {{ $VerRelation->applicant_citizen ?? '' }} @if ($VerRelation->applicant_id_no) and National ID No. {{ $VerRelation->applicant_id_no }} @endif @if ($VerRelation->applicant_passport) and Passport No. {{ $VerRelation->applicant_passport }} @endif is the permanent resident of {{ $VerRelation->municipality->name ?? '' }} Municipality Ward No. {{ $VerRelation->ward->name ?? ($VerRelation->previous_ward_no ?? '') }} @if ($VerRelation->previous_ward_no) (Previous ward No. {{ $VerRelation->previous_ward_no }}), @endif {{ $VerRelation->district ?? '' }}, {{ $VerRelation->provinance ?? '' }}, Nepal. This is to certify that the following agricultural properties are exempted from agricultural tax. They have paid all kind of payable tax and dues in this municipality office and in my observation there is no any pending due taxes till date.
@php // Decode relations data from JSON $relations = is_string($VerRelation->relations) ? json_decode($VerRelation->relations, true) : $VerRelation->relations; // Calculate total income $totalIncome = 0; if (is_array($relations)) { foreach ($relations as $relation) { if (isset($relation['income_price']) && is_numeric($relation['income_price'])) { $totalIncome += floatval($relation['income_price']); } } } @endphp @if(is_array($relations) && count($relations) > 0)| S.N | Municipality | Ward No. | Plot No. | Cultivate Area | Agricultural Products | Amount (NRS.) |
|---|---|---|---|---|---|---|
| {{ $index + 1 }} | {{ $VerRelation->municipality->name ?? 'Bhaktapur Municipality' }} | {{ $relation['ward_no'] }} | {{ $relation['plot_no'] ?? '-' }} | {{ $relation['area'] ?? '-' }} | {{ $relation['agriculture_product'] ?? '-' }} | {{ number_format(floatval($relation['income_price'] ?? 0), 2) }}/- |
| TOTAL | {{ number_format($totalIncome, 2) }}/- | |||||
This letter is hereby issued in accordance with the Section 12 of the Local Government Operation Act, 2074 BS (2017 AD).