$totalDiscount = 0; } } else { $totalDiscount = 0; } $grandTotal = $currentTotal - $totalDiscount; } //check autoDispense???? if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $chargesCode) == "yes") { $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, $totalDiscount, $grandTotal, $grandTotal, 0, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room, "dispensedBy_" . $username, $ro->getSynapseTime()); } else { $ro->addCharges_cash($status, $registrationNo, $chargesCode, $description, $sellingPrice, $totalDiscount, $grandTotal, $grandTotal, 0, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room); } //ORIGINAL //$ro->addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$totalDiscount,$grandTotal,$grandTotal,0,0,$timeCharge,$dateCharge,$username,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$ro->getRegistrationDetails_branch(),$room); } } } } } } } } } }
<?php include "../../../storedProcedure.php"; $registrationNo = $_GET['registrationNo']; $protoType = $_GET['protoType']; $room = $_GET['room']; $username = $_GET['username']; $ro = new storedProcedure(); if ($protoType == "Discharged") { $ro->EditNow("room", "Description", $room, "Status", "Vacant"); $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", date("Y-m-d")); $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", $ro->getSynapseTime()); $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "unregisteredBy", $username); //if( $ro->selectNow("registrationDetails","type","registrationNo",$registrationNo) == "OPD" ) { $ro->lockedAccountItems($registrationNo, date('Y-m-d H:i:s'), $username); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh", "yes_" . $username); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh_date", date("Y-m-d")); //}else { } } else { $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", ""); $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", ""); $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "room", ""); $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "unregisteredBy", ""); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh", ""); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh_date", ""); } echo "\n<script type='text/javascript'>"; if ($protoType == "Discharged") { echo "alert('Patient is now Discharged');"; } else { echo "alert('Patient is now Active');";
<?php include "../../../storedProcedure.php"; require_once '../authentication.php'; $date = $_POST['date']; $username = $_POST['username']; $makeDo = $_POST['makeDo']; $ro = new storedProcedure(); echo "<html>"; echo "<head>"; if ($makeDo == "putStatus") { if (isset($_POST['requestNo']) && isset($_POST['status'])) { $requestNo = $_POST['requestNo']; $status = $_POST['status']; $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")); } else { } } ?> <link rel="stylesheet" type="text/css" href="http://<?php echo $ro->getMyUrl(); ?> /COCONUT/flow/rickyCSS1.css" /> <script type='text/javascript'>
$price = $_POST['price']; $total = $_POST['total']; $username = $_POST['username']; $password = $_POST['password']; $ro = new storedProcedure(); $ro->requestLog($username, $password); if ($username == "" && $password == "") { echo "<script type='text/javascript'>"; echo "alert('Authentication Error');"; echo "window.back(-1)"; echo "</script>"; } else { $username1 = mysql_real_escape_string(strip_tags($username)); $password1 = mysql_real_escape_string(strip_tags($password)); $description1 = mysql_real_escape_string(strip_tags($description)); $qty1 = mysql_real_escape_string(strip_tags($qty)); $price1 = mysql_real_escape_string(strip_tags($price)); $total1 = mysql_real_escape_string(strip_tags($total)); if ($username == $ro->requestLog_username() && $password == $ro->requestLog_password()) { $ro->request2admin($description1, $qty1, $price1, $total1, $username1, getenv("REMOTE_ADDR") . "-" . php_uname("n"), $ro->getSynapseTime(), date("Y-m-d")); echo "<script type='text/javascript'>"; echo "alert('Request Delivered!');"; echo "window.location='http://" . $ro->getMyUrl() . "/LOGINPAGE/module.php'"; echo "</script>"; } else { echo "<script type='text/javascript'>"; echo "alert('Authentication Error');"; echo "window.back(-1)"; echo "</script>"; } }
if ($title == "MEDICINE" && $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < $quantity) { $ro->getBack("Sorry, Not Enough Stock"); } else { if ($title == "SUPPLIES" && $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < $quantity) { $ro->getBack("Sorry, Not Enough Stock"); } else { $dateCharge = date("Y-m-d"); $currentTotal = $quantity * $sellingPrice; $totalDiscount = 0; $grandTotal = $currentTotal - $totalDiscount; //check autoDispense???? if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $chargesCode) == "yes") { $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_injectables($status, $registrationNo, $chargesCode, $description, $sellingPrice, $totalDiscount, $grandTotal, $grandTotal, 0, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room, "dispensedBy_" . $username, $ro->getSynapseTime(), $status2, $qty2, $registrationNo2, $chargesCode2, $description2, $sellingPrice2, $month2, $day2, $year2, $timeCharge2, $chargeBy2, $service2, $title2, $paidVia2, $cashPaid2, $batchNo2, $username2, $discount2, $inventoryFrom2, $room2, $paycash2, $remarks2); } else { if ($ro->getRegistrationDetails_company() != "" && $ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo) == "OPD") { //opd na meron company $ro->addCharges_cash_injectables($status, $registrationNo, $chargesCode, $description, $sellingPrice, $totalDiscount, $grandTotal, 0, 0, $grandTotal, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room, $remarks, $docSpecialization, $status2, $qty2, $registrationNo2, $chargesCode2, $description2, $sellingPrice2, $month2, $day2, $year2, $timeCharge2, $chargeBy2, $service2, $title2, $paidVia2, $cashPaid2, $batchNo2, $username2, $discount2, $inventoryFrom2, $room2, $paycash2, $remarks2); } else { $ro->addCharges_cash_injectables($status, $registrationNo, $chargesCode, $description, $sellingPrice, $totalDiscount, $grandTotal, $grandTotal, 0, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room, $remarks, $docSpecialization, $status2, $qty2, $registrationNo2, $chargesCode2, $description2, $sellingPrice2, $month2, $day2, $year2, $timeCharge2, $chargeBy2, $service2, $title2, $paidVia2, $cashPaid2, $batchNo2, $username2, $discount2, $inventoryFrom2, $room2, $paycash2, $remarks2); } } //ORIGINAL //$ro->addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$totalDiscount,$grandTotal,$grandTotal,0,0,$timeCharge,$dateCharge,$username,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$ro->getRegistrationDetails_branch(),$room); } }