My budget is Rs. 20,000. I might be able to stretch it a little if I feel you are adding super value.
We are looking at a slot booking system. This is based in India so the SMS and Payment gateway integrations mainly need to be done for India. However, the Paypal gateway needs to be integrated as well for international customers. This needs to be linked to a wordpress site eventually.
1. There should be a calendar of the current month which shows up like in the following link:
[login to view URL]
2. There must be 3 dropdowns which must reload the calendar: City, Venue, Game, Pitch
3. Once you click on a date it must take you into a page with all the available slots in 30 min intervals.
12:00am-12:30am,12:30am-1:00am,6:00am-6:30am....(all slots between that).... 11:30pm-12:00am
4. Validation: Minimum 1 hour must be blocked. Only adjacent booking slots can be selected. For eg. 7:00-7:30, 7:30-8:00, 8:00-8:30 is correct. 7:00-7:30, 7:30-8:00, 10:30-11:00 is incorrect. The play time must be continuous
5. All payments will be accepted in INR for Indian customers and USD for international customers
6. On Selection of slots, the user must enter the following details before proceeding:
- First Name
- Last Name
- Date of Birth
- Email
- Country
- Mobile Number
- Additional remarks
7. On submission, the details entered by the user must be saved to the database and must be available to view and download from the Admin. These details must be stored for both Failed and Successful transactions.
8. Failed transaction - An email must be sent to the id letting them know that the transaction failed and they should try again. Also an SMS must be sent stating that the booking failed.
9. Successful transaction - An email must be sent to the id letting them know that the booking has been confirmed and the invoice must be sent as well. Also an SMS must be sent stating that the booking has been confirmed.
Slot Mechanism:
A) Frontend
1. Available slots must be shown in Black and a user should be able to check a box to select it.
2. The unavailable slots must be shown in Red and must be disabled.
B) Admin
1. The Admin must be able to define the Slots under various profiles.
- Default weekdays: Define Slots, Slot pricing, Enable/Disable certain slots.
- Default weekends: Define Slots, Slot pricing, Enable/Disable certain slots.
- Special schedule 1: In addition to slots, pricing and enable/disable, this will have a set of dates which can be selected for applying this price schedule.
- Special schedule 2: In addition to slots, pricing and enable/disable, this will have a set of dates which can be selected for applying this price schedule.
- Special schedule 3: In addition to slots, pricing and enable/disable, this will have a set of dates which can be selected for applying this price schedule.
2. The Admin user must be able to make offline bookings through the backend. It should go in as an offline transaction and must reflect in the database accordingly.
3. There should be a mechanism of creating Discount coupons with a set percentage. When applied, the users should get that discount. This must also be stored in the database for each transaction.
4. A detailed view must be available with all bookings made and the status.
5. These detailed view must have filters: Serach by name, City, Venue, Pitch, Order status, Search between dates
** It will be a big plus if there can be some kind of graphs which can be plotted. But this is not a must
6. There should be an option to download the filtered results in excel format.
7. There must be an option to edit records through the Admin.
** Very good email sending is required. Every time a user completes an order an email must be sent to him/her and a the invoice must also be sent.
Payment gateway Integrations:
Integrate with Payu(India) for payments
Integrate with Paypal for international payments
SMS Gateway integration:
Integrate with an SMS gateway.