@@ -6,12 +6,12 @@ |
||
6 | 6 | |
7 | 7 | |
8 | 8 | $gtampil=mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
9 | - $g=mysql_fetch_array($gtampil); |
|
9 | + $g=mysql_fetch_array($gtampil); |
|
10 | 10 | |
11 | 11 | if ($g['pict']) { |
12 | - $pict = $g['pict']; |
|
12 | + $pict = $g['pict']; |
|
13 | 13 | } else { |
14 | - $pict = ''; |
|
14 | + $pict = ''; |
|
15 | 15 | } |
16 | 16 | |
17 | 17 | ?> |
@@ -52,55 +52,55 @@ discard block |
||
52 | 52 | default: |
53 | 53 | |
54 | 54 | if($_GET['fdate']) { |
55 | - $fdate = $_GET['fdate']; |
|
55 | + $fdate = $_GET['fdate']; |
|
56 | 56 | } else { |
57 | - $hour = time() - (1 * 1 * 60 * 60); |
|
58 | - $fdate = date("Y-m-d", $hour); |
|
57 | + $hour = time() - (1 * 1 * 60 * 60); |
|
58 | + $fdate = date("Y-m-d", $hour); |
|
59 | 59 | } |
60 | 60 | |
61 | 61 | if($_GET['ldate']) { |
62 | - $ldate = $_GET['ldate']; |
|
62 | + $ldate = $_GET['ldate']; |
|
63 | 63 | } else { |
64 | - $hour = time() - (1 * 1 * 60 * 60) + (168 * 1 * 60 * 60); |
|
65 | - $ldate = date("Y-m-d",$hour); |
|
64 | + $hour = time() - (1 * 1 * 60 * 60) + (168 * 1 * 60 * 60); |
|
65 | + $ldate = date("Y-m-d",$hour); |
|
66 | 66 | } |
67 | 67 | |
68 | 68 | $fdate1 = date("m/d/Y", strtotime($fdate)); |
69 | 69 | $ldate1 = date("m/d/Y", strtotime($ldate)); |
70 | 70 | |
71 | 71 | |
72 | - $fday = date("d", strtotime($fdate)); |
|
73 | - $fmonth = date("m", strtotime($fdate)); |
|
74 | - $fyear = date("Y", strtotime($fdate)); |
|
72 | + $fday = date("d", strtotime($fdate)); |
|
73 | + $fmonth = date("m", strtotime($fdate)); |
|
74 | + $fyear = date("Y", strtotime($fdate)); |
|
75 | 75 | |
76 | 76 | |
77 | - $fmonthName = date("M", mktime(0, 0, 0, $fmonth, 10)); |
|
77 | + $fmonthName = date("M", mktime(0, 0, 0, $fmonth, 10)); |
|
78 | 78 | |
79 | - $lday = mysql_query("SELECT substr(LAST_DAY('$fdate'),-2,2) as lastday "); |
|
80 | - $l = mysql_fetch_array($lday); |
|
81 | - $f_lastday = $l['lastday']; |
|
82 | - $f_jml = ($f_lastday-$fday)+1; |
|
79 | + $lday = mysql_query("SELECT substr(LAST_DAY('$fdate'),-2,2) as lastday "); |
|
80 | + $l = mysql_fetch_array($lday); |
|
81 | + $f_lastday = $l['lastday']; |
|
82 | + $f_jml = ($f_lastday-$fday)+1; |
|
83 | 83 | |
84 | - //$ldate = '2014-08-15'; |
|
84 | + //$ldate = '2014-08-15'; |
|
85 | 85 | |
86 | - $lday = date("d", strtotime($ldate)); |
|
87 | - $lmonth = date("m", strtotime($ldate)); |
|
88 | - $lyear = date("Y", strtotime($ldate)); |
|
89 | - $l_jml = $lday; |
|
86 | + $lday = date("d", strtotime($ldate)); |
|
87 | + $lmonth = date("m", strtotime($ldate)); |
|
88 | + $lyear = date("Y", strtotime($ldate)); |
|
89 | + $l_jml = $lday; |
|
90 | 90 | |
91 | - $lmonthName = date("M", mktime(0, 0, 0, $lmonth, 10)); |
|
91 | + $lmonthName = date("M", mktime(0, 0, 0, $lmonth, 10)); |
|
92 | 92 | |
93 | - $jml = ($lday - $fday)+1; |
|
93 | + $jml = ($lday - $fday)+1; |
|
94 | 94 | |
95 | 95 | |
96 | 96 | if($_GET['ldate']) { |
97 | - if ($lmonth == $fmonth and $lyear == $fyear) { |
|
98 | - $jcol = $jml; |
|
99 | - } else { |
|
100 | - $jcol = $f_jml+$l_jml; |
|
101 | - } |
|
97 | + if ($lmonth == $fmonth and $lyear == $fyear) { |
|
98 | + $jcol = $jml; |
|
99 | + } else { |
|
100 | + $jcol = $f_jml+$l_jml; |
|
101 | + } |
|
102 | 102 | } else { |
103 | - $jcol = 8; |
|
103 | + $jcol = 8; |
|
104 | 104 | } |
105 | 105 | |
106 | 106 | ?> |
@@ -122,15 +122,15 @@ discard block |
||
122 | 122 | <select name="room_type" class="form-control1" required onChange="document.myform.submit();"> |
123 | 123 | <option value="">--------- Room Type ---------</option> |
124 | 124 | <? |
125 | - $query = mysql_query('SELECT * FROM room_type ORDER BY room_type'); |
|
126 | - if($query && mysql_num_rows($query) > 0){ |
|
127 | - while($row = mysql_fetch_object($query)){ |
|
128 | - echo '<option value="'.$row->id_room_type.'"'; |
|
129 | - if($row->id_room_type == $_GET['room_type']) echo ' selected'; |
|
130 | - echo '>'.$row->room_type.'</option>'; |
|
131 | - } |
|
132 | - } |
|
133 | - ?> |
|
125 | + $query = mysql_query('SELECT * FROM room_type ORDER BY room_type'); |
|
126 | + if($query && mysql_num_rows($query) > 0){ |
|
127 | + while($row = mysql_fetch_object($query)){ |
|
128 | + echo '<option value="'.$row->id_room_type.'"'; |
|
129 | + if($row->id_room_type == $_GET['room_type']) echo ' selected'; |
|
130 | + echo '>'.$row->room_type.'</option>'; |
|
131 | + } |
|
132 | + } |
|
133 | + ?> |
|
134 | 134 | </select> |
135 | 135 | </div> |
136 | 136 | |
@@ -155,38 +155,38 @@ discard block |
||
155 | 155 | <th style='text-align:center;' width='17%' ><h3 style='font-size:12px;'>Room</h3></th> |
156 | 156 | |
157 | 157 | <? |
158 | - $col = (83/$jcol); |
|
158 | + $col = (83/$jcol); |
|
159 | 159 | |
160 | 160 | |
161 | - if ($lmonth == $fmonth and $lyear == $fyear) { |
|
161 | + if ($lmonth == $fmonth and $lyear == $fyear) { |
|
162 | 162 | |
163 | - for($i = $fday; $i <= $lday; $i++) { |
|
163 | + for($i = $fday; $i <= $lday; $i++) { |
|
164 | 164 | |
165 | - if (strlen($i) == '1') { |
|
166 | - $tgl = '0'.$i; |
|
167 | - } else { |
|
168 | - $tgl = $i; |
|
169 | - } |
|
165 | + if (strlen($i) == '1') { |
|
166 | + $tgl = '0'.$i; |
|
167 | + } else { |
|
168 | + $tgl = $i; |
|
169 | + } |
|
170 | 170 | |
171 | - $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
171 | + $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
172 | 172 | |
173 | - $DayName = date("D",strtotime($tanggal)); |
|
173 | + $DayName = date("D",strtotime($tanggal)); |
|
174 | 174 | |
175 | - $sSQL= "select sdate from special_day_detail where sdate in ('$tanggal')"; |
|
176 | - $sday = mysql_query($sSQL); |
|
177 | - $s=mysql_fetch_array($sday); |
|
175 | + $sSQL= "select sdate from special_day_detail where sdate in ('$tanggal')"; |
|
176 | + $sday = mysql_query($sSQL); |
|
177 | + $s=mysql_fetch_array($sday); |
|
178 | 178 | |
179 | - $nday = date('N', strtotime($tanggal)); |
|
179 | + $nday = date('N', strtotime($tanggal)); |
|
180 | 180 | |
181 | - if($s['sdate']) { |
|
182 | - $bg ='#eba51c'; |
|
183 | - } else if ($nday == '6' or $nday == '7') { |
|
184 | - $bg ='#eb1c41'; |
|
185 | - } else { |
|
186 | - $bg =''; |
|
187 | - } |
|
181 | + if($s['sdate']) { |
|
182 | + $bg ='#eba51c'; |
|
183 | + } else if ($nday == '6' or $nday == '7') { |
|
184 | + $bg ='#eb1c41'; |
|
185 | + } else { |
|
186 | + $bg =''; |
|
187 | + } |
|
188 | 188 | |
189 | - echo"<th style='text-align:center;background-color:$bg' width='$col%'> |
|
189 | + echo"<th style='text-align:center;background-color:$bg' width='$col%'> |
|
190 | 190 | <h3 style='font-size:12px;'> |
191 | 191 | $tgl<BR> |
192 | 192 | $fmonthName<BR> |
@@ -194,37 +194,37 @@ discard block |
||
194 | 194 | </h3> |
195 | 195 | </th>"; |
196 | 196 | |
197 | - } |
|
197 | + } |
|
198 | 198 | |
199 | - } else { |
|
199 | + } else { |
|
200 | 200 | |
201 | - for($i = $fday; $i <= $f_lastday; $i++) { |
|
201 | + for($i = $fday; $i <= $f_lastday; $i++) { |
|
202 | 202 | |
203 | - if (strlen($i) == '1') { |
|
204 | - $tgl = '0'.$i; |
|
205 | - } else { |
|
206 | - $tgl = $i; |
|
207 | - } |
|
203 | + if (strlen($i) == '1') { |
|
204 | + $tgl = '0'.$i; |
|
205 | + } else { |
|
206 | + $tgl = $i; |
|
207 | + } |
|
208 | 208 | |
209 | - $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
209 | + $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
210 | 210 | |
211 | - $DayName = date("D",strtotime($tanggal)); |
|
211 | + $DayName = date("D",strtotime($tanggal)); |
|
212 | 212 | |
213 | - $sSQL= "select sdate from special_day_detail where sdate in ('$tanggal')"; |
|
214 | - $sday = mysql_query($sSQL); |
|
215 | - $s=mysql_fetch_array($sday); |
|
213 | + $sSQL= "select sdate from special_day_detail where sdate in ('$tanggal')"; |
|
214 | + $sday = mysql_query($sSQL); |
|
215 | + $s=mysql_fetch_array($sday); |
|
216 | 216 | |
217 | - $nday = date('N', strtotime($tanggal)); |
|
217 | + $nday = date('N', strtotime($tanggal)); |
|
218 | 218 | |
219 | - if($s['sdate']) { |
|
220 | - $bg ='#eba51c'; |
|
221 | - } else if ($nday == '6' or $nday == '7') { |
|
222 | - $bg ='#eb1c41'; |
|
223 | - } else { |
|
224 | - $bg =''; |
|
225 | - } |
|
219 | + if($s['sdate']) { |
|
220 | + $bg ='#eba51c'; |
|
221 | + } else if ($nday == '6' or $nday == '7') { |
|
222 | + $bg ='#eb1c41'; |
|
223 | + } else { |
|
224 | + $bg =''; |
|
225 | + } |
|
226 | 226 | |
227 | - echo"<th style='text-align:center;background-color:$bg' width='$col%'> |
|
227 | + echo"<th style='text-align:center;background-color:$bg' width='$col%'> |
|
228 | 228 | <h3 style='font-size:12px;'> |
229 | 229 | $tgl<BR> |
230 | 230 | $fmonthName<BR> |
@@ -232,36 +232,36 @@ discard block |
||
232 | 232 | </h3> |
233 | 233 | </th>"; |
234 | 234 | |
235 | - } |
|
235 | + } |
|
236 | 236 | |
237 | - for($i = 1; $i <= $lday; $i++) { |
|
237 | + for($i = 1; $i <= $lday; $i++) { |
|
238 | 238 | |
239 | - if (strlen($i) == '1') { |
|
240 | - $tgl = '0'.$i; |
|
241 | - } else { |
|
242 | - $tgl = $i; |
|
243 | - } |
|
239 | + if (strlen($i) == '1') { |
|
240 | + $tgl = '0'.$i; |
|
241 | + } else { |
|
242 | + $tgl = $i; |
|
243 | + } |
|
244 | 244 | |
245 | - $tanggal = $lyear.'-'.$lmonth.'-'.$tgl; |
|
245 | + $tanggal = $lyear.'-'.$lmonth.'-'.$tgl; |
|
246 | 246 | |
247 | 247 | |
248 | - $DayName = date("D",strtotime($tanggal)); |
|
248 | + $DayName = date("D",strtotime($tanggal)); |
|
249 | 249 | |
250 | - $sSQL= "select sdate from special_day_detail where sdate in ('$tanggal')"; |
|
251 | - $sday = mysql_query($sSQL); |
|
252 | - $s=mysql_fetch_array($sday); |
|
250 | + $sSQL= "select sdate from special_day_detail where sdate in ('$tanggal')"; |
|
251 | + $sday = mysql_query($sSQL); |
|
252 | + $s=mysql_fetch_array($sday); |
|
253 | 253 | |
254 | - $nday = date('N', strtotime($tanggal)); |
|
254 | + $nday = date('N', strtotime($tanggal)); |
|
255 | 255 | |
256 | - if($s['sdate']) { |
|
257 | - $bg ='#eba51c'; |
|
258 | - } else if ($nday == '6' or $nday == '7') { |
|
259 | - $bg ='#eb1c41'; |
|
260 | - } else { |
|
261 | - $bg =''; |
|
262 | - } |
|
256 | + if($s['sdate']) { |
|
257 | + $bg ='#eba51c'; |
|
258 | + } else if ($nday == '6' or $nday == '7') { |
|
259 | + $bg ='#eb1c41'; |
|
260 | + } else { |
|
261 | + $bg =''; |
|
262 | + } |
|
263 | 263 | |
264 | - echo"<th style='text-align:center;background-color:$bg' width='$col%'> |
|
264 | + echo"<th style='text-align:center;background-color:$bg' width='$col%'> |
|
265 | 265 | <h3 style='font-size:12px;'> |
266 | 266 | $tgl<BR> |
267 | 267 | $lmonthName<BR> |
@@ -269,10 +269,10 @@ discard block |
||
269 | 269 | </h3> |
270 | 270 | </th>"; |
271 | 271 | |
272 | - } |
|
273 | - } |
|
272 | + } |
|
273 | + } |
|
274 | 274 | |
275 | - ?> |
|
275 | + ?> |
|
276 | 276 | |
277 | 277 | </tr> |
278 | 278 | |
@@ -282,125 +282,125 @@ discard block |
||
282 | 282 | |
283 | 283 | |
284 | 284 | <? |
285 | - $tSQL = "SELECT * FROM room_type "; |
|
285 | + $tSQL = "SELECT * FROM room_type "; |
|
286 | 286 | |
287 | - if ($_GET['room_type']){ |
|
288 | - $tSQL .= "WHERE id_room_type = '$_GET[room_type]'"; |
|
289 | - } |
|
287 | + if ($_GET['room_type']){ |
|
288 | + $tSQL .= "WHERE id_room_type = '$_GET[room_type]'"; |
|
289 | + } |
|
290 | 290 | |
291 | - $tSQL .= "ORDER BY room_type"; |
|
291 | + $tSQL .= "ORDER BY room_type"; |
|
292 | 292 | |
293 | - $type = mysql_query($tSQL); |
|
293 | + $type = mysql_query($tSQL); |
|
294 | 294 | |
295 | - while($t=mysql_fetch_array($type)){ |
|
295 | + while($t=mysql_fetch_array($type)){ |
|
296 | 296 | |
297 | - $id_room_type = $t['id_room_type']; |
|
297 | + $id_room_type = $t['id_room_type']; |
|
298 | 298 | |
299 | 299 | |
300 | - echo"<tr>"; |
|
301 | - echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'>".$t['room_type']."</td>"; |
|
300 | + echo"<tr>"; |
|
301 | + echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'>".$t['room_type']."</td>"; |
|
302 | 302 | |
303 | 303 | |
304 | - if ($lmonth == $fmonth and $lyear == $fyear) { |
|
304 | + if ($lmonth == $fmonth and $lyear == $fyear) { |
|
305 | 305 | |
306 | - for($i = $fday; $i <= $lday; $i++) { |
|
306 | + for($i = $fday; $i <= $lday; $i++) { |
|
307 | 307 | |
308 | - if (strlen($i) == '1') { |
|
309 | - $tgl = '0'.$i; |
|
310 | - } else { |
|
311 | - $tgl = $i; |
|
312 | - } |
|
308 | + if (strlen($i) == '1') { |
|
309 | + $tgl = '0'.$i; |
|
310 | + } else { |
|
311 | + $tgl = $i; |
|
312 | + } |
|
313 | 313 | |
314 | - $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
314 | + $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
315 | 315 | |
316 | - echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'> |
|
316 | + echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'> |
|
317 | 317 | </td>"; |
318 | 318 | |
319 | - } |
|
319 | + } |
|
320 | 320 | |
321 | - } else { |
|
321 | + } else { |
|
322 | 322 | |
323 | - for($i = $fday; $i <= $f_lastday; $i++) { |
|
323 | + for($i = $fday; $i <= $f_lastday; $i++) { |
|
324 | 324 | |
325 | - if (strlen($i) == '1') { |
|
326 | - $tgl = '0'.$i; |
|
327 | - } else { |
|
328 | - $tgl = $i; |
|
329 | - } |
|
325 | + if (strlen($i) == '1') { |
|
326 | + $tgl = '0'.$i; |
|
327 | + } else { |
|
328 | + $tgl = $i; |
|
329 | + } |
|
330 | 330 | |
331 | - $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
331 | + $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
332 | 332 | |
333 | - $DayName = date("D",strtotime($tanggal)); |
|
333 | + $DayName = date("D",strtotime($tanggal)); |
|
334 | 334 | |
335 | - echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'> |
|
335 | + echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'> |
|
336 | 336 | </td>"; |
337 | 337 | |
338 | - } |
|
338 | + } |
|
339 | 339 | |
340 | - for($i = 1; $i <= $lday; $i++) { |
|
340 | + for($i = 1; $i <= $lday; $i++) { |
|
341 | 341 | |
342 | - if (strlen($i) == '1') { |
|
343 | - $tgl = '0'.$i; |
|
344 | - } else { |
|
345 | - $tgl = $i; |
|
346 | - } |
|
342 | + if (strlen($i) == '1') { |
|
343 | + $tgl = '0'.$i; |
|
344 | + } else { |
|
345 | + $tgl = $i; |
|
346 | + } |
|
347 | 347 | |
348 | - $tanggal = $lyear.'-'.$lmonth.'-'.$tgl; |
|
348 | + $tanggal = $lyear.'-'.$lmonth.'-'.$tgl; |
|
349 | 349 | |
350 | - $DayName = date("D",strtotime($tanggal)); |
|
350 | + $DayName = date("D",strtotime($tanggal)); |
|
351 | 351 | |
352 | - echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'> |
|
352 | + echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'> |
|
353 | 353 | </td>"; |
354 | 354 | |
355 | - } |
|
356 | - } |
|
355 | + } |
|
356 | + } |
|
357 | 357 | |
358 | - echo"</tr>"; |
|
358 | + echo"</tr>"; |
|
359 | 359 | |
360 | - $rSQL= "SELECT * FROM room WHERE id_room_type = '$id_room_type' ORDER BY room_no"; |
|
360 | + $rSQL= "SELECT * FROM room WHERE id_room_type = '$id_room_type' ORDER BY room_no"; |
|
361 | 361 | |
362 | - $room = mysql_query($rSQL); |
|
362 | + $room = mysql_query($rSQL); |
|
363 | 363 | |
364 | - $no = 1; |
|
365 | - while($r=mysql_fetch_array($room)){ |
|
364 | + $no = 1; |
|
365 | + while($r=mysql_fetch_array($room)){ |
|
366 | 366 | |
367 | - $aktif = $r['aktif']; |
|
367 | + $aktif = $r['aktif']; |
|
368 | 368 | |
369 | - if(($no % 2)==0){ |
|
370 | - $sty="ftd"; |
|
371 | - } else{ |
|
372 | - $sty="ltd"; |
|
373 | - } |
|
369 | + if(($no % 2)==0){ |
|
370 | + $sty="ftd"; |
|
371 | + } else{ |
|
372 | + $sty="ltd"; |
|
373 | + } |
|
374 | 374 | |
375 | - $id_room = $r['id_room']; |
|
375 | + $id_room = $r['id_room']; |
|
376 | 376 | |
377 | - echo"<tr>"; |
|
378 | - echo"<td style='padding-left:20px;text-align:left;' class=$sty>".$r['room_no']."</td>"; |
|
377 | + echo"<tr>"; |
|
378 | + echo"<td style='padding-left:20px;text-align:left;' class=$sty>".$r['room_no']."</td>"; |
|
379 | 379 | |
380 | - if ($lmonth == $fmonth and $lyear == $fyear) { |
|
380 | + if ($lmonth == $fmonth and $lyear == $fyear) { |
|
381 | 381 | |
382 | - for($i = $fday; $i <= $lday; $i++) { |
|
382 | + for($i = $fday; $i <= $lday; $i++) { |
|
383 | 383 | |
384 | - if (strlen($i) == '1') { |
|
385 | - $tgl = '0'.$i; |
|
386 | - } else { |
|
387 | - $tgl = $i; |
|
388 | - } |
|
384 | + if (strlen($i) == '1') { |
|
385 | + $tgl = '0'.$i; |
|
386 | + } else { |
|
387 | + $tgl = $i; |
|
388 | + } |
|
389 | 389 | |
390 | - $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
390 | + $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
391 | 391 | |
392 | - echo"<td class=$sty style='padding:0;'>"; |
|
392 | + echo"<td class=$sty style='padding:0;'>"; |
|
393 | 393 | |
394 | - if ($aktif == 'T') { |
|
395 | - echo" |
|
394 | + if ($aktif == 'T') { |
|
395 | + echo" |
|
396 | 396 | <i class='fa fa-warning' style='color: red;font-size:18px' onMouseover=\"ddrivetip('Out of Order')\"; onMouseout=\"hideddrivetip()\"></i> |
397 | 397 | "; |
398 | - } |
|
398 | + } |
|
399 | 399 | |
400 | - echo"<table cellpadding='0' cellspacing='0' border='0' width='100%'>"; |
|
401 | - echo"<tr>"; |
|
400 | + echo"<table cellpadding='0' cellspacing='0' border='0' width='100%'>"; |
|
401 | + echo"<tr>"; |
|
402 | 402 | |
403 | - $cSQL = "SELECT a.id_room,a.room_no,b.rdate,b.status,a.aktif,c.guest,c.initial,d.legend |
|
403 | + $cSQL = "SELECT a.id_room,a.room_no,b.rdate,b.status,a.aktif,c.guest,c.initial,d.legend |
|
404 | 404 | FROM room a left join room_reservation b |
405 | 405 | ON a.id_room = b.id_room |
406 | 406 | and b.status in ('0','1') |
@@ -412,150 +412,150 @@ discard block |
||
412 | 412 | AND b.rdate = '$tanggal' |
413 | 413 | ORDER BY a.room_no,b.id_reservation"; |
414 | 414 | |
415 | - $croom = mysql_query($cSQL); |
|
415 | + $croom = mysql_query($cSQL); |
|
416 | 416 | |
417 | - $jml = mysql_num_rows($croom); |
|
417 | + $jml = mysql_num_rows($croom); |
|
418 | 418 | |
419 | - //$c=mysql_fetch_array($croom); |
|
420 | - while ($c=mysql_fetch_array($croom)){ |
|
419 | + //$c=mysql_fetch_array($croom); |
|
420 | + while ($c=mysql_fetch_array($croom)){ |
|
421 | 421 | |
422 | - $rdate = $c['rdate']; |
|
422 | + $rdate = $c['rdate']; |
|
423 | 423 | |
424 | - $lSQL = "SELECT '$rdate' - INTERVAL 1 DAY as ldate, '$rdate' + INTERVAL 1 DAY as ndate "; |
|
425 | - //echo $lSQL; |
|
426 | - $ld = mysql_query($lSQL); |
|
424 | + $lSQL = "SELECT '$rdate' - INTERVAL 1 DAY as ldate, '$rdate' + INTERVAL 1 DAY as ndate "; |
|
425 | + //echo $lSQL; |
|
426 | + $ld = mysql_query($lSQL); |
|
427 | 427 | |
428 | - $l=mysql_fetch_array($ld); |
|
428 | + $l=mysql_fetch_array($ld); |
|
429 | 429 | |
430 | - $ldate = $l['ldate']; |
|
430 | + $ldate = $l['ldate']; |
|
431 | 431 | |
432 | - $ndate = $l['ndate']; |
|
432 | + $ndate = $l['ndate']; |
|
433 | 433 | |
434 | - $cSQL1 = "SELECT * from room_reservation |
|
434 | + $cSQL1 = "SELECT * from room_reservation |
|
435 | 435 | WHERE id_room = '$id_room' |
436 | 436 | AND rdate = '$ldate'"; |
437 | 437 | |
438 | - $lroom = mysql_query($cSQL1); |
|
438 | + $lroom = mysql_query($cSQL1); |
|
439 | 439 | |
440 | - if ($ldate) { |
|
441 | - $ljml = mysql_num_rows($lroom); |
|
442 | - } else { |
|
443 | - $ljml = '0'; |
|
444 | - } |
|
440 | + if ($ldate) { |
|
441 | + $ljml = mysql_num_rows($lroom); |
|
442 | + } else { |
|
443 | + $ljml = '0'; |
|
444 | + } |
|
445 | 445 | |
446 | 446 | |
447 | - $cSQL2 = "SELECT * from room_reservation |
|
447 | + $cSQL2 = "SELECT * from room_reservation |
|
448 | 448 | WHERE id_room = '$id_room' |
449 | 449 | AND rdate = '$ndate'"; |
450 | 450 | |
451 | - $nroom = mysql_query($cSQL2); |
|
451 | + $nroom = mysql_query($cSQL2); |
|
452 | 452 | |
453 | - $njml = mysql_num_rows($nroom); |
|
453 | + $njml = mysql_num_rows($nroom); |
|
454 | 454 | |
455 | 455 | |
456 | - if ($ndate) { |
|
457 | - $njml = mysql_num_rows($nroom); |
|
458 | - } else { |
|
459 | - $njml = '0'; |
|
460 | - } |
|
456 | + if ($ndate) { |
|
457 | + $njml = mysql_num_rows($nroom); |
|
458 | + } else { |
|
459 | + $njml = '0'; |
|
460 | + } |
|
461 | 461 | |
462 | 462 | |
463 | - $guest = $c['guest']; |
|
463 | + $guest = $c['guest']; |
|
464 | 464 | |
465 | - $legend = $c['legend']; |
|
466 | - $status = $c['status']; |
|
465 | + $legend = $c['legend']; |
|
466 | + $status = $c['status']; |
|
467 | 467 | |
468 | 468 | |
469 | - if ($status == 0) { |
|
470 | - $icolor = '#fff'; |
|
471 | - } else { |
|
472 | - $icolor = '#fff'; |
|
473 | - } |
|
469 | + if ($status == 0) { |
|
470 | + $icolor = '#fff'; |
|
471 | + } else { |
|
472 | + $icolor = '#fff'; |
|
473 | + } |
|
474 | 474 | |
475 | - if ($status == 0) { |
|
476 | - $istatus = 'Reserved'; |
|
477 | - } elseif ($status == 1) { |
|
478 | - $istatus = 'Check In'; |
|
479 | - } else { |
|
480 | - $istatus = 'Check Out'; |
|
481 | - } |
|
475 | + if ($status == 0) { |
|
476 | + $istatus = 'Reserved'; |
|
477 | + } elseif ($status == 1) { |
|
478 | + $istatus = 'Check In'; |
|
479 | + } else { |
|
480 | + $istatus = 'Check Out'; |
|
481 | + } |
|
482 | 482 | |
483 | - $iguest = trim($c['initial']).'. '.trim($c['guest']).' | '.$istatus; |
|
483 | + $iguest = trim($c['initial']).'. '.trim($c['guest']).' | '.$istatus; |
|
484 | 484 | |
485 | 485 | |
486 | 486 | |
487 | - if($c['initial'] == 'Mr ' ) { |
|
488 | - $icon = 'fa fa-male'; |
|
489 | - } else { |
|
490 | - $icon = 'fa fa-female'; |
|
491 | - } |
|
487 | + if($c['initial'] == 'Mr ' ) { |
|
488 | + $icon = 'fa fa-male'; |
|
489 | + } else { |
|
490 | + $icon = 'fa fa-female'; |
|
491 | + } |
|
492 | 492 | |
493 | - echo $ljml.'-'.$jml.'-'.$njml; |
|
493 | + echo $ljml.'-'.$jml.'-'.$njml; |
|
494 | 494 | |
495 | - //if ($jml == '1') { |
|
495 | + //if ($jml == '1') { |
|
496 | 496 | |
497 | - if ($ljml == '0' and $jml == '1' and $njml == '1') { |
|
498 | - echo"<td width='50%'> |
|
497 | + if ($ljml == '0' and $jml == '1' and $njml == '1') { |
|
498 | + echo"<td width='50%'> |
|
499 | 499 | </td>"; |
500 | - } |
|
500 | + } |
|
501 | 501 | |
502 | - if ($guest) { |
|
502 | + if ($guest) { |
|
503 | 503 | |
504 | 504 | |
505 | - if ($guest) { |
|
506 | - echo"<td style='background-color:$legend;' width='50%'> |
|
505 | + if ($guest) { |
|
506 | + echo"<td style='background-color:$legend;' width='50%'> |
|
507 | 507 | <a href='' onMouseover=\"ddrivetip('$iguest')\"; onMouseout=\"hideddrivetip()\" title=''><i class='$icon' style='color: $icolor;font-size:15px'></i></a> |
508 | 508 | </td>"; |
509 | - } else { |
|
510 | - echo"<td style='background-color:$legend;' width='50%'> |
|
509 | + } else { |
|
510 | + echo"<td style='background-color:$legend;' width='50%'> |
|
511 | 511 | </td>"; |
512 | - } |
|
512 | + } |
|
513 | 513 | |
514 | 514 | |
515 | - } |
|
515 | + } |
|
516 | 516 | |
517 | - } |
|
517 | + } |
|
518 | 518 | |
519 | - if ($ljml != '0' and $jml == '1') { |
|
520 | - echo"<td width='50%'> |
|
519 | + if ($ljml != '0' and $jml == '1') { |
|
520 | + echo"<td width='50%'> |
|
521 | 521 | </td>"; |
522 | - } |
|
522 | + } |
|
523 | 523 | |
524 | - //} |
|
524 | + //} |
|
525 | 525 | |
526 | 526 | |
527 | 527 | |
528 | - echo"</tr>"; |
|
529 | - echo"</table>"; |
|
530 | - echo"</td>"; |
|
528 | + echo"</tr>"; |
|
529 | + echo"</table>"; |
|
530 | + echo"</td>"; |
|
531 | 531 | |
532 | 532 | |
533 | - } |
|
533 | + } |
|
534 | 534 | |
535 | - } else { |
|
535 | + } else { |
|
536 | 536 | |
537 | - for($i = $fday; $i <= $f_lastday; $i++) { |
|
537 | + for($i = $fday; $i <= $f_lastday; $i++) { |
|
538 | 538 | |
539 | - if (strlen($i) == '1') { |
|
540 | - $tgl = '0'.$i; |
|
541 | - } else { |
|
542 | - $tgl = $i; |
|
543 | - } |
|
539 | + if (strlen($i) == '1') { |
|
540 | + $tgl = '0'.$i; |
|
541 | + } else { |
|
542 | + $tgl = $i; |
|
543 | + } |
|
544 | 544 | |
545 | - $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
545 | + $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
546 | 546 | |
547 | - echo"<td class=$sty style='padding:0;'>"; |
|
547 | + echo"<td class=$sty style='padding:0;'>"; |
|
548 | 548 | |
549 | - if ($aktif == 'T') { |
|
550 | - echo" |
|
549 | + if ($aktif == 'T') { |
|
550 | + echo" |
|
551 | 551 | <i class='fa fa-warning' style='color: red;font-size:18px' onMouseover=\"ddrivetip('Out of Order')\"; onMouseout=\"hideddrivetip()\"></i> |
552 | 552 | "; |
553 | - } |
|
553 | + } |
|
554 | 554 | |
555 | - echo"<table cellpadding='0' cellspacing='0' border='0' width='100%'>"; |
|
556 | - echo"<tr>"; |
|
555 | + echo"<table cellpadding='0' cellspacing='0' border='0' width='100%'>"; |
|
556 | + echo"<tr>"; |
|
557 | 557 | |
558 | - $cSQL = "SELECT a.id_room,a.room_no,b.rdate,b.status,a.aktif,c.guest,c.initial,d.legend |
|
558 | + $cSQL = "SELECT a.id_room,a.room_no,b.rdate,b.status,a.aktif,c.guest,c.initial,d.legend |
|
559 | 559 | FROM room a left join room_reservation b |
560 | 560 | ON a.id_room = b.id_room |
561 | 561 | and b.status in ('0','1') |
@@ -567,96 +567,96 @@ discard block |
||
567 | 567 | AND b.rdate = '$tanggal' |
568 | 568 | ORDER BY a.room_no"; |
569 | 569 | |
570 | - $croom = mysql_query($cSQL); |
|
570 | + $croom = mysql_query($cSQL); |
|
571 | 571 | |
572 | - $jml = mysql_num_rows($croom); |
|
572 | + $jml = mysql_num_rows($croom); |
|
573 | 573 | |
574 | - //$c=mysql_fetch_array($croom); |
|
575 | - while ($c=mysql_fetch_array($croom)){ |
|
574 | + //$c=mysql_fetch_array($croom); |
|
575 | + while ($c=mysql_fetch_array($croom)){ |
|
576 | 576 | |
577 | 577 | |
578 | - $guest = $c['guest']; |
|
578 | + $guest = $c['guest']; |
|
579 | 579 | |
580 | - $legend = $c['legend']; |
|
581 | - $status = $c['status']; |
|
580 | + $legend = $c['legend']; |
|
581 | + $status = $c['status']; |
|
582 | 582 | |
583 | - if ($status == 0) { |
|
584 | - $icolor = '#fff'; |
|
585 | - } else { |
|
586 | - $icolor = '#fff'; |
|
587 | - } |
|
583 | + if ($status == 0) { |
|
584 | + $icolor = '#fff'; |
|
585 | + } else { |
|
586 | + $icolor = '#fff'; |
|
587 | + } |
|
588 | 588 | |
589 | - if ($status == 0) { |
|
590 | - $istatus = 'Reserved'; |
|
591 | - } elseif ($status == 1) { |
|
592 | - $istatus = 'Check In'; |
|
593 | - } else { |
|
594 | - $istatus = 'Check Out'; |
|
595 | - } |
|
589 | + if ($status == 0) { |
|
590 | + $istatus = 'Reserved'; |
|
591 | + } elseif ($status == 1) { |
|
592 | + $istatus = 'Check In'; |
|
593 | + } else { |
|
594 | + $istatus = 'Check Out'; |
|
595 | + } |
|
596 | 596 | |
597 | - $iguest = trim($c['initial']).'. '.trim($c['guest']).' | '.$istatus; |
|
597 | + $iguest = trim($c['initial']).'. '.trim($c['guest']).' | '.$istatus; |
|
598 | 598 | |
599 | 599 | |
600 | 600 | |
601 | - if($c['initial'] == 'Mr ' ) { |
|
602 | - $icon = 'fa fa-male'; |
|
603 | - } else { |
|
604 | - $icon = 'fa fa-female'; |
|
605 | - } |
|
601 | + if($c['initial'] == 'Mr ' ) { |
|
602 | + $icon = 'fa fa-male'; |
|
603 | + } else { |
|
604 | + $icon = 'fa fa-female'; |
|
605 | + } |
|
606 | 606 | |
607 | - if ($guest) { |
|
607 | + if ($guest) { |
|
608 | 608 | |
609 | 609 | |
610 | - if ($guest) { |
|
611 | - echo"<td style='background-color:$legend;' width='50%'> |
|
610 | + if ($guest) { |
|
611 | + echo"<td style='background-color:$legend;' width='50%'> |
|
612 | 612 | <a href='' onMouseover=\"ddrivetip('$iguest')\"; onMouseout=\"hideddrivetip()\" title=''><i class='$icon' style='color: $icolor;font-size:15px'></i></a> |
613 | 613 | </td>"; |
614 | - } else { |
|
615 | - echo"<td style='background-color:$legend;' width='50%'> |
|
614 | + } else { |
|
615 | + echo"<td style='background-color:$legend;' width='50%'> |
|
616 | 616 | </td>"; |
617 | - } |
|
617 | + } |
|
618 | 618 | |
619 | 619 | |
620 | - } |
|
620 | + } |
|
621 | 621 | |
622 | - } |
|
622 | + } |
|
623 | 623 | |
624 | - if ($jml == '1') { |
|
624 | + if ($jml == '1') { |
|
625 | 625 | |
626 | 626 | |
627 | - echo"<td width='50%'> |
|
627 | + echo"<td width='50%'> |
|
628 | 628 | </td>"; |
629 | - } |
|
629 | + } |
|
630 | 630 | |
631 | - echo"</tr>"; |
|
632 | - echo"</table>"; |
|
633 | - echo"</td>"; |
|
631 | + echo"</tr>"; |
|
632 | + echo"</table>"; |
|
633 | + echo"</td>"; |
|
634 | 634 | |
635 | 635 | |
636 | - } |
|
636 | + } |
|
637 | 637 | |
638 | - for($i = 1; $i <= $lday; $i++) { |
|
638 | + for($i = 1; $i <= $lday; $i++) { |
|
639 | 639 | |
640 | - if (strlen($i) == '1') { |
|
641 | - $tgl = '0'.$i; |
|
642 | - } else { |
|
643 | - $tgl = $i; |
|
644 | - } |
|
640 | + if (strlen($i) == '1') { |
|
641 | + $tgl = '0'.$i; |
|
642 | + } else { |
|
643 | + $tgl = $i; |
|
644 | + } |
|
645 | 645 | |
646 | - $tanggal = $lyear.'-'.$lmonth.'-'.$tgl; |
|
646 | + $tanggal = $lyear.'-'.$lmonth.'-'.$tgl; |
|
647 | 647 | |
648 | - echo"<td class=$sty style='padding:0;'>"; |
|
648 | + echo"<td class=$sty style='padding:0;'>"; |
|
649 | 649 | |
650 | - if ($aktif == 'T') { |
|
651 | - echo" |
|
650 | + if ($aktif == 'T') { |
|
651 | + echo" |
|
652 | 652 | <i class='fa fa-warning' style='color: red;font-size:18px' onMouseover=\"ddrivetip('Out of Order')\"; onMouseout=\"hideddrivetip()\"></i> |
653 | 653 | "; |
654 | - } |
|
654 | + } |
|
655 | 655 | |
656 | - echo"<table cellpadding='0' cellspacing='0' border='0' width='100%'>"; |
|
657 | - echo"<tr>"; |
|
656 | + echo"<table cellpadding='0' cellspacing='0' border='0' width='100%'>"; |
|
657 | + echo"<tr>"; |
|
658 | 658 | |
659 | - $cSQL = "SELECT a.id_room,a.room_no,b.rdate,b.status,a.aktif,c.guest,c.initial,d.legend |
|
659 | + $cSQL = "SELECT a.id_room,a.room_no,b.rdate,b.status,a.aktif,c.guest,c.initial,d.legend |
|
660 | 660 | FROM room a left join room_reservation b |
661 | 661 | ON a.id_room = b.id_room |
662 | 662 | and b.status in ('0','1') |
@@ -668,80 +668,80 @@ discard block |
||
668 | 668 | AND b.rdate = '$tanggal' |
669 | 669 | ORDER BY a.room_no"; |
670 | 670 | |
671 | - $croom = mysql_query($cSQL); |
|
671 | + $croom = mysql_query($cSQL); |
|
672 | 672 | |
673 | - $jml = mysql_num_rows($croom); |
|
673 | + $jml = mysql_num_rows($croom); |
|
674 | 674 | |
675 | - //$c=mysql_fetch_array($croom); |
|
676 | - while ($c=mysql_fetch_array($croom)){ |
|
675 | + //$c=mysql_fetch_array($croom); |
|
676 | + while ($c=mysql_fetch_array($croom)){ |
|
677 | 677 | |
678 | 678 | |
679 | - $guest = $c['guest']; |
|
679 | + $guest = $c['guest']; |
|
680 | 680 | |
681 | - $legend = $c['legend']; |
|
682 | - $status = $c['status']; |
|
681 | + $legend = $c['legend']; |
|
682 | + $status = $c['status']; |
|
683 | 683 | |
684 | - if ($status == 0) { |
|
685 | - $icolor = '#fff'; |
|
686 | - } else { |
|
687 | - $icolor = '#fff'; |
|
688 | - } |
|
684 | + if ($status == 0) { |
|
685 | + $icolor = '#fff'; |
|
686 | + } else { |
|
687 | + $icolor = '#fff'; |
|
688 | + } |
|
689 | 689 | |
690 | - if ($status == 0) { |
|
691 | - $istatus = 'Reserved'; |
|
692 | - } elseif ($status == 1) { |
|
693 | - $istatus = 'Check In'; |
|
694 | - } else { |
|
695 | - $istatus = 'Check Out'; |
|
696 | - } |
|
690 | + if ($status == 0) { |
|
691 | + $istatus = 'Reserved'; |
|
692 | + } elseif ($status == 1) { |
|
693 | + $istatus = 'Check In'; |
|
694 | + } else { |
|
695 | + $istatus = 'Check Out'; |
|
696 | + } |
|
697 | 697 | |
698 | - $iguest = trim($c['initial']).'. '.trim($c['guest']).' | '.$istatus; |
|
698 | + $iguest = trim($c['initial']).'. '.trim($c['guest']).' | '.$istatus; |
|
699 | 699 | |
700 | 700 | |
701 | 701 | |
702 | - if($c['initial'] == 'Mr ' ) { |
|
703 | - $icon = 'fa fa-male'; |
|
704 | - } else { |
|
705 | - $icon = 'fa fa-female'; |
|
706 | - } |
|
702 | + if($c['initial'] == 'Mr ' ) { |
|
703 | + $icon = 'fa fa-male'; |
|
704 | + } else { |
|
705 | + $icon = 'fa fa-female'; |
|
706 | + } |
|
707 | 707 | |
708 | - if ($guest) { |
|
708 | + if ($guest) { |
|
709 | 709 | |
710 | 710 | |
711 | - if ($guest) { |
|
712 | - echo"<td style='background-color:$legend;' width='50%'> |
|
711 | + if ($guest) { |
|
712 | + echo"<td style='background-color:$legend;' width='50%'> |
|
713 | 713 | <a href='' onMouseover=\"ddrivetip('$iguest')\"; onMouseout=\"hideddrivetip()\" title=''><i class='$icon' style='color: $icolor;font-size:15px'></i></a> |
714 | 714 | </td>"; |
715 | - } else { |
|
716 | - echo"<td style='background-color:$legend;' width='50%'> |
|
715 | + } else { |
|
716 | + echo"<td style='background-color:$legend;' width='50%'> |
|
717 | 717 | </td>"; |
718 | - } |
|
718 | + } |
|
719 | 719 | |
720 | 720 | |
721 | - } |
|
721 | + } |
|
722 | 722 | |
723 | - } |
|
723 | + } |
|
724 | 724 | |
725 | - if ($jml == '1') { |
|
726 | - echo"<td width='50%'> |
|
725 | + if ($jml == '1') { |
|
726 | + echo"<td width='50%'> |
|
727 | 727 | </td>"; |
728 | - } |
|
728 | + } |
|
729 | 729 | |
730 | - echo"</tr>"; |
|
731 | - echo"</table>"; |
|
732 | - echo"</td>"; |
|
730 | + echo"</tr>"; |
|
731 | + echo"</table>"; |
|
732 | + echo"</td>"; |
|
733 | 733 | |
734 | 734 | |
735 | - } |
|
736 | - } |
|
737 | - echo"</tr>"; |
|
735 | + } |
|
736 | + } |
|
737 | + echo"</tr>"; |
|
738 | 738 | |
739 | - $no++; |
|
740 | - } |
|
739 | + $no++; |
|
740 | + } |
|
741 | 741 | |
742 | 742 | |
743 | - } |
|
744 | - ?> |
|
743 | + } |
|
744 | + ?> |
|
745 | 745 | |
746 | 746 | </tbody> |
747 | 747 | </table> |
@@ -755,19 +755,19 @@ discard block |
||
755 | 755 | <tr> |
756 | 756 | <td style='padding-right:3px;'>Room Status : </td> |
757 | 757 | <? |
758 | - $SQL= "SELECT * FROM room_status where aktif ='Y' ORDER BY id_room_status"; |
|
759 | - $tampil=mysql_query($SQL); |
|
758 | + $SQL= "SELECT * FROM room_status where aktif ='Y' ORDER BY id_room_status"; |
|
759 | + $tampil=mysql_query($SQL); |
|
760 | 760 | |
761 | - while($r=mysql_fetch_array($tampil)){ |
|
761 | + while($r=mysql_fetch_array($tampil)){ |
|
762 | 762 | |
763 | 763 | |
764 | - echo"<td style='width:20px;background-color:".$r['legend'].";'> </td>"; |
|
765 | - echo"<td style='padding-left:3px;'>".$r['room_status']." </td>"; |
|
764 | + echo"<td style='width:20px;background-color:".$r['legend'].";'> </td>"; |
|
765 | + echo"<td style='padding-left:3px;'>".$r['room_status']." </td>"; |
|
766 | 766 | |
767 | 767 | |
768 | - } |
|
768 | + } |
|
769 | 769 | |
770 | - ?> |
|
770 | + ?> |
|
771 | 771 | </tr> |
772 | 772 | </table> |
773 | 773 | </div> |
@@ -778,14 +778,14 @@ discard block |
||
778 | 778 | <td style='padding-right:3px;'>Day Status : </td> |
779 | 779 | <? |
780 | 780 | |
781 | - echo"<td style='width:20px;background-color:#eba51c;'> </td>"; |
|
782 | - echo"<td style='padding-left:3px;'>Spesial Day </td>"; |
|
783 | - echo"<td style='width:20px;background-color:#eb1c41;'> </td>"; |
|
784 | - echo"<td style='padding-left:3px;'>Weekend </td>"; |
|
785 | - echo"<td style='width:20px;background-color:#2A3F54;;'> </td>"; |
|
786 | - echo"<td style='padding-left:3px;'>Weekday </td>"; |
|
787 | - |
|
788 | - ?> |
|
781 | + echo"<td style='width:20px;background-color:#eba51c;'> </td>"; |
|
782 | + echo"<td style='padding-left:3px;'>Spesial Day </td>"; |
|
783 | + echo"<td style='width:20px;background-color:#eb1c41;'> </td>"; |
|
784 | + echo"<td style='padding-left:3px;'>Weekend </td>"; |
|
785 | + echo"<td style='width:20px;background-color:#2A3F54;;'> </td>"; |
|
786 | + echo"<td style='padding-left:3px;'>Weekday </td>"; |
|
787 | + |
|
788 | + ?> |
|
789 | 789 | </tr> |
790 | 790 | </table> |
791 | 791 | </div> |
@@ -6,11 +6,11 @@ discard block |
||
6 | 6 | |
7 | 7 | if ($_GET['prd']) { |
8 | 8 | |
9 | - $prd = $_GET['prd']; |
|
9 | + $prd = $_GET['prd']; |
|
10 | 10 | |
11 | 11 | } else { |
12 | 12 | |
13 | - $prd = DATE('Y-m'); |
|
13 | + $prd = DATE('Y-m'); |
|
14 | 14 | |
15 | 15 | } |
16 | 16 | |
@@ -331,7 +331,7 @@ discard block |
||
331 | 331 | |
332 | 332 | |
333 | 333 | |
334 | - $tampil=mysql_query("SELECT a.*,b.shift |
|
334 | + $tampil=mysql_query("SELECT a.*,b.shift |
|
335 | 335 | |
336 | 336 | FROM kasir a left join shift b |
337 | 337 | |
@@ -349,15 +349,15 @@ discard block |
||
349 | 349 | |
350 | 350 | |
351 | 351 | |
352 | - $no = 1; |
|
352 | + $no = 1; |
|
353 | 353 | |
354 | 354 | |
355 | 355 | |
356 | - while ($r=mysql_fetch_array($tampil)){ |
|
356 | + while ($r=mysql_fetch_array($tampil)){ |
|
357 | 357 | |
358 | 358 | |
359 | 359 | |
360 | - $tgl = date("d/m/Y", strtotime($r['tanggal'])); |
|
360 | + $tgl = date("d/m/Y", strtotime($r['tanggal'])); |
|
361 | 361 | |
362 | 362 | |
363 | 363 | |
@@ -365,84 +365,84 @@ discard block |
||
365 | 365 | |
366 | 366 | |
367 | 367 | |
368 | - if($r['status'] == '0'){ |
|
368 | + if($r['status'] == '0'){ |
|
369 | 369 | |
370 | 370 | $istatus = 'Baru'; |
371 | 371 | |
372 | - } else if($r['status'] == '1'){ |
|
372 | + } else if($r['status'] == '1'){ |
|
373 | 373 | |
374 | 374 | $istatus = 'Disetujui'; |
375 | 375 | |
376 | - } else if($r['status'] == '2'){ |
|
376 | + } else if($r['status'] == '2'){ |
|
377 | 377 | |
378 | 378 | $istatus = 'Ditolak'; |
379 | 379 | |
380 | - } else if($r['status'] == '9'){ |
|
380 | + } else if($r['status'] == '9'){ |
|
381 | 381 | |
382 | 382 | $istatus = 'Posting'; |
383 | 383 | |
384 | - } else { |
|
384 | + } else { |
|
385 | 385 | |
386 | - $istatus = 'Dibatalkan'; |
|
386 | + $istatus = 'Dibatalkan'; |
|
387 | 387 | |
388 | - } |
|
388 | + } |
|
389 | 389 | |
390 | 390 | |
391 | 391 | |
392 | - $ID = $r[id_kasir]; |
|
392 | + $ID = $r[id_kasir]; |
|
393 | 393 | |
394 | - echo"<tr>"; |
|
394 | + echo"<tr>"; |
|
395 | 395 | |
396 | 396 | |
397 | 397 | |
398 | - echo"<td>$tgl </td>"; |
|
398 | + echo"<td>$tgl </td>"; |
|
399 | 399 | |
400 | 400 | |
401 | - echo"<td>$r[shift]</td>"; |
|
401 | + echo"<td>$r[shift]</td>"; |
|
402 | 402 | |
403 | - echo"<td>$r[petugas]</td>"; |
|
403 | + echo"<td>$r[petugas]</td>"; |
|
404 | 404 | |
405 | - echo"<td>$r[note]</td>"; |
|
405 | + echo"<td>$r[note]</td>"; |
|
406 | 406 | |
407 | - // echo"<td>$istatus</td>"; |
|
407 | + // echo"<td>$istatus</td>"; |
|
408 | 408 | |
409 | - echo"<td style='text-align:center;'>"; |
|
409 | + echo"<td style='text-align:center;'>"; |
|
410 | 410 | |
411 | 411 | |
412 | 412 | |
413 | - if($r_edit == 'Y') { |
|
413 | + if($r_edit == 'Y') { |
|
414 | 414 | |
415 | - echo"<a href='?module=$module&id_module=$id&act=save&ID=$ID' title='Update'><span class='icon'><i class='fa fa-pencil'></i></span></a>"; |
|
415 | + echo"<a href='?module=$module&id_module=$id&act=save&ID=$ID' title='Update'><span class='icon'><i class='fa fa-pencil'></i></span></a>"; |
|
416 | 416 | |
417 | - } |
|
417 | + } |
|
418 | 418 | |
419 | 419 | |
420 | 420 | |
421 | 421 | |
422 | 422 | if($r_delete == 'Y' and $r['status'] == '0') { |
423 | 423 | |
424 | - echo"<a href='modul/mod_$module/aksi_$module.php?module=$module&act=hapus&id=$ID&id_module=$id&id_module=$id' onClick=\"return confirm('Hapus Data ?')\" title='Hapus $nmmodule'><span class='icon'><i class='fa fa-trash'></i></span></a>"; |
|
424 | + echo"<a href='modul/mod_$module/aksi_$module.php?module=$module&act=hapus&id=$ID&id_module=$id&id_module=$id' onClick=\"return confirm('Hapus Data ?')\" title='Hapus $nmmodule'><span class='icon'><i class='fa fa-trash'></i></span></a>"; |
|
425 | 425 | |
426 | - } else { |
|
427 | - echo"<i class='fa fa-trash'></i></span>"; |
|
428 | - } |
|
426 | + } else { |
|
427 | + echo"<i class='fa fa-trash'></i></span>"; |
|
428 | + } |
|
429 | 429 | |
430 | 430 | |
431 | 431 | |
432 | 432 | |
433 | 433 | |
434 | 434 | |
435 | - echo"</td>"; |
|
435 | + echo"</td>"; |
|
436 | 436 | |
437 | - echo"</tr>"; |
|
437 | + echo"</tr>"; |
|
438 | 438 | |
439 | - $no++; |
|
439 | + $no++; |
|
440 | 440 | |
441 | 441 | |
442 | 442 | |
443 | - } |
|
443 | + } |
|
444 | 444 | |
445 | - ?> |
|
445 | + ?> |
|
446 | 446 | |
447 | 447 | </tbody> |
448 | 448 | |
@@ -589,9 +589,9 @@ discard block |
||
589 | 589 | |
590 | 590 | <? |
591 | 591 | |
592 | - echo"<a href='modul/mod_$module/aksi_$module.php?module=$module&act=batal&id=$ID&id_module=$id¬rans=$notrans&prd=$prd&kode=$kodee&outlet=$outlet' onClick=\"return confirm('Hapus transaksi ?')\" title='Hapus $nmmodule'><span class='btn btn-danger'><span style='color:white;'>Hapus</span></a>"; |
|
592 | + echo"<a href='modul/mod_$module/aksi_$module.php?module=$module&act=batal&id=$ID&id_module=$id¬rans=$notrans&prd=$prd&kode=$kodee&outlet=$outlet' onClick=\"return confirm('Hapus transaksi ?')\" title='Hapus $nmmodule'><span class='btn btn-danger'><span style='color:white;'>Hapus</span></a>"; |
|
593 | 593 | |
594 | - ?> |
|
594 | + ?> |
|
595 | 595 | |
596 | 596 | <?php } else { ?> |
597 | 597 | |
@@ -663,23 +663,23 @@ discard block |
||
663 | 663 | |
664 | 664 | <? |
665 | 665 | |
666 | - $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY id_shift'); |
|
666 | + $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY id_shift'); |
|
667 | 667 | |
668 | 668 | if($query && mysql_num_rows($query) > 0){ |
669 | 669 | |
670 | - while($row = mysql_fetch_object($query)){ |
|
670 | + while($row = mysql_fetch_object($query)){ |
|
671 | 671 | |
672 | - echo '<option value="'.$row->id_shift.'"'; |
|
672 | + echo '<option value="'.$row->id_shift.'"'; |
|
673 | 673 | |
674 | - if($row->id_shift == $shift) echo ' selected'; |
|
674 | + if($row->id_shift == $shift) echo ' selected'; |
|
675 | 675 | |
676 | - echo '>'.$row->shift.'</option>'; |
|
676 | + echo '>'.$row->shift.'</option>'; |
|
677 | 677 | |
678 | - } |
|
678 | + } |
|
679 | 679 | |
680 | 680 | } |
681 | 681 | |
682 | - ?> |
|
682 | + ?> |
|
683 | 683 | |
684 | 684 | </select> |
685 | 685 | |
@@ -898,24 +898,24 @@ discard block |
||
898 | 898 | |
899 | 899 | <? |
900 | 900 | |
901 | - $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY shift'); |
|
901 | + $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY shift'); |
|
902 | 902 | |
903 | 903 | if($query && mysql_num_rows($query) > 0){ |
904 | 904 | |
905 | 905 | |
906 | - while($row = mysql_fetch_object($query)){ |
|
906 | + while($row = mysql_fetch_object($query)){ |
|
907 | 907 | |
908 | - echo '<option value="'.$row->id_shift.'"'; |
|
908 | + echo '<option value="'.$row->id_shift.'"'; |
|
909 | 909 | |
910 | - if($row->id_shift == $shift) echo ' selected'; |
|
910 | + if($row->id_shift == $shift) echo ' selected'; |
|
911 | 911 | |
912 | - echo '>'.$row->shift.'</option>'; |
|
912 | + echo '>'.$row->shift.'</option>'; |
|
913 | 913 | |
914 | - } |
|
914 | + } |
|
915 | 915 | |
916 | 916 | } |
917 | 917 | |
918 | - ?> |
|
918 | + ?> |
|
919 | 919 | |
920 | 920 | </select> |
921 | 921 | |
@@ -1011,23 +1011,23 @@ discard block |
||
1011 | 1011 | |
1012 | 1012 | <? |
1013 | 1013 | |
1014 | - $query = mysql_query('SELECT * FROM jenis_transaksi WHERE aktif = "Y" ORDER BY id_jenis_transaksi'); |
|
1014 | + $query = mysql_query('SELECT * FROM jenis_transaksi WHERE aktif = "Y" ORDER BY id_jenis_transaksi'); |
|
1015 | 1015 | |
1016 | 1016 | if($query && mysql_num_rows($query) > 0){ |
1017 | 1017 | |
1018 | - while($row = mysql_fetch_object($query)){ |
|
1018 | + while($row = mysql_fetch_object($query)){ |
|
1019 | 1019 | |
1020 | - echo '<option value="'.$row->id_jenis_transaksi.'"'; |
|
1020 | + echo '<option value="'.$row->id_jenis_transaksi.'"'; |
|
1021 | 1021 | |
1022 | - if($row->id_jenis_transaksi == @$data->id_jenis_transaksi) echo ' selected'; |
|
1022 | + if($row->id_jenis_transaksi == @$data->id_jenis_transaksi) echo ' selected'; |
|
1023 | 1023 | |
1024 | - echo '>'.$row->jenis_transaksi.'</option>'; |
|
1024 | + echo '>'.$row->jenis_transaksi.'</option>'; |
|
1025 | 1025 | |
1026 | - } |
|
1026 | + } |
|
1027 | 1027 | |
1028 | 1028 | } |
1029 | 1029 | |
1030 | - ?> |
|
1030 | + ?> |
|
1031 | 1031 | |
1032 | 1032 | </select> |
1033 | 1033 | |
@@ -1058,23 +1058,23 @@ discard block |
||
1058 | 1058 | |
1059 | 1059 | <? |
1060 | 1060 | |
1061 | - $query = mysql_query('SELECT * FROM jenis_pembayaran WHERE aktif = "Y" ORDER BY id_jenis_pembayaran'); |
|
1061 | + $query = mysql_query('SELECT * FROM jenis_pembayaran WHERE aktif = "Y" ORDER BY id_jenis_pembayaran'); |
|
1062 | 1062 | |
1063 | 1063 | if($query && mysql_num_rows($query) > 0){ |
1064 | 1064 | |
1065 | - while($row = mysql_fetch_object($query)){ |
|
1065 | + while($row = mysql_fetch_object($query)){ |
|
1066 | 1066 | |
1067 | - echo '<option value="'.$row->id_jenis_pembayaran.'"'; |
|
1067 | + echo '<option value="'.$row->id_jenis_pembayaran.'"'; |
|
1068 | 1068 | |
1069 | - if($row->id_jenis_pembayaran == @$data->id_jenis_pembayaran) echo ' selected'; |
|
1069 | + if($row->id_jenis_pembayaran == @$data->id_jenis_pembayaran) echo ' selected'; |
|
1070 | 1070 | |
1071 | - echo '>'.$row->jenis_pembayaran.'</option>'; |
|
1071 | + echo '>'.$row->jenis_pembayaran.'</option>'; |
|
1072 | 1072 | |
1073 | - } |
|
1073 | + } |
|
1074 | 1074 | |
1075 | 1075 | } |
1076 | 1076 | |
1077 | - ?> |
|
1077 | + ?> |
|
1078 | 1078 | |
1079 | 1079 | </select> |
1080 | 1080 | |
@@ -1087,23 +1087,23 @@ discard block |
||
1087 | 1087 | |
1088 | 1088 | <? |
1089 | 1089 | |
1090 | - $query = mysql_query('SELECT * FROM penjamin WHERE aktif = "Y" ORDER BY id_penjamin'); |
|
1090 | + $query = mysql_query('SELECT * FROM penjamin WHERE aktif = "Y" ORDER BY id_penjamin'); |
|
1091 | 1091 | |
1092 | 1092 | if($query && mysql_num_rows($query) > 0){ |
1093 | 1093 | |
1094 | - while($row = mysql_fetch_object($query)){ |
|
1094 | + while($row = mysql_fetch_object($query)){ |
|
1095 | 1095 | |
1096 | - echo '<option value="'.$row->id_penjamin.'"'; |
|
1096 | + echo '<option value="'.$row->id_penjamin.'"'; |
|
1097 | 1097 | |
1098 | - if($row->id_penjamin == @$data->id_penjamin) echo ' selected'; |
|
1098 | + if($row->id_penjamin == @$data->id_penjamin) echo ' selected'; |
|
1099 | 1099 | |
1100 | - echo '>'.$row->penjamin.'</option>'; |
|
1100 | + echo '>'.$row->penjamin.'</option>'; |
|
1101 | 1101 | |
1102 | - } |
|
1102 | + } |
|
1103 | 1103 | |
1104 | 1104 | } |
1105 | 1105 | |
1106 | - ?> |
|
1106 | + ?> |
|
1107 | 1107 | |
1108 | 1108 | </select> |
1109 | 1109 | |
@@ -1179,77 +1179,77 @@ discard block |
||
1179 | 1179 | |
1180 | 1180 | |
1181 | 1181 | |
1182 | - $d_id = $d['id_kasir_detail']; |
|
1182 | + $d_id = $d['id_kasir_detail']; |
|
1183 | 1183 | |
1184 | 1184 | |
1185 | 1185 | |
1186 | 1186 | |
1187 | - $ijumlah = number_format($d['jumlah'], 0, ".", ","); |
|
1187 | + $ijumlah = number_format($d['jumlah'], 0, ".", ","); |
|
1188 | 1188 | |
1189 | - $jumlah = number_format($d['jumlah'], 0, ".", ""); |
|
1189 | + $jumlah = number_format($d['jumlah'], 0, ".", ""); |
|
1190 | 1190 | |
1191 | - $total = $total+$d['jumlah']; |
|
1191 | + $total = $total+$d['jumlah']; |
|
1192 | 1192 | |
1193 | - $itotal = number_format($total, 0, ".", ","); |
|
1193 | + $itotal = number_format($total, 0, ".", ","); |
|
1194 | 1194 | |
1195 | 1195 | |
1196 | - echo"<tr>"; |
|
1196 | + echo"<tr>"; |
|
1197 | 1197 | |
1198 | 1198 | |
1199 | 1199 | |
1200 | 1200 | |
1201 | 1201 | |
1202 | - echo" <td>"; |
|
1202 | + echo" <td>"; |
|
1203 | 1203 | |
1204 | - echo $d['notrans'] ; |
|
1204 | + echo $d['notrans'] ; |
|
1205 | 1205 | |
1206 | - echo"</td>"; |
|
1206 | + echo"</td>"; |
|
1207 | 1207 | |
1208 | - echo" <td>"; |
|
1208 | + echo" <td>"; |
|
1209 | 1209 | |
1210 | - echo $d['pasien'] ; |
|
1210 | + echo $d['pasien'] ; |
|
1211 | 1211 | |
1212 | - echo"</td>"; |
|
1212 | + echo"</td>"; |
|
1213 | 1213 | |
1214 | 1214 | |
1215 | - echo" <td>"; |
|
1215 | + echo" <td>"; |
|
1216 | 1216 | |
1217 | - echo $d['jenis_transaksi'] ; |
|
1217 | + echo $d['jenis_transaksi'] ; |
|
1218 | 1218 | |
1219 | - echo"</td>"; |
|
1219 | + echo"</td>"; |
|
1220 | 1220 | |
1221 | - echo" <td style='text-align:right;'>"; |
|
1221 | + echo" <td style='text-align:right;'>"; |
|
1222 | 1222 | |
1223 | - echo $ijumlah; |
|
1223 | + echo $ijumlah; |
|
1224 | 1224 | |
1225 | - echo"</td>"; |
|
1225 | + echo"</td>"; |
|
1226 | 1226 | |
1227 | 1227 | |
1228 | 1228 | |
1229 | - echo" <td>"; |
|
1229 | + echo" <td>"; |
|
1230 | 1230 | |
1231 | - echo $d['jenis_pembayaran']; |
|
1231 | + echo $d['jenis_pembayaran']; |
|
1232 | 1232 | |
1233 | - echo"</td>"; |
|
1233 | + echo"</td>"; |
|
1234 | 1234 | |
1235 | 1235 | |
1236 | - echo" <td>"; |
|
1236 | + echo" <td>"; |
|
1237 | 1237 | |
1238 | - echo $d['penjamin']; |
|
1238 | + echo $d['penjamin']; |
|
1239 | 1239 | |
1240 | - echo"</td>"; |
|
1240 | + echo"</td>"; |
|
1241 | 1241 | |
1242 | - echo" <td>"; |
|
1242 | + echo" <td>"; |
|
1243 | 1243 | |
1244 | - echo $d['ket']; |
|
1244 | + echo $d['ket']; |
|
1245 | 1245 | |
1246 | - echo"</td>"; |
|
1246 | + echo"</td>"; |
|
1247 | 1247 | |
1248 | 1248 | |
1249 | 1249 | |
1250 | 1250 | |
1251 | 1251 | |
1252 | - echo" <td style='text-align:center;'>"; |
|
1252 | + echo" <td style='text-align:center;'>"; |
|
1253 | 1253 | |
1254 | 1254 | |
1255 | 1255 | |
@@ -1266,16 +1266,16 @@ discard block |
||
1266 | 1266 | |
1267 | 1267 | |
1268 | 1268 | |
1269 | - if($r_delete == 'Y') { |
|
1269 | + if($r_delete == 'Y') { |
|
1270 | 1270 | |
1271 | 1271 | echo"<a href='modul/mod_$module/aksi_$module.php?module=$module&id_module=$_GET[id_module]&act=dhapus&id=$d_id&k_ID=$k_ID' onClick=\"return confirm('Hapus Data ?')\" title='Hapus $nmmodule'><span class='btn btn-danger btn-xs'><i class='fa fa-trash'></i></span></a>"; |
1272 | 1272 | |
1273 | 1273 | } |
1274 | 1274 | |
1275 | 1275 | |
1276 | - echo"</td>"; |
|
1276 | + echo"</td>"; |
|
1277 | 1277 | |
1278 | - echo"</tr>"; |
|
1278 | + echo"</tr>"; |
|
1279 | 1279 | |
1280 | 1280 | } |
1281 | 1281 | |
@@ -1365,19 +1365,19 @@ discard block |
||
1365 | 1365 | |
1366 | 1366 | if ($jml > 0 ) { |
1367 | 1367 | |
1368 | - // $readonly = 'readonly'; |
|
1368 | + // $readonly = 'readonly'; |
|
1369 | 1369 | |
1370 | - // $disabled = 'disabled'; |
|
1370 | + // $disabled = 'disabled'; |
|
1371 | 1371 | |
1372 | - $readonly = ''; |
|
1372 | + $readonly = ''; |
|
1373 | 1373 | |
1374 | - $disabled = ''; |
|
1374 | + $disabled = ''; |
|
1375 | 1375 | |
1376 | 1376 | } else { |
1377 | 1377 | |
1378 | - $readonly = ''; |
|
1378 | + $readonly = ''; |
|
1379 | 1379 | |
1380 | - $disabled = ''; |
|
1380 | + $disabled = ''; |
|
1381 | 1381 | |
1382 | 1382 | } |
1383 | 1383 | |
@@ -1491,23 +1491,23 @@ discard block |
||
1491 | 1491 | |
1492 | 1492 | <? |
1493 | 1493 | |
1494 | - $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY shift'); |
|
1494 | + $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY shift'); |
|
1495 | 1495 | |
1496 | 1496 | if($query && mysql_num_rows($query) > 0){ |
1497 | 1497 | |
1498 | - while($row = mysql_fetch_object($query)){ |
|
1498 | + while($row = mysql_fetch_object($query)){ |
|
1499 | 1499 | |
1500 | - echo '<option value="'.$row->id_shift.'"'; |
|
1500 | + echo '<option value="'.$row->id_shift.'"'; |
|
1501 | 1501 | |
1502 | - if($row->id_shift == $shift) echo ' selected'; |
|
1502 | + if($row->id_shift == $shift) echo ' selected'; |
|
1503 | 1503 | |
1504 | - echo '>'.$row->shift.'</option>'; |
|
1504 | + echo '>'.$row->shift.'</option>'; |
|
1505 | 1505 | |
1506 | - } |
|
1506 | + } |
|
1507 | 1507 | |
1508 | 1508 | } |
1509 | 1509 | |
1510 | - ?> |
|
1510 | + ?> |
|
1511 | 1511 | |
1512 | 1512 | </select> |
1513 | 1513 | |
@@ -1600,75 +1600,75 @@ discard block |
||
1600 | 1600 | |
1601 | 1601 | |
1602 | 1602 | |
1603 | - $d_id = $d['id_kasir_detail']; |
|
1603 | + $d_id = $d['id_kasir_detail']; |
|
1604 | 1604 | |
1605 | 1605 | |
1606 | 1606 | |
1607 | 1607 | |
1608 | - $ijumlah = number_format($d['jumlah'], 0, ".", ","); |
|
1608 | + $ijumlah = number_format($d['jumlah'], 0, ".", ","); |
|
1609 | 1609 | |
1610 | - $jumlah = number_format($d['jumlah'], 0, ".", ""); |
|
1610 | + $jumlah = number_format($d['jumlah'], 0, ".", ""); |
|
1611 | 1611 | |
1612 | - $total = $total+$d['jumlah']; |
|
1612 | + $total = $total+$d['jumlah']; |
|
1613 | 1613 | |
1614 | - $itotal = number_format($total, 0, ".", ","); |
|
1614 | + $itotal = number_format($total, 0, ".", ","); |
|
1615 | 1615 | |
1616 | 1616 | |
1617 | - echo"<tr>"; |
|
1617 | + echo"<tr>"; |
|
1618 | 1618 | |
1619 | 1619 | |
1620 | 1620 | |
1621 | 1621 | |
1622 | 1622 | |
1623 | - echo" <td>"; |
|
1623 | + echo" <td>"; |
|
1624 | 1624 | |
1625 | - echo $d['notrans'] ; |
|
1625 | + echo $d['notrans'] ; |
|
1626 | 1626 | |
1627 | - echo"</td>"; |
|
1627 | + echo"</td>"; |
|
1628 | 1628 | |
1629 | - echo" <td>"; |
|
1629 | + echo" <td>"; |
|
1630 | 1630 | |
1631 | - echo $d['pasien'] ; |
|
1631 | + echo $d['pasien'] ; |
|
1632 | 1632 | |
1633 | - echo"</td>"; |
|
1633 | + echo"</td>"; |
|
1634 | 1634 | |
1635 | 1635 | |
1636 | - echo" <td>"; |
|
1636 | + echo" <td>"; |
|
1637 | 1637 | |
1638 | - echo $d['jenis_transaksi'] ; |
|
1638 | + echo $d['jenis_transaksi'] ; |
|
1639 | 1639 | |
1640 | - echo"</td>"; |
|
1640 | + echo"</td>"; |
|
1641 | 1641 | |
1642 | - echo" <td style='text-align:right;'>"; |
|
1642 | + echo" <td style='text-align:right;'>"; |
|
1643 | 1643 | |
1644 | - echo $ijumlah; |
|
1644 | + echo $ijumlah; |
|
1645 | 1645 | |
1646 | - echo"</td>"; |
|
1646 | + echo"</td>"; |
|
1647 | 1647 | |
1648 | 1648 | |
1649 | 1649 | |
1650 | - echo" <td>"; |
|
1650 | + echo" <td>"; |
|
1651 | 1651 | |
1652 | - echo $d['jenis_pembayaran']; |
|
1652 | + echo $d['jenis_pembayaran']; |
|
1653 | 1653 | |
1654 | - echo"</td>"; |
|
1654 | + echo"</td>"; |
|
1655 | 1655 | |
1656 | 1656 | |
1657 | - echo" <td>"; |
|
1657 | + echo" <td>"; |
|
1658 | 1658 | |
1659 | - echo $d['penjamin']; |
|
1659 | + echo $d['penjamin']; |
|
1660 | 1660 | |
1661 | - echo"</td>"; |
|
1661 | + echo"</td>"; |
|
1662 | 1662 | |
1663 | - echo" <td>"; |
|
1663 | + echo" <td>"; |
|
1664 | 1664 | |
1665 | - echo $d['ket']; |
|
1665 | + echo $d['ket']; |
|
1666 | 1666 | |
1667 | - echo"</td>"; |
|
1667 | + echo"</td>"; |
|
1668 | 1668 | |
1669 | 1669 | |
1670 | 1670 | |
1671 | - echo"</tr>"; |
|
1671 | + echo"</tr>"; |
|
1672 | 1672 | |
1673 | 1673 | } |
1674 | 1674 | |
@@ -1820,24 +1820,24 @@ discard block |
||
1820 | 1820 | |
1821 | 1821 | <? |
1822 | 1822 | |
1823 | - $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY shift'); |
|
1823 | + $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY shift'); |
|
1824 | 1824 | |
1825 | 1825 | if($query && mysql_num_rows($query) > 0){ |
1826 | 1826 | |
1827 | 1827 | |
1828 | - while($row = mysql_fetch_object($query)){ |
|
1828 | + while($row = mysql_fetch_object($query)){ |
|
1829 | 1829 | |
1830 | - echo '<option value="'.$row->id_shift.'"'; |
|
1830 | + echo '<option value="'.$row->id_shift.'"'; |
|
1831 | 1831 | |
1832 | - if($row->id_shift == $shift) echo ' selected'; |
|
1832 | + if($row->id_shift == $shift) echo ' selected'; |
|
1833 | 1833 | |
1834 | - echo '>'.$row->shift.'</option>'; |
|
1834 | + echo '>'.$row->shift.'</option>'; |
|
1835 | 1835 | |
1836 | - } |
|
1836 | + } |
|
1837 | 1837 | |
1838 | 1838 | } |
1839 | 1839 | |
1840 | - ?> |
|
1840 | + ?> |
|
1841 | 1841 | |
1842 | 1842 | </select> |
1843 | 1843 | |
@@ -1902,7 +1902,7 @@ discard block |
||
1902 | 1902 | |
1903 | 1903 | <? |
1904 | 1904 | |
1905 | - $d_id = $_GET['d_id']; |
|
1905 | + $d_id = $_GET['d_id']; |
|
1906 | 1906 | |
1907 | 1907 | |
1908 | 1908 | $dSQL = "SELECT a.*,b.jenis_transaksi,c.penjamin,d.jenis_pembayaran |
@@ -1940,19 +1940,19 @@ discard block |
||
1940 | 1940 | |
1941 | 1941 | while ($d=mysql_fetch_array($dtampil)){ |
1942 | 1942 | |
1943 | - $jid = $d['id_kasir_detail']; |
|
1943 | + $jid = $d['id_kasir_detail']; |
|
1944 | 1944 | |
1945 | 1945 | |
1946 | - $ijumlah = number_format($d['jumlah'], 0, ".", ","); |
|
1946 | + $ijumlah = number_format($d['jumlah'], 0, ".", ","); |
|
1947 | 1947 | |
1948 | - $jumlah = number_format($d['jumlah'], 0, ".", ""); |
|
1948 | + $jumlah = number_format($d['jumlah'], 0, ".", ""); |
|
1949 | 1949 | |
1950 | 1950 | |
1951 | 1951 | |
1952 | 1952 | |
1953 | - if ($jid == $d_id) { |
|
1953 | + if ($jid == $d_id) { |
|
1954 | 1954 | |
1955 | - ?> |
|
1955 | + ?> |
|
1956 | 1956 | |
1957 | 1957 | |
1958 | 1958 | |
@@ -1993,23 +1993,23 @@ discard block |
||
1993 | 1993 | |
1994 | 1994 | <? |
1995 | 1995 | |
1996 | - $query = mysql_query('SELECT * FROM jenis_transaksi WHERE aktif = "Y" ORDER BY id_jenis_transaksi'); |
|
1996 | + $query = mysql_query('SELECT * FROM jenis_transaksi WHERE aktif = "Y" ORDER BY id_jenis_transaksi'); |
|
1997 | 1997 | |
1998 | 1998 | if($query && mysql_num_rows($query) > 0){ |
1999 | 1999 | |
2000 | - while($row = mysql_fetch_object($query)){ |
|
2000 | + while($row = mysql_fetch_object($query)){ |
|
2001 | 2001 | |
2002 | - echo '<option value="'.$row->id_jenis_transaksi.'"'; |
|
2002 | + echo '<option value="'.$row->id_jenis_transaksi.'"'; |
|
2003 | 2003 | |
2004 | - if($row->id_jenis_transaksi == @$d['id_jenis_transaksi']) echo ' selected'; |
|
2004 | + if($row->id_jenis_transaksi == @$d['id_jenis_transaksi']) echo ' selected'; |
|
2005 | 2005 | |
2006 | - echo '>'.$row->jenis_transaksi.'</option>'; |
|
2006 | + echo '>'.$row->jenis_transaksi.'</option>'; |
|
2007 | 2007 | |
2008 | - } |
|
2008 | + } |
|
2009 | 2009 | |
2010 | 2010 | } |
2011 | 2011 | |
2012 | - ?> |
|
2012 | + ?> |
|
2013 | 2013 | |
2014 | 2014 | </select> |
2015 | 2015 | |
@@ -2040,23 +2040,23 @@ discard block |
||
2040 | 2040 | |
2041 | 2041 | <? |
2042 | 2042 | |
2043 | - $query = mysql_query('SELECT * FROM jenis_pembayaran WHERE aktif = "Y" ORDER BY id_jenis_pembayaran'); |
|
2043 | + $query = mysql_query('SELECT * FROM jenis_pembayaran WHERE aktif = "Y" ORDER BY id_jenis_pembayaran'); |
|
2044 | 2044 | |
2045 | 2045 | if($query && mysql_num_rows($query) > 0){ |
2046 | 2046 | |
2047 | - while($row = mysql_fetch_object($query)){ |
|
2047 | + while($row = mysql_fetch_object($query)){ |
|
2048 | 2048 | |
2049 | - echo '<option value="'.$row->id_jenis_pembayaran.'"'; |
|
2049 | + echo '<option value="'.$row->id_jenis_pembayaran.'"'; |
|
2050 | 2050 | |
2051 | - if($row->id_jenis_pembayaran == @$d['id_jenis_pembayaran']) echo ' selected'; |
|
2051 | + if($row->id_jenis_pembayaran == @$d['id_jenis_pembayaran']) echo ' selected'; |
|
2052 | 2052 | |
2053 | - echo '>'.$row->jenis_pembayaran.'</option>'; |
|
2053 | + echo '>'.$row->jenis_pembayaran.'</option>'; |
|
2054 | 2054 | |
2055 | - } |
|
2055 | + } |
|
2056 | 2056 | |
2057 | 2057 | } |
2058 | 2058 | |
2059 | - ?> |
|
2059 | + ?> |
|
2060 | 2060 | |
2061 | 2061 | </select> |
2062 | 2062 | |
@@ -2069,23 +2069,23 @@ discard block |
||
2069 | 2069 | |
2070 | 2070 | <? |
2071 | 2071 | |
2072 | - $query = mysql_query('SELECT * FROM penjamin WHERE aktif = "Y" ORDER BY id_penjamin'); |
|
2072 | + $query = mysql_query('SELECT * FROM penjamin WHERE aktif = "Y" ORDER BY id_penjamin'); |
|
2073 | 2073 | |
2074 | 2074 | if($query && mysql_num_rows($query) > 0){ |
2075 | 2075 | |
2076 | - while($row = mysql_fetch_object($query)){ |
|
2076 | + while($row = mysql_fetch_object($query)){ |
|
2077 | 2077 | |
2078 | - echo '<option value="'.$row->id_penjamin.'"'; |
|
2078 | + echo '<option value="'.$row->id_penjamin.'"'; |
|
2079 | 2079 | |
2080 | - if($row->id_penjamin == @$d['id_penjamin']) echo ' selected'; |
|
2080 | + if($row->id_penjamin == @$d['id_penjamin']) echo ' selected'; |
|
2081 | 2081 | |
2082 | - echo '>'.$row->penjamin.'</option>'; |
|
2082 | + echo '>'.$row->penjamin.'</option>'; |
|
2083 | 2083 | |
2084 | - } |
|
2084 | + } |
|
2085 | 2085 | |
2086 | 2086 | } |
2087 | 2087 | |
2088 | - ?> |
|
2088 | + ?> |
|
2089 | 2089 | |
2090 | 2090 | </select> |
2091 | 2091 | |
@@ -2127,68 +2127,68 @@ discard block |
||
2127 | 2127 | |
2128 | 2128 | |
2129 | 2129 | |
2130 | - echo"<tr>"; |
|
2130 | + echo"<tr>"; |
|
2131 | 2131 | |
2132 | 2132 | |
2133 | 2133 | |
2134 | 2134 | |
2135 | 2135 | |
2136 | - echo" <td>"; |
|
2136 | + echo" <td>"; |
|
2137 | 2137 | |
2138 | - echo $d['notrans'] ; |
|
2138 | + echo $d['notrans'] ; |
|
2139 | 2139 | |
2140 | - echo"</td>"; |
|
2140 | + echo"</td>"; |
|
2141 | 2141 | |
2142 | 2142 | |
2143 | 2143 | |
2144 | - echo" <td>"; |
|
2144 | + echo" <td>"; |
|
2145 | 2145 | |
2146 | - echo $d['pasien'] ; |
|
2146 | + echo $d['pasien'] ; |
|
2147 | 2147 | |
2148 | - echo"</td>"; |
|
2148 | + echo"</td>"; |
|
2149 | 2149 | |
2150 | 2150 | |
2151 | 2151 | |
2152 | 2152 | |
2153 | - echo" <td>"; |
|
2153 | + echo" <td>"; |
|
2154 | 2154 | |
2155 | - echo $d['jenis_transaksi']; |
|
2155 | + echo $d['jenis_transaksi']; |
|
2156 | 2156 | |
2157 | - echo"</td>"; |
|
2157 | + echo"</td>"; |
|
2158 | 2158 | |
2159 | 2159 | |
2160 | 2160 | |
2161 | - echo" <td style='text-align:right;'>"; |
|
2161 | + echo" <td style='text-align:right;'>"; |
|
2162 | 2162 | |
2163 | - echo $ijumlah; |
|
2163 | + echo $ijumlah; |
|
2164 | 2164 | |
2165 | - echo"</td>"; |
|
2165 | + echo"</td>"; |
|
2166 | 2166 | |
2167 | 2167 | |
2168 | 2168 | |
2169 | - echo" <td>"; |
|
2169 | + echo" <td>"; |
|
2170 | 2170 | |
2171 | - echo $d['jenis_pembayaran']; |
|
2171 | + echo $d['jenis_pembayaran']; |
|
2172 | 2172 | |
2173 | - echo"</td>"; |
|
2173 | + echo"</td>"; |
|
2174 | 2174 | |
2175 | 2175 | |
2176 | 2176 | echo" <td>"; |
2177 | 2177 | |
2178 | - echo $d['penjamin']; |
|
2178 | + echo $d['penjamin']; |
|
2179 | 2179 | |
2180 | - echo"</td>"; |
|
2180 | + echo"</td>"; |
|
2181 | 2181 | |
2182 | 2182 | echo" <td>"; |
2183 | 2183 | |
2184 | - echo $d['ket']; |
|
2184 | + echo $d['ket']; |
|
2185 | 2185 | |
2186 | - echo"</td>"; |
|
2186 | + echo"</td>"; |
|
2187 | 2187 | |
2188 | 2188 | |
2189 | 2189 | |
2190 | 2190 | |
2191 | - echo" <td style='text-align:center;'>"; |
|
2191 | + echo" <td style='text-align:center;'>"; |
|
2192 | 2192 | |
2193 | 2193 | |
2194 | 2194 | |
@@ -2200,19 +2200,19 @@ discard block |
||
2200 | 2200 | |
2201 | 2201 | |
2202 | 2202 | |
2203 | - if($r_delete == 'Y') { |
|
2203 | + if($r_delete == 'Y') { |
|
2204 | 2204 | |
2205 | 2205 | echo"<span class='btn btn-danger btn-sm' disabled><i class='fa fa-trash'></i></span>"; |
2206 | 2206 | |
2207 | - } |
|
2207 | + } |
|
2208 | 2208 | |
2209 | 2209 | |
2210 | 2210 | |
2211 | 2211 | |
2212 | 2212 | |
2213 | - echo"</td>"; |
|
2213 | + echo"</td>"; |
|
2214 | 2214 | |
2215 | - echo"</tr>"; |
|
2215 | + echo"</tr>"; |
|
2216 | 2216 | |
2217 | 2217 | } |
2218 | 2218 |
@@ -313,37 +313,37 @@ discard block |
||
313 | 313 | |
314 | 314 | { |
315 | 315 | |
316 | - $abil = array("", "satu", "dua", "tiga", "empat", "lima", "enam", "tujuh", "delapan", "sembilan", "sepuluh", "sebelas"); |
|
316 | + $abil = array("", "satu", "dua", "tiga", "empat", "lima", "enam", "tujuh", "delapan", "sembilan", "sepuluh", "sebelas"); |
|
317 | 317 | |
318 | - if ($x < 12) |
|
318 | + if ($x < 12) |
|
319 | 319 | |
320 | 320 | return " " . $abil[$x]; |
321 | 321 | |
322 | - elseif ($x < 20) |
|
322 | + elseif ($x < 20) |
|
323 | 323 | |
324 | 324 | return Terbilang($x - 10) . "belas"; |
325 | 325 | |
326 | - elseif ($x < 100) |
|
326 | + elseif ($x < 100) |
|
327 | 327 | |
328 | 328 | return Terbilang($x / 10) . " puluh" . Terbilang($x % 10); |
329 | 329 | |
330 | - elseif ($x < 200) |
|
330 | + elseif ($x < 200) |
|
331 | 331 | |
332 | 332 | return " seratus" . Terbilang($x - 100); |
333 | 333 | |
334 | - elseif ($x < 1000) |
|
334 | + elseif ($x < 1000) |
|
335 | 335 | |
336 | 336 | return Terbilang($x / 100) . " ratus" . Terbilang($x % 100); |
337 | 337 | |
338 | - elseif ($x < 2000) |
|
338 | + elseif ($x < 2000) |
|
339 | 339 | |
340 | 340 | return " seribu" . Terbilang($x - 1000); |
341 | 341 | |
342 | - elseif ($x < 1000000) |
|
342 | + elseif ($x < 1000000) |
|
343 | 343 | |
344 | 344 | return Terbilang($x / 1000) . " ribu" . Terbilang($x % 1000); |
345 | 345 | |
346 | - elseif ($x < 1000000000) |
|
346 | + elseif ($x < 1000000000) |
|
347 | 347 | |
348 | 348 | return Terbilang($x / 1000000) . " juta" . Terbilang($x % 1000000); |
349 | 349 | |
@@ -409,19 +409,19 @@ discard block |
||
409 | 409 | |
410 | 410 | |
411 | 411 | |
412 | - $gtampil=mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
412 | + $gtampil=mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
413 | 413 | |
414 | - $g=mysql_fetch_array($gtampil); |
|
414 | + $g=mysql_fetch_array($gtampil); |
|
415 | 415 | |
416 | 416 | |
417 | 417 | |
418 | 418 | if ($g['pict']) { |
419 | 419 | |
420 | - $pict = $g['pict']; |
|
420 | + $pict = $g['pict']; |
|
421 | 421 | |
422 | 422 | } else { |
423 | 423 | |
424 | - $pict = ''; |
|
424 | + $pict = ''; |
|
425 | 425 | |
426 | 426 | } |
427 | 427 | |
@@ -433,13 +433,13 @@ discard block |
||
433 | 433 | |
434 | 434 | |
435 | 435 | |
436 | - $otampil=mysql_query("SELECT * FROM outlet where id_outlet = '$outlet'"); |
|
436 | + $otampil=mysql_query("SELECT * FROM outlet where id_outlet = '$outlet'"); |
|
437 | 437 | |
438 | - $o=mysql_fetch_array($otampil); |
|
438 | + $o=mysql_fetch_array($otampil); |
|
439 | 439 | |
440 | 440 | |
441 | 441 | |
442 | - ?> |
|
442 | + ?> |
|
443 | 443 | |
444 | 444 | |
445 | 445 | |
@@ -551,23 +551,23 @@ discard block |
||
551 | 551 | |
552 | 552 | if($r['status'] == '0'){ |
553 | 553 | |
554 | - $istatus = 'Baru'; |
|
554 | + $istatus = 'Baru'; |
|
555 | 555 | |
556 | 556 | } else if($r['status'] == '1'){ |
557 | 557 | |
558 | - $istatus = 'Disetujui'; |
|
558 | + $istatus = 'Disetujui'; |
|
559 | 559 | |
560 | 560 | } else if($r['status'] == '2'){ |
561 | 561 | |
562 | - $istatus = 'Ditolak'; |
|
562 | + $istatus = 'Ditolak'; |
|
563 | 563 | |
564 | - } else if($r['status'] == '9'){ |
|
564 | + } else if($r['status'] == '9'){ |
|
565 | 565 | |
566 | - $istatus = 'Posting'; |
|
566 | + $istatus = 'Posting'; |
|
567 | 567 | |
568 | - } else { |
|
568 | + } else { |
|
569 | 569 | |
570 | - $istatus = 'Dibatalkan'; |
|
570 | + $istatus = 'Dibatalkan'; |
|
571 | 571 | |
572 | 572 | } |
573 | 573 | |
@@ -597,19 +597,19 @@ discard block |
||
597 | 597 | |
598 | 598 | <? |
599 | 599 | |
600 | - echo"<table width='100%' border=0 cellpadding=0 cellspacing=0>"; |
|
600 | + echo"<table width='100%' border=0 cellpadding=0 cellspacing=0>"; |
|
601 | 601 | |
602 | - echo"<tr>"; |
|
602 | + echo"<tr>"; |
|
603 | 603 | |
604 | - echo"<td width='72%' style='text-align:right;'>No. Pemesanan</td>"; |
|
604 | + echo"<td width='72%' style='text-align:right;'>No. Pemesanan</td>"; |
|
605 | 605 | |
606 | - echo"<td width='1%'>:</td>"; |
|
606 | + echo"<td width='1%'>:</td>"; |
|
607 | 607 | |
608 | - echo"<td width='27%' style='text-align:left;'>".$r['kode']."".$r['notrans']."</td>"; |
|
608 | + echo"<td width='27%' style='text-align:left;'>".$r['kode']."".$r['notrans']."</td>"; |
|
609 | 609 | |
610 | - echo"</tr>"; |
|
610 | + echo"</tr>"; |
|
611 | 611 | |
612 | - echo"</table>"; |
|
612 | + echo"</table>"; |
|
613 | 613 | |
614 | 614 | ?> |
615 | 615 | |
@@ -621,19 +621,19 @@ discard block |
||
621 | 621 | |
622 | 622 | <? |
623 | 623 | |
624 | - echo"<table width='100%' border=0 cellpadding=0 cellspacing=0>"; |
|
624 | + echo"<table width='100%' border=0 cellpadding=0 cellspacing=0>"; |
|
625 | 625 | |
626 | - echo"<tr>"; |
|
626 | + echo"<tr>"; |
|
627 | 627 | |
628 | - echo"<td width='72%' style='text-align:right;'>Tanggal</td>"; |
|
628 | + echo"<td width='72%' style='text-align:right;'>Tanggal</td>"; |
|
629 | 629 | |
630 | - echo"<td width='1%'>:</td>"; |
|
630 | + echo"<td width='1%'>:</td>"; |
|
631 | 631 | |
632 | - echo"<td width='27%' style='text-align:left;'>".$tgl."</td>"; |
|
632 | + echo"<td width='27%' style='text-align:left;'>".$tgl."</td>"; |
|
633 | 633 | |
634 | - echo"</tr>"; |
|
634 | + echo"</tr>"; |
|
635 | 635 | |
636 | - echo"</table>"; |
|
636 | + echo"</table>"; |
|
637 | 637 | |
638 | 638 | ?> |
639 | 639 | |
@@ -649,19 +649,19 @@ discard block |
||
649 | 649 | |
650 | 650 | <? |
651 | 651 | |
652 | - echo"<table width='100%' border=0 cellpadding=0 cellspacing=0>"; |
|
652 | + echo"<table width='100%' border=0 cellpadding=0 cellspacing=0>"; |
|
653 | 653 | |
654 | - echo"<tr>"; |
|
654 | + echo"<tr>"; |
|
655 | 655 | |
656 | - echo"<td width='72%' style='text-align:right;'>Term</td>"; |
|
656 | + echo"<td width='72%' style='text-align:right;'>Term</td>"; |
|
657 | 657 | |
658 | - echo"<td width='1%'>:</td>"; |
|
658 | + echo"<td width='1%'>:</td>"; |
|
659 | 659 | |
660 | - echo"<td width='27%' style='text-align:left;'>".$r['term']." Hari</td>"; |
|
660 | + echo"<td width='27%' style='text-align:left;'>".$r['term']." Hari</td>"; |
|
661 | 661 | |
662 | - echo"</tr>"; |
|
662 | + echo"</tr>"; |
|
663 | 663 | |
664 | - echo"</table>"; |
|
664 | + echo"</table>"; |
|
665 | 665 | |
666 | 666 | ?> |
667 | 667 | |
@@ -897,95 +897,95 @@ discard block |
||
897 | 897 | |
898 | 898 | |
899 | 899 | |
900 | - $d_id = $d['id_pemesanan_barang_detail']; |
|
900 | + $d_id = $d['id_pemesanan_barang_detail']; |
|
901 | 901 | |
902 | - $ibarang = $d['kode_bar'].'    '.$d['barang']; |
|
902 | + $ibarang = $d['kode_bar'].'    '.$d['barang']; |
|
903 | 903 | |
904 | - $iqty = number_format($d['qty'], 2, ".", ","); |
|
904 | + $iqty = number_format($d['qty'], 2, ".", ","); |
|
905 | 905 | |
906 | - $qty = number_format($d['qty'], 2, ".", ""); |
|
906 | + $qty = number_format($d['qty'], 2, ".", ""); |
|
907 | 907 | |
908 | 908 | |
909 | 909 | |
910 | - $harga = number_format($d['harga'], 0, ".", ","); |
|
910 | + $harga = number_format($d['harga'], 0, ".", ","); |
|
911 | 911 | |
912 | 912 | |
913 | 913 | |
914 | - $total = number_format($d['total'], 0, ".", ","); |
|
914 | + $total = number_format($d['total'], 0, ".", ","); |
|
915 | 915 | |
916 | - $ctotal = number_format($d['ctotal'], 2, ".", ","); |
|
916 | + $ctotal = number_format($d['ctotal'], 2, ".", ","); |
|
917 | 917 | |
918 | 918 | |
919 | 919 | |
920 | - echo"<tr>"; |
|
920 | + echo"<tr>"; |
|
921 | 921 | |
922 | 922 | |
923 | 923 | |
924 | 924 | echo" <td class='border' style='text-align: center;'>"; |
925 | 925 | |
926 | - echo $no.'.' ; |
|
926 | + echo $no.'.' ; |
|
927 | 927 | |
928 | - echo"</td>"; |
|
928 | + echo"</td>"; |
|
929 | 929 | |
930 | 930 | |
931 | 931 | |
932 | - echo" <td class='border'>"; |
|
932 | + echo" <td class='border'>"; |
|
933 | 933 | |
934 | - echo $ibarang ; |
|
934 | + echo $ibarang ; |
|
935 | 935 | |
936 | - echo"</td>"; |
|
936 | + echo"</td>"; |
|
937 | 937 | |
938 | 938 | |
939 | 939 | |
940 | - echo" <td class='border' style='text-align:right;'>"; |
|
940 | + echo" <td class='border' style='text-align:right;'>"; |
|
941 | 941 | |
942 | - echo $iqty; |
|
942 | + echo $iqty; |
|
943 | 943 | |
944 | - echo"</td>"; |
|
944 | + echo"</td>"; |
|
945 | 945 | |
946 | 946 | |
947 | 947 | |
948 | - echo" <td class='border'>"; |
|
948 | + echo" <td class='border'>"; |
|
949 | 949 | |
950 | - echo $d['unit_barang']; |
|
950 | + echo $d['unit_barang']; |
|
951 | 951 | |
952 | - echo"</td>"; |
|
952 | + echo"</td>"; |
|
953 | 953 | |
954 | 954 | |
955 | 955 | |
956 | - echo" <td class='border' style='text-align:right;'>"; |
|
956 | + echo" <td class='border' style='text-align:right;'>"; |
|
957 | 957 | |
958 | - echo $harga; |
|
958 | + echo $harga; |
|
959 | 959 | |
960 | - echo"</td>"; |
|
960 | + echo"</td>"; |
|
961 | 961 | |
962 | 962 | |
963 | 963 | |
964 | - if ($mata_uang == '1') { |
|
964 | + if ($mata_uang == '1') { |
|
965 | 965 | |
966 | - echo" <td class='border' style='text-align:right;'>"; |
|
966 | + echo" <td class='border' style='text-align:right;'>"; |
|
967 | 967 | |
968 | - echo $total; |
|
968 | + echo $total; |
|
969 | 969 | |
970 | - echo"</td>"; |
|
970 | + echo"</td>"; |
|
971 | 971 | |
972 | - } else { |
|
972 | + } else { |
|
973 | 973 | |
974 | - echo" <td class='border' style='text-align:right;'>"; |
|
974 | + echo" <td class='border' style='text-align:right;'>"; |
|
975 | 975 | |
976 | - echo $ctotal; |
|
976 | + echo $ctotal; |
|
977 | 977 | |
978 | - echo"</td>"; |
|
978 | + echo"</td>"; |
|
979 | 979 | |
980 | - echo" <td class='border' style='text-align:right;'>"; |
|
980 | + echo" <td class='border' style='text-align:right;'>"; |
|
981 | 981 | |
982 | - echo $total; |
|
982 | + echo $total; |
|
983 | 983 | |
984 | - echo"</td>"; |
|
984 | + echo"</td>"; |
|
985 | 985 | |
986 | 986 | |
987 | 987 | |
988 | - } |
|
988 | + } |
|
989 | 989 | |
990 | 990 | |
991 | 991 | |
@@ -999,19 +999,19 @@ discard block |
||
999 | 999 | |
1000 | 1000 | if ($no < 10) { |
1001 | 1001 | |
1002 | - while ($no < 10) { |
|
1002 | + while ($no < 10) { |
|
1003 | 1003 | |
1004 | - echo "<tr>"; |
|
1004 | + echo "<tr>"; |
|
1005 | 1005 | |
1006 | - echo"<td colspan=4> </td>"; |
|
1006 | + echo"<td colspan=4> </td>"; |
|
1007 | 1007 | |
1008 | - echo"</tr>"; |
|
1008 | + echo"</tr>"; |
|
1009 | 1009 | |
1010 | - $no++; |
|
1010 | + $no++; |
|
1011 | 1011 | |
1012 | - }; |
|
1012 | + }; |
|
1013 | 1013 | |
1014 | - }; |
|
1014 | + }; |
|
1015 | 1015 | |
1016 | 1016 | |
1017 | 1017 | |
@@ -1029,37 +1029,37 @@ discard block |
||
1029 | 1029 | |
1030 | 1030 | |
1031 | 1031 | |
1032 | - $total = number_format($r['total'], 0, ".", ","); |
|
1032 | + $total = number_format($r['total'], 0, ".", ","); |
|
1033 | 1033 | |
1034 | - $ppn = number_format($r['totaltax'], 0, ".", ","); |
|
1034 | + $ppn = number_format($r['totaltax'], 0, ".", ","); |
|
1035 | 1035 | |
1036 | - $gtotal = number_format($r['gtotal'], 0, ".", ","); |
|
1036 | + $gtotal = number_format($r['gtotal'], 0, ".", ","); |
|
1037 | 1037 | |
1038 | 1038 | |
1039 | 1039 | |
1040 | - $igtotal = $r['gtotal']; |
|
1040 | + $igtotal = $r['gtotal']; |
|
1041 | 1041 | |
1042 | 1042 | |
1043 | 1043 | |
1044 | - $ctotal = number_format($r['ctotal'], 2, ".", ","); |
|
1044 | + $ctotal = number_format($r['ctotal'], 2, ".", ","); |
|
1045 | 1045 | |
1046 | - $cppn = number_format($r['ctotaltax'], 2, ".", ","); |
|
1046 | + $cppn = number_format($r['ctotaltax'], 2, ".", ","); |
|
1047 | 1047 | |
1048 | - $cgtotal = number_format($r['cgtotal'], 2, ".", ","); |
|
1048 | + $cgtotal = number_format($r['cgtotal'], 2, ".", ","); |
|
1049 | 1049 | |
1050 | 1050 | |
1051 | 1051 | |
1052 | - $icgtotal = $r['cgtotal']; |
|
1052 | + $icgtotal = $r['cgtotal']; |
|
1053 | 1053 | |
1054 | 1054 | |
1055 | 1055 | |
1056 | 1056 | if ($mata_uang == '1') { |
1057 | 1057 | |
1058 | - $rterbilang = ucwords(Terbilang($igtotal)).' Rupiah'; |
|
1058 | + $rterbilang = ucwords(Terbilang($igtotal)).' Rupiah'; |
|
1059 | 1059 | |
1060 | 1060 | } else { |
1061 | 1061 | |
1062 | - $rterbilang = ucwords(Terbilang($icgtotal)).' '.$cnote; |
|
1062 | + $rterbilang = ucwords(Terbilang($icgtotal)).' '.$cnote; |
|
1063 | 1063 | |
1064 | 1064 | } |
1065 | 1065 | |
@@ -1187,7 +1187,7 @@ discard block |
||
1187 | 1187 | |
1188 | 1188 | |
1189 | 1189 | |
1190 | - $tanda_tangan = mysql_query("SELECT a.judul,a.penanda_tangan FROM tanda_tangan a LEFT JOIN kode_transaksi b |
|
1190 | + $tanda_tangan = mysql_query("SELECT a.judul,a.penanda_tangan FROM tanda_tangan a LEFT JOIN kode_transaksi b |
|
1191 | 1191 | |
1192 | 1192 | ON a.id_kode_transaksi = b.id_kode_transaksi |
1193 | 1193 | |
@@ -1195,21 +1195,21 @@ discard block |
||
1195 | 1195 | |
1196 | 1196 | |
1197 | 1197 | |
1198 | - $jml = mysql_num_rows($tanda_tangan); |
|
1198 | + $jml = mysql_num_rows($tanda_tangan); |
|
1199 | 1199 | |
1200 | 1200 | |
1201 | 1201 | |
1202 | - $cp = $jml +1 ; |
|
1202 | + $cp = $jml +1 ; |
|
1203 | 1203 | |
1204 | 1204 | |
1205 | 1205 | |
1206 | - $ps = 100/$cp; |
|
1206 | + $ps = 100/$cp; |
|
1207 | 1207 | |
1208 | 1208 | $user = $_SESSION['userid']; |
1209 | 1209 | |
1210 | 1210 | |
1211 | 1211 | |
1212 | - ?> |
|
1212 | + ?> |
|
1213 | 1213 | |
1214 | 1214 | |
1215 | 1215 | |
@@ -1247,13 +1247,13 @@ discard block |
||
1247 | 1247 | |
1248 | 1248 | <? |
1249 | 1249 | |
1250 | - $tanda_tangan = mysql_query("SELECT a.judul,a.penanda_tangan FROM tanda_tangan a LEFT JOIN kode_transaksi b |
|
1250 | + $tanda_tangan = mysql_query("SELECT a.judul,a.penanda_tangan FROM tanda_tangan a LEFT JOIN kode_transaksi b |
|
1251 | 1251 | |
1252 | 1252 | ON a.id_kode_transaksi = b.id_kode_transaksi |
1253 | 1253 | |
1254 | 1254 | WHERE b.kode = '$kode' AND a.aktif = 'Y'"); |
1255 | 1255 | |
1256 | - ?> |
|
1256 | + ?> |
|
1257 | 1257 | |
1258 | 1258 | <?php while($s = mysql_fetch_array($tanda_tangan)) { ?> |
1259 | 1259 |
@@ -1,7 +1,7 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | session_start(); |
3 | 3 | if (empty($_SESSION['username']) AND empty($_SESSION['password'])){ |
4 | - echo "<script>window.alert('Please login first.'); window.location=('../../index.php.php')</script>"; |
|
4 | + echo "<script>window.alert('Please login first.'); window.location=('../../index.php.php')</script>"; |
|
5 | 5 | } else{ |
6 | 6 | include "./../../config/koneksi.php"; |
7 | 7 | include "./../../config/fungsi_thumb.php"; |
@@ -18,30 +18,30 @@ discard block |
||
18 | 18 | |
19 | 19 | // Hapus modul |
20 | 20 | if ($module=='resep_obat' AND $act=='dhapus'){ |
21 | - $id = $_GET['id']; |
|
22 | - $id_module = $_GET['id_module']; |
|
23 | - $id_kunjungan_berobat = $_GET['id_kunjungan_berobat']; |
|
21 | + $id = $_GET['id']; |
|
22 | + $id_module = $_GET['id_module']; |
|
23 | + $id_kunjungan_berobat = $_GET['id_kunjungan_berobat']; |
|
24 | 24 | |
25 | - mysql_query("DELETE FROM kunjungan_berobat_detail WHERE id_kunjungan_berobat_detail = $id"); |
|
25 | + mysql_query("DELETE FROM kunjungan_berobat_detail WHERE id_kunjungan_berobat_detail = $id"); |
|
26 | 26 | |
27 | - mysql_query("UPDATE obat SET jumlah = jumlah+'$_GET[qty]' |
|
27 | + mysql_query("UPDATE obat SET jumlah = jumlah+'$_GET[qty]' |
|
28 | 28 | ,upddt = '$datetime' |
29 | 29 | ,updby = '$userid' |
30 | 30 | WHERE id_obat = '$_GET[obat]'"); |
31 | 31 | |
32 | - header('location:form_'.$module.'.php?id_kunjungan_berobat='.$id_kunjungan_berobat.'&module='.$module.'&id_module='.$id_modul); |
|
32 | + header('location:form_'.$module.'.php?id_kunjungan_berobat='.$id_kunjungan_berobat.'&module='.$module.'&id_module='.$id_modul); |
|
33 | 33 | |
34 | - } |
|
34 | + } |
|
35 | 35 | |
36 | - // Input group |
|
36 | + // Input group |
|
37 | 37 | elseif ($module=='resep_obat' AND $act=='input'){ |
38 | 38 | |
39 | - $id_module = $_POST['id_module']; |
|
40 | - $id_kunjungan_berobat = $_POST['id_kunjungan_berobat']; |
|
39 | + $id_module = $_POST['id_module']; |
|
40 | + $id_kunjungan_berobat = $_POST['id_kunjungan_berobat']; |
|
41 | 41 | |
42 | 42 | |
43 | - if($_POST['ID']){ |
|
44 | - mysql_query("UPDATE kunjungan_berobat_detail SET id_obat = '$_POST[obat]' |
|
43 | + if($_POST['ID']){ |
|
44 | + mysql_query("UPDATE kunjungan_berobat_detail SET id_obat = '$_POST[obat]' |
|
45 | 45 | ,qty = '$_POST[qty]' |
46 | 46 | ,descr = '$_POST[descr]' |
47 | 47 | ,upddt = '$datetime' |
@@ -59,9 +59,9 @@ discard block |
||
59 | 59 | WHERE id_obat = '$_POST[obat]'"); |
60 | 60 | |
61 | 61 | |
62 | - } else { |
|
62 | + } else { |
|
63 | 63 | |
64 | - mysql_query("INSERT INTO kunjungan_berobat_detail(id_obat |
|
64 | + mysql_query("INSERT INTO kunjungan_berobat_detail(id_obat |
|
65 | 65 | ,qty |
66 | 66 | ,descr |
67 | 67 | ,id_kunjungan_berobat |
@@ -78,18 +78,18 @@ discard block |
||
78 | 78 | ,'$datetime' |
79 | 79 | ,'$userid')"); |
80 | 80 | |
81 | - mysql_query("UPDATE obat SET jumlah = jumlah-'$_POST[qty]' |
|
81 | + mysql_query("UPDATE obat SET jumlah = jumlah-'$_POST[qty]' |
|
82 | 82 | ,upddt = '$datetime' |
83 | 83 | ,updby = '$userid' |
84 | 84 | WHERE id_obat = '$_POST[obat]'"); |
85 | 85 | |
86 | - } |
|
86 | + } |
|
87 | 87 | |
88 | 88 | |
89 | 89 | |
90 | - header('location:form_'.$module.'.php?id_kunjungan_berobat='.$id_kunjungan_berobat.'&module='.$module.'&id_module='.$id_modul); |
|
90 | + header('location:form_'.$module.'.php?id_kunjungan_berobat='.$id_kunjungan_berobat.'&module='.$module.'&id_module='.$id_modul); |
|
91 | 91 | |
92 | - ?> |
|
92 | + ?> |
|
93 | 93 | |
94 | 94 | |
95 | 95 | <!-- <script language="javascript"> |
@@ -99,8 +99,8 @@ |
||
99 | 99 | echo" <td style='text-align:center;'>"; |
100 | 100 | |
101 | 101 | if($r_edit == 'Y') { |
102 | - echo"<a class='thickbox' href='modul/mod_$module/form_$module.php?id_kunjungan_berobat=$r[id_kunjungan_berobat]&id_module=$id&width=720&height=620&module=$module&TB_iframe=true' title='Tambah $nmmodule'><span class='icon'><i class='fa fa-pencil'></i></span></a>"; |
|
103 | - } |
|
102 | + echo"<a class='thickbox' href='modul/mod_$module/form_$module.php?id_kunjungan_berobat=$r[id_kunjungan_berobat]&id_module=$id&width=720&height=620&module=$module&TB_iframe=true' title='Tambah $nmmodule'><span class='icon'><i class='fa fa-pencil'></i></span></a>"; |
|
103 | + } |
|
104 | 104 | |
105 | 105 | |
106 | 106 |
@@ -6,12 +6,12 @@ |
||
6 | 6 | |
7 | 7 | |
8 | 8 | $gtampil=mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
9 | - $g=mysql_fetch_array($gtampil); |
|
9 | + $g=mysql_fetch_array($gtampil); |
|
10 | 10 | |
11 | 11 | if ($g['pict']) { |
12 | - $pict = $g['pict']; |
|
12 | + $pict = $g['pict']; |
|
13 | 13 | } else { |
14 | - $pict = ''; |
|
14 | + $pict = ''; |
|
15 | 15 | } |
16 | 16 | |
17 | 17 | ?> |
@@ -2,39 +2,39 @@ discard block |
||
2 | 2 | session_start(); |
3 | 3 | include 'config/koneksi.php'; |
4 | 4 | |
5 | - if ($_SESSION['role'] == 'SA') { |
|
6 | - $sql = mysql_query("select * from modul where aktif='Y' and status_menu = 'M' order by urutan"); |
|
5 | + if ($_SESSION['role'] == 'SA') { |
|
6 | + $sql = mysql_query("select * from modul where aktif='Y' and status_menu = 'M' order by urutan"); |
|
7 | 7 | |
8 | - $gjml = '1'; |
|
9 | - } else { |
|
10 | - $sql = mysql_query("select distinct c.* from groupmodul b |
|
8 | + $gjml = '1'; |
|
9 | + } else { |
|
10 | + $sql = mysql_query("select distinct c.* from groupmodul b |
|
11 | 11 | inner join modul c |
12 | 12 | on b.id_modul = c.id_modul |
13 | 13 | where b.id_groups = '$groups' and c.aktif='Y' and status_menu='M' |
14 | 14 | order by c.urutan"); |
15 | 15 | |
16 | - $gsql = mysql_query("select * |
|
16 | + $gsql = mysql_query("select * |
|
17 | 17 | from modul a inner join groupmodul b |
18 | 18 | on a.id_modul = b.id_modul |
19 | 19 | where link = 'general_setting' |
20 | 20 | and b.id_groups = '$groups' |
21 | 21 | "); |
22 | - $gjml = mysql_num_rows($gsql); |
|
23 | - } |
|
24 | - |
|
25 | - while ($r = mysql_fetch_array($sql)) { |
|
26 | - if ($r[status_menu] == 'M' and !empty($r[link])) { |
|
27 | - echo "<li><a href='$r[link]&id_module=$r[id_modul]'><i class='$r[icon]'></i> $r[nama_modul]</a>"; |
|
28 | - } elseif ($r[status_menu] == 'M' and empty($r[link])) { |
|
29 | - echo "<li><a href='#'><i class='$r[icon]'></i> $r[nama_modul] <span class='fa fa-chevron-down'></span></a>"; |
|
30 | - } |
|
31 | - |
|
32 | - echo'<ul class="nav child_menu" style="display: none">'; |
|
33 | - |
|
34 | - if ($_SESSION['role'] == 'SA') { |
|
35 | - $detil = mysql_query("select * from modul where aktif='Y' and status_menu = 'C' and parentid = '$r[id_modul]' order by urutan"); |
|
36 | - } else { |
|
37 | - $detil = mysql_query("select distinct c.* |
|
22 | + $gjml = mysql_num_rows($gsql); |
|
23 | + } |
|
24 | + |
|
25 | + while ($r = mysql_fetch_array($sql)) { |
|
26 | + if ($r[status_menu] == 'M' and !empty($r[link])) { |
|
27 | + echo "<li><a href='$r[link]&id_module=$r[id_modul]'><i class='$r[icon]'></i> $r[nama_modul]</a>"; |
|
28 | + } elseif ($r[status_menu] == 'M' and empty($r[link])) { |
|
29 | + echo "<li><a href='#'><i class='$r[icon]'></i> $r[nama_modul] <span class='fa fa-chevron-down'></span></a>"; |
|
30 | + } |
|
31 | + |
|
32 | + echo'<ul class="nav child_menu" style="display: none">'; |
|
33 | + |
|
34 | + if ($_SESSION['role'] == 'SA') { |
|
35 | + $detil = mysql_query("select * from modul where aktif='Y' and status_menu = 'C' and parentid = '$r[id_modul]' order by urutan"); |
|
36 | + } else { |
|
37 | + $detil = mysql_query("select distinct c.* |
|
38 | 38 | from groupmodul b |
39 | 39 | inner join modul c |
40 | 40 | on b.id_modul = c.id_modul |
@@ -43,17 +43,17 @@ discard block |
||
43 | 43 | and c.status_menu='C' |
44 | 44 | and c.parentid = '$r[id_modul]' |
45 | 45 | order by c.urutan"); |
46 | - } |
|
47 | - while ($d = mysql_fetch_array($detil)) { |
|
48 | - if ($d[is_form] == 'Y') { |
|
49 | - echo"<li><a href='modul/mod_$d[link]/form_$d[link].php?width=$d[f_width]&height=$d[f_height]&module=$d[link]&imodule=$imodule&id_module=$id&imenu=$imenu&isub=$isub&TB_iframe=true' title='$d[nama_modul]' class='thickbox' ><i class='$d[fa_icon]'></i>  $d[nama_modul]</a></li>"; |
|
50 | - } else { |
|
51 | - echo"<li><a href='$d[link]&id_module=$d[id_modul]'><i class='$d[fa_icon]'></i>  $d[nama_modul]</a></li>"; |
|
52 | - } |
|
53 | - } |
|
54 | - |
|
55 | - echo'</ul>'; |
|
56 | - } |
|
46 | + } |
|
47 | + while ($d = mysql_fetch_array($detil)) { |
|
48 | + if ($d[is_form] == 'Y') { |
|
49 | + echo"<li><a href='modul/mod_$d[link]/form_$d[link].php?width=$d[f_width]&height=$d[f_height]&module=$d[link]&imodule=$imodule&id_module=$id&imenu=$imenu&isub=$isub&TB_iframe=true' title='$d[nama_modul]' class='thickbox' ><i class='$d[fa_icon]'></i>  $d[nama_modul]</a></li>"; |
|
50 | + } else { |
|
51 | + echo"<li><a href='$d[link]&id_module=$d[id_modul]'><i class='$d[fa_icon]'></i>  $d[nama_modul]</a></li>"; |
|
52 | + } |
|
53 | + } |
|
54 | + |
|
55 | + echo'</ul>'; |
|
56 | + } |
|
57 | 57 | |
58 | 58 | ?> |
59 | 59 |
@@ -1,13 +1,13 @@ |
||
1 | 1 | <?php |
2 | 2 | |
3 | - session_start(); |
|
3 | + session_start(); |
|
4 | 4 | |
5 | - session_destroy(); |
|
5 | + session_destroy(); |
|
6 | 6 | |
7 | - $userid = $_GET['userid']; |
|
8 | - $module = $_GET['module']; |
|
7 | + $userid = $_GET['userid']; |
|
8 | + $module = $_GET['module']; |
|
9 | 9 | |
10 | - header('location:index.php?userid='.$userid.'&module='.$module.''); |
|
10 | + header('location:index.php?userid='.$userid.'&module='.$module.''); |
|
11 | 11 | |
12 | 12 | // Apabila setelah logout langsung menuju halaman utama website, aktifkan baris di bawah ini: |
13 | 13 |