<?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);
	
	//------------------------------------------------------------------------------------------
	//Лист 1
	$objPHPExcel = PHPExcel_IOFactory::load("excel/templates/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('AT15', iconv("Windows-1251", "UTF-8", $regionname));
	if($_POST['District'] != "" && $_POST['City'] == ""){
		$objPHPExcel->getActiveSheet()->setCellValue('AT16', iconv("Windows-1251", "UTF-8", "Район"));
		$objPHPExcel->getActiveSheet()->setCellValue('AT17', iconv("Windows-1251", "UTF-8", $_POST['District']));
	}
	if($_POST['District'] == "" && $_POST['City'] != ""){
		$objPHPExcel->getActiveSheet()->setCellValue('AT16', iconv("Windows-1251", "UTF-8", "Город"));
		$objPHPExcel->getActiveSheet()->setCellValue('AT17', iconv("Windows-1251", "UTF-8", $_POST['City']));
	}
	if($_POST['District'] == "" && $_POST['City'] == ""){
		$objPHPExcel->getActiveSheet()->setCellValue('AT16', iconv("Windows-1251", "UTF-8", "—"));
		$objPHPExcel->getActiveSheet()->setCellValue('AT17', iconv("Windows-1251", "UTF-8", "—"));
	}
	
	if($_POST['Locality'] != ""){
		$f = fopen("locality.csv", "r");
		while(!feof($f)) {
			$data = fgetcsv($f, 1000, ';');
			if($data[0] == $_POST['Locality_type']){
				break;
			}
		}
		fclose($f);
		$objPHPExcel->getActiveSheet()->setCellValue('AT18', iconv("Windows-1251", "UTF-8", $data[1]));
		$objPHPExcel->getActiveSheet()->setCellValue('AT19', iconv("Windows-1251", "UTF-8", $_POST['Locality']));
	}else{
		$objPHPExcel->getActiveSheet()->setCellValue('AT18', iconv("Windows-1251", "UTF-8", "—"));
		$objPHPExcel->getActiveSheet()->setCellValue('AT19', iconv("Windows-1251", "UTF-8", "—"));
	}
	
	if($_POST['Name_consolidation'] != ""){
		$objPHPExcel->getActiveSheet()->setCellValue('BN20', iconv("Windows-1251", "UTF-8", $_POST['Name_consolidation']));
	}else{
		$objPHPExcel->getActiveSheet()->setCellValue('BN20', iconv("Windows-1251", "UTF-8", "—"));
	}
	
	if($_POST['Street_Name'] != ""){
		$f = fopen("street.csv", "r");
		while(!feof($f)) {
			$data = fgetcsv($f, 1000, ';');
			if($data[0] == $_POST['Street_Type']){
				break;
			}
		}
		fclose($f);
		$objPHPExcel->getActiveSheet()->setCellValue('AT21', iconv("Windows-1251", "UTF-8", $data[1]." ".$_POST['Street_Name']));
	}else{
		$objPHPExcel->getActiveSheet()->setCellValue('AT21', iconv("Windows-1251", "UTF-8", "—"));
	}
	
	
	$house = $_POST['Level1_Name'];
	$objPHPExcel->getActiveSheet()->setCellValue('AS22', iconv("Windows-1251", "UTF-8", substr($house, 0, 1)));
	$objPHPExcel->getActiveSheet()->setCellValue('AW22', iconv("Windows-1251", "UTF-8", substr($house, 1, 1)));
	$objPHPExcel->getActiveSheet()->setCellValue('BA22', iconv("Windows-1251", "UTF-8", substr($house, 2, 1)));
	$objPHPExcel->getActiveSheet()->setCellValue('BE22', iconv("Windows-1251", "UTF-8", substr($house, 3, 1)));
	
	$house = $_POST['Level2_Name'];
	$objPHPExcel->getActiveSheet()->setCellValue('CR22', iconv("Windows-1251", "UTF-8", substr($house, 0, 1)));
	$objPHPExcel->getActiveSheet()->setCellValue('CV22', iconv("Windows-1251", "UTF-8", substr($house, 1, 1)));
	$objPHPExcel->getActiveSheet()->setCellValue('CZ22', iconv("Windows-1251", "UTF-8", substr($house, 2, 1)));
	if($_POST['Level4_Name'])
	$objPHPExcel->getActiveSheet()->setCellValue('AT23', iconv("Windows-1251", "UTF-8", "Квартира ".$_POST['Level4_Name']));
	$objPHPExcel->getActiveSheet()->setCellValue('AT23', iconv("Windows-1251", "UTF-8", "—"));
	if($_POST['Other'] != ""){
		$objPHPExcel->getActiveSheet()->setCellValue('AT23', iconv("Windows-1251", "UTF-8", $_POST['Other']));
	}else{
		$objPHPExcel->getActiveSheet()->setCellValue('AT23', iconv("Windows-1251", "UTF-8", "—"));
	}
	
	if($_POST['Obj_Type'] == "Здание"){
		$objPHPExcel->getActiveSheet()->setCellValue('AB28', "V");
		if($_POST['Obj_Ass'] == "Жилой дом"){
			$objPHPExcel->getActiveSheet()->setCellValue('AB31', "V");
		}
		if($_POST['Obj_Ass'] == "Нежилое здание"){
			$objPHPExcel->getActiveSheet()->setCellValue('BI31', "V");
		}
		if($_POST['Obj_Ass'] == "Многоквартирный дом"){
			$objPHPExcel->getActiveSheet()->setCellValue('CZ31', "V");
		}
	}
	if($_POST['Obj_Type'] == "Сооружение"){
		$objPHPExcel->getActiveSheet()->setCellValue('CZ28', "V");
		$objPHPExcel->getActiveSheet()->setCellValue('B37', iconv("Windows-1251", "UTF-8", $_POST['con_ass']));
	}
	if($_POST['Obj_Type'] == "Помещение"){
		$objPHPExcel->getActiveSheet()->setCellValue('AB29', "V");
		if($_POST['Obj_Ass'] == "Жилое"){
			$objPHPExcel->getActiveSheet()->setCellValue('AB33', "V");
			if($_POST['Flat_Type'] == "Квартира"){
				$objPHPExcel->getActiveSheet()->setCellValue('AB35', "V");
			}
			if($_POST['Flat_Type'] == "Комната"){
				$objPHPExcel->getActiveSheet()->setCellValue('BI35', "V");
			}
		}
		if($_POST['Obj_Ass'] == "Нежилое"){
			$objPHPExcel->getActiveSheet()->setCellValue('BI33', "V");
		}
	}
	if($_POST['Obj_Type'] == "Объект"){
		$objPHPExcel->getActiveSheet()->setCellValue('CZ29', "V");
	}
	
	if($_POST['Obj_Type'] == "Здание" || $_POST['Obj_Type'] == "Сооружение" || $_POST['Obj_Type'] == "Объект"){
		if($_POST['Parent_CadastralNumber1'])
			$objPHPExcel->getActiveSheet()->setCellValue('AT39', iconv("Windows-1251", "UTF-8", $_POST['Parent_CadastralNumber1']));
		if($_POST['Parent_CadastralNumber2'])
			$objPHPExcel->getActiveSheet()->setCellValue('A40', iconv("Windows-1251", "UTF-8", $_POST['Parent_CadastralNumber2']));
		if($_POST['Parent_CadastralNumber3'])
			$objPHPExcel->getActiveSheet()->setCellValue('A41', iconv("Windows-1251", "UTF-8", $_POST['Parent_CadastralNumber3']));
		if($_POST['Parent_CadastralNumber4'])
			$objPHPExcel->getActiveSheet()->setCellValue('A42', iconv("Windows-1251", "UTF-8", $_POST['Parent_CadastralNumber4']));
		$objPHPExcel->getActiveSheet()->setCellValue('AT43', iconv("Windows-1251", "UTF-8", "—"));
		$objPHPExcel->getActiveSheet()->setCellValue('AT44', iconv("Windows-1251", "UTF-8", "—"));
	}else{
		$objPHPExcel->getActiveSheet()->setCellValue('AT39', iconv("Windows-1251", "UTF-8", "—"));
	}
	
	if($_POST['Obj_Type'] == "Помещение"){
		if($_POST['Obj_Ass'] == "Жилое"){
			if($_POST['Flat_Type'] == "Квартира"){
				if($_POST['Cad_Number'])
					$objPHPExcel->getActiveSheet()->setCellValue('AT43', iconv("Windows-1251", "UTF-8", $_POST['Cad_Number']));
				$objPHPExcel->getActiveSheet()->setCellValue('AT44', iconv("Windows-1251", "UTF-8", "—"));
			}
			if($_POST['Flat_Type'] == "Комната"){
				if($_POST['Cad_Number'])
					$objPHPExcel->getActiveSheet()->setCellValue('AT43', iconv("Windows-1251", "UTF-8", "—"));
				$objPHPExcel->getActiveSheet()->setCellValue('AT44', iconv("Windows-1251", "UTF-8", $_POST['Cad_Number']));
			}
		}
		if($_POST['Obj_Ass'] == "Нежилое"){
			if($_POST['Cad_Number'])
				$objPHPExcel->getActiveSheet()->setCellValue('AT43', iconv("Windows-1251", "UTF-8", $_POST['Cad_Number']));
			$objPHPExcel->getActiveSheet()->setCellValue('AT44', iconv("Windows-1251", "UTF-8", "—"));
		}
	}
	
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
	$objWriter->save("excel/declarations/1 Декларация ".$GUID.".xlsx");
	
	//-------------------------------------------------------------------------------------------
	//Лист 2
	$objPHPExcel = PHPExcel_IOFactory::load("excel/templates/2 Декларация.xlsx");
	$objPHPExcel->setActiveSheetIndex(0);
	
	$objPHPExcel->getActiveSheet()->setCellValue('AF4', $_POST['Area']);
	
	if($_POST['Obj_Type'] == "Помещение"){
		$objPHPExcel->getActiveSheet()->setCellValue('CU4', $_POST['floor']);
	}
	
	if($_POST['Obj_Type'] == "Здание"){
		$objPHPExcel->getActiveSheet()->setCellValue('BI5', $_POST['floor']);
		if($_POST['wall'] == "Крипич"){
			$objPHPExcel->getActiveSheet()->setCellValue('Z8', "V");
		}
		if($_POST['wall'] == "Бетон"){
			$objPHPExcel->getActiveSheet()->setCellValue('AX8', "V");
		}
		if($_POST['wall'] == "Камень"){
			$objPHPExcel->getActiveSheet()->setCellValue('BS8', "V");
		}
		if($_POST['wall'] == "Деревянный"){
			$objPHPExcel->getActiveSheet()->setCellValue('CR8', "V");
		}
		if($_POST['wall'] == "Прочий"){
			$objPHPExcel->getActiveSheet()->setCellValue('Z9', "V");
		}
		if($_POST['wall'] == "Смешанный"){
			$objPHPExcel->getActiveSheet()->setCellValue('AX9', "V");
		}
	}
	
	$year = $_POST['Year'];
	$objPHPExcel->getActiveSheet()->setCellValue('BY6', iconv("Windows-1251", "UTF-8", substr($year, 0, 1)));
	$objPHPExcel->getActiveSheet()->setCellValue('CC6', iconv("Windows-1251", "UTF-8", substr($year, 1, 1)));
	$objPHPExcel->getActiveSheet()->setCellValue('CG6', iconv("Windows-1251", "UTF-8", substr($year, 2, 1)));
	$objPHPExcel->getActiveSheet()->setCellValue('CK6', iconv("Windows-1251", "UTF-8", substr($year, 3, 1)));
	
	
	if($_POST['Client'] == "Person"){
		$objPHPExcel->getActiveSheet()->setCellValue('AU12', iconv("Windows-1251", "UTF-8", $_POST['Clientf']));
		$objPHPExcel->getActiveSheet()->setCellValue('AU13', iconv("Windows-1251", "UTF-8", $_POST['Clienti']));
		$objPHPExcel->getActiveSheet()->setCellValue('AU14', iconv("Windows-1251", "UTF-8", $_POST['Cliento']));
		$objPHPExcel->getActiveSheet()->setCellValue('BE15', iconv("Windows-1251", "UTF-8", $_POST['document']));
		$objPHPExcel->getActiveSheet()->setCellValue('J16', iconv("Windows-1251", "UTF-8", $_POST['documentg']));
		
		$Postal_Code1 = $_POST['Postal_Code1'];
		$objPHPExcel->getActiveSheet()->setCellValue('AV19', iconv("Windows-1251", "UTF-8", substr($Postal_Code1, 0, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AZ19', iconv("Windows-1251", "UTF-8", substr($Postal_Code1, 1, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BD19', iconv("Windows-1251", "UTF-8", substr($Postal_Code1, 2, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BH19', iconv("Windows-1251", "UTF-8", substr($Postal_Code1, 3, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BL19', iconv("Windows-1251", "UTF-8", substr($Postal_Code1, 4, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BP19', iconv("Windows-1251", "UTF-8", substr($Postal_Code1, 5, 1)));
		
		$objPHPExcel->getActiveSheet()->setCellValue('AV20', iconv("Windows-1251", "UTF-8", $regionname));
		
		if($_POST['City1'] != ""){
			$objPHPExcel->getActiveSheet()->setCellValue('AV21', iconv("Windows-1251", "UTF-8", $_POST['City1']));
		}else{
			$objPHPExcel->getActiveSheet()->setCellValue('AV21', iconv("Windows-1251", "UTF-8", "—"));
		}
		
		if($_POST['District1'] != ""){
			$objPHPExcel->getActiveSheet()->setCellValue('AV22', iconv("Windows-1251", "UTF-8", $_POST['District1']));
		}else{
			$objPHPExcel->getActiveSheet()->setCellValue('AV22', iconv("Windows-1251", "UTF-8", "—"));
		}
		
		if($_POST['Locality1'] != ""){
			$objPHPExcel->getActiveSheet()->setCellValue('AV23', iconv("Windows-1251", "UTF-8", $_POST['Locality1']));
		}else{
			$objPHPExcel->getActiveSheet()->setCellValue('AV23', iconv("Windows-1251", "UTF-8", "—"));
		}
		
		if($_POST['Street_Name1'] != ""){
			$objPHPExcel->getActiveSheet()->setCellValue('AV24', iconv("Windows-1251", "UTF-8", $_POST['Street_Name1']));
		}else{
			$objPHPExcel->getActiveSheet()->setCellValue('AV24', iconv("Windows-1251", "UTF-8", "—"));
		}
		
		$house = $_POST['Level1_Name1'];
		$objPHPExcel->getActiveSheet()->setCellValue('AV25', iconv("Windows-1251", "UTF-8", substr($house, 0, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AZ25', iconv("Windows-1251", "UTF-8", substr($house, 1, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BD25', iconv("Windows-1251", "UTF-8", substr($house, 2, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BH25', iconv("Windows-1251", "UTF-8", substr($house, 3, 1)));
		
		$house = $_POST['Level2_Name1'];
		$objPHPExcel->getActiveSheet()->setCellValue('AV26', iconv("Windows-1251", "UTF-8", substr($house, 0, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AZ26', iconv("Windows-1251", "UTF-8", substr($house, 1, 1)));
		
		$house = $_POST['Level4_Name1'];
		$objPHPExcel->getActiveSheet()->setCellValue('CJ26', iconv("Windows-1251", "UTF-8", substr($house, 0, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CN26', iconv("Windows-1251", "UTF-8", substr($house, 1, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CR26', iconv("Windows-1251", "UTF-8", substr($house, 2, 1)));
		
		if($_POST['email1'] != ""){
			$objPHPExcel->getActiveSheet()->setCellValue('AV27', iconv("Windows-1251", "UTF-8", $_POST['email1']));
		}
	}
	if($_POST['Client'] == "Organization"){
		$objPHPExcel->getActiveSheet()->setCellValue('A30', iconv("Windows-1251", "UTF-8", $_POST['org_name']));
		
		$house = $_POST['org_ogrn'];
		$objPHPExcel->getActiveSheet()->setCellValue('AV31', iconv("Windows-1251", "UTF-8", substr($house, 0, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AZ31', iconv("Windows-1251", "UTF-8", substr($house, 1, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BD31', iconv("Windows-1251", "UTF-8", substr($house, 2, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BH31', iconv("Windows-1251", "UTF-8", substr($house, 3, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BL31', iconv("Windows-1251", "UTF-8", substr($house, 4, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BP31', iconv("Windows-1251", "UTF-8", substr($house, 5, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BT31', iconv("Windows-1251", "UTF-8", substr($house, 6, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BX31', iconv("Windows-1251", "UTF-8", substr($house, 7, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CB31', iconv("Windows-1251", "UTF-8", substr($house, 8, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CF31', iconv("Windows-1251", "UTF-8", substr($house, 9, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CJ31', iconv("Windows-1251", "UTF-8", substr($house, 10, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CN31', iconv("Windows-1251", "UTF-8", substr($house, 11, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CR31', iconv("Windows-1251", "UTF-8", substr($house, 12, 1)));
		
		$datereg = $_POST['org_date'];

		$objPHPExcel->getActiveSheet()->setCellValue('AV32', iconv("Windows-1251", "UTF-8", substr($datereg, 0, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AZ32', iconv("Windows-1251", "UTF-8", substr($datereg, 1, 1)));

		$objPHPExcel->getActiveSheet()->setCellValue('BD32', iconv("Windows-1251", "UTF-8", substr($datereg, 3, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BH32', iconv("Windows-1251", "UTF-8", substr($datereg, 4, 1)));

		$objPHPExcel->getActiveSheet()->setCellValue('BL32', iconv("Windows-1251", "UTF-8", substr($datereg, 6, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BP32', iconv("Windows-1251", "UTF-8", substr($datereg, 7, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BT32', iconv("Windows-1251", "UTF-8", substr($datereg, 8, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BX32', iconv("Windows-1251", "UTF-8", substr($datereg, 9, 1)));
		
		$house = $_POST['org_inn'];
		$objPHPExcel->getActiveSheet()->setCellValue('AV33', iconv("Windows-1251", "UTF-8", substr($house, 0, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AZ33', iconv("Windows-1251", "UTF-8", substr($house, 1, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BD33', iconv("Windows-1251", "UTF-8", substr($house, 2, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BH33', iconv("Windows-1251", "UTF-8", substr($house, 3, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BL33', iconv("Windows-1251", "UTF-8", substr($house, 4, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BP33', iconv("Windows-1251", "UTF-8", substr($house, 5, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BT33', iconv("Windows-1251", "UTF-8", substr($house, 6, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BX33', iconv("Windows-1251", "UTF-8", substr($house, 7, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CB33', iconv("Windows-1251", "UTF-8", substr($house, 8, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CF33', iconv("Windows-1251", "UTF-8", substr($house, 9, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CJ33', iconv("Windows-1251", "UTF-8", substr($house, 10, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CN33', iconv("Windows-1251", "UTF-8", substr($house, 11, 1)));
		
		$house = $_POST['org_num'];
		$objPHPExcel->getActiveSheet()->setCellValue('AN36', iconv("Windows-1251", "UTF-8", substr($house, 0, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AR36', iconv("Windows-1251", "UTF-8", substr($house, 1, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AV36', iconv("Windows-1251", "UTF-8", substr($house, 2, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AZ36', iconv("Windows-1251", "UTF-8", substr($house, 3, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BD36', iconv("Windows-1251", "UTF-8", substr($house, 4, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BH36', iconv("Windows-1251", "UTF-8", substr($house, 5, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BL36', iconv("Windows-1251", "UTF-8", substr($house, 6, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BP36', iconv("Windows-1251", "UTF-8", substr($house, 7, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BT36', iconv("Windows-1251", "UTF-8", substr($house, 8, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BX36', iconv("Windows-1251", "UTF-8", substr($house, 9, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CB36', iconv("Windows-1251", "UTF-8", substr($house, 10, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CF36', iconv("Windows-1251", "UTF-8", substr($house, 11, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CJ36', iconv("Windows-1251", "UTF-8", substr($house, 12, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CN36', iconv("Windows-1251", "UTF-8", substr($house, 13, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CR36', iconv("Windows-1251", "UTF-8", substr($house, 14, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CV36', iconv("Windows-1251", "UTF-8", substr($house, 15, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CZ36', iconv("Windows-1251", "UTF-8", substr($house, 16, 1)));
		
		$house = $_POST['Postal_Code1'];
		$objPHPExcel->getActiveSheet()->setCellValue('AN37', iconv("Windows-1251", "UTF-8", substr($house, 0, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AR37', iconv("Windows-1251", "UTF-8", substr($house, 1, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AV37', iconv("Windows-1251", "UTF-8", substr($house, 2, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AZ37', iconv("Windows-1251", "UTF-8", substr($house, 3, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BD37', iconv("Windows-1251", "UTF-8", substr($house, 4, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BH37', iconv("Windows-1251", "UTF-8", substr($house, 5, 1)));
		
		
		$objPHPExcel->getActiveSheet()->setCellValue('AN39', iconv("Windows-1251", "UTF-8", $regionname));
		
		if($_POST['City1'] != ""){
			$objPHPExcel->getActiveSheet()->setCellValue('AN40', iconv("Windows-1251", "UTF-8", $_POST['City1']));
		}else{
			$objPHPExcel->getActiveSheet()->setCellValue('AN40', iconv("Windows-1251", "UTF-8", "—"));
		}
		
		if($_POST['District1'] != ""){
			$objPHPExcel->getActiveSheet()->setCellValue('AN41', iconv("Windows-1251", "UTF-8", $_POST['District1']));
		}else{
			$objPHPExcel->getActiveSheet()->setCellValue('AN41', iconv("Windows-1251", "UTF-8", "—"));
		}
	}

	
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
	$objWriter->save("excel/declarations/2 Декларация ".$GUID.".xlsx");
	
	//-------------------------------------------------------------------------------------------
	//Лист 3
	$objPHPExcel = PHPExcel_IOFactory::load("excel/templates/3 Декларация.xlsx");
	$objPHPExcel->setActiveSheetIndex(0);
	
	if($_POST['Client'] == "Organization"){
		if($_POST['Locality1'] != ""){
			$objPHPExcel->getActiveSheet()->setCellValue('AV3', iconv("Windows-1251", "UTF-8", $_POST['Locality_type1']." ".$_POST['Locality1']));
		}else{
			$objPHPExcel->getActiveSheet()->setCellValue('AV3', iconv("Windows-1251", "UTF-8", "—"));
		}
		
		if($_POST['Street_Name1'] != ""){
			$objPHPExcel->getActiveSheet()->setCellValue('AV4', iconv("Windows-1251", "UTF-8", $_POST['Street_Type1']." ".$_POST['Street_Name1']));
		}else{
			$objPHPExcel->getActiveSheet()->setCellValue('AV4', iconv("Windows-1251", "UTF-8", "—"));
		}
		
		$house = $_POST['Level1_Name1'];
		$objPHPExcel->getActiveSheet()->setCellValue('AP5', iconv("Windows-1251", "UTF-8", substr($house, 0, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AT5', iconv("Windows-1251", "UTF-8", substr($house, 1, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('AX5', iconv("Windows-1251", "UTF-8", substr($house, 2, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('BB5', iconv("Windows-1251", "UTF-8", substr($house, 3, 1)));
		
		$house = $_POST['Level2_Name1'];
		$objPHPExcel->getActiveSheet()->setCellValue('CR5', iconv("Windows-1251", "UTF-8", substr($house, 0, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CV5', iconv("Windows-1251", "UTF-8", substr($house, 1, 1)));
		$objPHPExcel->getActiveSheet()->setCellValue('CZ5', iconv("Windows-1251", "UTF-8", substr($house, 1, 1)));
		
		if($_POST['email1'] != ""){
			$objPHPExcel->getActiveSheet()->setCellValue('AV27', iconv("Windows-1251", "UTF-8", $_POST['email1']));
		}
	}
	if($_POST['Client'] == "Governance"){
		if($_POST['gov_type'] == "РФ"){
			$objPHPExcel->getActiveSheet()->setCellValue('BB8', "V");
		}
		if($_POST['gov_type'] == "СРФ"){
			$objPHPExcel->getActiveSheet()->setCellValue('BB9', "V");
			$objPHPExcel->getActiveSheet()->setCellValue('AE10', iconv("Windows-1251", "UTF-8", $_POST['gov_name']));
		}
		if($_POST['gov_type'] == "МО"){
			$objPHPExcel->getActiveSheet()->setCellValue('BB11', "V");
			$objPHPExcel->getActiveSheet()->setCellValue('AE12', iconv("Windows-1251", "UTF-8", $_POST['gov_name']));
		}
		if($_POST['gov_type'] == "ИГ"){
			$objPHPExcel->getActiveSheet()->setCellValue('BB13', "V");
			$objPHPExcel->getActiveSheet()->setCellValue('AE14', iconv("Windows-1251", "UTF-8", $_POST['gov_name']));
		}
	}
	if($_POST['owner'] != ""){
		$objPHPExcel->getActiveSheet()->setCellValue('A16', iconv("Windows-1251", "UTF-8", $_POST['owner']));
	}
	
	for($i = 1; $i <= $_POST['add_new_doc_']; $i++){
		$f = fopen("DocumentsTP.csv", "r");
		$data = fgetcsv($f, 1000, ';');
		for($j = 1;;$j++){
				if($data[0] == $_POST['select_doc_'.$i])
				{
					$docname = $data[1];
					break;
				}
				$data = fgetcsv($f, 1000, ';');
		}
		fclose($f);
		if($_POST['Date'.$i] != "")
			$docname .= " от ".$_POST['Date'.$i]." г.";
		if($_POST['Series'.$i] != "")
			$docname .= " серия ".$_POST['Series'.$i];
		if($_POST['Number'.$i] != "")
			$docname .= " № ".$_POST['Number'.$i];
		$objPHPExcel->getActiveSheet()->setCellValue('A'.(22 + $i), iconv("Windows-1251", "UTF-8", $docname));
	}
	
	$objPHPExcel->getActiveSheet()->setCellValue('I33', iconv("Windows-1251", "UTF-8", $_POST['date']));
	
	$pod = "/".$_POST['Clientf']." ".substr($_POST['Clienti'], 0, 1).". ".substr($_POST['Cliento'], 0, 1)."./";
	$objPHPExcel->getActiveSheet()->setCellValue('AE35', iconv("Windows-1251", "UTF-8", $pod));
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
	$objWriter->save("excel/declarations/3 Декларация ".$GUID.".xlsx");
	
	
	$zip = new ZipArchive(); 
	$zip->open("excel/declarations/Декларация ".$GUID.".zip", ZIPARCHIVE::CREATE); 
	
	$filecontents = file_get_contents("excel/declarations/3 Декларация ".$GUID.".xlsx");
	$zip->addFromString(iconv('windows-1251', 'cp866', "3 Декларация ".$GUID.".xlsx"), $filecontents); 


	$filecontents = file_get_contents("excel/declarations/2 Декларация ".$GUID.".xlsx");
	$zip->addFromString(iconv('windows-1251', 'cp866', "2 Декларация ".$GUID.".xlsx"), $filecontents); 
	
		
	$filecontents = file_get_contents("excel/declarations/1 Декларация ".$GUID.".xlsx");
	$zip->addFromString(iconv('windows-1251', 'cp866', "1 Декларация ".$GUID.".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); 
?>