80 lines
2.7 KiB
PHP
80 lines
2.7 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
include('log_entry.php');
|
|
error_log ( "Start Printing Request Attributes" );
|
|
$requestStr="";
|
|
foreach ( $_REQUEST as $key => $value ) {
|
|
$requestStr.=$key . " : " . $value . "\n";
|
|
error_log ( $key . " : " . $value . "<br />\r\n" );
|
|
}
|
|
error_log ( "End Printing Request Attributes" );
|
|
save_log($requestStr,'inventory parameters','SAVE','save_inventory_parameters.php');
|
|
error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE);
|
|
begin();
|
|
|
|
|
|
$status_id=$_POST['status_id'];
|
|
$shift=$_POST['shift'];
|
|
|
|
|
|
$param_id=$_POST['param_id'];
|
|
|
|
|
|
$param_year= $_POST['param_year'];
|
|
$param_month= $_POST['param_month'];
|
|
$issue_type=$_POST['issue_type'];
|
|
$amb_id=$_POST['amb_id'];
|
|
$shift=$_POST['shift'];
|
|
$item_cat=$_POST['item_cat'];
|
|
$status=$_POST['status'];
|
|
|
|
// $shift_status= implode(',',$_POST['shift_status']);
|
|
|
|
|
|
|
|
$query_initial="";
|
|
$endquery="";
|
|
if(!empty($status_id)){
|
|
$sql_del = "delete from inventory_parameters_status where status_id='$status_id'";
|
|
mysqli_query($conn,$sql_del);
|
|
}
|
|
|
|
|
|
// $ambulance_id = getFieldFromTable('id','ambulance_details_new
|
|
// ','ohc_type_id',$ohc_type_id);
|
|
error_log("ambulance_id ".$ambulance_id);
|
|
$query="insert into inventory_parameters_status set param_date=STR_TO_DATE('".$_POST['param_date']."','%d-%m-%Y'), param_id='".$param_id."',
|
|
param_status='".$_POST['param_status']."',shift='".$shift."',
|
|
param_remark='".$_POST['param_remark']."',ohc_type_id = '".$_SESSION['current_ohcttype']."' ,modified_by = '".$_SESSION['user_id']."' ,ambulance_id='".$_POST['ambulance_id']."' ".$endquery;
|
|
error_log("Ambulance paramters query details".$query);
|
|
//echo $query;
|
|
|
|
if (!$result = mysqli_query($conn,$query)) {
|
|
error_log ( "Exception:" . mysqli_error($conn) );
|
|
error_log ( "Failed to Execute the Personal info Query::: " . $query );
|
|
rollback();
|
|
exit(mysqli_error($conn));
|
|
}
|
|
|
|
commit();
|
|
$data=array();
|
|
$select_query_st= "select status_id from inventory_checklist_status where param_year='$param_year' and param_month='$param_month' and issue_type='$issue_type' and amb_id='$amb_id' and shift='$shift' and ohc_type_id = '".$_SESSION['current_ohcttype']."' ";
|
|
error_log("Ambulance paramters query details".$select_query_st);
|
|
$result_select_st = @mysqli_query($conn, $select_query_st);
|
|
$row_select_st= mysqli_fetch_array($result_select_st);
|
|
$st_id=$row_select_st["status_id"];
|
|
|
|
|
|
if($st_id=='' || $st_id==null || $st_id==0){
|
|
$is_inseted=0;
|
|
}else{
|
|
$is_inseted=1;
|
|
}
|
|
|
|
|
|
$data['max_st_id']=getTableFieldValue('inventory_parameters_status','max(status_id)','','');
|
|
$data['is_inseted']=$is_inseted;
|
|
error_log(print_r($data,true)) ;
|
|
echo json_encode($data);
|
|
?>
|