get_var( "SELECT COUNT(*) FROM {$table}" ); // phpcs:ignore WordPress.DB $week_entries = (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$table} WHERE created_at >= %s", gmdate( 'Y-m-d H:i:s', strtotime( '-7 days' ) ) ) ); // phpcs:ignore WordPress.DB $today_entries = (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$table} WHERE created_at >= %s", gmdate( 'Y-m-d 00:00:00' ) ) ); // phpcs:ignore WordPress.DB $unread = (int) $wpdb->get_var( "SELECT COUNT(*) FROM {$table} WHERE status != 'read'" ); // phpcs:ignore WordPress.DB $series = self::daily_series( 14 ); $max = max( array_merge( [ 1 ], array_values( $series ) ) ); $totals = Analytics::site_totals(); $recent = $wpdb->get_results( "SELECT * FROM {$table} ORDER BY created_at DESC LIMIT 6" ); // phpcs:ignore WordPress.DB $onboarding = ! get_option( 'phemightforms_onboarding_done', 0 ); $forms_url = add_query_arg( [ 'page' => Admin::SLUG_FORMS ], admin_url( 'admin.php' ) ); $new_url = add_query_arg( [ 'page' => Admin::SLUG_FORMS, 'action' => 'new', ], admin_url( 'admin.php' ) ); $entries_url = add_query_arg( [ 'page' => Admin::SLUG . '-entries' ], admin_url( 'admin.php' ) ); ?>

%

ID ); $count = (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$table} WHERE form_id = %d", $post->ID ) ); // phpcs:ignore WordPress.DB $edit_url = add_query_arg( [ 'page' => Admin::SLUG_FORMS, 'action' => 'edit', 'form' => $post->ID, ], admin_url( 'admin.php' ) ); ?> post_title ); ?> get_fields() ), (int) $count ); ?>
count. */ private static function daily_series( $days ) { global $wpdb; $table = Install::entries_table(); $since = gmdate( 'Y-m-d 00:00:00', strtotime( '-' . ( $days - 1 ) . ' days' ) ); $rows = $wpdb->get_results( $wpdb->prepare( "SELECT created_at FROM {$table} WHERE created_at >= %s", $since ) ); // phpcs:ignore WordPress.DB $series = []; for ( $i = $days - 1; $i >= 0; $i-- ) { $series[ gmdate( 'Y-m-d', strtotime( '-' . $i . ' days' ) ) ] = 0; } foreach ( $rows as $row ) { $day = substr( $row->created_at, 0, 10 ); if ( isset( $series[ $day ] ) ) { $series[ $day ]++; } } return $series; } }