@@ -52,6 +52,9 @@ class admin_list_table extends WP_List_Table {

     return $wpdb->get_var($sql);

   }

+  /*

+   * 그외 컬럼의 값

+   */

   public function column_default($item, $column_name) {

     switch ($column_name) {

     case 'address':

@@ -62,12 +65,18 @@ class admin_list_table extends WP_List_Table {

     }

   }

+  /*

+   * cb 컬럼의 값

+   */

   function column_cb($item) {

     return sprintf(

       '<input type="checkbox" name="bulk-delete[]" value="%s" />', $item['ID']

     );

   }

+  /*

+   * name 컬럼의 값

+   */

   function column_name($item) {

     $delete_nonce = wp_create_nonce('delete_item');

@@ -32,9 +32,7 @@ class admin_list_table extends WP_List_Table {

     $sql .= " LIMIT $per_page";

     $sql .= ' OFFSET ' . ($page_number - 1) * $per_page;

-    $result = $wpdb->get_results($sql, 'ARRAY_A');

-

-    return $result;

+    return $wpdb->get_results($sql, 'ARRAY_A');

   }

   public function delete_item($id) {

@@ -19,7 +19,6 @@ class admin_list_table extends WP_List_Table {

     return $wpdb->prefix . "customers";

   }

-

   public function get_item_data($per_page = 5, $page_number = 1) {

     global $wpdb;

@@ -131,10 +130,7 @@ class admin_list_table extends WP_List_Table {

     if ('delete' === $this->current_action()) {

       $nonce = esc_attr($_REQUEST['_wpnonce']);

-      if (! wp_verify_nonce($nonce, 'delete_item')) {

-        die('Go get a life script kiddies');

-      }

-      else {

+      if (wp_verify_nonce($nonce, 'delete_item')) {

         $this->delete_item(absint($_GET['customer']));

       }

     }

@@ -14,10 +14,16 @@ class admin_list_table extends WP_List_Table {

     ));

   }

+  protected function get_table_name() {

+    global $wpdb;

+    return $wpdb->prefix . "customers";

+  }

+

+

   public function get_item_data($per_page = 5, $page_number = 1) {

     global $wpdb;

-    $sql = "SELECT * FROM {$wpdb->prefix}customers";

+    $sql = "SELECT * FROM ". $this->get_table_name();

     if (!empty($_REQUEST['orderby'])) {

       $sql .= ' ORDER BY ' . esc_sql($_REQUEST['orderby']);

@@ -36,7 +42,7 @@ class admin_list_table extends WP_List_Table {

     global $wpdb;

     $wpdb->delete(

-      "{$wpdb->prefix}customers",

+      $this->get_table_name(),

       array('ID' => $id),

       array('%d')

     );

@@ -45,7 +51,7 @@ class admin_list_table extends WP_List_Table {

   public function record_count() {

     global $wpdb;

-    $sql = "SELECT COUNT(*) FROM {$wpdb->prefix}customers";

+    $sql = "SELECT COUNT(*) FROM ". $this->get_table_name();

     return $wpdb->get_var($sql);

   }

@@ -14,7 +14,7 @@ class admin_list_table extends WP_List_Table {

     ));

   }

-  public function get_customers($per_page = 5, $page_number = 1) {

+  public function get_item_data($per_page = 5, $page_number = 1) {

     global $wpdb;

     $sql = "SELECT * FROM {$wpdb->prefix}customers";

@@ -32,7 +32,7 @@ class admin_list_table extends WP_List_Table {

     return $result;

   }

-  public function delete_customer($id) {

+  public function delete_item($id) {

     global $wpdb;

     $wpdb->delete(

@@ -66,7 +66,7 @@ class admin_list_table extends WP_List_Table {

   }

   function column_name($item) {

-    $delete_nonce = wp_create_nonce('delete_customer');

+    $delete_nonce = wp_create_nonce('delete_item');

     $title = '<strong>' . $item['name'] . '</strong>';

@@ -118,18 +118,18 @@ class admin_list_table extends WP_List_Table {

       'per_page'    => $per_page //WE have to determine how many items to show on a page

     ));

-    $this->items = $this->get_customers($per_page, $current_page);

+    $this->items = $this->get_item_data($per_page, $current_page);

   }

   public function process_bulk_action() {

     if ('delete' === $this->current_action()) {

       $nonce = esc_attr($_REQUEST['_wpnonce']);

-      if (! wp_verify_nonce($nonce, 'delete_customer')) {

+      if (! wp_verify_nonce($nonce, 'delete_item')) {

         die('Go get a life script kiddies');

       }

       else {

-        $this->delete_customer(absint($_GET['customer']));

+        $this->delete_item(absint($_GET['customer']));

       }

     }

@@ -138,7 +138,7 @@ class admin_list_table extends WP_List_Table {

       $delete_ids = esc_sql($_POST['bulk-delete']);

       foreach ($delete_ids as $id) {

-        $this->delete_customer($id);

+        $this->delete_item($id);

       }

     }

   }

@@ -11,10 +11,10 @@ class admin_list_table extends WP_List_Table {

       'plural'   => 'Customers', //plural name of the listed records

       'ajax'     => false,       //should this table support ajax?

       'screen'   => null

-   ));

+    ));

   }

-  public static function get_customers($per_page = 5, $page_number = 1) {

+  public function get_customers($per_page = 5, $page_number = 1) {

     global $wpdb;

     $sql = "SELECT * FROM {$wpdb->prefix}customers";

@@ -32,17 +32,17 @@ class admin_list_table extends WP_List_Table {

     return $result;

   }

-  public static function delete_customer($id) {

+  public function delete_customer($id) {

     global $wpdb;

     $wpdb->delete(

       "{$wpdb->prefix}customers",

       array('ID' => $id),

       array('%d')

-   );

+    );

   }

-  public static function record_count() {

+  public function record_count() {

     global $wpdb;

     $sql = "SELECT COUNT(*) FROM {$wpdb->prefix}customers";

@@ -62,7 +62,7 @@ class admin_list_table extends WP_List_Table {

   function column_cb($item) {

     return sprintf(

       '<input type="checkbox" name="bulk-delete[]" value="%s" />', $item['ID']

-   );

+    );

   }

   function column_name($item) {

@@ -84,7 +84,7 @@ class admin_list_table extends WP_List_Table {

       'name'    => 'Name',

       'address' => 'Address',

       'city'    => 'City'

-   );

+    );

     return $columns;

   }

@@ -93,7 +93,7 @@ class admin_list_table extends WP_List_Table {

     $sortable_columns = array(

       'name' => array('name', true),

       'city' => array('city', true)

-   );

+    );

     return $sortable_columns;

   }

@@ -107,21 +107,39 @@ class admin_list_table extends WP_List_Table {

   public function prepare_items() {

     $this->_column_headers = $this->get_column_info();

-    /** Process bulk action */

     $this->process_bulk_action();

     $per_page     = $this->get_items_per_page('customers_per_page', 5);

     $current_page = $this->get_pagenum();

-    $total_items  = self::record_count();

+    $total_items  = $this->record_count();

     $this->set_pagination_args(array(

       '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);

+    $this->items = $this->get_customers($per_page, $current_page);

   }

   public function process_bulk_action() {

+    if ('delete' === $this->current_action()) {

+      $nonce = esc_attr($_REQUEST['_wpnonce']);

+

+      if (! wp_verify_nonce($nonce, 'delete_customer')) {

+        die('Go get a life script kiddies');

+      }

+      else {

+        $this->delete_customer(absint($_GET['customer']));

+      }

+    }

+

+    if ((isset($_POST['action']) && $_POST['action'] == 'bulk-delete')

+      || (isset($_POST['action2']) && $_POST['action2'] == 'bulk-delete')) {

+      $delete_ids = esc_sql($_POST['bulk-delete']);

+

+      foreach ($delete_ids as $id) {

+        $this->delete_customer($id);

+      }

+    }

   }

 }

new file mode 100644

@@ -0,0 +1,127 @@

+<?php

+

+if(!class_exists('WP_List_Table')) {

+  require_once(ABSPATH . 'wp-admin/includes/class-wp-list-table.php');

+}

+

+class admin_list_table extends WP_List_Table {

+  public function __construct() {

+    parent::__construct(array(

+      'singular' => 'Customer',  //singular name of the listed records

+      'plural'   => 'Customers', //plural name of the listed records

+      'ajax'     => false,       //should this table support ajax?

+      'screen'   => null

+   ));

+  }

+

+  public static function get_customers($per_page = 5, $page_number = 1) {

+    global $wpdb;

+

+    $sql = "SELECT * FROM {$wpdb->prefix}customers";

+

+    if (!empty($_REQUEST['orderby'])) {

+      $sql .= ' ORDER BY ' . esc_sql($_REQUEST['orderby']);

+      $sql .= ! empty($_REQUEST['order']) ? ' ' . esc_sql($_REQUEST['order']) : ' ASC';

+    }

+

+    $sql .= " LIMIT $per_page";

+    $sql .= ' OFFSET ' . ($page_number - 1) * $per_page;

+

+    $result = $wpdb->get_results($sql, 'ARRAY_A');

+

+    return $result;

+  }

+

+  public static function delete_customer($id) {

+    global $wpdb;

+

+    $wpdb->delete(

+      "{$wpdb->prefix}customers",

+      array('ID' => $id),

+      array('%d')

+   );

+  }

+

+  public static function record_count() {

+    global $wpdb;

+

+    $sql = "SELECT COUNT(*) FROM {$wpdb->prefix}customers";

+    return $wpdb->get_var($sql);

+  }

+

+  public function column_default($item, $column_name) {

+    switch ($column_name) {

+    case 'address':

+    case 'city':

+      return $item[$column_name];

+    default:

+      return print_r($item, true); //Show the whole array for troubleshooting purposes

+    }

+  }

+

+  function column_cb($item) {

+    return sprintf(

+      '<input type="checkbox" name="bulk-delete[]" value="%s" />', $item['ID']

+   );

+  }

+

+  function column_name($item) {

+    $delete_nonce = wp_create_nonce('delete_customer');

+

+    $title = '<strong>' . $item['name'] . '</strong>';

+

+    $actions = array(

+      'delete' => sprintf('<a href="?page=%s&action=%s&customer=%s&_wpnonce=%s">Delete</a>',

+      esc_attr($_REQUEST['page']), 'delete', absint($item['ID']), $delete_nonce)

+    );

+

+    return $title . $this->row_actions($actions);

+  }

+

+  function get_columns() {

+    $columns = array(

+      'cb'      => '<input type="checkbox" />',

+      'name'    => 'Name',

+      'address' => 'Address',

+      'city'    => 'City'

+   );

+

+    return $columns;

+  }

+

+  public function get_sortable_columns() {

+    $sortable_columns = array(

+      'name' => array('name', true),

+      'city' => array('city', true)

+   );

+

+    return $sortable_columns;

+  }

+

+  public function get_bulk_actions() {

+    $actions = array('bulk-delete' => 'Delete');

+

+    return $actions;

+  }

+

+  public function prepare_items() {

+    $this->_column_headers = $this->get_column_info();

+

+    /** Process bulk action */

+    $this->process_bulk_action();

+

+    $per_page     = $this->get_items_per_page('customers_per_page', 5);

+    $current_page = $this->get_pagenum();

+    $total_items  = self::record_count();

+

+    $this->set_pagination_args(array(

+      '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);

+  }

+

+  public function process_bulk_action() {

+  }

+}