$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)); }