$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>";