@php if (!function_exists('numberToWords')) { function numberToWords($number) { $no = floor($number); $point = round($number - $no, 2) * 100; $hundred = null; $digits_1 = strlen($no); $i = 0; $str = []; $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', ]; $digits = ['', 'Hundred', 'Thousand', 'Lakh', 'Crore']; while ($i < $digits_1) { $divider = $i == 2 ? 10 : 100; $number = floor($no % $divider); $no = floor($no / $divider); $i += $divider == 10 ? 1 : 2; if ($number) { $plural = ($counter = count($str)) && $number > 9 ? 's' : null; $hundred = $counter == 1 && $str[0] ? ' and ' : null; $str[] = $number < 21 ? $words[$number] . ' ' . $digits[$counter] . $plural . ' ' . $hundred : $words[floor($number / 10) * 10] . ' ' . $words[$number % 10] . ' ' . $digits[$counter] . $plural . ' ' . $hundred; } else { $str[] = null; } } $str = array_reverse($str); $result = implode('', $str); $points = $point ? '.' . $words[$point / 10] . ' ' . $words[($point = $point % 10)] : ''; return $result . 'Rupees Only'; } } @endphp CFC Generic Report
BNCMC Logo

Bhiwandi Nizampur City Municipal Corporation

CFC Generic Report / सीएफसी सामान्य अहवाल

Prabhag: @php $pIds = $request->prabhag_id; if (is_array($pIds) && in_array('all', $pIds)) { $pIds = null; } if (!empty($pIds)) { if (is_array($pIds)) { echo \App\Models\Prabhag::whereIn('id', $pIds) ->pluck('prabhag_name') ->implode(', '); } else { echo \App\Models\Prabhag::find($pIds)->prabhag_name ?? '-'; } } else { echo 'All'; } @endphp Department: @php $dIds = $request->department_id; if (is_array($dIds) && in_array('all', $dIds)) { $dIds = null; } if (!empty($dIds)) { if (is_array($dIds)) { echo \App\Models\Department::whereIn('id', $dIds) ->pluck('department_name') ->implode(', '); } else { echo \App\Models\Department::find($dIds)->department_name ?? '-'; } } else { echo 'All'; } @endphp Date: {{ $request->from_date ? \Carbon\Carbon::parse($request->from_date)->format('d-m-Y') : 'Start' }} to {{ $request->to_date ? \Carbon\Carbon::parse($request->to_date)->format('d-m-Y') : 'Today' }}
Service: @php $sIds = $request->service_id; if (is_array($sIds) && in_array('all', $sIds)) { $sIds = null; } if (!empty($sIds)) { if (is_array($sIds)) { echo \App\Models\Service::whereIn('id', $sIds) ->pluck('service_name') ->implode(', '); } else { echo \App\Models\Service::find($sIds)->service_name ?? '-'; } } else { echo 'All'; } @endphp Payment Mode: @php $pm = $request->payment_mode; if (is_array($pm) && in_array('all', $pm)) { $pm = null; } if (!empty($pm)) { if (is_array($pm)) { echo implode(', ', $pm); } else { echo $pm; } } else { echo 'All'; } @endphp
@php $gtTotal = 0; @endphp @foreach ($details as $detail) @php $gtTotal += $detail->total_amount; @endphp @endforeach
Sr No/अ. क्र. Receipt No / पावती क्र. Date / तारीख Applicant / आवेदक Dept / विभाग Service / सेवा Budget Code / बजट कोड Acc No / खाता क्र. Amount / रक्म SGST / एसजीएसटी. CGST / सीजीएसटी Total / एकूण Mode / मोड Chq No / चेक क्र. Chq Date / चेक तारीख
{{ $loop->iteration }} {{ $detail->demand->reference_number }} {{ $detail->demand->updated_at->format('d-m-Y') }} {{ $detail->demand->applicant_name }} {{ $detail->department->department_name ?? '-' }} {{ $detail->service->service_name ?? '-' }} {{ $detail->accountNumber->budgetCode->code ?? '-' }} {{ $detail->accountNumber->account_number ?? '-' }} {{ number_format($detail->amount, 2) }} {{ number_format($detail->sgst, 2) }} {{ number_format($detail->cgst, 2) }} {{ number_format($detail->total_amount, 2) }} {{ $detail->demand->payment_mode }} {{ $detail->demand->cheque_dd_number ?? '-' }} {{ $detail->demand->cheque_dd_date ? \Carbon\Carbon::parse($detail->demand->cheque_dd_date)->format('d-m-Y') : '-' }}
Grand Total: {{ number_format($gtTotal, 2) }}
Total Amount in Words: {{ numberToWords($gtTotal) }}
Prepared By
({{ auth()->user()->name ?? 'System' }})
Department Head
(Signature)
Printed On: {{ \Carbon\Carbon::now('Asia/Kolkata')->format('d-m-Y h:i A') }}
Day: {{ \Carbon\Carbon::now('Asia/Kolkata')->format('l') }}