/wp-content/plugins/wordpress-seo/admin/links/class-link-query.php
https://bitbucket.org/carloskikea/helpet · PHP · 160 lines · 80 code · 25 blank · 55 comment · 4 complexity · f4de9c28b5da91634247e978b6d5c412 MD5 · raw file
- <?php
- /**
- * WPSEO plugin file.
- *
- * @package WPSEO\Admin\Links
- */
- /**
- * Database helper class.
- */
- class WPSEO_Link_Query {
- /**
- * Determine if there are any unprocessed public posts.
- *
- * @param array $post_types List of post types to check with.
- *
- * @return bool True if unprocessed posts are found, false if none are found.
- */
- public static function has_unprocessed_posts( array $post_types ) {
- global $wpdb;
- if ( empty( $post_types ) ) {
- return false;
- }
- $post_types = self::format_post_types( $post_types );
- $count_table = self::get_count_table_name();
- // Get any object which has not got the processed meta key.
- $query = '
- SELECT ID
- FROM ' . $wpdb->posts . ' AS posts
- LEFT JOIN ' . $count_table . ' AS yoast_meta
- ON yoast_meta.object_id = posts.ID
- WHERE posts.post_status = "publish"
- AND posts.post_type IN ( ' . $post_types . ' )
- AND yoast_meta.internal_link_count IS NULL
- LIMIT 1';
- // If anything is found, we have unprocessed posts.
- $results = $wpdb->get_var( $query );
- return ! empty( $results );
- }
- /**
- * Filter out posts that have not been processed yet.
- *
- * @param array $post_ids Post IDs to filter.
- *
- * @return array
- */
- public static function filter_unprocessed_posts( array $post_ids ) {
- global $wpdb;
- $post_ids = array_filter( $post_ids );
- if ( empty( $post_ids ) || array() === $post_ids ) {
- return $post_ids;
- }
- $count_table = self::get_count_table_name();
- $query = '
- SELECT object_id
- FROM ' . $count_table . '
- WHERE object_id IN ( ' . implode( ',', $post_ids ) . ' )
- ';
- $results = $wpdb->get_results( $query, ARRAY_A );
- return array_map( 'intval', wp_list_pluck( $results, 'object_id' ) );
- }
- /**
- * Returns a limited set of unindexed posts.
- *
- * @param array $post_types The post type.
- * @param int $limit The limit for the resultset.
- *
- * @return array|null|object The set of unindexed posts.
- */
- public static function get_unprocessed_posts( array $post_types, $limit = 5 ) {
- global $wpdb;
- $count_table = self::get_count_table_name();
- $post_types = self::format_post_types( $post_types );
- // @codingStandardsIgnoreStart
- $query = 'SELECT posts.ID, posts.post_content
- FROM ' . $wpdb->posts . ' AS posts
- LEFT JOIN ' . $count_table . ' AS yoast_meta
- ON yoast_meta.object_id = posts.ID
- WHERE posts.post_status = "publish"
- AND posts.post_type IN ( ' . $post_types . ' )
- AND yoast_meta.internal_link_count IS NULL
- LIMIT %d
- ';
- // @codingStandardsIgnoreEnd
- return $wpdb->get_results(
- $wpdb->prepare( $query, $limit )
- );
- }
- /**
- * Returns the total amount of unindexed posts for given post type.
- *
- * @param array $post_types The post types.
- *
- * @return int The total of unindexed posts.
- */
- public static function get_unprocessed_count( array $post_types ) {
- global $wpdb;
- if ( empty( $post_types ) ) {
- return 0;
- }
- $count_table = self::get_count_table_name();
- $post_types = self::format_post_types( $post_types );
- // @codingStandardsIgnoreStart
- $query = '
- SELECT COUNT( posts.ID )
- FROM ' . $wpdb->posts . ' AS posts
- LEFT JOIN ' . $count_table . ' AS yoast_meta
- ON yoast_meta.object_id = posts.ID
- WHERE posts.post_status = "publish"
- AND posts.post_type IN ( ' . $post_types . ' )
- AND yoast_meta.internal_link_count IS NULL';
- // @codingStandardsIgnoreEnd
- return (int) $wpdb->get_var( $query );
- }
- /**
- * Returns the table name where the counts are stored.
- *
- * @return string
- */
- protected static function get_count_table_name() {
- $storage = new WPSEO_Meta_Storage();
- return $storage->get_table_name();
- }
- /**
- * Formats an array with post types as an SQL string.
- *
- * @param array $post_types The post types to format.
- *
- * @return string Post types formatted for use in SQL statement.
- */
- protected static function format_post_types( array $post_types ) {
- $sanitized_post_types = array_map( 'esc_sql', $post_types );
- $post_types = sprintf( '"%s"', implode( '", "', $sanitized_post_types ) );
- return $post_types;
- }
- }