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'));
}
