 <?php  
//  header('Content-Type: application/json');
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,'Task List','SAVE','save_task_master_status.php');
/**
** @var $data (Array) : contains recieved data
**/
$data = json_decode($_POST['data']);
$task_id = $data->task_id;
$trigger_date = $data->trigger_date;
$trigger_time = $data->trigger_time;
$task_status = $data->task_status;
echo "task status: ".$task_status;
$status_comment = $data->status_comment;

/**
** @purpose: query to watch if the data is present or not in the table if yes then upate or insert accordingly.
**/
$task_status_sql="select * from  task_master_status  where task_id='".$task_id."' and task_date='".$trigger_date."' ";
$task_status_result = @mysqli_query($conn,$task_status_sql);	
$task_status_num_rows=@mysqli_num_rows($task_status_result);
$task_status_row=@mysqli_fetch_array($task_status_result);
do {
	$count = $count+1;	
	$task_status_id = $task_status_row['id']; 
	}while($task_status_row=@mysqli_fetch_array($task_status_result));

if(!empty($task_status_id)){
$query = "update task_master_status set task_id = '$task_id', task_date = '$trigger_date', task_time = '$trigger_time', status = '$task_status', status_comment = '$status_comment', modified_by = '".$_SESSION['user_id']."' where task_id = '".$task_id."' and task_date='".$trigger_date."' ";
		  error_log('update query'.$query);
}
else {
$query = "insert into task_master_status (task_id, task_date, task_time, status, status_comment, modified_by) 
		  values ('$task_id','$trigger_date', '$trigger_time','$task_status', '$status_comment','".$_SESSION['user_id']."' ); ";
		  error_log('insert query'.$query);
}
if (!$result = @mysqli_query($conn,$query)) {
            exit(error_log(mysqli_error($conn)));
}
 else{
	
	// number of total records in task master status
	$query = "select max(id) id  from task_master_status  ";
	if (!$result = @mysqli_query($conn,$query)) {
		exit(mysqli_error($conn));
	}
	if(mysqli_num_rows($result) > 0) {
		while ($row = @mysqli_fetch_assoc($result)) {
			
			$task_status_id_max = $row['task_status_id'];
		}
	}

   $query = "select * from task_master_status where id='".$task_status_id_max."'";
   if (!$result = @mysqli_query($conn,$query)) {
		exit(mysqli_error($conn));
	}
	if(mysqli_num_rows($result) > 0) {
		while ($row = @mysqli_fetch_assoc($result)) {
			
			$data=$row;
		}
	}

	

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