public function indexAction(Request $request) { /****Check language session*******/ $session = $request->getSession(); $user = $session->get('user'); if (!empty($user)) { $lan = $session->get('language'); $request->setLocale($lan); $type = $request->request->get('type'); $em = $this->container->get('doctrine')->getManager(); $typeid = 0; if ($type == 'Destination') { $destination = $em->createQuery("SELECT d FROM MytripAdminBundle:Destination d WHERE d.status='Active' AND d.url='" . $request->request->get('destination') . "'")->getArrayResult(); $typeid = $destination[0]['destinationId']; } elseif ($type == 'Hostal') { $destination = $em->createQuery("SELECT d FROM MytripAdminBundle:Destination d WHERE d.status='Active' AND d.url='" . $request->request->get('destination') . "'")->getArrayResult(); $hostal = $em->createQuery("SELECT d FROM MytripAdminBundle:Hostal d WHERE d.status='Active' AND d.destination='" . $destination[0]['destinationId'] . "' AND d.url='" . $request->request->get('hostal') . "'")->getArrayResult(); $typeid = $hostal[0]['hostalId']; } if ($typeid > 0) { $reviews = new \Mytrip\AdminBundle\Entity\Review(); $reviews->setUser($this->getDoctrine()->getRepository('MytripAdminBundle:User')->find($user['userId'])); $reviews->setTypeId($typeid); $reviews->setReviewType($request->request->get('type')); $reviews->setRating($request->request->get('rate')); $reviews->setReview($request->request->get('review')); $reviews->setLan($lan); $reviews->setStatus('Active'); $reviews->setCreatedDate(new \DateTime()); $em->persist($reviews); $em->flush(); $check = array('suc' => '1', 'msg' => $this->get('translator')->trans('Thanks for your interest on us')); } else { $check = array('suc' => '0', 'msg' => $this->get('translator')->trans('Sorry, Please try again')); } } else { $session->set('destination', $request->request->get('destination')); $session->set('hostal', $request->request->get('hostal')); $session->set('type', $request->request->get('type')); $session->set('rate', $request->request->get('rate')); $session->set('review', $request->request->get('review')); $session->set('created_date', new \DateTime()); $this->get('session')->getFlashBag()->add('loginerror', $this->get('translator')->trans('Please Login')); $check = array('suc' => '2', 'msg' => $this->get('translator')->trans('Please Login')); } return new Response(json_encode($check)); }
public function signinAction(Request $request) { $checkrefer = $this->referercheck($request); if ($checkrefer == false) { return $this->redirect($this->generateUrl('mytrip_user_homepage')); } $session = $request->getSession(); $this->langsession($session); $lan = $session->get('language'); $request->setLocale($lan); $em = $this->container->get('doctrine')->getManager(); if ($request->getMethod() == "POST") { $emailcheck = $em->createQuery("SELECT p FROM MytripAdminBundle:User p WHERE p.email='" . $request->request->get('email') . "' AND p.status NOT IN ('Trash')")->getArrayResult(); if (!empty($emailcheck)) { if ($emailcheck[0]['password'] == sha1($request->request->get('password'))) { if ($emailcheck[0]['status'] == 'Active') { $session = $request->getSession(); $session->set('user', $emailcheck[0]); $session->set('UserLogin', "True"); if ($request->server->get('HTTP_REFERER') != '') { $ref = explode("/", $request->server->get('HTTP_REFERER')); if (in_array('booking', $ref)) { return $this->redirect($request->server->get('HTTP_REFERER')); } } if ($session->get('review') != '') { if ($session->get('hostal') != '') { $url = $this->container->get('router')->getContext()->getBaseUrl() . "/" . $session->get('destination') . "/" . $session->get('hostal'); } else { $url = $this->container->get('router')->getContext()->getBaseUrl() . "/" . $session->get('destination'); } $user = $session->get('user'); $typeid = 0; if ($session->get('type') == 'Destination') { $destination = $em->createQuery("SELECT d FROM MytripAdminBundle:Destination d WHERE d.status='Active' AND d.url='" . $session->get('destination') . "'")->getArrayResult(); $typeid = $destination[0]['destinationId']; } elseif ($session->get('type') == 'Hostal') { $destination = $em->createQuery("SELECT d FROM MytripAdminBundle:Destination d WHERE d.status='Active' AND d.url='" . $session->get('destination') . "'")->getArrayResult(); $hostal = $em->createQuery("SELECT d FROM MytripAdminBundle:Hostal d WHERE d.status='Active' AND d.destination='" . $destination[0]['destinationId'] . "' AND d.url='" . $session->get('hostal') . "'")->getArrayResult(); $typeid = $hostal[0]['hostalId']; } if ($typeid > 0) { $lan = $session->get('language'); $reviews = new \Mytrip\AdminBundle\Entity\Review(); $reviews->setUser($this->getDoctrine()->getRepository('MytripAdminBundle:User')->find($user['userId'])); $reviews->setTypeId($typeid); $reviews->setReviewType($session->get('type')); $reviews->setRating($session->get('rate')); $reviews->setReview($session->get('review')); $reviews->setCreatedDate($session->get('created_date')); $reviews->setLan($lan); $reviews->setStatus('Active'); $em->persist($reviews); $em->flush(); $session->remove('type'); $session->remove('review'); $session->remove('rate'); $session->remove('destination'); $session->remove('hostal'); $this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Your review was successfully posted')); } else { $this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Sorry, your review was not posted. Please try again.')); } return $this->redirect($url); } return $this->redirect($this->generateUrl('mytrip_user_profile')); } else { if ($emailcheck[0]['status'] == "Inactive") { $this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('You are deactivated by admin. Please contact admin')); } else { $this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Please check your mail. Click the confirmation link.')); } } } else { $this->get('session')->getFlashBag()->add('loginerror', $this->get('translator')->trans('Invalid Username or Password')); } } else { $this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Sorry, you are not a registered member!')); } return $this->redirect($request->server->get('HTTP_REFERER')); } return $this->redirect($this->generateUrl('mytrip_user_homepage')); }