__('Download', 'simple-download-monitor'), //singular name of the listed records
'plural' => __('Downloads', 'simple-download-monitor'), //plural name of the listed records
'ajax' => false //does this table support ajax?
));
}
function column_default($item, $column_name) {
switch ($column_name) {
case 'URL':
case 'visitor_ip':
case 'date':
return $item[$column_name];
case 'visitor_country':
return $item[$column_name];
case 'visitor_name':
return $item[$column_name];
default:
return print_r($item, true); //Show the whole array for troubleshooting purposes
}
}
function column_title($item) {
$delete_log_nonce = wp_create_nonce('sdm_delete_log_entry');
//Build row actions
$actions = array(
'edit' => sprintf('' . __('Edit', 'simple-download-monitor') . ''),
'delete' => sprintf('' . __('Delete', 'simple-download-monitor') . '', 'delete', $item['ID'], $item['row_id'], $delete_log_nonce),
);
//Return the title contents
return sprintf('%1$s (id:%2$s)%3$s',
/* $1%s */ $item['title'],
/* $2%s */ $item['ID'],
/* $3%s */ $this->row_actions($actions)
);
}
function column_cb($item) {
return sprintf(
'',
/* $1%s */ $this->_args['singular'], //Let's simply repurpose the table's singular label ("Download")
/* $2%s */ $item['row_id'] //The value of the checkbox should be the record's id
);
}
function get_columns() {
$columns = array(
'cb' => '', //Render a checkbox instead of text
'title' => __('Title', 'simple-download-monitor'),
'URL' => __('File', 'simple-download-monitor'),
'visitor_ip' => __('Visitor IP', 'simple-download-monitor'),
'date' => __('Date', 'simple-download-monitor'),
'visitor_country' => __('Country', 'simple-download-monitor'),
'visitor_name' => __('Username', 'simple-download-monitor')
);
return $columns;
}
function get_sortable_columns() {
$sortable_columns = array(
'title' => array('post_title', false), //true means it's already sorted
'URL' => array('file_url', false),
'visitor_ip' => array('visitor_ip', false),
'date' => array('date_time', false),
'visitor_country' => array('visitor_country', false),
'visitor_name' => array('visitor_name', false)
);
return $sortable_columns;
}
function get_bulk_actions() {
$actions = array();
$actions['delete2'] = __('Delete Permanently', 'simple-download-monitor');
return $actions;
}
function process_bulk_action() {
// if bulk 'Delete Permanently' was clicked
if ('delete2' === $this->current_action()) {
//Check bulk delete nonce
$nonce = filter_input(INPUT_POST, '_wpnonce', FILTER_SANITIZE_STRING);
$action = 'bulk-' . $this->_args['plural'];
if (!wp_verify_nonce($nonce, $action)){
wp_die(__('Nope! Security check failed!', 'simple-download-monitor'));
}
if (!isset($_POST['download']) || $_POST['download'] == null) {
echo '
' . __('No entries were selected.', 'simple-download-monitor') . '
' . __('Click to Dismiss', 'simple-download-monitor') . '
';
return;
}
foreach ($_POST['download'] as $item) {
$row_id = sanitize_text_field($item);
if (!is_numeric($row_id)){
wp_die(__('Error! The row id value of a log entry must be numeric.', 'simple-download-monitor'));
}
global $wpdb;
$del_row = $wpdb->query('DELETE FROM ' . $wpdb->prefix . 'sdm_downloads WHERE id = "' . $row_id . '"');
}
if ($del_row) {
echo '
' . __('Click to Dismiss', 'simple-download-monitor') . '
';
} else {
echo '
' . __('Error', 'simple-download-monitor') . '
' . __('Click to Dismiss', 'simple-download-monitor') . '
';
}
}
}
function prepare_items() {
global $wpdb; //This is used only if making any database queries
$per_page = apply_filters('sdm_download_logs_menu_items_per_page', 50);
$columns = $this->get_columns();
$hidden = array();
$sortable = $this->get_sortable_columns();
$current_page = $this->get_pagenum();
$this->_column_headers = array($columns, $hidden, $sortable);
$this->process_bulk_action();
// Grab the sort inputs then sanitize the values before using it in the query. Use a whitelist approach to sanitize it.
$orderby_column = isset($_GET['orderby'])? sanitize_text_field($_GET['orderby']):'';
$sort_order = isset($_GET['order'])? sanitize_text_field($_GET['order']):'';
if(empty($orderby_column)){
$orderby_column = "date_time";
$sort_order = "DESC";
}
$orderby_column = sdm_sanitize_value_by_array($orderby_column, array('post_title'=>'1', 'file_url'=>'1', 'visitor_ip'=>'1', 'date_time'=>'1', 'visitor_country'=>'1', 'visitor_name'=>'1'));
$sort_order = sdm_sanitize_value_by_array($sort_order, array('DESC' => '1', 'ASC' => '1'));
//Do a query to find the total number of rows then calculate the query limit
$table_name = $wpdb->prefix . 'sdm_downloads';
if(isset($_REQUEST['sdm_logs_dl_id']) && !empty($_REQUEST['sdm_logs_dl_id'])){
//For specific download logs
$dl_id = sanitize_text_field($_REQUEST['sdm_logs_dl_id']);
$query = "SELECT COUNT(*) FROM $table_name WHERE post_id = $dl_id";
$total_items = $wpdb->get_var($query);//For pagination requirement
$query = "SELECT * FROM $table_name WHERE post_id = $dl_id ORDER BY $orderby_column $sort_order";
} else {
//For all download logs
$query = "SELECT COUNT(*) FROM $table_name";
$total_items = $wpdb->get_var($query);//For pagination requirement
$query = "SELECT * FROM $table_name ORDER BY $orderby_column $sort_order";
}
$offset = ($current_page - 1) * $per_page;
$query.=' LIMIT ' . (int) $offset . ',' . (int) $per_page;//Limit to query to only load a limited number of records
$data_results = $wpdb->get_results($query);
//Prepare the array with the correct index names that the table is expecting.
$data = array();
foreach ($data_results as $data_result) {
$data[] = array('row_id' => $data_result->id, 'ID' => $data_result->post_id, 'title' => $data_result->post_title, 'URL' => $data_result->file_url, 'visitor_ip' => $data_result->visitor_ip, 'date' => $data_result->date_time, 'visitor_country' => $data_result->visitor_country, 'visitor_name' => $data_result->visitor_name);
}
// Now we add our *sorted* data to the items property, where it can be used by the rest of the class.
$this->items = $data;
$this->set_pagination_args(array(
'total_items' => $total_items, //WE have to calculate the total number of items
'per_page' => $per_page, //WE have to determine how many items to show on a page
'total_pages' => ceil($total_items / $per_page) //WE have to calculate the total number of pages
));
}
}