/** * @return array */ public function getAllEmployees() { $response = new StandardResponse(); $queryString = "SELECT user.id, user.name, user.role, user.email, user.phone, user.created_at, user.updated_at " . "FROM \\App\\Entity\\User user WHERE user.role = 'employee'"; $query = $this->em->createQuery($queryString); $results = $query->getArrayResult(); if ($results) { $response->setSuccess(true); $response->setMessage('Here are the employees.'); $response->setData($results); } return $response->getObjectVars(); }
/** * @param int $id * @return null|object * @throws \Doctrine\ORM\ORMException * @throws \Doctrine\ORM\OptimisticLockException * @throws \Doctrine\ORM\TransactionRequiredException */ public function get($id) { $response = new StandardResponse(); $queryString = 'SELECT shift.id, shift.manager_id, shift.employee_id, shift.break, ' . 'shift.start_time, shift.end_time, shift.created_at, shift.updated_at FROM \\App\\Entity\\Shift shift ' . 'WHERE shift.id = :id'; $shift = $this->em->createQuery($queryString)->setParameter('id', (int) $id)->getArrayResult(); if ($shift) { if (isset($shift[0])) { $shift[0]['start_time'] = $shift[0]['start_time']->getTimestamp(); $shift[0]['end_time'] = $shift[0]['end_time']->getTimestamp(); } $response->setSuccess(true); $response->setMessage('Here is the shift.'); $response->setData(isset($shift[0]) ? $shift[0] : []); } return $response->getObjectVars(); }
/** * @param int $id * @return StandardResponse */ public function getUser($id) { $response = new StandardResponse(); $response->setMessage('User not found'); $queryString = 'SELECT user FROM \\App\\Entity\\User user WHERE user.id = :id'; $user = $this->em->createQuery($queryString)->setParameter('id', (int) $id)->getArrayResult(); if (isset($user[0])) { $response->setSuccess(true); $response->setMessage('Here is the user.'); $response->setData($user[0]); } return $response->getObjectVars(); }