59 lines
3.0 KiB
PHP
59 lines
3.0 KiB
PHP
<?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);
|
|
?>
|