126 lines
4.6 KiB
PHP
126 lines
4.6 KiB
PHP
<?php
|
|
error_reporting(E_ERROR | E_PARSE);
|
|
include ('includes/config/config.php');
|
|
include ('includes/functions.php');
|
|
include('log_entry.php');
|
|
$initial_query="";
|
|
$end_query="";
|
|
$noRows=$_POST['count_items'];
|
|
$indent_id=$_POST['indent_id0'];
|
|
error_log("indent id:".$indent_id);
|
|
// $item_id=$_POST['item_id'];
|
|
// error_log("item id ".$_POST['items_id']);
|
|
$indent_date = $_POST['indent_date0'];
|
|
$remarks = $_POST['remarks0'];
|
|
$ref_no = $_POST['indent_ref_no0'];
|
|
$rolecode = $_SESSION ['RoleCode'];
|
|
error_log("rows " .$noRows);
|
|
//for dirct send for approval on creation
|
|
$status=$_POST['status'];
|
|
if($status=='APPROVE'){
|
|
$app_date = date('Y/m/d');
|
|
}
|
|
//
|
|
// $item_id= implode(', ', $item_id);
|
|
// $indent_qty= implode(', ', $indent_qty);
|
|
error_log("indent qty ".$_POST['indent_qty']);
|
|
$data = array ();
|
|
|
|
begin();
|
|
if(!empty($indent_id)){
|
|
|
|
$initial_query="update indent_master set ";
|
|
$end_query="where indent_id='".$_POST['indent_id0']."' and ohc_type_id = '" . $_SESSION['current_ohcttype'] . "' ";
|
|
}else{
|
|
$month=date('n');
|
|
$year = date ( 'Y' );
|
|
|
|
if ($month > 3) {
|
|
$year = $year;
|
|
} else {
|
|
$year = $year - 1;
|
|
}
|
|
|
|
$query_indent_ref_no = "select max( CAST(substring(indent_ref_no,locate('-',indent_ref_no)+1,length(indent_ref_no)-(5+locate('-',indent_ref_no))) as UNSIGNED) ) from indent_master where ohc_type_id = '" . $_SESSION['current_ohcttype'] . "' and indent_ref_no like '%$year%'";
|
|
$result_indent_ref_no = @mysqli_query($conn,$query_indent_ref_no );
|
|
$row_indent_ref_no = mysqli_fetch_row ( $result_indent_ref_no );
|
|
$ref_no = 'IND-' . ($row_indent_ref_no [0] + 1) . '-' . $year;
|
|
|
|
$initial_query="insert into indent_master set indent_ref_no='$ref_no', ohc_type_id = '" . $_SESSION['current_ohcttype'] . "' ,";
|
|
$end_query="";
|
|
}
|
|
if ($rolecode == 'DOC') {
|
|
$final_query=$initial_query." indent_date=STR_TO_DATE('".$indent_date."','%d/%m/%Y'),remarks='".$remarks."',approving_doc_id='".$_SESSION['user_id']."',status='$status',approval_date ='$app_date' ".$end_query;
|
|
}else{
|
|
$final_query=$initial_query." indent_date=STR_TO_DATE('".$indent_date."','%d/%m/%Y'),remarks='".$remarks."',generated_by='".$_SESSION['user_id']."', status='$status',,approval_date ='$app_date' ".$end_query;
|
|
}
|
|
|
|
error_log("indent:: " .$final_query);
|
|
if (! $result = @mysqli_query ( $conn,$final_query )) {
|
|
error_log("Error saving indent:".mysqli_error($conn).": Query Failing: ".$final_query);
|
|
rollback();
|
|
exit(error_log(mysqli_error($conn)));
|
|
} else {
|
|
|
|
if (empty ( $_POST ['indent_id0'] )) {
|
|
|
|
// insert case when procuremnt id is not available but needed for saving into the child table
|
|
$query = "select indent_id from indent_master where indent_date=STR_TO_DATE('".$indent_date."','%d/%m/%Y') and ohc_type_id = '" . $_SESSION['current_ohcttype'] . "'";
|
|
//echo $query;
|
|
error_log("INDENT ID QUERY::" .$query);
|
|
if (! $result = @mysqli_query ( $conn,$query )) {
|
|
error_log("no result found: Query Failing: ".$query);
|
|
// rollback();
|
|
//exit(error_log(mysql_error()));
|
|
} else {
|
|
if (mysqli_num_rows ($result ) > 0) {
|
|
while ( $row = mysqli_fetch_assoc ( $result ) ) {
|
|
$data = $row;
|
|
$indent_id = $row ['indent_id'];
|
|
error_log("INDENT ID::" .$indentId);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
// clear existing entries into the child table
|
|
$query_del = " delete from indent_items where indent_id = '" .$indent_id. "' and ohc_type_id = '" . $_SESSION['current_ohcttype'] . "' ";
|
|
error_log("indent delete: ".$query_del);
|
|
|
|
if (!$result_del = @mysqli_query($conn,$query_del )) {
|
|
rollback();
|
|
exit(error_log(mysqli_error($conn)));
|
|
}
|
|
|
|
for($i = 0; $i <$noRows; $i ++) {
|
|
|
|
error_log("ROWS::" .$noRows);
|
|
|
|
// error_log("INDENT ID::" .$indentId);
|
|
|
|
if(isset(${"indent_qty$i"}) && ${"indent_qty$i"}!=null && ${"indent_qty$i"}!='' && ${"indent_qty$i"}>0){
|
|
|
|
|
|
|
|
$query1 = "insert into indent_items set indent_id='".$indent_id."', item_id ='" . ${"item_id$i"} . "',indent_qty='".${"indent_qty$i"}."',modified_by = '".$_SESSION['user_id']."', ohc_type_id = '" . $_SESSION['current_ohcttype'] . "' ";
|
|
error_log("indent item:: ".$query1);
|
|
if (!$result1 = @mysqli_query($conn,$query1)) {
|
|
error_log ("Exception saving stock_issue_items:".mysqli_error($conn)." failing query:".$query1);
|
|
rollback();
|
|
exit(mysqli_error($conn));
|
|
}
|
|
}
|
|
|
|
// $item_stock_query="select current_stock_level from tbl_items where item_id='".${"item_id$i"}."'";
|
|
}
|
|
|
|
commit();
|
|
|
|
if ($data == null) {
|
|
$data ['status'] = 200;
|
|
$data ['message'] = "Data not found!";
|
|
}
|
|
echo json_encode ( $data );
|
|
|
|
?>
|