function create($var, &$errors)
{
global $cfg;
if (!$var['name']) {
$errors['name'] = 'required';
} elseif (!$errors && Template::getIdByName($var['name'])) {
$errors['name'] = _('Name already in use');
}
if (!$var['copy_template']) {
$errors['copy_template'] = 'required';
} else {
if (!$errors) {
$template = new Template($var['copy_template'], $cfg->getId());
if (!is_object($template) || !$template->getId()) {
$errors['copy_template'] = _('Unknown template');
}
}
}
$id = 0;
if (!$errors && ($info = $template->getInfo())) {
$sql = 'INSERT INTO ' . EMAIL_TEMPLATE_TABLE . ' SET updated=NOW(), created=NOW() ' . ',cfg_id=' . db_input($cfg->getId()) . ',name=' . db_input(Format::striptags($var['name'])) . ',notes=' . db_input('New template: copy of ' . $info['name']) . ',ticket_autoresp_subj=' . db_input(Format::striptags($info['ticket_autoresp_subj'])) . ',ticket_autoresp_body=' . db_input(Format::striptags($info['ticket_autoresp_body'])) . ',message_autoresp_subj=' . db_input(Format::striptags($info['message_autoresp_subj'])) . ',message_autoresp_body=' . db_input(Format::striptags($info['message_autoresp_body'])) . ',ticket_notice_subj=' . db_input(Format::striptags($info['ticket_notice_subj'])) . ',ticket_notice_body=' . db_input(Format::striptags($info['ticket_notice_body'])) . ',ticket_alert_subj=' . db_input(Format::striptags($info['ticket_alert_subj'])) . ',ticket_alert_body=' . db_input(Format::striptags($info['ticket_alert_body'])) . ',message_alert_subj=' . db_input(Format::striptags($info['message_alert_subj'])) . ',message_alert_body=' . db_input(Format::striptags($info['message_alert_body'])) . ',note_alert_subj=' . db_input(Format::striptags($info['note_alert_subj'])) . ',note_alert_body=' . db_input(Format::striptags($info['note_alert_body'])) . ',assigned_alert_subj=' . db_input(Format::striptags($info['assigned_alert_subj'])) . ',assigned_alert_body=' . db_input(Format::striptags($info['assigned_alert_body'])) . ',ticket_overdue_subj=' . db_input(Format::striptags($info['ticket_overdue_subj'])) . ',ticket_overdue_body=' . db_input(Format::striptags($info['ticket_overdue_body'])) . ',ticket_overlimit_subj=' . db_input(Format::striptags($info['ticket_overlimit_subj'])) . ',ticket_overlimit_body=' . db_input(Format::striptags($info['ticket_overlimit_body'])) . ',ticket_reply_subj=' . db_input(Format::striptags($info['ticket_reply_subj'])) . ',ticket_reply_body=' . db_input(Format::striptags($info['ticket_reply_body']));
//echo $sql;
if (!db_query($sql) || !($id = db_insert_id())) {
$errors['err'] = _('Unable to create the template. Internal error occured');
}
}
return $id;
}
function create($var, &$errors)
{
global $cfg;
if (!$var['name']) {
$errors['name'] = 'obrigatório';
} elseif (!$errors && Template::getIdByName($var['name'])) {
$errors['name'] = 'Nome já está em uso';
}
if (!$var['copy_template']) {
$errors['copy_template'] = 'obrigatório';
} else {
if (!$errors) {
$template = new Template($var['copy_template'], $cfg->getId());
if (!is_object($template) || !$template->getId()) {
$errors['copy_template'] = 'Modelo desconhecido';
}
}
}
$id = 0;
if (!$errors && ($info = $template->getInfo())) {
$sql = 'INSERT INTO ' . EMAIL_TEMPLATE_TABLE . ' SET updated=NOW(), created=NOW() ' . ',cfg_id=' . db_input($cfg->getId()) . ',name=' . db_input(Format::striptags($var['name'])) . ',notes=' . db_input('New template: copy of ' . $info['name']) . ',ticket_autoresp_subj=' . db_input(Format::striptags($info['ticket_autoresp_subj'])) . ',ticket_autoresp_body=' . db_input(Format::striptags($info['ticket_autoresp_body'])) . ',message_autoresp_subj=' . db_input(Format::striptags($info['message_autoresp_subj'])) . ',message_autoresp_body=' . db_input(Format::striptags($info['message_autoresp_body'])) . ',ticket_notice_subj=' . db_input(Format::striptags($info['ticket_notice_subj'])) . ',ticket_notice_body=' . db_input(Format::striptags($info['ticket_notice_body'])) . ',ticket_alert_subj=' . db_input(Format::striptags($info['ticket_alert_subj'])) . ',ticket_alert_body=' . db_input(Format::striptags($info['ticket_alert_body'])) . ',message_alert_subj=' . db_input(Format::striptags($info['message_alert_subj'])) . ',message_alert_body=' . db_input(Format::striptags($info['message_alert_body'])) . ',note_alert_subj=' . db_input(Format::striptags($info['note_alert_subj'])) . ',note_alert_body=' . db_input(Format::striptags($info['note_alert_body'])) . ',assigned_alert_subj=' . db_input(Format::striptags($info['assigned_alert_subj'])) . ',assigned_alert_body=' . db_input(Format::striptags($info['assigned_alert_body'])) . ',ticket_overdue_subj=' . db_input(Format::striptags($info['ticket_overdue_subj'])) . ',ticket_overdue_body=' . db_input(Format::striptags($info['ticket_overdue_body'])) . ',ticket_overlimit_subj=' . db_input(Format::striptags($info['ticket_overlimit_subj'])) . ',ticket_overlimit_body=' . db_input(Format::striptags($info['ticket_overlimit_body'])) . ',ticket_reply_subj=' . db_input(Format::striptags($info['ticket_reply_subj'])) . ',ticket_reply_body=' . db_input(Format::striptags($info['ticket_reply_body']));
//echo $sql;
if (!db_query($sql) || !($id = db_insert_id())) {
$errors['err'] = 'Não foi possível criar o modelo. Erro interno';
}
}
return $id;
}
function save($id, $vars, &$errors)
{
global $cfg;
$tpl = null;
$vars['name'] = Format::striptags(trim($vars['name']));
if ($id && $id != $vars['id']) {
$errors['err'] = 'Internal error. Try again';
}
if (!$vars['name']) {
$errors['name'] = 'Name required';
} elseif (($tid = Template::getIdByName($vars['name'])) && $tid != $id) {
$errors['name'] = 'Template name already exists';
}
if (!$id && (!$vars['tpl_id'] || !($tpl = Template::lookup($vars['tpl_id'])))) {
$errors['tpl_id'] = 'Selection required';
}
if ($errors) {
return false;
}
$sql = ' updated=NOW() ' . ' ,name=' . db_input($vars['name']) . ' ,isactive=' . db_input($vars['isactive']) . ' ,notes=' . db_input($vars['notes']);
if ($id) {
$sql = 'UPDATE ' . EMAIL_TEMPLATE_TABLE . ' SET ' . $sql . ' WHERE tpl_id=' . db_input($id);
if (db_query($sql)) {
return true;
}
$errors['err'] = 'Unable to update the template. Internal error occurred';
} elseif ($tpl && ($info = $tpl->getInfo())) {
$sql = 'INSERT INTO ' . EMAIL_TEMPLATE_TABLE . ' SET ' . $sql . ' ,created=NOW() ' . ' ,cfg_id=' . db_input($cfg->getId()) . ' ,ticket_autoresp_subj=' . db_input($info['ticket_autoresp_subj']) . ' ,ticket_autoresp_body=' . db_input($info['ticket_autoresp_body']) . ' ,ticket_notice_subj=' . db_input($info['ticket_notice_subj']) . ' ,ticket_notice_body=' . db_input($info['ticket_notice_body']) . ' ,ticket_alert_subj=' . db_input($info['ticket_alert_subj']) . ' ,ticket_alert_body=' . db_input($info['ticket_alert_body']) . ' ,message_autoresp_subj=' . db_input($info['message_autoresp_subj']) . ' ,message_autoresp_body=' . db_input($info['message_autoresp_body']) . ' ,message_alert_subj=' . db_input($info['message_alert_subj']) . ' ,message_alert_body=' . db_input($info['message_alert_body']) . ' ,note_alert_subj=' . db_input($info['note_alert_subj']) . ' ,note_alert_body=' . db_input($info['note_alert_body']) . ' ,assigned_alert_subj=' . db_input($info['assigned_alert_subj']) . ' ,assigned_alert_body=' . db_input($info['assigned_alert_body']) . ' ,ticket_overdue_subj=' . db_input($info['ticket_overdue_subj']) . ' ,ticket_overdue_body=' . db_input($info['ticket_overdue_body']) . ' ,ticket_overlimit_subj=' . db_input($info['ticket_overlimit_subj']) . ' ,ticket_overlimit_body=' . db_input($info['ticket_overlimit_body']) . ' ,ticket_reply_subj=' . db_input($info['ticket_reply_subj']) . ' ,ticket_reply_body=' . db_input($info['ticket_reply_body']);
if (db_query($sql) && ($id = db_insert_id())) {
return $id;
}
$errors['err'] = 'Unable to create template. Internal error';
}
return false;
}
function create($var, &$errors)
{
global $cfg;
if (!$var['name']) {
$errors['name'] = 'requerido';
} elseif (!$errors && Template::getIdByName($var['name'])) {
$errors['name'] = 'Este nombre ya esta en uso';
}
if (!$var['copy_template']) {
$errors['copy_template'] = 'requerido';
} else {
if (!$errors) {
$template = new Template($var['copy_template'], $cfg->getId());
if (!is_object($template) || !$template->getId()) {
$errors['copy_template'] = 'Plantilla desconocida';
}
}
}
$id = 0;
if (!$errors && ($info = $template->getInfo())) {
$sql = 'INSERT INTO ' . EMAIL_TEMPLATE_TABLE . ' SET updated=NOW(), created=NOW() ' . ',cfg_id=' . db_input($cfg->getId()) . ',name=' . db_input(Format::striptags($var['name'])) . ',notes=' . db_input('Nueva plantilla: Copia de ' . $info['name']) . ',ticket_autoresp_subj=' . db_input(Format::striptags($info['ticket_autoresp_subj'])) . ',ticket_autoresp_body=' . db_input(Format::striptags($info['ticket_autoresp_body'])) . ',message_autoresp_subj=' . db_input(Format::striptags($info['message_autoresp_subj'])) . ',message_autoresp_body=' . db_input(Format::striptags($info['message_autoresp_body'])) . ',ticket_notice_subj=' . db_input(Format::striptags($info['ticket_notice_subj'])) . ',ticket_notice_body=' . db_input(Format::striptags($info['ticket_notice_body'])) . ',ticket_alert_subj=' . db_input(Format::striptags($info['ticket_alert_subj'])) . ',ticket_alert_body=' . db_input(Format::striptags($info['ticket_alert_body'])) . ',message_alert_subj=' . db_input(Format::striptags($info['message_alert_subj'])) . ',message_alert_body=' . db_input(Format::striptags($info['message_alert_body'])) . ',note_alert_subj=' . db_input(Format::striptags($info['note_alert_subj'])) . ',note_alert_body=' . db_input(Format::striptags($info['note_alert_body'])) . ',assigned_alert_subj=' . db_input(Format::striptags($info['assigned_alert_subj'])) . ',assigned_alert_body=' . db_input(Format::striptags($info['assigned_alert_body'])) . ',ticket_overdue_subj=' . db_input(Format::striptags($info['ticket_overdue_subj'])) . ',ticket_overdue_body=' . db_input(Format::striptags($info['ticket_overdue_body'])) . ',ticket_overlimit_subj=' . db_input(Format::striptags($info['ticket_overlimit_subj'])) . ',ticket_overlimit_body=' . db_input(Format::striptags($info['ticket_overlimit_body'])) . ',ticket_reply_subj=' . db_input(Format::striptags($info['ticket_reply_subj'])) . ',ticket_reply_body=' . db_input(Format::striptags($info['ticket_reply_body']));
//echo $sql;
if (!db_query($sql) || !($id = db_insert_id())) {
$errors['err'] = 'No se puede crear la plantilla. Error interno';
}
}
return $id;
}
