/** * Function to save a given record model of the current module * @param EmailtTemplates_Record_Model $recordModel * @return <integer> template id */ public function saveRecord(EmailTemplates_Record_Model $recordModel) { $db = PearDatabase::getInstance(); $templateid = $recordModel->getId(); if (empty($templateid)) { $templateid = $db->getUniqueID('vtiger_emailtemplates'); $sql = "INSERT INTO vtiger_emailtemplates(templatename, subject, description, body, deleted, templateid) VALUES (?,?,?,?,?,?)"; } else { $sql = "UPDATE vtiger_emailtemplates SET templatename=?, subject=?, description=?, body=?, deleted=? WHERE templateid = ?"; } $params = array(decode_html($recordModel->get('templatename')), decode_html($recordModel->get('subject')), decode_html($recordModel->get('description')), $recordModel->get('body'), 0, $templateid); $db->pquery($sql, $params); return $recordModel->setId($templateid); }
public function process(Vtiger_Request $request) { $moduleName = $request->getModule(); $record = $request->get('record'); $recordModel = new EmailTemplates_Record_Model(); $recordModel->setModule($moduleName); if (!empty($record)) { $recordModel->setId($record); } $recordModel->set('templatename', $request->get('templatename')); $recordModel->set('description', $request->get('description')); $recordModel->set('subject', $request->get('subject')); $recordModel->set('body', $request->get('templatecontent')); $recordModel->save(); $loadUrl = $recordModel->getDetailViewUrl(); header("Location: {$loadUrl}"); }