<?
//error_reporting(E_ALL);
//ini_set('display_errors', 1);

ini_set("memory_limit", "256M");

require('api.php');

if ( isset($_GET['lang']) ){
	$lang = $_GET['lang'];
} else {
	$lang = 'ua';
}

$function = 'Branch000';
$where = "Branchtype = 'ППВ'";
$where = '';
$order    = 'RegionDescriptionUA, CityDescriptionUA';

$function = 'Branch1';
$where = '(LimitDelivery = 0 OR LimitJustReceive = 0)';
$order    = 'RegionDescriptionUA, CityDescriptionUA';

$xml = api($function, $where, $order);

set_time_limit(600);

//print_r($xml);
//die();

include('excell.php');
header('Content-Type: application/force-download');
header('Content-Type: application/octet-stream');
header('Content-Type: application/download');
header('Content-Disposition: attachment;filename=conv_' . 'file' . ".xls"); 
header('Content-Transfer-Encoding: binary');
			
xlsBOF();
$handle = fopen($download_file, 'r');
$i = 0;
xlsWriteLabel ($i, 0, iconv('UTF-8', 'windows-1251', 'Відділення'));
xlsWriteLabel ($i, 1, iconv('UTF-8', 'windows-1251', 'Тип'));
xlsWriteLabel ($i, 2, iconv('UTF-8', 'windows-1251', 'Адрес'));
xlsWriteLabel ($i, 3, iconv('UTF-8', 'windows-1251', 'пн-пт'));
xlsWriteLabel ($i, 4, iconv('UTF-8', 'windows-1251', 'сб'));
xlsWriteLabel ($i, 5, iconv('UTF-8', 'windows-1251', 'нд'));
xlsBOF();
$i = 0;
$last_region = '';

foreach ($xml->result_table->items as $row){
	$region   = (string)$row->RegionDescriptionUA;
	$name     = (string)$row->DescriptionUA;
	$city     = (string)$row->CityDescriptionUA;
	$street   = (string)$row->StreetDescriptionUA;
	$house    = (string)$row->House;
	$flat     = trim((string)$row->Flat);
	$lim      = $row->Limitweight;
	$type     = $row->Branchtype;
	$code     = $row->BranchCode;
	$arr_shc  = explode (';', str_replace(array('Пн ', ' Вт ', ' Ср ', ' Чт ', ' Пт ', ' Сб ', ' Нд ', '--:-- - --:--'), '', (string)$row->WorkingHours));
	$only_r   = (string)$row->OnlyReceiver;
	$lat      = $row->Latitude;
	$lon      = $row->Longitude;
	$adr_more = $row->AddressMoreInformation;
	
	if ($city == ''){
		continue;
	}
	
	if ($only_r == '1'){
		$only_r_txt = '*';
	} else {
		$only_r_txt = '';
	}
	
	$adress = $street;
	if ($house != ''){
		$adress .= ', ' . $house;
	}
	if ($flat != ''){
		$adress .= '/' . $flat;
	}
	if ($adr_more != ''){
		//$adress .= ' (' . $adr_more . ')';
	}
	
	$i++;
	
	if ($last_region != $region){
		xlsWriteLabel ($i, 0, iconv('UTF-8', 'windows-1251', $region . '  область'));
		xlsWriteLabel ($i, 1, '');
		xlsWriteLabel ($i, 2, '');
		xlsWriteLabel ($i, 3, '');
		xlsWriteLabel ($i, 4, '');
		xlsWriteLabel ($i, 5, '');
		$i++;
	}
	$last_region = $region;
	
	xlsWriteLabel ($i, 0, iconv('UTF-8', 'windows-1251', $city));
	xlsWriteLabel ($i, 1, iconv('UTF-8', 'windows-1251', $type . '  ' . $only_r_txt . ' №' . $code));
	xlsWriteLabel ($i, 2, iconv('UTF-8', 'windows-1251', $adress));
	xlsWriteLabel ($i, 3, iconv('UTF-8', 'windows-1251', $arr_shc[0]));
	xlsWriteLabel ($i, 4, iconv('UTF-8', 'windows-1251', $arr_shc[5]));
	xlsWriteLabel ($i, 5, iconv('UTF-8', 'windows-1251', $arr_shc[6]));
}
xlsEOF();