get_supported_post_types(); foreach ($post_types as $post_type) { // Add column header add_filter("manage_{$post_type}_posts_columns", [$this, 'add_column_header'], 10); // Add column content add_action("manage_{$post_type}_posts_custom_column", [$this, 'render_column_content'], 10, 2); // Make column sortable add_filter("manage_edit-{$post_type}_sortable_columns", [$this, 'make_column_sortable'], 10); } }); // Handle sorting add_action('pre_get_posts', [$this, 'handle_column_sorting']); // Enqueue admin styles for column add_action('admin_enqueue_scripts', [$this, 'enqueue_column_styles']); } /** * Get supported post types * * @return array Array of post type names */ private function get_supported_post_types(): array { $post_types = get_post_types(['public' => true], 'names'); // Remove unnecessary post types unset($post_types['attachment']); unset($post_types['elementor_library']); unset($post_types['oceanwp_library']); unset($post_types['ae_global_templates']); // Divi library + Theme Builder templates. unset($post_types['et_pb_layout']); unset($post_types['et_theme_builder']); unset($post_types['et_template']); unset($post_types['et_header_layout']); unset($post_types['et_body_layout']); unset($post_types['et_footer_layout']); /** * Filter supported post types for ThinkRank SEO Overview column * * @param array $post_types Array of post type names */ return apply_filters('thinkrank_seo_overview_post_types', $post_types); } /** * Add column header * * @param array $columns Existing columns * @return array Modified columns */ public function add_column_header(array $columns): array { // Insert column before date column $new_columns = []; foreach ($columns as $key => $value) { if ($key === 'date') { $new_columns[self::COLUMN_ID] = __('ThinkRank SEO Overview', 'thinkrank'); } $new_columns[$key] = $value; } // If date column doesn't exist, add at the end if (!isset($columns['date'])) { $new_columns[self::COLUMN_ID] = __('ThinkRank SEO Overview', 'thinkrank'); } return $new_columns; } /** * Render column content * * @param string $column_name Column name * @param int $post_id Post ID * @return void */ public function render_column_content(string $column_name, int $post_id): void { if ($column_name !== self::COLUMN_ID) { return; } // Get SEO data $seo_data = $this->get_seo_data($post_id); // Render the column content $this->render_seo_overview($seo_data, $post_id); } /** * Get SEO data for a post * * @param int $post_id Post ID * @return array SEO data */ private function get_seo_data(int $post_id): array { // Get SEO score and metrics from database table $seo_metrics = $this->get_seo_metrics_from_database($post_id); // Get focus keyword(s). The column shows only the primary keyword, but // the inline editor operates on the full comma-separated set so editing // never drops the secondary keywords. $focus_keywords = \ThinkRank\SEO\Focus_Keywords::get($post_id); $focus_keyword = implode(', ', $focus_keywords); $focus_keyword_primary = $focus_keywords[0] ?? ''; // Get the effective meta title/description. When no custom per-post value // is set, ThinkRank still renders these from the Bulk SEO Optimization // (Global SEO) patterns, so resolve those inherited values here instead of // reporting "Not Set" for content that is actually output on the frontend. $raw_title = get_post_meta($post_id, '_thinkrank_seo_title', true); $meta_title = $raw_title !== '' ? \ThinkRank\SEO\Pattern_Resolver::resolve_value($raw_title, $post_id) : \ThinkRank\SEO\Pattern_Resolver::title($post_id); $raw_description = get_post_meta($post_id, '_thinkrank_meta_description', true); $meta_description = $raw_description !== '' ? \ThinkRank\SEO\Pattern_Resolver::resolve_value($raw_description, $post_id) : \ThinkRank\SEO\Pattern_Resolver::description($post_id); // Get content quality and readability from database columns $content_quality = $seo_metrics['content_quality'] ?? 'Not Analyzed'; $readability = $seo_metrics['readability_score'] ?? 'N/A'; return [ 'seo_score' => $seo_metrics['seo_score'], 'seo_grade' => $seo_metrics['seo_grade'], 'content_quality' => $content_quality, 'readability' => $readability, 'focus_keyword' => !empty($focus_keyword), 'focus_keyword_value' => $focus_keyword, 'focus_keyword_primary' => $focus_keyword_primary, 'meta_title' => !empty($meta_title), 'meta_description' => !empty($meta_description), 'pillar_content' => $this->is_link_suggestions_enabled(get_post_type($post_id)) && get_post_meta($post_id, '_thinkrank_pillar_content', true) === '1', ]; } /** * Check if link suggestions are enabled for a post type * * @param string $post_type Post type * @return bool True if enabled */ private function is_link_suggestions_enabled(string $post_type): bool { $settings = get_option('thinkrank_global_seo_settings', []); if (isset($settings[$post_type]['link_suggestions'])) { return (bool) $settings[$post_type]['link_suggestions']; } return true; } /** * Cached result of the scores-table existence check. * * The post-list column renders this method once per row; the table schema * cannot change mid-request, so the `SHOW TABLES LIKE` probe is memoized for * the lifetime of the request instead of re-running per row. * * @since 1.16.2 * @var bool|null Null until first resolved, then the boolean result. */ private static ?bool $scores_table_exists = null; /** * Get SEO metrics from database table * * @param int $post_id Post ID * @return array SEO metrics (seo_score, content_quality, readability_score) */ private function get_seo_metrics_from_database(int $post_id): array { global $wpdb; $table_name = $wpdb->prefix . 'thinkrank_seo_scores'; // Default values $default_metrics = [ 'seo_score' => null, 'seo_grade' => null, 'content_quality' => null, 'readability_score' => null, ]; // Check if table exists (memoized per request — the column runs this // per row and the schema is stable within a single page load). if (null === self::$scores_table_exists) { // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- SEO score retrieval requires direct database access self::$scores_table_exists = (bool) $wpdb->get_var($wpdb->prepare( "SHOW TABLES LIKE %s", $table_name )); } if (!self::$scores_table_exists) { return $default_metrics; } // Get the most recent metrics from the database // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- SEO score retrieval requires direct database access $result = $wpdb->get_row($wpdb->prepare( // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- Table name is properly escaped "SELECT overall_score, grade, content_quality, readability_score FROM `{$table_name}` WHERE post_id = %d ORDER BY created_at DESC LIMIT 1", $post_id ), ARRAY_A); if (!$result) { return $default_metrics; } return [ 'seo_score' => $result['overall_score'] !== null ? intval($result['overall_score']) : null, 'seo_grade' => $result['grade'] !== null ? $result['grade'] : null, 'content_quality' => $result['content_quality'], 'readability_score' => $result['readability_score'], ]; } /** * Render SEO overview content * * @param array $seo_data SEO data * @param int $post_id Post ID * @return void */ private function render_seo_overview(array $seo_data, int $post_id): void { ?>
%
•
•
•
•
= 90) { return 'great'; } elseif ($score >= 70) { return 'good'; } elseif ($score >= 50) { return 'medium'; } else { return 'poor'; } } /** * Make column sortable * * @param array $columns Sortable columns * @return array Modified sortable columns */ public function make_column_sortable(array $columns): array { $columns[self::COLUMN_ID] = 'thinkrank_seo_score'; return $columns; } /** * Handle column sorting * * @param \WP_Query $query WordPress query object * @return void */ public function handle_column_sorting(\WP_Query $query): void { if (!is_admin() || !$query->is_main_query()) { return; } if ($query->get('orderby') !== 'thinkrank_seo_score') { return; } // Sort on the scores table — the same source the column renders. The // `_thinkrank_seo_score` meta cannot be used here: it is written only by // the AI analyze flow and reset to 0 on every save, and ordering by // meta_key INNER JOINs postmeta, which silently drops every post that // lacks the key from the list entirely. add_filter('posts_clauses', [$this, 'add_seo_score_order_clauses'], 10, 2); } /** * Order the posts list by each post's latest SEO score. * * LEFT JOIN so posts that have never been scored still appear (they order as * NULL: last when sorting DESC). The subquery collapses the append-only * score history to one row per post — the newest by primary key — so posts * are never duplicated by the join. * * @param array $clauses Query clauses * @param \WP_Query $query Query object * @return array Modified clauses */ public function add_seo_score_order_clauses(array $clauses, \WP_Query $query): array { global $wpdb; // Leave any other query untouched — and leave the filter attached, since // the query that asked for this ordering may not be the first to run. if ($query->get('orderby') !== 'thinkrank_seo_score') { return $clauses; } // Handled — don't touch anything that runs later in the request. remove_filter('posts_clauses', [$this, 'add_seo_score_order_clauses'], 10); $table_name = $wpdb->prefix . 'thinkrank_seo_scores'; $order = strtoupper((string) $query->get('order')) === 'ASC' ? 'ASC' : 'DESC'; // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- Table name derives from $wpdb->prefix and $order is whitelisted above $clauses['join'] .= " LEFT JOIN ( SELECT s.post_id, s.overall_score FROM `{$table_name}` s INNER JOIN ( SELECT post_id, MAX(id) AS latest_id FROM `{$table_name}` GROUP BY post_id ) latest ON latest.latest_id = s.id ) thinkrank_scores ON thinkrank_scores.post_id = {$wpdb->posts}.ID"; // Tie-break on ID so equal scores keep a stable, deterministic order. // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- $order is whitelisted above $clauses['orderby'] = "thinkrank_scores.overall_score {$order}, {$wpdb->posts}.ID DESC"; return $clauses; } /** * Enqueue column styles * * @param string $hook_suffix Current admin page hook * @return void */ public function enqueue_column_styles(string $hook_suffix): void { // Only load on post list pages (edit.php for all post types) $screen = get_current_screen(); if (!$screen || $screen->base !== 'edit') { return; } // Enqueue column styles wp_enqueue_style( 'thinkrank-admin-columns', THINKRANK_PLUGIN_URL . 'static/css/admin-columns.css', [], THINKRANK_VERSION ); // Enqueue inline editing script wp_enqueue_script( 'thinkrank-focus-keyword-inline-edit', THINKRANK_PLUGIN_URL . 'assets/focus-keyword-inline-edit.js', ['jquery'], THINKRANK_VERSION, true ); // Localize script with AJAX data wp_localize_script( 'thinkrank-focus-keyword-inline-edit', 'thinkrankFocusKeyword', [ 'ajaxUrl' => admin_url('admin-ajax.php'), 'nonce' => wp_create_nonce(\ThinkRank\Admin\Focus_Keyword_Ajax::get_nonce_action()), 'action' => \ThinkRank\Admin\Focus_Keyword_Ajax::get_ajax_action(), 'i18n' => [ 'notSet' => __('Not Set', 'thinkrank'), 'clickToEdit' => __('Click to edit', 'thinkrank'), 'pressEnter' => __('Press Enter to save, Esc to cancel', 'thinkrank'), 'saving' => __('Saving...', 'thinkrank'), 'saved' => __('Saved!', 'thinkrank'), 'error' => __('Error updating focus keyword. Please try again.', 'thinkrank'), ] ] ); } }