source: trunk/inc/classes/BxDolEmailTemplates.php

<?php

/***************************************************************************
*                            Dolphin Smart Community Builder
*                              -----------------
*     begin                : Mon Mar 23 2006
*     copyright            : (C) 2006 BoonEx Group
*     website              : http://www.boonex.com/
* This file is part of Dolphin - Smart Community Builder
*
* Dolphin is free software. This work is licensed under a Creative Commons Attribution 3.0 License. 
* http://creativecommons.org/licenses/by/3.0/
*
* Dolphin is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
* without even the implied warranty of  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the Creative Commons Attribution 3.0 License for more details. 
* You should have received a copy of the Creative Commons Attribution 3.0 License along with Dolphin, 
* see license.txt file; if not, write to marketing@boonex.com
***************************************************************************/

bx_import('BxDolPaginate');

class BxDolEmailTemplates {
        var $iDefaultLangId;
        var $aDefaultKeys;

        /**
         * Class constructor.
         */
        function BxDolEmailTemplates() {
                $this->iDefaultLangId = $GLOBALS['MySQL']->getOne("SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='" . process_db_input($GLOBALS['sCurrentLanguage']) . "' LIMIT 1");
                $this->aDefaultKeys = array(
            'Domain' => $GLOBALS['site']['url'],
            'SiteName' => $GLOBALS['site']['title'],
                );
        }

        /**
         * Update existing or create new template ;
         *
         * @param $sTemplateName (string)   - name of template ;
         * @param $sTemplateSubj (string)   - subject of template ;
         * @param $sTemplateBody (string)   - text of template ;
         * @param $iLangID (integer)        - needed language's ID; 
         * @return HTML presentation data ;
         */
        function setTemplate( $sTemplateName, $sTemplateSubj, $sTemplateBody, $iLangID ) 
        {
                if ( !db_value("SELECT `ID` FROM `sys_email_templates` WHERE `Name` = '" . process_db_input($sTemplateName) . "'  AND `LangID` = '{$iLangID}'") ) 
                {
                        $sQuery = 
                        " 
                                INSERT INTO 
                                        `sys_email_templates` (`Name`, `Subject`, `Body`, `LangID`)  
                                VALUES
                                        (
                                                '" . process_db_input($sTemplateName) . "', 
                                                '" . process_db_input($sTemplateSubj) . "',
                                                '" . process_db_input($sTemplateBody) . "',
                                                '" . (int) $iLangID . "'
                                        )
                        ";

                        $sMessage = 'Template was created';
                }
                else
                {
                        $sQuery = 
                        " 
                                UPDATE 
                                        `sys_email_templates` 
                                SET 
                                        `Subject` = '" . process_db_input($sTemplateSubj) . "',
                                        `Body` = '" . process_db_input($sTemplateBody) . "'
                                WHERE 
                                        `Name`   = '" . process_db_input($sTemplateName) . "'
                                                AND
                                        `LangID` = '" . (int) $iLangID . "'
                                LIMIT 1    
                        ";

                        $sMessage = 'Template was updated';
                }

                db_res($sQuery);
                return $this ->  genTemplatesForm( $sTemplateName, $iLangID, $sMessage ) ;
        }

        /**
         * Function will return array of needed template ;
         *                 
         * @param string $sTemplateName - name of necessary template.
         * @param integer $iMemberId - ID of registered member.
         * @return array with template subject and its body.
         */
        function getTemplate($sTemplateName, $iMemberId = 0 ) {
                if($iMemberId != 0) {
                    $aProfile = getProfileInfo($iMemberId);
                    $iUseLang = $aProfile['LangID'] ? $aProfile['LangID'] : $this->iDefaultLangId;
                }
                else {
            $iUseLang = $this->iDefaultLangId;
                }

                $sSql = "SELECT `Subject`, `Body` FROM `sys_email_templates` WHERE `Name`='" . process_db_input($sTemplateName) . "' AND (`LangID` = '" . (int) $iUseLang . "' OR `LangID` = '0') ORDER BY `LangID` DESC LIMIT 1";
                return $GLOBALS['MySQL']->getRow($sSql);
        }

        function parseTemplate($sTemplateName, $aTemplateKeys, $iMemberId = 0) {
            $aTemplate = $this->getTemplate($sTemplateName, $iMemberId);

            return array(
               'subject' => $this->parseContent($aTemplate['Subject'], $aTemplateKeys, $iMemberId),
               'body' => $this->parseContent($aTemplate['Body'], $aTemplateKeys, $iMemberId)
            );
        }
        function parseContent($sContent, $aKeys, $iMemberId = 0) {
            $aResultKeys = $this->aDefaultKeys;
            if($iMemberId != 0) {
            $aProfile = getProfileInfo($iMemberId);
            
            $aResultKeys = array_merge($aResultKeys, array(
                'recipientID' => $aProfile['ID'],
                'RealName'    => $aProfile['NickName'],
                'NickName'        => $aProfile['NickName'],
                'Email'       => $aProfile['Email'],
                'Password'    => $aProfile['Password'],
                'SiteName'        => getParam('site_title'),
            ));
            }
            if(is_array($aKeys))
            $aResultKeys = array_merge($aResultKeys, $aKeys);
            
            return $GLOBALS['oSysTemplate']->parseHtmlByContent($sContent, $aResultKeys, array('<', '>'));
    }
}
?>