order = $order; parent::__construct( array( 'singular' => 'audit_order', 'plural' => 'audit_orders', 'ajax' => false, ) ); } public function print_overview() { $this->prepare_items(); echo '
'; echo '
'; echo '

Audit Order List

'; if ( count( $this->items ) == 0 ) { echo '
'; echo '

No changes were made on this order

'; echo '
'; } else { $this->display(); } echo '
'; } public function column_default( $order_audit, $column_name ) { $user = get_user_by( 'id', $order_audit->user_id ); switch ( $column_name ) { case 'username': return get_avatar( $user->ID ) . '' . $user->user_nicename . ''; case 'name': return '' . $user->display_name . ''; case 'action': return '' . $order_audit->action . ''; case 'old_value': if ( $order_audit->is_commission_change == 1 ) { return '$' . number_format( $order_audit->old_value, 2, '.', ',' ) . ''; } else { return '' . $order_audit->old_value . ''; } case 'new_value': if ( $order_audit->is_commission_change == 1 ) { return '$' . number_format( $order_audit->new_value, 2, '.', ',' ) . ''; } else { return '' . $order_audit->new_value . ''; } case 'timestamp': return '' . $order_audit->timestamp . ''; } return ''; } public function display_tablenav( $which ) { echo '
'; } public function get_columns() { $columns = array( 'username' => 'Username', 'name' => 'Name', 'action' => 'Action', 'old_value' => 'Old Value', 'new_value' => 'New Value', 'timestamp' => 'Timestamp', ); return $columns; } public function prepare_items() { /** * Init column headers. */ $this->_column_headers = array( $this->get_columns(), array(), array() ); global $wpdb; $table_name = $wpdb->prefix . 'zacctmgr_acm_order_audit_mapping'; $order_id = $this->order->get_id(); $query = $wpdb->get_results( "SELECT * FROM $table_name WHERE order_id=$order_id ORDER BY timestamp DESC; " ); $this->items = $query; } } ?>