'search-submit' ) ); ?>
plugin['slug']; $text = $this->plugin['text']; $title = ! empty( $item['title'] ) ? $item['title'] : esc_attr__( 'Untitle', $this->plugin['text'] ); $edit_url = admin_url( '/admin.php?page=' . esc_attr( $slug ) . '&tab=settings&act=update&id=' . urlencode( $item['ID'] ) ); $duplicate_url = admin_url( '/admin.php?page=' . esc_attr( $slug ) . '&tab=settings&act=duplicate&id=' . urlencode( $item['ID'] ) ); $delete_url = admin_url( '/admin.php?page=' . esc_attr( $slug ) . '&info=delete&did=' . urlencode( $item['ID'] ) ); $actions = array( 'edit' => '' . esc_attr__( 'Edit', $this->plugin['text'] ) . '', 'duplicate' => '' . esc_attr__( 'Duplicate', $this->plugin['text'] ) . '', 'delete' => '' . esc_attr__( 'Delete', $this->plugin['text'] ) . '', ); return '' . $title . '' . $this->row_actions( $actions ); } /** * Prepare the items for the table to process * * @return Void */ public function prepare_items() { $columns = $this->get_columns(); $hidden = $this->get_hidden_columns(); $sortable = $this->get_sortable_columns(); $data = $this->table_data(); $perPage = 30; $currentPage = $this->get_pagenum(); if ( $data ) { usort( $data, array( &$this, 'sort_data' ) ); $data = array_slice( $data, ( ( $currentPage - 1 ) * $perPage ), $perPage ); } $totalItems = $this->list_count(); $this->_column_headers = array( $columns, $hidden, $sortable ); $this->items = $data; $this->set_pagination_args( array( 'total_items' => $totalItems, 'per_page' => $perPage, 'total_pages' => ceil( $totalItems / $perPage ), ) ); } /** * Override the parent columns method. Defines the columns to use in your listing table * * @return Array */ public function get_columns() { $columns = array( 'cb' => '', 'title' => 'Title', 'code' => 'Shortcode', 'status' => 'Status', 'testmode' => 'Test Mode', ); return $columns; } /** * Define which columns are hidden * * @return Array */ public function get_hidden_columns() { return array(); } /** * Define the sortable columns * * @return array */ public function get_sortable_columns() { return array( 'ID' => array( 'ID', false ), ); } /** * Get the table data * * @return Array */ private function table_data() { global $wpdb; $data = array(); $paged = $this->get_paged(); $offset = $this->per_page * ( $paged - 1 ); $search = $this->get_search(); $table = $this->data; if ( ! $search || empty( $search ) ) { $result = $wpdb->get_results( "SELECT * FROM $table order by id desc" ); } elseif ( is_numeric( $search ) ) { $query = $wpdb->prepare( "SELECT * FROM $table WHERE id=%d", absint( $search ) ); $result = $wpdb->get_results( $query ); } else { $query = $wpdb->prepare( "SELECT * FROM $table WHERE title=%s order by id desc", sanitize_text_field( $search ) ); $result = $wpdb->get_results( $query ); } $slug = $this->plugin['slug']; $shortcode = $this->plugin['shortcode']; $prefix = $this->plugin['prefix']; if ( $result ) { foreach ( $result as $key => $value ) { $param = unserialize( $value->param ); $option_name_view = '_' . $prefix . '_view_counter_' . $value->id; $option_name_action = '_' . $prefix . '_action_counter_' . $value->id; $tool_view = get_option( $option_name_view, '0' ); $tool_action = get_option( $option_name_action, '0' ); if ( ! empty( $tool_view ) ) { $conversion = round( $tool_action / $tool_view * 100, 2 ) . '%'; } else { $conversion = '0%'; } $title = ! empty( $value->title ) ? $value->title : esc_attr__( 'Untitle', $this->plugin['text'] ) ; $check_status = isset( $param['menu_status'] ) ? $param['menu_status'] : 1; $status = ! empty( $check_status ) ? 'Activated' : 'Deactivated'; $testmode = empty( $param['test_mode'] ) ? 'OFF' : 'ON'; $data[] = array( 'ID' => $value->id, 'title' => '' . esc_attr($title) . '', 'code' => '[' . esc_attr($shortcode) . ' id="' . absint($value->id) . '"]', 'view' => $tool_view, 'action' => $tool_action, 'conversion' => $conversion, 'edit' => 'edit', 'delete' => 'delete', 'duplicate' => 'duplicate', 'status' => $status, 'testmode' => $testmode, ); } } return $data; } /** * Retrieve the current page number * * @access public * @return int Current page number * @since 1.5 */ public function get_paged() { return isset( $_GET['paged'] ) ? absint( $_GET['paged'] ) : 1; } /** * Retrieves the search query string * * @access public * @return mixed string If search is present, false otherwise * @since 1.0 */ public function get_search() { return ! empty( $_POST['s'] ) ? urldecode( trim( $_POST['s'] ) ) : false; } public function list_count() { global $wpdb; $data = $this->data; $result = $wpdb->get_results( "SELECT * FROM {$data} order by id asc" ); return count( $result ); } /** * Render the checkbox column * * @access public * * @param array $item Contains all the data for the checkbox column * * @return string Displays a checkbox * @since 1.0 */ public function column_cb( $item ) { return sprintf( '', 'ID', $item['ID'] ); } /** * Retrieve the bulk actions * * @access public * @return array $actions Array of the bulk actions * @since 1.4 */ public function get_bulk_actions() { $actions = array( 'delete-items' => esc_attr__('Delate', $this->plugin['text']), ); return $actions; } /** * Gets the name of the primary column. * * @return string Name of the primary column. * @since 1.0 * @access protected * */ protected function get_primary_column_name() { return 'ID'; } /** * Allows you to sort the data by the variables set in the $_GET * * @return Mixed */ private function sort_data( $a, $b ) { // If no sort, default to title $orderby = ( ! empty( $_GET['orderby'] ) ) ? sanitize_text_field( $_GET['orderby'] ) : 'ID'; // If no order, default to asc $order = ( ! empty( $_GET['order'] ) ) ? sanitize_text_field( $_GET['order'] ) : 'desc'; // Determine sort order $result = strnatcmp( $a[ $orderby ], $b[ $orderby ] ); // Send final sort direction to usort return ( $order === 'asc' ) ? $result : - $result; } }