<?php
header('Content-Type: application/json');
include 'config.php';
date_default_timezone_set('Asia/Calcutta');
$curDate = date('Y-m-d H:i:s');

/*********** Required file Mail *****************/

/***********************************************/

$DataType = $_REQUEST['dataType'];
$array = array();
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include "/var/www/grapossconnect/include/mail-functions.php";

function getExtension($str)
{
	$i = strrpos($str, ".");
	if (!$i) {
		return "";
	}
	$l = strlen($str) - $i;
	$ext = substr($str, $i + 1, $l);
	return $ext;
}
/***********   admission form  *****************/
if ($DataType == 'partner') {
	$user_name = $_REQUEST['uname'];
	$user_email = $_REQUEST['uemail'];
	$user_phone = $_REQUEST['uphone'];
	$user_message = $_REQUEST['umessage'];

	if (!filter_var($user_email, FILTER_VALIDATE_EMAIL)) {
		$array = array('status' => '0', 'msg' => 'Enter correct email id');
	} else if (ctype_alnum(str_replace(' ', '', $user_phone)) == '') {
		$array = array('status' => '0', 'msg' => 'Enter correct phone number');
	} else {
		$stmt = $conn->prepare("INSERT INTO gc_partner_enquiry (name, email, mobile, content, add_date, status) VALUES (?, ?, ?, ?, ?, 'Y')");
		$stmt->bind_param("sssss", $user_name, $user_email, $user_phone, $user_message, $curDate);

		if ($stmt->execute()) {
			sendmailPartnerWithUs($user_name, $user_message, $user_email, $user_phone);
			$array = array('status' => '1', 'msg' => 'Thank for writing us, we will contact to you soon.');
		} else {
			$array = array('status' => '0', 'msg' => 'Query not inserted');
		}
	}
} else if ($DataType == 'contact') {
	$user_name = $_REQUEST['uname'];
	$user_email = $_REQUEST['uemail'];
	$user_message = $_REQUEST['umessage'];
	$curDate = date('Y-m-d H:i:s');

	if (!filter_var($user_email, FILTER_VALIDATE_EMAIL)) {
		$array = array('status' => '0', 'msg' => 'Enter correct email id');
	} else {
		$stmt = $conn->prepare("INSERT INTO gc_contactus_enquiry (name, email, content, add_date, status) VALUES (?, ?, ?, ?, 'Y')");
		$stmt->bind_param("ssss", $user_name, $user_email, $user_message, $curDate);

		if ($stmt->execute()) {
			$array = array('status' => '1', 'msg' => 'Thank for writing us, we will contact to you soon.');
			sendContactUsmail($user_name, $user_message, $user_email);
		} else {
			$array = array('status' => '0', 'msg' => 'Something went wrong');
		}

		$stmt->close();
	}
} else if ($DataType == 'career') {

	$q_jb = $_REQUEST['q_jb'];
	$q_fn = $_REQUEST['q_fn'];
	$q_m = $_REQUEST['q_m'];
	$q_em = $_REQUEST['q_em'];
	$q_msg = $_REQUEST['q_msg'];
	$q_prof = @$_FILES['q_prof'];

	if (ctype_alnum(str_replace(' ', '', $q_jb)) == '') {
		$array = array('status' => '0', 'msg' => 'Do not use any special character in title');
	} else if (ctype_alnum(str_replace(' ', '', $q_fn)) == '') {
		$array = array('status' => '0', 'msg' => 'Do not use any special character in name');
	} else if (!filter_var($q_em, FILTER_VALIDATE_EMAIL)) {
		$array = array('status' => '0', 'msg' => 'Invalid email id');
	} else if ($q_m != '' && (strlen($q_m) != '10')) {
		$array = array('status' => '0', 'msg' => 'Invalid contact number');
	} else if (ctype_alnum(str_replace(' ', '', $q_msg)) == '') {
		$array = array('status' => '0', 'msg' => 'Do not use any special character in message box');
	} else if (empty($q_prof)) {
		$array = array('status' => '0', 'msg' => 'Please upload your resume');
	} else {

		if (!empty(@$_FILES['q_prof'])) {

			$target_path = '/var/www/grapossconnect/include/career_profiles/';

			$curTime = date('ymdHis');


			$filename = stripslashes($_FILES['q_prof']['name']);

			// get the extension of the file in a lower case format
			$extension = getExtension($filename);
			$extension = strtolower($extension);

			$docName = $curTime . "_" . $_FILES['q_prof']['name'];

			if (($extension != "docx") && ($extension != "pdf")) {
				$array = array('status' => '0', 'msg' => 'Invalid file format');
			} else {

				$target_file = $target_path . $docName;

				if (move_uploaded_file($_FILES['q_prof']["tmp_name"], $target_file)) {

					$insertQuery = "INSERT INTO gc_careers_requests SET job_title='$q_jb',name='$q_fn', contact_no='$q_m', email_address='$q_em', remarks='$q_msg', request_date='$curDate', status='1', profile_doc='$docName'";
					if ($conn->query($insertQuery) === TRUE) {
						$array = array('status' => '1', 'msg' => 'Thank for writing us, we will contact to you soon.');
						sendCareerMail($q_fn, $q_msg, $q_em);
					} else {
						$filePath = $target_path . $docName;
						$array = array('status' => '0', 'msg' => 'Something went wrong');
						unlink($filePath);
					}
				} else {
					$array = array('status' => '0', 'msg' => 'Something went wrong');
				}
			}
		} else {
			$array = array('status' => '0', 'msg' => 'Please upload your resume');
		}
	}
}

echo json_encode($array);