<?php


        if (isset($_POST['startdatum10']) && isset($_POST['einddatum10'])) {

            $startdate = createTimeStampDate($_POST['startdatum10']);
            $einddatum = createTimeStampDateWKKenGSCEnd($_POST['einddatum10']);


             // Create new PHPExcel object
            $objPHPExcel = new PHPExcel();


        $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_sqlite;

            if(!PHPExcel_Settings::setCacheStorageMethod($cacheMethod)) {
                exit;
            }

            // Set document properties
            $objPHPExcel->getProperties()->setCreator("energy")
                    ->setLastModifiedBy("energy")
                    ->setTitle("energy")
                    ->setSubject("energy")
                    ->setDescription("energy")
                    ->setKeywords("energy")
                    ->setCategory("energy");

           $verbruiks = $blVerbruik->getVerbruikBetweenDates("verbruik_$ean", $startdate, $einddatum);

                            // hoofding en tabelhoofding
                            $objPHPExcel->setActiveSheetIndex(0)
                                    ->setCellValueExplicit('A1', utf8_encode($ean), PHPExcel_Cell_DataType::TYPE_STRING)
                                    ->setCellValueExplicit('A2', utf8_encode("Timestamp"), PHPExcel_Cell_DataType::TYPE_STRING)
                                    ->setCellValueExplicit('B2', utf8_encode("Datum"), PHPExcel_Cell_DataType::TYPE_STRING)
                                    ->setCellValueExplicit('C2', utf8_encode("Actief vermogen (Kw)"), PHPExcel_Cell_DataType::TYPE_STRING)
                                    ->setCellValueExplicit('D2', utf8_encode("Inductief vermogen (Kw)"), PHPExcel_Cell_DataType::TYPE_STRING)
                                    ->setCellValueExplicit('E2', utf8_encode("Capacitief vermogen (Kw)"), PHPExcel_Cell_DataType::TYPE_STRING);

                            $teller = 3;

                    if ($verbruiks != null) {
                                foreach ($verbruiks as $verbruik) {
                                    $startdate = $verbruik->getTijd() + date('Z', $verbruik->getTijd());

                                    $ExcelDate = 25569 + $startdate / 86400;


                                    $objPHPExcel->setActiveSheetIndex(0)
                                            ->setCellValue('A' . $teller, utf8_encode($verbruik->getTijd()))
                                            ->setCellValue('B' . $teller, $ExcelDate)
                                            ->setCellValueExplicit('C' . $teller, utf8_encode($verbruik->getA()), PHPExcel_Cell_DataType::TYPE_NUMERIC)
                                            ->setCellValueExplicit('D' . $teller, utf8_encode($verbruik->getI()), PHPExcel_Cell_DataType::TYPE_NUMERIC)
                                            ->setCellValueExplicit('E' . $teller, utf8_encode($verbruik->getC()), PHPExcel_Cell_DataType::TYPE_NUMERIC);

                                    $objPHPExcel->getActiveSheet()->getStyle('B' . $teller)->getNumberFormat()->setFormatCode('dd/mm/yyyy H:m:s');

                                    $teller++;
                                }
                            }



            // Rename worksheet
            $objPHPExcel->getActiveSheet()->setTitle('Energy');

            // Set active sheet index to the first sheet, so Excel opens this as the first sheet
            $objPHPExcel->setActiveSheetIndex(0);

            if ($ean_obj != null) {
                if ($ean_obj->getKlantnummer() != "") {
                    $filename = $ean_obj->getKlantnummer() . "_";
                }

                $filename .= $ean_obj->getType() . "_" . $ean_obj->getBemetering() . "_" . $ean_obj->getEan() . "_" . date("Ymd", $startdate) . "_" . date("Ymd", $einddatum) . ".xlsx";
            } else {
                $filename = "EVSEnergydata.xlsx";
            }

            //  Redirect output to a client’s web browser (Excel5)
            header('Content-Type: application/vnd.ms-excel');
            header('Content-Disposition: attachment;filename="' . $filename . '"');
            header('Cache-Control: max-age=0');



            $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
            $objWriter->save('php://output');

            exit;
        } else {
            header("Location: admin_data/2");
        }
    }

?>