<?php
	set_time_limit(0);
	ini_set('memory_limit', '-1');
	date_default_timezone_set("Europe/Moscow");
	require_once 'php/Classes/PHPExcel.php';
	require_once 'php/Classes/PHPExcel/IOFactory.php';
	
	if(isset($_POST['upload'])){
		$whitelist = array(".csv");         
		$data = array();
		$error = true;
		foreach  ($whitelist as  $item) {
			if(preg_match("/$item\$/i",$_FILES['userfile']['name'])) $error = false;
		}
		if(!$error){
			$uploadedFile =  "csv/".$_FILES['userfile']['name'];	
			if(is_uploaded_file($_FILES['userfile']['tmp_name'])){
			
				if(move_uploaded_file($_FILES['userfile']['tmp_name'],$uploadedFile)){
			
					$data = $_FILES['userfile'];
					$flag = 1;
				}
			}
		}
	}
	
	
	
	
	$objPHPExcel = PHPExcel_IOFactory::load("./excel/templates/Шаблон302.xlsx");
	$objPHPExcel->setActiveSheetIndex(0);
	
	$csvname = $data['name'];
	$f = fopen("csv/".$csvname, "r");
	$csv = fgetcsv($f, 1000, ';');
	$i = 0;
	//10*$i + 1
	while($csv){
		$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 4), iconv("Windows-1251", "UTF-8", "—"));
		$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 5), iconv("Windows-1251", "UTF-8", $csv[2]));
		$address = $_POST['address'];
		if($csv[3] == "1"){
			$address .= " , кв. ".$csv[0];
		}
		$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 6), iconv("Windows-1251", "UTF-8", $address));
		if($csv[3] == "1"){
			$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 7), iconv("Windows-1251", "UTF-8", "—"));
			$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 8), iconv("Windows-1251", "UTF-8", "Жилое"));
			$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 9), iconv("Windows-1251", "UTF-8", "Квартира"));
		}
		if($csv[3] == "2"){
			$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 7), iconv("Windows-1251", "UTF-8", "нежилое помещение ".$csv[0]));
			$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 8), iconv("Windows-1251", "UTF-8", "Нежилое"));
			$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 9), iconv("Windows-1251", "UTF-8", "—"));
		}
		$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 10), iconv("Windows-1251", "UTF-8", $csv[1]));
		$csv = fgetcsv($f, 1000, ';');
		$i++;
	}
	fclose($f);
	
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
	$objWriter->save("csv/".$csvname.".xlsx");
	
	
	$filename = "Результат.xlsx";
	$file="csv/".$csvname.".xlsx";
	$size = filesize($file);
	header("Content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
	header("Content-Length: ".$size);
	header("Content-Disposition: attachment; filename=".$filename."");
	readfile($file);
?>