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


$patient_id = $_POST['patient_id'];
$checkup_type = $_POST['checkup_type_iddm'];
$ticket_no = creatingCheckupTicketNo();
$exa_date = date('Y-m-d');


$checkup_section_ids = getFieldFromTable('checkup_form_section_ids','checkup_type','checkup_type_id',$checkup_type);

// error_log($patient_flex_id." <-flex".$patient_id."<-patient id".$checkup_type."<-chk type".$exa_date."<-  exa dipak");


$query = "insert into checkup_form set ticket_no='$ticket_no',emp_id= '$patient_id',checkup_type_id= '$checkup_type',checkup_section_ids = '$checkup_section_ids',checkup_date= '$exa_date',ohc_type_id='".$_SESSION['current_ohcttype']."',approve_date=STR_TO_DATE('" . $_POST['approve_date'] . "','%d/%m/%Y %h:%i %p'),valid_upto=STR_TO_DATE('" . $_POST['valid_upto_date'] . "','%d/%m/%Y'),doc_attend='" . $_SESSION['logged_user_empid'] . "',department='" . $department . "',designation='" . $designation . "', modified_by = '".$_SESSION['user_id']."'";

error_log("insert".$query);

if (!$result = @mysqli_query($conn,$query)) {
            exit(mysqli_error($conn));
}

$lastInsertedId = mysqli_insert_id($conn);

$dm = array(
    'checkup_id'=>$lastInsertedId,
    'checkup_type_id_db'=> getFieldFromTable('checkup_type_id','checkup_form','checkup_id',$lastInsertedId),
    'emp_id_history'=> $patient_id,
    
);
echo json_encode($dm);
?>