<?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);
