/**
* Returns the number of posts for a given post_type, date and language combination that is published.
*
* @param string $lang language code to check
* @param null|int $year
* @param null|int $month
* @param null|int $day
* @param string|array $post_type
*
* @return bool
*
* @used-by \WPML_Languages::add_date_or_cpt_url_to_ls_lang to determine what languages to show in the Language Switcher
*/
public function archive_query_has_posts($lang, $year = null, $month = null, $day = null, $post_type = 'post')
{
$cache_args = array();
$cache_args['lang'] = $lang;
$cache_args['year'] = $year;
$cache_args['month'] = $month;
$cache_args['day'] = $day;
$cache_args['post_type'] = $post_type;
$cache_key = md5(json_encode($cache_args));
$cache_group = 'archive_query_has_posts';
$cache = new WPML_WP_Cache($cache_group);
$found = false;
$result = $cache->get($cache_key, $found);
if (!$found) {
$post_status_snippet = $this->wp_api->current_user_can('read') ? "p.post_status IN (" . wpml_prepare_in(array('publish', 'private')) . ") " : "p.post_status = 'publish'";
$post_type_snippet = is_array($post_type) ? " AND post_type IN (" . wpml_prepare_in($post_type) . ") " : $this->wpdb->prepare(' AND p.post_type = %s ', $post_type);
$year_snippet = (bool) $year === true ? $this->wpdb->prepare(' AND year(p.post_date) = %d ', $year) : '';
$month_snippet = (bool) $month === true ? $this->wpdb->prepare(' AND month(p.post_date) = %d ', $month) : '';
$day_snippet = (bool) $day === true ? $this->wpdb->prepare(' AND day(p.post_date) = %d ', $day) : '';
$lang_snippet = $this->wpdb->prepare(' AND t.language_code = %s ', $lang);
$result = $this->wpdb->get_var("\n SELECT p.ID FROM {$this->wpdb->posts} p\n\t\t\t\t\t\tJOIN {$this->wpdb->prefix}icl_translations t\n\t\t\t\t\t\t\tON p.ID = t.element_id AND t.element_type = CONCAT('post_', p.post_type)\n\t\t\t\t\t\tWHERE " . $post_status_snippet . $year_snippet . $month_snippet . $day_snippet . $post_type_snippet . $lang_snippet . "\n\t\t\t\t\t\tLIMIT 1");
$cache->set($cache_key, $result);
}
return (bool) $result;
}
