Andi. Ariyus, Dony dan Abas Ali Pange

134 Pages·2012·0.31 MB·English

DAFTAR PUSTAKA
Al Fatta, Hanif. 2007. Analisis dan Perancangan Sistem Operasi. Yogyakarta:
Andi.
Ariyus, Dony dan Abas Ali Pangera. 2010. Sistem Operasi. Yogyakarta: Andi.
Kadir, Abdul. 2008. Dasar Pemrograman Web Dinamis Menggunakan PHP.
Yogyakarta: Andi.
Kristanto, Andri. 2008. Perancangan Sistem Informasi dan Aplikasinya.
Yogyakarta: Gava Media.
Madcoms. 2011. Dreamweaver CS6 PHP –MySQL. Yogyakarta: Andi.
Mulyono, Hasyim. 2008. Pintar Komputer.Jakarta: Kriya Pustaka.
Nugroho, Bunafit. 2004. PHP dan MySQL dengan Editor Dreamweaver MX.
Yogyakarta: Andi.
Sanusi, Anwar. 2011. Metodologi Penelitian Bisnis. Jakarta: Salemba Empat.
Setiawan, Andi. 2004. Mudah Tepat Singkat Pemrograman HTML. Bandung:
Yrama Widya.
Sidik, Betha. 2012. Pemrograman Web dengan HTML. Bandung: Informatika.
Sunarfrihantono, Bimo. 2003. PHP dan MySQL untuk Web. Yogyakarta: Andi.
Sutabri, Tata. 2012. Analisis Sistem Informasi. Yogyakarta: Andi.
Wahana Komputer. 2004. Kamus Istilah Internet. Yogyakarta: Andi.
Wahana Komputer. 2010. Pengembangan Aplikasi Database Berbasis JavaDB
denganNetbeans. Yogyakarta: Andi.
<?php $querySpec =
mysql_query($sqlSpec);
require "database.php";
echo mysql_error();
$kode_spesifikasi =
strip_tags(mysql_real_escape_string $hasil =
($_GET['kode_spesifikasi'])); mysql_fetch_array($querySpec);
$jenis_perjalanan = ?>
strip_tags(mysql_real_escape_string
<td>Harga</td>
($_GET['jenis_perjalanan']));
<td><input readonly name="harga"
if(!empty($kode_spesifikasi) and
id="harga" type="text" size="11"
!empty($jenis_perjalanan)):
maxlength="11" value="<?php
if($jenis_perjalanan == 'Transfer if($jenis_perjalanan=='Transfer One
One Way'): Way') : echo
$hasil['transfer_one_way'];
$sqlSpec = "SELECT
elseif($jenis_perjalanan=='Dalam
transfer_one_way FROM
Kota'): echo
spesifikasi_bus WHERE
$hasil['dalam_kota'];elseif($jenis_pe
kode_spesifikasi =
rjalanan=='Luar Kota'): echo
'$kode_spesifikasi'";
$hasil['luar_kota'];endif?>"
elseif($jenis_perjalanan == 'Dalam placeholder="Harga"/></td>
Kota'):
<?php endif;?>
$sqlSpec = "SELECT dalam_kota
FROM spesifikasi_bus WHERE
kode_spesifikasi = <?php
'$kode_spesifikasi'";
require "database.php";
elseif($jenis_perjalanan == 'Luar
$kode_kamar =
Kota'):
strip_tags(mysql_real_escape_string
$sqlSpec = "SELECT ($_GET['kode_kamar']));
luar_kota FROM spesifikasi_bus
$sqlHarga = "SELECT harga FROM
WHERE kode_spesifikasi =
kamar_hotel WHERE kode_kamar =
'$kode_spesifikasi'";
'$kode_kamar'";
endif;
$queryHarga =
mysql_query($sqlHarga);
$hasil = $hasil =
mysql_fetch_array($queryHarga); mysql_fetch_array($queryPaket);
?> ?>
<td>Harga</td> <?php endif;?>
<td><input readonly name="harga" <input readonly name="total_biaya"
id="harga" type="text" size="11" id="total_biaya" type="text"
maxlength="11" value="<?php echo size="11" value="<?php echo
$hasil['harga']?>" $hasil['harga'];?>" maxlength="11"
placeholder="Harga"/></td> placeholder="Total Biaya"/>
<td><input readonly
name="kode_paket"
<?php
id="kode_paket" type="hidden"
require "database.php"; size="11" maxlength="11"
value="<?php echo
$cabin_cat =
$hasil['kode_paket'];?>"
strip_tags(mysql_real_escape_string
placeholder="Kode Paket"/></td>
($_GET['cabin_cat']));
$masa_perjalanan =
strip_tags(mysql_real_escape_string <option value="">[Pilih
($_GET['masa_perjalanan'])); Hotel]</option>
if(!empty($cabin_cat) and <?php
!empty($masa_perjalanan)):
$kota =
$sqlPaket = "SELECT strip_tags(mysql_real_escape_string
kode_paket,harga FROM paket ($_GET['kota']));
WHERE cabin_cat = '$cabin_cat'
require "database.php";
AND
masa_perjalanan='$masa_perjalanan $sqlHotel = "SELECT
'"; nama,kode_hotel FROM hotel
WHERE kota='$kota'";
$queryPaket =
mysql_query($sqlPaket); $queryHotel =
mysql_query($sqlHotel);
echo mysql_error();
while($hotel =
mysql_fetch_array($queryHotel)):
?> </tr>
<option value="<?php echo <tr>
$hotel['kode_hotel']?>"><?php echo
<td>Foto</td>
$hotel['nama'];?></option>
<td><input name="foto"
<?php endwhile;?>
type="file"
onchange="readURL(this);" /></td>
<?php <img id="upload1"
src="assets/img/no-image.png"
//panggil halama cek_sesi.php
alt="" />
require "cek_sesi.php";
</tr>
?>
<tr>
<h3>Tambah Bus</h3>
<td>&nbsp;</td>
<hr />
<td>
<form action="bus-add-proses.php"
<input name="" type="submit"
method="post"
value="Simpan" />
enctype="multipart/form-data">
<a href="index.php?p=master-
<table width="400" border="0"
bus"><input name="" type="button"
cellspacing="0" cellpadding="5">
value="Batal" /></a>
<tr>
</td>
<td width="144">Nama</td>
</tr>
<td width="236"><input
</table>
name="nama" type="text" size="25"
placeholder="Nama Bus"/></td> </form>
</tr> <script type="text/javascript">
<tr> function readURL(input) {
<td>Alamat</td> if (input.files && input.files[0]) {
<td><textarea name="alamat" var reader = new FileReader();
id="alamat" cols="30"
reader.onload = function (e) {
rows="5"></textarea></td>
$('#upload1').attr('src', echo "<script>alert('Harap
e.target.result); lengkapi semua data.');history.go(-
1);</script>";
}
exit();
reader.readAsDataURL(input.files[0 endif;
]);
$sqlCek = "SELECT nama FROM
} bus WHERE nama='$nama'";
} $queryCek =
mysql_query($sqlCek);
</script>
if(mysql_num_rows($queryCek) >
0):
<?php
list($nama) =
require "database.php"; mysql_fetch_row($queryCek);
//inisialisasi variabel echo "<script>alert('Maaf,
data perusahaan bus dengan nama
$nama =
".$nama." sudah ada. Harap
strip_tags(mysql_real_escape_string
masukkan data bus
($_POST['nama']));
lain.');location.href='index.php?p=ta
$alamat = mbah-bus';</script>";
strip_tags(mysql_real_escape_string
exit();
($_POST['alamat']));
else:
$foto = $_FILES['foto']['name'];
if(move_uploaded_file($tmp_
$nama_foto =
foto,
rand(000,999).$_FILES['foto']['nam
"img/Gallery/bus/".$nama_foto)):
e'];
$sqlSave = "INSERT
$tmp_foto =
INTO bus SET
$_FILES['foto']['tmp_name'];
nama='$nama',alamat='$alamat',foto
if(empty($nama) or empty($alamat) ='$nama_foto'";
or empty($foto)):
$querySave =
mysql_query($sqlSave);
if($querySave): <input type="hidden"
name="p" value="<?php echo
echo
$_GET['p'];?>">
"<script>alert('Data bus berhasil
disimpan!');location.href='index.php <table border="0"
?p=master-bus';</script>"; cellpadding="5">
exit(); <tr>
else: <td>
echo
"<script>alert('Data bus gagal <select name="field"
disimpan!');history.go(- id="field">
1);</script>";
exit(); <option value="">[Cari
Berdasarkan]</option>
endif;
endif;
<option
endif; value="a.nama">Nama
Pemesan</option>
?>
<option
<?php value="b.nama">Nama
Bus</option>
require "cek_sesi.php";
require "database.php";
<option
value="a.kode_pesan_bus">Kode
require "paginator.class.php";
Pemesanan</option>
?>
<h3>Bus Reservation List</h3>
<option value="a.tgl_pesan-
periode">Periode</option>
<hr />
<div class="inline">
<option value="a.tgl_pesan-
<form action="" class="pull- tgl">Tanggal</option>
right">
<th>Alamat</th>
</select>
<th>No.
</td> Handphone</th>
<td><input <th>Nama
type="text" width="25" Bus</th>
name="keyword" maxlength="25"
placeholder="Cari Bus"></td>
<th>Spesifikasi</th>
<td><input
<th>Jenis
type="submit" value="Cari"></td>
Perjalanan</th>
<td><a
<th>Tanggal
target="_blank" href="cetak-
Pergi</th>
pemesanan-bus.php?field=<?php
echo <th>Tanggal
$_GET['field']?>&keyword=<?php Pulang</th>
echo $_GET['keyword'];?>"
<th>Lama
targe"_blank"><input type="button"
Sewa</th>
value="Cetak"></a></td>
<th>Jumlah
</tr>
Bus</th>
</table>
<th>Total
</form> Biaya</th>
</div> <th>Biaya
Admin</th>
<div class="grid" style="overflow-
x:auto;width:100%;"> <th>Total
Keseluruhan</th>
<table class="table"
cellpadding="5" border="1"> <th>Action</th>
<thead> </thead>
<th>No.</th> <tbody>
<th>Tgl. <?php
Pesan</th>
$field =
<th>Nama </th> $_GET['field'];
$keyword = elseif($pecah[0] ==
$_GET['keyword']; 'Agustus'):
if($field == $bulan = "08";
'a.tgl_pesan-periode'):
elseif($pecah[0] ==
$pecah = explode(' ', 'September'):
$keyword);
$bulan = "09";
if($pecah[0] ==
elseif($pecah[0] ==
'Januari'):
'Agustus'):
$bulan = "01";
$bulan = "10";
elseif($pecah[0] ==
elseif($pecah[0] ==
'Februari'):
'September'):
$bulan = "02";
$bulan = "11";
elseif($pecah[0] ==
elseif($pecah[0] ==
'Maret'):
'Desember'):
$bulan = "03";
$bulan = "12";
elseif($pecah[0] ==
endif;
'April'):
$keyword =
$bulan = "04";
$pecah[1]."-".$bulan;
elseif($pecah[0] ==
$belah =
'Mei'):
explode('-', $field);
$bulan = "05";
$field =
elseif($pecah[0] == $belah[0];
'Juni'):
elseif($field ==
$bulan = "06"; 'a.tgl_pesan-tgl'):
elseif($pecah[0] == $keyword =
'Juli'): $_GET['keyword'];
$bulan = "07"; $belah =
explode('-', $field);
$field = $sql .= " AND
$belah[0]; $field LIKE '%$keyword%'";
else: endif;
$keyword = $sql .= " ORDER
$_GET['keyword']; BY a.kode_pesan_bus ASC";
endif; $page-
>items_total =
//buat kelas
mysql_num_rows(mysql_query($sql
paginator baru dengan nama $page
));
$page = new
$page-
paginator();
>paginate();
//atur jumlah
$sql .= " $page-
baris per halaman
>limit";
$page-
$query =
>items_per_page = 10;
mysql_query($sql);
//mengambil
echo
semua data dari tabel datagaji
mysql_error();
$sql = "SELECT
$prevPage =
a.kode_pesan_bus,a.nama,a.alamat,a
(int)$_GET['page']-1;
.no_hp,b.nama as
nama_bus,c.spesifikasi,a.jenis_perjal $i =
anan,a.tgl_pergi,a.tgl_pulang,a.lama $prevPage*(int)$_GET['ipp']+1;
_sewa,a.jumlah_bus,a.total_sewa,a.b
while($result =
iaya_admin,a.total_keseluruhan,a.tgl
mysql_fetch_array($query)):
_pesan FROM pemesanan_bus a,
bus b, spesifikasi_bus c WHERE ?>
a.kode_bus = b.kode_bus AND
<tr>
a.kode_spesifikasi =
c.kode_spesifikasi"; <td
style="text-align:center;"><?php
if(!empty($field)
echo $i;?></td>
AND !empty($keyword)):
<td><?php
echo $result['tgl_pesan'];?></td>
<td><?php <td>Rp.
echo $result['nama'];?></td> <?php echo
number_format($result['total_keselu
<td><?php
ruhan']);?>,-</td>
echo $result['alamat'];?></td>
<td
<td><?php
style="text-align:center;">
echo $result['no_hp'];?></td>
<a
<td><?php
onclick="return confirm('Apakah
echo $result['nama_bus'];?></td>
anda yakin?');" href="bus-booking-
<td><?php delete.php?kode=<?php echo
echo $result['spesifikasi'];?></td> $result['kode_pesan_bus'];?>">
Hapus</a>
<td><?php
echo </td>
$result['jenis_perjalanan'];?></td>
</tr>
<td><?php
<?php
echo $result['tgl_pergi'];?></td>
$i++;
<td><?php
echo $result['tgl_pulang'];?></td> endwhile;?>
<td><?php </tbody>
echo $result['lama_sewa'];?>
</table>
Hari</td>
</div>
<td><?php
echo $result['jumlah_bus'];?> <div id="pagination">
Bus</td>
<ul class="pagination">
<td>Rp.
<?php echo $page-
<?php echo
>display_pages();?>
number_format($result['total_sewa']
);?>,-</td> </ul>
<td>Rp. </div>
<?php echo
number_format($result['biaya_admi
n']);?>,-</td>
<?php