<?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");

//step2
$sentid = $_REQUEST['sentid']; 
//print_r($sentid);die;
$title66 = $_REQUEST['title66']; //step2
$forenames66 = $_REQUEST['forenames66'];
$surname66 = $_REQUEST['surname66'];
//$DepartureDatep66 = date('Y-m-d', strtotime(($_POST['DepartureDatep66'])));
$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'];
$DepartureDates66 = date('Y-m-d', strtotime(($_POST['DepartureDates66'])));
$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'];
$property1 = $_REQUEST['Property1'];

$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'");
*/


$address2 = $_REQUEST['address2']; //showstep2
$PostCode = $_REQUEST['PostCode'];
$Property_Landline_No = $_REQUEST['Property_Landline_No'];
$Example = $_REQUEST['Example'];
$Example1 = $_REQUEST['Example1'];
$Example2 = $_REQUEST['Example2'];
$Landline_No = $_REQUEST['Landline_No'];
$Property = $_REQUEST['Property'];
$Media_provider = $_REQUEST['Media_provider'];
$value1 = $_REQUEST['value1'];
$How_Many = $_REQUEST['How_Many'];
$value2 = $_REQUEST['value2'];
$authorised_keyholder = $_REQUEST['authorised_keyholder'];
$Alarm_Details = $_REQUEST['Alarm_Details'];
$Contract_No = $_REQUEST['Contract_No'];
$value3 = $_REQUEST['value3'];
$value4 = $_REQUEST['value4'];
$Code1 = $_REQUEST['Code1'];
$Code2 = $_REQUEST['Code2'];
$Masterpass = ($_REQUEST['Masterpass']);
$Location = $_REQUEST['Location'];
$Service_Contractor = $_REQUEST['Service_Contractor'];
$Property_Landline_No1 = $_REQUEST['Property_Landline_No1'];
$Property_Landline_No2 = $_REQUEST['Property_Landline_No2'];
$value5 = $_REQUEST['value5'];


/*insert_data = $obj->my_insert("tbllandlord","address_property,postcode,propertyland_no,example1,example2,example3,landline_no,property,mediaprovider,value1,how_many,value2,authorised_key,alarm_details,contract_no,value3,value4,code1,code2,masterpass,location,service_cont,propertyLandlineNo1,propertyLandlineNo2,value5",
"'$address2','$PostCode','$Property_Landline_No','$Example','$Example1','$Example2','$Landline_No','$Property','$Media_provider'
,'$value1','$How_Many','$value2','$authorised_keyholder','$Alarm_Details','$Contract_No','$value3','$value4','$Code1','$Code2',
'$Masterpass','$Location','$Service_Contractor','$Property_Landline_No1','$Property_Landline_No2','$value5'");
*/


$namestep41 = $_REQUEST['namestep41']; //showstep3
$namestep42 = $_REQUEST['namestep42'];
$addresstep41 = $_REQUEST['addresstep41'];
$addresstep42 = $_REQUEST['addresstep42'];
$postcodestep41 = $_REQUEST['postcodestep41'];
$postcodestep42 = $_REQUEST['postcodestep42'];
$phonestep41 = $_REQUEST['phonestep41'];
$phonestep42 = $_REQUEST['phonestep42'];
$emailstep1 = $_REQUEST['emailstep1'];
$emailstep2 = $_REQUEST['emailstep2']; // done

$interviewradiostep41 = $_REQUEST['interviewradiostep41'];
$interviewradiostep42 = $_REQUEST['interviewradiostep42'];
$interviewradiostep43 = $_REQUEST['interviewradiostep43'];
$interviewradiostep44 = $_REQUEST['interviewradiostep44'];
$interviewradiostep45 = $_REQUEST['interviewradiostep45'];
$interviewradiostep46 = $_REQUEST['interviewradiostep46'];

$claimsstep41 = $_REQUEST['claimsstep41'];
$claimsstep42 = $_REQUEST['claimsstep42'];

$interviewradiostep47 = $_REQUEST['interviewradiostep47'];
$interviewradiostep48 = $_REQUEST['interviewradiostep48']; //done
$Sumstep41 = $_REQUEST['Sumstep41'];
$Sumstep42 = $_REQUEST['Sumstep42'];
$Agestep41 = $_REQUEST['Agestep41'];
$Currentstep41 = $_REQUEST['Currentstep41'];
$Amountstep41 = $_REQUEST['Amountstep41'];

$interviewradiostep49 = $_REQUEST['interviewradiostep49'];
$interviewradiostep410 = $_REQUEST['interviewradiostep410'];


/*$insert_step4 = $obj->my_insert("tbllandlord","name1,name2,addresstep41,addresstep42,postcode1,postcode2,phone_no1,phone_no2,
emailstep1,emailstep2,radiostep41,radiostep42,radiostep43,radiostep44,radiostep45,radiostep46,claims1,claims2,radiostep47,
radiostep48,Sumstep41,Sumstep42,Agestep41,Currentstep41,Amountstep41,radiostep49,radiostep410","'$namestep41','$namestep42','$addresstep41','$addresstep42','$postcodestep41','$postcodestep42',
'$phonestep41','$phonestep42','$emailstep1','$emailstep2','$interviewradiostep41','$interviewradiostep42','$interviewradiostep43','$interviewradiostep44',
'$interviewradiostep45','$interviewradiostep46','$claimsstep41','$claimsstep42','$interviewradiostep47','$interviewradiostep48',
'$Sumstep41','$Sumstep42','$Agestep41','$Currentstep41','$Amountstep41','$interviewradiostep49','$interviewradiostep410'");
*/

$Gasstep5 = $_REQUEST['Gasstep5']; //showstep4
$Electricstep5 = $_REQUEST['Electricstep5'];
$Waterstep5 = $_REQUEST['Waterstep5'];
$Meterstep51 = $_REQUEST['Meterstep51'];
$Meterstep52 = $_REQUEST['Meterstep52'];
$Meterstep53 = $_REQUEST['Meterstep53'];
$Locationstep51 = $_REQUEST['Locationstep51'];
$Heatingstep5 = $_REQUEST['Heatingstep5'];
$Boilerstep51 = $_REQUEST['Boilerstep51'];
$Boilerstep52 = $_REQUEST['Boilerstep52'];
$Locationstep52 = $_REQUEST['Locationstep52'];
$Hotstep51 = $_REQUEST['Hotstep51'];

$interviewradiostep51 = $_REQUEST['interviewradiostep51'];

$Locationstep53 = $_REQUEST['Locationstep53'];
$Locationstep54 = $_REQUEST['Locationstep54'];

$interviewradiostep52 = $_REQUEST['interviewradiostep52'];

$Locationstep55 = $_REQUEST['Locationstep55'];
$Annualstep51 = $_REQUEST['Annualstep51'];
$Servicestep52 = $_REQUEST['Servicestep52'];
$Datestep51 = $_REQUEST['Datestep51'];
$Homecarestep51 = $_REQUEST['Homecarestep51'];
$Homecarestep52 = $_REQUEST['Homecarestep52'];
$Installationsstep51 = $_REQUEST['Installationsstep51'];
$inspectionsstep51 = $_REQUEST['inspectionsstep51'];
$testingstep51 = $_REQUEST['testingstep51'];
$Periodicstep51 = $_REQUEST['Periodicstep51'];

$interviewradiostep53 = $_REQUEST['interviewradiostep53'];
$interviewradiostep54 = $_REQUEST['interviewradiostep54'];
$interviewradiostep55 = $_REQUEST['interviewradiostep55'];
$interviewradiostep56 = $_REQUEST['interviewradiostep56'];


$plumber = $_REQUEST['plumber'];
$Heating_engineer = $_REQUEST['Heating_engineer'];
$Electrician = $_REQUEST['Electrician'];
$Carpenter = $_REQUEST['Carpenter'];
$Decorator = $_REQUEST['Decorator'];
$Handyman = $_REQUEST['Handyman'];
$Gardener = $_REQUEST['Gardener'];
$other = $_REQUEST['other'];
$contractors = $_REQUEST['contractors'];
$contractors_text = $_REQUEST['contractors_text'];

$company1 = $_REQUEST['company1'];
$company2 = $_REQUEST['company2'];
$company3 = $_REQUEST['company3'];
$company4 = $_REQUEST['company4'];
$company5 = $_REQUEST['company5'];
$company6 = $_REQUEST['company6'];
$company7 = $_REQUEST['company7'];
$company8 = $_REQUEST['company8']; 

$email1 = $_REQUEST['email1'];
$email2 = $_REQUEST['email2'];
$email3 = $_REQUEST['email3'];
$email4 = $_REQUEST['email4'];
$email5 = $_REQUEST['email5'];
$email6 = $_REQUEST['email6'];
$email7 = $_REQUEST['email7'];
$email8 = $_REQUEST['email8']; 

$mobile1 = $_REQUEST['mobile1'];
$mobile2 = $_REQUEST['mobile2'];
$mobile3 = $_REQUEST['mobile3'];
$mobile4 = $_REQUEST['mobile4'];
$mobile5 = $_REQUEST['mobile5'];
$mobile6 = $_REQUEST['mobile6'];
$mobile7 = $_REQUEST['mobile7'];
$mobile8 = $_REQUEST['mobile8'];

$tel1 = $_REQUEST['tel1'];
$tel2 = $_REQUEST['tel2'];
$tel3 = $_REQUEST['tel3'];
$tel4 = $_REQUEST['tel4'];
$tel5 = $_REQUEST['tel5'];
$tel6 = $_REQUEST['tel6'];
$tel7 = $_REQUEST['tel7'];
$tel8 = $_REQUEST['tel8'];


$electricity_supplier = $_REQUEST['electricity_supplier'];
$gas_supplier = $_REQUEST['gas_supplier'];
$water_supplier = $_REQUEST['water_supplier'];
$council_tax = $_REQUEST['council_tax'];
$sewage = $_REQUEST['sewage'];
$refuse_collected = $_REQUEST['refuse_collected'];
$drainage = $_REQUEST['drainage'];
$saniflo_location = $_REQUEST['saniflo_location'];
$account_no1 = $_REQUEST['account_no1'];
$telno_no1 = $_REQUEST['telno_no1'];
$provider1 = $_REQUEST['provider1'];
$account_no2 = $_REQUEST['account_no2'];
$telno_no2 = $_REQUEST['telno_no2'];
$provider2 = $_REQUEST['provider2'];
$installation_property = $_REQUEST['installation_property'];


$WashingMachine = $_REQUEST['WashingMachine'];
$Washingage = $_REQUEST['Washingage'];
$manual1 = $_REQUEST['manual1'];
$guarantee1 = $_REQUEST['guarantee1'];
$Washing1 = $_REQUEST['Washing1'];

$Dryer = $_REQUEST['Dryer'];
$Dryerage = $_REQUEST['Dryerage'];
$manual2 = $_REQUEST['manual2'];
$guarantee2 = $_REQUEST['guarantee2'];
$Dryer1 = $_REQUEST['Dryer1'];


$Washer = $_REQUEST['Washer'];
$Washerage = $_REQUEST['Washerage'];
$manual3 = $_REQUEST['manual3'];
$guarantee3 = $_REQUEST['guarantee3'];
$Washer1 = $_REQUEST['Washer1'];


$Dish = $_REQUEST['Dish'];
$Dishage = $_REQUEST['Dishage'];
$manual4 = $_REQUEST['manual4'];
$guarantee4= $_REQUEST['guarantee4'];
$Dish1 = $_REQUEST['Dish1'];

$Cooker = $_REQUEST['Cooker'];
$Cookerage = $_REQUEST['Cookerage'];
$manual5 = $_REQUEST['manual5'];
$guarantee5 = $_REQUEST['guarantee5'];
$Cooker1 = $_REQUEST['Cooker1'];

$Oven = $_REQUEST['Oven'];
$Ovenage = $_REQUEST['Ovenage'];
$manual6 = $_REQUEST['manual6'];
$guarantee6 = $_REQUEST['guarantee6'];
$Oven1 = $_REQUEST['Oven1'];

$Hob = $_REQUEST['Hob'];
$Hobage = $_REQUEST['Hobage'];
$manual7 = $_REQUEST['manual7'];
$guarantee7 = $_REQUEST['guarantee7'];
$Hob1 = $_REQUEST['Hob1'];

$MicroWave = $_REQUEST['MicroWave'];
$MicroWaveage = $_REQUEST['MicroWaveage'];
$manual8 = $_REQUEST['manual8'];
$guarantee8 = $_REQUEST['guarantee8'];
$MicroWave1 = $_REQUEST['MicroWave1'];

$Fridge = $_REQUEST['Fridge'];
$Fridgeage = $_REQUEST['Fridgeage'];
$manual9 = $_REQUEST['manual9'];
$guarantee9 = $_REQUEST['guarantee9'];
$Fridge1 = $_REQUEST['Fridge1'];


$Refrigderator = $_REQUEST['Refrigderator'];
$Refrigderatorage = $_REQUEST['Refrigderatorage'];
$manual10= $_REQUEST['manual10'];
$guarantee10= $_REQUEST['guarantee10'];
$Refrigderator1 = $_REQUEST['Refrigderator1'];

$Freezer = $_REQUEST['Freezer'];
$Freezerage = $_REQUEST['Freezerage'];
$manual11 = $_REQUEST['manual11'];
$guarantee11 = $_REQUEST['guarantee11'];
$Freezer1 = $_REQUEST['Freezer1'];
//print_r($value21);

$Disposal = $_REQUEST['Disposal'];
$Disposalage = $_REQUEST['Disposalage'];
$manual12 = $_REQUEST['manual12'];
$guarantee12 = $_REQUEST['guarantee12'];

$Softener = $_REQUEST['Softener'];
$Softenerage = $_REQUEST['Softenerage'];
$manual13 = $_REQUEST['manual13'];
$guarantee13 = $_REQUEST['guarantee13'];


$pumpage = $_REQUEST['pumpage'];
$pump = $_REQUEST['pump'];
$manual14= $_REQUEST['manual14'];
$guarantee14 = $_REQUEST['guarantee14'];

$Saniflo = $_REQUEST['Saniflo'];
$Sanifloage = $_REQUEST['Sanifloage'];
$manual15= $_REQUEST['manual15'];
$guarantee15= $_REQUEST['guarantee15'];

$Heaters = $_REQUEST['Heaters'];
$Heatersage = $_REQUEST['Heatersage'];
$manual16 = $_REQUEST['manual16'];
$guarantee16 = $_REQUEST['guarantee16'];

$Extractor = $_REQUEST['Extractor'];
$Extractorage = $_REQUEST['Extractorage'];
$manual17 = $_REQUEST['manual17'];
$guarantee17 = $_REQUEST['guarantee17'];

$StorageHeatersage = $_REQUEST['StorageHeatersage'];
$StorageHeaters = $_REQUEST['StorageHeaters'];
$manual18 = $_REQUEST['manual18'];
$guarantee18 = $_REQUEST['guarantee18'];

//print_r($_REQUEST);

//print_r($_FILES['input3']); print_r($_FILES['input33']); //die;


$first_time= $obj->select("*","tbllandlord","linksent_id='$sentid' ");
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,address_property,postcode,propertyland_no,example1,example2,example3,landline_no,property,mediaprovider,value1,how_many,value2,authorised_key,alarm_details,contract_no,value3,value4,code1,code2,masterpass,location,service_cont,propertyLandlineNo1,propertyLandlineNo2,value5,
name1,name2,addresstep41,addresstep42,postcode1,postcode2,phone_no1,phone_no2,emailstep1,emailstep2,radiostep41,radiostep42,radiostep43,radiostep44,radiostep45,radiostep46,claims1,claims2,radiostep47,
radiostep48,Sumstep41,Sumstep42,Agestep41,Currentstep41,Amountstep41,radiostep49,radiostep410,Gasstep5,Electricstep5,Waterstep5,Meterstep51,Meterstep52,Meterstep53,
Locationstep51,Heatingstep5,Boilerstep51,Boilerstep52,Locationstep52,Hotstep51,interviewradiostep51,Locationstep53,Locationstep54,
interviewradiostep52,Locationstep55,Annualstep51,Servicestep52,Datestep51,Homecarestep51,Homecarestep52,Installationsstep51,
inspectionsstep51,testingstep51,Periodicstep51,interviewradiostep53,interviewradiostep54,interviewradiostep55,interviewradiostep56,sentname,property_type,newpincode1,newpincode2","'$sentid','$title66','$forenames66','$surname66','$DepartureDatep66','$address66','$Tel66','$mobile66','$email66','$title166','$forenames166',
'$surname166','$DepartureDates66','$address166','$tel166','$mobile166','$email166','$bank66','$sortcode66','$accountno66',
'$namesonAccount66','$value666','$address2','$PostCode','$Property_Landline_No','$Example','$Example1','$Example2','$Landline_No','$Property','$Media_provider'
,'$value1','$How_Many','$value2','$authorised_keyholder','$Alarm_Details','$Contract_No','$value3','$value4','$Code1','$Code2',
'$Masterpass','$Location','$Service_Contractor','$Property_Landline_No1','$Property_Landline_No2','$value5','$namestep41','$namestep42','$addresstep41','$addresstep42','$postcodestep41','$postcodestep42',
'$phonestep41','$phonestep42','$emailstep1','$emailstep2','$interviewradiostep41','$interviewradiostep42','$interviewradiostep43','$interviewradiostep44',
'$interviewradiostep45','$interviewradiostep46','$claimsstep41','$claimsstep42','$interviewradiostep47','$interviewradiostep48',
'$Sumstep41','$Sumstep42','$Agestep41','$Currentstep41','$Amountstep41','$interviewradiostep49','$interviewradiostep410','$Gasstep5','$Electricstep5','$Waterstep5','$Meterstep51','$Meterstep52','$Meterstep53','$Locationstep51','$Heatingstep5','$Boilerstep51',
'$Boilerstep52','$Locationstep52','$Hotstep51','$interviewradiostep51','$Locationstep53','$Locationstep54','$interviewradiostep52',
'$Locationstep55','$Annualstep51','$Servicestep52','$Datestep51','$Homecarestep51','$Homecarestep52','$Installationsstep51',
'$inspectionsstep51','$testingstep51','$Periodicstep51','$interviewradiostep53','$interviewradiostep54','$interviewradiostep55','$interviewradiostep56','$esentname','$property1','$newpincode1','$newpincode2'");

$insertdata1 = $obj->my_insert("tbllandlord2","Plumber,Company1,Tel1,Mobile1,Email1,Heating_Engineer,Company2,Tel2,Mobile2,Email2,Electrician,
		                                             Company3,Tel3,Mobile3,Email3,Carpenter,Company4,Tel4,Mobile4,Email4,Decorator,Company5,Tel5,Mobile5,
													 Email5,Handyman,Company6,Tel6,Mobile6,Email6,Gardener,Company7,Tel7,Mobile7,Email7,Other,Company8,Tel8,
													 Mobile8,Email8,f_info,info_text,e_supplier,g_supplier,w_supplier,c_tax,sewage,refuseday,drainage,installation,
													 saniflo_location,account_no_line_1,tel_no_line_1,provider1,account_no_line_2,tel_no_line_2,provider2,w_machine,
													 dryer,washer_dryer,d_washer,cooker,oven,hob,microwave,f_freezer,refrigderator,freezer,w_dispoal,w_softener,w_pump,
													 saniflo,w_heaters,s_heaters,extractor,age1,age2,age3,age4,age5,age6,age7,age8,age9,age10,age11,age12,age13,age14,age15,
													 age16,age17,age18,m_provided1,m_provided2,m_provided3,m_provided4,m_provided5,m_provided6,m_provided7,m_provided8,
													 m_provided9,m_provided10,m_provided11,m_provided12,m_provided13,m_provided14,m_provided15,m_provided16,m_provided17
													 ,m_provided18,g_warrranty1,g_warrranty2,g_warrranty3,g_warrranty4,g_warrranty5,g_warrranty6,g_warrranty7,g_warrranty8,
													 g_warrranty9,g_warrranty10,g_warrranty11,g_warrranty12,g_warrranty13,g_warrranty14,g_warrranty15,g_warrranty16,g_warrranty17
													 ,g_warrranty18,integrated1,integrated2,integrated3,integrated4,integrated5,integrated6,integrated7,integrated8,integrated9,
													 integrated10,integrated11,landlordformid","'$plumber','$company1','$tel1','$mobile1','$email1','$Heating_engineer','$company2','$tel2','$mobile2'
													 ,'$email2','$Electrician','$company3','$tel3','$mobile3','$email3','$Carpenter','$company4','$tel4','$mobile4','$email4','$Decorator',
													 '$company5','$tel5','$mobile5','$email5','$Handyman','$company6','$tel6','$mobile6','$email6','$Gardener','$company7',
													 '$tel7','$mobile7','$email7','$other','$company8','$tel8','$mobile8','$email8','$contractors','$contractors_text',
													 '$electricity_supplier','$gas_supplier','$water_supplier','$council_tax','$sewage','$refuse_collected','$drainage',
													 '$installation_property','$saniflo_location','$account_no1','$telno_no1','$provider1','$account_no2','$telno_no2',
													 '$provider2','$WashingMachine','$Dryer','$Washer','$Dish','$Cooker','$Oven','$Hob','$MicroWave','$Fridge','$Refrigderator',
													 '$Freezer','$Disposal','$Softener','$pump','$Saniflo','$Heaters','$StorageHeaters','$Extractor','$Washingage',
													 '$Dryerage','$Washerage','$Dishage','$Cookerage','$Ovenage','$Hobage','$MicroWaveage','$Fridgeage','$Refrigderatorage','$Freezerage',
													 '$Disposalage','$Softenerage','$pumpage','$Sanifloage','$Heatersage','$StorageHeatersage','$Extractorage','$manual1','$manual2','$manual3',
													 '$manual4','$manual5','$manual6','$manual7','$manual8','$manual9','$manual10','$manual11','$manual12','$manual13','$manual14',
													 '$manual15','$manual16','$manual17','$manual18','$guarantee1','$guarantee2','$guarantee3','$guarantee4','$guarantee5','$guarantee6','$guarantee7',
													 '$guarantee8','$guarantee9','$guarantee10','$guarantee11','$guarantee12','$guarantee13','$guarantee14','$guarantee15','$guarantee16','$guarantee17','$guarantee18',
													 '$Washing1','$Dryer1','$Washer1','$Dish1','$Cooker1','$Oven1','$Hob1','$MicroWave1','$Fridge1','$Refrigderator1','$Freezer1','$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',address_property='$address2',postcode='$PostCode',propertyland_no='$Property_Landline_No',example1='$Example',example2='$Example1',example3='$Example2',landline_no='$Landline_No',property='$Property',property_type='$property1',mediaprovider='$Media_provider',value1='$value1',how_many='$How_Many',value2='$value2',authorised_key='$authorised_keyholder',alarm_details='$Alarm_Details',contract_no='$Contract_No',value3='$value3',value4='$value4',code1='$Code1',code2='$Code2',masterpass='$Masterpass',location='$Location',service_cont='$Service_Contractor',propertyLandlineNo1='$Property_Landline_No1',propertyLandlineNo2='$Property_Landline_No2',value5='$value5',name1='$namestep41',name2='$namestep42',addresstep41='$addresstep41',addresstep42='$addresstep42',postcode1='$postcodestep41',postcode2='$postcodestep42',phone_no1='$phonestep41',phone_no2='$phonestep42',emailstep1='$emailstep1',emailstep2='$emailstep2',radiostep41='$interviewradiostep41',radiostep42='$interviewradiostep42',radiostep43='$interviewradiostep43',radiostep44='$interviewradiostep44',radiostep45='$interviewradiostep45',radiostep46='$interviewradiostep46',claims1='$claimsstep41',claims2='$claimsstep42',radiostep47='$interviewradiostep47',radiostep48='$interviewradiostep48',Sumstep41='$Sumstep41',Sumstep42='$Sumstep42',Agestep41='$Agestep41',Currentstep41='$Currentstep41',Amountstep41='$Amountstep41',radiostep49='$interviewradiostep49',radiostep410='$interviewradiostep410',Gasstep5='$Gasstep5',Electricstep5='$Electricstep5',Waterstep5='$Waterstep5',Meterstep51='$Meterstep51',Meterstep52='$Meterstep52',Meterstep53='$Meterstep53',Locationstep51='$Locationstep51',Heatingstep5='$Heatingstep5',Boilerstep51='$Boilerstep51',Boilerstep52='$Boilerstep52',Locationstep52='$Locationstep52',Hotstep51='$Hotstep51',interviewradiostep51='$interviewradiostep51',Locationstep53='$Locationstep53',Locationstep54='$Locationstep54',interviewradiostep52='$interviewradiostep52',Locationstep55='$Locationstep55',Annualstep51='$Annualstep51',Servicestep52='$Servicestep52',Datestep51='$Datestep51',Homecarestep51='$Homecarestep51',Homecarestep52='$Homecarestep52',Installationsstep51='$Installationsstep51',inspectionsstep51='$inspectionsstep51',testingstep51='$testingstep51',Periodicstep51='$Periodicstep51',interviewradiostep53='$interviewradiostep53',interviewradiostep54='$interviewradiostep54',interviewradiostep55='$interviewradiostep55',interviewradiostep56='$interviewradiostep56'","id='$secondtimeid'");


	$insertdata1 = $obj->update("tbllandlord2","Plumber='$plumber',Company1='$company1',Tel1='$tel1',Mobile1='$mobile1',Email1='$email1',Heating_Engineer='$Heating_engineer',Company2='$company2',Tel2='$tel2',Mobile2='$mobile2',Email2='$email2',Electrician='$Electrician',Company3='$company3',Tel3='$tel3',Mobile3='$mobile3',Email3='$email3',Carpenter='$Carpenter',Company4='$company4',Tel4='$tel4',Mobile4='$mobile4',Email4='$email4',Decorator='$Decorator',Company5='$company5',Tel5='$tel5',Mobile5='$mobile5',Email5='$email5',Handyman='$Handyman',Company6='$company6',Tel6='$tel6',Mobile6='$mobile6',Email6='$email6',Gardener='$Gardener',Company7='$company7',Tel7='$tel7',Mobile7='$mobile7',Email7='$email7',Other='$other',Company8='$company8',Tel8='$tel8',Mobile8='$mobile8',Email8='$email8',f_info='$contractors',info_text='$contractors_text',e_supplier='$electricity_supplier',g_supplier='$gas_supplier',w_supplier='$water_supplier',c_tax='$council_tax',sewage='$sewage',refuseday='$refuse_collected',drainage='$drainage',installation='$installation_property',saniflo_location='$saniflo_location',account_no_line_1='$account_no1',tel_no_line_1='$telno_no1',provider1='$provider1',account_no_line_2='$account_no2',tel_no_line_2='$telno_no2',provider2='$provider2',w_machine='$WashingMachine',dryer='$Dryer',washer_dryer='$Washer',d_washer='$Dish',cooker='$Cooker',oven='$Oven',hob='$Hob',microwave='$MicroWave',f_freezer='$Fridge',refrigderator='$Refrigderator',freezer='$Freezer',w_dispoal='$Disposal',w_softener='$Softener',w_pump='$pump',saniflo='$Saniflo',w_heaters='$Heaters',s_heaters='$StorageHeaters',extractor='$Extractor',age1='$Washingage',age2='$Dryerage',age3='$Washerage',age4='$Dishage',age5='$Cookerage',age6='$Ovenage',age7='$Hobage',age8='$MicroWaveage',age9='$Fridgeage',age10='$Refrigderatorage',age11='$Freezerage',age12='$Disposalage',age13='$Softenerage',age14='$pumpage',age15='$Sanifloage',age16='$Heatersage',age17='$StorageHeatersage',age18='$Extractorage',m_provided1='$manual1',m_provided2='$manual2',m_provided3='$manual3',m_provided4='$manual4',m_provided5='$manual5',m_provided6='$manual6',m_provided7='$manual7',m_provided8='$manual8',m_provided9='$manual9',m_provided10='$manual10',m_provided11='$manual11',m_provided12='$manual12',m_provided13='$manual13',m_provided14='$manual14',m_provided15='$manual15',m_provided16='$manual16',m_provided17='$manual17',m_provided18='$manual18',g_warrranty1='$guarantee1',g_warrranty2='$guarantee2',g_warrranty3='$guarantee3',g_warrranty4='$guarantee4',g_warrranty5='$guarantee5',g_warrranty6='$guarantee6',g_warrranty7='$guarantee7',g_warrranty8='$guarantee8',g_warrranty9='$guarantee9',g_warrranty10='$guarantee10',g_warrranty11='$guarantee11',g_warrranty12='$guarantee12',g_warrranty13='$guarantee13',g_warrranty14='$guarantee14',g_warrranty15='$guarantee15',g_warrranty16='$guarantee16',g_warrranty17='$guarantee17',g_warrranty18='$guarantee18',integrated1='$Washing1',integrated2='$Dryer1',integrated3='$Washer1',integrated4='$Dish1',integrated5='$Cooker1',integrated6='$Oven1',integrated7='$Hob1',integrated8='$MicroWave1',integrated9='$Fridge1',integrated10='$Refrigderator1',integrated11='$Freezer1'","landlordformid='$secondtimeid'");
}
$valid_formats = array("jpg", "jpeg", "png", "gif", "bmp", "JPG", "JPEG", "PNG", "GIF");
	$path = "rush/rush2017/backend/uploads/"; // Upload directory
   $max_file_size = 1024*2000; //100 kb //2 mb
 $count = 0;
 
	$valid_formatss = array("doc","PDF","pdf","DOC","DOCX");
	
//echo 1; 


       if(!empty($_FILES['input3']['name']))
    {
        foreach ($_FILES['input3']['name'] as $f => $name) 
         {    
            if ($_FILES['input3']['error'][$f] == 4)
            {
                continue; // Skip file if any error found
            }         
              if ($_FILES['input3']['error'][$f] == 0)
               {    // print_r($name);          
                        if ($_FILES['input3']['size'][$f] > $max_file_size) 
                        {  
                            $message[] = "$name is too large!.";
                            //continue; // Skip large files
                        }
                        else if( ! in_array(pathinfo($name, PATHINFO_EXTENSION), $valid_formats) )
                        {  
                            $message[] = "$name is not a valid format";
                            //continue; // Skip invalid file formats
                        }
                        else
                        { // o error found! Move uploaded files 
                           
                            $name = str_replace(' ', '_', $name);
                            $pname2 = time().$name;
                              
                           if(move_uploaded_file($_FILES["input3"]["tmp_name"][$f],$path.$pname2)) {
                               

                                $count++; // Number of successfully uploaded files
                                $insertgallery = $obj->my_insert("tbllandlordimages","tbllandlord_id,images","'$sentid','$pname2'");
                   
                            }
                         	 
                        }
 // print_r($message);
                
                }
        }   
//echo 1; 		
    }

	 if(!empty($_FILES['input33']['name']))
    {
        foreach ($_FILES['input33']['name'] as $f => $name) 
         {    
            if ($_FILES['input33']['error'][$f] == 4)
            {
                continue; // Skip file if any error found
            }         
              if ($_FILES['input33']['error'][$f] == 0)
               {    // print_r($name);          
                        if ($_FILES['input33']['size'][$f] > $max_file_size) 
                        {  
                            $message[] = "$name is too large!.";
                            //continue; // Skip large files
                        }
                        else if( ! in_array(pathinfo($name, PATHINFO_EXTENSION), $valid_formatss) )
                        {  
                            $message[] = "$name is not a valid format";
                            //continue; // Skip invalid file formats
                        }
                        else
                        { // o error found! Move uploaded files 
                           
                            $name = str_replace(' ', '_', $name);
                            $pname2 = time().$name;
                              
                           if(move_uploaded_file($_FILES["input33"]["tmp_name"][$f],$path.$pname2)) {
                               

                                $count++; // Number of successfully uploaded files
                                $insertgallery = $obj->my_insert("tbllandlordimages","tbllandlord_id,images","'$sentid','$pname2'");
                   
                            }
                         	 
                        }
//  print_r($message);
                
                }
        }   
 		
    }	
	echo 1;
?>