GetNumberOfPosts.php
430 Bytes
<?php
namespace WPML\TM\ATE\AutoTranslate\Endpoint;
use WPML\API\PostTypes;
use WPML\Collect\Support\Collection;
class GetNumberOfPosts {
public function run( Collection $data, \wpdb $wpdb ) {
$postIn = wpml_prepare_in( $data->get( 'postTypes', PostTypes::getAutomaticTranslatable() ) );
return $wpdb->get_var(
"SELECT COUNT(id) FROM {$wpdb->posts} WHERE post_type IN ({$postIn}) AND post_status='publish'"
);
}
}