# mainwp/trunk/widgets/widget-mainwp-updates-overview.php

MainWP Dashboard: Self-hosted WordPress Management for Agencies, version trunk. 1,455 lines.

- Page: https://pluginprobe.com/plugins/mainwp/trunk/code/widgets/widget-mainwp-updates-overview.php
- Raw: https://pluginprobe.com/plugins/mainwp/trunk/raw/widgets/widget-mainwp-updates-overview.php
- Modified: 2026-08-05T16:01:10+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/mainwp/trunk/code/widgets/widget-mainwp-updates-overview.php#L10-L20`.

```php
<?php
/**
 * MainWP Updates Overview Widget
 *
 * Grab Child Sites update status & build widget.
 *
 * @package MainWP/Updates_Overview
 */

namespace MainWP\Dashboard;

// Exit if accessed directly.
if ( ! defined( 'ABSPATH' ) ) {
    exit;
}


/**
 * Class MainWP_Updates_Overview
 *
 * @package MainWP\Dashboard
 */
class MainWP_Updates_Overview { // phpcs:ignore Generic.Classes.OpeningBraceSameLine.ContentAfterBrace -- NOSONAR.

    /**
     * Method get_class_name()
     *
     * Get Class Name
     *
     * @return string __CLASS__ Class Name.
     */
    public static function get_class_name() {
        return __CLASS__;
    }

    /**
     * Method init()
     *
     * Add plugins api filter.
     */
    public static function init() {
        add_filter( 'plugins_api', array( __CLASS__, 'plugins_api' ), 10, 3 );
    }

    /**
     * Method plugins_api()
     *
     * Grab Child Sites update status & build widget.
     *
     * @param mixed $default_value Default.
     * @param mixed $action Action.
     * @param mixed $args Slug.
     *
     * @return mixed $default|$res
     */
    public static function plugins_api( $default_value, $action, $args ) {

        if ( ( is_object( $args ) && property_exists( $args, 'slug' ) && ( 'mainwp' === $args->slug ) ) || ( is_array( $args ) && ! empty( $args['slug'] ) && 'mainwp' === $args['slug'] ) ) {
            return $default_value;
        }

        $url = 'http://api.wordpress.org/plugins/info/1.0/';
        $ssl = wp_http_supports( array( 'ssl' ) );
        if ( $ssl ) {
            $url = set_url_scheme( $url, 'https' );
        }

        $args    = array(
            'timeout' => 15,
            'body'    => array(
                'action'  => $action,
                'request'    => serialize( $args ), // phpcs:ignore -- WP.org API params.
            ),
        );
        $request = wp_remote_post( $url, $args );

        if ( is_wp_error( $request ) ) {
            $url  = isset( $_REQUEST['url'] ) ? esc_url_raw( wp_unslash( $_REQUEST['url'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification,WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
            $name = isset( $_REQUEST['name'] ) ? wp_unslash( $_REQUEST['name'] ) : ''; // phpcs:ignore WordPress.Security.NonceVerification,WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
            return new \WP_Error( 'plugins_api_failed', esc_html__( '<h3>No plugin information found.</h3> This may be a premium plugin and no other details are available from WordPress.', 'mainwp' ) . ' ' . ( empty( $url ) ? esc_html__( 'Please visit the plugin website for more information.', 'mainwp' ) : esc_html__( 'Please visit the plugin website for more information: ', 'mainwp' ) . '<a href="' . esc_html( rawurldecode( $url ) ) . '" target="_blank">' . esc_html( rawurldecode( $name ) ) . '</a>' ), $request->get_error_message() );
        }
        return $default_value;
    }

    /**
     * Method get_name()
     *
     * Define Widget Title.
     */
    public static function get_name() {
        return esc_html__( 'Update Overview', 'mainwp' );
    }

    /**
     * Method render()
     *
     * Check if $_GET['dashboard'] then run render_sites().
     */
    public static function render() {
        static::render_sites();
    }

    /**
     * Method render_sites()
     *
     * Grab available Child Sites updates a build Widget.
     *
     * @uses \MainWP\Dashboard\MainWP_DB_Common::get_user_extension()
     * @uses \MainWP\Dashboard\MainWP_DB_Common::get_last_sync_status()
     * @uses \MainWP\Dashboard\MainWP_DB::query()
     * @uses \MainWP\Dashboard\MainWP_DB::get_website_by_id()
     * @uses \MainWP\Dashboard\MainWP_DB::get_website_option()
     * @uses \MainWP\Dashboard\MainWP_DB::data_seek()::fetch_object()
     * @uses \MainWP\Dashboard\MainWP_DB::data_seek()
     * @uses \MainWP\Dashboard\MainWP_System_Utility::get_current_wpid()
     * @uses \MainWP\Dashboard\MainWP_Utility::format_timestamp()
     */
    public static function render_sites() { // phpcs:ignore -- NOSONAR - current complexity required to achieve desired results. Pull request solutions appreciated.

        $globalView = true;

        /**
         * Current user global.
         *
         * @global string
         */
        global $current_user;

        $current_wpid = (int) MainWP_System_Utility::get_current_wpid();
        $is_staging = 'no';

        if ( $current_wpid ) {
            $sql        = MainWP_DB::instance()->get_sql_website_by_id( $current_wpid, false, array( 'wp_upgrades', 'ignored_wp_upgrades', 'ignored_trans_updates', 'premium_upgrades', 'plugins_outdate_dismissed', 'themes_outdate_dismissed', 'plugins_outdate_info', 'themes_outdate_info', 'favi_icon' ) );
            $globalView = false;
        } else {
            $staging_enabled = is_plugin_active( 'mainwp-staging-extension/mainwp-staging-extension.php' ) || is_plugin_active( 'mainwp-timecapsule-extension/mainwp-timecapsule-extension.php' );
            // To support staging extension.
            if ( $staging_enabled ) {
                $staging_updates_view = MainWP_System_Utility::get_select_staging_view_sites();
                if ( 'staging' === $staging_updates_view ) {
                    $is_staging = 'yes';
                }
            }
            // end support.

            $sql = MainWP_DB::instance()->get_sql_websites_for_current_user( false, null, 'wp.url', false, false, null, false, array( 'wp_upgrades', 'ignored_wp_upgrades', 'ignored_trans_updates', 'premium_upgrades', 'plugins_outdate_dismissed', 'themes_outdate_dismissed', 'plugins_outdate_info', 'themes_outdate_info', 'favi_icon' ), $is_staging, array( 'connected' => 'yes' ) );
        }

        $userExtension = MainWP_DB_Common::instance()->get_user_extension();

        $mainwp_show_language_updates = get_option( 'mainwp_show_language_updates', 1 );
        $count_websites               = 0;

        $total_wp_upgrades          = 0;
        $total_plugin_upgrades      = 0;
        $total_translation_upgrades = 0;
        $total_theme_upgrades       = 0;

        $total_plugins_outdate = 0;
        $total_themes_outdate  = 0;

        $sites_ids = array();

        $currentSite = null;

        $count_plugins = 0;
        $count_themes  = 0;

        $cache_overview = array();
        $use_cached     = false;

        $cache_group = '';
        if ( $globalView ) {
            $count_websites = MainWP_DB::instance()->get_websites_count();
            $cache_group    = MainWP_Cache_Helper::CGR_UPDATES;
            $cache_key      = MainWP_Cache_Helper::get_cache_key( 'updates_overview', $cache_group, array( 'staging' => $is_staging ) );
            $cache_overview = MainWP_Cache_Helper::instance()->get_cache(
                $cache_key,
                $cache_group
            );
        }

        if ( ! empty( $cache_overview ) && is_array( $cache_overview ) ) {
            $use_cached                 = true;
            $total_wp_upgrades          = isset( $cache_overview['total_wp_upgrades'] ) ? intval( $cache_overview['total_wp_upgrades'] ) : 0;
            $total_plugin_upgrades      = isset( $cache_overview['total_plugin_upgrades'] ) ? intval( $cache_overview['total_plugin_upgrades'] ) : 0;
            $total_translation_upgrades = isset( $cache_overview['total_translation_upgrades'] ) ? intval( $cache_overview['total_translation_upgrades'] ) : 0;
            $total_theme_upgrades       = isset( $cache_overview['total_theme_upgrades'] ) ? intval( $cache_overview['total_theme_upgrades'] ) : 0;

            $count_plugins = isset( $cache_overview['count_plugins'] ) ? intval( $cache_overview['count_plugins'] ) : 0;
            $count_themes  = isset( $cache_overview['count_themes'] ) ? intval( $cache_overview['count_themes'] ) : 0;

            $total_plugins_outdate = isset( $cache_overview['total_plugins_outdate'] ) ? intval( $cache_overview['total_plugins_outdate'] ) : 0;
            $total_themes_outdate  = isset( $cache_overview['total_themes_outdate'] ) ? intval( $cache_overview['total_themes_outdate'] ) : 0;

            $sites_ids = isset( $cache_overview['sites_ids'] ) && is_array( $cache_overview['sites_ids'] ) ? $cache_overview['sites_ids'] : array();
        } else {
            $decodedDismissedPlugins = ! empty( $userExtension->dismissed_plugins ) ? json_decode( $userExtension->dismissed_plugins, true ) : array();
            $decodedDismissedThemes  = ! empty( $userExtension->dismissed_themes ) ? json_decode( $userExtension->dismissed_themes, true ) : array();
            $decodedIgnoredCores     = ! empty( $userExtension->ignored_wp_upgrades ) ? json_decode( $userExtension->ignored_wp_upgrades, true ) : array();
            if ( ! is_array( $decodedIgnoredCores ) ) {
                $decodedIgnoredCores = array();
            }
        }

        if ( ! $globalView || ! $use_cached ) {
            $websites = MainWP_DB::instance()->query( $sql );
            MainWP_DB::data_seek( $websites, 0 );
            while ( $websites && ( $website = MainWP_DB::fetch_object( $websites ) ) ) {
                if ( ! $globalView ) {
                    $currentSite = $website;
                }

                $sites_ids[] = $website->id;

                $count_plugins += ! empty( $website->plugins ) ? count( json_decode( $website->plugins, true ) ) : 0;
                $count_themes  += ! empty( $website->themes ) ? count( json_decode( $website->themes, true ) ) : 0;

                $pluginsIgnoredAbandoned_perSites = array();
                $themesIgnoredAbandoned_perSites  = array();

                $wp_upgrades           = ! empty( $website->wp_upgrades ) ? json_decode( $website->wp_upgrades, true ) : array();
                $ignored_core_upgrades = ! empty( $website->ignored_wp_upgrades ) ? json_decode( $website->ignored_wp_upgrades, true ) : array();

                if ( $website->is_ignoreCoreUpdates || MainWP_Common_Functions::instance()->is_ignored_updates( $wp_upgrades, $ignored_core_upgrades, 'core' ) || MainWP_Common_Functions::instance()->is_ignored_updates( $wp_upgrades, $decodedIgnoredCores, 'core' ) ) {
                    $wp_upgrades = array();
                }

                if ( is_array( $wp_upgrades ) && ! empty( $wp_upgrades ) ) {
                    ++$total_wp_upgrades;
                }

                $translation_upgrades = ! empty( $website->translation_upgrades ) ? json_decode( $website->translation_upgrades, true ) : array();

                if ( ! empty( $website->ignored_trans_updates ) ) {
                    $translation_upgrades = array();
                }

                $plugin_upgrades = ! empty( $website->plugin_upgrades ) ? json_decode( $website->plugin_upgrades, true ) : array();

                if ( $website->is_ignorePluginUpdates ) {
                    $plugin_upgrades = array();
                }

                $theme_upgrades = ! empty( $website->theme_upgrades ) ? json_decode( $website->theme_upgrades, true ) : array();
                if ( $website->is_ignoreThemeUpdates ) {
                    $theme_upgrades = array();
                }

                $decodedPremiumUpgrades = MainWP_DB::instance()->get_website_option( $website, 'premium_upgrades' );
                $decodedPremiumUpgrades = ! empty( $decodedPremiumUpgrades ) ? json_decode( $decodedPremiumUpgrades, true ) : array();

                if ( is_array( $decodedPremiumUpgrades ) ) {
                    foreach ( $decodedPremiumUpgrades as $crrSlug => $premiumUpgrade ) {
                        $premiumUpgrade['premium'] = true;

                        if ( 'plugin' === $premiumUpgrade['type'] ) {
                            if ( ! is_array( $plugin_upgrades ) ) {
                                $plugin_upgrades = array();
                            }
                            if ( ! $website->is_ignorePluginUpdates ) {

                                $premiumUpgrade = array_filter( $premiumUpgrade );
                                if ( ! isset( $plugin_upgrades[ $crrSlug ] ) ) {
                                    continue;
                                }

                                $plugin_upgrades[ $crrSlug ] = array_merge( $plugin_upgrades[ $crrSlug ], $premiumUpgrade );
                            }
                        } elseif ( 'theme' === $premiumUpgrade['type'] ) {
                            if ( ! is_array( $theme_upgrades ) ) {
                                $theme_upgrades = array();
                            }
                            if ( ! $website->is_ignoreThemeUpdates ) {
                                $theme_upgrades[ $crrSlug ] = $premiumUpgrade;
                            }
                        }
                    }
                }

                if ( is_array( $translation_upgrades ) ) {
                    $total_translation_upgrades += count( $translation_upgrades );
                }

                if ( is_array( $plugin_upgrades ) ) {
                    $ignored_plugins = ! empty( $website->ignored_plugins ) ? json_decode( $website->ignored_plugins, true ) : array();
                    if ( is_array( $ignored_plugins ) ) {
                        $plugin_upgrades = MainWP_Common_Functions::instance()->get_not_ignored_updates_themesplugins( $plugin_upgrades, $ignored_plugins );

                    }

                    $ignored_plugins = ! empty( $userExtension->ignored_plugins ) ? json_decode( $userExtension->ignored_plugins, true ) : array();
                    if ( is_array( $ignored_plugins ) ) {
                        $plugin_upgrades = MainWP_Common_Functions::instance()->get_not_ignored_updates_themesplugins( $plugin_upgrades, $ignored_plugins );

                    }

                    $total_plugin_upgrades += count( $plugin_upgrades );
                }

                if ( is_array( $theme_upgrades ) ) {
                    $ignored_themes = ! empty( $website->ignored_themes ) ? json_decode( $website->ignored_themes, true ) : array();
                    if ( is_array( $ignored_themes ) ) {
                        $theme_upgrades = MainWP_Common_Functions::instance()->get_not_ignored_updates_themesplugins( $theme_upgrades, $ignored_themes );
                    }

                    $ignored_themes = ! empty( $userExtension->ignored_themes ) ? json_decode( $userExtension->ignored_themes, true ) : array();
                    if ( is_array( $ignored_themes ) ) {
                        $theme_upgrades = MainWP_Common_Functions::instance()->get_not_ignored_updates_themesplugins( $theme_upgrades, $ignored_themes );
                    }

                    $total_theme_upgrades += count( $theme_upgrades );
                }

                $pluginsIgnoredAbandoned_perSites = MainWP_DB::instance()->get_website_option( $website, 'plugins_outdate_dismissed' );
                $pluginsIgnoredAbandoned_perSites = ! empty( $pluginsIgnoredAbandoned_perSites ) ? json_decode( $pluginsIgnoredAbandoned_perSites, true ) : array();
                if ( is_array( $pluginsIgnoredAbandoned_perSites ) ) {
                    $pluginsIgnoredAbandoned_perSites = array_filter( $pluginsIgnoredAbandoned_perSites );
                }

                $themesIgnoredAbandoned_perSites = MainWP_DB::instance()->get_website_option( $website, 'themes_outdate_dismissed' );
                $themesIgnoredAbandoned_perSites = ! empty( $themesIgnoredAbandoned_perSites ) ? json_decode( $themesIgnoredAbandoned_perSites, true ) : array();
                if ( is_array( $themesIgnoredAbandoned_perSites ) ) {
                    $themesIgnoredAbandoned_perSites = array_filter( $themesIgnoredAbandoned_perSites );
                }

                $plugins_outdate = MainWP_DB::instance()->get_website_option( $website, 'plugins_outdate_info' );
                $plugins_outdate = ! empty( $plugins_outdate ) ? json_decode( $plugins_outdate, true ) : array();

                $themes_outdate = MainWP_DB::instance()->get_website_option( $website, 'themes_outdate_info' );
                $themes_outdate = ! empty( $themes_outdate ) ? json_decode( $themes_outdate, true ) : array();

                if ( is_array( $plugins_outdate ) ) {
                    if ( is_array( $pluginsIgnoredAbandoned_perSites ) ) {
                        $plugins_outdate = array_diff_key( $plugins_outdate, $pluginsIgnoredAbandoned_perSites );
                    }

                    if ( is_array( $decodedDismissedPlugins ) ) {
                        $plugins_outdate = array_diff_key( $plugins_outdate, $decodedDismissedPlugins );
                    }

                    $total_plugins_outdate += count( $plugins_outdate );
                }

                if ( is_array( $themes_outdate ) ) {
                    if ( is_array( $themesIgnoredAbandoned_perSites ) ) {
                        $themes_outdate = array_diff_key( $themes_outdate, $themesIgnoredAbandoned_perSites );
                    }

                    if ( is_array( $decodedDismissedThemes ) ) {
                        $themes_outdate = array_diff_key( $themes_outdate, $decodedDismissedThemes );
                    }

                    $total_themes_outdate += count( $themes_outdate );
                }
            }

            if ( $globalView && ! empty( $cache_key ) ) {
                $data = array(
                    'total_wp_upgrades',
                    'total_plugin_upgrades',
                    'total_translation_upgrades',
                    'total_theme_upgrades',
                    'total_plugins_outdate',
                    'total_themes_outdate',
                    'count_plugins',
                    'count_themes',
                    'sites_ids',
                );
                MainWP_Cache_Helper::add_cache( $cache_key, $cache_group, compact( $data ) );
            }
        }

        // WP Upgrades part.
        $total_upgrades = $total_wp_upgrades + $total_plugin_upgrades + $total_theme_upgrades;

        // to fix incorrect total updates.
        if ( $mainwp_show_language_updates ) {
            $total_upgrades += $total_translation_upgrades;
        }

        $trustedPlugins = ! empty( $userExtension->trusted_plugins ) ? json_decode( $userExtension->trusted_plugins, true ) : array();
        if ( ! is_array( $trustedPlugins ) ) {
            $trustedPlugins = array();
        }
        $trustedThemes = ! empty( $userExtension->trusted_themes ) ? json_decode( $userExtension->trusted_themes, true ) : array();
        if ( ! is_array( $trustedThemes ) ) {
            $trustedThemes = array();
        }

        /**
         * Filter: mainwp_limit_updates_all
         *
         * Limits the number of updates that will be processed in a single run on Update Everything action.
         *
         * @since 4.0
         */
        $limit_updates_all = apply_filters( 'mainwp_limit_updates_all', 0 );

        if ( ! $globalView ) {
            $last_dtsSync = $currentSite->dtsSync;
        } else {
            $result       = MainWP_DB_Common::instance()->get_last_sync_status( $is_staging );
            $sync_status  = $result['sync_status'];
            $last_sync    = $result['last_sync'];
            $last_dtsSync = $result['last_sync'];

            if ( 'all_synced' === $sync_status ) {
                $last_dtsSync = get_option( 'mainwp_last_synced_all_sites', $last_sync );
            }
        }

        $lastSyncMsg = '';
        if ( $last_dtsSync ) {
            $lastSyncMsg = esc_html__( 'Last synchronization completed on: ', 'mainwp' ) . MainWP_Utility::format_timestamp( MainWP_Utility::get_timestamp( $last_dtsSync ) );
        }

        $user_can_update_translation = \mainwp_current_user_can( 'dashboard', 'update_translations' );
        $user_can_update_wordpress   = \mainwp_current_user_can( 'dashboard', 'update_wordpress' );
        $user_can_update_themes      = \mainwp_current_user_can( 'dashboard', 'update_themes' );
        $user_can_update_plugins     = \mainwp_current_user_can( 'dashboard', 'update_plugins' );

        $can_total_update = ( $user_can_update_wordpress && $user_can_update_plugins && $user_can_update_themes && $user_can_update_translation ) ? true : false;

        static::render_updates_overview_widget_header( $lastSyncMsg );
        ?>
        <div class="mainwp-scrolly-overflow">

            <div class="ui small cards mainwp-cards">

                <?php static::render_total_update( $total_upgrades, $can_total_update, $limit_updates_all, $count_websites, $count_plugins, $count_themes, $current_wpid ); ?>
                <?php static::render_wordpress_update( $user_can_update_wordpress, $total_wp_upgrades, $globalView, $current_wpid, $count_websites ); ?>
                <?php static::render_plugins_update( $user_can_update_plugins, $total_plugin_upgrades, $globalView, $current_wpid, $count_plugins ); ?>
                <?php static::render_themes_update( $user_can_update_themes, $total_theme_upgrades, $globalView, $current_wpid, $count_themes ); ?>
                <?php if ( 1 === (int) $mainwp_show_language_updates ) : ?>
                    <?php static::render_language_update( $user_can_update_translation, $total_translation_upgrades, $globalView, $current_wpid ); ?>
                <?php endif; ?>
                <?php static::render_abandoned_plugins( $total_plugins_outdate, $globalView, $current_wpid, $count_plugins ); ?>
                <?php static::render_abandoned_themes( $total_themes_outdate, $globalView, $current_wpid, $count_themes ); ?>

                <?php
                /**
                 * Action: mainwp_updates_overview_after_update_details
                 *
                 * Fires at the bottom of the Update Details section in the Updates Overview widget.
                 *
                 * @since 4.1
                 */
                do_action( 'mainwp_updates_overview_after_update_details', $currentSite, $globalView, $userExtension );
                ?>

            </div>

        </div>
        <div id="mainwp_prepare_global_update_all_container" style="display: none"></div>
        <?php

        static::render_bottom( $sites_ids, $globalView );
    }

    /**
     * Method prepare_update_data().
     *
     * @param string $update_type: Values all, core, plugin, theme, trans.
     * @param int $current_wpid Current site id.
     */
    public static function prepare_update_data( $update_type, $current_wpid ) { // phpcs:ignore -- NOSONAR - long function.

        $process = array(
            'core'   => in_array( $update_type, array( 'all', 'core' ), true ),
            'plugin' => in_array( $update_type, array( 'all', 'plugin' ), true ),
            'theme'  => in_array( $update_type, array( 'all', 'theme' ), true ),
            'trans'  => in_array( $update_type, array( 'all', 'trans' ), true ),
        );

        if ( $current_wpid ) {
            $sql = MainWP_DB::instance()->get_sql_website_by_id( $current_wpid, false, array( 'wp_upgrades', 'ignored_wp_upgrades', 'ignored_trans_updates', 'premium_upgrades', 'plugins_outdate_dismissed', 'themes_outdate_dismissed', 'plugins_outdate_info', 'themes_outdate_info', 'favi_icon' ) );
        } else {
            $staging_enabled = is_plugin_active( 'mainwp-staging-extension/mainwp-staging-extension.php' ) || is_plugin_active( 'mainwp-timecapsule-extension/mainwp-timecapsule-extension.php' );
            // To support staging extension.
            $is_staging = 'no';
            if ( $staging_enabled ) {
                $staging_updates_view = MainWP_System_Utility::get_select_staging_view_sites();
                if ( 'staging' === $staging_updates_view ) {
                    $is_staging = 'yes';
                }
            }
            // end support.

            $sql = MainWP_DB::instance()->get_sql_websites_for_current_user( false, null, 'wp.url', false, false, null, false, array( 'wp_upgrades', 'ignored_wp_upgrades', 'ignored_trans_updates', 'premium_upgrades', 'plugins_outdate_dismissed', 'themes_outdate_dismissed', 'plugins_outdate_info', 'themes_outdate_info', 'favi_icon' ), $is_staging, array( 'connected' => 'yes' ) );
        }

        $userExtension = MainWP_DB_Common::instance()->get_user_extension();

        $total_wp_upgrades          = 0;
        $total_plugin_upgrades      = 0;
        $total_translation_upgrades = 0;
        $total_theme_upgrades       = 0;

        $all_wp_updates           = array();
        $all_plugins_updates      = array();
        $all_themes_updates       = array();
        $all_translations_updates = array();

        $decodedIgnoredCores   = MainWP_Utility::get_decoded_array( $userExtension->ignored_wp_upgrades );
        $decodedIgnoredPlugins = MainWP_Utility::get_decoded_array( $userExtension->ignored_plugins );
        $decodedIgnoredThemes  = MainWP_Utility::get_decoded_array( $userExtension->ignored_themes );

        $websites = MainWP_DB::instance()->query( $sql );
        MainWP_DB::data_seek( $websites, 0 );
        while ( $websites && ( $website = MainWP_DB::fetch_object( $websites ) ) ) {

            $plugin_upgrades = array();
            $theme_upgrades  = array();

            if ( $process['core'] ) {

                $wp_upgrades           = MainWP_Utility::get_decoded_array( $website->wp_upgrades );
                $ignored_core_upgrades = MainWP_Utility::get_decoded_array( $website->ignored_wp_upgrades );

                if (
                    $website->is_ignoreCoreUpdates ||
                    MainWP_Common_Functions::instance()->is_ignored_updates( $wp_upgrades, $ignored_core_upgrades, 'core' ) ||
                    MainWP_Common_Functions::instance()->is_ignored_updates( $wp_upgrades, $decodedIgnoredCores, 'core' )
                ) {
                    $wp_upgrades = array();
                }

                if ( ! empty( $wp_upgrades ) ) {
                    ++$total_wp_upgrades;

                    $all_wp_updates[] = array(
                        'id'           => $website->id,
                        'name'         => $website->name,
                        'is_suspended' => $website->suspended ? 1 : 0,
                    );
                }
            }

            if ( $process['trans'] ) {

                $translation_upgrades = MainWP_Utility::get_decoded_array( $website->translation_upgrades );

                if ( ! empty( $website->ignored_trans_updates ) ) {
                    $translation_upgrades = array();
                }

                if ( is_array( $translation_upgrades ) ) {

                    $total_translation_upgrades += count( $translation_upgrades );

                    foreach ( $translation_upgrades as $trans_upgrade ) {
                        $all_translations_updates[] = array(
                            'id'               => $website->id,
                            'name'             => $website->name,
                            'translation_slug' => rawurlencode( $trans_upgrade['slug'] ),
                            'is_suspended'     => $website->suspended ? 1 : 0,
                        );
                    }
                }
            }

            $decodedPremiumUpgrades = array();

            if ( $process['plugin'] || $process['theme'] ) {
                $decodedPremiumUpgrades = MainWP_DB::instance()->get_website_option( $website, 'premium_upgrades' );
                $decodedPremiumUpgrades = MainWP_Utility::get_decoded_array( $decodedPremiumUpgrades );
            }

            if ( $process['plugin'] ) {
                $plugin_upgrades = MainWP_Utility::get_decoded_array( $website->plugin_upgrades );

                if ( $website->is_ignorePluginUpdates ) {
                    $plugin_upgrades = array();
                }
                if ( is_array( $decodedPremiumUpgrades ) ) {
                    foreach ( $decodedPremiumUpgrades as $crrSlug => $premiumUpgrade ) {
                        $premiumUpgrade['premium'] = true;
                        if ( 'plugin' === $premiumUpgrade['type'] ) {
                            if ( ! is_array( $plugin_upgrades ) ) {
                                $plugin_upgrades = array();
                            }
                            if ( ! $website->is_ignorePluginUpdates ) {

                                $premiumUpgrade = array_filter( $premiumUpgrade );
                                if ( ! isset( $plugin_upgrades[ $crrSlug ] ) ) {
                                    continue;
                                }

                                $plugin_upgrades[ $crrSlug ] = array_merge( $plugin_upgrades[ $crrSlug ], $premiumUpgrade );
                            }
                        }
                    }
                }
            }

            if ( $process['theme'] ) {
                $theme_upgrades = MainWP_Utility::get_decoded_array( $website->theme_upgrades );
                if ( $website->is_ignoreThemeUpdates ) {
                    $theme_upgrades = array();
                }

                if ( is_array( $decodedPremiumUpgrades ) ) {
                    foreach ( $decodedPremiumUpgrades as $crrSlug => $premiumUpgrade ) {
                        $premiumUpgrade['premium'] = true;
                        if ( 'theme' === $premiumUpgrade['type'] ) {
                            if ( ! is_array( $theme_upgrades ) ) {
                                $theme_upgrades = array();
                            }
                            if ( ! $website->is_ignoreThemeUpdates ) {
                                $theme_upgrades[ $crrSlug ] = $premiumUpgrade;
                            }
                        }
                    }
                }
            }

            if ( $process['plugin'] && is_array( $plugin_upgrades ) ) {
                $ignored_plugins = MainWP_Utility::get_decoded_array( $website->ignored_plugins );
                $plugin_upgrades = MainWP_Common_Functions::instance()->get_not_ignored_updates_themesplugins( $plugin_upgrades, $ignored_plugins );

                if ( is_array( $decodedIgnoredPlugins ) ) {
                    $plugin_upgrades = MainWP_Common_Functions::instance()->get_not_ignored_updates_themesplugins( $plugin_upgrades, $decodedIgnoredPlugins );

                }

                $total_plugin_upgrades += count( $plugin_upgrades );

                if ( ! empty( $plugin_upgrades ) ) {
                    foreach ( $plugin_upgrades as $slug => $value ) {
                        $all_plugins_updates[] = array(
                            'id'           => $website->id,
                            'name'         => $website->name,
                            'plugin_slug'  => $slug,
                            'is_suspended' => $website->suspended ? 1 : 0,
                        );
                    }
                }
            }

            if ( $process['theme'] && is_array( $theme_upgrades ) ) {
                $ignored_themes = MainWP_Utility::get_decoded_array( $website->ignored_themes );
                $theme_upgrades = MainWP_Common_Functions::instance()->get_not_ignored_updates_themesplugins( $theme_upgrades, $ignored_themes );

                if ( is_array( $decodedIgnoredThemes ) ) {
                    $theme_upgrades = MainWP_Common_Functions::instance()->get_not_ignored_updates_themesplugins( $theme_upgrades, $decodedIgnoredThemes );
                }

                $total_theme_upgrades += count( $theme_upgrades );

                if ( ! empty( $theme_upgrades ) ) {
                    foreach ( $theme_upgrades as $slug => $value ) {
                        $all_themes_updates[] = array(
                            'id'           => $website->id,
                            'name'         => $website->name,
                            'theme_slug'   => $slug,
                            'is_suspended' => $website->suspended ? 1 : 0,
                        );
                    }
                }
            }
        }

        switch ( $update_type ) {
            case 'core':
                return compact( 'total_wp_upgrades', 'all_wp_updates' );
            case 'plugin':
                return compact( 'total_plugin_upgrades', 'all_plugins_updates' );
            case 'theme':
                return compact( 'total_theme_upgrades', 'all_themes_updates' );
            case 'trans':
                return compact( 'total_translation_upgrades', 'all_translations_updates' );
            case 'all':
            default:
                return compact( 'total_wp_upgrades', 'total_plugin_upgrades', 'total_translation_upgrades', 'total_theme_upgrades', 'all_wp_updates', 'all_plugins_updates', 'all_themes_updates', 'all_translations_updates' );
        }
    }


    /**
     * Renders Updates Overview widget header.
     *
     * @param string $lastSyncMsg last sync info.
     */
    public static function render_updates_overview_widget_header( $lastSyncMsg ) {
        ?>
        <div class="ui grid mainwp-widget-header">
            <div class="sixteen wide column">
                <h2 class="ui header handle-drag">
                    <?php
                    /**
                     * Filter: mainwp_updates_overview_widget_title
                     *
                     * Filters the Updates Overview widget title text.
                     *
                     * @since 4.1
                     */
                    echo esc_html( apply_filters( 'mainwp_updates_overview_widget_title', esc_html__( 'Updates Overview', 'mainwp' ) ) );
                    ?>
                    <div class="sub header"><?php echo $lastSyncMsg; // phpcs:ignore WordPress.Security.EscapeOutput ?></div>
                </h2>
            </div>
        </div>
        <?php
    }

    /**
     * Renders Updates Overview widget footer.
     */
    public static function render_updates_overview_widget_footer() {
        ?>
        <div class="ui two column grid mainwp-widget-footer">
            <div class="left aligned middle aligned column"></div>
            <div class="right aligned middle aligned column"></div>
        </div>
        <?php
    }

    /**
     * Render total update.
     *
     * @param int  $total_upgrades number of update.
     * @param bool $can_total_update permission to update all.
     * @param int  $limit_updates_all limit number of update per request, 0 is no limit.
     * @param int  $count_websites count websites.
     * @param int  $count_plugins count plugins.
     * @param int  $count_themes count themes.
     * @param int  $current_wpid Current site id.
     */
    public static function render_total_update( $total_upgrades, $can_total_update, $limit_updates_all, $count_websites, $count_plugins, $count_themes, $current_wpid ) { // phpcs:ignore -- NOSONAR - complex.

        if ( 0 < $count_plugins ) {
            $outdated_percentage = round( ( ( intval( $total_upgrades ) / intval( $count_themes + $count_plugins + $count_websites ) ) * 100 ), 2 ) . '%';
        } else {
            $outdated_percentage = '0.00%';
        }

        ?>
        <input type="hidden" name="updatesoverview_limit_updates_all" id="updatesoverview_limit_updates_all" value="<?php echo intval( $limit_updates_all ); ?>">
        <?php
        /**
         * Action: mainwp_updates_overview_before_total_updates
         *
         * Fires before the total updates section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_before_total_updates' );

        /**
         * Filter:  mainwp_update_everything_button_text
         *
         * Filters the Update Everything button text.
         *
         * @since 4.1
         */
        ?>
        <div class="ui card">
            <div class="content">
                <div class="header">
                    <span class="ui large text"><i class="sync alternate icon"></i> <?php echo esc_html( MainWP_Utility::short_number_format( intval( $total_upgrades ) ) ); ?></span>
                    <?php if ( intval( $total_upgrades ) > 0 ) : ?>
                        <span class="ui small text">(<?php echo esc_html( $outdated_percentage ); ?>)</span>
                    <?php else : ?>
                        <span class="ui small text">(0%)</span>
                    <?php endif; ?>
                </div>
                <div class="description"><?php esc_html_e( 'Available updates.', 'mainwp' ); ?></div>
            </div>
            <div class="extra content">
                <div class="ui grid">
                    <div class="center aligned middle alidgned column">
                    <?php if ( ! get_option( 'mainwp_hide_update_everything', false ) ) : ?>
                        <?php if ( $can_total_update ) : ?>
                            <a href="#" <?php echo empty( $total_upgrades ) ? 'disabled' : 'onClick="updatesoverview_global_upgrade_all( \'all\', ' .  intval( $current_wpid ) . ' ); return false;"'; ?> class="ui mini basic green fluid button" id="mainwp-update-everything-button"><?php echo esc_html( apply_filters( 'mainwp_update_everything_button_text', esc_html__( 'Update Everything', 'mainwp' ) ) ); ?></a>
                        <?php endif; ?>
                    <?php endif; ?>
                    </div>
                </div>
            </div>
        </div>
        <?php
        /**
         * Action: mainwp_updates_overview_after_total_updates
         *
         * Fires after the total updates section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_after_total_updates' );
    }

    /**
     * Renders WordPress update details.
     *
     * @param bool $user_can_update_wordpress Permission to update WordPress.
     * @param int  $total_wp_upgrades         Total number of WordPress update.
     * @param bool $globalView                Global view or not.
     * @param int  $current_wpid              Current site ID.
     * @param int  $count_websites             Number of sites.
     *
     * @uses \MainWP\Dashboard\MainWP_Updates::set_continue_update_html_selector()
     * @uses \MainWP\Dashboard\MainWP_Updates::get_continue_update_selector()
     */
    public static function render_wordpress_update( $user_can_update_wordpress, $total_wp_upgrades, $globalView, $current_wpid, $count_websites ) { //phpcs:ignore -- NOSONAR - complexity.
        if ( 0 < $count_websites ) {
            $outdated_percentage = round( ( ( intval( $total_wp_upgrades ) / $count_websites ) * 100 ), 2 ) . '%';
        } else {
            $outdated_percentage = '0.00%';
        }

        $wpcore_update_disabled_by = '';
        if ( $globalView ) {
            $detail_wp_up = 'admin.php?page=UpdatesManage&tab=wordpress-updates';
        } else {
            $detail_wp_up              = 'admin.php?page=managesites&updateid=' . $current_wpid . '&tab=wordpress-updates';
            $wpcore_update_disabled_by = MainWP_System_Utility::disabled_wpcore_update_by( $current_wpid );
        }

        /**
         * Action: mainwp_updates_overview_before_update_details
         *
         * Fires at the top of the Update Details section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_before_update_details' );

        /**
         * Action: mainwp_updates_overview_before_wordpress_updates
         *
         * Fires before the WordPress updates section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_before_wordpress_updates' );
        ?>

        <div class="ui card">
            <div class="content">
                <div class="header">
                    <span class="ui large text"><i class="wordpress icon"></i> <?php echo esc_html( MainWP_Utility::short_number_format( intval( $total_wp_upgrades ) ) ); ?></span> <?php // keep `wordpress`. ?>
                    <?php if ( intval( $total_wp_upgrades ) > 0 ) : ?>
                        <span class="ui small red text">(<?php echo esc_html( $outdated_percentage ); ?>)</span>
                    <?php else : ?>
                        <span class="ui small green text">(0%)</span>
                    <?php endif; ?>
                </div>
                <div class="description"><?php esc_html_e( 'Available WordPress core updates.', 'mainwp' ); ?></div>
            </div>
            <div class="extra content">
                <div class="ui two column grid">
                    <div class="left aligned middle aligned column">
                    <?php if ( $user_can_update_wordpress ) : ?>
                        <?php if ( 0 < $total_wp_upgrades ) : ?>
                            <?php MainWP_Updates::set_continue_update_html_selector( 'wpcore_global_upgrade_all' ); ?>
                            <?php if ( ! empty( $wpcore_update_disabled_by ) ) : ?>
                                <a href="javascript:void(0)"  class="ui mini button basic green disabled mainwp-update-all-button"><?php esc_html_e( 'Update All', 'mainwp' ); ?></a>
                            <?php else : ?>
                                <a href="#" onClick="updatesoverview_global_upgrade_all('wp', <?php echo intval( $current_wpid ); ?>); return false;" class="ui mini green button mainwp-update-all-button <?php MainWP_Updates::get_continue_update_selector(); // phpcs:ignore WordPress.Security.EscapeOutput ?>"><?php esc_html_e( 'Update All', 'mainwp' ); ?></a>
                            <?php endif; ?>
                        <?php else : ?>
                            <a href="#" class="ui disabled green mini button mainwp-update-all-button"><?php esc_html_e( 'Update All', 'mainwp' ); ?></a>
                        <?php endif; ?>
                    <?php endif; ?>
                    </div>
                    <div class="right aligned middle aligned column">
                        <?php if ( 0 < $total_wp_upgrades ) : ?>
                            <a href="<?php echo esc_url( $detail_wp_up ); ?>" class="ui mini basic button" aria-label="<?php esc_attr_e( 'View WordPress core updates details', 'mainwp' ); ?>"><?php esc_html_e( 'Details', 'mainwp' ); ?></a>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
        </div>
        <?php
        /**
         * Action: mainwp_updates_overview_after_wordpress_updates
         *
         * Fires after the WordPress updates section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_after_wordpress_updates' );
    }

    /**
     * Renders Plugins update detail.
     *
     * @param bool $user_can_update_plugins permission to update.
     * @param int  $total_plugin_upgrades  total number of update.
     * @param bool $globalView global view or not.
     * @param int  $current_wpid  current site id.
     * @param int  $count_plugins  count plugin.
     *
     * @uses \MainWP\Dashboard\MainWP_Updates::set_continue_update_html_selector()
     * @uses \MainWP\Dashboard\MainWP_Updates::get_continue_update_selector()
     */
    public static function render_plugins_update( $user_can_update_plugins, $total_plugin_upgrades, $globalView, $current_wpid, $count_plugins ) { //phpcs:ignore -- NOSONAR - complexity.
        if ( 0 < $count_plugins ) {
            $outdated_percentage = round( ( ( intval( $total_plugin_upgrades ) / $count_plugins ) * 100 ), 2 ) . '%';
        } else {
            $outdated_percentage = '0.00%';
        }

        if ( $globalView ) {
            $detail_plugins_up = 'admin.php?page=UpdatesManage&tab=plugins-updates';
        } else {
            $detail_plugins_up = 'admin.php?page=managesites&updateid=' . $current_wpid . '&tab=plugins-updates';
        }

        /**
         * Action: mainwp_updates_overview_before_plugin_updates
         *
         * Fires before the Plugin updates section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_before_plugin_updates' );
        ?>
        <div class="ui card">
            <div class="content">
                <div class="header">
                    <span class="ui large text"><i class="plug icon"></i> <?php echo esc_html( MainWP_Utility::short_number_format( intval( $total_plugin_upgrades ) ) ); ?></span>
                    <?php if ( intval( $total_plugin_upgrades ) > 0 ) : ?>
                        <span class="ui small red text">(<?php echo esc_html( $outdated_percentage ); ?>)</span>
                    <?php else : ?>
                        <span class="ui small green text">(0%)</span>
                    <?php endif; ?>
                </div>
                <div class="description"><?php esc_html_e( 'Available plugin updates.', 'mainwp' ); ?></div>
            </div>
            <div class="extra content">
                <div class="ui two column grid">
                    <div class="left aligned middle aligned column">
                    <?php if ( $user_can_update_plugins ) : ?>
                        <?php if ( ! empty( $total_plugin_upgrades ) ) : ?>
                            <?php MainWP_Updates::set_continue_update_html_selector( 'plugins_global_upgrade_all' ); ?>
                                <a href="#" onClick="updatesoverview_global_upgrade_all('plugin', <?php echo intval( $current_wpid ); ?>); return false;" class="ui mini green mainwp-update-all-button button <?php MainWP_Updates::get_continue_update_selector(); // phpcs:ignore WordPress.Security.EscapeOutput ?>"><?php esc_html_e( 'Update All', 'mainwp' ); ?></a>
                        <?php else : ?>
                            <a href="#" class="ui disabled green mini button mainwp-update-all-button"><?php esc_html_e( 'Update All', 'mainwp' ); ?></a>
                        <?php endif; ?>
                    <?php endif; ?>
                    </div>
                    <div class="right aligned middle aligned column">
                        <?php if ( ! empty( $total_plugin_upgrades ) ) : ?>
                            <a href="<?php echo esc_url( $detail_plugins_up ); ?>" class="ui mini basic button" aria-label="<?php esc_attr_e( 'View plugin updates details', 'mainwp' ); ?>"><?php esc_html_e( 'Details', 'mainwp' ); ?></a>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
        </div>
        <?php
        /**
         * Action: mainwp_updates_overview_after_plugin_updates
         *
         * Fires after the Plugin updates section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_after_plugin_updates' );
    }

    /**
     * Render Themes update detail.
     *
     * @param bool $user_can_update_themes permission to update.
     * @param int  $total_theme_upgrades  total number of update.
     * @param bool $globalView global view or not.
     * @param int  $current_wpid  current site id.
     * @param int  $count_themes  count themes.
     *
     * @uses \MainWP\Dashboard\MainWP_Updates::set_continue_update_html_selector()
     * @uses \MainWP\Dashboard\MainWP_Updates::get_continue_update_selector()
     */
    public static function render_themes_update( $user_can_update_themes, $total_theme_upgrades, $globalView, $current_wpid, $count_themes ) { //phpcs:ignore -- NOSONAR - complexity.
        if ( 0 < $count_themes ) {
            $outdated_percentage = round( ( ( intval( $total_theme_upgrades ) / $count_themes ) * 100 ), 2 ) . '%';
        } else {
            $outdated_percentage = '0.00%';
        }

        if ( $globalView ) {
            $detail_themes_up = 'admin.php?page=UpdatesManage&tab=themes-updates';
        } else {
            $detail_themes_up = 'admin.php?page=managesites&updateid=' . $current_wpid . '&tab=themes-updates';
        }

        /**
         * Action: mainwp_updates_overview_before_theme_updates
         *
         * Fires before the Theme updates section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_before_theme_updates' );
        ?>
        <div class="ui card">
            <div class="content">
                <div class="header">
                    <span class="ui large text"><i class="tint icon"></i> <?php echo esc_html( MainWP_Utility::short_number_format( intval( $total_theme_upgrades ) ) ); ?></span>
                    <?php if ( intval( $total_theme_upgrades ) > 0 ) : ?>
                        <span class="ui small red text">(<?php echo esc_html( $outdated_percentage ); ?>)</span>
                    <?php else : ?>
                        <span class="ui small green text">(0%)</span>
                    <?php endif; ?>
                </div>
                <div class="description"><?php esc_html_e( 'Available theme updates.', 'mainwp' ); ?></div>
            </div>
            <div class="extra content">
                <div class="ui two column grid">
                    <div class="left aligned middle aligned column">
                    <?php if ( $user_can_update_themes ) : ?>
                        <?php if ( ! empty( $total_theme_upgrades ) ) : ?>
                            <?php MainWP_Updates::set_continue_update_html_selector( 'themes_global_upgrade_all' ); ?>
                            <a href="#" onClick="updatesoverview_global_upgrade_all('theme', <?php echo intval( $current_wpid ); ?>); return false;" class="ui mini green mainwp-update-all-button button <?php MainWP_Updates::get_continue_update_selector(); // phpcs:ignore WordPress.Security.EscapeOutput ?>"><?php esc_html_e( 'Update All', 'mainwp' ); ?></a>
                        <?php else : ?>
                            <a href="#" class="ui disabled green mini button mainwp-update-all-button"><?php esc_html_e( 'Update All', 'mainwp' ); ?></a>
                        <?php endif; ?>
                    <?php endif; ?>
                    </div>
                    <div class="right aligned middle aligned column">
                        <?php if ( ! empty( $total_theme_upgrades ) ) : ?>
                            <a href="<?php echo esc_url( $detail_themes_up ); ?>" class="ui mini basic button" aria-label="<?php esc_attr_e( 'View theme updates details', 'mainwp' ); ?>"><?php esc_html_e( 'Details', 'mainwp' ); ?></a>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
        </div>
        <?php
        /**
         * Action: mainwp_updates_overview_after_theme_updates
         *
         * Fires after the Theme updates section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_after_theme_updates' );
    }
    /**
     * Render language update details.
     *
     * @param bool $user_can_update_translation Permission to update.
     * @param int  $total_translation_upgrades  Total number of update.
     * @param bool $globalView                  Global view or not.
     * @param int  $current_wpid                Current site id.
     *
     * @uses \MainWP\Dashboard\MainWP_Updates::set_continue_update_html_selector()
     * @uses \MainWP\Dashboard\MainWP_Updates::get_continue_update_selector()
     */
    public static function render_language_update( $user_can_update_translation, $total_translation_upgrades, $globalView, $current_wpid ) {
        if ( $globalView ) {
            $detail_trans_up = 'admin.php?page=UpdatesManage&tab=translations-updates';
        } else {
            $detail_trans_up = 'admin.php?page=managesites&updateid=' . $current_wpid . '&tab=translations-updates';
        }
        /**
         * Action: mainwp_updates_overview_before_translation_updates
         *
         * Fires before the Translation updates section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_before_translation_updates' );
        ?>
        <div class="ui card">
            <div class="content">
                <div class="header">
                    <span class="ui large text"><i class="language icon"></i> <?php echo esc_html( MainWP_Utility::short_number_format( intval( $total_translation_upgrades ) ) ); ?></span>
                </div>
                <div class="description"><?php esc_html_e( 'Available translation updates.', 'mainwp' ); ?></div>
            </div>
            <div class="extra content">
                <div class="ui two column grid">
                    <div class="left aligned middle aligned column">
                    <?php if ( $user_can_update_translation ) : ?>
                        <?php if ( ! empty( $total_translation_upgrades ) ) : ?>
                            <?php MainWP_Updates::set_continue_update_html_selector( 'translations_global_upgrade_all' ); ?>
                            <a href="#" onClick="updatesoverview_global_upgrade_all('translation', <?php echo intval( $current_wpid ); ?>); return false;" class="ui mini green mainwp-update-all-button button <?php MainWP_Updates::get_continue_update_selector(); // phpcs:ignore WordPress.Security.EscapeOutput ?>"><?php esc_html_e( 'Update All', 'mainwp' ); ?></a>
                        <?php else : ?>
                            <a href="#" class="ui disabled green mini button mainwp-update-all-button"><?php esc_html_e( 'Update All', 'mainwp' ); ?></a>
                        <?php endif; ?>
                    <?php endif; ?>
                    </div>
                    <div class="right aligned middle aligned column">
                        <?php if ( ! empty( $total_translation_upgrades ) ) : ?>
                            <a href="<?php echo esc_url( $detail_trans_up ); ?>" class="ui mini basic button" aria-label="<?php esc_attr_e( 'View translation updates details', 'mainwp' ); ?>"><?php esc_html_e( 'Details', 'mainwp' ); ?></a>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
        </div>
        <?php
        /**
         * Action: mainwp_updates_overview_after_translation_updates
         *
         * Fires after the Translation updates section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_after_translation_updates' );
    }

    /**
     * Renders abandoned plugins detail.
     *
     * @param int  $total_plugins_outdate  total number of update.
     * @param bool $globalView global view or not.
     * @param int  $current_wpid  current site id.
     * @param int  $count_plugins  count plugins.
     */
    public static function render_abandoned_plugins( $total_plugins_outdate, $globalView, $current_wpid, $count_plugins ) {
        if ( $globalView ) {
            $detail_aban_plugins = 'admin.php?page=PluginsAbandoned';
        } else {
            $detail_aban_plugins = 'admin.php?page=managesites&updateid=' . $current_wpid . '&tab=abandoned-plugins';
        }

        if ( 0 < $count_plugins ) {
            $outdated_percentage = round( ( ( intval( $total_plugins_outdate ) / $count_plugins ) * 100 ), 2 ) . '%';
        } else {
            $outdated_percentage = '0.00%';
        }
        /**
         * Action: mainwp_updates_overview_before_abandoned_plugins_themes
         *
         * Fires at the top of the Abandoned Plugins & Themes section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_before_abandoned_plugins_themes' );
        ?>
        <div class="ui light card">
            <div class="content">
                <div class="header">
                    <span class="ui large text">
                        <i class="icons">
                            <i class="plug icon"></i>
                            <i class="inverted corner clock icon"></i>
                        </i>
                        <?php echo esc_html( MainWP_Utility::short_number_format( intval( $total_plugins_outdate ) ) ); ?>
                    </span>
                    <?php if ( intval( $total_plugins_outdate ) > 0 ) : ?>
                        <span class="ui small red text">(<?php echo esc_html( $outdated_percentage ); ?>)</span>
                    <?php else : ?>
                        <span class="ui small green text">(0%)</span>
                    <?php endif; ?>
                </div>
                <div class="description"><?php esc_html_e( 'Detected abandoned plugins.', 'mainwp' ); ?></div>
            </div>
            <div class="extra content">
                <div class="ui two column grid">
                    <div class="left aligned middle aligned column">

                    </div>
                    <div class="right aligned middle aligned column">
                        <a href="<?php echo esc_url( $detail_aban_plugins ); ?>" class="ui mini basic button" aria-label="<?php esc_attr_e( 'View abandoned plugins details', 'mainwp' ); ?>"><?php esc_html_e( 'Details', 'mainwp' ); ?></a>
                    </div>
                </div>
            </div>
        </div>
        <?php
    }

    /**
     * Renders abandoned themes detail.
     *
     * @param int  $total_themes_outdate Total number of update.
     * @param bool $globalView global    View or not.
     * @param int  $current_wpid         Current site ID.
     * @param int  $count_themes         count themes.
     */
    public static function render_abandoned_themes( $total_themes_outdate, $globalView, $current_wpid, $count_themes ) {
        if ( $globalView ) {
            $detail_aban_themes = 'admin.php?page=ThemesAbandoned';
        } else {
            $detail_aban_themes = 'admin.php?page=managesites&updateid=' . $current_wpid . '&tab=abandoned-themes';
        }

        if ( 0 < $count_themes ) {
            $outdated_percentage = round( ( ( intval( $total_themes_outdate ) / $count_themes ) * 100 ), 2 ) . '%';
        } else {
            $outdated_percentage = '0.00%';
        }

        ?>
        <div class="ui light card">
            <div class="content">
                <div class="header">
                    <span class="ui large text">
                        <i class="icons">
                            <i class="tint icon"></i>
                            <i class="inverted corner clock icon"></i>
                        </i>
                        <?php echo esc_html( MainWP_Utility::short_number_format( intval( $total_themes_outdate ) ) ); ?>
                    </span>
                    <?php if ( intval( $total_themes_outdate ) > 0 ) : ?>
                        <span class="ui small red text">(<?php echo esc_html( $outdated_percentage ); ?>)</span>
                    <?php else : ?>
                        <span class="ui small green text">(0%)</span>
                    <?php endif; ?>
                </div>
                <div class="description"><?php esc_html_e( 'Detected abandoned themes.', 'mainwp' ); ?></div>
            </div>
            <div class="extra content">
                <div class="ui two column grid">
                    <div class="left aligned middle aligned column">

                    </div>
                    <div class="right aligned middle aligned column">
                        <a href="<?php echo esc_url( $detail_aban_themes ); ?>" class="ui mini basic button" aria-label="<?php esc_attr_e( 'View abandoned themes details', 'mainwp' ); ?>"><?php esc_html_e( 'Details', 'mainwp' ); ?></a>
                    </div>
                </div>
            </div>
        </div>
        <?php
        /**
         * Action: mainwp_updates_overview_after_abandoned_plugins_themes
         *
         * Fires at the bottom of the Abandoned Plugins & Themes section in the Updates Overview widget.
         *
         * @since 4.1
         */
        do_action( 'mainwp_updates_overview_after_abandoned_plugins_themes' );
    }

    /**
     * Method render_global_update()
     *
     * Render global updates.
     *
     * @param string $update_type Update type.
     * @param bool   $user_can_update_wordpress Permission to update WordPress.
     * @param int    $total_wp_upgrades         Total WordPress update.
     * @param array  $all_wp_updates            All WordPress update list.
     *
     * @param bool   $user_can_update_plugins permission to update plugings.
     * @param int    $total_plugin_upgrades total WordPress update.
     * @param array  $all_plugins_updates all WordPress update list.
     *
     * @param bool   $user_can_update_themes permission to update themes.
     * @param int    $total_theme_upgrades total themes update.
     * @param mixed  $all_themes_updates all themes update list.
     *
     * @param mixed  $mainwp_show_language_updates MainWP Language Updates.
     * @param bool   $user_can_update_translation permission to update languages.
     * @param int    $total_translation_upgrades total WordPress update.
     * @param mixed  $all_translations_updates all transations update list.
     */
    public static function render_global_update( // phpcs:ignore -- NOSONAR - complex.
        $update_type,
        $user_can_update_wordpress,
        $total_wp_upgrades,
        $all_wp_updates,
        $user_can_update_plugins,
        $total_plugin_upgrades,
        $all_plugins_updates,
        $user_can_update_themes,
        $total_theme_upgrades,
        $all_themes_updates,
        $mainwp_show_language_updates,
        $user_can_update_translation,
        $total_translation_upgrades,
        $all_translations_updates
    ) {

        $process = array(
            'core'   => in_array( $update_type, array( 'all', 'core' ), true ),
            'plugin' => in_array( $update_type, array( 'all', 'plugin' ), true ),
            'theme'  => in_array( $update_type, array( 'all', 'theme' ), true ),
            'trans'  => in_array( $update_type, array( 'all', 'trans' ), true ),
        );

        ?>

            <div id="wp_upgrades">
                <?php
                if ( $process['core'] && $user_can_update_wordpress && $total_wp_upgrades > 0 ) {
                    foreach ( $all_wp_updates as $item ) {
                        ?>
                        <div updated="0" site_id="<?php echo intval( $item['id'] ); ?>" site_name="<?php echo esc_attr( $item['name'] ); ?>" is-suspended="<?php echo ! empty( $item['is_suspended'] ) ? esc_attr( $item['is_suspended'] ) : ''; ?>"></div>
                        <?php
                    }
                }
                ?>
            </div>

            <div id="wp_plugin_upgrades">
                <?php
                if ( $process['plugin'] && $user_can_update_plugins && $total_plugin_upgrades > 0 ) {
                    foreach ( $all_plugins_updates as $item ) {
                        ?>
                        <div updated="0" site_id="<?php echo intval( $item['id'] ); ?>" site_name="<?php echo esc_attr( $item['name'] ); ?>" plugin_slug="<?php echo esc_attr( $item['plugin_slug'] ); ?>" is-suspended="<?php echo ! empty( $item['is_suspended'] ) ? esc_attr( $item['is_suspended'] ) : ''; ?>"></div>
                            <?php
                    }
                }
                ?>
            </div>
            <div id="wp_theme_upgrades">

                <?php
                if ( $process['theme'] && $user_can_update_themes && $total_theme_upgrades > 0 ) {
                    foreach ( $all_themes_updates as $item ) {
                        ?>
                        <div updated="0" site_id="<?php echo intval( $item['id'] ); ?>" site_name="<?php echo esc_attr( $item['name'] ); ?>" theme_slug="<?php echo esc_attr( $item['theme_slug'] ); ?>" is-suspended="<?php echo ! empty( $item['is_suspended'] ) ? esc_attr( $item['is_suspended'] ) : ''; ?>"></div>
                            <?php
                    }
                }
                ?>

            </div>
            <?php if ( 1 === (int) $mainwp_show_language_updates ) : ?>
            <div id="wp_translation_upgrades">

                <?php
                if ( $process['trans'] && $user_can_update_translation && $total_translation_upgrades > 0 ) {
                    foreach ( $all_translations_updates as $item ) {
                        ?>
                        <div updated="0" site_id="<?php echo intval( $item['id'] ); ?>" site_name="<?php echo esc_attr( $item['name'] ); ?>" translation_slug="<?php echo esc_attr( $item['translation_slug'] ); ?>" is-suspended="<?php echo ! empty( $item['is_suspended'] ) ? esc_attr( $item['is_suspended'] ) : ''; ?>"></div>
                        <?php
                    }
                }
                ?>
            </div>
            <?php endif; ?>
        <?php
    }

    /**
     * Render bottom of widget.
     *
     * @param array $sites_ids   Child sites ids.
     * @param bool  $globalView Whether it's global or individual site view.
     *
     * @uses \MainWP\Dashboard\MainWP_DB::fetch_object()
     * @uses \MainWP\Dashboard\MainWP_DB::data_seek()
     * @uses \MainWP\Dashboard\MainWP_DB::free_result()
     */
    public static function render_bottom( $sites_ids, $globalView ) {

        /**
         * Action: mainwp_updatesoverview_widget_bottom
         *
         * Fires at the bottom of the Updates Overview widgets.
         *
         * @param array $side_ids Array of sites IDs.
         * @param bool  $globalView Whether it's global or individual site view.
         *
         * @since 4.0
         */
        do_action( 'mainwp_updatesoverview_widget_bottom', $sites_ids, $globalView );
        ?>
        <div class="ui modal" id="updatesoverview-backup-box" tabindex="0">
            <div class="header"><?php esc_html_e( 'Backup Check', 'mainwp' ); ?></div>
            <div class="scrolling content mainwp-modal-content"></div>
            <div class="actions mainwp-modal-actions">
                <input id="updatesoverview-backup-all" type="button" name="<?php esc_attr_e( 'Backup All', 'mainwp' ); ?>" value="<?php esc_attr_e( 'Backup All', 'mainwp' ); ?>" class="ui basic button"/>
                <a id="updatesoverview-backup-now" href="#" target="_blank" style="display: none"  class="ui basic button"><?php esc_html_e( 'Backup Now', 'mainwp' ); ?></a>&nbsp;
                <input id="updatesoverview-backup-ignore" type="button" name="<?php esc_attr_e( 'Ignore', 'mainwp' ); ?>" value="<?php esc_attr_e( 'Ignore', 'mainwp' ); ?>" class="button"/>
            </div>
        </div>
        <?php
    }

    /**
     * Method dismiss_sync_errors()
     *
     * @param bool $dismiss true|false.
     *
     * @return bool true
     */
    public static function dismiss_sync_errors( $dismiss = true ) {
        global $current_user;
        update_user_option( $current_user->ID, 'mainwp_syncerrors_dismissed', $dismiss );

        return true;
    }

    /**
     * Method checkbackups()
     *
     * Check if Child Site needs to be backed up before updates.
     *
     * @return mixed $output
     *
     * @uses \MainWP\Dashboard\MainWP_Backup_Handler::is_archive()
     * @uses \MainWP\Dashboard\MainWP_DB::get_website_by_id()
     * @uses \MainWP\Dashboard\MainWP_DB::get_website_option()
     * @uses \MainWP\Dashboard\MainWP_System_Utility::get_primary_backup()
     * @uses \MainWP\Dashboard\MainWP_System_Utility::get_mainwp_specific_dir()
     */
    public static function check_backups() { // phpcs:ignore -- NOSONAR - complex.
        if ( empty( $_POST['sites'] ) || ! is_array( $_POST['sites'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification,WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- NOSONAR - verified before.
            return true;
        }

        $primaryBackup                = MainWP_System_Utility::get_primary_backup();
        $global_backup_before_upgrade = get_option( 'mainwp_backup_before_upgrade' );

        $mainwp_backup_before_upgrade_days = get_option( 'mainwp_backup_before_upgrade_days' );
        if ( empty( $mainwp_backup_before_upgrade_days ) || ! ctype_digit( $mainwp_backup_before_upgrade_days ) ) {
            $mainwp_backup_before_upgrade_days = 7;
        }

        $output = array();
        if ( isset( $_POST['sites'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification,WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
            foreach ( array_map( 'sanitize_text_field', wp_unslash( $_POST['sites'] ) ) as $siteId ) { // phpcs:ignore WordPress.Security.NonceVerification,WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
                $website = MainWP_DB::instance()->get_website_by_id( $siteId );
                if ( ( 0 === (int) $website->backup_before_upgrade ) || ( ( 2 === (int) $website->backup_before_upgrade ) && empty( $global_backup_before_upgrade ) ) ) {
                    continue;
                }

                $backup_method = '';
                if ( property_exists( $website, 'primary_backup_method' ) ) {
                    if ( '' === $website->primary_backup_method || 'global' === $website->primary_backup_method ) {
                        $backup_method = $primaryBackup;
                    } else {
                        $backup_method = $website->primary_backup_method;
                    }
                }

                if ( ! empty( $backup_method ) ) {
                    $lastBackup = MainWP_DB::instance()->get_website_option( $website, 'primary_lasttime_backup' );

                    if ( -1 !== $lastBackup ) { // installed backup plugin.
                        $output['sites'][ $siteId ] = ( $lastBackup < ( time() - ( $mainwp_backup_before_upgrade_days * 24 * 60 * 60 ) ) ? false : true );
                    }
                    $output['primary_backup'] = $backup_method;
                } else {
                    $dir = MainWP_System_Utility::get_mainwp_specific_dir( $siteId );
                    // Check if backup ok.
                    $lastBackup = - 1;
                    if ( file_exists( $dir ) ) {
                        $dh = opendir( $dir ); // NOSONAR.
                        if ( $dh ) {
                            while ( false !== ( $file = readdir( $dh ) ) ) {
                                if ( '.' !== $file && '..' !== $file ) {
                                    $theFile = $dir . $file;
                                    if ( MainWP_Backup_Handler::is_archive( $file ) && ! MainWP_Backup_Handler::is_sql_archive( $file ) && ( filemtime( $theFile ) > $lastBackup ) ) {
                                        $lastBackup = filemtime( $theFile );
                                    }
                                }
                            }
                            closedir( $dh );
                        }
                    }

                    $output['sites'][ $siteId ] = ( $lastBackup < ( time() - ( $mainwp_backup_before_upgrade_days * 24 * 60 * 60 ) ) ? false : true );
                }
            }
        }

        return $output;
    }
}

```