PHP database2::getSynapseTime Examples

Example #1

File: requestDisp.php Project: rickyx12/mendero

$inventoryCode = $_GET['inventoryCode'];
$verificationNo = $_GET['verificationNo'];
$inventoryCount = count($inventoryCode);
$verificationCount = count($verificationNo);
$username = $_GET['username'];
$ro = new database2();
for ($i = 0, $v = 0; $i < $inventoryCount, $v < $verificationCount; $i++, $v++) {
    $description = $ro->selectNow("inventoryManager", "description", "verificationNo", $verificationNo[$v]);
    $generic = $ro->selectNow("inventory", "genericName", "inventoryCode", $inventoryCode[$i]);
    $unitcost = $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode[$i]);
    $date = date("Y-m-d");
    $month = date("m");
    $day = date("d");
    $year = date("Y");
    $expiration = $ro->selectNow("inventory", "expiration", "inventoryCode", $inventoryCode[$i]);
    $serverTime = $ro->getSynapseTime();
    $inventoryLocation = $ro->selectNow("inventoryManager", "requestingDepartment", "verificationNo", $verificationNo[$i]);
    $branch = "Consolacion";
    $inventoryType = $ro->selectNow("inventory", "inventoryType", "inventoryCode", $inventoryCode[$i]);
    $transition = " Issued By " . $ro->selectNow("inventoryManager", "requestTo_department", "verificationNo", $verificationNo[$v]) . " / Issued Staff {$username}";
    $remarks = "requestitionNo_{$verificationNo[$v]} / from inventoryCode of {$inventoryCode[$i]}";
    $quantity = $ro->selectNow("inventoryManager", "quantity", "verificationNo", $verificationNo[$v]);
    $currentQTY = $ro->getCurrentQTY($inventoryCode[$i]) - $quantity;
    $requestingUser = $ro->selectNow("inventoryManager", "requestingUser", "verificationNo", $verificationNo[$v]);
    $invqty = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode[$i]);
    if ($quantity > $invqty) {
    } else {
        if ($inventoryType == "medicine") {
            $ro->addNewMedicine1($description, $generic, $unitcost, $quantity, $expiration, $requestingUser, $date, $serverTime, $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $ro->selectNow("inventory", "Added", "inventoryCode", $inventoryCode[$i]), $inventoryCode[$i]);
        } else {
            $ro->addNewMedicine1($description, $generic, $unitcost, $quantity, $expiration, $requestingUser, $date, $serverTime, $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode[$i]), $inventoryCode[$i]);

Example #2

File: discharge_new1.php Project: rickyx12/mendero

<?php

include "../../../myDatabase2.php";
$itemNo = $_GET['itemNo'];
$countItem = count($itemNo);
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database2();
for ($x = 0; $x < $countItem; $x++) {
    $ro->editNow("room", "Description", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x]), "status", "Vacant");
    $ro->editNow("patientCharges", "itemNo", $itemNo[$x], "status", "Discharged");
}
$ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", date("Y-m-d"));
$ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", $ro->getSynapseTime());
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh", $username);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "unregisteredBy", $username);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh_date", date("Y-m-d") . "@" . $ro->getSynapseTime());
echo "<center><br><Br><Br><font color=red>Patient Discharged</font>";

Example #3

File: deleteResult.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$itemNo = $_GET['itemNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->editNow("core2_laboratoryResultChecker", "itemNo", $itemNo, "status", "DELETED_{$username}-@" . date("Y-m-d") . "-" . $ro->getSynapseTime());
$ro->editNow("labSavedResult", "itemNo", $itemNo, "status", "DELETED_{$username}-@" . date("Y-m-d") . "-" . $ro->getSynapseTime());
echo "<br><Br><br<center>";
echo $ro->selectNow("patientCharges", "description", "itemNo", $itemNo) . " Result is now Deleted";

Example #4

File: verified1.php Project: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "verified", $username . "+" . date("M_d_Y") . "+" . $ro->getSynapseTime());
echo "<font color=red>Patient is now Verified</font>";
?>

Example #5

File: newRecord_again.php Project: rickyx12/protacio

$ro->showOption("Doctors","Name");
echo "</select>";
*/
echo "<Br><br><select name='room' class='company'>";
echo "<option value='OPD'>OPD</option>";
echo "<option value='OPD'>OPD</option>";
//echo "<option value='ER'>ER</option>";
echo "<option value='OR/DR'>OR/DR</option>";
echo "<option value='OB-Package'>OB Package</option>";
$ro->showOptionRoom("room", "Description", "status");
echo "</select>";
echo "<p id='curTime'></p>";
echo "<input type=hidden name='registrationNo' value='{$registrationNo}'>";
echo "<input type=hidden name='patientNo' value='{$patientNo}'>";
echo "<input type=hidden name='registrationStatus' value='old'>";
echo "<input type=hidden name='serverTime' value='" . $ro->getSynapseTime() . "'>";
echo "<input type=hidden name='dateRegistered' value='" . date("Y-m-d") . "'>";
echo "<input type=hidden name='from' value='{$from}'>";
echo "<br><br><input type=submit value='Register' style='border:1px solid #000000; background:#3b5998 no-repeat 4px 4px; color:white;'><br>";
$ro->coconutHidden("seniorCitizen", "NO");
$ro->coconutHidden("philHealth", "NO");
$ro->coconutHidden("religion", "");
$ro->coconutHidden("diagnosis", "");
$ro->coconutHidden("civilStatus", "");
$ro->coconutHidden("bloodpressure", "");
$ro->coconutHidden("patientTemperature", "");
$ro->coconutHidden("weight", "");
$ro->coconutHidden("height", "");
$ro->coconutHidden("attendingDoctor", "");
$ro->coconutHidden("admittingDoctor", "");
$ro->coconutHidden("diet", "");

Example #6

File: addPermission.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$username = $_POST['username'];
$registrationNo = $_POST['registrationNo'];
$ro = new database2();
$ro->addPermission($registrationNo, $ro->getSynapseTime(), date("Y-m-d"), $username);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/currentPatient/locked/showLocked.php?registrationNo={$registrationNo}&username={$username}");

Example #7

File: addGeneratorCharges.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$chargeNo = $_GET['chargeNo'];
$count = count($chargeNo);
$username = $_GET['username'];
$ro = new database2();
$ro->getPatientProfile($registrationNo);
$roomType = $ro->selectNow("room", "type", "Description", $ro->getRegistrationDetails_room());
$sp = 0;
//room Selling PRice
if ($roomType == "WARD") {
    $sp = 0.16;
} else {
    $sp = 0.41;
}
//public function addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room)
for ($x = 0; $x < $count; $x++) {
    $gt = round($ro->selectNow("generatorCharge", "hours", "chargeNo", $chargeNo[$x]) * $sp);
    //totalPrice
    $ro->addCharges_cash("UNPAID", $registrationNo, "330", "Generator Charge (" . $ro->selectNow("generatorCharge", "dateStart", "chargeNo", $chargeNo[$x]) . ")", $sp, "0", $gt, $gt, "0", "0", $ro->getSynapseTime(), date("M_d_Y"), $username, "Electricity", "GENERATOR_CHARGE", "Cash", "0", "0", $ro->selectNow("generatorCharge", "hours", "chargeNo", $chargeNo[$x]), "", "Pagadian", $ro->getRegistrationDetails_room());
}
header("Location: /COCONUT/patientProfile/SOAoption/summary.php?registrationNo={$registrationNo}&username={$username}");
?>
 

Example #8

File: csrReturn1.php Project: rickyx12/mendero

<?php

include "../../myDatabase2.php";
$verificationNo = $_POST['verificationNo'];
$inventoryCode = $_POST['inventoryCode'];
$description = $_POST['description'];
$qty = $_POST['qty'];
$borrowerDepartment = $_POST['borrowerDepartment'];
$returnBy = $_POST['returnBy'];
$ro = new database2();
$newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode) + $qty;
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "quantity", $newQTY);
$ro->csrReturnItem($verificationNo, $inventoryCode, $description, $qty, $borrowerDepartment, $returnBy, date("Y-m-d"), $ro->getSynapseTime());
echo "<br><Br><Br><center><font color=red>{$description} Returned</font>";

Example #9

File: searchAvailableMedicineNow.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$searchBy = $_GET['searchBy'];
$searchFrom = $_GET['searchFrom'];
$room = $_GET['room'];
$ro = new database2();
$ro->getAvailableMedicine_mobile($searchBy, $_GET['charges'], $registrationNo, $batchNo, $ro->getSynapseTime(), $username, $searchFrom, $room);

Example #10

File: checkBalance.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database2();
if ($ro->checkBalance($registrationNo) < 1) {
    $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"));
} else {
}
//$ro->gotoPage("http://".$ro->getMyUrl()."/COCONUT/patientProfile/patientProfile_handler.php?registrationNo=$registrationNo&username=$username");
$ro->gotoPage("http://" . $ro->getMyUrl() . "/Department/patientDepartmentProfile.php?registrationNo={$registrationNo}&module=" . $ro->selectNow("registeredUser", "module", "username", $username) . "&username={$username}&month=" . date("m") . "&day=" . date("d") . "&year=" . date("Y") . "&fromTime_hour=00&fromTime_minutes=00&fromTime_seconds=00&toTime_hour=24&toTime_minutes=00&toTime_seconds=00&nod=");

Example #11

File: returnNow.php Project: rickyx12/protacio

$toTime_hour = $_GET['toTime_hour'];
$toTime_minutes = $_GET['toTime_minutes'];
$toTime_seconds = $_GET['toTime_seconds'];
$nod = $_GET['nod'];
$ro = new database2();
$returnQTY = $ro->selectNow("returnInventory", "qty", "returnNo", $returnNo);
$newQTY = $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo) - $returnQTY;
$invQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) + $returnQTY;
if ($ro->selectNow("registrationDetails", "dateUnregistered", "registrationNo", $registrationNo) != "") {
    echo "<br><br><br><Br><center><font color=red>Cannot Return.<br>The Patient is discharged<Br>This is to prevent possible changes in the S.O.A</font>";
} else {
    if ($ro->selectNow("returnInventory", "qty", "returnNo", $returnNo) == $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo)) {
        $ro->editNow("patientCharges", "itemNo", $itemNo, "status", "DELETED_" . $username);
        $ro->editNow("patientCharges", "itemNo", $itemNo, "returnFlag", "return");
        $ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "quantity", $invQTY);
        $ro->editNow("returnInventory", "returnNo", $returnNo, "returnDetails_PHARMACY", date("Y-m-d") . "@" . $ro->getSynapseTime());
        $ro->editNow("returnInventory", "returnNo", $returnNo, "returnPHARMACY", $username);
    } else {
        $ro->editNow("returnInventory", "returnNo", $returnNo, "returnDetails_PHARMACY", date("Y-m-d") . "@" . $ro->getSynapseTime());
        $ro->editNow("returnInventory", "returnNo", $returnNo, "returnPHARMACY", $username);
        $ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $newQTY);
        $ro->editNow("patientCharges", "itemNo", $itemNo, "total", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $newQTY);
        $ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $newQTY);
        $ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "quantity", $invQTY);
        $ro->editNow("patientCharges", "itemNo", $itemNo, "status", "UNPAID");
        $ro->editNow("patientCharges", "itemNo", $itemNo, "departmentStatus", "dispensedBy_" . $username);
        $regNo = $ro->selectNow("patientCharges", "registrationNo", "itemNo", $itemNo);
        $stockCardNo = $ro->selectNow("patientCharges", "stockCardNo", "itemNo", $itemNo);
        $chargeCodez = $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo);
        $desc = $ro->selectNow("patientCharges", "description", "itemNo", $itemNo);
        $sp = $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo);

Example #12

File: consumed.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$inventoryCode = $_GET['inventoryCode'];
$department = $_GET['department'];
$description = $_GET['description'];
$username = $_GET['username'];
$ro = new database2();
$ro->coconutDesign();
echo "<Br><br><br>";
$ro->coconutFormStart("post", "http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/consumed1.php");
$ro->coconutHidden("department", $department);
$ro->coconutHidden("date", date("Y-m-d"));
$ro->coconutHidden("time", $ro->getSynapseTime());
$ro->coconutHidden("username", $username);
$ro->coconutBoxStart("500", "150");
echo "<br>";
echo "<table border=0>";
echo "<tr>";
echo "<td>Inventory Code</td>";
echo "<td>";
$ro->coconutTextBox_short_readonly("inventoryCode", $inventoryCode);
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>Description</td>";
echo "<td>";
$ro->coconutTextBox("description", $description);
echo "</td>";
echo "</tr>";
echo "<tr>";

Example #13

File: referredUser1_radio.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$username = $_POST['username'];
$password = $_POST['password'];
$radioSavedNo = $_POST['radioSavedNo'];
$ro = new database2();
$user = $ro->selectNow("registeredUser", "username", "password", $password);
if ($username == $user) {
    $ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "refer", $user);
    $ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "referTime", $ro->getSynapseTime());
    echo "<font color=red>Referrred</font> <Br>Press F5 to refresh ";
} else {
    echo "\n<script type='text/javascript'>\nalert('Incorrect Password');\nhistory.back();\n</script>\n\n";
}

Example #14

File: dispensedCSR.php Project: rickyx12/mendero

<?php

include "../../myDatabase2.php";
$verificationNo = $_GET['verificationNo'];
$countVerification = count($verificationNo);
$username = $_GET['username'];
$ro = new database2();
for ($x = 0; $x < $countVerification; $x++) {
    $identifier = preg_split("/\\_/", $verificationNo[$x]);
    // $identifier[0]=verificationNo, identifier[1]=inventoryCode
    //echo $verificationNo[$x];//verificationNo na galing sa inventoryManager table [serve as unique identifier]
    if ($ro->selectNow("inventory", "quantity", "inventoryCode", $identifier[1]) >= $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0])) {
        //double check kung mas mataas p ung in stock qty
        $newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $identifier[1]) - $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0]);
        $ro->editNow("inventory", "inventoryCode", $identifier[1], "quantity", $newQTY);
        $generic = "";
        $pricing = $ro->selectNow("inventory", "unitcost", "inventoryCode", $identifier[1]);
        $expiration = "";
        //addNewMedicine($description,$generic,$unitcost,$quantity,$expiration,$addedBy,$dateAdded,$timeAdded,$inventoryLocation,$inventoryType,$branch,$transition,$remarks,$preparation,$phic,$added,$criticalLevel,$supplier,$begCapital,$begQTY,$suppliesUNITCOST)
        $ro->addNewMedicine($ro->selectNow("inventoryManager", "description", "verificationNo", $identifier[0]), $generic, $pricing, $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0]), $expiration, $ro->selectNow("inventoryManager", "requestingUser", "verificationNo", $identifier[0]), date("Y-m-d"), $ro->getSynapseTime(), $ro->selectNow("inventoryManager", "requestingDepartment", "verificationNo", $identifier[0]), $ro->selectNow("inventory", "inventoryType", "inventoryCode", $identifier[1]), "Consolacion", "requestition", "from inventoryCode:" . $identifier[1] . " issued by:" . $username, "", "", "", "", "", "", $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0]), $ro->selectNow("inventory", "suppliesUNITCOST", "inventoryCode", $identifier[1]), "yes");
        //insert to inventory table
        $ro->editNow("inventoryManager", "verificationNo", $identifier[0], "status", "dispensed");
        $ro->editNow("inventoryManager", "verificationNo", $identifier[0], "dispensedDate", date("Y-m-d"));
    } else {
        echo "<font color=red>Sorry... " . $ro->selectNow("inventoryManager", "description", "verificationNo", $identifier[0]) . " Cannot be dispensed because there's only " . $ro->selectNow("inventory", "quantity", "inventoryCode", $identifier[1]) . " in stock</font> ";
    }
}

Example #15

File: searchAvailableChargesNow.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$room = $_GET['room'];
$ro = new database2();
//if( $room == "" ) {
//echo "<font color=red>The Patient Has No room.....Pls Select an appropriate room for patient before you can charge</font>";
//$ro->getAvailableCharges($_GET['charges'],$registrationNo,$batchNo,$ro->getSynapseTime(),$username,"OPD_OPD");
//}else {
$ro->getAvailableCharges_mobile($_GET['charges'], $registrationNo, $batchNo, $ro->getSynapseTime(), $username, $room);
//}

Example #16

File: addLabToPatient.php Project: rickyx12/mendero

    $Len_Str_Message = STRLEN($Str_Message);
    $Str_Encrypted_Message = "";
    for ($Position = 0; $Position < $Len_Str_Message; $Position++) {
        // long code of the function to explain the algoritm
        //this function can be tailored by the programmer modifyng the formula
        //to calculate the key to use for every character in the string.
        $Key_To_Use = ($Len_Str_Message + $Position) * 230;
        // (+5 or *3 or ^2)
        //after that we need a module division because can´t be greater than 255
        //$Key_To_Use = (255+$Key_To_Use) % 255;
        $Key_To_Use = (168 + $Key_To_Use) % 168;
        $Byte_To_Be_Encrypted = SUBSTR($Str_Message, $Position, 1);
        $Ascii_Num_Byte_To_Encrypt = ORD($Byte_To_Be_Encrypted);
        $Xored_Byte = $Ascii_Num_Byte_To_Encrypt ^ $Key_To_Use;
        //xor operation
        $Encrypted_Byte = CHR($Xored_Byte);
        $Str_Encrypted_Message .= $Encrypted_Byte;
        //short code of  the function once explained
        //$str_encrypted_message .= chr((ord(substr($str_message, $position, 1))) ^ ((255+(($len_str_message+$position)+1)) % 255));
    }
    return $Str_Encrypted_Message;
}
$ro->addLaboratoryResultChecker($registrationNo, $itemNo);
$ro->addLaboratoryResultInPatient($registrationNo, $itemNo, $chargesCode, $username, $date, ENCRYPT_DECRYPT($result), $ro->getSynapseTime(), $remarks, $morphology);
//$ro->useReagents($itemNo,$registrationNo,$reagents1,date("Y-m-d"));
//$ro->useReagents($itemNo,$registrationNo,$reagents2,date("Y-m-d"));
//$ro->useReagents($itemNo,$registrationNo,$reagents3,date("Y-m-d"));
//$ro->useReagents($itemNo,$registrationNo,$reagents4,date("Y-m-d"));
//$ro->useReagents($itemNo,$registrationNo,$reagents5,date("Y-m-d"));
echo "<br><br><br><center>Result Added";
//$ro->gotoPage("http://".$ro->getMyUrl()."/COCONUT/Laboratory/resultList/resultForm_output.php?registrationNo=$registrationNo&itemNo=$itemNo");

Example #17

File: referredUser1.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$username = $_POST['username'];
$password = $_POST['password'];
$savedNo = $_POST['savedNo'];
$ro = new database2();
$user = $ro->selectNow("registeredUser", "username", "password", $password);
if ($username == $user) {
    $ro->editNow("labSavedResult", "savedNo", $savedNo, "referred", $user);
    $ro->editNow("labSavedResult", "savedNo", $savedNo, "timeReferred", $ro->getSynapseTime());
    echo "<font color=red>Referrred</font> <Br>Press F5 to refresh ";
} else {
    echo "\n<script type='text/javascript'>\nalert('Incorrect Password');\nhistory.back();\n</script>\n\n";
}

Example #18

File: deletePatientCharges_redirect.php Project: rickyx12/mendero

    echo "<br><br><br><font color=red>Ooopsss.. you are trying to return {$quantity} but there is only " . $ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) . " Dispensed to the patient</font>";
} else {
    if (($ro->getTitle($itemNo) == "MEDICINE" || $ro->getTitle($itemNo) == "SUPPLIES") && $ro->getChargesStatusDept($itemNo)) {
        if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) == "yes") {
            $currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo));
            // current qty ng meds/sup sa inventory
            $newQTY = $currentQTY + $quantity;
            //dagdag inventory once return
            $ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "quantity", $newQTY);
            // update qty sa database
            $ro->deletePatientCharges($registrationNo, $itemNo);
        } else {
            $ro->editNow("patientCharges", "itemNo", $itemNo, "status", "Return");
            $ro->editNow("patientCharges", "itemNo", $itemNo, "dateReturn", date("Y-m-d"));
            $ro->editNow("patientCharges", "itemNo", $itemNo, "departmentStatus", $quantity . "_" . $registrationNo);
            $ro->returnInventory($itemNo, $registrationNo, $ro->selectNow("patientCharges", "description", "itemNo", $itemNo), $quantity, date("Y-m-d") . "@" . $ro->getSynapseTime(), $username);
            /*
            $regNo = $ro->selectNow("patientCharges","registrationNo","itemNo",$itemNo);
            $chargeCodez = $ro->selectNow("patientCharges","chargesCode","itemNo",$itemNo);
            $desc = $ro->selectNow("patientCharges","description","itemNo",$itemNo);
            $sp = $ro->selectNow("patientCharges","sellingPrice","itemNo",$itemNo);
            $disc = $ro->selectNow("patientCharges","discount","itemNo",$itemNo);
            $totz = ($ro->selectNow("patientCharges","sellingPrice","itemNo",$itemNo) * $quantity);
            $excess = $ro->selectNow("patientCharges","cashUnpaid","itemNo",$itemNo);
            $phicx = $ro->selectNow("patientCharges","phic","itemNo",$itemNo);
            $companyx = $ro->selectNow("patientCharges","company","itemNo",$itemNo);
            $timeChargex = $ro->selectNow("patientCharges","timeCharge","itemNo",$itemNo);
            $dateChargex = $ro->selectNow("patientCharges","dateCharge","itemNo",$itemNo);
            $chargeByx = $ro->selectNow("patientCharges","chargeBy","itemNo",$itemNo);
            $servicex = $ro->selectNow("patientCharges","service","itemNo",$itemNo);
            $titlex = $ro->selectNow("patientCharges","title","itemNo",$itemNo);

Example #19

File: checkedApproved.php Project: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$radioSavedNo = $_GET['radioSavedNo'];
$username = $_GET['username'];
$doctorCode = $_GET['doctorCode'];
$module = $_GET['module'];
$checkz = $_GET['checkz'];
$radNo = count($radioSavedNo);
$ro = new database2();
for ($x = 0; $x < $radNo; $x++) {
    //echo $radioSavedNo[$x];
    $ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo[$x], "approved", "yes");
    $ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo[$x], "approvedDate", date("Y-m-d"));
    $ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo[$x], "approvedTime", $ro->getSynapseTime());
    $ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo[$x], "approvedBy", $username);
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/radiology/forApproval.php?username={$username}&doctorCode={$doctorCode}&module={$module}&checkz={$checkz}");