<?php
 include"inc/session.php";
  if(isset($_POST['prosesvalidation'])) {

  if($_POST['ppk_id']=='blank1')   {
  ?><script language="JavaScript">alert('Warning ! Mohon pilih data terlebih dahulu');
  document.location='?option=Update-Tracking'</script><?php
  }
  elseif($_POST['status']=='blank2') {
  ?><script language="JavaScript">alert('Warning ! Mohon pilih data terlebih dahulu');
  document.location='?option=Update-Tracking'</script><?php
  }
  else {


  $result=mysql_query("SELECT ppk_id,status,date_status FROM trac_status WHERE  ppk_id='".$_POST['ppk_id']."' AND status='".$_POST['status']."'");
  $row=mysql_fetch_array($result);
  $cek=mysql_num_rows($result);
  if($cek >0)   {




  ?><script language="JavaScript">alert('Maaf ! PPK ID <?php echo $_POST['ppk_id'];?> dengan status <?php echo status($row['status']);?> sudah pernah dilakukan sebelumnya');
  document.location='?option=Update-Tracking'</script><?php
  }
  else  {

  if($_POST['status']=='1') {

   $status='Delivery';
   }
    else if($_POST['status']=='2')  {
   $status='Customer Receipt';
   }
   else if($_POST['status']=='3')   {
   $status='Customer AP';
   }
   else if($_POST['status']=='4')   {
   $status='Customer Accounting';
   }
   else if($_POST['status']=='5')   {
   $status='Customer Finance';
   }
   else if($_POST['status']=='6')   {
   $status='Customer Buyer';
   }
   else if($_POST['status']=='7')   {
   $status='Complete';
   }
   else {
   $status='Tak ditemukan';
   }
  $Sql=mysql_query("INSERT INTO trac_status (ppk_id,status,date_status,id_user) VALUES
  ('".$_POST['ppk_id']."','".$_POST['status']."',NOW(),'".$_SESSION['SES_USER_ID']."')");

  if($Sql==true)    {
  ?><script language="JavaScript">alert('PPK ID <?php echo $_POST['ppk_id'];?> telah diupdate dengan status <?php echo $status;?>');
document.location='?option=Update-Tracking'</script><?php
  }


  else {
  echo"ERROR ".mysql_error()."";

  }
    }
  }
  }

  ?>