include/SugarObjects/templates/company/Company.php

   1 <?php
   2 /*********************************************************************************
   3  * SugarCRM Community Edition is a customer relationship management program developed by
   4  * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
   5  *
   6  * This program is free software; you can redistribute it and/or modify it under
   7  * the terms of the GNU Affero General Public License version 3 as published by the
   8  * Free Software Foundation with the addition of the following permission added
   9  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
  10  * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
  11  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
  12  *
  13  * This program is distributed in the hope that it will be useful, but WITHOUT
  14  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  15  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
  16  * details.
  17  *
  18  * You should have received a copy of the GNU Affero General Public License along with
  19  * this program; if not, see http://www.gnu.org/licenses or write to the Free
  20  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
  21  * 02110-1301 USA.
  22  *
  23  * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
  24  * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
  25  *
  26  * The interactive user interfaces in modified source and object code versions
  27  * of this program must display Appropriate Legal Notices, as required under
  28  * Section 5 of the GNU Affero General Public License version 3.
  29  *
  30  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
  31  * these Appropriate Legal Notices must retain the display of the "Powered by
  32  * SugarCRM" logo. If the display of the logo is not reasonably feasible for
  33  * technical reasons, the Appropriate Legal Notices must display the words
  34  * "Powered by SugarCRM".
  35  ********************************************************************************/
  36
  37 require_once('include/SugarObjects/templates/basic/Basic.php');
  38
  39 class Company extends Basic
  40 {
  41         /**
  42          * Constructor
  43          */
  44     public function Company()
  45         {
  46                 parent::Basic();
  47                 $this->emailAddress = new SugarEmailAddress();
  48         }
  49
  50         /**
  51          * @see parent::save()
  52          */
  53         public function save($check_notify=false)
  54         {
  55             if(!empty($GLOBALS['resavingRelatedBeans']))
  56             {
  57                 return parent::save($check_notify);
  58             }
  59                 $this->add_address_streets('billing_address_street');
  60                 $this->add_address_streets('shipping_address_street');
  61         $ori_in_workflow = empty($this->in_workflow) ? false : true;
  62                 $this->emailAddress->handleLegacySave($this, $this->module_dir);
  63         $record_id = parent::save($check_notify);
  64         $override_email = array();
  65         if(!empty($this->email1_set_in_workflow)) {
  66             $override_email['emailAddress0'] = $this->email1_set_in_workflow;
  67         }
  68         if(!empty($this->email2_set_in_workflow)) {
  69             $override_email['emailAddress1'] = $this->email2_set_in_workflow;
  70         }
  71         if(!isset($this->in_workflow)) {
  72             $this->in_workflow = false;
  73         }
  74         if($ori_in_workflow === false || !empty($override_email)){
  75             $this->emailAddress->save($this->id, $this->module_dir, $override_email,'','','','',$this->in_workflow);
  76         }
  77                 return $record_id;
  78         }
  79
  80         /**
  81          * Populate email address fields here instead of retrieve() so that they are properly available for logic hooks
  82          *
  83          * @see parent::fill_in_relationship_fields()
  84          */
  85         public function fill_in_relationship_fields()
  86         {
  87             parent::fill_in_relationship_fields();
  88             $this->emailAddress->handleLegacyRetrieve($this);
  89         }
  90
  91         /**
  92          * @see parent::get_list_view_data()
  93          */
  94         public function get_list_view_data()
  95         {
  96                 global $system_config;
  97                 global $current_user;
  98
  99                 $temp_array = $this->get_list_view_array();
 100
 101                 $temp_array['EMAIL1'] = $this->emailAddress->getPrimaryAddress($this);
 102
 103             $this->email1 = $temp_array['EMAIL1'];
 104
 105                 $temp_array['EMAIL1_LINK'] = $current_user->getEmailLink('email1', $this, '', '', 'ListView');
 106
 107                 return $temp_array;
 108         }
 109
 110     /**
 111      * Default export query for Company based modules
 112      * used to pick all mails (primary and non-primary)
 113      *
 114      * @see SugarBean::create_export_query()
 115      */
 116     function create_export_query(&$order_by, &$where, $relate_link_join = '')
 117     {
 118         $custom_join = $this->custom_fields->getJOIN(true, true, $where);
 119
 120         // For easier code reading, reused plenty of time
 121         $table = $this->table_name;
 122
 123         if($custom_join)
 124         {
 125             $custom_join['join'] .= $relate_link_join;
 126         }
 127         $query = "SELECT
 128                                         $table.*,
 129                                         email_addresses.email_address email_address,
 130                                         '' email_addresses_non_primary, " . // email_addresses_non_primary needed for get_field_order_mapping()
 131                                         "users.user_name as assigned_user_name ";
 132         if($custom_join)
 133         {
 134             $query .= $custom_join['select'];
 135         }
 136
 137         $query .= " FROM $table ";
 138
 139
 140         $query .= "LEFT JOIN users
 141                                         ON $table.assigned_user_id=users.id ";
 142
 143
 144         //Join email address table too.
 145         $query .=  " LEFT JOIN email_addr_bean_rel on $table.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module = '" . $this->module_dir . "' and email_addr_bean_rel.deleted = 0 and email_addr_bean_rel.primary_address = 1";
 146         $query .=  " LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id ";
 147
 148         if($custom_join)
 149         {
 150             $query .= $custom_join['join'];
 151         }
 152
 153         $where_auto = " $table.deleted=0 ";
 154
 155         if($where != "")
 156         {
 157             $query .= "WHERE ($where) AND " . $where_auto;
 158         }
 159         else
 160         {
 161             $query .= "WHERE " . $where_auto;
 162         }
 163
 164         $order_by = $this->process_order_by($order_by);
 165         if (!empty($order_by)) {
 166             $query .= ' ORDER BY ' . $order_by;
 167         }
 168
 169         return $query;
 170     }
 171
 172 }