TranslationHandler

Complexity

Total Complexity

32

Size/Duplication

Total Lines	284
Duplicated Lines	5.99 %

Coupling/Cohesion

Components	1
Dependencies	0

Importance

Changes

0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	createMessageFiles()	0	8	2
B	createMessageFile()	6	77	8
A	escape_text()	0	12	2
A	prepare_text()	11	11	2
A	addText()	0	21	3
A	clearReferences()	0	4	1
A	importFromTable()	0	40	4
A	loadNodeTextFile()	0	22	4
B	substitueVariables()	0	25	6

<?php
/***************************************************************************
 * for license information see LICENSE.md
 ***************************************************************************/

$translationHandler = new TranslationHandler();

/**
 * Class TranslationHandler
 */
class TranslationHandler
{
    /**
     * create all files in cache2/translate
     */
    public function createMessageFiles(): void
    {
        $rs = sqlf('SELECT DISTINCT `lang` FROM `sys_trans_text`');

The function sqlf() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        while ($r = sql_fetch_assoc($rs)) {

The function sql_fetch_assoc() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            $this->createMessageFile($r['lang']);
        }
        sql_free_result($rs);

The function sql_free_result() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

    }

    /**
     * create file in cache2/translate/$language/LC_MESSAGES/...
     *
     * @param $language
     */
    private function createMessageFile($language): void
    {
        global $opt;

        $language_upper = mb_strtoupper($language);
        $language_lower = mb_strtolower($language);
        if (!isset($opt['locale'][$language_upper])) {
            return;
        }

        if (!is_dir(__DIR__ . '/../var/cache2/translate/' . $language_lower)) {
            mkdir(__DIR__ . '/../var/cache2/translate/' . $language_lower);
        }
        if (!is_dir(__DIR__ . '/../var/cache2/translate/' . $language_lower . '/LC_MESSAGES')) {
            mkdir(__DIR__ . '/../var/cache2/translate/' . $language_lower . '/LC_MESSAGES');
        }

        $f = fopen(__DIR__ . '/../var/cache2/translate/' . $language_lower . '/LC_MESSAGES/messages.po', 'wb');

        fwrite($f, 'msgid ""' . "\n");
        fwrite($f, 'msgstr ""' . "\n");
        fwrite($f, '"MIME-Version: 1.0\n"' . "\n");
        fwrite($f, '"Content-Type: text/plain; charset=UTF-8\n"' . "\n");
        fwrite($f, '"Content-Transfer-Encoding: 8bit\n"' . "\n");
        fwrite($f, "\n");

        // English texts in sys_trans_text are more up-to-date than the original translation
        // strings in sys_trans. Therefore sys_trans_text/EN is used whenever a translation
        // is missing and sys_trans_text/EN differs from sys_trans.

        $rs = sqlf(

The function sqlf() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            "
            SELECT
                `sys_trans`.`text` AS `text`,
                IFNULL(`stt`.`text`, `stt_en`.`text`) AS `trans`
            FROM
                `sys_trans`
                LEFT JOIN `sys_trans_text` `stt` ON `stt`.`trans_id`=`sys_trans`.`id` AND `stt`.`lang`='&1'
                LEFT JOIN `sys_trans_text` `stt_en` ON `stt_en`.`trans_id`=`sys_trans`.`id` AND `stt_en`.`lang`='EN'
                WHERE `sys_trans`.`text`!=''",
            $language_upper
        );

        $variables = array();
        $this->loadNodeTextFile($variables, $opt['logic']['node']['id'] . '.txt', $language_lower);
        $this->loadNodeTextFile(
            $variables,
            $opt['logic']['node']['id'] . '-' . $language_lower . '.txt',
            $language_lower
        );

        while ($r = sql_fetch_assoc($rs)) {

The function sql_fetch_assoc() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            $trans = $r['trans'];
            if ($trans !== null && $trans != $r['text']) {
                $trans = $this->substitueVariables($variables, $language_lower, $trans);

                fwrite($f, 'msgid "' . $this->escape_text($r['text']) . '"' . "\n");
                fwrite($f, 'msgstr "' . $this->escape_text($trans) . '"' . "\n");
                fwrite($f, "\n");
            }
        }
        sql_free_result($rs);

The function sql_free_result() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        fclose($f);

        try {
            exec(
                'msgfmt -o ' . escapeshellcmd(
                    __DIR__ . '/../var/cache2/translate/' . $language_lower . '/LC_MESSAGES/messages.mo'
                ) . ' ' . escapeshellcmd(
                    __DIR__ . '/../var/cache2/translate/' . $language_lower . '/LC_MESSAGES/messages.po'
                )
            );
        } catch (Exception $e) {
            // @todo implement logging
        }
    }

    /**
     * escape string for po-file
     *
     * @param $text
     *
     * @return string
     */
    private function escape_text($text)
    {
        $text = mb_ereg_replace('\\\\', '\\\\', $text);
        $text = mb_ereg_replace('"', '\"', $text);
        $text = mb_ereg_replace("\r", '', $text);
        while (mb_substr($text, - 1, 1) == "\n") {
            $text = mb_substr($text, 0, mb_strlen($text) - 1);
        }
        $text = mb_ereg_replace("\n", "\\n\"\n\"", $text);

        return $text;
    }

    /**
     * @param $text
     *
     * @return string
     */
    private function prepare_text($text)

This method seems to be duplicated in your project.

    {
        $text = mb_ereg_replace("\t", ' ', $text);
        $text = mb_ereg_replace("\r", ' ', $text);
        $text = mb_ereg_replace("\n", ' ', $text);
        while (mb_strpos($text, '  ') !== false) {
            $text = mb_ereg_replace('  ', ' ', $text);
        }

        return $text;
    }

    /**
     * add text to database
     *
     * @param $text
     * @param $resource_name
     * @param $line
     */
    public function addText($text, $resource_name, $line): void
    {
        if ($text == '') {
            return;
        }

        $text = $this->prepare_text($text);

        $trans_id = sqlf_value("SELECT `id` FROM `sys_trans` WHERE `text`='&1'", 0, $text);

The function sqlf_value() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        if ($trans_id == 0) {
            sqlf("INSERT INTO `sys_trans` (`text`) VALUES ('&1')", $text);

The function sqlf() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            $trans_id = sql_insert_id();

The function sql_insert_id() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        }

        sqlf(

The function sqlf() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            "INSERT IGNORE INTO `sys_trans_ref` (`trans_id`, `resource_name`, `line`) VALUES ('&1', '&2', '&3')",
            $trans_id,
            $resource_name,
            $line
        );
    }

    /**
     * clear sys_trans_ref to begin new translation of resource
     */
    public function clearReferences(): void
    {
        sqlf('DELETE FROM `sys_trans_ref`');

The function sqlf() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

    }

    /**
     * import strings from given field to sys_trans_text
     *
     * @param $table
     * @param string $fname
     * @param string $fid
     */
    public function importFromTable($table, $fname = 'name', $fid = 'trans_id'): void
    {
        $rs = sqlf(

The function sqlf() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            'SELECT `&1`.`&2`
            FROM `&1`
            LEFT JOIN `sys_trans`
                ON `&1`.`&3`=`sys_trans`.`id`
                AND `&1`.`&2`=`sys_trans`.`text`',
            $table,
            $fname,
            $fid
        );
        while ($r = sql_fetch_array($rs)) {

The function sql_fetch_array() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

$rs is of type object<mysqli_result>, but the function expects a resource.

            if ($r[$fname] == '') {
                continue;
            }

            $lastId = sqlf_value("SELECT `id` FROM `sys_trans` WHERE `text`='&1'", 0, $r[$fname]);

The function sqlf_value() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            if ($lastId == 0) {
                sqlf("INSERT INTO `sys_trans` (`text`) VALUES ('&1')", $r[$fname]);

The function sqlf() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

                $lastId = sql_insert_id();

The function sql_insert_id() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            }

            sqlf(

The function sqlf() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

                "INSERT IGNORE INTO `sys_trans_ref` (`trans_id`, `resource_name`, `line`) VALUES ('&1', '&2', 0)",
                $lastId,
                'table:' . $table . ';field=' . $fname
            );
        }
        sql_free_result($rs);

The function sql_free_result() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        sqlf('UPDATE `&1` SET `&2`=0', $table, $fid);

The function sqlf() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        sqlf(

The function sqlf() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            'UPDATE `&1`, `sys_trans`
            SET `&1`.`&3`=`sys_trans`.`id`
            WHERE `&1`.`&2`=`sys_trans`.`text`',
            $table,
            $fname,
            $fid
        );
    }

    /**
     * import variables for substition from config2/nodetext/
     *
     * @param $variables
     * @param string $file
     * @param string $language
     *
     * @return bool
     */
    public function loadNodeTextFile(&$variables, $file, $language)
    {
        $filename = __DIR__ . '/../config2/nodetext/' . $file;
        if (file_exists($filename)) {
            $fhandle = fopen($filename, 'rb');

            if ($fhandle) {
                while ($line = fgets($fhandle, 4096)) {
                    $pos = mb_strpos($line, ' ');
                    $variable = mb_substr($line, 0, $pos);
                    $substitution = mb_substr($line, $pos + 1, mb_strlen($line));
                    $substitution = rtrim($substitution);
                    $variables[$language][$variable] = $substitution;
                }
                fclose($fhandle);

                return true;
            }
        }

        return false;
    }

    /**
     * @param $variables
     * @param string $lang
     * @param $str
     *
     * @return string
     */
    public function substitueVariables(&$variables, $lang, $str)
    {
        $langStr = $str;

        // replace variables in string
        if (mb_ereg_search_init($langStr)) {
            while (false != $vars = mb_ereg_search_regs('%[^%]*%')) {
                foreach ($vars as $curly_pattern) {
                    // $curly_pattern contatins %pattern% in replacement string
                    $pattern = mb_substr($curly_pattern, 1, mb_strlen($curly_pattern) - 2);

                    // avoid recursive loop
                    if ($pattern != $str) {
                        if (isset($variables[$lang][$pattern])) {
                            $pattern_replacement = $variables[$lang][$pattern];

                            $langstr = mb_ereg_replace($curly_pattern, $pattern_replacement, $langStr);

$langstr is not used, you could remove the assignment.

                        }
                    }
                }
            }
        }

        return $langStr;
    }
}