LeaveTest.php | searchcode

/lib/models/leave/LeaveTest.php

https://bitbucket.org/wildanm/orangehrm
PHP | 551 lines | 419 code | 73 blank | 59 comment | 5 complexity | 417d0c1b26bc9531c340a57d717fe29c MD5 | raw file
Possible License(s): CC-BY-SA-3.0, AGPL-3.0, BSD-3-Clause, AGPL-1.0, GPL-2.0, LGPL-2.1, LGPL-3.0

<?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 LeaveTest::main() if this source file is executed directly.

if (!defined("PHPUnit_MAIN_METHOD")) {

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

}



require_once "PHPUnit/Framework/TestCase.php";

require_once "PHPUnit/Framework/TestSuite.php";



require_once "testConf.php";



$_SESSION['WPATH'] = WPATH;



require_once "Leave.php";

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



/**

 * Test class for Leave.

 * Generated by PHPUnit_Util_Skeleton on 2006-10-12 at 08:36:24.

 */

class LeaveTest extends PHPUnit_Framework_TestCase {



	public $classLeave = null;

    public $connection = null;

	/**

     * Runs the test methods of this class.

     *

     * @access public

     * @static

     */

    public static function main() {

        require_once "PHPUnit/TextUI/TestRunner.php";



        $suite  = new PHPUnit_Framework_TestSuite("LeaveTest");

        $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->classLeave = new Leave();



    	$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, employee_id, emp_lastname, emp_firstname, emp_nick_name, coun_code) " .

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

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

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

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

				"VALUES (13, '013', 'Mohanjithx', 'Sudirikkux', 'Hannadigex', 'MOHAx')");

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

				"VALUES (14, '014', 'Mohanjith1', 'Sudirikku1', 'Hannadige1', 'MOHA1')");

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

				"VALUES (15, '015', 'Mohanjith1', 'Sudirikku1', 'Hannadige1', 'MOHA1')");



		// For testStoreLeaveTaken

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

				"VALUES (18, NULL, 'Gayanath', 'Wageeshwara', 'Jayarathne', 'GAYA')");

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

				"VALUES (19, 'A19', 'Gamalath', 'Kamalra', 'JKD', 'ABC')");



		mysql_query("INSERT INTO `hs_hr_emp_reportto` VALUES ('012', '011', 1);");



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

		// For testStoreLeaveTaken

		mysql_query("INSERT INTO `hs_hr_leavetype` VALUES ('LTY012', 'Personal', 1)");





		mysql_query("INSERT INTO `hs_hr_workshift` (`workshift_id`, `name`, `hours_per_day`) VALUES (10, 'Test', 6);");

		mysql_query("INSERT INTO `hs_hr_employee_workshift` (`workshift_id`, `emp_number`) VALUES (10, 15)");



		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)."', '012')");

		mysql_query("INSERT INTO `hs_hr_leave_requests` (`leave_request_id`, `leave_type_id`, `leave_type_name`, `date_applied`, `employee_id`) VALUES (11, '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 (12, 'LTY010', 'Medical', '".date('Y-m-d', time()+3600*24)."', '013')");

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

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

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

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

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



		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)."', 1, 0.12, 1, 'Leave 1', 11)");

		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*2)."', 1, 0.12, 1, 'Leave 2', 11)");



		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', 'LTY010', '".date('Y-m-d', time()+3600*24)."', 8, 1, 3, 'Leave 4', 12)");

		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 (13, '013', 'LTY010', '".date('Y-m-d', time()+3600*24*2)."', 8, 1, 3, 'Leave 5', 12)");



		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`, `start_time`, `end_time`) VALUES (15, '014', 'LTY010', '".date('Y-m-d', time())."', 8, 1, 2, 'Leave 6', 13, '10:00', '18:00')");



		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`, `start_time`, `end_time`) VALUES (16, '013', 'LTY010', '".date('Y-m-d', time())."', 8, 1, 3, 'Leave 7', 14, '10:00', '18:00')");



		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`, `start_time`, `end_time`) VALUES (17, '015', 'LTY010', '".date('Y-m-d', time()+3600*24*2)."', 1, 0.17, 1, 'Leave 2', 15, '10:00', '11:00')");



		$this->assertTrue(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`, `start_time`, `end_time`) VALUES (18, '019', 'LTY010', '".date('Y-m-d', time()+3600*24*3)."', 1, 0.17, 0, 'Leave 2', 16, '10:00', '11:00')"), mysql_error());



		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`, `start_time`, `end_time`) VALUES (19, '019', 'LTY010', '".date('Y-m-d', time()+3600*24*4)."', 1, 0.17, -1, 'Leave 2', 17, '10:00', '11:00')");



        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 (20, '016', 'LTY010', '".date('Y-m-d', time()+3600*24)."', 8, 1, 4, 'Leave 6', 12)");



		// For testStoreLeaveTaken

		mysql_query("INSERT INTO `hs_hr_employee_leave_quota` (year, leave_type_id, employee_id, no_of_days_allotted) VALUES ('2007', 'LTY012', '018', '10')");



    }



	/**

	 * Test the retrieveDuplicateLeave method

	 */

	public function testRetrieveDuplicateLeave() {

		$leaveObj = $this->classLeave;



		// unknown employee id -> return empty array

		$result = $leaveObj->retrieveDuplicateLeave(16, date('Y-m-d', time()), date('Y-m-d', time()+3600*24*4));

		$this->assertNull($result);



		// no duplicate leave -> return empty array

		$result = $leaveObj->retrieveDuplicateLeave(15, date('Y-m-d', time()), date('Y-m-d', time()+3600*24*1));

		$this->assertNull($result);



		// Only cancelled duplicate leave -> return empty array

		$result = $leaveObj->retrieveDuplicateLeave(19, date('Y-m-d', time()), date('Y-m-d', time()+3600*24*3));

		$this->assertNull($result);



		// Return rejected duplicate leave

		$result = $leaveObj->retrieveDuplicateLeave(19, date('Y-m-d', time()), date('Y-m-d', time()+3600*24*4));

		$this->assertTrue(is_array($result));

		$this->assertEquals(1, count($result));

		$this->assertEquals($result[0]->getLeaveId(), 19);



		// Return duplicate leave

		$result = $leaveObj->retrieveDuplicateLeave(13, date('Y-m-d', time()), date('Y-m-d', time()+3600*24*4));

		$this->assertTrue(is_array($result));

		$this->assertEquals(3, count($result));



		$expected = array(12, 13, 16);



		foreach ($result as $leave) {

			$key = array_search($leave->getLeaveId(), $expected);

			$this->assertTrue($key !== false);

			unset($expected[$key]);

		}



		$this->assertEquals(count($expected), 0);

	}



    /**

     * 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_emp_reportto` WHERE `erep_sup_emp_number` = '012' AND `erep_sub_emp_number` = '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_employee_workshift` WHERE `workshift_id` = '10'");

    	mysql_query("DELETE FROM `hs_hr_workshift` WHERE `workshift_id` = '10'");



    	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` WHERE `emp_number` = '014'", $this->connection);

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

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

		// For testStoreLeaveTaken

		mysql_query("DELETE FROM `hs_hr_employee_leave_quota` WHERE employee_id = '018'");

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

	}



	/**

	 * Run given sql query

	 */

	private function _runQuery($sql) {

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

    }



    public function testRetrieveTakenLeaveAccuracy1() {

    	$leveObj = $this->classLeave;



    	$res = $leveObj->retrieveTakenLeave(date('Y', time()+3600*24*367), '013');



    	$this->assertEquals($res, false, "Returned future record");

    }



    public function testRetrieveTakenLeaveAccuracy2() {

    	$leveObj = $this->classLeave;



    	$res = $leveObj->retrieveTakenLeave(date('Y', time()+3600*24), '010');



    	$this->assertEquals($res, false, "Returned non exsiting record");

    }



    public function testRetrieveTakenLeaveAccuracy3() {

    	$leveObj = $this->classLeave;



    	$res = $leveObj->retrieveTakenLeave(date('Y', time()+3600*24), '013');



    	$expected[0] = array(date('Y-m-d', time()+3600*24), 'Medical', 3, 8, 'Leave 4', null, null);

        $expected[1] = array(date('Y-m-d', time()+3600*24*2), 'Medical', 3, 8, 'Leave 5', null, null);

        $expected[2] = array(date('Y-m-d', time()), 'Medical', 3, 8, 'Leave 7', '10:00', '18:00');



        $this->assertNotNull($res, "Returned nothing");



        $this->assertEquals(count($res), count($expected), "Didn't return the expected number of records");



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

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

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

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

        	$this->assertEquals($res[$i]->getLeaveComments(), $expected[$i][4], "Didn't return expected result");

        	$this->assertEquals($res[$i]->getStartTime(), $expected[$i][5], "Didn't return expected result");

        	$this->assertEquals($res[$i]->getEndTime(), $expected[$i][6], "Didn't return expected result");

        }

    }



    public function testRetrieveIndividualLeaveAccuracy1() {

    	$leveObj = $this->classLeave;



    	$res = $leveObj->retrieveIndividualLeave('12');



    	$expected[0] = array(date('Y-m-d', time()+3600*24), 'Medical', 3, 8, 'Leave 4', null, null);



        $this->assertNotNull($res, "Returned nothing");



        $this->assertEquals(count($res), count($expected), "Didn't return the expected number of records");



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

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

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

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

        	$this->assertEquals($res[$i]->getLeaveComments(), $expected[$i][4], "Didn't return expected result");

        	$this->assertEquals($res[$i]->getStartTime(), $expected[$i][5], "Didn't return expected result");

        	$this->assertEquals($res[$i]->getEndTime(), $expected[$i][6], "Didn't return expected result");

        }

    }



    public function testRetrieveIndividualLeaveAccuracy2() {

        $leveObj = $this->classLeave;



        $res = $leveObj->retrieveIndividualLeave('20');



        $expected[0] = array(date('Y-m-d', time()+3600*24), 'Medical', 4, 8, 'Leave 6');



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

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

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

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

            $this->assertEquals($expected[$i][4], $res[$i]->getLeaveComments(), "Didn't return expected result");

        }

    }



    public function testRetriveLeaveEmployeeAccuracy() {

        $res = $this->classLeave->retrieveLeaveEmployee("011");



        $expected[0] = array(date('Y-m-d', time()+3600*24), 'Medical', 1, 1, 'Leave 1');

        $expected[1] = array(date('Y-m-d', time()+3600*24*2), 'Medical', 1, 1, 'Leave 2');



        $this->assertNotNull($res, "No record found ");



        $this->assertEquals(count($res), 2, "Number of records found is not accurate ");



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

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

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

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

        	$this->assertEquals($res[$i]->getLeaveComments(), $expected[$i][4], "Didn't return expected result ");

        }

    }



    public function testRetriveLeaveEmployeeAccuracy2() {

        $res = $this->classLeave->retrieveLeaveEmployee("015");



        $expected[0] = array(date('Y-m-d', time()+3600*24*2), 'Medical', 1, 1, 0.17, 'Leave 2', '10:00', '11:00');



        $this->assertNotNull($res, "No record found ");



        $this->assertEquals(count($res), count($expected), "Number of records found is not accurate ");



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

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

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

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

        	$this->assertEquals($res[$i]->getLeaveLengthDays(), $expected[$i][4], "Didn't return expected result ");

        	$this->assertEquals($res[$i]->getLeaveComments(), $expected[$i][5], "Didn't return expected result ");

        	$this->assertEquals($res[$i]->getStartTime(), $expected[$i][6], "Didn't return expected result ");

        	$this->assertEquals($res[$i]->getEndTime(), $expected[$i][7], "Didn't return expected result ");

        }

    }



    public function testApplyLeave() {



    	$this->classLeave->setLeaveRequestId("010");

    	$this->classLeave->setEmployeeId("012");

    	$this->classLeave->setLeaveTypeId("LTY010");

    	$this->classLeave->setLeaveDate(date('Y-m-d', time()+3600*24));

    	$this->classLeave->setLeaveLengthHours("2");

    	$this->classLeave->setLeaveLengthDays("0.25");

    	$this->classLeave->setLeaveStatus("1");

    	$this->classLeave->setLeaveComments("Leave 1");



    	$res = $this->classLeave->applyLeave();



    	$res = $this->classLeave->retrieveLeaveEmployee("012");



    	$this->assertNotNull($res, "No record found");



    	$this->assertEquals(count($res), 1, "Wrong number of records found");



        $expected[0] = array(date('Y-m-d', time()+3600*24), 'Medical', 1, 2, 0.25, 'Leave 1');



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

        	$this->assertEquals($res[$i]->getLeaveDate(), $expected[$i][0], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveStatus(), $expected[$i][2], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveLengthHours(), $expected[$i][3], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveLengthDays(), $expected[$i][4], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveComments(), $expected[$i][5], "Checking added / applied leave ");

        }



        $this->classLeave->setLeaveComments("Leave 2");

        $res = $this->classLeave->applyLeave();



        $res = $this->classLeave->retrieveLeaveEmployee("012");

        $expected[1] = array(date('Y-m-d', time()+3600*24), 'Medical', 1, 2, 0.25, 'Leave 2');



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

        	$this->assertEquals($res[$i]->getLeaveDate(), $expected[$i][0], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveStatus(), $expected[$i][2], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveLengthHours(), $expected[$i][3], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveLengthDays(), $expected[$i][4], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveComments(), $expected[$i][5], "Checking added / applied leave ");

        }

    }



    public function testApplyLeave2() {



    	$this->classLeave->setLeaveRequestId("010");

    	$this->classLeave->setEmployeeId("012");

    	$this->classLeave->setLeaveTypeId("LTY010");

    	$this->classLeave->setLeaveDate(date('Y-m-d', time()+3600*24));

    	$this->classLeave->setLeaveLengthHours("2");

    	$this->classLeave->setLeaveLengthDays("0.25");

    	$this->classLeave->setLeaveStatus("1");

    	$this->classLeave->setLeaveComments("Leave 1");

    	$this->classLeave->setStartTime("08:00");

    	$this->classLeave->setEndTime("10:00");



    	$res = $this->classLeave->applyLeave();



    	$res = $this->classLeave->retrieveLeaveEmployee("012");



    	$this->assertNotNull($res, "No record found");



    	$this->assertEquals(count($res), 1, "Wrong number of records found");



        $expected[0] = array(date('Y-m-d', time()+3600*24), 'Medical', 1, 2, 0.25, 'Leave 1', "08:00", "10:00");



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

        	$this->assertEquals($res[$i]->getLeaveDate(), $expected[$i][0], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveStatus(), $expected[$i][2], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveLengthHours(), $expected[$i][3], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveLengthDays(), $expected[$i][4], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveComments(), $expected[$i][5], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getStartTime(), $expected[$i][6], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getEndTime(), $expected[$i][7], "Checking added / applied leave ");

        }

    }



    public function testApplyLeave3() {



    	$this->classLeave->setLeaveRequestId("15");

    	$this->classLeave->setEmployeeId("15");

    	$this->classLeave->setLeaveTypeId("LTY010");

    	$this->classLeave->setLeaveDate(date('Y-m-d', time()+3600*24));

    	$this->classLeave->setLeaveLengthHours("3");

    	$this->classLeave->setLeaveStatus("1");

    	$this->classLeave->setLeaveComments("Leave 1");

    	$this->classLeave->setStartTime("08:00");

    	$this->classLeave->setEndTime("10:00");



    	$res = $this->classLeave->applyLeave();



    	$res = $this->classLeave->retrieveLeaveEmployee("015");



    	$this->assertNotNull($res, "No record found");



    	$expected[0] = array(date('Y-m-d', time()+3600*24), 'Medical', 1, 3, 0.5, 'Leave 1', "08:00", "10:00");

		$expected[1] = array(date('Y-m-d', time()+3600*24*2), 'Medical', 1, 1, 0.17, 'Leave 2', '10:00', '11:00');



    	$this->assertEquals(count($res), count($expected), "Wrong number of records found");



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

        	$this->assertEquals($res[$i]->getLeaveDate(), $expected[$i][0], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveStatus(), $expected[$i][2], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveLengthHours(), $expected[$i][3], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveLengthDays(), $expected[$i][4], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getLeaveComments(), $expected[$i][5], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getStartTime(), $expected[$i][6], "Checking added / applied leave ");

        	$this->assertEquals($res[$i]->getEndTime(), $expected[$i][7], "Checking added / applied leave ");

        }

    }



    public function testCancelLeaveAccuracy() {



        $this->classLeave->setLeaveStatus(Leave::LEAVE_STATUS_LEAVE_CANCELLED);

        $res = $this->classLeave->cancelLeave(10);

        $expected = true;



        $this->assertEquals($res, $expected, "Cancel of leave failed ");



        $res = $this->classLeave->cancelLeave(10);

        $expected = false;



        $this->assertEquals($res, $expected, "Cancelled already cancelled leave ");



        $res = $this->classLeave->retrieveLeaveEmployee("011");

        $expected[0] = array(date('Y-m-d', time()+3600*24), 'Medical', 0, 1, '');

        $expected[1] = array(date('Y-m-d', time()+3600*24*1), 'Medical', 0, 1, '');



        $this->assertNotNull($res, "No record found ");



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

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

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

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

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

        }

    }



    public function testCountLeave() {

    	$this->classLeave->setEmployeeId("013");

    	$res = $this->classLeave->countLeave( "LTY010", date('Y', time()+3600*24));



    	$this->assertEquals($res, 3, "Retruned wrong count");

    }



    public function testGetLeaveYears() {



    	$res = $this->classLeave->getLeaveYears();



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



    	$this->assertEquals(count($res), 2, "Retruned wrong number of records");



    	$expected = array(date('Y')+1, date('Y'));



    	$this->assertEquals($res, $expected, "Retruned wrong count");

    }



    public function testTakeLeaveAccuracy() {



    	$res = $this->classLeave->retrieveLeaveEmployee("014");

        $this->assertNotNull($res, "Exsistent record not found ");



        $expected[0] = array(date('Y-m-d', time()), 'Medical', 2, 8, 'Leave 6');



        $this->assertNotNull($res, "No record found ");



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

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

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

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

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

        }



    	$res = $this->classLeave->takeLeave();

    	$this->assertNotNull($res, "Unexpected behavior ");



        $res = $this->classLeave->retrieveLeaveEmployee("014");

        $this->assertNotNull($res, "Exsistent record not found2 ");



        $expected[0] = array(date('Y-m-d', time()), 'Medical', 3, 8, 'Leave 6');



        $this->assertNotNull($res, "No record found ");



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

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

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

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

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

        }



        $res = $this->classLeave->takeLeave();

    	$this->assertEquals($res, false, "Unexpected behavior ");

    }



    public function testStoreLeaveTaken() {



    	$checkStoreTaken = new Leave();



		$checkStoreTaken->setLeaveLengthDays(10);

		$checkStoreTaken->setLeaveDate("2007-10-12");

		$checkStoreTaken->setLeaveTypeId("LTY012");

		$checkStoreTaken->setEmployeeId(18);



		$this->assertTrue($checkStoreTaken->storeLeaveTaken());



    }

    

    public function testIsLeaveTableEmpty() {

    	

    	$result = Leave::isLeaveTableEmpty();

    	

    	$this->assertFalse($result);

    }



}



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

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

    LeaveTest::main();

}

?>