$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "cashPaid", $ro->doubleSelectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo[$x], "registrationNo", $registrationNo));
// kuhain ang total price at ilagay sa cashPaid cols
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "cashUnpaid", "0");
// gwen 0 ang cashUnpaid cols
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "status", "PAID");
// tagged as PAID
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "datePaid", $datePaid);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "control_datePaid", $year . "-" . $m . "-" . $day);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "timePaid", $ro->getSynapseTime());
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "paidBy", $username);
// gwen 0 ang cashUnpaid cols
/*
$newQty = ( $ro->selectNow("inventory","quantity","inventoryCode", $ro->selectNow("patientCharges","chargesCode","itemNo",$itemNo[$x])) - $ro->selectNow("patientCharges","quantity","itemNo",$itemNo[$x]) );
$ro->editNow("inventory","inventoryCode",$ro->doubleSelectNow("patientCharges","chargesCode","itemNo",$itemNo[$x],"registrationNo",$registrationNo),"quantity",$newQty);
*/
//$ro->doubleEditNow("patientCharges","itemNo",$itemNo[$x],"registrationNo",$registrationNo,"departmentStatus","dispensedBy_".$username);
//$ro->doubleEditNow("patientCharges","itemNo",$itemNo[$x],"registrationNo",$registrationNo,"departmentTime",$ro->getSynapseTime());
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "orNO", $orNO);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "receiptType", $receiptType);
}
$ro->getPatientProfile($registrationNo);
if ($ro->getPatientRecord_firstName() == "N/A" && $ro->getPatientRecord_middleName() == "N/A") {
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", date("Y-m-d"));
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", $ro->getSynapseTime());
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh", "Synapse System");
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh_date", date("Y-m-d"));
$ro->gotoPage("/COCONUT/patientProfile/individualPayment/checkBalance.php?registrationNo={$registrationNo}&username={$username}");
} else {
$ro->gotoPage("/COCONUT/patientProfile/individualPayment/checkBalance.php?registrationNo={$registrationNo}&username={$username}");
}
<?php
include "../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->getBatchNo();
$myFile = $ro->getReportInformation("homeRoot") . "/COCONUT/trackingNo/batchNo.dat";
$fh = fopen($myFile, 'r');
$batchNo = fread($fh, 100);
fclose($fh);
echo "\r\n\r\n<style type='text/css'>\r\na \r\n{ \r\ntext-decoration:none;\r\ncolor:black;\r\nfont-weight:bold;\r\n }\r\nul { list-style-type:none; }\r\ndisplay: block;\r\n</style>\r\n\r\n";
$ro->getPatientProfile($registrationNo);
if ($ro->selectNow("registeredUser", "module", "username", $ro->getRegistrationDetails_registeredBy()) == "MI") {
echo "<br><hr><font size=2 color=blue>" . $ro->getPatientRecord_lastName() . " " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . ".</font><hr>";
} else {
echo "<br><hr><font size=2 color=red>" . $ro->getPatientRecord_lastName() . " " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "</font><hr>";
}
echo "<ul>";
echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_right.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "' target='rightFrame'><font size=2>Information</font></a></li>";
if ($ro->getRegistrationDetails_caseType() != "") {
echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/show_phicLimit.php?registrationNo={$registrationNo}&casetype=" . $ro->getRegistrationDetails_caseType() . "' target='rightFrame'><font size=2>Credit Limit</font></a></li>";
} else {
echo "";
}
/*
if($ro->getRegistrationDetails_room() != "OPD_OPD") {
echo "<li><a href='http://".$ro->getMyUrl()."/COCONUT/patientProfile/creditLimit/viewCreditLimit.php?registrationNo=$registrationNo&username=$username' target='rightFrame'><font size=2>Credit Limit</font></a></li>";
}else {
echo "";
}
//echo "<center><font size=4><b>MENDERO MEDICAL CENTER</b></font></center>";
//echo "<center><b><font size=3><b>LABORATORY DEPARTMENT</b></font></b></center>";
//echo "<center><font size=3>Consolacion, Cebu City</font></center>";
//echo "<center><font size=3>Tel No. 062-2143237</font></center>";
echo "<br><br><br><Br><br><Br><Br><Br>";
echo "<center>";
echo "<table border=0 cellspacing=0 cellpadding=1 width='100%' >";
echo "<tr>";
echo "<td><B>Patient ID:</b></td>";
echo "<td><input type='text' class='linez' value='" . $ro->getRegistrationDetails_patientNo() . "'></td>";
echo "<td><B>Date:</b></td>";
echo "<td><input type='text' class='linez' value='" . $ro->selectNow("labSavedResult", "date", "itemNo", $itemNo) . "@" . $ro->selectNow("labSavedResult", "time", "itemNo", $itemNo) . "'></td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>Name:</b></td>";
echo "<td><input type='text' class='linez' value='" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "'></td>";
echo "<td><b>Age/Sex:</b></td>";
echo "<td><input type='text' class='linez' value='" . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "'></td>";
echo "</tr>";
echo "<tr>";
echo "<Td><b>Date of Birth:</td>";
echo "<td></b><input type='text' class='linez' value='" . $ro->getPatientRecord_birthDate() . "'></tD>";
echo "<td><b>Status:</td>";
echo "<td></b><input type='text' class='linez' value='" . $ro->getPatientRecord_civilStatus() . "'></tD>";
echo "</tr>";
echo "<tr>";
echo "<Td><b>Physician:</b></td>";
echo "<td><input type='text' class='linez' value='" . $ro->getAttendingDoc($registrationNo, "ATTENDING") . "'></tD>";
echo "<Td><b>Room:</b></td>";
echo "<td> <input type='text' class='linez' value='" . $ro->getRegistrationDetails_room() . "'></tD>";
echo "</tr>";