<?php defined('BX_DOL') or die('hack attempt');
/**
 * Copyright (c) UNA, Inc - https://una.io
 * MIT License - https://opensource.org/licenses/MIT
 *
 * @defgroup    UnaCore UNA Core
 * @{
 */

/**
 * Database queries for BxDolEmailTemplates object.
 * @see BxDolEmailTemplates
 */
class BxDolEmailTemplatesQuery extends BxDolDb implements iBxDolSingleton
{
    public static function getInstance()
    {
        if (!isset($GLOBALS['bxDolClasses'][__CLASS__])) {
            $o = new BxDolEmailTemplatesQuery();
            $GLOBALS['bxDolClasses'][__CLASS__] = $o;
        }

        return $GLOBALS['bxDolClasses'][__CLASS__];
    }

    public function getTemplate ($sTemplateName, $iLangAccount, $iLangDefault, $iLangFallback)
    {
        // get email templates keys
        $sSql = $this->prepare("SELECT `Subject`, `Body` FROM `sys_email_templates` WHERE `Name`=? LIMIT 1", $sTemplateName);
        $a = $this->getRow($sSql);
        if (!$a)
            return false;

        // build languages idsto search for translation in
        $aLangs = array ($iLangAccount);
        if ($iLangDefault != $iLangAccount)
            $aLangs[] = $iLangDefault;
        if ($iLangFallback != $iLangAccount && $iLangFallback != $iLangDefault)
            $aLangs[] = $iLangFallback;

        // get translation for subject
        $sSubject = false;
        foreach ($aLangs as $iLang)
            if ($sSubject = $this->getLangTranslation($a['Subject'], $iLang))
                break;
        if (!$sSubject)
            return false;

        // get translation for body
        $sBody = false;
        foreach ($aLangs as $iLang)
            if ($sBody = $this->getLangTranslation($a['Body'], $iLang))
                break;
        if (!$sBody)
            return false;

        // return result
        return array ('Subject' => $sSubject, 'Body' => $sBody);
    }

    public function getLangTranslation ($sKey, $iLangId)
    {
        $sSql = $this->prepare("SELECT `s`.`String` FROM `sys_localization_strings` as `s` INNER JOIN `sys_localization_keys` AS `k` ON (`s`.`IDKey` = `k`.`ID`) WHERE `k`.`Key` = ? AND `s`.`IDLanguage` = ? LIMIT 1", $sKey, $iLangId);
        return $this->getOne($sSql);
    }
}

/** @} */