<?php
$xml_data_begin = '<?xml version="1.0"?>
					<?mso-application progid="Excel.Sheet"?>
					<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
					 xmlns:o="urn:schemas-microsoft-com:office:office"
					 xmlns:x="urn:schemas-microsoft-com:office:excel"
					 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
					 xmlns:html="http://www.w3.org/TR/REC-html40">
					  <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
					   <Author>Kazkeyev Z.N.</Author>
					   <LastAuthor>Radmin</LastAuthor>
					   <Created>1980-02-15T00:00:01Z</Created>
					   <Version>12.00</Version>
					  </DocumentProperties>
					  <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
					   <ProtectStructure>False</ProtectStructure>
					   <ProtectWindows>False</ProtectWindows>
					  </ExcelWorkbook>
					<Worksheet ss:Name="Result">';
$xml_data_end = '<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
			   <ProtectObjects>False</ProtectObjects>
			   <ProtectScenarios>False</ProtectScenarios>
			  </WorksheetOptions>
			</Worksheet>
			</Workbook>';
if (ob_get_level()) {ob_end_clean();}
//header('Content-Description: File Transfer');
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=employee.xml");
echo $xml_data_begin;
	
//Наименование столбца(Колонка-РЕГИОН)
echo '<Table x:FullColumns="1"   x:FullRows="1" ss:DefaultRowHeight="15">';
	echo '<Row ss:AutoFitHeight="0">';
		echo '<Cell><Data ss:Type="String">'.mb_convert_encoding("Регион", "utf-8","windows-1251").'</Data></Cell>';
echo '</Row>';

$limit = 10;
/*$queryCount = "SELECT COUNT(*) AS count_row FROM zrdt.report_detail WHERE report_id={$report_id} 
and report_result_id={$report_result_id}";
$database->setQuery($queryCount);*/

//$rowCount = intval($database->query());         
//$rowCount = intval($database->loadResult());
//$rowCount = intval($database->loadRow());
$rowCount = intval($database->setQuery());

$maxStep = round($rowCount / $limit);

for($step = 0; $step <= 3 /* $maxStep */; $step++){//это мой цикл, который не заходит на 2 раз
	
	// $offset = $limit * $step;
	$a = $limit * $step + 1;
	$b = $a + $limit;
	
	$query = " SELECT  f.full_name AS f_name, d.*"
			. " FROM zrdt.report_detail d,zrdt.filial f"
			. " WHERE f.id=d.filial_id AND report_id = " . $report_id . " AND report_result_id = " .$report_result_id
			. " AND rownum BETWEEN {$a} AND {$b}"
			. " ORDER BY filial_id ASC";
	//var_dump($query);

	 $database->setQuery( $query );
	 $rows = $database->loadRowList(); 
	 
	// echo count($rows) . "<br>";

	foreach($rows as $row) {
	 echo '<Row>';
		echo '<Cell><Data ss:Type="String">'.mb_convert_encoding(trim($row['F_NAME']), "utf-8","windows-1251").'</Data></Cell>';	  
	echo '</Row>';	
    };
	$rows = NULL;

};
	
echo '</Table>';
echo $xml_data_end;

exit();
?>