modules/InboundEmail/EditView.php

   1 <?php
   2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
   3 /*********************************************************************************
   4  * SugarCRM is a customer relationship management program developed by
   5  * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
   6  *
   7  * This program is free software; you can redistribute it and/or modify it under
   8  * the terms of the GNU Affero General Public License version 3 as published by the
   9  * Free Software Foundation with the addition of the following permission added
  10  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
  11  * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
  12  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
  13  *
  14  * This program is distributed in the hope that it will be useful, but WITHOUT
  15  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  16  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
  17  * details.
  18  *
  19  * You should have received a copy of the GNU Affero General Public License along with
  20  * this program; if not, see http://www.gnu.org/licenses or write to the Free
  21  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
  22  * 02110-1301 USA.
  23  *
  24  * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
  25  * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
  26  *
  27  * The interactive user interfaces in modified source and object code versions
  28  * of this program must display Appropriate Legal Notices, as required under
  29  * Section 5 of the GNU Affero General Public License version 3.
  30  *
  31  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
  32  * these Appropriate Legal Notices must retain the display of the "Powered by
  33  * SugarCRM" logo. If the display of the logo is not reasonably feasible for
  34  * technical reasons, the Appropriate Legal Notices must display the words
  35  * "Powered by SugarCRM".
  36  ********************************************************************************/
  37
  38 $_REQUEST['edit']='true';
  39
  40 require_once('include/SugarFolders/SugarFolders.php');
  41 require_once('include/templates/TemplateGroupChooser.php');
  42
  43 // GLOBALS
  44 global $mod_strings;
  45 global $app_strings;
  46 global $app_list_strings;
  47 global $current_user;
  48
  49 $focus = new InboundEmail();
  50 $focus->checkImap();
  51 $javascript = new Javascript();
  52 $email = new Email();
  53 /* Start standard EditView setup logic */
  54
  55 $domMailBoxType = $app_list_strings['dom_mailbox_type'];
  56
  57 if(isset($_REQUEST['record'])) {
  58         $GLOBALS['log']->debug("In InboundEmail edit view, about to retrieve record: ".$_REQUEST['record']);
  59         $result = $focus->retrieve($_REQUEST['record']);
  60     if($result == null)
  61     {
  62         sugar_die($app_strings['ERROR_NO_RECORD']);
  63     }
  64 }
  65 else
  66 {
  67     if(!empty($_REQUEST['mailbox_type']))
  68         $focus->mailbox_type = $_REQUEST['mailbox_type'];
  69
  70     //Default to imap protocol for new accounts.
  71     $focus->protocol = 'imap';
  72 }
  73
  74 if($focus->mailbox_type == 'bounce')
  75 {
  76     unset($domMailBoxType['pick']);
  77     unset($domMailBoxType['createcase']);
  78 }
  79 else
  80     unset($domMailBoxType['bounce']);
  81
  82 if(isset($_REQUEST['isDuplicate']) && $_REQUEST['isDuplicate'] == 'true') {
  83         $GLOBALS['log']->debug("isDuplicate found - duplicating record of id: ".$focus->id);
  84         $focus->id = "";
  85 }
  86
  87 $GLOBALS['log']->info("InboundEmail Edit View");
  88 /* End standard EditView setup logic */
  89
  90 /* Start custom setup logic */
  91 // status drop down
  92 $status = get_select_options_with_id_separate_key($app_list_strings['user_status_dom'],$app_list_strings['user_status_dom'], $focus->status);
  93 // default MAILBOX value
  94 if(empty($focus->mailbox)) {
  95         $mailbox = 'INBOX';
  96 } else {
  97         $mailbox = $focus->mailbox;
  98 }
  99
 100 // service options breakdown
 101 $tls = '';
 102 $notls = '';
 103 $cert = '';
 104 $novalidate_cert = '';
 105 $ssl = '';
 106 if(!empty($focus->service)) {
 107         // will always have 2 values: /tls || /notls and /validate-cert || /novalidate-cert
 108         $exServ = explode('::', $focus->service);
 109         if($exServ[0] == 'tls') {
 110                 $tls = "CHECKED";
 111         } elseif($exServ[5] == 'notls') {
 112                 $notls = "CHECKED";
 113         }
 114         if($exServ[1] == 'validate-cert') {
 115                 $cert = "CHECKED";
 116         } elseif($exServ[4] == 'novalidate-cert') {
 117                 $novalidate_cert = 'CHECKED';
 118         }
 119         if(isset($exServ[2]) && !empty($exServ[2]) && $exServ[2] == 'ssl') {
 120                 $ssl = "CHECKED";
 121         }
 122 }
 123 $mark_read = '';
 124 if($focus->delete_seen == 0 || empty($focus->delete_seen)) {
 125         $mark_read = 'CHECKED';
 126 }
 127
 128 // mailbox type
 129
 130 if ($focus->is_personal) {
 131         array_splice($domMailBoxType, 1, 1);
 132 } // if
 133 $mailbox_type = get_select_options_with_id($domMailBoxType, $focus->mailbox_type);
 134
 135 // auto-reply email template
 136 $email_templates_arr = get_bean_select_array(true, 'EmailTemplate','name', '','name',true);
 137
 138 if(!empty($focus->stored_options)) {
 139         $storedOptions = unserialize(base64_decode($focus->stored_options));
 140         $from_name = $storedOptions['from_name'];
 141         $from_addr = $storedOptions['from_addr'];
 142
 143         $reply_to_name = (isset($storedOptions['reply_to_name'])) ? $storedOptions['reply_to_name'] : "";
 144         $reply_to_addr = (isset($storedOptions['reply_to_addr'])) ? $storedOptions['reply_to_addr'] : "";
 145
 146         $trashFolder = (isset($storedOptions['trashFolder'])) ? $storedOptions['trashFolder'] : "";
 147         $sentFolder = (isset($storedOptions['sentFolder'])) ? $storedOptions['sentFolder'] : "";
 148         $distrib_method = (isset($storedOptions['distrib_method'])) ? $storedOptions['distrib_method'] : "";
 149         $create_case_email_template = (isset($storedOptions['create_case_email_template'])) ? $storedOptions['create_case_email_template'] : "";
 150         $email_num_autoreplies_24_hours = (isset($storedOptions['email_num_autoreplies_24_hours'])) ? $storedOptions['email_num_autoreplies_24_hours'] : $focus->defaultEmailNumAutoreplies24Hours;
 151
 152         if($storedOptions['only_since']) {
 153                 $only_since = 'CHECKED';
 154         } else {
 155                 $only_since = '';
 156         }
 157         if(isset($storedOptions['filter_domain']) && !empty($storedOptions['filter_domain'])) {
 158                 $filterDomain = $storedOptions['filter_domain'];
 159         } else {
 160                 $filterDomain = '';
 161         }
 162         if(!isset($storedOptions['leaveMessagesOnMailServer']) || $storedOptions['leaveMessagesOnMailServer'] == 1) {
 163                 $leaveMessagesOnMailServer = 1;
 164         } else {
 165                 $leaveMessagesOnMailServer = 0;
 166         } // else
 167 } else { // initialize empty vars for template
 168         $from_name = $current_user->name;
 169         $from_addr = $current_user->email1;
 170         $reply_to_name = '';
 171         $reply_to_addr = '';
 172         $only_since = '';
 173         $filterDomain = '';
 174         $trashFolder = '';
 175         $sentFolder = '';
 176         $distrib_method ='';
 177         $create_case_email_template='';
 178         $leaveMessagesOnMailServer = 1;
 179         $email_num_autoreplies_24_hours = $focus->defaultEmailNumAutoreplies24Hours;
 180 } // else
 181
 182 // return action
 183 if(isset($focus->id)) {
 184         $return_action = 'DetailView';
 185 } else {
 186         $return_action = 'ListView';
 187 }
 188
 189 // javascript
 190 $javascript->setSugarBean($focus);
 191 $javascript->setFormName('EditView');
 192 $javascript->addRequiredFields();
 193 $javascript->addFieldGeneric('email_user', 'alpha', $mod_strings['LBL_LOGIN'], true);
 194 $javascript->addFieldGeneric('email_password', 'alpha', $mod_strings['LBL_PASSWORD'], false);
 195 $javascript->addFieldRange('email_num_autoreplies_24_hours', 'int', $mod_strings['LBL_MAX_AUTO_REPLIES'], true, "", 1, $focus->maxEmailNumAutoreplies24Hours);
 196
 197 $r = $focus->db->query('SELECT value FROM config WHERE name = \'fromname\'');
 198 $a = $focus->db->fetchByAssoc($r);
 199 $default_from_name = $a['value'];
 200 $r = $focus->db->query('SELECT value FROM config WHERE name = \'fromaddress\'');
 201 $a = $focus->db->fetchByAssoc($r);
 202 $default_from_addr = $a['value'];
 203
 204 /* End custom setup logic */
 205
 206
 207 // TEMPLATE ASSIGNMENTS
 208 if ($focus->mailbox_type == 'template') {
 209         $xtpl = new XTemplate('modules/InboundEmail/EmailAccountTemplateEditView.html');
 210 } else {
 211         $xtpl = new XTemplate('modules/InboundEmail/EditView.html');
 212 }
 213 // if no IMAP libraries available, disable Save/Test Settings
 214 if(!function_exists('imap_open')) {
 215         $xtpl->assign('IE_DISABLED', 'DISABLED');
 216 }
 217 // standard assigns
 218 $xtpl->assign('MOD', $mod_strings);
 219 $xtpl->assign('APP', $app_strings);
 220 $xtpl->assign('THEME', SugarThemeRegistry::current()->__toString());
 221 $xtpl->assign('GRIDLINE', $gridline);
 222 $xtpl->assign('MODULE', 'InboundEmail');
 223 $xtpl->assign('RETURN_MODULE', 'InboundEmail');
 224 $xtpl->assign('RETURN_ID', $focus->id);
 225 $xtpl->assign('RETURN_ACTION', $return_action);
 226 // module specific
 227 //$xtpl->assign('ROLLOVER', $email->rolloverStyle);
 228 $xtpl->assign("EMAIL_OPTIONS", $mod_strings['LBL_EMAIL_OPTIONS']);
 229 $xtpl->assign('MODULE_TITLE', get_module_title($mod_strings['LBL_MODULE_TITLE'], $mod_strings['LBL_MODULE_NAME'].": ".$focus->name, true));
 230 $xtpl->assign('ID', $focus->id);
 231 $xtpl->assign('NAME', $focus->name);
 232 $xtpl->assign('STATUS', $status);
 233 $xtpl->assign('SERVER_URL', $focus->server_url);
 234 $xtpl->assign('USER', $focus->email_user);
 235 // Don't send password back
 236 $xtpl->assign('HAS_PASSWORD', empty($focus->email_password)?0:1);
 237 $xtpl->assign('TRASHFOLDER', $trashFolder);
 238 $xtpl->assign('SENTFOLDER', $sentFolder);
 239 $xtpl->assign('MAILBOX', $mailbox);
 240 $xtpl->assign('TLS', $tls);
 241 $xtpl->assign('NOTLS', $notls);
 242 $xtpl->assign('CERT', $cert);
 243 $xtpl->assign('NOVALIDATE_CERT', $novalidate_cert);
 244 $xtpl->assign('SSL', $ssl);
 245
 246 $protocol = filterInboundEmailPopSelection($app_list_strings['dom_email_server_type']);
 247 $xtpl->assign('PROTOCOL', get_select_options_with_id($protocol, $focus->protocol));
 248 $xtpl->assign('MARK_READ', $mark_read);
 249 $xtpl->assign('MAILBOX_TYPE', $focus->mailbox_type);
 250 $xtpl->assign('TEMPLATE_ID', $focus->template_id);
 251 $xtpl->assign('EMAIL_TEMPLATE_OPTIONS', get_select_options_with_id($email_templates_arr, $focus->template_id));
 252 $xtpl->assign('ONLY_SINCE', $only_since);
 253 $xtpl->assign('FILTER_DOMAIN', $filterDomain);
 254 $xtpl->assign('EMAIL_NUM_AUTOREPLIES_24_HOURS', $email_num_autoreplies_24_hours);
 255 if(!empty($focus->port)) {
 256         $xtpl->assign('PORT', $focus->port);
 257 }
 258 // groups
 259 $groupId = "";
 260 $is_auto_import = "";
 261 $allow_outbound = '';
 262 if(isset($focus->id))
 263         $groupId = $focus->group_id;
 264 else
 265 {
 266         $groupId = create_guid();
 267         $is_auto_import = 'checked';
 268 }
 269
 270 $xtpl->assign('GROUP_ID', $groupId);
 271 // auto-reply stuff
 272 $xtpl->assign('FROM_NAME', $from_name);
 273 $xtpl->assign('FROM_ADDR', $from_addr);
 274 $xtpl->assign('DEFAULT_FROM_NAME', $default_from_name);
 275 $xtpl->assign('DEFAULT_FROM_ADDR', $default_from_addr);
 276 $xtpl->assign('REPLY_TO_NAME', $reply_to_name);
 277 $xtpl->assign('REPLY_TO_ADDR', $reply_to_addr);
 278 $createCaseRowStyle = "display:none";
 279 if($focus->template_id) {
 280         $xtpl->assign("EDIT_TEMPLATE","visibility:inline");
 281 } else {
 282         $xtpl->assign("EDIT_TEMPLATE","visibility:hidden");
 283 }
 284 if($focus->port == 110 || $focus->port == 995) {
 285         $xtpl->assign('DISPLAY', "display:''");
 286 } else {
 287         $xtpl->assign('DISPLAY', "display:none");
 288 }
 289 $leaveMessagesOnMailServerStyle = "display:none";
 290 if($focus->is_personal) {
 291         $xtpl->assign('DISABLE_GROUP', 'DISABLED');
 292         $xtpl->assign('EDIT_GROUP_FOLDER_STYLE', "display:none");
 293         $xtpl->assign('CREATE_GROUP_FOLDER_STYLE', "display:none");
 294         $xtpl->assign('MAILBOX_TYPE_STYLE', "display:none");
 295         $xtpl->assign('AUTO_IMPORT_STYLE', "display:none");
 296 } else {
 297         $folder = new SugarFolder();
 298         $xtpl->assign('CREATE_GROUP_FOLDER_STYLE', "display:''");
 299         $xtpl->assign('MAILBOX_TYPE_STYLE', "display:''");
 300         $xtpl->assign('AUTO_IMPORT_STYLE', "display:''");
 301         $ret = $folder->getFoldersForSettings($current_user);
 302
 303         //For existing records, do not allow
 304         $is_auto_import_disabled = "";
 305         if (!empty($focus->groupfolder_id))
 306         {
 307                 $is_auto_import = "checked";
 308             $xtpl->assign('EDIT_GROUP_FOLDER_STYLE', "visibility:inline");
 309                 $leaveMessagesOnMailServerStyle = "display:''";
 310                 $allow_outbound = (isset($storedOptions['allow_outbound_group_usage']) && $storedOptions['allow_outbound_group_usage'] == 1) ? 'CHECKED'  : '';
 311         }
 312         else
 313         {
 314                 $xtpl->assign('EDIT_GROUP_FOLDER_STYLE', "visibility:hidden");
 315         }
 316
 317         $xtpl->assign('ALLOW_OUTBOUND_USAGE', $allow_outbound);
 318         $xtpl->assign('IS_AUTO_IMPORT', $is_auto_import);
 319
 320         if ($focus->isMailBoxTypeCreateCase())
 321                 $createCaseRowStyle = "display:''";
 322
 323 }
 324
 325 $xtpl->assign('hasGrpFld',$focus->groupfolder_id == null ? '' : 'checked="1"');
 326 $xtpl->assign('LEAVEMESSAGESONMAILSERVER_STYLE', $leaveMessagesOnMailServerStyle);
 327 $xtpl->assign('LEAVEMESSAGESONMAILSERVER', get_select_options_with_id($app_list_strings['dom_int_bool'], $leaveMessagesOnMailServer));
 328 $distributionMethod = get_select_options_with_id($app_list_strings['dom_email_distribution_for_auto_create'], $distrib_method);
 329 $xtpl->assign('DISTRIBUTION_METHOD', $distributionMethod);
 330 $xtpl->assign('CREATE_CASE_ROW_STYLE', $createCaseRowStyle);
 331 $xtpl->assign('CREATE_CASE_EMAIL_TEMPLATE_OPTIONS', get_select_options_with_id($email_templates_arr, $create_case_email_template));
 332 if(!empty($create_case_email_template)) {
 333         $xtpl->assign("CREATE_CASE_EDIT_TEMPLATE","visibility:inline");
 334 } else {
 335         $xtpl->assign("CREATE_CASE_EDIT_TEMPLATE","visibility:hidden");
 336 }
 337
 338 $quicksearch_js = "";
 339
 340 //$javascript = get_set_focus_js(). $javascript->getScript() . $quicksearch_js;
 341 $xtpl->assign('JAVASCRIPT', get_set_focus_js(). $javascript->getScript() . $quicksearch_js);
 342
 343 // WINDOWS work arounds
 344 //if(is_windows()) {
 345 //      $xtpl->assign('MAYBE', '<style> div.maybe { display:none; }</style>');
 346 //}
 347 // PARSE AND PRINT
 348 //Overrides for bounce mailbox accounts
 349 if ($focus->mailbox_type == 'bounce')
 350 {
 351     $xtpl->assign('MODULE_TITLE', get_module_title($mod_strings['LBL_MODULE_TITLE'], $mod_strings['LBL_BOUNCE_MODULE_NAME'].": ".$focus->name, true));
 352     $xtpl->assign("EMAIL_OPTIONS", $mod_strings['LBL_EMAIL_BOUNCE_OPTIONS']);
 353     $xtpl->assign('MAILBOX_TYPE_STYLE', "display:none");
 354     $xtpl->assign('AUTO_IMPORT_STYLE', "display:none");
 355 }
 356 elseif ($focus->mailbox_type == 'createcase')
 357     $xtpl->assign("IS_CREATE_CASE", 'checked');
 358
 359 else if( $focus->is_personal == '1')
 360      $xtpl->assign('MODULE_TITLE', get_module_title($mod_strings['LBL_MODULE_TITLE'], $mod_strings['LBL_PERSONAL_MODULE_NAME'].": ".$focus->name, true));
 361
 362 //else
 363
 364
 365 $xtpl->parse("main");
 366 $xtpl->out("main");
 367 ?>