";
echo "";
$qq=mysql_query("SELECT * FROM `payments` WHERE `payment_or`='$or' AND `branch_code`='$comCode' AND `cancel`='no' ORDER by `payment_id` ASC");
echo "";
echo "
| No. |
Item ID |
Item Description |
Qty |
Total Amount |
- |
";
//$TreatmentUsage = mysql_result(mysql_query("SELECT COUNT('session_id') FROM `treatment_session` WHERE `session_patient_id`='$patientID' AND `session_header_id`='$transactionID'"),0);
while($row = mysql_fetch_array($qq)){
$totalORAmount = $row['payment_amount'] +$totalORAmount;
$count = $count +1;
echo "";
echo "| ".$count." | ";
echo "".$row['item_id']." | ";
echo "";
$itmID = $row['item_id'];
$itemDesc = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$itmID'"),0);
if($itmID==='0'){
echo "Non-medical Supply";
}else {
echo $itemDesc;
}
echo " | ";
echo "".$row['quantity']." | ";
echo "".$row['payment_amount']." | ";
echo "x | ";
echo " ";
}
echo "";
echo "| TOTAL ";
echo number_format($totalORAmount,2,'.',',');
echo " | ";
echo "";
echo "";
echo " ";
echo "";
//Saving Records
//
}
?> |