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'];
	}
	
	$compname = $_POST['compname'];
	$cname = $_POST['cname'];
	$address = $_POST['address'];
	$phone = $_POST['phone'];
	$location = $_POST['location'];
	$email = $_POST['email'];
	$addemail = $_POST['addemail'];
	$website = $_POST['website'];
	$remarks = $_POST['remarks'];
	$stat = 'MARKETING PAGE';
	
	date_default_timezone_set('Asia/Muscat');
 	$de = date('Y-m-d H:i:s');
	
	$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; 
	 }
	 $entry = date('Y-m-d');

$sql = $js->prepare('INSERT INTO `customer_entry` (`custid`, `entrydate`, `custname`, `companyname`, `address`, `location`, `phone`, `email`, `add_email`, `website`, `remarks`, `status`, `enteredby`, `addedat` ) VALUES (:custid, :entry, :cname, :compname, :address, :location, :phone, :email, :addemail, :website, :remarks, :stat, :empids, :de)');
			$statuss = $sql->execute(array(':cname' => $cname,
											':custid' => $custid,
											':entry' => $entry, 
											':compname' => $compname,
											':address' => $address,
											':location' => $location,
											':phone' => $phone, 
											':email' => $email,
											':addemail' => $addemail,
											':website' => $website,
											':remarks' => $remarks,
											':stat' => $stat,
											':empids' => $empids,
											':de' => $de)); 
										
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 = 'marketing@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->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 = "EXPLORE OMAN WITH THE FALCON EXPEDITIONS";	 
					
	
$comments = "
<html>
<head><link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css'></head>

Warm Greetings from The Falcon Expeditions !

We introduce us, THE FALCON EXPEDITIONS, a DMC for Oman Tourism, founded and managed by a group of tourism enthusiasts with a vision to provide luxury travel and tourism services for expeditioners who are looking to explore the world of travel. We are focused on offering tour operating activities to The Sultanate of Oman, with a strong mission to provide 'Tailor-Made' holiday packages and any kind of tourism service with personalized guidance to our valuable customers, focused on high-end hospitality, value for money, and attention to detail.

Whether you are planning for an Arab Heritage trip, family holiday, romantic retreat, honeymoon package, relaxing cruise, or an adventure activity to explore in Oman or to experience golfing packages or game fishing, special interest packages such as senior citizen tours or women-only tours, business meetings trips, corporate incentive trips for employees and dealers, conference management or exhibition (MICE), our well-experienced and trained tourism consultants can provide proper guidance to choose the best destinations, and we have the expertise to make your dream a hassle-free reality.

</div>
<h3 align='center'> WE SPECIALIZE</h3>

	HOLIDAYS PACKAGES | ADVENTURE TRIPS | HONEYMOON PACKAGES | MICE TRIPS AND EVENTS | EXCLUSIVE FAMILY VACATIONS | GOLF AND GAME FISHING | BUSINESS PARTNERS MEETINGS | WEDDING PACKAGES

<a href='https://thefalconexpeditions.com/FALCON_EXPEDITIONS_INDIA_DMC_BROCHURE.pdf' target='_blank' style='color:#D19E2A'><h4 align='center'>Click here to view our exiting Brochure!</h4></a>

WHY CHOOSE THE FALCON EXPEDITIONS

* Perfect Planning Create your perfect Holidays with the assistance of our experienced Consultants, just share your ideas and plans to us, our team will assist you to make it happen.

* The Secure Venues We work hard to find the best venues with the best facilities in the most popular destinations. Our experts will Consult and choose the best for you.

* Beautiful Memories Book your ever awaited vacation packages with us and create memories that will last a lifetime! We believe that travel is to live, you can Create History!

OUR CULTURE

Freedom &amp; Imagination 
We value individuals and their needs over processes &amp; rules. We want our people to be Creative &amp; freethinkers, that&rsquo;s why we never force them into closed procedures. 
Communication &amp; Interaction

We value continuous communication between us and our customers. A product is only as good as the needs it serves. We always focus on the customer&rsquo;s wants &amp; needs. 
Smart &amp; Agile 
We hire smart and agile people who are forward-looking and want to become leaders in their field. 
Start-up mindset 
We maintain a start-up culture where every employee's opinion is valued &amp; appreciated. We like to challenge ourselves by analyzing any Idea&rsquo;s pros and cons. 
Workplace &amp; lifestyle 
We offer a workplace where everyone can keep a healthy way of life and can truly feel at home. A happy employee is also an efficient and productive one.

OUR VISION 
To be a leading tourism and hospitality service provider by always setting the benchmarks and pioneering best practices of providing boundaryless mindset and approach by thinking beyond constraints and working collaboratively to provide the Power-of-Travel to all expeditioners.

To be a trusted and reliable example of a sustainable tourism development company in the country, by understanding the needs of our customers and ensuring we have the right people on board,&nbsp;by being knowledgeable about our products, services, and the tourism industry to provide what we promised.

OUR MISSION 
To provide luxury experience to our clients through excellent service with personal specialization, using our local knowledge and trips that are socially and environmentally friendly, to meet the wishes of our customers by providing customized luxury travel plans as per choices of their Expeditions.

To plan, organize and execute high quality tourism services for each of our customers based on agreed specifications within the agreed time and at competitive pricing to strive to become leaders in the field of Tourism and Hospitality at all levels, including providing ideas, customization of needs and operating with personalized monitoring.

We have an excellent customer base that has benefited from our cooperation, and we are keen to have you added to that list! 
We thank you for your valuable time for knowing our services, we are looking forward to serving you with your upcoming travel needs.

</div>

Regards,

RIDDHESH RAJENDRA VANARASE 
SALES & MARKETING MANAGER 
FALCON EXPEDITIONS INDIA 
17/63/1, Vivekanand Colony 
Ichalkaranji, Maharashtra - 416 115 
Contact : +91 7420 828 610 
Email: <a href='mailto:salesindia@thefalconexpeditions.com'>salesindia@thefalconexpeditions.com</a> | <a href='https://thefalconexpeditions.com/'>www.thefalconexpeditions.com</a>

HEAD OFFICE 
FALCON EXPEDITIONS TRADE LLC. 
Po Box: 102 , Postal Code: 114, Muscat, Sultanate of Oman 
</div>

</body>
</html>";
$to = $email;
			echo $mail->Body = $comments;
		// 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 = 'EXPLORE OMAN WITH THE FALCON EXPEDITIONS';
$to = $email;

// Additional headers
$headers[] = 'To: '.$cname.' <'.$email.'>';
if($addemail != '')
			{
				$headers[] = 'Cc: '.$cname.' <'.$addemail.'>';
			}
$headers[] = 'From: Falcon Expeditions <support@thefalconexpeditions.com>';

$headers[] = 'Cc: salesindia@thefalconexpeditions.com';
$headers[] = 'Cc: naval@thefalconexpeditions.com';
$headers[] = 'Cc: mandar@thefalconexpeditions.com';
$headers[] = 'Cc: james@thefalconexpeditions.com'; 
$headers[] = 'Cc: khalid@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.location = 'add_marketing_customer.php'</script>