__('Post', 'wpil'),
);
if($show_date){
$options['date'] =
'';
}
$options['word_cloud'] =
'';
if($show_traffic){
$options['organic_traffic'] =
'';
}
$selected_sources = Wpil_TargetKeyword::get_active_keyword_sources();
if(in_array('gsc', $selected_sources, true)){
$options['gsc'] =
'';
}
if(in_array('yoast', $selected_sources, true)){
$options['yoast'] =
'';
}
if(in_array('rank-math', $selected_sources, true)){
$options['rank-math'] =
'';
}
if(in_array('aioseo', $selected_sources, true)){
$options['aioseo'] =
'';
}
if(in_array('seopress', $selected_sources, true)){
$options['seopress'] =
'';
}
if(in_array('squirrly', $selected_sources, true)){
$options['squirrly'] =
'';
}
if(in_array('post-content', $selected_sources, true)){
$options['post-content'] =
'';
}
if(in_array('ai-generated', $selected_sources, true)){
$options['ai-generated'] =
'';
}
$options['custom'] =
'';
return $options;
}
function prepare_items()
{
define('WPIL_LOADING_REPORT', true);
$options = get_user_meta(get_current_user_id(), 'target_keyword_options', true);
$per_page = !empty($options['per_page']) ? (int)$options['per_page'] : false;
$page = isset($_REQUEST['paged']) ? (int)$_REQUEST['paged'] : 1;
$search = !empty($_GET['s']) ? $_GET['s'] : '';
$orderby = isset($_REQUEST['orderby']) ? $_REQUEST['orderby'] : '';
$order = isset($_REQUEST['order']) ? $_REQUEST['order'] : '';
if(!isset($_REQUEST['paged']) && empty($search) && empty($orderby) && empty($order)){
Wpil_Telemetry::log_event('report_open_target_keywords');
}
if(empty($per_page)){
$options2 = get_user_meta(get_current_user_id(), 'report_options', true);
$per_page = !empty($options2['per_page']) ? $options2['per_page'] : 20;
}
$columns = $this->get_columns();
$hidden = [];
$sortable = $this->get_sortable_columns();
$this->_column_headers = [$columns, $hidden, $sortable];
$data = Wpil_TargetKeyword::getData($per_page, $page, $search, $orderby, $order);
$this->items = $data['data'];
$this->set_pagination_args(array(
'total_items' => $data['total_items'],
'per_page' => $per_page,
'total_pages' => ceil($data['total_items'] / $per_page)
));
}
function column_default($item, $column_name)
{
if(is_array($item) && isset($item['post'])){
$post = $item['post'];
}elseif(!empty($item)){
$post = new Wpil_Model_Post($item->ID, $item->post_type);
}
switch($column_name) {
case 'post_title':
$actions = [];
$title = '' . esc_attr($post->getTitle()) . ' ';
$actions['view'] = 'View ';
$actions['edit'] = 'Edit ';
$actions['add_inbound'] = 'id}&page=link_whisper&type=inbound_suggestions_page&ret_url=" . base64_encode($_SERVER['REQUEST_URI']))) . '">Add Inbound Links ';
return $title . $this->row_actions($actions);
case 'word_cloud':
$keywords = Wpil_TargetKeyword::get_keywords_by_post_ids($post->id, $post->type);
$keyword_string = '';
$has_active_keywords = false;
foreach($keywords as $keyword){
$hidden = 'style="display:none;"';
if(!empty($keyword->checked) || !empty($keyword->auto_checked)){
$has_active_keywords = true;
$hidden = '';
}
$keyword_string .= '' . esc_html($keyword->keywords) . ' ';
}
$hidden_notice = '';
if($has_active_keywords){
$hidden_notice = ' style="display:none;" ';
}
$no_active_keys = '' . __('No Active Keywords', 'wpil') . ' ';
return '' . $no_active_keys . $keyword_string . ' ';
case 'organic_traffic':
$keywords = Wpil_TargetKeyword::get_post_keywords_by_type($post->id, $post->type, 'gsc-keyword', false);
$clicks = 0;
$position = 0;
foreach($keywords as $keyword){
$clicks += $keyword->clicks;
$position += floatval($keyword->position);
}
if($position > 0){
$position = round($position/count($keywords), 2);
}
return '
' . __('Clicks: ', 'wpil') . $clicks . '
' . __('AVG Position: ', 'wpil') . $position . '
';
case 'gsc':
$keywords = Wpil_TargetKeyword::filter_duplicate_gsc_keywords(Wpil_TargetKeyword::get_post_keywords_by_type($post->id, $post->type));
$keyword_type = 'gsc-keyword';
$col_number = $this->get_keyword_column_number($column_name);
ob_start();
include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/blocks/collapsible_target_keywords.php';
return ob_get_clean();
case 'yoast':
$keywords = Wpil_TargetKeyword::get_post_keywords_by_type($post->id, $post->type, 'yoast-keyword');
$keyword_type = 'yoast-keyword';
$col_number = $this->get_keyword_column_number($column_name);
ob_start();
include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/blocks/collapsible_target_keywords.php';
return ob_get_clean();
case 'rank-math':
$keywords = Wpil_TargetKeyword::get_post_keywords_by_type($post->id, $post->type, 'rank-math-keyword');
$keyword_type = 'rank-math-keyword';
$col_number = $this->get_keyword_column_number($column_name);
ob_start();
include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/blocks/collapsible_target_keywords.php';
return ob_get_clean();
case 'aioseo':
$keywords = Wpil_TargetKeyword::get_post_keywords_by_type($post->id, $post->type, 'aioseo-keyword');
$keyword_type = 'aioseo-keyword';
$col_number = $this->get_keyword_column_number($column_name);
ob_start();
include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/blocks/collapsible_target_keywords.php';
return ob_get_clean();
case 'seopress':
$keywords = Wpil_TargetKeyword::get_post_keywords_by_type($post->id, $post->type, 'seopress-keyword');
$keyword_type = 'seopress-keyword';
$col_number = $this->get_keyword_column_number($column_name);
ob_start();
include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/blocks/collapsible_target_keywords.php';
return ob_get_clean();
case 'squirrly':
$keywords = Wpil_TargetKeyword::get_post_keywords_by_type($post->id, $post->type, 'squirrly-keyword');
$keyword_type = 'squirrly-keyword';
$col_number = $this->get_keyword_column_number($column_name);
ob_start();
include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/blocks/collapsible_target_keywords.php';
return ob_get_clean();
case 'post-content':
$keywords = Wpil_TargetKeyword::get_post_keywords_by_type($post->id, $post->type, 'post-content-keyword');
$keyword_type = 'post-content-keyword';
$col_number = $this->get_keyword_column_number($column_name);
ob_start();
include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/blocks/collapsible_target_keywords.php';
return ob_get_clean();
case 'ai-generated':
$keywords = Wpil_TargetKeyword::get_post_keywords_by_type($post->id, $post->type, 'ai-generated-keyword');
$keyword_type = 'ai-generated-keyword';
$col_number = $this->get_keyword_column_number($column_name);
ob_start();
include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/blocks/collapsible_target_keywords.php';
return ob_get_clean();
case 'custom':
$keywords = Wpil_TargetKeyword::get_post_keywords_by_type($post->id, $post->type, 'custom-keyword');
$keyword_type = 'custom-keyword';
$col_number = $this->get_keyword_column_number($column_name);
ob_start();
include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/blocks/collapsible_target_keywords.php';
return ob_get_clean();
case 'date':
if($post->type === 'post'){
return get_the_date('', $post->id);
}else{
return __('Not Set', 'wpil');
}
default:
return $item->$column_name;
}
}
function get_sortable_columns()
{
return [
'post_title' => ['post_title', false],
'gsc' => ['gsc', false],
'yoast' => ['yoast', true],
'rank-math' => ['rank-math', true],
'aioseo' => ['aioseo', true],
'seopress' => ['seopress', true],
'squirrly' => ['squirrly', true],
'organic_traffic' => ['organic_traffic', true],
'custom' => ['custom', false],
'post-content' => ['post-content', true],
'ai-generated' => ['ai-generated', true],
'date' => ['date', false]
];
}
function extra_tablenav( $which ) {
if ($which == "top") {
return;
$post_type = Wpil_Filter::linksPostType();
$post_type = !empty($post_type) ? $post_type : 0;
?>
>
Filter
get_column_info();
foreach ( $columns as $column_name => $column_display_name ) {
$classes = "$column_name column-$column_name";
if ( $primary === $column_name ) {
$classes .= ' has-row-actions column-primary';
}
if ( in_array( $column_name, $hidden, true ) ) {
$classes .= ' hidden';
}
if(in_array($column_name, array('gsc', 'yoast', 'rank-math', 'aioseo', 'seopress', 'squirrly', 'post-content', 'ai-generated', 'custom'), true)){
$classes .= ' wpil-dropdown-column';
}
// Comments column uses HTML in the display name with screen reader text.
// Instead of using esc_attr(), we strip tags to get closer to a user-friendly string.
$data = 'data-colname="' . wp_strip_all_tags( $column_display_name ) . '"';
$attributes = "class='$classes' $data";
if ( 'cb' === $column_name ) {
echo '';
echo $this->column_cb( $item );
echo ' ';
} elseif ( method_exists( $this, '_column_' . $column_name ) ) {
echo call_user_func(
array( $this, '_column_' . $column_name ),
$item,
$classes,
$data,
$primary
);
} elseif ( method_exists( $this, 'column_' . $column_name ) ) {
echo "";
echo call_user_func( array( $this, 'column_' . $column_name ), $item );
echo $this->handle_row_actions( $item, $column_name, $primary );
echo ' ';
} else {
echo "";
echo $this->column_default( $item, $column_name );
echo $this->handle_row_actions( $item, $column_name, $primary );
echo ' ';
}
}
}
/**
* Calculates which Target Keyword column is the current one
* @param string $col The name of the current column
* @return int The column's number, counting from the left
**/
function get_keyword_column_number($col = ''){
$columns = array(
'gsc' => true,
'yoast' => true,
'rank-math' => true,
'aioseo' => true,
'seopress' => true,
'squirrly' => true,
'post-content' => true,
'ai-generated' => true,
'custom' => true
);
$active = array_flip(array_keys(array_intersect_key($columns, $this->_column_headers[0])));
return isset($active[$col]) ? $active[$col] : false;
}
}