/** * Used to retrieve a set of employees assigned to a contract. * * @param id The contract id for which assigned employees are to be * retrieved. * * @param day The day for which contract assignments must be valid. * * @return Returns the requested contract employees. */ public function getContractEmployees($id, $day = null) { // Make sure the id is valid. if (!isset($id) || !is_numeric($id)) { return array(); } // Get the database adapter. $db = $this->getAdapter(); // Set the fetch mode. $db->setFetchMode(Zend_Db::FETCH_OBJ); // Get the select object. $select = $db->select(); // Get the DAO for the table we will be joining with. $assignmentDao = new ContractAssignmentDao(); // Build the query. $select->from(array('a' => $assignmentDao->_name))->join(array('e' => $this->_name), 'a.employee_id = e.id', array('login', 'email', 'first_name', 'last_name', 'suffix', 'division', 'personnel_type', 'active'))->where('a.contract_id = ?', $id)->where('e.active = true'); // Make sure the pay period is not null before adding the // clause to prevent expired contracts from being retrieved. if (isset($day)) { $select->where('start IS NULL OR start <= ?', $day); $select->where('end IS NULL OR end >= ?', $day); } // Add ordering. $this->setDefaultOrder($select); // Retrieve all the objects. $objs = $db->query($select)->fetchAll(); // Perform post-processing on all the objects. if (isset($objs) && count($objs) > 0) { // Iterate over the identified employees. foreach ($objs as $obj) { // Make sure the employee id value is valid. if (is_numeric($obj->id)) { // Set the employee's roles. $roleDao = new RoleDao(); $obj->roles = $roleDao->getForEmployee($obj->id); // Set the employee's supervisors. $obj->supervisors = $this->getSupervisorEmployees($obj->id); // Set the employees this employee is supervising. $obj->supervised = $this->getSupervisedEmployees($obj->id); } // Perform the post-processing. $this->postProcess($obj); } } // Return the objects. return $objs; }