This is a joomla and google maps project:
We are developing a joomla based website for a company that has many offices in different cities around the world.
We need a google maps component which let me see all the offices of this company, following the requeriments:
- the list of these offices are in table of a MYSQL database different to the joomla´s one. So the component must take this list from the table and show it in a datagrid and also located in the map, this list must be filtered by country and city. Countries and cities are Ajax chained selects and they are also in tables of the database.
The search must be done using coordinates if this field isn’t null or address if there are not coordinates. (there are places where searching by address doesn’t work well, so we need coordinates. finding coordinates from address: [url removed, login to view])
- the table has the fields: id, country, city, zone, name, address, telephone, postcode, coordinates
country: United Kingdom
zone: Elephant and castle
address: 92a Walworth Road
Postcode: SE1 6SW
Coordinates: [url removed, login to view],[url removed, login to view]
note: all fields are strings.
- the user must be able to search a city or a zone inside a city, and zoom in the map into that place, and the map must show the offices in the city or zone entered
- if you click an item of the list that it’s being shown this must appear located in the map.
- It must be possible to configure in the admin the database, that is going to be the component conected. this included the setup of the name of the db, user, password.
- The size of the map must be configurable
- Edit the tittle of the component.