get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %i", $chat_table ) ); $openai_queries = (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %i WHERE provider = 'openai'", $chat_table ) ); $gemini_queries = (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %i WHERE provider = 'gemini'", $chat_table ) ); $fallbacks = (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %i WHERE answer LIKE %s", $chat_table, '%I am not sure based on the provided documentation%' ) ); $resolved = max( 0, $total_queries - $fallbacks ); $resolved_pct = $total_queries > 0 ? round( ( $resolved / $total_queries ) * 100 ) : 100; $fallback_pct = $total_queries > 0 ? round( ( $fallbacks / $total_queries ) * 100 ) : 0; $openai_pct = $total_queries > 0 ? round( ( $openai_queries / $total_queries ) * 100 ) : 0; $gemini_pct = $total_queries > 0 ? round( ( $gemini_queries / $total_queries ) * 100 ) : 0; $raw_days = $wpdb->get_results( $wpdb->prepare( "SELECT DATE(created_at) as date, COUNT(*) as cnt FROM %i WHERE created_at >= DATE_SUB(NOW(), INTERVAL 7 DAY) GROUP BY DATE(created_at) ORDER BY date ASC", $chat_table ), OBJECT_K ); $days_data = array(); for ( $i = 6; $i >= 0; $i-- ) { $date = gmdate( 'Y-m-d', strtotime( "-$i days" ) ); $day_name = gmdate( 'D', strtotime( $date ) ); $days_data[ $day_name ] = isset( $raw_days[ $date ] ) ? (int) $raw_days[ $date ]->cnt : 0; } $max_day_count = max( array_values( $days_data ) ); $max_day_count = $max_day_count > 0 ? $max_day_count : 1; ?>

() %

$count ) : ?>