Odyssey
Public Member Functions | List of all members
SendEmailTest Class Reference
Inheritance diagram for SendEmailTest:

Public Member Functions

 setUp ()
 
 test_ValidateTemplate ()
 
 test_ConstructSQL ()
 

Detailed Description

Definition at line 9 of file SendEmailTest.php.

Member Function Documentation

◆ setUp()

SendEmailTest::setUp ( )

function setUp() Need to require all files here.

Definition at line 15 of file SendEmailTest.php.

15  {
16  $sharedLibrary = "/var/www/html/shared/library";
17  $admIncludes = "/var/www/html/admcom/includes";
18  require_once("$sharedLibrary/hcuFunctions.i");
19  require_once("$admIncludes/aSendEmail.data");
20  }

◆ test_ConstructSQL()

SendEmailTest::test_ConstructSQL ( )

function test_ConstructSQL() Validates the function _ConstructSQL().

Definition at line 77 of file SendEmailTest.php.

77  {
78  $Cu = "ANOTHERCU";
79  $optin = 1;
80  $select = "not in list";
81  $emailFlag = 518; // Purposely wrong values
82  $askBillPay = 35;
83 
84  $results = _ConstructSQL($Cu, $optin, $select, $emailFlag, $askBillPay);
85  $this->assertEquals($results["error"], "Option is not valid.");
86 
87  $select = "all";
88  $results = _ConstructSQL($Cu, $optin, $select, $emailFlag, $askBillPay);
89  $this->assertEquals($results["status"], "000");
90  $baseSQL = $results["data"]["baseSQL"];
91 
92  $this->assertContains("from ANOTHERCUuser u", $baseSQL);
93  $this->assertContains("(coalesce(u.msg_tx, 0) & 518) = 0", $baseSQL);
94  $this->assertContains("u.egenl_flag = 'Y'", $baseSQL);
95  $this->assertNotContains("inner join", $baseSQL);
96  $this->assertNotContains("(u.userflags & 35) <> 0", $baseSQL);
97 
98  $select = "withE";
99  $optin = 0;
100  $results = _ConstructSQL($Cu, $optin, $select, $emailFlag, $askBillPay);
101  $baseSQL = $results["data"]["baseSQL"];
102 
103  $this->assertNotContains("u.egenl_flag = 'Y'", $baseSQL);
104  $this->assertContains("and exists (select 'FOUND' from ANOTHERCUmemberacct ma", $baseSQL);
105 
106  $select = "withoutE";
107  $results = _ConstructSQL($Cu, $optin, $select, $emailFlag, $askBillPay);
108  $baseSQL = $results["data"]["baseSQL"];
109 
110  $this->assertContains("and not exists (select 'FOUND' from ANOTHERCUmemberacct ma", $baseSQL);
111 
112  // #3044: option is no longer available
113  // If necessary, we will need to use perms on profile
114  // --------------------
115  // $select = "withBP";
116  // $results = _ConstructSQL($Cu, $optin, $select, $emailFlag, $askBillPay);
117  // $baseSQL = $results["data"]["baseSQL"];
118 
119  // $this->assertContains("(u.userflags & 35) <> 0", $baseSQL);
120 
121  $select = "withText";
122  $results = _ConstructSQL($Cu, $optin, $select, $emailFlag, $askBillPay);
123  $baseSQL = $results["data"]["baseSQL"];
124 
125  $this->assertContains("exists (select 'FOUND' from cusms s", $baseSQL);
126  }

◆ test_ValidateTemplate()

SendEmailTest::test_ValidateTemplate ( )

function test_ValidateTemplate() Validates the function _ValidateTemplate().

Definition at line 26 of file SendEmailTest.php.

26  {
27  $testAddress = "";
28  $fromEmail = "";
29  $subject = "";
30  $select = "";
31  $templateName = "";
32  $selectArray = "";
33  $optin = "";
34 
35  $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
36  $this->assertEquals($results["error"], "From email is required.");
37 
38  $fromEmail = "invalid email";
39  $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
40  $this->assertEquals($results["error"], "From address is not valid.");
41 
42  $fromEmail = "valid@email.yeah";
43  $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
44  $this->assertEquals($results["error"], "Subject is required.");
45 
46  $subject = "adlskj";
47  $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
48  $this->assertEquals($results["error"], "Name is required.");
49 
50  $templateName = "alkdsjf";
51  $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
52  $this->assertEquals($results["error"], "Select array is not valid.");
53 
54  $select = "not in the list";
55  $selectArray = array("in list");
56  $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
57  $this->assertEquals($results["error"], "Select is invalid.");
58 
59  $select = "in list";
60  $testAddress = "invalid email";
61  $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
62  $this->assertEquals($results["error"], "Test address is not valid.");
63 
64  $testAddress = "valid@email.yeah";
65  $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
66  $this->assertEquals($results["error"], "Optin is not valid.");
67 
68  $optin = "Y";
69  $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
70  $this->assertEquals($results["status"], "000");
71  }

The documentation for this class was generated from the following file: