__( 'Zero Spam for WordPress Blocked Location', 'zero-spam' ),
'plural' => __( 'Zero Spam for WordPress Blocked Locations', 'zero-spam' ),
);
parent::__construct( $args );
}
/**
* Column values
*/
public function column_default( $item, $column_name ) {
switch ( $column_name ) {
case 'date_added':
case 'start_block':
case 'end_block':
if (
! empty( $item['blocked_type'] ) &&
'permanent' === $item['blocked_type'] &&
'end_block' === $column_name
) {
return 'N/A';
}
if ( empty( $item[ $column_name ] ) || '0000-00-00 00:00:00' === $item[ $column_name ] ) {
return 'N/A';
}
$date_time_format = 'm/d/Y';
return get_date_from_gmt( gmdate( 'Y-m-d H:i:s', strtotime( $item[ $column_name ] ) ), $date_time_format );
break;
case 'location':
if ( empty( $item['blocked_key'] ) ) {
return 'N/A';
}
$location = $item['blocked_key'];
if ( ! empty( $item['key_type'] ) ) {
$location .= ' (' . $item['key_type'] . ')';
}
return $location;
break;
case 'actions':
ob_start();
?>
; ?>assets/img/icon-trash.svg)
__( 'Delete Selected', 'zero-spam' ),
// 'delete_all' => __( 'Delete All Locations', 'zero-spam' ),
);
return $actions;
}
/**
* Hidable columns
*/
public function get_hidden_columns() {
return array();
}
/**
* Prepare log items
*/
public function prepare_items( $args = array() ) {
$this->process_bulk_action();
$columns = $this->get_columns();
$hidden = $this->get_hidden_columns();
$sortable = $this->get_sortable_columns();
$per_page = 50;
$current_page = $this->get_pagenum();
$offset = $per_page * ( $current_page - 1 );
$order = ! empty( $_REQUEST['order'] ) ? sanitize_key( $_REQUEST['order'] ) : 'desc';
$orderby = ! empty( $_REQUEST['orderby'] ) ? sanitize_sql_orderby( $_REQUEST['orderby'] ) : 'date_added';
$log_type = ! empty( $_REQUEST['type'] ) ? sanitize_text_field( $_REQUEST['type'] ) : false;
$user_ip = ! empty( $_REQUEST['s'] ) ? sanitize_text_field( $_REQUEST['s'] ) : false;
$query_args = array(
'limit' => $per_page,
'offset' => $offset,
'order' => $order,
'orderby' => $orderby,
'where' => array(
'key_type' => array(
'value' => array( 'country_code', 'region_code', 'zip', 'city' ),
'relation' => 'IN',
),
),
);
if ( $user_ip ) {
$query_args['where']['user_ip'] = array(
'value' => $user_ip,
);
}
$data = ZeroSpam\Includes\DB::query( 'blocked', $query_args );
if ( ! $data ) {
return false;
}
$this->items = $data;
unset( $query_args['limit'] );
unset( $query_args['offset'] );
$data = ZeroSpam\Includes\DB::query( 'blocked', $query_args );
$total_items = count( $data );
$this->set_pagination_args(
array(
'total_items' => $total_items,
'per_page' => $per_page,
'total_pages' => ceil( $total_items / $per_page ),
'orderby' => $orderby,
'order' => $order,
)
);
$this->_column_headers = array( $columns, $hidden, $sortable );
$paging_options = array();
if ( ! empty( $query_args['where'] ) ) {
foreach ( $query_args['where'] as $key => $value ) {
switch ( $key ) {
case 'blocked_type':
$paging_options['type'] = $value['value'];
break;
case 'user_ip':
$paging_options['s'] = $value['value'];
break;
}
}
}
$_SERVER['REQUEST_URI'] = add_query_arg( $paging_options, $_SERVER['REQUEST_URI'] );
}
/**
* Add more filters
*/
public function extra_tablenav( $which ) {
if ( 'top' !== $which ) {
return;
}
?>
' . __( 'Filter by type', 'zero-spam' ) . '';
$options = apply_filters( 'zerospam_types', array() );
$current_type = ! empty( $_REQUEST['type'] ) ? sanitize_text_field( $_REQUEST['type'] ) : false;
?>
'',
'date_added' => __( 'Date', 'zero-spam' ),
'location' => __( 'Location', 'zero-spam' ),
'blocked_type' => __( 'Type', 'zero-spam' ),
'start_block' => __( 'Starts', 'zero-spam' ),
'end_block' => __( 'Ends', 'zero-spam' ),
'reason' => __( 'Reason', 'zero-spam' ),
'actions' => __( 'Actions', 'zero-spam' ),
);
return $columns;
}
/**
* Sortable columns
*/
public function get_sortable_columns() {
$sortable_columns = array(
'date_added' => array( 'date_added', false ),
'blocked_type' => array( 'blocked_type', false ),
'start_block' => array( 'start_block', false ),
'end_block' => array( 'end_block', false ),
'location' => array( 'blocked_key', false ),
);
return $sortable_columns;
}
/**
* Column contact
*/
public function column_cb( $item ) {
return sprintf(
'',
/*$1%s*/ 'ids',
/*$2%s*/ $item['blocked_id']
);
}
/**
* Process bulk actions
*/
public function process_bulk_action() {
global $wpdb;
$ids = ( isset( $_REQUEST['ids'] ) ) ? sanitize_text_field( wp_unslash( $_REQUEST['ids'] ) ) : '';
switch ( $this->current_action() ) {
case 'delete':
$nonce = ( isset( $_REQUEST['zerospam_nonce'] ) ) ? sanitize_text_field( wp_unslash( $_REQUEST['zerospam_nonce'] ) ) : '';
if ( ! wp_verify_nonce( $nonce, 'zerospam_nonce' ) ) {
return false;
}
if ( ! empty( $ids ) && is_array( $ids ) ) {
foreach ( $ids as $k => $blocked_id ) {
ZeroSpam\Includes\DB::delete( 'blocked', 'blocked_id', $blocked_id );
}
}
break;
case 'delete_all':
// ZeroSpam\Includes\DB::delete_all( 'blocked' );
break;
}
}
}