<?php

namespace Piwik\Plugins\Diagnostics\Diagnostic;

use Piwik\Db;
use Piwik\Piwik;
use Piwik\SettingsPiwik;
use Piwik\Translation\Translator;
use Piwik\Metrics\Formatter;
use Piwik\Url;
/**
 * Check if Piwik is connected with database through ssl.
 */
class DbMaxPacket implements \Piwik\Plugins\Diagnostics\Diagnostic\Diagnostic
{
    /**
     * @var Translator
     */
    private $translator;
    public const MIN_VALUE_MAX_PACKET_MB = 64;
    public function __construct(Translator $translator)
    {
        $this->translator = $translator;
    }
    public function execute()
    {
        if (!SettingsPiwik::isMatomoInstalled()) {
            return array();
            // only possible to perform check once we have DB connection
        }
        $maxPacketBytes = Db::fetchRow("SHOW VARIABLES LIKE 'max_allowed_packet'");
        $status = \Piwik\Plugins\Diagnostics\Diagnostic\DiagnosticResult::STATUS_OK;
        $label = $this->translator->translate('Diagnostics_MysqlMaxPacketSize');
        $comment = '';
        $minSize = self::MIN_VALUE_MAX_PACKET_MB * 1000 * 1000;
        // not using 1024 just in case... this amount be good enough
        if (!empty($maxPacketBytes['Value']) && $maxPacketBytes['Value'] < $minSize) {
            $status = \Piwik\Plugins\Diagnostics\Diagnostic\DiagnosticResult::STATUS_WARNING;
            $formatter = new Formatter\Html();
            $pretty = $formatter->getPrettySizeFromBytes($maxPacketBytes['Value'], 'M', $precision = 1);
            $configured = str_replace(array(' M', '&nbsp;M'), 'MB', $pretty);
            $comment = Piwik::translate('Diagnostics_MysqlMaxPacketSizeWarning', [Url::getExternalLinkTag('https://dev.mysql.com/doc/refman/en/packet-too-large.html'), '</a>', '64MB', $configured]);
        }
        return array(\Piwik\Plugins\Diagnostics\Diagnostic\DiagnosticResult::singleResult($label, $status, $comment));
    }
}
