<?php session_start();
/**
 * Created by PhpStorm.
 * User: Przemek
 * Date: 2015-10-15
 * Time: 01:16
 */

require_once '../PHPExcel.php';

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

$styleArray = array(
        'font'  => array(
        'bold'  => true,
        'size'  => 16
    ));

$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A1:L1');
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(25);
$objPHPExcel->getActiveSheet()->getStyle('A1:L1')->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->SetCellValue('A1', $_SESSION['site401ahis_devName'].' - historia pomiarów ['.$_SESSION['site401ahis_from'].' - '.$_SESSION['site401ahis_to'].']');

$objPHPExcel->getActiveSheet()->SetCellValue('A2', 'Lp.');
$objPHPExcel->getActiveSheet()->SetCellValue('B2', 'Data');
$objPHPExcel->getActiveSheet()->SetCellValue('C2', 'Hst [m]');
$objPHPExcel->getActiveSheet()->SetCellValue('D2', 'Hd [m]');
$objPHPExcel->getActiveSheet()->SetCellValue('E2', 'Q [m3/min]');
$objPHPExcel->getActiveSheet()->SetCellValue('F2', 'p1 [m]');
$objPHPExcel->getActiveSheet()->SetCellValue('G2', 'p2 [m]');
$objPHPExcel->getActiveSheet()->SetCellValue('H2', 'I [A]');
$objPHPExcel->getActiveSheet()->SetCellValue('I2', 'U [V]');
$objPHPExcel->getActiveSheet()->SetCellValue('J2', 'Pe [kW]');
$objPHPExcel->getActiveSheet()->SetCellValue('K2', 'cos (fi)');
$objPHPExcel->getActiveSheet()->SetCellValue('L2', 'Czas pracy [h]');

for($i=0;$i<count($_SESSION['site401ahis_array']);$i++)
{
    $objPHPExcel->getActiveSheet()->SetCellValue('A'.($i+3), $i+1);
    $objPHPExcel->getActiveSheet()->SetCellValue('B'.($i+3), $_SESSION['site401ahis_array'][$i]['his_date']);
    $objPHPExcel->getActiveSheet()->SetCellValue('C'.($i+3), $_SESSION['site401ahis_array'][$i]['his_hst']);
    $objPHPExcel->getActiveSheet()->SetCellValue('D'.($i+3), $_SESSION['site401ahis_array'][$i]['his_hd']);
    $objPHPExcel->getActiveSheet()->SetCellValue('E'.($i+3), $_SESSION['site401ahis_array'][$i]['his_q']);
    $objPHPExcel->getActiveSheet()->SetCellValue('F'.($i+3), $_SESSION['site401ahis_array'][$i]['his_p1']);
    $objPHPExcel->getActiveSheet()->SetCellValue('G'.($i+3), $_SESSION['site401ahis_array'][$i]['his_p2']);
    $objPHPExcel->getActiveSheet()->SetCellValue('H'.($i+3), $_SESSION['site401ahis_array'][$i]['his_I']);
    $objPHPExcel->getActiveSheet()->SetCellValue('I'.($i+3), $_SESSION['site401ahis_array'][$i]['his_U']);
    $objPHPExcel->getActiveSheet()->SetCellValue('J'.($i+3), $_SESSION['site401ahis_array'][$i]['his_PE']);
    $objPHPExcel->getActiveSheet()->SetCellValue('K'.($i+3), $_SESSION['site401ahis_array'][$i]['his_cos']);
    $objPHPExcel->getActiveSheet()->SetCellValue('L'.($i+3), $_SESSION['site401ahis_array'][$i]['his_work_time']);


}
$objPHPExcel->getActiveSheet()->setTitle('historia pomiarów');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;
?>