<?php include "../../../myDatabase.php"; $itemNo = $_GET['itemNo']; $batchNo = $_GET['batchNo']; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $ro = new database(); if ($ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) != "PHARMACY") { //echo "<script type='text/javascript'>alert('You cannot delete that meds/sup here its already dispensed pls return instead in Medicine menu');</script>"; $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/itemDepartment.php?itemNo={$itemNo}&username={$username}&return=ecart"); } else { //$ro->deleteNow("patientCharges","itemNo",$itemNo); $ro->editNow("patientCharges", "itemNo", $itemNo, "status", "DELETED_" . $username . "[" . date("Y-m-d") . "@" . $ro->getSynapseTime() . "]"); } $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/ECART/showCart_update.php?registrationNo={$registrationNo}&batchNo={$batchNo}&username={$username}");
function () { $(this).addClass("hover").children().addClass("hover"); $(this).parent().prev().find("span.arrow:first").addClass("pre_hover"); }, function () { $(this).removeClass("hover").children().removeClass("hover"); $(this).parent().prev().find("span.arrow:first").removeClass("pre_hover"); } ); </script> <?php if ($status == "new") { $stockCardNo = $ro->selectNow("trackingNo", "value", "name", "stockCardNo"); $newStockCardNo = $stockCardNo + 1; $ro->editNow("trackingNo", "name", "stockCardNo", "value", $newStockCardNo); /* $ro->getInventoryStockCardNo(); $myFile = $ro->getReportInformation("homeRoot")."/COCONUT/trackingNo/stockCardNo.dat"; $fh = fopen($myFile, 'r'); $stockCardNo = fread($fh, 100); fclose($fh); */ } else { $stockCardNo = $oldStockCardNo; } $description1 = $_GET['description']; echo "<body onload='DisplayTime();'>"; echo "<form method='post' action='addInventory_insert.php'>"; echo "<input type='hidden' name='description1' value='{$description1}' />"; echo "<input type='hidden' name='genericName1' value='' />";
$registrationNo = $_GET['registrationNo']; $casetype = $_GET['casetype']; $cash = $_GET['cash']; $case = $_GET['case']; $ro = new database(); $ro->getPHIClimit_setter($casetype); echo $cash - $ro->getPHIClimit_room(); echo "<br><br>"; $itemz = preg_split("/\\_/", $ro->getMaximumTotal_any($registrationNo, "Room And Board")); echo "Price:" . $itemz[0]; echo "<br><br>item no." . $itemz[1]; $ro->getPatientChargesToEdit($itemz[1]); if ($itemz[0] >= $ro->getPHIClimit_room()) { $newCash = $ro->patientCharges_cashUnpaid() - ($ro->getPHIClimit_room() - $ro->getTotal("phic", "Room And Board", $registrationNo)); if ($newCash > 1) { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->getPHIClimit_room() - $ro->getTotal("phic", "Room And Board", $registrationNo)); } else { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->patientCharges_cashUnpaid()); } } else { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->patientCharges_cashUnpaid()); } if ($ro->getTotal("phic", "Room And Board", $registrationNo) != $ro->getPHIClimit_room()) { $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/phicFuller_room.php?registrationNo={$registrationNo}&casetype={$casetype}&cash=&case={$case}"); } else { if ($ro->getMaximumTotal_any_checker($registrationNo, "Room And Board") == 0) { $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/phicFuller_PF.php?registrationNo={$registrationNo}&casetype={$casetype}&cash=&case={$case}"); } else {
<?php include "../../../myDatabase.php"; $itemNo = $_GET['itemNo']; $registrationNo = $_GET['registrationNo']; $subjective = $_GET['subjective']; $objective = $_GET['objective']; $assessment = $_GET['assessment']; $plan = $_GET['plan']; $username = $_GET['username']; $ro = new database(); $ro->getPatientProfile($registrationNo); $ro->getSOAP($itemNo, $registrationNo); $ro->editNow("SOAP", "soapNo", $ro->soap_soapNo(), "subjective", $subjective); $ro->editNow("SOAP", "soapNo", $ro->soap_soapNo(), "objective", $objective); $ro->editNow("SOAP", "soapNo", $ro->soap_soapNo(), "assessment", $assessment); $ro->editNow("SOAP", "soapNo", $ro->soap_soapNo(), "plan", $plan); $ro->editNow("SOAP", "soapNo", $ro->soap_soapNo(), "patientNo", $ro->getRegistrationDetails_patientNo()); echo "\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/Doctor/doctorModule/soapView.php?itemNo={$itemNo}®istrationNo={$registrationNo}&username={$username}';\n</script>\n\n";
$controlDay25 = $_POST['controlDay25']; $day26 = $_POST['day26']; $controlDay26 = $_POST['controlDay26']; $day27 = $_POST['day27']; $controlDay27 = $_POST['controlDay27']; $day28 = $_POST['day28']; $controlDay28 = $_POST['controlDay28']; $day29 = $_POST['day29']; $controlDay29 = $_POST['controlDay29']; $day30 = $_POST['day30']; $controlDay30 = $_POST['controlDay30']; $day31 = $_POST['day31']; $controlDay31 = $_POST['controlDay31']; $ro = new database(); //itp dpat and eedit $ro->editNow("patientRecord", "Birthdate", $day1, "Birthdate", $controlDay1); $ro->editNow("patientRecord", "Birthdate", $day2, "Birthdate", $controlDay2); $ro->editNow("patientRecord", "Birthdate", $day3, "Birthdate", $controlDay3); $ro->editNow("patientRecord", "Birthdate", $day4, "Birthdate", $controlDay4); $ro->editNow("patientRecord", "Birthdate", $day5, "Birthdate", $controlDay5); $ro->editNow("patientRecord", "Birthdate", $day6, "Birthdate", $controlDay6); $ro->editNow("patientRecord", "Birthdate", $day7, "Birthdate", $controlDay7); $ro->editNow("patientRecord", "Birthdate", $day8, "Birthdate", $controlDay8); $ro->editNow("patientRecord", "Birthdate", $day9, "Birthdate", $controlDay9); $ro->editNow("patientRecord", "Birthdate", $day10, "Birthdate", $controlDay10); $ro->editNow("patientRecord", "Birthdate", $day11, "Birthdate", $controlDay11); $ro->editNow("patientRecord", "Birthdate", $day12, "Birthdate", $controlDay12); $ro->editNow("patientRecord", "Birthdate", $day13, "Birthdate", $controlDay13); $ro->editNow("patientRecord", "Birthdate", $day14, "Birthdate", $controlDay14); $ro->editNow("patientRecord", "Birthdate", $day15, "Birthdate", $controlDay15); $ro->editNow("patientRecord", "Birthdate", $day16, "Birthdate", $controlDay16);
<?php include "../../../myDatabase.php"; $payee = $_POST['payee']; $amount = $_POST['amount']; $username = $_POST['username']; $requestNo = $_POST['requestNo']; $date = $_POST['date']; $ro = new database(); $ro->coconutDesign(); $ro->editNow("admin2request", "requestNo", $requestNo, "releasedBy", $username); $ro->editNow("admin2request", "requestNo", $requestNo, "releaseTime", $ro->getSynapseTime()); $ro->editNow("admin2request", "requestNo", $requestNo, "releaseDate", date("Y-m-d")); $ro->editNow("admin2request", "requestNo", $requestNo, "releaseTo", $payee); $ro->editNow("admin2request", "requestNo", $requestNo, "releasedAmount", $amount); //$ro->gotoPage("http://".$ro->getMyUrl()."/COCONUT/ADMIN/request/viewApprovedRequest.php?date=$date&username=$username"); echo "\n<style type='text/css'>\ntr:hover { background-color:yellow; color:black;}\na { text-decoration:none; color:black; }\n</style>"; echo "Request#:" . $requestNo; echo "<br>"; $ro->coconutTableStart(); $ro->coconutTableRowStart(); $ro->coconutTableData("<b>Description</b>"); $ro->coconutTableData($ro->selectNow("admin2request", "description", "requestNo", $requestNo)); $ro->coconutTableRowStart(); $ro->coconutTableData("<b>QTY</b>"); $ro->coconutTableData($ro->selectNow("admin2request", "qty", "requestNo", $requestNo)); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->coconutTableData("<b>Price</b>"); $ro->coconutTableData($ro->selectNow("admin2request", "price", "requestNo", $requestNo)); $ro->coconutTableRowStop();
<?php include "../../myDatabase.php"; $radioSavedNo = $_GET['radioSavedNo']; $username = $_GET['username']; $module = $_GET['module']; $doctorCode = $_GET['doctorCode']; $ro = new database(); $ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "approved", "yes"); $ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "approvedDate", date("Y-m-d")); $ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "approvedTime", $ro->getSynapseTime()); $ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "approvedBy", $username); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/radiology/forApproval.php?username={$username}&module={$module}&doctorCode={$doctorCode}");
<?php require_once "../authentication.php"; include "../../myDatabase.php"; include "../../myDatabase4.php"; $invoiceNo = $_POST['invoiceNo']; $supplier = $_POST['supplier']; $terms = $_POST['terms']; $date = $_POST['date']; $ro = new database(); $ro4 = new database4(); $purchaseDate = date("Ymd"); $counterDate = $ro->selectNow("counters", "counterDate", "id", "1"); $counter01 = $ro->selectNow("counters", "counter01", "id", "1"); if ($purchaseDate != $counterDate) { $ro->editNow("counters", "id", "1", "counterDate", $purchaseDate); $ro->editNow("counters", "id", "1", "counter01", "0"); } else { $newCounter01 = $counter01 + 1; $ro->editNow("counters", "counterdate", $purchaseDate, "counter01", $newCounter01); } if ($counter01 < 10) { $sino = date("Ymd") . "000" . $counter01; } else { if ($counter01 > 9 && $counter01 < 100) { $sino = date("Ymd") . "00" . $counter01; } else { if ($counter01 > 99 && $counter01 < 1000) { $sino = date("Ymd") . "0" . $counter01; } else { $sino = date("Ymd") . $counter01;
<?php include "../../myDatabase.php"; $sssID = $_POST['sssID']; $range1 = $_POST['range1']; $range2 = $_POST['range2']; $monthlySalaryCredit = $_POST['monthlySalaryCredit']; $ER = $_POST['ER']; $EE = $_POST['EE']; $total = $_POST['total']; $EC_ER = $_POST['EC_ER']; $username = $_POST['username']; $ro = new database(); $ro->editNow("contribution_sss", "sssID", $sssID, "range1", $range1); $ro->editNow("contribution_sss", "sssID", $sssID, "range2", $range2); $ro->editNow("contribution_sss", "sssID", $sssID, "monthlySalaryCredit", $monthlySalaryCredit); $ro->editNow("contribution_sss", "sssID", $sssID, "ER", $ER); $ro->editNow("contribution_sss", "sssID", $sssID, "EE", $EE); $ro->editNow("contribution_sss", "sssID", $sssID, "total", $total); $ro->editNow("contribution_sss", "sssID", $sssID, "EC_ER", $EC_ER); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/payroll/sssTable.php?username={$username}");
<li><a href="#" class="odd">Patient<span class="arrow"></span></a></li> <li> </li> </ol> <?php /* $ro->getRegistrationNo(); $myFile = $ro->getReportInformation("homeRoot")."/COCONUT/trackingNo/registrationNo.dat"; $fh = fopen($myFile, 'r'); $registrationNo = fread($fh, 100); fclose($fh); */ $registrationNo = $ro->selectNow("trackingNo", "value", "name", "registrationNo"); $incrementRegistrationNo = $ro->selectNow("trackingNo", "value", "name", "registrationNo") + 1; $ro->editNow("trackingNo", "name", "registrationNo", "value", $incrementRegistrationNo); /* $ro->getPatientID(); $myFile = "/opt/lampp/htdocs/COCONUT/trackingNo/patientID.dat"; $fh = fopen($myFile, 'r'); $patientNo = fread($fh, 100); fclose($fh); */ //newRecord_insert.php echo "<br><br>"; echo "<body>"; /**** if($ro->checkBalance($patientNo) != 0) { echo "<Center><font size=2 color=red>This patient has a Balance Pls Proceed to Cashier to pay the unpaid amount</font>"; } */
<?php include "../../../myDatabase.php"; $username = $_POST['username']; $user = $_POST['user']; $password = $_POST['password']; $module = $_POST['module']; $branch = $_POST['branch']; $completeName = $_POST['completeName']; $employeeID = $_POST['employeeID']; $show = $_POST['show']; $station = $_POST['station']; $position = $_POST['position']; $ro = new database(); $ro->editNow("registeredUser", "employeeID", $employeeID, "username", $user); $ro->editNow("registeredUser", "employeeID", $employeeID, "password", $password); $ro->editNow("registeredUser", "employeeID", $employeeID, "module", $module); $ro->editNow("registeredUser", "employeeID", $employeeID, "branch", $branch); $ro->editNow("registeredUser", "employeeID", $employeeID, "station", $station); $ro->editNow("registeredUser", "employeeID", $employeeID, "completeName", $completeName); $ro->editNow("registeredUser", "employeeID", $employeeID, "position", $position); echo "\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/user.php?username={$username}&show={$show}';\n</script>\n\n\n";
<?php include "../../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $casetype = $_GET['casetype']; $ro = new database(); $ro->getPatientProfile($registrationNo); $ro->getPHIClimit_setter($casetype); if ($ro->getPatientRecord_phic() == "yes" || $ro->getPatientRecord_phic() == "YES") { //check kung phic $phicMed = $ro->getTotal("cashUnpaid", "", $registrationNo) - $ro->getPHIClimit_medicine(); echo $phicMed; $ro->editNow("patientCharges", "itemNo", $ro->getHighestCharges_itemNo("MEDICINE", "cashUnpaid", $registrationNo), "phic", $ro->getPHIClimit_medicine()); // magLLgay ng amount based on PHIC-med limit $ro->editNow("patientCharges", "itemNo", $ro->getHighestCharges_itemNo("MEDICINE", "cashUnpaid", $registrationNo), "cashUnpaid", $ro->getTotal("cashUnpaid", "", $registrationNo) - $ro->getPHIClimit_medicine()); // magLLgay ng amount based on PHIC-med limit } else { echo "hello"; }
<?php include "../../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $advised = $_GET['advised']; $followUp = $_GET['followUp']; $ro = new database(); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "advised", $advised); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "followUp", $followUp); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/newPlan.php?registrationNo={$registrationNo}");
echo "alert('Pls Enter a Birth Year');"; echo "history.back();"; echo "</script>"; } if ($company == "Select Company") { $company = ""; } $completeName = $lastname . " " . $firstname . " " . $middlename; $x = 0; $year = date("Y"); $x = (int) $year; $birthDate = $birthYear . "-" . $month . "-" . $day; try { $incrementRegNo = $ro->selectNow("trackingNo", "value", "name", "registrationNo") + 1; $incrementPatNo = $ro->selectNow("trackingNo", "value", "name", "patientNo") + 1; $ro->editNow("trackingNo", "name", "registrationNo", "value", $incrementRegNo); $ro->editNow("trackingNo", "name", "patientNo", "value", $incrementPatNo); if ($pxCount > 0) { $newPxCount = $pxCount + 1; $ro->editNow("pxCount", "id", "1", "pxCount", $newPxCount); $ro->editNow("pxCount", "id", "1", "currentDate", date("Y-m-d")); } else { } if ($registrationStatus == "new") { // Registration Status [new] $ro->addNewPatientRecord($patientNo, $manual_patientID, $lastname, $firstname, $middlename, $completeName, $ro->calculate_age($birthDate), $patientContact, $birthDate, $gender, $seniorCitizen, $address, $philHealth, $civilStatus, $religion, $email); if ($room == "OPD") { $ro->addNewRegistration($patientNo, $registrationNo, $manual_patientID, $manual_caseno, $bloodpressure, $patientTemperature, $height, $weight, $company, $diagnosis, $dateRegistered, $serverTime, $ro->getUserBranch($password), "OPD", "OPD_OPD", $ro->getUserRegistered(), $casetype, "2000", date("Y-m-d"), $diet, $pulse, $respiratory, $from, $pxCount); } else { if ($room == "walkin") { $ro->addNewRegistration($patientNo, $registrationNo, $manual_patientID, $manual_caseno, $bloodpressure, $patientTemperature, $height, $weight, $company, $diagnosis, $dateRegistered, $serverTime, $ro->getUserBranch($password), "walkin", "walkin_walkin", $ro->getUserRegistered(), $casetype, "2000", date("Y-m-d"), $diet, $pulse, $respiratory, $from, $pxCount);
<?php include "../../../myDatabase1.php"; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $ro = new database(); $ro->deletePatientCharges_batch($registrationNo, "package"); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "package", ""); echo "\r\n<script type='text/javascript'>\r\nalert('Package Removed');\r\nwindow.parent.location.reload();\r\n</script>\r\n\r\n";
<?php include "../../../myDatabase.php"; $unlockNo = $_GET['unlockNo']; $username = $_GET['username']; $registrationNo = $_GET['registrationNo']; $ro = new database(); $ro->editNow("pxUnlocked", "unlockNo", $unlockNo, "timeClosed", $ro->getSynapseTime()); $ro->editNow("pxUnlocked", "unlockNo", $unlockNo, "dateClosed", date("Y-m-d")); $ro->editNow("pxUnlocked", "unlockNo", $unlockNo, "status", "Closed"); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/currentPatient/locked/showLocked.php?registrationNo={$registrationNo}&username={$username}");
include "../../../myDatabase.php"; $casetype = $_GET['casetype']; $registrationNo = $_GET['registrationNo']; $phicSup_excess = $_GET['phicSup_excess']; $phicMed_excess = $_GET['phicMed_excess']; $ro = new database(); $ro->getPatientProfile($registrationNo); $ro->getPHIClimit_setter($casetype); if ($phicMed_excess > 0) { $ro->getHighestCharges_itemNo("MEDICINE", $registrationNo, $phicMed_excess); //phic meds n pnkmataas n phic Covered $lesz = $ro->highestCharges_getPHIC() - $phicMed_excess; //bbwsan ung may pnkmataas n cashUnpaid //echo $phicMed_excess; //PRA SA MEDS $ro->editNow("patientCharges", "itemNo", $ro->highestCharges_getItemNo(), "phic", $lesz); //bbwsan ung cashUnpa $ro->editNow("patientCharges", "itemNo", $ro->highestCharges_getItemNo(), "cashUnpaid", $phicMed_excess); } $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/limitMagic1.php?registrationNo={$registrationNo}&casetype={$casetype}&phicSup_excess={$phicSup_excess}"); /* else if($phicSup_excess > 0) { $newPHIC = $phicSup_excess - $ro->getPHIClimit_supplies(); $ro->editNow("patientCharges","itemNo",$ro->getHighestCharges_itemNo("SUPPLIES","phic",$registrationNo),"phic",$ro->getPHIClimit_supplies()); $newCASH_sup = $ro->getTotal("cashUnpaid","",$registrationNo) + $phicSup_excess; $ro->editNow("patientCharges","itemNo",$ro->getHighestCharges_itemNo("SUPPLIES","phic",$registrationNo),"cashUnpaid",$newCASH_sup); }else { } if($phicSup_excess > 0) { $newPHIC = $phicSup_excess - $ro->getPHIClimit_supplies(); $ro->editNow("patientCharges","itemNo",$ro->getHighestCharges_itemNo("SUPPLIES","phic",$registrationNo),"phic",$ro->getPHIClimit_supplies());
<?php include "../../myDatabase.php"; $function = $_GET['function']; $description = $_GET['description']; $value = $_GET['val']; $id = $_GET['id']; $username = $_GET['username']; $ro = new database(); $ro->editNow("reportHeading", "headingNo", $id, "description", $description); $ro->editNow("reportHeading", "headingNo", $id, "information", $value); $ro->gotoPage("misc.php?username={$username}");
<?php include "../../../myDatabase.php"; require_once '../authentication.php'; $requestNo = $_POST['requestNo']; $username = $_POST['username']; $date = $_POST['date']; $status = $_POST['status']; $ro = new database(); $ro->editNow("admin2request", "requestNo", $requestNo, "status", $status . "_" . $username); $ro->editNow("admin2request", "requestNo", $requestNo, "status_time", $ro->getSynapseTime()); $ro->editNow("admin2request", "requestNo", $requestNo, "status_date", date("Y-m-d")); $ro->editNow("admin2request", "requestNo", $requestNo, "status_encodeIn", getenv("REMOTE_ADDR") . "-" . php_uname("n")); //$ro->gotoPage("http://".$ro->getMyUrl()."/COCONUT/ADMIN/request/table.php?date=$date"); /* echo " <script> setTimeout(function(){ history.go(-1); return false; },3000); </script> "; */ echo "<Br><br><br><br><Br><Br><Br>"; echo "<CenteR>"; $ro->coconutImages("ajax-loader.gif"); if ($status == "APPROVED") { echo " Please Wait While Approving....."; } else { echo " Please Wait While Cancelling....."; } echo "</center>"; ?>
<?php include "../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $height = $_GET['height']; $weight = $_GET['weight']; $bloodpressure = $_GET['bloodpressure']; $temperature = $_GET['temperature']; $pulse = $_GET['pulse']; $respiratory = $_GET['respiratory']; $ro = new database(); $ro->editHeight($registrationNo, $height); $ro->editWeight($registrationNo, $weight); $ro->editBloodPressure($registrationNo, $bloodpressure); $ro->editTemperature($registrationNo, $temperature); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "pulseRate", $pulse); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "respiratoryRate", $respiratory); echo "\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$username}';\n</script>\n";
<?php include "myDatabase.php"; $endingNo = $_GET['endingNo']; $ro = new database(); foreach ($endingNo as $endingNo) { $inventoryCode = $ro->selectNow("endingInventory", "inventoryCode", "endingNo", $endingNo); $unitcost = $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode); $ro->editNow("endingInventory", "endingNo", $endingNo, "unitcost", round($unitcost, 2)); echo $inventoryCode; }
<?php require_once "../authentication.php"; include "../../myDatabase.php"; $module = $_POST['module']; $ro = new database(); if ($module != 'PHARMACY' && $module != 'NURSING' && $module != 'E.R' && $module != 'OR') { header("Location: stop-requesition.php"); } else { $requesitionNo = $ro->selectNow("trackingNo", "value", "name", "requesitionNo"); $newRequesitionNo = $requesitionNo + 1; $ro->editNow("trackingNo", "name", "requesitionNo", "value", $newRequesitionNo); header("Location: request-inventory.php?requesitionNo={$requesitionNo}&module={$module}"); }
if ($room == "OR/DR") { $ro->addNewRegistration($patientNo, $registrationNo, $bloodpressure, $patientTemperature, $height, $weight, $company, $diagnosis, $dateRegistered, $serverTime, $ro->getUserBranch($password), "OR/DR", "OR/DR_OR/DR", $ro->getUserRegistered(), $casetype, "2000", date("Y-m-d"), $diet, $pulse, $respiratory); } else { $ro->addNewRegistration($patientNo, $registrationNo, $bloodpressure, $patientTemperature, $height, $weight, $company, $diagnosis, $dateRegistered, $serverTime, $ro->getUserBranch($password), "IPD", $room, $ro->getUserRegistered(), $casetype, "2000", date("Y-m-d"), $diet, $pulse, $respiratory); $timezone = "Asia/Manila"; date_default_timezone_set($timezone); //ADD ROOM $ro->EditNow("room", "Description", $room, "status", "Occupied"); //GWEN OCCUPIED ANG STATUS NG ROOM $ro->getRoom($room); $ro->addCharges_cash("UNPAID", $registrationNo, $room, $room, $ro->room_rate(), 0, $ro->room_rate(), $ro->room_rate(), 0, 0, $serverTime, $dateRegistered, $ro->getUserRegistered(), "Confinement", "Room And Board", "Cash", 0, "", 1, "", $ro->getUserBranch($password), ""); //ADD ATTENDING AND ADMITTING DOCTOR } } } $ro->editNow("patientRecord", "patientNo", $patientNo, "lastName", $lastname); $ro->editNow("patientRecord", "patientNo", $patientNo, "firstName", $firstname); $ro->editNow("patientRecord", "patientNo", $patientNo, "middleName", $middlename); $ro->editNow("patientRecord", "patientNo", $patientNo, "contactNo", $patientContact); $ro->editNow("patientRecord", "patientNo", $patientNo, "Birthdate", $birthDate); $ro->editNow("patientRecord", "patientNo", $patientNo, "Gender", $gender); $ro->editNow("patientRecord", "patientNo", $patientNo, "Senior", $seniorCitizen); $ro->editNow("patientRecord", "patientNo", $patientNo, "Address", $address); $ro->editNow("patientRecord", "patientNo", $patientNo, "PHIC", $philHealth); $ro->editNow("patientRecord", "patientNo", $patientNo, "civilStatus", $civilStatus); $ro->editNow("patientRecord", "patientNo", $patientNo, "phicType", $phicType); $ro->editNow("patientRecord", "patientNo", $patientNo, "completeName", $completeName); } // Registration Status [old] session_regenerate_id(); $_SESSION['employeeID'] = $ro->getUserRegistrarEmployeeID();
$cashPaid = $_GET['cashPaid']; $batchNo = $_GET['batchNo']; $username = $_GET['username']; $quantity = $_GET['quantity']; $inventoryFrom = $_GET['inventoryFrom']; $room = $_GET['room']; $paycash = $_GET['paycash']; $remarks = $_GET['remarks']; $stockCardNo = $_GET['stockCardNo']; $ro = new database(); $ro->getPatientProfile($registrationNo); if ($quantity > $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode)) { $ro->getBack("Current Stock is " . $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) . " only"); } else { //$dateCharge = $year."-".$month."-".$day; $discount = 0; $totalPrice = $sellingPrice * $quantity; //addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room,$remarks,$docSpecialization,$Capital,$stockCardNo,$dispenseFlag,$dispenseQTY) //check autoDispense???? if ($ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $chargesCode) != "PHARMACY") { $currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode); // current qty ng meds/sup sa inventory $newQTY = $currentQTY - $quantity; // less sa inventory as in qty after ibawas ung desired qty ng user $ro->editNow("inventory", "inventoryCode", $chargesCode, "quantity", $newQTY); // update qty sa database $ro->addCharges_cash_autoDispense($status, $registrationNo, $chargesCode, $description, $sellingPrice, $discount, $totalPrice, $totalPrice, "0", "0", $ro->getSynapseTime(), $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room, "dispensedBy_" . $username, $ro->getSynapseTime(), $stockCardNo, "dispense", $quantity); } else { $ro->addCharges_cash($status, $registrationNo, $chargesCode, $description, $sellingPrice, $discount, $totalPrice, $totalPrice, "0", "0", $ro->getSynapseTime(), $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room, $remarks, "", "", $stockCardNo, "", ""); } }
<?php include "../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $itemNo = $_GET['itemNo']; $quantity = $_GET['quantity']; $username = $_GET['username']; $show = $_GET['show']; $desc = $_GET['desc']; $ro = new database(); if (($ro->getTitle($itemNo) == "MEDICINE" || $ro->getTitle($itemNo) == "SUPPLIES") && $ro->getChargesStatusDept($itemNo)) { $ro->editNow("patientCharges", "itemNo", $itemNo, "status", "Return"); $ro->editNow("patientCharges", "itemNo", $itemNo, "departmentStatus", $quantity . "_" . $registrationNo); $ro->editNow("patientCharges", "itemNo", $itemNo, "approvedBy", $username); $ro->changeQTY($ro->getChargesCode($itemNo), $ro->getCurrentQTY($ro->getChargesCode($itemNo)) + $quantity); $ro->deletePatientCharges($registrationNo, $itemNo); } else { $ro->deletePatientCharges($registrationNo, $itemNo); $ro->editNow("forDeletion", "itemNo", $itemNo, "approvedBy", $username); } echo "\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/ADMIN/requestDelete_update.php?username={$username}';\n</script>\n"; ?>
<?php include "../../../myDatabase.php"; $chargesCode = $_GET['chargesCode']; $description = $_GET['description']; $opd = $_GET['opdprice']; $ipd = $_GET['ipdprice']; $subCategory = $_GET['subCategory']; $ro = new database(); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "Description", $description); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "OPD", $opd); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "HMO", $ipd); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "WARD", $ipd); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "SOLOWARD", $ipd); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "SEMIPRIVATE", $ipd); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "PRIVATE", $ipd); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "subCategory", $subCategory); ?>
<?php include "../../myDatabase.php"; $verificationNo = $_GET['verificationNo']; $requestingDepartment = $_GET['requestingDepartment']; $requestingBranch = $_GET['requestingBranch']; $requestTo_department = $_GET['requestTo_department']; $requestTo_branch = $_GET['requestTo_branch']; $username = $_GET['username']; $ro = new database(); $ro->editNow("inventoryManager", "verificationNo", $verificationNo, "status", "DELETED_" . $username); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableMedicine/showRequestList.php?requestingDepartment={$requestingDepartment}&requestingBranch={$requestingBranch}&requestTo_department={$requestTo_department}&requestTo_branch={$requestTo_branch}&username={$username}");
$soloward = $_GET['solowardprice']; $semiprivate = $_GET['semiprivateprice']; $private = $_GET['privateprice']; $subCategory = $_GET['subCategory']; $hmo = $_GET['hmo']; $unitCost = $_GET['unitCost']; if ($category == "LABORATORY") { $reagent1 = $_GET['reagent1']; $reagent2 = $_GET['reagent2']; $reagent3 = $_GET['reagent3']; $reagent4 = $_GET['reagent4']; $reagent5 = $_GET['reagent5']; } else { } $ro = new database(); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "Description", $description); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "Service", $service); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "Category", $category); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "OPD", $opd); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "HMO", $hmo); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "WARD", $ward); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "SOLOWARD", $soloward); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "SEMIPRIVATE", $semiprivate); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "PRIVATE", $private); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "subCategory", $subCategory); $ro->editNow("availableCharges", "chargesCode", $chargesCode, "unitCost", $unitCost); if ($category == "LABORATORY") { $ro->editNow("availableCharges", "chargesCode", $chargesCode, "reagents", $reagent1 . "-" . $reagent2 . "-" . $reagent3 . "-" . $reagent4 . "-" . $reagent5); } else { } ?>
<?php require_once "../authentication.php"; include "../../myDatabase.php"; include "../../myDatabase4.php"; $endingNo = $_POST['endingNo']; $stockCardNo = $_POST['stockCardNo']; $endingNo1 = ""; $totalEnding = 0; $ro = new database(); $ro4 = new database4(); $user = $ro->selectNow('registeredUser', 'username', 'employeeID', $_SESSION['employeeID']); foreach ($endingNo as $end) { $totalEnding += $ro->selectNow("endingInventory", "endingQTY", "endingNo", $end); $endingNo1 = $end; $ro->editNow("endingInventory", "endingNo", $end, "status", "encoded_" . $user); } if ($ro->selectNow("inventoryStockCard", "inventoryType", "stockCardNo", $ro->selectNow("endingInventory", "stockCardNo", "endingNo", $endingNo1)) == "medicine") { $stockCardNo = $ro->selectNow("endingInventory", "stockCardNo", "endingNo", $endingNo1); $genericName = $ro->selectNow("inventoryStockCard", "genericName", "stockCardNo", $stockCardNo); $brandName = $ro->selectNow("inventoryStockCard", "description", "stockCardNo", $stockCardNo); $preparation = $ro->selectNow("inventory", "preparation", "stockCardNo", $stockCardNo); $qty = $totalEnding; $unitcost = $ro->selectNow("endingInventory", "unitcost", "endingNo", $endingNo1); //selectLast($table,$cols,$identifier,$identifierData,$ordering) $opdPrice = $ro4->selectLast("inventory", "opdPrice", "stockCardNo", $stockCardNo, "inventoryCode"); $ipdPrice = $ro4->selectLast("inventory", "ipdPrice", "stockCardNo", $stockCardNo, "inventoryCode"); $expiration = $ro4->selectLast('inventory', 'expiration', 'stockCardNo', $stockCardNo, 'inventoryCode'); $remarks = "Ending inventory - " . date('Y-m-d'); $locked = "no"; $criticalLevel = "5";
$transition = $_GET['transition']; $remarks = $_GET['remarks']; $phic = $_GET['phic']; $preparation = $_GET['preparation']; $pricing = $_GET['pricing']; $additional = $_GET['additional']; $criticalLevel = $_GET['criticalLevel']; $supplier = $_GET['supplier']; $phicPrice = $_GET['phicPrice']; $companyPrice = $_GET['companyPrice']; $autoDispense = $_GET['autoDispense']; $ro = new database(); if ($inventoryType == "medicine" && $additional == "") { echo "<script type='text/javascript'> alert('Pls input the price of the medicine..');history.back(-1); </script>"; } else { $ro->editNow("inventory", "inventoryCode", $inventoryCode, "description", $description); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "genericName", $generic); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "unitcost", $unitcost); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "quantity", $quantity); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "expiration", $expiration); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "dateAdded", $dateAdded); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "timeAdded", $timeAdded); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "inventoryType", $inventoryType); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "inventoryLocation", $inventoryLocation); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "branch", $branch); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "transition", $transition); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "remarks", $remarks); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "preparation", $preparation); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "phic", $phic); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "Added", $pricing . "_" . $additional); $ro->editNow("inventory", "inventoryCode", $inventoryCode, "criticalLevel", $criticalLevel);