amarcinkowski / hospitalplugin

src/Entities/PatientPOR.php

Spacing +3 added lines, -3 removed lines

@@ -270,8 +270,8 @@ 
 	 * @return multitype:string
 	 */
 	public static function getFields() {
-		$superFields = parent::getFields ();
-		$fields = array_merge ( $superFields, array (
+		$superFields = parent::getFields();
+		$fields = array_merge($superFields, array(
 				"iCiaza",
 				"iWywiad",
 				"iPozycja",
@@ -313,7 +313,7 @@ 
 				"iVPomiarParametrowZyciowych",
 				"iVKarmienie",
 				"iVEdukacjaZdrowotnaIWsparciePsychiczne" 
-		) );
+		));
 		return $fields;
 	}
 	public function getICiaza() {

src/Entities/PatientRaportOptimized.php

Spacing +15 added lines, -15 removed lines

@@ -14,14 +14,14 @@ 
 	 * @param unknown $date        	
 	 */
 	public static function getRaport($wardId, $date) {
-		$startDate = $date . '-01';
-		$endDate = date ( "Y-m-t 23:59:59", strtotime ( $startDate ) );
+		$startDate = $date.'-01';
+		$endDate = date("Y-m-t 23:59:59", strtotime($startDate));
 		
-		return PatientRaportOptimized::getRaportBetweenDatesNative ( $wardId, $startDate, $endDate );
+		return PatientRaportOptimized::getRaportBetweenDatesNative($wardId, $startDate, $endDate);
 	}
 	private static function updateNativeRaport() {
-		$em = DoctrineBootstrap::getEntityManager ();
-		$conn = $em->getConnection ();
+		$em = DoctrineBootstrap::getEntityManager();
+		$conn = $em->getConnection();
 		// create report table
 		$sql1 = "CREATE TABLE IF NOT EXISTS kategoria_view 
 					(data DATETIME, oddzialId INT, kategoria INT, suma INT,
@@ -50,9 +50,9 @@ 
 					kategoriaPacjenta";
 		// select
 		try {
-			$conn->query ( $sql1 );
-			$conn->query ( $sql2 );
-		} catch ( Exception $e ) {
+			$conn->query($sql1);
+			$conn->query($sql2);
+		} catch (Exception $e) {
 			// echo 'Caught exception: ', $e->getMessage(), "\n";
 		}
 	}
@@ -63,19 +63,19 @@ 
 	 * @param unknown $endDate
 	 */
 	public static function getRaportBetweenDatesNative($wardId, $startDate, $endDate) {
-		$em = DoctrineBootstrap::getEntityManager ();
+		$em = DoctrineBootstrap::getEntityManager();
 		PatientRaportOptimized::updateNativeRaport();
-		$conn = $em->getConnection ();
+		$conn = $em->getConnection();
 		$sql3 = "SELECT kategoria, date(data) as data, suma FROM kategoria_view WHERE data between :data1 AND :data2 and oddzialId = :oddzialId";
-		$stmt = $conn->prepare ( $sql3 );
-		$stmt->execute ( array (
+		$stmt = $conn->prepare($sql3);
+		$stmt->execute(array(
 				'data1' => $startDate,
 				'data2' => $endDate,
 				'oddzialId' => $wardId 
-		) );
+		));
 		$result = $stmt->fetchAll();
-		$table = array ();
-		foreach ( $result as $row ) {
+		$table = array();
+		foreach ($result as $row) {
 			$table [$row ['data']] [$row ['kategoria']] = $row ['suma'];
 		}
 		return $table;

src/Entities/User.php

Spacing +1 added lines, -1 removed lines

@@ -82,7 +82,7 @@
 		return $this;
 	}
 	public function toString() {
-		return $this->getId() . $this->getName() . $this->getWard();
+		return $this->getId().$this->getName().$this->getWard();
 	}
 }
 

src/Entities/Ward.php

Spacing +2 added lines, -2 removed lines

@@ -113,7 +113,7 @@ 
 	 */
 	private $users;
 	public function __construct() {
-		$this->users = new ArrayCollection ();
+		$this->users = new ArrayCollection();
 	}
 	
 	/**
@@ -122,7 +122,7 @@ 
 	 * @return string
 	 */
 	public function __toString() {
-		return $this->getName ();
+		return $this->getName();
 	}
 	public function getId() {
 		return $this->id;

src/Twig/GetPropertiesExtension.php

Spacing +1 added lines, -1 removed lines

@@ -25,7 +25,7 @@
             return array();
         }
         $class = new \ReflectionClass($class);
-        $properties = array_filter($class->getProperties(), function ($prop) use($class)
+        $properties = array_filter($class->getProperties(), function($prop) use($class)
         {
             return $prop->getDeclaringClass()->name == $class->name;
         });

src/Twig/PLTwig.php

Spacing +8 added lines, -8 removed lines

@@ -12,22 +12,22 @@
 	 * @return void|\Twig_Environment
 	 */
 	public static function load($viewsDir) {
-		if (! class_exists ( 'Twig_Loader_Filesystem' )) {
+		if (!class_exists('Twig_Loader_Filesystem')) {
 			echo 'Twig not activated. Make sure you activate the plugin in
     <a href="/wp-admin/plugins.php#timber">/wp-admin/plugins.php</a>';
 			return;
 		}
-		\Twig_Autoloader::register ();
+		\Twig_Autoloader::register();
 		try {
-			$loader = new \Twig_Loader_Filesystem ( $viewsDir );
-			$twig = new \Twig_Environment ( $loader, array () );
+			$loader = new \Twig_Loader_Filesystem($viewsDir);
+			$twig = new \Twig_Environment($loader, array());
 			// 'debug' => true
 			// 'cache' => '/tmp/'
-			$twig->getExtension ( 'core' )->setTimezone ( 'Europe/Warsaw' ); //
-			$twig->addExtension ( new EscapePLCharsExtension () );
+			$twig->getExtension('core')->setTimezone('Europe/Warsaw'); //
+			$twig->addExtension(new EscapePLCharsExtension());
 			return $twig;
-		} catch ( Exception $e ) {
-			echo "ERR: " . $e;
+		} catch (Exception $e) {
+			echo "ERR: ".$e;
 		}
 	}
 }
\ No newline at end of file

src/utils/ExcelExport.php

Spacing +44 added lines, -44 removed lines

@@ -10,60 +10,60 @@ 
 	/**
 	 */
 	public static function init() {
-		add_action ( 'admin_init', array (
+		add_action('admin_init', array(
 				'Hospitalplugin\utils\ExcelExport',
 				'excel_export' 
-		), 1 );
+		), 1);
 	}
 	/**
 	 * 
 	 */
 	public static function getColumnLetter($num) {
-		return chr ( 65 + $num );
+		return chr(65 + $num);
 	}
 	/**
 	 */
 	static function excel_export() {
-		if (! isset ( $_POST ['excel'] )) {
+		if (!isset ($_POST ['excel'])) {
 			return;
 		} else {
 			// dataSetName: Infections, Punction
 			$dataSetName = $_POST ['dataSetName'];
-			$classname = '\Hospitalplugin\utils\ExcelExport' . $dataSetName;
+			$classname = '\Hospitalplugin\utils\ExcelExport'.$dataSetName;
 		}
 		
-		$objPHPExcel = new \PHPExcel ();
-		$classname::fillData ( $objPHPExcel );
+		$objPHPExcel = new \PHPExcel();
+		$classname::fillData($objPHPExcel);
 		
-		ExcelExport::downloadExcel ( $objPHPExcel, $dataSetName . '.xlsx' );
+		ExcelExport::downloadExcel($objPHPExcel, $dataSetName.'.xlsx');
 	}
 	/**
 	 */
 	static function cellColor($objPHPExcel, $cells, $color) {
-		$objPHPExcel->getActiveSheet ()->getStyle ( $cells )->getFill ()->applyFromArray ( array (
+		$objPHPExcel->getActiveSheet()->getStyle($cells)->getFill()->applyFromArray(array(
 				'type' => \PHPExcel_Style_Fill::FILL_SOLID,
-				'startcolor' => array (
+				'startcolor' => array(
 						'rgb' => $color 
 				) 
-		) );
+		));
 	}
 	/**
 	 */
 	static function styleActiveSheet($objPHPExcel) {
-		$objPHPExcel->getActiveSheet ()->getDefaultStyle ()->getFont ()->setName ( 'Arial' )->setSize ( 8 )->setBold ( false );
-		$objPHPExcel->getActiveSheet ()->getDefaultStyle ()->getNumberFormat ()->setFormatCode ( \PHPExcel_Style_NumberFormat::FORMAT_TEXT );
-		$objPHPExcel->getActiveSheet ()->freezePane ( 'A3' );
-		$style = array (
-				'alignment' => array (
+		$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setName('Arial')->setSize(8)->setBold(false);
+		$objPHPExcel->getActiveSheet()->getDefaultStyle()->getNumberFormat()->setFormatCode(\PHPExcel_Style_NumberFormat::FORMAT_TEXT);
+		$objPHPExcel->getActiveSheet()->freezePane('A3');
+		$style = array(
+				'alignment' => array(
 						'horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
 						'vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER 
 				) 
 		);
-		$objWorksheet = $objPHPExcel->getActiveSheet ();
-		$objWorksheet->getDefaultStyle ()->applyFromArray ( $style );
-		$objWorksheet->getStyle ( 'A1:AA2' )->getFont ()->setBold ( true );
-		for($col = ord ( 'a' ); $col <= ord ( 'z' ); $col ++) {
-			$objWorksheet->getColumnDimension ( chr ( $col ) )->setAutoSize ( true );
+		$objWorksheet = $objPHPExcel->getActiveSheet();
+		$objWorksheet->getDefaultStyle()->applyFromArray($style);
+		$objWorksheet->getStyle('A1:AA2')->getFont()->setBold(true);
+		for ($col = ord('a'); $col <= ord('z'); $col ++) {
+			$objWorksheet->getColumnDimension(chr($col))->setAutoSize(true);
 		}
 		return $objPHPExcel;
 	}
@@ -72,19 +72,19 @@ 
 	 * @param unknown $objPHPExcel        	
 	 */
 	private static function downloadExcel($objPHPExcel, $filename) {
-		ob_end_clean ();
-		ob_start ();
-		header ( "Content-type: application/vnd.ms-excel; charset=utf-8" );
-		header ( "Content-Transfer-Encoding: binary" );
-		header ( "Content-Description: File Transfer" );
-		header ( "Content-Disposition: attachment; filename=\"" . $filename . "\"" );
-		header ( "Cache-Control: max-age=0" );
-		header ( "Expires: 0" );
-		header ( "Pragma: no-cache" );
+		ob_end_clean();
+		ob_start();
+		header("Content-type: application/vnd.ms-excel; charset=utf-8");
+		header("Content-Transfer-Encoding: binary");
+		header("Content-Description: File Transfer");
+		header("Content-Disposition: attachment; filename=\"".$filename."\"");
+		header("Cache-Control: max-age=0");
+		header("Expires: 0");
+		header("Pragma: no-cache");
 		
-		$objWriter = \PHPExcel_IOFactory::createWriter ( $objPHPExcel, 'Excel2007' );
-		$objWriter->setPreCalculateFormulas ( true );
-		$objWriter->save ( 'php://output' );
+		$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
+		$objWriter->setPreCalculateFormulas(true);
+		$objWriter->save('php://output');
 		exit ();
 	}
 	/**
@@ -92,12 +92,12 @@ 
 	 * @param unknown $string        	
 	 */
 	private static function clearName($string, $removeWords) {
-		$string = str_replace ( ' ', '-', $string );
-		$string = preg_replace ( '/[^A-Za-z0-9\-]/', '', $string );
-		foreach ( $removeWords as $word ) {
-			$string = str_replace ( $word, '', $string );
+		$string = str_replace(' ', '-', $string);
+		$string = preg_replace('/[^A-Za-z0-9\-]/', '', $string);
+		foreach ($removeWords as $word) {
+			$string = str_replace($word, '', $string);
 		}
-		$string = substr ( $string, 0, 29 );
+		$string = substr($string, 0, 29);
 		return $string;
 	}
 	/**
@@ -105,8 +105,8 @@ 
 	 * @param unknown $title        	
 	 */
 	static function printTitle($objPHPExcel, $title) {
-		$objPHPExcel->getActiveSheet ()->setTitle ( ExcelExport::clearName ( $title, array('ddzia') ), true );
-		$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 0, 1, $title );
+		$objPHPExcel->getActiveSheet()->setTitle(ExcelExport::clearName($title, array('ddzia')), true);
+		$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 1, $title);
 	}
 	/**
 	 *
@@ -114,11 +114,11 @@ 
 	 */
 	static function newSheet($objPHPExcel, $index = -1) {
 		if ($index < 0) {
-			$index = $objPHPExcel->getSheetCount ();
+			$index = $objPHPExcel->getSheetCount();
 		}
-		$objPHPExcel->createSheet ( $index );
-		$objPHPExcel->setActiveSheetIndex ( $index );
-		$sheet = $objPHPExcel->getActiveSheet ();
+		$objPHPExcel->createSheet($index);
+		$objPHPExcel->setActiveSheetIndex($index);
+		$sheet = $objPHPExcel->getActiveSheet();
 		return $sheet;
 	}
 	

src/utils/ExcelExportInfections.php

Spacing +25 added lines, -25 removed lines

@@ -7,61 +7,61 @@
 
 class ExcelExportInfections {
 	private static function getData() {
-		$wardId = (! empty ( $_POST ['wardId'] ) ? $_POST ['wardId'] : 0);
-		$date = (! empty ( $_POST ['date'] ) ? $_POST ['date'] : (new \DateTime ())->format ( "Y-m" ));
-		$from = new \DateTime ( $date . '-01' );
-		$fromStr = $from->format ( 'Y-m-01' );
-		$toStr = $from->format ( 'Y-m-t' );
-		$infections = InfectionsCRUD::getInfections ( $fromStr, $toStr, $wardId, 'Infections' );
+		$wardId = (!empty ($_POST ['wardId']) ? $_POST ['wardId'] : 0);
+		$date = (!empty ($_POST ['date']) ? $_POST ['date'] : (new \DateTime())->format("Y-m"));
+		$from = new \DateTime($date.'-01');
+		$fromStr = $from->format('Y-m-01');
+		$toStr = $from->format('Y-m-t');
+		$infections = InfectionsCRUD::getInfections($fromStr, $toStr, $wardId, 'Infections');
 		return $infections;
 	}
 	private static function getColumns() {
-		return Infections::getFields ();
+		return Infections::getFields();
 	}
 	private static function printHeaders($objPHPExcel, $cols) {
 		$count = 0;
-		foreach ( $cols as $col => $sym ) {
-			$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( $count ++, 2, sprintf ( "%7s", $col ) );
+		foreach ($cols as $col => $sym) {
+			$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($count ++, 2, sprintf("%7s", $col));
 		}
 	}
 	/**
 	 */
 	private static function printData($objPHPExcel, $data, $cols) {
 		$row = 3;
-		foreach ( $data as $rowValue ) {
+		foreach ($data as $rowValue) {
 			$count = 0;
-			foreach ( $cols as $col => $sym ) {
+			foreach ($cols as $col => $sym) {
 				$value = $rowValue->$sym;
-				$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( $count ++, $row, $value );
+				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($count ++, $row, $value);
 			}
 			$row ++;
 		}
 		return $row;
 	}
 	private static function printTitle($objPHPExcel, $title) {
-		$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 0, 1, $title );
+		$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 1, $title);
 	}
 	/**
 	 *
 	 * @param PHPExcel $objPHPExcel        	
 	 */
 	private static function printFooter($objPHPExcel, $cols, $row) {
-		$objPHPExcel->getActiveSheet ()->getStyle ( 'A' . $row . ':AA' . ($row + 1) )->getFont ()->setBold ( true );
+		$objPHPExcel->getActiveSheet()->getStyle('A'.$row.':AA'.($row + 1))->getFont()->setBold(true);
 		// SUM
-		$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 1, $row, "SUMA" );
-		for($i = 2; $i < count ( $cols ); $i ++) {
-			$colLetter = chr ( 65 + $i );
-			$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( $i, $row, "=sum(" . $colLetter . "3" . ":" . $colLetter . ($row - 1) . ")" );
+		$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $row, "SUMA");
+		for ($i = 2; $i < count($cols); $i ++) {
+			$colLetter = chr(65 + $i);
+			$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($i, $row, "=sum(".$colLetter."3".":".$colLetter.($row - 1).")");
 		}
-		ExcelExport::cellColor ( $objPHPExcel, 'A' . $row . ':AA' . ($row + 1), 'DDDDDD' );
+		ExcelExport::cellColor($objPHPExcel, 'A'.$row.':AA'.($row + 1), 'DDDDDD');
 	}
 	static function fillData($objPHPExcel) {
-		$data = ExcelExportInfections::getData ();
-		$cols = ExcelExportInfections::getColumns ();
+		$data = ExcelExportInfections::getData();
+		$cols = ExcelExportInfections::getColumns();
 		
-		ExcelExportInfections::printTitle ( $objPHPExcel, "Raport" );
-		ExcelExportInfections::printHeaders ( $objPHPExcel, $cols );
-		$lastRow = ExcelExportInfections::printData ( $objPHPExcel, $data, $cols );
-		ExcelExportInfections::printFooter ( $objPHPExcel, $cols, $lastRow );
+		ExcelExportInfections::printTitle($objPHPExcel, "Raport");
+		ExcelExportInfections::printHeaders($objPHPExcel, $cols);
+		$lastRow = ExcelExportInfections::printData($objPHPExcel, $data, $cols);
+		ExcelExportInfections::printFooter($objPHPExcel, $cols, $lastRow);
 	}
 }
\ No newline at end of file

src/utils/ExcelExportPunction.php

Spacing +72 added lines, -72 removed lines

@@ -14,7 +14,7 @@ 
 	 * @param unknown $id        	
 	 */
 	private static function getData($id, $type) {
-		$raport = PatientRaport::getRaportBetweenDates ( $id, $type, '2014-06-01', (new \DateTime ())->format ( "Y-m-d" ) );
+		$raport = PatientRaport::getRaportBetweenDates($id, $type, '2014-06-01', (new \DateTime())->format("Y-m-d"));
 		return $raport;
 	}
 	/**
@@ -24,9 +24,9 @@ 
 	 */
 	private static function printHeaders($objPHPExcel, $cols) {
 		$count = 1;
-		$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 0, 2, "Data" );
-		foreach ( $cols as $col ) {
-			$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( $count ++, 2, sprintf ( "%7s", $col ) );
+		$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 2, "Data");
+		foreach ($cols as $col) {
+			$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($count ++, 2, sprintf("%7s", $col));
 		}
 	}
 	/**
@@ -34,45 +34,45 @@ 
 	private static function printData($objPHPExcel, $data, $type) {
 		$row = 3;
 		$lastColumn = 1;
-		$colNumberOfPatients = ExcelExport::getColumnLetter ( 1 );
-		$indexes = PatientRaport::getIndexes ( $type );
-		foreach ( $data as $rowKey => $rowValue ) {
+		$colNumberOfPatients = ExcelExport::getColumnLetter(1);
+		$indexes = PatientRaport::getIndexes($type);
+		foreach ($data as $rowKey => $rowValue) {
 			// 1 col: date
-			$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 0, $row, json_encode ( $rowKey ) );
+			$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $row, json_encode($rowKey));
 			$count = 1;
 			// 2-5 cols: N1 N2 N3 N0
-			foreach ( $indexes as $index ) {
-				$value = isset ( $rowValue [$index] ) ? $rowValue [$index] : "0";
-				$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( $count ++, $row, $value );
+			foreach ($indexes as $index) {
+				$value = isset ($rowValue [$index]) ? $rowValue [$index] : "0";
+				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($count ++, $row, $value);
 			}
 			// 6 col: num of categorized (N = N1+N2+N3)
-			$colHighestCategory = ExcelExport::getColumnLetter ( $count - 2 );
-			$colNumberOfPatients = ExcelExport::getColumnLetter ( $count );
-			$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( $count ++, $row, '=SUM(B' . $row . ':' . $colHighestCategory . $row . ')' );
-			$tpb = PatientRaport::getTpb ( $type );
+			$colHighestCategory = ExcelExport::getColumnLetter($count - 2);
+			$colNumberOfPatients = ExcelExport::getColumnLetter($count);
+			$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($count ++, $row, '=SUM(B'.$row.':'.$colHighestCategory.$row.')');
+			$tpb = PatientRaport::getTpb($type);
 			// 7-11 tpb1, tpb2, tpb3, 0 (no-cat), 2 (add)
-			foreach ( $tpb as $tpbn ) {
-				$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( $count ++, $row, $tpbn );
+			foreach ($tpb as $tpbn) {
+				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($count ++, $row, $tpbn);
 			}
 			// 9-11: Tpb1*N1,Tpb2*N2,Tpb3*N3+2xN
-			$tpbSize = count ( $tpb );
-			foreach ( $tpb as $tpbn ) {
-				$col1Letter = ExcelExport::getColumnLetter ( $count - 2 * $tpbSize );
-				$col2Letter = ExcelExport::getColumnLetter ( $count - $tpbSize );
-				$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( $count ++, $row, '=' . $col1Letter . $row . "*" . $col2Letter . $row );
+			$tpbSize = count($tpb);
+			foreach ($tpb as $tpbn) {
+				$col1Letter = ExcelExport::getColumnLetter($count - 2 * $tpbSize);
+				$col2Letter = ExcelExport::getColumnLetter($count - $tpbSize);
+				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($count ++, $row, '='.$col1Letter.$row."*".$col2Letter.$row);
 			}
 			// SUM Tpb
-			$col3Letter = ExcelExport::getColumnLetter ( $count - $tpbSize );
-			$col4Letter = ExcelExport::getColumnLetter ( $count - 1 );
-			$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( $count ++, $row, '=SUM(' . $col3Letter . $row . ":" . $col4Letter . $row . ")" );
+			$col3Letter = ExcelExport::getColumnLetter($count - $tpbSize);
+			$col4Letter = ExcelExport::getColumnLetter($count - 1);
+			$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($count ++, $row, '=SUM('.$col3Letter.$row.":".$col4Letter.$row.")");
 			$row ++;
 			$lastColumn = $count - 1;
 		}
 		// number of categorization days
-		$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 1, 1, '=COUNTIFS(' . $colNumberOfPatients . '3:' . $colNumberOfPatients . ($row - 1) . ',">0")' );
+		$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 1, '=COUNTIFS('.$colNumberOfPatients.'3:'.$colNumberOfPatients.($row - 1).',">0")');
 		// sum
-		$col5Letter = ExcelExport::getColumnLetter ( $lastColumn );
-		$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 2, 1, '=SUM(' . $col5Letter . '3:' . $col5Letter . ($row - 1) . ')/60' );
+		$col5Letter = ExcelExport::getColumnLetter($lastColumn);
+		$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 1, '=SUM('.$col5Letter.'3:'.$col5Letter.($row - 1).')/60');
 		return $row;
 	}
 	
@@ -81,61 +81,61 @@ 
 	 * @param unknown $objPHPExcel        	
 	 */
 	static function fillSummary($objPHPExcel) {
-		ExcelExport::newSheet ( $objPHPExcel, 0 );
-		ExcelExport::printTitle ( $objPHPExcel, "Raport" );
-		$sheetCount = $objPHPExcel->getSheetCount ();
-		$objPHPExcel->getActiveSheet ()->setCellValue ( 'A2', 'Oddz.' );
-		$objPHPExcel->getActiveSheet ()->setCellValue ( 'B2', 'Dni' );
-		$objPHPExcel->getActiveSheet ()->setCellValue ( 'C2', 'Tpb' );
-		$objPHPExcel->getActiveSheet ()->setCellValue ( 'D2', 'Tśpb' );
-		$objPHPExcel->getActiveSheet ()->setCellValue ( 'E2', 'Tśpc*' );
-		$objPHPExcel->getActiveSheet ()->setCellValue ( 'F2', 'Tśpc**' );
-		$objPHPExcel->getActiveSheet ()->setCellValue ( 'G2', 'Td***' );
-		$objPHPExcel->getActiveSheet ()->setCellValue ( 'H2', 'Le*' );
-		$objPHPExcel->getActiveSheet ()->setCellValue ( 'I2', 'Le**' );
-		for($i = 1; $i < $sheetCount; $i ++) {
-			$loadedSheetNames = $objPHPExcel->getSheetNames ();
-			foreach ( $loadedSheetNames as $sheetIndex => $loadedSheetName ) {
+		ExcelExport::newSheet($objPHPExcel, 0);
+		ExcelExport::printTitle($objPHPExcel, "Raport");
+		$sheetCount = $objPHPExcel->getSheetCount();
+		$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Oddz.');
+		$objPHPExcel->getActiveSheet()->setCellValue('B2', 'Dni');
+		$objPHPExcel->getActiveSheet()->setCellValue('C2', 'Tpb');
+		$objPHPExcel->getActiveSheet()->setCellValue('D2', 'Tśpb');
+		$objPHPExcel->getActiveSheet()->setCellValue('E2', 'Tśpc*');
+		$objPHPExcel->getActiveSheet()->setCellValue('F2', 'Tśpc**');
+		$objPHPExcel->getActiveSheet()->setCellValue('G2', 'Td***');
+		$objPHPExcel->getActiveSheet()->setCellValue('H2', 'Le*');
+		$objPHPExcel->getActiveSheet()->setCellValue('I2', 'Le**');
+		for ($i = 1; $i < $sheetCount; $i ++) {
+			$loadedSheetNames = $objPHPExcel->getSheetNames();
+			foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
 				if ($sheetIndex == 0) {
 					continue;
 				}
 				$row = $sheetIndex + 2;
-				$objPHPExcel->getActiveSheet ()->setCellValue ( 'A' . $row, "='" . $loadedSheetName . "'!A1" );
-				$objPHPExcel->getActiveSheet ()->setCellValue ( 'B' . $row, "='" . $loadedSheetName . "'!B1" );
-				$objPHPExcel->getActiveSheet ()->setCellValue ( 'C' . $row, "='" . $loadedSheetName . "'!C1" );
-				$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 3, $row, "=IF(C" . $row . ">0,C" . $row . "/B" . $row . ",0)" );
-				$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 4, $row, "=D" . $row . "*110%" );
-				$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 5, $row, "=D" . $row . "*125%" );
-				$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 6, $row, "1531" );
-				$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 7, $row, "=IF(E" . $row . ">0,E" . $row . "*365/G" . $row . ",\"-\")" );
-				$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 8, $row, "=IF(F" . $row . ">0,F" . $row . "*365/G" . $row . ",\"-\")" );
+				$objPHPExcel->getActiveSheet()->setCellValue('A'.$row, "='".$loadedSheetName."'!A1");
+				$objPHPExcel->getActiveSheet()->setCellValue('B'.$row, "='".$loadedSheetName."'!B1");
+				$objPHPExcel->getActiveSheet()->setCellValue('C'.$row, "='".$loadedSheetName."'!C1");
+				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $row, "=IF(C".$row.">0,C".$row."/B".$row.",0)");
+				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $row, "=D".$row."*110%");
+				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $row, "=D".$row."*125%");
+				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $row, "1531");
+				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $row, "=IF(E".$row.">0,E".$row."*365/G".$row.",\"-\")");
+				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $row, "=IF(F".$row.">0,F".$row."*365/G".$row.",\"-\")");
 			}
-			$objPHPExcel->getActiveSheet ()->getStyle ( 'C3:I100' )->getNumberFormat ()->setFormatCode ( '#,##0.0' );
-			$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 0, $row + 1, "* Czas pielęgnacji pośredniej jako 10% czasu pielęgnacji bezpośredniej" );
-			$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 0, $row + 2, "** Czas pielęgnacji pośredniej jako 25% czasu pielęgnacji bezpośredniej" );
-			$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 0, $row + 3, "*** Czas dyspozycyjny - propozycja z Rozporządzenia MZ: 202 dni x 7,58 h" );
-			ExcelExport::styleActiveSheet ( $objPHPExcel );
+			$objPHPExcel->getActiveSheet()->getStyle('C3:I100')->getNumberFormat()->setFormatCode('#,##0.0');
+			$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $row + 1, "* Czas pielęgnacji pośredniej jako 10% czasu pielęgnacji bezpośredniej");
+			$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $row + 2, "** Czas pielęgnacji pośredniej jako 25% czasu pielęgnacji bezpośredniej");
+			$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $row + 3, "*** Czas dyspozycyjny - propozycja z Rozporządzenia MZ: 202 dni x 7,58 h");
+			ExcelExport::styleActiveSheet($objPHPExcel);
 		}
 	}
 	static function fillData($objPHPExcel) {
 		// no time limit for this script
-		set_time_limit ( 0 );
-		$time_start = microtime ( true );
+		set_time_limit(0);
+		$time_start = microtime(true);
 		// remove first default sheet
-		$objPHPExcel->removeSheetByIndex ( 0 );
+		$objPHPExcel->removeSheetByIndex(0);
 		// get wards
-		$wards = WardCRUD::getWardsArray ();
-		foreach ( $wards as $ward ) {
-			ExcelExport::newSheet ( $objPHPExcel );
-			$wardName = $ward->name . " (" . $ward->getTypOddzialu () . ")";
-			ExcelExport::printTitle ( $objPHPExcel, $wardName );
-			$data = ExcelExportPunction::getData ( $ward->id, $ward->getTypOddzialu () );
-			$cols = PatientRaport::getColumns ( $ward->getTypOddzialu () );
-			ExcelExportPunction::printHeaders ( $objPHPExcel, $cols );
-			ExcelExportPunction::printData ( $objPHPExcel, $data, $ward->getTypOddzialu () );
-			ExcelExport::styleActiveSheet ( $objPHPExcel );
+		$wards = WardCRUD::getWardsArray();
+		foreach ($wards as $ward) {
+			ExcelExport::newSheet($objPHPExcel);
+			$wardName = $ward->name." (".$ward->getTypOddzialu().")";
+			ExcelExport::printTitle($objPHPExcel, $wardName);
+			$data = ExcelExportPunction::getData($ward->id, $ward->getTypOddzialu());
+			$cols = PatientRaport::getColumns($ward->getTypOddzialu());
+			ExcelExportPunction::printHeaders($objPHPExcel, $cols);
+			ExcelExportPunction::printData($objPHPExcel, $data, $ward->getTypOddzialu());
+			ExcelExport::styleActiveSheet($objPHPExcel);
 		}
-		ExcelExportPunction::fillSummary ( $objPHPExcel );
-		$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 0, 100, "summary " . ($time_start - microtime ( true )) . " s" );
+		ExcelExportPunction::fillSummary($objPHPExcel);
+		$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 100, "summary ".($time_start - microtime(true))." s");
 	}
 }
\ No newline at end of file