tests/include/SubPanel/GetUnionRelatedTest.php

   1 <?php
   2 /*********************************************************************************
   3  * SugarCRM Community Edition is a customer relationship management program developed by
   4  * SugarCRM, Inc. Copyright (C) 2004-2011 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
  38 require_once('data/SugarBean.php');
  39 require_once('modules/Contacts/Contact.php');
  40 require_once('include/SubPanel/SubPanelDefinitions.php');
  41
  42 /**
  43  * test get_union_related_list() with subpanels, functions, distinct clause
  44  */
  45 class GetUnionRelatedTest extends Sugar_PHPUnit_Framework_TestCase
  46 {
  47     /**
  48      * Bean to use for tests
  49      * @var SugarBean
  50      */
  51     protected $bean;
  52
  53         public function setUp()
  54         {
  55             global $moduleList, $beanList, $beanFiles;
  56         require('include/modules.php');
  57             $GLOBALS['current_user'] = SugarTestUserUtilities::createAnonymousUser();
  58         $this->bean = new Contact();
  59         }
  60
  61         public function tearDown()
  62         {
  63                 SugarTestUserUtilities::removeAllCreatedAnonymousUsers();
  64         unset($GLOBALS['current_user']);
  65         }
  66
  67     public function testGetUnionRelatedList()
  68     {
  69         $subpanel = array(
  70                         'order' => 20,
  71                         'sort_order' => 'desc',
  72                         'sort_by' => 'date_entered',
  73                         'type' => 'collection',
  74                         'subpanel_name' => 'history',   //this values is not associated with a physical file.
  75                         'top_buttons' => array(),
  76                         'collection_list' => array(
  77                                 'meetings' => array(
  78                                         'module' => 'Meetings',
  79                                         'subpanel_name' => 'ForHistory',
  80                                         'get_subpanel_data' => 'meetings',
  81                                 ),
  82                                 'emails' => array(
  83                                         'module' => 'Emails',
  84                                         'subpanel_name' => 'ForHistory',
  85                                         'get_subpanel_data' => 'emails',
  86                                     'get_distinct_data' => true,
  87                                 ),
  88                                 'linkedemails_contacts' => array(
  89                         'module' => 'Emails',
  90                         'subpanel_name' => 'ForHistory',
  91                                     'generate_select'=>true,
  92                                     'get_distinct_data' => true,
  93                     'get_subpanel_data' => 'function:GetUnionRelatedTest_get_select',
  94                                 'function_parameters' => array('import_function_file' => __FILE__),
  95                                 ),
  96                         )
  97         );
  98         $subpanel_def = new aSubPanel("testpanel", $subpanel, $this->bean);
  99         $query = $this->bean->get_union_related_list($this->bean, "", '', "", 0, 5, -1, 0, $subpanel_def);
 100         $result = $this->bean->db->query($query["query"]);
 101         $this->assertTrue($result != false, "Bad query: {$query["query"]}");
 102     }
 103 }
 104
 105 function GetUnionRelatedTest_get_select()
 106 {
 107     $return_array['select']='SELECT DISTINCT emails.id';
 108     $return_array['from']='FROM emails ';
 109         $return_array['join'] = " JOIN emails_email_addr_rel eear ON eear.email_id = emails.id AND eear.deleted=0
 110                         JOIN email_addr_bean_rel eabr ON eabr.email_address_id=eear.email_address_id AND eabr.bean_module = 'Contacts'
 111                                 AND eabr.deleted=0 AND eabr.bean_id = '1'";
 112     $return_array['where']="";
 113     $return_array['join_tables'] = array();
 114     return $return_array;
 115 }