\n \n

\n );\n}\n\n// Main App Component\nfunction SchoolManagementSystem() {\n const { user, loginType, login, logout } = AuthContext();\n const [view, setView] = useState('dashboard');\n const [students, setStudents] = useState([]);\n const [teachers, setTeachers] = useState([]);\n const [classes, setClasses] = useState([]);\n\n // Fetch initial data\n useEffect(() => {\n if (user) {\n fetchData();\n }\n }, [user]);\n\n const fetchData = async () => {\n try {\n const response = await fetch('/school-data');\n const data = await response.json();\n setStudents(data.students);\n setTeachers(data.teachers);\n setClasses(data.classes);\n } catch (error) {\n console.error('Failed to fetch school data:', error);\n }\n };\n\n // Render views based on user role and login status\n const renderView = () => {\n if (!user) {\n return ;\n }\n\n // Principal can view everything\n if (loginType === 'principal') {\n switch(view) {\n case 'students':\n return (\n

Students 👥

\n \n \n \n \n \n \n \n \n \n \n {students.map(student => (\n \n \n \n \n \n \n ))}\n \n

ID	Name	Grade	Username
{student.id}	{student.name}	{student.grade}	{student.username}

\n );\n case 'teachers':\n return (\n

Teachers 👩‍🏫

\n \n \n \n \n \n \n \n \n \n \n {teachers.map(teacher => (\n \n \n \n \n \n \n ))}\n \n

ID	Name	Department	Username
{teacher.id}	{teacher.name}	{teacher.department}	{teacher.username}

\n );\n case 'classes':\n return (\n

Classes 📚

\n \n \n \n \n \n \n \n \n \n {classes.map(cls => (\n \n \n \n \n \n ))}\n \n

ID	Name	Teacher
{cls.id}	{cls.name}	{cls.teacher}

\n );\n default:\n return (\n

School Dashboard 🏫

Welcome, Principal {user.name}!

Total Students: {students.length}

Total Teachers: {teachers.length}

Total Classes: {classes.length}

\n );\n }\n }\n\n // Existing student and teacher views remain the same\n switch(view) {\n case 'students':\n return loginType === 'teacher' ? (\n

Students 👥

\n \n \n \n \n \n \n \n \n \n \n {students.map(student => (\n \n \n \n \n \n ))}\n \n

ID	Name	Age	Grade
{student.id}	{student.name}	{student.grade}

\n ) : (\n

My Profile 👤

Name: {user.name}

Grade: {user.grade}

\n );\n case 'teachers':\n return loginType === 'teacher' ? (\n

Teachers 👩‍🏫

\n \n \n \n \n \n \n \n \n \n {teachers.map(teacher => (\n \n \n \n \n \n ))}\n \n

ID	Name	Department
{teacher.id}	{teacher.name}	{teacher.department}

\n ) : (\n

Access Denied

\n );\n case 'classes':\n return (\n

Classes 📚

\n \n \n \n \n \n \n \n \n \n {classes.map(cls => (\n \n \n \n \n \n ))}\n \n

ID	Name	Teacher
{cls.id}	{cls.name}	{cls.teacher}

\n );\n default:\n return (\n

School Dashboard 🏫

Welcome, {user.name}!

Total Students: {students.length}

Total Teachers: {teachers.length}

Total Classes: {classes.length}

\n );\n }\n };\n\n return (\n

School Management System

\n {user && (\n \n )}\n

\n {renderView()}\n

\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"School_Management_System\";\n const SCHEMA_VERSION = 4; // Increment for principal table\n\n // Initialize authentication tables\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_students_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n name TEXT NOT NULL,\n password TEXT NOT NULL,\n grade INTEGER NOT NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_teachers_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n name TEXT NOT NULL,\n password TEXT NOT NULL,\n department TEXT NOT NULL\n )\n `);\n\n // Renamed administrators table to principals\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_principals_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n name TEXT NOT NULL,\n password TEXT NOT NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_classes_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n teacher_id INTEGER,\n FOREIGN KEY(teacher_id) REFERENCES ${KEY}_teachers_${SCHEMA_VERSION}(id)\n )\n `);\n\n // Seed initial data with hashed passwords\n const studentsCount = (await sqlite.execute(`SELECT COUNT(*) as count FROM ${KEY}_students_${SCHEMA_VERSION}`)).rows[0].count;\n if (studentsCount === 0) {\n const studentPassword = await hashPassword('student123');\n await sqlite.execute(`\n INSERT INTO ${KEY}_students_${SCHEMA_VERSION} (username, name, password, grade) VALUES \n ('alice', 'Alice Johnson', '${studentPassword}', 10),\n ('bob', 'Bob Smith', '${studentPassword}', 11),\n ('charlie', 'Charlie Brown', '${studentPassword}', 9)\n `);\n }\n\n const teachersCount = (await sqlite.execute(`SELECT COUNT(*) as count FROM ${KEY}_teachers_${SCHEMA_VERSION}`)).rows[0].count;\n if (teachersCount === 0) {\n const teacherPassword = await hashPassword('teacher123');\n await sqlite.execute(`\n INSERT INTO ${KEY}_teachers_${SCHEMA_VERSION} (username, name, password, department) VALUES \n ('williams', 'Ms. Williams', '${teacherPassword}', 'Mathematics'),\n ('garcia', 'Mr. Garcia', '${teacherPassword}', 'Science'),\n ('lee', 'Mrs. Lee', '${teacherPassword}', 'English')\n `);\n }\n\n // Seed principal data\n const principalsCount = (await sqlite.execute(`SELECT COUNT(*) as count FROM ${KEY}_principals_${SCHEMA_VERSION}`)).rows[0].count;\n if (principalsCount === 0) {\n const principalPassword = await hashPassword('principal123');\n await sqlite.execute(`\n INSERT INTO ${KEY}_principals_${SCHEMA_VERSION} (username, name, password) VALUES \n ('principal', 'Dr. Smith', '${principalPassword}')\n `);\n }\n\n const classesCount = (await sqlite.execute(`SELECT COUNT(*) as count FROM ${KEY}_classes_${SCHEMA_VERSION}`)).rows[0].count;\n if (classesCount === 0) {\n await sqlite.execute(`\n INSERT INTO ${KEY}_classes_${SCHEMA_VERSION} (name, teacher_id) VALUES \n ('Algebra I', 1),\n ('Biology', 2),\n ('Literature', 3)\n `);\n }\n\n // Login route\n if (request.method === 'POST' && new URL(request.url).pathname === '/login') {\n const { username, password, type } = await request.json();\n \n let table, user;\n switch(type) {\n case 'student':\n table = `${KEY}_students_${SCHEMA_VERSION}`;\n break;\n case 'teacher':\n table = `${KEY}_teachers_${SCHEMA_VERSION}`;\n break;\n case 'principal':\n table = `${KEY}_principals_${SCHEMA_VERSION}`;\n break;\n default:\n return new Response(JSON.stringify({ success: false }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n const result = await sqlite.execute(`\n SELECT * FROM ${table} WHERE username = ?\n `, [username]);\n\n if (result.rows.length > 0) {\n user = result.rows[0];\n const isPasswordValid = await verifyPassword(password, user.password);\n \n if (isPasswordValid) {\n // Remove sensitive data\n delete user.password;\n return new Response(JSON.stringify({ \n success: true, \n user \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n return new Response(JSON.stringify({ \n success: false \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // Logout route\n if (request.method === 'POST' && new URL(request.url).pathname === '/logout') {\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n // Handle data request\n if (request.method === 'GET' && new URL(request.url).pathname === '/school-data') {\n const students = (await sqlite.execute(`SELECT id, username, name, grade FROM ${KEY}_students_${SCHEMA_VERSION}`)).rows;\n const teachers = (await sqlite.execute(`SELECT id, username, name, department FROM ${KEY}_teachers_${SCHEMA_VERSION}`)).rows;\n const classes = (await sqlite.execute(`\n SELECT c.id, c.name, t.name as teacher \n FROM ${KEY}_classes_${SCHEMA_VERSION} c \n JOIN ${KEY}_teachers_${SCHEMA_VERSION} t ON c.teacher_id = t.id\n `)).rows;\n\n return new Response(JSON.stringify({ students, teachers, classes }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n // Render HTML\n return new Response(`\n \n \n School Management System\n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\n// CSS remains the same\nconst css = `\nbody {\n font-family: Arial, sans-serif;\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n line-height: 1.6;\n}\nheader {\n background-color: #f4f4f4;\n padding: 10px;\n text-align: center;\n}\nnav {\n display: flex;\n justify-content: center;\n gap: 10px;\n margin-bottom: 20px;\n}\nbutton {\n padding: 5px 10px;\n cursor: pointer;\n}\ntable {\n width: 100%;\n border-collapse: collapse;\n}\nth, td {\n border: 1px solid #ddd;\n padding: 8px;\n text-align: left;\n}\nth {\n background-color: #f4f4f4;\n}\nfooter {\n margin-top: 20px;\n text-align: center;\n font-size: 0.8em;\n}\n.login-container {\n display: flex;\n justify-content: center;\n align-items: center;\n height: 400px;\n}\n.login-container form {\n display: flex;\n flex-direction: column;\n width: 300px;\n gap: 10px;\n}\n.error {\n color: red;\n text-align: center;\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/Alphydoo/School_Management_System/code/main.tsx","extension","actionData","errors"]

School Login 🏫

Students 👥

Teachers 👩‍🏫

Classes 📚

School Dashboard 🏫

Students 👥

My Profile 👤

Teachers 👩‍🏫

Classes 📚

School Dashboard 🏫