37 lines
1.3 KiB
PHP
37 lines
1.3 KiB
PHP
<?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 );
|
|
?>
|