/** * 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)); }