<?php session_start();


require_once '../PHPExcel.php';

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="'.date("Y-m-d").'_raport_chwilowy.xlsx"');
header('Cache-Control: max-age=0');

$styleArray = array(
        'font'  => array(
        'bold'  => true,
        'size'  => 16,
        'color' => array('rgb' => 'B22222')
    ));
$styleArray1 = array(
		'font'  => array(
		'bold'  => true,
		));

$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A1:M1');
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(25);
$objPHPExcel->getActiveSheet()->getStyle('A1:M1')->applyFromArray($styleArray);
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Raport chwilowy pracy systemu odwodnienia wgłębnego '.str_replace('Dębina', 'P/Bełchatów - bariera ochronna Dębina', $_SESSION['syndis_eq_stock']) );


$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A2:I2');
$objPHPExcel->getActiveSheet()->SetCellValue('A2', 'Data: '.$_SESSION['rep007Array'][0]['date']);

$objPHPExcel->getActiveSheet()->SetCellValue('A4','Lp.');
$objPHPExcel->getActiveSheet()->SetCellValue('B4','Studnia');
$objPHPExcel->getActiveSheet()->SetCellValue('C4','Agregat pompowy');
$objPHPExcel->getActiveSheet()->SetCellValue('D4','Moc Pe [kW]');
$objPHPExcel->getActiveSheet()->SetCellValue('E4','Czas pracy [h]');
$objPHPExcel->getActiveSheet()->SetCellValue('F4','Jedn. zużycie energii [Wh/m3/m]');
$objPHPExcel->getActiveSheet()->SetCellValue('G4','HST0 [m]');
$objPHPExcel->getActiveSheet()->SetCellValue('H4','HD [m]');
$objPHPExcel->getActiveSheet()->SetCellValue('I4','Wydajność Q [m3/min]');
$objPHPExcel->getActiveSheet()->SetCellValue('J4','Ciśnienie p1 [m]');
$objPHPExcel->getActiveSheet()->SetCellValue('K4','Ciśnienie p2 [m]');
$objPHPExcel->getActiveSheet()->SetCellValue('L4','Temp. wody [oC]');
$objPHPExcel->getActiveSheet()->SetCellValue('M4','Stężenie chlorków Cl [mg/l]');


$bariera="";
$kolumna=5;

for($i=0;$i<count($_SESSION['rep007Array']);$i++)
{	
	if ($bariera!=$_SESSION['rep007Array'][$i]['bariera'])
	{
		$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A'.($kolumna+$i).':M'.($kolumna+$i));
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.($kolumna+$i), 'Bariera '.$_SESSION['rep007Array'][$i]['bariera']);
		$kolumna++;
		
		$bariera=$_SESSION['rep007Array'][$i]['bariera'];
	}
    $objPHPExcel->getActiveSheet()->SetCellValue('A'.($kolumna+$i), ($i+1));
    $objPHPExcel->getActiveSheet()->SetCellValue('B'.($kolumna+$i), $_SESSION['rep007Array'][$i]['well']);
    $objPHPExcel->getActiveSheet()->SetCellValue('C'.($kolumna+$i), $_SESSION['rep007Array'][$i]['agregat']);
    $objPHPExcel->getActiveSheet()->SetCellValue('D'.($kolumna+$i), $_SESSION['rep007Array'][$i]['moc']);
    $objPHPExcel->getActiveSheet()->SetCellValue('E'.($kolumna+$i), $_SESSION['rep007Array'][$i]['czas']);
    $objPHPExcel->getActiveSheet()->SetCellValue('F'.($kolumna+$i), $_SESSION['rep007Array'][$i]['jzu']);
    $objPHPExcel->getActiveSheet()->SetCellValue('G'.($kolumna+$i), $_SESSION['rep007Array'][$i]['hst']);
    $objPHPExcel->getActiveSheet()->SetCellValue('H'.($kolumna+$i), $_SESSION['rep007Array'][$i]['hd']);
    $objPHPExcel->getActiveSheet()->SetCellValue('I'.($kolumna+$i), $_SESSION['rep007Array'][$i]['q']);
    $objPHPExcel->getActiveSheet()->SetCellValue('J'.($kolumna+$i), $_SESSION['rep007Array'][$i]['p1']);
    $objPHPExcel->getActiveSheet()->SetCellValue('K'.($kolumna+$i), $_SESSION['rep007Array'][$i]['p2']);
    $objPHPExcel->getActiveSheet()->SetCellValue('L'.($kolumna+$i), $_SESSION['rep007Array'][$i]['temp']);
    $objPHPExcel->getActiveSheet()->SetCellValue('M'.($kolumna+$i), $_SESSION['rep007Array'][$i]['clor']);
}


$objPHPExcel->getActiveSheet()->setTitle('Raport chwilowy');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;
?>