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