"; print_r($result); echo ""; return $result; } /** * Returns the count of records in the database. * * @return null|string */ public static function record_count() { global $wpdb, $alertme_table; ; $table_name = $wpdb->prefix . $alertme_table; $sql = "SELECT COUNT(*) FROM (SELECT COUNT(*) FROM $table_name WHERE email_confirm =1 GROUP BY `post_id`) groups"; return $wpdb->get_var( $sql ); } /** Text displayed when no customer data is available */ public function no_items() { _e( 'No Statistics yet.', ALERTME_TXT_DOMAIN ); } /** * Render a column when no column specific method exist. * * @param array $item * @param string $column_name * * @return mixed */ public function column_default( $item, $column_name ) { switch ( $column_name ) { case 'page': return $this->get_post_name($item); case 'Subscribers': return $item[ $column_name ]; default: return print_r( $item, true ); //Show the whole array for troubleshooting purposes } } function get_post_name($item) { return ''.get_the_title($item['page']) . ''; } /** * Associative array of columns * * @return array */ function get_columns() { $columns = [ 'page' => __( 'Page/Post', ALERTME_TXT_DOMAIN ), 'Subscribers' => __( 'Subscribers', ALERTME_TXT_DOMAIN ) ]; return $columns; } /** * Columns to make sortable. * * @return array */ public function get_sortable_columns() { $sortable_columns = array(); return $sortable_columns; } /** * Returns an associative array containing the bulk action * * @return array */ public function get_bulk_actions() { $actions = []; return $actions; } /** * Handles data query and filter, sorting, and pagination. */ public function prepare_items() { $this->_column_headers = $this->get_column_info(); $per_page = $this->get_items_per_page( 'alert_me_per_page', 20 ); $current_page = $this->get_pagenum(); $total_items = self::record_count(); $this->set_pagination_args( [ '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 ] ); $this->items = self::get_customers( $per_page, $current_page ); } } class AlertMe_load_Statistics_page { // class instance static $instance; // customer WP_List_Table object public $customers_obj; // class constructor public function __construct() { add_filter( 'set-screen-option', [ __CLASS__, 'set_screen' ], 10, 3 ); add_action( 'admin_menu', [ $this, 'plugin_menu' ] ); } public static function set_screen( $status, $option, $value ) { return $value; } public function plugin_menu() { $hook = add_submenu_page( 'alert_me_settings', 'Statistics', 'Statistics', 'manage_options', 'alert-me-statistics', [ $this, 'alert_me_statistics' ]); add_action( "load-$hook", [ $this, 'screen_option' ] ); } /** * Plugin settings page */ public function alert_me_statistics() { global $wpdb, $alertme_table; $table_name = $wpdb->prefix . $alertme_table; $sql_max = "SELECT `post_id` as page, COUNT(*) as Subscribers FROM $table_name WHERE email_confirm =1 GROUP BY `post_id` ORDER BY Subscribers DESC LIMIT 1"; $sql_min = "SELECT `post_id` as page, COUNT(*) as Subscribers FROM $table_name WHERE email_confirm =1 GROUP BY `post_id` ORDER BY Subscribers ASC LIMIT 1"; $result_max = $wpdb->get_row( $sql_max, 'ARRAY_A' ); $result_min = $wpdb->get_row( $sql_min, 'ARRAY_A' ); ?>