50 lines
1.4 KiB
PHP
50 lines
1.4 KiB
PHP
<?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'];
|
|
$ohc_loc = $_POST['ohc_loc'];
|
|
|
|
|
|
|
|
if(!empty( $_POST['box_number'] )){
|
|
$param = "si.amb_no_box_code='".$_POST['box_number']."'";
|
|
}
|
|
if(!empty( $_POST['ambulance_number'] )){
|
|
$param = "si.amb_no_box_code='".$_POST['ambulance_number']."'";
|
|
}
|
|
if(!empty( $_POST['p_id'] )){
|
|
$param = "si.amb_no_box_code='".$_POST['ambulance_number']."'";
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$sql_stock_item = "SELECT distinct(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
|
|
JOIN stock_issue si ON si.stock_issue_id=s.stock_issue_id
|
|
WHERE $param 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);
|