'; echo '

' . esc_html__( 'BW Plugin Installs', 'bw-update-server' ) . '

'; echo '

' . sprintf( esc_html__( 'Tracking %1$d distinct sites across %2$d plugins.', 'bw-update-server' ), (int) $stats['total_sites'], (int) $stats['total_plugins'] ) . '

'; echo '
'; echo '

' . esc_html__( 'Distinct Sites', 'bw-update-server' ) . '

' . (int) $stats['total_sites'] . '

'; echo '

' . esc_html__( 'Plugins Tracked', 'bw-update-server' ) . '

' . (int) $stats['total_plugins'] . '

'; echo '

' . esc_html__( 'Checks Today', 'bw-update-server' ) . '

' . (int) $stats['checks_today'] . '

'; echo '

' . esc_html__( 'Stale Installs', 'bw-update-server' ) . '

' . (int) $stats['stale_sites'] . '

'; echo '
'; $by_plugin = BW_Update_Server_Stats::installs_by_plugin(); echo '

' . esc_html__( 'Per-Plugin Installs', 'bw-update-server' ) . '

'; if ( empty( $by_plugin ) ) { echo '

' . esc_html__( 'No installs logged yet. Once a BW plugin is installed on a client site and checks for updates, it will appear here.', 'bw-update-server' ) . '

'; } else { foreach ( $by_plugin as $slug => $data ) { $this->render_plugin_section( $slug, $data ); } } $export_url = wp_nonce_url( add_query_arg( array( 'page' => self::MENU_SLUG, 'bw_export' => 'csv', ), admin_url( 'admin.php' ) ), 'bw_us_export_csv' ); echo '

' . esc_html__( 'Export', 'bw-update-server' ) . '

'; echo '

' . esc_html__( 'Download CSV of all install logs', 'bw-update-server' ) . '

'; echo ''; } private function render_plugin_section( $slug, $data ) { echo '

' . esc_html( $slug ) . ' (' . (int) $data['sites_count'] . ' sites)

'; if ( ! empty( $data['version_distribution'] ) ) { echo '
'; echo '' . esc_html__( 'Version distribution:', 'bw-update-server' ) . ' '; foreach ( $data['version_distribution'] as $ver => $count ) { $label = $ver ? $ver : '(unknown)'; echo '' . esc_html( $label ) . ' × ' . (int) $count . ' '; } echo '
'; } echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ( $data['sites'] as $site ) { $site_url = $site->site_url ? $site->site_url : '(unknown)'; $age_seconds = time() - strtotime( $site->last_check . ' UTC' ); $is_stale = $age_seconds > ( self::STALE_DAYS * DAY_IN_SECONDS ); $status_class = $is_stale ? 'bw-us-stale' : 'bw-us-active'; $status_text = $is_stale ? __( 'stale', 'bw-update-server' ) : __( 'active', 'bw-update-server' ); echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '
' . esc_html__( 'Site', 'bw-update-server' ) . '' . esc_html__( 'Installed', 'bw-update-server' ) . '' . esc_html__( 'WP', 'bw-update-server' ) . '' . esc_html__( 'Last Check', 'bw-update-server' ) . '' . esc_html__( 'Checks', 'bw-update-server' ) . '' . esc_html__( 'Status', 'bw-update-server' ) . '
' . esc_html( $site_url ) . '' . esc_html( $site->installed_version ?: '?' ) . '' . esc_html( $site->wp_version ?: '-' ) . '' . esc_html( human_time_diff( strtotime( $site->last_check . ' UTC' ) ) . ' ' . __( 'ago', 'bw-update-server' ) ) . '' . (int) $site->check_count . '' . esc_html( $status_text ) . '
'; } public function render_activity_page() { if ( ! current_user_can( self::CAP ) ) { return; } $limit = 100; $rows = BW_Update_Server_Repository::recent_checks( null, $limit ); echo '
'; echo '

' . esc_html__( 'BW Plugins — Recent Activity', 'bw-update-server' ) . '

'; echo '

' . sprintf( esc_html__( 'Most recent %d update checks from client sites.', 'bw-update-server' ), $limit ) . '

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ( $rows as $row ) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '
' . esc_html__( 'When', 'bw-update-server' ) . '' . esc_html__( 'Plugin', 'bw-update-server' ) . '' . esc_html__( 'Site', 'bw-update-server' ) . '' . esc_html__( 'Installed', 'bw-update-server' ) . '' . esc_html__( 'Latest', 'bw-update-server' ) . '' . esc_html__( 'WP', 'bw-update-server' ) . '' . esc_html__( 'IP', 'bw-update-server' ) . '
' . esc_html( $row->checked_at ) . '' . esc_html( $row->plugin_slug ) . '' . esc_html( $row->site_url ?: '-' ) . '' . esc_html( $row->installed_version ?: '-' ) . '' . esc_html( $row->latest_version ?: '-' ) . '' . esc_html( $row->wp_version ?: '-' ) . '' . esc_html( $row->ip_address ?: '-' ) . '
'; } public function register_dashboard_widget() { if ( ! current_user_can( self::CAP ) ) { return; } wp_add_dashboard_widget( 'bw_update_server_widget', __( 'BW Plugins — Install Summary', 'bw-update-server' ), array( $this, 'render_dashboard_widget' ) ); } public function render_dashboard_widget() { $stats = BW_Update_Server_Stats::overview(); $link = admin_url( 'admin.php?page=' . self::MENU_SLUG ); echo ''; echo '

' . esc_html__( 'View all installs →', 'bw-update-server' ) . '

'; } public function handle_csv_export() { if ( ! isset( $_GET['bw_export'] ) || 'csv' !== $_GET['bw_export'] ) { return; } if ( ! current_user_can( self::CAP ) ) { wp_die( 'Insufficient permissions' ); } if ( ! isset( $_GET['_wpnonce'] ) || ! wp_verify_nonce( sanitize_key( wp_unslash( $_GET['_wpnonce'] ) ), 'bw_us_export_csv' ) ) { wp_die( 'Invalid nonce' ); } global $wpdb; $table = BW_Update_Server_Installer::table_name(); $rows = $wpdb->get_results( "SELECT * FROM {$table} ORDER BY checked_at DESC" ); nocache_headers(); header( 'Content-Type: text/csv; charset=utf-8' ); header( 'Content-Disposition: attachment; filename="bw-plugins-installs-' . gmdate( 'Ymd-His' ) . '.csv"' ); $out = fopen( 'php://output', 'w' ); fputcsv( $out, array( 'id', 'plugin_slug', 'site_url', 'installed_version', 'latest_version', 'wp_version', 'php_version', 'ip_address', 'user_agent', 'checked_at' ) ); foreach ( $rows as $r ) { fputcsv( $out, array( $r->id, $r->plugin_slug, $r->site_url, $r->installed_version, $r->latest_version, $r->wp_version, $r->php_version, $r->ip_address, $r->user_agent, $r->checked_at, ) ); } fclose( $out ); exit; } }