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