35 lines
1.2 KiB
PHP
35 lines
1.2 KiB
PHP
<?php
|
|
include "includes/config/config.php";
|
|
include "log_entry.php";
|
|
include('includes/functions.php');
|
|
|
|
|
|
$ticketNo = $_REQUEST['ticket_no'];
|
|
|
|
$AppId = getFieldFromTable('appointment_id' , 'employee_appointment' , 'ticket_no' , $ticketNo);
|
|
|
|
$sql = "SELECT * From treatment a WHERE a.appointment_id = '".$AppId."'";
|
|
$query = mysqli_query($conn , $sql);
|
|
// $fetch = mysqli_fetch_assoc($query);
|
|
$data = array();
|
|
while($fetch = mysqli_fetch_assoc($query)){
|
|
|
|
$dm = [
|
|
'appointment_id' => $fetch['appointment_id'],
|
|
'ticket_no' => $fetch['ticket_no'],
|
|
'for_days' => $fetch['for_days'],
|
|
'item_qty' => $fetch['item_qty'],
|
|
'issued_qty' => $fetch['issued_qty'],
|
|
'dosage' => $fetch['dosage'],
|
|
'is_display' => $fetch['is_display'],
|
|
'timing' => getTableFieldValue('medicine_timings', 'timing_description', 'timing_id', $fetch['timing_id']),
|
|
'item_name' => getFieldFromTable('item_name' , 'tbl_items' , 'item_id' , $fetch['item_id']),
|
|
'frequency_name' => getFieldFromTable('medicine_frequency', 'medicine_frequency', 'frequency_id', $fetch['frequency_id']),
|
|
'dosage_category' =>getFieldFromTable("dosage_category", "dosage_category", "dosage_category_id", $fetch['dosage_category_id']),
|
|
];
|
|
|
|
array_push($data , $dm);
|
|
|
|
}
|
|
echo json_encode($data);
|
|
?>
|