@@ -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,14 +18,14 @@ discard block |
||
18 | 18 | |
19 | 19 | // Hapus modul |
20 | 20 | if ($module=='pasien' AND $act=='hapus'){ |
21 | - $id = $_GET['id']; |
|
22 | - $id_module = $_GET['id_module']; |
|
21 | + $id = $_GET['id']; |
|
22 | + $id_module = $_GET['id_module']; |
|
23 | 23 | |
24 | - mysql_query("DELETE FROM ".$module." WHERE id_".$module." = $id"); |
|
24 | + mysql_query("DELETE FROM ".$module." WHERE id_".$module." = $id"); |
|
25 | 25 | |
26 | - //header('location:../../main.php?module='.$module.'&id_module='.$id_module); |
|
26 | + //header('location:../../main.php?module='.$module.'&id_module='.$id_module); |
|
27 | 27 | |
28 | - ?> |
|
28 | + ?> |
|
29 | 29 | |
30 | 30 | <script language="javascript"> |
31 | 31 | window.parent.location.href = "<?php echo"./../../main.php?module=$module&id_module=$id_module";?>"; |
@@ -34,16 +34,16 @@ discard block |
||
34 | 34 | |
35 | 35 | <?php |
36 | 36 | |
37 | - } |
|
37 | + } |
|
38 | 38 | |
39 | - // Input group |
|
39 | + // Input group |
|
40 | 40 | elseif ($module=='pasien' AND $act=='input'){ |
41 | 41 | |
42 | - $id_module = $_POST['id_module']; |
|
42 | + $id_module = $_POST['id_module']; |
|
43 | 43 | |
44 | 44 | |
45 | - if($_POST['ID']){ |
|
46 | - mysql_query("UPDATE pasien SET ktp = '$_POST[ktp]' |
|
45 | + if($_POST['ID']){ |
|
46 | + mysql_query("UPDATE pasien SET ktp = '$_POST[ktp]' |
|
47 | 47 | ,nama = '$_POST[nama]' |
48 | 48 | ,gender = '$_POST[gender]' |
49 | 49 | ,tgl_lahir = '$_POST[tgl_lahir]' |
@@ -58,8 +58,8 @@ discard block |
||
58 | 58 | |
59 | 59 | |
60 | 60 | |
61 | - } else { |
|
62 | - mysql_query("INSERT INTO pasien(ktp |
|
61 | + } else { |
|
62 | + mysql_query("INSERT INTO pasien(ktp |
|
63 | 63 | ,nama |
64 | 64 | ,gender |
65 | 65 | ,tgl_lahir |
@@ -87,12 +87,12 @@ discard block |
||
87 | 87 | ,'$_POST[aktif]')"); |
88 | 88 | |
89 | 89 | |
90 | - } |
|
90 | + } |
|
91 | 91 | |
92 | 92 | |
93 | - //header('location:../../main.php?module='.$module.'&id_module='.$id_module); |
|
93 | + //header('location:../../main.php?module='.$module.'&id_module='.$id_module); |
|
94 | 94 | |
95 | - ?> |
|
95 | + ?> |
|
96 | 96 | |
97 | 97 | <script language="javascript"> |
98 | 98 | window.parent.location.href = "<?php echo"./../../main.php?module=$module&id_module=$id_module";?>"; |
@@ -92,13 +92,13 @@ |
||
92 | 92 | <? |
93 | 93 | |
94 | 94 | if($r_edit == 'Y') { |
95 | - echo"<a class='thickbox' href='modul/mod_$module/form_$module.php?id_pasien=$r[id_pasien]&id_module=$id&width=720&height=560&module=$module&TB_iframe=true' title='Update $nmmodule'><span class='icon'><i class='fa fa-pencil'></i></span></a>"; |
|
96 | - } |
|
95 | + echo"<a class='thickbox' href='modul/mod_$module/form_$module.php?id_pasien=$r[id_pasien]&id_module=$id&width=720&height=560&module=$module&TB_iframe=true' title='Update $nmmodule'><span class='icon'><i class='fa fa-pencil'></i></span></a>"; |
|
96 | + } |
|
97 | 97 | |
98 | 98 | |
99 | - // if($r_delete == 'Y') { |
|
100 | - // echo"<a href='modul/mod_$module/aksi_$module.php?module=$module&act=hapus&id=$r[id_pasien]&id_module=$id' onClick=\"return confirm('Delete this record ?')\" title='Delete $nmmodule'><span class='icon'><i class='fa fa-trash'></i></span></a>"; |
|
101 | - // } |
|
99 | + // if($r_delete == 'Y') { |
|
100 | + // echo"<a href='modul/mod_$module/aksi_$module.php?module=$module&act=hapus&id=$r[id_pasien]&id_module=$id' onClick=\"return confirm('Delete this record ?')\" title='Delete $nmmodule'><span class='icon'><i class='fa fa-trash'></i></span></a>"; |
|
101 | + // } |
|
102 | 102 | echo"</td>"; |
103 | 103 | echo"</tr>"; |
104 | 104 | $no++; |
@@ -1,7 +1,7 @@ discard block |
||
1 | 1 | <? |
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 | ?> |
@@ -41,27 +41,27 @@ discard block |
||
41 | 41 | |
42 | 42 | $id_module = $_GET['id_module']; |
43 | 43 | |
44 | - $id = isset($_GET['id_pasien']) ? intval($_GET['id_pasien']) : false; |
|
44 | + $id = isset($_GET['id_pasien']) ? intval($_GET['id_pasien']) : false; |
|
45 | 45 | |
46 | - if($id){ |
|
47 | - $query = mysql_query('SELECT * FROM pasien WHERE id_pasien = "'.$id.'"'); |
|
48 | - if($query && mysql_num_rows($query) == 1){ |
|
46 | + if($id){ |
|
47 | + $query = mysql_query('SELECT * FROM pasien WHERE id_pasien = "'.$id.'"'); |
|
48 | + if($query && mysql_num_rows($query) == 1){ |
|
49 | 49 | $data = mysql_fetch_object($query); |
50 | - }else |
|
50 | + }else |
|
51 | 51 | die('Data modul tidak ditemukan'); |
52 | - } |
|
52 | + } |
|
53 | 53 | |
54 | 54 | if ($_GET['igroup']) { |
55 | - $group = $_GET['igroup']; |
|
55 | + $group = $_GET['igroup']; |
|
56 | 56 | } else { |
57 | - $group = $data->id_pasien; |
|
57 | + $group = $data->id_pasien; |
|
58 | 58 | |
59 | 59 | } |
60 | 60 | |
61 | 61 | if ($_GET['imenu']) { |
62 | - $imenu = $_GET['imenu']; |
|
62 | + $imenu = $_GET['imenu']; |
|
63 | 63 | } else { |
64 | - $imenu = $data->id_modul; |
|
64 | + $imenu = $data->id_modul; |
|
65 | 65 | |
66 | 66 | } |
67 | 67 | |
@@ -139,14 +139,14 @@ discard block |
||
139 | 139 | <div class="col-md-6 col-sm-6 col-xs-12" > |
140 | 140 | <select name="agama" class="form-control"> |
141 | 141 | <? |
142 | - $query = mysql_query('SELECT * FROM agama ORDER BY agama'); |
|
143 | - if($query && mysql_num_rows($query) > 0){ |
|
144 | - while($row = mysql_fetch_object($query)){ |
|
145 | - echo '<option value="'.$row->id_agama.'"'; |
|
146 | - if($row->id_agama == @$data->id_agama) echo ' selected'; |
|
147 | - echo '>'.$row->agama.'</option>'; |
|
148 | - } |
|
149 | - } |
|
142 | + $query = mysql_query('SELECT * FROM agama ORDER BY agama'); |
|
143 | + if($query && mysql_num_rows($query) > 0){ |
|
144 | + while($row = mysql_fetch_object($query)){ |
|
145 | + echo '<option value="'.$row->id_agama.'"'; |
|
146 | + if($row->id_agama == @$data->id_agama) echo ' selected'; |
|
147 | + echo '>'.$row->agama.'</option>'; |
|
148 | + } |
|
149 | + } |
|
150 | 150 | ?> |
151 | 151 | </select> |
152 | 152 | </div> |
@@ -156,14 +156,14 @@ discard block |
||
156 | 156 | <div class="col-md-6 col-sm-6 col-xs-12" > |
157 | 157 | <select name="kategori" class="form-control"> |
158 | 158 | <? |
159 | - $query = mysql_query('SELECT * FROM kategori ORDER BY kategori'); |
|
160 | - if($query && mysql_num_rows($query) > 0){ |
|
161 | - while($row = mysql_fetch_object($query)){ |
|
162 | - echo '<option value="'.$row->id_kategori.'"'; |
|
163 | - if($row->id_kategori == @$data->id_kategori) echo ' selected'; |
|
164 | - echo '>'.$row->kategori.'</option>'; |
|
165 | - } |
|
166 | - } |
|
159 | + $query = mysql_query('SELECT * FROM kategori ORDER BY kategori'); |
|
160 | + if($query && mysql_num_rows($query) > 0){ |
|
161 | + while($row = mysql_fetch_object($query)){ |
|
162 | + echo '<option value="'.$row->id_kategori.'"'; |
|
163 | + if($row->id_kategori == @$data->id_kategori) echo ' selected'; |
|
164 | + echo '>'.$row->kategori.'</option>'; |
|
165 | + } |
|
166 | + } |
|
167 | 167 | ?> |
168 | 168 | </select> |
169 | 169 | </div> |
@@ -368,9 +368,9 @@ discard block |
||
368 | 368 | |
369 | 369 | |
370 | 370 | |
371 | - $gtampil=mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
371 | + $gtampil=mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
372 | 372 | |
373 | - $g=mysql_fetch_array($gtampil); |
|
373 | + $g=mysql_fetch_array($gtampil); |
|
374 | 374 | |
375 | 375 | |
376 | 376 | |
@@ -392,7 +392,7 @@ discard block |
||
392 | 392 | |
393 | 393 | |
394 | 394 | |
395 | - ?> |
|
395 | + ?> |
|
396 | 396 | |
397 | 397 | <div style='border:1px solid black;'> |
398 | 398 | |
@@ -411,7 +411,7 @@ discard block |
||
411 | 411 | |
412 | 412 | |
413 | 413 | <? |
414 | - $tampil=mysql_query("SELECT a.*,b.agama,c.kategori |
|
414 | + $tampil=mysql_query("SELECT a.*,b.agama,c.kategori |
|
415 | 415 | FROM pasien a left join agama b |
416 | 416 | ON a.id_agama = b.id_agama |
417 | 417 | left join kategori c |
@@ -13,83 +13,83 @@ discard block |
||
13 | 13 | |
14 | 14 | function getBulan1($bln1){ |
15 | 15 | |
16 | - switch ($bln1){ |
|
16 | + switch ($bln1){ |
|
17 | 17 | |
18 | - case 1: |
|
18 | + case 1: |
|
19 | 19 | |
20 | - return "Januari"; |
|
20 | + return "Januari"; |
|
21 | 21 | |
22 | - break; |
|
22 | + break; |
|
23 | 23 | |
24 | - case 2: |
|
24 | + case 2: |
|
25 | 25 | |
26 | - return "Februari"; |
|
26 | + return "Februari"; |
|
27 | 27 | |
28 | - break; |
|
28 | + break; |
|
29 | 29 | |
30 | - case 3: |
|
30 | + case 3: |
|
31 | 31 | |
32 | - return "Maret"; |
|
32 | + return "Maret"; |
|
33 | 33 | |
34 | - break; |
|
34 | + break; |
|
35 | 35 | |
36 | - case 4: |
|
36 | + case 4: |
|
37 | 37 | |
38 | - return "April"; |
|
38 | + return "April"; |
|
39 | 39 | |
40 | - break; |
|
40 | + break; |
|
41 | 41 | |
42 | - case 5: |
|
42 | + case 5: |
|
43 | 43 | |
44 | - return "Mei"; |
|
44 | + return "Mei"; |
|
45 | 45 | |
46 | - break; |
|
46 | + break; |
|
47 | 47 | |
48 | - case 6: |
|
48 | + case 6: |
|
49 | 49 | |
50 | - return "Juni"; |
|
50 | + return "Juni"; |
|
51 | 51 | |
52 | - break; |
|
52 | + break; |
|
53 | 53 | |
54 | - case 7: |
|
54 | + case 7: |
|
55 | 55 | |
56 | - return "Juli"; |
|
56 | + return "Juli"; |
|
57 | 57 | |
58 | - break; |
|
58 | + break; |
|
59 | 59 | |
60 | - case 8: |
|
60 | + case 8: |
|
61 | 61 | |
62 | - return "Agustus"; |
|
62 | + return "Agustus"; |
|
63 | 63 | |
64 | - break; |
|
64 | + break; |
|
65 | 65 | |
66 | - case 9: |
|
66 | + case 9: |
|
67 | 67 | |
68 | - return "September"; |
|
68 | + return "September"; |
|
69 | 69 | |
70 | - break; |
|
70 | + break; |
|
71 | 71 | |
72 | - case 10: |
|
72 | + case 10: |
|
73 | 73 | |
74 | - return "Oktober"; |
|
74 | + return "Oktober"; |
|
75 | 75 | |
76 | - break; |
|
76 | + break; |
|
77 | 77 | |
78 | - case 11: |
|
78 | + case 11: |
|
79 | 79 | |
80 | - return "November"; |
|
80 | + return "November"; |
|
81 | 81 | |
82 | - break; |
|
82 | + break; |
|
83 | 83 | |
84 | - case 12: |
|
84 | + case 12: |
|
85 | 85 | |
86 | - return "Desember"; |
|
86 | + return "Desember"; |
|
87 | 87 | |
88 | - break; |
|
88 | + break; |
|
89 | 89 | |
90 | - } |
|
90 | + } |
|
91 | 91 | |
92 | - } |
|
92 | + } |
|
93 | 93 | |
94 | 94 | $report_id = $_GET[report_id]; |
95 | 95 | $tampil=mysql_query("SELECT * FROM modul WHERE id_modul ='".$report_id."'"); |
@@ -248,38 +248,38 @@ discard block |
||
248 | 248 | |
249 | 249 | <? |
250 | 250 | |
251 | - $gtampil=mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
251 | + $gtampil=mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
252 | 252 | |
253 | - $g=mysql_fetch_array($gtampil); |
|
253 | + $g=mysql_fetch_array($gtampil); |
|
254 | 254 | |
255 | 255 | |
256 | 256 | |
257 | - if ($g['pict']) { |
|
257 | + if ($g['pict']) { |
|
258 | 258 | |
259 | 259 | $pict = $g['pict']; |
260 | 260 | |
261 | - } else { |
|
261 | + } else { |
|
262 | 262 | |
263 | 263 | $pict = ''; |
264 | 264 | |
265 | - } |
|
265 | + } |
|
266 | 266 | |
267 | 267 | |
268 | - $company = ucwords($g['company']); |
|
268 | + $company = ucwords($g['company']); |
|
269 | 269 | |
270 | - $jsql = mysql_query("SELECT * FROM jenis_transaksi |
|
270 | + $jsql = mysql_query("SELECT * FROM jenis_transaksi |
|
271 | 271 | WHERE id_jenis_transaksi = '$jenis_transaksi' |
272 | 272 | |
273 | 273 | "); |
274 | 274 | |
275 | 275 | |
276 | 276 | |
277 | - $j = mysql_fetch_array($jsql); |
|
277 | + $j = mysql_fetch_array($jsql); |
|
278 | 278 | |
279 | - $jenis_transaksi = $j['jenis_transaksi']; |
|
279 | + $jenis_transaksi = $j['jenis_transaksi']; |
|
280 | 280 | |
281 | 281 | |
282 | - $sql = mysql_query("SELECT a.*,b.shift FROM kasir a LEFT JOIN shift b |
|
282 | + $sql = mysql_query("SELECT a.*,b.shift FROM kasir a LEFT JOIN shift b |
|
283 | 283 | ON a.id_shift = b.id_shift |
284 | 284 | WHERE a.id_kasir = '$k_ID' |
285 | 285 | |
@@ -287,20 +287,20 @@ discard block |
||
287 | 287 | |
288 | 288 | |
289 | 289 | |
290 | - $r = mysql_fetch_array($sql); |
|
290 | + $r = mysql_fetch_array($sql); |
|
291 | 291 | |
292 | 292 | |
293 | - $penjualan_barang = $r['id_kasir']; |
|
293 | + $penjualan_barang = $r['id_kasir']; |
|
294 | 294 | |
295 | - $shift = $r['shift']; |
|
295 | + $shift = $r['shift']; |
|
296 | 296 | |
297 | - $petugas = $r['petugas']; |
|
297 | + $petugas = $r['petugas']; |
|
298 | 298 | |
299 | - $status = $r['status']; |
|
299 | + $status = $r['status']; |
|
300 | 300 | |
301 | - $tanggal = DATE('d/m/Y',strtotime($r['tanggal'])); |
|
301 | + $tanggal = DATE('d/m/Y',strtotime($r['tanggal'])); |
|
302 | 302 | |
303 | - ?> |
|
303 | + ?> |
|
304 | 304 | |
305 | 305 | <table width="100%"> |
306 | 306 | <tr> |
@@ -329,11 +329,11 @@ discard block |
||
329 | 329 | |
330 | 330 | while ($h=mysql_fetch_array($htampil)){ |
331 | 331 | |
332 | - echo "<th colspan='2'>".$h['penjamin']."</th>"; |
|
332 | + echo "<th colspan='2'>".$h['penjamin']."</th>"; |
|
333 | 333 | |
334 | 334 | } |
335 | 335 | |
336 | - ?> |
|
336 | + ?> |
|
337 | 337 | |
338 | 338 | <th colspan ="4" >UMUM</th> |
339 | 339 | <th rowspan="2" >PIC</th> |
@@ -348,14 +348,14 @@ discard block |
||
348 | 348 | <tr> |
349 | 349 | |
350 | 350 | <? |
351 | - for($j = 1; $j <= $hjml; $j++) { |
|
351 | + for($j = 1; $j <= $hjml; $j++) { |
|
352 | 352 | |
353 | - echo "<th>JML</th>"; |
|
354 | - echo "<th>RUPIAH</th>"; |
|
353 | + echo "<th>JML</th>"; |
|
354 | + echo "<th>RUPIAH</th>"; |
|
355 | 355 | |
356 | 356 | |
357 | - } |
|
358 | - ?> |
|
357 | + } |
|
358 | + ?> |
|
359 | 359 | |
360 | 360 | |
361 | 361 | <th>JML</th> |
@@ -378,18 +378,18 @@ discard block |
||
378 | 378 | |
379 | 379 | <? for($i = 1; $i <= 31; $i++) { |
380 | 380 | |
381 | - echo"<tr>"; |
|
381 | + echo"<tr>"; |
|
382 | 382 | |
383 | - echo"<td style='text-align:center;'>$i</td>"; |
|
383 | + echo"<td style='text-align:center;'>$i</td>"; |
|
384 | 384 | |
385 | - if (strlen($i) == '1') { |
|
386 | - $tgl = $prd.'-0'.$i; |
|
387 | - } else { |
|
388 | - $tgl = $prd.'-'.$i; |
|
389 | - } |
|
385 | + if (strlen($i) == '1') { |
|
386 | + $tgl = $prd.'-0'.$i; |
|
387 | + } else { |
|
388 | + $tgl = $prd.'-'.$i; |
|
389 | + } |
|
390 | 390 | |
391 | - //transaksi asuransi |
|
392 | - $dtampil1=mysql_query("SELECT a.id_penjamin |
|
391 | + //transaksi asuransi |
|
392 | + $dtampil1=mysql_query("SELECT a.id_penjamin |
|
393 | 393 | , COUNT(c.jumlah) as jml |
394 | 394 | , IFNULL(SUM(c.jumlah),0) as rp |
395 | 395 | FROM penjamin a LEFT JOIN kasir b |
@@ -406,16 +406,16 @@ discard block |
||
406 | 406 | ORDER BY a.id_penjamin"); |
407 | 407 | |
408 | 408 | |
409 | - while ($d1=mysql_fetch_array($dtampil1)){ |
|
409 | + while ($d1=mysql_fetch_array($dtampil1)){ |
|
410 | 410 | |
411 | 411 | |
412 | - echo "<th>".$d1['jml']."</th>"; |
|
413 | - echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, ".", ",")."</th>"; |
|
412 | + echo "<th>".$d1['jml']."</th>"; |
|
413 | + echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, ".", ",")."</th>"; |
|
414 | 414 | |
415 | - } |
|
415 | + } |
|
416 | 416 | |
417 | - //transaksi umum tunai |
|
418 | - $dtampil2=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
417 | + //transaksi umum tunai |
|
418 | + $dtampil2=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
419 | 419 | , IFNULL(SUM(c.jumlah),0) as rp |
420 | 420 | FROM kasir b LEFT JOIN kasir_detail c |
421 | 421 | ON b.id_kasir = c.id_kasir |
@@ -425,15 +425,15 @@ discard block |
||
425 | 425 | WHERE b.tanggal = '$tgl' |
426 | 426 | AND b.status != '4'"); |
427 | 427 | |
428 | - $d2=mysql_fetch_array($dtampil2); |
|
428 | + $d2=mysql_fetch_array($dtampil2); |
|
429 | 429 | |
430 | 430 | |
431 | - echo "<th>".$d2['jml']."</th>"; |
|
432 | - echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, ".", ",")."</th>"; |
|
431 | + echo "<th>".$d2['jml']."</th>"; |
|
432 | + echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, ".", ",")."</th>"; |
|
433 | 433 | |
434 | 434 | |
435 | - //transaksi umum tunai |
|
436 | - $dtampil3=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
435 | + //transaksi umum tunai |
|
436 | + $dtampil3=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
437 | 437 | , IFNULL(SUM(c.jumlah),0) as rp |
438 | 438 | FROM kasir b LEFT JOIN kasir_detail c |
439 | 439 | ON b.id_kasir = c.id_kasir |
@@ -443,22 +443,22 @@ discard block |
||
443 | 443 | WHERE b.tanggal = '$tgl' |
444 | 444 | AND b.status != '4'"); |
445 | 445 | |
446 | - $d3=mysql_fetch_array($dtampil3); |
|
446 | + $d3=mysql_fetch_array($dtampil3); |
|
447 | 447 | |
448 | 448 | |
449 | - echo "<th>".$d3['jml']."</th>"; |
|
450 | - echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, ".", ",")."</th>"; |
|
449 | + echo "<th>".$d3['jml']."</th>"; |
|
450 | + echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, ".", ",")."</th>"; |
|
451 | 451 | |
452 | - echo "<th></th>"; |
|
453 | - echo "<th></th>"; |
|
454 | - echo "<th></th>"; |
|
452 | + echo "<th></th>"; |
|
453 | + echo "<th></th>"; |
|
454 | + echo "<th></th>"; |
|
455 | 455 | |
456 | - echo "<th></th>"; |
|
457 | - echo "<th></th>"; |
|
458 | - echo "<th></th>"; |
|
456 | + echo "<th></th>"; |
|
457 | + echo "<th></th>"; |
|
458 | + echo "<th></th>"; |
|
459 | 459 | |
460 | - //total jml |
|
461 | - $dtampil4=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
460 | + //total jml |
|
461 | + $dtampil4=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
462 | 462 | FROM kasir b LEFT JOIN kasir_detail c |
463 | 463 | ON b.id_kasir = c.id_kasir |
464 | 464 | AND c.status != '4' |
@@ -466,13 +466,13 @@ discard block |
||
466 | 466 | WHERE b.tanggal = '$tgl' |
467 | 467 | AND b.status != '4'"); |
468 | 468 | |
469 | - $d4=mysql_fetch_array($dtampil4); |
|
469 | + $d4=mysql_fetch_array($dtampil4); |
|
470 | 470 | |
471 | 471 | |
472 | - echo "<th>".$d4['jml']."</th>"; |
|
472 | + echo "<th>".$d4['jml']."</th>"; |
|
473 | 473 | |
474 | - //total pembayaran |
|
475 | - $dtampil5=mysql_query("SELECT a.groups |
|
474 | + //total pembayaran |
|
475 | + $dtampil5=mysql_query("SELECT a.groups |
|
476 | 476 | , IFNULL(SUM(c.jumlah),0) as rp |
477 | 477 | FROM jenis_pembayaran a LEFT JOIN kasir b |
478 | 478 | ON b.tanggal = '$tgl' |
@@ -485,33 +485,33 @@ discard block |
||
485 | 485 | GROUP BY a.groups |
486 | 486 | ORDER BY a.groups"); |
487 | 487 | |
488 | - while ($d5=mysql_fetch_array($dtampil5)){ |
|
488 | + while ($d5=mysql_fetch_array($dtampil5)){ |
|
489 | 489 | |
490 | 490 | |
491 | - echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, ".", ",")."</th>"; |
|
491 | + echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, ".", ",")."</th>"; |
|
492 | 492 | |
493 | - } |
|
493 | + } |
|
494 | 494 | |
495 | 495 | |
496 | 496 | |
497 | 497 | |
498 | - echo"</tr>"; |
|
498 | + echo"</tr>"; |
|
499 | 499 | |
500 | 500 | |
501 | - } ?> |
|
501 | + } ?> |
|
502 | 502 | |
503 | 503 | </tbody> |
504 | 504 | |
505 | 505 | <? |
506 | 506 | |
507 | - echo"<tr>"; |
|
507 | + echo"<tr>"; |
|
508 | 508 | |
509 | - echo"<th style='text-align:center;'>TOTAL</th>"; |
|
509 | + echo"<th style='text-align:center;'>TOTAL</th>"; |
|
510 | 510 | |
511 | 511 | |
512 | 512 | |
513 | - //transaksi asuransi |
|
514 | - $dtampil1=mysql_query("SELECT a.id_penjamin |
|
513 | + //transaksi asuransi |
|
514 | + $dtampil1=mysql_query("SELECT a.id_penjamin |
|
515 | 515 | , COUNT(c.jumlah) as jml |
516 | 516 | , IFNULL(SUM(c.jumlah),0) as rp |
517 | 517 | FROM penjamin a LEFT JOIN kasir b |
@@ -527,16 +527,16 @@ discard block |
||
527 | 527 | GROUP BY a.id_penjamin |
528 | 528 | ORDER BY a.id_penjamin"); |
529 | 529 | |
530 | - while ($d1=mysql_fetch_array($dtampil1)){ |
|
530 | + while ($d1=mysql_fetch_array($dtampil1)){ |
|
531 | 531 | |
532 | 532 | |
533 | - echo "<th>".$d1['jml']."</th>"; |
|
534 | - echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, ".", ",")."</th>"; |
|
533 | + echo "<th>".$d1['jml']."</th>"; |
|
534 | + echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, ".", ",")."</th>"; |
|
535 | 535 | |
536 | - } |
|
536 | + } |
|
537 | 537 | |
538 | - //transaksi umum tunai |
|
539 | - $dtampil2=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
538 | + //transaksi umum tunai |
|
539 | + $dtampil2=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
540 | 540 | , IFNULL(SUM(c.jumlah),0) as rp |
541 | 541 | FROM kasir b LEFT JOIN kasir_detail c |
542 | 542 | ON b.id_kasir = c.id_kasir |
@@ -546,15 +546,15 @@ discard block |
||
546 | 546 | AND b.tanggal LIKE '$prd%' |
547 | 547 | AND b.status != '4'"); |
548 | 548 | |
549 | - $d2=mysql_fetch_array($dtampil2); |
|
549 | + $d2=mysql_fetch_array($dtampil2); |
|
550 | 550 | |
551 | 551 | |
552 | - echo "<th>".$d2['jml']."</th>"; |
|
553 | - echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, ".", ",")."</th>"; |
|
552 | + echo "<th>".$d2['jml']."</th>"; |
|
553 | + echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, ".", ",")."</th>"; |
|
554 | 554 | |
555 | 555 | |
556 | - //transaksi umum tunai |
|
557 | - $dtampil3=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
556 | + //transaksi umum tunai |
|
557 | + $dtampil3=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
558 | 558 | , IFNULL(SUM(c.jumlah),0) as rp |
559 | 559 | FROM kasir b LEFT JOIN kasir_detail c |
560 | 560 | ON b.id_kasir = c.id_kasir |
@@ -564,22 +564,22 @@ discard block |
||
564 | 564 | WHERE b.tanggal LIKE '$prd%' |
565 | 565 | AND b.status != '4'"); |
566 | 566 | |
567 | - $d3=mysql_fetch_array($dtampil3); |
|
567 | + $d3=mysql_fetch_array($dtampil3); |
|
568 | 568 | |
569 | 569 | |
570 | - echo "<th>".$d3['jml']."</th>"; |
|
571 | - echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, ".", ",")."</th>"; |
|
570 | + echo "<th>".$d3['jml']."</th>"; |
|
571 | + echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, ".", ",")."</th>"; |
|
572 | 572 | |
573 | - echo "<th></th>"; |
|
574 | - echo "<th></th>"; |
|
575 | - echo "<th></th>"; |
|
573 | + echo "<th></th>"; |
|
574 | + echo "<th></th>"; |
|
575 | + echo "<th></th>"; |
|
576 | 576 | |
577 | - echo "<th></th>"; |
|
578 | - echo "<th></th>"; |
|
579 | - echo "<th></th>"; |
|
577 | + echo "<th></th>"; |
|
578 | + echo "<th></th>"; |
|
579 | + echo "<th></th>"; |
|
580 | 580 | |
581 | - //total jml |
|
582 | - $dtampil4=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
581 | + //total jml |
|
582 | + $dtampil4=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
583 | 583 | FROM kasir b LEFT JOIN kasir_detail c |
584 | 584 | ON b.id_kasir = c.id_kasir |
585 | 585 | AND c.status != '4' |
@@ -587,13 +587,13 @@ discard block |
||
587 | 587 | WHERE b.tanggal LIKE '$prd%' |
588 | 588 | AND b.status != '4'"); |
589 | 589 | |
590 | - $d4=mysql_fetch_array($dtampil4); |
|
590 | + $d4=mysql_fetch_array($dtampil4); |
|
591 | 591 | |
592 | 592 | |
593 | - echo "<th>".$d4['jml']."</th>"; |
|
593 | + echo "<th>".$d4['jml']."</th>"; |
|
594 | 594 | |
595 | - //total pembayaran |
|
596 | - $dtampil5=mysql_query("SELECT a.groups |
|
595 | + //total pembayaran |
|
596 | + $dtampil5=mysql_query("SELECT a.groups |
|
597 | 597 | , IFNULL(SUM(c.jumlah),0) as rp |
598 | 598 | FROM jenis_pembayaran a LEFT JOIN kasir b |
599 | 599 | ON b.tanggal LIKE '$prd%' |
@@ -606,24 +606,24 @@ discard block |
||
606 | 606 | GROUP BY a.groups |
607 | 607 | ORDER BY a.groups"); |
608 | 608 | |
609 | - while ($d5=mysql_fetch_array($dtampil5)){ |
|
609 | + while ($d5=mysql_fetch_array($dtampil5)){ |
|
610 | 610 | |
611 | 611 | |
612 | - echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, ".", ",")."</th>"; |
|
612 | + echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, ".", ",")."</th>"; |
|
613 | 613 | |
614 | - } |
|
614 | + } |
|
615 | 615 | |
616 | 616 | |
617 | 617 | |
618 | 618 | |
619 | - echo"</tr>"; |
|
619 | + echo"</tr>"; |
|
620 | 620 | |
621 | - echo"<tr>"; |
|
621 | + echo"<tr>"; |
|
622 | 622 | |
623 | - echo"<th style='text-align:center;' colspan='23'>TOTAL REVENUE</th>"; |
|
623 | + echo"<th style='text-align:center;' colspan='23'>TOTAL REVENUE</th>"; |
|
624 | 624 | |
625 | - //total jml |
|
626 | - $dtampil4=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
625 | + //total jml |
|
626 | + $dtampil4=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
627 | 627 | FROM kasir b LEFT JOIN kasir_detail c |
628 | 628 | ON b.id_kasir = c.id_kasir |
629 | 629 | AND c.status != '4' |
@@ -631,13 +631,13 @@ discard block |
||
631 | 631 | WHERE b.tanggal LIKE '$prd%' |
632 | 632 | AND b.status != '4'"); |
633 | 633 | |
634 | - $d4=mysql_fetch_array($dtampil4); |
|
634 | + $d4=mysql_fetch_array($dtampil4); |
|
635 | 635 | |
636 | 636 | |
637 | - echo "<th>".$d4['jml']."</th>"; |
|
637 | + echo "<th>".$d4['jml']."</th>"; |
|
638 | 638 | |
639 | - //total pembayaran |
|
640 | - $dtampil5=mysql_query("SELECT IFNULL(SUM(c.jumlah),0) as rp |
|
639 | + //total pembayaran |
|
640 | + $dtampil5=mysql_query("SELECT IFNULL(SUM(c.jumlah),0) as rp |
|
641 | 641 | FROM kasir b LEFT JOIN kasir_detail c |
642 | 642 | ON b.id_kasir = c.id_kasir |
643 | 643 | AND c.status != '4' |
@@ -645,14 +645,14 @@ discard block |
||
645 | 645 | WHERE b.tanggal LIKE '$prd%' |
646 | 646 | AND b.status != '4'"); |
647 | 647 | |
648 | - $d5=mysql_fetch_array($dtampil5); |
|
648 | + $d5=mysql_fetch_array($dtampil5); |
|
649 | 649 | |
650 | 650 | |
651 | - echo "<th style='text-align:right;' colspan='2'>".number_format($d5['rp'], 0, ".", ",")."</th>"; |
|
651 | + echo "<th style='text-align:right;' colspan='2'>".number_format($d5['rp'], 0, ".", ",")."</th>"; |
|
652 | 652 | |
653 | 653 | |
654 | 654 | |
655 | - ?> |
|
655 | + ?> |
|
656 | 656 | |
657 | 657 | |
658 | 658 | |
@@ -667,13 +667,13 @@ discard block |
||
667 | 667 | $month = DATE('m',strtotime($iprd))*1; |
668 | 668 | |
669 | 669 | if ($month == '1') { |
670 | - $imonth = 12; |
|
670 | + $imonth = 12; |
|
671 | 671 | } else { |
672 | - $imonth = $month-1; |
|
672 | + $imonth = $month-1; |
|
673 | 673 | } |
674 | 674 | |
675 | - $nprd = $lastday.' '.getBulan1($imonth).' '.$year; |
|
676 | - ?> |
|
675 | + $nprd = $lastday.' '.getBulan1($imonth).' '.$year; |
|
676 | + ?> |
|
677 | 677 | |
678 | 678 | <table width="100%"> |
679 | 679 | <tr> |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | $prd = date("Y-m"); |
65 | 65 | |
66 | 66 | $userid = $_SESSION['userid']; |
67 | - ?> |
|
67 | + ?> |
|
68 | 68 | |
69 | 69 | <div class=""> |
70 | 70 | |
@@ -101,14 +101,14 @@ discard block |
||
101 | 101 | <div class="col-md-9 col-sm-9 col-xs-9 form-group"> |
102 | 102 | <select name="jenis_transaksi" class="form-control"> |
103 | 103 | <? |
104 | - $query = mysql_query('SELECT * FROM jenis_transaksi ORDER BY id_jenis_transaksi'); |
|
105 | - if($query && mysql_num_rows($query) > 0){ |
|
106 | - while($row = mysql_fetch_object($query)){ |
|
107 | - echo '<option value="'.$row->id_jenis_transaksi.'"'; |
|
108 | - if($row->id_jenis_transaksi == '1') echo ' selected'; |
|
109 | - echo '>'.$row->jenis_transaksi.'</option>'; |
|
110 | - } |
|
111 | - } |
|
104 | + $query = mysql_query('SELECT * FROM jenis_transaksi ORDER BY id_jenis_transaksi'); |
|
105 | + if($query && mysql_num_rows($query) > 0){ |
|
106 | + while($row = mysql_fetch_object($query)){ |
|
107 | + echo '<option value="'.$row->id_jenis_transaksi.'"'; |
|
108 | + if($row->id_jenis_transaksi == '1') echo ' selected'; |
|
109 | + echo '>'.$row->jenis_transaksi.'</option>'; |
|
110 | + } |
|
111 | + } |
|
112 | 112 | ?> |
113 | 113 | </select> |
114 | 114 | </div> |
@@ -130,12 +130,12 @@ discard block |
||
130 | 130 | |
131 | 131 | <? |
132 | 132 | |
133 | - $module = '?module='.$_GET['module']; |
|
134 | - $tampil=mysql_query("SELECT id_modul as id FROM modul WHERE link='".$module."'"); |
|
135 | - $r=mysql_fetch_array($tampil); |
|
133 | + $module = '?module='.$_GET['module']; |
|
134 | + $tampil=mysql_query("SELECT id_modul as id FROM modul WHERE link='".$module."'"); |
|
135 | + $r=mysql_fetch_array($tampil); |
|
136 | 136 | |
137 | - echo"<input type='hidden' name='report_id' id='report_id' value=".$r[id].">"; |
|
138 | - echo"<input type='hidden' name='module' value=".$_GET[module].">"; |
|
137 | + echo"<input type='hidden' name='report_id' id='report_id' value=".$r[id].">"; |
|
138 | + echo"<input type='hidden' name='module' value=".$_GET[module].">"; |
|
139 | 139 | ?> |
140 | 140 | </form> |
141 | 141 |
@@ -4,83 +4,83 @@ discard block |
||
4 | 4 | |
5 | 5 | function getBulan1($bln1){ |
6 | 6 | |
7 | - switch ($bln1){ |
|
7 | + switch ($bln1){ |
|
8 | 8 | |
9 | - case 1: |
|
9 | + case 1: |
|
10 | 10 | |
11 | - return "Januari"; |
|
11 | + return "Januari"; |
|
12 | 12 | |
13 | - break; |
|
13 | + break; |
|
14 | 14 | |
15 | - case 2: |
|
15 | + case 2: |
|
16 | 16 | |
17 | - return "Februari"; |
|
17 | + return "Februari"; |
|
18 | 18 | |
19 | - break; |
|
19 | + break; |
|
20 | 20 | |
21 | - case 3: |
|
21 | + case 3: |
|
22 | 22 | |
23 | - return "Maret"; |
|
23 | + return "Maret"; |
|
24 | 24 | |
25 | - break; |
|
25 | + break; |
|
26 | 26 | |
27 | - case 4: |
|
27 | + case 4: |
|
28 | 28 | |
29 | - return "April"; |
|
29 | + return "April"; |
|
30 | 30 | |
31 | - break; |
|
31 | + break; |
|
32 | 32 | |
33 | - case 5: |
|
33 | + case 5: |
|
34 | 34 | |
35 | - return "Mei"; |
|
35 | + return "Mei"; |
|
36 | 36 | |
37 | - break; |
|
37 | + break; |
|
38 | 38 | |
39 | - case 6: |
|
39 | + case 6: |
|
40 | 40 | |
41 | - return "Juni"; |
|
41 | + return "Juni"; |
|
42 | 42 | |
43 | - break; |
|
43 | + break; |
|
44 | 44 | |
45 | - case 7: |
|
45 | + case 7: |
|
46 | 46 | |
47 | - return "Juli"; |
|
47 | + return "Juli"; |
|
48 | 48 | |
49 | - break; |
|
49 | + break; |
|
50 | 50 | |
51 | - case 8: |
|
51 | + case 8: |
|
52 | 52 | |
53 | - return "Agustus"; |
|
53 | + return "Agustus"; |
|
54 | 54 | |
55 | - break; |
|
55 | + break; |
|
56 | 56 | |
57 | - case 9: |
|
57 | + case 9: |
|
58 | 58 | |
59 | - return "September"; |
|
59 | + return "September"; |
|
60 | 60 | |
61 | - break; |
|
61 | + break; |
|
62 | 62 | |
63 | - case 10: |
|
63 | + case 10: |
|
64 | 64 | |
65 | - return "Oktober"; |
|
65 | + return "Oktober"; |
|
66 | 66 | |
67 | - break; |
|
67 | + break; |
|
68 | 68 | |
69 | - case 11: |
|
69 | + case 11: |
|
70 | 70 | |
71 | - return "November"; |
|
71 | + return "November"; |
|
72 | 72 | |
73 | - break; |
|
73 | + break; |
|
74 | 74 | |
75 | - case 12: |
|
75 | + case 12: |
|
76 | 76 | |
77 | - return "Desember"; |
|
77 | + return "Desember"; |
|
78 | 78 | |
79 | - break; |
|
79 | + break; |
|
80 | 80 | |
81 | - } |
|
81 | + } |
|
82 | 82 | |
83 | - } |
|
83 | + } |
|
84 | 84 | |
85 | 85 | |
86 | 86 | |
@@ -147,38 +147,38 @@ discard block |
||
147 | 147 | |
148 | 148 | <? |
149 | 149 | |
150 | - $gtampil=mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
150 | + $gtampil=mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
151 | 151 | |
152 | - $g=mysql_fetch_array($gtampil); |
|
152 | + $g=mysql_fetch_array($gtampil); |
|
153 | 153 | |
154 | 154 | |
155 | 155 | |
156 | - if ($g['pict']) { |
|
156 | + if ($g['pict']) { |
|
157 | 157 | |
158 | 158 | $pict = $g['pict']; |
159 | 159 | |
160 | - } else { |
|
160 | + } else { |
|
161 | 161 | |
162 | 162 | $pict = ''; |
163 | 163 | |
164 | - } |
|
164 | + } |
|
165 | 165 | |
166 | 166 | |
167 | - $company = ucwords($g['company']); |
|
167 | + $company = ucwords($g['company']); |
|
168 | 168 | |
169 | - $jsql = mysql_query("SELECT * FROM jenis_transaksi |
|
169 | + $jsql = mysql_query("SELECT * FROM jenis_transaksi |
|
170 | 170 | WHERE id_jenis_transaksi = '$jenis_transaksi' |
171 | 171 | |
172 | 172 | "); |
173 | 173 | |
174 | 174 | |
175 | 175 | |
176 | - $j = mysql_fetch_array($jsql); |
|
176 | + $j = mysql_fetch_array($jsql); |
|
177 | 177 | |
178 | - $jenis_transaksi = $j['jenis_transaksi']; |
|
178 | + $jenis_transaksi = $j['jenis_transaksi']; |
|
179 | 179 | |
180 | 180 | |
181 | - $sql = mysql_query("SELECT a.*,b.shift FROM kasir a LEFT JOIN shift b |
|
181 | + $sql = mysql_query("SELECT a.*,b.shift FROM kasir a LEFT JOIN shift b |
|
182 | 182 | ON a.id_shift = b.id_shift |
183 | 183 | WHERE a.id_kasir = '$k_ID' |
184 | 184 | |
@@ -186,20 +186,20 @@ discard block |
||
186 | 186 | |
187 | 187 | |
188 | 188 | |
189 | - $r = mysql_fetch_array($sql); |
|
189 | + $r = mysql_fetch_array($sql); |
|
190 | 190 | |
191 | 191 | |
192 | - $penjualan_barang = $r['id_kasir']; |
|
192 | + $penjualan_barang = $r['id_kasir']; |
|
193 | 193 | |
194 | - $shift = $r['shift']; |
|
194 | + $shift = $r['shift']; |
|
195 | 195 | |
196 | - $petugas = $r['petugas']; |
|
196 | + $petugas = $r['petugas']; |
|
197 | 197 | |
198 | - $status = $r['status']; |
|
198 | + $status = $r['status']; |
|
199 | 199 | |
200 | - $tanggal = DATE('d/m/Y',strtotime($r['tanggal'])); |
|
200 | + $tanggal = DATE('d/m/Y',strtotime($r['tanggal'])); |
|
201 | 201 | |
202 | - ?> |
|
202 | + ?> |
|
203 | 203 | |
204 | 204 | <table width="100%"> |
205 | 205 | <tr> |
@@ -231,11 +231,11 @@ discard block |
||
231 | 231 | |
232 | 232 | while ($h=mysql_fetch_array($htampil)){ |
233 | 233 | |
234 | - echo "<th colspan='2'>".$h['penjamin']."</th>"; |
|
234 | + echo "<th colspan='2'>".$h['penjamin']."</th>"; |
|
235 | 235 | |
236 | 236 | } |
237 | 237 | |
238 | - ?> |
|
238 | + ?> |
|
239 | 239 | |
240 | 240 | <th colspan ="4" >UMUM</th> |
241 | 241 | <th rowspan="2" >PIC</th> |
@@ -250,14 +250,14 @@ discard block |
||
250 | 250 | <tr> |
251 | 251 | |
252 | 252 | <? |
253 | - for($j = 1; $j <= $hjml; $j++) { |
|
253 | + for($j = 1; $j <= $hjml; $j++) { |
|
254 | 254 | |
255 | - echo "<th>JML</th>"; |
|
256 | - echo "<th>RUPIAH</th>"; |
|
255 | + echo "<th>JML</th>"; |
|
256 | + echo "<th>RUPIAH</th>"; |
|
257 | 257 | |
258 | 258 | |
259 | - } |
|
260 | - ?> |
|
259 | + } |
|
260 | + ?> |
|
261 | 261 | |
262 | 262 | |
263 | 263 | <th>JML</th> |
@@ -280,18 +280,18 @@ discard block |
||
280 | 280 | |
281 | 281 | <? for($i = 1; $i <= 31; $i++) { |
282 | 282 | |
283 | - echo"<tr>"; |
|
283 | + echo"<tr>"; |
|
284 | 284 | |
285 | - echo"<td style='text-align:center;'>$i</td>"; |
|
285 | + echo"<td style='text-align:center;'>$i</td>"; |
|
286 | 286 | |
287 | - if (strlen($i) == '1') { |
|
288 | - $tgl = $prd.'-0'.$i; |
|
289 | - } else { |
|
290 | - $tgl = $prd.'-'.$i; |
|
291 | - } |
|
287 | + if (strlen($i) == '1') { |
|
288 | + $tgl = $prd.'-0'.$i; |
|
289 | + } else { |
|
290 | + $tgl = $prd.'-'.$i; |
|
291 | + } |
|
292 | 292 | |
293 | - //transaksi asuransi |
|
294 | - $dtampil1=mysql_query("SELECT a.id_penjamin |
|
293 | + //transaksi asuransi |
|
294 | + $dtampil1=mysql_query("SELECT a.id_penjamin |
|
295 | 295 | , COUNT(c.jumlah) as jml |
296 | 296 | , IFNULL(SUM(c.jumlah),0) as rp |
297 | 297 | FROM penjamin a LEFT JOIN kasir b |
@@ -307,16 +307,16 @@ discard block |
||
307 | 307 | GROUP BY a.id_penjamin |
308 | 308 | ORDER BY a.id_penjamin"); |
309 | 309 | |
310 | - while ($d1=mysql_fetch_array($dtampil1)){ |
|
310 | + while ($d1=mysql_fetch_array($dtampil1)){ |
|
311 | 311 | |
312 | 312 | |
313 | - echo "<th>".$d1['jml']."</th>"; |
|
314 | - echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, ".", ",")."</th>"; |
|
313 | + echo "<th>".$d1['jml']."</th>"; |
|
314 | + echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, ".", ",")."</th>"; |
|
315 | 315 | |
316 | - } |
|
316 | + } |
|
317 | 317 | |
318 | - //transaksi umum tunai |
|
319 | - $dtampil2=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
318 | + //transaksi umum tunai |
|
319 | + $dtampil2=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
320 | 320 | , IFNULL(SUM(c.jumlah),0) as rp |
321 | 321 | FROM kasir b LEFT JOIN kasir_detail c |
322 | 322 | ON b.id_kasir = c.id_kasir |
@@ -326,15 +326,15 @@ discard block |
||
326 | 326 | WHERE b.tanggal = '$tgl' |
327 | 327 | AND b.status != '4'"); |
328 | 328 | |
329 | - $d2=mysql_fetch_array($dtampil2); |
|
329 | + $d2=mysql_fetch_array($dtampil2); |
|
330 | 330 | |
331 | 331 | |
332 | - echo "<th>".$d2['jml']."</th>"; |
|
333 | - echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, ".", ",")."</th>"; |
|
332 | + echo "<th>".$d2['jml']."</th>"; |
|
333 | + echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, ".", ",")."</th>"; |
|
334 | 334 | |
335 | 335 | |
336 | - //transaksi umum tunai |
|
337 | - $dtampil3=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
336 | + //transaksi umum tunai |
|
337 | + $dtampil3=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
338 | 338 | , IFNULL(SUM(c.jumlah),0) as rp |
339 | 339 | FROM kasir b LEFT JOIN kasir_detail c |
340 | 340 | ON b.id_kasir = c.id_kasir |
@@ -344,22 +344,22 @@ discard block |
||
344 | 344 | WHERE b.tanggal = '$tgl' |
345 | 345 | AND b.status != '4'"); |
346 | 346 | |
347 | - $d3=mysql_fetch_array($dtampil3); |
|
347 | + $d3=mysql_fetch_array($dtampil3); |
|
348 | 348 | |
349 | 349 | |
350 | - echo "<th>".$d3['jml']."</th>"; |
|
351 | - echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, ".", ",")."</th>"; |
|
350 | + echo "<th>".$d3['jml']."</th>"; |
|
351 | + echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, ".", ",")."</th>"; |
|
352 | 352 | |
353 | - echo "<th></th>"; |
|
354 | - echo "<th></th>"; |
|
355 | - echo "<th></th>"; |
|
353 | + echo "<th></th>"; |
|
354 | + echo "<th></th>"; |
|
355 | + echo "<th></th>"; |
|
356 | 356 | |
357 | - echo "<th></th>"; |
|
358 | - echo "<th></th>"; |
|
359 | - echo "<th></th>"; |
|
357 | + echo "<th></th>"; |
|
358 | + echo "<th></th>"; |
|
359 | + echo "<th></th>"; |
|
360 | 360 | |
361 | - //total jml |
|
362 | - $dtampil4=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
361 | + //total jml |
|
362 | + $dtampil4=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
363 | 363 | FROM kasir b LEFT JOIN kasir_detail c |
364 | 364 | ON b.id_kasir = c.id_kasir |
365 | 365 | AND c.status != '4' |
@@ -367,13 +367,13 @@ discard block |
||
367 | 367 | WHERE b.tanggal = '$tgl' |
368 | 368 | AND b.status != '4'"); |
369 | 369 | |
370 | - $d4=mysql_fetch_array($dtampil4); |
|
370 | + $d4=mysql_fetch_array($dtampil4); |
|
371 | 371 | |
372 | 372 | |
373 | - echo "<th>".$d4['jml']."</th>"; |
|
373 | + echo "<th>".$d4['jml']."</th>"; |
|
374 | 374 | |
375 | - //total pembayaran |
|
376 | - $dtampil5=mysql_query("SELECT a.groups |
|
375 | + //total pembayaran |
|
376 | + $dtampil5=mysql_query("SELECT a.groups |
|
377 | 377 | , IFNULL(SUM(c.jumlah),0) as rp |
378 | 378 | FROM jenis_pembayaran a LEFT JOIN kasir b |
379 | 379 | ON b.tanggal = '$tgl' |
@@ -386,33 +386,33 @@ discard block |
||
386 | 386 | GROUP BY a.groups |
387 | 387 | ORDER BY a.groups"); |
388 | 388 | |
389 | - while ($d5=mysql_fetch_array($dtampil5)){ |
|
389 | + while ($d5=mysql_fetch_array($dtampil5)){ |
|
390 | 390 | |
391 | 391 | |
392 | - echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, ".", ",")."</th>"; |
|
392 | + echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, ".", ",")."</th>"; |
|
393 | 393 | |
394 | - } |
|
394 | + } |
|
395 | 395 | |
396 | 396 | |
397 | 397 | |
398 | 398 | |
399 | - echo"</tr>"; |
|
399 | + echo"</tr>"; |
|
400 | 400 | |
401 | 401 | |
402 | - } ?> |
|
402 | + } ?> |
|
403 | 403 | |
404 | 404 | </tbody> |
405 | 405 | |
406 | 406 | <? |
407 | 407 | |
408 | - echo"<tr>"; |
|
408 | + echo"<tr>"; |
|
409 | 409 | |
410 | - echo"<th style='text-align:center;'>TOTAL</th>"; |
|
410 | + echo"<th style='text-align:center;'>TOTAL</th>"; |
|
411 | 411 | |
412 | 412 | |
413 | 413 | |
414 | - //transaksi asuransi |
|
415 | - $dtampil1=mysql_query("SELECT a.id_penjamin |
|
414 | + //transaksi asuransi |
|
415 | + $dtampil1=mysql_query("SELECT a.id_penjamin |
|
416 | 416 | , COUNT(c.jumlah) as jml |
417 | 417 | , IFNULL(SUM(c.jumlah),0) as rp |
418 | 418 | FROM penjamin a LEFT JOIN kasir b |
@@ -428,16 +428,16 @@ discard block |
||
428 | 428 | GROUP BY a.id_penjamin |
429 | 429 | ORDER BY a.id_penjamin"); |
430 | 430 | |
431 | - while ($d1=mysql_fetch_array($dtampil1)){ |
|
431 | + while ($d1=mysql_fetch_array($dtampil1)){ |
|
432 | 432 | |
433 | 433 | |
434 | - echo "<th>".$d1['jml']."</th>"; |
|
435 | - echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, ".", ",")."</th>"; |
|
434 | + echo "<th>".$d1['jml']."</th>"; |
|
435 | + echo "<th style='text-align:right;'>".number_format($d1['rp'], 0, ".", ",")."</th>"; |
|
436 | 436 | |
437 | - } |
|
437 | + } |
|
438 | 438 | |
439 | - //transaksi umum tunai |
|
440 | - $dtampil2=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
439 | + //transaksi umum tunai |
|
440 | + $dtampil2=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
441 | 441 | , IFNULL(SUM(c.jumlah),0) as rp |
442 | 442 | FROM kasir b LEFT JOIN kasir_detail c |
443 | 443 | ON b.id_kasir = c.id_kasir |
@@ -447,15 +447,15 @@ discard block |
||
447 | 447 | AND b.tanggal LIKE '$prd%' |
448 | 448 | AND b.status != '4'"); |
449 | 449 | |
450 | - $d2=mysql_fetch_array($dtampil2); |
|
450 | + $d2=mysql_fetch_array($dtampil2); |
|
451 | 451 | |
452 | 452 | |
453 | - echo "<th>".$d2['jml']."</th>"; |
|
454 | - echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, ".", ",")."</th>"; |
|
453 | + echo "<th>".$d2['jml']."</th>"; |
|
454 | + echo "<th style='text-align:right;'>".number_format($d2['rp'], 0, ".", ",")."</th>"; |
|
455 | 455 | |
456 | 456 | |
457 | - //transaksi umum tunai |
|
458 | - $dtampil3=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
457 | + //transaksi umum tunai |
|
458 | + $dtampil3=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
459 | 459 | , IFNULL(SUM(c.jumlah),0) as rp |
460 | 460 | FROM kasir b LEFT JOIN kasir_detail c |
461 | 461 | ON b.id_kasir = c.id_kasir |
@@ -465,35 +465,35 @@ discard block |
||
465 | 465 | WHERE b.tanggal LIKE '$prd%' |
466 | 466 | AND b.status != '4'"); |
467 | 467 | |
468 | - $d3=mysql_fetch_array($dtampil3); |
|
468 | + $d3=mysql_fetch_array($dtampil3); |
|
469 | 469 | |
470 | 470 | |
471 | - echo "<th>".$d3['jml']."</th>"; |
|
472 | - echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, ".", ",")."</th>"; |
|
471 | + echo "<th>".$d3['jml']."</th>"; |
|
472 | + echo "<th style='text-align:right;'>".number_format($d3['rp'], 0, ".", ",")."</th>"; |
|
473 | 473 | |
474 | - echo "<th></th>"; |
|
475 | - echo "<th></th>"; |
|
476 | - echo "<th></th>"; |
|
474 | + echo "<th></th>"; |
|
475 | + echo "<th></th>"; |
|
476 | + echo "<th></th>"; |
|
477 | 477 | |
478 | - echo "<th></th>"; |
|
479 | - echo "<th></th>"; |
|
480 | - echo "<th></th>"; |
|
478 | + echo "<th></th>"; |
|
479 | + echo "<th></th>"; |
|
480 | + echo "<th></th>"; |
|
481 | 481 | |
482 | - //total jml |
|
483 | - $dtampil4=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
482 | + //total jml |
|
483 | + $dtampil4=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
484 | 484 | FROM kasir b LEFT JOIN kasir_detail c |
485 | 485 | ON b.id_kasir = c.id_kasir |
486 | 486 | AND c.status != '4' |
487 | 487 | WHERE b.tanggal LIKE '$prd%' |
488 | 488 | AND b.status != '4'"); |
489 | 489 | |
490 | - $d4=mysql_fetch_array($dtampil4); |
|
490 | + $d4=mysql_fetch_array($dtampil4); |
|
491 | 491 | |
492 | 492 | |
493 | - echo "<th>".$d4['jml']."</th>"; |
|
493 | + echo "<th>".$d4['jml']."</th>"; |
|
494 | 494 | |
495 | - //total pembayaran |
|
496 | - $dtampil5=mysql_query("SELECT a.groups |
|
495 | + //total pembayaran |
|
496 | + $dtampil5=mysql_query("SELECT a.groups |
|
497 | 497 | , IFNULL(SUM(c.jumlah),0) as rp |
498 | 498 | FROM jenis_pembayaran a LEFT JOIN kasir b |
499 | 499 | ON b.tanggal LIKE '$prd%' |
@@ -506,24 +506,24 @@ discard block |
||
506 | 506 | GROUP BY a.groups |
507 | 507 | ORDER BY a.groups"); |
508 | 508 | |
509 | - while ($d5=mysql_fetch_array($dtampil5)){ |
|
509 | + while ($d5=mysql_fetch_array($dtampil5)){ |
|
510 | 510 | |
511 | 511 | |
512 | - echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, ".", ",")."</th>"; |
|
512 | + echo "<th style='text-align:right;'>".number_format($d5['rp'], 0, ".", ",")."</th>"; |
|
513 | 513 | |
514 | - } |
|
514 | + } |
|
515 | 515 | |
516 | 516 | |
517 | 517 | |
518 | 518 | |
519 | - echo"</tr>"; |
|
519 | + echo"</tr>"; |
|
520 | 520 | |
521 | - echo"<tr>"; |
|
521 | + echo"<tr>"; |
|
522 | 522 | |
523 | - echo"<th style='text-align:center;' colspan='23'>TOTAL REVENUE</th>"; |
|
523 | + echo"<th style='text-align:center;' colspan='23'>TOTAL REVENUE</th>"; |
|
524 | 524 | |
525 | - //total jml |
|
526 | - $dtampil4=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
525 | + //total jml |
|
526 | + $dtampil4=mysql_query("SELECT COUNT(c.jumlah) as jml |
|
527 | 527 | FROM kasir b LEFT JOIN kasir_detail c |
528 | 528 | ON b.id_kasir = c.id_kasir |
529 | 529 | AND c.status != '4' |
@@ -531,13 +531,13 @@ discard block |
||
531 | 531 | WHERE b.tanggal LIKE '$prd%' |
532 | 532 | AND b.status != '4'"); |
533 | 533 | |
534 | - $d4=mysql_fetch_array($dtampil4); |
|
534 | + $d4=mysql_fetch_array($dtampil4); |
|
535 | 535 | |
536 | 536 | |
537 | - echo "<th>".$d4['jml']."</th>"; |
|
537 | + echo "<th>".$d4['jml']."</th>"; |
|
538 | 538 | |
539 | - //total pembayaran |
|
540 | - $dtampil5=mysql_query("SELECT IFNULL(SUM(c.jumlah),0) as rp |
|
539 | + //total pembayaran |
|
540 | + $dtampil5=mysql_query("SELECT IFNULL(SUM(c.jumlah),0) as rp |
|
541 | 541 | FROM kasir b LEFT JOIN kasir_detail c |
542 | 542 | ON b.id_kasir = c.id_kasir |
543 | 543 | AND c.status != '4' |
@@ -545,14 +545,14 @@ discard block |
||
545 | 545 | WHERE b.tanggal LIKE '$prd%' |
546 | 546 | AND b.status != '4'"); |
547 | 547 | |
548 | - $d5=mysql_fetch_array($dtampil5); |
|
548 | + $d5=mysql_fetch_array($dtampil5); |
|
549 | 549 | |
550 | 550 | |
551 | - echo "<th style='text-align:right;' colspan='2'>".number_format($d5['rp'], 0, ".", ",")."</th>"; |
|
551 | + echo "<th style='text-align:right;' colspan='2'>".number_format($d5['rp'], 0, ".", ",")."</th>"; |
|
552 | 552 | |
553 | 553 | |
554 | 554 | |
555 | - ?> |
|
555 | + ?> |
|
556 | 556 | |
557 | 557 | |
558 | 558 | |
@@ -567,13 +567,13 @@ discard block |
||
567 | 567 | $month = DATE('m',strtotime($iprd))*1; |
568 | 568 | |
569 | 569 | if ($month == '1') { |
570 | - $imonth = 12; |
|
570 | + $imonth = 12; |
|
571 | 571 | } else { |
572 | - $imonth = $month-1; |
|
572 | + $imonth = $month-1; |
|
573 | 573 | } |
574 | 574 | |
575 | - $nprd = $lastday.' '.getBulan1($imonth).' '.$year; |
|
576 | - ?> |
|
575 | + $nprd = $lastday.' '.getBulan1($imonth).' '.$year; |
|
576 | + ?> |
|
577 | 577 | |
578 | 578 | <table width="100%"> |
579 | 579 | <tr><td colspan="26"><br></td></tr> |
@@ -13,9 +13,9 @@ discard block |
||
13 | 13 | $fa_icon = $r['fa_icon']; |
14 | 14 | |
15 | 15 | if($r[orientation] == 'P') { |
16 | - $orientation = 'portrait'; |
|
16 | + $orientation = 'portrait'; |
|
17 | 17 | } else { |
18 | - $orientation = 'landscape'; |
|
18 | + $orientation = 'landscape'; |
|
19 | 19 | } |
20 | 20 | |
21 | 21 | |
@@ -163,12 +163,12 @@ discard block |
||
163 | 163 | |
164 | 164 | <? |
165 | 165 | $gtampil=mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
166 | - $g=mysql_fetch_array($gtampil); |
|
166 | + $g=mysql_fetch_array($gtampil); |
|
167 | 167 | |
168 | 168 | if ($g['pict']) { |
169 | - $pict = $g['pict']; |
|
169 | + $pict = $g['pict']; |
|
170 | 170 | } else { |
171 | - $pict = ''; |
|
171 | + $pict = ''; |
|
172 | 172 | } |
173 | 173 | |
174 | 174 | $company = ucwords($g['company']); |
@@ -207,7 +207,7 @@ discard block |
||
207 | 207 | |
208 | 208 | <? |
209 | 209 | |
210 | - $tampil=mysql_query("SELECT b.obat |
|
210 | + $tampil=mysql_query("SELECT b.obat |
|
211 | 211 | , c.satuan |
212 | 212 | , sum(a.qty) as jumlah |
213 | 213 | FROM kunjungan_berobat h inner join kunjungan_berobat_detail a |
@@ -244,7 +244,7 @@ discard block |
||
244 | 244 | echo"</tr>"; |
245 | 245 | $no++; |
246 | 246 | |
247 | - } |
|
247 | + } |
|
248 | 248 | ?> |
249 | 249 | |
250 | 250 | <tfoot> |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | $prd = date("Y-m"); |
65 | 65 | |
66 | 66 | $userid = $_SESSION['userid']; |
67 | - ?> |
|
67 | + ?> |
|
68 | 68 | |
69 | 69 | <div class=""> |
70 | 70 | |
@@ -115,12 +115,12 @@ discard block |
||
115 | 115 | |
116 | 116 | <? |
117 | 117 | |
118 | - $module = '?module='.$_GET['module']; |
|
119 | - $tampil=mysql_query("SELECT id_modul as id FROM modul WHERE link='".$module."'"); |
|
120 | - $r=mysql_fetch_array($tampil); |
|
118 | + $module = '?module='.$_GET['module']; |
|
119 | + $tampil=mysql_query("SELECT id_modul as id FROM modul WHERE link='".$module."'"); |
|
120 | + $r=mysql_fetch_array($tampil); |
|
121 | 121 | |
122 | - echo"<input type='hidden' name='report_id' id='report_id' value=".$r[id].">"; |
|
123 | - echo"<input type='hidden' name='module' value=".$_GET[module].">"; |
|
122 | + echo"<input type='hidden' name='report_id' id='report_id' value=".$r[id].">"; |
|
123 | + echo"<input type='hidden' name='module' value=".$_GET[module].">"; |
|
124 | 124 | ?> |
125 | 125 | </form> |
126 | 126 |