/** * * @param LeavePeriod $leavePeriod * @return unknown_type */ public function xgetLeavePeriodOverlapLeaves(LeavePeriod $leavePeriod) { try { $q = Doctrine_Query::create()->from('Leave l')->andWhere('l.leave_date > ?', $leavePeriod->getEndDate())->groupBy('l.leave_request_id'); $leaveList = $q->execute(); return $leaveList; } catch (Exception $e) { throw new DaoException($e->getMessage()); } }