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