29 lines
1.2 KiB
PHP
29 lines
1.2 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('log_entry.php');
|
|
include('includes/functions.php');
|
|
mysqli_query($conn,'SET character_set_results=utf8');
|
|
|
|
$itemId = $_REQUEST['id'];
|
|
$query = "select a.*,b.item_name,c.employer_contractor_name, c.employer_contractor_code from item_rate_change_history a left join tbl_items b on a.item_id=b.item_id left join employer_contractor c on b.vendor_id=c.id where procurement_item_id = '".$itemId."' order by last_modified desc ";
|
|
error_log("query: ".$query);
|
|
if (!$result = @mysqli_query($conn,$query)) {
|
|
exit(mysqli_error($conn));
|
|
}
|
|
$data = array();
|
|
if(mysqli_num_rows($result) > 0) {
|
|
while ($row = @mysqli_fetch_assoc($result)) {
|
|
$row['last_modified']=strtoupper(date_format(date_create($row['last_modified']), "d-M-Y "));
|
|
$row['modified_by']=getTableFieldValue("tbl_users","emp_id","user_id", $row['modified_by']);
|
|
$row['modified_by']=getTableFieldValue("patient_master","patient_name","id", $row['modified_by']);
|
|
array_push($data , $row);
|
|
// $data=$row;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
$data['status'] = 200;
|
|
$data['message'] = "Data not found!";
|
|
}
|
|
echo json_encode($data);
|
|
?>
|