wpsl_sql - WP Store Locator

Description
Usage
Changelog
Source File
Related

Description

This filter allows you to modify the SQL query that determines if a store location falls within the selected radius.

Usage

This example uses the default SQL query and sorting:

add_filter( 'wpsl_sql', 'custom_sql' ); function custom_sql() { global $wpdb, $wpsl_settings; // Set a limit for the results and order them by distance. if ( isset( $_GET['autoload'] ) && $_GET['autoload'] ) { $limit = ''; if ( $wpsl_settings['autoload_limit'] ) { $limit = 'LIMIT %d'; } $sql_sort = 'ORDER BY distance DESC '. $limit; } else { $sql_sort = 'HAVING distance < %d ORDER BY distance DESC LIMIT 0, %d'; } // The default query that selects store location that fall within the selected radius. $sql = "SELECT post_lat.meta_value AS lat, post_lng.meta_value AS lng, posts.ID, ( %d * acos( cos( radians( %s ) ) * cos( radians( post_lat.meta_value ) ) * cos( radians( post_lng.meta_value ) - radians( %s ) ) + sin( radians( %s ) ) * sin( radians( post_lat.meta_value ) ) ) ) AS distance FROM $wpdb->posts AS posts INNER JOIN $wpdb->postmeta AS post_lat ON post_lat.post_id = posts.ID AND post_lat.meta_key = 'wpsl_lat' INNER JOIN $wpdb->postmeta AS post_lng ON post_lng.post_id = posts.ID AND post_lng.meta_key = 'wpsl_lng' WHERE posts.post_type = 'wpsl_stores' AND posts.post_status = 'publish' $sql_sort"; return $sql; }

If you add additional placeholders like %s or %d to the SQL query, then don’t forget to also add the additional placeholder values with the wpsl_sql_placeholder_values filter.

Changelog

Since 2.0

Source File

This filter is located in /frontend/class-frontend.php.

Placement

The code needs to be placed in the functions.php file inside your active theme folder.

Description

Usage

Changelog

Source File

Related

Placement