/**
* Get locations of objects.
*
* <code>
* $results = GeoMashupDB::get_object_locations( array(
* 'object_name' => 'user',
* 'minlat' => 30,
* 'maxlat' => 40,
* 'minlon' => -106,
* 'maxlat' => -103 )
* );
* </code>
*
* @since 1.3
*
* @param string $query_args Override default args.
* @return array Array of matching rows.
*/
public static function get_object_locations($query_args = '')
{
global $wpdb;
$default_args = array('minlat' => null, 'maxlat' => null, 'minlon' => null, 'maxlon' => null, 'radius_km' => null, 'radius_mi' => null, 'map_cat' => null, 'tax_query' => null, 'map_post_type' => 'any', 'object_name' => 'post', 'show_future' => 'false', 'suppress_filters' => false, 'limit' => 0, 'map_offset' => 0);
$query_args = wp_parse_args($query_args, $default_args);
// Construct the query
$object_name = $query_args['object_name'];
$object_store = self::object_storage($object_name);
if (empty($object_store)) {
return null;
}
// Giving tables an alias was a mistake, now filters depend on them
$field_string = "gmlr.object_id, gmlr.geo_date, o.{$object_store['label_column']} as label, gml.*";
$table_string = "{$wpdb->prefix}geo_mashup_locations gml " . "INNER JOIN {$wpdb->prefix}geo_mashup_location_relationships gmlr " . $wpdb->prepare('ON gmlr.object_name = %s AND gmlr.location_id = gml.id ', $object_name) . "INNER JOIN {$object_store['table']} o ON o.{$object_store['id_column']} = gmlr.object_id";
$wheres = array();
$groupby = '';
$having = '';
if ('post' == $object_name) {
$field_string .= ', o.post_author';
if ($query_args['show_future'] == 'true') {
$wheres[] = 'post_status in ( \'publish\',\'future\' )';
} else {
if ($query_args['show_future'] == 'only') {
$wheres[] = 'post_status = \'future\'';
} else {
$wheres[] = 'post_status = \'publish\'';
}
}
} else {
if ('comment' == $object_name) {
$wheres[] = 'comment_approved = \'1\'';
}
}
$location_args = wp_array_slice_assoc($query_args, array_keys(GM_Location_Query::get_defaults()));
$location_query = new GM_Location_Query($location_args);
// Handle inclusion and exclusion of terms
if (!empty($query_args['tax_query']) and is_array($query_args['tax_query'])) {
$tax_query = $query_args['tax_query'];
} else {
$tax_query = array();
}
if (!empty($query_args['map_cat'])) {
$cats = preg_split('/[,\\s]+/', $query_args['map_cat']);
$escaped_include_ids = array();
$escaped_exclude_ids = array();
foreach ($cats as $cat) {
if (is_numeric($cat)) {
if ($cat < 0) {
$escaped_exclude_ids[] = abs($cat);
$escaped_exclude_ids = array_merge($escaped_exclude_ids, get_term_children($cat, 'category'));
} else {
$escaped_include_ids[] = intval($cat);
$escaped_include_ids = array_merge($escaped_include_ids, get_term_children($cat, 'category'));
}
} else {
// Slugs might begin with a dash, so we only include them
$term = get_term_by('slug', $cat, 'category');
if ($term) {
$escaped_include_ids[] = $term->term_id;
$escaped_include_ids = array_merge($escaped_include_ids, get_term_children($term->term_id, 'category'));
}
}
}
if (!empty($escaped_include_ids)) {
$tax_query[] = array('taxonomy' => 'category', 'terms' => $escaped_include_ids, 'field' => 'term_id');
}
if (!empty($escaped_exclude_ids)) {
$tax_query[] = array('taxonomy' => 'category', 'terms' => $escaped_exclude_ids, 'operator' => 'NOT IN', 'field' => 'term_id');
}
}
// end if map_cat exists
if (!empty($tax_query)) {
$tax_clauses = get_tax_sql($tax_query, 'o', $object_store['id_column']);
$table_string .= $tax_clauses['join'];
$wheres[] = preg_replace('/^ AND/', '', $tax_clauses['where']);
$groupby = 'GROUP BY gmlr.object_id';
}
if ('post' == $object_name) {
// Handle inclusion and exclusion of post types
if ('any' == $query_args['map_post_type']) {
$include_post_types = '';
$searchable_post_types = GeoMashup::get_searchable_post_types();
if (!empty($searchable_post_types)) {
$include_post_types .= "o.post_type IN ('" . join("', '", array_map('esc_sql', $searchable_post_types)) . "')";
}
$wheres[] = $include_post_types;
} else {
if (!is_array($query_args['map_post_type'])) {
$query_args['map_post_type'] = preg_split('/[,\\s]+/', $query_args['map_post_type']);
}
$wheres[] = "o.post_type IN ('" . join("', '", $query_args['map_post_type']) . "')";
}
}
if (!empty($query_args['object_id'])) {
$wheres[] = 'gmlr.object_id = ' . esc_sql($query_args['object_id']);
} else {
if (!empty($query_args['object_ids'])) {
$wheres[] = 'gmlr.object_id IN ( ' . esc_sql($query_args['object_ids']) . ' )';
}
}
if (!empty($query_args['exclude_object_ids'])) {
$wheres[] = 'gmlr.object_id NOT IN ( ' . esc_sql($query_args['exclude_object_ids']) . ' )';
}
list($l_cols, $l_join, $l_where, $l_groupby) = $location_query->get_sql('o', $object_store['id_column']);
$field_string .= $l_cols;
$table_string .= $l_join;
if (empty($groupby) and !empty($l_groupby)) {
$groupby = 'GROUP BY ' . $l_groupby;
}
$where = empty($wheres) ? '' : 'WHERE ' . implode(' AND ', $wheres) . $l_where;
$sort = isset($query_args['sort']) ? $query_args['sort'] : $object_store['sort'];
$sort = empty($sort) ? '' : 'ORDER BY ' . esc_sql($sort);
$offset = absint($query_args['map_offset']);
$limit = absint($query_args['limit']);
if ($limit or $offset) {
$limit = " LIMIT {$offset},{$limit}";
} else {
$limit = '';
}
if (!$query_args['suppress_filters']) {
$field_string = apply_filters('geo_mashup_locations_fields', $field_string);
$table_string = apply_filters('geo_mashup_locations_join', $table_string);
$where = apply_filters('geo_mashup_locations_where', $where);
$sort = apply_filters('geo_mashup_locations_orderby', $sort);
$groupby = apply_filters('geo_mashup_locations_groupby', $groupby);
$limit = apply_filters('geo_mashup_locations_limits', $limit);
$suppress_post_filters = defined('GEO_MASHUP_SUPPRESS_POST_FILTERS') && GEO_MASHUP_SUPPRESS_POST_FILTERS;
if ('post' === $object_name and !$suppress_post_filters and isset($GLOBALS['sitepress'])) {
// Ok, we're catering to WPML here. If we ever integrate with a WP_Query object for posts,
// this could be made more general
// This filter will include all translatable post types, I hope
add_filter('get_translatable_documents', array(__CLASS__, 'wpml_filter_get_translatable_documents'));
// Apply post query filters, changing posts table references to our alias
// As of WPML 2.9 these calls can trigger undefined variable notices
$table_string = $GLOBALS['sitepress']->posts_join_filter($table_string, null);
$table_string = str_replace($wpdb->posts . '.', 'o.', $table_string);
$where = $GLOBALS['sitepress']->posts_where_filter($where, null);
$where = str_replace($wpdb->posts . '.', 'o.', $where);
remove_filter('get_translatable_documents', array(__CLASS__, 'wpml_filter_get_translatable_documents'));
}
}
$query_string = "SELECT {$field_string} FROM {$table_string} {$where} {$groupby} {$having} {$sort} {$limit}";
$wpdb->query($query_string);
return $wpdb->last_result;
}
function test_gm_location_query()
{
global $wpdb;
$unlocated_user_ids = $this->factory->user->create_many(2);
$nv_user_id = $this->factory->user->create();
$nv_location = $this->get_nv_test_location();
GeoMashupDB::set_object_location('user', $nv_user_id, $nv_location, false);
$location_query = new GM_Location_Query(array('minlat' => $nv_location->lat - 1, 'maxlat' => $nv_location->lat + 1, 'minlon' => $nv_location->lng - 1, 'maxlon' => $nv_location->lng + 1));
list($cols, $join, $where, $groupby) = $location_query->get_sql($wpdb->users, 'ID');
$this->assertNotContains('distance_km', $cols, 'Got a distance_km column for a non-radius query.');
$this->assertEmpty($groupby, 'Got a groupby value for a non-radius query.');
$sql = "SELECT {$wpdb->users}.ID\n\t\t\tFROM {$wpdb->users}{$join}\n\t\t\tWHERE 1=1{$where}\n\t\t";
$results = $wpdb->get_results($sql);
$this->assertCount(1, $results);
$this->assertEquals($nv_user_id, $results[0]->ID);
}