Jumat, 03 Juli 2020

Layout Cari PHP




<?php
$pro="simpan";
$tanggal=WKT(date("Y-m-d"));
?>
<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>
   
 <link rel="stylesheet" href="jsacordeon/jquery-ui.css">
  <link rel="stylesheet" href="resources/demos/style.css">
<script src="jsacordeon/jquery-1.12.4.js"></script>
  <script src="jsacordeon/jquery-ui.js"></script>
  <script>
  $( function() {
    $( "#accordion" ).accordion({
      collapsible: true
    });
  } );
  </script>

 
<script type="text/javascript">

function PRINT(tgl){
win=window.open('pemasukanbarang/print.php?tgl='+tgl,'win','width=1000, height=400, menubar=0, scrollbars=1, resizable=0, location=0, toolbar=0, status=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
$pilih="bt";
$wkt=WKT(date("Y-m-d"));
$item=$ar[1]." ".$ar[0];

if(isset($_POST["Cari"])){
$pilih=$_POST["pilih"];
$item=$_POST["item"];
}
?>
<div id="accordion">
  <h3>Laporan Data Kegiatan</h3>
  <div>

<form action="" method="post" enctype="multipart/form-data">
<table class="table table-hover">


<tr>
<th><label for="id_keluar">Pencarian Berdasarkan:</label>
<th>
<select name="pilih" class="form-control" >
<option value="bt" <?php if($pilih=="bt"){echo"selected";}?>>Bulan Tahun</option>
<option value="id_kegiatan" <?php if($pilih=="id_kegiatan"){echo"selected";}?>>ID Kegiatan</option>
<option value="tgl" <?php if($pilih=="tgl"){echo"selected";}?>>Tanggal</option>
<option value="nama_pj" <?php if($pilih=="nama_pj"){echo"selected";}?>>Nama PJ</option>
<option value="jabatan_pj" <?php if($pilih=="jabatan_pj"){echo"selected";}?>>Jabatan PJ</option>
<option value="objek_kerja" <?php if($pilih=="objek_kerja"){echo"selected";}?>>Objek Kerja</option>
<option value="jenis_kerusakan" <?php if($pilih=="jenis_kerusakan"){echo"selected";}?>>Jenis Kerusakan</option>
<option value="lokasi" <?php if($pilih=="lokasi"){echo"selected";}?>>Lokasi</option>
<option value="ukuran" <?php if($pilih=="ukuran"){echo"selected";}?>>Ukuran</option>

<option value="status" <?php if($pilih=="status"){echo"selected";}?>>Status</option>

</select>
<th>Item Dicari
<th>
<input name="item" class="form-control" type="text" id="item" value="<?php echo $item;?>" size="15" />
<th >
<input name="Cari" type="submit" class="btn btn-success" id="Cari" value="Cari" />
<a href="?mnu=cari"><input name="Batal" class="btn btn-danger" type="button" id="Batal" value="Batal" /></a>
</th></tr>
</table>
</form>
<hr>


Data Pencarian   :

<table class="table table-bordered table-striped table-hover">
  <tr bgcolor="#CCCCCC">
    <th width="3%">No</th>
<th width="90%">List Kegiatan/Pelaporan</th>
  </tr>
<?php 

$bulan=date("m");
$tahun=date("Y");
$awal="$tahun-$bulan-01";
$ahir="$tahun-$bulan-31";
  $sql="select *  from `$tbkegiatan`   order by `id_kegiatan` desc ";
if(isset($_POST["Cari"])){
$pilih=trim($_POST["pilih"]);
$item=trim($_POST["item"]);

if($pilih=="bt"){
$ar=explode(" ",$item);
$bln=strtolower($ar[0]);
$bulan=1;
if($bln=="januari"|| $bln=="jan"){$bulan=1;}
else if($bln=="februari"|| $bln=="feb"){$bulan=2;}
else if($bln=="maret"|| $bln=="mar"){$bulan=3;}
else if($bln=="april"|| $bln=="apr"){$bulan=4;}
else if($bln=="mei"|| $bln=="mei"){$bulan=5;}
else if($bln=="juni"|| $bln=="jun"){$bulan=6;}
else if($bln=="juli"|| $bln=="jul"){$bulan=7;}
else if($bln=="agustus"|| $bln=="agu"){$bulan=8;}
else if($bln=="september"|| $bln=="sep"){$bulan=9;}
else if($bln=="oktober"|| $bln=="okt"){$bulan=10;}
else if($bln=="november"|| $bln=="nov"){$bulan=11;}
else if($bln=="desember"|| $bln=="des"){$bulan=12;}

$tahun=$ar[1];
$awal="$tahun-$bulan-01";
$ahir="$tahun-$bulan-31";
$sql="select * from `$tbkegiatan` where `tgl` between '$awal' and '$ahir' order by `id_kegiatan` desc ";
}
else
$sql="select * from `$tbkegiatan`where `$pilih` like '%$item%'";
}


   $jum=getJum($conn,$sql);
if($jum > 0){
$no=1;
$arr=getData($conn,$sql);
foreach($arr as $d) {
$id_kegiatan=$d["id_kegiatan"];
$id_kegiatan0=$d["id_kegiatan"];
$nama_pj=$d["nama_pj"];
$alamat_pj=$d["alamat_pj"];
$jabatan_pj=$d["jabatan_pj"];
$hari=$d["hari"];
$id_petugas=$d["id_petugas"];
$objek_kerja=$d["objek_kerja"];
$lokasi=$d["lokasi"];
$jenis_kerusakan=$d["jenis_kerusakan"];
$ukuran=$d["ukuran"];
$status=$d["status"];
$keterangan=$d["keterangan"];
$tgl=WKT($d["tgl"]);
$gab="<ol>";

$sqlg="select * from `$tblaporan` where `id_kegiatan`='$id_kegiatan'";
$arrg=getData($conn,$sqlg);
foreach($arrg as $dg) {
$id_laporan=$dg["id_laporan"];
$tgl2=WKT($dg["tgl"]);
$jam=$dg["jam"];
$kondisi_lapangan=$dg["kondisi_lapangan"];
$penanganan=$dg["penanganan"];
$keterangan2=$dg["keterangan"];
$gab.="<li>$penanganan Kondisi Lapangan : $kondisi_lapangan $tgl2 $jam wib</li>";
}
$gab.="</ol>";

$color="#dddddd";
if($no %2==0){$color="#eeeeee";}
echo"<tr bgcolor='$color'>
<td>$no</td>
<td>
<b>$objek_kerja: $jenis_kerusakan #Ukuran $ukuran, Lokasi $lokasi</b>
<br><i>Alamat $alamat_pj Pengerjaan $hari - $tgl  <br>PJ: $nama_pj ($jabatan_pj) </i>
<br>Catatan : $keterangan, Petugas: $id_petugas Status $status

<i>$gab<i></td>
</tr>";

$no++;
}//while
}//if
else{echo"<tr><td colspan='7'><blink>Maaf, Data pengeluaran barang belum tersedia...</blink></td></tr>";}
?>
</table>

</div>
</div>

Tidak ada komentar:

Posting Komentar

global_priv WARNING Selalu

 Jika muncul pesan kesalahan: Warning in .\libraries\classes\Dbal\DbiMysqli.php#209  mysqli::query(): (HY000/1034): Index for table 'glo...