<? session_start(); ?>
<?	
include("config/data.config.php");
include("$LIB_DIR/functions.library.php");
include("$LIB_DIR/class.database.php");
include("$LIB_DIR/data.constant.php");
include("$LIB_DIR/includes.php");

$db=new DbConnect($DB_HOST, $DB_USERNAME, $DB_PASSWORD, $DB_NAME, $DB_REPORT_ERROR, $DB_PERSISTENT_CONN);
$db->open() or die($db->error());


$pageid = $_REQUEST['pid'];
$pagename = $_REQUEST['pname'];
getProjectDetail($pageid,$pagename,$db);
getProjectContentDetail($pageid,$pagename,$db);
getPages($pageid,$pagename,$db);
if($pagename)
{
$pagenameVal  = str_replace("-"," ", $pagename);
}

if(isset($_POST['Register'])){
	$NAME= $_POST['txt_name'];
	$EMAIL= $_POST['txt_email'];
	$PHONE= $_POST['txt_phone'];
	$CITY= $_POST['txt_city'];
	$MSG= $_POST['txt_comments'];
	$PID= $_POST['project_id'];
	$PTITLE= $_POST['project_title'];
	$TYPE="enquiry-project";
	$IP = getenv("REMOTE_ADDR");
	$CREATED_AT = strtotime("now");
	
	//receiver 
	$to = "info@builderflight.com";
	// subject of the mail
	$subject = "$NAME is intrested in $PTITLE";
	// from mail
	$from1 = "From:$EMAIL \r\n";
	// setting message which will sent to the e-mail
	//------------------------------------------------
	$message = "Enquiry on builderflight.com via Project Page \n
	IP - Address: $IP \n
	Name : $NAME \n
	Email Id : $EMAIL \n
	Project Id : $PID \n
	Project Name : $PTITLE \n
	Contact : $PHONE \n
	City : $CITY \n 
	Comments : $MSG \n";
	// mail script send through the server
	mail($to,$subject,$message,$from1);
	// Echo " Thanks we will get back soon";
	$message1="Thanks $NAME, For your your interest in $PTITLE. You will get a call back from us within next 24 hours.\n\n
	Thanks \n
	BuilderFlight Team \r
	Contact : +91 1204247021
	E-Mail : info@builderflight.com
	F-4, D-242,Sector-63, Noida";
	$subject1 = "Thanks for contacting us Mr/Mrs $NAME";
	$from2="From:$to \r\n";
	mail($from1,$subject1,$message1,$from2);
	addQuerytoDataBase($NAME,$EMAIL,$PHONE,$CITY,$MSG,$TYPE,$IP,$PID,$PTITLE,$CREATED_AT,$db);

}

if($_SESSION['SESS_v_siteuser'])
{
$TOPBAR		= ReadTemplate("$TEMPLATE_DIR/common/topbar_login.html");
}
else
{
$TOPBAR		= ReadTemplate("$TEMPLATE_DIR/common/topbar_project.html");
}

$PAGE_CONTENTS	= ReadTemplate("$TEMPLATE_DIR/project.html");
//$LEFT_CONTENTS	= ReadTemplate("$TEMPLATE_DIR/common/project_leftbar.html");
//$BOTTOMBAR	= ReadTemplate("$TEMPLATE_DIR/common/project_bottombar.html");
$SUB_TEMPLATE	= ReadTemplate("$TEMPLATE_DIR/common/sub_template_project.html");
$TEMPLATE		= ReadTemplate("$TEMPLATE_DIR/common/project_template.html");

ReplaceContent(Array("TOPBAR", "BOTTOMBAR","LEFT_CONTENTS", "PAGE_CONTENTS", "SUB_TEMPLATE", "TEMPLATE"));
print $TEMPLATE;
flush();

function getPages($pageid,$pagename,$db)
{	global $NEWS_HEADLINES, $MAP_VROOT_PATH, $IMG_DIR, $DOCUMENT_ROOT, $NEWS_PIC_DIR, $GRID1, 	$GRID2,$GRIDLIST,$GRIDLIST1, $TEMPLATE_DIR;
	global 	$v_location,$v_newspaper,$d_newsDate,$developer_title,$profle,$pagename,$i_newsID,$LIST;
   
   /*if($pagename){
	$v_pgTitleArr = explode("_",$pagename);
	if(count($v_pgTitleArr) >1)
	{
		$pagenameStr = implode(" ",$v_pgTitleArr);
		$pagenameStr = strtoupper($pagenameStr);
	}
   else
   {
	$pagenameStr = strtoupper($pagename);
   }
   }
   */
   $pidDecode = base64_decode($pageid);
   if($pidDecode)
   {
	$pidDecodeArr = explode("_",$pidDecode);
	$pidVal = $pidDecodeArr[1];
   }
   
   $query2="select * from tbl_developers where developer_id ='$pidVal'";
   $db->query($query2);
   $total = $db->num_rows();
   if($total >0){
   $row = $db->fetch_array();
   $developer_title = ucfirst($row[developer_title]);
    $profle = $row[profle];
   }
   else
   {
		 $pagename = "Error";
		 $PAGE = "No Page Found!";
   }
}


function getProjectDetail($pageid,$pagename,$db)
{
	global $PROJECT_LOGO,$display_location,$TOP_LEFT_VAL,$display_price,$acc,$pidVal,$project_title,$AMENTIES,$AMENTIES1, $LAT, $LONG;
   $pidDecode = base64_decode($pageid);
   if($pidDecode)
   {
	$pidDecodeArr = explode("_",$pidDecode);
	$pidVal = $pidDecodeArr[1];
   }
   $query2="select * from tbl_project_dtls where project_id ='$pidVal'";
   $db->query($query2);
   $total = $db->num_rows();
   if($total >0){
   $TOP_LEFT_VAL = "";
   $row = $db->fetch_array();
   $project_title	= ucfirst($row[project_title]);
   $project_id 		= $row[project_id];
   $project_type 	= $row[project_type];
   $project_city 	= $row[project_city];
   $project_location = $row[project_location];
   $project_image 	= $row[project_image];
   $project_logo 	= $row[project_logo];
   $power_backup 	= $row[power_backup];
   $ifms 			= $row[ifms];
   $tower 			= $row[tower];
   $corner_unit 	= $row[corner_unit];
   $display_location 	= $row[display_location];
   $LAT		=  	($row['latitude'] != '')?$row['latitude']:'';
   $LONG	= 	($row['longitude'] != '')?$row['longitude']:'';
   $display_price	= $row['display_price'];
   $acc = getAccomodation($row);
   
   if(isset($row['amenities']) && $row['amenities'] != '')
   {
	   $amenitiesData	= explode(',', $row['amenities']);
	   $AMENTIES	= '<ul>';
	   $AMENTIES1 	= '<ul>';
	   if(!empty($amenitiesData))
	   {
	   $totalem	= count($amenitiesData);
	   
	   $halfem	= floor($totalem/2);
	   $ii=1;	
	   foreach($amenitiesData as $value)
	   {
	   	if(($halfem) >= $ii)
	   	{
	   	$AMENTIES1 .= "<li style='font-weight:700'>";		 
		  $AMENTIES1 .= ucfirst($value);
		  $AMENTIES1.= "</li>"; 
		  
		 }else{
		 
		  $AMENTIES .= "<li style='font-weight:700'>";		 
		  $AMENTIES .= ucfirst($value);
		  $AMENTIES .= "</li>"; 
		  
		 }
		 $ii++;
		   
	   }
	   $AMENTIES	.= '<ul>';
	   $AMENTIES1	.= '<ul>';
	   
	   }
	   
   }else{
	   
	   $AMENTIES 	= "N/A";
   } 
   
   
   if($project_type == "R")
   {
   $project_type_val = "Residential";
   }
   if($project_type == "C")
   {
    $project_type_val = "Commercial";
   }
   if($project_type == "P")
   {
    $project_type_val = "Plot";
   }
   
   if($project_type){
   $TOP_LEFT_VAL .= "<li><strong>Project Type: </strong>$project_type_val </li>";
   }
    if($tower){
   $TOP_LEFT_VAL .= "<li><strong>Plan: </strong>$tower </li>";
   }
   if($display_price){
   $TOP_LEFT_VAL .= "<li><strong>Price: </strong> $display_price </li>";
   }
   if($display_location){
   $TOP_LEFT_VAL .= "<li><strong>Location: </strong>$display_location </li>";
   }
  
   
   if($project_logo){
   $PROJECT_LOGO = "<img src='$MAP_VROOT_PATH/project_photo/$project_logo'  />";
   }
   
   }
   else
   {
		 $pagename = "Error";
		 $PAGE = "No Page Found!";
   }
}

function getProjectContentDetail($pageid,$pagename,$db)
{
	global $overview,$features,$project_usp,$price_list,$payment_plan,$BROUCHER_CONTENT,$gallery_img1,$gallery_img2,$gallery_img3,$gallery_img4,$gallery_img5,$gallery_img6,$PAY_PLAN_IMG,$PAYMENT_PLAN_IMG, $LAT, $LONG;
	$pidDecode = base64_decode($pageid);
	   if($pidDecode)
	   {
		$pidDecodeArr = explode("_",$pidDecode);
		$pidVal = $pidDecodeArr[1];
	   }
    	   $query2="select * from tbl_project_content where project_id ='$pidVal'";
	   $db->query($query2);
	   $total = $db->num_rows();
	   if($total >0){
	   $TOP_LEFT_VAL = "";
	   $row = $db->fetch_array();
   
    $overview	= $row['overview'];
   $features 		= $row['features'];
   $project_usp 	= $row['project_usp'];
   $price_list 	= $row['price_list'];
   $payment_plan = $row['payment_plan'];
   $brouchre 	= $row['brouchre'];
   $floor_plan_image=json_decode($row['floor_plan_image'], true);
   $payment_plan_image=json_decode($row['payment_plan_image'], true);
   
  
   foreach($floor_plan_image as $value)
	{
	$PAYMENT_PLAN_IMG.='<div class="col-lg-3 col-md-4 col-xs-6 thumb">';
        $PAYMENT_PLAN_IMG.='<a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="/project_photo/'.$value.'"  data-target="#image-gallery">';
        $PAYMENT_PLAN_IMG.='<img class="img-thumbnail" src="/project_photo/'.$value.'" alt="Another alt text">';
        $PAYMENT_PLAN_IMG.='</a>';
        $PAYMENT_PLAN_IMG.='</div>'; 
            
           
	}
	
	foreach($payment_plan_image as $value)
	{
	$PAY_PLAN_IMG.='<div class="col-lg-3 col-md-4 col-xs-6 thumb">';
        $PAY_PLAN_IMG.='<a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="/project_photo/'.$value.'"  data-target="#image-gallery">';
        $PAY_PLAN_IMG.='<img class="img-thumbnail" src="/project_photo/'.$value.'" alt="Another alt text">';
        $PAY_PLAN_IMG.='</a>';
        $PAY_PLAN_IMG.='</div>'; 
         
	
	}
	
		
   if($brouchre)
   {
   $BROUCHER_CONTENT = "<h4>Download Brouchre</h4><a href='$MAP_VROOT_PATH/project_photo/$brouchre' target='_blank'> <img src='$MAP_VROOT_PATH/images/e-brouchre.png' border='0' /> </a><br />";
   }
   
   if(isset($row['gallery_img1']) && $row['gallery_img1'] != '')
   {
   $gallery_img1 	= '<div class="image">   
   <a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="'.$MAP_VROOT_PATH.'/project_photo/'.$row['gallery_img1'].'"  data-target="#image-gallery">
	<img src="'.$MAP_VROOT_PATH.'/project_photo/'.$row['gallery_img1'].'" alt="">
   </a>
   </div>';
   
   }else{
   $gallery_img1 	= '<div class="image">
   <a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="https://freedesignfile.com/upload/2017/07/Warm-home-HD-picture.jpg"  data-target="#image-gallery">
   <img src="https://freedesignfile.com/upload/2017/07/Warm-home-HD-picture.jpg" alt=""></a></div>';   
   
   }
   if(isset($row['gallery_img2']) && $row['gallery_img2'] != '')
   {
   $gallery_img2 	= '<div class="image"><a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="'.$MAP_VROOT_PATH.'/project_photo/'.$row['gallery_img2'].'"  data-target="#image-gallery">
						<img src="'.$MAP_VROOT_PATH.'/project_photo/'.$row['gallery_img2'].'" alt="">
						</a></div>';
   
   }else{
   $gallery_img2 	= '<div class="image">
   <a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="https://freedesignfile.com/upload/2017/07/Warm-home-HD-picture.jpg"  data-target="#image-gallery">
   <img src="https://freedesignfile.com/upload/2017/07/Warm-home-HD-picture.jpg" alt=""></a></div>';   
   
   }
   
   if(isset($row['gallery_img3']) && $row['gallery_img3'] != '')
   {
   $gallery_img3 	= '<div class="image"><a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="'.$MAP_VROOT_PATH.'/project_photo/'.$row['gallery_img3'].'"  data-target="#image-gallery">
						<img src="'.$MAP_VROOT_PATH.'/project_photo/'.$row['gallery_img3'].'" alt="">
						</a></div>';
   
   }else{
   $gallery_img3 	= '<div class="image">
   <a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="https://freedesignfile.com/upload/2017/07/Warm-home-HD-picture.jpg"  data-target="#image-gallery">
   <img src="https://freedesignfile.com/upload/2017/07/Warm-home-HD-picture.jpg" alt=""></a></div>';   
   
   }
   
   if(isset($row['gallery_img4']) && $row['gallery_img4'] != '')
   {
   $gallery_img4 	= '<div class="image"><a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="'.$MAP_VROOT_PATH.'/project_photo/'.$row['gallery_img4'].'"  data-target="#image-gallery">
						<img src="'.$MAP_VROOT_PATH.'/project_photo/'.$row['gallery_img4'].'" alt="">
						</a></div>';
   
   }else{
   $gallery_img4	= '<div class="image">
   <a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="https://freedesignfile.com/upload/2017/07/Warm-home-HD-picture.jpg"  data-target="#image-gallery">
   <img src="https://freedesignfile.com/upload/2017/07/Warm-home-HD-picture.jpg" alt=""></a></div>';   
   
   }
   
   
   if(isset($row['gallery_img5']) && $row['gallery_img5'] != '')
   {
   $gallery_img5 	= '<div class="image"><a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="'.$MAP_VROOT_PATH.'/project_photo/'.$row['gallery_img5'].'"  data-target="#image-gallery">
						<img src="'.$MAP_VROOT_PATH.'/project_photo/'.$row['gallery_img5'].'" alt="">
						</a></div>';
   
   }else{
   $gallery_img5	= '<div class="image">
   <a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="https://freedesignfile.com/upload/2017/07/Warm-home-HD-picture.jpg"  data-target="#image-gallery">
   <img src="https://freedesignfile.com/upload/2017/07/Warm-home-HD-picture.jpg" alt=""></a></div>';   
   
   }
   
   if(isset($row['gallery_img6']) && $row['gallery_img6'] != '')
   {
   $gallery_img6 	= '<div class="image"><a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="'.$MAP_VROOT_PATH.'/project_photo/'.$row['gallery_img6'].'"  data-target="#image-gallery">
						<img src="'.$MAP_VROOT_PATH.'/project_photo/'.$row['gallery_img6'].'" alt="">
						</a></div>';
   
   }else{
   $gallery_img6	= '<div class="image">
   <a class="thumbnail" href="#" data-image-id="" data-toggle="modal" data-title="" data-image="https://freedesignfile.com/upload/2017/07/Warm-home-HD-picture.jpg"  data-target="#image-gallery">
   <img src="https://freedesignfile.com/upload/2017/07/Warm-home-HD-picture.jpg" alt=""></a></div>';   
   
   }
   
   
}
}
function getAccomodation($data){
	if($data['project_type'] == "R")
   {
   $project_type_val = "Residential";
   }
   if($data['project_type'] == "C")
   {
    $project_type_val = "Commercial";
   }
   if($data['project_type'] == "P")
   {
    $project_type_val = "Plot";
   }
	$ret = "";
	if($data){
		$ret .= "<li>BHK <strong>".$data['bhk']."</strong></li>";
		$ret .= "<li>Type <strong>".$project_type_val."</strong></li>";
		$ret .= "<li>Project Completion <strong>".$data['project_completion_year']."</strong></li>";
	}

return $ret;	
}
function addQuerytoDataBase($NAME,$EMAIL,$PHONE,$CITY,$MSG,$TYPE,$IP,$PID,$PTITLE,$CREATED_AT,$db)
{
$query="insert into tbl_query (name,email,mobile,city,msg,type,ip,p_id,p_title,created_at) values ('$NAME','$EMAIL','$PHONE','$CITY','$MSG','$TYPE','$IP','$PID','$PTITLE','$CREATED_AT')";
$db->query($query);
}
?>