This is our first project on Freelances, so not really sure how many project details do we have to provide at this point.
The project is about optimizing/recreating our booking engine search. It is basically a complex search that would search approx 20 sql tables and retrieve list of available hotel rooms and do the following
- filter availability
- filter occupied dates
- calculate surcharges
- calculated discounts
- calculate child discounts
- calculate special deals
- calculate taxes
- return detailed price calculation
Search should be optimized for good perfomance, and should not use loops or any other high resource consuming techniques.
If interested I would send a sketch and detailed specification of sql tables.