Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ?>
- <style type="text/css">
- textarea{
- resize:none;
- }
- </style>
- <style type="text/css">
- a#cl:link {background: #FFCC00; text-decoration: none}
- a#cl:visited {background: #FFCC00; text-decoration: none}
- a#cl:active {background: #FFCC00; text-decoration: none}
- a#cl:hover {background: #fff; font-weight:bold; color: black;}
- </style>
- <script type="text/javascript">
- $(document).ready(function(){
- $('input:radio[name=cek]').change(function(){
- if(this.value=='sudah'){
- $('#pernah_pesan').show();
- $('#hanya_pesan').hide();
- $('#list').hide();
- }
- else if(this.value=='hanya_pesan'){
- $('#hanya_pesan').show();
- $('#pernah_pesan').hide();
- $('#laporan1').hide();
- $('#list').hide();
- }
- else if(this.value=='belum'){
- $('#hanya_pesan').hide();
- $('#pernah_pesan').hide();
- $('#laporan1').hide();
- $('#list').hide();
- }
- });
- });
- function myFunction() {
- document.getElementById("simpan").disabled = true;
- document.getElementById("laporan1").show();
- }
- </script>
- <?php
- if (isset($_POST['nama'])) {
- // update status
- mysql_query("UPDATE tb_reservasi_kamar SET status='A' WHERE no_pemesanan='".decode_autonumber($_POST['nop'],"TRK")."'");
- foreach ($_POST['nama'] as $irpd => $nama) {
- foreach ($nama as $key => $nama2) {
- mysql_query("INSERT INTO tb_data_penghuni_kamar (id_pemesanan_kamar_detail,nama,alamat,tanggal_lahir,kebangsaan) VALUES('$irpd', '".$nama2."', '".$_POST['alamat'][$irpd][$key]."', '".$_POST['tgl_lahir'][$irpd][$key]."', '".$_POST['bangsa'][$irpd][$key]."')");
- echo "<meta http-equiv='refresh' content=3;url='?page=biling.biling'>Berhasil";
- }
- }
- echo "<script>
- simpan.disabled=true;
- list.hide();
- laporan1.show();
- myFunction();
- </script>";
- }
- ?>
- <?php
- if (empty($_GET['kode_biling'])AND $_SESSION['ses_admin_level']!='Roomboy') :
- ?>
- <h4>Transaksi Check_in</h4>
- <hr></hr>
- Proses checkin kamar
- <hr></hr>
- <form method="post" action="">
- <h3>Apakah Sudah Pernah Pesan</h3>
- <?php
- $checked = isset($_GET['checked']) ? $_GET['checked'] : '';
- ?>
- <input <?php if($checked=='1'){ echo "checked"; } ?> id="reserved" type="radio"name="cek" value="sudah" >Sudah Pesan,Akan Checkin
- <input <?php if($checked=='3'){ echo "checked"; } ?> id="onlypesan" type="radio"name="cek" value="hanya_pesan" >Hanya Pesan
- <img src="../image/log_in.ico" height="20px"><a id="cl" href='?page=biling.checkin_langsung'>Langsung checkin</a>
- </form>
- <?php endif; ?>
- <!-- melihat tabel transaksi checkin kamar -->
- <div id="list">
- <?php if(isset($_GET['kode_biling'])): ?>
- <?php
- $kode_biling=antihtml(decode_autonumber($_GET['kode_biling'],"TRK"));
- //print_r($kode_biling); exit;
- $data_reservasi=detail_reservasi_kamar($kode_biling);
- $data_member=detail_member($data_reservasi[0]['id_member']);
- //print_r($data_reservasi);
- $sekarang=date('Y-m-d H:i:s');
- $comax12=$data_reservasi[0]['tanggal_checkout'].' 12:00:00';
- $comax17=$data_reservasi[0]['tanggal_checkout'].' 17:00:00';
- //mengetahui detik berjalan
- $detik_sekarang=strtotime($sekarang);
- $detik_kcomax12=strtotime($comax12);
- $detik_comax17=strtotime($comax17);
- if($detik_sekarang>$detik_kcomax12 AND $detik_sekarang < $detik_comax17){
- $tambah=50;
- }else if( $detik_sekarang > $detik_comax17){
- $tambah=100;
- }else
- {
- $tambah=0;
- }
- ?>
- <?php
- $query= mysql_query("SELECT * FROM tb_reservasi_kamar rk
- JOIN tb_konfirmasi_pemesanan_kamar kpk ON rk.no_pemesanan=kpk.no_pemesanan where rk.status!='Y' and rk.status!='A' or rk.status!='DP'
- ORDER BY rk.no_pemesanan DESC ");
- $data_bayar=mysql_fetch_array($query);
- ?>
- <div class="bagi-3">
- <?php echo "Nomor pemesanan : ".autonumber($data_reservasi[0]['no_pemesanan'],"TRK"); ?><br>
- <?php echo "Nama pemesan : ".$data_member['nama_member']; ?><br>
- <?php echo "Alamat Lengkap : ".$data_member['alamat_lengkap']; ?><br>
- <?php echo "Kebangsaan : ".$data_member['kebangsaan']; ?><br>
- <?php echo "Tanggal_Check_in : ".tgl_indo($data_reservasi[0]['tanggal_check_in']); ?><br>
- <?php echo "Tanggal _Checkout : ".tgl_indo($data_reservasi[0]['tanggal_checkout']); ?>
- <br>
- <script>
- $(document).ready(function(){
- $("#perpanjang").click(function(){
- $("input").show();
- $("button").hide();
- $("#proses").show();
- });
- });
- </script>
- <button id="perpanjang" >Perpanjang inap kamar</button>
- <form action="" method="post">
- <input type="text" name="perpanjang"id="perpanjangancheckout"style="display:none";>
- <button id="proses" type="submit"name="prosespanjang" style="display:none"; >Proses Perpanjang</button>
- <input type="hidden" name="txtID" value="<?php echo decode_autonumber($data_reservasi[0]['no_pemesanan'],"TRK")?> ">
- <input type="hidden" name="checkoutlama" value="<?php echo tgl_indo ($data_reservasi[0]['tanggal_checkout'])?> ">
- </form>
- <?php
- error_reporting(0);
- if (isset($_POST['prosespanjang'])) {
- //echo $jumlah_hari;
- // exit();
- //$jumlah_hariperpanjangan=round(strtotime($_POST['perpanjang'])-strtotime($_POST['checkoutlama']))/86400;;
- //echo $jumlah_hariperpanjangan;
- //exit();
- $sql1="UPDATE tb_reservasi_kamar SET tanggal_checkout='".ubahformatTgl2($_POST['perpanjang'])."'";
- $sql1.="WHERE no_pemesanan=".$_POST['txtID'];
- //echo $sql1;
- //exit();
- mysql_query($sql1) or exit ("Gagal Query : ".$sql1);
- echo "<meta http-equiv='refresh' content=3;url='?page=biling.biling&kode_biling=$_GET[kode_biling]'>Berhasil Diperpanjang";
- }
- ?>
- <table border="1" >
- <thead>
- <tr>
- <th>No</th>
- <th>Nama _kamar</th>
- <th>Biaya Kamar</th>
- <th >Total biaya Layanan</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $debug='<pre>'.print_r($_REQUEST,1).'POST:'.print_r($_POST,1).'</pre>';
- $total=0;
- $total_tambahan=0;
- $total_piutang=0;
- $total_perpanjang=0;
- ?>
- <?php foreach ($data_reservasi as $no => $perkamar):?>
- <?php
- $tanggal_Awal=strtotime(ubahformatTgl2($_POST['perpanjang']));
- //echo $tanggal_Awal;
- //exit();
- $tanggal_akhir=strtotime(tgl_database($_POST['checkoutlama']));
- //echo $tanggal_akhir;
- //exit();
- $jumlah_hariperpanjangan=($tanggal_Awal-$tanggal_akhir)/86400;
- $debug.="<br>jumlah hari = $jumlah_hariperpanjangan=($tanggal_Awal-$tanggal_akhir)/86400";
- $data_kamar=detail_kamar($perkamar['no_kamar']);
- $debug.="<pre>".print_r($data_kamar,1)."</pre>";
- ?>
- <tr>
- <td><?php echo $no+1; ?></td>
- <td><?php echo $data_kamar['nama_kamar']; ?></td>
- <td><?php echo $data_kamar['harga']; ?></td>
- <td>
- <?php echo hitung_layanan_kamar($perkamar['no_kamar'],$kode_biling); ?>
- </td>
- </tr>
- <?php
- $total_perpanjang=$jumlah_hariperpanjangan*$data_kamar['harga'];
- $debug.="<hr/>total: $total_perpanjang=$jumlah_hariperpanjangan ";
- $total_piutang+=$data_bayar['total_biaya_sewa']-$data_bayar['jumlah_bayar'];
- $total_tambahan+=$tambah/100*$data_kamar['harga']; ?>
- <?php $total+=hitung_layanan_kamar($perkamar['no_kamar'],$kode_biling);?>
- <?php endforeach ?>
- <?php $total+=$total_tambahan+$total_piutang+$total_perpanjang; ?>
- </tbody>
- <tfoot>
- <tr>
- <th colspan="2">Tambahan Biaya</th>
- <th><?php echo $total_tambahan; ?></th>
- <th colspan="2">-</th>
- </tr>
- <tr>
- <th colspan="2">Piutang Dari Hotel Ke tamu</th>
- <th><?php echo $total_piutang; ?></th>
- <th colspan="2">-</th>
- </tr>
- <tr>
- <th colspan="2">Biaya Perpanjangan</th>
- <th><?php echo $total_perpanjang; ?></th>
- <th colspan="2">-</th>
- </tr>
- <tr>
- <th colspan="2">Total</th>
- <th colspan="2"><?php echo $total; ?></th>
- </tr>
- </tfoot>
- </table>
- <?php
- echo isset($debug)?$debug:'';
- if (isset($_GET['kode_biling'])AND $_SESSION['ses_admin_level']=='Receptionist') {
- ?>
- <strong>Data Tamu</strong>
- <hr></hr>
- <table border="1" width="50%" id="tampil">
- <?php
- $ambil=mysql_query("SELECT DISTINCT no_pemesanan,no_kamar,jumlah_orang,nama,alamat,tanggal_lahir,kebangsaan FROM `tb_reservasi_kamar_detail` trkd join tb_data_penghuni_kamar tdpk on tdpk.id_pemesanan_kamar_detail=trkd.id_pemesanan_kamar_detail WHERE `no_pemesanan`= '".decode_autonumber($data_reservasi[0]['no_pemesanan'],"TRK")."'");
- //print_r($ambil);
- //exit();
- while ($data=mysql_fetch_assoc($ambil)){
- //print_r($data);
- //exit();
- //$data_kamar=detail_kamar($perkamar['no_kamar']);
- ?>
- <tr>
- <td colspan="8">
- Kamar <?php echo $data['no_kamar']; ?>
- </td>
- </tr>
- <tr>
- <td>Nama</td>
- <td><input type="text" name="nama[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]" value ="<?php echo $data['nama']; ?>"readonly="readonly"></td>
- <td>Alamat</td>
- <td><textarea type="textarea" rows="10" cols="30"readonly="readonly" name="alamat[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"><?php echo $data['alamat']; ?></textarea></td>
- <td>Tanggal Lahir</td>
- <td><input type="text" readonly="readonly" name="tgl_lahir[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"value="<?php echo tgl_indo($data ['tanggal_lahir']); ?>"></td>
- <td>Kebangsaan</td>
- <td><select selected="selected" name="bangsa[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]">
- <option value ="<?php echo $data['kebangsaan'];?>" > <?php echo $data['kebangsaan'];?></option>
- </select>
- </td>
- </tr>
- <?php }; ?>
- </table>
- <br>
- <form method="post" action="">
- <input type="hidden" name="nop"value="<?php echo $kode_biling; ?>"/>
- <input type="submit"name="proses" value="CHECKOUT" />
- </form>
- <?php
- }
- ?>
- <?php
- if (isset($_POST['proses'])) {
- $que=mysql_query("UPDATE tb_reservasi_kamar SET status='CO' WHERE no_pemesanan='".decode_autonumber($_POST['nop'],"TRK")."' ");
- //echo $que;
- //exit();
- echo "<meta http-equiv='refresh' content=3;url='cetak_checkout.php?kode_biling=$kode_biling'>Berhasil checkout";}
- ?>
- <?php
- //jika yang masuk sebagai roomboy
- ?>
- <?php
- if (isset($_GET['kode_biling'])AND $_SESSION['ses_admin_level']=='Roomboy') {
- ?>
- <strong>Data Tamu</strong>
- <hr></hr>
- <table border="1" width="50%" id="tampil">
- <?php
- $ambil=mysql_query("SELECT DISTINCT no_pemesanan,no_kamar,jumlah_orang,nama,alamat,tanggal_lahir,kebangsaan FROM `tb_reservasi_kamar_detail` trkd join tb_data_penghuni_kamar tdpk on tdpk.id_pemesanan_kamar_detail=trkd.id_pemesanan_kamar_detail WHERE `no_pemesanan`= '".decode_autonumber($data_reservasi[0]['no_pemesanan'],"TRK")."'");
- //print_r($ambil);
- //exit();
- while ($data=mysql_fetch_assoc($ambil)){
- //print_r($data);
- //exit();
- //$data_kamar=detail_kamar($perkamar['no_kamar']);
- ?>
- <tr>
- <td colspan="8">
- Kamar <?php echo $data['no_kamar']; ?>
- </td>
- <td colspan="2">aksi</td>
- </tr>
- <tr>
- <td>Nama</td>
- <td><input type="text" name="nama[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]" value ="<?php echo $data['nama']; ?>"readonly="readonly"></td>
- <td>Alamat</td>
- <td><textarea type="textarea" rows="10" cols="30"readonly="readonly" name="alamat[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"><?php echo $data['alamat']; ?></textarea></td>
- <td>Tanggal Lahir</td>
- <td><input type="text" readonly="readonly" name="tgl_lahir[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"value="<?php echo tgl_indo($data ['tanggal_lahir']); ?>"></td>
- <td>Kebangsaan</td>
- <td><select selected="selected" name="bangsa[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]">
- <option value ="<?php echo $data['kebangsaan'];?>" > <?php echo $data['kebangsaan'];?></option>
- </select>
- </td>
- <td><a href="?page=biling.tambah_layanan&no_kamar=<?php echo $data['no_kamar'];?>&nop=<?php echo $kode_biling;?>">Tambah Layanan</a>
- <td><a href="?page=biling.detail_layanan&no_kamar=<?php echo $data['no_kamar'];?>&nop=<?php echo $kode_biling;?>">Detail</a></td>
- </tr>
- <?php }; ?>
- </table>
- <br>
- <form method="post" action="">
- <input type="hidden" name="nop"value="<?php echo $kode_biling; ?>"/>
- <input type="submit"name="proses" value="CHECKOUT" disabled="disabled" />
- </form>
- <?php
- }
- ?>
- <?php
- if (isset($_POST['proses'])) {
- $que=mysql_query("UPDATE tb_reservasi_kamar SET status='CO' WHERE no_pemesanan='".decode_autonumber($_POST['nop'],"TRK")."' ");
- //echo $que;
- //exit();
- echo "<meta http-equiv='refresh' content=3;url='cetak_checkout.php?kode_biling=$kode_biling'>Berhasil checkout";}
- ?>
- <?php //------------------ ?>
- </div>
- <br>
- <?php else:
- if (empty($_GET['kode_biling']) AND $_SESSION['ses_admin_level']=='Receptionist') {
- ?>
- <?php if ($checked != 1 AND $checked !=2 AND $checked !=3): ?>
- <h4>List Transaksi Check_in</h4>
- <hr></hr>
- Cari Berdasarkan Nama penghuni kamar
- <hr></hr>
- <form method="post" action='?page=biling.hasil_cari'>
- <label>Nama Penghuni </label><input type="text"name="nama"required="required" /> <br>
- <button type="submit" name="cari">Cari</button>
- </form>
- <div class="clear"></div>
- <table border="1">
- <thead>
- <th>No.</th>
- <th>No.Pemesanan</th>
- <th>Nama Pemesan</th>
- <th>Alamat</th>
- <th>Kebangsaan</th>
- <th>Tanggal_checkin</th>
- <th>Tanggal_checkout</th>
- <th colspan="2">Aksi</th>
- </thead>
- <tbody>
- <?php ;
- $dataPerPage = 2;
- // apabila $_GET['page'] sudah didefinisikan, gunakan nomor halaman tersebut,
- // sedangkan apabila belum, nomor halamannya 1.
- if(isset($_GET['halaman']))
- {
- $noPage = $_GET['halaman'];
- }
- else $noPage = 1;
- // perhitungan offset
- $offset = ($noPage - 1) * $dataPerPage;
- $no=$offset+1;
- ?>
- <?php foreach (tampil_reservasi_kamar($offset,$dataPerPage) as $reservasi){ ?>
- <?php
- $data_member=detail_member($reservasi['id_member']);
- ?>
- <tr>
- <td><?php echo $no++; ?></td>
- <td><?php echo autonumber($reservasi['no_pemesanan'],"TRK"); ?></td>
- <td><?php echo $data_member['nama_member']; ?></td>
- <td><?php echo $data_member['alamat_lengkap']; ?></td>
- <td><?php echo $data_member['kebangsaan']; ?></td>
- <td><?php echo tgl_indo($reservasi['tanggal_check_in']); ?></td>
- <td><?php echo tgl_indo($reservasi['tanggal_checkout']); ?></td>
- <td><a href="cetak_laporan.php?kode_biling=<?php echo decode_autonumber($reservasi['no_pemesanan'],"TRK")?>">Cetak</a></td>
- <td><a href="?page=biling.biling&kode_biling=<?php echo autonumber($reservasi['no_pemesanan'],"TRK")?>">Detail</a></td>
- </tr>
- <?php
- }
- ?>
- </tbody>
- </table>
- <?php
- // mencari jumlah semua data dalam tabel admin
- $query = "SELECT COUNT(*) as jumData FROM tb_reservasi_kamar where status='A'";
- $hasil = mysql_query($query);
- $data = mysql_fetch_array($hasil);
- $jumData = $data['jumData'];
- $jumPage = ceil($jumData/$dataPerPage);
- echo "<div id='paging'>";
- // menampilkan link previous
- echo "Pages (".$jumPage.") : ";
- if ($noPage > 1) echo "<a class='page' href='?page=biling.biling&halaman=".($noPage-1)."'><< Prev</a>";
- // memunculkan nomor halaman dan linknya
- $showPage=0;
- for($page = 1; $page <= $jumPage; $page++)
- {
- if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $jumPage))
- {
- if (($showPage == 1) && ($page != 2))
- echo "...";
- if (($showPage != ($jumPage - 1)) && ($page == $jumPage))
- echo "...";
- if ($page == $noPage)
- echo " <b>".$page."</b> ";
- else
- echo " <a class='page' href='?page=biling.biling&halaman=".$page."'>".$page."</a> ";
- $showPage = $page;
- }
- }
- // menampilkan link next
- if ($noPage < $jumPage) echo "<a class='page' href='?page=biling.biling&halaman=".($noPage+1)."'>Next >></a>";
- echo "</div>";?>
- <?php endif ?>
- <?php }; endif ?>
- <?php //jika masuk roomboy
- if (empty($_GET['kode_biling'])AND $_SESSION['ses_admin_level']=='Roomboy') {
- ?>
- <?php
- $checked = isset($_GET['checked']) ? $_GET['checked'] : '';
- if ($checked != 1 AND $checked !=2 AND $checked !=3): ?>
- <h4>List Transaksi Check_in</h4>
- <hr></hr>
- Cari Berdasarkan Nama penghuni kamar
- <hr></hr>
- <form method="post" action='?page=biling.hasil_cari'>
- <label>Nama Penghuni </label><input type="text"name="nama"required="required" /> <br>
- <button type="submit" name="cari">Cari</button>
- </form>
- <div class="clear"></div>
- <table border="1">
- <thead>
- <th>No.</th>
- <th>No.Pemesanan</th>
- <th>Nama Pemesan</th>
- <th>Alamat</th>
- <th>Kebangsaan</th>
- <th>Tanggal_checkin</th>
- <th>Tanggal_checkout</th>
- <th colspan="2">Aksi</th>
- </thead>
- <tbody>
- <?php ;
- $dataPerPage = 2;
- // apabila $_GET['page'] sudah didefinisikan, gunakan nomor halaman tersebut,
- // sedangkan apabila belum, nomor halamannya 1.
- if(isset($_GET['halaman']))
- {
- $noPage = $_GET['halaman'];
- }
- else $noPage = 1;
- // perhitungan offset
- $offset = ($noPage - 1) * $dataPerPage;
- $no=$offset+1;
- ?>
- <?php foreach (tampil_reservasi_kamar($offset,$dataPerPage) as $reservasi){ ?>
- <?php
- $data_member=detail_member($reservasi['id_member']);
- ?>
- <tr>
- <td><?php echo $no++; ?></td>
- <td><?php echo autonumber($reservasi['no_pemesanan'],"TRK"); ?></td>
- <td><?php echo $data_member['nama_member']; ?></td>
- <td><?php echo $data_member['alamat_lengkap']; ?></td>
- <td><?php echo $data_member['kebangsaan']; ?></td>
- <td><?php echo tgl_indo($reservasi['tanggal_check_in']); ?></td>
- <td><?php echo tgl_indo($reservasi['tanggal_checkout']); ?></td>
- <td><a href="?page=biling.biling&kode_biling=<?php echo autonumber($reservasi['no_pemesanan'],"TRK")?>">Detail</a></td>
- </tr>
- <?php
- }
- ?>
- </tbody>
- </table>
- <?php
- // mencari jumlah semua data dalam tabel admin
- $query = "SELECT COUNT(*) as jumData FROM tb_reservasi_kamar where status='A'";
- $hasil = mysql_query($query);
- $data = mysql_fetch_array($hasil);
- $jumData = $data['jumData'];
- $jumPage = ceil($jumData/$dataPerPage);
- echo "<div id='paging'>";
- // menampilkan link previous
- echo "Pages (".$jumPage.") : ";
- if ($noPage > 1) echo "<a class='page' href='?page=biling.biling&halaman=".($noPage-1)."'><< Prev</a>";
- // memunculkan nomor halaman dan linknya
- $showPage=0;
- for($page = 1; $page <= $jumPage; $page++)
- {
- if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $jumPage))
- {
- if (($showPage == 1) && ($page != 2))
- echo "...";
- if (($showPage != ($jumPage - 1)) && ($page == $jumPage))
- echo "...";
- if ($page == $noPage)
- echo " <b>".$page."</b> ";
- else
- echo " <a class='page' href='?page=biling.biling&halaman=".$page."'>".$page."</a> ";
- $showPage = $page;
- }
- }
- // menampilkan link next
- if ($noPage < $jumPage) echo "<a class='page' href='?page=biling.biling&halaman=".($noPage+1)."'>Next >></a>";
- echo "</div>";?>
- <?php endif ?>
- <?php }; //endif; ?>
- </div>
- <!-- Endof tabel -->
- <div style="display:none;" id="pernah_pesan">
- <form action="?page=biling.biling&checked=1" method="post">
- <label>Masukan kode pemesanan</label>
- <input type="text" name="kode" required="required"value="TRK" />
- <br></br>
- <input type="submit" name="proses" value="cek kode" >
- <br><br>
- </form>
- </div>
- <?php
- if (isset($_POST['kode'])) {
- $cek_kode=mysql_query("SELECT * from tb_reservasi_kamar tr join tb_reservasi_kamar_detail trk on tr.no_pemesanan=trk.no_pemesanan where tr.status='A' and tr.no_pemesanan='".decode_autonumber($_POST['kode'],"TRK")."'");
- if(mysql_num_rows($cek_kode)>0){
- echo "<script> alert('Kode Pemesanan Tersebut sudah melakukan Checkin'); location='?page=biling.biling';</script>";
- exit();
- }
- //print_r(decode_autonumber($_POST['kode'],"TRK")); exit();
- ?>
- <div id="laporan1">
- <br>
- <hr></hr>
- <strong>KONFIRMASI CHECKIN</strong>
- <hr></hr>
- <?php
- $data_reservasi=detail_reservasi_kamar (decode_autonumber(antihtml($_POST['kode']),"TRK"));
- $data_member=detail_member($data_reservasi[0]['id_member']);
- $jumlah_hari=round((strtotime($data_reservasi[0]['tanggal_checkout'])-strtotime($data_reservasi[0]['tanggal_check_in']))/86400);
- $total_seluruh=0;
- $co=strtotime($data_reservasi[0]['tanggal_checkout']);
- $ci=strtotime($data_reservasi[0]['tanggal_check_in']);
- if (time()>$co) {
- echo "<script> alert('Maaf Anda terlambat Checkin'); location='?page=biling.biling';</script>";
- exit();
- }
- if (time()<$ci) {
- echo "<script> alert('Maaf Anda Belum saatnya Checkin'); location='?page=biling.biling';</script>";
- exit();
- }
- ?>
- <form id="checkin" method="post" action="?page=biling.biling&checked=1">
- <div class="bagi-2-3" id="laporan1">
- <strong>Transaksi Pemesanan Pernah Dilakukan Oleh: </strong>
- <table border="1" width="100%">
- <tr>
- <td>
- <?php echo "NO KTP : ".$data_member['id_member']; ?><br>
- <?php echo "Nama pemesan : ".$data_member['nama_member']; ?><br>
- <?php echo "Alamat Lengkap : ".$data_member['alamat_lengkap']; ?><br>
- <?php echo "Kebangsaan : ".$data_member['kebangsaan']; ?><br>
- </td>
- </tr>
- </table>
- <br>
- <strong>Untuk memesan</strong>
- <table border="1" width="100%" >
- <?php foreach ($data_reservasi as $reserv):
- ?>
- <tr>
- <td width="53%">
- <?php
- $data_kamar=detail_kamar($reserv['no_kamar']);
- $total_seluruh+=($data_kamar['harga']*$jumlah_hari);
- ?>
- <?php echo "Nama Kamar : ".$data_kamar['nama_kamar']; ?><br>
- <?php echo "Tipe Kamar : ".$data_kamar['nama_tipe_kamar']; ?><br>
- <?php echo "Harga : ".$data_kamar['harga']; ?><br>
- </td>
- <td width="10%"><select name="jumlah[<?php echo $reserv['no_kamar'] ?>]" >
- <option value="'<?php echo $reserv['jumlah_orang']; ?>'"><?php echo $reserv['jumlah_orang']; ?> orang</option>
- </select>
- </td>
- </tr>
- <?php endforeach; ?>
- </table>
- <div id="judul_tabel" style="display:none;">
- <strong>Data Tamu</strong>
- <hr></hr>
- </div>
- <table border="1" width="50%" id="tampil">
- <?php
- $ambil=mysql_query("SELECT * FROM `tb_reservasi_kamar_detail` WHERE `no_pemesanan`= '".decode_autonumber($_POST['kode'],"TRK")."'");
- //print_r($ambil)
- //exit();
- while ($data=mysql_fetch_assoc($ambil)){
- ?>
- <tr>
- <td colspan="8">
- Kamar <?php echo $data['no_kamar']; ?>
- </td>
- </tr>
- <?php for($i=1; $i<= $data['jumlah_orang']; $i++){ ?>
- <tr>
- <td>Nama</td>
- <td><input type="text" name="nama[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"></td>
- <td>Alamat</td>
- <td><textarea type="textarea" rows="10" cols="30" name="alamat[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"></textarea></td>
- <td>Tanggal Lahir</td>
- <td><input type="date" name="tgl_lahir[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"></td>
- <td>Kebangsaan</td>
- <td><select name="bangsa[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]">
- <?php foreach ($countries as $idn => $country): ?>
- <option value ="<?php echo $country;?>" > <?php echo $country;?></option>
- <?php endforeach ?>
- </select>
- </td>
- </tr>
- <?php } ?>
- <?php
- }
- ?>
- </table>
- <br>
- <table border="1"width="100%">
- <tr>
- <td>
- <input type="hidden" name="nop" value="<?php echo $_POST['kode']; ?>"/>
- <input type="hidden" name="no_ktp" value="<?php echo $data_member['id_member']; ?>">
- <label>Tanggal Check In</label><input type="text" value="<?php echo tgl_indo($data_reservasi['0']['tanggal_check_in']); ?>" readonly="readonly" name="ci">
- <label>Tanggal Check Out</label><input type="text" value="<?php echo tgl_indo($data_reservasi['0']['tanggal_checkout']); ?>" readonly="readonly" name="co">
- <label>lama</label><?php echo $jumlah_hari. " Malam ";?><br>
- <label>Biaya Pemesanan</label><input type="text"name="total"value="<?php echo $total_seluruh ?>" readonly="readonly"><br>
- </td>
- </tr>
- </table>
- <input type="hidden" name="ci" value="<?php echo $data_reservasi['0']['tanggal_check_in']; ?> "/>
- <input type="hidden" name="co" value="<?php echo $data_reservasi['0']['tanggal_checkout']; ?> "/>
- <button type="submit" name="simpan" id="save" onclick="myFunction();" class="hidden-print">Simpan</button>
- </div>
- </form>
- <?php
- }
- ?>
- </div>
- <div class="clear"></div>
- <!----=============================--
- Jika Orang yang datang hanya memesan kamar maka :-->
- <div style="display:none;" id="hanya_pesan">
- <h4>CEK KETERSEDIAAN KAMAR</h4>
- <hr></hr>
- <?php if ($checked != 1 AND $checked !=2 AND $checked !=3): ?>
- <form action="" name ="cek_ketersediaan" method="post">
- <label>Tanggal_check_in</label>
- <input type="text" name="checkin" id="check_in"required="required">
- <label>Tanggal Check out</label>
- <input type="text" name="checkout" id="check_out" required="required">
- <br>
- <button type="submit">Check</button>
- </form>
- <script language='javascript'>
- function validAngka(a)
- {
- if(!/^[0-9.]+$/.test(a.value))
- {
- a.value = a.value.substring(0,a.value.length-1000);
- }
- }
- </script>
- <style>
- textarea {
- resize: none;
- }
- </style>
- <?php
- //fungsi menampilkan kamar yang tersedia
- //proses pengecekan kamar
- if(isset($_POST['checkin']))
- {
- $tgl_check_in=ubahformatTgl2($_POST['checkin']);
- $tgl_checkout=ubahformatTgl2($_POST['checkout']);
- $ambil = mysql_query("SELECT * FROM tb_kamar
- WHERE
- no_kamar NOT IN(SELECT k.no_kamar FROM tb_kamar k JOIN
- tb_reservasi_kamar_detail rkd ON rkd.no_kamar = k.no_kamar JOIN
- tb_reservasi_kamar rk ON rk.no_pemesanan=rkd.no_pemesanan
- WHERE
- '$tgl_check_in' BETWEEN rk.tanggal_check_in
- AND
- rk.tanggal_checkout OR '$tgl_checkout'
- BETWEEN
- rk.tanggal_check_in AND
- rk.tanggal_checkout)");
- //echo mysql_error();
- //exit();
- if (mysql_num_rows($ambil)>0){
- ?>
- <form method="post" action="">
- <input type="hidden"name="check_in" value="<?php echo $tgl_check_in; ?>">
- <input type="hidden"name="check_out" value="<?php echo $tgl_checkout; ?>">
- <?php
- while($data=mysql_fetch_assoc($ambil))
- {
- $data_kamar=detail_kamar($data['no_kamar']);
- ?>
- <div class="bagi-4">
- <!--
- -->
- <img src="../image/kamar/<?php echo $data_kamar['foto']; ?>" class="responsive">
- Nama Kamar : <?php echo $data_kamar['nama_kamar']; ?><br>
- Harga Sewa : <?php echo $data_kamar['harga'];?><br>
- Tipe Kamar : <?php echo $data_kamar['nama_tipe_kamar']; ?><br>
- <input type="checkbox" name="kamar[]" value="<?php echo $data_kamar['no_kamar'];?> " />PILIH KAMAR
- </div>
- <?php
- }
- ?>
- <div class="clear"></div><br>
- <center><button type="submit" name="lanjutkan_konfirmasi" align="right" style="float:left;";>lanjut</button></center>
- </form>
- <?php
- }else{
- echo "kamar tidak ada yang tersedia";
- }
- ?>
- <?php
- }
- else if(isset($_POST['kamar']))
- {
- pesan_kamar($_POST['kamar']);
- ?>
- <div class="bagi-3">
- <h4>Apakah Tamu Tersebut Sudah Terdaftar Sebelumnya ?</h4>
- <hr></hr>
- <form method="post" action='?page=reservasi_kamar_langsung.konfirmasi'>
- <input type="hidden"name="check_in" value="<?php echo $_POST['check_in']; ?>">
- <input type="hidden"name="check_out" value="<?php echo $_POST['check_out']; ?>">
- <input type="hidden" name="terdaftar" value="benar">
- <label> Masukan Nomor KTP</label>
- <br>
- <input type="text" name="no_ktp" maxlength="16" onkeyup="validAngka(this);"/>
- <br>
- <button type="submit">Lanjut</button>
- </form>
- </div>
- <div class="bagi-2-3" style="border-left:1px dotted green;">
- <h4>Daftarkan Tamu Baru</h4>
- <hr></hr>
- <form action='?page=reservasi_kamar_langsung.konfirmasi' method="post">
- <input type="hidden"name="check_in" value="<?php echo $_POST['check_in']; ?>">
- <input type="hidden"name="check_out" value="<?php echo $_POST['check_out']; ?>">
- <div class="bagi-2">
- <label>No KTP</label>
- <input type="text" name="no_ktp" maxlength="16" onkeyup="validAngka(this);" />
- <label>NAMA</label>
- <input type="text" name="nama"/>
- <label>EMAIL</label>
- <input type="email" name="email"/>
- <label>USERNAME</label>
- <input type="text" name="username"/>
- <label>PASSWORD</label>
- <input type="password" name="pass"/>
- <label>TANGGAL_LAHIR</label>
- <input type="text" name="tgllahir" id="tgllahir"/>
- </div>
- <div class="bagi-2">
- <label>TEMPAT LAHIR</label>
- <input type="text" name="tempat_lahir"/>
- <label>ALAMAT</label>
- <textarea name="alamat" width="900" cols="35" rows="5"></textarea>
- <label>KEBANGSAAN</label>
- <select name="kebangsaan">
- <?php foreach ($countries as $idn => $country): ?>
- <option value ="<?php echo $country;?>" > <?php echo $country;?></option>
- <?php endforeach ?>
- </select>
- </div>
- <div class="clear"></div>
- <div class="bagi-3">
- <button type="submit" name="lanjutkan" >Lanjut</button>
- </div>
- </form>
- </div>
- <?php
- }
- ?>
- <?php endif; ?>
- <div class="clear"></div>
- <!-- Apabila tamu datang langsung tanpa pesan dan langsung mau checkin kamar -->
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement