modules/Campaigns/EmailQueue.php

   1 <?php
   2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
   3 /*********************************************************************************
   4  * SugarCRM Community Edition is a customer relationship management program developed by
   5  * SugarCRM, Inc. Copyright (C) 2004-2012 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 /*********************************************************************************
  39
  40  * Description:  TODO: To be written.
  41  * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
  42  * All Rights Reserved.
  43  * Contributor(s): ______________________________________..
  44  ********************************************************************************/
  45
  46
  47
  48
  49
  50
  51
  52 global $timedate;
  53 global $current_user;
  54
  55
  56 $campaign = new Campaign();
  57 $campaign->retrieve($_REQUEST['record']);
  58
  59 $query = "SELECT prospect_list_id as id FROM prospect_list_campaigns WHERE campaign_id='$campaign->id' AND deleted=0";
  60
  61 $fromName = $_REQUEST['from_name'];
  62 $fromEmail = $_REQUEST['from_address'];
  63 $date_start = $_REQUEST['date_start'];
  64 $time_start = $_REQUEST['time_start'];
  65 $template_id = $_REQUEST['email_template'];
  66
  67 $dateval = $timedate->merge_date_time($date_start, $time_start);
  68
  69
  70 $listresult = $campaign->db->query($query);
  71
  72 while($list = $campaign->db->fetchByAssoc($listresult))
  73 {
  74         $prospect_list = $list['id'];
  75         $focus = new ProspectList();
  76
  77         $focus->retrieve($prospect_list);
  78
  79         $query = "SELECT prospect_id,contact_id,lead_id FROM prospect_lists_prospects WHERE prospect_list_id='$focus->id' AND deleted=0";
  80         $result = $focus->db->query($query);
  81
  82         while($row = $focus->db->fetchByAssoc($result))
  83         {
  84                 $prospect_id = $row['prospect_id'];
  85                 $contact_id = $row['contact_id'];
  86                 $lead_id = $row['lead_id'];
  87
  88                 if($prospect_id <> '')
  89                 {
  90                         $moduleName = "Prospects";
  91                         $moduleID = $row['prospect_id'];
  92                 }
  93                 if($contact_id <> '')
  94                 {
  95                         $moduleName = "Contacts";
  96                         $moduleID = $row['contact_id'];
  97                 }
  98                 if($lead_id <> '')
  99                 {
 100                         $moduleName = "Leads";
 101                         $moduleID = $row['lead_id'];
 102                 }
 103
 104                 $mailer = new EmailMan();
 105                 $mailer->module = $moduleName;
 106                 $mailer->module_id = $moduleID;
 107                 $mailer->user_id = $current_user->id;
 108                 $mailer->list_id = $prospect_list;
 109                 $mailer->template_id = $template_id;
 110                 $mailer->from_name = $fromName;
 111                 $mailer->from_email = $fromEmail;
 112                 $mailer->send_date_time = $dateval;
 113                 $mailer->save();
 114         }
 115
 116
 117 }
 118
 119
 120 $header_URL = "Location: index.php?action=DetailView&module=Campaigns&record={$_REQUEST['record']}";
 121 $GLOBALS['log']->debug("about to post header URL of: $header_URL");
 122
 123 header($header_URL);
 124 ?>