Standardizing Database Records";
echo "Environment: " . (ENVIRONMENT) . "
";
$db = DB();
try {
$students = $db->fetchAll("SELECT id, roll_number, full_name FROM students");
$updatedCount = 0;
echo "";
foreach ($students as $s) {
$oldRoll = $s['roll_number'];
// 1. Remove non-numeric characters (like R-)
$newRoll = preg_replace('/[^0-9]/', '', $oldRoll);
// 2. Pad to 10 digits
if (!empty($newRoll)) {
$newRoll = str_pad($newRoll, 10, '0', STR_PAD_LEFT);
} else {
// If it was empty or just text, we might need a fallback, but usually we just keep it or skip
continue;
}
if ($oldRoll !== $newRoll) {
$db->update('students', ['roll_number' => $newRoll], ['id' => $s['id']]);
echo "✅ Updated {$s['full_name']}: $oldRoll → $newRoll
";
$updatedCount++;
}
}
echo "
";
echo "Update Complete! Standardized $updatedCount records.
";
// --- TESTING DATA SETUP ---
echo "Setting up test data...
";
// 1. Ensure Vijay Kumar (0026448251) has Paid status and an Admit Card
$db->query("UPDATE students SET payment_status = 'paid' WHERE roll_number = '0026448251'");
$vijay = $db->fetchOne("SELECT id FROM students WHERE roll_number = '0026448251'");
if ($vijay) {
$db->query("INSERT IGNORE INTO admit_cards (student_id, admit_card_number, exam_session, exam_type, exam_centre, generated_at)
VALUES (?, 'AC0026448251', '2023-24', 'annual', 'IBVTE MAIN CAMPUS', NOW())", [$vijay['id']]);
echo "✅ Setup Vijay Kumar (Admit Card & Paid Status)
";
}
// --------------------------
// Security: Only delete if not on localhost
if (!$isLocalhost) {
echo "Deleting this script for security...
";
unlink(__FILE__);
}
} catch (Exception $e) {
echo "Error: " . $e->getMessage() . "
";
}
?>