<?php
include('includes/config/config.php');
include('includes/functions.php');
$id = $_REQUEST['emp_id'];
$parameters = $_REQUEST['parameters'];
$startDate=$_REQUEST['startDate'];
$endDate=$_REQUEST['endDate'];


$key_param_name = array();
$checkup_parameter_ids = array();

 
$status_data = array();
$date_count = array();


$checkup_form="select checkup_id from checkup_form where emp_id='$id' and date_format(date(`checkup_date`),'%d-%m-%Y') BETWEEN date('$startDate') and DATE('$endDate') ";


$result_checkup_form = @mysqli_query($conn, $checkup_form);


$checkup_form_id='(';
    while($row_checkup_form_id=@mysqli_fetch_array($result_checkup_form)){
    $checkup_form_id.=$row_checkup_form_id["checkup_id"].',';
    }
$checkup_form_id.='0)';
error_log("total parameters ".$checkup_form_id);
for ($i = 0; $i < count($parameters); $i++) {
    

    $query = "SELECT a.column_name,b.key_param_name FROM `checkup_parameter` a left join key_health_reportable_parameter_master b on a.key_health_map_name=b.key_param_id WHERE a.key_health_map_name='".$parameters[$i]."' ";
    
    $key_name=getTableFieldValue('key_health_reportable_parameter_master','key_param_name','key_param_id',$parameters[$i]);

    $key_param_name+=array($parameters[$i]=>$key_name);
    $result = @mysqli_query($conn, $query);
    $param_date=array();
        $param_value=array();
        
    if (mysqli_num_rows($result) > 0) {
        while ($row = @mysqli_fetch_array($result)) {
         

          $checkup_form_key_value="select * from checkup_form_key_value where checkup_form_id in $checkup_form_id and checkup_form_key='".$row["column_name"]."' ";
          error_log("checkup_form_key_value:chart".$checkup_form_key_value);
          $result_checkup_form_key_value = @mysqli_query($conn, $checkup_form_key_value);
          if (mysqli_num_rows($result_checkup_form_key_value) > 0) {
          while($row_value=@mysqli_fetch_array($result_checkup_form_key_value)){
            if($row_value["checkup_form_value"]!='' ||$row_value["checkup_form_value"]!=null ){
                array_push($param_date,getTableFieldValue("checkup_form","date_format(date(`checkup_date`),'%d-%m-%Y')","checkup_id",$row_value["checkup_form_id"]) );
                array_push($param_value,$row_value["checkup_form_value"]);
            }    
          }}else{
            $param_date+=array(date('d-m-Y'));
            $param_value+=array(0);
          }
          
        }
        

        $checkup_parameter_ids+=array($parameters[$i]=>array($param_date,$param_value));
    }else{
        $checkup_parameter_ids+=array($parameters[$i]=>array(array(date('d-m-Y')),array(0)));
    }
   
}

$data = array(
    'key_param_name' => $key_param_name,
    'checkup_parameter' => $checkup_parameter_ids,
);
error_log("wellnes data" . print_r($data, true));
echo json_encode($data);