__( 'Zero Spam for WordPress Log', 'zero-spam' ),
'plural' => __( 'Zero Spam for WordPress Logs', 'zero-spam' ),
);
parent::__construct( $args );
}
/**
* Define table columns
*/
public function get_columns() {
$columns = array(
'cb' => '',
'date_recorded' => __( 'Date', 'zero-spam' ),
'log_type' => __( 'Type', 'zero-spam' ),
'user_ip' => __( 'IP Address', 'zero-spam' ),
'country' => __( 'Country', 'zero-spam' ),
'region' => __( 'Region', 'zero-spam' ),
'actions' => __( 'Actions', 'zero-spam' ),
);
return $columns;
}
/**
* Sortable columns
*/
public function get_sortable_columns() {
$sortable_columns = array(
'date_recorded' => array( 'date_recorded', false ),
'log_type' => array( 'log_type', false ),
'user_ip' => array( 'user_ip', false ),
'country' => array( 'country', false ),
'region' => array( 'region', false ),
);
return $sortable_columns;
}
/**
* Checkbox column
*/
public function column_cb( $item ) {
return sprintf(
'',
/*$1%s*/ 'ids',
/*$2%s*/ $item['log_id']
);
}
/**
* Column values
*/
public function column_default( $item, $column_name ) {
switch ( $column_name ) {
case 'log_type':
$value = ! empty( $item[ $column_name ] ) ? $item[ $column_name ] : false;
if ( ! $value ) {
return 'N/A';
}
$type = '';
$types = apply_filters( 'zerospam_types', array() );
if ( ! empty( $types[ $value ] ) ) {
$type .= $types[ $value ]['label'];
} else {
$type .= $value;
}
$type .= '';
return $type;
break;
case 'user_ip':
return '' . $item[ $column_name ] . '';
break;
case 'date_recorded':
$date_time_format = 'm/d/Y g:ia';
return get_date_from_gmt( gmdate( 'Y-m-d H:i:s', strtotime( $item[ $column_name ] ) ), $date_time_format );
break;
case 'actions':
ob_start();
?>
';
if ( $country_name ) {
$return .= $country_name . ' (' . $item[ $column_name ] . ')';
} else {
$return .= $item[ $column_name ];
}
return $return;
}
return 'N/A';
break;
default:
if ( empty( $item[ $column_name ] ) ) {
return 'N/A';
} else {
return $item[ $column_name ];
}
}
}
/**
* Bulk actions
*/
public function get_bulk_actions() {
$actions = array(
'delete' => __( 'Delete Selected', 'zero-spam' ),
'delete_all' => __( 'Delete All Logs', 'zero-spam' ),
);
return $actions;
}
/**
* Hidable columns
*/
public function get_hidden_columns() {
return array();
}
/**
* Get the data
*/
public function prepare_items() {
global $wpdb;
$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 = 1 === $current_page ? false : $per_page * $current_page;
// @codingStandardsIgnoreLine
$order = ! empty( $_REQUEST['order'] ) ? sanitize_key( wp_unslash( $_REQUEST['order'] ) ) : 'desc';
// @codingStandardsIgnoreLine
$orderby = ! empty( $_REQUEST['orderby'] ) ? sanitize_sql_orderby( wp_unslash( $_REQUEST['orderby'] ) ) : 'date_recorded';
$log_type = ! empty( $_REQUEST['type'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['type'] ) ) : false;
$country = ! empty( $_REQUEST['country'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['country'] ) ) : false;
$user_ip = ! empty( $_REQUEST['s'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['s'] ) ) : false;
$database_query_arguments = [];
// Define the database table.
$database_table = $wpdb->prefix . \ZeroSpam\Includes\DB::$tables['log'];
// Order & add extra select statements.
$order_statement = '';
switch ( $orderby ) {
case 'user_ip':
$order_statement = " ORDER BY user_ip $order";
break;
case 'country':
$order_statement = " ORDER BY country $order";
break;
case 'region':
$order_statement = " ORDER BY country $order";
break;
case 'date_recorded':
$order_statement = " ORDER BY date_recorded $order";
break;
case 'log_type':
$order_statement = " ORDER BY log_type $order";
break;
}
// Where.
$where_array = array();
$where_statement = '';
if ( $log_type ) {
$where_array[] = '`log_type` = %s';
$database_query_arguments[] = $log_type;
}
if ( $country ) {
$where_array[] = '`country` = %s';
$database_query_arguments[] = $country;
}
if ( $user_ip ) {
$where_array[] = '`user_ip` = %s';
$database_query_arguments[] = $user_ip;
}
if ( $where_array ) {
$where_statement .= 'WHERE ';
$where_statement .= implode( ' AND ', $where_array );
}
// Limit.
$limit_statement = "LIMIT $per_page";
if ( $offset ) {
$limit_statement .= ", $offset";
}
$database_query = $wpdb->prepare(
"SELECT * FROM `$database_table`$where_statement$order_statement $limit_statement",
$database_query_arguments
);
$data = $wpdb->get_results( $database_query, ARRAY_A );
if ( ! $data ) {
return false;
}
// Get total number of rows.
$count_query = "SELECT COUNT(*) FROM $database_table ";
$total_items = $wpdb->get_var( $count_query );
$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 );
$this->items = $data;
$paging_options = array();
if ( $log_type ) {
$paging_options['log_type'] = $log_type;
}
if ( $country ) {
$paging_options['country'] = $country;
}
if ( $user_ip ) {
$paging_options['s'] = $user_ip;
}
// @codingStandardsIgnoreLine
$_SERVER['REQUEST_URI'] = add_query_arg( $paging_options, wp_unslash( $_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;
?>
' . __( 'Filter by country', 'zero-spam' ) . '';
$current_country = ! empty( $_REQUEST['country'] ) ? sanitize_text_field( $_REQUEST['country'] ) : false;
?>
current_action() ) {
case 'delete':
if ( ! empty( $ids ) && is_array( $ids ) ) {
foreach ( $ids as $k => $log_id ) {
\ZeroSpam\Includes\DB::delete( 'log', 'log_id', $log_id );
}
}
break;
case 'delete_all':
\ZeroSpam\Includes\DB::delete_all( 'log' );
break;
}
}
}