<?php 
ob_start();
session_start();
//include_once("../connect/helper.php");

include_once("rush/rush2017/backend/connect/helper.php");

date_default_timezone_set('Asia/Kolkata');
$today = date("Y-m-d H:i:s");
//echo "<pre>";print_r($_REQUEST);die;
//step2
$sentid = $_REQUEST['sentid']; 
//print_r($_REQUEST);die;
$title66 = $_REQUEST['title66']; //step2
$forenames66 = $_REQUEST['forenames66'];
$surname66 = $_REQUEST['surname66'];


if($_POST['DepartureDatep66']!=''){
$DepartureDatep66 = date('Y-m-d', strtotime(($_POST['DepartureDatep66'])));
}else{
$DepartureDatep66= '0000-00-00';
}

//$DepartureDatep66 = $_POST['DepartureDatep66'];
//echo $DepartureDatep66; die;
$address66 = $_REQUEST['address66'];
$newpincode1= $_REQUEST['newpincode1'];
$newpincode2= $_REQUEST['newpincode2'];
$Tel66 = $_REQUEST['Tel66'];
$mobile66 = $_REQUEST['mobile66'];
$email66 = $_REQUEST['email66'];
$title166 = $_REQUEST['title166'];
$forenames166 = $_REQUEST['forenames166'];
$surname166 = $_REQUEST['surname166'];
if($_POST['DepartureDates66']!=''){
$DepartureDates66 = date('Y-m-d', strtotime(($_POST['DepartureDates66'])));
}else{
$DepartureDates66 = '0000-00-00';
}
//$DepartureDates66 = $_POST['DepartureDates66'];
$address166 = $_REQUEST['address166'];
$tel166 = $_REQUEST['tel166'];
$mobile166 = $_REQUEST['mobile166'];
$email166 = $_REQUEST['email166'];
$bank66 = $_REQUEST['bank66'];
$sortcode66 = $_REQUEST['sortcode66'];
$accountno66 = $_REQUEST['accountno66'];
$namesonAccount66 = $_REQUEST['namesonAccount66'];
$value666 = $_REQUEST['value666'];


$selsent_name=$obj->select("username","tbllandformsdetails","id='$sentid'");
$esentname=$selsent_name[0][0];

/*$insert_step2 = $obj->my_insert("tbllandlord","title,forenames,surname,ukdeparturedate,address,tel,mobile,email,
title1,forenames1,surname1,ukdeparturedate1,address1,tel1,mobile1,email1,bank,sortCode,accountNo,namesonAccount,hmrcapproval",
"'$title66','$forenames66','$surname66','$DepartureDatep66','$address66','$Tel66','$mobile66','$email66','$title166','$forenames166',
'$surname166','$DepartureDates66','$address166','$tel166','$mobile166','$email166','$bank66','$sortcode66','$accountno66',
'$namesonAccount66','$value666'");
*/


$first_time= $obj->select("*","tbllandlord","linksent_id='$sentid'");
//print_r($first_time);
$datet1= date("Y-m-d", strtotime($DepartureDatep66) );
$datet2=date("Y-m-d", strtotime($DepartureDates66) );
if($first_time=='no')
{

$insert_step5 = $obj->my_insert("tbllandlord","linksent_id,title,forenames,surname,ukdeparturedate,address,tel,mobile,email,
title1,forenames1,surname1,ukdeparturedate1,address1,tel1,mobile1,email1,bank,sortCode,accountNo,namesonAccount,hmrcapproval,newpincode1,newpincode2","'$sentid','$title66','$forenames66','$surname66','$datet1','$address66','$Tel66','$mobile66','$email66','$title166','$forenames166',
'$surname166','$datet2','$address166','$tel166','$mobile166','$email166','$bank66','$sortcode66','$accountno66',
'$namesonAccount66','$value666','$newpincode1','$newpincode2'");

	$insertdata1 = $obj->my_insert("tbllandlord2","landlordformid","'$insert_step5'");	
		
//$update_pass = $obj->update("tbllandformsdetails","status='received',received_date='$today'","id='$sentid'");
}
else{
	$second_time= $obj->select("id","tbllandlord","linksent_id='$sentid' ");
	$secondtimeid=$second_time[0][0];


$datet1= date("Y-m-d", strtotime($DepartureDatep66) );
$datet2=date("Y-m-d", strtotime($DepartureDates66) );
	//echo $DepartureDates66.$DepartureDatep66;
	

$update_first_table = $obj->update("tbllandlord","title='$title66',forenames='$forenames66',surname='$surname66',ukdeparturedate='$datet1',address='$address66',tel='$Tel66',mobile='$mobile66',email='$email66',
title1='$title166',forenames1='$forenames166',surname1='$surname166',ukdeparturedate1='$datet2',address1='$address166',tel1='$tel166',mobile1='$mobile166',email1='$email166',bank='$bank66',sortCode='$sortcode66',accountNo='$accountno66',namesonAccount='$namesonAccount66',hmrcapproval='$value666',newpincode1='$newpincode1',newpincode2='$newpincode2'","id='$secondtimeid'");


}


	echo 1;
?>