lampiran 1. halaman utamaeprints.umpo.ac.id/2331/8/lampiran.pdf · 2016. 10. 11. ·
TRANSCRIPT
LAMPIRAN
1. Halaman Utama
<?php
include './conn.php';
$page = 'home';
if (isset($_GET['p'])) {
$page = $_GET['p'];
}
$step = 0;
if (isset($_GET['s'])) {
$step = $_GET['s'];
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Pemesanan Tiket Online</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-
width, initial-scale=1.0">
<link
href="./resources/bootstrap/css/bootstrap.min.css"
rel="stylesheet" type="text/css"/>
<link
href="./resources/bootstrap/css/bootstrap-
theme.min.css" rel="stylesheet" type="text/css"/>
<link href="./resources/bootstrap/roboto-
fontface/css/roboto-fontface.css" rel="stylesheet"
type="text/css"/>
<link href="./resources/main.css"
rel="stylesheet" type="text/css"/>
<script
src="./resources/jquery/jquery.min.js"
type="text/javascript"></script>
<script
src="./resources/bootstrap/js/bootstrap.min.js"
type="text/javascript"></script>
</head>
<body>
<nav class="navbar navbar-inverse navbar-
fixed-top">
<div class="container-fluid">
<!-- Brand and toggle get grouped
for better mobile display -->
<div class="navbar-header">
<button type="button"
class="navbar-toggle collapsed" data-
toggle="collapse" data-target="#bs-example-navbar-
collapse-1" aria-expanded="false">
<span class="sr-only">Toggle
navigation</span>
<span class="icon-
bar"></span>
<span class="icon-
bar"></span>
<span class="icon-
bar"></span>
</button>
<a class="navbar-brand"
href="./">Pemesanan Tiket Online</a>
</div>
<!-- Collect the nav links, forms,
and other content for toggling -->
<div class="collapse navbar-
collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li<?php echo $page ==
'pemesanan' ? ' class=active' : '' ?>><a
href="./?p=pemesanan">Pemesanan</a></li>
<li<?php echo $page ==
'konfirmasi' ? ' class=active' : '' ?>><a
href="./?p=konfirmasi">Konfirmasi</a></li>
<li<?php echo $page ==
'pesanan' ? ' class=active' : '' ?>><a
href="./?p=pesanan">Cek Status Pesanan</a></li>
</ul>
</div><!-- /.navbar-collapse -->
</div><!-- /.container-fluid -->
</nav>
<div class="container-fluid">
<div class="paper">
<div class="row">
<div class="col-sm-12">
<?php
if ($page == 'pemesanan') {
$page = $page . '-' .
$step;
}
include $page . '.php';
?>
</div>
</div>
<div class="row">
<div class="col-sm-12">
<hr/>
<p>Copyright © <?php
echo date("Y"); ?> </p>
</div>
</div>
</div>
</div>
</body>
</html>
2. Halaman Pemesanan
<?php
$id_jadwal = '-1';
if (isset($_GET['id_jadwal'])) {
$id_jadwal = $_GET['id_jadwal'];
}
if (isset($_GET['act']) && $_GET['act'] == 'delete')
{
mysql_query("delete from jadwal where id_jadwal
= '" . $id_jadwal . "'");
echo '<script>window.location.href =
"?p=jadwal";</script>';
}
$hari = 0;
if (isset($_GET['hari'])) {
$hari = $_GET['hari'];
}
$id_biro = '-1';
if (isset($_GET['id_biro'])) {
$id_biro = $_GET['id_biro'];
} else {
$qb = mysql_query("select * from biro order by
nama asc");
$rb = mysql_fetch_array($qb);
$id_biro = $rb[0];
mysql_free_result($qb);
}
$qb = mysql_query("select * from biro where id_biro
= '$id_biro'");
$rb = mysql_fetch_array($qb);
?>
<h1>Pemesanan Tiket<br/><small>Silakan pilih salah
satu dari jadwal di bawah ini yang sesuai dengan
keinginan anda</small></h1>
<hr/>
<div style="float: left; width: 160px;">
<h3>Biro Perjalanan</h3>
<hr/>
<ul class="nav nav-pills nav-stacked">
<?php
$queryBiro = mysql_query("select * from biro
order by nama asc");
while ($rsBiro =
mysql_fetch_array($queryBiro)) {
?>
<li<?php echo $id_biro ==
$rsBiro['id_biro'] ? ' class=active' : ''; ?>><a
href="./?p=pemesanan&id_biro=<?php echo
$rsBiro['id_biro']; ?>&hari=<?php echo $hari;
?>"><?php echo $rsBiro['nama']; ?></a></li>
<?php
}
mysql_free_result($queryBiro);
?>
</ul>
</div>
<div style="margin-left: 240px;">
<table class="table table-striped">
<thead>
<tr>
<th style="width:
140px;">Armada</th>
<th>Jurusan</th>
<th style="text-align: center;
width: 160px;">Jam Berangkat</th>
<th style="text-align: right; width:
140px;">Harga</th>
<th style="text-align: right; width:
40px;"></th>
</tr>
</thead>
<tbody>
<?php
$query = mysql_query("select
j.id_jadwal, j.jurusan, j.jam_berangkat, a.nama,
j.harga from jadwal j, armada a where a.id_armada =
j.id_armada and j.id_biro= '$id_biro' order by
a.id_armada asc, j.jam_berangkat asc");
while ($row = mysql_fetch_array($query))
{
?>
<tr>
<td><?php echo $row['nama'];
?></td>
<td><?php echo $row['jurusan'];
?></td>
<td style="text-align:
center;"><?php echo date('H:i',
strtotime($row['jam_berangkat'])); ?> WIB</td>
<td style="text-align:
right;"><?php echo number_format($row['harga']);
?></td>
<td style="text-align: right;">
<a
href="./?p=pemesanan&s=1&id_jadwal=<?php echo
$row['id_jadwal']; ?>" class="btn btn-success btn-
xs">Pilih</a>
</td>
</tr>
<?php
}
mysql_free_result($query);
?>
</tbody>
</table>
</div>
<?php
mysql_free_result($qb);
3. Halaman Pemesanan Step 1
<?php
if (isset($_POST['simpan'])) {
$kode = time();
$jumlah_harga = $_POST['harga'] *
$_POST['jumlah_pemesanan'];
mysql_query("insert into pemesanan
(nama_pemesan, "
. "alamat_pemesan, "
. "telepon_pemesan, "
. "tanggal_pemesanan, "
. "id_jadwal, "
. "id_biro, "
. "tanggal_pemberangkatan, "
. "jam_pemberangkatan, "
. "jumlah_pemesanan, "
. "harga, "
. "jumlah_harga, "
. "status_pemesanan, "
. "kode) values ("
. "'" . $_POST['pemesan_nama'] . "', "
. "'" . $_POST['pemesan_alamat'] . "', "
. "'" . $_POST['pemesan_telepon'] . "',
"
. "'" . $_POST['tanggal_pemesanan'] .
"', "
. "'" . $_POST['id_jadwal'] . "', "
. "'" . $_POST['id_biro'] . "', "
. "'" . date('Y-m-d',
strtotime($_POST['tanggal_pemberangkatan'])) . "', "
. "'" . $_POST['jam_pemberangkatan'] .
"', "
. "'" . $_POST['jumlah_pemesanan'] . "',
"
. "'" . $_POST['harga'] . "', "
. "'" . $jumlah_harga . "', "
. "'0', "
. "'$kode'"
. ")", $conn) or die (mysql_error());
$id = mysql_insert_id($conn);
echo '<script>window.location.href =
"?p=pemesanan&s=2&id_pemesanan=' . $id .
'";</script>';
}
$id_jadwal = '-1';
if (isset($_GET['id_jadwal'])) {
$id_jadwal = $_GET['id_jadwal'];
}
$queryJadwal = mysql_query("select * from jadwal
where id_jadwal = '" . $id_jadwal . "'");
$rsJadwal = mysql_fetch_array($queryJadwal);
$queryArmada = mysql_query("select * from armada
where id_armada = '$rsJadwal[id_armada]'");
$rsArmada = mysql_fetch_array($queryArmada);
$queryBiro = mysql_query("select * from biro where
id_biro = '$rsJadwal[id_biro]'");
$rsBiro = mysql_fetch_array($queryBiro);
?>
<h1>Pemesanan Tiket <strong>Step
1</strong><br/><small>Masukkan detail pemesanan di
bawah ini</small></h1>
<hr/>
<form class="form-horizontal" method="post"
action="./?p=pemesanan&s=1">
<div class="form-group">
<label for="pemesan_nama" class="control-
label col-sm-2">Nama Pemesan</label>
<div class="col-sm-10">
<input type="text" class="form-control"
name="pemesan_nama" id="pemesan_nama"
placeholder="Nama Pemesan"/>
</div>
</div>
<div class="form-group">
<label for="pemesan_alamat" class="control-
label col-sm-2">Alamat</label>
<div class="col-sm-10">
<input type="text" class="form-control"
name="pemesan_alamat" id="pemesan_alamat"
placeholder="Alamat"/>
</div>
</div>
<div class="form-group">
<label for="pemesan_telepon" class="control-
label col-sm-2">Telepon</label>
<div class="col-sm-10">
<input type="text" class="form-control"
name="pemesan_telepon" id="pemesan_telepon"
placeholder="Telepon"/>
</div>
</div>
<div class="form-group">
<label for="biro_nama" class="control-label
col-sm-2">Biro</label>
<div class="col-sm-10">
<input type="text" class="form-control"
name="biro_nama" id="biro_nama" placeholder="Nama
Biro" value="<?php echo $rsBiro['nama']; ?>"
readonly="true"/>
</div>
</div>
<div class="form-group">
<label for="armada_nama" class="control-
label col-sm-2">Armada</label>
<div class="col-sm-10">
<input type="text" class="form-control"
name="armada_nama" id="armada_nama"
placeholder="Nama Armada" value="<?php echo
$rsArmada['nama']; ?>" readonly="true"/>
</div>
</div>
<div class="form-group">
<label for="jurusan" class="control-label
col-sm-2">Jurusan</label>
<div class="col-sm-10">
<input type="text" class="form-control"
name="jurusan" id="pemesan_telepon"
placeholder="Jurusan" value="<?php echo
$rsJadwal['jurusan']; ?>" readonly="true"/>
</div>
</div>
<div class="form-group">
<label for="tanggal_pemberangkatan"
class="control-label col-sm-2">Tanggal
Berangkat</label>
<div class="col-sm-2">
<input type="text" class="form-control"
name="tanggal_pemberangkatan"
id="tanggal_pemberangkatan" value="<?php echo
date('d-m-Y'); ?>"/>
</div>
<div class="col-sm-2"></div>
<label for="jam_pemberangkatan"
class="control-label col-sm-2">Jam Berangkat</label>
<div class="col-sm-2">
<input type="text" class="form-control"
name="jam_pemberangkatan" id="jam_pemberangkatan"
value="<?php echo date('H:i',
strtotime($rsJadwal['jam_berangkat'])); ?>"
readonly="true"/>
</div>
<div class="col-sm-2"></div>
</div>
<div class="form-group">
<label for="jumlah_pemesanan"
class="control-label col-sm-2">Jumlah
Pemesanan</label>
<div class="col-sm-2">
<input type="text" class="form-control"
name="jumlah_pemesanan" id="jumlah_pemesanan"
value="1"/>
</div>
<div class="col-sm-2"></div>
<label for="harga" class="control-label col-
sm-2">Harga Per Kursi</label>
<div class="col-sm-2">
<input type="text" class="form-control"
name="harga" id="harga" value="<?php echo
$rsJadwal['harga']; ?>"/>
</div>
<div class="col-sm-2"></div>
</div>
<input type="hidden" name="id_jadwal"
value="<?php echo $rsJadwal['id_jadwal']; ?>"/>
<input type="hidden" name="id_biro" value="<?php
echo $rsJadwal['id_biro']; ?>"/>
<input type="hidden" name="tanggal_pemesanan"
value="<?php echo date('Y-m-d'); ?>"/>
<hr/>
<div class="form-group">
<div class="col-sm-2"></div>
<div class="col-sm-10">
<input type="submit" name="simpan"
value="Simpan" class="btn btn-primary"/>
<a href="javascript:history.back()"
class="btn btn-default">Kembali</a>
</div>
</div>
</form>
<?php
mysql_free_result($queryJadwal);
mysql_free_result($queryArmada);
mysql_free_result($queryBiro);
4. Halaman Pemesanan Step 2
<?php
$id_pemesanan = '-1';
if (isset($_GET['id_pemesanan'])) {
$id_pemesanan = $_GET['id_pemesanan'];
}
if (isset($_GET['act'])) {
mysql_query("update pemesanan set
status_pemesanan = 9 where id_pemesanan =
'$id_pemesanan'");
echo '<script>window.location.href =
"?p=pemesanan&s=9&id_pemesanan=' . $id_pemesanan .
'";</script>';
}
if (isset($_POST['simpan'])) {
$id_pemesanan = $_POST['id_pemesanan'];
mysql_query("update pemesanan set
status_pemesanan = 1 where id_pemesanan =
'$id_pemesanan'");
echo '<script>window.location.href =
"?p=pemesanan&s=3&id_pemesanan=' . $id_pemesanan .
'";</script>';
}
$query = mysql_query("select * from pemesanan where
id_pemesanan = '" . $id_pemesanan . "' and
status_pemesanan = 0");
$rs = mysql_fetch_array($query);
$queryJadwal = mysql_query("select * from jadwal
where id_jadwal = '$rs[id_jadwal]'");
$rsJadwal = mysql_fetch_array($queryJadwal);
$queryBiro = mysql_query("select * from biro where
id_biro = '$rs[id_biro]'");
$rsBiro = mysql_fetch_array($queryBiro);
$queryArmada = mysql_query("select * from armada
where id_armada = '$rsJadwal[id_armada]'");
$rsArmada = mysql_fetch_array($queryArmada);
?>
<h1>Pemesanan Tiket <strong>Step
2</strong><br/><small>Detail Pesanan
Anda</small></h1>
<hr/>
<div class="row">
<div class="col-sm-4">
<h1>
Kode Pemesanan<br/>
<strong><?php echo $rs['kode'];
?></strong><br/>
<small>Simpan kode ini, dan gunakan kode
ini untuk konfirmasi pembayaran</small>
</h1>
</div>
<div class="col-sm-8">
<table class="detail">
<tbody>
<tr>
<td style="width: 220px;">Nama
Pemesan</td>
<td style="width: 20px;">:</td>
<td><?php echo
$rs['nama_pemesan']; ?></td>
</tr>
<tr>
<td style="width:
220px;">Alamat</td>
<td style="width: 20px;">:</td>
<td><?php echo
$rs['alamat_pemesan']; ?></td>
</tr>
<tr>
<td style="width:
220px;">Telepon</td>
<td style="width: 20px;">:</td>
<td><?php echo
$rs['telepon_pemesan']; ?></td>
</tr>
<tr>
<td style="width: 220px;">Biro &
Armada</td>
<td style="width: 20px;">:</td>
<td><?php echo $rsBiro['nama'];
?>, <?php echo $rsArmada['nama']; ?></td>
</tr>
<tr>
<td style="width:
220px;">Jurusan</td>
<td style="width: 20px;">:</td>
<td><?php echo
$rsJadwal['jurusan']; ?></td>
</tr>
<tr>
<td style="width:
220px;">Tanggal Pemesanan</td>
<td style="width: 20px;">:</td>
<td><?php echo date('d-m-Y',
strtotime($rs['tanggal_pemesanan'])); ?></td>
</tr>
<tr>
<td style="width:
220px;">Tanggal Pemberangkatan</td>
<td style="width: 20px;">:</td>
<td><?php echo date('d-m-Y',
strtotime($rs['tanggal_pemberangkatan'])); ?></td>
</tr>
<tr>
<td style="width: 220px;">Jam
Pemberangkatan</td>
<td style="width: 20px;">:</td>
<td><?php echo date('H:i',
strtotime($rs['jam_pemberangkatan'])); ?> WIB</td>
</tr>
<tr>
<td style="width: 220px;">Jumlah
Pemesanan</td>
<td style="width: 20px;">:</td>
<td><?php echo
$rs['jumlah_pemesanan']; ?> Tempat Duduk</td>
</tr>
<tr>
<td style="width: 220px;">Harga
@</td>
<td style="width: 20px;">:</td>
<td><?php echo
number_format($rs['harga']); ?></td>
</tr>
<tr>
<td style="width: 220px;">Jumlah
Harga</td>
<td style="width: 20px;">:</td>
<td><?php echo
number_format($rs['jumlah_harga']); ?></td>
</tr>
</tbody>
</table>
</div>
</div>
<hr/>
<div class="row">
<div class="col-sm-4">
</div>
<div class="col-sm-8">
<form method="post"
action="?p=pemesanan&s=2">
<input type="hidden" name="id_pemesanan"
value="<?php echo $id_pemesanan; ?>"/>
<p>Apakah anda yakin akan melanjutkan
pemesanan ini?</p>
<p>
<input type="submit" name="simpan"
class="btn btn-primary" value="Simpan"/>
<a
href="./?p=pemesanan&s=2&id_pemesanan=<?php echo
$id_pemesanan; ?>&act=cancel" class="btn btn-
info">Batalkan transaksi</a>
</p>
</form>
</div>
</div>
<?php
mysql_free_result($query);
mysql_free_result($queryJadwal);
mysql_free_result($queryBiro);
mysql_free_result($queryArmada);
5. Halaman Pemesanan Step 3
<?php
$id_pemesanan = '-1';
if (isset($_GET['id_pemesanan'])) {
$id_pemesanan = $_GET['id_pemesanan'];
}
if (isset($_GET['act'])) {
mysql_query("update pemesanan set
status_pemesanan = 9 where id_pemesanan =
'$id_pemesanan'");
echo '<script>window.location.href =
"?p=pemesanan&s=9&id_pemesanan=' . $id_pemesanan .
'";</script>';
}
if (isset($_POST['simpan'])) {
$id_pemesanan = $_POST['id_pemesanan'];
mysql_query("update pemesanan set
status_pemesanan = 1 where id_pemesanan =
'$id_pemesanan'");
echo '<script>window.location.href =
"?p=pemesanan&s=3&id_pemesanan=' . $id_pemesanan .
'";</script>';
}
$query = mysql_query("select * from pemesanan where
id_pemesanan = '" . $id_pemesanan . "' and
status_pemesanan = 1");
$rs = mysql_fetch_array($query);
$queryJadwal = mysql_query("select * from jadwal
where id_jadwal = '$rs[id_jadwal]'");
$rsJadwal = mysql_fetch_array($queryJadwal);
$queryBiro = mysql_query("select * from biro where
id_biro = '$rs[id_biro]'");
$rsBiro = mysql_fetch_array($queryBiro);
$queryArmada = mysql_query("select * from armada
where id_armada = '$rsJadwal[id_armada]'");
$rsArmada = mysql_fetch_array($queryArmada);
?>
<h1>Pemesanan Tiket <strong>Step
3</strong><br/><small>Pemesanan tiket telah selesai,
silakan cetak bukti pemesanan di bawah
ini</small></h1>
<hr/>
<div class="row">
<div class="col-sm-4">
<h1>
Kode Pemesanan<br/>
<strong><?php echo $rs['kode'];
?></strong><br/>
<small>Simpan kode ini, dan gunakan kode
ini untuk konfirmasi pembayaran</small>
</h1>
</div>
<div class="col-sm-8">
<table class="detail">
<tbody>
<tr>
<td style="width: 220px;">Nama
Pemesan</td>
<td style="width: 20px;">:</td>
<td><?php echo
$rs['nama_pemesan']; ?></td>
</tr>
<tr>
<td style="width:
220px;">Alamat</td>
<td style="width: 20px;">:</td>
<td><?php echo
$rs['alamat_pemesan']; ?></td>
</tr>
<tr>
<td style="width:
220px;">Telepon</td>
<td style="width: 20px;">:</td>
<td><?php echo
$rs['telepon_pemesan']; ?></td>
</tr>
<tr>
<td style="width: 220px;">Biro &
Armada</td>
<td style="width: 20px;">:</td>
<td><?php echo $rsBiro['nama'];
?>, <?php echo $rsArmada['nama']; ?></td>
</tr>
<tr>
<td style="width:
220px;">Jurusan</td>
<td style="width: 20px;">:</td>
<td><?php echo
$rsJadwal['jurusan']; ?></td>
</tr>
<tr>
<td style="width:
220px;">Tanggal Pemesanan</td>
<td style="width: 20px;">:</td>
<td><?php echo date('d-m-Y',
strtotime($rs['tanggal_pemesanan'])); ?></td>
</tr>
<tr>
<td style="width:
220px;">Tanggal Pemberangkatan</td>
<td style="width: 20px;">:</td>
<td><?php echo date('d-m-Y',
strtotime($rs['tanggal_pemberangkatan'])); ?></td>
</tr>
<tr>
<td style="width: 220px;">Jam
Pemberangkatan</td>
<td style="width: 20px;">:</td>
<td><?php echo date('H:i',
strtotime($rs['jam_pemberangkatan'])); ?> WIB</td>
</tr>
<tr>
<td style="width: 220px;">Jumlah
Pemesanan</td>
<td style="width: 20px;">:</td>
<td><?php echo
$rs['jumlah_pemesanan']; ?> Tempat Duduk</td>
</tr>
<tr>
<td style="width: 220px;">Harga
@</td>
<td style="width: 20px;">:</td>
<td><?php echo
number_format($rs['harga']); ?></td>
</tr>
<tr>
<td style="width: 220px;">Jumlah
Harga</td>
<td style="width: 20px;">:</td>
<td><?php echo
number_format($rs['jumlah_harga']); ?></td>
</tr>
</tbody>
</table>
</div>
</div>
<hr/>
<div class="row">
<div class="col-sm-4">
</div>
<div class="col-sm-8">
<p>
<a href="./pemesanan-
cetak.php?id_pemesanan=<?php echo $id_pemesanan; ?>"
class="btn btn-primary" target="_blank">Cetak</a>
<a href="./?p=home" class="btn btn-
info">Kembali ke home</a>
</p>
</div>
</div>
<?php
mysql_free_result($query);
mysql_free_result($queryJadwal);
mysql_free_result($queryBiro);
mysql_free_result($queryArmada);
6. Cetak Bukti Pembayaran
<?php
include './conn.php';
$id_pemesanan = '-1';
if (isset($_GET['id_pemesanan'])) {
$id_pemesanan = $_GET['id_pemesanan'];
}
if (isset($_GET['act'])) {
mysql_query("update pemesanan set
status_pemesanan = 9 where id_pemesanan =
'$id_pemesanan'");
echo '<script>window.location.href =
"?p=pemesanan&s=9&id_pemesanan=' . $id_pemesanan .
'";</script>';
}
if (isset($_POST['simpan'])) {
$id_pemesanan = $_POST['id_pemesanan'];
mysql_query("update pemesanan set
status_pemesanan = 1 where id_pemesanan =
'$id_pemesanan'");
echo '<script>window.location.href =
"?p=pemesanan&s=3&id_pemesanan=' . $id_pemesanan .
'";</script>';
}
$query = mysql_query("select * from pemesanan where
id_pemesanan = '" . $id_pemesanan . "'");
$rs = mysql_fetch_array($query);
$queryJadwal = mysql_query("select * from jadwal
where id_jadwal = '$rs[id_jadwal]'");
$rsJadwal = mysql_fetch_array($queryJadwal);
$queryBiro = mysql_query("select * from biro where
id_biro = '$rs[id_biro]'");
$rsBiro = mysql_fetch_array($queryBiro);
$queryArmada = mysql_query("select * from armada
where id_armada = '$rsJadwal[id_armada]'");
$rsArmada = mysql_fetch_array($queryArmada);
?>
<!DOCTYPE html>
<html>
<head>
<title>Pemesanan Tiket Online</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-
width, initial-scale=1.0">
<link
href="./resources/bootstrap/css/bootstrap.min.css"
rel="stylesheet" type="text/css"/>
<link
href="./resources/bootstrap/css/bootstrap-
theme.min.css" rel="stylesheet" type="text/css"/>
<link href="./resources/bootstrap/roboto-
fontface/css/roboto-fontface.css" rel="stylesheet"
type="text/css"/>
<link href="./resources/main.css"
rel="stylesheet" type="text/css"/>
<script
src="./resources/jquery/jquery.min.js"
type="text/javascript"></script>
<script
src="./resources/bootstrap/js/bootstrap.min.js"
type="text/javascript"></script>
<script>
function cetak() {
window.print();
}
</script>
</head>
<body style="background-color: #fff;"
onLoad="cetak()">
<div style="width: 800px; margin: 40px
auto;">
<h1 style="text-align: center;">CETAK
BUKTI PEMESANAN</h1>
<hr/>
<table style="width: 100%">
<tbody>
<tr>
<td style="width: 40%;
vertical-align: top;">
<h3>
Kode Pemesanan<br/>
<strong><?php echo
$rs['kode']; ?></strong><br/>
<small>Simpan kode
ini, dan gunakan kode ini untuk konfirmasi
pembayaran</small>
</h3>
<div class="jml">
<?php echo
$rs['status_pemesanan'] == 3 ? 'Lunas' : 'Belum
Dibayar'; ?>
</div>
</td>
<td style="padding-left:
60px;">
<table class="detail">
<tbody>
<tr>
<td
style="width: 220px;">Nama Pemesan</td>
<td
style="width: 20px;">:</td>
<td><?php
echo $rs['nama_pemesan']; ?></td>
</tr>
<tr>
<td
style="width: 220px;">Alamat</td>
<td
style="width: 20px;">:</td>
<td><?php
echo $rs['alamat_pemesan']; ?></td>
</tr>
<tr>
<td
style="width: 220px;">Telepon</td>
<td
style="width: 20px;">:</td>
<td><?php
echo $rs['telepon_pemesan']; ?></td>
</tr>
<tr>
<td
style="width: 220px;">Biro & Armada</td>
<td
style="width: 20px;">:</td>
<td><?php
echo $rsBiro['nama']; ?>, <?php echo
$rsArmada['nama']; ?></td>
</tr>
<tr>
<td
style="width: 220px;">Jurusan</td>
<td
style="width: 20px;">:</td>
<td><?php
echo $rsJadwal['jurusan']; ?></td>
</tr>
<tr>
<td
style="width: 220px;">Tanggal Pemesanan</td>
<td
style="width: 20px;">:</td>
<td><?php
echo date('d-m-Y',
strtotime($rs['tanggal_pemesanan'])); ?></td>
</tr>
<tr>
<td
style="width: 220px;">Tanggal Pemberangkatan</td>
<td
style="width: 20px;">:</td>
<td><?php
echo date('d-m-Y',
strtotime($rs['tanggal_pemberangkatan'])); ?></td>
</tr>
<tr>
<td
style="width: 220px;">Jam Pemberangkatan</td>
<td
style="width: 20px;">:</td>
<td><?php
echo date('H:i',
strtotime($rs['jam_pemberangkatan'])); ?> WIB</td>
</tr>
<tr>
<td
style="width: 220px;">Jumlah Pemesanan</td>
<td
style="width: 20px;">:</td>
<td><?php
echo $rs['jumlah_pemesanan']; ?> Tempat Duduk</td>
</tr>
<tr>
<td
style="width: 220px;">Harga @</td>
<td
style="width: 20px;">:</td>
<td><?php
echo number_format($rs['harga']); ?></td>
</tr>
<tr>
<td
style="width: 220px;">Jumlah Harga</td>
<td
style="width: 20px;">:</td>
<td><?php
echo number_format($rs['jumlah_harga']); ?></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
<?php
mysql_free_result($query);
mysql_free_result($queryJadwal);
mysql_free_result($queryBiro);
mysql_free_result($queryArmada);
7. Halaman Konfirmasi
<?php
$kode = '';
if (isset($_GET['kode'])) {
$kode = $_GET['kode'];
}
if (isset($_POST['simpan'])) {
$waktu = date('Y-m-d H:i:s');
mysql_query("insert into konfirmasi ("
. "waktu, kode, nama_bank,
nomor_rekening, nama_pengirim,
nomor_rekening_pengirim, jumlah_bayar,
status_konfirmasi) values ("
. "'".$waktu."', "
. "'".$_POST['kode']."', "
. "'".$_POST['nama_bank']."', "
. "'".$_POST['nomor_rekening']."', "
. "'".$_POST['nama_pengirim']."', "
.
"'".$_POST['nomor_rekening_pengirim']."', "
. "'".$_POST['jumlah_bayar']."', "
. "'0'"
. ")", $conn) or die (mysql_error());
echo '<script>window.location.href =
"?p=konfirmasi-sukses";</script>';
}
?>
<h1>Konfirmasi Pembayaran<br/>
<small>Isi formulir konfirmasi pembayaran di
bawah ini sesuai dengan data transfer anda</small>
</h1>
<hr/>
<form class="form-horizontal" method="post"
action="./?p=konfirmasi">
<div class="form-group">
<label for="kode" class="control-label col-
sm-4">Kode Pemesanan</label>
<div class="col-sm-8">
<input type="text" id="kode" name="kode"
class="form-control" value="<?php echo $kode; ?>"/>
</div>
</div>
<div class="form-group">
<label for="nama_bank" class="control-label
col-sm-4">Nama Bank Tujuan</label>
<div class="col-sm-8">
<input type="text" id="nama_bank"
name="nama_bank" class="form-control"/>
</div>
</div>
<div class="form-group">
<label for="nomor_rekening" class="control-
label col-sm-4">Nomor Rekening Tujuan</label>
<div class="col-sm-8">
<input type="text" id="nomor_rekening"
name="nomor_rekening" class="form-control"/>
</div>
</div>
<div class="form-group">
<label for="nama_pengirim" class="control-
label col-sm-4">Nama Pengirim</label>
<div class="col-sm-8">
<input type="text" id="nama_pengirim"
name="nama_pengirim" class="form-control"/>
</div>
</div>
<div class="form-group">
<label for="nomor_rekening_pengirim"
class="control-label col-sm-4">Nomor Rekening
Pengirim</label>
<div class="col-sm-8">
<input type="text"
id="nomor_rekening_pengirim"
name="nomor_rekening_pengirim" class="form-
control"/>
</div>
</div>
<div class="form-group">
<label for="jumlah_bayar" class="control-
label col-sm-4">Jumlah Transfer</label>
<div class="col-sm-8">
<input type="text" id="jumlah_bayar"
name="jumlah_bayar" class="form-control"/>
</div>
</div>
<hr/>
<div class="form-group">
<div class="col-sm-4"></div>
<div class="col-sm-8">
<input type="submit" name="simpan"
value="Konfirmasi" class="btn btn-primary"/>
</div>
</div>
</form>
8. Halaman Cek Status Pemesanan
<?php
$kode = '-1';
if (isset($_GET['kode'])) {
$kode = $_GET['kode'];
}
?>
<h1>Cek Status Pemesanan<br/>
<small>Masukkan kode pemesanan anda pada
formulir di bawah ini</small>
</h1>
<hr/>
<form class="form-horizontal" method="get"
action="./?p=pesanan">
<div class="form-group">
<label for="kode" class="control-label col-
sm-2">Kode Pemesanan</label>
<div class="col-sm-8">
<input type="text" id="kode" name="kode"
class="form-control" placeholder="Kode Pemesanan"/>
</div>
<input type="hidden" name="p"
value="pesanan"/>
<div class="col-sm-2">
<input type="submit" name="simpan"
value="Cek Status" class="btn btn-primary"/>
</div>
</div>
<hr/>
<table class="table table-striped">
<thead>
<tr>
<th>Kode</th>
<th>Nama Pemesan</th>
<th>Alamat Pemesan</th>
<th>Telepon Pemesan</th>
<th>Tanggal Pemesanan</th>
<th>Biro</th>
<th>Jurusan</th>
<th>Berangkat</th>
<th>Status Pembayaran</th>
</tr>
</thead>
<tbody>
<?php
$query = mysql_query("select * from
pemesanan where kode = '$kode'");
while ($row = mysql_fetch_array($query))
{
?>
<tr>
<td>
<a href="pemesanan-
cetak.php?id_pemesanan=<?php echo
$row['id_pemesanan']; ?>" target="_blank">
<?php echo $row['kode'];
?>
</a>
</td>
<td><?php echo
$row['nama_pemesan']; ?></td>
<td><?php echo
$row['alamat_pemesan']; ?></td>
<td><?php echo
$row['telepon_pemesan']; ?></td>
<td><?php echo date('d-m-Y',
strtotime($row['tanggal_pemesanan'])); ?></td>
<td>
<?php
$id_biro = $row['id_biro'];
$queryBiro =
mysql_query("select * from biro where id_biro =
'$id_biro'");
$rsBiro =
mysql_fetch_array($queryBiro);
echo $rsBiro['nama'];
mysql_free_result($queryBiro);
?>
</td>
<td>
<?php
$id_jadwal =
$row['id_jadwal'];
$queryJadwal =
mysql_query("select * from jadwal where id_jadwal =
'$id_jadwal'");
$rsJadwal =
mysql_fetch_array($queryJadwal);
echo $rsJadwal['jurusan'];
mysql_free_result($queryJadwal);
?>
</td>
<td>
<?php echo date('d-m-Y',
strtotime($row['tanggal_pemberangkatan'])); ?>
<?php echo date('H:i',
strtotime($row['jam_pemberangkatan'])); ?>
</td>
<td>
<?php echo
$row['status_pemesanan'] == 3 ? 'Sudah' : 'Belum';
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</form>