Closed

Woothemes Listings Theme Modifications

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

ISSUES:

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

Thanks

Skills: MySQL, PHP, SQL, WordPress

See more: woothemes listings zipcode, woothemes listings code, woothemes sql, woothemes listings zipcode search, listings theme radius search, woothemes listings, need put label, longitude, listings, setup geo, distance zip code, google api zipcode, dropdown search form, location zip code, php form dropdown list, custom modifications, geo name, field addition, selector php, select dropdown, distance search, php selector, modifications theme, google zipcode, custom search api php

About the Employer:
( 9 reviews ) Tampa, United States

Project ID: #1137721

5 freelancers are bidding on average $175 for this job

vigentocommerce

As disscuss. ^^

$135 USD in 3 days
(108 Reviews)
7.6
rosew100

Please check PM

$221 USD in 2 days
(96 Reviews)
6.8
webqueue

We are sincerely read your requirements and are ready to endow with the solution as per your requirement.We can assure you that with the help of expert development team,we will provide you high level of satisfaction an More

$250 USD in 10 days
(93 Reviews)
6.8
Dream9891

I can do it. Please check your PM. Thank you. Regards.

$50 USD in 1 day
(1 Review)
0.0
vikkuinfotech

I able to done this project.

$150 USD in 4 days
(0 Reviews)
0.0
balsmca

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.

$120 USD in 2 days
(1 Review)
0.0