ESH/get_form_name.php
2024-10-23 18:28:06 +05:30

26 lines
1.0 KiB
PHP

<?php
include('includes/config/config.php');
include('includes/functions.php');
include('log_entry.php');
error_reporting(E_ERROR | E_PARSE);
$item_id = $_POST['item_id'];
$data = null;
$form_name_query = "select mf.is_qty_fixed from tbl_items tb left join medicine_form mf on tb.item_form_id = mf.form_id where tb.item_id='" . $item_id . "'";
error_log("checking if its qty is fixed or not " . $form_name_query);
$form_name_result = mysqli_query($conn, $form_name_query);
$form_name_qty = mysqli_fetch_assoc($form_name_result);
$data['is_qty_fixed'] = $form_name_qty['is_qty_fixed'];
// $appointment_id = $_POST['appointment_id'];
// $sql_treatment_qty = "select * from treatment where appointment_id='" . $appointment_id . "' and is_display!='N' and item_id='" . $item_id . "'";
// error_log("qyery ".$sql_treatment_qty);
// $res_treatment_qty = mysqli_query($conn, $sql_treatment_qty);
// $row_treatment_qty = mysqli_fetch_assoc($res_treatment_qty);
// $data['prev_issue_qty'] = $row_treatment_qty['issued_qty'];
echo json_encode($data);