count(get_option('accua_forms_saved_forms', array())), 'pages' => (int) $wpdb->get_var("SELECT COUNT(DISTINCT afs_uri) FROM `{$wpdb->prefix}accua_forms_submissions`"), 'submissions' => (int) $wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}accua_forms_submissions` WHERE afs_status >= 0"), 'emails' => (int) $wpdb->get_var("SELECT COUNT(DISTINCT afsv_value) FROM `{$wpdb->prefix}accua_forms_submissions_values` WHERE afsv_type = 'autoreply_email'"), ); // phpcs:enable set_transient('accua_forms_dashboard_stats', $stats, 5 * MINUTE_IN_SECONDS); return $stats; } /** * Dashboard widget handler for Contact Forms stats. * * Shows form statistics including active forms, pages, submissions, and distinct emails. * Only accessible to users with the 'manage_options' capability. */ function accua_contact_forms_dashboard_widget_news_handler() { if (!current_user_can('manage_options')) { return; } $stats = accua_contact_forms_dashboard_get_stats(); $rows = array( array($stats['active_forms'], __('Active forms', 'contact-forms')), array($stats['pages'], __('Pages', 'contact-forms')), array($stats['submissions'], __('Submissions', 'contact-forms')), array($stats['emails'], __('Distinct Emails', 'contact-forms')), ); $plugin_data = get_plugin_data(ACCUA_FORMS_FILE, false, false); ?>
|