Google Map Local Club finder - PHP and MySQL back end
- or -
Post a project like this2932
£100(approx. $125)
- Posted:
- Proposals: 2
- Remote
- #1104644
- Awarded
Description
Experience Level: Intermediate
General information for the website: Website is for the small (micro?) national association. We want users to be able to find their local club, or list their local club.
Description of requirements/features: Google Map of UK where people can see the following pins on a map:
Clubs - Blue Pin
Events - Red Pin
Proposed club - Yellow Pin
Interested flyer - Green Pin
When the user hovers over the pin on the map they can see more details of the club/ event/ proposed club/ interested flyer.
They can filter the results so as to only see the types of pins they want (Clubs/ Event/ Proposed Clubs/ Interested Flyers - any combination of these is possible). They can also filter so that only events in the future can be seen, or all events, or events in the next month.
For clubs the pin will be blue and details will be:
Name: (Text)
Place: (Text)
Usual Times/ Day: (Text)
Website:
Message:
If it's an event then the pin will be red and the details will be:
Name: (Text)
Place: (Text)
Time/ Date: (Text)
Website:
Message:
If it's a proposed club then the pin will be yellow and the details will be:
Name: (Text)
Proposed Area: (Text)
Website:
Message:
If it's an interested flyer the pin will be green and the details will be:
Name: (Text)
Area: (Text)
Message:
When the user clicks on one of the "Reveal" links the system will do the following:
Log that this entry was accessed, including the IP/ cookie
Check that this IP/ cookie has not already accessed more than five records today (we do not want other parties harvesting every entry from our database).
If the user has already accessed five today show the message "Sorry - you have reached your daily lookup/ message limit", otherwise show the information.
When the user clicks "Send message" do exactly the same as above but if the limit has not been reached take the user to a message form with the following fields:
Name: (Text)
Message: (Text)
The user can then fill in this form and press submit and a message is sent to the other party. The other party will receive an email with the subject "New message from " (Website name to be revealed in private message, not for Google to index on PPH) and the body of the message will be included in the body of the email. The message will also be stored in the database (the body, the name (from name), the to name and the date and time).
Only five records or messages can be sent per user per day.
CMS and Admin requirements: Adding new pins. To add a new pin (either a club, event, proposed club or interested flyer), the user can click on the place on the map and then click "List Club" or "List Event" or "List Proposed Club" or "List Interested Flyer").
The user will then be taken to a form with the corresponding fields.
For a club:
Name: (Text)
Place: (Text)
Usual Times/ Day: (Text)
Website: (Text)
Email address: (Text)
For an event:
Name: (Text)
Place: (Text)
Time/ Date: (Text)
Website: (Text)
Email: (Text)
For a proposed club:
Name: (Text)
Proposed Area: (Text)
Website: (Text)
Email: (Text)
For an interested flyer:
Name: (Text)
Area: (Text)
Email: (Text)
No HTML links should be allowed in any of the fields except website (which will not be a link per se, it will be a URL in plain text which the system will present as a link after the user presses "Reveal").
The website field is not mandatory and the user can leave this blank (if they don’t yet have a website).
Extra notes:
Description of requirements/features: Google Map of UK where people can see the following pins on a map:
Clubs - Blue Pin
Events - Red Pin
Proposed club - Yellow Pin
Interested flyer - Green Pin
When the user hovers over the pin on the map they can see more details of the club/ event/ proposed club/ interested flyer.
They can filter the results so as to only see the types of pins they want (Clubs/ Event/ Proposed Clubs/ Interested Flyers - any combination of these is possible). They can also filter so that only events in the future can be seen, or all events, or events in the next month.
For clubs the pin will be blue and details will be:
Name: (Text)
Place: (Text)
Usual Times/ Day: (Text)
Website:
Message:
If it's an event then the pin will be red and the details will be:
Name: (Text)
Place: (Text)
Time/ Date: (Text)
Website:
Message:
If it's a proposed club then the pin will be yellow and the details will be:
Name: (Text)
Proposed Area: (Text)
Website:
Message:
If it's an interested flyer the pin will be green and the details will be:
Name: (Text)
Area: (Text)
Message:
When the user clicks on one of the "Reveal" links the system will do the following:
Log that this entry was accessed, including the IP/ cookie
Check that this IP/ cookie has not already accessed more than five records today (we do not want other parties harvesting every entry from our database).
If the user has already accessed five today show the message "Sorry - you have reached your daily lookup/ message limit", otherwise show the information.
When the user clicks "Send message" do exactly the same as above but if the limit has not been reached take the user to a message form with the following fields:
Name: (Text)
Message: (Text)
The user can then fill in this form and press submit and a message is sent to the other party. The other party will receive an email with the subject "New message from " (Website name to be revealed in private message, not for Google to index on PPH) and the body of the message will be included in the body of the email. The message will also be stored in the database (the body, the name (from name), the to name and the date and time).
Only five records or messages can be sent per user per day.
CMS and Admin requirements: Adding new pins. To add a new pin (either a club, event, proposed club or interested flyer), the user can click on the place on the map and then click "List Club" or "List Event" or "List Proposed Club" or "List Interested Flyer").
The user will then be taken to a form with the corresponding fields.
For a club:
Name: (Text)
Place: (Text)
Usual Times/ Day: (Text)
Website: (Text)
Email address: (Text)
For an event:
Name: (Text)
Place: (Text)
Time/ Date: (Text)
Website: (Text)
Email: (Text)
For a proposed club:
Name: (Text)
Proposed Area: (Text)
Website: (Text)
Email: (Text)
For an interested flyer:
Name: (Text)
Area: (Text)
Email: (Text)
No HTML links should be allowed in any of the fields except website (which will not be a link per se, it will be a URL in plain text which the system will present as a link after the user presses "Reveal").
The website field is not mandatory and the user can leave this blank (if they don’t yet have a website).
Extra notes:
Simon D.
100% (28)Projects Completed
51
Freelancers worked with
34
Projects awarded
24%
Last project
1 Mar 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies