<tbody>
<?php
$store_key = $_SESSION['mystoreid'];
$result = mysqli_query($con, "select r.*, m.medicine_name from `return_stock` as r join `medicine` as m on (r.medicine_id = m.medicine_id and r.store_key = '{$store_key}' and m.store_key = '{$store_key}' and r.status <> 0)");
$index = 0;
$records = array();
$medicines = array();
$users = array();
$distributors = array();
while ($row = mysqli_fetch_array($result)) {
$records[] = $row;
$medicines[] = $row['medicine_id'];
$users[] = $row['returned_by'];
$distributors[] = $row['distributor_id'];
}
$users_list = DhsHelper::getUsersList($users);
$medicines_list = DhsHelper::getMedicinesList($medicines);
$distributor_list = DhsHelper::getDistributorsList($distributors);
foreach ($records as $record) {
?>
<tr>
<td><?php
echo ++$index;
?>
</td>
<td><?php
echo isset($medicines_list[$record['medicine_id']]) ? $medicines_list[$record['medicine_id']] : 'N/A';
?>
</td>
<td><?php
echo $record['quantity'];
