Online PHP editor | perf for bgsFj

<?php <?php function cellColor($cells,$color){ global $objPHPExcel; $objPHPExcel->getActiveSheet()->getStyle($cells)->getFill() ->applyFromArray(array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'startcolor' => array('rgb' => $color) )); } $strana = 0; $mesiace = array( '01'=>'Január', '02'=>'Február', '03'=>'Marec', '04'=>'Apríl', '05'=>'Máj', '06'=>'Jún', '07'=>'Júl', '08'=>'August', '09'=>'September', '10'=>'Október', '11'=>'November', '12'=>'December' ); $pop = array( 'B' => 'VŽP', 'C' => 'Cena', 'D' => 'Zber', 'E' => 'Oleje', 'F' => 'Cena', 'G' => 'dátum/kg', 'H' => 'dátum/kg', 'I' => 'dátum/kg', 'J' => 'dátum/kg', 'K' => 'dátum/kg', 'L' => 'dátum/l', 'M' => 'dátum/l', 'N' => 'dátum/l' ); $pos = 0; for ($i = 1; $i <= 12; $i++) { $c = ($i< 10) ? '0'.$i : (string) $i; if ($i-1 > 0) $objPHPExcel->createSheet($i-1); $objPHPExcel->getSheet($i-1)->setTitle($mesiace[$c]); } $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(32); $eArra = array('E', 'G', 'H', 'I', 'J', 'K'); for ($y = 0; $y < count($eArra); $y++) { $objPHPExcel->getActiveSheet()->getColumnDimension($eArra[$y])->setWidth(15); } // Set page orientation, size, Print Area and Fit To Pages $objPageSetup = new PHPExcel_Worksheet_PageSetup(); $objPageSetup->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4); $objPageSetup->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT); $objPageSetup->setPrintArea("A1:N800"); $objPageSetup->setFitToWidth(1); $objPHPExcel->getActiveSheet()->setPageSetup($objPageSetup); ## function recode ($str) { $separator1 = ';'; $separator2 = '&#'; $tmp = explode($separator1, $str); foreach ($tmp as $key=>$value) { $pmt = explode($separator2, $value); foreach ($pmt as $key2=>$value2) { if (is_numeric($value2) && mb_strlen((string) $value2) < 4) $pmt[$key2] = mb_convert_encoding($separator2 . intval($value2) . $separator1, 'UTF-8', 'HTML-ENTITIES'); } $tmp[$key] = implode('', $pmt); } $output = implode('', $tmp); return preg_replace('/\s+/', ' ', $output); } $iterator = 0; foreach ($mesiace as $cislomesiaca=>$nazovmesiaca) { $pos = 0; $objPHPExcel->setActiveSheetIndex($iterator); foreach ($vystup as $key=>$value) { $prevadzka = $value['name']; $kontakt = $value['contact']; $info = $value['note']; $vzp = ($value['waste_vzp'] != 1) ? 'NIE' : 'ÁNO'; $cenavzp = ($value['waste_vzp'] != 1) ? '' : $value['price_vzp']; $zbervzp = ($value['waste_vzp'] != 1) ? '' : $value['collection_vzp'] . 'x'; $oleje = $value['contracts']; $cenaodpad = $value['waste_price']; foreach ($value['wastes'] as $key2=>$value2) { $mesiacik = $mesiace[$key2]; $objPHPExcel->getActiveSheet()->setCellValue('A4', $_GET['y'] . ' - ' . $nazovmesiaca); foreach ($value2 as $key3=>$value3) { foreach ($value3 as $datum=>$vaha) { if ($cislomesiaca == $key2) { } } } } // TBLR $objPHPExcel->getActiveSheet()->getStyle('A' . (7 + $pos) . ':N' . (7 + $pos))->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); $objPHPExcel->getActiveSheet()->getStyle('A' . (7 + $pos) . ':N' . (7 + $pos))->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); $objPHPExcel->getActiveSheet()->getStyle('A' . (7 + $pos) . ':N' . (7 + $pos))->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); $objPHPExcel->getActiveSheet()->getStyle('A' . (7 + $pos) . ':N' . (7 + $pos))->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); // left $objPHPExcel->getActiveSheet()->getStyle('G' . (7 + $pos))->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); $objPHPExcel->getActiveSheet()->getStyle('G' . (8 + $pos))->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); $objPHPExcel->getActiveSheet()->getStyle('G' . (9 + $pos))->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); $objPHPExcel->getActiveSheet()->getStyle('L' . (7 + $pos))->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); $objPHPExcel->getActiveSheet()->getStyle('L' . (8 + $pos))->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); $objPHPExcel->getActiveSheet()->getStyle('L' . (9 + $pos))->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); // right $objPHPExcel->getActiveSheet()->getStyle('N' . (7 + $pos))->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); $objPHPExcel->getActiveSheet()->getStyle('N' . (8 + $pos))->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); $objPHPExcel->getActiveSheet()->getStyle('N' . (9 + $pos))->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); // bottom $objPHPExcel->getActiveSheet()->getStyle('G' . (9 + $pos) . ':N' . (9 + $pos))->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); cellColor('A' . (7 + $pos) . ':N' . (7 + $pos), 'EEEEEE'); cellColor('G' . (9 + $pos) . ':N' . (9 + $pos), 'EEEEEE'); $objPHPExcel->getActiveSheet()->getStyle('A' . (9 + $pos))->getAlignment()->setWrapText(true); foreach ($pop as $bunka=>$hodnota) { $objPHPExcel->getActiveSheet()->setCellValue($bunka . (7 + $pos), recode($hodnota)); } $objPHPExcel->getActiveSheet()->setCellValue('A' . (7 + $pos), recode($prevadzka)); $objPHPExcel->getActiveSheet()->setCellValue('A' . (8 + $pos), recode($kontakt)); $objPHPExcel->getActiveSheet()->setCellValue('A' . (9 + $pos), recode($info)); $objPHPExcel->getActiveSheet()->setCellValue('B' . (8 + $pos), recode($vzp)); $objPHPExcel->getActiveSheet()->setCellValue('C' . (8 + $pos), $cenavzp); $objPHPExcel->getActiveSheet()->setCellValue('D' . (8 + $pos), $zbervzp); $objPHPExcel->getActiveSheet()->setCellValue('E' . (8 + $pos), recode($oleje)); $objPHPExcel->getActiveSheet()->setCellValue('F' . (8 + $pos), $cenaodpad); $pos+=4; } $iterator++; } $objPHPExcel->setActiveSheetIndex(0); $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->save($fileName); header("Content-Description: File Transfer"); header("Content-Type: application/force-download"); header("Content-Disposition: attachment; filename=\"$fileName\""); readfile ($fileName); ?>

Version	System time (s)	User time (s)	Memory (MiB)
5.4.27	0.011	0.039	12.36
5.4.26	0.005	0.047	12.36
5.4.25	0.009	0.049	12.36
5.4.24	0.008	0.046	12.36
5.4.23	0.009	0.053	12.35
5.4.22	0.007	0.038	12.36
5.4.21	0.010	0.034	12.36
5.4.20	0.007	0.042	12.35
5.4.19	0.008	0.037	12.35
5.4.18	0.009	0.042	12.35
5.4.17	0.007	0.045	12.36
5.4.16	0.007	0.038	12.35
5.4.15	0.004	0.040	12.35
5.4.14	0.008	0.042	12.04
5.4.13	0.005	0.039	12.02
5.4.12	0.008	0.037	11.98
5.4.11	0.010	0.038	11.98
5.4.10	0.010	0.035	11.98
5.4.9	0.009	0.038	11.98
5.4.8	0.007	0.050	11.98
5.4.7	0.012	0.055	11.97
5.4.6	0.012	0.052	11.98
5.4.5	0.010	0.049	11.98
5.4.4	0.008	0.055	11.96
5.4.3	0.011	0.053	11.96
5.4.2	0.012	0.056	11.96
5.4.1	0.014	0.054	11.96
5.4.0	0.011	0.050	11.45
5.3.28	0.010	0.068	12.71
5.3.27	0.010	0.050	12.72
5.3.26	0.012	0.064	12.72
5.3.25	0.007	0.047	12.72
5.3.24	0.007	0.041	12.71
5.3.23	0.007	0.042	12.71
5.3.22	0.021	0.049	12.68
5.3.21	0.006	0.047	12.68
5.3.20	0.009	0.041	12.68
5.3.19	0.010	0.038	12.68
5.3.18	0.009	0.043	12.67
5.3.17	0.008	0.037	12.67
5.3.16	0.005	0.046	12.67
5.3.15	0.007	0.039	12.67
5.3.14	0.009	0.036	12.66
5.3.13	0.009	0.041	12.66
5.3.12	0.008	0.041	12.65
5.3.11	0.008	0.043	12.66
5.3.10	0.008	0.042	12.12
5.3.9	0.007	0.036	12.08
5.3.8	0.007	0.037	12.07
5.3.7	0.009	0.035	12.07
5.3.6	0.009	0.040	12.06
5.3.5	0.009	0.046	12.00
5.3.4	0.010	0.047	12.00
5.3.3	0.012	0.041	11.94
5.3.2	0.014	0.049	11.70
5.3.1	0.009	0.053	11.66
5.3.0	0.011	0.054	11.65