WordPress.org
Get WordPress

Plugin Directory

Changeset 2008370


Ignore:
Timestamp:
01/08/2019 11:24:27 AM (7 years ago)
Author:
ajaylulia
Message:

Location Search Bug Fix

File:
1 edited

Legend:

Unmodified
Added
Removed

  • jsp-store-locator/trunk/public/class_jsp_store_locator_public.php

    r2008314 r2008370  
    626626        global $wpdb;
    627627 
    628         $searchquery = $data['zipsearch'];
     628        $searchquery = urlencode($data);
    629629 
    630630        if($searchquery!=''){
    631             $config = $this->getConfig();
     631            $config = $this->jspsl_getConfig();
    632632            $GoogleAPI = $config[0]->GOOGLE_MAP_KEY;
    633633 
    634634         /** If Yahoo API Doesn't return any result then search by Google API **/
    635635 
    636            $url = 'https://maps.googleapis.com/maps/api/geocode/json?address='.$searchquery.'&key=$GoogleAPI';
     636           $url = 'https://maps.googleapis.com/maps/api/geocode/json?address='.$searchquery.'&key='.$GoogleAPI;
    637637            $output = json_decode(file_get_contents($url));
    638  
     638            
    639639            if($output->status == 'OK'){
    640640            $lat = $output->results[0]->geometry->location->lat;
    … …  
    649649 
    650650            if($search_radius == 0){
    651             $distance = $this->haversineGreatCircleDistance($latfrom,$longfrom,$latto,$longto,$earthRadius = 3959);
     651            $distance = $this->jspsl_haversineGreatCircleDistance($latfrom,$longfrom,$latto,$longto,$earthRadius = 3959);
    652652            $radius = $distance;
    653653 
    … …  
    657657            }
    658658 
    659             $query="SELECT ".JSPPREFIX."stores.*, IFNULL(( 6371* acos( cos( radians('37.09024') ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians('-95.712891') ) + sin( radians('37.09024') ) * sin( radians( latitude ) ) ) ),0) As distance FROM ".JSPPREFIX."stores WHERE (((ACOS( SIN(RADIANS($lat)) * SIN(RADIANS(".JSPPREFIX."stores.latitude)) + COS(RADIANS($lat)) * COS(RADIANS(".JSPPREFIX."stores.latitude)) * COS(RADIANS(".JSPPREFIX."stores.longitude) - RADIANS($long)) ) * 3963.1676) <= $radius) OR (".JSPPREFIX."stores.latitude = $lat AND ".JSPPREFIX."stores.longitude = $long)) ORDER BY distance ASC";
     659            $query="SELECT ".JSPSL_DB_PREFIX."stores.*, IFNULL(( 6371* acos( cos( radians('37.09024') ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians('-95.712891') ) + sin( radians('37.09024') ) * sin( radians( latitude ) ) ) ),0) As distance FROM ".JSPSL_DB_PREFIX."stores WHERE (((ACOS( SIN(RADIANS($lat)) * SIN(RADIANS(".JSPSL_DB_PREFIX."stores.latitude)) + COS(RADIANS($lat)) * COS(RADIANS(".JSPSL_DB_PREFIX."stores.latitude)) * COS(RADIANS(".JSPSL_DB_PREFIX."stores.longitude) - RADIANS($long)) ) * 3963.1676) <= $radius) OR (".JSPSL_DB_PREFIX."stores.latitude = $lat AND ".JSPSL_DB_PREFIX."stores.longitude = $long)) ORDER BY distance ASC";
     660                       
    660661            $result = $wpdb->get_results($query);
     662           
     663
    661664            if(!empty($result)){
    662665                $temp = $result;
Note: See TracChangeset for help on using the changeset viewer.