INVENTORY REPORT ".$branchName."";?> " . $branchAddress ."";?>
"; switch($getTheCat){ case 'All': $checkIssuance=mysql_query("SELECT * FROM `medicines` WHERE `medicine_status`='1' ORDER by `medicine_desc` ASC"); break; case 'billable': $checkIssuance=mysql_query("SELECT * FROM `medicines` WHERE `type`='Dialyzer' || `type`='Epo' ORDER by `medicine_desc` ASC"); break; case 'non-billable': $checkIssuance=mysql_query("SELECT * FROM `medicines` WHERE `type`!='Dialyzer' || `type`!='Epo' ORDER by `medicine_desc` ASC"); break; case 'medicine': $checkIssuance=mysql_query("SELECT * FROM `medicines` WHERE `type`='Medicine' ORDER by `medicine_desc` ASC"); break; case 'supplies': $checkIssuance=mysql_query("SELECT * FROM `medicines` WHERE `type`='Supplies' ORDER by `medicine_desc` ASC"); break; case 'ero': $checkIssuance=mysql_query("SELECT * FROM `medicines` WHERE `type`='Epo' ORDER by `medicine_desc` ASC"); break; case 'dialyzer': $checkIssuance=mysql_query("SELECT * FROM `medicines` WHERE `type`='Dialyzer' ORDER by `medicine_desc` ASC"); break; } while($row = mysql_fetch_array($checkIssuance)){ $itemID = $row['medicine_id']; $qty = mysql_result(mysql_query("SELECT `item_qty` FROM `inventory` WHERE `item_id`='$itemID' AND `inv_comp_id`='$compCode'"),0); $iCount = $iCount + 1; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $qty=0; } ?> No. ITEM ID ITEM DESCRIPTION PRODUCT TYPE UoM CATEGORY UNIT PRICE STOCK-ON-HAND ".strtoupper($iCount)." ".$itemID." ".strtoupper($row['medicine_desc'])." ".strtoupper($row['type'])." ".strtoupper($row['UoM'])." ".strtoupper($row['type'])." ".number_format($row['medicine_price'],2,'.',',')." ".number_format($qty,0,'.',',')."