bulk_actions( $which ); ?>
get_results( "
SELECT DISTINCT YEAR( download_date ) AS year, MONTH( download_date ) AS month
FROM {$wpdb->download_log}
ORDER BY download_date DESC
"
);
$month_count = count( $months );
if ( $month_count && ! ( 1 == $month_count && 0 == $months[0]->month ) ) {
$m = isset( $_GET['filter_month'] ) ? $_GET['filter_month'] : 0;
?>
extra_tablenav( $which );
$this->pagination( $which );
?>
process_bulk_action();
// Init headers
$this->_column_headers = array( $this->get_columns(), array(), $this->get_sortable_columns() );
$per_page = absint( $this->logs_per_page );
$current_page = absint( $this->get_pagenum() );
// setup filters
$filters = array();
// filter status
if ( $this->filter_status ) {
$filters[] = array(
'key' => 'download_status',
'value' => $this->filter_status
);
}
// filter month
if ( $this->filter_month ) {
$filters[] = array(
'key' => 'download_date',
'value' => date( 'Y-m-01', strtotime( $this->filter_month ) ),
'operator' => '>='
);
$filters[] = array(
'key' => 'download_date',
'value' => date( 'Y-m-t', strtotime( $this->filter_month ) ),
'operator' => '<='
);
}
// filter on user
if ( $this->filter_user > 0 ) {
$filters[] = array(
'key' => 'user_id',
'value' => $this->filter_user
);
}
// check for order
$order_by = ( ! empty( $_GET['orderby'] ) ) ? $_GET['orderby'] : 'download_date';
$order = ( ! empty( $_GET['order'] ) ) ? $_GET['order'] : 'DESC';
/** @var DLM_WordPress_Log_Item_Repository $log_item_repository */
$log_item_repository = download_monitor()->service( 'log_item_repository' );
$total_items = $log_item_repository->num_rows( $filters );
$this->items = $log_item_repository->retrieve( $filters, $per_page, ( ( $current_page - 1 ) * $per_page ), $order_by, $order );
// Pagination
$this->set_pagination_args( array(
'total_items' => $total_items,
'per_page' => absint( $this->logs_per_page ),
'total_pages' => ( ( $total_items > 0 ) ? ceil( $total_items / absint( $this->logs_per_page ) ) : 1 )
) );
}
/**
* Process bulk actions
*/
public function process_bulk_action() {
if ( 'delete' === $this->current_action() ) {
// check nonce
if ( empty( $_POST['_wpnonce'] ) || ! wp_verify_nonce( $_POST['_wpnonce'], 'bulk-' . $this->_args['plural'] ) ) {
wp_die( 'process_bulk_action() nonce check failed' );
}
// check capability
if ( ! current_user_can( 'dlm_manage_logs' ) ) {
wp_die( "You're not allowed to delete logs!" );
}
// check
if ( count( $_POST['log'] ) > 0 ) {
// delete the posted logs
foreach ( $_POST['log'] as $log_id ) {
download_monitor()->service( 'log_item_repository' )->delete( $log_id );
}
// display delete message
$this->display_delete_message = true;
}
}
}
}