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

Audit Log

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

No changes were made on this account manager

'; echo '
'; } else { $this->display(); } echo '
'; } public function column_default( $manager_audit, $column_name ) { $user = get_user_by( 'id', $manager_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 '' . $manager_audit->action . ''; case 'old_value': return '' . $manager_audit->old_value . ''; case 'new_value': return '' . $manager_audit->new_value . ''; case 'timestamp': return '' . $manager_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_manager_commission_audit_mapping'; $query = $wpdb->get_results( "SELECT * FROM $table_name WHERE manager_id=$this->manager_id ORDER BY timestamp DESC; " ); $this->items = $query; } } ?>