.
* 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 Links_List extends \WP_List_Table {
protected $limit = 50;
protected $offset = 0;
public function __construct() {
parent::__construct( [
'singular' => 'seo_automated_link_building_link',
'plural' => 'seo_automated_link_building_links',
'ajax' => false,
] );
}
public function setLimit( $limit ) {
$this->limit = $limit;
}
public function get_bulk_actions() {
return [
'delete' => __( 'Delete' ),
'activate' => __( 'Activate' ),
'deactivate' => __( 'Deactivate' ),
'export' => __( 'Export', 'seo-automated-link-building' )
];
}
public function no_items() {
_e( 'No links available.', 'seo-automated-link-building' );
}
public function display() {
$this->prepare_items();
$this->search_box( __( 'Search' ), 'seo-automated-link-building' );
parent::display(); // TODO: Change the autogenerated stub
}
public function prepare_items() {
$this->process_bulk_action();
$columns = $this->get_columns();
$hidden = [];
$sortable = $this->get_sortable_columns();
$this->_column_headers = [ $columns, $hidden, $sortable ];
$currentPage = $this->get_pagenum();
$offset = ( $currentPage - 1 ) * $this->limit;
$search = isset( $_POST['s'] ) ? sanitize_text_field( $_POST['s'] ) : '';
$active = isset( $_REQUEST['active'] ) ? $_REQUEST['active'] === '1' : null;
$orderBy = isset( $_REQUEST['orderby'] ) ? sanitize_sql_orderby( $_REQUEST['orderby'] ) : 'title';
$order = isset( $_REQUEST['order'] ) && $_REQUEST['order'] === 'desc' ? 'desc' : 'asc';
$select = Link::query()->limit( $this->limit )->offset( $offset )->order_by( $orderBy, $order );
if ( ! empty( $search ) ) {
$select = $select->where( 'title', 'LIKE', '%' . Link::wpdb()->esc_like( $search ) . '%' );
}
if ( ! is_null( $active ) ) {
$select = $select->where( 'active', $active );
}
$this->items = $select->get();
$all = Link::query()->select( "count(*)" );
if ( ! empty( $search ) ) {
$all = $all->where( 'title', 'LIKE', '%' . Link::wpdb()->esc_like( $search ) . '%' );
}
$this->set_pagination_args( array(
'total_items' => $all->get_var(),
'per_page' => $this->limit,
) );
}
public function process_bulk_action() {
$action = $this->current_action();
if ( ! $action ) {
return;
}
// Row-Action (Einzelaktion via GET mit eigener Nonce)
if ( isset( $_GET['id'] ) && is_scalar( $_GET['id'] ) && isset( $_GET['_wpnonce'] ) ) {
$id = (int) $_GET['id'];
// Nonce-Action-Namen je Aktion/ID (muss zu wp_nonce_url unten passen)
$nonce_action = "row-action-{$action}-{$id}";
check_admin_referer( $nonce_action );
$ids = [ $id ];
}
else {
check_admin_referer( 'bulk-' . $this->_args['plural'] );
$ids = isset( $_REQUEST['id'] ) ? wp_parse_id_list( $_REQUEST['id'] ) : [];
}
if ( empty( $ids ) ) {
return;
}
if ( $action === 'delete' && isset( $_REQUEST['id'] ) ) {
Link::query()->delete()->where( 'id', 'in', [ $ids ] )->execute();
}
if ( $action === 'deactivate' && isset( $_REQUEST['id'] ) ) {
Link::query()->update()->where( 'id', 'in', [ $ids ] )->set( 'active', false )->execute();
}
if ( $action === 'activate' ) {
Link::query()->update()->where( 'id', 'in', [ $ids ] )->set( 'active', true )->execute();
}
}
public function get_columns() {
return [
'cb' => '',
'title' => __( 'Title' ),
'keywords' => __( 'Keywords', 'seo-automated-link-building' ),
'url' => __( 'Page' ) . ' / ' . __( 'Url' ),
'status' => __( 'Status' ),
'priority' => __( 'Priority', 'seo-automated-link-building' )
];
}
function get_sortable_columns() {
return [
'title' => [ 'title', true ],
'keywords' => [ 'keywords', true ],
'url' => [ 'url', true ],
'status' => [ 'status', true ],
'priority' => [ 'priority', true ],
];
}
protected function column_default( $item, $column_name ) {
return $item->{$column_name};
}
protected function column_cb( $item ) {
return sprintf( '', $item->id );
}
protected function column_title( $item ) {
$base = admin_url("admin.php?page=seo-automated-link-building-all-links");
$edit_url = add_query_arg(['id' => $item->id], $base);
$toggle_action = $item->active ? 'deactivate' : 'activate';
$toggle_url = add_query_arg(['action' => $toggle_action, 'id' => $item->id], $base);
$toggle_url = wp_nonce_url($toggle_url, "row-action-{$toggle_action}-{$item->id}");
$delete_url = add_query_arg(['action' => 'delete', 'id' => $item->id], $base);
$delete_url = wp_nonce_url($delete_url, "row-action-delete-{$item->id}");
return "{$item->title}
";
}
protected function column_url( $item ) {
$title = $item->url;
$url = $item->url;
if ( $item->page_id ) {
$post = get_post( $item->page_id );
if ( $post ) {
$title = $post->post_title;
$url = get_permalink( $post );
}
}
return "" . htmlentities( $title ) . "";
}
protected function column_keywords( $item ) {
$keywords = json_decode( $item->keywords, false, 512, JSON_UNESCAPED_UNICODE );
if ( ! is_array( $keywords ) ) {
$keywords = [];
}
return implode( '
', $keywords );
}
protected function column_status( $item ) {
return __( $item->active ? 'Active' : 'Deactivated', 'seo-automated-link-building' );
}
}