<?
	defined('_JEXEC') or die('=;)');

	jimport('joomla.application.component.view');
	require_once('Spreadsheet/Excel/Writer.php');
	
	
	class vxcViewMAReports extends JView
	{
	
		function display($tpl = null)
		{
			$document    = & JFactory::getDocument();
						
			$modelReports =& $this->getModel('reports');
			
			$report =& $modelReports->getData();		
			$lists = & $modelReports->getList();
						
			/*
			$modelCheckingOrders =& $this->getModel('checkingorders');			
			$orders	=& $modelCheckingOrders->getData();			
			
			$modelOrderAttribute =& $this->getModel('orderattribute');	
			
			$this->assignRef('orders', $orders);						
			$this->assignRef('att',$modelOrderAttribute);
			
				*/	
			//$this->_layout = JRequest::getVar('layout','default');	
			$this->_layout = 'csvreport';//JRequest::getVar('layout','default');	
			
			$date = new JDate();
			$date->setOffset(date('Z')/3600.0);			
			$filename = 'report'.$lists['searchreporttype'].'_'.$date->toFormat("%Y%m%d_%H%M%S");
			
			$typeformat = JRequest::getVar('typeformat');
			
			
			if ($typeformat == 'csv')			
			{
				$document->setMimeEncoding('text/csv');
				$filename .= ".csv";
				
				$date = gmdate('D, d M Y H:i:s',time()).' GMT';
				$document->setModifiedDate($date);			
							
			//	$document->setCharset('iso-8859-1');
								
				$meta = "attachment; filename=\"" . $filename . "\"";
				JResponse::setHeader('Content-Disposition',$meta);
			
				
			}
			else
			{
				$filename .= ".xls";	
				
				
				require_once 'Spreadsheet/Excel/Writer.php';
				$xls = new Spreadsheet_Excel_Writer();
				$xls->setVersion(8);			
				
				$xls->send($filename);		
				ob_clean();
				flush();
				
				$page =& $xls->addWorksheet('report');	
				$page->setInputEncoding('UTF-8');	
				if (count($report)>0)
				{
					foreach($report[0] as $key2 => $value)
					{
						$keys[] = $key2;
						$sums[$key2] = 0;
					}

					for($col = 0; $col<count($keys);$col++)
						$page->write(0,$col, $keys[$col]);

					$i=0;
					foreach($report as $row)
					{	
						$dataRow= array();
						foreach($row as $key => $value)	
						{
							$dataRow[] = $value;
							$sums[$key] += $value;
						}
						
						for($col = 0; $col< count($dataRow);$col++)
							$page->write($i+1,$col, trim($dataRow[$col]));
						

						$i++;	
					}
				}	
				

				$xls->close();		
				flush();
				exit;
		
				
				
			}							
			
			$this->assignRef('report',$report);
			$this->assignRef('lists', $lists);	
			$this->assignRef('filename',$filename);
			$this->assignRef('typeformat', $typeformat);
					
			parent::display($tpl);
		}// function

	}// class
	
?>