get_var( "SELECT COUNT(*) FROM {$wpdb->posts} WHERE post_type = 'post' AND post_status = 'publish'" ); // AI-generated posts // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- AI content statistics for widget $stats['ai_generated_posts'] = $wpdb->get_var( "SELECT COUNT(*) FROM {$wpdb->posts} p JOIN {$wpdb->postmeta} pm ON p.ID = pm.post_id WHERE p.post_type = 'post' AND p.post_status = 'publish' AND pm.meta_key = 'ai_story_maker_generated_via' AND pm.meta_value IN ('master_api', 'openai_api')" ); // Posts this week // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Weekly statistics for analytics $stats['posts_this_week'] = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$wpdb->posts} WHERE post_type = 'post' AND post_status = 'publish' AND post_date >= %s", gmdate( 'Y-m-d', strtotime( '-7 days' ) ) ) ); // Posts this month // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Monthly statistics for analytics $stats['posts_this_month'] = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$wpdb->posts} WHERE post_type = 'post' AND post_status = 'publish' AND post_date >= %s", gmdate( 'Y-m-01' ) ) ); // AI stories in last 6 months $six_months_ago = gmdate( 'Y-m-d', strtotime( '-180 days' ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Historical analytics data aggregation $story_results = $wpdb->get_results( $wpdb->prepare( "SELECT DATE(post_date) as date, COUNT(*) as count FROM {$wpdb->posts} WHERE post_type = 'post' AND post_status = 'publish' AND post_date >= %s AND ID IN ( SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key = 'ai_story_maker_generated_via' AND meta_value IN ('master_api', 'openai_api') ) GROUP BY DATE(post_date)", $six_months_ago ) ); $story_data = array(); foreach ( $story_results as $row ) { if ( $row && isset( $row->date, $row->count ) ) { $story_data[ $row->date ] = (int) $row->count; } } $stats['total_stories_6months'] = array_sum( $story_data ); $stats['max_stories_per_day'] = ! empty( $story_data ) ? max( $story_data ) : 0; // Calculate AI content percentage $stats['ai_percentage'] = $stats['total_posts'] > 0 ? round( ( $stats['ai_generated_posts'] / $stats['total_posts'] ) * 100, 1 ) : 0; return $stats; } /** * Get recent posts for quick reference */ private static function get_recent_posts() { global $wpdb; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Recent posts for widget display return $wpdb->get_results( "SELECT ID, post_title, post_date FROM {$wpdb->posts} WHERE post_type = 'post' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 3" ); } /** * Render the dashboard widget * * @param array $args { * @type bool $show_footer Whether to show the View Analytics footer link. Default true. * } */ public static function render_widget( $args = array() ) { $args = wp_parse_args( $args, array( 'show_footer' => true, ) ); $stats = self::get_statistics(); $recent_posts = self::get_recent_posts(); ?>
📊
🤖
📅
📈 0 ? round( $stats['posts_this_month'] / gmdate( 'j' ), 1 ) : 0; /* translators: %s: average number of posts per day this month */ printf( esc_html__( '%s per day', 'ai-story-maker' ), esc_html( $daily_avg ) ); ?>

{ card.addEventListener("click", function() { // Future: Add click functionality for data drilling }); }); }); '; } } // Initialize the widget AISTMA_Data_Cards_Widget::init();