<?php
include('includes/config/config.php');
include('log_entry.php');
include('includes/functions.php');
// include('includes/auth/auth.php');

$emp_id = $_REQUEST['emp_id'];
$chronic = $_POST['chronic'];
$chronic = implode(",", $chronic);
error_log("chronic " . $chronic);
$sql_get_disease = "SELECT * FROM `prescription_master` WHERE `diseases` in ($chronic) and emp_id = '" . $emp_id . "' order by medicine_name asc";

error_log("query to get treatment prescription " . $sql_get_disease);

$result_get_disease = $conn->query($sql_get_disease);

$sql_diagnosis_chronic = "select group_concat(ailment_id) as diagnosis_id from diagnosis_chronic_mapping where chronic_id in ($chronic)";
error_log("query to get mapped diagnosis " . $sql_diagnosis_chronic);
$result_diagnosis_chronic = mysqli_query($conn, $sql_diagnosis_chronic);
$row_diagnosis_chronic = mysqli_fetch_assoc($result_diagnosis_chronic);

$medicine = [];

if ($result_get_disease->num_rows > 0) {
    $count = $result_get_disease->num_rows;
    while ($row_get_disease = $result_get_disease->fetch_assoc()) {

        $med_get = "SELECT * FROM `tbl_items` WHERE `item_id`='$row_get_disease[medicine_name]';";
        $result_med_get = $conn->query($med_get);
        $row_med_get = $result_med_get->fetch_assoc();
        $medicine[$row_get_disease["medicine_name"]] = array(
            'name' => $row_med_get["item_name"],
            'frequency' => '',
            'freq_val' => '',
            'timing' => '',
            'admin_route' => '',
            'duration' => '',
            'dose' => '',
            'count' => $count,
            'is_prescription' => $row_med_get['is_prescription'],
            'health_advices' => getCommaSeperatedValuesForInClause("select health_advice_name from health_advice", 'health_advice_id', $row_get_disease['health_advices']),
            'diagnosis' => $row_diagnosis_chronic['diagnosis_id'],
        );

        $medicine[$row_get_disease["medicine_name"]]['frequency'] = $row_get_disease['medicine_frequency'];

        $medicine[$row_get_disease["medicine_name"]]['timing'] = $row_get_disease['medicine_timing'];


        $medicine[$row_get_disease["medicine_name"]]['admin_route'] = $row_get_disease['admin_route'];

        $medicine[$row_get_disease["medicine_name"]]['duration'] = $row_get_disease["duration"];

        //removing this because for dosage we are using same qty that is present in medicine_frequency
        // $medicine[$row_get_disease["medicine_name"]]['dose'] =  $row_get_disease["dose_qty"];

        $medicine[$row_get_disease["medicine_name"]]['dose']  = getFieldFromTable('qty', 'medicine_frequency', 'frequency_id', $row_get_disease['medicine_frequency']);

        $medicine[$row_get_disease["medicine_name"]]['freq_val'] =  getTableFieldValue('medicine_frequency', 'qty', 'frequency_id', $row_get_disease['medicine_frequency']);
    }


    error_log("final data " . print_r($medicine, true));
    echo json_encode($medicine);
}