title, bulk-preloaded once per pageload by * prepare_items() so column_integration_id() avoids a per-row query. * * @var array */ public $title_cache = array(); /** * Construct function * Set default settings. */ function __construct() { global $status, $page; parent::__construct( array( 'ajax' => FALSE, 'singular' => 'log', 'plural' => 'logs', ) ); $this->log = new Advanced_Form_Integration_Log(); } /** * Renders the columns. */ function column_default( $item, $column_name ) { switch ( $column_name ) { case 'id': $value = $item['id']; break; case 'response_code': $value = $item['response_code']; break; case 'integration_id': $value = $item['integration_id']; break; case 'request_data': $value = $item['request_data']; break; case 'response_data': $value = $item['response_data']; break; case 'action': $value = $item['action']; break; default: $value = ''; } return apply_filters( 'adfoin_log_table_column_value', $value, $item, $column_name ); } /** * Retrieve the table columns. */ function get_columns() { $columns = array( 'cb' => '', 'response_code' => esc_html__( 'Status', 'advanced-form-integration' ), 'integration_id' => esc_html__( 'Integration', 'advanced-form-integration' ), 'request_data' => esc_html__( 'Request', 'advanced-form-integration' ), 'response_data' => esc_html__( 'Response', 'advanced-form-integration' ), 'time' => esc_html__( 'Date', 'advanced-form-integration' ), 'actions' => esc_html__( 'Actions', 'advanced-form-integration' ), ); return apply_filters( 'adfoin_log_table_columns', $columns ); } /** * Render the checkbox column. */ public function column_cb( $item ) { return ''; } /** * Render the Integration column — ID shown, full title as tooltip. * If the integration has been deleted, show the ID as plain text * with a muted "(deleted)" note instead of a broken link. */ public function column_integration_id( $item ) { $int_id = absint( $item['integration_id'] ); // Title comes from the bulk preload in prepare_items() — no per-row // Advanced_Form_Integration_Integration construction or SELECT * here. $title = isset( $this->title_cache[ $int_id ] ) ? $this->title_cache[ $int_id ] : ''; if ( $title ) { $edit_url = admin_url( 'admin.php?page=advanced-form-integration&action=edit&id=' . $int_id ); return sprintf( '#%d', esc_url( $edit_url ), esc_attr( $title ), $int_id ); } return sprintf( '#%d %s', esc_attr__( 'This integration no longer exists', 'advanced-form-integration' ), $int_id, esc_html__( 'deleted', 'advanced-form-integration' ) ); } /** * Render the Status / response-code column (badge only — no date). */ public function column_response_code( $item ) { $code = ! empty( $item['response_code'] ) ? $item['response_code'] : __( 'Unknown', 'advanced-form-integration' ); $starting = substr( (string) $code, 0, 1 ); $class = 'code-200'; if ( '4' === $starting ) { $class = 'code-400'; } elseif ( '5' === $starting ) { $class = 'code-500'; } elseif ( ! is_numeric( $code ) ) { $class = 'code-500'; } $label = esc_html( $code ); if ( isset( $item['response_message'] ) && ! empty( $item['response_message'] ) ) { $label .= ' ' . esc_html( $item['response_message'] ) . ''; } return sprintf( '%s', $class, $label ); } /** * Render the Date column. */ public function column_time( $item ) { if ( empty( $item['time'] ) ) { return '—'; } $ts = strtotime( $item['time'] ); $display = date_i18n( 'Y/m/d', $ts ) . '
' . date_i18n( 'g:i a', $ts ) . ''; return sprintf( '%s', esc_attr( $item['time'] ), $display ); } /** * Prepare sanitized preview for log values. * * @param mixed $raw_value Stored value. * @return array{title:string, display:string} */ protected function prepare_log_preview( $raw_value ) { if ( is_string( $raw_value ) ) { $prepared = wp_unslash( $raw_value ); } else { $prepared = wp_json_encode( $raw_value, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES ); } if ( ! is_string( $prepared ) ) { $prepared = ''; } $stripped = trim( wp_strip_all_tags( $prepared ) ); if ( '' === $stripped ) { return array( 'title' => '', 'display' => esc_html__( '(empty)', 'advanced-form-integration' ), ); } if ( function_exists( 'mb_substr' ) ) { $snippet = mb_substr( $stripped, 0, 60 ); if ( mb_strlen( $stripped ) > 60 ) { $snippet .= '…'; } } else { $snippet = substr( $stripped, 0, 60 ); if ( strlen( $stripped ) > 60 ) { $snippet .= '…'; } } return array( 'title' => esc_attr( $stripped ), 'display' => esc_html( $snippet ), ); } /** * Render the request data column. */ public function column_request_data( $item ) { $preview = $this->prepare_log_preview( $item['request_data'] ); printf( '%s', $preview['title'], $preview['display'] ); } /** * Render the response data column. */ public function column_response_data( $item ) { $preview = $this->prepare_log_preview( $item['response_data'] ); printf( '%s', $preview['title'], $preview['display'] ); } /** * Render the Actions column — View, Copy, Delete. */ public function column_actions( $item ) { $log_id = absint( $item['id'] ); $admin_url = admin_url( 'admin.php?page=advanced-form-integration-log' ); $full_log = wp_json_encode( array( 'integration_id' => $item['integration_id'], 'response_code' => $item['response_code'], 'response_message' => $item['response_message'], 'request_data' => json_decode( $item['request_data'], true ), 'response_data' => json_decode( $item['response_data'], true ), 'time' => $item['time'], ) ); $delete_url = wp_nonce_url( add_query_arg( array( 'action' => 'delete', 'log_id' => $log_id ), $admin_url ), 'adfoin_delete_log_nonce' ); $view_url = add_query_arg( array( 'action' => 'view', 'id' => $log_id ), $admin_url ); // Lucide-style stroke SVG icons — modern, consistent 16 × 16 viewBox. $icon_view = ''; $icon_copy = ''; $icon_delete = ''; echo '

'; printf( '%s', esc_url( $view_url ), esc_attr__( 'View Full Log', 'advanced-form-integration' ), $icon_view ); printf( '', esc_attr__( 'Copy Full Log', 'advanced-form-integration' ), esc_attr( $full_log ), $icon_copy ); printf( '%s', esc_url( $delete_url ), esc_attr__( 'Delete Log', 'advanced-form-integration' ), esc_js( __( 'Delete this log entry? This cannot be undone.', 'advanced-form-integration' ) ), $icon_delete ); echo '

'; } /** * Define bulk actions. */ public function get_bulk_actions() { return array( 'delete' => esc_html__( 'Delete', 'advanced-form-integration' ), ); } /** * Process bulk actions and single-row delete. */ public function process_bulk_actions() { $action = $this->current_action(); if ( 'delete' !== $action ) { return; } // Single-row delete (GET link with nonce). if ( isset( $_GET['log_id'] ) && isset( $_GET['_wpnonce'] ) ) { if ( wp_verify_nonce( wp_unslash( $_GET['_wpnonce'] ), 'adfoin_delete_log_nonce' ) ) { $ids = array_map( 'absint', (array) $_GET['log_id'] ); $this->delete_log_ids( $ids ); advanced_form_integration_redirect( admin_url( 'admin.php?page=advanced-form-integration-log' ) ); exit; } } // Bulk delete (POST form with nonce). $ids = isset( $_REQUEST['log_id'] ) ? (array) $_REQUEST['log_id'] : array(); $ids = array_map( 'absint', $ids ); if ( empty( $ids ) ) { return; } if ( wp_verify_nonce( isset( $_REQUEST['_wpnonce'] ) ? wp_unslash( $_REQUEST['_wpnonce'] ) : '', 'bulk-logs' ) || wp_verify_nonce( isset( $_REQUEST['_wpnonce'] ) ? wp_unslash( $_REQUEST['_wpnonce'] ) : '', 'adfoin_delete_log_nonce' ) ) { $this->delete_log_ids( $ids ); advanced_form_integration_redirect( admin_url( 'admin.php?page=advanced-form-integration-log' ) ); exit; } } /** * Delete multiple log rows in a single DELETE ... WHERE id IN (...) query * instead of one round-trip per id. * * @param int[] $ids * @return void */ private function delete_log_ids( $ids ) { global $wpdb; $ids = array_filter( array_map( 'absint', (array) $ids ) ); if ( empty( $ids ) ) { return; } $placeholders = implode( ',', array_fill( 0, count( $ids ), '%d' ) ); $wpdb->query( $wpdb->prepare( "DELETE FROM {$this->log->table} WHERE id IN ($placeholders)", $ids ) ); } /** * Filter controls above the table — dropdowns for integration and status. */ public function extra_tablenav( $which ) { if ( 'top' !== $which ) { return; } global $wpdb; $selected_integration = isset( $_REQUEST['integration_id'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['integration_id'] ) ) : ''; $selected_code_family = isset( $_REQUEST['code_family'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['code_family'] ) ) : ''; // Integrations that appear in the log. Resolve the distinct ids off the // (integration_id, id) index first, then fetch their titles in one // small IN() query — far cheaper than a DISTINCT + LEFT JOIN scan of // the whole log table. $log_table = $wpdb->prefix . 'adfoin_log'; $int_table = $wpdb->prefix . 'adfoin_integration'; $distinct_ids = $wpdb->get_col( "SELECT DISTINCT integration_id FROM {$log_table} ORDER BY integration_id ASC" ); $distinct_ids = array_filter( array_map( 'absint', (array) $distinct_ids ) ); $integrations = array(); if ( ! empty( $distinct_ids ) ) { $placeholders = implode( ',', array_fill( 0, count( $distinct_ids ), '%d' ) ); $title_rows = $wpdb->get_results( $wpdb->prepare( "SELECT id, title FROM {$int_table} WHERE id IN ($placeholders)", $distinct_ids ), ARRAY_A ); $title_map = $title_rows ? wp_list_pluck( $title_rows, 'title', 'id' ) : array(); foreach ( $distinct_ids as $iid ) { $integrations[] = array( 'integration_id' => $iid, 'title' => isset( $title_map[ $iid ] ) ? $title_map[ $iid ] : '', ); } } ?>

prefix . 'adfoin_log'; // One conditional-aggregate pass instead of four separate COUNT(*) // full scans. $counts = (array) $wpdb->get_row( "SELECT COUNT(*) AS total, SUM(CASE WHEN response_code LIKE '2%' THEN 1 ELSE 0 END) AS success, SUM(CASE WHEN response_code LIKE '4%' THEN 1 ELSE 0 END) AS client_err, SUM(CASE WHEN response_code LIKE '5%' THEN 1 ELSE 0 END) AS server_err FROM {$log_table}", ARRAY_A ); $total = isset( $counts['total'] ) ? (int) $counts['total'] : 0; $success = isset( $counts['success'] ) ? (int) $counts['success'] : 0; $client_err = isset( $counts['client_err'] ) ? (int) $counts['client_err'] : 0; $server_err = isset( $counts['server_err'] ) ? (int) $counts['server_err'] : 0; $other = $total - $success - $client_err - $server_err; $current = isset( $_REQUEST['code_family'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['code_family'] ) ) : ''; $base_url = remove_query_arg( array( 'code_family', 'paged' ) ); $views = array(); $views['all'] = sprintf( '%s (%d)', esc_url( $base_url ), '' === $current ? ' class="current"' : '', esc_html__( 'All', 'advanced-form-integration' ), $total ); if ( $success > 0 ) { $views['success'] = sprintf( '%s (%d)', esc_url( add_query_arg( 'code_family', 'success', $base_url ) ), 'success' === $current ? ' class="current"' : '', esc_html__( 'Success', 'advanced-form-integration' ), $success ); } if ( $client_err > 0 ) { $views['client_error'] = sprintf( '%s (%d)', esc_url( add_query_arg( 'code_family', 'client_error', $base_url ) ), 'client_error' === $current ? ' class="current"' : '', esc_html__( 'Client Error', 'advanced-form-integration' ), $client_err ); } if ( $server_err > 0 ) { $views['server_error'] = sprintf( '%s (%d)', esc_url( add_query_arg( 'code_family', 'server_error', $base_url ) ), 'server_error' === $current ? ' class="current"' : '', esc_html__( 'Server Error', 'advanced-form-integration' ), $server_err ); } if ( $other > 0 ) { $views['other_error'] = sprintf( '%s (%d)', esc_url( add_query_arg( 'code_family', 'other_error', $base_url ) ), 'other_error' === $current ? ' class="current"' : '', esc_html__( 'Other', 'advanced-form-integration' ), $other ); } return $views; } /** * Sortable columns: integration, time (default desc), response_code. */ function get_sortable_columns() { return array( 'integration_id' => array( 'integration_id', false ), 'time' => array( 'time', true ), // true = already sorted desc by default 'response_code' => array( 'response_code', false ), ); } public function fetch_table_data( $args = array() ) { global $wpdb; $defaults = array( 'number' => 20, 'offset' => 0, 'orderby' => 'id', 'order' => 'DESC', 'count' => false, 'integration_id' => '', 'response_code' => '', 'code_family' => '', ); $args = wp_parse_args( $args, $defaults ); $log = new Advanced_Form_Integration_Log(); $sql = "SELECT * FROM {$log->table}"; $where = array(); if ( isset( $args['s'] ) && ! empty( $args['s'] ) ) { // esc_like() escapes literal `%` and `_` so they aren't interpreted // as LIKE wildcards. Without it, searching for `100%` would match // anything starting with `100`. The integrations list table at // class-adfoin-list-table.php already does this correctly; this // brings the log table in line. $arg_s = $wpdb->esc_like( $args['s'] ); $where[] = $wpdb->prepare( "(`response_message` LIKE %s OR `request_data` LIKE %s OR `response_data` LIKE %s)", '%' . $arg_s . '%', '%' . $arg_s . '%', '%' . $arg_s . '%' ); } if ( ! empty( $args['integration_id'] ) ) { // Integer column — %d is self-sanitizing, the sanitize_text_field() was redundant. $where[] = $wpdb->prepare( "`integration_id` = %d", (int) $args['integration_id'] ); } // Legacy direct response_code filter (used internally). if ( ! empty( $args['response_code'] ) ) { $where[] = $wpdb->prepare( "`response_code` = %d", (int) $args['response_code'] ); } // New code_family filter. if ( ! empty( $args['code_family'] ) ) { switch ( $args['code_family'] ) { case 'success': $where[] = "`response_code` LIKE '2%'"; break; case 'client_error': $where[] = "`response_code` LIKE '4%'"; break; case 'server_error': $where[] = "`response_code` LIKE '5%'"; break; case 'other_error': $where[] = "(`response_code` NOT LIKE '2%' AND `response_code` NOT LIKE '4%' AND `response_code` NOT LIKE '5%')"; break; } } if ( ! empty( $where ) ) { $sql .= ' WHERE ' . implode( ' AND ', $where ); } if ( ! empty( $args['orderby'] ) ) { // esc_sql() only quotes string values — it does NOT make a column // name safe in ORDER BY position. $args['orderby'] flows in from // $_REQUEST, so whitelist it the way class-adfoin-list-table.php does. $allowed_orderby = array( 'id', 'time', 'integration_id', 'response_code' ); $orderby = in_array( $args['orderby'], $allowed_orderby, true ) ? $args['orderby'] : 'id'; $order = ( ! empty( $args['order'] ) && strtoupper( $args['order'] ) === 'DESC' ) ? 'DESC' : 'ASC'; $sql .= " ORDER BY {$orderby} {$order}"; } if ( $args['count'] ) { $count_sql = "SELECT COUNT(*) FROM {$log->table}"; if ( ! empty( $where ) ) { $count_sql .= ' WHERE ' . implode( ' AND ', $where ); } $result = $log->get_var( $count_sql ); } else { $sql .= ' LIMIT ' . (int) $args['number']; $sql .= ' OFFSET ' . (int) $args['offset']; $result = $log->get_results( $sql, 'ARRAY_A' ); } return $result; } /** * Handles filtered count. */ public function count() { $args = array( 'count' => true ); if ( isset( $_REQUEST['s'] ) && ! empty( $_REQUEST['s'] ) ) { $args['s'] = sanitize_text_field( wp_unslash( $_REQUEST['s'] ) ); } if ( isset( $_REQUEST['integration_id'] ) && ! empty( $_REQUEST['integration_id'] ) ) { $args['integration_id'] = sanitize_text_field( wp_unslash( $_REQUEST['integration_id'] ) ); } if ( isset( $_REQUEST['code_family'] ) && ! empty( $_REQUEST['code_family'] ) ) { $args['code_family'] = sanitize_text_field( wp_unslash( $_REQUEST['code_family'] ) ); } elseif ( isset( $_REQUEST['response_code'] ) && is_numeric( $_REQUEST['response_code'] ) ) { $args['response_code'] = absint( wp_unslash( $_REQUEST['response_code'] ) ); } return $this->fetch_table_data( $args ); } /** * Prepare items for display. */ public function prepare_items() { global $wpdb; $this->process_bulk_actions(); $count = $this->count(); $columns = $this->get_columns(); $hidden = array(); $sortable = $this->get_sortable_columns(); $this->_column_headers = array( $columns, $hidden, $sortable ); $current_page = $this->get_pagenum(); $per_page = $this->get_items_per_page( 'adfoin_log_per_page', 20 ); $offset = ( $current_page - 1 ) * $per_page; $args = array( 'offset' => $offset, 'number' => $per_page, ); if ( isset( $_REQUEST['orderby'] ) && ! empty( $_REQUEST['orderby'] ) ) { $args['orderby'] = sanitize_text_field( wp_unslash( $_REQUEST['orderby'] ) ); } if ( isset( $_REQUEST['order'] ) && ! empty( $_REQUEST['order'] ) ) { $args['order'] = sanitize_text_field( wp_unslash( $_REQUEST['order'] ) ); } if ( isset( $_REQUEST['s'] ) && ! empty( $_REQUEST['s'] ) ) { $args['s'] = sanitize_text_field( wp_unslash( $_REQUEST['s'] ) ); } if ( isset( $_REQUEST['integration_id'] ) && ! empty( $_REQUEST['integration_id'] ) ) { $args['integration_id'] = sanitize_text_field( wp_unslash( $_REQUEST['integration_id'] ) ); } if ( isset( $_REQUEST['code_family'] ) && ! empty( $_REQUEST['code_family'] ) ) { $args['code_family'] = sanitize_text_field( wp_unslash( $_REQUEST['code_family'] ) ); } elseif ( isset( $_REQUEST['response_code'] ) && is_numeric( $_REQUEST['response_code'] ) ) { $args['response_code'] = absint( wp_unslash( $_REQUEST['response_code'] ) ); } $this->items = $this->fetch_table_data( $args ); // Bulk-preload the integration titles for the rows on this page in a // single id-IN query. column_integration_id() then reads from this // cache instead of constructing a fresh Integration object (and running // a full SELECT *, longtext included) once per row. $this->title_cache = array(); $int_ids = array(); if ( is_array( $this->items ) ) { foreach ( $this->items as $row ) { $iid = isset( $row['integration_id'] ) ? (int) $row['integration_id'] : 0; if ( $iid > 0 ) { $int_ids[ $iid ] = $iid; } } } if ( ! empty( $int_ids ) ) { $placeholders = implode( ',', array_fill( 0, count( $int_ids ), '%d' ) ); $title_rows = $wpdb->get_results( $wpdb->prepare( "SELECT id, title FROM {$wpdb->prefix}adfoin_integration WHERE id IN ($placeholders)", array_values( $int_ids ) ), ARRAY_A ); if ( $title_rows ) { $this->title_cache = wp_list_pluck( $title_rows, 'title', 'id' ); } } $this->set_pagination_args( array( 'total_items' => $count, 'per_page' => $per_page, 'total_pages' => ceil( $count / $per_page ), ) ); } /** * admin_header — column widths now live in asset.css; kept as a * no-op so any external calls don't fatal. */ public function admin_header() {} }