{{-- QR CODE & DATE SECTION --}}

{{-- Empty left column --}}

Date: {{ now()->format('d-M-Y') }} {{-- Fixed QR Code - using PNG/SVG instead of EPS --}}

{{-- TOP DETAIL TABLE --}}

Gold Loan A/c No	{{ $customer->gold_loan_account_no ?? 'N/A' }}
Ledger Folio No	{{ $customer->ledger_folio_no ?? 'N/A' }}
Name and address of first appraiser	{{ $admin->name ?? 'Appraiser Name' }}
Date of Appraiser's Certificate	{{ $customer->second_appraisal_date ? \Carbon\Carbon::parse($customer->second_appraisal_date)->format('d/m/Y') : 'N/A' }}

{{-- BANK ADDRESS BLOCK --}} @php $rawBank = strtolower($customer->bank->bank ?? ''); $bankList = [ 'sbi' => 'State Bank of India', 'bob' => 'Bank of Baroda', 'pnb' => 'Punjab National Bank', 'boi' => 'Bank of India', 'hdfc' => 'HDFC Bank', 'icici' => 'ICICI Bank', 'canara' => 'Canara Bank', 'union' => 'Union Bank of India', 'idbi' => 'IDBI Bank', 'cbi' => 'Central Bank of India', 'iob' => 'Indian Overseas Bank', 'uboi' => 'Union Bank of India', ]; $bankName = $bankList[$rawBank] ?? ucwords($customer->bank->bank ?? 'Bank Name'); $branchAddress = $customer->branch->branch_address ?? 'Branch Address'; $branchCode = $customer->branch->branch_code ?? 'N/A'; $appraisalDate = $customer->second_appraisal_date ? \Carbon\Carbon::parse($customer->second_appraisal_date)->format('d/m/Y') : 'N/A'; @endphp

The Branch Manager,
{{ $bankName }}
{{ $branchAddress }} (Branch Code: {{ $branchCode }})

Madam Dear Sir,

{{-- CERTIFICATE BODY TEXT --}}

I hereby certify that the ornaments/Coins of the above mentioned gold loan account have been weighed and appraised by me on {{ $admin->name ?? 'Appraiser Name' }} in the presence of Sri/Smt. {{ $customer->cash_incharge ?? 'Cash Officer' }} (Cash in charge) and Sri/Smt. {{ $customer->joint_custody_officer ?? 'Joint Officer' }} (Joint Custody Officer) The exact weight, purity of the metal and market value of each item as on date are indicated below:

{{-- GOLD ITEMS TABLE --}} @php $i = 1; $gross = $precious = $net = $total = 0; @endphp @forelse($items as $item) @php $marketValue = ($item->net_weight ?? 0) * ($item->rate_per_gram ?? 0); $itemStoneWeight = $item->stone_weight ?? 0; $itemNetWeight = $item->net_weight ?? 0; @endphp @php $gross += $item->gross_weight ?? 0; $precious += $itemStoneWeight; $net += $itemNetWeight; $total += $marketValue; @endphp @empty @for ($j = 1; $j <= 6; $j++) @endfor @php $i = 7; @endphp @endforelse @for ($j = $i; $j <= 6; $j++) @endfor {{-- TOTAL ROW --}}

S No	Description of the Article/Unit	Gross Weight	Approximate weight of the precious stones in the ornaments (Grams)	Purity (Carat)	Net Weight (Grams)	Market Value Rs
{{ $i++ }}	{{ $item->description }}	{{ number_format($item->gross_weight ?? 0, 3) }}	{{ number_format($itemStoneWeight, 3) }}	{{ $item->purity ?? '' }}	{{ number_format($itemNetWeight, 3) }}	{{ number_format($item->rate_per_gram, 2) }}
{{ $j }}
{{ $j }}
Total({{ $i - 1 }})		{{ number_format($gross, 3) }}	{{ number_format($precious, 3) }}		{{ number_format($net, 3) }}	{{ number_format($total, 2) }}

Method(s)* used for purity testing: _______________________________________

I solemnly declare that weight & purity of the gold ornaments/precious stones indicated above are correct and I undertake to indemnify the Bank against any loss it may sustain on account of any inaccuracy in appraisal.

{{-- SIGNATURE SECTION --}}

Yours faithfully

Name & Signature of the Appraiser     Joint Custody Officer   

Name

Cash Officer in Charge Name