<!DOCTYPE html>
<html lang="so">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Natiijada Imtixaanka Ardayda (Student Result Checker)</title>
<!-- Tailwind CSS CDN -->
<script src="https://cdn.tailwindcss.com"></script>
<!-- FontAwesome for Icons -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
<!-- SheetJS for parsing XLSX/CSV files -->
<script src="https://cdn.jsdelivr.net/npm/xlsx@0.18.5/dist/xlsx.full.min.js"></script>
<!-- Google Fonts -->
<link href="https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700&display=swap" rel="stylesheet">
<style>
body {
font-family: 'Inter', sans-serif;
background-color: #f3f4f6;
}
@media print {
.no-print {
display: none !important;
}
.print-area {
box-shadow: none !important;
border: none !important;
margin: 0 !important;
width: 100% !important;
}
body {
background-color: #ffffff !important;
}
}
</style>
</head>
<body class="min-h-screen flex flex-col justify-between text-gray-800">
<!-- Top Header -->
<header class="bg-indigo-700 text-white shadow-md no-print">
<div class="max-w-6xl mx-auto px-4 py-4 flex flex-col sm:flex-row justify-between items-center gap-3">
<div class="flex items-center space-x-3 space-x-reverse">
<div class="bg-white p-2 rounded-lg text-indigo-700 font-bold text-2xl">
<i class="fa-solid font-bold fa-graduation-cap"></i>
</div>
<div>
<h1 class="text-xl font-bold tracking-wide">Nidaamka Hubinta Natiijada Ardayda</h1>
<p class="text-xs text-indigo-200">Dugsiga Dhexe & Sare - Raadi Natiijadaada</p>
</div>
</div>
<!-- Admin Data Upload Button -->
<button onclick="toggleAdminModal()" class="text-xs bg-indigo-600 hover:bg-indigo-800 border border-indigo-400 text-white font-medium py-2 px-3 rounded-lg flex items-center gap-2 transition">
<i class="fa-solid fa-file-excel text-green-300"></i>
<span>Cusbooneysii Xogta (Excel/CSV)</span>
</button>
</div>
</header>
<!-- Main Container -->
<main class="max-w-4xl mx-auto w-full px-4 py-8 flex-grow">
<!-- Search Card -->
<section class="bg-white rounded-2xl shadow-lg p-6 md:p-8 mb-8 no-print border border-gray-100">
<div class="text-center mb-6">
<h2 class="text-2xl font-bold text-gray-800">Geli Aqoonsiga Ardayga (Student ID)</h2>
<p class="text-gray-500 text-sm mt-1">Sida Nabadgalyada ah ugu eeg kaliya natiijadaada imtixaanka</p>
</div>
<form id="searchForm" onsubmit="handleSearch(event)" class="max-w-md mx-auto">
<div class="relative flex items-center">
<input
type="text"
id="studentIdInput"
placeholder="Tusaale: Teysiir-2001, d1cddc5e..."
required
class="w-full pl-11 pr-28 py-3.5 border-2 border-indigo-200 rounded-xl focus:outline-none focus:border-indigo-600 font-mono text-gray-700 shadow-sm transition"
/>
<div class="absolute left-3.5 text-gray-400">
<i class="fa-solid fa-id-card text-lg"></i>
</div>
<button
type="submit"
class="absolute right-1.5 top-1.5 bottom-1.5 px-5 bg-indigo-600 hover:bg-indigo-700 text-white font-semibold rounded-lg shadow transition flex items-center gap-2">
<i class="fa-solid fa-magnifying-glass text-sm"></i>
<span>Raadi</span>
</button>
</div>
</form>
<!-- Quick Demo Credentials Banner -->
<div class="mt-6 pt-4 border-t border-gray-100 text-xs text-gray-500 flex flex-wrap items-center justify-center gap-2">
<span class="font-medium text-gray-600">ID-yada Tusaalaha ah:</span>
<button onclick="fillAndSearch('Teysiir-2001')" class="bg-gray-100 hover:bg-indigo-50 hover:text-indigo-600 px-2.5 py-1 rounded border border-gray-200 font-mono text-indigo-700 transition">Teysiir-2001</button>
<button onclick="fillAndSearch('d1cddc5e')" class="bg-gray-100 hover:bg-indigo-50 hover:text-indigo-600 px-2.5 py-1 rounded border border-gray-200 font-mono text-indigo-700 transition">d1cddc5e</button>
<button onclick="fillAndSearch('f47ba24a')" class="bg-gray-100 hover:bg-indigo-50 hover:text-indigo-600 px-2.5 py-1 rounded border border-gray-200 font-mono text-indigo-700 transition">f47ba24a</button>
</div>
</section>
<!-- Error Message Alert -->
<div id="errorAlert" class="hidden mb-8 bg-red-50 border-l-4 border-red-500 p-4 rounded-r-xl shadow-sm no-print">
<div class="flex items-center space-x-3 space-x-reverse">
<i class="fa-solid fa-circle-exclamation text-red-500 text-xl"></i>
<div>
<h3 class="font-bold text-red-800">Lama Helin!</h3>
<p class="text-sm text-red-700">Xogta ardayga ma ahan mid la helay. Fadlan hubi in ID-ga aad gelisay uu sax yahay.</p>
</div>
</div>
</div>
<!-- Result Card Display Area -->
<div id="resultContainer" class="hidden">
<!-- Print Action Header -->
<div class="mb-4 flex justify-between items-center no-print">
<p class="text-sm text-gray-500">Natiijada Aqoonsiga: <span id="displaySearchedId" class="font-bold text-indigo-700"></span></p>
<button onclick="window.print()" class="bg-green-600 hover:bg-green-700 text-white px-4 py-2 rounded-lg font-medium shadow flex items-center gap-2 text-sm transition">
<i class="fa-solid fa-print"></i>
<span>Daabac / PDF Sida Ahaan U Kaydi</span>
</button>
</div>
<!-- Report Card Frame -->
<div id="reportCard" class="print-area bg-white rounded-2xl shadow-xl border border-gray-200 overflow-hidden">
<!-- Report Card Top Header -->
<div class="bg-gradient-to-r from-indigo-800 to-indigo-950 text-white p-6 border-b border-indigo-900">
<div class="flex flex-col md:flex-row justify-between items-center text-center md:text-left gap-4">
<div class="flex items-center space-x-4 space-x-reverse">
<div class="w-16 h-16 bg-white text-indigo-800 rounded-full flex items-center justify-center font-bold text-3xl shadow">
<i class="fa-solid fa-school"></i>
</div>
<div>
<h2 class="text-2xl font-extrabold tracking-wide">WARQADDA NATIIJADA IMTIXAANKA</h2>
<p class="text-indigo-200 text-sm">Wasaaradda Waxbarashada iyo Barbaarinta</p>
</div>
</div>
<div class="text-center md:text-right bg-indigo-900/50 p-3 rounded-xl border border-indigo-700/50">
<span class="text-xs uppercase tracking-wider text-indigo-300 block">Sanad Dugsiyeedka</span>
<span id="academicYear" class="text-lg font-bold text-amber-300">2025-2026</span>
</div>
</div>
</div>
<!-- Student Information Grid -->
<div class="p-6 bg-slate-50 border-b border-gray-200">
<h3 class="text-xs font-bold text-indigo-900 uppercase tracking-wider mb-3">Xogta Ardayga (Student Details)</h3>
<div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-4 text-sm">
<div class="bg-white p-3 rounded-lg border border-gray-200 shadow-sm">
<span class="text-gray-400 text-xs block">Magaca Ardayga:</span>
<span id="studentName" class="font-bold text-gray-800 text-base">---</span>
</div>
<div class="bg-white p-3 rounded-lg border border-gray-200 shadow-sm">
<span class="text-gray-400 text-xs block">Aqoonsiga (Student ID):</span>
<span id="studentID" class="font-mono font-bold text-indigo-700 text-base">---</span>
</div>
<div class="bg-white p-3 rounded-lg border border-gray-200 shadow-sm">
<span class="text-gray-400 text-xs block">Magaca Hooyada:</span>
<span id="motherName" class="font-semibold text-gray-800">---</span>
</div>
<div class="bg-white p-3 rounded-lg border border-gray-200 shadow-sm">
<span class="text-gray-400 text-xs block">Sanadka Dhalashada:</span>
<span id="birthYear" class="font-semibold text-gray-800">---</span>
</div>
<div class="bg-white p-3 rounded-lg border border-gray-200 shadow-sm">
<span class="text-gray-400 text-xs block">Magaalada/Gobolka Dhalashada:</span>
<span id="birthPlace" class="font-semibold text-gray-800">---</span>
</div>
</div>
</div>
<!-- Subject Grades Table -->
<div class="p-6">
<h3 class="text-xs font-bold text-indigo-900 uppercase tracking-wider mb-3">Natiijada Maadooyinka (Subject Breakdown)</h3>
<div class="overflow-x-auto rounded-xl border border-gray-200">
<table class="w-full text-left text-sm">
<thead class="bg-indigo-50 text-indigo-900 uppercase text-xs">
<tr>
<th class="py-3 px-4">#</th>
<th class="py-3 px-4">Maaddada (Subject)</th>
<th class="py-3 px-4 text-center">Dhibcaha Badhan (Max)</th>
<th class="py-3 px-4 text-center">Dhibcaha La Helay (Score)</th>
<th class="py-3 px-4 text-center">Xaaladda Maaddada</th>
</tr>
</thead>
<tbody id="subjectsTableBody" class="divide-y divide-gray-200 text-gray-700">
<!-- Dynamic Subject Rows will be inserted here -->
</tbody>
</table>
</div>
</div>
<!-- Summary Cards -->
<div class="p-6 bg-slate-50 border-t border-gray-200">
<div class="grid grid-cols-1 sm:grid-cols-3 gap-4">
<!-- Total Score -->
<div class="bg-white p-4 rounded-xl border border-gray-200 text-center shadow-sm">
<p class="text-xs text-gray-500 font-medium">Warta Guud ee Imtixaanka</p>
<p class="text-2xl font-extrabold text-gray-800 mt-1"><span id="totalScore">0</span> / 800</p>
</div>
<!-- Average Percentage -->
<div class="bg-white p-4 rounded-xl border border-gray-200 text-center shadow-sm">
<p class="text-xs text-gray-500 font-medium">Celceliska Imtixaanka</p>
<p class="text-2xl font-extrabold text-indigo-600 mt-1"><span id="averagePercentage">0</span>%</p>
</div>
<!-- Result Status -->
<div id="statusCard" class="p-4 rounded-xl border text-center shadow-sm">
<p class="text-xs font-medium opacity-80">Xaaladda Ardayga (Status)</p>
<p id="statusText" class="text-2xl font-black mt-1">---</p>
</div>
</div>
<!-- Stamp & Signature Placeholder -->
<div class="mt-8 pt-6 border-t border-gray-200 flex justify-between items-end text-xs text-gray-500">
<div>
<p>Tariikhda Daabacaadda: <span id="currentDate" class="font-medium text-gray-700"></span></p>
<p class="mt-1">Nidaamka Maamulka Natiijada Dugsiga</p>
</div>
<div class="text-center">
<div class="w-32 border-b border-gray-400 mb-1"></div>
<p class="font-semibold text-gray-700">Saxiixa & Shaabadada Maamulka</p>
</div>
</div>
</div>
</div>
</div>
</main>
<!-- Admin Excel Upload Modal -->
<div id="adminModal" class="fixed inset-0 bg-black/60 backdrop-blur-sm hidden flex items-center justify-center p-4 z-50 no-print">
<div class="bg-white rounded-2xl max-w-md w-full p-6 shadow-2xl relative">
<button onclick="toggleAdminModal()" class="absolute top-4 right-4 text-gray-400 hover:text-gray-600">
<i class="fa-solid fa-xmark text-xl"></i>
</button>
<div class="flex items-center space-x-3 space-x-reverse mb-4">
<div class="p-3 bg-indigo-100 text-indigo-700 rounded-xl">
<i class="fa-solid fa-file-excel text-xl"></i>
</div>
<div>
<h3 class="font-bold text-lg text-gray-800">Cusbooneysii Xogta Excel</h3>
<p class="text-xs text-gray-500">Soo rar faylka Excel ama CSV si aad xog cusub u geliso</p>
</div>
</div>
<div class="space-y-4">
<div class="border-2 border-dashed border-gray-300 hover:border-indigo-500 rounded-xl p-6 text-center cursor-pointer transition bg-gray-50" onclick="document.getElementById('excelFileInput').click()">
<i class="fa-solid fa-cloud-arrow-up text-3xl text-indigo-500 mb-2"></i>
<p class="text-sm font-medium text-gray-700">Geli ama jiid faylka Excel/CSV</p>
<p class="text-xs text-gray-400 mt-1">.xlsx, .xls ama .csv</p>
<input type="file" id="excelFileInput" accept=".xlsx, .xls, .csv" class="hidden" onchange="handleFileUpload(event)" />
</div>
<div class="bg-amber-50 border border-amber-200 text-amber-800 p-3 rounded-lg text-xs space-y-1">
<p class="font-bold"><i class="fa-solid fa-lightbulb"></i> Fiiro gaar ah:</p>
<p>Waa in faylku leeyahay tiirarka: <strong>STUDENTID</strong>, <strong>Magaca Ardayga</strong>, Fiqi, Carabi, English, Somali, Xadiis, Siiro, Naxwo, Xisaab.</p>
</div>
<div class="flex gap-2">
<button onclick="resetToDemoData()" class="w-full py-2.5 px-4 bg-gray-100 hover:bg-gray-200 text-gray-700 font-medium text-xs rounded-lg transition">
Dajiso Xogta Asalka ah (Demo)
</button>
<button onclick="toggleAdminModal()" class="w-full py-2.5 px-4 bg-indigo-600 hover:bg-indigo-700 text-white font-medium text-xs rounded-lg transition">
Khaaraj
</button>
</div>
</div>
</div>
</div>
<!-- Footer -->
<footer class="bg-gray-800 text-gray-400 py-4 text-center text-xs no-print">
<p>© 2026 Nidaamka Hubinta Natiijooyinka Imtixaanka Ardayda. Xuquuqda oo dhan waa dhowran tahay.</p>
</footer>
<!-- JavaScript Application Logic -->
<script>
// Default Pre-loaded Demo Dataset
const demoData = [
{
STUDENTID: "Teysiir-2001",
"Magaca Ardayga": "Axmed Jamac Asad",
"Magaca Hooyada": "Farhiyo Aden Ahmed",
"Sanad Dugsiyeedka": "2025-2026",
"Sanadka Dhalashada": "2008",
"Magaalada Dhalashada": "Mogadishu",
Fiqi: 60,
Carabi: 100,
English: 52,
Somali: 63,
Xadiis: 96,
Siiro: 80,
Naxwo: 70,
Xisaab: 18
},
{
STUDENTID: "d1cddc5e",
"Magaca Ardayga": "Yuusuf Faadir Xamdi",
"Magaca Hooyada": "Hsjsjsjsjsjssj",
"Sanad Dugsiyeedka": "2027",
"Sanadka Dhalashada": "2007",
"Magaalada Dhalashada": "Hargeisa",
Fiqi: 50,
Carabi: 30,
English: 60,
Somali: 100,
Xadiis: 100,
Siiro: 100,
Naxwo: 85,
Xisaab: 25
},
{
STUDENTID: "f47ba24a",
"Magaca Ardayga": "Ueueueuudhshhj",
"Magaca Hooyada": "Yyyyyyyyyyyy",
"Sanad Dugsiyeedka": "2027",
"Sanadka Dhalashada": "2009",
"Magaalada Dhalashada": "Kismayo",
Fiqi: 80,
Carabi: 100,
English: 60,
Somali: 38,
Xadiis: 88,
Siiro: 66,
Naxwo: 36,
Xisaab: 45
}
];
// Subject Keys List
const subjectKeys = ["Fiqi", "Carabi", "English", "Somali", "Xadiis", "Siiro", "Naxwo", "Xisaab"];
// Initialize Local Storage
function getStudentDatabase() {
const stored = localStorage.getItem('student_results_db');
if (stored) {
try {
return JSON.parse(stored);
} catch (e) {
console.error("Failed to parse local storage data", e);
}
}
// Save demo data if empty
localStorage.setItem('student_results_db', JSON.stringify(demoData));
return demoData;
}
// Fill search box and auto-search
function fillAndSearch(id) {
document.getElementById('studentIdInput').value = id;
handleSearch(new Event('submit'));
}
// Main Search Form Handler
function handleSearch(event) {
if (event) event.preventDefault();
const searchInput = document.getElementById('studentIdInput').value.trim();
const errorAlert = document.getElementById('errorAlert');
const resultContainer = document.getElementById('resultContainer');
if (!searchInput) return;
const database = getStudentDatabase();
// Find matching student by STUDENTID (case-insensitive)
const student = database.find(s =>
String(s.STUDENTID || s.studentId || s.id || '').trim().toLowerCase() === searchInput.toLowerCase()
);
if (student) {
// Hide Error, Show Result
errorAlert.classList.add('hidden');
displayStudentResult(student, searchInput);
resultContainer.classList.remove('hidden');
// Smooth Scroll to result
resultContainer.scrollIntoView({ behavior: 'smooth', block: 'start' });
} else {
// Show Error, Hide Result
resultContainer.classList.add('hidden');
errorAlert.classList.remove('hidden');
}
}
// Populate Result Card DOM
function displayStudentResult(student, queryId) {
document.getElementById('displaySearchedId').innerText = queryId;
// Info Populate
document.getElementById('studentName').innerText = student["Magaca Ardayga"] || student.Name || student.name || "N/A";
document.getElementById('studentID').innerText = student.STUDENTID || student.studentId || queryId;
document.getElementById('motherName').innerText = student["Magaca Hooyada"] || student.Mother || "---";
document.getElementById('academicYear').innerText = student["Sanad Dugsiyeedka"] || student.Year || "2025-2026";
document.getElementById('birthYear').innerText = student["Sanadka Dhalashada"] || "---";
document.getElementById('birthPlace').innerText = student["Magaalada Dhalashada"] || student["Gobolka Dhalashada"] || "---";
// Subjects Table
const tbody = document.getElementById('subjectsTableBody');
tbody.innerHTML = '';
let totalScore = 0;
const maxScorePerSubject = 100;
subjectKeys.forEach((subject, index) => {
const score = Number(student[subject]) || 0;
totalScore += score;
const isPassed = score >= 50;
const tr = document.createElement('tr');
tr.className = index % 2 === 0 ? 'bg-white' : 'bg-gray-50';
tr.innerHTML = `
<td class="py-3 px-4 font-mono text-gray-400">${index + 1}</td>
<td class="py-3 px-4 font-semibold text-gray-800">${subject}</td>
<td class="py-3 px-4 text-center font-mono text-gray-500">${maxScorePerSubject}</td>
<td class="py-3 px-4 text-center font-bold font-mono text-base ${isPassed ? 'text-gray-800' : 'text-red-600'}">${score}</td>
<td class="py-3 px-4 text-center">
<span class="px-2.5 py-1 rounded-full text-xs font-semibold ${isPassed ? 'bg-green-100 text-green-800' : 'bg-red-100 text-red-800'}">
${isPassed ? 'Gudbay' : 'Dhacay'}
</span>
</td>
`;
tbody.appendChild(tr);
});
// Summary Totals
const totalMax = subjectKeys.length * 100;
const average = (totalScore / totalMax) * 100;
const isOverallPassed = average >= 50;
document.getElementById('totalScore').innerText = totalScore;
document.getElementById('averagePercentage').innerText = average.toFixed(1);
const statusCard = document.getElementById('statusCard');
const statusText = document.getElementById('statusText');
if (isOverallPassed) {
statusCard.className = "p-4 rounded-xl border border-green-200 bg-green-50 text-green-800 text-center shadow-sm";
statusText.innerText = "Gudbay (Passed)";
} else {
statusCard.className = "p-4 rounded-xl border border-red-200 bg-red-50 text-red-800 text-center shadow-sm";
statusText.innerText = "Dhacay (Failed)";
}
// Date
const today = new Date();
document.getElementById('currentDate').innerText = today.toLocaleDateString('so-SO', {
year: 'numeric',
month: 'long',
day: 'numeric'
});
}
// Admin Modal Controls
function toggleAdminModal() {
const modal = document.getElementById('adminModal');
modal.classList.toggle('hidden');
}
// Handle Excel File Upload
function handleFileUpload(event) {
const file = event.target.files[0];
if (!file) return;
const reader = new FileReader();
reader.onload = function(e) {
try {
const data = new Uint8Array(e.target.result);
const workbook = XLSX.read(data, { type: 'array' });
const firstSheetName = workbook.SheetNames[0];
const worksheet = workbook.Sheets[firstSheetName];
const jsonData = XLSX.utils.sheet_to_json(worksheet);
if (jsonData && jsonData.length > 0) {
localStorage.setItem('student_results_db', JSON.stringify(jsonData));
alert(`Xogta si guul leh ayaa loo cusbooneysiiyay! Waxaa la helay ${jsonData.length} arday.`);
toggleAdminModal();
} else {
alert("Faylka aad soo gelisay ma laha xog sax ah.");
}
} catch (err) {
alert("Waxaa dhacay error marka faylka la akhrinayay: " + err.message);
}
};
reader.readAsArrayBuffer(file);
}
// Reset to Default Demo Dataset
function resetToDemoData() {
localStorage.setItem('student_results_db', JSON.stringify(demoData));
alert("Xogta dib ayaa loogu celiyay demo-gii hore.");
toggleAdminModal();
}
// Initialize default state
window.onload = function() {
getStudentDatabase();
};
</script>
</body>
</html>