WasteLessV6.2AlphaB1 / student-management.html
EHDEM's picture
Upload 14 files
6cfcdf2 verified
Raw History Blame Contribute Delete
31.9 kB
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>WASTE-LESS - Student Management</title>
<link rel="stylesheet" href="style.css">
<script src="https://cdn.tailwindcss.com"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
</head>
<body class="bg-gray-100 min-h-screen">
<div class="container mx-auto px-4 py-8 max-w-4xl">
<!-- Header -->
<header class="bg-blue-600 text-white rounded-lg shadow-lg p-6 mb-8">
<div class="flex items-center">
<a href="admin-dashboard.html" class="text-blue-100 hover:text-white mr-4 text-xl"><i class="fas fa-arrow-left"></i></a>
<div>
<h1 class="text-3xl font-bold">Student Management</h1>
<p class="text-blue-100">Add or remove students from the system</p>
</div>
</div>
</header>
<!-- Tabs -->
<div class="bg-white rounded-lg shadow-md p-6 mb-8">
<div class="flex border-b border-gray-200 mb-6 overflow-x-auto">
<button id="add-tab" class="px-4 py-2 font-medium text-blue-600 border-b-2 border-blue-600 whitespace-nowrap">
<i class="fas fa-user-plus mr-2"></i> Add Student
</button>
<button id="remove-tab" class="px-4 py-2 font-medium text-gray-500 hover:text-gray-700 whitespace-nowrap">
<i class="fas fa-user-minus mr-2"></i> Remove Student
</button>
<button id="class-tab" class="px-4 py-2 font-medium text-gray-500 hover:text-gray-700 whitespace-nowrap">
<i class="fas fa-building mr-2"></i> Manage Classes
</button>
<button id="import-export-tab" class="px-4 py-2 font-medium text-gray-500 hover:text-gray-700 whitespace-nowrap">
<i class="fas fa-file-import mr-2"></i> Import/Export
</button>
</div>
<!-- Add Student -->
<div id="add-form" class="space-y-4">
<div class="grid grid-cols-1 md:grid-cols-2 gap-4">
<div>
<label for="add-class" class="block text-gray-700 font-medium mb-2">Class</label>
<select id="add-class" class="w-full px-4 py-2 border border-gray-300 rounded-lg">
<option value="">Select Class</option>
</select>
</div>
<div>
<label for="add-form-select" class="block text-gray-700 font-medium mb-2">Form</label>
<select id="add-form-select" class="w-full px-4 py-2 border border-gray-300 rounded-lg">
<option value="1">Form 1</option>
<option value="2">Form 2</option>
<option value="3">Form 3</option>
<option value="4">Form 4</option>
<option value="5">Form 5</option>
</select>
</div>
</div>
<div>
<label for="student-name" class="block text-gray-700 font-medium mb-2">Student Name</label>
<input type="text" id="student-name" class="w-full px-4 py-2 border border-gray-300 rounded-lg" placeholder="Enter full name">
</div>
<button id="add-student-btn" class="w-full bg-blue-600 hover:bg-blue-700 text-white font-bold py-3 px-4 rounded-lg transition duration-200">
<i class="fas fa-save mr-2"></i> Add Student
</button>
<div id="add-success" class="hidden bg-green-50 border border-green-200 text-green-700 p-4 rounded-lg">
<div class="flex items-center">
<i class="fas fa-check-circle text-green-500 text-xl mr-3"></i>
<div><h3 class="font-bold">Student Added Successfully!</h3><p class="text-sm">Saved to GitHub.</p></div>
</div>
</div>
</div>
<!-- Remove Student -->
<div id="remove-form" class="space-y-4 hidden">
<div class="grid grid-cols-1 md:grid-cols-2 gap-4">
<div>
<label for="remove-class" class="block text-gray-700 font-medium mb-2">Class</label>
<select id="remove-class" class="w-full px-4 py-2 border border-gray-300 rounded-lg">
<option value="">Select Class</option>
</select>
</div>
<div>
<label for="remove-form-select" class="block text-gray-700 font-medium mb-2">Form</label>
<select id="remove-form-select" class="w-full px-4 py-2 border border-gray-300 rounded-lg">
<option value="">Select Form</option>
<option value="1">Form 1</option>
<option value="2">Form 2</option>
<option value="3">Form 3</option>
<option value="4">Form 4</option>
<option value="5">Form 5</option>
</select>
</div>
</div>
<div id="student-select-container" class="hidden">
<label for="student-select" class="block text-gray-700 font-medium mb-2">Student</label>
<select id="student-select" class="w-full px-4 py-2 border border-gray-300 rounded-lg">
<option value="">Select Student</option>
</select>
</div>
<button id="remove-student-btn" class="w-full bg-red-600 hover:bg-red-700 text-white font-bold py-3 px-4 rounded-lg transition duration-200">
<i class="fas fa-trash-alt mr-2"></i> Remove Student
</button>
<div id="remove-success" class="hidden bg-green-50 border border-green-200 text-green-700 p-4 rounded-lg">
<div class="flex items-center">
<i class="fas fa-check-circle text-green-500 text-xl mr-3"></i>
<div><h3 class="font-bold">Student Removed Successfully!</h3><p class="text-sm">Changes saved to GitHub.</p></div>
</div>
</div>
</div>
<!-- Manage Classes -->
<div id="class-form" class="space-y-6 hidden">
<div class="bg-blue-50 border border-blue-200 text-blue-700 p-4 rounded-lg">
<div class="flex items-center">
<i class="fas fa-info-circle text-blue-500 text-xl mr-3"></i>
<div>
<h3 class="font-bold">Manage Classes</h3>
<p class="text-sm">Add or remove classes. Changes are saved directly to GitHub.</p>
</div>
</div>
</div>
<div class="grid grid-cols-1 md:grid-cols-3 gap-4">
<div>
<label for="class-action" class="block text-gray-700 font-medium mb-2">Action</label>
<select id="class-action" class="w-full px-4 py-2 border border-gray-300 rounded-lg">
<option value="add">Add New Class</option>
<option value="remove">Remove Existing Class</option>
</select>
</div>
<div>
<label for="class-scope" class="block text-gray-700 font-medium mb-2">Scope</label>
<select id="class-scope" class="w-full px-4 py-2 border border-gray-300 rounded-lg">
<option value="specific">Specific Form</option>
<option value="all">All Forms</option>
</select>
</div>
<div id="specific-form-container">
<label for="class-form-select" class="block text-gray-700 font-medium mb-2">Form</label>
<select id="class-form-select" class="w-full px-4 py-2 border border-gray-300 rounded-lg">
<option value="">Choose Form</option>
<option value="1">Form 1</option>
<option value="2">Form 2</option>
<option value="3">Form 3</option>
<option value="4">Form 4</option>
<option value="5">Form 5</option>
</select>
</div>
</div>
<div id="add-class-container" class="hidden">
<label for="new-class-name" class="block text-gray-700 font-medium mb-2">New Class Name</label>
<input type="text" id="new-class-name" class="w-full px-4 py-2 border border-gray-300 rounded-lg" placeholder="e.g. CERIA">
</div>
<div id="remove-class-container" class="hidden">
<label for="remove-class-name" class="block text-gray-700 font-medium mb-2">Class to Remove</label>
<select id="remove-class-name" class="w-full px-4 py-2 border border-gray-300 rounded-lg">
<option value="">Select Class</option>
</select>
<p class="text-sm text-red-600 mt-2">Warning: This will permanently delete the class and all its students.</p>
</div>
<button id="apply-class-btn" class="w-full bg-blue-600 hover:bg-blue-700 text-white font-bold py-3 px-4 rounded-lg transition duration-200">
<i class="fas fa-save mr-2"></i> Apply Changes
</button>
<div id="class-success" class="hidden bg-green-50 border border-green-200 text-green-700 p-4 rounded-lg">
<div class="flex items-center">
<i class="fas fa-check-circle text-green-500 text-xl mr-3"></i>
<div>
<h3 class="font-bold">Success!</h3>
<p id="class-success-msg" class="text-sm"></p>
</div>
</div>
</div>
</div>
<!-- Import/Export -->
<div id="import-export-form" class="space-y-4 hidden">
<div class="bg-blue-50 border border-blue-200 text-blue-700 p-4 rounded-lg mb-4">
<div class="flex items-center">
<i class="fas fa-info-circle text-blue-500 text-xl mr-3"></i>
<div>
<h3 class="font-bold">Bulk Import/Export</h3>
<p class="text-sm">Import from CSV or export current data.</p>
</div>
</div>
</div>
<div class="grid grid-cols-1 md:grid-cols-2 gap-6">
<div class="bg-white border border-gray-200 rounded-lg p-4">
<h3 class="text-lg font-medium mb-4 text-gray-800">Export Data</h3>
<p class="text-gray-600 mb-4">Download latest student list in CSV format.</p>
<button id="export-btn" class="w-full bg-green-600 hover:bg-green-700 text-white font-bold py-2 px-4 rounded-lg transition duration-200">
<i class="fas fa-file-export mr-2"></i> Export to CSV
</button>
<button id="export-sample-btn" class="mt-3 w-full bg-blue-100 hover:bg-blue-200 text-blue-700 font-medium py-2 px-4 rounded-lg transition duration-200">
<i class="fas fa-file-download mr-2"></i> Sample CSV
</button>
<div id="export-success" class="hidden bg-green-50 border border-green-200 text-green-700 p-4 rounded-lg mt-4">
<div class="flex items-center"><i class="fas fa-check-circle text-green-500 text-xl mr-3"></i>
<div><h4 class="font-bold">Export ready!</h4><p class="text-sm">Click below to download.</p></div>
</div>
<a id="download-link" class="mt-3 block w-full text-center bg-green-600 hover:bg-green-700 text-white font-bold py-2 px-4 rounded-lg">
<i class="fas fa-download mr-2"></i> Download CSV File
</a>
</div>
</div>
<div class="bg-white border border-gray-200 rounded-lg p-4">
<h3 class="text-lg font-medium mb-4 text-gray-800">Import Data</h3>
<p class="text-gray-600 mb-2">CSV format: Class,Form,StudentName</p>
<div class="border-2 border-dashed border-gray-300 rounded-lg p-4 text-center mb-3">
<input type="file" id="csv-file" accept=".csv" class="hidden">
<label for="csv-file" class="cursor-pointer">
<i class="fas fa-file-csv text-3xl text-blue-500 mb-2"></i>
<p class="text-gray-600">Click to select CSV file</p>
<p class="text-sm text-gray-500" id="file-name">No file selected</p>
</label>
</div>
<button id="import-btn" class="w-full bg-blue-600 hover:bg-blue-700 text-white font-bold py-2 px-4 rounded-lg transition duration-200">
<i class="fas fa-file-import mr-2"></i> Import CSV
</button>
<div id="import-success" class="hidden bg-green-50 border border-green-200 text-green-700 p-3 rounded-lg mt-3">
Import completed! <span id="import-stats" class="font-bold"></span>
</div>
<div id="import-error" class="hidden bg-red-50 border border-red-200 text-red-700 p-3 rounded-lg mt-3">
<span id="error-message"></span>
</div>
</div>
</div>
</div>
</div>
</div>
<script src="config.js"></script>
<script>
const REPO = 'SMSS-Waste-Less/Waste-LessV5';
const FILE_PATH = 'student-list.json';
const CSV_TEMPLATE = `class,form,studentName
BUDI,1,John Doe
BUDI,1,Jane Smith
USAHA,2,Michael Johnson
USAHA,2,Sarah Williams
MAJU,3,David Brown
MAJU,3,Emily Davis`;
let students = {};
let availableClasses = [];
let currentCsvBlobUrl = null;
let fileSha = '';
async function loadStudentList() {
try {
const response = await fetch(`https://api.github.com/repos/${REPO}/contents/${FILE_PATH}`, {
headers: { 'Authorization': `token ${GITHUB_CONFIG.TOKEN}`, 'Accept': 'application/vnd.github.v3+json' }
});
if (response.status === 404) {
students = {}; availableClasses = [];
} else if (response.ok) {
const data = await response.json();
fileSha = data.sha;
students = JSON.parse(atob(data.content));
availableClasses = [...new Set(Object.keys(students).map(k => k.split('-')[0]))].sort();
} else {
throw new Error('GitHub API error: ' + response.status);
}
} catch (err) {
console.error(err);
alert('Failed to load data from GitHub. Check connection or token.');
students = {}; availableClasses = [];
}
updateClassDropdowns();
loadStudentsForRemoval();
}
function updateClassDropdowns() {
['add-class', 'remove-class'].forEach(id => {
const select = document.getElementById(id);
select.innerHTML = '<option value="">Select Class</option>';
availableClasses.forEach(cls => {
const opt = document.createElement('option');
opt.value = opt.textContent = cls;
select.appendChild(opt);
});
if (!availableClasses.length) select.innerHTML += '<option disabled>No classes yet</option>';
});
}
async function saveStudentListToGitHub() {
try {
let sha = fileSha;
if (!sha) {
const res = await fetch(`https://api.github.com/repos/${REPO}/contents/${FILE_PATH}`, {
headers: { 'Authorization': `token ${GITHUB_CONFIG.TOKEN}` }
});
if (res.ok) sha = (await res.json()).sha;
}
const putRes = await fetch(`https://api.github.com/repos/${REPO}/contents/${FILE_PATH}`, {
method: 'PUT',
headers: {
'Authorization': `token ${GITHUB_CONFIG.TOKEN}`,
'Content-Type': 'application/json'
},
body: JSON.stringify({
message: `Update by admin - ${new Date().toISOString()}`,
content: btoa(JSON.stringify(students, null, 2)),
sha: sha || undefined,
branch: 'main'
})
});
if (!putRes.ok) {
const err = await putRes.json();
throw new Error(err.message || 'Save failed');
}
const resData = await putRes.json();
fileSha = resData.content.sha;
return true;
} catch (err) {
alert('Failed to save to GitHub: ' + err.message);
return false;
}
}
// Export
document.getElementById('export-btn').addEventListener('click', async () => {
const btn = document.getElementById('export-btn');
btn.disabled = true;
btn.innerHTML = '<i class="fas fa-spinner fa-spin mr-2"></i> Exporting...';
await loadStudentList();
const csv = 'class,form,studentName
' + Object.keys(students).map(key => {
const [cls, form] = key.split('-');
return students[key].map(s => `${cls},${form},"${s.replace(/"/g, '""')}"`).join('
');
}).join('
');
const filename = `student-list-${new Date().toISOString().split('T')[0]}.csv`;
if (currentCsvBlobUrl) URL.revokeObjectURL(currentCsvBlobUrl);
const blob = new Blob([csv], { type: 'text/csv' });
currentCsvBlobUrl = URL.createObjectURL(blob);
document.getElementById('download-link').href = currentCsvBlobUrl;
document.getElementById('download-link').download = filename;
document.getElementById('export-success').classList.remove('hidden');
btn.disabled = false;
btn.innerHTML = '<i class="fas fa-file-export mr-2"></i> Export to CSV';
});
document.getElementById('export-sample-btn').addEventListener('click', () => {
const blob = new Blob([CSV_TEMPLATE], { type: 'text/csv' });
const url = URL.createObjectURL(blob);
const a = document.createElement('a');
a.href = url; a.download = 'student-list-sample.csv';
a.click(); URL.revokeObjectURL(url);
});
// Import
function parseCSV(text) {
const lines = text.split('
').map(l => l.trim()).filter(l => l);
if (lines.length < 1) throw new Error('Empty file');
const headers = lines[0].toLowerCase().split(',');
if (!headers.includes('class') || !headers.includes('form') || !headers.includes('studentname'))
throw new Error('Missing columns: class, form, studentName');
const data = {};
for (let i = 1; i < lines.length; i++) {
const match = lines[i].match(/([^,]*),([^,]*),(.*)/);
if (!match) continue;
let cls = match[1].trim().toUpperCase();
let form = match[2].trim();
let name = match[3].trim().replace(/^"|"$/g, '').replace(/""/g, '"');
if (!cls || !form || !name) continue;
const key = `${cls}-${form}`;
if (!data[key]) data[key] = [];
if (!data[key].includes(name)) data[key].push(name);
}
return data;
}
document.getElementById('import-btn').addEventListener('click', async () => {
const file = document.getElementById('csv-file').files[0];
if (!file) return alert('Select a CSV file');
const reader = new FileReader();
reader.onload = async e => {
try {
students = parseCSV(e.target.result);
const saved = await saveStudentListToGitHub();
if (saved) {
availableClasses = [...new Set(Object.keys(students).map(k => k.split('-')[0]))].sort();
updateClassDropdowns();
const count = Object.values(students).reduce((a,b) => a + b.length, 0);
document.getElementById('import-stats').textContent = `${count} students imported`;
document.getElementById('import-success').classList.remove('hidden');
setTimeout(() => document.getElementById('import-success').classList.add('hidden'), 5000);
document.getElementById('csv-file').value = '';
document.getElementById('file-name').textContent = 'No file selected';
}
} catch (err) {
document.getElementById('error-message').textContent = err.message;
document.getElementById('import-error').classList.remove('hidden');
setTimeout(() => document.getElementById('import-error').classList.add('hidden'), 6000);
}
};
reader.readAsText(file);
});
document.getElementById('csv-file').addEventListener('change', e => {
document.getElementById('file-name').textContent = e.target.files[0]?.name || 'No file selected';
});
// Tab switching
const tabs = ['add-tab', 'remove-tab', 'class-tab', 'import-export-tab'];
const forms = ['add-form', 'remove-form', 'class-form', 'import-export-form'];
tabs.forEach((tabId, i) => {
document.getElementById(tabId).addEventListener('click', () => {
forms.forEach(f => document.getElementById(f).classList.add('hidden'));
document.getElementById(forms[i]).classList.remove('hidden');
tabs.forEach(t => {
const btn = document.getElementById(t);
btn.classList.add('text-gray-500');
btn.classList.remove('text-blue-600', 'border-b-2', 'border-blue-600');
});
document.getElementById(tabId).classList.remove('text-gray-500');
document.getElementById(tabId).classList.add('text-blue-600', 'border-b-2', 'border-blue-600');
if (tabId === 'class-tab') updateClassFormVisibility();
});
});
// Remove student dropdown
['remove-class', 'remove-form-select'].forEach(id => document.getElementById(id).addEventListener('change', loadStudentsForRemoval));
function loadStudentsForRemoval() {
const cls = document.getElementById('remove-class').value;
const form = document.getElementById('remove-form-select').value;
const sel = document.getElementById('student-select');
const cont = document.getElementById('student-select-container');
sel.innerHTML = '<option value="">Select Student</option>';
cont.classList.add('hidden');
if (cls && form) {
const key = `${cls}-${form}`;
if (students[key]?.length) {
students[key].forEach(s => {
const opt = document.createElement('option');
opt.value = opt.textContent = s;
sel.appendChild(opt);
});
cont.classList.remove('hidden');
}
}
}
// Add student
document.getElementById('add-student-btn').addEventListener('click', async () => {
const cls = document.getElementById('add-class').value;
const form = document.getElementById('add-form-select').value;
const name = document.getElementById('student-name').value.trim();
if (!name) return alert('Enter student name');
if (!cls) return alert('Select a class');
const key = `${cls}-${form}`;
if (!students[key]) students[key] = [];
if (students[key].includes(name)) return alert('Student already exists');
students[key].push(name);
const saved = await saveStudentListToGitHub();
if (saved) {
document.getElementById('student-name').value = '';
document.getElementById('add-success').classList.remove('hidden');
setTimeout(() => document.getElementById('add-success').classList.add('hidden'), 3000);
availableClasses = [...new Set(Object.keys(students).map(k => k.split('-')[0]))].sort();
updateClassDropdowns();
}
});
// Remove student
document.getElementById('remove-student-btn').addEventListener('click', async () => {
const cls = document.getElementById('remove-class').value;
const form = document.getElementById('remove-form-select').value;
const name = document.getElementById('student-select').value;
if (!name) return alert('Select a student');
const key = `${cls}-${form}`;
if (students[key]) {
students[key] = students[key].filter(s => s !== name);
if (!students[key].length) delete students[key];
}
const saved = await saveStudentListToGitHub();
if (saved) {
loadStudentsForRemoval();
document.getElementById('remove-success').classList.remove('hidden');
setTimeout(() => document.getElementById('remove-success').classList.add('hidden'), 3000);
availableClasses = [...new Set(Object.keys(students).map(k => k.split('-')[0]))].sort();
updateClassDropdowns();
}
});
// Manage Classes
const allForms = ['1','2','3','4','5'];
function populateRemoveClassDropdown() {
const select = document.getElementById('remove-class-name');
const scope = document.getElementById('class-scope').value;
const form = scope === 'all' ? null : document.getElementById('class-form-select').value;
select.innerHTML = '<option value="">Select Class</option>';
const set = new Set();
for (const key in students) {
const [c, f] = key.split('-');
if (!form || f === form) set.add(c);
}
if (set.size === 0) {
select.innerHTML = '<option value="">No classes found</option>';
} else {
set.forEach(c => {
const opt = document.createElement('option');
opt.value = opt.textContent = c;
select.appendChild(opt);
});
}
}
function updateClassFormVisibility() {
const action = document.getElementById('class-action').value;
const scope = document.getElementById('class-scope').value;
document.getElementById('add-class-container').classList.toggle('hidden', action !== 'add');
document.getElementById('remove-class-container').classList.toggle('hidden', action !== 'remove');
document.getElementById('specific-form-container').classList.toggle('hidden', scope === 'all');
if (action === 'remove') populateRemoveClassDropdown();
}
document.getElementById('class-action').addEventListener('change', updateClassFormVisibility);
document.getElementById('class-scope').addEventListener('change', updateClassFormVisibility);
document.getElementById('class-form-select').addEventListener('change', () => {
if (document.getElementById('class-action').value === 'remove') populateRemoveClassDropdown();
});
document.getElementById('apply-class-btn').addEventListener('click', async () => {
const action = document.getElementById('class-action').value;
const scope = document.getElementById('class-scope').value;
const targetForms = scope === 'all' ? allForms : [document.getElementById('class-form-select').value];
if (scope === 'specific' && !targetForms[0]) return alert('Select a form');
let msg = '';
if (action === 'add') {
const newCls = document.getElementById('new-class-name').value.trim().toUpperCase();
if (!newCls) return alert('Enter class name');
let added = 0;
for (const f of targetForms) {
const key = `${newCls}-${f}`;
if (!students[key]) { students[key] = []; added++; }
}
if (added === 0) return alert('Class already exists in selected form(s)');
msg = `Class ${newCls} added to ${added} form(s)`;
} else {
const cls = document.getElementById('remove-class-name').value;
if (!cls) return alert('Select a class');
let removed = 0;
for (const f of targetForms) {
const key = `${cls}-${f}`;
if (students[key]) {
if (students[key].length > 0 && !confirm(`Delete ${students[key].length} students in ${cls} Form ${f}?`)) continue;
delete students[key];
removed++;
}
}
if (removed === 0) return alert('No classes removed');
msg = `Class ${cls} removed from ${removed} form(s)`;
}
const saved = await saveStudentListToGitHub();
if (saved) {
document.getElementById('class-success-msg').textContent = msg;
document.getElementById('class-success').classList.remove('hidden');
setTimeout(() => document.getElementById('class-success').classList.add('hidden'), 5000);
availableClasses = [...new Set(Object.keys(students).map(k => k.split('-')[0]))].sort();
updateClassDropdowns();
updateClassFormVisibility();
}
});
window.addEventListener('load', loadStudentList);
</script>
</body>
</html>