'download', // singular name of the listed records
'plural' => 'downloads', // plural name of the listed records
'ajax' => false, // does this table support ajax?
]);
}
public function column_episode($episode)
{
return sprintf(
'%s %s',
'podlove_analytics',
$episode['id'],
' '.$episode['title'],
''
.sprintf(__('%s ago'), human_time_diff(strtotime($episode['post_date_gmt'])))
.''
);
}
public function column_downloads($episode)
{
return self::get_number_or_dash($episode['downloads']);
}
public function column_cb($item)
{
$post_id = $item['post_id'];
$title = $item['title']; ?>
('.self::get_number_or_dash($item['downloads']).')';
}
// otherwise a dash -
return '–';
}
}
public static function get_number_or_dash($value)
{
if (is_numeric($value) && $value) {
return number_format_i18n($value);
}
return '–';
}
public function get_columns()
{
return [
'cb' => '',
// 'episode' => __('Episode', 'podlove-podcasting-plugin-for-wordpress'),
'downloads' => __('Total', 'podlove-podcasting-plugin-for-wordpress'),
'3y' => __('3y', 'podlove-podcasting-plugin-for-wordpress'),
'2y' => __('2y', 'podlove-podcasting-plugin-for-wordpress'),
'1y' => __('1y', 'podlove-podcasting-plugin-for-wordpress'),
'3q' => __('3q', 'podlove-podcasting-plugin-for-wordpress'),
'2q' => __('2q', 'podlove-podcasting-plugin-for-wordpress'),
'1q' => __('1q', 'podlove-podcasting-plugin-for-wordpress'),
'4w' => __('4w', 'podlove-podcasting-plugin-for-wordpress'),
'3w' => __('3w', 'podlove-podcasting-plugin-for-wordpress'),
'2w' => __('2w', 'podlove-podcasting-plugin-for-wordpress'),
'1w' => __('1w', 'podlove-podcasting-plugin-for-wordpress'),
'6d' => __('6d', 'podlove-podcasting-plugin-for-wordpress'),
'5d' => __('5d', 'podlove-podcasting-plugin-for-wordpress'),
'4d' => __('4d', 'podlove-podcasting-plugin-for-wordpress'),
'3d' => __('3d', 'podlove-podcasting-plugin-for-wordpress'),
'2d' => __('2d', 'podlove-podcasting-plugin-for-wordpress'),
'1d' => __('1d', 'podlove-podcasting-plugin-for-wordpress'),
];
}
public function get_sortable_columns()
{
return [
'episode' => ['episode', true],
'downloads' => ['downloads', true],
'3y' => ['3y', true],
'2y' => ['2y', true],
'1y' => ['1y', true],
'3q' => ['3q', true],
'2q' => ['2q', true],
'1q' => ['1q', true],
'4w' => ['4w', true],
'3w' => ['3w', true],
'2w' => ['2w', true],
'1w' => ['1w', true],
'6d' => ['6d', true],
'5d' => ['5d', true],
'4d' => ['4d', true],
'3d' => ['3d', true],
'2d' => ['2d', true],
'1d' => ['1d', true],
];
}
public static function aggregation_columns()
{
$columns = array_keys(DownloadTimedAggregatorJob::groupings());
array_shift($columns); // remove 'total' column
return $columns;
}
public function single_row($item)
{
$hidden_columns = count(get_hidden_columns(get_current_screen()));
$columns = count($this->get_columns()) - $hidden_columns;
echo '';
echo "| ";
echo $this->column_episode($item);
echo ' | ';
echo '
';
echo '';
$this->single_row_columns($item);
echo '
';
}
public function prepare_items()
{
// number of items per page
$per_page = get_user_meta(get_current_user_id(), podlove_episodes_per_page_option_name(), true);
if (!$per_page) {
$per_page = 20;
}
// define column headers
$this->_column_headers = $this->get_column_info();
$data = Downloads_List_Data::get_data(
filter_input(INPUT_GET, 'orderby'),
filter_input(INPUT_GET, 'order')
);
// get current page
$current_page = $this->get_pagenum();
// get total items
$total_items = count($data);
// extrage page for current page only
$data = array_slice($data, (($current_page - 1) * $per_page), $per_page);
// add items to table
$this->items = $data;
// register pagination options & calculations
$this->set_pagination_args([
'total_items' => $total_items,
'per_page' => $per_page,
'total_pages' => ceil($total_items / $per_page),
]);
}
protected function extra_tablenav($which)
{
global $wpdb;
if ($which == 'bottom') { ?>
data_age(); ?>
$interval,
'next' => $next_cron,
'prev' => $prev_cron,
];
};
$totals_cron = $get_cron_info('podlove_calc_hourly_download_sums');
$prev_totals_job = Job::find_one_recent_finished_job('Podlove\Jobs\DownloadTimedAggregatorJob');
echo sprintf(
__('Analytics data is %s old.', 'podlove-podcasting-plugin-for-wordpress'),
human_time_diff(max($totals_cron['prev'], strtotime($prev_totals_job->updated_at)), time())
);
echo ' ';
echo sprintf(
__('Next update will be in %s.', 'podlove-podcasting-plugin-for-wordpress'),
human_time_diff(time(), $totals_cron['next'])
);
}
}