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

include_once("rush/rush2017/backend/connect/helper.php");
//print_r($_FILES); //die;

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($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'];
$interviewradioalarm = $_REQUEST['interviewradioalarm'];
$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($tel4);

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


$first_time= $obj->select("*","tbllandlord","linksent_id='$sentid'");
//print_r($first_time);

	$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;
	

$insertdata1 = $obj->update("tbllandlord2","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; 

$update_pass = $obj->update("tbllandformsdetails","status='received',received_date='$today'","id='$sentid'");

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