37 lines
1.4 KiB
PHP
37 lines
1.4 KiB
PHP
<?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);
|
|
?>
|