public function renewPlanAction(Request $request)
{
$session = $this->getRequest()->getSession();
if ($session->get('type') != 4) {
//if user is login then it will be redirect to login page
return $this->redirect($this->generateUrl('user_home'));
}
$session = $this->getRequest()->getSession();
$em = $this->getDoctrine()->getEntityManager();
$plans = $em->createQueryBuilder()->select('UserPlan')->from('DRPAdminBundle:UserPlan', 'UserPlan')->where('UserPlan.user_id=:id')->setParameter('id', $session->get('userId'))->SetMaxResults(1)->addOrderBy('UserPlan.id', 'DESC')->getQuery()->getArrayResult();
//******update plan*******//
$planDetail = $em->createQueryBuilder()->select('plan')->from('DRPAdminBundle:Plan', 'plan')->where('plan.id=:id')->setParameter('id', $plans[0]['plan_id'])->getQuery()->getArrayResult();
$userDetail = $em->createQueryBuilder()->select('user')->from('DRPAdminBundle:User', 'user')->where('user.id=:id')->setParameter('id', $session->get('userId'))->getQuery()->getArrayResult();
$newSearches = $userDetail[0]['search_count_total'] + $planDetail[0]['searches'];
/*$renewPlan = $em->createQueryBuilder()
->select('renewPlan')
->update('DRPAdminBundle:User', 'renewPlan')
->set('renewPlan.search_count_total', ':total')
->where('renewPlan.id = :id')
->setParameter('total', $newSearches)
->setParameter('id', $session->get('userId'))
->getQuery()
->getResult();*/
//******update plan*******//
$token = $this->generateRandomString(8);
$plan = new UserPlan();
$plan->setPlanId($plans[0]['plan_id']);
$plan->setUserId($session->get('userId'));
$plan->setStatus(0);
$plan->setPaymentStatus(0);
$plan->setToken($token);
$em->persist($plan);
$em->flush();
$ipAddress = $_SERVER['REMOTE_ADDR'];
$params['event'] = $this->getLogEventTitleAction('RENEW_PLAN');
$params['description'] = $this->getLogEventDescriptionAction('RENEW_PLAN');
$params['userId'] = $session->get('userId');
$params['ipAddress'] = $ipAddress;
$params['creatorId'] = $session->get('userId');
$this->setLogAction($params);
return $this->redirect($this->generateUrl('user_printRenewPlan'));
}
public function addUserAction(Request $request)
{
$session = $this->getRequest()->getSession();
if ($session->get('type') != 1) {
//if user is login then it will be redirect to login page
return $this->redirect($this->generateUrl('drp_adminLogin'));
}
$em = $this->getDoctrine()->getEntityManager();
$plans = $em->createQueryBuilder()->select('plan')->from('DRPAdminBundle:Plan', 'plan')->getQuery()->getResult();
$businessType = $em->createQueryBuilder()->select('businsess')->from('DRPAdminBundle:BusinessType', 'businsess')->getQuery()->getResult();
//echo"<pre>";print_r($businessType);die;
if ($request->getMethod() == 'POST') {
$sourcePath = $file = $_FILES['image']['name'];
$file1 = $_FILES['image']['tmp_name'];
move_uploaded_file($_FILES["image"]["tmp_name"], "uploads/user/" . $_FILES["image"]["name"]);
$company = $file = $_FILES['companyImage']['name'];
$token = $this->generateRandomString(6);
$file2 = $_FILES['companyImage']['tmp_name'];
move_uploaded_file($_FILES["companyImage"]["tmp_name"], "uploads/company/" . $_FILES["companyImage"]["name"]);
$firstName = $request->get('firstname');
$password = $request->get('password');
$middleName = $request->get('middlename');
$lastName = $request->get('lastname');
$email = $request->get('email');
$userName = $request->get('username');
$telephone1 = $request->get('tel1');
$telephone2 = $request->get('tel2');
$nin = $request->get('nin');
$tin = $request->get('tin');
$type = $request->get('business');
$token = $this->generateRandomString(8);
$name = $request->get('name');
$description = $request->get('description');
$emailCompany = $request->get('emailCompany');
$address = $request->get('address');
$tinCompany = $request->get('tinCompany');
$telephone1Company = $request->get('tel1Company');
$telephone2Company = $request->get('tel2Company');
$planId = $request->get('plan');
$addUser = new User();
$addUser->setFirstName($firstName);
$addUser->setMiddleName($middleName);
$addUser->setLastName($lastName);
$addUser->setEmail($email);
$addUser->setUsername($userName);
$addUser->setTelephone1($telephone1);
$addUser->setTelephone2($telephone2);
$addUser->setPassword(md5($password));
$addUser->setNin($nin);
$addUser->setTin($tin);
$addUser->setStatus(1);
$addUser->setType(4);
$addUser->setPicture($sourcePath);
$addUser->setToken($token);
$addUser->setCreatorId($session->get('userId'));
$em->persist($addUser);
$em->flush();
$userId = $addUser->getId();
$addBusiness = new Business();
$addBusiness->setName($name);
$addBusiness->setDescription($description);
$addBusiness->setEmail($emailCompany);
$addBusiness->setType($type);
$addBusiness->setAddress($address);
$addBusiness->setPicture($company);
$addBusiness->setTin($tinCompany);
$addBusiness->setTelephone1($telephone1Company);
$addBusiness->setTelephone2($telephone2Company);
$addBusiness->setUserId($userId);
$addUser->setCreatorId($session->get('userId'));
$em->persist($addBusiness);
$em->flush();
$plan = new UserPlan();
$plan->setPlanId($planId);
$plan->setUserId($userId);
$plan->setToken($token);
$plan->setStatus(0);
$em->persist($plan);
$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 = "User Registration";
$txt = 'Hello ' . $firstName . ' ' . $lastName . ',<br><br>Your have created account on ' . $date . '<br><br>Email is: <b>' . $email . '</b>' . 'and your password is' . $password;
mail($to, $subject, $txt, $headers);
//echo $txt;die;
$ipAddress = $_SERVER['REMOTE_ADDR'];
$params['event'] = $this->getLogEventTitleAction('ADD_USER');
$params['description'] = $this->getLogEventDescriptionAction('ADD_USER');
$params['userId'] = $session->get('userId');
$params['ipAddress'] = $ipAddress;
$params['creatorId'] = $session->get('userId');
$this->setLogAction($params);
return $this->redirect($this->generateUrl('drp_users'));
}
return $this->render('DRPAdminBundle:Pages:addUser.html.twig', array('plans' => $plans, 'businessType' => $businessType));
}
public function addUserAction(Request $request)
{
$session = $this->getRequest()->getSession();
if ($session->get('type') != 3) {
//if user is login then it will be redirect to login page
return $this->redirect($this->generateUrl('registrarAdmin_adminLogin'));
}
$em = $this->getDoctrine()->getEntityManager();
$plans = $em->createQueryBuilder()->select('plan')->from('DRPAdminBundle:Plan', 'plan')->getQuery()->getResult();
$businessType = $em->createQueryBuilder()->select('businsess')->from('DRPAdminBundle:BusinessType', 'businsess')->getQuery()->getResult();
//echo"<pre>";print_r($businessType);die;
if ($request->getMethod() == 'POST') {
$sourcePath = $file = $_FILES['image']['name'];
$file1 = $_FILES['image']['tmp_name'];
move_uploaded_file($_FILES["image"]["tmp_name"], "uploads/user/" . $_FILES["image"]["name"]);
$company = $file = $_FILES['companyImage']['name'];
$token = $this->generateRandomString(6);
$file2 = $_FILES['companyImage']['tmp_name'];
move_uploaded_file($_FILES["companyImage"]["tmp_name"], "uploads/company/" . $_FILES["companyImage"]["name"]);
$firstName = $request->get('firstname');
$password = $request->get('password');
$middleName = $request->get('middlename');
$lastName = $request->get('lastname');
$email = $request->get('email');
$userName = $request->get('username');
$telephone1 = $request->get('tel1');
$telephone2 = $request->get('tel2');
$nin = $request->get('nin');
$tin = $request->get('tin');
$type = $request->get('business');
$token = $this->generateRandomString(8);
$name = $request->get('name');
$description = $request->get('description');
$emailCompany = $request->get('emailCompany');
$address = $request->get('address');
$tinCompany = $request->get('tinCompany');
$telephone1Company = $request->get('tel1Company');
$telephone2Company = $request->get('tel2Company');
$planId = $request->get('plan');
$addUser = new User();
$addUser->setFirstName($firstName);
$addUser->setMiddleName($middleName);
$addUser->setLastName($lastName);
$addUser->setEmail($email);
$addUser->setUsername($userName);
$addUser->setTelephone1($telephone1);
$addUser->setTelephone2($telephone2);
$addUser->setPassword(md5($password));
$addUser->setNin($nin);
$addUser->setTin($tin);
$addUser->setStatus(1);
$addUser->setType(4);
$addUser->setPicture($sourcePath);
$addUser->setToken($token);
$addUser->setCreatorId($session->get('userId'));
$em->persist($addUser);
$em->flush();
$userId = $addUser->getId();
$addBusiness = new Business();
$addBusiness->setName($name);
$addBusiness->setDescription($description);
$addBusiness->setEmail($emailCompany);
$addBusiness->setType($type);
$addBusiness->setAddress($address);
$addBusiness->setPicture($company);
$addBusiness->setTin($tinCompany);
$addBusiness->setTelephone1($telephone1Company);
$addBusiness->setTelephone2($telephone2Company);
$addBusiness->setUserId($userId);
$em->persist($addBusiness);
$em->flush();
$plan = new UserPlan();
$plan->setPlanId($planId);
$plan->setUserId($userId);
$plan->setToken($token);
$plan->setStatus(0);
$em->persist($plan);
$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 = "User Registration";
$txt = '
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="min-width: 320px;"><tr><td align="center" bgcolor="#eff3f8" >
<table border="0" cellspacing="0" cellpadding="0" class="table_width_100" width="100%" style="max-width: 680px; min-width: 300px;" >
<!--header -->
<tr><td align="center" >
<!-- padding -->
<table width="90%" border="0" cellspacing="0" cellpadding="0" style="margin: 30px 0 31px;">
<!--header END-->
<!--content 1 -->
<tr><td align="center" bgcolor="#fbfcfd">
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top" class="mob_center" >
<a href="#" target="_blank" style="color: #596167; font-family: Arial, Helvetica, sans-serif; font-size: 13px; float:left;" >
<font face="Arial, Helvetica, sans-seri; font-size: 13px;" size="3" color="#596167">
<img src="http://www.gamregistry.com/images/logo.png" width="117" height="77px" alt="DRP" border="0" style="display: block;margin-top:10px;" /></font></a>
<p style=" color: #92171c;
display: block;
float: left;
font-size: 24px;
font-weight: bold;
margin: 40px 0 0 63px;">Registrar of Deeds</p>
<a href="#" target="_blank" style="color: #596167; font-family: Arial, Helvetica, sans-serif; font-size: 13px;float:right;" >
<font face="Arial, Helvetica, sans-seri; font-size: 13px;" size="3" color="#596167">
<img src="http://www.gamregistry.com/images/flag.jpg" width="77" height="77px" alt="DRP" border="0" style="display: block; margin-top:10px;" /></font></a>
</td>
</tr>
<tr><td align="center">
<div style="line-height: 44px; margin-top: 29px;">
<font face="Arial, Helvetica, sans-serif" size="5" color="#57697e" style="font-size: 34px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: 34px; color: #57697e;">
User Registration
</span></font>
</div>
<!-- padding -->
</td></tr>
<tr><td align="center">
<div style="line-height: 24px;">
<font face="Arial, Helvetica, sans-serif" size="4" color="#57697e" style="font-size: 15px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: 15px; color: #57697e;">
Hello ' . $firstName . ' ' . $lastName . ' you have created account on ' . $date . '.Your Account detalis are:<br>Username/Email:<b>' . $email . '</b><br>Password:<b>' . $password . '</b>
</span></font>
</div>
<!-- padding --><div style="height: 40px; line-height: 40px; font-size: 10px;"> </div>
</td></tr>
<tr><td align="center">
<div style="line-height: 24px;">
<a href="#" target="_blank" style="color: #596167; font-family: Arial, Helvetica, sans-serif; font-size: 13px;">
<font face="Arial, Helvetica, sans-seri; font-size: 13px;" size="3" color="#596167">
<a href="http://www.gamregistry.com" style="background-color: #3598dc;
color: #ffffff; font-size: 17px;
outline: medium none !important;
padding: 13px 42px;
text-decoration: none;" >Click Here For Login</a></font></a>
</div>
<!-- padding --><div style="height: 60px; line-height: 60px; font-size: 10px;"> </div>
</td></tr>
</table>
</td></tr>
<!--content 1 END-->
<!--content 2 -->
</table>
</td></tr>
</table>
';
mail($to, $subject, $txt, $headers);
//echo $txt;die;
$ipAddress = $_SERVER['REMOTE_ADDR'];
$params['event'] = $this->getLogEventTitleAction('ADD_USER');
$params['description'] = $this->getLogEventDescriptionAction('ADD_USER');
$params['userId'] = $session->get('userId');
$params['ipAddress'] = $ipAddress;
$params['creatorId'] = $session->get('userId');
$this->setLogAction($params);
return $this->redirect($this->generateUrl('registrarAdmin_users'));
}
return $this->render('DRPRegistrarAdminBundle:Pages:addUser.html.twig', array('plans' => $plans, 'businessType' => $businessType));
}