Hi Everyone!
I am developing my own on line travel agency that will work like an online shop just instead of buying products you would be able to book rooms in different hotels around Dalmatian coast.
As a shop base I am using osCommerce online shop which is fantastic stuff. The only thing that is missing for on-line travel agency to be fully functional is the booking rooms calendar integrated with products database tables.
I have managed to install osCommerce shop, added new rooms/apartments in database tables and have managed to integrate calendar view and booking form on the shopping_cart.php page. As a base for booking calendar I used open source booking calendar script from http://www.jjwdesign.com/booking_calendar.html
I am using only some parts of this calendar, which are displayed two months calendar that will show availability for every room in shopping cart, navigation - previous/next month and add booking form - book from date to date. - I have managed to do this part so far.
Now I need to rewrite database queries that will select products/rooms, available dates, display available and booked dates on the two months calendar view in sopping cart. Also, insert selected/booked dates into database accordingly.
I assume that the next thing that has to be done is to retouch the database tables so that tables booking tables are matching shop tables and then rewrite the queries This is where I am lost.
For the moment I am running everything locally as the hosting server I have at the moment does not allow me access to ini file.
If it would make our life easier i could upload some parts of the shop on that server or I can post you the script............
 |
