invisio v2.0

<?php	
	session_start();
	
	ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);
	
	$empids = $_POST['emp'];
	
	include('config.php');
	
	$resultz = $js->prepare('SELECT * FROM `employees` WHERE empid = :empids');
	$resultz->execute(array(':empids' => $empids));
	
	while($rowz = $resultz->fetch(PDO::FETCH_ASSOC)) 
	{
		$empname = $rowz['empname'];	
		$desig = $rowz['desig'];
		$dept = $rowz['dept'];
	}
	
	$cname = $_POST['cname'];
	$phone = $_POST['phone'];
	$location = $_POST['location'];
	$email = $_POST['email'];
	$addemail = $_POST['addemail'];
	$prefdest = $_POST['prefdest'];
	$plandate = $_POST['plandate'];
	$days = $_POST['days'];
	$countryfrom = $_POST['countryfrom'];
	$pax = $_POST['pax'];
	$nation = $_POST['nation'];
	$category = $_POST['category'];
	$ptype = $_POST['ptype'];
	$services = $_POST['services'];
	$remarks = $_POST['remarks'];
	
	$stat = $_POST['stats'];
	
	$enquirystatus = 'Pending';
	
	date_default_timezone_set('Asia/Muscat');
 	$de = date('Y-m-d  H:i:s');
	$entry = date('Y-m-d');
	
	$day = date('d');
	$month = date('m');
	$year = date('Y');
	
	$result = $js->query('SELECT * FROM `customer_entry` ORDER BY `id`');
	$result->execute();
	$cc = $result->rowCount();
	
	if($cc == '0')
	{
		$nw = $cc;	
	}
	else
	{
	  while($row = $result->fetch(PDO::FETCH_ASSOC)) 
	  {
		  $nw = $row['custid'];
	  }
	}
	if($cc == '0')
	{
		$sno = $nw + 1;
	}
	else
	{
		$sub = substr($nw,11);
		$sno = $sub + 1;
	}
	 if($sno > '0' && $sno < '10')
	  {
			$custid = 'FET'.$day.$month.$year.'0000'.$sno; 
	  }
	  elseif($sno >= '10' && $sno < '100')
	  {
			$custid = 'FET'.$day.$month.$year.'000'.$sno; 
	  }
	  elseif($sno >= '100' && $sno < '1000')
	  {
			$custid = 'FET'.$day.$month.$year.'00'.$sno; 
	  }
	  elseif($sno >= '1000' && $sno <= '10000')
	  {
			$custid = 'FET'.$day.$month.$year.'0'.$sno; 
	  }
	  
	 // echo $custid;

$sql = $js->prepare('INSERT INTO `customer_entry` (`custid`, `entrydate`, `custname`, `location`, `phone`, `email`, `prefdest`, `plannningdate`, `daysplanning`, `countryfrom`, `pax`, `nationality`, `category`, `ptype`, `services`, `remarks`, `status`, `enteredby`, `addedat`, `enquirystatus` ) VALUES (:custid, :entry, :cname, :location, :phone, :email, :prefdest, :plandate, :days, :countryfrom, :pax, :nation, :category, :ptype, :services, :remarks, :stat, :empids, :de, :enquirystatus)');
			$statuss = $sql->execute(array(':cname' => $cname,
											':custid' => $custid,
											':entry' => $entry, 
											':plandate' => $plandate,
											':prefdest' => $prefdest,
											':location' => $location,
											':phone' => $phone, 
											':email' => $email,
											':days' => $days,
											':countryfrom' => $countryfrom,
											':pax' => $pax,
											':nation' => $nation,
											':category' => $category, 
											':ptype' => $ptype,
											':services' => $services, 
											':remarks' => $remarks,
											':stat' => $stat,
											':empids' => $empids,
											':de' => $de,
											':enquirystatus' => $enquirystatus)); 
										
require("PHPMailer/class.phpmailer.php");
			require("PHPMailer/class.smtp.php");
			require("language/phpmailer.lang-en.php");

$your_smtp = "relay-hosting.secureserver.net"; 
			$your_smtp_user = "support@thefalconexpeditions.com";
			$your_smtp_pass = "Falcon@1234";
			
			$mail = new PHPmailer();
			$mail->From = 'support@thefalconexpeditions.com';
			$mail->FromName = 'The Falcon Expeditions - Travel Planners of Oman';
			
			$mail->Host = $your_smtp;
			//$mail->Mailer   = "smtp";
			$mail->Port = 25;
			$mail->SMTPAuth = false;
			$mail->SMTPSecure = false;
        	$mail->IsHTML(true);

$mail->Password = $your_smtp_pass;
			$mail->Username = $your_smtp_user;

$mail->AddAddress($email, $cname);
			if($addemail != ' ')
			{
				$mail->AddCC($addemail, $cname);
			}
			$mail->AddCC('james@thefalconexpeditions.com', 'James - The Falcon Expeditions');
			$mail->AddCC('khalid@thefalconexpeditions.com', 'Khalid - The Falcon Expeditions');
			$mail->AddBCC('marketing@thefalconexpeditions.com', 'Sales - The Falcon Expeditions');
			$mail->AddBCC('support@thefalconexpeditions.com', 'Sales - The Falcon Expeditions');
			$mail->AddBCC('seeonsoft@gmail.com', 'The Falcon Expeditions');
			
			//$mail->AddEmbeddedImage('images/falconlogo.png', 'logo');

$mail->Subject = "Holiday enquiry for $prefdest : Customer ID $custid";	
					
	
$comments = "
<html>
<head><link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css'></head>

<body style='color:#0B5394;'>";

/*<div align='left' ><img src=\"cid:logo\" alt='THE FALCON EXPEDITIONS' /></div>*/

$comments .= "<div align='justify'>
 Dear $cname, <br>
 <br>
 
Warm Greetings from The Falcon Expeditions ! <br>

<p style='text-align: justify;'>Thank you for contacting us for your <b>Holidays to $prefdest</b>, we have received your enquiry and a <b>Customer ID $custid</b> has been generated for your query. You are requested to mention the  Customer ID when replying to us to enable us to serve you better.</p>

<p><a href='https://www.google.com/search?q=the+falcon+expeditions+muscat+reviews&oq=the+fa&gs_lcrp=EgZjaHJvbWUqBggAEEUYOzIGCAAQRRg7MgcIARAAGIAEMgcIAhAuGIAEMgcIAxAuGIAEMgYIBBBFGDwyBggFEEUYPDIGCAYQRRhBMgYIBxBFGEHSAQg1ODU3ajBqN6gCALACAA&sourceid=chrome&ie=UTF-8#lrd=0x3e91ffd782d5c911:0xe6e9a16d4d8b8e16,1,,,,'><strong>Reviews of Falcon Expeditions</strong></a></p>

<p style='text-align: justify;'> Very shortly, one of our Holiday Consultant will contact you to discuss about your travel plans. If you are in need of urgent assistance, <a href='https://wa.me/message/EAEH3TTMBWFEO1'> click here to connect on Whatsapp to our Customer Support helpline </a>,  Our team members are available round-the-clock and are happy to help you to plan a suitable holiday. </p>

</div>
<p align='center'><a href='https://thefalconexpeditions.com/FALCON EXPEDITIONS DMC BROCHURE.pdf' target='_blank' style='color:#D19E2A'><h4 align='center'>Click here to know about Oman Tourism !</h4></a></p>

We have an excellent customer base that has benefited from our cooperation, and we are keen to have you added to that list!<br><br>

</div>
<p style='text-align: justify;'>Happy Holidaying!<br></p>

Warm Regards, <br><br>

FALCON EXPEDITIONS TRADE LLC. <br>

Po Box: 102 , Postal Code: 114 <br>
Muscat, Sultanate of Oman <br>

Contact: +968 7719 0959 | +968 941 55255 <br>

Email: <a href='mailto:support@thefalconexpeditions.com'>support@thefalconexpeditions.com</a> | <a href='https://thefalconexpeditions.com/'>www.thefalconexpeditions.com</a> <br> 
</div>

</body>
</html>";
			/*echo $mail->Body = $comments;
		
		
         if (!$mail->Send()) {
             echo "<p>There was an error in sending mail, please try again at a later time</p>".$mail->ErrorInfo;
         } else {
        ?>
                <script type="text/javascript">
              alert("Have send mail successfully !! ");
			  window.open("view_detailedenquiry.php?custid=<?php echo $custid?>"); 
				window.location = 'add_customer.php';	
				</script>
                <?php
                   echo "<p>Mail has been sent to $attn.</p>";
           }
           $mail->ClearAddresses();
           $mail->ClearAttachments();
*/

// To send HTML mail, the Content-type header must be set
$headers[] = 'MIME-Version: 1.0';
$headers[] = 'Content-type: text/html; charset=iso-8859-1';
$subject = 'Holiday enquiry for '.$prefdest.' : Customer ID '.$custid;
$to = $email;

// Additional headers
$headers[] = 'To: '.$cname.' <'.$email.'>';
$headers[] = 'From: Falcon Expeditions <support@thefalconexpeditions.com>';
$headers[] = 'Cc: james@thefalconexpeditions.com';
$headers[] = 'BCc: support@thefalconexpeditions.com';

// Mail it
mail($to, $subject, $comments, implode("\r\n", $headers));
			
			
			
?>
<script type="text/javascript">
              alert("Have send mail successfully !! ");
			  window.open("view_detailedenquiry.php?custid=<?php echo $custid?>"); 
				window.location = 'add_customer.php';	
				</script>