/**
* Reads one employee record from database.
*
* @param Doctrine\DBAL\Connection $_db An Doctrine DBAL Connection instance
* @param integer $_id The ID of the employee resource
* @return array The result from a database query
*
* @todo Check parameters from REQUEST
* @todo Error handling
*/
protected function _readOne($_id, $_db)
{
$employee = $_db->createQueryBuilder()->select('e.*', 'd.name as "department"')->from('company_employees', 'e')->leftJoin('e', 'company_departments', 'd', 'e.department_id = d.id')->andWhere('e.id = :id')->setParameters(array('id' => $_id))->execute();
return array('success' => true, 'data' => $employee->fetchAll(\PDO::FETCH_ASSOC));
}
