50 lines
2.0 KiB
PHP
50 lines
2.0 KiB
PHP
<?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 = array();
|
|
|
|
|
|
$query = "SELECT DISTINCT a.column_name, b.key_param_name,b.key_param_id, cf.checkup_form_value, DATE_FORMAT(c.checkup_date, '%d-%m-%Y') AS checkup_date_formatted FROM `checkup_parameter` a LEFT JOIN key_health_reportable_parameter_master b ON a.key_health_map_name = b.key_param_id JOIN checkup_form_key_value cf ON a.column_name = cf.checkup_form_key JOIN checkup_form c ON cf.checkup_form_id = c.checkup_id WHERE a.key_health_map_name IN (" . implode(',', $parameters) . ") AND cf.checkup_form_id IN (SELECT checkup_id FROM checkup_form WHERE emp_id='$id' AND date(checkup_date) BETWEEN STR_TO_DATE('" . $startDate . "', '%d-%m-%Y') AND STR_TO_DATE('" . $endDate . "', '%d-%m-%Y'))";
|
|
|
|
error_log('wellness query:' . $query);
|
|
|
|
$result = mysqli_query($conn, $query);
|
|
|
|
|
|
foreach ($parameters as $param_id) {
|
|
$key_name = getTableFieldValue('key_health_reportable_parameter_master', 'key_param_name', 'key_param_id', $param_id);
|
|
$key_param_name[$param_id] = $key_name;
|
|
$checkup_parameter[$param_id] = array(array(), array());
|
|
}
|
|
|
|
while ($row = mysqli_fetch_array($result)) {
|
|
$param_id = $row['key_param_id'];
|
|
$param_date = $row['checkup_date_formatted'];
|
|
$param_value = $row['checkup_form_value'];
|
|
|
|
$checkup_parameter[$param_id][0][] = $param_date;
|
|
$checkup_parameter[$param_id][1][] = $param_value;
|
|
}
|
|
|
|
$data = array(
|
|
'key_param_name' => $key_param_name,
|
|
'checkup_parameter' => $checkup_parameter,
|
|
);
|
|
|
|
ksort($data['checkup_parameter']);
|
|
|
|
foreach ($data['checkup_parameter'] as &$parameterData) {
|
|
array_multisort(array_map('strtotime', $parameterData[0]), $parameterData[0], $parameterData[1]);
|
|
}
|
|
unset($parameterData);
|
|
|
|
error_log("wellness data" . print_r($data, true));
|
|
echo json_encode($data);
|