@foreach ($data as $ward) @php $totalBits = $ward->constructionForms->where('created_at', '>=', $middleDate)->count(); $inspectedBit = $ward->constructionForms->where('created_at', '>=', $middleDate)->sum('inspector_bits_count'); $hasKalam = $ward->constructionForms->where('created_at', '>=', $middleDate)->sum('bit_kalams_count'); $nikali = $ward->constructionForms->where('created_at', '>=', $middleDate)->sum('nikali_count'); $pendingInspection = $totalBits - $inspectedBit; $pendingForKalam = $inspectedBit - $hasKalam; $lasttotalBits = $ward->constructionForms->where('created_at', '<=', $middleDate)->count(); $lastinspectedBit = $ward->constructionForms->where('created_at', '<=', $middleDate)->sum('inspector_bits_count'); $lasthasKalam = $ward->constructionForms->where('created_at', '<=', $middleDate)->sum('bit_kalams_count'); $lastnikali = $ward->constructionForms->where('created_at', '<=', $middleDate)->sum('nikali_count'); $lastpendingInspection = $lasttotalBits - $lastinspectedBit; $lastpendingForKalam = $lastinspectedBit - $lasthasKalam; @endphp @endforeach

		सध्याचा महिना ( {{ Carbon\Carbon::createFromFormat('Y-m', $year.'-'.$month)->format('M-Y') }} )						गेल्या महिन्यात ( {{ Carbon\Carbon::createFromFormat('Y-m', $year.'-'.$month)->subMonth()->format('M-Y') }} )
अ. क्र.	प्रभागाचे नाव	बीट नोंदणी	बीट निरीक्षण	प्रलंबित निरीक्षण	बीट कार्यवाही	प्रलंबित कार्यवाही	निकाली	बीट नोंदणी	बीट निरीक्षण	प्रलंबित निरीक्षण	बीट कार्यवाही	प्रलंबित कार्यवाही	निकाली
{{ $loop->iteration }}	{{ $ward->name }}	{{ $totalBits }}	{{ $inspectedBit }}	{{ $pendingInspection }}	{{ $hasKalam }}	{{ $pendingForKalam }}	{{ $nikali }}	{{ $lasttotalBits }}	{{ $lastinspectedBit }}	{{ $lastpendingInspection }}	{{ $lasthasKalam }}	{{ $lastpendingForKalam }}	{{ $lastnikali }}