 <?php 
include('includes/config/config.php');
error_reporting(E_ERROR | E_PARSE);
$sample_id = $_POST['sample_id'];
$sampleDate =$_POST['sampleDate'];
$hygiene_id = $_POST['hygieneParameter'];
//echo $hygiene;
$hygSampleId =$_POST['sample'];
$commentAndRecommendation = $_POST['commentsAndRecommendations'];
$department = $_POST['department'];
$department_id = implode(',', $department);
$current_value = $_POST['currentValue'];

if(!empty($sample_id)){
    $query = "update work_area_sample_level set sample_date=STR_TO_DATE('".$_POST['sampleDate']."','%d/%m/%Y %h:%i %p'), hyg_sample_id = '$hygSampleId' ,department_ids = '$department_id' ,commentsAndRecommendations='$commentAndRecommendation',modified_by = '".$_SESSION['user_id']."' where sample_id = 
'".$sample_id."'    ";
}
else {
    $query = "insert into work_area_sample_level set  sample_date=STR_TO_DATE('".$_POST['sampleDate']."','%d/%m/%Y %h:%i %p'),hyg_sample_id = '$hygSampleId', department_ids = '$department_id' ,commentsAndRecommendations='$commentAndRecommendation',modified_by = '".$_SESSION['user_id']."'" ;
}
if (!$result = @mysqli_query($conn,$query)) {
	exit(mysqli_error($conn));
}
else{
	$id=mysqli_insert_id();
	if($id==0 or $id=='' or $id==null)
		$id=$sample_id;
	/*$query = "select max(sample_id) sample_id   from work_area_sample_level  ";
	if (!$result = @mysqli_query($conn,$query)) {
		exit(mysqli_error($conn));
	}
	if(mysqli_num_rows($result) > 0) {
		while ($row = mysqli_fetch_assoc($result)) {
				
			$sample_id_max = $row['sample_id'];
		}*/
	}


$parameterRow=$_REQUEST['parameterRow'];
//echo $parameterRow;
  for($i=0;$i<$parameterRow;$i++){
  	$intial_hyg_parameter="";
  	$end_hyg_parameter="";
  	if(isset($_REQUEST['hygieneParameter'.$i])){
  		$query_for_hyg_parameter=" set hyg_parameter_id='".$_REQUEST['hygieneParameter'.$i]."',hyg_param_val='".$_REQUEST['currentValue'.$i]."',work_area_sample_id='$id' ";
  		
  		if(isset($_REQUEST['parameter_record_id'.$i])){
  			$intial_hyg_parameter="update work_area_hyg_parameter";
  			$end_hyg_parameter=" where id='".$_REQUEST['parameter_record_id'.$i]."'";
  		}else{
  			$intial_hyg_parameter="insert into  work_area_hyg_parameter";
  			$end_hyg_parameter="";
  		}
  		$final_hyg_parameter=$intial_hyg_parameter.$query_for_hyg_parameter.$end_hyg_parameter;
  		//$query_for_hyg_parameter
  		  		//echo $query_for_hyg_parameter;
  		
  		 @mysqli_query($conn,$final_hyg_parameter);
  	}
  	
  	
  }
echo $query;


if($data==null)
{
	$data['status'] = 200;
	$data['message'] = "Data not found!";
}
 echo json_encode($data);
?>