OfficeHourApp
We developed a Flask web application that provides a queueing system for officehours. The purpose is to simplify the chaos of waiting during commonly packed office hours
Lastest Demo!
(TA account- Username: admin Password: default/Student account-any other combination)
Fork at:
https://github.com/nexusapoorvacus/OHAppHack_NoAutoRefresh
Chapter 1: Django at CSUA
- We tried to use Django to get the prototype done during the CSUA hackathon. But we got stuck on how to implementing functional "delete" button with Django. We found the tutorial of Django too much time consuming. As a sad ending, this attempt failed.
Chapter 2: Exploration
- We turned to our godlike TA Andrew Huang and got some Awesome ideas including the TA(God) mode.
- Exploration Week(10.19-10.26):
- Finally, we decided to use Flask
Chapter 3: OfficeHour Prototype1
- We got the first prototype working during the H@B: Bearhack.
- Outlines
- Able to enter name, category, description
- Entries in database shown on the website
- TA view - sort by time/category
- General and specific delete buttons on every entry
- Demo (Click on the picture)
Chapter 4: Prototype2
- Two different login systems: TA/Students (implemented by Apoorva Dornadula)
- TA can reorder entries by dragging and dropping (implemented by me)
- Limit students' permission: Each student can only delete his/her own entry
- Reward system: "Helped by peer" will promote the student helping
- Time stamp for each entry
- Demo (Click on the picture)
TA view (Username: admin Password: defalt) 
Student view (Any other combination) 
Chapter 5: Bootstrap it!
- Used Twitter Boostrap to improve the user interface.
- Demo (Click on the picture)
TA view (Username: admin Password: defalt) 
Student view (Any other combination) 
Chapter bonus: Miscellaneous
Bugs need fixing
- A safer session management
- Autorefreshing
- Edit function
- "Delete" jumps to the head of page, not very convenient
- Better "sort by category"
Trouble and shooting
- T: After not using for a long time, we get error about database when we attempt to run python flaskr.py
S: run python in terminal, do following:
>>> from flaskr import init_db
>>> init_db()
Big thanks to collaborators
- Andrew Huang
- Apoorva Dornadula :)
- Kay Toma :)
- Selena Shang
- Michelle Chang