We intend to create small city-based hotel directory sites. This project is for the creation of a reusable script as we will be creating multiple websites that work in a similar manner.
Project scope: Create a database-powered website with admin backend in PHP/MySQL. Website will display hotels, landing pages about area attractions, and feature advanced Google Maps integration.
Finished site will be made up of a home page with two views (default & search view), hotel content pages & attraction content pages. Backend will allow admins to add/edit/delete hotel & attraction content. All hotel content pages will use the same format. All hotel content pages will use the same format – so there are essentially 3 templates for this site.
Google Maps integration as follows: when a new hotel is created, driving distance to each attraction will be calculated using the google maps API and this distance will be added to the database. Hotel detail pages will include a map centered on the hotel with markers for each of the attractions in the area. Attraction detail pages will include a map centered on the attraction with markers for each of the hotels in the area.
We will provide: XHTML & CSS for the layout, form actions for the different brands, FTP and cpanel access to our hosting server.
Deliverables: working script hosted on our server along with detailed instructions on replicating the script for additional websites.
*IF YOU HAVE A QUESTION, PLEASE POST TO PMB AND GET AN ANSWER FROM ME BEFORE YOU BID. IF YOU BID, I ASSUME THAT YOU UNDERSTAND THE PROJECT SCOPE 100%*
—
Admin
create pages (hotel content & attraction content pages)
set page filename, title, meta
(hotel)Set thumbnail
(hotel)Set rate
(hotel)Set booking brand & code
(hotel)Upload photos for photo gallery
(hotel)2 page copy fields (intro & detail)
(attraction) 1 copy field
—
Map / API Features
Map hotels & attractions, click to link to hotel or attraction page
Get driving distances between hotels & attractions, automatically add to database
Create maps for hotel pages & attraction pages
—
Home
See example here: http://hoteldevserver.com/temp/houston-portal/
Default view: Display 5 hotels with pagination to view the other hotels
sort list by price or hotel name
Dropdown – query list of attractions
Search view: Display 5 closest properties by distance to attraction as selected in dropdown
—
Hotel content page
See example here: http://hoteldevserver.com/temp/houston-portal/interior.html
(Google map will be below the 2nd content field)
Database field for this page include:
-Hotel Name
-Hotel Address
-Hotel Thumbnail
-Hotel photos (for lightbox-style gallery)
-Hotel brand
-hotel booking code
-Intro text field
-Detail text field
—
Attraction content page
Same basic layout as hotel content page, but will have only one content field and no booking or photo gallery
Database fields for this page include:
-Attraction name
-Attraction address
-Attraction thumbnail
-Detail text field
