PHP database2::gotoPage Examples

Example #1

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 #2

File: select_prePackage1.php Project: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$package = $_GET['package'];
$ro = new database2();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "prePackage", $package);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$username}");

Example #3

File: verifyDelete_redirect_checkAllow.php Project: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$description = $_GET['description'];
$quantity = $_GET['quantity'];
$username = $_GET['username'];
$show = $_GET['show'];
$desc = $_GET['desc'];
$ro = new database2();
/*
if( ($ro->getTitle($itemNo) == "MEDICINE" || $ro->getTitle($itemNo) == "SUPPLIES")  && $ro->selectNow("registeredUser","module","username",$username) != "PHARMACY" ) {
echo "<br><Br><Br><font color=red>PHARMACY NA LANG MAG RERETURN.
<bR>
NAHIYA AKO SAYO EH BKA BUSY KA. =)</font>";
*/
//}else {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/verifyDelete_redirect.php?registrationNo={$registrationNo}&itemNo={$itemNo}&description={$description}&quantity={$quantity}&username={$username}&show={$show}&desc={$desc}");
//}

Example #4

File: deleteTemplate1.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$templateNo = $_POST['templateNo'];
$ro = new database2();
$ro->deleteNow("labResultList", "templateNo", $templateNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Laboratory/resultList/resultFormMasterfile.php");

Example #5

File: computeDays1.php Project: rickyx12/protacio

$itemNo = $_GET['itemNo'];
$dateIn = $_GET['dateIn'];
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$username = $_GET['username'];
$ro = new database2();
$dateOut = $year . "-" . $month . "-" . $day;
$out = new DateTime($dateOut);
$in = new DateTime($dateIn);
$days = $out->diff($in)->d;
if ($ro->selectNow("patientCharges", "phic", "itemNo", $itemNo) < 1) {
    $ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $days);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "total", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $days);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $days);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "phic", "0");
    $ro->editNow("patientCharges", "itemNo", $itemNo, "company", "0");
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=Room and Board&username={$username}&show=&desc=");
} else {
    $cashUnpaid = $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo);
    $hmo = $ro->selectNow("patientCharges", "company", "itemNo", $itemNo);
    $philhealth = $ro->selectNow("patientCharges", "phic", "itemNo", $itemNo);
    $newTotal = $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $days;
    $ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $days);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "total", $newTotal);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $newTotal - $philhealth);
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=Room and Board&username={$username}&show=&desc=");
}
?>
t

Example #6

File: deletePHICPayment1.php Project: rickyx12/mendero

<?php

include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$phicPaymentNo = $_GET['phicPaymentNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->editNow("phicPayment", "phicPaymentNo", $phicPaymentNo, "status", "DELETED_" . $username . "_" . date("Y-m-d"));
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/viewPHICPayment.php?registrationNo={$registrationNo}&username={$username}");

Example #7

File: editItem1.php Project: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$packageNo = $_GET['packageNo'];
$packageName = $_GET['packageName'];
$price = $_GET['price'];
$ro = new database2();
$ro->editNow("hospitalPackage", "packageNo", $packageNo, "Added", $price);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/hospitalPackage/showAddedPackage_update.php?packageName={$packageName}");

Example #8

File: editChargesCashier1.php Project: rickyx12/protacio

$cashUnpaid = $_GET['cashUnpaid'];
$doctorsPF = $_GET['doctorsPF'];
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$fromTime_hour = $_GET['fromTime_hour'];
$fromTime_minutes = $_GET['fromTime_minutes'];
$fromTime_seconds = $_GET['fromTime_seconds'];
$toTime_hour = $_GET['toTime_hour'];
$toTime_minutes = $_GET['toTime_minutes'];
$toTime_seconds = $_GET['toTime_seconds'];
$username = $_GET['username'];
$registrationNo = $_GET['registrationNo'];
$shift = $_GET['shift'];
$ro = new database2();
$totalz = $cashUnpaid + $doctorsPF;
if ($totalz == $total) {
    if ($ro->selectNow("patientCharges", "title", "itemNo", $itemNo) == "PROFESSIONAL FEE") {
        $ro->editNow("patientCharges", "itemNo", $itemNo, "sellingPrice", $sellingPrice . "/" . $sellingPrice);
    } else {
        $ro->editNow("patientCharges", "itemNo", $itemNo, "sellingPrice", $sellingPrice);
    }
    $ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $quantity);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "total", $total);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $cashUnpaid);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "company", $doctorsPF);
} else {
    $ro->getBack("ERROR!");
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Cashier/patientUnpaidChargesCompany.php?month={$month}&day={$day}&year={$year}&fromTime_hour={$fromTime_hour}&fromTime_minutes={$fromTime_minutes}&fromTime_seconds={$fromTime_seconds}&toTime_hour={$toTime_hour}&toTime_minutes={$toTime_minutes}&toTime_seconds={$toTime_seconds}&username={$username}&registrationNo={$registrationNo}&shift={$shift}");

Example #9

File: verifyDelete_pass_checkAllow.php Project: rickyx12/mendero

<?php

include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$description = $_GET['description'];
$quantity = $_GET['quantity'];
$username = $_GET['username'];
$show = $_GET['show'];
$desc = $_GET['desc'];
$ro = new database2();
//if( ($ro->getTitle($itemNo) == "MEDICINE" || $ro->getTitle($itemNo) == "SUPPLIES")  && $ro->selectNow("registeredUser","module","username",$username) != "PHARMACY" ) {
//echo "<br><Br><Br><font color=red>PHARMACY NA LANG MAG RERETURN.
//<bR>
//NAHIYA AKO SAYO EH BKA BUSY KA. =)</font>";
//}else {
//}
if ($ro->selectNow("patientCharges", "inventoryFrom", "itemNo", $itemNo) != "PHARMACY" && $ro->selectNow("patientCharges", "inventoryFrom", "itemNo", $itemNo) != "CSR") {
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/itemDepartment.php?itemNo={$itemNo}&username={$username}&return=main");
} else {
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/verifyDelete_redirect_checkAllow.php?registrationNo={$registrationNo}&itemNo={$itemNo}&description={$description}&quantity={$quantity}&username={$username}&show={$show}&desc={$desc}");
}

Example #10

File: inventoryLog.php Project: rickyx12/mendero

<?php

include "../../../myDatabase2.php";
$inventoryCode = $_GET['inventoryCode'];
$department = $_GET['department'];
$description = $_GET['description'];
$date = $_GET['date'];
$time = $_GET['time'];
$username = $_GET['username'];
$qty = $_GET['qty'];
$ro = new database2();
$newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode) - $qty;
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "quantity", $newQTY);
$ro->addConsumed($inventoryCode, $department, $qty, $description, $date, $time, $username);
echo "<script>alert('{$qty} pcs of {$description} is now Consumed and deducted to the inventory ')</script>";
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/inventory/department/searchInventory.php?username={$username}&department={$department}");

Example #11

File: itemDepartment.php Project: rickyx12/mendero

<?php

include "../../myDatabase2.php";
$itemNo = $_GET['itemNo'];
$username = $_GET['username'];
$return = $_GET['return'];
$ro = new database2();
$ro->editNow("patientCharges", "itemNo", $itemNo, "status", "DELETED_" . $username . "[" . date("Y-m-d") . "@" . date("H:i:s") . "]");
$ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "quantity", $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo) + $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)));
$ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "status", "");
$registrationNo = $ro->selectNow("patientCharges", "registrationNo", "itemNo", $itemNo);
$batchNo = $ro->selectNow("patientCharges", "batchNo", "itemNo", $itemNo);
if ($return == "main") {
    $title = $ro->selectNow("patientCharges", "title", "itemNo", $itemNo);
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title={$title}&username={$username}&show=&desc=");
} else {
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/ECART/showCart_update.php?registrationNo={$registrationNo}&batchNo={$batchNo}&username={$username}");
}

Example #12

File: editItem1.php Project: rickyx12/mendero

<?php

include "../../myDatabase2.php";
$verificationNo = $_POST['verificationNo'];
$quantity = $_POST['quantity'];
$username = $_POST['username'];
$batchNo = $_POST['batchNo'];
$ro = new database2();
$ro->editNow("inventoryManager", "verificationNo", $verificationNo, "quantity", $quantity);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/CSR/showRequest.php?username={$username}&batchNo={$batchNo}");

Example #13

File: deleteCharges1.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$itemNo = $_POST['itemNo'];
$registrationNo = $_POST['registrationNo'];
$ro = new database2();
$ro->deleteNow("patientCharges", "itemNo", $itemNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/viewHospitalCharges.php?registrationNo={$registrationNo}");

Example #14

File: deleteRequest.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$verificationNo = $_GET['verificationNo'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->deleteNow("inventoryManager", "verificationNo", $verificationNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/requestition/batchRequest/showCart_update.php?batchNo={$batchNo}&username={$username}");

Example #15

File: addCharges.php Project: rickyx12/protacio

}
if (isset($_GET['instruction1'])) {
    $instruction1 = $_GET['instruction1'];
} else {
    $instruction1 = "";
}
if (isset($_GET['indication1'])) {
    $indication1 = $_GET['indication1'];
} else {
    $indication1 = "";
}
$ro = new database2();
$ro->getPatientProfile($registrationNo);
$currentTotal = $quantity * $sellingPrice;
$grandTotal = $currentTotal;
if ($decision == "yes") {
    $dateCharge = date("Y-m-d");
    $ro->addCharges_cash_mobile($status, $registrationNo, $chargesCode, $description, $sellingPrice, "0", $grandTotal, $grandTotal, 0, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room);
    if ($title == "MEDICINE") {
        $ro->addNewPlan($registrationNo, $description, $timing1, $instruction1, $indication1, $quantity);
    } else {
    }
} else {
    if ($title != "MEDICINE") {
        $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "advised", $ro->selectNow("registrationDetails", "advised", "registrationNo", $registrationNo) . "," . $description);
        $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/mobileAddCharges_charges.php?registrationNo={$registrationNo}&username={$username}&room={$room}&batchNo={$batchNo}");
    } else {
        $ro->addNewPlan_fromCharging($registrationNo, $description, $timing1, $instruction1, $indication1, $quantity, $batchNo, $room, $username);
        $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/mobileAddCharges_medicine.php?registrationNo={$registrationNo}&username={$username}&room={$room}&batchNo={$batchNo}");
    }
}

Example #16

File: receiptTypeReportRedirect.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$receiptType = $_GET['receiptType'];
$fromTime_hour = $_GET['fromTime_hour'];
$fromTime_minutes = $_GET['fromTime_minutes'];
$fromTime_seconds = $_GET['fromTime_seconds'];
$toTime_hour = $_GET['toTime_hour'];
$toTime_minutes = $_GET['toTime_minutes'];
$toTime_seconds = $_GET['toTime_seconds'];
$username = $_GET['username'];
$ro = new database2();
$date = $year . "-" . $month . "-" . $day;
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Cashier/cashierReport/receiptTypeReport.php?date={$date}&receiptType={$receiptType}&fromTime_hour={$fromTime_hour}&fromTime_minutes={$fromTime_minutes}&fromTime_seconds={$fromTime_seconds}&toTime_hour={$toTime_hour}&toTime_minutes={$toTime_minutes}&toTime_seconds={$toTime_seconds}&username={$username}");

Example #17

File: delete.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$orderNo = $_GET['orderNo'];
$batchNo = $_GET['batchNo'];
$ro = new database2();
$ro->deleteNow("orderForm", "orderNo", $orderNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableMedicine/reOrder/orderForm_update.php?batchNo={$batchNo}");

Example #18

File: deleteDiet1.php Project: rickyx12/mendero

<?php

include "../../myDatabase2.php";
$dietNo = $_POST['dietNo'];
$username = $_POST['username'];
$ro = new database2();
$ro->deleteNow("dietList", "dietNo", $dietNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/dietary/viewDiet.php?username={$username}");

Example #19

File: editCharges1.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$itemNo = $_POST['itemNo'];
$cash = $_POST['cash'];
$company = $_POST['company'];
$phic = $_POST['phic'];
$company1 = $_POST['company1'];
$ro = new database2();
$ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $cash);
$ro->editNow("patientCharges", "itemNo", $itemNo, "company", $company);
$ro->editNow("patientCharges", "itemNo", $itemNo, "phic", $phic);
$ro->editNow("patientCharges", "itemNo", $itemNo, "company1", $company1);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/additionalCompany/transfertoAdditionalCompany.php?registrationNo=" . $ro->selectNow("patientCharges", "registrationNo", "itemNo", $itemNo) . "&mode=");
?>

Example #20

File: deleteDisbursementEntry.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$username = $_GET['username'];
$idNo = $_GET['idNo'];
$transactionNo = $_GET['transactionNo'];
$ro = new database2();
$ro->editNow("disbursement", "idNo", $idNo, "status", "DELETED");
$ro->editNow("disbursement", "idNo", $idNo, "deleteDetails", date("Y-m-d") . "_" . date("H:i:s") . "_" . $username);
if ($fromPage == "encode") {
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/accounting/cashDisbursement/disbursementUpdate.php?transactionNo={$transactionNo}&username={$username}");
} else {
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/accounting/cashDisbursement/editDisbursementEntry/disbursementUpdate.php?transactionNo={$transactionNo}&username={$username}");
}

Example #21

File: phicPayment1.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$refNo = $_POST['refNo'];
$registrationNo = $_POST['registrationNo'];
$amount = $_POST['amount'];
$tax = $_POST['tax'];
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];
$postBy = $_POST['postBy'];
$ro = new database2();
$date = $year . "-" . $month . "-" . $day;
$ro->addPHICPayment($refNo, $registrationNo, $amount, $tax, $date, $postBy);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_right.php?registrationNo={$registrationNo}&username={$postBy}");

Example #22

File: addOrder1.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$description = $_GET['description'];
$sellingPrice = $_GET['sellingPrice'];
$unitCost = $_GET['unitCost'];
$supplier = $_GET['supplier'];
$username = $_GET['username'];
$batchNo = $_GET['batchNo'];
$qty = $_GET['qty'];
$ro = new database2();
$ro->addOrder($description, $sellingPrice, $unitCost, $batchNo, date("M_d_Y"), $username, $qty, $supplier);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableMedicine/reOrder/searchMedicine_reorder.php?username={$username}&inventoryFrom=PHARMACY&reOrder={$batchNo}");

Example #23

File: deleteRadio.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$radioSavedNo = $_GET['radioSavedNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->deleteNow("radioSavedReport", "radioSavedNo", $radioSavedNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Results/clinicalChemistry/view_labTest_done.php?registrationNo={$registrationNo}&username={$username}");

Example #24

File: inventoryMovement_insert.php Project: rickyx12/protacio

        } else {
            $ro->doubleEditNow("inventoryMovement", "movementNo", $movementNo, "stockCardNo", $stockCardNo, "endingInventory1", $endingInventory2);
        }
    } else {
        if ($menu == "thirdThreePurchases") {
            $endingInventory3 = $_GET['endingInventory3'];
            if ($control == "encode") {
                $ro->inventoryMovement_insertEndingInventory($stockCardNo, "endingInventory2", $endingInventory3);
            } else {
                $ro->doubleEditNow("inventoryMovement", "movementNo", $movementNo, "stockCardNo", $stockCardNo, "endingInventory2", $endingInventory3);
            }
        } else {
            if ($menu == "fourthThreePurchases") {
                $endingInventory4 = $_GET['endingInventory4'];
                if ($control == "encode") {
                    $ro->inventoryMovement_insertEndingInventory($stockCardNo, "endingInventory3", $endingInventory4);
                } else {
                    $ro->doubleEditNow("inventoryMovement", "movementNo", $movementNo, "stockCardNo", $stockCardNo, "endingInventory3", $endingInventory4);
                }
            } else {
                if ($menu == "medicineType") {
                    $medicineType = $_GET['medicineType'];
                    $ro->doubleEditNow("inventoryMovement", "movementNo", $movementNo, "stockCardNo", $stockCardNo, "medicineType", $medicineType);
                } else {
                }
            }
        }
    }
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovement.php?username={$username}&type={$type}&medicineType={$medType}&year={$year}");

Example #25

File: cashCollectionDetails_delete.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$collectionNo = $_GET['collectionNo'];
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$ro = new database2();
$ro->deleteNow("cashCollection", "collectionNo", $collectionNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Cashier/cashCollection/cashCollectionDetails.php?month={$month}&day={$day}&year={$year}");

Example #26

File: analyzing_rBanny.php Project: rickyx12/protacio

//echo ( $cash - $targetAmount );
echo "<center><br>";
$itemz = preg_split("/\\_/", $ro->getMaximumTotal_rBanny($registrationNo));
//format cashUnpaid_itemNo
echo "<Br>";
echo "Item#:&nbsp;" . $itemz[1];
echo "<br>Price:&nbsp;" . $itemz[0];
echo "<br><b>Analyzing &nbsp;" . $ro->selectNow("patientCharges", "description", "itemNo", $itemz[1]) . "</b>";
//check kung ilan na lang ung natitira sa target amount kpg bnwsan na sa current phic ng px
$pxPHIC = $ro->getCurrentPHIC_check_rBanny($registrationNo) - $targetAmount;
//check kung mas mataas pa ung total ng item kaysa sa natitirang sa targetAmount
if ($itemz[0] >= $pxPHIC) {
    $newCash = $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemz[1]) - ($targetAmount - $ro->getTotal("phic", "", $registrationNo));
    if ($newCash > 1) {
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash);
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $targetAmount - $ro->getTotal("phic", "", $registrationNo));
    } else {
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemz[1]));
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0");
    }
} else {
    $excessPHIC = $itemz[0] - $targetAmount;
    $exactPHIC = $itemz[0] - $excessPHIC;
    $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $excessPHIC);
    $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $exactPHIC);
}
if ($ro->getTotal("phic", "", $registrationNo) != $targetAmount) {
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/analyzing_rBanny.php?registrationNo={$registrationNo}&cash={$cash}&targetAmount={$targetAmount}");
} else {
    echo "<br><Br><Br><center><font size=5 color=red><i>R-Banny is now completed the PhilHealth CaseRate</i></font></center>";
}

Example #27

File: generateBatchNo.php Project: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$registrationNo = $_POST['registrationNo'];
$itemNo = $_POST['itemNo'];
$subjective = $_POST['subjective'];
$objective = $_POST['objectives'];
$assessment = $_POST['assessment'];
$ro = new database2();
$ro->getBatchNo();
$myFile = $ro->getReportInformation("homeRoot") . "/COCONUT/trackingNo/batchNo.dat";
$fh = fopen($myFile, 'r');
$batchNo = fread($fh, 100);
fclose($fh);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/mobileAddCharges.php?batchNo={$batchNo}&registrationNo={$registrationNo}&itemNo={$itemNo}&subjective={$subjective}&objective={$objective}&assessment={$assessment}&username=ricky");

Example #28

File: addLabToPatient.php Project: rickyx12/protacio

        //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;
}
$patientNo = $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo);
$lastName = $ro->selectNow("patientRecord", "lastName", "patientNo", $patientNo);
$firstName = $ro->selectNow("patientRecord", "firstName", "patientNo", $patientNo);
$patientName = $lastName . ", " . $firstName;
$ro->addLaboratoryResultChecker($registrationNo, $itemNo);
$ro->addLaboratoryResultInPatient($registrationNo, $itemNo, $chargesCode, $username, $date, ENCRYPT_DECRYPT($result), $ro->getSynapseTime(), $remarks, $morphology, $patientName);
//$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"));
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Laboratory/resultList/resultForm_output.php?registrationNo={$registrationNo}&itemNo={$itemNo}");

Example #29

File: consumedRoom.php Project: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$targetAmount = $_GET['targetAmount'];
$ro = new database2();
$itemz = preg_split("/\\_/", $ro->getMaximumTotal_rBanny($registrationNo, "Room and Board"));
$ro->getPatientChargesToEdit($itemz[1]);
if ($ro->getTotal("cashUnpaid", "Room And Board", $registrationNo) > 0) {
    echo "<br><Br><br><br><br>";
    echo "<font color=red>R-Banny is now Calculating Room</font><br>";
    echo "Total:&nbsp;" . $itemz[0];
    echo "<br>";
    echo "Item#:&nbsp;" . $itemz[1];
    if ($targetAmount >= $itemz[0]) {
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0");
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0");
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $itemz[0]);
    } else {
        //echo "<br><Br><br><br><font color=blue size=5>R-Banny is Having a trouble in Computation</font>";
        $newCash = $itemz[0] - $targetAmount;
        $newPHIC = $ro->selectNow("patientCharges", "total", "itemNo", $itemz[1]) - $newCash;
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash);
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0");
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $newPHIC);
    }
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedRoom.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}");
} else {
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedMeds.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}");
}

Example #30

File: deletedItemsPassword1.php Project: rickyx12/mendero

<?php

include "../../myDatabase2.php";
$username = $_POST['username'];
$password = $_POST['password'];
$registrationNo = $_POST['registrationNo'];
$ro = new database2();
$asql = mysql_query("SELECT * FROM registeredUser WHERE user");
if ($username == "") {
    $ro->getBack("AUTHENTICATION ERROR");
} else {
    if ($password == "") {
        $ro->getBack("AUTHENTICATION ERROR");
    } else {
        if ($username == "" && $password == "") {
            $ro->getBack("AUTHENTICATION ERROR");
        } else {
            if ($ro->getEmployeeId_username($username, $password) != "") {
                echo "LOADING...";
                echo "<br>";
                $usernameCharges = $ro->selectNow("registeredUser", "username", "employeeID", $ro->getEmployeeId_username($username, $password));
                $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/ADMIN/pendingDelete_update.php?registrationNo={$registrationNo}&username={$usernameCharges}");
            } else {
                $ro->getBack("AUTHENTICATION ERROR");
            }
        }
    }
}