prefix . self::TABLE; $result = $wpdb->insert( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $table, [ 'event' => $event, 'session_id' => substr( $session_id, 0, 64 ), 'product_id' => $product_id, 'quantity' => $quantity, 'total' => $total, 'currency' => $currency ? substr( $currency, 0, 8 ) : null, 'created_at' => current_time( 'mysql' ), ] ); return false !== $result; } /** * Get aggregated summary for a date range. * * @param string $from Start date (Y-m-d H:i:s). * @param string $to End date (Y-m-d H:i:s). * @return array */ public function summary( string $from, string $to ): array { global $wpdb; $table = $wpdb->prefix . self::TABLE; $rows = $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->prepare( "SELECT event, COUNT(*) as count FROM `{$table}` WHERE created_at BETWEEN %s AND %s GROUP BY event", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared $from, $to ), ARRAY_A ); $stats = [ 'total_chats' => 0, 'total_searches' => 0, 'total_searches_found' => 0, 'total_cards_rendered' => 0, 'total_add_to_cart' => 0, 'conversion_rate' => 0.0, ]; foreach ( $rows as $row ) { switch ( $row['event'] ) { case 'chat_opened': $stats['total_chats'] = (int) $row['count']; break; case 'search_called': $stats['total_searches'] = (int) $row['count']; break; case 'search_found': $stats['total_searches_found'] = (int) $row['count']; break; case 'cart_card_rendered': $stats['total_cards_rendered'] = (int) $row['count']; break; case 'cart_added': $stats['total_add_to_cart'] = (int) $row['count']; break; } } if ( $stats['total_cards_rendered'] > 0 ) { $stats['conversion_rate'] = round( ( $stats['total_add_to_cart'] / $stats['total_cards_rendered'] ) * 100, 1 ); } return $stats; } }