/lib/models/leave/LeaveSummaryTest.php

<?php

/**

 * OrangeHRM is a comprehensive Human Resource Management (HRM) System that captures

 * all the essential functionalities required for any enterprise.

 * Copyright (C) 2006 OrangeHRM Inc., http://www.orangehrm.com

 *

 * OrangeHRM is free software; you can redistribute it and/or modify it under the terms of

 * the GNU General Public License as published by the Free Software Foundation; either

 * version 2 of the License, or (at your option) any later version.

 *

 * OrangeHRM is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;

 * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

 * See the GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License along with this program;

 * if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,

 * Boston, MA  02110-1301, USA

 *

 */





// Call LeaveSummaryTest::main() if this source file is executed directly.

if (!defined("PHPUnit_MAIN_METHOD")) {

    define("PHPUnit_MAIN_METHOD", "LeaveSummaryTest::main");

}



require_once "PHPUnit/Framework/TestCase.php";

require_once "PHPUnit/Framework/TestSuite.php";



require_once "testConf.php";



$_SESSION['WPATH'] = WPATH;



require_once "LeaveSummary.php";

require_once ROOT_PATH."/lib/confs/Conf.php";



/**

 * Test class for LeaveSummary.

 * Generated by PHPUnit_Util_Skeleton on 2006-10-19 at 13:16:38.

 */

class LeaveSummaryTest extends PHPUnit_Framework_TestCase {

    /**

     * Runs the test methods of this class.

     *

     * @access public

     * @static

     */



    private $leaveSummary = null;

    private $connection	= null;



    public static function main() {

        require_once "PHPUnit/TextUI/TestRunner.php";



        $suite  = new PHPUnit_Framework_TestSuite("LeaveSummaryTest");

        $result = PHPUnit_TextUI_TestRunner::run($suite);

    }



    /**

     * Sets up the fixture, for example, open a network connection.

     * This method is called before a test is executed.

     *

     * @access protected

     */

    protected function setUp() {



    	$this->leaveSummary = new LeaveSummary();



    	$conf = new Conf();



    	$this->connection = mysql_connect($conf->dbhost.":".$conf->dbport, $conf->dbuser, $conf->dbpass);



        mysql_select_db($conf->dbname);



    	$this->_deleteTestData();

		$this->_runQuery("INSERT INTO `hs_hr_employee`(emp_number, emp_lastname, emp_firstname, emp_nick_name, coun_code) " .

				"VALUES ('011', 'Arnold', 'Subasinghe', 'Arnold', 'AF')");

		$this->_runQuery("INSERT INTO `hs_hr_employee`(emp_number, emp_lastname, emp_firstname, emp_middle_name, emp_nick_name) " .

				"VALUES ('012', 'Mohanjith', 'Sudirikku', 'Hannadige', 'MOHA')");

		$this->_runQuery("INSERT INTO `hs_hr_employee`(emp_number, emp_lastname, emp_firstname, emp_middle_name, emp_nick_name) " .

				"VALUES ('013', 'Rasmus', 'Vido', 'Q', 'Ras')");



		mysql_query("INSERT INTO `hs_hr_leavetype` VALUES ('LTY010', 'Medical', 1)");

		mysql_query("INSERT INTO `hs_hr_leavetype` VALUES ('LTY011', 'Casual', 1)");

		mysql_query("INSERT INTO `hs_hr_leavetype` VALUES ('LTY012', 'Annual', 0)");



		mysql_query("INSERT INTO `hs_hr_employee_leave_quota` (year, leave_type_id, employee_id, no_of_days_allotted, leave_taken) VALUES ('".date('Y')."', 'LTY010', '012', 10, 5);");

		mysql_query("INSERT INTO `hs_hr_employee_leave_quota` (year, leave_type_id, employee_id, no_of_days_allotted, leave_taken) VALUES ('".date('Y')."', 'LTY011', '012', 20, 30);");



		mysql_query("INSERT INTO `hs_hr_employee_leave_quota` (year, leave_type_id, employee_id, no_of_days_allotted) VALUES ('".date('Y')."', 'LTY012', '013', 30);");



		mysql_query("INSERT INTO `hs_hr_employee_leave_quota` (year, leave_type_id, employee_id, no_of_days_allotted) VALUES ('".date('Y')."', 'LTY010', '011', 10);");

		mysql_query("INSERT INTO `hs_hr_employee_leave_quota` (year, leave_type_id, employee_id, no_of_days_allotted) VALUES ('".date('Y')."', 'LTY011', '011', 20);");



		mysql_query("INSERT INTO `hs_hr_leave_requests` (`leave_request_id`, `leave_type_id`, `leave_type_name`, `date_applied`, `employee_id`) VALUES (10, 'LTY010', 'Medical', '".date('Y-m-d', time()+3600*24)."', '011')");

		mysql_query("INSERT INTO `hs_hr_leave_requests` (`leave_request_id`, `leave_type_id`, `leave_type_name`, `date_applied`, `employee_id`) VALUES (11, 'LTY012', 'Medical', '".date('Y-m-d', time()+3600*24)."', '013')");



		mysql_query("INSERT INTO `hs_hr_leave` (`leave_id`, `employee_id`, `leave_type_id`, `leave_date`, `leave_length_hours`, `leave_length_days`, `leave_status`, `leave_comments`, `leave_request_id`) VALUES (10, '011', 'LTY010', '".date('Y-m-d', time()+3600*24)."', 8, 1, 3, 'Leave 1', 10)");

		mysql_query("INSERT INTO `hs_hr_leave` (`leave_id`, `employee_id`, `leave_type_id`, `leave_date`, `leave_length_hours`, `leave_length_days`, `leave_status`, `leave_comments`, `leave_request_id`) VALUES (11, '011', 'LTY010', '".date('Y-m-d', time()+3600*24)."', 8, 1, 3, 'Leave 2', 10)");

		mysql_query("INSERT INTO `hs_hr_leave` (`leave_id`, `employee_id`, `leave_type_id`, `leave_date`, `leave_length_hours`, `leave_length_days`, `leave_status`, `leave_comments`, `leave_request_id`) VALUES (12, '013', 'LTY012', '".date('Y-m-d', time()+3600*24)."', 8, 1, 3, 'Leave 3', 11)");



    }



    /**

     * Tears down the fixture, for example, close a network connection.

     * This method is called after a test is executed.

     *

     * @access protected

     */

    protected function tearDown() {

    	$this->_deleteTestData();

    }



	/**

	 * Deletes test data created during test

	 */

	private function _deleteTestData() {

    	mysql_query("DELETE FROM `hs_hr_employee` WHERE `emp_number` = '011'", $this->connection);

    	mysql_query("DELETE FROM `hs_hr_employee` WHERE `emp_number` = '012'", $this->connection);

    	mysql_query("DELETE FROM `hs_hr_employee` WHERE `emp_number` = '013'", $this->connection);



    	mysql_query("DELETE FROM `hs_hr_employee_leave_quota` WHERE `Employee_ID` = '012'", $this->connection);

    	mysql_query("DELETE FROM `hs_hr_employee_leave_quota` WHERE `Employee_ID` = '013'", $this->connection);

    	mysql_query("DELETE FROM `hs_hr_employee_leave_quota` WHERE `Employee_ID` = '011'", $this->connection);



    	mysql_query("TRUNCATE TABLE `hs_hr_leave`", $this->connection);

    	mysql_query("TRUNCATE TABLE `hs_hr_leave_requests`", $this->connection);



    	mysql_query("DELETE FROM `hs_hr_leavetype` WHERE `Leave_Type_ID` = 'LTY010'", $this->connection);

    	mysql_query("DELETE FROM `hs_hr_leavetype` WHERE `Leave_Type_ID` = 'LTY011'", $this->connection);

    	mysql_query("DELETE FROM `hs_hr_leavetype` WHERE `Leave_Type_ID` = 'LTY012'", $this->connection);

	}



	/**

	 * Run given sql query

	 */

	private function _runQuery($sql) {

	    $this->assertTrue(mysql_query($sql), mysql_error());

	}



    public function testFetchAllEmployeeLeaveSummaryAccuracy() {



        $res = $this->leaveSummary->fetchAllEmployeeLeaveSummary("012", date('Y', time()+3600*24));



        $this->assertNotNull($res, "No records returned");

        $this->assertEquals(count($res), 2, "Returned invalid numner of records");



        $expected[] = array("Medical", 10, 5, 5);

        $expected[] = array("Casual", 20, 30, -10);



        for ($i=0; $i < count($res); $i++) {

        	$this->assertEquals($res[$i]['leave_type_name'], $expected[$i][0], "Didn't return expected leave_type_name ");

        	$this->assertEquals($res[$i]['no_of_days_allotted'], $expected[$i][1], "Didn't return expected no_of_days_allotted ");

        	$this->assertEquals($res[$i]['leave_taken'], $expected[$i][2], "Didn't return expected leave_taken ");

        	$this->assertEquals($res[$i]['leave_available'], $expected[$i][3], "Didn't return expected leave_available ");

        }



    }

}



// Call LeaveSummaryTest::main() if this source file is executed directly.

if (PHPUnit_MAIN_METHOD == "LeaveSummaryTest::main") {

    LeaveSummaryTest::main();

}

?>