University Clearance System

University Clearance System

Tech Stack

Backend: Python 3, Flask

Database: MySQL (SQLAlchemy ORM + PyMySQL)

Frontend: Bootstrap 5, Jinja2, JavaScript

Authentication: Flask-Login

Notifications: VAPID / PyWebPush

Features

Role-Based Access Control (RBAC): (Student, Section Head, System Administrator).

Real-time Notifications (Web Push): Instant browser alerts when status updates occur.

Advanced Filtering System: Filter students and requests by College, Department, Stage, etc.

Excel Operations: Import students from Excel with automatic strong password generation.

Document Generation: Generate a printable clearance certificate upon approval.

Seamless User Experience: Interface supports Arabic (RTL) and is mobile-responsive.

Statistical Dashboard: Multi-dimensional charts displaying completion rates and department workload.