<?php
	set_time_limit(0);
	require_once 'php/Classes/PHPExcel.php';
	require_once 'php/Classes/PHPExcel/IOFactory.php';
	date_default_timezone_set("Europe/Moscow");
	function create_guid($namespace = '') {    
		static $guid = '';
		$uid = uniqid("", true);
		$data = $namespace;
		$data .= $_SERVER['REQUEST_TIME'];
		$data .= $_SERVER['HTTP_USER_AGENT'];
		$data .= $_SERVER['LOCAL_ADDR'];
		$data .= $_SERVER['LOCAL_PORT'];
		$data .= $_SERVER['REMOTE_ADDR'];
		$data .= $_SERVER['REMOTE_PORT'];
		$hash = strtoupper(hash('ripemd128', $uid . $guid . md5($data)));
		$guid = '{' .  
				substr($hash,  0,  8) .
				'-' .
				substr($hash,  8,  4) .
				'-' .
				substr($hash, 12,  4) .
				'-' .
				substr($hash, 16,  4) .
				'-' .
				substr($hash, 20, 12) .
				'}';
		return $guid;
	}
	$buf = create_guid();
	$GUID = substr($buf, 1, 32);
	mkdir("excel/declarations/".$GUID, 0777);
	//------------------------------------------------------------------------------------------
	//Лист 1
	$objPHPExcel = PHPExcel_IOFactory::load("excel/1 Новая декларация.xlsx");
	$objPHPExcel->setActiveSheetIndex(0);
	$f = fopen("Regions.csv", "r");
	$data = fgetcsv($f, 1000, ';');
	for($j = 1;;$j++){
			if($data[0] == $_POST['region'])
			{
				$regionname = $data[1];
				break;
			}
			$data = fgetcsv($f, 1000, ';');
	}
	fclose($f);
	$objPHPExcel->getActiveSheet()->setCellValue('BI9', iconv("Windows-1251", "UTF-8", $regionname));
	if($_POST['District']){
		$objPHPExcel->getActiveSheet()->setCellValue('BI10', iconv("Windows-1251", "UTF-8", $_POST['District']." р-н"));
	}
	if($_POST['City']){
		$objPHPExcel->getActiveSheet()->setCellValue('BI10', iconv("Windows-1251", "UTF-8", "г. ".$_POST['City']));
	}
	if($_POST['Locality']){
		$objPHPExcel->getActiveSheet()->setCellValue('BI11', iconv("Windows-1251", "UTF-8", $_POST['Locality_type']." ".$_POST['Locality']));
	}
	if($_POST['Name_consolidation']){
		$objPHPExcel->getActiveSheet()->setCellValue('BI12', iconv("Windows-1251", "UTF-8", $_POST['Name_consolidation']));
	}
	if($_POST['Street_Name']){
		$objPHPExcel->getActiveSheet()->setCellValue('BI13', iconv("Windows-1251", "UTF-8", $_POST['Street_Type']." ".$_POST['Street_Name']));
	}
	if($_POST['Level1_Name']){
		$objPHPExcel->getActiveSheet()->setCellValue('BI14', iconv("Windows-1251", "UTF-8", $_POST['Level1_Name']));
	}
	if($_POST['Level2_Name'] || $_POST['Level3_Name']){
		$corp_str = "";
		if($_POST['Level2_Name']){
			$corp_str .= "корп. ".$_POST['Level2_Name'];
			if($_POST['Level3_Name']){
				$corp_str .= ", стр. ".$_POST['Level3_Name'];
			}
		}
		if($_POST['Level3_Name'] && !$_POST['Level2_Name']){
			$corp_str .= "стр. ".$_POST['Level3_Name'];
		}
		$objPHPExcel->getActiveSheet()->setCellValue('BI15', iconv("Windows-1251", "UTF-8", $corp_str));
	}
	if($_POST['Level4_Name']){
		$objPHPExcel->getActiveSheet()->setCellValue('BI16', iconv("Windows-1251", "UTF-8", $_POST['Level4_Name']));
	}
	if($_POST['Level5_Name']){
		$objPHPExcel->getActiveSheet()->setCellValue('BI17', iconv("Windows-1251", "UTF-8", $_POST['Level5_Name']));
	}
	if($_POST['other']){
		$objPHPExcel->getActiveSheet()->setCellValue('BI18', iconv("Windows-1251", "UTF-8", $_POST['other']));
	}
	
	if($_POST['Object_Type'] == "Flat"){
		$Room_Flag = 0;
		$objPHPExcel->getActiveSheet()->setCellValue('AR21', iconv("Windows-1251", "UTF-8", "V"));
		if($_POST['Flat_Assig'] == "Resid"){
			$objPHPExcel->getActiveSheet()->setCellValue('AR30', iconv("Windows-1251", "UTF-8", "V"));
			if($_POST['Flat_Resident_Type'] == "1"){
				$objPHPExcel->getActiveSheet()->setCellValue('AR33', iconv("Windows-1251", "UTF-8", "V"));
			}
			if($_POST['Flat_Resident_Type'] == "2"){
				$objPHPExcel->getActiveSheet()->setCellValue('AR34', iconv("Windows-1251", "UTF-8", "V"));
				if($_POST['Flat_Building_Cad_Num']){
					$objPHPExcel->getActiveSheet()->setCellValue('AY43', iconv("Windows-1251", "UTF-8", $_POST['Flat_Building_Cad_Num']));
					$Room_Flag = 1;
				}
			}
		}
		if(!$Room_Flag){
			if($_POST['Flat_Building_Cad_Num']){
				$objPHPExcel->getActiveSheet()->setCellValue('AY42', iconv("Windows-1251", "UTF-8", $_POST['Flat_Building_Cad_Num']));
			}
		}
		if($_POST['Flat_Assig'] == "Nonresid"){
			$objPHPExcel->getActiveSheet()->setCellValue('AR31', iconv("Windows-1251", "UTF-8", "V"));
		}
		$Block_Num = "";
		for($i = 1; $i <= $_POST['add_new_cad_block_']; $i++){
			if($i == 1){
				$Block_Num .= $_POST['Cad_Block'.$i];
			}else{
				$Block_Num .= ", ".$_POST['Cad_Block'.$i];
			}
		}
		if($Block_Num){
			$objPHPExcel->getActiveSheet()->setCellValue('BU38', iconv("Windows-1251", "UTF-8", $Block_Num));
		}
	}
	
	if($_POST['Object_Type'] == "Building"){
		$objPHPExcel->getActiveSheet()->setCellValue('AR22', iconv("Windows-1251", "UTF-8", "V"));
		if($_POST['Building_Assig'] == "1"){
			$objPHPExcel->getActiveSheet()->setCellValue('AR26', iconv("Windows-1251", "UTF-8", "V"));
		}
		if($_POST['Building_Assig'] == "2"){
			$objPHPExcel->getActiveSheet()->setCellValue('AR27', iconv("Windows-1251", "UTF-8", "V"));
		}
		if($_POST['Building_Assig'] == "3"){
			$objPHPExcel->getActiveSheet()->setCellValue('AR28', iconv("Windows-1251", "UTF-8", "V"));
		}
		if($_POST['Building_Name']){
			$objPHPExcel->getActiveSheet()->setCellValue('AY37', iconv("Windows-1251", "UTF-8", $_POST['Building_Name']));
		}
		$Block_Num = "";
		for($i = 1; $i <= $_POST['add_new_cad_block_']; $i++){
			if($i == 1){
				$Block_Num .= $_POST['Cad_Block'.$i];
			}else{
				$Block_Num .= ", ".$_POST['Cad_Block'.$i];
			}
		}
		if($Block_Num){
			$objPHPExcel->getActiveSheet()->setCellValue('BU38', iconv("Windows-1251", "UTF-8", $Block_Num));
		}
		$Cad_Num = "";
		for($i = 1; $i <= $_POST['add_new_cad_num_']; $i++){
			if($i == 1){
				$Cad_Num .= $_POST['Cad_Num'.$i];
			}else{
				$Cad_Num .= ", ".$_POST['Cad_Num'.$i];
			}
		}
		if($Cad_Num){
			$objPHPExcel->getActiveSheet()->setCellValue('AY40', iconv("Windows-1251", "UTF-8", $Cad_Num));
		}
		
	}
	
	if($_POST['Object_Type'] == "Construction"){
		$objPHPExcel->getActiveSheet()->setCellValue('AR23', iconv("Windows-1251", "UTF-8", "V"));
		if($_POST['Construction_Assig'] == "иное сооружение"){
			$objPHPExcel->getActiveSheet()->setCellValue('AY35', iconv("Windows-1251", "UTF-8", "иное сооружение (".$_POST['Construction_Other_Assig'].")"));
		}else{
			$objPHPExcel->getActiveSheet()->setCellValue('AY35', iconv("Windows-1251", "UTF-8", $_POST['Construction_Assig']));
		}
		$Block_Num = "";
		for($i = 1; $i <= $_POST['add_new_cad_block_']; $i++){
			if($i == 1){
				$Block_Num .= $_POST['Cad_Block'.$i];
			}else{
				$Block_Num .= ", ".$_POST['Cad_Block'.$i];
			}
		}
		if($Block_Num){
			$objPHPExcel->getActiveSheet()->setCellValue('BU38', iconv("Windows-1251", "UTF-8", $Block_Num));
		}
		$Cad_Num = "";
		for($i = 1; $i <= $_POST['add_new_cad_num_']; $i++){
			if($i == 1){
				$Cad_Num .= $_POST['Cad_Num'.$i];
			}else{
				$Cad_Num .= ", ".$_POST['Cad_Num'.$i];
			}
		}
		if($Cad_Num){
			$objPHPExcel->getActiveSheet()->setCellValue('AY40', iconv("Windows-1251", "UTF-8", $Cad_Num));
		}
	}
	
	if($_POST['Object_Type'] == "Uncomp_Const"){
		$objPHPExcel->getActiveSheet()->setCellValue('AR24', iconv("Windows-1251", "UTF-8", "V"));
		if($_POST['UC_Type']){
			if($_POST['UC_Assig'] == "иное сооружение"){
				$objPHPExcel->getActiveSheet()->setCellValue('AY36', iconv("Windows-1251", "UTF-8", "иное сооружение (".$_POST['UC_Other_Assig'].")"));
			}else{
				$objPHPExcel->getActiveSheet()->setCellValue('AY36', iconv("Windows-1251", "UTF-8", $_POST['UC_Assig']));
			}
		}
		$Block_Num = "";
		for($i = 1; $i <= $_POST['add_new_cad_block_']; $i++){
			if($i == 1){
				$Block_Num .= $_POST['Cad_Block'.$i];
			}else{
				$Block_Num .= ", ".$_POST['Cad_Block'.$i];
			}
		}
		if($Block_Num){
			$objPHPExcel->getActiveSheet()->setCellValue('BU38', iconv("Windows-1251", "UTF-8", $Block_Num));
		}
		$Cad_Num = "";
		for($i = 1; $i <= $_POST['add_new_cad_num_']; $i++){
			if($i == 1){
				$Cad_Num .= $_POST['Cad_Num'.$i];
			}else{
				$Cad_Num .= ", ".$_POST['Cad_Num'.$i];
			}
		}
		if($Cad_Num){
			$objPHPExcel->getActiveSheet()->setCellValue('AY40', iconv("Windows-1251", "UTF-8", $Cad_Num));
		}
	}
	
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
	$objWriter->save("excel/declarations/".$GUID."/1 Декларация.xlsx");
	
	//------------------------------------------------------------------------------------------
	//Лист 2
	
	$objPHPExcel = PHPExcel_IOFactory::load("excel/2 Новая декларация.xlsx");
	$objPHPExcel->setActiveSheetIndex(0);
	
	if($_POST['Object_Type'] == "Flat"){
		if($_POST['Flat_Area']){
			$objPHPExcel->getActiveSheet()->setCellValue('BP5', iconv("Windows-1251", "UTF-8", $_POST['Flat_Area']));
		}
		if($_POST['Flat_Floor']){
			$objPHPExcel->getActiveSheet()->setCellValue('BP6', iconv("Windows-1251", "UTF-8", $_POST['Flat_Floor']));
		}
	}
	if($_POST['Object_Type'] == "Building"){
		if($_POST['Building_Area']){
			$objPHPExcel->getActiveSheet()->setCellValue('BP5', iconv("Windows-1251", "UTF-8", $_POST['Building_Area']));
		}
		if($_POST['Building_Floors']){
			$objPHPExcel->getActiveSheet()->setCellValue('BP7', iconv("Windows-1251", "UTF-8", $_POST['Building_Floors']));
		}
		if($_POST['Building_Und_Floors']){
			$objPHPExcel->getActiveSheet()->setCellValue('BP8', iconv("Windows-1251", "UTF-8", $_POST['Building_Und_Floors']));
		}
		if($_POST['Building_Year']){
			$objPHPExcel->getActiveSheet()->setCellValue('BP9', iconv("Windows-1251", "UTF-8", $_POST['Building_Year']));
		}
		if($_POST['Building_Mat'] == "1"){
			$objPHPExcel->getActiveSheet()->setCellValue('R11', iconv("Windows-1251", "UTF-8", "V"));
		}
		if($_POST['Building_Mat'] == "2"){
			$objPHPExcel->getActiveSheet()->setCellValue('R12', iconv("Windows-1251", "UTF-8", "V"));
		}
		if($_POST['Building_Mat'] == "3"){
			$objPHPExcel->getActiveSheet()->setCellValue('R13', iconv("Windows-1251", "UTF-8", "V"));
		}
		if($_POST['Building_Mat'] == "4"){
			$objPHPExcel->getActiveSheet()->setCellValue('R14', iconv("Windows-1251", "UTF-8", "V"));
		}
		if($_POST['Building_Mat'] == "5"){
			$objPHPExcel->getActiveSheet()->setCellValue('R15', iconv("Windows-1251", "UTF-8", "V"));
		}
		if($_POST['Building_Mat'] == "6"){
			$objPHPExcel->getActiveSheet()->setCellValue('R16', iconv("Windows-1251", "UTF-8", "V"));
		}
		
	}
	if($_POST['Object_Type'] == "Construction"){
		if($_POST['Construction_Floors']){
			$objPHPExcel->getActiveSheet()->setCellValue('BP18', iconv("Windows-1251", "UTF-8", $_POST['Construction_Floors']));
		}
		if($_POST['Construction_Und_Floors']){
			$objPHPExcel->getActiveSheet()->setCellValue('BP19', iconv("Windows-1251", "UTF-8", $_POST['Construction_Und_Floors']));
		}
		if($_POST['Construction_Year']){
			$objPHPExcel->getActiveSheet()->setCellValue('BP20', iconv("Windows-1251", "UTF-8", $_POST['Construction_Year']));
		}
		if($_POST['Construction_Main_Char'] == "1"){
			$objPHPExcel->getActiveSheet()->setCellValue('BP22', iconv("Windows-1251", "UTF-8", $_POST['Construction_Main_Char_Value']));
		}
		if($_POST['Construction_Main_Char'] == "2"){
			$objPHPExcel->getActiveSheet()->setCellValue('BP23', iconv("Windows-1251", "UTF-8", $_POST['Construction_Main_Char_Value']));
		}
		if($_POST['Construction_Main_Char'] == "3"){
			$objPHPExcel->getActiveSheet()->setCellValue('BP24', iconv("Windows-1251", "UTF-8", $_POST['Construction_Main_Char_Value']));
		}
		if($_POST['Construction_Main_Char'] == "4"){
			$objPHPExcel->getActiveSheet()->setCellValue('BP25', iconv("Windows-1251", "UTF-8", $_POST['Construction_Main_Char_Value']));
		}
		if($_POST['Construction_Main_Char'] == "5"){
			$objPHPExcel->getActiveSheet()->setCellValue('BP26', iconv("Windows-1251", "UTF-8", $_POST['Construction_Main_Char_Value']));
		}
		if($_POST['Construction_Main_Char'] == "6"){
			$objPHPExcel->getActiveSheet()->setCellValue('BP27', iconv("Windows-1251", "UTF-8", $_POST['Construction_Main_Char_Value']));
		}
	}
	
	if($_POST['Object_Type'] == "Uncomp_Const"){
		if($_POST['UC_Type'] == "UC_Type_Building"){
			$objPHPExcel->getActiveSheet()->setCellValue('BP32', iconv("Windows-1251", "UTF-8", $_POST['UC_Area']));
		}
		if($_POST['UC_Type'] == "UC_Type_Construction"){
			if($_POST['UC_Main_Char'] == "1"){
				$objPHPExcel->getActiveSheet()->setCellValue('BP30', iconv("Windows-1251", "UTF-8", $_POST['UC_Main_Char_Value']));
			}
			if($_POST['UC_Main_Char'] == "2"){
				$objPHPExcel->getActiveSheet()->setCellValue('BP31', iconv("Windows-1251", "UTF-8", $_POST['UC_Main_Char_Value']));
			}
			if($_POST['UC_Main_Char'] == "3"){
				$objPHPExcel->getActiveSheet()->setCellValue('BP32', iconv("Windows-1251", "UTF-8", $_POST['UC_Main_Char_Value']));
			}
			if($_POST['UC_Main_Char'] == "4"){
				$objPHPExcel->getActiveSheet()->setCellValue('BP33', iconv("Windows-1251", "UTF-8", $_POST['UC_Main_Char_Value']));
			}
			if($_POST['UC_Main_Char'] == "5"){
				$objPHPExcel->getActiveSheet()->setCellValue('BP34', iconv("Windows-1251", "UTF-8", $_POST['UC_Main_Char_Value']));
			}
			if($_POST['UC_Main_Char'] == "6"){
				$objPHPExcel->getActiveSheet()->setCellValue('BP35', iconv("Windows-1251", "UTF-8", $_POST['UC_Main_Char_Value']));
			}
		}
		if($_POST['UC_Readiness']){
			$objPHPExcel->getActiveSheet()->setCellValue('BP36', iconv("Windows-1251", "UTF-8", $_POST['UC_Readiness']));
		}
	}
	
	if($_POST['add_new_owner_'] >= 1){
		if($_POST['add_new_owner_'] >= 2){
			 $title = "6. Правообладатель объекта недвижимости (земельного участка, на котором находится здание, сооружение, объект незавершенного строительства), список приведен в приложении на листах: ";
			for($i = 2; $i <= $_POST['add_new_owner_']; $i++){
				if($i == 2){
					$title .= ($i + 3);
				}else{
					$title .= ", ".($i + 3);
				}
			}
			$objPHPExcel->getActiveSheet()->setCellValue('A37', iconv("Windows-1251", "UTF-8", $title));
		}
		if($_POST['Owner_Type1'] == "Person"){
			if($_POST['Owner_Surname1']){
				$objPHPExcel->getActiveSheet()->setCellValue('AP39', iconv("Windows-1251", "UTF-8", $_POST['Owner_Surname1']));
			}
			if($_POST['Owner_Name1']){
				$objPHPExcel->getActiveSheet()->setCellValue('AP40', iconv("Windows-1251", "UTF-8", $_POST['Owner_Name1']));
			}
			if($_POST['Owner_Patronymic1']){
				$objPHPExcel->getActiveSheet()->setCellValue('AP41', iconv("Windows-1251", "UTF-8", $_POST['Owner_Patronymic1']));
			}
			if($_POST['Owner_SNILS1']){
				$objPHPExcel->getActiveSheet()->setCellValue('CF42', iconv("Windows-1251", "UTF-8", $_POST['Owner_SNILS1']));
			}
			if($_POST['Owner_Pasport1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BE43', iconv("Windows-1251", "UTF-8", $_POST['Owner_Pasport1']));
			}
			if($_POST['Owner_Pasport_Given1']){
				$objPHPExcel->getActiveSheet()->setCellValue('J44', iconv("Windows-1251", "UTF-8", $_POST['Owner_Pasport_Given1']));
			}
			
			$f = fopen("Regions.csv", "r");
			$data = fgetcsv($f, 1000, ';');
			for($j = 1;;$j++){
					if($data[0] == $_POST['owner_region1'])
					{
						$regionname = $data[1];
						break;
					}
					$data = fgetcsv($f, 1000, ';');
			}
			fclose($f);
			
			if($_POST['Owner_Postal_Code1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI46', iconv("Windows-1251", "UTF-8", $_POST['Owner_Postal_Code1']));
			}
			if($_POST['Owner_City1'] || $_POST['Owner_District1'] || $_POST['Owner_Locality1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI47', iconv("Windows-1251", "UTF-8", $regionname));
			}
			if($_POST['Owner_City1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI48', iconv("Windows-1251", "UTF-8", $_POST['Owner_City1']));
			}
			if($_POST['Owner_District1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI49', iconv("Windows-1251", "UTF-8", $_POST['Owner_District1']));
			}
			if($_POST['Owner_Locality1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI50', iconv("Windows-1251", "UTF-8", $_POST['Owner_Locality_type1']." ".$_POST['Owner_Locality1']));
			}
		}
	}
	
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
	$objWriter->save("excel/declarations/".$GUID."/2 Декларация.xlsx");
	
	//------------------------------------------------------------------------------------------
	//Лист 3
	$objPHPExcel = PHPExcel_IOFactory::load("excel/3 Новая декларация.xlsx");
	$objPHPExcel->setActiveSheetIndex(0);
	
	if($_POST['add_new_owner_'] >= 1){
		if($_POST['Owner_Type1'] == "Person"){
			if($_POST['Owner_Street_Name1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI4', iconv("Windows-1251", "UTF-8", $_POST['Owner_Street_Type1']." ".$_POST['Owner_Street_Name1']));
			}
			if($_POST['Owner_Level1_1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI5', iconv("Windows-1251", "UTF-8", $_POST['Owner_Level1_1']));
			}
			if($_POST['Owner_Level2_1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI6', iconv("Windows-1251", "UTF-8", $_POST['Owner_Level2_1']));
			}
			if($_POST['Owner_Level3_1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI7', iconv("Windows-1251", "UTF-8", $_POST['Owner_Level3_1']));
			}
			if($_POST['Owner_Email1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI8', iconv("Windows-1251", "UTF-8", $_POST['Owner_Email1']));
			}
		}
		if($_POST['Owner_Type1'] == "Organization"){
			if($_POST['Owner_Name1']){
				$objPHPExcel->getActiveSheet()->setCellValue('AN10', iconv("Windows-1251", "UTF-8", $_POST['Owner_Name1']));
			}
			if($_POST['Owner_OGRN1']){
				$objPHPExcel->getActiveSheet()->setCellValue('AN11', iconv("Windows-1251", "UTF-8", $_POST['Owner_OGRN1']));
			}
			if($_POST['Owner_Date1']){
				$objPHPExcel->getActiveSheet()->setCellValue('AN12', iconv("Windows-1251", "UTF-8", $_POST['Owner_Date1']));
			}
			if($_POST['Owner_INN1']){
				$objPHPExcel->getActiveSheet()->setCellValue('AN13', iconv("Windows-1251", "UTF-8", $_POST['Owner_INN1']));
			}
			if($_POST['Owner_Contry1']){
				$objPHPExcel->getActiveSheet()->setCellValue('AN14', iconv("Windows-1251", "UTF-8", $_POST['Owner_Contry1']));
			}
			if($_POST['Owner_Date_Reg1']){
				$objPHPExcel->getActiveSheet()->setCellValue('AN15', iconv("Windows-1251", "UTF-8", $_POST['Owner_Date_Reg1']));
			}
			if($_POST['Owner_Reg_Number1']){
				$objPHPExcel->getActiveSheet()->setCellValue('AN16', iconv("Windows-1251", "UTF-8", $_POST['Owner_Reg_Number1']));
			}
			
			$f = fopen("Regions.csv", "r");
			$data = fgetcsv($f, 1000, ';');
			for($j = 1;;$j++){
					if($data[0] == $_POST['owner_region1'])
					{
						$regionname = $data[1];
						break;
					}
					$data = fgetcsv($f, 1000, ';');
			}
			fclose($f);
			
			if($_POST['Owner_Postal_Code1']){
				$objPHPExcel->getActiveSheet()->setCellValue('AN17', iconv("Windows-1251", "UTF-8", $_POST['Owner_Postal_Code1']));
			}
			if($_POST['Owner_City1'] || $_POST['Owner_District1'] || $_POST['Owner_Locality1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI19', iconv("Windows-1251", "UTF-8", $regionname));
			}
			if($_POST['Owner_City1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI20', iconv("Windows-1251", "UTF-8", $_POST['Owner_City1']));
			}
			if($_POST['Owner_District1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI21', iconv("Windows-1251", "UTF-8", $_POST['Owner_District1']));
			}
			if($_POST['Owner_Locality1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI22', iconv("Windows-1251", "UTF-8", $_POST['Owner_Locality_type1']." ".$_POST['Owner_Locality1']));
			}
			if($_POST['Owner_Street_Name1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI23', iconv("Windows-1251", "UTF-8", $_POST['Owner_Street_Type1']." ".$_POST['Owner_Street_Name1']));
			}
			if($_POST['Owner_Level1_1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI24', iconv("Windows-1251", "UTF-8", $_POST['Owner_Level1_1']));
			}
			if($_POST['Owner_Level2_1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI25', iconv("Windows-1251", "UTF-8", $_POST['Owner_Level2_1']));
			}
			if($_POST['Owner_Email1']){
				$objPHPExcel->getActiveSheet()->setCellValue('BI26', iconv("Windows-1251", "UTF-8", $_POST['Owner_Email1']));
			}
		}
		if($_POST['Owner_Type1'] == "Russia"){
			$objPHPExcel->getActiveSheet()->setCellValue('AX28', iconv("Windows-1251", "UTF-8", "V"));
		}
		if($_POST['Owner_Type1'] == "SubjectRF"){
			$objPHPExcel->getActiveSheet()->setCellValue('AX29', iconv("Windows-1251", "UTF-8", "V"));
			if($_POST['Owner_Name1']){
				$objPHPExcel->getActiveSheet()->setCellValue('Z30', iconv("Windows-1251", "UTF-8", $_POST['Owner_Name1']));
			}
		}
		if($_POST['Owner_Type1'] == "Municipality"){
			$objPHPExcel->getActiveSheet()->setCellValue('AX31', iconv("Windows-1251", "UTF-8", "V"));
			if($_POST['Owner_Name1']){
				$objPHPExcel->getActiveSheet()->setCellValue('Z32', iconv("Windows-1251", "UTF-8", $_POST['Owner_Name1']));
			}
		}
		if($_POST['Owner_Type1'] == "Foreign_Country"){
			$objPHPExcel->getActiveSheet()->setCellValue('AX33', iconv("Windows-1251", "UTF-8", "V"));
			if($_POST['Owner_Name1']){
				$objPHPExcel->getActiveSheet()->setCellValue('Z34', iconv("Windows-1251", "UTF-8", $_POST['Owner_Name1']));
			}
		}
	}
	
	if($_POST['Repres_Type'] == "Repres_Person"){
		if($_POST['Repres_Surname']){
			$objPHPExcel->getActiveSheet()->setCellValue('AP42', iconv("Windows-1251", "UTF-8", $_POST['Repres_Surname']));
		}
		if($_POST['Repres_Name']){
			$objPHPExcel->getActiveSheet()->setCellValue('AP43', iconv("Windows-1251", "UTF-8", $_POST['Repres_Name']));
		}
		if($_POST['Repres_Patronymic']){
			$objPHPExcel->getActiveSheet()->setCellValue('AP44', iconv("Windows-1251", "UTF-8", $_POST['Repres_Patronymic']));
		}
		if($_POST['Repres_SNILS']){
			$objPHPExcel->getActiveSheet()->setCellValue('CF45', iconv("Windows-1251", "UTF-8", $_POST['Repres_SNILS']));
		}
		if($_POST['Repres_Pasport']){
			$objPHPExcel->getActiveSheet()->setCellValue('BE46', iconv("Windows-1251", "UTF-8", $_POST['Repres_Pasport']));
		}
		if($_POST['Repres_Pasport_Given']){
			$objPHPExcel->getActiveSheet()->setCellValue('J47', iconv("Windows-1251", "UTF-8", $_POST['Repres_Pasport_Given']));
		}
		if($_POST['Repres_Postal_Code']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI49', iconv("Windows-1251", "UTF-8", $_POST['Repres_Postal_Code']));
		}
	}
	
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
	$objWriter->save("excel/declarations/".$GUID."/3 Декларация.xlsx");
	
	//------------------------------------------------------------------------------------------
	//Лист 4
	$objPHPExcel = PHPExcel_IOFactory::load("excel/4 Новая декларация.xlsx");
	$objPHPExcel->setActiveSheetIndex(0);
	
	if($_POST['Repres_Type'] == "Repres_Person"){
		$f = fopen("Regions.csv", "r");
		$data = fgetcsv($f, 1000, ';');
		for($j = 1;;$j++){
				if($data[0] == $_POST['repres_region'])
				{
					$regionname = $data[1];
					break;
				}
				$data = fgetcsv($f, 1000, ';');
		}
		fclose($f);
		
		if($_POST['Repres_City'] || $_POST['Repres_District'] || $_POST['Repres_Locality']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI4', iconv("Windows-1251", "UTF-8", $regionname));
		}
		if($_POST['Repres_City']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI5', iconv("Windows-1251", "UTF-8", $_POST['Repres_City']));
		}
		if($_POST['Repres_District']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI6', iconv("Windows-1251", "UTF-8", $_POST['Repres_District']));
		}
		if($_POST['Repres_Locality']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI7', iconv("Windows-1251", "UTF-8", $_POST['Repres_Locality_type']." ".$_POST['Repres_Locality']));
		}
		if($_POST['Repres_Street_Name']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI8', iconv("Windows-1251", "UTF-8", $_POST['Repres_Street_Type']." ".$_POST['Repres_Street_Name']));
		}
		if($_POST['Repres_Level1_']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI9', iconv("Windows-1251", "UTF-8", $_POST['Repres_Level1_']));
		}
		if($_POST['Repres_Level2_']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI10', iconv("Windows-1251", "UTF-8", $_POST['Repres_Level2_']));
		}
		if($_POST['Repres_Level3_']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI11', iconv("Windows-1251", "UTF-8", $_POST['Repres_Level3_']));
		}
		if($_POST['Repres_Email']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI12', iconv("Windows-1251", "UTF-8", $_POST['Repres_Email']));
		}
	}
	
	if($_POST['Repres_Type'] == "Repres_Org"){
		if($_POST['Repres_Name']){
			$objPHPExcel->getActiveSheet()->setCellValue('AN18', iconv("Windows-1251", "UTF-8", $_POST['Repres_Name']));
		}
		if($_POST['Repres_OGRN']){
			$objPHPExcel->getActiveSheet()->setCellValue('AN19', iconv("Windows-1251", "UTF-8", $_POST['Repres_OGRN']));
		}
		if($_POST['Repres_Date']){
			$objPHPExcel->getActiveSheet()->setCellValue('AN20', iconv("Windows-1251", "UTF-8", $_POST['Repres_Date']));
		}
		if($_POST['Repres_INN']){
			$objPHPExcel->getActiveSheet()->setCellValue('AN21', iconv("Windows-1251", "UTF-8", $_POST['Repres_INN']));
		}
		if($_POST['Repres_Contry']){
			$objPHPExcel->getActiveSheet()->setCellValue('AN22', iconv("Windows-1251", "UTF-8", $_POST['Repres_Contry']));
		}
		if($_POST['Repres_Date_Reg']){
			$objPHPExcel->getActiveSheet()->setCellValue('AN23', iconv("Windows-1251", "UTF-8", $_POST['Repres_Date_Reg']));
		}
		if($_POST['Repres_Reg_Number']){
			$objPHPExcel->getActiveSheet()->setCellValue('AN24', iconv("Windows-1251", "UTF-8", $_POST['Repres_Reg_Number']));
		}
		if($_POST['Repres_Postal_Code']){
			$objPHPExcel->getActiveSheet()->setCellValue('AN25', iconv("Windows-1251", "UTF-8", $_POST['Repres_Postal_Code']));
		}
		
		$f = fopen("Regions.csv", "r");
		$data = fgetcsv($f, 1000, ';');
		for($j = 1;;$j++){
				if($data[0] == $_POST['repres_region'])
				{
					$regionname = $data[1];
					break;
				}
				$data = fgetcsv($f, 1000, ';');
		}
		fclose($f);
		
		if($_POST['Repres_City'] || $_POST['Repres_District'] || $_POST['Repres_Locality']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI27', iconv("Windows-1251", "UTF-8", $regionname));
		}
		if($_POST['Repres_City']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI28', iconv("Windows-1251", "UTF-8", $_POST['Repres_City']));
		}
		if($_POST['Repres_District']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI29', iconv("Windows-1251", "UTF-8", $_POST['Repres_District']));
		}
		if($_POST['Repres_Locality']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI30', iconv("Windows-1251", "UTF-8", $_POST['Repres_Locality_type']." ".$_POST['Repres_Locality']));
		}
		if($_POST['Repres_Street_Name']){
			$objPHPExcel->getActiveSheet()->setCellValue('BI31', iconv("Windows-1251", "UTF-8", $_POST['Repres_Street_Type']." ".$_POST['Repres_Street_Name']));
		}
	}
	
	if($_POST['Date']){
		$objPHPExcel->getActiveSheet()->setCellValue('I42', iconv("Windows-1251", "UTF-8", $_POST['Date']));
	}
	
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
	$objWriter->save("excel/declarations/".$GUID."/4 Декларация.xlsx");
	
	
	//------------------------------------------------------------------------------------------
	//Приложения
	for($i = 2; $i <= $_POST['add_new_owner_']; $i++){
		$objPHPExcel = PHPExcel_IOFactory::load("excel/Приложение.xlsx");
		$objPHPExcel->setActiveSheetIndex(0);
		
		$objPHPExcel->getActiveSheet()->setCellValue('CZ1', iconv("Windows-1251", "UTF-8", ($i + 3)));
		
		if($_POST['Owner_Type'.$i] == "Person"){
			if($_POST['Owner_Surname'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('AP5', iconv("Windows-1251", "UTF-8", $_POST['Owner_Surname'.$i]));
			}
			if($_POST['Owner_Name'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('AP6', iconv("Windows-1251", "UTF-8", $_POST['Owner_Name'.$i]));
			}
			if($_POST['Owner_Patronymic'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('AP7', iconv("Windows-1251", "UTF-8", $_POST['Owner_Patronymic'.$i]));
			}
			if($_POST['Owner_SNILS'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('CF8', iconv("Windows-1251", "UTF-8", $_POST['Owner_SNILS'.$i]));
			}
			if($_POST['Owner_Pasport'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BE9', iconv("Windows-1251", "UTF-8", $_POST['Owner_Pasport'.$i]));
			}
			if($_POST['Owner_Pasport_Given'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('J10', iconv("Windows-1251", "UTF-8", $_POST['Owner_Pasport_Given'.$i]));
			}
			
			$f = fopen("Regions.csv", "r");
			$data = fgetcsv($f, 1000, ';');
			for($j = 1;;$j++){
					if($data[0] == $_POST['owner_region'.$i])
					{
						$regionname = $data[1];
						break;
					}
					$data = fgetcsv($f, 1000, ';');
			}
			fclose($f);
			
			if($_POST['Owner_Postal_Code'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI12', iconv("Windows-1251", "UTF-8", $_POST['Owner_Postal_Code'.$i]));
			}
			if($_POST['Owner_City'.$i] || $_POST['Owner_District'.$i] || $_POST['Owner_Locality'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI13', iconv("Windows-1251", "UTF-8", $regionname));
			}
			if($_POST['Owner_City'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI14', iconv("Windows-1251", "UTF-8", $_POST['Owner_City'.$i]));
			}
			if($_POST['Owner_District'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI15', iconv("Windows-1251", "UTF-8", $_POST['Owner_District'.$i]));
			}
			if($_POST['Owner_Locality'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI16', iconv("Windows-1251", "UTF-8", $_POST['Owner_Locality_type'.$i]." ".$_POST['Owner_Locality'.$i]));
			}
			if($_POST['Owner_Street_Name'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI17', iconv("Windows-1251", "UTF-8", $_POST['Owner_Street_Type'.$i]." ".$_POST['Owner_Street_Name'.$i]));
			}
			if($_POST['Owner_Level1_'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI18', iconv("Windows-1251", "UTF-8", $_POST['Owner_Level1_'.$i]));
			}
			if($_POST['Owner_Level2_'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI19', iconv("Windows-1251", "UTF-8", $_POST['Owner_Level2_'.$i]));
			}
			if($_POST['Owner_Level3_'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI20', iconv("Windows-1251", "UTF-8", $_POST['Owner_Level3_'.$i]));
			}
			if($_POST['Owner_Email'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI21', iconv("Windows-1251", "UTF-8", $_POST['Owner_Email'.$i]));
			}
		}
		
		if($_POST['Owner_Type'.$i] == "Organization"){
			if($_POST['Owner_Name'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('AN23', iconv("Windows-1251", "UTF-8", $_POST['Owner_Name'.$i]));
			}
			if($_POST['Owner_OGRN'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('AN24', iconv("Windows-1251", "UTF-8", $_POST['Owner_OGRN'.$i]));
			}
			if($_POST['Owner_Date'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('AN25', iconv("Windows-1251", "UTF-8", $_POST['Owner_Date'.$i]));
			}
			if($_POST['Owner_INN'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('AN26', iconv("Windows-1251", "UTF-8", $_POST['Owner_INN'.$i]));
			}
			if($_POST['Owner_Contry'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('AN27', iconv("Windows-1251", "UTF-8", $_POST['Owner_Contry'.$i]));
			}
			if($_POST['Owner_Date_Reg'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('AN28', iconv("Windows-1251", "UTF-8", $_POST['Owner_Date_Reg'.$i]));
			}
			if($_POST['Owner_Reg_Number'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('AN29', iconv("Windows-1251", "UTF-8", $_POST['Owner_Reg_Number'.$i]));
			}
			
			$f = fopen("Regions.csv", "r");
			$data = fgetcsv($f, 1000, ';');
			for($j = 1;;$j++){
					if($data[0] == $_POST['owner_region'.$i])
					{
						$regionname = $data[1];
						break;
					}
					$data = fgetcsv($f, 1000, ';');
			}
			fclose($f);
			
			if($_POST['Owner_Postal_Code'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('AN30', iconv("Windows-1251", "UTF-8", $_POST['Owner_Postal_Code'.$i]));
			}
			if($_POST['Owner_City'.$i] || $_POST['Owner_District'.$i] || $_POST['Owner_Locality'.$i] || $_POST['Owner_Street_Name'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI32', iconv("Windows-1251", "UTF-8", $regionname));
			}
			if($_POST['Owner_City'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI33', iconv("Windows-1251", "UTF-8", $_POST['Owner_City'.$i]));
			}
			if($_POST['Owner_District'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI34', iconv("Windows-1251", "UTF-8", $_POST['Owner_District'.$i]));
			}
			if($_POST['Owner_Locality'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI35', iconv("Windows-1251", "UTF-8", $_POST['Owner_Locality_type'.$i]." ".$_POST['Owner_Locality'.$i]));
			}
			if($_POST['Owner_Street_Name'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI36', iconv("Windows-1251", "UTF-8", $_POST['Owner_Street_Type'.$i]." ".$_POST['Owner_Street_Name'.$i]));
			}
			if($_POST['Owner_Level1_'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI37', iconv("Windows-1251", "UTF-8", $_POST['Owner_Level1_'.$i]));
			}
			if($_POST['Owner_Level2_'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI38', iconv("Windows-1251", "UTF-8", $_POST['Owner_Level2_'.$i]));
			}
			if($_POST['Owner_Email'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('BI39', iconv("Windows-1251", "UTF-8", $_POST['Owner_Email'.$i]));
			}
		}
		
		if($_POST['Owner_Type'.$i] == "Russia"){
			$objPHPExcel->getActiveSheet()->setCellValue('AX41', iconv("Windows-1251", "UTF-8", "V"));
		}
		if($_POST['Owner_Type'.$i] == "SubjectRF"){
			$objPHPExcel->getActiveSheet()->setCellValue('AX42', iconv("Windows-1251", "UTF-8", "V"));
			if($_POST['Owner_Name'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('Z43', iconv("Windows-1251", "UTF-8", $_POST['Owner_Name'.$i]));
			}
		}
		if($_POST['Owner_Type'.$i] == "Municipality"){
			$objPHPExcel->getActiveSheet()->setCellValue('AX44', iconv("Windows-1251", "UTF-8", "V"));
			if($_POST['Owner_Name'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('Z45', iconv("Windows-1251", "UTF-8", $_POST['Owner_Name'.$i]));
			}
		}
		if($_POST['Owner_Type'.$i] == "Foreign_Country"){
			$objPHPExcel->getActiveSheet()->setCellValue('AX46', iconv("Windows-1251", "UTF-8", "V"));
			if($_POST['Owner_Name'.$i]){
				$objPHPExcel->getActiveSheet()->setCellValue('Z47', iconv("Windows-1251", "UTF-8", $_POST['Owner_Name'.$i]));
			}
		}
		
		
		$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
		$objWriter->save("excel/declarations/".$GUID."/".($i + 3)." Приложение.xlsx");
	}
	//------------------------------------------------------------------------------------------
	
	$zip = new ZipArchive(); 
	$zip->open("excel/declarations/".$GUID."/Декларация.zip", ZIPARCHIVE::CREATE); 
	
	$filecontents = file_get_contents("excel/declarations/".$GUID."/1 Декларация.xlsx");
	$zip->addFromString(iconv('windows-1251', 'cp866', "1 Декларация.xlsx"), $filecontents);
	
	$filecontents = file_get_contents("excel/declarations/".$GUID."/2 Декларация.xlsx");
	$zip->addFromString(iconv('windows-1251', 'cp866', "2 Декларация.xlsx"), $filecontents);
	
	$filecontents = file_get_contents("excel/declarations/".$GUID."/3 Декларация.xlsx");
	$zip->addFromString(iconv('windows-1251', 'cp866', "3 Декларация.xlsx"), $filecontents);
	
	$filecontents = file_get_contents("excel/declarations/".$GUID."/4 Декларация.xlsx");
	$zip->addFromString(iconv('windows-1251', 'cp866', "4 Декларация.xlsx"), $filecontents);
	
	for($i = 2; $i <= $_POST['add_new_owner_']; $i++){
		$filecontents = file_get_contents("excel/declarations/".$GUID."/".($i + 3)." Приложение.xlsx");
		$zip->addFromString(iconv('windows-1251', 'cp866', ($i + 3)." Приложение.xlsx"), $filecontents);
	}
	
	$zip->close(); 
	
	$file = "excel/declarations/".$GUID."/Декларация.zip";
	$size = filesize($file);
	header("Content-type: application/zip");
	header("Content-Length: ".$size);
	header("Content-Disposition: attachment; filename = Декларация.zip");
	readfile($file);
?>