$store_id = $_POST['store_id'];
$search = stripslashes($search);
$store_id = stripslashes($store_id);
$store_id = mysql_real_escape_string($store_id);
$search = mysql_real_escape_string($search);
$result = mysqli_query($con, "select m.`medicine_id`, m.`medicine_name`, c.`name`, m.`manufacturer` \n\t\t\t\t\t\tfrom `medicine` as m join `category` as c \n\t\t\t\t\t\ton (m.category_id = c.category_id and m.`store_key` = '{$store_id}' and c.`store_key` = '{$store_id}' and m.`medicine_name` like '%{$search}%')");
$medicines = array();
$medicine_ids = array();
error_reporting(0);
while ($row = mysqli_fetch_array($result)) {
$medicines[$row['medicine_id']]['med_name'] = $row['medicine_name'];
$medicines[$row['medicine_id']]['cat_name'] = $row['name'];
$medicines[$row['medicine_id']]['mfg'] = $row['manufacturer'];
$medicine_ids[] = $row['medicine_id'];
}
list($records, $purchased, $sold, $return) = DhsHelper::getInventoryDetails($medicine_ids);
?>
<?php
if (!empty($medicines)) {
?>
<div style="font-size: 1.3em; border-bottom:1px solid #ccc;"><strong>Search Results</strong></div>
<table class="table table-stripped">
<thead>
<tr>
<th>#</th>
<th>Medicine Name</th>
<th>Type</th>
<th>Manufacturer</th>
<th>Available Quantity</th>
</tr>
</thead>
public function stock_details($request)
{
$compulsory = array('storeid');
$data = self::processRequestData($request, $compulsory, array());
if (!is_array($data)) {
return array('success_code' => '404', 'result' => $data);
}
$key = 0;
$records = array();
list($medicines, $purchased, $sold, $return) = DhsHelper::getInventoryDetails(0, null, $data['storeid']);
foreach ($medicines as $medicine) {
$medicine_id = $medicine['medicine_id'];
$purchase = isset($purchased[$medicine_id]) ? $purchased[$medicine_id]['quantity'] : 0;
$sell = isset($sold[$medicine_id]) ? $sold[$medicine_id]['quantity'] : 0;
$rturn = isset($return[$medicine_id]) ? $return[$medicine_id]['quantity'] : 0;
$records[$key]['medicine_id'] = $medicine_id;
$records[$key]['available_quantity'] = $purchase - $sell - $rturn;
$records[$key]['medicine_name'] = $medicine['medicine_name'];
$key++;
}
return array('success_code' => '200', 'result' => $records);
}
