How chetangawali/collegecomplaint works
This is a Flask college complaint portal. Users register or log in, submit categorized complaints, and review their complaint history; administrators log in, review complaints, and update their status and reply. The routes and SQL operations are in app.py, with database connection setup in database.py and page rendering through templates. The tree and sampled source support these workflows; no README documentation or template contents were provided, so template styling and any additional behavior are not inferred.
Main entry points: database.py Connection setup · app.py Complaint review · index.html Home page · register.html Register page
Components 18
Public access
- Home page
templates/index.html
User workflow
- Registration
app.py - Register page
templates/register.html - User login
app.py - Login page
templates/login.html - Complaint submission
app.py - Submission form
templates/submit_complaint.html - User dashboard
app.py - Complaint history
templates/dashboard.html
Admin workflow
- Admin login
app.py - Admin login page
templates/admin_login.html - Complaint review
app.py - Admin dashboard
templates/admin_dashboard.html
Runtime and data
- Connection setup
database.py - MySQL database
Other components
- Visitor
- User
- Administrator
Connections 30
- Visitor → Home page: requests page
- Home page → Visitor: renders
- User → Registration: submits details
- Registration → Register page: renders
- Registration → Connection setup: opens connection
- Registration → MySQL database: inserts user
- User → User login: submits credentials
- User login → Login page: renders
- User login → Connection setup: opens connection
- User login → MySQL database: checks credentials
- User → Complaint submission: submits complaint
- Complaint submission → Submission form: renders
- Complaint submission → Connection setup: opens connection
- Complaint submission → MySQL database: reads categories
- Complaint submission → MySQL database: inserts complaint
- User → User dashboard: requests history
- User dashboard → Connection setup: opens connection
- User dashboard → MySQL database: reads user complaints
- User dashboard → Complaint history: renders history
- Administrator → Admin login: submits credentials
- Admin login → Admin login page: renders
- Admin login → Connection setup: opens connection
- Admin login → MySQL database: checks credentials
- Administrator → Complaint review: requests review
- Complaint review → Connection setup: opens connection
- Complaint review → MySQL database: reads complaints
- Complaint review → Admin dashboard: renders review
- Administrator → Complaint review: submits update
- Complaint review → MySQL database: updates complaint
- Connection setup → MySQL database: connects