@php $logoPath = public_path('admin/images/bncmc-logo.png'); $logoSrc = ''; if (file_exists($logoPath)) { $logoData = base64_encode(file_get_contents($logoPath)); $mimeType = mime_content_type($logoPath); $logoSrc = 'data:' . $mimeType . ';base64,' . $logoData; } else { $logoSrc = asset('admin/images/bncmc-logo.png'); } @endphp

Bhiwandi Nizampur City Municipal Corporation भिवंडी निजामपूर शहर महानगरपालिका Water Tax Department / पाणीपुरवठा कर विभाग DEMAND COLLECTION ARREARS REPORT / मागणी संकलन थकबाकी अहवाल

From Date /पासून: {{ \Carbon\Carbon::parse($request->from_date)->format('d-m-Y') }}

To Date /पर्यंत: {{ \Carbon\Carbon::parse($request->to_date)->format('d-m-Y') }}

@php if (!function_exists('indian_format')) { function indian_format($number) { $decimal = round($number - ($no = floor($number)), 2) * 100; $hundred = null; $digits_length = strlen($no); $i = 0; $str = array(); $words = array(0 => '', 1 => '1', 2 => '2', 3 => '3', 4 => '4', 5 => '5', 6 => '6', 7 => '7', 8 => '8', 9 => '9', 10 => '10', 11 => '11', 12 => '12', 13 => '13', 14 => '14', 15 => '15', 16 => '16', 17 => '17', 18 => '18', 19 => '19', 20 => '20', 30 => '30', 40 => '40', 50 => '50', 60 => '60', 70 => '70', 80 => '80', 90 => '90'); $digits = array('', 'Hundred', 'Thousand', 'Lakh', 'Crore'); $num = explode('.', number_format($number, 2, '.', '')); $whole = $num[0]; $decimal = $num[1]; $last3 = substr($whole, -3); $rest = substr($whole, 0, -3); if($rest) { $rest = preg_replace("/\B(?=(\d{2})+(?!\d))/", ",", $rest); return $rest . "," . $last3 . "." . $decimal; } else { return $last3 . "." . $decimal; } } } $totals = [ 'demand_prev' => 0, 'demand_curr' => 0, 'demand_adv' => 0, 'coll_prev' => 0, 'coll_curr' => 0, 'coll_adv' => 0, 'arrears_prev' => 0, 'arrears_curr' => 0, ]; @endphp @foreach ($data as $key => $row) @php $parts = explode('|', $key); foreach ($totals as $k => $v) { $totals[$k] += $row[$k]; } $rowTotalDemand = $row['demand_prev'] + $row['demand_curr']; $rowTotalColl = $row['coll_prev'] + $row['coll_curr']; $perc = $rowTotalDemand > 0 ? ($rowTotalColl / $rowTotalDemand) * 100 : 0; @endphp @endforeach @php $grandDemand = $totals['demand_prev'] + $totals['demand_curr']; $grandColl = $totals['coll_prev'] + $totals['coll_curr']; $grandPerc = $grandDemand > 0 ? ($grandColl / $grandDemand) * 100 : 0; @endphp

WARD / प्रभाग	VIBHAG / विभाग	BLOCK / ब्लॉक	DEMAND / मागणी			COLLECTION / संकलन			ARREARS / थकबाकी		PERC / टक्केवारी
			PREV / मागील	CURR / चालू	ADV / आगाऊ	PREV / मागील	CURR / चालू	ADV / आगाऊ	PREV / मागील	CURR / चालू
{{ $parts[0] }}	{{ $parts[1] }}	{{ $parts[2] }}	{{ indian_format($row['demand_prev']) }}	{{ indian_format($row['demand_curr']) }}	{{ indian_format($row['demand_adv']) }}	{{ indian_format($row['coll_prev']) }}	{{ indian_format($row['coll_curr']) }}	{{ indian_format($row['coll_adv']) }}	{{ indian_format($row['arrears_prev']) }}	{{ indian_format($row['arrears_curr']) }}	{{ number_format($perc, 2) }}%
TOTAL / एकूण			{{ indian_format($totals['demand_prev']) }}	{{ indian_format($totals['demand_curr']) }}	{{ indian_format($totals['demand_adv']) }}	{{ indian_format($totals['coll_prev']) }}	{{ indian_format($totals['coll_curr']) }}	{{ indian_format($totals['coll_adv']) }}	{{ indian_format($totals['arrears_prev']) }}	{{ indian_format($totals['arrears_curr']) }}	{{ number_format($grandPerc, 2) }}%