442 lines
18 KiB
PHP
Executable File
442 lines
18 KiB
PHP
Executable File
<?php
|
|
if (!defined('sugarEntry') || !sugarEntry) {
|
|
die('Not A Valid Entry Point');
|
|
}
|
|
/**
|
|
*
|
|
* SugarCRM Community Edition is a customer relationship management program developed by
|
|
* SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
|
|
*
|
|
* SuiteCRM is an extension to SugarCRM Community Edition developed by SalesAgility Ltd.
|
|
* Copyright (C) 2011 - 2018 SalesAgility Ltd.
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify it under
|
|
* the terms of the GNU Affero General Public License version 3 as published by the
|
|
* Free Software Foundation with the addition of the following permission added
|
|
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
|
|
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
|
|
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
|
|
*
|
|
* This program 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 GNU Affero General Public License for more
|
|
* details.
|
|
*
|
|
* You should have received a copy of the GNU Affero General Public License along with
|
|
* this program; if not, see http://www.gnu.org/licenses or write to the Free
|
|
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
|
|
* 02110-1301 USA.
|
|
*
|
|
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
|
|
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
|
|
*
|
|
* The interactive user interfaces in modified source and object code versions
|
|
* of this program must display Appropriate Legal Notices, as required under
|
|
* Section 5 of the GNU Affero General Public License version 3.
|
|
*
|
|
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
|
|
* these Appropriate Legal Notices must retain the display of the "Powered by
|
|
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
|
|
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
|
|
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
|
|
*/
|
|
|
|
/*********************************************************************************
|
|
|
|
* Description: Base Form For Notes
|
|
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
|
|
* All Rights Reserved.
|
|
* Contributor(s): ______________________________________..
|
|
********************************************************************************/
|
|
|
|
|
|
#[\AllowDynamicProperties]
|
|
class EmailTemplateFormBase
|
|
{
|
|
public function __construct()
|
|
{
|
|
}
|
|
|
|
public function getFormBody($prefix, $mod='', $formname='', $size='30')
|
|
{
|
|
global $mod_strings;
|
|
|
|
$temp_strings = $mod_strings;
|
|
|
|
if (!empty($mod)) {
|
|
global $current_language;
|
|
$mod_strings = return_module_language($current_language, $mod);
|
|
}
|
|
global $app_strings;
|
|
global $app_list_strings;
|
|
|
|
$lbl_required_symbol = $app_strings['LBL_REQUIRED_SYMBOL'];
|
|
$lbl_subject = $mod_strings['LBL_NOTE_SUBJECT'];
|
|
$lbl_description = $mod_strings['LBL_NOTE'];
|
|
$default_parent_type= $app_list_strings['record_type_default_key'];
|
|
|
|
$form = <<<EOF
|
|
<input type="hidden" name="{$prefix}record" value="">
|
|
<input type="hidden" name="{$prefix}parent_type" value="{$default_parent_type}">
|
|
<p>
|
|
<table cellspacing="0" cellpadding="0" border="0">
|
|
<tr>
|
|
<td scope="row">$lbl_subject <span class="required">$lbl_required_symbol</span></td>
|
|
</tr>
|
|
<tr>
|
|
<td ><input name='{$prefix}name' size='{$size}' maxlength='255' type="text" value=""></td>
|
|
</tr>
|
|
<tr>
|
|
<td scope="row">$lbl_description</td>
|
|
</tr>
|
|
<tr>
|
|
<td ><textarea name='{$prefix}description' cols='{$size}' rows='4' ></textarea></td>
|
|
</tr>
|
|
</table></p>
|
|
EOF;
|
|
|
|
$javascript = new javascript();
|
|
$javascript->setFormName($formname);
|
|
$javascript->setSugarBean(BeanFactory::newBean('EmailTemplates'));
|
|
$javascript->addRequiredFields($prefix);
|
|
$form .=$javascript->getScript();
|
|
$mod_strings = $temp_strings;
|
|
return $form;
|
|
}
|
|
|
|
public function getForm($prefix, $mod='')
|
|
{
|
|
if (!empty($mod)) {
|
|
global $current_language;
|
|
$mod_strings = return_module_language($current_language, $mod);
|
|
} else {
|
|
global $mod_strings;
|
|
}
|
|
global $app_strings;
|
|
global $app_list_strings;
|
|
|
|
$lbl_save_button_title = $app_strings['LBL_SAVE_BUTTON_TITLE'];
|
|
$lbl_save_button_key = $app_strings['LBL_SAVE_BUTTON_KEY'];
|
|
$lbl_save_button_label = $app_strings['LBL_SAVE_BUTTON_LABEL'];
|
|
|
|
|
|
$the_form = get_left_form_header($mod_strings['LBL_NEW_FORM_TITLE']);
|
|
$the_form .= <<<EOQ
|
|
|
|
<form name="{$prefix}EmailTemplateSave" onSubmit="return check_form('{$prefix}EmailTemplateSave')" method="POST" action="index.php">
|
|
<input type="hidden" name="{$prefix}module" value="EmailTemplates">
|
|
<input type="hidden" name="{$prefix}action" value="Save">
|
|
EOQ;
|
|
$the_form .= $this->getFormBody($prefix, $mod, "{$prefix}EmailTemplateSave", "20");
|
|
$the_form .= <<<EOQ
|
|
<p><input title="$lbl_save_button_title" accessKey="$lbl_save_button_key" class="button" type="submit" name="button" value=" $lbl_save_button_label " ></p>
|
|
</form>
|
|
|
|
EOQ;
|
|
|
|
$the_form .= get_left_form_footer();
|
|
$the_form .= get_validate_record_js();
|
|
|
|
|
|
return $the_form;
|
|
}
|
|
|
|
|
|
public function handleSave($prefix, $redirect=true, $useRequired=false, $useSiteURL = false, $entryPoint = 'download', $useUploadFolder = false)
|
|
{
|
|
require_once('include/formbase.php');
|
|
require_once('include/upload_file.php');
|
|
global $upload_maxsize;
|
|
global $mod_strings;
|
|
global $sugar_config;
|
|
|
|
$focus = BeanFactory::newBean('EmailTemplates');
|
|
if ($useRequired && !checkRequired($prefix, array_keys($focus->required_fields))) {
|
|
return null;
|
|
}
|
|
$focus = populateFromPost($prefix, $focus);
|
|
//process the text only flag
|
|
if (isset($_POST['text_only']) && ($_POST['text_only'] == '1')) {
|
|
$focus->text_only = 1;
|
|
} else {
|
|
$focus->text_only = 0;
|
|
}
|
|
|
|
$this->checkAccess($focus);
|
|
|
|
if (!isset($_REQUEST['published'])) {
|
|
$focus->published = 'off';
|
|
}
|
|
|
|
$this->handleAttachmentsProcessImages($focus, $redirect, $useSiteURL, $entryPoint, $useUploadFolder);
|
|
return $focus;
|
|
}
|
|
|
|
public function handleAttachmentsProcessImages($focus, $redirect, $useSiteURL = false, $entryPoint = 'download', $useUploadFolder = false)
|
|
{
|
|
$return_id = $this->processImages($focus, $useSiteURL, $entryPoint, $useUploadFolder);
|
|
return $this->handleAttachments($focus, $redirect, $return_id);
|
|
}
|
|
|
|
public function processImages(&$focus, $useSiteURL, $entryPoint, $useUploadFolder)
|
|
{
|
|
global $sugar_config;
|
|
$preProcessedImages = array();
|
|
$emailTemplateBodyHtml = from_html($focus->body_html);
|
|
if (strpos((string) $emailTemplateBodyHtml, '"cache/images/')) {
|
|
$matches = array();
|
|
preg_match_all('#<img[^>]*[\s]+src[^=]*=[\s]*["\']cache/images/(.+?)["\']#si', (string) $emailTemplateBodyHtml, $matches);
|
|
foreach ($matches[1] as $match) {
|
|
$filename = urldecode($match);
|
|
if ($filename !== pathinfo($filename, PATHINFO_BASENAME)) {
|
|
// don't allow paths there
|
|
$emailTemplateBodyHtml = str_replace("cache/images/$match", "", (string) $emailTemplateBodyHtml);
|
|
continue;
|
|
}
|
|
$file_location = sugar_cached("images/{$filename}");
|
|
$mime_type = pathinfo($filename, PATHINFO_EXTENSION);
|
|
|
|
if (file_exists($file_location)) {
|
|
//$id = create_guid();
|
|
|
|
$note = BeanFactory::newBean('Notes');
|
|
$note->save();
|
|
$id = $note->id;
|
|
|
|
$newFileLocation = "upload://$id";
|
|
if (!copy($file_location, $newFileLocation)) {
|
|
$GLOBALS['log']->debug("EMAIL Template could not copy attachment to $newFileLocation");
|
|
} else {
|
|
if ($useUploadFolder) {
|
|
$secureLink = ($useSiteURL ? $sugar_config['site_url'] . '/' : '') . "public/{$id}";
|
|
// create a copy with correct extension by mime type
|
|
if (!file_exists('public')) {
|
|
sugar_mkdir('public', 0777);
|
|
}
|
|
if (copy($file_location, "public/{$id}.{$mime_type}")) {
|
|
$secureLink .= ".{$mime_type}";
|
|
}
|
|
} else {
|
|
$secureLink = ($useSiteURL ? $sugar_config['site_url'] . '/' : '') . "index.php?entryPoint=" . $entryPoint . "&type=Notes&id={$id}&filename=" . $match;
|
|
}
|
|
|
|
$emailTemplateBodyHtml = str_replace("cache/images/$match", $secureLink, (string) $emailTemplateBodyHtml);
|
|
//unlink($file_location);
|
|
$preProcessedImages[$filename] = $id;
|
|
}
|
|
} // if
|
|
} // foreach
|
|
} // if
|
|
if (isset($GLOBALS['check_notify'])) {
|
|
$check_notify = $GLOBALS['check_notify'];
|
|
} else {
|
|
$check_notify = false;
|
|
}
|
|
if ($preProcessedImages) {
|
|
$focus->body_html = $emailTemplateBodyHtml;
|
|
}
|
|
$return_id = $focus->save($check_notify);
|
|
return $return_id;
|
|
}
|
|
|
|
public function handleAttachments($focus, $redirect, $return_id)
|
|
{
|
|
///////////////////////////////////////////////////////////////////////////////
|
|
//// ATTACHMENT HANDLING
|
|
|
|
///////////////////////////////////////////////////////////////////////////
|
|
//// ADDING NEW ATTACHMENTS
|
|
|
|
global $mod_strings;
|
|
|
|
$max_files_upload = count($_FILES);
|
|
|
|
if (!empty($focus->id)) {
|
|
$note = BeanFactory::newBean('Notes');
|
|
$where = "notes.parent_id='{$focus->id}'";
|
|
if (!empty($_REQUEST['old_id'])) { // to support duplication of email templates
|
|
$where .= " OR notes.parent_id='".htmlspecialchars((string) $_REQUEST['old_id'], ENT_QUOTES)."'";
|
|
}
|
|
$notes_list = $note->get_full_list("", $where, true);
|
|
}
|
|
|
|
if (!isset($notes_list)) {
|
|
$notes_list = array();
|
|
}
|
|
|
|
if (!is_array($focus->attachments)) { // PHP5 does not auto-create arrays(). Need to initialize it here.
|
|
$focus->attachments = array();
|
|
}
|
|
$focus->attachments = array_merge($focus->attachments, $notes_list);
|
|
|
|
|
|
|
|
//for($i = 0; $i < $max_files_upload; $i++) {
|
|
|
|
foreach ($_FILES as $key => $file) {
|
|
$note = BeanFactory::newBean('Notes');
|
|
|
|
//Images are presaved above so we need to prevent duplicate files from being created.
|
|
if (isset($preProcessedImages[$file['name']])) {
|
|
$oldId = $preProcessedImages[$file['name']];
|
|
$note->id = $oldId;
|
|
$note->new_with_id = true;
|
|
$GLOBALS['log']->debug("Image {$file['name']} has already been processed.");
|
|
}
|
|
|
|
$i=preg_replace("/email_attachment(.+)/", '$1', $key);
|
|
$upload_file = new UploadFile($key);
|
|
|
|
if (isset($_FILES[$key]) && $upload_file->confirm_upload() && preg_match("/^email_attachment/", $key)) {
|
|
$note->filename = $upload_file->get_stored_file_name();
|
|
$note->file = $upload_file;
|
|
$note->name = $mod_strings['LBL_EMAIL_ATTACHMENT'].': '.$note->file->original_file_name;
|
|
if (isset($_REQUEST['embedded'.$i]) && !empty($_REQUEST['embedded'.$i])) {
|
|
if ($_REQUEST['embedded'.$i]=='true') {
|
|
$note->embed_flag =true;
|
|
} else {
|
|
$note->embed_flag =false;
|
|
}
|
|
}
|
|
array_push($focus->attachments, $note);
|
|
}
|
|
}
|
|
|
|
$focus->saved_attachments = array();
|
|
foreach ($focus->attachments as $note) {
|
|
if (!empty($note->id) && $note->new_with_id === false) {
|
|
if (empty($_REQUEST['old_id'])) {
|
|
array_push($focus->saved_attachments, $note);
|
|
} // to support duplication of email templates
|
|
else {
|
|
// we're duplicating a template with attachments
|
|
// dupe the file, create a new note, assign the note to the new template
|
|
$newNote = BeanFactory::newBean('Notes');
|
|
$newNote->retrieve($note->id);
|
|
$newNote->id = create_guid();
|
|
$newNote->parent_id = $focus->id;
|
|
$newNote->new_with_id = true;
|
|
$newNote->date_modified = '';
|
|
$newNote->date_entered = '';
|
|
/* BEGIN - SECURITY GROUPS */
|
|
//Need to do this so that attachments show under an EmailTemplate correctly for a normal user
|
|
global $current_user;
|
|
$newNote->assigned_user_id = $current_user->id;
|
|
/* END - SECURITY GROUPS */
|
|
$newNoteId = $newNote->save();
|
|
|
|
UploadFile::duplicate_file($note->id, $newNoteId, $note->filename);
|
|
}
|
|
continue;
|
|
}
|
|
$note->parent_id = $focus->id;
|
|
$note->parent_type = 'Emails';
|
|
$note->file_mime_type = $note->file->mime_type;
|
|
/* BEGIN - SECURITY GROUPS */
|
|
//Need to do this so that attachments show under an EmailTemplate correctly for a normal user
|
|
global $current_user;
|
|
$note->assigned_user_id = $current_user->id;
|
|
/* END - SECURITY GROUPS */
|
|
$note_id = $note->save();
|
|
array_push($focus->saved_attachments, $note);
|
|
$note->id = $note_id;
|
|
|
|
if ($note->new_with_id === false) {
|
|
$note->file->final_move($note->id);
|
|
} else {
|
|
$GLOBALS['log']->debug("Not performing final move for note id {$note->id} as it has already been processed");
|
|
}
|
|
}
|
|
|
|
//// END NEW ATTACHMENTS
|
|
///////////////////////////////////////////////////////////////////////////
|
|
|
|
///////////////////////////////////////////////////////////////////////////
|
|
//// ATTACHMENTS FROM DOCUMENTS
|
|
$count = '';
|
|
if (!empty($_REQUEST['document'])) {
|
|
$count = is_countable($_REQUEST['document']) ? count($_REQUEST['document']) : 0;
|
|
} else {
|
|
$count = 10;
|
|
}
|
|
|
|
for ($i=0; $i<$count; $i++) {
|
|
if (isset($_REQUEST['documentId'.$i]) && !empty($_REQUEST['documentId'.$i])) {
|
|
$doc = BeanFactory::newBean('Documents');
|
|
$docRev = BeanFactory::newBean('DocumentRevisions');
|
|
$docNote = BeanFactory::newBean('Notes');
|
|
|
|
$doc->retrieve($_REQUEST['documentId'.$i]);
|
|
$docRev->retrieve($doc->document_revision_id);
|
|
|
|
array_push($focus->saved_attachments, $docRev);
|
|
|
|
$docNote->name = $doc->document_name;
|
|
$docNote->filename = $docRev->filename;
|
|
$docNote->description = $doc->description;
|
|
$docNote->parent_id = $focus->id;
|
|
$docNote->parent_type = 'Emails';
|
|
$docNote->file_mime_type = $docRev->file_mime_type;
|
|
$docId = $docNote = $docNote->save();
|
|
|
|
UploadFile::duplicate_file($docRev->id, $docId, $docRev->filename);
|
|
}
|
|
}
|
|
|
|
//// END ATTACHMENTS FROM DOCUMENTS
|
|
///////////////////////////////////////////////////////////////////////////
|
|
|
|
///////////////////////////////////////////////////////////////////////////
|
|
//// REMOVE ATTACHMENTS
|
|
|
|
if (isset($_REQUEST['remove_attachment']) && !empty($_REQUEST['remove_attachment'])) {
|
|
foreach ($_REQUEST['remove_attachment'] as $noteId) {
|
|
$q = 'UPDATE notes SET deleted = 1 WHERE id = \''.$noteId.'\'';
|
|
$focus->db->query($q);
|
|
}
|
|
}
|
|
|
|
//// END REMOVE ATTACHMENTS
|
|
///////////////////////////////////////////////////////////////////////////
|
|
//// END ATTACHMENT HANDLING
|
|
///////////////////////////////////////////////////////////////////////////////
|
|
|
|
clear_register_value('select_array', $focus->object_name);
|
|
|
|
if ($redirect) {
|
|
$GLOBALS['log']->debug("Saved record with id of ".$return_id);
|
|
handleRedirect($return_id, "EmailTemplates");
|
|
} else {
|
|
return $focus;
|
|
}
|
|
}
|
|
|
|
/**
|
|
* @param SugarBean $focus
|
|
* @return void
|
|
*/
|
|
protected function checkAccess(SugarBean $focus): void
|
|
{
|
|
global $current_user;
|
|
|
|
if (!$focus->ACLAccess('Save')) {
|
|
ACLController::displayNoAccess(true);
|
|
sugar_cleanup(true);
|
|
}
|
|
|
|
$type = !empty($focus->type) ? $focus->type : '';
|
|
if (!empty($focus->id)) {
|
|
$template = BeanFactory::getBean('EmailTemplates', $focus->id);
|
|
|
|
if (!empty($template) && !empty($template->type)) {
|
|
$type = $template->type;
|
|
}
|
|
}
|
|
|
|
if ($type === 'system' && !is_admin($current_user)) {
|
|
ACLController::displayNoAccess(true);
|
|
sugar_cleanup(true);
|
|
}
|
|
}
|
|
}
|