*/
class AngellEYE_PayPal_For_Divi_Company_Setting_Class extends WP_List_Table {
var $data = array();
/**
* Hook in methods
* @since 0.1.0
* @access static
*/
/** * ***********************************************************************
* REQUIRED. Set up a constructor that references the parent constructor. We
* use the parent reference to set some default configs.
* ************************************************************************* */
public function __construct() {
global $status, $page;
//Set parent defaults
parent::__construct(array(
'singular' => 'company', //singular name of the listed records
'plural' => 'companies', //plural name of the listed records
'ajax' => true //does this table support ajax?
));
}
/**
* Hook in methods
* @since 0.1.0
* @access static
*/
public static function init() {
add_action('angelleye_paypal_for_divi_company_create_setting', array(__CLASS__, 'angelleye_paypal_for_divi_company_create_setting'));
add_action('angelleye_paypal_for_divi_company_setting_save_field', array(__CLASS__, 'angelleye_paypal_for_divi_company_setting_save_field'));
add_action('angelleye_paypal_for_divi_company_setting', array(__CLASS__, 'angelleye_paypal_for_divi_company_setting'));
}
public function get_data() {
global $wpdb;
$companies = $wpdb->prefix . 'angelleye_paypal_for_divi_companies'; // do not forget about tables prefix
$this->data = $wpdb->get_results("SELECT * FROM `{$companies}`", ARRAY_A);
return $this->data;
}
function column_default($item, $column_name) {
switch ($column_name) {
case 'title':
case 'account_id':
case 'paypal_mode':
return $item[$column_name];
}
}
function column_title($item) {
//Build row actions
$nonce = wp_create_nonce('delete_company' . $item['ID']);
$actions = array(
'edit' => sprintf('%s', sanitize_key($_REQUEST['page']), 'edit', $item['ID'],__('Edit','angelleye_paypal_divi')),
'delete' => sprintf('%s', sanitize_key($_REQUEST['page']), 'delete', $item['ID'],__('Delete','angelleye_paypal_divi'))
);
//Return the title contents
return sprintf('%1$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 ("company")
/* $2%s */ $item['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' => __('PayPal Account Name','angelleye_paypal_divi'),
'account_id' => __('PayPal Account ID','angelleye_paypal_divi'),
'paypal_mode' => __('PayPal Mode','angelleye_paypal_divi')
);
return $columns;
}
function get_sortable_columns() {
$sortable_columns = array(
'title' => array('title', false) //true means it's already sorted
);
return $sortable_columns;
}
function prepare_items() {
global $wpdb; //This is used only if making any database queries
/**
* First, lets decide how many records per page to show
*/
$per_page = 5;
$columns = $this->get_columns();
$hidden = array();
$sortable = $this->get_sortable_columns();
$this->_column_headers = array($columns, $hidden, $sortable);
$this->process_bulk_action();
$data = $this->get_data();
function usort_reorder($a, $b) {
$orderby = (!empty($_REQUEST['orderby'])) ? sanitize_key($_REQUEST['orderby']) : 'ID'; //If no sort, default to title
$order = (!empty($_REQUEST['order'])) ? sanitize_key($_REQUEST['order']) : 'asc'; //If no order, default to asc
$result = strcmp($a[$orderby], $b[$orderby]); //Determine sort order
return ($order === 'asc') ? $result : -$result; //Send final sort direction to usort
}
usort($data, 'usort_reorder');
$current_page = $this->get_pagenum();
$total_items = count($data);
$data = array_slice($data, (($current_page - 1) * $per_page), $per_page);
$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
));
}
public static function angelleye_paypal_for_divi_company_setting() {
global $wpdb;
$table = new AngellEYE_PayPal_For_Divi_Company_Setting_Class();
$table_name_company = $wpdb->prefix . "angelleye_paypal_for_divi_companies";
if (isset($_GET['action']) && sanitize_key($_GET['action']) == 'delete') {
if (isset($_GET['cmp_id']) && !empty(sanitize_key($_GET['cmp_id']))) {
$obj_company_operation_delete = new AngellEYE_PayPal_For_Divi_Company_Operations();
$get_current_id = $wpdb->get_row("SELECT ID FROM $table_name_company where ID='".sanitize_key($_GET['cmp_id'])."'");
if (isset($get_current_id->ID) && !empty($get_current_id->ID)) {
$delete_result = $obj_company_operation_delete->paypal_for_divi_delete_company();
if (!$delete_result) {
?>
' . __('Something went wrong item not deleted.', 'angelleye_paypal_divi') . ''; ?>