TranslationsDumper.php

<?php

namespace AppBundle\Helper;

use Pimcore\Config;
use Pimcore\Db;

class TranslationsDumper
{
    public function dump()
    {
        $res = Db::get()->fetchAll("SELECT * FROM translations_website");
        $translations = [];

        foreach ($res as $key => $translation) {
            if (in_array($translation['language'], $this->getAvailableLanguages())) {
                $translations[$translation['language']][$translation['key']] = $translation['text'] ? $translation['text'] : $translation['key'];
            }
        }
        return $translations;
    }


    /**
     * @return array
     */
    protected function getAvailableLanguages()
    {
        try {
            $general = Config::getSystemConfig()->get('general');
            return explode(',', $general->get('validLanguages'));
        } catch (\Exception $e) {
            return [];
        }

    }
}