public function captureEmailAction(Request $request, $id) { $em = $this->getDoctrine()->getEntityManager(); $gbl_email_administrator = $this->container->getParameter('gbl_email_administrator'); //get email of administrator $website_url = $this->container->getParameter('website_url'); //get url of website $reviewDateTime = new DateTime(); $airlineId = $this->get('request')->request->get('airlineReview'); $airlineName = $this->get('request')->request->get('search'); $departureCity = $this->get('request')->request->get('departureCity'); $destinationCity = $this->get('request')->request->get('destinationCity'); $stars = $this->get('request')->request->get('stars'); $starH = $this->get('request')->request->get('starH'); $starR = $this->get('request')->request->get('starR'); $starM = $this->get('request')->request->get('starM'); $starL = $this->get('request')->request->get('starL'); $starG = $this->get('request')->request->get('starG'); $starQ = $this->get('request')->request->get('starQ'); $travel = $this->get('request')->request->get('recagent'); $trip = $this->get('request')->request->get('trip'); $headline = $this->get('request')->request->get('headline'); $writereview = $this->get('request')->request->get('writereview'); $agent = $this->get('request')->request->get('agent'); $receiveUpdates = $this->get('request')->request->get('receiveUpdates') == 'on' ? 1 : 0; $recommend = $this->get('request')->request->get('recomend'); /*----Start - When reviewr is Logged In-----*/ $session = $this->getRequest()->getSession(); if ($session->get('userId') && $session->get('userId') != '') { /*---Start - fetch detail of reviewer -----*/ $reviewerName = $em->createQueryBuilder()->select('user')->from('RAAAdminBundle:User', 'user')->where('user.id=:id')->setParameter('id', $session->get('userId'))->getQuery()->getArrayResult(); $firstname = $reviewerName[0]['first_name']; $emailReviewer = $reviewerName[0]['email']; $lastname = $reviewerName[0]['last_name']; /*---End - fetch detail of reviewer -----*/ /*---Start - Store a new review in database -----*/ $file = $_FILES['revImage']['name']; $file1 = $_FILES['revImage']['tmp_name']; move_uploaded_file($_FILES["revImage"]["tmp_name"], "images/Airline/" . $_FILES["revImage"]["name"]); $rating = new Review(); $rating->setHeadline($headline); $rating->setDescription($writereview); $rating->setUseAgent($agent); $rating->setReceiveUpdates($receiveUpdates); $rating->setDepartureCity($departureCity); $rating->setDestinationCity($destinationCity); $rating->setRecomendAgent($recommend); $rating->setRating($stars); $rating->setReviewerId($session->get('userId')); $rating->setcreationTimestamp($reviewDateTime); if ($airlineId) { $rating->setAirlineId($airlineId); } else { $rating->setAirlineId($id); } $rating->setHonesty($starH); $rating->setTravel($travel); $rating->setTrip($trip); $rating->setSender('REVIEWER'); $rating->setStatus(2); $rating->setHonesty($starH); $rating->setMarketKnowldege($starL); $rating->setSoldPrice($starH); $rating->setResponsiveness($starR); $rating->setService($starM); $rating->setSoldQuickly($starQ); $rating->setReviewerImage($file); $em->persist($rating); $em->flush(); /*---End - Store a new review in database -----*/ $reviewId = $rating->getId(); //get last inserted id of reviewer $confirmationLink = $website_url . "approve/review/" . $reviewId; //review link /*---Start - swift mailer for approve review -----*/ $message = \Swift_Message::newInstance()->setSubject('Review')->setFrom($emailReviewer)->setTo($gbl_email_administrator)->setBody($this->renderView('RAAWebBundle:Email:review.txt.twig', array('firstname' => $firstname, 'lastname' => $lastname, 'writereview' => $writereview, 'airlineName' => $airlineName, 'confirmationLink' => $confirmationLink, 'stars' => $stars))); $this->get('mailer')->send($message); /*---Start - swift mailer for approve review -----*/ return $this->render('RAAWebBundle:Page:confirmationLink.html.twig'); } /*----End - When reviewer is Logged In-----*/ $website_url = $this->container->getParameter('website_url'); if ($request->getMethod() == 'POST') { $file = $_FILES['revImage']['name']; $file1 = $_FILES['revImage']['tmp_name']; move_uploaded_file($_FILES["revImage"]["tmp_name"], "images/Airline/" . $_FILES["revImage"]["name"]); $phone = $this->get('request')->request->get('phone'); $fbFirstName = $this->get('request')->request->get('fbFirstName'); $fbLastName = $this->get('request')->request->get('fbLastName'); $fbUserFullName = $this->get('request')->request->get('fbUserFullName'); $fbEmail = $this->get('request')->request->get('fbEmail'); $fbUserprofpic = $this->get('request')->request->get('fbpimage'); $fbId = $this->get('request')->request->get('user_form_email'); /*----Start - When Guest is Register-----*/ if ($fbEmail == "") { $firstname = $this->get('request')->request->get('firstname'); $lastname = $this->get('request')->request->get('lastname'); $email = $this->get('request')->request->get('email'); $phone = $this->get('request')->request->get('phone'); $airlineId = $this->get('request')->request->get('airlineReview'); $departureCity = $this->get('request')->request->get('departureCity'); $destinationCity = $this->get('request')->request->get('destinationCity'); $stars = $this->get('request')->request->get('stars'); $starH = $this->get('request')->request->get('starH'); $starR = $this->get('request')->request->get('starR'); $starM = $this->get('request')->request->get('starM'); $starL = $this->get('request')->request->get('starL'); $starG = $this->get('request')->request->get('starG'); $starQ = $this->get('request')->request->get('starQ'); $travel = $this->get('request')->request->get('recagent'); $trip = $this->get('request')->request->get('trip'); $headline = $this->get('request')->request->get('headline'); $writereview = $this->get('request')->request->get('writereview'); $agent = $this->get('request')->request->get('agent'); $receiveUpdates = $this->get('request')->request->get('receiveUpdates') == 'on' ? 1 : 0; $recommend = $this->get('request')->request->get('recomend'); $type = 3; $status = 1; $sysPwd = $this->generateRandomString(8); $repository = $em->getRepository('RAAAdminBundle:User'); $user = $repository->findOneBy(array('email' => $email)); /*---Start - Register new Reviewer -----*/ $reviewer = new User(); $reviewer->setFirstName($firstname); $reviewer->setLastName($lastname); $reviewer->setEmail($email); $reviewer->setPassword(md5($sysPwd)); $reviewer->setPhone($phone); $reviewer->setType($type); $reviewer->setStatus($status); $em->persist($reviewer); $em->flush(); /*---End - Register new Reviewer -----*/ $reviewerId = $reviewer->getId(); //last inserted id of reviewer $website_url = $this->container->getParameter('website_url'); //get website url $confirmationLink = $website_url . "confirmed/registration/" . $reviewerId; //registration link /*---Start - Swift mailer for registration -----*/ $message = \Swift_Message::newInstance()->setSubject('Registration')->setFrom('*****@*****.**')->setTo($email)->setBody($this->renderView('RAAWebBundle:Email:registration.txt.twig', array('firstname' => $firstname, 'lastname' => $lastname, 'email' => $email, 'password' => $sysPwd, 'confirmationLink' => $confirmationLink))); $this->get('mailer')->send($message); /*---End - Swift mailer for registration -----*/ /*---Start - add new Review -----*/ $reviewDateTime = new DateTime(); $rating = new Review(); $rating->setHeadline($headline); $rating->setDescription($writereview); $rating->setUseAgent($agent); $rating->setReceiveUpdates($receiveUpdates); $rating->setRecomendAgent($recommend); $rating->setDepartureCity($departureCity); $rating->setDestinationCity($destinationCity); $rating->setRating($stars); $rating->setReviewerId($reviewerId); $rating->setcreationTimestamp($reviewDateTime); if ($airlineId) { $em = $this->getDoctrine()->getEntityManager(); $rating->setAirlineId($airlineId); } else { $rating->setAirlineId($id); } $rating->setSender('REVIEWER'); $rating->setStatus(2); $rating->setHonesty($starH); $rating->setTravel($travel); $rating->setTrip($trip); $rating->setMarketKnowldege($starL); $rating->setSoldPrice($starH); $rating->setResponsiveness($starR); $rating->setService($starM); $rating->setSoldQuickly($starQ); $rating->setReviewerImage($file); $em->persist($rating); $em->flush(); /*---End - add new Review -----*/ $reviewId = $rating->getId(); if (!isset($emailReviewer)) { $emailReviewer = $email; } $confirmationLink = $website_url . "approve/review/" . $reviewId; //review link /*---Start - swift mailer for approve review -----*/ $messageAdmin = \Swift_Message::newInstance()->setSubject('Review')->setFrom($emailReviewer)->setTo($gbl_email_administrator)->setBody($this->renderView('RAAWebBundle:Email:review.txt.twig', array('firstname' => $firstname, 'lastname' => $lastname, 'writereview' => $writereview, 'airlineName' => $airlineName, 'confirmationLink' => $confirmationLink, 'stars' => $stars))); $this->get('mailer')->send($messageAdmin); /*---End - swift mailer for approve review -----*/ return $this->render('RAAWebBundle:Page:reviewRegistration.html.twig'); /*----End - When Guest is Register-----*/ /*----Start - When Guest is Logged with facebook-----*/ } else { $firstname = $fbFirstName; $lastname = $fbLastName; $email = $fbEmail; $fbUserprofpic = $this->get('request')->request->get('fbpimage'); $fbId = $this->get('request')->request->get('user_form_email'); $session->set('fbId', $fbId); $session->set('fbUserprofpic', $fbUserprofpic); } $airlineId = $this->get('request')->request->get('airlineReview'); $departureCity = $this->get('request')->request->get('departureCity'); $destinationCity = $this->get('request')->request->get('destinationCity'); $stars = $this->get('request')->request->get('stars'); $starH = $this->get('request')->request->get('starH'); $starR = $this->get('request')->request->get('starR'); $starM = $this->get('request')->request->get('starM'); $starL = $this->get('request')->request->get('starL'); $starG = $this->get('request')->request->get('starG'); $starQ = $this->get('request')->request->get('starQ'); $travel = $this->get('request')->request->get('recagent'); $trip = $this->get('request')->request->get('trip'); $headline = $this->get('request')->request->get('headline'); $writereview = $this->get('request')->request->get('writereview'); $agent = $this->get('request')->request->get('agent'); $receiveUpdates = $this->get('request')->request->get('receiveUpdates') == 'on' ? 1 : 0; $recommend = $this->get('request')->request->get('recomend'); $type = 3; $status = 1; $sysPwd = $this->generateRandomString(8); $repository = $em->getRepository('RAAAdminBundle:User'); $user = $repository->findOneBy(array('email' => $email)); /*---Start - Add Facebook User -----*/ $reviewer = new User(); $reviewer->setFirstName($firstname); $reviewer->setLastName($lastname); $reviewer->setEmail($email); $reviewer->setPassword(md5($sysPwd)); $reviewer->setPhone($phone); $reviewer->setImage($fbUserprofpic); $reviewer->setfacebookId($fbId); $reviewer->setType($type); $reviewer->setStatus($status); $em->persist($reviewer); $em->flush(); /*---End - Add Facebook User -----*/ /*---Start - Login Facebook User -----*/ $reviewerId = $reviewer->getId(); $session = $this->getRequest()->getSession(); $session->set('userId', $reviewerId); $session->set('userEmail', $email); $session->set('userName', $firstname); $session->set('userType', $type); $facebookRepository = $em->getRepository('RAAAdminBundle:User'); $userLogin = $facebookRepository->findOneBy(array('email' => $email, 'facebook_id' => $fbId, 'type' => 3, 'status' => 1)); /*---End - Login Facebook User -----*/ /*---Start - Add a new Reviewer -----*/ $website_url = $this->container->getParameter('website_url'); $confirmationLink = $website_url . "confirmed/registration/" . $reviewerId; $reviewDateTime = new DateTime(); $rating = new Review(); $rating->setHeadline($headline); $rating->setDescription($writereview); $rating->setUseAgent($agent); $rating->setReceiveUpdates($receiveUpdates); $rating->setRecomendAgent($recommend); $rating->setDepartureCity($departureCity); $rating->setDestinationCity($destinationCity); $rating->setRating($stars); $rating->setReviewerId($reviewerId); $rating->setcreationTimestamp($reviewDateTime); if ($airlineId) { $rating->setAirlineId($airlineId); } else { $rating->setAirlineId($id); } $rating->setSender('REVIEWER'); $rating->setStatus(2); $rating->setHonesty($starH); $rating->setTravel($travel); $rating->setTrip($trip); $rating->setMarketKnowldege($starL); $rating->setSoldPrice($starH); $rating->setResponsiveness($starR); $rating->setService($starM); $rating->setSoldQuickly($starQ); $rating->setReviewerImage($file); $em->persist($rating); $em->flush(); /*---End - Add a new Reviewer -----*/ /*---Start - swift mailer for approve review -----*/ $reviewId = $rating->getId(); $confirmationLink = $website_url . "approve/review/" . $reviewId; $messageAdmin = \Swift_Message::newInstance()->setSubject('Review')->setFrom($email)->setTo($gbl_email_administrator)->setBody($this->renderView('RAAWebBundle:Email:review.txt.twig', array('firstname' => $firstname, 'lastname' => $lastname, 'writereview' => $writereview, 'airlineName' => $airlineName, 'confirmationLink' => $confirmationLink, 'stars' => $stars))); $this->get('mailer')->send($messageAdmin); /*---End - swift mailer for approve review -----*/ if ($userLogin) { return $this->redirect($this->generateUrl('raa_web_home')); } } return $this->render('RAAWebBundle:Page:reviewRegistration.html.twig'); }
public function importRealtorsAction(Request $request) { $session = $this->getRequest()->getSession(); $loggedInUserId = $session->get('userId'); $currentTimestamp = new DateTime(); if ($request->getMethod() == 'POST') { //echo $_FILES['file']['type'];die(); if (!($_FILES['file']['type'] == "text/comma-separated-values") && !($_FILES['file']['type'] == "application/vnd.ms-excel")) { $error = 'Wrong file selected'; return $this->render('RAAAdminBundle:Airline:importAirlines.html.twig', array('error' => $error)); } else { if (is_uploaded_file($_FILES['file']['tmp_name'])) { //readfile($_FILES['file']['tmp_name']); } $handle = fopen($_FILES['file']['tmp_name'], "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $firstName = $data[0]; $lastName = $data[1]; $email = $data[2]; $password = $data[3]; $phone = $data[4]; $address = $data[5]; $address2 = $data[6]; $city = $data[7]; $state = $data[8]; $country = $data[9]; $pincode = $data[10]; $fax = $data[11]; $business = $data[12]; $overview = $data[13]; $twitter = $data[14]; $google = $data[15]; $linkedin = $data[16]; $video = $data[17]; $facebook = $data[18]; $realtor = new User(); $realtor->setFirstName($firstName); $realtor->setLastName($lastName); $realtor->setEmail($email); $realtor->setPassword(md5($password)); $realtor->setPhone($phone); $realtor->setAddress($address); $realtor->setAddress2($address2); $realtor->setCity($city); $realtor->setState($state); $realtor->setCountry($country); $realtor->setPinCode($pincode); $realtor->setFax($fax); $realtor->setBusinessName($business); $realtor->setOverview($overview); $realtor->setTwitter($twitter); $realtor->setGoogle($google); $realtor->setLinkedin($linkedin); $realtor->setFacebook($facebook); $realtor->setVideo($video); $realtor->setType(2); $realtor->setPlanId(1); $realtor->setStatus(1); $realtor->setCreatorId($loggedInUserId); $realtor->setModifierId($loggedInUserId); $realtor->setCreationTimestamp($currentTimestamp); $realtor->setModificationTimestamp($currentTimestamp); $em = $this->getDoctrine()->getEntityManager(); $em->persist($realtor); $em->flush(); } fclose($handle); //print "Import done"; } } return $this->render('RAAAdminBundle:Airline:importAirlines.html.twig'); }