<?php 
 error_reporting(E_ERROR | E_PARSE);
	include ('includes/config/config.php');
	include ('includes/functions.php');
	$noOfRows = $_POST ['count_items'];
	// echo $noOfRows;
	$stock_issue_id = $_POST ['stock_issue_id'];
	// $procurement_refno = $_POST['ref_no'];
	// echo $procurement_refno;
	$remarks = $_POST ['remarks'];
	$issue_date = $_POST ['issue_date'];
	// echo $procurement_id;
	$initquery = "";
	$data = array ();
	$data['approval_status']=$_POST['approval_status'];
	$endquery = "";
	$isuue_ref_no = "";
	if (! empty ( $stock_issue_id )) {
		// update case
		$initquery = "update stock_issue set  ";
		$endquery = " where stock_issue_id = '" . $stock_issue_id . "'   ";
		$data['stock_issue_id']=$stock_issue_id;
	} 
	$query = $initquery . " remarks='" . $remarks . "', ohc_location_id='".$_POST['ohc_loc']."',status='".$_POST['approval_status']."',issue_date = STR_TO_DATE('" . $issue_date . "','%d/%m/%Y') ,modified_by = '" . $_SESSION ['user_id'] . "' $endquery ";
	//echo $query;
	
    error_log("update_query:".$query);
	if (! $result = @mysqli_query($conn,$query )) {
        error_log("update_error:".mysqli_error($conn));
		exit ( mysqli_error($conn) );
	} 
	if ($data == null) {
		$data ['status'] = 200;
		$data ['message'] = "Data not found!";
	}
	echo json_encode ( $data );
?>