/**
* Test method for getEmployeesWithoutWorkshift
*/
public function testGetEmployeesWithoutWorkshift()
{
$employees = Workshift::getEmployeesWithoutWorkshift();
$expected[1] = array(1, '0011', 'Rajasinghe', 'Saman', 'Marlon');
$expected[2] = array(2, '0022', 'Jayasinghe', 'Aruna', 'Shantha');
$expected[3] = array(3, '0034', 'Ranasinghe', 'Nimal', 'Bandara');
$this->assertEquals(3, count($employees));
$this->_checkEmployeeList($employees, $expected);
$this->assertTrue(mysql_query("INSERT INTO " . Workshift::WORKSHIFT_TABLE . " VALUES ('1' , 'New Test Shift', '5')"));
$this->assertTrue(mysql_query("INSERT INTO " . Workshift::WORKSHIFT_TABLE . " VALUES ('2' , 'Workshift 2', '10')"));
$employees = Workshift::getEmployeesWithoutWorkshift();
$this->assertEquals(3, count($employees));
$this->_checkEmployeeList($employees, $expected);
$this->assertTrue(mysql_query("INSERT INTO hs_hr_employee_workshift(workshift_id, emp_number) VALUES (1, 1)"));
$employees = Workshift::getEmployeesWithoutWorkshift();
$this->assertEquals(2, count($employees));
unset($expected[1]);
$this->_checkEmployeeList($employees, $expected);
$this->assertTrue(mysql_query("INSERT INTO hs_hr_employee_workshift(workshift_id, emp_number) VALUES (2, 2)"));
$employees = Workshift::getEmployeesWithoutWorkshift();
$this->assertEquals(1, count($employees));
unset($expected[2]);
$this->_checkEmployeeList($employees, $expected);
$this->assertTrue(mysql_query("INSERT INTO hs_hr_employee_workshift(workshift_id, emp_number) VALUES (2, 3)"));
$employees = Workshift::getEmployeesWithoutWorkshift();
$this->assertEquals(0, count($employees));
}
