<?php
// error_reporting(E_ERROR | E_PARSE);
include('includes/config/config.php');
include_once("log_entry.php");
$patient = $_POST['p_id'];
$box_number = $_POST['box_number'];
$ambulance_number = $_POST['ambulance_number'];


$sql_stock_item = "SELECT i.item_id,trim(concat(ifnull(f.form_name,''),' ',i.item_name)) item_name
FROM tbl_items i
JOIN medicine_form f ON i.item_form_id=f.form_id
JOIN stock_issue_items s ON i.item_id=s.item_id WHERE s.patient_id='$patient' and i.status='1' and i.is_group_item!='P' order by item_name;";
error_log("get item::" . $sql_stock_item);
if (!$result_stock_item = @mysqli_query($conn, $sql_stock_item)) {
    exit(mysqli_error($conn));
}
$data = array();
if (mysqli_num_rows($result_stock_item) > 0) {
    while ($row_stock_item = mysqli_fetch_assoc($result_stock_item)) {
        //extract($row);
        $data[] = $row_stock_item;
    }
} else {
    $data['status'] = 200;
    $data['message'] = "Data not found!";
}

echo  json_encode($data);