50% Project Completed Already
Need SQL query built within Listings theme to compare the latitude / longitude markers of a dropdown of custom field zip codes that is setup already within Listing's backend. It searches this already by default but we need to it also in addition, compare the address of each post also and if their latitude/longitude markers are within the radius then it will put them into the SQL results query.
So what we already have is this:
1) Radius selector on search form to choose between 1-5000 radius distance
2) functions are placed to connect with google geo location api and pull location and latitude/longitude markers for the zip code selection searched
1) When you select a zip code custom field, it actually only sets the field_2 (thats the field name) as the line # that the item selection is on , so for example if i selected the 4th zip code in the list it wont show up as field_2=zipcode but will show up in the results query as field_2=4 .. we need it to show the label text of the selection instead of the number that the selection is on within the dropdown list.
2) It isn't comparing for posts within the radius of the field_2 zip code selection. It needs to be able to connect to the right post systems (we'll specify) and compare these as well as it's normal search functions which are already in place and work 100%
Will provide more information as bids are made
5 freelancers are bidding on average $175 for this job
Hi, We are pleasure to bid on your project. We have enough source and infrastructure for working 10 employees. We will deliver the project with cent percentage satisfactions to you.