bulk_actions( $which ); ?>
get_results( "
SELECT DISTINCT YEAR( date_created ) AS year, MONTH( date_created ) AS month
FROM {$wpdb->prefix}dlm_order
ORDER BY date_created DESC
"
);
$month_count = count( $months );
if ( $month_count && ! ( 1 == $month_count && 0 == $months[0]->month ) ) {
$m = ! empty( $this->filter_month ) ? $this->filter_month : 0;
?>
filter_status ) {
?>"/>
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->orders_per_page );
$current_page = absint( $this->get_pagenum() );
// setup filters
$filters = array();
// filter status
if ( $this->filter_status ) {
$filters[] = array(
'key' => 'status',
'value' => $this->filter_status
);
}
// filter month
if ( $this->filter_month ) {
$filters[] = array(
'key' => 'date_created',
'value' => date( 'Y-m-01', strtotime( $this->filter_month ) ),
'operator' => '>='
);
$filters[] = array(
'key' => 'date_created',
'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'] : 'id';
$order = ( ! empty( $_GET['order'] ) ) ? $_GET['order'] : 'DESC';
/** @var \Never5\DownloadMonitor\Shop\Order\WordPressRepository $order_repository */
$order_repository = Services::get()->service( 'order_repository' );
$total_items = $order_repository->num_rows( $filters );
$this->items = $order_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->orders_per_page ),
'total_pages' => ( ( $total_items > 0 ) ? ceil( $total_items / absint( $this->orders_per_page ) ) : 1 )
) );
}
/**
* Process bulk actions
*/
public function process_bulk_action() {
return;
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 orders!" );
}
// check
if ( count( $_POST['log'] ) > 0 ) {
// @todo: implement delete
// display delete message
$this->display_delete_message = true;
}
}
}
}