PHP database2::getSynapseTime方法代码示例

$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]);

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

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

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

$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", "");

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

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

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

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

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

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

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

<?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";
}

<?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> ";
    }
}

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