/**
* Use templates to output content for objects.
*
* @since 1.3
*/
public static function generate_object_html()
{
global $comments, $users;
$object_ids = $_GET['object_ids'];
if (!is_array($object_ids)) {
$object_ids = explode(',', $object_ids);
}
$object_name = isset($_GET['object_name']) ? $_GET['object_name'] : 'post';
$template_base = isset($_GET['template']) ? $_GET['template'] : '';
switch ($object_name) {
case 'post':
$query_vars = array('post__in' => $object_ids, 'post_type' => GeoMashup::get_searchable_post_types(), 'post_status' => 'publish,future');
// Don't filter this query through other plugins (e.g. event-calendar)
$query_vars['suppress_filters'] = true;
// No sticky posts please
if (function_exists('get_queried_object')) {
$query_vars['ignore_sticky_posts'] = true;
} else {
$query_vars['caller_get_posts'] = true;
}
// Necessary only for WP 3.0 support
// Don't limit the number of results
$query_vars['posts_per_page'] = -1;
query_posts($query_vars);
if (have_posts()) {
status_header(200);
}
$template_base = empty($template_base) ? 'info-window' : $template_base;
break;
case 'comment':
$comments = GeoMashupDB::get_comment_in(array('comment__in' => $object_ids));
if (!empty($comments)) {
status_header(200);
}
$template_base = empty($template_base) ? 'comment' : $template_base;
break;
case 'user':
$users = GeoMashupDB::get_user_in(array('user__in' => $object_ids));
if (!empty($users)) {
status_header(200);
}
$template_base = empty($template_base) ? 'user' : $template_base;
break;
}
load_template(GeoMashup::locate_template($template_base));
}
/**
* 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;
}
