Tag: work

I'm trying to display a WP_List_table table inside a metabox. The metabox is intended for the list of users enrolled in a course (type of course post LifterLMS). The columns in the table contain user_id, username, percentage, and notes. I do not think about the fact that I'm trying to do it for a custom message type. I am only mentioning that for the sake of clarity.

What happens is that everything seems to go on until I click on the Search by id button (the function of the wp search button used) on the custom publication type edit screen. WP_List_Table will be redirected to the page /wp-admin/edit.php by clicking on the search button (after entering the ID in the entry element). And it shows an updated administrative post notice at the top of the editing screen.
What you need to do is to list only the user for whom the administrator has performed a search. The same code that I used on other admin menu pages worked well. All other functions work correctly (ascending order, descending order, order_by). Only problem arises with the search feature.
The code is attached below.
The data

/** Class constructor */
public function __construct() {

    parent::__construct( (
        'singular' => __( 'Student', WOOSUB_TEXT_DOMAIN ), //singular name of the listed records
        'plural'   => __( 'Students', WOOSUB_TEXT_DOMAIN ), //plural name of the listed records
        'ajax'     => false //does this table support ajax?
    ) );

}

/**
 * Function to filter data based on order , order_by & searched items
 *
 * @param string $orderby
 * @param string $order
 * @param string $search_term
 * @return array $users_array()
 */
public function list_table_data_fun( $orderby='', $order='' , $search_term='' ) {

    $users_array = array();
    $args        = array();
    if( !empty( $search_term ) ) {
        $searchcol= array(
            'ID',
            'user_email',
            'user_login',
            'user_nicename',
            'user_url',
            'display_name'
        );

        $args  = array(
            'fields'         => 'all_with_meta', 
            'orderby'        => $orderby , 
            'order'          => $order , 
            'search'         => $_REQUEST("s") ,
            'search_columns' => $searchcol
            );
        } else {
                if( $order == "asc" && $orderby == "id" ) {
                    $args = array(
                        'orderby'      => 'ID',
                        'order'        => 'ASC',
                    ); 
            } elseif ( $order == "desc" && $orderby == "id"  ) {
                    $args = array(
                        'orderby'      => 'ID',
                        'order'        => 'DESC',
                    );

            } elseif ( $order == "desc" && $orderby == "title"  ) {
                    $args = array(
                        'orderby'      => 'name',
                        'order'        => 'DESC',
                    );
            } elseif ( $order == "asc" && $orderby == "title"  ) {
                $args = array(
                    'orderby'      => 'name',
                    'order'        => 'ASC',
                );
            } else {
                $args = array(
                    'orderby'      => 'ID',
                    'order'        => 'DESC',
                );
            }

        }

        $users = get_users( $args );

        if( count( $users ) > 0 ) {
            foreach ( $users as $index => $user) {
                $author_info = get_userdata( $user->ID );
                if ( $user ) {

                    $users_array() = array(
                        "id"         => $user->ID,
                        "title"      => ' '. $author_info->display_name .'' ,
                        "percentage" => 10,
                        "grade"      => ''. 'A'.''
                    );
                }
                # code...
            }
        }

    return $users_array;
}
//prepare_items
public function prepare_items() {

    $orderby = isset( $_GET('orderby') ) ? trim( $_GET('orderby') ): "";
    $order   = isset( $_GET('order') ) ? trim( $_GET('order') ) : "";

    $search_term  = isset( $_POST('s') ) ? trim( $_POST('s') ) : "";

    if( $search_term == "" ) {

        $search_term  = isset( $_GET('s') ) ? trim( $_GET('s') ) : "";
    }

    $datas        = $this->list_table_data_fun( $orderby, $order, $search_term );


    $per_page     = 3;
    $current_page = $this->get_pagenum();
    $total_items  = count($datas);

    $this->set_pagination_args( array( "total_items"=> $total_items,
        "per_page" => $per_page ) );

    $this->items = array_slice( $datas, ( ( $current_page - 1 )* $per_page ), $per_page );

    $columns  = $this->get_columns();
    $hidden   = $this->get_hidden_columns();
    $sortable = $this->get_sortable_columns();

    $this->_column_headers = array( $columns, $hidden, $sortable );
}
    //get_columns
public function get_columns() {

    $columns = array(
        "cb"         => "",
        "id"         => "ID",
        "title"      => "User Name",
        "percentage" => "Percentage",
        "grade"      => "Grade",
        "action"     => "Action"        
    );

    return $columns;
}

public function get_hidden_columns() {
    return array("");
}

public function get_sortable_columns() {
        return array (
        "title" => array( "title", true ),
        "id"    => array( "id", true ),
    );

}   

//column_default
public function column_default( $item, $column_name ){
    switch ( $column_name ) {
        case 'id':


        case 'title':


        case 'percentage':

        case 'grade':
        return $item( $column_name );
        case 'action':  
            if ( isset ( $_GET('page') ) ){
                $page = $_GET('page');
            } else {
                global $pagenow;
                $page = $pagenow;
            }
            return 'Edit';

        default:
            return "no value";

    }

}
protected function display_tablenav( $which ) {

    // REMOVED NONCE -- INTERFERING WITH SAVING POSTS ON METABOXES
    // Add better detection if this class is used on meta box or not.

    // if ( 'top' == $which ) {
    //  wp_nonce_field( 'bulk-' . $this->_args('plural') );
    // }

}

public function column_title( $item ) {
    if ( isset ( $_GET('page') ) ){
        $page = $_GET('page');
    } else {
        global $pagenow;
        $page = $pagenow;
    }
    $action = array(
            "edit" => sprintf('Edit',$page,'llmsgb-edit',$item('id')));
    return sprintf('%1$s %2$s', $item('title'),$this->row_actions( $action ) );
}

}

function list_table_layout () {

$ myRequestTable = new List_Table_Class ();

global $pagenow;
?>
Students Grades Information



    prepare_items();  ?>
    search_box( __( 'Search Students By ID' ), 'students' ); //Needs To be called after $myRequestTable->prepare_items() ?>
    display(); ?>

}
list_table_layout ();