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-2011 SugarCRM Inc.
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.
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
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
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.
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.
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 ********************************************************************************/
38 /*********************************************************************************
41 ********************************************************************************/
50 class CampaignLog extends SugarBean {
52 var $table_name = 'campaign_log';
53 var $object_name = 'CampaignLog';
54 var $module_dir = 'CampaignLog';
56 var $new_schema = true;
59 var $target_tracker_key;
69 var $more_information;
71 function CampaignLog() {
77 function get_list_view_data(){
79 $temp_array = $this->get_list_view_array();
80 //make sure that both items in array are set to some value, else return null
81 if(!(isset($temp_array['TARGET_TYPE']) && $temp_array['TARGET_TYPE']!= '') || !(isset($temp_array['TARGET_ID']) && $temp_array['TARGET_ID']!= ''))
82 { //needed values to construct query are empty/null, so return null
83 $GLOBALS['log']->debug("CampaignLog.php:get_list_view_data duntion: temp_array['TARGET_TYPE'] and/or temp_array['TARGET_ID'] are empty, return null");
88 $table = strtolower($temp_array['TARGET_TYPE']);
90 if ( ( $this->db->dbType == 'mysql' ) or ( $this->db->dbType == 'oci8' ) )
92 $query="select first_name, last_name, CONCAT(CONCAT(first_name, ' '), last_name) name, date_modified from ".strtolower($temp_array['TARGET_TYPE']) . " where id ='{$temp_array['TARGET_ID']}'";
94 if($this->db->dbType == 'mssql')
96 $query="select first_name, last_name, (first_name + ' ' + last_name) name, date_modified from ".strtolower($temp_array['TARGET_TYPE']) . " where id ='{$temp_array['TARGET_ID']}'";
99 if($temp_array['TARGET_TYPE']=='Accounts'){
100 $query = "select name from $table where id = ".$this->db->quoted($temp_array['TARGET_ID']);
102 $query = "select first_name, last_name, ".$this->db->concat($table, array('first_name', 'last_name'))." name from $table" .
103 " where id = ".$this->db->quoted($temp_array['TARGET_ID']);
105 $result=$this->db->query($query);
106 $row=$this->db->fetchByAssoc($result);
109 if($temp_array['TARGET_TYPE']=='Accounts'){
110 $temp_array['RECIPIENT_NAME']=$row['name'];
112 $full_name = $locale->getLocaleFormattedName($row['first_name'], $row['last_name'], '');
113 $temp_array['RECIPIENT_NAME']=$full_name;
114 $temp_array['ACTIVITY_DATE'] = $row['date_modified'];
117 $temp_array['RECIPIENT_EMAIL']=$this->retrieve_email_address($temp_array['TARGET_ID']);
119 $query = 'select name from email_marketing where id = \'' . $temp_array['MARKETING_ID'] . '\'';
120 $result=$this->db->query($query);
121 $row=$this->db->fetchByAssoc($result);
125 $temp_array['MARKETING_NAME'] = $row['name'];
131 function retrieve_email_address($trgt_id = ''){
133 if(!empty($trgt_id)){
134 $qry = " select eabr.primary_address, ea.email_address";
135 $qry .= " from email_addresses ea ";
136 $qry .= " Left Join email_addr_bean_rel eabr on eabr.email_address_id = ea.id ";
137 $qry .= " where eabr.bean_id = '{$trgt_id}' ";
138 $qry .= " and ea.deleted = 0 ";
139 $qry .= " and eabr.deleted = 0" ;
140 $qry .= " order by primary_address desc ";
142 $result=$this->db->query($qry);
143 $row=$this->db->fetchByAssoc($result);
145 if (!empty($row['email_address'])){
146 $return_str = $row['email_address'];
155 //this function is called statically by the campaing_log subpanel.
156 function get_related_name($related_id, $related_type) {
158 $db= DBManagerFactory::getInstance();
159 if ($related_type == 'Emails') {
160 $query="SELECT name from emails where id='$related_id'";
161 $result=$db->query($query);
162 $row=$db->fetchByAssoc($result);
167 if ($related_type == 'Contacts') {
168 $query="SELECT first_name, last_name from contacts where id='$related_id'";
169 $result=$db->query($query);
170 $row=$db->fetchByAssoc($result);
172 return $full_name = $locale->getLocaleFormattedName($row['first_name'], $row['last_name']);
175 if ($related_type == 'Leads') {
176 $query="SELECT first_name, last_name from leads where id='$related_id'";
177 $result=$db->query($query);
178 $row=$db->fetchByAssoc($result);
180 return $full_name = $locale->getLocaleFormattedName($row['first_name'], $row['last_name']);
183 if ($related_type == 'Prospects') {
184 $query="SELECT first_name, last_name from prospects where id='$related_id'";
185 $result=$db->query($query);
186 $row=$db->fetchByAssoc($result);
188 return $full_name = $locale->getLocaleFormattedName($row['first_name'], $row['last_name']);
191 if ($related_type == 'CampaignTrackers') {
192 $query="SELECT tracker_url from campaign_trkrs where id='$related_id'";
193 $result=$db->query($query);
194 $row=$db->fetchByAssoc($result);
196 return $row['tracker_url'] ;
199 if ($related_type == 'Accounts') {
200 $query="SELECT name from accounts where id='$related_id'";
201 $result=$db->query($query);
202 $row=$db->fetchByAssoc($result);
207 return $related_id.$related_type;