public function userRegisterAction(Request $request)
{
$categories = $this->getDoctrine()->getRepository('JobPortalAdminBundle:Categories')->findBy(array('isDeleted' => '1', 'status' => '1'));
if ($request->getMethod() == 'POST') {
if ($_POST['g-recaptcha-response'] != '') {
$user = new Users();
$password = chr(rand(65, 90)) . chr(rand(65, 90)) . chr(rand(65, 90)) . chr(rand(65, 90)) . chr(rand(65, 90));
$user->setName($_POST['name']);
$user->setEmail($_POST['email']);
$user->setPhone($_POST['phone']);
$user->setPassword(md5($password));
$user->setStatus(1);
$user->setIsDeleted(1);
$em = $this->getDoctrine()->getManager();
$em->persist($user);
$em->flush();
/* User mail password */
$to = $_POST['email'];
$subject = 'Inscription Courrier';
$message = 'Merci pour linscription dans notre site Web. Votre mot de passe une fois de connexion est ' . $password;
$headers = 'From: info@jobportal.com' . "\r\n" . 'Reply-To: info@jobportal.com' . "\r\n" . 'X-Mailer: PHP/' . phpversion();
mail($to, $subject, $message, $headers);
/* User mail password end */
foreach ($_POST['category'] as $catg) {
$CategoryUserMappings = new CategoryUserMappings();
$CategoryUserMappings->setUserId($user->getId());
$CategoryUserMappings->setCategoryId($catg);
$em->persist($CategoryUserMappings);
}
$em->flush();
/* candidate Session Data Set */
$candidate_session_array = array('login_candidate_id' => $user->getId(), 'login_candidate_name' => $_POST['name']);
$this->get('session')->set('candidatedata', $candidate_session_array);
/* candidate Session Data Set End */
return new RedirectResponse($this->generateUrl('chage_password'));
} else {
return $this->render('JobPortalFrontBundle:Users:userRegister.html.php', array('categories' => $categories, 'captach_code' => 'Captcha Invalide'));
}
} else {
/* Get Cookies Value */
$user_remember_data = unserialize($this->getRequest()->cookies->get('user_remember_cookies'));
/* Get Cookies Value End */
return $this->render('JobPortalFrontBundle:Users:userRegister.html.php', array('categories' => $categories, 'user_cookies_remember' => $user_remember_data));
}
}
public function testScoreAction(Request $request)
{
$candateDetails = $this->get('session')->get('candidatedata');
$login_user_id = $candateDetails['login_candidate_id'];
$conn = $this->get('database_connection');
if ($request->getMethod() == "POST") {
$answer_arr = $request->request->all();
$score = 0;
$total_marks = 0;
$total_questions = 0;
$correct_answer = 0;
if (!empty($answer_arr['given_question_answer'])) {
foreach ($answer_arr['given_question_answer'] as $key => $data) {
$answer_status = $conn->fetchAll('SELECT q.*, a.* FROM questions q LEFT JOIN answers a ON a.question_id = q.id where q.id = "' . $data['question'] . '" AND a.id = "' . $data['answer'] . '" ');
$total_marks = $total_marks + $answer_status[0]['marks_positive'];
if ($answer_status[0]['answer_status']) {
$score = $score + $answer_status[0]['marks_positive'];
$correct_answer = $correct_answer + 1;
} else {
$score = $score - $answer_status[0]['marks_negative'];
}
$array_question[] = $data['question'];
}
}
if (!empty($answer_arr['total_question_id'])) {
foreach ($answer_arr['total_question_id'] as $question_key) {
$total_questions = $total_questions + 1;
if (in_array($question_key, $array_question)) {
} else {
$not_attend_answer = $conn->fetchAll('SELECT q.* FROM questions q where q.id = "' . $question_key . '" ');
$total_marks = $total_marks + $not_attend_answer[0]['marks_positive'];
$score = $score - $not_attend_answer[0]['marks_negative'];
}
}
}
$em = $this->getDoctrine()->getManager();
$exam_name = $conn->fetchAll('SELECT id,category FROM categories WHERE id = ' . $answer_status[0]['category_id']);
$question_string = implode(",", $array_question);
$date = date("Y-m-d H:i:s");
$exam_category = $conn->fetchAll('SELECT * FROM category_user_mappings WHERE user_id = ' . $login_user_id . ' AND category_id = ' . $answer_status[0]['category_id']);
if (empty($exam_category)) {
$CategoryUserMappings = new CategoryUserMappings();
$CategoryUserMappings->setUserId($login_user_id);
$CategoryUserMappings->setCategoryId($answer_status[0]['category_id']);
$em->persist($CategoryUserMappings);
$em->flush();
}
$scores = new Scores();
$scores->setCategoryType($answer_status[0]['category_id']);
$scores->setUserId($login_user_id);
$scores->setDate($date);
$scores->setScore($score);
$scores->setTotalMarks($total_marks);
$scores->setQuestion($question_string);
$em->persist($scores);
$em->flush();
}
$data_output = array('correct_answer' => $correct_answer, 'total_questions' => $total_questions, 'score' => $score, 'total_marks' => $total_marks, 'exam_name' => $exam_name[0]['category'], 'exam_id' => $exam_name[0]['id']);
$this->get('session')->set('exam_data', $data_output);
return new Response();
}
