<?php
if ( ! defined( 'ABSPATH' ) ) exit;

if( isset($_GET['delete'] ) &&  ($_GET['delete']=='success'))
    echo '<div class="updated"><p><strong>'.__('User(s) Deleted Successfully','mvp').'</strong></p></div>';

if( ! class_exists( 'WP_List_Table' ) ) {
    require_once( ABSPATH . 'wp-admin/includes/class-wp-list-table.php' );
}

class video_List_Table extends WP_List_Table {
    function __construct() {
        global $status, $page;
        parent::__construct( array('items',));
    }

    function column_default($item, $column_name){  
        switch($column_name){ 
            case 'id':
            case 'UserName':
            case 'UserMail':
            case 'UserIPAddress':
            case 'Date':
                return $item[$column_name];
            default:
            case 'datetime':echo date('j-M-Y',strtotime($item['datetime'])); 
                return false;
            }
        }

    function column_UserName($item){ 
        $actions=array('delete' => sprintf('<a href="?page=%s&action=%s&id=%s">Delete</a>',$_REQUEST['page'],'delete',$item['id']),);
        return sprintf('%1$s%3$s',
        $item['UserName'],
        $item['id'],
        $this->row_actions($actions));
    }

    function column_cb($item){
        return sprintf('<input type="checkbox" name="check[]" value="%1$s" />', $item['id'] );
    }

    function get_columns(){
        $columns = array(
                        'cb'=>'<input type="checkbox"/>',
                        'UserName'=>__('User Name','mvp'),
                        'UserMail'=> __('User Mail','mvp'),
                        'UserIPAddress'=> __('User IP Address','mvp'),
                        'Date'=> __('Created On','mvp')
                    );
        return $columns;
    }

    function get_sortable_columns(){
        $sortable_columns = array('UserName'=> array( __('UserName','mvp'),false), 
                                'UserMail'    => array(__('UserMail','mvp'),false),
                                'UserIPAddress'    => array(__('UserIPAddress','mvp'),false),
                                'Date'    => array(__('Date','mvp'),false),
                            );
        return $sortable_columns;
    }

    function get_bulk_actions() {
        $actions = array('trash' => __('Trash','mvp'));
        return $actions;
    }

    function process_bulk_action() {
        global $wpdb;        
        $users_table = $wpdb->base_prefix . 'mvplayer_users';

        if( 'delete'===$this->current_action() ) {
            if( isset($_REQUEST['id'])){
                $id =  $_REQUEST['id'];
                $screen = get_current_screen();
                $query = "delete  FROM $users_table where id=$id";
                $wpdb->query($query);
                wp_mvplayer_redirect("?page=mv_player_users&delete=success");
            }else{
                wp_mvplayer_redirect("?page=mv_player_users");
            }
        }

        if(isset($check)){
            if( 'trash'===$this->current_action() ) {
                foreach($check as $trashid){
                    $query = "delete  FROM $users_table where id=$trashid ";
                    $wpdb->query($query);
                }

                wp_mvplayer_redirect("?page=mv_player_users&delete=success");
            }
        }
    }

    function prepare_items(){
        global $wpdb;
        $per_page =20;
        $screen = get_current_screen();
        $users_table = $wpdb->base_prefix . 'mvplayer_users';
        $query = "SELECT * FROM $users_table";
        $example_data=$wpdb->get_results($query, ARRAY_A);
        $columns = $this->get_columns();
        $hidden = array();
        $sortable = $this->get_sortable_columns();
        $this->_column_headers = array($columns, $hidden, $sortable);       
        $this->process_bulk_action();
        $tdata = array();

        if(isset($item)){
            foreach($example_data as $k){
                $actions = $this->column_UserName($item) ;
                $tdata[]=array();
                echo $k->UserName;
            }
        }

        if(isset($actions) && isset($k)){
            $data=array( $k, $actions );
        }      

        $data = $example_data;

        if(isset($_REQUEST['orderby'])){
            function usort_reorder($a,$b){
                $orderby = (!empty($_REQUEST['orderby'])) ? $_REQUEST['orderby'] : 'date';
                $order = (!empty($_REQUEST['order'])) ? $_REQUEST['order'] : 'desc';
                $result = strcmp($a[$orderby], $b[$orderby]);
                return ($order==='asc') ? $result : -$result;
            }

            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,'per_page'=> $per_page,
            'total_pages'=>ceil($total_items/$per_page)) );
    }
}
?> 
<div class="wrap">
    <div id="icon-edit" class="icon32"><br/></div>
    <h2><?php echo __('Users','mvp'); ?></h2> 
    <form action="<?php echo MV_PLAYER_URL . 'includes/csvfiledownload.php';?>" method="post">
        <input type="hidden" name="hidden" value="hidden"/>
        <input type="submit" value="<?php echo __('Export','mvp'); ?>" class="button" style="float: right;margin-left: 5px;"/> 
    </form>

    <form id="movies-filter" method="get">
        <input type="hidden" name="page" value="<?php echo $_REQUEST['page'] ?>" />
        <?php 
            $testListTable = new video_List_Table();
            $testListTable->prepare_items();
            $testListTable->search_box('Search','Title');
        ?>
        <div>  <?php $testListTable->display(); ?></div>
    </form>
</div>