Event ticketing system
Budget: $500 – $2,000 USD
Back-End
Written in Node + Express
Secure connection to Relational Database (MySQL or Oracle)
Script to create database + tables and fill catalog tables
Users registration with roles
Login + encrypted token
Secure routes + functionality for the app described below
Web App
Written in React
Logo and navigation bar (different for users with admin role)
RESTful
All texts and labels should be in English
Easy way for us to translate to a 2nd language (and select which one to use)
Login + Sign up (with captcha)
Security in conjunction with back-end (token + session + roles)
Admin Panel
Creation and edition of Venues
Creation and edition of Layouts
Linked to a Venue
Inclusion of an image with the map (for now static)
Zones (e.g. VIP, Gold, etc.) + Areas per Zone (e.g. 102, 103...) + Rows per area (e.g. A, B, C...) + Seats per row (1, 2, 3...)
Creation and edition of Events
Linked to a Venue + Layout
Reservation of specific seats as Complimentary
Way to download these tickets as pdf
Zone + Area + Rows + Seat should be part of the name of the file
Publish (visible to users)
Queries/Reports
Tickets sold for an event ($ by zone)
Separate columns for complimentary vs sold
Totals
Chart showing sales by date (since the event is published)
User Page
Home page with list of active/published events
Option to find available seats
Map is visible on the side
Criteria by zone, area
Selection of number of tickets (up to 4 per purchase)
Purchase Option
Connection to PayU for payment
https://developers.payu.com/en/restapi.html
Temporary lock of seats while paying (with visible timeout)
On successful payment:
Mark seats as sold
Generate tickets in PDF (with QR and security code(s), so they cannot be generated by malicious users)
Send to user's email
Landing screen showing transaction id + explaining their tickets will arrive in their email, etc.
Contact option for problems with purchases
Written in Node + Express
Secure connection to Relational Database (MySQL or Oracle)
Script to create database + tables and fill catalog tables
Users registration with roles
Login + encrypted token
Secure routes + functionality for the app described below
Web App
Written in React
Logo and navigation bar (different for users with admin role)
RESTful
All texts and labels should be in English
Easy way for us to translate to a 2nd language (and select which one to use)
Login + Sign up (with captcha)
Security in conjunction with back-end (token + session + roles)
Admin Panel
Creation and edition of Venues
Creation and edition of Layouts
Linked to a Venue
Inclusion of an image with the map (for now static)
Zones (e.g. VIP, Gold, etc.) + Areas per Zone (e.g. 102, 103...) + Rows per area (e.g. A, B, C...) + Seats per row (1, 2, 3...)
Creation and edition of Events
Linked to a Venue + Layout
Reservation of specific seats as Complimentary
Way to download these tickets as pdf
Zone + Area + Rows + Seat should be part of the name of the file
Publish (visible to users)
Queries/Reports
Tickets sold for an event ($ by zone)
Separate columns for complimentary vs sold
Totals
Chart showing sales by date (since the event is published)
User Page
Home page with list of active/published events
Option to find available seats
Map is visible on the side
Criteria by zone, area
Selection of number of tickets (up to 4 per purchase)
Purchase Option
Connection to PayU for payment
https://developers.payu.com/en/restapi.html
Temporary lock of seats while paying (with visible timeout)
On successful payment:
Mark seats as sold
Generate tickets in PDF (with QR and security code(s), so they cannot be generated by malicious users)
Send to user's email
Landing screen showing transaction id + explaining their tickets will arrive in their email, etc.
Contact option for problems with purchases