'event', 'plural' => 'events', 'ajax' => false ]); } /** * Get columns */ public function get_columns() { return [ 'occurred_at' => __('Time', 'valuespace'), 'event_type' => __('Event Type', 'valuespace'), 'object' => __('Product or Page', 'valuespace'), 'visitor' => __('User / Session', 'valuespace'), 'audience' => __('Country / Language', 'valuespace'), 'delivery_status' => __('ValueSpace Delivery', 'valuespace'), 'event_data' => __('Event Data', 'valuespace'), ]; } /** * Get sortable columns */ public function get_sortable_columns() { return [ 'occurred_at' => ['occurred_at', true], 'event_type' => ['event_type', false], ]; } /** * Column default */ public function column_default($item, $column_name) { switch ($column_name) { case 'occurred_at': $occurred_at = $item['occurred_at'] ?? ''; $event_timestamp = is_numeric($occurred_at) ? (int) $occurred_at : strtotime((string) $occurred_at); return $event_timestamp ? esc_html(wp_date(get_option('date_format') . ' ' . get_option('time_format'), $event_timestamp)) : '—'; case 'object': return $this->render_object_column($item); case 'visitor': return $this->render_visitor_column($item); case 'audience': $country = isset($item['country_code']) ? strtoupper((string) $item['country_code']) : (isset($item['country']) ? strtoupper((string) $item['country']) : ''); $language = isset($item['language']) ? (string) $item['language'] : ''; $audience = array_filter([$country, $language], 'strlen'); return empty($audience) ? '—' : esc_html(implode(' / ', $audience)); case 'delivery_status': $status = sanitize_key((string) ($item['delivery_status'] ?? 'pending')); $labels = [ 'pending' => __('Waiting', 'valuespace'), 'acknowledged' => __('Sent to ValueSpace', 'valuespace'), 'discarded' => __('Not sent', 'valuespace'), 'ignored' => __('Ignored', 'valuespace'), ]; $label = $labels[$status] ?? $labels['pending']; return '' . esc_html($label) . ''; case 'timestamp': // Show raw timestamp value for debugging $raw_value = ''; if (isset($item['timestamp'])) { $raw_value = $item['timestamp']; } elseif (isset($item['recorded_at'])) { $raw_value = gmdate('Y-m-d H:i:s', (int)$item['recorded_at']); } // Display raw value as string (no conversions) return '' . esc_html($raw_value) . ''; case 'event_type': return '' . esc_html($item['event_type']) . ''; case 'wp_user_id': $user_id = $item['wp_user_id'] ?? 0; if ($user_id && $user_id > 0) { $user = get_userdata($user_id); if ($user) { return sprintf( '%s (#%d)', esc_url(get_edit_user_link($user_id)), esc_html($user->user_login), $user_id ); } return '#' . intval($user_id); } return '' . esc_html__('Guest', 'valuespace') . ''; case 'session_id': $session_id = $item['session_id'] ?? 'unknown'; return '' . esc_html($session_id) . ''; case 'event_data': $event_data = $item['data'] ?? []; $data_summary = []; // Handle cart_snapshot specially if (isset($event_data['cart_snapshot'])) { $snapshot = $event_data['cart_snapshot']; $cart_info = []; if (isset($snapshot['total_items'])) { $cart_info[] = sprintf( /* translators: %s: Number of items in the recorded cart snapshot. */ __('Items: %s', 'valuespace'), $snapshot['total_items'] ); } if (isset($snapshot['total'])) { $cart_info[] = sprintf( /* translators: %s: Total value of the recorded cart snapshot. */ __('Total: %s', 'valuespace'), $snapshot['total'] ); } if (isset($snapshot['currency'])) { $cart_info[] = sprintf( /* translators: %s: Currency code of the recorded cart snapshot. */ __('Currency: %s', 'valuespace'), $snapshot['currency'] ); } $cart_summary = !empty($cart_info) ? sprintf( /* translators: %s: Comma-separated cart snapshot details. */ __('Cart: %s', 'valuespace'), implode(', ', $cart_info) ) : __('Cart data available', 'valuespace'); $data_summary[] = 'cart_snapshot: ' . esc_html($cart_summary) . ''; } // Handle other scalar values foreach ($event_data as $key => $value) { if ($key === 'cart_snapshot') continue; // Already handled above if (is_scalar($value)) { $display_value = strlen($value) > 50 ? substr($value, 0, 50) . '...' : $value; $data_summary[] = '' . esc_html($key) . ': ' . esc_html($display_value); } elseif (is_array($value) && !empty($value)) { $array_summary = []; foreach ($value as $sub_key => $sub_value) { if (is_scalar($sub_value) && strlen($sub_value) < 20) { $array_summary[] = $sub_key . ':' . $sub_value; } } if (!empty($array_summary)) { $data_summary[] = '' . esc_html($key) . ': {' . esc_html(implode(', ', array_slice($array_summary, 0, 2))) . '...}'; } else { $data_summary[] = '' . esc_html($key) . ': ' . esc_html(sprintf( /* translators: %d: Number of items in an event-data array. */ _n('Array with %d item', 'Array with %d items', count($value), 'valuespace'), count($value) )); } } } if (!empty($data_summary)) { $full_data = wp_json_encode($event_data, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES); $short_summary = implode('
', array_slice($data_summary, 0, 2)); return '
' . $short_summary . '
' . esc_html__('Full event data (JSON)', 'valuespace') . '
'; } return '-'; case 'url': // Try multiple URL sources, with special handling for navigation events $url = null; // For navigation.page_view events, the URL is stored in event data if (isset($item['event_type']) && $item['event_type'] === 'navigation.page_view') { $url = $item['data']['url'] ?? null; // If it's a relative URL, construct full URL if ($url && !filter_var($url, FILTER_VALIDATE_URL)) { $site_url = get_site_url(); if (strpos($url, '/') === 0) { $url = rtrim($site_url, '/') . $url; } } } else { // Try other sources for non-navigation events $url = $item['url'] ?? $item['data']['page_url'] ?? $item['data']['to_url'] ?? $item['data']['from_url'] ?? $item['data']['file_url'] ?? null; } if ($url && filter_var($url, FILTER_VALIDATE_URL)) { $display_url = strlen($url) > 50 ? substr($url, 0, 50) . '...' : $url; return sprintf( '%s', esc_url($url), esc_attr($url), esc_html($display_url) ); } return '-'; default: return isset($item[$column_name]) ? esc_html($item[$column_name]) : '-'; } } /** * Prepare items for display */ public function prepare_items() { $this->_column_headers = [$this->get_columns(), [], $this->get_sortable_columns()]; $per_page = 20; $current_page = max(1, (int) $this->get_pagenum()); $orderby = isset($_GET['orderby']) ? sanitize_key(wp_unslash($_GET['orderby'])) : 'occurred_at'; $orderby = in_array($orderby, ['occurred_at', 'event_type'], true) ? $orderby : 'occurred_at'; $order = isset($_GET['order']) && sanitize_key(wp_unslash($_GET['order'])) === 'asc' ? 'asc' : 'desc'; $query = [ 'page' => $current_page, 'per_page' => $per_page, 'search' => isset($_GET['s']) ? sanitize_text_field(wp_unslash($_GET['s'])) : '', 'event_type' => isset($_GET['event_type']) ? sanitize_text_field(wp_unslash($_GET['event_type'])) : '', 'delivery_status' => isset($_GET['delivery_status']) ? sanitize_key(wp_unslash($_GET['delivery_status'])) : '', 'orderby' => $orderby, 'order' => $order, ]; $index_status = function_exists('vasp_event_get_index_status') ? vasp_event_get_index_status() : []; $index_ready = !isset($index_status['schema_ready']) || !empty($index_status['schema_ready']); $result = $index_ready && function_exists('vasp_event_query_events') ? vasp_event_query_events($query) : ['items' => [], 'total' => 0]; $this->items = isset($result['items']) && is_array($result['items']) ? $result['items'] : []; $total_filtered_events = isset($result['total']) ? max(0, (int) $result['total']) : 0; $this->set_pagination_args([ 'total_items' => $total_filtered_events, 'per_page' => $per_page, 'total_pages' => (int) ceil($total_filtered_events / $per_page), ]); } /** * Message to display when no items */ public function no_items() { esc_html_e('No events match the current filters.', 'valuespace'); } /** * Extra table navigation - not used, using default WordPress display */ protected function extra_tablenav($which) { if ($which !== 'top') { return; } $options = function_exists('vasp_event_get_filter_options') ? vasp_event_get_filter_options() : []; $event_types = isset($options['event_types']) && is_array($options['event_types']) ? $options['event_types'] : []; $selected_type = isset($_GET['event_type']) ? sanitize_text_field(wp_unslash($_GET['event_type'])) : ''; $selected_delivery = isset($_GET['delivery_status']) ? sanitize_key(wp_unslash($_GET['delivery_status'])) : ''; ?>
' . $primary . ' ' . esc_html__('(opens in a new tab)', 'valuespace') . ''; } $meta = []; if ($type !== '') { $meta[] = $type === 'product' ? __('Product', 'valuespace') : __('Page', 'valuespace'); } if ($id !== '') { $meta[] = '#' . $id; } $secondary = $default_title !== '' && $default_title !== $title ? '' . sprintf( /* translators: %s: Default title of the event object. */ esc_html__('Default: %s', 'valuespace'), esc_html($default_title) ) . '' : ''; return '' . $primary . '' . (!empty($meta) ? '' . esc_html(implode(' ', $meta)) . '' : '') . $secondary; } /** * Render user and session identity. */ private function render_visitor_column($item) { $user_id = isset($item['wp_user_id']) ? (int) $item['wp_user_id'] : 0; $session_id = isset($item['session_id']) ? (string) $item['session_id'] : ''; $html = ''; if ($user_id > 0) { $user = get_userdata($user_id); $html = $user ? '' . esc_html($user->display_name ?: $user->user_login) . ' #' . $user_id . '' : sprintf( /* translators: %d: WordPress user ID. */ esc_html__('User #%d', 'valuespace'), $user_id ); } else { $html = '' . esc_html__('Guest', 'valuespace') . ''; } if ($session_id !== '') { $html .= '' . esc_html($session_id) . ''; } return $html; } }