🎓 ICCT SmartCampus Portal

A production-ready full-stack school management system combining a Learning Management System (LMS) and Student Information System (SIS) for ICCT Colleges.

---

📋 Table of Contents

• Features
• Tech Stack
• Project Structure
• Getting Started
• Default Accounts
• API Documentation
• Deployment
• Screenshots

---

✨ Features

🌐 Public Website

• Home, About, Contact, FAQ, Privacy, Terms pages
• News & Announcements feed
• Newsletter subscription
• Search bar with auto-suggest
• System Status page
• Help Center / Knowledge Base
• Custom 404 page
• Fully responsive (mobile, tablet, desktop)

👨‍🎓 Student Portal

• Dashboard with schedule, grades, and announcements
• View prelim/midterm/final grades with equivalency
• Weekly class schedule viewer
• Access and download course learning materials
• Edit personal profile

👨‍🏫 Faculty Portal

• View assigned course sections and class rosters
• Encode and submit student grades online
• Upload and manage course learning materials per section
• View teaching schedule

🛠️ Admin Portal

• System dashboard with live statistics and charts
• User management (approve, suspend, delete accounts)
• Course and section management (CRUD)
• Create and publish announcements
• Finalize submitted grades
• Trigger manual or review automated backups
• Full audit log

🔒 Security

• bcrypt password hashing (12 salt rounds)
• JWT access + refresh token authentication
• Role-based access control (Student / Faculty / Admin / Super Admin)
• Helmet.js HTTP security headers
• Rate limiting (100 req/15min)
• Input validation and XSS sanitization

💾 Automated Backup System

• Daily automated PostgreSQL dump (2:00 AM Asia/Manila)
• C++ microservice encrypts backup file using AES-256-CBC
• Encrypted file uploaded to Google Drive via API
• Backup status logged to database

---

🛠 Tech Stack

Layer	Technology
Frontend	React 18 + Vite + Tailwind CSS
Backend	Node.js 20 + Express 4
Database	PostgreSQL 15
Auth	JWT (access + refresh) + bcrypt
C++ Service	AES-256 encryption microservice
File Storage	Local + Google Drive (backups)
Deployment	Vercel / Railway / Supabase

---

📁 Project Structure

smartcampus-portal/
├── frontend/                   # React + Vite app
│   ├── src/
│   │   ├── components/
│   │   │   └── layout/        # Navbar, Footer, PortalLayout, PublicLayout
│   │   ├── context/           # AuthContext (JWT state)
│   │   ├── pages/
│   │   │   ├── auth/          # Login, Register
│   │   │   ├── public/        # Home, About, Contact, FAQ, etc.
│   │   │   └── portal/
│   │   │       ├── student/   # Dashboard, Grades, Schedule, Materials
│   │   │       ├── faculty/   # Dashboard, Grades encoder, Materials
│   │   │       └── admin/     # Dashboard, Users, Courses, Backup
│   │   ├── styles/            # Tailwind + custom CSS
│   │   └── utils/             # Axios API client with auto-refresh
│   └── package.json
│
├── backend/                    # Node.js + Express API
│   ├── src/
│   │   ├── config/            # PostgreSQL pool
│   │   ├── controllers/       # 11 controllers
│   │   ├── middleware/        # Auth, validation, upload
│   │   ├── routes/            # 12 route files
│   │   ├── services/          # Backup, Scheduler
│   │   └── utils/             # API response helpers, logger
│   └── package.json
│
├── cpp-service/                # C++ AES-256 microservice
│   ├── src/main.cpp
│   ├── CMakeLists.txt
│   └── Dockerfile
│
├── database/
│   ├── migrations/            # 001_initial_schema.sql (16 tables)
│   └── seeds/                 # 001_seed_data.sql (demo data)
│
├── docs/
│   ├── srs/                   # Software Requirements Specification
│   ├── api/                   # REST API Documentation (45+ endpoints)
│   └── DEPLOYMENT_GUIDE.md
│
└── deployment/
    └── docker-compose.yml

---

🚀 Getting Started

Prerequisites

• Node.js 18+
• PostgreSQL 15+
• Git

1. Clone the repository

git clone https://github.com/YOUR_USERNAME/smartcampus-portal.git
cd smartcampus-portal

2. Set up the database

psql -U postgres -c "CREATE DATABASE smartcampus_db;"
psql -U postgres -d smartcampus_db -f database/migrations/001_initial_schema.sql
psql -U postgres -d smartcampus_db -f database/seeds/001_seed_data.sql

3. Configure the backend

cd backend
cp .env.example .env

Edit .env and fill in your values:

DB_HOST=localhost
DB_PORT=5432
DB_NAME=smartcampus_db
DB_USER=postgres
DB_PASSWORD=your_password
JWT_SECRET=your_secret_key_here
JWT_REFRESH_SECRET=your_refresh_secret_here

4. Install and run the backend

cd backend
npm install
npm run dev
# → API running at http://localhost:5000

5. Install and run the frontend

cd frontend
npm install
npm run dev
# → App running at http://localhost:5173

Open http://localhost:5173 in your browser.

---

🔑 Default Accounts

These are seed data accounts for testing. Change all passwords in production.

Role	Email	Password
Super Admin	superadmin@icctsmartcampus.edu.ph	SmartCampus@2024!
Admin	admin@icctsmartcampus.edu.ph	SmartCampus@2024!
Faculty	jdela.cruz@icctsmartcampus.edu.ph	SmartCampus@2024!
Student	student1@gmail.com	SmartCampus@2024!
Student	student2@gmail.com	SmartCampus@2024!

---

📡 API Documentation

Base URL: http://localhost:5000/api

Method	Endpoint	Description
POST	/auth/register	Register new account
POST	/auth/login	Login and receive tokens
POST	/auth/refresh	Refresh access token
GET	/auth/me	Get current user profile
GET	/students	List all students (Admin/Faculty)
GET	/students/:id	Get student by ID
PUT	/students/:id	Update student profile
GET	/students/:id/grades	Get student grades
GET	/students/:id/schedule	Get student schedule
GET	/faculty	List all faculty (Admin)
GET	/courses	List all courses
POST	/courses	Create course (Admin)
POST	/enrollments	Enroll student in section
POST	/grades	Submit grades (Faculty)
GET	/grades/:studentId	Get grades by student
GET	/announcements	List public announcements
POST	/announcements	Create announcement
GET	/notifications	Get user notifications
PUT	/notifications/read-all	Mark all as read
GET	/materials/section/:id	Get materials for section
POST	/materials	Upload material (Faculty)
POST	/newsletter/subscribe	Subscribe to newsletter
GET	/admin/dashboard	Admin statistics
GET	/admin/users	List all users
PUT	/admin/users/:id/status	Update user status
POST	/backup/run	Trigger manual backup

Full API docs: docs/api/API_DOCUMENTATION.md

---

☁️ Deployment

Service	Platform
Frontend	Vercel
Backend	Railway
Database	Supabase
C++ Service	Railway (Docker)
Backups	Google Drive API

See full instructions: docs/DEPLOYMENT_GUIDE.md

---

🏗️ C++ Microservice

The cpp-service/ directory contains a standalone HTTP server written in C++ that handles AES-256-CBC file encryption for database backups.

# Build (Linux/macOS/WSL)
cd cpp-service
g++ -std=c++17 -O2 -o smartcampus-service src/main.cpp -lssl -lcrypto -lpthread

# Run
./smartcampus-service 8080

The Node.js backend calls this service automatically during backup. If unavailable, it falls back to uploading the unencrypted dump.

---

📄 License

This project is licensed under the MIT License — see LICENSE for details.

---

👥 Authors

Built as a capstone-level school portal project for ICCT Colleges.

---

Keywords: school portal, student information system, learning management system, LMS, SIS, React, Node.js, PostgreSQL, Express, Tailwind CSS, school management system, academic portal, ICCT, Philippines