<?php /********************************************************************* templates.php Email Templates Peter Rotich <peter@osticket.com> Copyright (c) 2006-2013 osTicket http://www.osticket.com Released under the GNU General Public License WITHOUT ANY WARRANTY. See LICENSE.TXT for details. vim: expandtab sw=4 ts=4 sts=4: **********************************************************************/ require('admin.inc.php'); include_once(INCLUDE_DIR.'class.template.php'); $template=null; if($_REQUEST['tpl_id'] && !($template=EmailTemplateGroup::lookup($_REQUEST['tpl_id']))) $errors['err']='Unknown or invalid template group ID.'; elseif($_REQUEST['id'] && !($template=EmailTemplate::lookup($_REQUEST['id']))) $errors['err']='Unknown or invalid template ID.'; elseif($_REQUEST['default_for']) { $sql = 'SELECT id FROM '.EMAIL_TEMPLATE_TABLE .' WHERE tpl_id='.db_input($cfg->getDefaultTemplateId()) .' AND code_name='.db_input($_REQUEST['default_for']); if ($id = db_result(db_query($sql))) Http::redirect('templates.php?a=manage&id='.db_input($id)); } if($_POST){ switch(strtolower($_POST['do'])){ case 'updatetpl': if(!$template){ $errors['err']='Unknown or invalid template'; }elseif($template->update($_POST,$errors)){ $msg='Message template updated successfully'; // Drop drafts for this template for ALL users Draft::deleteForNamespace('tpl.'.$template->getCodeName() .'.'.$template->getTplId()); }elseif(!$errors['err']){ $errors['err']='Error updating message template. Try again!'; } break; case 'implement': if(!$template){ $errors['err']='Unknown or invalid template'; }elseif($new = EmailTemplate::add($_POST,$errors)){ $template = $new; $msg='Message template updated successfully'; // Drop drafts for this user for this template Draft::deleteForNamespace('tpl.'.$new->getCodeName() .$new->getTplId(), $thisstaff->getId()); }elseif(!$errors['err']){ $errors['err']='Error updating message template. Try again!'; } break; case 'update': if(!$template){ $errors['err']='Unknown or invalid template'; }elseif($template->update($_POST,$errors)){ $msg='Template updated successfully'; }elseif(!$errors['err']){ $errors['err']='Error updating template. Try again!'; } break; case 'add': if(($new=EmailTemplateGroup::add($_POST,$errors))){ $template=$new; $msg='Template added successfully'; $_REQUEST['a']=null; }elseif(!$errors['err']){ $errors['err']='Unable to add template. Correct error(s) below and try again.'; } break; case 'mass_process': if(!$_POST['ids'] || !is_array($_POST['ids']) || !count($_POST['ids'])) { $errors['err']='You must select at least one template to process.'; } else { $count=count($_POST['ids']); switch(strtolower($_POST['a'])) { case 'enable': $sql='UPDATE '.EMAIL_TEMPLATE_GRP_TABLE.' SET isactive=1 ' .' WHERE tpl_id IN ('.implode(',', db_input($_POST['ids'])).')'; if(db_query($sql) && ($num=db_affected_rows())){ if($num==$count) $msg = 'Selected templates enabled'; else $warn = "$num of $count selected templates enabled"; } else { $errors['err'] = 'Unable to enable selected templates'; } break; case 'disable': $i=0; foreach($_POST['ids'] as $k=>$v) { if(($t=EmailTemplateGroup::lookup($v)) && !$t->isInUse() && $t->disable()) $i++; } if($i && $i==$count) $msg = 'Selected templates disabled'; elseif($i) $warn = "$i of $count selected templates disabled (in-use templates can't be disabled)"; else $errors['err'] = "Unable to disable selected templates (in-use or default template can't be disabled)"; break; case 'delete': $i=0; foreach($_POST['ids'] as $k=>$v) { if(($t=EmailTemplateGroup::lookup($v)) && !$t->isInUse() && $t->delete()) $i++; } if($i && $i==$count) $msg = 'Selected templates deleted successfully'; elseif($i>0) $warn = "$i of $count selected templates deleted"; elseif(!$errors['err']) $errors['err'] = 'Unable to delete selected templates'; break; default: $errors['err']='Unknown template action'; } } break; default: $errors['err']='Unknown action'; break; } } $page='templates.inc.php'; $tip_namespace = 'email.templates'; if($template && !strcasecmp($_REQUEST['a'],'manage')){ $page='tpl.inc.php'; }elseif($template && !strcasecmp($_REQUEST['a'],'implement')){ $page='tpl.inc.php'; }elseif($template || !strcasecmp($_REQUEST['a'],'add')){ $page='template.inc.php'; $tip_namespace = 'emails.email_template_form'; } $nav->setTabActive('emails'); $ost->addExtraHeader('<meta name="tip-namespace" content="' . $tip_namespace . '" />', "$('#content').data('tipNamespace', '".$tip_namespace."');"); require(STAFFINC_DIR.'header.inc.php'); require(STAFFINC_DIR.$page); include(STAFFINC_DIR.'footer.inc.php'); ?>