. * For questions related to this program contact post@webraketen-media.de */ namespace SeoAutomatedLinkBuilding; if ( is_admin() && ! class_exists('\WP_List_Table') ) { require_once ABSPATH . 'wp-admin/includes/class-wp-list-table.php'; } class Statistic_List extends \WP_List_Table { public function prepare_items() { $this->process_bulk_action(); $columns = $this->get_columns(); $hidden = []; $sortable = $this->get_sortable_columns(); $this->_column_headers = [$columns, $hidden, $sortable]; $search = isset($_POST['s']) ? sanitize_text_field($_POST['s']) : ''; $active = isset($_REQUEST['active']) ? $_REQUEST['active'] === '1' : null; $select = Statistic::query() ->order_by('created_at', 'desc') ->limit(100); if(!empty($search)) { $select = $select->where('title', 'LIKE', '%' . Statistic::wpdb()->esc_like($search) . '%'); } if(!is_null($active)) { $select = $select->where('active', $active); } $this->items = $select->get(); } public function get_columns() { return [ 'title' => __('Title'), 'link_id' => 'Link ID', 'destination_url' => __('Destination Url', Plugin::$domain), 'source_url' => __('Source Url', Plugin::$domain), 'created_at' => __('Date', Plugin::$domain), ]; } public function get_bulk_actions() { return []; } public function process_bulk_action() { $action = $this->current_action(); if ( ! $action ) { return; } if ($action === 'reset') { check_admin_referer( 'bulk-action-reset-statistic' ); Statistic::query()->delete()->execute(); add_action('admin_notices', function () { echo '

' . esc_html__('Statistik wurde zurückgesetzt.', Plugin::$domain) . '

'; }); } } protected function column_default($item, $column_name) { return '' . $item->{$column_name}; } protected function column_title($item) { return sprintf( '%s', esc_html($item->title) ); } protected function column_source_url($item) { $url = (string) $item->source_url; return sprintf( '%s', esc_url($url), esc_html($url) ); } protected function column_destination_url($item) { $url = (string) $item->destination_url; return sprintf( '%s', esc_url($url), esc_html($url) ); } public function no_items() { _e( 'No Statistic available.', Plugin::$domain ); } public function preDisplay() { $this->prepare_items(); } public function display() { $base = admin_url("admin.php?page=seo-automated-link-building-statistic"); $reset_url = add_query_arg(['action' => 'reset'], $base); $reset_url = wp_nonce_url($reset_url, "bulk-action-reset-statistic"); echo '' . esc_html(__('Reset statistics', Plugin::$domain)) . ''; $this->search_box(__('Search'), Plugin::$domain); parent::display(); } }