<?php

/**
 * 2007-2018 PrestaShop
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is bundled with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * https://opensource.org/licenses/OSL-3.0
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@prestashop.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future. If you wish to customize PrestaShop for your
 * needs please refer to http://www.prestashop.com for more information.
 *
 * @author    PrestaShop SA <contact@prestashop.com>
 * @copyright 2007-2018 PrestaShop SA
 * @license   https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
 * International Registered Trademark & Property of PrestaShop SA
 */

namespace PrestaShopBundle\Translation\Loader;

use Symfony\Component\Translation\Loader\LoaderInterface;
use Symfony\Component\Translation\MessageCatalogue;
use Doctrine\ORM\EntityManagerInterface;

class DatabaseTranslationLoader implements LoaderInterface
{
    /** @var EntityManagerInterface */
    protected $entityManager;

    /**
     * @param EntityManagerInterface $entityManager
     */
    public function __construct(EntityManagerInterface $entityManager)
    {
        $this->entityManager = $entityManager;
    }

    /**
     * {@inheritdoc}
     */
    public function load($resource, $locale, $domain = 'messages', $theme = null)
    {
        static $langs = array();
        if (!array_key_exists($locale, $langs)) {
            $langs[$locale] = $this->entityManager
                ->getRepository('PrestaShopBundle:Lang')
                ->findOneByLocale($locale)
            ;
        }

        $translationRepository = $this->entityManager
            ->getRepository('PrestaShopBundle:Translation')
        ;

        $queryBuilder = $translationRepository
            ->createQueryBuilder('t')
            ->where('t.lang =:lang')
            ->setParameter('lang', $langs[$locale])
        ;

        if (!is_null($theme)) {
            $queryBuilder
                ->andWhere('t.theme = :theme')
                ->setParameter('theme', $theme)
            ;
        } else {
            $queryBuilder->andWhere('t.theme IS NULL');
        }

        if ($domain !== '*') {
            $queryBuilder->andWhere('REGEXP(t.domain, :domain) = true')
                ->setParameter('domain', $domain)
            ;
        }

        $translations = $queryBuilder->getQuery()
            ->getResult()
        ;

        $catalogue = new MessageCatalogue($locale);

        foreach ($translations as $translation) {
            $catalogue->set($translation->getKey(), $translation->getTranslation(), $translation->getDomain());
        }

        return $catalogue;
    }
}
