Completed
Push — master ( 17af13...acdc2b )
by Andrzej
02:44
created
src/Entities/PatientRaport.php 2 patches
Indentation   +186 added lines, -186 removed lines patch added patch discarded remove patch
@@ -8,192 +8,192 @@
 block discarded – undo
8 8
 use Doctrine\ORM\Query\ResultSetMapping;
9 9
 
10 10
 class PatientRaport {
11
-	/**
12
-	 *
13
-	 * @param unknown $wardId        	
14
-	 * @param unknown $date        	
15
-	 */
16
-	public static function getRaport($wardId, $date, $wardType) {
17
-		$startDate = $date . '-01';
18
-		$endDate = date ( "Y-m-t 23:59:59", strtotime ( $startDate ) );
11
+    /**
12
+     *
13
+     * @param unknown $wardId        	
14
+     * @param unknown $date        	
15
+     */
16
+    public static function getRaport($wardId, $date, $wardType) {
17
+        $startDate = $date . '-01';
18
+        $endDate = date ( "Y-m-t 23:59:59", strtotime ( $startDate ) );
19 19
 		
20
-		return PatientRaport::getRaportBetweenDates ( $wardId, $wardType, $startDate, $endDate );
21
-	}
22
-	private static function getQuery($type) {
23
-		if ($type == 'POR') {
24
-			// poród zabiegowy
25
-			$dql1 = "  SELECT p.kategoriaPacjenta + 3 as kategoria, DATE(p.dataKategoryzacji) as data, COUNT(p.kategoriaPacjenta) as suma ";
26
-			$dql1 .= " FROM Hospitalplugin\Entities\PatientPOR p ";
27
-			$dql1 .= " WHERE p.dataKategoryzacji BETWEEN ?1 AND ?2 AND p.oddzialId = ?3 AND p.iICzas = 3";
28
-			$dql1 .= " GROUP BY data, p.kategoriaPacjenta";
29
-			// poród siłami natury
30
-			$dql2 = "  SELECT p.kategoriaPacjenta as kategoria, DATE(p.dataKategoryzacji) as data, COUNT(p.kategoriaPacjenta) as suma ";
31
-			$dql2 .= " FROM Hospitalplugin\Entities\PatientPOR p ";
32
-			$dql2 .= " WHERE p.dataKategoryzacji BETWEEN ?1 AND ?2 AND p.oddzialId = ?3 AND (p.iICzas <> 3 OR p.iICzas IS NULL)";
33
-			$dql2 .= " GROUP BY data, p.kategoriaPacjenta";
34
-			return array (
35
-					$dql1,
36
-					$dql2 
37
-			);
38
-		} else {
39
-			// pozostałe typy
40
-			$dql = "  SELECT p.kategoriaPacjenta as kategoria, DATE(p.dataKategoryzacji) as data, COUNT(p.kategoriaPacjenta) as suma ";
41
-			$dql .= " FROM Hospitalplugin\Entities\Patient p ";
42
-			$dql .= " WHERE p.dataKategoryzacji BETWEEN ?1 AND ?2 AND p.oddzialId = ?3";
43
-			$dql .= " GROUP BY data, p.kategoriaPacjenta";
44
-			return array (
45
-					$dql 
46
-			);
47
-		}
48
-	}
49
-	/**
50
-	 *
51
-	 * @param unknown $wardId        	
52
-	 * @param unknown $type        	
53
-	 * @param unknown $startDate        	
54
-	 * @param unknown $endDate        	
55
-	 * @return array
56
-	 */
57
-	public static function getRaportBetweenDates($wardId, $type, $startDate, $endDate) {
58
-		$em = DoctrineBootstrap::getEntityManager ();
59
-		$em->getConfiguration ()->addCustomDatetimeFunction ( 'DATE', 'Hospitalplugin\DQLFunctions\DateFunction' );
60
-		$dql = PatientRaport::getQuery ( $type );
61
-		$allResults = array ();
62
-		foreach ( $dql as $query ) {
63
-			$result = $em->createQuery ( $query )->setParameter ( 1, $startDate )->setParameter ( 2, $endDate )->setParameter ( 3, $wardId )->getResult ();
64
-			$allResults = array_merge ( $result, $allResults );
65
-		}
20
+        return PatientRaport::getRaportBetweenDates ( $wardId, $wardType, $startDate, $endDate );
21
+    }
22
+    private static function getQuery($type) {
23
+        if ($type == 'POR') {
24
+            // poród zabiegowy
25
+            $dql1 = "  SELECT p.kategoriaPacjenta + 3 as kategoria, DATE(p.dataKategoryzacji) as data, COUNT(p.kategoriaPacjenta) as suma ";
26
+            $dql1 .= " FROM Hospitalplugin\Entities\PatientPOR p ";
27
+            $dql1 .= " WHERE p.dataKategoryzacji BETWEEN ?1 AND ?2 AND p.oddzialId = ?3 AND p.iICzas = 3";
28
+            $dql1 .= " GROUP BY data, p.kategoriaPacjenta";
29
+            // poród siłami natury
30
+            $dql2 = "  SELECT p.kategoriaPacjenta as kategoria, DATE(p.dataKategoryzacji) as data, COUNT(p.kategoriaPacjenta) as suma ";
31
+            $dql2 .= " FROM Hospitalplugin\Entities\PatientPOR p ";
32
+            $dql2 .= " WHERE p.dataKategoryzacji BETWEEN ?1 AND ?2 AND p.oddzialId = ?3 AND (p.iICzas <> 3 OR p.iICzas IS NULL)";
33
+            $dql2 .= " GROUP BY data, p.kategoriaPacjenta";
34
+            return array (
35
+                    $dql1,
36
+                    $dql2 
37
+            );
38
+        } else {
39
+            // pozostałe typy
40
+            $dql = "  SELECT p.kategoriaPacjenta as kategoria, DATE(p.dataKategoryzacji) as data, COUNT(p.kategoriaPacjenta) as suma ";
41
+            $dql .= " FROM Hospitalplugin\Entities\Patient p ";
42
+            $dql .= " WHERE p.dataKategoryzacji BETWEEN ?1 AND ?2 AND p.oddzialId = ?3";
43
+            $dql .= " GROUP BY data, p.kategoriaPacjenta";
44
+            return array (
45
+                    $dql 
46
+            );
47
+        }
48
+    }
49
+    /**
50
+     *
51
+     * @param unknown $wardId        	
52
+     * @param unknown $type        	
53
+     * @param unknown $startDate        	
54
+     * @param unknown $endDate        	
55
+     * @return array
56
+     */
57
+    public static function getRaportBetweenDates($wardId, $type, $startDate, $endDate) {
58
+        $em = DoctrineBootstrap::getEntityManager ();
59
+        $em->getConfiguration ()->addCustomDatetimeFunction ( 'DATE', 'Hospitalplugin\DQLFunctions\DateFunction' );
60
+        $dql = PatientRaport::getQuery ( $type );
61
+        $allResults = array ();
62
+        foreach ( $dql as $query ) {
63
+            $result = $em->createQuery ( $query )->setParameter ( 1, $startDate )->setParameter ( 2, $endDate )->setParameter ( 3, $wardId )->getResult ();
64
+            $allResults = array_merge ( $result, $allResults );
65
+        }
66 66
 		
67
-		$table = array ();
68
-		foreach ( $allResults as $row ) {
69
-			$table [$row ['data']] [$row ['kategoria']] = $row ['suma'];
70
-		}
71
-		return $table;
72
-	}
73
-	/**
74
-	 * @param unknown $type
75
-	 */
76
-	static function getColumns($type) {
77
-		if ($type == 'POR') {
78
-			return array (
79
-					'N1 naturalny',
80
-					'N2 naturalny',
81
-					'N3 naturalny',
82
-					'N1 zabiegowy',
83
-					'N2 zabiegowy',
84
-					'N3 zabiegowy',
85
-					'brak kat.',
86
-					'N',
87
-					'Tpb1',
88
-					'Tpb2',
89
-					'Tpb3',
90
-					'Tpb1z',
91
-					'Tpb2z',
92
-					'Tpb3z',
93
-					'Tpb0',
94
-					'2',
95
-					'Tpb1*N1',
96
-					'Tpb2*N2',
97
-					'Tpb3*N3',
98
-					'Tpb1z*N1z',
99
-					'Tpb2z*N2z',
100
-					'Tpb3z*N3z',
101
-					'Tpb0',
102
-					'2*N',
103
-					'Tpb/dzień'
104
-			);
105
-		} else {
106
-			return array (
107
-					'N1',
108
-					'N2',
109
-					'N3',
110
-					'brak kat.',
111
-					'N',
112
-					'Tpb1',
113
-					'Tpb2',
114
-					'Tpb3',
115
-					'Tpb0',
116
-					'2',
117
-					'Tpb1*N1',
118
-					'Tpb2*N2',
119
-					'Tpb3*N3',
120
-					'Tpb0',
121
-					'2*N',
122
-					'Tpb/dzień'
123
-			);
124
-		}
125
-	}
126
-	static function getIndexes($type) {
127
-		if ($type == 'POR') {
128
-			return array (
129
-					'1',
130
-					'2',
131
-					'3',
132
-					'4',
133
-					'5',
134
-					'6',
135
-					'0'
136
-			);
137
-		} else {
138
-			return array (
139
-					'1',
140
-					'2',
141
-					'3',
142
-					'0'
143
-			);
144
-		}
145
-	}
146
-	/**
147
-	 * based on
148
-	 * Zalecenie Konsultanta Krajowego w dz.
149
-	 * pielęgniarstwa w sprawie realizacji przepisów rozporządzenia Ministra Zdrowia z dnia 28 grudnia 2012 roku w sprawie sposobu ustalenia minimalnych norm zatrudnienia pielęgniarek i położnych w podmiotach leczniczych niebędących przedsiębiorcami.
150
-	 * http://www.nipip.pl/index.php/prawo/opiniekk/w-dz-pielegniarstwa/konsultant-krajowy-dr-hab-n-hum-maria-kozka/2265-zalecenie-konsultanta-krajowego-w-dz-pielegniarstwa-w-sprawie-realizacji-przepisow-rozporzadzenia-ministra-zdrowia-z-dnia-28-grudnia-2012-roku-w-sprawie-sposobu-ustalenia-minimalnych-norm-zatrudnienia-pielegniarek-i-poloznych-w-podmiotach-leczniczych-nieb
151
-	 *
152
-	 * @param unknown $type
153
-	 */
154
-	static function getTpb($type) {
155
-		if ($type == 'ZZ' || $type == 'PED') {
156
-			return array (
157
-					38,
158
-					95,
159
-					159,
160
-					0,
161
-					2
162
-			);
163
-		} else if ($type == 'PSY') {
164
-			return array (
165
-					40,
166
-					100,
167
-					160,
168
-					0,
169
-					2
170
-			);
171
-		} else if ($type == 'POR') {
172
-			return array (
173
-					137,
174
-					274,
175
-					328,
176
-					53,
177
-					53,
178
-					120,
179
-					0,
180
-					2
181
-			);
182
-		} else if ($type == 'DIA') {
183
-			return array (
184
-					52,
185
-					112,
186
-					0,
187
-					2
188
-			);
189
-		} else if ($type == 'POL') {
190
-			return array (
191
-					72,
192
-					100,
193
-					98,
194
-					0,
195
-					2
196
-			);
197
-		}
198
-	}
67
+        $table = array ();
68
+        foreach ( $allResults as $row ) {
69
+            $table [$row ['data']] [$row ['kategoria']] = $row ['suma'];
70
+        }
71
+        return $table;
72
+    }
73
+    /**
74
+     * @param unknown $type
75
+     */
76
+    static function getColumns($type) {
77
+        if ($type == 'POR') {
78
+            return array (
79
+                    'N1 naturalny',
80
+                    'N2 naturalny',
81
+                    'N3 naturalny',
82
+                    'N1 zabiegowy',
83
+                    'N2 zabiegowy',
84
+                    'N3 zabiegowy',
85
+                    'brak kat.',
86
+                    'N',
87
+                    'Tpb1',
88
+                    'Tpb2',
89
+                    'Tpb3',
90
+                    'Tpb1z',
91
+                    'Tpb2z',
92
+                    'Tpb3z',
93
+                    'Tpb0',
94
+                    '2',
95
+                    'Tpb1*N1',
96
+                    'Tpb2*N2',
97
+                    'Tpb3*N3',
98
+                    'Tpb1z*N1z',
99
+                    'Tpb2z*N2z',
100
+                    'Tpb3z*N3z',
101
+                    'Tpb0',
102
+                    '2*N',
103
+                    'Tpb/dzień'
104
+            );
105
+        } else {
106
+            return array (
107
+                    'N1',
108
+                    'N2',
109
+                    'N3',
110
+                    'brak kat.',
111
+                    'N',
112
+                    'Tpb1',
113
+                    'Tpb2',
114
+                    'Tpb3',
115
+                    'Tpb0',
116
+                    '2',
117
+                    'Tpb1*N1',
118
+                    'Tpb2*N2',
119
+                    'Tpb3*N3',
120
+                    'Tpb0',
121
+                    '2*N',
122
+                    'Tpb/dzień'
123
+            );
124
+        }
125
+    }
126
+    static function getIndexes($type) {
127
+        if ($type == 'POR') {
128
+            return array (
129
+                    '1',
130
+                    '2',
131
+                    '3',
132
+                    '4',
133
+                    '5',
134
+                    '6',
135
+                    '0'
136
+            );
137
+        } else {
138
+            return array (
139
+                    '1',
140
+                    '2',
141
+                    '3',
142
+                    '0'
143
+            );
144
+        }
145
+    }
146
+    /**
147
+     * based on
148
+     * Zalecenie Konsultanta Krajowego w dz.
149
+     * pielęgniarstwa w sprawie realizacji przepisów rozporządzenia Ministra Zdrowia z dnia 28 grudnia 2012 roku w sprawie sposobu ustalenia minimalnych norm zatrudnienia pielęgniarek i położnych w podmiotach leczniczych niebędących przedsiębiorcami.
150
+     * http://www.nipip.pl/index.php/prawo/opiniekk/w-dz-pielegniarstwa/konsultant-krajowy-dr-hab-n-hum-maria-kozka/2265-zalecenie-konsultanta-krajowego-w-dz-pielegniarstwa-w-sprawie-realizacji-przepisow-rozporzadzenia-ministra-zdrowia-z-dnia-28-grudnia-2012-roku-w-sprawie-sposobu-ustalenia-minimalnych-norm-zatrudnienia-pielegniarek-i-poloznych-w-podmiotach-leczniczych-nieb
151
+     *
152
+     * @param unknown $type
153
+     */
154
+    static function getTpb($type) {
155
+        if ($type == 'ZZ' || $type == 'PED') {
156
+            return array (
157
+                    38,
158
+                    95,
159
+                    159,
160
+                    0,
161
+                    2
162
+            );
163
+        } else if ($type == 'PSY') {
164
+            return array (
165
+                    40,
166
+                    100,
167
+                    160,
168
+                    0,
169
+                    2
170
+            );
171
+        } else if ($type == 'POR') {
172
+            return array (
173
+                    137,
174
+                    274,
175
+                    328,
176
+                    53,
177
+                    53,
178
+                    120,
179
+                    0,
180
+                    2
181
+            );
182
+        } else if ($type == 'DIA') {
183
+            return array (
184
+                    52,
185
+                    112,
186
+                    0,
187
+                    2
188
+            );
189
+        } else if ($type == 'POL') {
190
+            return array (
191
+                    72,
192
+                    100,
193
+                    98,
194
+                    0,
195
+                    2
196
+            );
197
+        }
198
+    }
199 199
 }
200 200
\ No newline at end of file
Please login to merge, or discard this patch.
Spacing   +23 added lines, -23 removed lines patch added patch discarded remove patch
@@ -14,10 +14,10 @@  discard block
 block discarded – undo
14 14
 	 * @param unknown $date        	
15 15
 	 */
16 16
 	public static function getRaport($wardId, $date, $wardType) {
17
-		$startDate = $date . '-01';
18
-		$endDate = date ( "Y-m-t 23:59:59", strtotime ( $startDate ) );
17
+		$startDate = $date.'-01';
18
+		$endDate = date("Y-m-t 23:59:59", strtotime($startDate));
19 19
 		
20
-		return PatientRaport::getRaportBetweenDates ( $wardId, $wardType, $startDate, $endDate );
20
+		return PatientRaport::getRaportBetweenDates($wardId, $wardType, $startDate, $endDate);
21 21
 	}
22 22
 	private static function getQuery($type) {
23 23
 		if ($type == 'POR') {
@@ -31,7 +31,7 @@  discard block
 block discarded – undo
31 31
 			$dql2 .= " FROM Hospitalplugin\Entities\PatientPOR p ";
32 32
 			$dql2 .= " WHERE p.dataKategoryzacji BETWEEN ?1 AND ?2 AND p.oddzialId = ?3 AND (p.iICzas <> 3 OR p.iICzas IS NULL)";
33 33
 			$dql2 .= " GROUP BY data, p.kategoriaPacjenta";
34
-			return array (
34
+			return array(
35 35
 					$dql1,
36 36
 					$dql2 
37 37
 			);
@@ -41,7 +41,7 @@  discard block
 block discarded – undo
41 41
 			$dql .= " FROM Hospitalplugin\Entities\Patient p ";
42 42
 			$dql .= " WHERE p.dataKategoryzacji BETWEEN ?1 AND ?2 AND p.oddzialId = ?3";
43 43
 			$dql .= " GROUP BY data, p.kategoriaPacjenta";
44
-			return array (
44
+			return array(
45 45
 					$dql 
46 46
 			);
47 47
 		}
@@ -55,17 +55,17 @@  discard block
 block discarded – undo
55 55
 	 * @return array
56 56
 	 */
57 57
 	public static function getRaportBetweenDates($wardId, $type, $startDate, $endDate) {
58
-		$em = DoctrineBootstrap::getEntityManager ();
59
-		$em->getConfiguration ()->addCustomDatetimeFunction ( 'DATE', 'Hospitalplugin\DQLFunctions\DateFunction' );
60
-		$dql = PatientRaport::getQuery ( $type );
61
-		$allResults = array ();
62
-		foreach ( $dql as $query ) {
63
-			$result = $em->createQuery ( $query )->setParameter ( 1, $startDate )->setParameter ( 2, $endDate )->setParameter ( 3, $wardId )->getResult ();
64
-			$allResults = array_merge ( $result, $allResults );
58
+		$em = DoctrineBootstrap::getEntityManager();
59
+		$em->getConfiguration()->addCustomDatetimeFunction('DATE', 'Hospitalplugin\DQLFunctions\DateFunction');
60
+		$dql = PatientRaport::getQuery($type);
61
+		$allResults = array();
62
+		foreach ($dql as $query) {
63
+			$result = $em->createQuery($query)->setParameter(1, $startDate)->setParameter(2, $endDate)->setParameter(3, $wardId)->getResult();
64
+			$allResults = array_merge($result, $allResults);
65 65
 		}
66 66
 		
67
-		$table = array ();
68
-		foreach ( $allResults as $row ) {
67
+		$table = array();
68
+		foreach ($allResults as $row) {
69 69
 			$table [$row ['data']] [$row ['kategoria']] = $row ['suma'];
70 70
 		}
71 71
 		return $table;
@@ -75,7 +75,7 @@  discard block
 block discarded – undo
75 75
 	 */
76 76
 	static function getColumns($type) {
77 77
 		if ($type == 'POR') {
78
-			return array (
78
+			return array(
79 79
 					'N1 naturalny',
80 80
 					'N2 naturalny',
81 81
 					'N3 naturalny',
@@ -103,7 +103,7 @@  discard block
 block discarded – undo
103 103
 					'Tpb/dzień'
104 104
 			);
105 105
 		} else {
106
-			return array (
106
+			return array(
107 107
 					'N1',
108 108
 					'N2',
109 109
 					'N3',
@@ -125,7 +125,7 @@  discard block
 block discarded – undo
125 125
 	}
126 126
 	static function getIndexes($type) {
127 127
 		if ($type == 'POR') {
128
-			return array (
128
+			return array(
129 129
 					'1',
130 130
 					'2',
131 131
 					'3',
@@ -135,7 +135,7 @@  discard block
 block discarded – undo
135 135
 					'0'
136 136
 			);
137 137
 		} else {
138
-			return array (
138
+			return array(
139 139
 					'1',
140 140
 					'2',
141 141
 					'3',
@@ -153,7 +153,7 @@  discard block
 block discarded – undo
153 153
 	 */
154 154
 	static function getTpb($type) {
155 155
 		if ($type == 'ZZ' || $type == 'PED') {
156
-			return array (
156
+			return array(
157 157
 					38,
158 158
 					95,
159 159
 					159,
@@ -161,7 +161,7 @@  discard block
 block discarded – undo
161 161
 					2
162 162
 			);
163 163
 		} else if ($type == 'PSY') {
164
-			return array (
164
+			return array(
165 165
 					40,
166 166
 					100,
167 167
 					160,
@@ -169,7 +169,7 @@  discard block
 block discarded – undo
169 169
 					2
170 170
 			);
171 171
 		} else if ($type == 'POR') {
172
-			return array (
172
+			return array(
173 173
 					137,
174 174
 					274,
175 175
 					328,
@@ -180,14 +180,14 @@  discard block
 block discarded – undo
180 180
 					2
181 181
 			);
182 182
 		} else if ($type == 'DIA') {
183
-			return array (
183
+			return array(
184 184
 					52,
185 185
 					112,
186 186
 					0,
187 187
 					2
188 188
 			);
189 189
 		} else if ($type == 'POL') {
190
-			return array (
190
+			return array(
191 191
 					72,
192 192
 					100,
193 193
 					98,
Please login to merge, or discard this patch.