<?php
include_once('../../includes/db_connect.php'); 
header("Content-Type:application/json");
$date = date("Y-m-d H:i:s");
$year = date("Y");


//unit
if(isset($_POST["unitid"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["unitid"]));
  if(mysqli_query($con,"UPDATE units SET status='1' WHERE id = '$id'")){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
  if(isset($_POST["unitid2"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["unitid2"]));
  if(mysqli_query($con,"UPDATE units SET status='0' WHERE id = '$id'")){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
  if(isset($_POST["unitid3"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["unitid3"]));
  if(mysqli_query($con,"DELETE FROM units WHERE id = '$id'")){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
?>
<?php mysqli_close($con) ?>