tests/modules/Emails/FindEmailFromBeanIdsTest.php

   1 <?php
   2 require_once('modules/Emails/EmailUI.php');
   3
   4 /**
   5  * Test cases for Bug 9755
   6  */
   7 class FindEmailFromBeanIdTest extends Sugar_PHPUnit_Framework_TestCase
   8 {
   9         private $emailUI;
  10         private $beanIds, $beanType, $whereArr;
  11         private $resultQuery, $expectedQuery;
  12
  13         function setUp()
  14         {
  15                 global $current_user, $currentModule ;
  16                 $current_user = SugarTestUserUtilities::createAnonymousUser();
  17                 $this->emailUI = new EmailUI();
  18                 $this->beanIds[] = '8744c7d9-9e4b-2338-cb76-4ab0a3d0a651';
  19                 $this->beanIds[] = '8749a110-1d85-4562-fa23-4ab0a3c65e12';
  20                 $this->beanIds[] = '874c1242-4645-898d-238a-4ab0a3f7e7c3';
  21                 $this->beanType = 'users';
  22                 $this->whereArr['first_name'] = 'testfn';
  23                 $this->whereArr['last_name'] = 'testln';
  24                 $this->whereArr['email_address'] = 'test@example.com';
  25                 $this->expectedQuery = <<<EOQ
  26 SELECT users.id, users.first_name, users.last_name, eabr.primary_address, ea.email_address, 'Users' module FROM users JOIN email_addr_bean_rel eabr ON (users.id = eabr.bean_id and eabr.deleted=0) JOIN email_addresses ea ON (eabr.email_address_id = ea.id)  WHERE (users.deleted = 0 AND eabr.primary_address = 1 AND users.id in ('8744c7d9-9e4b-2338-cb76-4ab0a3d0a651','8749a110-1d85-4562-fa23-4ab0a3c65e12','874c1242-4645-898d-238a-4ab0a3f7e7c3')) AND (first_name LIKE 'testfn%' OR last_name LIKE 'testln%' OR email_address LIKE 'test@example.com%')
  27 EOQ;
  28         }
  29
  30         function tearDown()
  31         {
  32                 unset($this->emailUI);
  33                 SugarTestUserUtilities::removeAllCreatedAnonymousUsers();
  34         unset($GLOBALS['current_user']);
  35         }
  36
  37         function testFindEmailFromBeanIdTest()
  38         {
  39                 //$this->resultQuery = $this->emailUI->findEmailFromBeanIds('', $this->beanType, $this->whereArr);
  40                 $this->resultQuery = $this->emailUI->findEmailFromBeanIds($this->beanIds, $this->beanType, $this->whereArr);
  41                 $this->assertEquals($this->expectedQuery, $this->resultQuery);
  42         }
  43 }
  44
  45 ?>