<?php
include '../../include/conf.php';

if($_POST['filed_date']!='' && $_POST['product_id']!='' && $_POST['reason']!='' && $_POST['qty']!=''){
	
	$date = date('Y-m-d', strtotime($_POST['filed_date']));
	
	$get_curr = mysqli_query($conn, "select * from tbl_malaysia_update_stock where product_id = '".$_POST['product_id']."' order by id desc limit 1");
	$rows = mysqli_num_rows($get_curr);
	if($rows > 0){
		$get_curr_stock = mysqli_fetch_array($get_curr, MYSQLI_ASSOC);
	    $reduce_stock = $get_curr_stock['current_stock'] -  $_POST['qty'];
		mysqli_query($conn, "update tbl_malaysia_update_stock set current_stock = '$reduce_stock' where product_id = '".$_POST['product_id']."' and id='".$get_curr_stock['id']."'");
		mysqli_query($conn, "INSERT INTO `tbl_malaysia_damaged_expired` (`filed_date`, `product_id`, `reason`, `qty`) VALUES ('$date', '$_POST[product_id]', '$_POST[reason]', '$_POST[qty]')");
		sleep(3);
		echo '1';
		
	}else{
		echo '2';
		exit;
	}
	
}else{ 
	echo '2';
}

?>