aepnat /
simpuskesmas
@@ -13,7 +13,7 @@ discard block |
||
| 13 | 13 | $fdate = date('Y-m-d'); |
| 14 | 14 | $ldate = date('Y-m-d'); |
| 15 | 15 | |
| 16 | - ?> |
|
| 16 | + ?> |
|
| 17 | 17 | |
| 18 | 18 | <div class=""> |
| 19 | 19 | |
@@ -44,10 +44,10 @@ discard block |
||
| 44 | 44 | <option value='%'>Semua</option> |
| 45 | 45 | |
| 46 | 46 | <?php for ($x = 'A'; $x <= 'Z'; $x++) { |
| 47 | - ?> |
|
| 47 | + ?> |
|
| 48 | 48 | <option value= '<?=$x; ?>'><?=$x; ?></option> |
| 49 | 49 | <?php |
| 50 | - } ?> |
|
| 50 | + } ?> |
|
| 51 | 51 | |
| 52 | 52 | </select> |
| 53 | 53 | </div> --> |
@@ -65,12 +65,12 @@ discard block |
||
| 65 | 65 | |
| 66 | 66 | <?php |
| 67 | 67 | |
| 68 | - $module = '?module='.$_GET['module']; |
|
| 69 | - $tampil = mysql_query("SELECT id_modul as id FROM modul WHERE link='".$module."'"); |
|
| 70 | - $r = mysql_fetch_array($tampil); |
|
| 68 | + $module = '?module='.$_GET['module']; |
|
| 69 | + $tampil = mysql_query("SELECT id_modul as id FROM modul WHERE link='".$module."'"); |
|
| 70 | + $r = mysql_fetch_array($tampil); |
|
| 71 | 71 | |
| 72 | - echo"<input type='hidden' name='report_id' id='report_id' value=".$r[id].'>'; |
|
| 73 | - echo"<input type='hidden' name='module' value=".$_GET[module].'>'; |
|
| 72 | + echo"<input type='hidden' name='report_id' id='report_id' value=".$r[id].'>'; |
|
| 73 | + echo"<input type='hidden' name='module' value=".$_GET[module].'>'; |
|
| 74 | 74 | ?> |
| 75 | 75 | </form> |
| 76 | 76 | |
@@ -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 | <?php |
| 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 | |
@@ -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 | <?php |
| 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 | |
@@ -5,7 +5,7 @@ |
||
| 5 | 5 | default: |
| 6 | 6 | |
| 7 | 7 | $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
| 8 | - $g = mysql_fetch_array($gtampil); |
|
| 8 | + $g = mysql_fetch_array($gtampil); |
|
| 9 | 9 | |
| 10 | 10 | if ($g['pict']) { |
| 11 | 11 | $pict = $g['pict']; |
@@ -311,7 +311,7 @@ discard block |
||
| 311 | 311 | <?php |
| 312 | 312 | |
| 313 | 313 | |
| 314 | - $tampil = mysql_query("SELECT a.*,b.shift
|
|
| 314 | + $tampil = mysql_query("SELECT a.*,b.shift
|
|
| 315 | 315 | |
| 316 | 316 | FROM kasir a left join shift b |
| 317 | 317 | |
@@ -325,57 +325,57 @@ discard block |
||
| 325 | 325 | |
| 326 | 326 | ORDER BY a.tanggal"); |
| 327 | 327 | |
| 328 | - $no = 1; |
|
| 329 | - |
|
| 330 | - while ($r = mysql_fetch_array($tampil)) { |
|
| 331 | - $tgl = date('d/m/Y', strtotime($r['tanggal'])); |
|
| 332 | - |
|
| 333 | - if ($r['status'] == '0') { |
|
| 334 | - $istatus = 'Baru'; |
|
| 335 | - } elseif ($r['status'] == '1') { |
|
| 336 | - $istatus = 'Disetujui'; |
|
| 337 | - } elseif ($r['status'] == '2') { |
|
| 338 | - $istatus = 'Ditolak'; |
|
| 339 | - } elseif ($r['status'] == '9') { |
|
| 340 | - $istatus = 'Posting'; |
|
| 341 | - } else { |
|
| 342 | - $istatus = 'Dibatalkan'; |
|
| 343 | - } |
|
| 328 | + $no = 1; |
|
| 329 | + |
|
| 330 | + while ($r = mysql_fetch_array($tampil)) { |
|
| 331 | + $tgl = date('d/m/Y', strtotime($r['tanggal'])); |
|
| 332 | + |
|
| 333 | + if ($r['status'] == '0') { |
|
| 334 | + $istatus = 'Baru'; |
|
| 335 | + } elseif ($r['status'] == '1') { |
|
| 336 | + $istatus = 'Disetujui'; |
|
| 337 | + } elseif ($r['status'] == '2') { |
|
| 338 | + $istatus = 'Ditolak'; |
|
| 339 | + } elseif ($r['status'] == '9') { |
|
| 340 | + $istatus = 'Posting'; |
|
| 341 | + } else { |
|
| 342 | + $istatus = 'Dibatalkan'; |
|
| 343 | + } |
|
| 344 | 344 | |
| 345 | - $ID = $r[id_kasir]; |
|
| 345 | + $ID = $r[id_kasir]; |
|
| 346 | 346 | |
| 347 | - echo'<tr>'; |
|
| 347 | + echo'<tr>'; |
|
| 348 | 348 | |
| 349 | - echo"<td>$tgl </td>"; |
|
| 349 | + echo"<td>$tgl </td>"; |
|
| 350 | 350 | |
| 351 | - echo"<td>$r[shift]</td>"; |
|
| 351 | + echo"<td>$r[shift]</td>"; |
|
| 352 | 352 | |
| 353 | - echo"<td>$r[petugas]</td>"; |
|
| 353 | + echo"<td>$r[petugas]</td>"; |
|
| 354 | 354 | |
| 355 | - echo"<td>$r[note]</td>"; |
|
| 355 | + echo"<td>$r[note]</td>"; |
|
| 356 | 356 | |
| 357 | - // echo"<td>$istatus</td>"; |
|
| 357 | + // echo"<td>$istatus</td>"; |
|
| 358 | 358 | |
| 359 | - echo"<td style='text-align:center;'>"; |
|
| 359 | + echo"<td style='text-align:center;'>"; |
|
| 360 | 360 | |
| 361 | - if ($r_edit == 'Y') { |
|
| 362 | - 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>"; |
|
| 363 | - } |
|
| 361 | + if ($r_edit == 'Y') { |
|
| 362 | + 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>"; |
|
| 363 | + } |
|
| 364 | 364 | |
| 365 | - if ($r_delete == 'Y' and $r['status'] == '0') { |
|
| 366 | - 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>"; |
|
| 367 | - } else { |
|
| 368 | - echo"<i class='fa fa-trash'></i></span>"; |
|
| 369 | - } |
|
| 365 | + if ($r_delete == 'Y' and $r['status'] == '0') { |
|
| 366 | + 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>"; |
|
| 367 | + } else { |
|
| 368 | + echo"<i class='fa fa-trash'></i></span>"; |
|
| 369 | + } |
|
| 370 | 370 | |
| 371 | - echo'</td>'; |
|
| 371 | + echo'</td>'; |
|
| 372 | 372 | |
| 373 | - echo'</tr>'; |
|
| 373 | + echo'</tr>'; |
|
| 374 | 374 | |
| 375 | - $no++; |
|
| 376 | - } |
|
| 375 | + $no++; |
|
| 376 | + } |
|
| 377 | 377 | |
| 378 | - ?> |
|
| 378 | + ?> |
|
| 379 | 379 | |
| 380 | 380 | </tbody> |
| 381 | 381 | |
@@ -514,16 +514,16 @@ discard block |
||
| 514 | 514 | |
| 515 | 515 | <?php |
| 516 | 516 | |
| 517 | - 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>"; ?>
|
|
| 517 | + 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>"; ?>
|
|
| 518 | 518 | |
| 519 | 519 | <?php |
| 520 | 520 | } else { |
| 521 | - ?> |
|
| 521 | + ?> |
|
| 522 | 522 | |
| 523 | 523 | <button type="button" class="btn btn-danger" disabled>Hapus</button> |
| 524 | 524 | |
| 525 | 525 | <?php |
| 526 | - } ?> |
|
| 526 | + } ?> |
|
| 527 | 527 | |
| 528 | 528 | |
| 529 | 529 | |
@@ -589,7 +589,7 @@ discard block |
||
| 589 | 589 | |
| 590 | 590 | <?php |
| 591 | 591 | |
| 592 | - $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY id_shift'); |
|
| 592 | + $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY id_shift'); |
|
| 593 | 593 | |
| 594 | 594 | if ($query && mysql_num_rows($query) > 0) { |
| 595 | 595 | while ($row = mysql_fetch_object($query)) { |
@@ -603,7 +603,7 @@ discard block |
||
| 603 | 603 | } |
| 604 | 604 | } |
| 605 | 605 | |
| 606 | - ?> |
|
| 606 | + ?> |
|
| 607 | 607 | |
| 608 | 608 | </select> |
| 609 | 609 | |
@@ -813,7 +813,7 @@ discard block |
||
| 813 | 813 | |
| 814 | 814 | <?php |
| 815 | 815 | |
| 816 | - $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY shift'); |
|
| 816 | + $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY shift'); |
|
| 817 | 817 | |
| 818 | 818 | if ($query && mysql_num_rows($query) > 0) { |
| 819 | 819 | while ($row = mysql_fetch_object($query)) { |
@@ -827,7 +827,7 @@ discard block |
||
| 827 | 827 | } |
| 828 | 828 | } |
| 829 | 829 | |
| 830 | - ?> |
|
| 830 | + ?> |
|
| 831 | 831 | |
| 832 | 832 | </select> |
| 833 | 833 | |
@@ -923,7 +923,7 @@ discard block |
||
| 923 | 923 | |
| 924 | 924 | <?php |
| 925 | 925 | |
| 926 | - $query = mysql_query('SELECT * FROM jenis_transaksi WHERE aktif = "Y" ORDER BY id_jenis_transaksi'); |
|
| 926 | + $query = mysql_query('SELECT * FROM jenis_transaksi WHERE aktif = "Y" ORDER BY id_jenis_transaksi'); |
|
| 927 | 927 | |
| 928 | 928 | if ($query && mysql_num_rows($query) > 0) { |
| 929 | 929 | while ($row = mysql_fetch_object($query)) { |
@@ -937,7 +937,7 @@ discard block |
||
| 937 | 937 | } |
| 938 | 938 | } |
| 939 | 939 | |
| 940 | - ?> |
|
| 940 | + ?> |
|
| 941 | 941 | |
| 942 | 942 | </select> |
| 943 | 943 | |
@@ -968,7 +968,7 @@ discard block |
||
| 968 | 968 | |
| 969 | 969 | <?php |
| 970 | 970 | |
| 971 | - $query = mysql_query('SELECT * FROM jenis_pembayaran WHERE aktif = "Y" ORDER BY id_jenis_pembayaran'); |
|
| 971 | + $query = mysql_query('SELECT * FROM jenis_pembayaran WHERE aktif = "Y" ORDER BY id_jenis_pembayaran'); |
|
| 972 | 972 | |
| 973 | 973 | if ($query && mysql_num_rows($query) > 0) { |
| 974 | 974 | while ($row = mysql_fetch_object($query)) { |
@@ -982,7 +982,7 @@ discard block |
||
| 982 | 982 | } |
| 983 | 983 | } |
| 984 | 984 | |
| 985 | - ?> |
|
| 985 | + ?> |
|
| 986 | 986 | |
| 987 | 987 | </select> |
| 988 | 988 | |
@@ -995,7 +995,7 @@ discard block |
||
| 995 | 995 | |
| 996 | 996 | <?php |
| 997 | 997 | |
| 998 | - $query = mysql_query('SELECT * FROM penjamin WHERE aktif = "Y" ORDER BY id_penjamin'); |
|
| 998 | + $query = mysql_query('SELECT * FROM penjamin WHERE aktif = "Y" ORDER BY id_penjamin'); |
|
| 999 | 999 | |
| 1000 | 1000 | if ($query && mysql_num_rows($query) > 0) { |
| 1001 | 1001 | while ($row = mysql_fetch_object($query)) { |
@@ -1009,7 +1009,7 @@ discard block |
||
| 1009 | 1009 | } |
| 1010 | 1010 | } |
| 1011 | 1011 | |
| 1012 | - ?> |
|
| 1012 | + ?> |
|
| 1013 | 1013 | |
| 1014 | 1014 | </select> |
| 1015 | 1015 | |
@@ -1219,7 +1219,7 @@ discard block |
||
| 1219 | 1219 | |
| 1220 | 1220 | if ($jml > 0) { |
| 1221 | 1221 | |
| 1222 | - // $readonly = 'readonly'; |
|
| 1222 | + // $readonly = 'readonly'; |
|
| 1223 | 1223 | |
| 1224 | 1224 | // $disabled = 'disabled'; |
| 1225 | 1225 | |
@@ -1339,7 +1339,7 @@ discard block |
||
| 1339 | 1339 | |
| 1340 | 1340 | <?php |
| 1341 | 1341 | |
| 1342 | - $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY shift'); |
|
| 1342 | + $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY shift'); |
|
| 1343 | 1343 | |
| 1344 | 1344 | if ($query && mysql_num_rows($query) > 0) { |
| 1345 | 1345 | while ($row = mysql_fetch_object($query)) { |
@@ -1353,7 +1353,7 @@ discard block |
||
| 1353 | 1353 | } |
| 1354 | 1354 | } |
| 1355 | 1355 | |
| 1356 | - ?> |
|
| 1356 | + ?> |
|
| 1357 | 1357 | |
| 1358 | 1358 | </select> |
| 1359 | 1359 | |
@@ -1633,7 +1633,7 @@ discard block |
||
| 1633 | 1633 | |
| 1634 | 1634 | <?php |
| 1635 | 1635 | |
| 1636 | - $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY shift'); |
|
| 1636 | + $query = mysql_query('SELECT * FROM shift WHERE aktif = "Y" ORDER BY shift'); |
|
| 1637 | 1637 | |
| 1638 | 1638 | if ($query && mysql_num_rows($query) > 0) { |
| 1639 | 1639 | while ($row = mysql_fetch_object($query)) { |
@@ -1647,7 +1647,7 @@ discard block |
||
| 1647 | 1647 | } |
| 1648 | 1648 | } |
| 1649 | 1649 | |
| 1650 | - ?> |
|
| 1650 | + ?> |
|
| 1651 | 1651 | |
| 1652 | 1652 | </select> |
| 1653 | 1653 | |
@@ -1712,7 +1712,7 @@ discard block |
||
| 1712 | 1712 | |
| 1713 | 1713 | <?php |
| 1714 | 1714 | |
| 1715 | - $d_id = $_GET['d_id']; |
|
| 1715 | + $d_id = $_GET['d_id']; |
|
| 1716 | 1716 | |
| 1717 | 1717 | $dSQL = "SELECT a.*,b.jenis_transaksi,c.penjamin,d.jenis_pembayaran |
| 1718 | 1718 | |
@@ -359,9 +359,9 @@ discard block |
||
| 359 | 359 | |
| 360 | 360 | $outlet = $_GET['outlet']; |
| 361 | 361 | |
| 362 | - $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
| 362 | + $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
|
| 363 | 363 | |
| 364 | - $g = mysql_fetch_array($gtampil); |
|
| 364 | + $g = mysql_fetch_array($gtampil); |
|
| 365 | 365 | |
| 366 | 366 | if ($g['pict']) { |
| 367 | 367 | $pict = $g['pict']; |
@@ -371,11 +371,11 @@ discard block |
||
| 371 | 371 | |
| 372 | 372 | $company = ucwords($g['company']); |
| 373 | 373 | |
| 374 | - $otampil = mysql_query("SELECT * FROM outlet where id_outlet = '$outlet'"); |
|
| 374 | + $otampil = mysql_query("SELECT * FROM outlet where id_outlet = '$outlet'"); |
|
| 375 | 375 | |
| 376 | - $o = mysql_fetch_array($otampil); |
|
| 376 | + $o = mysql_fetch_array($otampil); |
|
| 377 | 377 | |
| 378 | - ?> |
|
| 378 | + ?> |
|
| 379 | 379 | |
| 380 | 380 | |
| 381 | 381 | |
@@ -5,7 +5,7 @@ |
||
| 5 | 5 | default: |
| 6 | 6 | |
| 7 | 7 | $gtampil = mysql_query("SELECT * FROM informasi_perusahaan where id_informasi_perusahaan = '1'"); |
| 8 | - $g = mysql_fetch_array($gtampil); |
|
| 8 | + $g = mysql_fetch_array($gtampil); |
|
| 9 | 9 | |
| 10 | 10 | if ($g['pict']) { |
| 11 | 11 | $pict = $g['pict']; |
@@ -119,16 +119,16 @@ discard block |
||
| 119 | 119 | <select name="room_type" class="form-control1" required onChange="document.myform.submit();"> |
| 120 | 120 | <option value="">--------- Room Type ---------</option> |
| 121 | 121 | <?php |
| 122 | - $query = mysql_query('SELECT * FROM room_type ORDER BY room_type'); |
|
| 123 | - if ($query && mysql_num_rows($query) > 0) { |
|
| 124 | - while ($row = mysql_fetch_object($query)) { |
|
| 125 | - echo '<option value="'.$row->id_room_type.'"'; |
|
| 126 | - if ($row->id_room_type == $_GET['room_type']) { |
|
| 127 | - echo ' selected'; |
|
| 128 | - } |
|
| 129 | - echo '>'.$row->room_type.'</option>'; |
|
| 130 | - } |
|
| 131 | - } |
|
| 122 | + $query = mysql_query('SELECT * FROM room_type ORDER BY room_type'); |
|
| 123 | + if ($query && mysql_num_rows($query) > 0) { |
|
| 124 | + while ($row = mysql_fetch_object($query)) { |
|
| 125 | + echo '<option value="'.$row->id_room_type.'"'; |
|
| 126 | + if ($row->id_room_type == $_GET['room_type']) { |
|
| 127 | + echo ' selected'; |
|
| 128 | + } |
|
| 129 | + echo '>'.$row->room_type.'</option>'; |
|
| 130 | + } |
|
| 131 | + } |
|
| 132 | 132 | ?> |
| 133 | 133 | </select> |
| 134 | 134 | </div> |
@@ -270,110 +270,110 @@ discard block |
||
| 270 | 270 | |
| 271 | 271 | |
| 272 | 272 | <?php |
| 273 | - $tSQL = 'SELECT * FROM room_type '; |
|
| 273 | + $tSQL = 'SELECT * FROM room_type '; |
|
| 274 | 274 | |
| 275 | - if ($_GET['room_type']) { |
|
| 276 | - $tSQL .= "WHERE id_room_type = '$_GET[room_type]'"; |
|
| 277 | - } |
|
| 275 | + if ($_GET['room_type']) { |
|
| 276 | + $tSQL .= "WHERE id_room_type = '$_GET[room_type]'"; |
|
| 277 | + } |
|
| 278 | 278 | |
| 279 | - $tSQL .= 'ORDER BY room_type'; |
|
| 279 | + $tSQL .= 'ORDER BY room_type'; |
|
| 280 | 280 | |
| 281 | - $type = mysql_query($tSQL); |
|
| 281 | + $type = mysql_query($tSQL); |
|
| 282 | 282 | |
| 283 | - while ($t = mysql_fetch_array($type)) { |
|
| 284 | - $id_room_type = $t['id_room_type']; |
|
| 283 | + while ($t = mysql_fetch_array($type)) { |
|
| 284 | + $id_room_type = $t['id_room_type']; |
|
| 285 | 285 | |
| 286 | - echo'<tr>'; |
|
| 287 | - echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'>".$t['room_type'].'</td>'; |
|
| 286 | + echo'<tr>'; |
|
| 287 | + echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'>".$t['room_type'].'</td>'; |
|
| 288 | 288 | |
| 289 | - if ($lmonth == $fmonth and $lyear == $fyear) { |
|
| 290 | - for ($i = $fday; $i <= $lday; $i++) { |
|
| 291 | - if (strlen($i) == '1') { |
|
| 292 | - $tgl = '0'.$i; |
|
| 293 | - } else { |
|
| 294 | - $tgl = $i; |
|
| 295 | - } |
|
| 289 | + if ($lmonth == $fmonth and $lyear == $fyear) { |
|
| 290 | + for ($i = $fday; $i <= $lday; $i++) { |
|
| 291 | + if (strlen($i) == '1') { |
|
| 292 | + $tgl = '0'.$i; |
|
| 293 | + } else { |
|
| 294 | + $tgl = $i; |
|
| 295 | + } |
|
| 296 | 296 | |
| 297 | - $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
| 297 | + $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
| 298 | 298 | |
| 299 | - echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'> |
|
| 299 | + echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'> |
|
| 300 | 300 | </td>"; |
| 301 | - } |
|
| 302 | - } else { |
|
| 303 | - for ($i = $fday; $i <= $f_lastday; $i++) { |
|
| 304 | - if (strlen($i) == '1') { |
|
| 305 | - $tgl = '0'.$i; |
|
| 306 | - } else { |
|
| 307 | - $tgl = $i; |
|
| 308 | - } |
|
| 301 | + } |
|
| 302 | + } else { |
|
| 303 | + for ($i = $fday; $i <= $f_lastday; $i++) { |
|
| 304 | + if (strlen($i) == '1') { |
|
| 305 | + $tgl = '0'.$i; |
|
| 306 | + } else { |
|
| 307 | + $tgl = $i; |
|
| 308 | + } |
|
| 309 | 309 | |
| 310 | - $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
| 310 | + $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
| 311 | 311 | |
| 312 | - $DayName = date('D', strtotime($tanggal)); |
|
| 312 | + $DayName = date('D', strtotime($tanggal)); |
|
| 313 | 313 | |
| 314 | - echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'> |
|
| 314 | + echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'> |
|
| 315 | 315 | </td>"; |
| 316 | - } |
|
| 316 | + } |
|
| 317 | 317 | |
| 318 | - for ($i = 1; $i <= $lday; $i++) { |
|
| 319 | - if (strlen($i) == '1') { |
|
| 320 | - $tgl = '0'.$i; |
|
| 321 | - } else { |
|
| 322 | - $tgl = $i; |
|
| 323 | - } |
|
| 318 | + for ($i = 1; $i <= $lday; $i++) { |
|
| 319 | + if (strlen($i) == '1') { |
|
| 320 | + $tgl = '0'.$i; |
|
| 321 | + } else { |
|
| 322 | + $tgl = $i; |
|
| 323 | + } |
|
| 324 | 324 | |
| 325 | - $tanggal = $lyear.'-'.$lmonth.'-'.$tgl; |
|
| 325 | + $tanggal = $lyear.'-'.$lmonth.'-'.$tgl; |
|
| 326 | 326 | |
| 327 | - $DayName = date('D', strtotime($tanggal)); |
|
| 327 | + $DayName = date('D', strtotime($tanggal)); |
|
| 328 | 328 | |
| 329 | - echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'> |
|
| 329 | + echo"<td style='background-color: #1ABB9C;color: #E7E7E7;'> |
|
| 330 | 330 | </td>"; |
| 331 | - } |
|
| 332 | - } |
|
| 331 | + } |
|
| 332 | + } |
|
| 333 | 333 | |
| 334 | - echo'</tr>'; |
|
| 334 | + echo'</tr>'; |
|
| 335 | 335 | |
| 336 | - $rSQL = "SELECT * FROM room WHERE id_room_type = '$id_room_type' ORDER BY room_no"; |
|
| 336 | + $rSQL = "SELECT * FROM room WHERE id_room_type = '$id_room_type' ORDER BY room_no"; |
|
| 337 | 337 | |
| 338 | - $room = mysql_query($rSQL); |
|
| 338 | + $room = mysql_query($rSQL); |
|
| 339 | 339 | |
| 340 | - $no = 1; |
|
| 341 | - while ($r = mysql_fetch_array($room)) { |
|
| 342 | - $aktif = $r['aktif']; |
|
| 340 | + $no = 1; |
|
| 341 | + while ($r = mysql_fetch_array($room)) { |
|
| 342 | + $aktif = $r['aktif']; |
|
| 343 | 343 | |
| 344 | - if (($no % 2) == 0) { |
|
| 345 | - $sty = 'ftd'; |
|
| 346 | - } else { |
|
| 347 | - $sty = 'ltd'; |
|
| 348 | - } |
|
| 344 | + if (($no % 2) == 0) { |
|
| 345 | + $sty = 'ftd'; |
|
| 346 | + } else { |
|
| 347 | + $sty = 'ltd'; |
|
| 348 | + } |
|
| 349 | 349 | |
| 350 | - $id_room = $r['id_room']; |
|
| 350 | + $id_room = $r['id_room']; |
|
| 351 | 351 | |
| 352 | - echo'<tr>'; |
|
| 353 | - echo"<td style='padding-left:20px;text-align:left;' class=$sty>".$r['room_no'].'</td>'; |
|
| 352 | + echo'<tr>'; |
|
| 353 | + echo"<td style='padding-left:20px;text-align:left;' class=$sty>".$r['room_no'].'</td>'; |
|
| 354 | 354 | |
| 355 | - if ($lmonth == $fmonth and $lyear == $fyear) { |
|
| 356 | - for ($i = $fday; $i <= $lday; $i++) { |
|
| 357 | - if (strlen($i) == '1') { |
|
| 358 | - $tgl = '0'.$i; |
|
| 359 | - } else { |
|
| 360 | - $tgl = $i; |
|
| 361 | - } |
|
| 355 | + if ($lmonth == $fmonth and $lyear == $fyear) { |
|
| 356 | + for ($i = $fday; $i <= $lday; $i++) { |
|
| 357 | + if (strlen($i) == '1') { |
|
| 358 | + $tgl = '0'.$i; |
|
| 359 | + } else { |
|
| 360 | + $tgl = $i; |
|
| 361 | + } |
|
| 362 | 362 | |
| 363 | - $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
| 363 | + $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
| 364 | 364 | |
| 365 | - echo"<td class=$sty style='padding:0;'>"; |
|
| 365 | + echo"<td class=$sty style='padding:0;'>"; |
|
| 366 | 366 | |
| 367 | - if ($aktif == 'T') { |
|
| 368 | - echo" |
|
| 367 | + if ($aktif == 'T') { |
|
| 368 | + echo" |
|
| 369 | 369 | <i class='fa fa-warning' style='color: red;font-size:18px' onMouseover=\"ddrivetip('Out of Order')\"; onMouseout=\"hideddrivetip()\"></i> |
| 370 | 370 | "; |
| 371 | - } |
|
| 371 | + } |
|
| 372 | 372 | |
| 373 | - echo"<table cellpadding='0' cellspacing='0' border='0' width='100%'>"; |
|
| 374 | - echo'<tr>'; |
|
| 373 | + echo"<table cellpadding='0' cellspacing='0' border='0' width='100%'>"; |
|
| 374 | + echo'<tr>'; |
|
| 375 | 375 | |
| 376 | - $cSQL = "SELECT a.id_room,a.room_no,b.rdate,b.status,a.aktif,c.guest,c.initial,d.legend |
|
| 376 | + $cSQL = "SELECT a.id_room,a.room_no,b.rdate,b.status,a.aktif,c.guest,c.initial,d.legend |
|
| 377 | 377 | FROM room a left join room_reservation b |
| 378 | 378 | ON a.id_room = b.id_room |
| 379 | 379 | and b.status in ('0','1') |
@@ -385,131 +385,131 @@ discard block |
||
| 385 | 385 | AND b.rdate = '$tanggal' |
| 386 | 386 | ORDER BY a.room_no,b.id_reservation"; |
| 387 | 387 | |
| 388 | - $croom = mysql_query($cSQL); |
|
| 388 | + $croom = mysql_query($cSQL); |
|
| 389 | 389 | |
| 390 | - $jml = mysql_num_rows($croom); |
|
| 390 | + $jml = mysql_num_rows($croom); |
|
| 391 | 391 | |
| 392 | - //$c=mysql_fetch_array($croom); |
|
| 393 | - while ($c = mysql_fetch_array($croom)) { |
|
| 394 | - $rdate = $c['rdate']; |
|
| 392 | + //$c=mysql_fetch_array($croom); |
|
| 393 | + while ($c = mysql_fetch_array($croom)) { |
|
| 394 | + $rdate = $c['rdate']; |
|
| 395 | 395 | |
| 396 | - $lSQL = "SELECT '$rdate' - INTERVAL 1 DAY as ldate, '$rdate' + INTERVAL 1 DAY as ndate "; |
|
| 397 | - //echo $lSQL; |
|
| 398 | - $ld = mysql_query($lSQL); |
|
| 396 | + $lSQL = "SELECT '$rdate' - INTERVAL 1 DAY as ldate, '$rdate' + INTERVAL 1 DAY as ndate "; |
|
| 397 | + //echo $lSQL; |
|
| 398 | + $ld = mysql_query($lSQL); |
|
| 399 | 399 | |
| 400 | - $l = mysql_fetch_array($ld); |
|
| 400 | + $l = mysql_fetch_array($ld); |
|
| 401 | 401 | |
| 402 | - $ldate = $l['ldate']; |
|
| 402 | + $ldate = $l['ldate']; |
|
| 403 | 403 | |
| 404 | - $ndate = $l['ndate']; |
|
| 404 | + $ndate = $l['ndate']; |
|
| 405 | 405 | |
| 406 | - $cSQL1 = "SELECT * from room_reservation |
|
| 406 | + $cSQL1 = "SELECT * from room_reservation |
|
| 407 | 407 | WHERE id_room = '$id_room' |
| 408 | 408 | AND rdate = '$ldate'"; |
| 409 | 409 | |
| 410 | - $lroom = mysql_query($cSQL1); |
|
| 410 | + $lroom = mysql_query($cSQL1); |
|
| 411 | 411 | |
| 412 | - if ($ldate) { |
|
| 413 | - $ljml = mysql_num_rows($lroom); |
|
| 414 | - } else { |
|
| 415 | - $ljml = '0'; |
|
| 416 | - } |
|
| 412 | + if ($ldate) { |
|
| 413 | + $ljml = mysql_num_rows($lroom); |
|
| 414 | + } else { |
|
| 415 | + $ljml = '0'; |
|
| 416 | + } |
|
| 417 | 417 | |
| 418 | - $cSQL2 = "SELECT * from room_reservation |
|
| 418 | + $cSQL2 = "SELECT * from room_reservation |
|
| 419 | 419 | WHERE id_room = '$id_room' |
| 420 | 420 | AND rdate = '$ndate'"; |
| 421 | 421 | |
| 422 | - $nroom = mysql_query($cSQL2); |
|
| 422 | + $nroom = mysql_query($cSQL2); |
|
| 423 | 423 | |
| 424 | - $njml = mysql_num_rows($nroom); |
|
| 424 | + $njml = mysql_num_rows($nroom); |
|
| 425 | 425 | |
| 426 | - if ($ndate) { |
|
| 427 | - $njml = mysql_num_rows($nroom); |
|
| 428 | - } else { |
|
| 429 | - $njml = '0'; |
|
| 430 | - } |
|
| 426 | + if ($ndate) { |
|
| 427 | + $njml = mysql_num_rows($nroom); |
|
| 428 | + } else { |
|
| 429 | + $njml = '0'; |
|
| 430 | + } |
|
| 431 | 431 | |
| 432 | - $guest = $c['guest']; |
|
| 432 | + $guest = $c['guest']; |
|
| 433 | 433 | |
| 434 | - $legend = $c['legend']; |
|
| 435 | - $status = $c['status']; |
|
| 434 | + $legend = $c['legend']; |
|
| 435 | + $status = $c['status']; |
|
| 436 | 436 | |
| 437 | - if ($status == 0) { |
|
| 438 | - $icolor = '#fff'; |
|
| 439 | - } else { |
|
| 440 | - $icolor = '#fff'; |
|
| 441 | - } |
|
| 437 | + if ($status == 0) { |
|
| 438 | + $icolor = '#fff'; |
|
| 439 | + } else { |
|
| 440 | + $icolor = '#fff'; |
|
| 441 | + } |
|
| 442 | 442 | |
| 443 | - if ($status == 0) { |
|
| 444 | - $istatus = 'Reserved'; |
|
| 445 | - } elseif ($status == 1) { |
|
| 446 | - $istatus = 'Check In'; |
|
| 447 | - } else { |
|
| 448 | - $istatus = 'Check Out'; |
|
| 449 | - } |
|
| 443 | + if ($status == 0) { |
|
| 444 | + $istatus = 'Reserved'; |
|
| 445 | + } elseif ($status == 1) { |
|
| 446 | + $istatus = 'Check In'; |
|
| 447 | + } else { |
|
| 448 | + $istatus = 'Check Out'; |
|
| 449 | + } |
|
| 450 | 450 | |
| 451 | - $iguest = trim($c['initial']).'. '.trim($c['guest']).' | '.$istatus; |
|
| 451 | + $iguest = trim($c['initial']).'. '.trim($c['guest']).' | '.$istatus; |
|
| 452 | 452 | |
| 453 | - if ($c['initial'] == 'Mr ') { |
|
| 454 | - $icon = 'fa fa-male'; |
|
| 455 | - } else { |
|
| 456 | - $icon = 'fa fa-female'; |
|
| 457 | - } |
|
| 453 | + if ($c['initial'] == 'Mr ') { |
|
| 454 | + $icon = 'fa fa-male'; |
|
| 455 | + } else { |
|
| 456 | + $icon = 'fa fa-female'; |
|
| 457 | + } |
|
| 458 | 458 | |
| 459 | - echo $ljml.'-'.$jml.'-'.$njml; |
|
| 459 | + echo $ljml.'-'.$jml.'-'.$njml; |
|
| 460 | 460 | |
| 461 | - //if ($jml == '1') { |
|
| 461 | + //if ($jml == '1') { |
|
| 462 | 462 | |
| 463 | - if ($ljml == '0' and $jml == '1' and $njml == '1') { |
|
| 464 | - echo"<td width='50%'> |
|
| 463 | + if ($ljml == '0' and $jml == '1' and $njml == '1') { |
|
| 464 | + echo"<td width='50%'> |
|
| 465 | 465 | </td>"; |
| 466 | - } |
|
| 466 | + } |
|
| 467 | 467 | |
| 468 | - if ($guest) { |
|
| 469 | - if ($guest) { |
|
| 470 | - echo"<td style='background-color:$legend;' width='50%'> |
|
| 468 | + if ($guest) { |
|
| 469 | + if ($guest) { |
|
| 470 | + echo"<td style='background-color:$legend;' width='50%'> |
|
| 471 | 471 | <a href='' onMouseover=\"ddrivetip('$iguest')\"; onMouseout=\"hideddrivetip()\" title=''><i class='$icon' style='color: $icolor;font-size:15px'></i></a> |
| 472 | 472 | </td>"; |
| 473 | - } else { |
|
| 474 | - echo"<td style='background-color:$legend;' width='50%'> |
|
| 473 | + } else { |
|
| 474 | + echo"<td style='background-color:$legend;' width='50%'> |
|
| 475 | 475 | </td>"; |
| 476 | - } |
|
| 477 | - } |
|
| 478 | - } |
|
| 476 | + } |
|
| 477 | + } |
|
| 478 | + } |
|
| 479 | 479 | |
| 480 | - if ($ljml != '0' and $jml == '1') { |
|
| 481 | - echo"<td width='50%'> |
|
| 480 | + if ($ljml != '0' and $jml == '1') { |
|
| 481 | + echo"<td width='50%'> |
|
| 482 | 482 | </td>"; |
| 483 | - } |
|
| 483 | + } |
|
| 484 | 484 | |
| 485 | - //} |
|
| 485 | + //} |
|
| 486 | 486 | |
| 487 | - echo'</tr>'; |
|
| 488 | - echo'</table>'; |
|
| 489 | - echo'</td>'; |
|
| 490 | - } |
|
| 491 | - } else { |
|
| 492 | - for ($i = $fday; $i <= $f_lastday; $i++) { |
|
| 493 | - if (strlen($i) == '1') { |
|
| 494 | - $tgl = '0'.$i; |
|
| 495 | - } else { |
|
| 496 | - $tgl = $i; |
|
| 497 | - } |
|
| 487 | + echo'</tr>'; |
|
| 488 | + echo'</table>'; |
|
| 489 | + echo'</td>'; |
|
| 490 | + } |
|
| 491 | + } else { |
|
| 492 | + for ($i = $fday; $i <= $f_lastday; $i++) { |
|
| 493 | + if (strlen($i) == '1') { |
|
| 494 | + $tgl = '0'.$i; |
|
| 495 | + } else { |
|
| 496 | + $tgl = $i; |
|
| 497 | + } |
|
| 498 | 498 | |
| 499 | - $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
| 499 | + $tanggal = $fyear.'-'.$fmonth.'-'.$tgl; |
|
| 500 | 500 | |
| 501 | - echo"<td class=$sty style='padding:0;'>"; |
|
| 501 | + echo"<td class=$sty style='padding:0;'>"; |
|
| 502 | 502 | |
| 503 | - if ($aktif == 'T') { |
|
| 504 | - echo" |
|
| 503 | + if ($aktif == 'T') { |
|
| 504 | + echo" |
|
| 505 | 505 | <i class='fa fa-warning' style='color: red;font-size:18px' onMouseover=\"ddrivetip('Out of Order')\"; onMouseout=\"hideddrivetip()\"></i> |
| 506 | 506 | "; |
| 507 | - } |
|
| 507 | + } |
|
| 508 | 508 | |
| 509 | - echo"<table cellpadding='0' cellspacing='0' border='0' width='100%'>"; |
|
| 510 | - echo'<tr>'; |
|
| 509 | + echo"<table cellpadding='0' cellspacing='0' border='0' width='100%'>"; |
|
| 510 | + echo'<tr>'; |
|
| 511 | 511 | |
| 512 | - $cSQL = "SELECT a.id_room,a.room_no,b.rdate,b.status,a.aktif,c.guest,c.initial,d.legend |
|
| 512 | + $cSQL = "SELECT a.id_room,a.room_no,b.rdate,b.status,a.aktif,c.guest,c.initial,d.legend |
|
| 513 | 513 | FROM room a left join room_reservation b |
| 514 | 514 | ON a.id_room = b.id_room |
| 515 | 515 | and b.status in ('0','1') |
@@ -521,82 +521,82 @@ discard block |
||
| 521 | 521 | AND b.rdate = '$tanggal' |
| 522 | 522 | ORDER BY a.room_no"; |
| 523 | 523 | |
| 524 | - $croom = mysql_query($cSQL); |
|
| 524 | + $croom = mysql_query($cSQL); |
|
| 525 | 525 | |
| 526 | - $jml = mysql_num_rows($croom); |
|
| 526 | + $jml = mysql_num_rows($croom); |
|
| 527 | 527 | |
| 528 | - //$c=mysql_fetch_array($croom); |
|
| 529 | - while ($c = mysql_fetch_array($croom)) { |
|
| 530 | - $guest = $c['guest']; |
|
| 528 | + //$c=mysql_fetch_array($croom); |
|
| 529 | + while ($c = mysql_fetch_array($croom)) { |
|
| 530 | + $guest = $c['guest']; |
|
| 531 | 531 | |
| 532 | - $legend = $c['legend']; |
|
| 533 | - $status = $c['status']; |
|
| 532 | + $legend = $c['legend']; |
|
| 533 | + $status = $c['status']; |
|
| 534 | 534 | |
| 535 | - if ($status == 0) { |
|
| 536 | - $icolor = '#fff'; |
|
| 537 | - } else { |
|
| 538 | - $icolor = '#fff'; |
|
| 539 | - } |
|
| 535 | + if ($status == 0) { |
|
| 536 | + $icolor = '#fff'; |
|
| 537 | + } else { |
|
| 538 | + $icolor = '#fff'; |
|
| 539 | + } |
|
| 540 | 540 | |
| 541 | - if ($status == 0) { |
|
| 542 | - $istatus = 'Reserved'; |
|
| 543 | - } elseif ($status == 1) { |
|
| 544 | - $istatus = 'Check In'; |
|
| 545 | - } else { |
|
| 546 | - $istatus = 'Check Out'; |
|
| 547 | - } |
|
| 541 | + if ($status == 0) { |
|
| 542 | + $istatus = 'Reserved'; |
|
| 543 | + } elseif ($status == 1) { |
|
| 544 | + $istatus = 'Check In'; |
|
| 545 | + } else { |
|
| 546 | + $istatus = 'Check Out'; |
|
| 547 | + } |
|
| 548 | 548 | |
| 549 | - $iguest = trim($c['initial']).'. '.trim($c['guest']).' | '.$istatus; |
|
| 549 | + $iguest = trim($c['initial']).'. '.trim($c['guest']).' | '.$istatus; |
|
| 550 | 550 | |
| 551 | - if ($c['initial'] == 'Mr ') { |
|
| 552 | - $icon = 'fa fa-male'; |
|
| 553 | - } else { |
|
| 554 | - $icon = 'fa fa-female'; |
|
| 555 | - } |
|
| 551 | + if ($c['initial'] == 'Mr ') { |
|
| 552 | + $icon = 'fa fa-male'; |
|
| 553 | + } else { |
|
| 554 | + $icon = 'fa fa-female'; |
|
| 555 | + } |
|
| 556 | 556 | |
| 557 | - if ($guest) { |
|
| 558 | - if ($guest) { |
|
| 559 | - echo"<td style='background-color:$legend;' width='50%'> |
|
| 557 | + if ($guest) { |
|
| 558 | + if ($guest) { |
|
| 559 | + echo"<td style='background-color:$legend;' width='50%'> |
|
| 560 | 560 | <a href='' onMouseover=\"ddrivetip('$iguest')\"; onMouseout=\"hideddrivetip()\" title=''><i class='$icon' style='color: $icolor;font-size:15px'></i></a> |
| 561 | 561 | </td>"; |
| 562 | - } else { |
|
| 563 | - echo"<td style='background-color:$legend;' width='50%'> |
|
| 562 | + } else { |
|
| 563 | + echo"<td style='background-color:$legend;' width='50%'> |
|
| 564 | 564 | </td>"; |
| 565 | - } |
|
| 566 | - } |
|
| 567 | - } |
|
| 565 | + } |
|
| 566 | + } |
|
| 567 | + } |
|
| 568 | 568 | |
| 569 | - if ($jml == '1') { |
|
| 570 | - echo"<td width='50%'> |
|
| 569 | + if ($jml == '1') { |
|
| 570 | + echo"<td width='50%'> |
|
| 571 | 571 | </td>"; |
| 572 | - } |
|
| 572 | + } |
|
| 573 | 573 | |
| 574 | - echo'</tr>'; |
|
| 575 | - echo'</table>'; |
|
| 576 | - echo'</td>'; |
|
| 577 | - } |
|
| 574 | + echo'</tr>'; |
|
| 575 | + echo'</table>'; |
|
| 576 | + echo'</td>'; |
|
| 577 | + } |
|
| 578 | 578 | |
| 579 | - for ($i = 1; $i <= $lday; $i++) { |
|
| 580 | - if (strlen($i) == '1') { |
|
| 581 | - $tgl = '0'.$i; |
|
| 582 | - } else { |
|
| 583 | - $tgl = $i; |
|
| 584 | - } |
|
| 579 | + for ($i = 1; $i <= $lday; $i++) { |
|
| 580 | + if (strlen($i) == '1') { |
|
| 581 | + $tgl = '0'.$i; |
|
| 582 | + } else { |
|
| 583 | + $tgl = $i; |
|
| 584 | + } |
|
| 585 | 585 | |
| 586 | - $tanggal = $lyear.'-'.$lmonth.'-'.$tgl; |
|
| 586 | + $tanggal = $lyear.'-'.$lmonth.'-'.$tgl; |
|
| 587 | 587 | |
| 588 | - echo"<td class=$sty style='padding:0;'>"; |
|
| 588 | + echo"<td class=$sty style='padding:0;'>"; |
|
| 589 | 589 | |
| 590 | - if ($aktif == 'T') { |
|
| 591 | - echo" |
|
| 590 | + if ($aktif == 'T') { |
|
| 591 | + echo" |
|
| 592 | 592 | <i class='fa fa-warning' style='color: red;font-size:18px' onMouseover=\"ddrivetip('Out of Order')\"; onMouseout=\"hideddrivetip()\"></i> |
| 593 | 593 | "; |
| 594 | - } |
|
| 594 | + } |
|
| 595 | 595 | |
| 596 | - echo"<table cellpadding='0' cellspacing='0' border='0' width='100%'>"; |
|
| 597 | - echo'<tr>'; |
|
| 596 | + echo"<table cellpadding='0' cellspacing='0' border='0' width='100%'>"; |
|
| 597 | + echo'<tr>'; |
|
| 598 | 598 | |
| 599 | - $cSQL = "SELECT a.id_room,a.room_no,b.rdate,b.status,a.aktif,c.guest,c.initial,d.legend |
|
| 599 | + $cSQL = "SELECT a.id_room,a.room_no,b.rdate,b.status,a.aktif,c.guest,c.initial,d.legend |
|
| 600 | 600 | FROM room a left join room_reservation b |
| 601 | 601 | ON a.id_room = b.id_room |
| 602 | 602 | and b.status in ('0','1') |
@@ -608,66 +608,66 @@ discard block |
||
| 608 | 608 | AND b.rdate = '$tanggal' |
| 609 | 609 | ORDER BY a.room_no"; |
| 610 | 610 | |
| 611 | - $croom = mysql_query($cSQL); |
|
| 611 | + $croom = mysql_query($cSQL); |
|
| 612 | 612 | |
| 613 | - $jml = mysql_num_rows($croom); |
|
| 613 | + $jml = mysql_num_rows($croom); |
|
| 614 | 614 | |
| 615 | - //$c=mysql_fetch_array($croom); |
|
| 616 | - while ($c = mysql_fetch_array($croom)) { |
|
| 617 | - $guest = $c['guest']; |
|
| 615 | + //$c=mysql_fetch_array($croom); |
|
| 616 | + while ($c = mysql_fetch_array($croom)) { |
|
| 617 | + $guest = $c['guest']; |
|
| 618 | 618 | |
| 619 | - $legend = $c['legend']; |
|
| 620 | - $status = $c['status']; |
|
| 619 | + $legend = $c['legend']; |
|
| 620 | + $status = $c['status']; |
|
| 621 | 621 | |
| 622 | - if ($status == 0) { |
|
| 623 | - $icolor = '#fff'; |
|
| 624 | - } else { |
|
| 625 | - $icolor = '#fff'; |
|
| 626 | - } |
|
| 622 | + if ($status == 0) { |
|
| 623 | + $icolor = '#fff'; |
|
| 624 | + } else { |
|
| 625 | + $icolor = '#fff'; |
|
| 626 | + } |
|
| 627 | 627 | |
| 628 | - if ($status == 0) { |
|
| 629 | - $istatus = 'Reserved'; |
|
| 630 | - } elseif ($status == 1) { |
|
| 631 | - $istatus = 'Check In'; |
|
| 632 | - } else { |
|
| 633 | - $istatus = 'Check Out'; |
|
| 634 | - } |
|
| 628 | + if ($status == 0) { |
|
| 629 | + $istatus = 'Reserved'; |
|
| 630 | + } elseif ($status == 1) { |
|
| 631 | + $istatus = 'Check In'; |
|
| 632 | + } else { |
|
| 633 | + $istatus = 'Check Out'; |
|
| 634 | + } |
|
| 635 | 635 | |
| 636 | - $iguest = trim($c['initial']).'. '.trim($c['guest']).' | '.$istatus; |
|
| 636 | + $iguest = trim($c['initial']).'. '.trim($c['guest']).' | '.$istatus; |
|
| 637 | 637 | |
| 638 | - if ($c['initial'] == 'Mr ') { |
|
| 639 | - $icon = 'fa fa-male'; |
|
| 640 | - } else { |
|
| 641 | - $icon = 'fa fa-female'; |
|
| 642 | - } |
|
| 638 | + if ($c['initial'] == 'Mr ') { |
|
| 639 | + $icon = 'fa fa-male'; |
|
| 640 | + } else { |
|
| 641 | + $icon = 'fa fa-female'; |
|
| 642 | + } |
|
| 643 | 643 | |
| 644 | - if ($guest) { |
|
| 645 | - if ($guest) { |
|
| 646 | - echo"<td style='background-color:$legend;' width='50%'> |
|
| 644 | + if ($guest) { |
|
| 645 | + if ($guest) { |
|
| 646 | + echo"<td style='background-color:$legend;' width='50%'> |
|
| 647 | 647 | <a href='' onMouseover=\"ddrivetip('$iguest')\"; onMouseout=\"hideddrivetip()\" title=''><i class='$icon' style='color: $icolor;font-size:15px'></i></a> |
| 648 | 648 | </td>"; |
| 649 | - } else { |
|
| 650 | - echo"<td style='background-color:$legend;' width='50%'> |
|
| 649 | + } else { |
|
| 650 | + echo"<td style='background-color:$legend;' width='50%'> |
|
| 651 | 651 | </td>"; |
| 652 | - } |
|
| 653 | - } |
|
| 654 | - } |
|
| 652 | + } |
|
| 653 | + } |
|
| 654 | + } |
|
| 655 | 655 | |
| 656 | - if ($jml == '1') { |
|
| 657 | - echo"<td width='50%'> |
|
| 656 | + if ($jml == '1') { |
|
| 657 | + echo"<td width='50%'> |
|
| 658 | 658 | </td>"; |
| 659 | - } |
|
| 660 | - |
|
| 661 | - echo'</tr>'; |
|
| 662 | - echo'</table>'; |
|
| 663 | - echo'</td>'; |
|
| 664 | - } |
|
| 665 | - } |
|
| 666 | - echo'</tr>'; |
|
| 667 | - |
|
| 668 | - $no++; |
|
| 669 | - } |
|
| 670 | - } |
|
| 659 | + } |
|
| 660 | + |
|
| 661 | + echo'</tr>'; |
|
| 662 | + echo'</table>'; |
|
| 663 | + echo'</td>'; |
|
| 664 | + } |
|
| 665 | + } |
|
| 666 | + echo'</tr>'; |
|
| 667 | + |
|
| 668 | + $no++; |
|
| 669 | + } |
|
| 670 | + } |
|
| 671 | 671 | ?> |
| 672 | 672 | |
| 673 | 673 | </tbody> |
@@ -682,13 +682,13 @@ discard block |
||
| 682 | 682 | <tr> |
| 683 | 683 | <td style='padding-right:3px;'>Room Status : </td> |
| 684 | 684 | <?php |
| 685 | - $SQL = "SELECT * FROM room_status where aktif ='Y' ORDER BY id_room_status"; |
|
| 686 | - $tampil = mysql_query($SQL); |
|
| 685 | + $SQL = "SELECT * FROM room_status where aktif ='Y' ORDER BY id_room_status"; |
|
| 686 | + $tampil = mysql_query($SQL); |
|
| 687 | 687 | |
| 688 | - while ($r = mysql_fetch_array($tampil)) { |
|
| 689 | - echo"<td style='width:20px;background-color:".$r['legend'].";'> </td>"; |
|
| 690 | - echo"<td style='padding-left:3px;'>".$r['room_status'].' </td>'; |
|
| 691 | - } |
|
| 688 | + while ($r = mysql_fetch_array($tampil)) { |
|
| 689 | + echo"<td style='width:20px;background-color:".$r['legend'].";'> </td>"; |
|
| 690 | + echo"<td style='padding-left:3px;'>".$r['room_status'].' </td>'; |
|
| 691 | + } |
|
| 692 | 692 | |
| 693 | 693 | ?> |
| 694 | 694 | </tr> |
@@ -701,12 +701,12 @@ discard block |
||
| 701 | 701 | <td style='padding-right:3px;'>Day Status : </td> |
| 702 | 702 | <?php |
| 703 | 703 | |
| 704 | - echo"<td style='width:20px;background-color:#eba51c;'> </td>"; |
|
| 705 | - echo"<td style='padding-left:3px;'>Spesial Day </td>"; |
|
| 706 | - echo"<td style='width:20px;background-color:#eb1c41;'> </td>"; |
|
| 707 | - echo"<td style='padding-left:3px;'>Weekend </td>"; |
|
| 708 | - echo"<td style='width:20px;background-color:#2A3F54;;'> </td>"; |
|
| 709 | - echo"<td style='padding-left:3px;'>Weekday </td>"; |
|
| 704 | + echo"<td style='width:20px;background-color:#eba51c;'> </td>"; |
|
| 705 | + echo"<td style='padding-left:3px;'>Spesial Day </td>"; |
|
| 706 | + echo"<td style='width:20px;background-color:#eb1c41;'> </td>"; |
|
| 707 | + echo"<td style='padding-left:3px;'>Weekend </td>"; |
|
| 708 | + echo"<td style='width:20px;background-color:#2A3F54;;'> </td>"; |
|
| 709 | + echo"<td style='padding-left:3px;'>Weekday </td>"; |
|
| 710 | 710 | |
| 711 | 711 | ?> |
| 712 | 712 | </tr> |
