SendEmailTest.php

<?php

use PHPUnit\Framework\TestCase;

/**
 * @var SendEmailTest
 * Contains all the test cases for the aSendEmail.data file.
 */
class SendEmailTest extends TestCase {

    /**
     * function setUp()
     * Need to require all files here.
     */
    function setUp() {
       $sharedLibrary = "/var/www/html/shared/library";
       $admIncludes = "/var/www/html/admcom/includes";
       require_once("$sharedLibrary/hcuFunctions.i");
       require_once("$admIncludes/aSendEmail.data");
    }

    /**
     * function test_ValidateTemplate()
     * Validates the function _ValidateTemplate().
     */
    function test_ValidateTemplate() {
        $testAddress = "";
        $fromEmail = "";
        $subject = "";
        $select = "";
        $templateName = "";
        $selectArray = "";
        $optin = "";

        $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
        $this->assertEquals($results["error"], "From email is required.");

        $fromEmail = "invalid email";
        $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
        $this->assertEquals($results["error"], "From address is not valid.");

        $fromEmail = "valid@email.yeah";
        $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
        $this->assertEquals($results["error"], "Subject is required.");

        $subject = "adlskj";
        $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
        $this->assertEquals($results["error"], "Name is required.");

        $templateName = "alkdsjf";
        $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
        $this->assertEquals($results["error"], "Select array is not valid.");

        $select = "not in the list";
        $selectArray = array("in list");
        $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
        $this->assertEquals($results["error"], "Select is invalid.");

        $select = "in list";
        $testAddress = "invalid email";
        $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
        $this->assertEquals($results["error"], "Test address is not valid.");

        $testAddress = "valid@email.yeah";
        $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
        $this->assertEquals($results["error"], "Optin is not valid.");

        $optin = "Y";
        $results = _ValidateTemplate ($testAddress, $fromEmail, $subject, $select, $templateName, $selectArray, $optin);
        $this->assertEquals($results["status"], "000");
    }

    /**
     * function test_ConstructSQL()
     * Validates the function _ConstructSQL().
     */
    function test_ConstructSQL() {
        $Cu = "ANOTHERCU";
        $optin = 1;
        $select = "not in list";
        $emailFlag = 518; // Purposely wrong values
        $askBillPay = 35;

        $results = _ConstructSQL($Cu, $optin, $select, $emailFlag, $askBillPay);
        $this->assertEquals($results["error"], "Option is not valid.");

        $select = "all";
        $results = _ConstructSQL($Cu, $optin, $select, $emailFlag, $askBillPay);
        $this->assertEquals($results["status"], "000");
        $baseSQL = $results["data"]["baseSQL"];

        $this->assertContains("from ANOTHERCUuser u", $baseSQL);
        $this->assertContains("(coalesce(u.msg_tx, 0) & 518) = 0", $baseSQL);
        $this->assertContains("u.egenl_flag = 'Y'", $baseSQL);
        $this->assertNotContains("inner join", $baseSQL);
        $this->assertNotContains("(u.userflags & 35) <> 0", $baseSQL);

        $select = "withE";
        $optin = 0;
        $results = _ConstructSQL($Cu, $optin, $select, $emailFlag, $askBillPay);
        $baseSQL = $results["data"]["baseSQL"];

        $this->assertNotContains("u.egenl_flag = 'Y'", $baseSQL);
        $this->assertContains("and exists (select 'FOUND' from ANOTHERCUmemberacct ma", $baseSQL);

        $select = "withoutE";
        $results = _ConstructSQL($Cu, $optin, $select, $emailFlag, $askBillPay);
        $baseSQL = $results["data"]["baseSQL"];

        $this->assertContains("and not exists (select 'FOUND' from ANOTHERCUmemberacct ma", $baseSQL);

        // #3044: option is no longer available
        // If necessary, we will need to use perms on profile
        // --------------------
        // $select = "withBP";
        // $results = _ConstructSQL($Cu, $optin, $select, $emailFlag, $askBillPay);
        // $baseSQL = $results["data"]["baseSQL"];

        // $this->assertContains("(u.userflags & 35) <> 0", $baseSQL);

        $select = "withText";
        $results = _ConstructSQL($Cu, $optin, $select, $emailFlag, $askBillPay);
        $baseSQL = $results["data"]["baseSQL"];

        $this->assertContains("exists (select 'FOUND' from cusms s", $baseSQL);
    }

}