SHOW:
|
|
- or go back to the newest paste.
1 | <?php | |
2 | ?> | |
3 | <style type="text/css"> | |
4 | textarea{ | |
5 | resize:none; | |
6 | } | |
7 | </style> | |
8 | <style type="text/css"> | |
9 | a#cl:link {background: #FFCC00; text-decoration: none} | |
10 | a#cl:visited {background: #FFCC00; text-decoration: none} | |
11 | a#cl:active {background: #FFCC00; text-decoration: none} | |
12 | a#cl:hover {background: #fff; font-weight:bold; color: black;} | |
13 | </style> | |
14 | <script type="text/javascript"> | |
15 | ||
16 | $(document).ready(function(){ | |
17 | $('input:radio[name=cek]').change(function(){ | |
18 | if(this.value=='sudah'){ | |
19 | $('#pernah_pesan').show(); | |
20 | $('#hanya_pesan').hide(); | |
21 | ||
22 | $('#list').hide(); | |
23 | } | |
24 | else if(this.value=='hanya_pesan'){ | |
25 | ||
26 | $('#hanya_pesan').show(); | |
27 | $('#pernah_pesan').hide(); | |
28 | $('#laporan1').hide(); | |
29 | ||
30 | $('#list').hide(); | |
31 | ||
32 | } | |
33 | else if(this.value=='belum'){ | |
34 | ||
35 | $('#hanya_pesan').hide(); | |
36 | $('#pernah_pesan').hide(); | |
37 | $('#laporan1').hide(); | |
38 | ||
39 | $('#list').hide(); | |
40 | ||
41 | } | |
42 | }); | |
43 | ||
44 | ||
45 | ||
46 | }); | |
47 | ||
48 | function myFunction() { | |
49 | ||
50 | ||
51 | document.getElementById("simpan").disabled = true; | |
52 | document.getElementById("laporan1").show(); | |
53 | ||
54 | } | |
55 | ||
56 | </script> | |
57 | <?php | |
58 | if (isset($_POST['nama'])) { | |
59 | // update status | |
60 | mysql_query("UPDATE tb_reservasi_kamar SET status='A' WHERE no_pemesanan='".decode_autonumber($_POST['nop'],"TRK")."'"); | |
61 | foreach ($_POST['nama'] as $irpd => $nama) { | |
62 | foreach ($nama as $key => $nama2) { | |
63 | 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]."')"); | |
64 | echo "<meta http-equiv='refresh' content=3;url='?page=biling.biling'>Berhasil"; | |
65 | } | |
66 | } | |
67 | echo "<script> | |
68 | ||
69 | simpan.disabled=true; | |
70 | list.hide(); | |
71 | laporan1.show(); | |
72 | myFunction(); | |
73 | </script>"; | |
74 | } | |
75 | ?> | |
76 | <?php | |
77 | if (empty($_GET['kode_biling'])AND $_SESSION['ses_admin_level']!='Roomboy') : | |
78 | ?> | |
79 | <h4>Transaksi Check_in</h4> | |
80 | <hr></hr> | |
81 | Proses checkin kamar | |
82 | <hr></hr> | |
83 | <form method="post" action=""> | |
84 | ||
85 | <h3>Apakah Sudah Pernah Pesan</h3> | |
86 | <?php | |
87 | $checked = isset($_GET['checked']) ? $_GET['checked'] : ''; | |
88 | ?> | |
89 | <input <?php if($checked=='1'){ echo "checked"; } ?> id="reserved" type="radio"name="cek" value="sudah" >Sudah Pesan,Akan Checkin | |
90 | <input <?php if($checked=='3'){ echo "checked"; } ?> id="onlypesan" type="radio"name="cek" value="hanya_pesan" >Hanya Pesan | |
91 | <img src="../image/log_in.ico" height="20px"><a id="cl" href='?page=biling.checkin_langsung'>Langsung checkin</a> | |
92 | ||
93 | </form> | |
94 | <?php endif; ?> | |
95 | <!-- melihat tabel transaksi checkin kamar --> | |
96 | <div id="list"> | |
97 | ||
98 | ||
99 | <?php if(isset($_GET['kode_biling'])): ?> | |
100 | <?php | |
101 | $kode_biling=antihtml(decode_autonumber($_GET['kode_biling'],"TRK")); | |
102 | //print_r($kode_biling); exit; | |
103 | $data_reservasi=detail_reservasi_kamar($kode_biling); | |
104 | $data_member=detail_member($data_reservasi[0]['id_member']); | |
105 | ||
106 | //print_r($data_reservasi); | |
107 | $sekarang=date('Y-m-d H:i:s'); | |
108 | $comax12=$data_reservasi[0]['tanggal_checkout'].' 12:00:00'; | |
109 | $comax17=$data_reservasi[0]['tanggal_checkout'].' 17:00:00'; | |
110 | ||
111 | //mengetahui detik berjalan | |
112 | $detik_sekarang=strtotime($sekarang); | |
113 | $detik_kcomax12=strtotime($comax12); | |
114 | $detik_comax17=strtotime($comax17); | |
115 | ||
116 | if($detik_sekarang>$detik_kcomax12 AND $detik_sekarang < $detik_comax17){ | |
117 | $tambah=50; | |
118 | }else if( $detik_sekarang > $detik_comax17){ | |
119 | $tambah=100; | |
120 | }else | |
121 | { | |
122 | $tambah=0; | |
123 | } | |
124 | ?> | |
125 | <?php | |
126 | $query= mysql_query("SELECT * FROM tb_reservasi_kamar rk | |
127 | 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' | |
128 | ORDER BY rk.no_pemesanan DESC "); | |
129 | $data_bayar=mysql_fetch_array($query); | |
130 | ?> | |
131 | <div class="bagi-3"> | |
132 | ||
133 | <?php echo "Nomor pemesanan : ".autonumber($data_reservasi[0]['no_pemesanan'],"TRK"); ?><br> | |
134 | <?php echo "Nama pemesan : ".$data_member['nama_member']; ?><br> | |
135 | <?php echo "Alamat Lengkap : ".$data_member['alamat_lengkap']; ?><br> | |
136 | <?php echo "Kebangsaan : ".$data_member['kebangsaan']; ?><br> | |
137 | <?php echo "Tanggal_Check_in : ".tgl_indo($data_reservasi[0]['tanggal_check_in']); ?><br> | |
138 | <?php echo "Tanggal _Checkout : ".tgl_indo($data_reservasi[0]['tanggal_checkout']); ?> | |
139 | ||
140 | <br> | |
141 | <script> | |
142 | $(document).ready(function(){ | |
143 | $("#perpanjang").click(function(){ | |
144 | $("input").show(); | |
145 | $("button").hide(); | |
146 | $("#proses").show(); | |
147 | ||
148 | }); | |
149 | ||
150 | }); | |
151 | </script> | |
152 | <button id="perpanjang" >Perpanjang inap kamar</button> | |
153 | <form action="" method="post"> | |
154 | ||
155 | <input type="text" name="perpanjang"id="perpanjangancheckout"style="display:none";> | |
156 | <button id="proses" type="submit"name="prosespanjang" style="display:none"; >Proses Perpanjang</button> | |
157 | <input type="hidden" name="txtID" value="<?php echo decode_autonumber($data_reservasi[0]['no_pemesanan'],"TRK")?> "> | |
158 | <input type="hidden" name="checkoutlama" value="<?php echo tgl_indo ($data_reservasi[0]['tanggal_checkout'])?> "> | |
159 | ||
160 | </form> | |
161 | <?php | |
162 | error_reporting(0); | |
163 | if (isset($_POST['prosespanjang'])) { | |
164 | //echo $jumlah_hari; | |
165 | // exit(); | |
166 | //$jumlah_hariperpanjangan=round(strtotime($_POST['perpanjang'])-strtotime($_POST['checkoutlama']))/86400;; | |
167 | //echo $jumlah_hariperpanjangan; | |
168 | //exit(); | |
169 | $sql1="UPDATE tb_reservasi_kamar SET tanggal_checkout='".ubahformatTgl2($_POST['perpanjang'])."'"; | |
170 | $sql1.="WHERE no_pemesanan=".$_POST['txtID']; | |
171 | //echo $sql1; | |
172 | //exit(); | |
173 | mysql_query($sql1) or exit ("Gagal Query : ".$sql1); | |
174 | echo "<meta http-equiv='refresh' content=3;url='?page=biling.biling&kode_biling=$_GET[kode_biling]'>Berhasil Diperpanjang"; | |
175 | } | |
176 | ?> | |
177 | <table border="1" > | |
178 | ||
179 | ||
180 | <thead> | |
181 | <tr> | |
182 | <th>No</th> | |
183 | <th>Nama _kamar</th> | |
184 | <th>Biaya Kamar</th> | |
185 | <th >Total biaya Layanan</th> | |
186 | ||
187 | ||
188 | </tr> | |
189 | </thead> | |
190 | <tbody> | |
191 | <?php | |
192 | - | $debug=''; |
192 | + | $debug='<pre>'.print_r($_REQUEST,1).'POST:'.print_r($_POST,1).'</pre>'; |
193 | $total=0; | |
194 | $total_tambahan=0; | |
195 | $total_piutang=0; | |
196 | $total_perpanjang=0; | |
197 | ?> | |
198 | <?php foreach ($data_reservasi as $no => $perkamar):?> | |
199 | <?php | |
200 | $tanggal_Awal=strtotime(ubahformatTgl2($_POST['perpanjang'])); | |
201 | //echo $tanggal_Awal; | |
202 | //exit(); | |
203 | $tanggal_akhir=strtotime(tgl_database($_POST['checkoutlama'])); | |
204 | //echo $tanggal_akhir; | |
205 | //exit(); | |
206 | $jumlah_hariperpanjangan=($tanggal_Awal-$tanggal_akhir)/86400; | |
207 | $debug.="<br>jumlah hari = $jumlah_hariperpanjangan=($tanggal_Awal-$tanggal_akhir)/86400"; | |
208 | $data_kamar=detail_kamar($perkamar['no_kamar']); | |
209 | $debug.="<pre>".print_r($data_kamar,1)."</pre>"; | |
210 | ?> | |
211 | <tr> | |
212 | <td><?php echo $no+1; ?></td> | |
213 | <td><?php echo $data_kamar['nama_kamar']; ?></td> | |
214 | <td><?php echo $data_kamar['harga']; ?></td> | |
215 | <td> | |
216 | <?php echo hitung_layanan_kamar($perkamar['no_kamar'],$kode_biling); ?> | |
217 | </td> | |
218 | ||
219 | </tr> | |
220 | <?php | |
221 | $total_perpanjang=$jumlah_hariperpanjangan*$data_kamar['harga']; | |
222 | $debug.="<hr/>total: $total_perpanjang=$jumlah_hariperpanjangan "; | |
223 | $total_piutang+=$data_bayar['total_biaya_sewa']-$data_bayar['jumlah_bayar']; | |
224 | $total_tambahan+=$tambah/100*$data_kamar['harga']; ?> | |
225 | <?php $total+=hitung_layanan_kamar($perkamar['no_kamar'],$kode_biling);?> | |
226 | <?php endforeach ?> | |
227 | <?php $total+=$total_tambahan+$total_piutang+$total_perpanjang; ?> | |
228 | </tbody> | |
229 | <tfoot> | |
230 | <tr> | |
231 | ||
232 | <th colspan="2">Tambahan Biaya</th> | |
233 | <th><?php echo $total_tambahan; ?></th> | |
234 | <th colspan="2">-</th> | |
235 | </tr> | |
236 | <tr> | |
237 | ||
238 | <th colspan="2">Piutang Dari Hotel Ke tamu</th> | |
239 | <th><?php echo $total_piutang; ?></th> | |
240 | <th colspan="2">-</th> | |
241 | </tr> | |
242 | <tr> | |
243 | ||
244 | <th colspan="2">Biaya Perpanjangan</th> | |
245 | <th><?php echo $total_perpanjang; ?></th> | |
246 | <th colspan="2">-</th> | |
247 | </tr> | |
248 | <tr> | |
249 | ||
250 | <th colspan="2">Total</th> | |
251 | <th colspan="2"><?php echo $total; ?></th> | |
252 | ||
253 | </tr> | |
254 | ||
255 | </tfoot> | |
256 | ||
257 | </table> | |
258 | <?php | |
259 | echo isset($debug)?$debug:''; | |
260 | if (isset($_GET['kode_biling'])AND $_SESSION['ses_admin_level']=='Receptionist') { | |
261 | ?> | |
262 | ||
263 | <strong>Data Tamu</strong> | |
264 | <hr></hr> | |
265 | ||
266 | <table border="1" width="50%" id="tampil"> | |
267 | <?php | |
268 | $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")."'"); | |
269 | //print_r($ambil); | |
270 | //exit(); | |
271 | while ($data=mysql_fetch_assoc($ambil)){ | |
272 | //print_r($data); | |
273 | //exit(); | |
274 | //$data_kamar=detail_kamar($perkamar['no_kamar']); | |
275 | ?> | |
276 | ||
277 | <tr> | |
278 | <td colspan="8"> | |
279 | Kamar <?php echo $data['no_kamar']; ?> | |
280 | </td> | |
281 | ||
282 | </tr> | |
283 | <tr> | |
284 | <td>Nama</td> | |
285 | <td><input type="text" name="nama[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]" value ="<?php echo $data['nama']; ?>"readonly="readonly"></td> | |
286 | <td>Alamat</td> | |
287 | <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> | |
288 | <td>Tanggal Lahir</td> | |
289 | <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> | |
290 | <td>Kebangsaan</td> | |
291 | <td><select selected="selected" name="bangsa[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"> | |
292 | <option value ="<?php echo $data['kebangsaan'];?>" > <?php echo $data['kebangsaan'];?></option> | |
293 | ||
294 | ||
295 | </select> | |
296 | </td> | |
297 | ||
298 | </tr> | |
299 | <?php }; ?> | |
300 | ||
301 | ||
302 | </table> | |
303 | <br> | |
304 | ||
305 | ||
306 | <form method="post" action=""> | |
307 | <input type="hidden" name="nop"value="<?php echo $kode_biling; ?>"/> | |
308 | <input type="submit"name="proses" value="CHECKOUT" /> | |
309 | </form> | |
310 | <?php | |
311 | } | |
312 | ?> | |
313 | <?php | |
314 | if (isset($_POST['proses'])) { | |
315 | $que=mysql_query("UPDATE tb_reservasi_kamar SET status='CO' WHERE no_pemesanan='".decode_autonumber($_POST['nop'],"TRK")."' "); | |
316 | //echo $que; | |
317 | //exit(); | |
318 | echo "<meta http-equiv='refresh' content=3;url='cetak_checkout.php?kode_biling=$kode_biling'>Berhasil checkout";} | |
319 | ?> | |
320 | <?php | |
321 | //jika yang masuk sebagai roomboy | |
322 | ||
323 | ?> | |
324 | <?php | |
325 | if (isset($_GET['kode_biling'])AND $_SESSION['ses_admin_level']=='Roomboy') { | |
326 | ?> | |
327 | ||
328 | <strong>Data Tamu</strong> | |
329 | <hr></hr> | |
330 | ||
331 | <table border="1" width="50%" id="tampil"> | |
332 | <?php | |
333 | $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")."'"); | |
334 | //print_r($ambil); | |
335 | //exit(); | |
336 | while ($data=mysql_fetch_assoc($ambil)){ | |
337 | //print_r($data); | |
338 | //exit(); | |
339 | //$data_kamar=detail_kamar($perkamar['no_kamar']); | |
340 | ?> | |
341 | ||
342 | <tr> | |
343 | <td colspan="8"> | |
344 | Kamar <?php echo $data['no_kamar']; ?> | |
345 | </td> | |
346 | <td colspan="2">aksi</td> | |
347 | </tr> | |
348 | <tr> | |
349 | <td>Nama</td> | |
350 | <td><input type="text" name="nama[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]" value ="<?php echo $data['nama']; ?>"readonly="readonly"></td> | |
351 | <td>Alamat</td> | |
352 | <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> | |
353 | <td>Tanggal Lahir</td> | |
354 | <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> | |
355 | <td>Kebangsaan</td> | |
356 | <td><select selected="selected" name="bangsa[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"> | |
357 | <option value ="<?php echo $data['kebangsaan'];?>" > <?php echo $data['kebangsaan'];?></option> | |
358 | ||
359 | ||
360 | </select> | |
361 | </td> | |
362 | <td><a href="?page=biling.tambah_layanan&no_kamar=<?php echo $data['no_kamar'];?>&nop=<?php echo $kode_biling;?>">Tambah Layanan</a> | |
363 | <td><a href="?page=biling.detail_layanan&no_kamar=<?php echo $data['no_kamar'];?>&nop=<?php echo $kode_biling;?>">Detail</a></td> | |
364 | ||
365 | </tr> | |
366 | <?php }; ?> | |
367 | ||
368 | ||
369 | </table> | |
370 | <br> | |
371 | ||
372 | ||
373 | <form method="post" action=""> | |
374 | <input type="hidden" name="nop"value="<?php echo $kode_biling; ?>"/> | |
375 | <input type="submit"name="proses" value="CHECKOUT" disabled="disabled" /> | |
376 | </form> | |
377 | <?php | |
378 | } | |
379 | ?> | |
380 | <?php | |
381 | if (isset($_POST['proses'])) { | |
382 | $que=mysql_query("UPDATE tb_reservasi_kamar SET status='CO' WHERE no_pemesanan='".decode_autonumber($_POST['nop'],"TRK")."' "); | |
383 | //echo $que; | |
384 | //exit(); | |
385 | echo "<meta http-equiv='refresh' content=3;url='cetak_checkout.php?kode_biling=$kode_biling'>Berhasil checkout";} | |
386 | ?> | |
387 | <?php //------------------ ?> | |
388 | </div> | |
389 | <br> | |
390 | <?php else: | |
391 | if (empty($_GET['kode_biling']) AND $_SESSION['ses_admin_level']=='Receptionist') { | |
392 | ?> | |
393 | ||
394 | ||
395 | ||
396 | <?php if ($checked != 1 AND $checked !=2 AND $checked !=3): ?> | |
397 | <h4>List Transaksi Check_in</h4> | |
398 | <hr></hr> | |
399 | ||
400 | Cari Berdasarkan Nama penghuni kamar | |
401 | <hr></hr> | |
402 | <form method="post" action='?page=biling.hasil_cari'> | |
403 | ||
404 | <label>Nama Penghuni </label><input type="text"name="nama"required="required" /> <br> | |
405 | <button type="submit" name="cari">Cari</button> | |
406 | </form> | |
407 | ||
408 | ||
409 | <div class="clear"></div> | |
410 | <table border="1"> | |
411 | <thead> | |
412 | <th>No.</th> | |
413 | <th>No.Pemesanan</th> | |
414 | <th>Nama Pemesan</th> | |
415 | <th>Alamat</th> | |
416 | <th>Kebangsaan</th> | |
417 | <th>Tanggal_checkin</th> | |
418 | <th>Tanggal_checkout</th> | |
419 | <th colspan="2">Aksi</th> | |
420 | ||
421 | </thead> | |
422 | <tbody> | |
423 | <?php ; | |
424 | ||
425 | $dataPerPage = 2; | |
426 | // apabila $_GET['page'] sudah didefinisikan, gunakan nomor halaman tersebut, | |
427 | // sedangkan apabila belum, nomor halamannya 1. | |
428 | if(isset($_GET['halaman'])) | |
429 | { | |
430 | $noPage = $_GET['halaman']; | |
431 | } | |
432 | else $noPage = 1; | |
433 | ||
434 | // perhitungan offset | |
435 | $offset = ($noPage - 1) * $dataPerPage; | |
436 | $no=$offset+1; | |
437 | ?> | |
438 | <?php foreach (tampil_reservasi_kamar($offset,$dataPerPage) as $reservasi){ ?> | |
439 | <?php | |
440 | $data_member=detail_member($reservasi['id_member']); | |
441 | ?> | |
442 | <tr> | |
443 | <td><?php echo $no++; ?></td> | |
444 | <td><?php echo autonumber($reservasi['no_pemesanan'],"TRK"); ?></td> | |
445 | <td><?php echo $data_member['nama_member']; ?></td> | |
446 | <td><?php echo $data_member['alamat_lengkap']; ?></td> | |
447 | <td><?php echo $data_member['kebangsaan']; ?></td> | |
448 | <td><?php echo tgl_indo($reservasi['tanggal_check_in']); ?></td> | |
449 | <td><?php echo tgl_indo($reservasi['tanggal_checkout']); ?></td> | |
450 | <td><a href="cetak_laporan.php?kode_biling=<?php echo decode_autonumber($reservasi['no_pemesanan'],"TRK")?>">Cetak</a></td> | |
451 | <td><a href="?page=biling.biling&kode_biling=<?php echo autonumber($reservasi['no_pemesanan'],"TRK")?>">Detail</a></td> | |
452 | ||
453 | </tr> | |
454 | <?php | |
455 | } | |
456 | ?> | |
457 | </tbody> | |
458 | </table> | |
459 | ||
460 | <?php | |
461 | ||
462 | ||
463 | // mencari jumlah semua data dalam tabel admin | |
464 | $query = "SELECT COUNT(*) as jumData FROM tb_reservasi_kamar where status='A'"; | |
465 | $hasil = mysql_query($query); | |
466 | $data = mysql_fetch_array($hasil); | |
467 | $jumData = $data['jumData']; | |
468 | $jumPage = ceil($jumData/$dataPerPage); | |
469 | echo "<div id='paging'>"; | |
470 | // menampilkan link previous | |
471 | echo "Pages (".$jumPage.") : "; | |
472 | if ($noPage > 1) echo "<a class='page' href='?page=biling.biling&halaman=".($noPage-1)."'><< Prev</a>"; | |
473 | ||
474 | // memunculkan nomor halaman dan linknya | |
475 | $showPage=0; | |
476 | for($page = 1; $page <= $jumPage; $page++) | |
477 | { | |
478 | if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $jumPage)) | |
479 | { | |
480 | if (($showPage == 1) && ($page != 2)) | |
481 | echo "..."; | |
482 | ||
483 | if (($showPage != ($jumPage - 1)) && ($page == $jumPage)) | |
484 | echo "..."; | |
485 | ||
486 | if ($page == $noPage) | |
487 | echo " <b>".$page."</b> "; | |
488 | else | |
489 | echo " <a class='page' href='?page=biling.biling&halaman=".$page."'>".$page."</a> "; | |
490 | $showPage = $page; | |
491 | } | |
492 | } | |
493 | ||
494 | // menampilkan link next | |
495 | if ($noPage < $jumPage) echo "<a class='page' href='?page=biling.biling&halaman=".($noPage+1)."'>Next >></a>"; | |
496 | echo "</div>";?> | |
497 | ||
498 | <?php endif ?> | |
499 | ||
500 | <?php }; endif ?> | |
501 | <?php //jika masuk roomboy | |
502 | if (empty($_GET['kode_biling'])AND $_SESSION['ses_admin_level']=='Roomboy') { | |
503 | ?> | |
504 | ||
505 | ||
506 | ||
507 | <?php | |
508 | $checked = isset($_GET['checked']) ? $_GET['checked'] : ''; | |
509 | if ($checked != 1 AND $checked !=2 AND $checked !=3): ?> | |
510 | <h4>List Transaksi Check_in</h4> | |
511 | <hr></hr> | |
512 | ||
513 | Cari Berdasarkan Nama penghuni kamar | |
514 | <hr></hr> | |
515 | <form method="post" action='?page=biling.hasil_cari'> | |
516 | ||
517 | <label>Nama Penghuni </label><input type="text"name="nama"required="required" /> <br> | |
518 | <button type="submit" name="cari">Cari</button> | |
519 | </form> | |
520 | ||
521 | ||
522 | <div class="clear"></div> | |
523 | <table border="1"> | |
524 | <thead> | |
525 | <th>No.</th> | |
526 | <th>No.Pemesanan</th> | |
527 | <th>Nama Pemesan</th> | |
528 | <th>Alamat</th> | |
529 | <th>Kebangsaan</th> | |
530 | <th>Tanggal_checkin</th> | |
531 | <th>Tanggal_checkout</th> | |
532 | <th colspan="2">Aksi</th> | |
533 | ||
534 | </thead> | |
535 | <tbody> | |
536 | <?php ; | |
537 | ||
538 | $dataPerPage = 2; | |
539 | // apabila $_GET['page'] sudah didefinisikan, gunakan nomor halaman tersebut, | |
540 | // sedangkan apabila belum, nomor halamannya 1. | |
541 | if(isset($_GET['halaman'])) | |
542 | { | |
543 | $noPage = $_GET['halaman']; | |
544 | } | |
545 | else $noPage = 1; | |
546 | ||
547 | // perhitungan offset | |
548 | $offset = ($noPage - 1) * $dataPerPage; | |
549 | $no=$offset+1; | |
550 | ?> | |
551 | <?php foreach (tampil_reservasi_kamar($offset,$dataPerPage) as $reservasi){ ?> | |
552 | <?php | |
553 | $data_member=detail_member($reservasi['id_member']); | |
554 | ?> | |
555 | <tr> | |
556 | <td><?php echo $no++; ?></td> | |
557 | <td><?php echo autonumber($reservasi['no_pemesanan'],"TRK"); ?></td> | |
558 | <td><?php echo $data_member['nama_member']; ?></td> | |
559 | <td><?php echo $data_member['alamat_lengkap']; ?></td> | |
560 | <td><?php echo $data_member['kebangsaan']; ?></td> | |
561 | <td><?php echo tgl_indo($reservasi['tanggal_check_in']); ?></td> | |
562 | <td><?php echo tgl_indo($reservasi['tanggal_checkout']); ?></td> | |
563 | <td><a href="?page=biling.biling&kode_biling=<?php echo autonumber($reservasi['no_pemesanan'],"TRK")?>">Detail</a></td> | |
564 | ||
565 | </tr> | |
566 | <?php | |
567 | } | |
568 | ?> | |
569 | </tbody> | |
570 | </table> | |
571 | ||
572 | <?php | |
573 | ||
574 | ||
575 | // mencari jumlah semua data dalam tabel admin | |
576 | $query = "SELECT COUNT(*) as jumData FROM tb_reservasi_kamar where status='A'"; | |
577 | $hasil = mysql_query($query); | |
578 | $data = mysql_fetch_array($hasil); | |
579 | $jumData = $data['jumData']; | |
580 | $jumPage = ceil($jumData/$dataPerPage); | |
581 | echo "<div id='paging'>"; | |
582 | // menampilkan link previous | |
583 | echo "Pages (".$jumPage.") : "; | |
584 | if ($noPage > 1) echo "<a class='page' href='?page=biling.biling&halaman=".($noPage-1)."'><< Prev</a>"; | |
585 | ||
586 | // memunculkan nomor halaman dan linknya | |
587 | $showPage=0; | |
588 | for($page = 1; $page <= $jumPage; $page++) | |
589 | { | |
590 | if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $jumPage)) | |
591 | { | |
592 | if (($showPage == 1) && ($page != 2)) | |
593 | echo "..."; | |
594 | ||
595 | if (($showPage != ($jumPage - 1)) && ($page == $jumPage)) | |
596 | echo "..."; | |
597 | ||
598 | if ($page == $noPage) | |
599 | echo " <b>".$page."</b> "; | |
600 | else | |
601 | echo " <a class='page' href='?page=biling.biling&halaman=".$page."'>".$page."</a> "; | |
602 | $showPage = $page; | |
603 | } | |
604 | } | |
605 | ||
606 | // menampilkan link next | |
607 | if ($noPage < $jumPage) echo "<a class='page' href='?page=biling.biling&halaman=".($noPage+1)."'>Next >></a>"; | |
608 | echo "</div>";?> | |
609 | ||
610 | <?php endif ?> | |
611 | ||
612 | <?php }; //endif; ?> | |
613 | ||
614 | ||
615 | ||
616 | ||
617 | ||
618 | ||
619 | ||
620 | ||
621 | ||
622 | ||
623 | ||
624 | </div> | |
625 | ||
626 | <!-- Endof tabel --> | |
627 | <div style="display:none;" id="pernah_pesan"> | |
628 | <form action="?page=biling.biling&checked=1" method="post"> | |
629 | ||
630 | <label>Masukan kode pemesanan</label> | |
631 | <input type="text" name="kode" required="required"value="TRK" /> | |
632 | <br></br> | |
633 | <input type="submit" name="proses" value="cek kode" > | |
634 | <br><br> | |
635 | ||
636 | </form> | |
637 | </div> | |
638 | ||
639 | <?php | |
640 | ||
641 | ||
642 | if (isset($_POST['kode'])) { | |
643 | ||
644 | ||
645 | ||
646 | ||
647 | $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")."'"); | |
648 | if(mysql_num_rows($cek_kode)>0){ | |
649 | echo "<script> alert('Kode Pemesanan Tersebut sudah melakukan Checkin'); location='?page=biling.biling';</script>"; | |
650 | exit(); | |
651 | } | |
652 | ||
653 | //print_r(decode_autonumber($_POST['kode'],"TRK")); exit(); | |
654 | ||
655 | ?> | |
656 | <div id="laporan1"> | |
657 | <br> | |
658 | <hr></hr> | |
659 | <strong>KONFIRMASI CHECKIN</strong> | |
660 | <hr></hr> | |
661 | <?php | |
662 | ||
663 | $data_reservasi=detail_reservasi_kamar (decode_autonumber(antihtml($_POST['kode']),"TRK")); | |
664 | $data_member=detail_member($data_reservasi[0]['id_member']); | |
665 | $jumlah_hari=round((strtotime($data_reservasi[0]['tanggal_checkout'])-strtotime($data_reservasi[0]['tanggal_check_in']))/86400); | |
666 | $total_seluruh=0; | |
667 | ||
668 | $co=strtotime($data_reservasi[0]['tanggal_checkout']); | |
669 | $ci=strtotime($data_reservasi[0]['tanggal_check_in']); | |
670 | if (time()>$co) { | |
671 | echo "<script> alert('Maaf Anda terlambat Checkin'); location='?page=biling.biling';</script>"; | |
672 | exit(); | |
673 | } | |
674 | ||
675 | if (time()<$ci) { | |
676 | echo "<script> alert('Maaf Anda Belum saatnya Checkin'); location='?page=biling.biling';</script>"; | |
677 | exit(); | |
678 | } | |
679 | ?> | |
680 | ||
681 | <form id="checkin" method="post" action="?page=biling.biling&checked=1"> | |
682 | <div class="bagi-2-3" id="laporan1"> | |
683 | <strong>Transaksi Pemesanan Pernah Dilakukan Oleh: </strong> | |
684 | <table border="1" width="100%"> | |
685 | <tr> | |
686 | <td> | |
687 | <?php echo "NO KTP : ".$data_member['id_member']; ?><br> | |
688 | <?php echo "Nama pemesan : ".$data_member['nama_member']; ?><br> | |
689 | <?php echo "Alamat Lengkap : ".$data_member['alamat_lengkap']; ?><br> | |
690 | <?php echo "Kebangsaan : ".$data_member['kebangsaan']; ?><br> | |
691 | </td> | |
692 | </tr> | |
693 | </table> | |
694 | <br> | |
695 | <strong>Untuk memesan</strong> | |
696 | <table border="1" width="100%" > | |
697 | <?php foreach ($data_reservasi as $reserv): | |
698 | ?> | |
699 | <tr> | |
700 | <td width="53%"> | |
701 | <?php | |
702 | $data_kamar=detail_kamar($reserv['no_kamar']); | |
703 | $total_seluruh+=($data_kamar['harga']*$jumlah_hari); | |
704 | ?> | |
705 | <?php echo "Nama Kamar : ".$data_kamar['nama_kamar']; ?><br> | |
706 | <?php echo "Tipe Kamar : ".$data_kamar['nama_tipe_kamar']; ?><br> | |
707 | <?php echo "Harga : ".$data_kamar['harga']; ?><br> | |
708 | </td> | |
709 | <td width="10%"><select name="jumlah[<?php echo $reserv['no_kamar'] ?>]" > | |
710 | <option value="'<?php echo $reserv['jumlah_orang']; ?>'"><?php echo $reserv['jumlah_orang']; ?> orang</option> | |
711 | ||
712 | ||
713 | </select> | |
714 | </td> | |
715 | ||
716 | </tr> | |
717 | <?php endforeach; ?> | |
718 | </table> | |
719 | <div id="judul_tabel" style="display:none;"> | |
720 | ||
721 | <strong>Data Tamu</strong> | |
722 | <hr></hr> | |
723 | </div> | |
724 | <table border="1" width="50%" id="tampil"> | |
725 | <?php | |
726 | $ambil=mysql_query("SELECT * FROM `tb_reservasi_kamar_detail` WHERE `no_pemesanan`= '".decode_autonumber($_POST['kode'],"TRK")."'"); | |
727 | //print_r($ambil) | |
728 | //exit(); | |
729 | while ($data=mysql_fetch_assoc($ambil)){ | |
730 | ?> | |
731 | <tr> | |
732 | <td colspan="8"> | |
733 | Kamar <?php echo $data['no_kamar']; ?> | |
734 | </td> | |
735 | </tr> | |
736 | <?php for($i=1; $i<= $data['jumlah_orang']; $i++){ ?> | |
737 | <tr> | |
738 | <td>Nama</td> | |
739 | <td><input type="text" name="nama[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"></td> | |
740 | <td>Alamat</td> | |
741 | <td><textarea type="textarea" rows="10" cols="30" name="alamat[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"></textarea></td> | |
742 | <td>Tanggal Lahir</td> | |
743 | <td><input type="date" name="tgl_lahir[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"></td> | |
744 | <td>Kebangsaan</td> | |
745 | <td><select name="bangsa[<?php echo $data['id_pemesanan_kamar_detail']; ?>][]"> | |
746 | <?php foreach ($countries as $idn => $country): ?> | |
747 | <option value ="<?php echo $country;?>" > <?php echo $country;?></option> | |
748 | ||
749 | <?php endforeach ?> | |
750 | </select> | |
751 | </td> | |
752 | </tr> | |
753 | <?php } ?> | |
754 | <?php | |
755 | } | |
756 | ?> | |
757 | ||
758 | </table> | |
759 | <br> | |
760 | <table border="1"width="100%"> | |
761 | <tr> | |
762 | <td> | |
763 | <input type="hidden" name="nop" value="<?php echo $_POST['kode']; ?>"/> | |
764 | <input type="hidden" name="no_ktp" value="<?php echo $data_member['id_member']; ?>"> | |
765 | <label>Tanggal Check In</label><input type="text" value="<?php echo tgl_indo($data_reservasi['0']['tanggal_check_in']); ?>" readonly="readonly" name="ci"> | |
766 | <label>Tanggal Check Out</label><input type="text" value="<?php echo tgl_indo($data_reservasi['0']['tanggal_checkout']); ?>" readonly="readonly" name="co"> | |
767 | <label>lama</label><?php echo $jumlah_hari. " Malam ";?><br> | |
768 | <label>Biaya Pemesanan</label><input type="text"name="total"value="<?php echo $total_seluruh ?>" readonly="readonly"><br> | |
769 | ||
770 | </td> | |
771 | </tr> | |
772 | </table> | |
773 | ||
774 | <input type="hidden" name="ci" value="<?php echo $data_reservasi['0']['tanggal_check_in']; ?> "/> | |
775 | ||
776 | <input type="hidden" name="co" value="<?php echo $data_reservasi['0']['tanggal_checkout']; ?> "/> | |
777 | ||
778 | <button type="submit" name="simpan" id="save" onclick="myFunction();" class="hidden-print">Simpan</button> | |
779 | ||
780 | ||
781 | ||
782 | </div> | |
783 | </form> | |
784 | <?php | |
785 | } | |
786 | ?> | |
787 | ||
788 | </div> | |
789 | <div class="clear"></div> | |
790 | <!----=============================-- | |
791 | Jika Orang yang datang hanya memesan kamar maka :--> | |
792 | <div style="display:none;" id="hanya_pesan"> | |
793 | <h4>CEK KETERSEDIAAN KAMAR</h4> | |
794 | <hr></hr> | |
795 | ||
796 | <?php if ($checked != 1 AND $checked !=2 AND $checked !=3): ?> | |
797 | <form action="" name ="cek_ketersediaan" method="post"> | |
798 | <label>Tanggal_check_in</label> | |
799 | <input type="text" name="checkin" id="check_in"required="required"> | |
800 | <label>Tanggal Check out</label> | |
801 | <input type="text" name="checkout" id="check_out" required="required"> | |
802 | <br> | |
803 | <button type="submit">Check</button> | |
804 | ||
805 | ||
806 | </form> | |
807 | ||
808 | <script language='javascript'> | |
809 | function validAngka(a) | |
810 | { | |
811 | if(!/^[0-9.]+$/.test(a.value)) | |
812 | { | |
813 | a.value = a.value.substring(0,a.value.length-1000); | |
814 | } | |
815 | } | |
816 | </script> | |
817 | <style> | |
818 | textarea { | |
819 | resize: none; | |
820 | } | |
821 | </style> | |
822 | <?php | |
823 | //fungsi menampilkan kamar yang tersedia | |
824 | ||
825 | //proses pengecekan kamar | |
826 | if(isset($_POST['checkin'])) | |
827 | { | |
828 | $tgl_check_in=ubahformatTgl2($_POST['checkin']); | |
829 | $tgl_checkout=ubahformatTgl2($_POST['checkout']); | |
830 | $ambil = mysql_query("SELECT * FROM tb_kamar | |
831 | WHERE | |
832 | no_kamar NOT IN(SELECT k.no_kamar FROM tb_kamar k JOIN | |
833 | tb_reservasi_kamar_detail rkd ON rkd.no_kamar = k.no_kamar JOIN | |
834 | tb_reservasi_kamar rk ON rk.no_pemesanan=rkd.no_pemesanan | |
835 | WHERE | |
836 | '$tgl_check_in' BETWEEN rk.tanggal_check_in | |
837 | AND | |
838 | rk.tanggal_checkout OR '$tgl_checkout' | |
839 | BETWEEN | |
840 | rk.tanggal_check_in AND | |
841 | rk.tanggal_checkout)"); | |
842 | ||
843 | //echo mysql_error(); | |
844 | //exit(); | |
845 | if (mysql_num_rows($ambil)>0){ | |
846 | ?> | |
847 | <form method="post" action=""> | |
848 | <input type="hidden"name="check_in" value="<?php echo $tgl_check_in; ?>"> | |
849 | <input type="hidden"name="check_out" value="<?php echo $tgl_checkout; ?>"> | |
850 | <?php | |
851 | while($data=mysql_fetch_assoc($ambil)) | |
852 | { | |
853 | $data_kamar=detail_kamar($data['no_kamar']); | |
854 | ?> | |
855 | <div class="bagi-4"> | |
856 | <!-- | |
857 | ||
858 | --> | |
859 | <img src="../image/kamar/<?php echo $data_kamar['foto']; ?>" class="responsive"> | |
860 | Nama Kamar : <?php echo $data_kamar['nama_kamar']; ?><br> | |
861 | Harga Sewa : <?php echo $data_kamar['harga'];?><br> | |
862 | Tipe Kamar : <?php echo $data_kamar['nama_tipe_kamar']; ?><br> | |
863 | <input type="checkbox" name="kamar[]" value="<?php echo $data_kamar['no_kamar'];?> " />PILIH KAMAR | |
864 | </div> | |
865 | <?php | |
866 | } | |
867 | ||
868 | ||
869 | ?> | |
870 | <div class="clear"></div><br> | |
871 | <center><button type="submit" name="lanjutkan_konfirmasi" align="right" style="float:left;";>lanjut</button></center> | |
872 | </form> | |
873 | <?php | |
874 | }else{ | |
875 | echo "kamar tidak ada yang tersedia"; | |
876 | } | |
877 | ?> | |
878 | ||
879 | ||
880 | <?php | |
881 | } | |
882 | ||
883 | else if(isset($_POST['kamar'])) | |
884 | { | |
885 | pesan_kamar($_POST['kamar']); | |
886 | ?> | |
887 | ||
888 | <div class="bagi-3"> | |
889 | <h4>Apakah Tamu Tersebut Sudah Terdaftar Sebelumnya ?</h4> | |
890 | <hr></hr> | |
891 | <form method="post" action='?page=reservasi_kamar_langsung.konfirmasi'> | |
892 | <input type="hidden"name="check_in" value="<?php echo $_POST['check_in']; ?>"> | |
893 | <input type="hidden"name="check_out" value="<?php echo $_POST['check_out']; ?>"> | |
894 | <input type="hidden" name="terdaftar" value="benar"> | |
895 | <label> Masukan Nomor KTP</label> | |
896 | <br> | |
897 | <input type="text" name="no_ktp" maxlength="16" onkeyup="validAngka(this);"/> | |
898 | <br> | |
899 | <button type="submit">Lanjut</button> | |
900 | ||
901 | </form> | |
902 | ||
903 | </div> | |
904 | ||
905 | ||
906 | <div class="bagi-2-3" style="border-left:1px dotted green;"> | |
907 | <h4>Daftarkan Tamu Baru</h4> | |
908 | <hr></hr> | |
909 | <form action='?page=reservasi_kamar_langsung.konfirmasi' method="post"> | |
910 | <input type="hidden"name="check_in" value="<?php echo $_POST['check_in']; ?>"> | |
911 | <input type="hidden"name="check_out" value="<?php echo $_POST['check_out']; ?>"> | |
912 | <div class="bagi-2"> | |
913 | <label>No KTP</label> | |
914 | <input type="text" name="no_ktp" maxlength="16" onkeyup="validAngka(this);" /> | |
915 | <label>NAMA</label> | |
916 | <input type="text" name="nama"/> | |
917 | <label>EMAIL</label> | |
918 | <input type="email" name="email"/> | |
919 | <label>USERNAME</label> | |
920 | <input type="text" name="username"/> | |
921 | ||
922 | <label>PASSWORD</label> | |
923 | <input type="password" name="pass"/> | |
924 | <label>TANGGAL_LAHIR</label> | |
925 | <input type="text" name="tgllahir" id="tgllahir"/> | |
926 | ||
927 | </div> | |
928 | <div class="bagi-2"> | |
929 | <label>TEMPAT LAHIR</label> | |
930 | <input type="text" name="tempat_lahir"/> | |
931 | <label>ALAMAT</label> | |
932 | <textarea name="alamat" width="900" cols="35" rows="5"></textarea> | |
933 | <label>KEBANGSAAN</label> | |
934 | <select name="kebangsaan"> | |
935 | ||
936 | <?php foreach ($countries as $idn => $country): ?> | |
937 | <option value ="<?php echo $country;?>" > <?php echo $country;?></option> | |
938 | ||
939 | <?php endforeach ?> | |
940 | </select> | |
941 | ||
942 | ||
943 | ||
944 | ||
945 | </div> | |
946 | <div class="clear"></div> | |
947 | <div class="bagi-3"> | |
948 | <button type="submit" name="lanjutkan" >Lanjut</button> | |
949 | </div> | |
950 | ||
951 | ||
952 | ||
953 | ||
954 | </form> | |
955 | </div> | |
956 | ||
957 | <?php | |
958 | ||
959 | ||
960 | ||
961 | ||
962 | } | |
963 | ||
964 | ?> | |
965 | <?php endif; ?> | |
966 | ||
967 | ||
968 | ||
969 | ||
970 | <div class="clear"></div> | |
971 | <!-- Apabila tamu datang langsung tanpa pesan dan langsung mau checkin kamar --> |