<?php
include('pdf_header_reverse.php');
$emp_id = $_POST['emp'];
$pro_schedule_id = $_POST['pro_id'];
error_log("emp id " . $emp_id . "  program schedule id " . $pro_schedule_id);
$data = array();

$query1 = "select * from checkup_form where emp_id = '" . $emp_id . "' and program_id='" . $pro_schedule_id . "' and program_status='N'";
$result1 = @mysqli_query($conn, $query1);
$row1 = @mysqli_fetch_assoc($result1);

$checkup_section_ids1 = $row1['checkup_section_ids'];
$param_present1 = (explode(',', $row1['checkup_section_ids']));
$param_present1 = array_unique($param_present1);
$i = 0;
foreach ($param_present1 as $x => $val) {
    $param_query1 = "select a.*,b.* from checkup_form_key_value a left join checkup_parameter b on a.checkup_form_key = b.column_name where a.checkup_form_id = '" . $row1['checkup_id'] . "' and checkup_form_section_id = '$val'";
    $param_result1 = @mysqli_query($conn, $param_query1);
    while ($row_param1 = @mysqli_fetch_assoc($param_result1)) {
        $data['names'][$i] = $row_param1['parameter_name'];
        if ($row_param1['input_type'] == 'select') {
            $data['pre'][$i] = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $row_param1['checkup_form_value']);
        } else if ($row_param1['input_type'] == 'multiselect') {
            $data['pre'][$i] = getCommaSeperatedValuesForInClause("select parameter_value_name from checkup_parameter_value", 'parameter_value_id', $row_param1['checkup_form_value']);
        } else {
            $data['pre'][$i] = $row_param1['checkup_form_value'];
        }
        $i++;
    }
}


$query2 = "select * from checkup_form where emp_id = '" . $emp_id . "' and program_id='" . $pro_schedule_id . "' and program_status='Y'";
$result2 = @mysqli_query($conn, $query2);
$row2 = @mysqli_fetch_assoc($result2);

$checkup_section_ids2 = $row2['checkup_section_ids'];
$param_present2 = (explode(',', $row2['checkup_section_ids']));
$param_present2 = array_unique($param_present2);
$j = 0;
foreach ($param_present2 as $x => $val) {
    $param_query2 = "select a.*,b.* from checkup_form_key_value a left join checkup_parameter b on a.checkup_form_key = b.column_name where a.checkup_form_id = '" . $row2['checkup_id'] . "' and checkup_form_section_id = '$val'";
    $param_result2 = @mysqli_query($conn, $param_query2);
    while ($row_param2 = @mysqli_fetch_assoc($param_result2)) {
        if ($row_param2['input_type'] == 'select') {
            $data['post'][$j] = getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $row_param2['checkup_form_value']);
        } else if ($row_param2['input_type'] == 'multiselect') {
            $data['post'][$j] = getCommaSeperatedValuesForInClause("select parameter_value_name from checkup_parameter_value", 'parameter_value_id', $row_param2['checkup_form_value']);
        } else {
            $data['post'][$j] = $row_param2['checkup_form_value'];
        }
        $j++;
    }
}
error_log("data " . json_encode($data));


echo json_encode($data);
?>