Пример #1
0
                                                     $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);
                                     }
                                 }
                             }
                         }
                     }
                 }
             }
         }
     }
 }
Пример #2
0
<?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');";
Пример #3
0
<?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'>
Пример #4
0
$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>";
    }
}
Пример #5
0
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);
    }
}