This is for the creation of a database-driven site which will be a directory of hotels, restaurants, clubs and attractions. Each database will have information about the place; for example restaurants will include cuisine type and menu links, and hotels will include prices, ammenities and other information. Each of these categories will have a different template and database that they pull data from; I wish to use Smarty Template Engine or a similar system. We must be able to add pictures with captions for each restaurant, hotel, club or atraction - this
There also must be a search system for each of the categories which lets the user search based on the different database entries; some entries in the database will be text, others will be numbers, others with be Yes/No.
I have an excel spreadsheet which will provide the initial information for the databases. Through the admin panel I must be able to add more categories to the database, and edit information about the restaurants, hotels, clubs and attractions.
There must also be the ability for the admin to assign a username and password to a restaurant, hotel, club or atraction so that they can edit the information listed in the database only regarding their restaurant, hotel, club or atraction.
We will also want integration with Google Maps so that all hotels, restaurants, clubs and attractions will be viewable on a map, with their names and links the hotels, restaurants, clubs or attractions page in our website.