PHP database2::doubleEditNow示例

示例#1

文件： reconcileDetails_editNow.php 项目： rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$reconcileNo = $_GET['reconcileNo'];
$refno = $_GET['refno'];
$amount = $_GET['amount'];
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$remarks = $_GET['remarks'];
$ro = new database2();
$date = $month . "_" . $day . "_" . $year;
$ro->doubleEditNow("phicReconcile", "reconcileNo", $reconcileNo, "registrationNo", $registrationNo, "refno", $refno);
$ro->doubleEditNow("phicReconcile", "reconcileNo", $reconcileNo, "registrationNo", $registrationNo, "amount", $amount);
$ro->doubleEditNow("phicReconcile", "reconcileNo", $reconcileNo, "registrationNo", $registrationNo, "date", $date);
$ro->doubleEditNow("phicReconcile", "reconcileNo", $reconcileNo, "registrationNo", $registrationNo, "remarks", $remarks);
echo "\n<script language='javascript' type='text/javascript'>\nfunction closeWindow() {\nwindow.open('','_parent','');\nwindow.close();\n}\n</script> \n";
echo "<Br><Br><Br>";
echo "<a href='javascript:closeWindow();' style='text-decoration:none; color:red;'>CLOSE</a>";

示例#2

文件： discount1.php 项目： rickyx12/mendero

<?php

include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$count = count($itemNo);
$ro = new database2();
for ($x = 0; $x < $count; $x++) {
    $sellingPrice = $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo[$x]);
    $disc = $ro->selectNow("patientCharges", "total", "itemNo", $itemNo[$x]) * 0.2;
    //$ro->doubleEditNow("patientCharges","itemNo",$itemNo[$x],"registrationNo",$registrationNo,"sellingPrice",$sellingPrice);
    $ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "total", $sellingPrice * $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo[$x]) - $disc);
    $ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "discount", $disc);
    $ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "cashUnpaid", $sellingPrice * $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo[$x]) - $disc);
}
echo "<font color=red>Discount Applied.!</font>";

示例#3

文件： mobileAddCharges.php 项目： rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$batchNo = $_GET['batchNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$itemNo = $_GET['itemNo'];
$subjective = $_GET['subjective'];
$objective = $_GET['objective'];
$assessment = $_GET['assessment'];
$ro = new database2();
if ($ro->selectNow("SOAP", "itemNo", "itemNo", $itemNo) != "") {
    $ro->doubleEditNow("SOAP", "itemNo", $itemNo, "registrationNo", $registrationNo, "subjective", $subjective);
    $ro->doubleEditNow("SOAP", "itemNo", $itemNo, "registrationNo", $registrationNo, "objective", $objective);
    $ro->doubleEditNow("SOAP", "itemNo", $itemNo, "registrationNo", $registrationNo, "assessment", $assessment);
} else {
    $ro->insert_soap($itemNo, $registrationNo, $subjective, $objective, $assessment, "");
}
echo "<div style='background:#47a3da; margin:10px; height:60px; width:350px; border-radius:15px;' >";
echo "<br><center>";
echo "<table border=0>";
echo "<tr>";
echo "<td>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/mobileAddCharges_charges_handler.php");
echo "<input type='submit' style='background:#47a3da; border:0px; color:white; font-weight:bold; font-size:20px;' value='Charges'>";
$ro->coconutHidden("batchNo", $batchNo);
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("room", $ro->selectNow("registrationDetails", "room", "registrationNo", $registrationNo));
$ro->coconutHidden("username", $username);
$ro->coconutFormStop();
echo "</td>";

示例#4

文件： inventoryMovement_insert.php 项目： rickyx12/protacio

include "../../../myDatabase2.php";
$menu = $_GET['menu'];
$stockCardNo = $_GET['stockCardNo'];
$movementNo = $_GET['movementNo'];
$type = $_GET['type'];
$medType = $_GET['medType'];
$control = $_GET['control'];
$username = $_GET['username'];
$year = $_GET['year'];
$ro = new database2();
if ($menu == "firstThreePurchases") {
    $endingInventory1 = $_GET['endingInventory1'];
    if ($control == "encode") {
        $ro->inventoryMovement_insertEndingInventory($stockCardNo, "endingInventory", $endingInventory1);
    } else {
        $ro->doubleEditNow("inventoryMovement", "movementNo", $movementNo, "stockCardNo", $stockCardNo, "endingInventory", $endingInventory1);
    }
} else {
    if ($menu == "secondThreePurchases") {
        $endingInventory2 = $_GET['endingInventory2'];
        if ($control == "encode") {
            $ro->inventoryMovement_insertEndingInventory($stockCardNo, "endingInventory1", $endingInventory2);
        } 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 {

示例#5

文件： itemException1.php 项目： rickyx12/protacio

<?php

include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$count = count($itemNo);
$ro = new database2();
for ($x = 0; $x < $count; $x++) {
    if ($ro->doubleSelectNow("patientCharges", "rBannyStatus", "registrationNo", $registrationNo, "itemNo", $itemNo[$x]) == "exclude") {
        $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo[$x], "rBannyStatus", "");
    } else {
        $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo[$x], "rBannyStatus", "exclude");
    }
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/itemException.php?registrationNo={$registrationNo}");