get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %i WHERE status = 'completed'", $doc_table ) ); $num_chunks = (int) $wpdb->get_var( $wpdb->prepare( 'SELECT COUNT(*) FROM %i', $chunk_table ) ); $request_stats = \AISupportAssistant\Chat\Statistics::summarize(); $total_queries = $request_stats['total']; $today_queries = $request_stats['today']; $recent_logs = $wpdb->get_results( $wpdb->prepare( 'SELECT * FROM %i ORDER BY created_at DESC LIMIT 5', $chat_table ) ); $settings = \AISupportAssistant\Admin\Settings::get_instance(); $provider = $settings->get( 'ai_provider', 'gemini' ); $model = ( 'openai' === $provider ) ? $settings->get( 'openai_chat_model' ) : $settings->get( 'gemini_chat_model' ); $vs = $settings->get( 'vector_store', 'mysql' ); $provider_name = 'wp_native_ai' === $provider ? 'WordPress AI' : ( false !== strpos( $provider, 'openai' ) ? 'OpenAI' : 'Google Gemini' ); if ( 'wp_native_ai' === $provider ) { $model = 'wp-native-ai'; } $vector_names = array( 'mysql' => 'Native WordPress (MySQL)', ); $vs_name = 'Native WordPress (MySQL)'; ?>