Overview #
This project is a capstone system developed for the Gensan Youth Orchestra and Choir Corporation (GYOCC), an arts and music organization based in General Santos City. The goal was to digitize their operations by building a centralized web platform for handling ticket sales, event bookings, music lesson scheduling, and report generation.
The system is built with Django, PostgreSQL, and deployed via Hostinger VPS. It includes real-time booking, secure payments, two-factor authentication, calendar management, and internal messaging.
My Role #
As part of a 4-member team, I was primarily responsible for:
- Designing the lesson scheduling and resource borrowing logic
- Building the 2FA ticket validation system
- Developing dynamic reports and CSV analytics exports
- Handling backend API integration with payment gateways
- Writing technical documentation and deployment scripts
Key Features #
- ✅ Online Ticketing with secure QR codes and 2FA validation
- 🎯 Booking System for concerts, private events, and student lessons
- 📚 Lesson Scheduling by instrument, instructor, and availability
- 📊 Analytics Dashboard with event stats, attendance, and payment logs
- 🔐 User Roles & Permissions: Admin, Instructor, Organizer, Member
- 📦 Resource + Repertoire Management: Borrow instruments, access learning materials
- 🔔 Notifications & Messaging + optional email subscriptions
Technical Stack #
- Frontend: HTML, CSS, Bootstrap, Figma (design)
- Backend: Python, Django (w/ Class-Based Views & DRF)
- Database: PostgreSQL with pgAdmin
- Deployment: Hostinger VPS (Apache2 + Django)
- Version Control: GitHub
- Authentication: JWT + OTP (email/SMS 2FA)
Challenges & Solutions #
-
🛠 Lesson Overlaps
Developed custom scheduling logic to detect & prevent double-booking between lessons and events using Django signals and cron-like schedule validators. -
🔐 Secure Ticket Validation
Built a 2FA ticketing system using OTP verification and QR codes scanned at the venue — integrated with user-specific authentication. -
📈 Real-Time Reports
Implemented downloadable CSV analytics for bookings, payments, and attendance — filtered by event, month, or date range.
Outcome #
The system was tested by actual GYOCC members and staff through alpha testing.
✅ Result: High satisfaction for ease of use, booking speed, and accessibility.
📉 Reduced manual workload for event scheduling by over 80%.
What I Learned #
- Real-world stakeholder communication with a live organization
- Working in a full-stack Django architecture under deadlines
- Handling edge cases in time-sensitive user features like scheduling and payment confirmation
- Importance of modular backend structure for scaling new features
Methodology ℹ️ #
We adopted the Inverted Spiral Model as our system development life cycle. This model allowed us to iteratively develop, test, and refine core modules while managing risks at every phase. It emphasized continuous consultation with our capstone adviser and host organization, making it ideal for a project that required real-time feedback, evolving user needs, and phased rollouts like booking, ticketing, and lesson scheduling.
Showcase 📸 #
Homepage #
Staff Page #
Dashboard #
Payment Sample #
Payment Success - Maya’s End #
Payment Sample - Web App’s End #
Alpha Testing 🧪 #
We conducted alpha testing with actual members, instructors, and staff of the Gensan Youth Orchestra and Choir Corporation. Testers were invited to register, explore features such as booking, ticketing, and lesson scheduling, and provide structured feedback through evaluation forms. The results showed high user satisfaction, particularly in ease of navigation and reduced booking friction. Their feedback directly informed final adjustments before the system’s completion and presentation.
Certifications ✔️ #
Final Thoughts 💭 #
This project was more than just a system build — it was a hands-on experience in real-world software development, from problem analysis to deployment and testing. Working with a live organization like GYOCC taught us the importance of user-centric design, stakeholder collaboration, and agile iteration. The system we delivered not only improved their operations but gave us a deeper understanding of how technology can empower local arts and culture.
💬 Want to know more about this project? Feel free to contact me or request access to the private GitHub repo.
Paper Document #
You can download the soft copy of our capstone document by clicking here.