$wardNo, 'male_count' => 0, 'female_count' => 0, 'total_count' => 0]; } if ($gender === 'M') { $rows[$wardNo]['male_count']++; } elseif ($gender === 'F') { $rows[$wardNo]['female_count']++; } $rows[$wardNo]['total_count']++; } fclose($handle); } } ksort($rows); $assemblyList = array_keys($assemblies); sort($assemblyList); // --- EXCEL DOWNLOAD HANDLER --- if ($action === 'export_excel') { $currentTimestamp = date('d M Y H:i:s'); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="BJYS_Registered_Users_Filtered.xls"'); header('Cache-Control: max-age=0'); echo "Bharat Jodo Yuva Sangh - Live Portal Export (bjys.karnataka.gov.in)\t\t\t\t\t\n"; echo "District: {$districtFilter}\tAssembly: {$assemblyFilter}\tWard: All Wards\tGenerated As On: {$currentTimestamp}\t\n"; echo "Sl No\tZonal No\tWard Name (Col G)\tMale (M) (Col Q)\tFemale (F) (Col Q)\tTotal Enrollment\tStatus\n"; $sl = 1; foreach ($rows as $r) { $total = $r['male_count'] + $r['female_count']; $zonal = ceil($r['ward_no'] / 7); echo "{$sl}\t{$zonal}\tWard No. {$r['ward_no']}\t{$r['male_count']}\t{$r['female_count']}\t{$total}\tActive\n"; $sl++; } exit; } ?> BJYS Portal - Real-Time Dashboard (bjys.karnataka.gov.in)

Live Portal Filter Panel

Total Wards Active
Male (M) Enrolled (Col Q)
Female (F) Enrolled (Col Q)
Live Ward Enrollment Breakdown
Download Filtered Excel (.XLS) View Official PDF Report
Sl No Zonal No Ward Name (Col G) Male (M) (Col Q) Female (F) (Col Q) Total Enrollment
No records found for the selected filters.
Ward No.
Grand Total: