function facebookLoginAction(Request $request)
{
$session = $this->getRequest()->getSession();
$em = $this->getDoctrine()->getEntityManager();
$type = 3;
$status = 1;
$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');
$session->set('fbId', $fbId);
$session->set('fbUserprofpic', $fbUserprofpic);
/*---Start - Add new Facebook User -----*/
$reviewer = new User();
$reviewer->setFirstName($fbFirstName);
$reviewer->setLastName($fbLastName);
$reviewer->setEmail($fbEmail);
$reviewer->setImage($fbUserprofpic);
$reviewer->setfacebookId($fbId);
$reviewer->setType($type);
$reviewer->setStatus($status);
$em->persist($reviewer);
$em->flush();
/*---End - Add new Facebook User -----*/
/*---Start - Facebook LoggedIn -----*/
$reviewerId = $reviewer->getId();
$session = $this->getRequest()->getSession();
$session->set('userId', $reviewerId);
$session->set('userEmail', $fbEmail);
$session->set('userName', $fbFirstName);
$session->set('userType', $type);
$facebookRepository = $em->getRepository('RARAdminBundle:User');
$userLogin = $facebookRepository->findOneBy(array('email' => $fbEmail, 'facebook_id' => $fbId, 'type' => 3, 'status' => 1));
if ($userLogin) {
return $this->redirect($this->generateUrl('rar_web_homepage'));
}
/*---End - Facebook LoggedIn -----*/
return $this->redirect($this->generateUrl('rar_web_homepage'));
}
public function addrealtorAction(Request $request)
{
$plans = $this->getPlanAction();
// get all states
$states = $this->getStatesAction();
if ($request->getMethod() == 'POST') {
$file = $_FILES['file']['name'];
$file1 = $_FILES['file']['tmp_name'];
move_uploaded_file($_FILES["file"]["tmp_name"], "uploads/" . $_FILES["file"]["name"]);
$logo = $_FILES['logo']['tmp_name'];
move_uploaded_file($_FILES["logo"]["tmp_name"], "logo/" . $_FILES["logo"]["name"]);
$firstname = $this->get('request')->request->get('firstname');
$lastname = $this->get('request')->request->get('lastname');
$password = $this->get('request')->request->get('password');
$email = $this->get('request')->request->get('email');
$phone = $this->get('request')->request->get('phone');
$state = $this->get('request')->request->get('state');
$address = $this->get('request')->request->get('address');
$address2 = $this->get('request')->request->get('address2');
$city = $this->get('request')->request->get('city');
$id = $this->get('request')->request->get('id');
$plan = $this->get('request')->request->get('plan');
$planName = $this->get('request')->request->get('planName');
$business = $this->get('request')->request->get('business');
$overview = $this->get('request')->request->get('overview');
$fax = $this->get('request')->request->get('fax');
$twitter = $this->get('request')->request->get('twitter');
$facebook = $this->get('request')->request->get('facebook');
$google = $this->get('request')->request->get('google');
$linkedin = $this->get('request')->request->get('linkedin');
$video = $this->get('request')->request->get('video');
//echo "<pre>";print_r($plan);die();
$country = 'US';
// set country USA
$type = 1;
$status = 1;
$pincode = $this->get('request')->request->get('pincode');
$realtor = new User();
$realtor->setFirstName($firstname);
$realtor->setLastName($lastname);
$realtor->setPassword(md5($password));
$realtor->setEmail($email);
$realtor->setPhone($phone);
$realtor->setState($state);
$realtor->setAddress($address);
$realtor->setAddress2($address2);
$realtor->setCity($city);
$realtor->setCountry($country);
$realtor->setType($type);
$realtor->setStatus($status);
$realtor->setPinCode($pincode);
$realtor->setImage($file);
$realtor->setLogo($logo);
$realtor->setOverview($overview);
$realtor->setFax($fax);
$realtor->setTwitter($twitter);
$realtor->setFacebook($facebook);
$realtor->setGoogle($google);
$realtor->setLinkedin($linkedin);
$realtor->setVideo($video);
$realtor->setBusinessName($business);
if ($plan == 1) {
$realtor->setSubscriptionTypeId('NULL');
} else {
$realtor->setSubscriptionTypeId($plan);
}
$realtor->setPlanId($planName);
$em = $this->getDoctrine()->getEntityManager();
$em->persist($realtor);
$em->flush();
$date = date("Y/m/d.");
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
$headers .= 'From: <*****@*****.**>' . "\r\n";
$to = $email;
$subject = "New Account Information";
$txt = 'Hello ' . $firstname . ' ' . $lastname . ',<br><br>Your account has been created with review-a-realtor.com on ' . $date . '<br><br>Your Account Details are as under: <br>Email Id: <b>' . $email . '</b><br>Password: <b>' . $password . '</b>';
mail($to, $subject, $txt, $headers);
//send mail
return $this->redirect($this->generateUrl('RARAdminBundle_realtor', array('states' => $states, 'plans' => $plans)));
}
return $this->render('RARAdminBundle:Realtor:addRealtor.html.twig', array('states' => $states, 'plans' => $plans));
}
public function importRealtorsAction(Request $request)
{
ini_set('max_execution_time', 10000000);
$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('RARAdminBundle:Realtor:importRealtors.html.twig',array('error'=>$error));
}
else
{*/
//echo"<pre>";print_r($_FILES);die;
if (is_uploaded_file($_FILES['file']['tmp_name'])) {
//readfile($_FILES['file']['tmp_name']);
}
$handle = fopen($_FILES['file']['tmp_name'], "r");
/*$i=0;
while (($data = fgetcsv($handle, 10000000, ";")) !== FALSE)
{
$arrFile[] = $data;
$i++;
if($i>50)
break;
}
echo "<PRE>";print_r($arrFile);die;*/
$stateCode = '';
$cityName = '';
$companyName = '';
$phone = '';
$businessUrl = '';
$address = '';
$zipCode = '';
$stateName = '';
$category1 = '';
$category2 = '';
while (($data = fgetcsv($handle, 10000000, ";")) !== FALSE) {
$data = explode(';', $data[0]);
if (isset($data[0])) {
$stateCode = ltrim($data[0]);
}
if (isset($data[1])) {
$cityName = ltrim($data[1]);
}
if (isset($data[2])) {
$companyName = ltrim($data[2]);
}
if (isset($data[3])) {
$phone = ltrim($data[3]);
}
if (isset($data[4])) {
$businessUrl = ltrim($data[4]);
}
if (isset($data[5])) {
$address = ltrim($data[5]);
}
if (isset($data[6])) {
$zipCode = ltrim($data[6]);
}
if (isset($data[7])) {
$stateName = ltrim($data[7]);
}
if (isset($data[8])) {
$category1 = ltrim($data[8]);
}
if (isset($data[9])) {
$category2 = ltrim($data[9]);
}
$em = $this->getDoctrine()->getEntityManager();
$city = $em->createQueryBuilder()->select('City')->from('RARAdminBundle:City', 'City')->where('City.city_name = :cityName')->setParameter('cityName', $cityName)->getQuery()->getArrayResult();
//echo $cityName."<PRE>";print_r($data);die;
$cityId = $city[0]['id'];
$country = 'US';
$arrCat = explode(',,,,,', $category2);
$category2 = $arrCat[0];
$realtor = new User();
$realtor->setState($stateCode);
$realtor->setCity($cityId);
$realtor->setBusinessName($companyName);
$realtor->setPhone($phone);
$realtor->setBusinessUrl($businessUrl);
$realtor->setAddress($address);
$realtor->setPinCode($zipCode);
//$realtor->setStateName($stateName);
$realtor->setCountry($country);
$realtor->setCategory1($category1);
$realtor->setCategory2($category2);
$realtor->setImage('default_user_image.jpeg');
$realtor->setLogo('company.jpeg');
$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);
//}
}
return $this->render('RARAdminBundle:Realtor:importRealtors.html.twig');
}
