Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $tanggal=WKT(date("Y-m-d"));
- $pro="simpan";
- $gambar0="avatar.jpg";
- //$PATH="ypathcss";
- ?>
- <link type="text/css" href="<?php echo "$PATH/base/";?>ui.all.css" rel="stylesheet" />
- <script type="text/javascript" src="<?php echo "$PATH/";?>jquery-1.3.2.js"></script>
- <script type="text/javascript" src="<?php echo "$PATH/";?>ui/ui.core.js"></script>
- <script type="text/javascript" src="<?php echo "$PATH/";?>ui/ui.datepicker.js"></script>
- <script type="text/javascript" src="<?php echo "$PATH/";?>ui/i18n/ui.datepicker-id.js"></script>
- <script type="text/javascript">
- $(document).ready(function(){
- $("#tanggal").datepicker({
- dateFormat : "dd MM yy",
- changeMonth : true,
- changeYear : true
- });
- });
- </script>
- <script type="text/javascript">
- function PRINT(){
- win=window.open('wisata/print.php','win','width=1000, height=400, menubar=0, scrollbars=1, resizable=0, location=0, toolbar=0, keterangan=0'); }
- </script>
- <script language="JavaScript">
- function buka(url) {window.open(url, 'window_baru', 'width=800,height=600,left=320,top=100,resizable=1,scrollbars=1');}
- </script>
- <?php
- $sql="select `id_wisata` from `$tbwisata` order by `id_wisata` desc";
- $q=mysqli_query($conn, $sql);
- $jum=mysqli_num_rows($q);
- $th=date("y");
- $bl=date("m")+0;if($bl<10){$bl="0".$bl;}
- $kd="WIS".$th.$bl;//KEG1610001
- if($jum > 0){
- $d=mysqli_fetch_array($q);
- $idmax=$d["id_wisata"];
- $bul=substr($idmax,5,2);
- $tah=substr($idmax,3,2);
- if($bul==$bl && $tah==$th){
- $urut=substr($idmax,7,3)+1;
- if($urut<10){$idmax="$kd"."00".$urut;}
- else if($urut<100){$idmax="$kd"."0".$urut;}
- else{$idmax="$kd".$urut;}
- }//==
- else{
- $idmax="$kd"."001";
- }
- }//jum>0
- else{$idmax="$kd"."001";}
- $id_wisata=$idmax;
- ?>
- <?php
- if($_GET["pro"]=="ubah"){
- $id_wisata=$_GET["kode"];
- $sql="select * from `$tbwisata` where `id_wisata`='$id_wisata'";
- $d=getField($conn,$sql);
- $id_wisata=$d["id_wisata"];
- $nama_wisata=$d["nama_wisata"];
- $telepon=$d["telepon"];
- $alamat=$d["alamat"];
- $latitude=$d["latitude"];
- $longitude=$d["longitude"];
- $deskripsi=$d["deskripsi"];
- $keterangan=$d["keterangan"];
- $gambar=$d["gambar"];
- $gambar0=$d["gambar"];
- $pro="ubah";
- }
- ?>
- <?php
- if($_GET["pro"]=="tambah" ||$_GET["pro"]=="ubah" ){
- ?>
- <div STYLE=" height: 100%; width: 100%; font-size: 12px; overflow: auto;">
- <form action="" method="post" enctype="multipart/form-data">
- <table class="table table-striped table-bordered table-hover" width="47%" >
- <tr>
- <th width="164"><label for="id_wisata">ID wisata</label>
- <th width="11">:
- <th colspan="2"><b><?php echo $id_wisata;?></b></tr>
- <tr>
- <td><label for="nama_wisata">Nama wisata</label>
- <td>:<td width="415"><input name="nama_wisata" type="text" id="nama_wisata" value="<?php echo $nama_wisata;?>" size="25" />
- </td>
- </tr>
- <tr>
- <td height="24"><label for="telepon">Telepon</label>
- <td>:<td><input name="telepon" type="text" id="telepon" value="<?php echo $telepon;?>" size="15" /></td>
- </tr>
- <tr>
- <td height="24"><label for="alamat">Alamat</label>
- <td>:<td><textarea name="alamat" cols="35" rows="3" id="alamat"><?php echo $alamat;?></textarea>
- </td>
- </tr>
- <tr>
- <td height="24"><label for="latitude">Latitude</label>
- <td>:<td><input name="latitude" type="text" id="latitude" value="<?php echo $latitude;?>" size="20" />
- </td>
- </tr>
- <tr>
- <td height="24"><label for="longitude">Longitude</label>
- <td>:<td><input name="longitude" type="longitude" id="longitude" value="<?php echo $longitude;?>" size="20" />
- </td>
- </tr>
- <tr>
- <td height="24"><label for="deskripsi">Deskripsi</label>
- <td>:<td><textarea name="deskripsi" cols="45" rows="4" id="deskripsi"><?php echo $deskripsi;?></textarea>
- </td>
- </tr>
- <tr>
- <td><label for="keterangan">Keterangan</label>
- <td>:<td colspan="2">
- <textarea name="keterangan" cols="35" rows="3" id="keterangan"><?php echo $keterangan;?></textarea>
- </td></tr>
- <tr>
- <td height="24"><label for="gambar">Gambar</label>
- <td>:<td colspan="2">
- <input name="gambar" type="file" id="gambar" size="20" />
- => <a href='#' onclick='buka("admin/zoom.php?id=<?php echo $kode_admin;?>")'><?php echo $gambar0;?></a></td>
- </tr>
- <tr>
- <td>
- <td>
- <td colspan="2"><input name="Simpan" class="btn btn-success" type="submit" id="Simpan" value="Simpan" />
- <input name="pro" type="hidden" id="pro" value="<?php echo $pro;?>" />
- <input name="gambar0" type="hidden" id="gambar0" value="<?php echo $gambar0;?>" />
- <input name="id_wisata" type="hidden" id="id_wisata" value="<?php echo $id_wisata;?>" />
- <input name="id_wisata0" type="hidden" id="id_wisata0" value="<?php echo $id_wisata0;?>" />
- <a href="?mnu=wisata"><input name="Batal" class="btn btn-danger" type="button" id="Batal" value="Batal" /></a>
- </td></tr>
- </table>
- </form>
- </div>
- <?php }
- else {?>
- <a class="blue" href="?mnu=wisata&pro=tambah"><button type="button" class="btn btn-info"><i class="fa fa-plus-square"></i> Tambah Data </button></a>
- <p>
- Data wisata: | <img src='ypathicon/print.png' alt='PRINT' OnClick="PRINT()"> |
- </p>
- <br>
- <table id="bootstrap-data-table-export" class="table table-striped table-bordered" width="100%" border="0">
- <thead>
- <tr bgcolor="#cccccc">
- <th width="3%">No</td>
- <th width="9%">Gambar</td>
- <th width="66%">Nama wisata</td>
- <th width="14%">Telepon</td>
- <th width="8%">Menu</td>
- </tr>
- </thead>
- <tbody>
- <?php
- $sql="select * from `$tbwisata` order by `id_wisata` desc";
- $jum=getJum($conn,$sql);
- if($jum > 0){
- $no =1;
- //--------------------------------------------------------------------------------------------
- $arr=getData($conn,$sql);
- foreach($arr as $d) {
- $id_wisata=$d["id_wisata"];
- $nama_wisata=$d["nama_wisata"];
- $telepon=$d["telepon"];
- $alamat=$d["alamat"];
- $latitude=$d["latitude"];
- $longitude=$d["longitude"];
- $deskripsi=$d["deskripsi"];
- if(strlen($deskripsi)>250){$deskripsi=substr($deskripsi." ...",0,250);}
- $keterangan=$d["keterangan"];
- $gambar=$d["gambar"];
- $gambar0=$d["gambar"];
- $color="#dddddd";
- if($no %2==0){$color="#eeeeee";}
- echo"<tr bgcolor='$color'>
- <td>$no</td>
- <td><div align='center'>";
- echo"<a href='#' onclick='buka(\"wisata/zoom.php?id=$id_wisata\")'>
- <img src='$YPATH/$gambar' width='40' height='40' /></a></div>";
- echo"</td>
- <td><b>$nama_wisata</b> ($id_wisata)</br>
- <b>Alamat :</b> <i>$alamat</i><br>Lat : $latitude - Lon : $longitude</br></br>
- <b>Keterangan :</b> $keterangan</br></br>
- <b>Deskripsi :</b> <i>$deskripsi</i></td>
- <td>$telepon</td>
- <td><div align='center'>
- <a href='?mnu=wisata&pro=ubah&kode=$id_wisata'><button type='button' class='btn-primary'><i class='fa fa-refresh'></i></button></a> <br><br>
- <a href='?mnu=wisata&pro=hapus&kode=$id_wisata'>
- <button type='button' class='btn-danger'
- onClick='return confirm(\"Apakah Anda benar-benar akan menghapus $nama_wisata pada data wisata ?..\")'><i class='fa fa-trash-o'></i></button></a></div></td>
- </tr>";
- $no++;
- }//while
- }//if
- else{echo"<tr><td colspan='6'><blink>Maaf, Data wisata belum tersedia...</blink></td></tr>";}
- ?>
- </tbody>
- </table>
- <?php } ?>
- <?php
- if(isset($_POST["Simpan"])){
- $pro=strip_tags($_POST["pro"]);
- $id_wisata=strip_tags($_POST["id_wisata"]);
- $id_wisata0=strip_tags($_POST["id_wisata"]);
- $nama_wisata=strip_tags($_POST["nama_wisata"]);
- $telepon=strip_tags($_POST["telepon"]);
- $alamat=strip_tags($_POST["alamat"]);
- $latitude=strip_tags($_POST["latitude"]);
- $longitude=strip_tags($_POST["longitude"]);
- $deskripsi=$_POST["deskripsi"];
- $keterangan=strip_tags($_POST["keterangan"]);
- $gambar0=strip_tags($_POST["gambar0"]);
- if ($_FILES["gambar"] != "") {
- @copy($_FILES["gambar"]["tmp_name"],"$YPATH/".$_FILES["gambar"]["name"]);
- $gambar=$_FILES["gambar"]["name"];
- }
- else {$gambar=$gambar0;}
- if(strlen($gambar)<1){$gambar=$gambar0;}
- if($pro=="simpan"){
- $sql=" INSERT INTO `$tbwisata` (
- `id_wisata` ,
- `nama_wisata` ,
- `telepon` ,
- `alamat` ,
- `latitude` ,
- `longitude` ,
- `deskripsi` ,
- `keterangan` ,
- `gambar`
- ) VALUES (
- '$id_wisata',
- '$nama_wisata',
- '$telepon',
- '$alamat',
- '$latitude',
- '$longitude',
- '$deskripsi',
- '$keterangan',
- '$gambar'
- )";
- $simpan=process($conn,$sql);
- if($simpan) {echo "<script>alert('Data $id_wisata berhasil disimpan !');document.location.href='?mnu=wisata';</script>";}
- else{echo"<script>alert('Data $id_wisata gagal disimpan...');document.location.href='?mnu=wisata';</script>";}
- }
- else{
- $sql="update `$tbwisata` set
- `nama_wisata`='$nama_wisata',
- `telepon`='$telepon',
- `alamat`='$alamat' ,
- `latitude`='$latitude',
- `longitude`='$longitude',
- `deskripsi`='$deskripsi',
- `keterangan`='$keterangan',
- `gambar`='$gambar'
- where `id_wisata`='$id_wisata0'";
- $ubah=process($conn,$sql);
- if($ubah) {echo "<script>alert('Data $id_wisata berhasil diubah !');document.location.href='?mnu=wisata';</script>";}
- else{echo"<script>alert('Data $id_wisata gagal diubah...');document.location.href='?mnu=wisata';</script>";}
- }//else simpan
- }
- ?>
- <?php
- if($_GET["pro"]=="hapus"){
- $id_wisata=$_GET["kode"];
- $sql="delete from `$tbwisata` where `id_wisata`='$id_wisata'";
- $hapus=process($conn,$sql);
- if($hapus) {echo "<script>alert('Data $id_wisata berhasil dihapus !');document.location.href='?mnu=wisata';</script>";}
- else{echo"<script>alert('Data $id_wisata gagal dihapus...');document.location.href='?mnu=wisata';</script>";}
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement