View difference between Paste ID: 7Fh5nf72 and aeCFSCk6
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)."'>&lt;&lt; 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 &gt;&gt;</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)."'>&lt;&lt; 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 &gt;&gt;</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 -->