File Manager

✏️ Edit File: /home/coemyoza/applyamnesty.coeminna.edu.ng/reports.php

<?php
session_start();

$DB_HOST = 'localhost';
$DB_NAME = 'sanda_coemx';
$DB_USER = 'root';
$DB_PASS = '';

try {
    $pdo = new PDO("mysql:host=$DB_HOST;dbname=$DB_NAME;charset=utf8mb4", $DB_USER, $DB_PASS, [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    ]);
} catch (Exception $e) {
    die('Database connection failed: ' . htmlspecialchars($e->getMessage()));
}

if (!isset($_SESSION['admin'])) {
    $_SESSION['admin'] = ['full_name'=>'Admin User','role'=>'editor'];
}

// Get current session & semester from settings
$settings = $pdo->query("SELECT * FROM settings LIMIT 1")->fetch(PDO::FETCH_ASSOC);
$current_session = $settings['current_session'] ?? '';
$current_semester = $settings['current_semester'] ?? '';

// Optional filter for status
$where = [];
$params = [];

if (!empty($_GET['status'])) {
    $where[] = "status = :status";
    $params[':status'] = $_GET['status'];
}

// SQL query for students
$sql = "SELECT * FROM students";
if ($where) {
    $sql .= " WHERE " . implode(" AND ", $where);
}
$sql .= " ORDER BY full_name ASC";

$stmt = $pdo->prepare($sql);
$stmt->execute($params);
$students = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Reports - Admin Dashboard</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css">
<style>
body {font-family:'Segoe UI',sans-serif; background:#f4f6f9; margin:0; padding:0;}
header {background:#006400; color:white; padding:15px 20px; display:flex; align-items:center; gap:15px;}
header img {height:50px;}
header h1 {margin:0; font-size:22px;}
.container {margin:20px 30px;}
form {margin-bottom:20px;}
select,button {padding:8px 12px; margin-right:10px; border-radius:5px; border:1px solid #ccc;}
button {background:#006400; color:white; border:none; cursor:pointer;}
button:hover {background:#004d00;}
table {width:100%; border-collapse:collapse; background:white;}
th,td {border:1px solid #ccc; padding:10px; text-align:left;}
th {background:#006400; color:white;}
footer {margin-top:30px; background:#2c3e50; color:#ecf0f1; text-align:center; padding:15px; border-radius:8px;}
</style>
</head>
<body>

<header>
    <img src="logo.png" alt="College Logo">
    <h1>Dr. Umaru Sanda Ahmadu College of Education - Reports</h1>
</header>

<div class="container">
    
    <form method="get">
        <label>Session:
            <select name="session">
                <option value="<?= htmlspecialchars($current_session) ?>" selected><?= htmlspecialchars($current_session) ?></option>
            </select>
        </label>
        <label>Semester:
            <select name="semester">
                <option value="<?= htmlspecialchars($current_semester) ?>" selected><?= htmlspecialchars($current_semester) ?></option>
            </select>
        </label>
        <label>Status:
            <select name="status">
                <option value="">All</option>
                <option value="Paid" <?= (isset($_GET['status']) && $_GET['status']=='Paid')?'selected':'' ?>>Paid</option>
                <option value="Pending" <?= (isset($_GET['status']) && $_GET['status']=='Pending')?'selected':'' ?>>Pending</option>
            </select>
        </label>
        <button type="submit"><i class="fas fa-filter"></i> Filter</button>
        <button type="button" onclick="printTable()"><i class="fas fa-print"></i> Print</button>
        <button type="button" onclick="exportCSV()"><i class="fas fa-file-csv"></i> CSV</button>
        <button type="button" onclick="exportPDF()"><i class="fas fa-file-pdf"></i> PDF</button>
    </form>

<table id="reportTable">
        <thead>
            <tr>
                <th>#</th>
                <th>Full Name</th>
                <th>Matric No</th>
                <th>Session</th>
                <th>Semester</th>
                <th>Status</th>
            </tr>
        </thead>
        <tbody>
        <?php foreach($students as $i=>$s): ?>
            <tr>
                <td><?= $i+1 ?></td>
                <td><?= htmlspecialchars($s['full_name'] ?? '') ?></td>
                <td><?= htmlspecialchars($s['matric_no'] ?? '') ?></td>
                <td><?= htmlspecialchars($current_session) ?></td>
                <td><?= htmlspecialchars($current_semester) ?></td>
                <td><?= htmlspecialchars($s['status'] ?? '') ?></td>
            </tr>
        <?php endforeach; ?>
        </tbody>
    </table>
</div>

<footer>
    &copy; <?= date("Y") ?> Dr. Umaru Sanda Ahmadu College of Education, Minna. All Rights Reserved.
</footer>

// Export CSV
function exportCSV(){
    let rows = document.querySelectorAll("#reportTable tr");
    let csv = [];
    rows.forEach(row => {
        let cols = row.querySelectorAll("th,td");
        let rowData = [];
        cols.forEach(col => rowData.push('"' + col.innerText.replace(/"/g,'""') + '"'));
        csv.push(rowData.join(","));
    });
    let csvFile = new Blob([csv.join("\n")], {type:"text/csv"});
    let downloadLink = document.createElement("a");
    downloadLink.download = "report.csv";
    downloadLink.href = window.URL.createObjectURL(csvFile);
    downloadLink.style.display = "none";
    document.body.appendChild(downloadLink);
    downloadLink.click();
    document.body.removeChild(downloadLink);
}

// Export PDF using jsPDF
function exportPDF(){
    const { jsPDF } = window.jspdf;
    const doc = new jsPDF();
    let rows = [];
    document.querySelectorAll("#reportTable tbody tr").forEach(tr => {
        let row = [];
        tr.querySelectorAll("td").forEach(td => row.push(td.innerText));
        rows.push(row);
    });
    doc.autoTable({
        head: [['#','Full Name','Matric No','Session','Semester','Status']],
        body: rows,
    });
    doc.save("report.pdf");
}
</script>

</body>
</html>

Batal

⬅ Naik ke coemyoza 158 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁.well-known	dir	—	2025-11-12 23:03	📂 Buka
📁cgi-bin	dir	—	2025-11-12 23:03	📂 Buka
📁dompdf	dir	—	2025-11-13 01:55	📂 Buka
📁images	dir	—	2025-11-30 21:14	📂 Buka
📁phpqrcode	dir	—	2025-11-13 01:55	📂 Buka
📁qr	dir	—	2025-11-18 15:44	📂 Buka
📁qrcodes	dir	—	2025-11-13 01:59	📂 Buka
📁student	dir	—	2025-12-01 09:13	📂 Buka
📁uploads	dir	—	2026-04-21 11:40	📂 Buka
📁vendor	dir	—	2025-11-13 01:55	📂 Buka
📄.htaccess	htaccess	42 B	2026-01-13 23:23	✏️ Edit 👁️ View
🐘20102012_amnesty_report.php	php	6.6 KB	2026-01-25 18:32	✏️ Edit 👁️ View
🌐Untitled12.html	html	9.3 KB	2025-10-23 12:33	✏️ Edit 👁️ View
🐘admin_carryover_list.php	php	5.9 KB	2025-10-29 02:05	✏️ Edit 👁️ View
🐘admin_courses.php	php	5.3 KB	2025-09-11 05:11	✏️ Edit 👁️ View
🐘admin_dashboard.php	php	9 KB	2025-10-23 11:22	✏️ Edit 👁️ View
🐘admin_drop_requests.php	php	2.6 KB	2025-11-30 16:09	✏️ Edit 👁️ View
🐘admin_forgot.php	php	2.5 KB	2025-09-28 20:19	✏️ Edit 👁️ View
🐘admin_login.php	php	3 KB	2025-11-21 14:38	✏️ Edit 👁️ View
📄admin_login.php.bak	bak	11.7 KB	2025-09-28 21:55	✏️ Edit 👁️ View
🐘admin_module - to Bank.php	php	8.9 KB	2025-09-28 14:52	✏️ Edit 👁️ View
🐘admin_module.php	php	17.9 KB	2025-11-21 14:50	✏️ Edit 👁️ View
🐘admin_payment_report.php	php	984 B	2026-01-11 17:27	✏️ Edit 👁️ View
🐘admin_signup.php	php	3.4 KB	2025-09-28 20:13	✏️ Edit 👁️ View
🐘amnesty_application_form.php	php	19.7 KB	2026-01-22 13:03	✏️ Edit 👁️ View
🐘amnesty_application_print.php	php	7.1 KB	2026-01-12 06:29	✏️ Edit 👁️ View
🐘amnesty_application_success.php	php	4.1 KB	2026-01-11 15:07	✏️ Edit 👁️ View
🐘amnesty_confirmation.php	php	4.1 KB	2025-11-12 23:47	✏️ Edit 👁️ View
🐘amnesty_index.php	php	3.7 KB	2026-01-25 09:49	✏️ Edit 👁️ View
🐘amnesty_matric_check.php	php	8.2 KB	2026-01-12 19:05	✏️ Edit 👁️ View
🐘amnesty_payment_report.php	php	4.2 KB	2026-01-25 12:07	✏️ Edit 👁️ View
🐘amnesty_reprint_login.php	php	1.4 KB	2025-12-04 10:33	✏️ Edit 👁️ View
🐘amnesty_slip.php	php	6.9 KB	2025-12-18 05:56	✏️ Edit 👁️ View
🐘amnesty_slip_reprint.php	php	3.7 KB	2025-12-04 10:07	✏️ Edit 👁️ View
🐘application_payment_confirmation.php	php	6.4 KB	2026-01-25 12:14	✏️ Edit 👁️ View
🐘application_receipt.php	php	8.6 KB	2026-01-26 12:33	✏️ Edit 👁️ View
🐘apply_amnesty.php	php	6.1 KB	2025-10-25 16:05	✏️ Edit 👁️ View
🐘bank_carryover_module.php	php	16.5 KB	2025-11-13 00:08	✏️ Edit 👁️ View
🐘bank_carryover_modules.php	php	13.3 KB	2025-10-30 17:40	✏️ Edit 👁️ View
🐘bank_combined_report.php	php	7.9 KB	2026-01-25 17:57	✏️ Edit 👁️ View
🐘bank_confirm.php	php	5.3 KB	2025-09-11 22:09	✏️ Edit 👁️ View
🐘bank_connect.php	php	628 B	2025-10-26 02:21	✏️ Edit 👁️ View
🐘bank_dashboard.php	php	40.1 KB	2025-10-31 04:30	✏️ Edit 👁️ View
🐘bank_export_transactions.php	php	3 KB	2026-04-09 06:00	✏️ Edit 👁️ View
📄bank_login.php.bak	bak	8.8 KB	2025-09-11 03:47	✏️ Edit 👁️ View
🐘bank_module.php	php	22.7 KB	2026-04-09 08:58	✏️ Edit 👁️ View
🐘bank_module_super.php	php	22 KB	2026-04-09 08:56	✏️ Edit 👁️ View
🐘bank_reprint_payment_slip.php	php	8.7 KB	2025-12-18 06:08	✏️ Edit 👁️ View
🐘bank_staff_login.php	php	1.1 KB	2025-09-11 21:55	✏️ Edit 👁️ View
🖼️campus1.jpg	jpg	24.8 KB	2025-09-14 16:53	✏️ Edit 👁️ View
🖼️campus2.jpg	jpg	381.9 KB	2025-09-14 16:53	✏️ Edit 👁️ View
🐘carryover_payment.php	php	4.9 KB	2025-10-29 01:31	✏️ Edit 👁️ View
🐘carryover_payment_confirmation.php	php	8.3 KB	2026-01-25 12:38	✏️ Edit 👁️ View
🐘carryover_receipt.php	php	7.3 KB	2026-01-22 14:16	✏️ Edit 👁️ View
🐘check_amnesty_eligibility.php	php	6.8 KB	2025-10-25 15:59	✏️ Edit 👁️ View
🐘check_amnesty_status.php	php	4.8 KB	2025-10-25 14:29	✏️ Edit 👁️ View
🐘check_table.php	php	347 B	2025-10-25 16:20	✏️ Edit 👁️ View
📄composer	file	329 B	2025-09-14 19:47	✏️ Edit 👁️ View
📄composer.bat	bat	128 B	2020-12-11 21:18	✏️ Edit 👁️ View
📄composer.phar	phar	3 MB	2025-09-14 19:47	✏️ Edit 👁️ View
🗃️cou.sql	sql	399 B	2025-09-11 04:55	✏️ Edit 👁️ View
🐘course_bulk_upload.php	php	3 KB	2025-11-30 16:13	✏️ Edit 👁️ View
🐘course_delete.php	php	275 B	2025-11-30 16:14	✏️ Edit 👁️ View
🐘course_fetch_all.php	php	1.7 KB	2025-11-30 16:13	✏️ Edit 👁️ View
🐘course_registration.php	php	11.3 KB	2025-12-07 11:59	✏️ Edit 👁️ View
🐘course_save.php	php	585 B	2025-11-30 16:12	✏️ Edit 👁️ View
🐘course_update.php	php	613 B	2025-11-30 16:14	✏️ Edit 👁️ View
🐘courses_admin.php	php	11.7 KB	2026-01-15 18:24	✏️ Edit 👁️ View
🐘create_carryover_transaction.php	php	4.6 KB	2025-11-21 14:32	✏️ Edit 👁️ View
🐘create_reset_tokens.php	php	1.6 KB	2025-09-28 19:39	✏️ Edit 👁️ View
🐘db_connect.php	php	588 B	2026-01-10 21:13	✏️ Edit 👁️ View
🐘ddashboard.php	php	7.1 KB	2026-01-21 23:11	✏️ Edit 👁️ View
🐘delete_amnesty_application.php	php	332 B	2025-11-28 14:18	✏️ Edit 👁️ View
🐘delete_news.php	php	562 B	2025-10-23 11:09	✏️ Edit 👁️ View
🐘delete_slide.php	php	581 B	2025-10-23 11:05	✏️ Edit 👁️ View
🐘download_slip.php	php	3.3 KB	2025-09-12 04:26	✏️ Edit 👁️ View
🐘edit_amnesty_application.php	php	2.1 KB	2025-11-28 14:18	✏️ Edit 👁️ View
🐘edit_news.php	php	2.2 KB	2025-10-23 11:08	✏️ Edit 👁️ View
🐘edit_slide.php	php	2.3 KB	2025-10-23 11:04	✏️ Edit 👁️ View
🐘edit_student.php	php	4.8 KB	2025-09-28 17:17	✏️ Edit 👁️ View
🐘eligibility_form.php	php	4.5 KB	2025-09-14 21:12	✏️ Edit 👁️ View
🐘eligibility_form_pdf.php	php	6.6 KB	2025-09-15 03:34	✏️ Edit 👁️ View
🐘eligibility_forms.php	php	4.5 KB	2025-09-14 21:12	✏️ Edit 👁️ View
🐘eligibility_print.php	php	5.9 KB	2025-10-25 04:21	✏️ Edit 👁️ View
📄error_log	file	2.5 MB	2026-04-21 13:14	✏️ Edit 👁️ View
🐘examiner_auth.php	php	113 B	2026-01-07 17:57	✏️ Edit 👁️ View
🐘existing_index.php	php	5.5 KB	2025-10-23 10:23	✏️ Edit 👁️ View
🐘export_paid_students.php	php	1.6 KB	2025-10-29 02:04	✏️ Edit 👁️ View
🐘export_student.php	php	1.2 KB	2026-01-10 21:11	✏️ Edit 👁️ View
🐘export_students.php	php	2.5 KB	2025-09-28 18:00	✏️ Edit 👁️ View
🐘export_transactions.php	php	3 KB	2026-04-09 05:37	✏️ Edit 👁️ View
🗃️fat.sql	sql	742 B	2025-09-30 14:25	✏️ Edit 👁️ View
🐘fetch_courses.php	php	2.1 KB	2025-11-30 16:10	✏️ Edit 👁️ View
📄fetch_courses.php.bak	bak	2 KB	2025-11-30 16:12	✏️ Edit 👁️ View
🐘fetch_departments.php	php	448 B	2025-09-11 16:22	✏️ Edit 👁️ View
🐘fetch_lgas.php	php	501 B	2025-09-13 23:30	✏️ Edit 👁️ View
🐘hash.php	php	61 B	2026-01-07 19:02	✏️ Edit 👁️ View
🐘home_page.php	php	7.9 KB	2025-11-16 09:58	✏️ Edit 👁️ View
🐘index.php	php	9.6 KB	2026-01-25 09:40	✏️ Edit 👁️ View
🐘llogin.php	php	3.1 KB	2026-01-15 18:08	✏️ Edit 👁️ View
🐘login_process.php	php	1.2 KB	2026-01-07 18:39	✏️ Edit 👁️ View
🖼️logo.jpeg	jpeg	85.3 KB	2025-08-11 01:23	✏️ Edit 👁️ View
🖼️logo.png	png	2.3 MB	2025-09-14 15:51	✏️ Edit 👁️ View
🖼️logou.png	png	1.1 MB	2025-09-14 16:10	✏️ Edit 👁️ View
🐘logout.php	php	90 B	2025-09-13 02:31	✏️ Edit 👁️ View
🐘manage_admins.php	php	4.3 KB	2025-09-28 22:04	✏️ Edit 👁️ View
🐘manage_courses.php	php	18.1 KB	2025-09-13 21:34	✏️ Edit 👁️ View
🐘manage_news.php	php	2.9 KB	2025-10-23 11:08	✏️ Edit 👁️ View
🐘manage_portals.php	php	2.5 KB	2025-10-23 11:10	✏️ Edit 👁️ View
🐘manage_slides.php	php	3.1 KB	2025-10-23 11:04	✏️ Edit 👁️ View
🐘manage_students.php	php	8.7 KB	2025-09-28 18:17	✏️ Edit 👁️ View
🐘merge_columns.php	php	10.3 KB	2025-11-12 23:18	✏️ Edit 👁️ View
🐘payment_confirmation.php	php	3.4 KB	2026-01-12 11:57	✏️ Edit 👁️ View
🐘payment_progress.php	php	857 B	2025-11-09 20:02	✏️ Edit 👁️ View
🐘payment_receipt.php	php	5.3 KB	2026-01-11 16:46	✏️ Edit 👁️ View
🐘payment_status.php	php	469 B	2026-01-11 17:27	✏️ Edit 👁️ View
🐘pre_register_student.php	php	7.4 KB	2026-01-21 23:00	✏️ Edit 👁️ View
🐘previour_admin_Dashboard.php	php	5.7 KB	2025-10-23 10:57	✏️ Edit 👁️ View
🐘print_carryover_slip.php	php	10.9 KB	2025-11-18 16:05	✏️ Edit 👁️ View
🐘print_course_form.php	php	8.1 KB	2025-12-01 09:09	✏️ Edit 👁️ View
🐘print_exam_cardss.php	php	7.7 KB	2025-11-30 19:26	✏️ Edit 👁️ View
🐘print_payment_slip.php	php	7.7 KB	2025-12-18 06:07	✏️ Edit 👁️ View
🐘print_slip.php	php	3.7 KB	2025-09-17 19:52	✏️ Edit 👁️ View
🐘reports.php	php	6.5 KB	2025-09-13 22:48	✏️ Edit 👁️ View
📄reports.php.bak	bak	6.9 KB	2025-09-13 22:45	✏️ Edit 👁️ View
🐘reset_admin_passwords.php	php	1.8 KB	2025-09-28 19:31	✏️ Edit 👁️ View
🐘reset_password.php	php	2.1 KB	2025-09-28 19:41	✏️ Edit 👁️ View
🐘revoke_pre_registration.php	php	638 B	2026-01-10 21:52	✏️ Edit 👁️ View
🐘rotate_md5_passwords.php	php	2.7 KB	2025-09-28 19:38	✏️ Edit 👁️ View
🗃️rsult.sql	sql	742 B	2025-09-30 14:27	✏️ Edit 👁️ View
📊sample_candidates_csv_upload_template.csv	csv	374 B	2025-08-17 01:54	✏️ Edit 👁️ View
📊sample_upload_template.csv	csv	155 B	2025-11-14 08:46	✏️ Edit 👁️ View
🐘save_registration.php	php	5.2 KB	2025-12-07 11:00	✏️ Edit 👁️ View
📄settings.php.bak	bak	9.1 KB	2025-09-28 15:40	✏️ Edit 👁️ View
🐘slogout.php	php	85 B	2026-01-10 20:35	✏️ Edit 👁️ View
🐘student_dashboard.php	php	10.9 KB	2025-11-30 23:33	✏️ Edit 👁️ View
🐘student_login.php	php	4.3 KB	2025-11-30 16:13	✏️ Edit 👁️ View
🐘student_portal.php	php	5.7 KB	2025-10-29 01:36	✏️ Edit 👁️ View
🐘student_signup - Copy.php	php	12.2 KB	2025-10-27 17:38	✏️ Edit 👁️ View
🐘student_signup.php	php	16.9 KB	2025-11-30 21:40	✏️ Edit 👁️ View
🐘students_eligibility_form.php	php	9.7 KB	2025-11-13 08:07	✏️ Edit 👁️ View
🐘submit_amnesty.php	php	1.5 KB	2025-10-25 14:21	✏️ Edit 👁️ View
🐘submit_registration.php	php	9.8 KB	2025-11-21 14:07	✏️ Edit 👁️ View
🐘success_amnesty.php	php	3.8 KB	2025-10-25 14:09	✏️ Edit 👁️ View
🐘summer_course_form.php	php	5.4 KB	2026-01-25 11:26	✏️ Edit 👁️ View
🐘summer_dashboard.php	php	4.9 KB	2026-01-25 10:14	✏️ Edit 👁️ View
🐘summer_exam_card.php	php	5.8 KB	2026-01-25 11:48	✏️ Edit 👁️ View
🐘summer_login.php	php	2.7 KB	2026-01-25 09:53	✏️ Edit 👁️ View
🐘summer_logout.php	php	91 B	2026-01-22 21:08	✏️ Edit 👁️ View
🐘summer_registration_slip.php	php	6.1 KB	2026-01-25 11:01	✏️ Edit 👁️ View
🐘test_db.php	php	109 B	2026-01-07 18:41	✏️ Edit 👁️ View
🐘update_amnesty_application.php	php	1.5 KB	2025-11-28 14:35	✏️ Edit 👁️ View
🐘upload_csv.php	php	3.1 KB	2026-01-15 18:06	✏️ Edit 👁️ View
🐘verify_payment.php	php	7.1 KB	2025-10-31 02:09	✏️ Edit 👁️ View
🐘verify_qr.php	php	3.5 KB	2025-10-25 20:42	✏️ Edit 👁️ View
🐘view_student.php	php	3 KB	2025-09-28 17:23	✏️ Edit 👁️ View
🐘view_submissions.php	php	7.7 KB	2026-01-15 18:15	✏️ Edit 👁️ View
🐘vview_submissions.php	php	7.8 KB	2026-01-15 19:01	✏️ Edit 👁️ View