76 lines
2.5 KiB
PHP
76 lines
2.5 KiB
PHP
|
<?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);
|
||
|
|
?>
|