amarcinkowski / hospitalplugin

src/Entities/HospitalForm.php

Unused Use Statements -2 removed lines

@@ -25,8 +25,6 @@
 namespace Hospitalplugin\Entities;
 
 use Hospitalplugin\DB\DoctrineBootstrap;
-use Hospitalplugin\utils\Utils;
-use Hospitalplugin\Twig\EscapePLCharsExtension;
 use Hospitalplugin\Entities\WardCRUD;
 use Hospitalplugin\Twig\PLTwig;
 

Indentation +23 added lines, -23 removed lines

@@ -31,30 +31,30 @@
 use Hospitalplugin\Twig\PLTwig;
 
 class HospitalForm {
-	public static function load($yaml, $class, $dir) {
-		try {
-			$em = DoctrineBootstrap::getEntityManager ();
+    public static function load($yaml, $class, $dir) {
+        try {
+            $em = DoctrineBootstrap::getEntityManager ();
 			
-			$userId = $userId = wp_get_current_user ()->ID;
-			$ward = WardCRUD::getWardForUser ( $userId );
-			$user = $em->find ( "\Hospitalplugin\Entities\User", $userId );
+            $userId = $userId = wp_get_current_user ()->ID;
+            $ward = WardCRUD::getWardForUser ( $userId );
+            $user = $em->find ( "\Hospitalplugin\Entities\User", $userId );
 			
-			if (! empty ( $_POST )) {
-				$args = $_POST;
-				$i = new $class ( $args );
-				$i->setWard ( $ward );
-				$i->setUser ( $user );
-				$em->persist ( $i );
-				$em->flush ();
-			} else {
-				$object = \Hospitalplugin\utils\YAML2Object::getObject ( $yaml );
-				echo PLTwig::load ( $dir )->render ( 'form.twig', array (
-						'infections' => $object 
-				) );
-			}
-		} catch ( Exception $e ) {
-			echo "ERR: " . $e;
-		}
-	}
+            if (! empty ( $_POST )) {
+                $args = $_POST;
+                $i = new $class ( $args );
+                $i->setWard ( $ward );
+                $i->setUser ( $user );
+                $em->persist ( $i );
+                $em->flush ();
+            } else {
+                $object = \Hospitalplugin\utils\YAML2Object::getObject ( $yaml );
+                echo PLTwig::load ( $dir )->render ( 'form.twig', array (
+                        'infections' => $object 
+                ) );
+            }
+        } catch ( Exception $e ) {
+            echo "ERR: " . $e;
+        }
+    }
 }
 ?>
\ No newline at end of file

src/Entities/InfectionsCRUD.php

Unused Use Statements -1 removed lines

@@ -25,7 +25,6 @@
 namespace Hospitalplugin\Entities;
 
 use Hospitalplugin\DB\DoctrineBootstrap;
-use Hospitalplugin\utils\Utils;
 
 class InfectionsCRUD {
 	public static function getInfections($from, $to, $wardId, $class) {

Indentation +34 added lines, -34 removed lines

@@ -28,44 +28,44 @@
 use Hospitalplugin\utils\Utils;
 
 class InfectionsCRUD {
-	public static function getInfections($from, $to, $wardId, $class) {
-		$em = ( object ) DoctrineBootstrap::getEntityManager ();
-		$qb = $em->createQueryBuilder ();
-		$qb->select ( 'i' )->from ( 'Hospitalplugin\Entities\\' . $class, 'i' ) /* */
+    public static function getInfections($from, $to, $wardId, $class) {
+        $em = ( object ) DoctrineBootstrap::getEntityManager ();
+        $qb = $em->createQueryBuilder ();
+        $qb->select ( 'i' )->from ( 'Hospitalplugin\Entities\\' . $class, 'i' ) /* */
         ->addOrderBy ( 'i.dataRaportu', 'DESC' ) /* */
         ->addOrderBy ( 'i.dataPrzeslania ', 'DESC' ) /* */
         ->where ( /* */
-        		$qb->expr ()->between ( 'i.dataRaportu', ':from', ':to' ) ) /* */
-        		->setParameters ( array (
-				'from' => $from,
-				'to' => $to 
-		) );
-		if ($wardId != 'all') {
-			$qb->andWhere ( $qb->expr ()->eq ( 'i.ward', ':ward' ) ) /* */
-        			->setParameter ( 'ward', $wardId );
-		}
+                $qb->expr ()->between ( 'i.dataRaportu', ':from', ':to' ) ) /* */
+                ->setParameters ( array (
+                'from' => $from,
+                'to' => $to 
+        ) );
+        if ($wardId != 'all') {
+            $qb->andWhere ( $qb->expr ()->eq ( 'i.ward', ':ward' ) ) /* */
+                    ->setParameter ( 'ward', $wardId );
+        }
 		
-		$query = $qb->getQuery ();
-		$infections = $query->getResult ();
+        $query = $qb->getQuery ();
+        $infections = $query->getResult ();
 		
-		return $infections;
-	}
-	public static function updateVerification($id, $weryfikacja) {
-		if ($id != null && $weryfikacja != null) {
-			$em = ( object ) DoctrineBootstrap::getEntityManager ();
-			$infection = $em->getRepository ( 'Hospitalplugin\Entities\Infections' )->find ( $id );
-			$infection->setWeryfikacja ( $weryfikacja );
-			$em->flush ();
-		}
-	}
-	public static function obj2DB($obj) {
-		$id = $obj->id;
-		$em = DoctrineBootstrap::getEntityManager();
-		$infection = $em->getRepository('Hospitalplugin\Entities\Infections')->find($id);
-		$infection->setWeryfikacja($obj->value);
-		$em->persist($infection);
-		$em->flush();
-		echo $id;
-	}
+        return $infections;
+    }
+    public static function updateVerification($id, $weryfikacja) {
+        if ($id != null && $weryfikacja != null) {
+            $em = ( object ) DoctrineBootstrap::getEntityManager ();
+            $infection = $em->getRepository ( 'Hospitalplugin\Entities\Infections' )->find ( $id );
+            $infection->setWeryfikacja ( $weryfikacja );
+            $em->flush ();
+        }
+    }
+    public static function obj2DB($obj) {
+        $id = $obj->id;
+        $em = DoctrineBootstrap::getEntityManager();
+        $infection = $em->getRepository('Hospitalplugin\Entities\Infections')->find($id);
+        $infection->setWeryfikacja($obj->value);
+        $em->persist($infection);
+        $em->flush();
+        echo $id;
+    }
 }
 ?>
\ No newline at end of file

src/Entities/PatientCRUD.php

Unused Use Statements -1 removed lines

@@ -27,7 +27,6 @@
 use Hospitalplugin\DB\DoctrineBootstrap;
 use Hospitalplugin\Entities\Patient;
 use Hospitalplugin\Entities\PatientDeleted;
-use Hospitalplugin\Entities\PatientFactory;
 use Hospitalplugin\utils\Utils;
 
 class PatientCRUD {

Indentation +110 added lines, -110 removed lines

@@ -32,120 +32,120 @@
 
 class PatientCRUD {
 	
-	/**
-	 * getPatients
-	 *
-	 * @param int $day
-	 *        	dayOfTheMonth
-	 * @param int $month
-	 *        	month
-	 *        	
-	 * @return Patient array
-	 */
-	public static function getPatients($month = null, $day = null, $wardId = 0) {
-		return PatientCRUD::getPatientsDateRange ( Utils::getStartDate ( $month, $day ), Utils::getEndDate ( $month, $day ), $wardId );
-	}
+    /**
+     * getPatients
+     *
+     * @param int $day
+     *        	dayOfTheMonth
+     * @param int $month
+     *        	month
+     *        	
+     * @return Patient array
+     */
+    public static function getPatients($month = null, $day = null, $wardId = 0) {
+        return PatientCRUD::getPatientsDateRange ( Utils::getStartDate ( $month, $day ), Utils::getEndDate ( $month, $day ), $wardId );
+    }
 	
-	/**
-	 * getPatientsDateRange
-	 *
-	 * TODO(AM) testy na przypadki graniczne - pacjenci z data przed polnoca, po polnocy, godzina przed obecna, po obecnej
-	 *
-	 * @param int $day
-	 *        	dayOfTheMonth
-	 * @param int $month
-	 *        	month
-	 *        	
-	 * @return Patient array
-	 */
-	public static function getPatientsDateRange($date1, $date2, $wardId = 0) {
-		$entityManager = ( object ) DoctrineBootstrap::getEntityManager ();
-		$params = array (
-				'from' => $date1,
-				'to' => $date2,
-				'oddzialId' => $wardId 
-		);
-		$q = $entityManager->createQuery ( 'select p FROM Hospitalplugin\Entities\Patient p WHERE p.dataKategoryzacji BETWEEN :from AND :to and p.oddzialId = :oddzialId ORDER BY p.name' )->setParameters ( $params )->setFirstResult ( 0 )->setMaxResults ( 1000 );
-		$patients = $q->getResult ();
-		return $patients;
-	}
+    /**
+     * getPatientsDateRange
+     *
+     * TODO(AM) testy na przypadki graniczne - pacjenci z data przed polnoca, po polnocy, godzina przed obecna, po obecnej
+     *
+     * @param int $day
+     *        	dayOfTheMonth
+     * @param int $month
+     *        	month
+     *        	
+     * @return Patient array
+     */
+    public static function getPatientsDateRange($date1, $date2, $wardId = 0) {
+        $entityManager = ( object ) DoctrineBootstrap::getEntityManager ();
+        $params = array (
+                'from' => $date1,
+                'to' => $date2,
+                'oddzialId' => $wardId 
+        );
+        $q = $entityManager->createQuery ( 'select p FROM Hospitalplugin\Entities\Patient p WHERE p.dataKategoryzacji BETWEEN :from AND :to and p.oddzialId = :oddzialId ORDER BY p.name' )->setParameters ( $params )->setFirstResult ( 0 )->setMaxResults ( 1000 );
+        $patients = $q->getResult ();
+        return $patients;
+    }
 	
-	/**
-	 * getPatient
-	 *
-	 * @param $id $id
-	 *        	int
-	 *        	
-	 * @return Patient Patient
-	 */
-	public static function getPatient($id, $type = '') {
-		$entityManager = ( object ) DoctrineBootstrap::getEntityManager ();
-		$type = 'Hospitalplugin\Entities\Patient' . $type;
-		$patient = $entityManager->getRepository ( $type )->findOneBy ( array (
-				'id' => $id 
-		) );
-		return Utils::cast ( $type, ( object ) $patient, 0 );
-	}
+    /**
+     * getPatient
+     *
+     * @param $id $id
+     *        	int
+     *        	
+     * @return Patient Patient
+     */
+    public static function getPatient($id, $type = '') {
+        $entityManager = ( object ) DoctrineBootstrap::getEntityManager ();
+        $type = 'Hospitalplugin\Entities\Patient' . $type;
+        $patient = $entityManager->getRepository ( $type )->findOneBy ( array (
+                'id' => $id 
+        ) );
+        return Utils::cast ( $type, ( object ) $patient, 0 );
+    }
 	
-	/**
-	 * setPatientCategories
-	 *
-	 * @param Patient $obj        	
-	 *
-	 * @return Patient
-	 */
-	public static function setPatientCategories($obj, $type) {
-		$entityManager = DoctrineBootstrap::getEntityManager ();
-		$patient = PatientCRUD::getPatient ( $obj->id, $type );
-		foreach ( get_object_vars ( $obj ) as $key => $value ) {
-			call_user_func ( array (
-					$patient,
-					'set' . ucwords ( $key ) 
-			), $value );
-		}
-		$entityManager->merge ( $patient );
-		$entityManager->flush ();
-		return $patient;
-	}
+    /**
+     * setPatientCategories
+     *
+     * @param Patient $obj        	
+     *
+     * @return Patient
+     */
+    public static function setPatientCategories($obj, $type) {
+        $entityManager = DoctrineBootstrap::getEntityManager ();
+        $patient = PatientCRUD::getPatient ( $obj->id, $type );
+        foreach ( get_object_vars ( $obj ) as $key => $value ) {
+            call_user_func ( array (
+                    $patient,
+                    'set' . ucwords ( $key ) 
+            ), $value );
+        }
+        $entityManager->merge ( $patient );
+        $entityManager->flush ();
+        return $patient;
+    }
 	
-	/**
-	 * setPatientCategories
-	 *
-	 * @param Patient $obj        	
-	 *
-	 * @return Patient
-	 */
-	public static function createPatient($type, $name, $pesel) {
-		$entityManager = DoctrineBootstrap::getEntityManager ();
-		$type = 'Hospitalplugin\Entities\Patient' . $type;
-		$patient = new $type ();
-		$patient->setName ( $name );
-		$patient->setPesel ( $pesel );
-		$entityManager->persist ( $patient );
-		$entityManager->flush ();
-		return $patient;
-	}
+    /**
+     * setPatientCategories
+     *
+     * @param Patient $obj        	
+     *
+     * @return Patient
+     */
+    public static function createPatient($type, $name, $pesel) {
+        $entityManager = DoctrineBootstrap::getEntityManager ();
+        $type = 'Hospitalplugin\Entities\Patient' . $type;
+        $patient = new $type ();
+        $patient->setName ( $name );
+        $patient->setPesel ( $pesel );
+        $entityManager->persist ( $patient );
+        $entityManager->flush ();
+        return $patient;
+    }
 	
-	/**
-	 * deletePatient
-	 *
-	 * @param $id $id
-	 *        	int
-	 */
-	public static function deletePatient($id, $userId = 0) {
-		$entityManager = ( object ) DoctrineBootstrap::getEntityManager ();
-		$type = 'Hospitalplugin\Entities\Patient';
-		$patient = $entityManager->getRepository ( $type )->findOneBy ( array (
-				'id' => $id 
-		) );
-		$entityManager->remove ( $patient );
-		$log = strval($patient);
-		$audit = new PatientDeleted();
-		$audit->deletedAt = new \DateTime ();
-		$audit->deletedByUserId = $userId;
-		$audit->log = $log;
-		$entityManager->persist ( $audit );
-		$entityManager->flush ();
-	}
+    /**
+     * deletePatient
+     *
+     * @param $id $id
+     *        	int
+     */
+    public static function deletePatient($id, $userId = 0) {
+        $entityManager = ( object ) DoctrineBootstrap::getEntityManager ();
+        $type = 'Hospitalplugin\Entities\Patient';
+        $patient = $entityManager->getRepository ( $type )->findOneBy ( array (
+                'id' => $id 
+        ) );
+        $entityManager->remove ( $patient );
+        $log = strval($patient);
+        $audit = new PatientDeleted();
+        $audit->deletedAt = new \DateTime ();
+        $audit->deletedByUserId = $userId;
+        $audit->log = $log;
+        $entityManager->persist ( $audit );
+        $entityManager->flush ();
+    }
 }
 ?>
\ No newline at end of file

src/Entities/PatientRaportOptimized.php

Unused Use Statements -3 removed lines

@@ -3,9 +3,6 @@
 namespace Hospitalplugin\Entities;
 
 use Hospitalplugin\DB\DoctrineBootstrap;
-use Hospitalplugin\utils\Utils;
-use Doctrine\DBAL\Schema\View;
-use Doctrine\ORM\Query\ResultSetMapping;
 
 class PatientRaportOptimized {
 	/**

Indentation +49 added lines, -49 removed lines

@@ -8,26 +8,26 @@ 
 use Doctrine\ORM\Query\ResultSetMapping;
 
 class PatientRaportOptimized {
-	/**
-	 *
-	 * @param unknown $wardId        	
-	 * @param unknown $date        	
-	 */
-	public static function getRaport($wardId, $date) {
-		$startDate = $date . '-01';
-		$endDate = date ( "Y-m-t 23:59:59", strtotime ( $startDate ) );
+    /**
+     *
+     * @param unknown $wardId        	
+     * @param unknown $date        	
+     */
+    public static function getRaport($wardId, $date) {
+        $startDate = $date . '-01';
+        $endDate = date ( "Y-m-t 23:59:59", strtotime ( $startDate ) );
 		
-		return PatientRaportOptimized::getRaportBetweenDatesNative ( $wardId, $startDate, $endDate );
-	}
-	private static function updateNativeRaport() {
-		$em = DoctrineBootstrap::getEntityManager ();
-		$conn = $em->getConnection ();
-		// create report table
-		$sql1 = "CREATE TABLE IF NOT EXISTS kategoria_view 
+        return PatientRaportOptimized::getRaportBetweenDatesNative ( $wardId, $startDate, $endDate );
+    }
+    private static function updateNativeRaport() {
+        $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,
 					PRIMARY KEY (data,oddzialId,kategoria));";
-		// update view
-		$sql2 = "INSERT INTO kategoria_view 
+        // update view
+        $sql2 = "INSERT INTO kategoria_view 
 					SELECT 
 						date( dataKategoryzacji ), 
 						oddzialId, 
@@ -48,37 +48,37 @@ 
 					oddzialId, 
 					date( dataKategoryzacji ) , 
 					kategoriaPacjenta";
-		// select
-		try {
-			$conn->query ( $sql1 );
-			$conn->query ( $sql2 );
-		} catch ( Exception $e ) {
-			// echo 'Caught exception: ', $e->getMessage(), "\n";
-		}
-	}
-	/**
-	 * 
-	 * @param unknown $wardId
-	 * @param unknown $startDate
-	 * @param unknown $endDate
-	 */
-	public static function getRaportBetweenDatesNative($wardId, $startDate, $endDate) {
-		$em = DoctrineBootstrap::getEntityManager ();
-		PatientRaportOptimized::updateNativeRaport();
-		$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 (
-				'data1' => $startDate,
-				'data2' => $endDate,
-				'oddzialId' => $wardId 
-		) );
-		$result = $stmt->fetchAll();
-		$table = array ();
-		foreach ( $result as $row ) {
-			$table [$row ['data']] [$row ['kategoria']] = $row ['suma'];
-		}
-		return $table;
-	}
+        // select
+        try {
+            $conn->query ( $sql1 );
+            $conn->query ( $sql2 );
+        } catch ( Exception $e ) {
+            // echo 'Caught exception: ', $e->getMessage(), "\n";
+        }
+    }
+    /**
+     * 
+     * @param unknown $wardId
+     * @param unknown $startDate
+     * @param unknown $endDate
+     */
+    public static function getRaportBetweenDatesNative($wardId, $startDate, $endDate) {
+        $em = DoctrineBootstrap::getEntityManager ();
+        PatientRaportOptimized::updateNativeRaport();
+        $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 (
+                'data1' => $startDate,
+                'data2' => $endDate,
+                'oddzialId' => $wardId 
+        ) );
+        $result = $stmt->fetchAll();
+        $table = array ();
+        foreach ( $result as $row ) {
+            $table [$row ['data']] [$row ['kategoria']] = $row ['suma'];
+        }
+        return $table;
+    }
 	
 }
\ No newline at end of file

src/utils/ExcelExport.php

Unused Use Statements -1 removed lines

@@ -2,7 +2,6 @@
 
 namespace Hospitalplugin\utils;
 
-use Hospitalplugin\Entities\InfectionsCRUD;
 use Hospitalplugin\Entities\Infections;
 
 class ExcelExport {

Indentation +111 added lines, -111 removed lines

@@ -7,119 +7,119 @@
 
 class ExcelExport {
 	
-	/**
-	 */
-	public static function init() {
-		add_action ( 'admin_init', array (
-				'Hospitalplugin\utils\ExcelExport',
-				'excel_export' 
-		), 1 );
-	}
-	/**
-	 * 
-	 */
-	public static function getColumnLetter($num) {
-		return chr ( 65 + $num );
-	}
-	/**
-	 */
-	static function excel_export() {
-		if (! isset ( $_POST ['excel'] )) {
-			return;
-		} else {
-			// dataSetName: Infections, Punction
-			$dataSetName = $_POST ['dataSetName'];
-			$classname = '\Hospitalplugin\utils\ExcelExport' . $dataSetName;
-		}
+    /**
+     */
+    public static function init() {
+        add_action ( 'admin_init', array (
+                'Hospitalplugin\utils\ExcelExport',
+                'excel_export' 
+        ), 1 );
+    }
+    /**
+     * 
+     */
+    public static function getColumnLetter($num) {
+        return chr ( 65 + $num );
+    }
+    /**
+     */
+    static function excel_export() {
+        if (! isset ( $_POST ['excel'] )) {
+            return;
+        } else {
+            // dataSetName: Infections, Punction
+            $dataSetName = $_POST ['dataSetName'];
+            $classname = '\Hospitalplugin\utils\ExcelExport' . $dataSetName;
+        }
 		
-		$objPHPExcel = new \PHPExcel ();
-		$classname::fillData ( $objPHPExcel );
+        $objPHPExcel = new \PHPExcel ();
+        $classname::fillData ( $objPHPExcel );
 		
-		ExcelExport::downloadExcel ( $objPHPExcel, $dataSetName . '.xlsx' );
-	}
-	/**
-	 */
-	static function cellColor($objPHPExcel, $cells, $color) {
-		$objPHPExcel->getActiveSheet ()->getStyle ( $cells )->getFill ()->applyFromArray ( array (
-				'type' => \PHPExcel_Style_Fill::FILL_SOLID,
-				'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 (
-						'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 );
-		}
-		return $objPHPExcel;
-	}
-	/**
-	 *
-	 * @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" );
+        ExcelExport::downloadExcel ( $objPHPExcel, $dataSetName . '.xlsx' );
+    }
+    /**
+     */
+    static function cellColor($objPHPExcel, $cells, $color) {
+        $objPHPExcel->getActiveSheet ()->getStyle ( $cells )->getFill ()->applyFromArray ( array (
+                'type' => \PHPExcel_Style_Fill::FILL_SOLID,
+                '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 (
+                        '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 );
+        }
+        return $objPHPExcel;
+    }
+    /**
+     *
+     * @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" );
 		
-		$objWriter = \PHPExcel_IOFactory::createWriter ( $objPHPExcel, 'Excel2007' );
-		$objWriter->setPreCalculateFormulas ( true );
-		$objWriter->save ( 'php://output' );
-		exit ();
-	}
-	/**
-	 * remove special chars and words from string 
-	 * @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 = substr ( $string, 0, 29 );
-		return $string;
-	}
-	/**
-	 * @param unknown $objPHPExcel        	
-	 * @param unknown $title        	
-	 */
-	static function printTitle($objPHPExcel, $title) {
-		$objPHPExcel->getActiveSheet ()->setTitle ( ExcelExport::clearName ( $title, array('ddzia') ), true );
-		$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 0, 1, $title );
-	}
-	/**
-	 *
-	 * @param unknown $objPHPExcel
-	 */
-	static function newSheet($objPHPExcel, $index = -1) {
-		if ($index < 0) {
-			$index = $objPHPExcel->getSheetCount ();
-		}
-		$objPHPExcel->createSheet ( $index );
-		$objPHPExcel->setActiveSheetIndex ( $index );
-		$sheet = $objPHPExcel->getActiveSheet ();
-		return $sheet;
-	}
+        $objWriter = \PHPExcel_IOFactory::createWriter ( $objPHPExcel, 'Excel2007' );
+        $objWriter->setPreCalculateFormulas ( true );
+        $objWriter->save ( 'php://output' );
+        exit ();
+    }
+    /**
+     * remove special chars and words from string 
+     * @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 = substr ( $string, 0, 29 );
+        return $string;
+    }
+    /**
+     * @param unknown $objPHPExcel        	
+     * @param unknown $title        	
+     */
+    static function printTitle($objPHPExcel, $title) {
+        $objPHPExcel->getActiveSheet ()->setTitle ( ExcelExport::clearName ( $title, array('ddzia') ), true );
+        $objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 0, 1, $title );
+    }
+    /**
+     *
+     * @param unknown $objPHPExcel
+     */
+    static function newSheet($objPHPExcel, $index = -1) {
+        if ($index < 0) {
+            $index = $objPHPExcel->getSheetCount ();
+        }
+        $objPHPExcel->createSheet ( $index );
+        $objPHPExcel->setActiveSheetIndex ( $index );
+        $sheet = $objPHPExcel->getActiveSheet ();
+        return $sheet;
+    }
 	
 }
\ No newline at end of file

src/utils/ExcelExportPunction.php

Unused Use Statements -2 removed lines

@@ -2,8 +2,6 @@
 
 namespace Hospitalplugin\utils;
 
-use Hospitalplugin\Entities\InfectionsCRUD;
-use Hospitalplugin\Entities\Infections;
 use Hospitalplugin\Entities\PatientRaport;
 use Hospitalplugin\Entities\WardCRUD;
 

Indentation +128 added lines, -128 removed lines

@@ -9,133 +9,133 @@
 
 class ExcelExportPunction {
 	
-	/**
-	 *
-	 * @param unknown $id        	
-	 */
-	private static function getData($id, $type) {
-		$raport = PatientRaport::getRaportBetweenDates ( $id, $type, '2014-06-01', (new \DateTime ())->format ( "Y-m-d" ) );
-		return $raport;
-	}
-	/**
-	 *
-	 * @param unknown $objPHPExcel        	
-	 * @param unknown $cols        	
-	 */
-	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 ) );
-		}
-	}
-	/**
-	 */
-	private static function printData($objPHPExcel, $data, $type) {
-		$row = 3;
-		$lastColumn = 1;
-		$colNumberOfPatients = ExcelExport::getColumnLetter ( 1 );
-		$indexes = PatientRaport::getIndexes ( $type );
-		foreach ( $data as $rowKey => $rowValue ) {
-			// 1 col: date
-			$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 );
-			}
-			// 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 );
-			// 7-11 tpb1, tpb2, tpb3, 0 (no-cat), 2 (add)
-			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 );
-			}
-			// SUM Tpb
-			$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")' );
-		// sum
-		$col5Letter = ExcelExport::getColumnLetter ( $lastColumn );
-		$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 2, 1, '=SUM(' . $col5Letter . '3:' . $col5Letter . ($row - 1) . ')/60' );
-		return $row;
-	}
+    /**
+     *
+     * @param unknown $id        	
+     */
+    private static function getData($id, $type) {
+        $raport = PatientRaport::getRaportBetweenDates ( $id, $type, '2014-06-01', (new \DateTime ())->format ( "Y-m-d" ) );
+        return $raport;
+    }
+    /**
+     *
+     * @param unknown $objPHPExcel        	
+     * @param unknown $cols        	
+     */
+    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 ) );
+        }
+    }
+    /**
+     */
+    private static function printData($objPHPExcel, $data, $type) {
+        $row = 3;
+        $lastColumn = 1;
+        $colNumberOfPatients = ExcelExport::getColumnLetter ( 1 );
+        $indexes = PatientRaport::getIndexes ( $type );
+        foreach ( $data as $rowKey => $rowValue ) {
+            // 1 col: date
+            $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 );
+            }
+            // 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 );
+            // 7-11 tpb1, tpb2, tpb3, 0 (no-cat), 2 (add)
+            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 );
+            }
+            // SUM Tpb
+            $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")' );
+        // sum
+        $col5Letter = ExcelExport::getColumnLetter ( $lastColumn );
+        $objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 2, 1, '=SUM(' . $col5Letter . '3:' . $col5Letter . ($row - 1) . ')/60' );
+        return $row;
+    }
 	
-	/**
-	 *
-	 * @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 ) {
-				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 ()->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 );
-		// remove first default sheet
-		$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 );
-		}
-		ExcelExportPunction::fillSummary ( $objPHPExcel );
-		$objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 0, 100, "summary " . ($time_start - microtime ( true )) . " s" );
-	}
+    /**
+     *
+     * @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 ) {
+                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 ()->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 );
+        // remove first default sheet
+        $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 );
+        }
+        ExcelExportPunction::fillSummary ( $objPHPExcel );
+        $objPHPExcel->getActiveSheet ()->setCellValueByColumnAndRow ( 0, 100, "summary " . ($time_start - microtime ( true )) . " s" );
+    }
 }
\ No newline at end of file

src/utils/PersonGenerator.php

Unused Use Statements -1 removed lines

@@ -24,7 +24,6 @@
 namespace Hospitalplugin\utils;
 
 use Hospitalplugin\Entities\Patient;
-use Hospitalplugin\Entities\PatientZZ;
 
 /**
  * PersonGenerator

Indentation +30 added lines, -30 removed lines

@@ -1,26 +1,26 @@ 
 <?php
 /**
- * PersonGenerator
- *
- * THIS MATERIAL IS PROVIDED AS IS, WITH ABSOLUTELY NO WARRANTY EXPRESSED
- * OR IMPLIED. ANY USE IS AT YOUR OWN RISK.
- *
- * Permission is hereby granted to use or copy this program
- * for any purpose, provided the above notices are retained on all copies.
- * Permission to modify the code and to distribute modified code is granted,
- * provided the above notices are retained, and a notice that the code was
- * modified is included with the above copyright notice.
- *
- * @category  Wp
- * @package   Punction
- * @author    Andrzej Marcinkowski <andrzej.max.marcinkowski@gmail.com>
- * @copyright 2014 Wojewódzki Szpital Zespolony, Kalisz
- * @license   MIT http://opensource.org/licenses/MIT
- * @version   1.0 $Id: a88997670673063e272ee5666aa86ed1ec9a1561 $ $Format:%H$
- * @link      http://
- * @since     File available since Release 1.0.0
- * PHP Version 5
- */
+     * PersonGenerator
+     *
+     * THIS MATERIAL IS PROVIDED AS IS, WITH ABSOLUTELY NO WARRANTY EXPRESSED
+     * OR IMPLIED. ANY USE IS AT YOUR OWN RISK.
+     *
+     * Permission is hereby granted to use or copy this program
+     * for any purpose, provided the above notices are retained on all copies.
+     * Permission to modify the code and to distribute modified code is granted,
+     * provided the above notices are retained, and a notice that the code was
+     * modified is included with the above copyright notice.
+     *
+     * @category  Wp
+     * @package   Punction
+     * @author    Andrzej Marcinkowski <andrzej.max.marcinkowski@gmail.com>
+     * @copyright 2014 Wojewódzki Szpital Zespolony, Kalisz
+     * @license   MIT http://opensource.org/licenses/MIT
+     * @version   1.0 $Id: a88997670673063e272ee5666aa86ed1ec9a1561 $ $Format:%H$
+     * @link      http://
+     * @since     File available since Release 1.0.0
+     * PHP Version 5
+     */
 namespace Hospitalplugin\utils;
 
 use Hospitalplugin\Entities\Patient;
@@ -50,7 +50,7 @@ 
 
     /**
      * @return \Hospitalplugin\Entities\Patient
-	 */
+     */
     public static function getRandomPerson()
     {
         // TODO extract paths
@@ -93,11 +93,11 @@ 
     }
 
     /**
-	 *
-	 * @param $date        	
-	 * @param $sex
-	 *        	'm' / 'f'
-	 */
+     *
+     * @param $date        	
+     * @param $sex
+     *        	'm' / 'f'
+     */
     public static function getRandomPesel($date, $sex = 'm')
     {
         $datetime = new \DateTime($date);
@@ -125,8 +125,8 @@ 
         $intSum = 0;
         for ($i = 0; $i < 10; $i ++) {
             $intSum += $arrSteps[$i] * $x[$i]; // mnożymy każdy ze znaków
-                                                   // przez wagć i sumujemy
-                                                   // wszystko
+                                                    // przez wagć i sumujemy
+                                                    // wszystko
         }
         $int = 10 - $intSum % 10; // obliczamy sumć kontrolną
         $intControlNr = ($int == 10) ? 0 : $int;
@@ -139,7 +139,7 @@ 
      * 
      * @param unknown $arr
      * @return string random element
-	 */
+     */
     public static function getRandom($arr)
     {
         return implode('', $arr[array_rand($arr)]);

scripts/migrate_patients.php

Indentation +67 added lines, -67 removed lines

@@ -25,14 +25,14 @@ 
 use Punction\DB\DoctrineBootstrap;
 
 if (! defined ( 'ABSPATH' )) {
-	define ( 'WP_USE_THEMES', false );
-	require ('/var/www/wp/wp-load.php');
+    define ( 'WP_USE_THEMES', false );
+    require ('/var/www/wp/wp-load.php');
 }
 require_once ('/var/www/vendor/autoload.php');
 Logger::configure ( '../resources/log4php.xml' );
 /**
- * migration log4php logger
- */
+     * migration log4php logger
+     */
 $log = Logger::getLogger ( "migration" );
 $log->info ( "Start!" );
 
@@ -63,73 +63,73 @@ 
 $entityManager = $db1->getEntityManager ();
 
 foreach ( $results as $result ) {
-	/**
-	 */
-	$id = $result ['ID'];
-	/**
-	 */
-	$title = $result ['post_title'];
-	/**
-	 */
-	$pesel = implode ( get_post_meta ( $id, 'pesel' ) );
-	/**
-	 */
-	$oddzid = implode ( get_post_meta ( $id, 'oddzial.ID' ) );
-	/**
-	 */
+    /**
+     */
+    $id = $result ['ID'];
+    /**
+     */
+    $title = $result ['post_title'];
+    /**
+     */
+    $pesel = implode ( get_post_meta ( $id, 'pesel' ) );
+    /**
+     */
+    $oddzid = implode ( get_post_meta ( $id, 'oddzial.ID' ) );
+    /**
+     */
 	
-	$numer_historii = implode ( get_post_meta ( $id, 'numer_ksiegi_glownej' ) );
-	/**
-	 */
-	$data_kategoryzacji = implode ( get_post_meta ( $id, 'data_kategoryzacji' ) );
-	/**
-	 */
-	$kategoria_pacjenta = implode ( get_post_meta ( $id, 'kategoria_pacjenta' ) );
-	/**
-	 */
-	$aktywnosc_fizyczna = implode ( get_post_meta ( $id, '1_aktywnosc_fizyczna' ) );
-	/**
-	 */
-	$higiena = implode ( get_post_meta ( $id, '2_higiena' ) );
-	/**
-	 */
-	$odzywianie = implode ( get_post_meta ( $id, '3_odzywianie' ) );
-	/**
-	 */
-	$wydalanie = implode ( get_post_meta ( $id, '4_wydalanie' ) );
-	/**
-	 */
-	$pomiar_objawow_zyciowych = implode ( get_post_meta ( $id, '5_pomiar_objawow_zyciowych' ) );
-	/**
-	 */
-	$leczenie = implode ( get_post_meta ( $id, '6_leczenie' ) );
-	/**
-	 */
-	$edukacja_i_wsparcie_psychiczne = implode ( get_post_meta ( $id, '7_edukacja_i_wsparcie_psychiczne' ) );
+    $numer_historii = implode ( get_post_meta ( $id, 'numer_ksiegi_glownej' ) );
+    /**
+     */
+    $data_kategoryzacji = implode ( get_post_meta ( $id, 'data_kategoryzacji' ) );
+    /**
+     */
+    $kategoria_pacjenta = implode ( get_post_meta ( $id, 'kategoria_pacjenta' ) );
+    /**
+     */
+    $aktywnosc_fizyczna = implode ( get_post_meta ( $id, '1_aktywnosc_fizyczna' ) );
+    /**
+     */
+    $higiena = implode ( get_post_meta ( $id, '2_higiena' ) );
+    /**
+     */
+    $odzywianie = implode ( get_post_meta ( $id, '3_odzywianie' ) );
+    /**
+     */
+    $wydalanie = implode ( get_post_meta ( $id, '4_wydalanie' ) );
+    /**
+     */
+    $pomiar_objawow_zyciowych = implode ( get_post_meta ( $id, '5_pomiar_objawow_zyciowych' ) );
+    /**
+     */
+    $leczenie = implode ( get_post_meta ( $id, '6_leczenie' ) );
+    /**
+     */
+    $edukacja_i_wsparcie_psychiczne = implode ( get_post_meta ( $id, '7_edukacja_i_wsparcie_psychiczne' ) );
 	
-	/**
-	 */
-	$patient = new PatientZZ ();
-	$patient->setName ( $title );
-	if ($data_kategoryzacji == null) {
-		$log->warn ( "Patient " . $id . " missing date. Omitting." );
-		continue;
-	}
-	$patient->setDataKategoryzacji ( \DateTime::createFromFormat ( "d-m-Y", $data_kategoryzacji ) );
-	$patient->setOddzialId ( $oddzid );
-	$patient->setNumerHistorii ( $numer_historii );
+    /**
+     */
+    $patient = new PatientZZ ();
+    $patient->setName ( $title );
+    if ($data_kategoryzacji == null) {
+        $log->warn ( "Patient " . $id . " missing date. Omitting." );
+        continue;
+    }
+    $patient->setDataKategoryzacji ( \DateTime::createFromFormat ( "d-m-Y", $data_kategoryzacji ) );
+    $patient->setOddzialId ( $oddzid );
+    $patient->setNumerHistorii ( $numer_historii );
 	
-	$patient->setPesel ( $pesel );
-	$patient->setKategoriaPacjenta ( $kategoria_pacjenta );
-	$patient->setAktywnoscFizyczna ( $aktywnosc_fizyczna );
-	$patient->setHigiena ( $higiena );
-	$patient->setOdzywianie ( $odzywianie );
-	$patient->setWydalanie ( $wydalanie );
-	$patient->setPomiarObjawowZyciowych ( $pomiar_objawow_zyciowych );
-	$patient->setLeczenie ( $leczenie );
-	$patient->setEdukacjaIWsparciePsychiczne ( $edukacja_i_wsparcie_psychiczne );
+    $patient->setPesel ( $pesel );
+    $patient->setKategoriaPacjenta ( $kategoria_pacjenta );
+    $patient->setAktywnoscFizyczna ( $aktywnosc_fizyczna );
+    $patient->setHigiena ( $higiena );
+    $patient->setOdzywianie ( $odzywianie );
+    $patient->setWydalanie ( $wydalanie );
+    $patient->setPomiarObjawowZyciowych ( $pomiar_objawow_zyciowych );
+    $patient->setLeczenie ( $leczenie );
+    $patient->setEdukacjaIWsparciePsychiczne ( $edukacja_i_wsparcie_psychiczne );
 	
-	$entityManager->persist ( $patient );
+    $entityManager->persist ( $patient );
 }
 $entityManager->flush ();
 $log->info ( "Stop!" );

src/Entities/InfectionRaport.php

Indentation +101 added lines, -101 removed lines

@@ -39,116 +39,116 @@
  */
 class InfectionRaport {
 	
-	/**
-	 * id
-	 * @Id @Column(type="integer") @GeneratedValue
-	 */
-	public $id;
+    /**
+     * id
+     * @Id @Column(type="integer") @GeneratedValue
+     */
+    public $id;
 	
-	/**
-	 * $dataRaportu datetime
-	 * @Column(type="datetime") *
-	 */
-	public $dataRaportu;
+    /**
+     * $dataRaportu datetime
+     * @Column(type="datetime") *
+     */
+    public $dataRaportu;
 	
-	/**
-	 * $dataPrzeslania datetime
-	 * @Column(type="datetime") *
-	 */
-	public $dataPrzeslania;
+    /**
+     * $dataPrzeslania datetime
+     * @Column(type="datetime") *
+     */
+    public $dataPrzeslania;
 	
-	/**
-	 * @ManyToOne(targetEntity="Hospitalplugin\Entities\Ward")
-	 * @JoinColumn(name="oddzialId", referencedColumnName="id")
-	 */
-	public $ward;
+    /**
+     * @ManyToOne(targetEntity="Hospitalplugin\Entities\Ward")
+     * @JoinColumn(name="oddzialId", referencedColumnName="id")
+     */
+    public $ward;
 	
-	/**
-	 * @ManyToOne(targetEntity="Hospitalplugin\Entities\User")
-	 * @JoinColumn(name="userId", referencedColumnName="id")
-	 */
-	protected $user;
+    /**
+     * @ManyToOne(targetEntity="Hospitalplugin\Entities\User")
+     * @JoinColumn(name="userId", referencedColumnName="id")
+     */
+    protected $user;
 	
-	function __construct($args) {
-		foreach ( $args as $key => $value ) {
-			if ($key == 'dataRaportu') {
-				$value = new \DateTime ( $value );
-			} 
-			call_user_func ( array (
-					$this,
-					'set' . $key 
-			), $value );
-		}
-		$this->dataPrzeslania = new \DateTime ();
-		echo '<h3><div class="alert alert-primary">Dziękuję za przesłanie raportu!</div></h3>';
-	}
+    function __construct($args) {
+        foreach ( $args as $key => $value ) {
+            if ($key == 'dataRaportu') {
+                $value = new \DateTime ( $value );
+            } 
+            call_user_func ( array (
+                    $this,
+                    'set' . $key 
+            ), $value );
+        }
+        $this->dataPrzeslania = new \DateTime ();
+        echo '<h3><div class="alert alert-primary">Dziękuję za przesłanie raportu!</div></h3>';
+    }
 	
-	/**
-	 * getId
-	 *
-	 * @return id
-	 */
-	public function getId() {
-		return $this->id;
-	}
+    /**
+     * getId
+     *
+     * @return id
+     */
+    public function getId() {
+        return $this->id;
+    }
 	
-	/**
-	 * sets id
-	 *
-	 * @param int $id
-	 *        	ID
-	 *        	
-	 * @return \Hospitalplugin\Entities\Patient
-	 */
-	public function setId($id) {
-		$this->id = $id;
-		return $this;
-	}
+    /**
+     * sets id
+     *
+     * @param int $id
+     *        	ID
+     *        	
+     * @return \Hospitalplugin\Entities\Patient
+     */
+    public function setId($id) {
+        $this->id = $id;
+        return $this;
+    }
 	
-	/**
-	 * toString
-	 *
-	 * @return string
-	 */
-	public function toString() {
-		$txt = $this->getId ();
-		$data = $this->getDataRaportu ();
-		if ($data instanceof \DateTime) {
-			$txt .= $this->getDataRaportu ()->format ( "Y-m-d" );
-		} else {
-			$txt .= $this->getDataRaportu ();
-		}
-		return $txt;
-	}
-	public function getDataRaportu() {
-		return $this->dataRaportu;
-	}
-	public function setDataRaportu($dataRaportu) {
-		$this->dataRaportu = $dataRaportu;
-		return $this;
-	}
+    /**
+     * toString
+     *
+     * @return string
+     */
+    public function toString() {
+        $txt = $this->getId ();
+        $data = $this->getDataRaportu ();
+        if ($data instanceof \DateTime) {
+            $txt .= $this->getDataRaportu ()->format ( "Y-m-d" );
+        } else {
+            $txt .= $this->getDataRaportu ();
+        }
+        return $txt;
+    }
+    public function getDataRaportu() {
+        return $this->dataRaportu;
+    }
+    public function setDataRaportu($dataRaportu) {
+        $this->dataRaportu = $dataRaportu;
+        return $this;
+    }
 	
-	public function getDataPrzeslania() {
-		return $this->dataPrzeslania;
-	}
-	public function setDataPrzeslania($dataPrzeslania) {
-		$this->dataPrzeslania = $dataPrzeslania;
-		return $this;
-	}
-	public function getWard() {
-		return $this->ward;
-	}
-	public function setWard($ward) {
-		$this->ward = $ward;
-		return $this;
-	}
-	public function getUser() {
-		return $this->user;
-	}
-	public function setUser($user) {
-		$this->user = $user;
-		return $this;
-	}
+    public function getDataPrzeslania() {
+        return $this->dataPrzeslania;
+    }
+    public function setDataPrzeslania($dataPrzeslania) {
+        $this->dataPrzeslania = $dataPrzeslania;
+        return $this;
+    }
+    public function getWard() {
+        return $this->ward;
+    }
+    public function setWard($ward) {
+        $this->ward = $ward;
+        return $this;
+    }
+    public function getUser() {
+        return $this->user;
+    }
+    public function setUser($user) {
+        $this->user = $user;
+        return $this;
+    }
 	
 	
 }