$sql = 'select m.medicine_name, invt.* from medicine as m inner join (select * from `inventory` ';
$sql .= 'where `store_key` = ' . "'" . $store_key . "'" . ' and `status` = ' . DHS_DISTRIBUTOR_INVENTORY_STATUS_VERIFIED;
$sql .= " and `barcode` = {$barcode} ) as invt on (m.medicine_id = invt.medicine_id)";
$result = mysqli_query($con, $sql);
$record = mysqli_fetch_array($result);
$record['unit_cost'] = DhsHelper::formatPrice($record['unit_cost']);
$record['subtotal'] = DhsHelper::formatPrice($record['subtotal']);
$record['total'] = DhsHelper::formatPrice($record['total']);
$record['mfg_date'] = DhsHelper::formatDate($record['mfg_date'], 'Y-m-d');
$record['expiry_date'] = DhsHelper::formatDate($record['expiry_date'], 'Y-m-d');
//$sold_rs = mysqli_query($con,'select sum(quantity) as sold from `cust_inventory` group by `barcode` where ');
echo '####' . json_encode($record) . '@@@@';
die;
break;
case "barcode_medicine":
$records = DhsHelper::getBarcodeDetails($barcode, $store_key);
echo '####' . json_encode($records) . '@@@@';
die;
break;
case "delete_medicine":
$id = $_REQUEST['medicine_id'];
if (!empty($id)) {
$sql = "update `medicine` set status=0 where medicine_id={$id}";
if (!($rs = mysqli_query($con, $sql))) {
die('Error' . mysql_error());
}
}
echo "<script>";
echo "window.location='index.php?view=medicine_details&menu=medicine'";
echo "</script>";
break;
public function barcode_details($request)
{
$compulsory = array('barcode', 'storeid');
$data = self::processRequestData($request, $compulsory, array());
if (!is_array($data)) {
return array('success_code' => '404', 'result' => $data);
}
$details = DhsHelper::getBarcodeDetails($data['barcode'], $data['storeid']);
return array('success_code' => '200', 'result' => array($details));
}
