//proses
<?php
session_start();
include "../../settings/connection.php";
include "../../settings/auth-admin.php";

if(isset($_GET["action"])){
  if($_GET["action"]=="save"){
    if(!empty($_POST["TglPemakaian"])&&!empty($_POST["KodeBarang"])&&!empty($_POST["JmlPemakaian"])){
      $barangada=false;
      $brg=mysql_query("select * from barang where KodeBarang='".$_POST["KodeBarang"]."'",$server_connect);
      if(mysql_num_rows($brg)>=1){$barangada=array();while($row=mysql_fetch_array($brg)){array_push($barangada,$row);break;}if($barangada[0]){$barangada=$barangada[0];}else{$barangada=false;}}
      if($barangada){
        $persediaanada=false;
        $prsd=mysql_query("Select * from persediaan_barang where KodeBarang='".$_POST['KodeBarang']."'",$server_connect);
        if(mysql_num_rows($prsd)>=1){$persediaanada=array();while($row=mysql_fetch_array($prsd)){array_push($persediaanada,$row);break;}if($persediaanada[0]){$persediaanada=$persediaanada[0];}else{$persediaanada=false;}}
        if($persediaanada){
          if($_POST["JmlPemakaian"]<=$persediaanada["StokTersedia"]){
            $simpan1=mysql_query("INSERT INTO `pemakaian` (`NoPemakaian`, `KodeBarang`, `TglPemakaian`, `JmlPemakaian`) VALUES (NULL, '".$_POST["KodeBarang"]."', '".date("Y-m-d", strtotime($_POST["TglPemakaian"]))."', '".$_POST["JmlPemakaian"]."')",$server_connect);
            $update1=mysql_query("Update persediaan_barang SET Pakai=Pakai + ".$_POST['JmlPemakaian'].",StokTersedia=StokTersedia - ".$_POST['JmlPemakaian']." Where KodeBarang='".$_POST['KodeBarang']."'",$server_connect);
            if($simpan1&&$update1){
              header("Location:../index.php?what=pemakaian&tab=input&input_success=true");
            }else{
              header("Location:../index.php?what=pemakaian&tab=input&input_fail=true");
            }
          }else{
            header("Location:../index.php?what=pemakaian&tab=input&less_stock=true");
          }
        }else{
          header("Location:../index.php?what=pemakaian&tab=input&empty_stock=true");
        }
      }else{
        header("Location:../index.php?what=pemakaian&tab=input&unknown_object=true");
      }
    }else{
      header("Location:../index.php?what=pemakaian&tab=input&empty_fields=true");
    }
  }else{
  	header("Location:../index.php?what=pemakaian&tab=data&error=true");
  }
}else{header("Location:../index.php?what=pemakaian&error=true");}
?>



//contents
//atas
<?php
$data=false;
?>

//select1
              <?php
              $databarang=array();
              $perintah="SELECT barang.KodeBarang, barang.NmBarang, barang.SatuanBarang, barang.KetBarang, persediaan_barang.StokTersedia
              FROM barang LEFT JOIN persediaan_barang ON barang.KodeBarang = persediaan_barang.KodeBarang WHERE persediaan_barang.StokTersedia>=1 GROUP BY barang.KodeBarang";
              $ambil=mysql_query($perintah,$server_connect);
              $forecho="";
              if(mysql_num_rows($ambil)>=1){while($row=mysql_fetch_array($ambil)){
                $databarang[$row['KodeBarang']]=$row["StokTersedia"];
                $forecho.="<option value='".$row['KodeBarang']."'";
                if($data){if($data["KodeBarang"]==$row['KodeBarang']){$forecho.=" selected";}}
                $forecho.=">".$row["NmBarang"]." | ".$row["StokTersedia"]." ".$row["SatuanBarang"]."</option>";
              }}else{$kosong=true;}
              echo $forecho;
              ?>

//tengah
<?php
$kolom=array(array("title"=>"No"),array("title"=>"Tanggal"),array("title"=>"Barang"),array("title"=>"Jumlah"));
$semua=array();

$ambil2s=mysql_query("SELECT * FROM pemakaian",$server_connect);
while($row=mysql_fetch_array($ambil2s)){
  /*
 	$act='<div class="input-group-btn">';
  $act.='<button type="button" class="btn btn-default dropdown-toggle btn-block btn-xs" data-toggle="dropdown">Opsi <span class="fa fa-caret-down"></span></button>';
  $act.='<ul class="dropdown-menu" style="right:0px;left:auto">';
  $act.='<li><a href="proses/pemakaian.php?action=edit&id='.$row["NoPemakaian"].'">Edit</a></li>';
  $act.='<li><a href="proses/pemakaian.php?action=delete&id='.$row["NoPemakaian"].'">Hapus</a></li>';
  $act.='</ul>';
  $act.='</div>';
  */

  $ambil2=mysql_query("Select * from barang where KodeBarang='".$row["KodeBarang"]."'",$server_connect);
  $ambil2ada=false;
  if(mysql_num_rows($ambil2)>=1){$ambil2ada=array();while($rows=mysql_fetch_array($ambil2)){array_push($ambil2ada,$rows);break;}if($ambil2ada[0]){$ambil2ada=$ambil2ada[0];}else{$ambil2ada=false;}}
  if($ambil2ada){$row["KodeBarang"]=$ambil2ada["NmBarang"];}else{$row["KodeBarang"]="Unknown";}

  $tupus=array($row["NoPemakaian"],date("d-m-Y", strtotime($row["TglPemakaian"])),$row["KodeBarang"],$row["JmlPemakaian"]);
  array_push($semua,$tupus);
}
?>

//bawah
<?php
if($databarang){
  echo "<script type='text/javascript'>window.data_barang=".json_encode($databarang)."</script>";
}
?>

<script type="text/javascript">
$("#KodeBarang").change(function(){
  var val=$("#KodeBarang").val();
  if(val&&data_barang&&data_barang[val]){
    $("#JmlPemakaian").attr("max",data_barang[val]);
  }
});
$("#JmlPemakaian").change(function(){
  var val=$("#KodeBarang").val();
  var val2=Number($("#JmlPemakaian").val());
  if(val&&val2&&data_barang&&data_barang[val]&&val2>Number(data_barang[val])){
    $("#JmlPemakaian").val(data_barang[val]);
  }
});



$(window).load(function(){
  $("#KodeBarang").change();
$("#JmlPemakaian").change();
$("#TglPemakaian").datepicker({
  "format":"dd-mm-yyyy",
  "startDate":"-14d",
  "endDate":"today",
  "todayBtn":"linked",
  "language":"id",
  "autoclose":true
});
});
</script>