get_columns();
$hidden = [];
$sortable = $this->get_sortable_columns();
$this->_column_headers = [$columns, $hidden, $sortable];
$start_date = strtotime('30 days ago');
if(isset($_GET['start_date']) && !empty($_GET['start_date'])){
$start_string = preg_replace('/([^0-9-TZ:\/])/', '', $_GET['start_date']);
if(!empty(DateTime::createFromFormat('Y-m-d', $start_string))){
$date = new DateTime($start_string);
$start_date = $date->getTimestamp();
}
}
$end_date = strtotime('now');
if(isset($_GET['end_date']) && !empty($_GET['end_date'])){
$end_string = preg_replace('/([^0-9-TZ:\/])/', '', $_GET['end_date']);
if(!empty(DateTime::createFromFormat('Y-m-d', $end_string))){
$date = new DateTime($end_string);
$end_date = $date->getTimestamp() + (DAY_IN_SECONDS - 5);
}
}
$data = Wpil_ClickTracker::get_detailed_click_table_data($id, $type, $page, $orderby, $order, array('start' => $start_date, 'end' => $end_date));
$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)
{
switch($column_name) {
case 'link_url':
return '' . esc_html($item->link_url) . '';
case 'post_id':
$post = new Wpil_Model_Post($item->post_id, $item->post_type);
return 'id}&post_type={$post->type}&page=link_whisper&type=click_details_page&ret_url=" . base64_encode($_SERVER['REQUEST_URI'] . '&direct_return=1'))) . '">' . esc_html($post->getTitle()) . '';
case 'wpil-report-actions':
return '' . $this->build_action_panel($item);
case 'user_ip':
return '' . esc_html($item->user_ip) . '';
case 'show_click_location':
return $item->link_location;
case 'link_created':
return !empty($item->link_created) ? date(get_option('date_format', 'F d, Y'), $item->link_created): __('Unknown', 'wpil');
default:
return $item->$column_name;
}
}
function build_action_panel($item){
if(is_numeric($_GET['post_id'])){
$actions = [
'view-url-clicks' => '' . esc_html__('View Clicks for URL', 'wpil') . '',
'delete-clicks' => 'Delete Clicks',
];
}else{
$post = new Wpil_Model_Post($item->post_id, $item->post_type);
$actions = [
'view-post-clicks' => 'id}&post_type={$post->type}&page=link_whisper&type=click_details_page&ret_url=" . base64_encode($_SERVER['REQUEST_URI'] . '&direct_return=1'))) . '" class="wpil-action-panel-button">' . esc_html__('View Clicks for Post', 'wpil') . '',
'delete-clicks' => 'Delete Clicks',
];
}
$content =
'
' . implode('', $actions). '
';
return $content;
}
function get_sortable_columns()
{
if(isset($_GET['post_type']) && $_GET['post_type'] === 'url'){
$options['post_id'] = ['post_id', true];
}else{
$options['link_url'] = ['link_url', true];
}
$options['link_anchor'] = ['link_anchor', true];
$options['click_date'] = ['click_date', true];
if(empty(get_option('wpil_disable_click_tracking_info_gathering', false))){
$options['user_ip'] = ['user_ip', true];
}
$options['total_clicks'] = ['total_clicks', true];
return $options;
}
/**
* Generates the columns for a single row of the table.
*
* @since 3.1.0
*
* @param object $item The current item.
*/
protected function single_row_columns( $item ) {
list( $columns, $hidden, $sortable, $primary ) = $this->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', '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 ' | ';
}
}
}
/**
* Remove the search box from the click table.
**/
public function search_box( $text, $input_id ) {
if(!isset($_GET['post_type']) || $_GET['post_type'] !== 'user_ip'){
return;
}
$ip_address = (isset($_GET['post_id'])) ? filter_var($_GET['post_id'], FILTER_VALIDATE_IP): false;
if(empty($ip_address)){
return;
}
?>