database1::selectNow PHP 코드 예제들

예제 #1

0

파일 보기

파일: reportPreview.php 프로젝트: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$reportNo = $_GET['reportNo'];
$ro = new database1();
echo $ro->selectNow("radioReportList", "title", "reportNo", $reportNo);
echo "<Br><Br>";
echo $ro->selectNow("radioReportList", "report", "reportNo", $reportNo);

예제 #2

0

파일 보기

파일: phicQTY.php 프로젝트: rickyx12/mendero

$chargesCode = $_GET['chargesCode'];
$description = $_GET['description'];
$sellingPrice = $_GET['sellingPrice'];
$discount = $_GET['discount'];
$timeCharge = $_GET['timeCharge'];
$room = $_GET['room'];
$chargeBy = $_GET['chargeBy'];
$service = $_GET['service'];
$title = $_GET['title'];
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$inventoryFrom = $_GET['inventoryFrom'];
$ro = new database1();
if ($ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < 1) {
    $ro->getBack("Sorry, Out of Stock");
}
echo "\n<style type='text/css'>\n.qty {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight:25px;\n\twidth: 100px;\n\tpadding:4px 4px 4px 10px;\n}\n\n</style>\n\n";
//addCharges.php
echo "<br><Br><Br>";
echo "<form method='get' action='http://" . $ro->getMyUrl() . "/COCONUT/availableSupplies/phicCovered.php'>";
echo "<center><div style='border:1px solid #000000; width:400px; height:100px;\t'>";
echo "<br><table border=0 cellpadding=0 cellspacing=0>";
echo "<tr>";
echo "<td><font size=4>Quantity:</font></td>";
echo "<td><input type=text class='qty' name='quantity' value='1'></td>";
echo "</tr>";
echo "<tr><td>&nbsp;</td></tr>";
echo "<tr>";
echo "<td><input type='button' class='button' value=' Back  '\nonClick='javascript: history.go(-1)' style='border:1px solid #000000; background-color:transparent;'></td>";

예제 #3

0

파일 보기

파일: radioReport_edit.php 프로젝트: rickyx12/protacio

$ro = new database1();
?>


<script type="text/javascript" src="/ckeditor/ckeditor.js"></script>

<?php 
echo "\n<style type='text/css'>\n\n.txtArea {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: auto;\n\twidth:900px;\n\tpadding:4px 4px 4px 5px;\n\tfont-size:20px;\n}\n\n</style>\n";
$ro->getPatientProfile($registrationNo);
$ro->coconutFormStart("get", "radioReport_update.php");
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("itemNo", $itemNo);
echo "<table border=0 width='160%'>";
echo "<tr>";
echo "<td><b>Name:</b>&nbsp;" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</td>";
echo "<td><b>Date:</b>&nbsp;" . $ro->selectNow("radioSavedReport", "date", "itemNo", $itemNo) . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>Age/Sex</b>&nbsp;" . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "</td>";
echo "<td>Physician:&nbsp;<b>" . $ro->selectNow("radioSavedReport", "physician", "itemNo", $itemNo) . "</b></td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>Room:</b>&nbsp;" . $ro->getRegistrationDetails_room() . "</td>";
echo "<td>Examination:&nbsp;<b>{$description}</b></td>";
echo "</tr>";
echo "</table>";
echo "<textarea id='report' name='radioReport' class='txtArea'>";
echo $ro->doubleSelectNow("radioSavedReport", "radioReport", "registrationNo", $registrationNo, "itemNo", $itemNo);
echo "</textarea>";
echo "<br><br>";
$ro->coconutButton("edit");

예제 #4

0

파일 보기

파일: radioReport_insert.php 프로젝트: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$physician = $_GET['physician'];
$radioReport = $_GET['radioReport'];
$radtech = $_GET['radtech'];
$ro = new database1();
if (isset($_GET['approved'])) {
    $ro->radioReportInsert($registrationNo, $itemNo, date("Y-m-d"), $physician, $radioReport, "Mendero Medical Center", "Consolacion,Cebu", $ro->getSynapseTime(), "yes", date("Y-m-d"), $ro->getSynapseTime(), $physician, $radtech);
} else {
    $ro->radioReportInsert($registrationNo, $itemNo, date("Y-m-d"), $physician, $radioReport, "Mendero Medical Center", "Consolacion,Cebu", $ro->getSynapseTime(), "", "", "", "", $radtech);
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Reports/radiologyReport/radioReport_output.php?itemNo={$itemNo}&registrationNo={$registrationNo}&description=" . $ro->selectNow("patientCharges", "description", "itemNo", $itemNo) . "");

예제 #5

0

파일 보기

파일: applyPackage_oct_4_2012.php 프로젝트: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$packageNo = $_GET['packageNo'];
$countz = count($packageNo);
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->getPatientProfile($registrationNo);
for ($x = 0; $x < $countz; $x++) {
    $packageIncluded = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "packageIncluded_description", "packageNo", $packageNo[$x]));
    //addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room)
    if ($packageIncluded[2] != "MEDICINE" || $packageIncluded[2] != "PROFESSIONAL FEE") {
        $services = "Examination";
    } else {
        if ($packageIncluded[2] == "MEDICINE") {
            $services = "Medication";
        } else {
            $services = "PROFESSIONAL FEE";
        }
    }
    $ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], "0.00", "0.00", "0.00", "0.00", "0.00", "0.00", $ro->getSynapseTime(), date("M_d_Y"), $username, $services, $packageIncluded[2], "Cash", "0.00", "package", $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room());
}
echo "\n<script type='text/javascript'>\nwindow.parent.location.reload();\n</script>\n\n";

예제 #6

0

파일 보기

파일: showIncluded.php 프로젝트: rickyx12/protacio

<?php

include "../packageControl.php";
include "../../../myDatabase1.php";
$packageName = $_GET['packageName'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$package = new hospitalPackage();
$ro = new database1();
/*
$ro->getBatchNo();
$myFile = $ro->getReportInformation("homeRoot")."/COCONUT/trackingNo/batchNo.dat";
$fh = fopen($myFile, 'r');
$batchNo = fread($fh, 100);
fclose($fh);
*/
$batchNo = $ro->selectNow("trackingNo", "value", "name", "batchNo");
echo "<center><font size=2 color=red>UNCHECK means the medicine/supplies is not available in the pharmacy</font>";
echo "<Br><Br>";
$package->showAddedPackage_onPatient($packageName, $registrationNo, $username, $batchNo);

예제 #7

0

파일 보기

파일: applyPackage.php 프로젝트: rickyx12/mendero

<?php

include "../../../myDatabase1.php";
$packageNo = $_GET['packageNo'];
$countz = count($packageNo);
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$batchNo = $_GET['batchNo'];
$unitcost = $_GET['unitcost'];
$Added = $_GET['Added'];
$ro = new database1();
$ro->getPatientProfile($registrationNo);
for ($x = 0; $x < $countz; $x++) {
    $packageIncluded = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "packageIncluded_description", "packageNo", $packageNo[$x]));
    //addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room)
    $sellingPrice;
    if ($packageIncluded[2] == "LABORATORY" || $packageIncluded[2] == "RADIOLOGY" || $packageIncluded[2] == "ECG" || $packageIncluded[2] == "OR/DR/ER/ Fee" || $packageIncluded[2] == "REHAB") {
        $services = "Examination";
        $chargesPrice = $ro->selectNow("availableCharges", "PRIVATE", "chargesCode", $packageIncluded[1]);
        $ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $chargesPrice, "0.00", $chargesPrice, $chargesPrice, "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "PHARMACY", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room());
    } else {
        if ($packageIncluded[2] == "MEDICINE") {
            $services = "Medication";
            $medPrice = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "Added", "packageNo", $packageNo[$x]));
            $ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $medPrice[1], "0.00", $medPrice[1], $medPrice[1], "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "PHARMACY", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room());
        } else {
            if ($packageIncluded[2] == "SUPPLIES") {
                $services = "Others";
                $supPrice = $ro->selectNow("hospitalPackage", "unitcost", "packageNo", $packageNo[$x]);
                $ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $supPrice, "0.00", $supPrice, $supPrice, "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "PHARMACY", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room());
            } else {

예제 #8

0

파일 보기

파일: radioReport_output.php 프로젝트: rickyx12/protacio

	a.document.close();
	a.focus();
	a.print();
	a.close();
}
</script>
<a href="#" onClick="printF('printData')" style="text-decoration:none; color:black;"><font color=red>PRINT</font></a>
<div id='printData'>

<?php 
echo "<center><a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/radiologyReport/radioReport_output_doctor.php?registrationNo={$registrationNo}&itemNo={$itemNo}&description={$description}'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/mendero.png' width='40%;' height='20%'></a></center>";
echo "<br>";
echo "<table border=0 width='100%;'>";
echo "<Tr>";
echo "<td><b>NAME:</b> " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</td>";
echo "<tD align='left'><b>DATE:</b> " . $ro->selectNow("radioSavedReport", "date", "itemNo", $itemNo) . "</tD>";
echo "</tr>";
echo "<tr>";
echo "<td><b>PATIENT NO:</b>&nbsp;" . $ro->getRegistrationDetails_patientNo() . "</td>";
echo "<td><b>AGE:</b> " . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>PERFORMED:&nbsp;</b> " . $ro->selectNow("radioSavedReport", "performed", "itemNo", $itemNo) . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td><B>PROCEDURE:</b> " . $ro->selectNow("patientCharges", "description", "itemNo", $itemNo) . "</td>";
echo "</tr>";
echo "</table>";
echo "</center>";
echo "<font size=4>" . $ro->selectNow("radioSavedReport", "radioReport", "itemNo", $itemNo) . "</font>";
echo "<br><br><br><br>";

예제 #9

0

파일 보기

파일: updatePriceNow.php 프로젝트: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$itemNo = $_GET['itemNo'];
$count = count($itemNo);
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$type = $_GET['type'];
$ro = new database1();
for ($x = 0; $x < $count; $x++) {
    //echo "<br>".$itemNo[$x];
    if ($type == "PhilHealth") {
        $ro->getPatientChargesToEdit($itemNo[$x]);
        if ($ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "MEDICINE" || $ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "SUPPLIES") {
            $newPrice = $ro->getInventoryPrice($ro->patientCharges_chargesCode()) + $ro->getInventoryPrice($ro->patientCharges_chargesCode()) * 0.25;
        } else {
            $newPrice = $ro->selectNow("availableCharges", "OPD", "chargesCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x])) + $ro->selectNow("availableCharges", "OPD", "chargesCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x])) * 0.25;
        }
        //phic Price
        //$newTotal = ($newPrice * $ro->patientCharges_quantity());
    } else {
        if ($type == "CASH") {
            $ro->getPatientChargesToEdit($itemNo[$x]);
            if ($ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "MEDICINE" || $ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "SUPPLIES") {
                $newPrice = $ro->getInventoryPrice($ro->patientCharges_chargesCode());
                //phic Price
            } else {
                $newPrice = $ro->selectNow("availableCharges", "OPD", "chargesCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x]));
            }
            ///$newTotal = ($newPrice * $ro->patientCharges_quantity());
        } else {

예제 #10

0

파일 보기

파일: paidNow.php 프로젝트: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$username = $_GET['username'];
$itemNo = $_GET['itemNo'];
$registrationNo = $_GET['registrationNo'];
$ro = new database1();
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "cashPaid", $ro->doubleSelectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo, "registrationNo", $registrationNo));
// kuhain ang total price at ilagay sa cashPaid cols
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "cashUnpaid", "0");
// gwen 0 ang cashUnpaid cols
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "status", "PAID");
// tagged as PAID
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "datePaid", date("M_d_Y"));
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "timePaid", $ro->getSynapseTime());
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "paidBy", $username);
// gwen 0 ang cashUnpaid cols
$newQty = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) - $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo);
$ro->editNow("inventory", "inventoryCode", $ro->doubleSelectNow("patientCharges", "chargesCode", "itemNo", $itemNo, "registrationNo", $registrationNo), "quantity", $newQty);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "departmentStatus", "dispensedBy_" . $username);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "departmentTime", $ro->getSynapseTime());

예제 #11

0

파일 보기

파일: deletePayment.php 프로젝트: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$paymentNo = $_GET['paymentNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->getPatientProfile($registrationNo);
$ro->addVoidPayment($registrationNo . "_" . $ro->getPatientRecord_completeName(), "IPD_DELETE_" . $ro->selectNow("patientPayment", "paymentFor", "paymentNo", $paymentNo), $ro->selectNow("patientPayment", "amountPaid", "paymentNo", $paymentNo), $ro->getSynapseTime(), date("Y-m-d"), $username);
$ro->deleteNow("patientPayment", "paymentNo", $paymentNo);
echo "\n\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/viewPayment.php?username={$username}&registrationNo={$registrationNo}'\n</script>\n\n";

예제 #12

0

파일 보기

파일: radioReport.php 프로젝트: rickyx12/protacio

echo "<tr>";
echo "<td><b>AGE:&nbsp;</b>" . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "</td>";
echo "<td></td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>PROCEDURE:</b>&nbsp;{$description}</td>";
echo "<td></td>";
echo "</tr>";
echo "<tr>";
echo "<td></td>";
echo "</tr>";
echo "<tr>";
echo "<td></td>";
echo "</tr>";
echo "</table>";
$text = $ro->selectNow("radioReportList", "report", "title", $report);
//$breaks = array("<br>","<br/>","<b>","</b>");
//$text1 = str_ireplace($breaks, "\r\n",$text);
echo "<textarea id='report' name='radioReport'>";
echo $text;
echo "</textarea>";
echo "<br>";
echo "<input type='checkbox' name='approved'><font color=red>Approved</font>";
echo "<bR><br>";
$ro->coconutButton("Proceed");
$ro->coconutFormStop();
echo "</div></div>";
?>

<script type="text/javascript" src="http://<?php 
echo $ro->getMyUrl();

예제 #13

0

파일 보기

파일: phicCovered.php 프로젝트: rickyx12/protacio

$description = $_GET['description'];
$sellingPrice = $_GET['sellingPrice'];
$timeCharge = $_GET['timeCharge'];
$chargeBy = $_GET['chargeBy'];
$service = $_GET['service'];
$title = $_GET['title'];
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$discount = $_GET['discount'];
$inventoryFrom = $_GET['inventoryFrom'];
$room = $_GET['room'];
$quantity = $_GET['quantity'];
$ro = new database1();
$ro->getPHIClimit_setter($ro->selectNow("registrationDetails", "casetype", "registrationNo", $registrationNo));
$ro->getPatientProfile($registrationNo);
// kunin ang data ng patient
//$totalPrice = $sellingPrice * $quantity; //kunin ang total price
//selectNow($table,$cols,$identifier,$identifierData)
//$ro->selectNow("inventory","phic","inventoryCode",$chargesCode); // ttgnan kung cover ba ng philhealth ung medicine
if ($quantity == 0) {
    $ro->getBack("Zero is not Allowed");
} else {
    //number_format($ro->getCurrentPHIC_check($registrationNo,"MEDICINE") - $ro->getPHIClimit_medicine(),2)
    $remainingLimit = $ro->getPHIClimit_medicine() - $ro->getCurrentPHIC_check($registrationNo, "MEDICINE");
    if ($ro->getPatientRecord_phic() == "YES") {
        //cover at pasok pa sa phic limit ng meds
        $totalPrice = $sellingPrice * $quantity;
        //phic price
        if ($remainingLimit >= $totalPrice) {

예제 #14

0

파일 보기

파일: passwordComment1.php 프로젝트: rickyx12/protacio

<?php

include "../../myDatabase1.php";
$password = $_POST['password'];
$comment = $_POST['comment'];
$ro = new database1();
if ($ro->selectNow("registeredUser", "username", "password", $password) != "") {
    $username = $ro->selectNow("registeredUser", "username", "password", $password);
    header("Location: /COCONUT/Homepage/addComment.php?username={$username}&comment={$comment}");
} else {
    echo "<script type='text/javascript'>\nalert('Incorrect Password');\nhistory.back();\n</script>";
}

예제 #15

0

파일 보기

파일: checkingStop_04242014.php 프로젝트: rickyx12/protacio

<?php

include "../myDatabase1.php";
$patientNo = $_GET['patientNo'];
$date = $_GET['date'];
$ro = new database1();
if ($ro->selectNow("reportHeading", "information", "reportName", "stopDoubleRegistration") == "Activate") {
    if ($ro->checkingStop($patientNo, date("Y-m-d")) == "") {
        header("Location:http://" . $ro->getMyUrl() . "/Registration/newRecord_again.php?patientNo={$patientNo}");
    } else {
        header("Location:http://" . $ro->getMyUrl() . "/Registration/stopRegistration.php");
    }
} else {
    header("Location:http://" . $ro->getMyUrl() . "/Registration/newRecord_again.php?patientNo={$patientNo}");
}

예제 #16

0

파일 보기

파일: noteChecker.php 프로젝트: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database1();
if ($ro->selectNow("promisorryNote", "registrationNo", "registrationNo", $registrationNo) != "") {
    header("Location: editPromisorry.php?username={$username}&registrationNo={$registrationNo}");
} else {
    header("Location: addPromisorry.php?username={$username}&registrationNo={$registrationNo}");
}

예제 #17

0

파일 보기

파일: phicCovered.php 프로젝트: rickyx12/protacio

$sellingPrice = $_GET['sellingPrice'];
$timeCharge = $_GET['timeCharge'];
$chargeBy = $_GET['chargeBy'];
$service = $_GET['service'];
$title = $_GET['title'];
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$discount = $_GET['discount'];
$inventoryFrom = $_GET['inventoryFrom'];
$room = $_GET['room'];
$quantity = $_GET['quantity'];
$remarks = $_GET['remarks'];
$ro = new database1();
$ro->getPHIClimit_setter($ro->selectNow("registrationDetails", "casetype", "registrationNo", $registrationNo));
$ro->getPatientProfile($registrationNo);
// kunin ang data ng patient
//$totalPrice = $sellingPrice * $quantity; //kunin ang total price
//selectNow($table,$cols,$identifier,$identifierData)
//$ro->selectNow("inventory","phic","inventoryCode",$chargesCode); // ttgnan kung cover ba ng philhealth ung medicine
//number_format($ro->getCurrentPHIC_check($registrationNo,"MEDICINE") - $ro->getPHIClimit_medicine(),2)
if ($quantity == 0) {
    $ro->getBack("Zero is not Allowed");
} else {
    $remainingLimit = $ro->getPHIClimit_suppliesOnly() - $ro->getTotal("phic", "SUPPLIES", $registrationNo);
    if ($ro->selectNow("inventory", "phic", "inventoryCode", $chargesCode) == "yes" && $ro->getPatientRecord_phic() == "YES") {
        //cover at pasok pa sa phic limit ng meds
        //$totalPrice = (($sellingPrice * 0.15) + $sellingPrice) * $quantity; //phic price
        $totalPrice = $sellingPrice * $quantity;
        // cashPrice muna for temporary

예제 #18

0

파일 보기

파일: resultForm_output.php 프로젝트: rickyx12/protacio

echo "<style type='text/css'>";
echo "\n\n.linez{\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 28px;\n\twidth: 300px;\n\tfont-weight:bold;\n\tborder-color:white white black white;\n\tfont-size:15px;\n\n}\n\n";
echo "</style>";
//echo "<br>";
//echo "<center><font size=4><b>MENDERO MEDICAL CENTER</b></font></center>";
//echo "<center><b><font size=3><b>LABORATORY DEPARTMENT</b></font></b></center>";
//echo "<center><font size=3>Consolacion, Cebu City</font></center>";
//echo "<center><font size=3>Tel No. 062-2143237</font></center>";
echo "<br><br><br><Br><br><Br><Br><Br>";
echo "<center>";
echo "<table border=0 cellspacing=0 cellpadding=1 width='100%' >";
echo "<tr>";
echo "<td><B>Patient ID:</b></td>";
echo "<td><input type='text' class='linez' value='" . $ro->getRegistrationDetails_patientNo() . "'></td>";
echo "<td><B>Date:</b></td>";
echo "<td><input type='text' class='linez' value='" . $ro->selectNow("labSavedResult", "date", "itemNo", $itemNo) . "@" . $ro->selectNow("labSavedResult", "time", "itemNo", $itemNo) . "'></td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>Name:</b></td>";
echo "<td><input type='text' class='linez' value='" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "'></td>";
echo "<td><b>Age/Sex:</b></td>";
echo "<td><input type='text' class='linez' value='" . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "'></td>";
echo "</tr>";
echo "<tr>";
echo "<Td><b>Date of Birth:</td>";
echo "<td></b><input type='text' class='linez' value='" . $ro->getPatientRecord_birthDate() . "'></tD>";
echo "<td><b>Status:</td>";
echo "<td></b><input type='text' class='linez' value='" . $ro->getPatientRecord_civilStatus() . "'></tD>";
echo "</tr>";
echo "<tr>";
echo "<Td><b>Physician:</b></td>";

예제 #19

0

파일 보기

파일: individualPaid.php 프로젝트: rickyx12/protacio

$itemNo = $_GET['itemNo'];
$username = $_GET['username'];
$module = $_GET['module'];
$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'];
$ro = new database1();
//$ro->doubleEditNow("patientCharges","registrationNo",$registrationNo,"itemNo",$itemNo,"status","PAID");
//$ro->doubleEditNow("patientCharges","registrationNo",$registrationNo,"itemNo",$itemNo,"cashUnpaid","0.00");
if ($ro->selectNow("patientCharges", "title", "itemNo", $itemNo) == "MEDICINE") {
    $price = preg_split("/\\_/", $ro->selectNow("inventory", "Added", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)));
    $totalPay = $price[1] * $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo);
    $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "status", "PAID");
    $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "cashUnpaid", "0.00");
    $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "phic", "0.00");
    $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "company", "0.00");
    $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "cashPaid", $totalPay);
    $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "sellingPrice", $price[1]);
    $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "total", $totalPay);
    $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "datePaid", date("Y-m-d"));
    $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "timePaid", $ro->getSynapseTime());
    $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "paidBy", $username);
} else {
    //supplies
    $totalPay = $ro->selectNow("inventory", "unitcost", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) * $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo);

예제 #20

0

파일 보기

파일: magicPackage_feb3.php 프로젝트: rickyx12/protacio

$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("Room's");
$ro->coconutTableData(number_format($ro->getTotal("phic", "Room And Board", $registrationNo), 2));
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("PROFESSIONAL FEE");
$ro->coconutTableData(number_format($ro->getTotal("phic", "PROFESSIONAL FEE", $registrationNo), 2));
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>TOTAL PHILHEALTH</b>");
$ro->coconutTableData("<font color=red><b>" . number_format($totalPHIC, 2) . "</b></font>");
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>PHILHEALTH PACKAGE</b>");
$ro->coconutTableData("<b>" . number_format($ro->selectNow("package", "price", "description", $ro->getRegistrationDetails_package()), 2) . "</b>");
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>SHORT</b>");
$ro->coconutTableData("<font color=red><b>" . number_format($ro->selectNow("package", "price", "description", $ro->getRegistrationDetails_package()) - $totalPHIC, 2) . "</b></font>");
$ro->coconutTableRowStop();
$ro->coconutTableStop();
echo "<br><Br>";
$shortPHIC = $ro->selectNow("package", "price", "description", $ro->getRegistrationDetails_package()) - $totalPHIC;
$ro->coconutFormStart("get", "magicPackage1.php");
$ro->coconutHidden("short", $shortPHIC);
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutButton("Apply Short Package");
$ro->coconutFormStop();
/*
echo "MEDICINE:&nbsp;".number_format($ro->getTotal("phic","MEDICINE",$registrationNo),2);

예제 #21

0

파일 보기

파일: applyPackage.php 프로젝트: rickyx12/mendero

<?php

include "../../../myDatabase1.php";
$packageNo = $_GET['packageNo'];
$countz = count($packageNo);
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$batchNo = $_GET['batchNo'];
$unitcost = $_GET['unitcost'];
$Added = $_GET['Added'];
$ro = new database1();
$ro->getPatientProfile($registrationNo);
for ($x = 0; $x < $countz; $x++) {
    $packageIncluded = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "packageIncluded_description", "packageNo", $packageNo[$x]));
    $itemQTY = $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]);
    //addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room)
    $sellingPrice;
    if ($packageIncluded[2] == "LABORATORY" || $packageIncluded[2] == "RADIOLOGY" || $packageIncluded[2] == "ECG" || $packageIncluded[2] == "OR/DR/ER Fee" || $packageIncluded[2] == "REHAB") {
        $services = "Examination";
        $chargesPrice = $ro->selectNow("availableCharges", "PRIVATE", "chargesCode", $packageIncluded[1]);
        $ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $chargesPrice, "0.00", $chargesPrice, $chargesPrice, "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), $ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $packageIncluded[1]), $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room());
    } else {
        if ($packageIncluded[2] == "MEDICINE") {
            $services = "Medication";
            $medPrice = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "Added", "packageNo", $packageNo[$x]));
            //original
            //$ro->addCharges_cash("UNPAID",$registrationNo,$packageIncluded[1],$packageIncluded[0],$medPrice[1],"0.00",$medPrice[1],$medPrice[1],"0.00","0.00",$ro->getSynapseTime(),date("Y-m-d"),$username,$services,$packageIncluded[2],"Cash","0.00",$batchNo,$ro->selectNow("hospitalPackage","packageIncluded_qty","packageNo",$packageNo[$x]),"PHARMACY",$ro->getRegistrationDetails_branch(),$ro->getRegistrationDetails_room());
            if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $packageIncluded[1]) == "yes") {
                //check autoDispense
                $currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $packageIncluded[1]);
                // current qty ng meds sa inventory

예제 #22

0

파일 보기

파일: clinicalCoverSheet.php 프로젝트: rickyx12/protacio

echo "<td>Address: <input type='text' value='" . $ro->getPatientRecord_address() . "' class='address'> </td>";
echo "</tr>";
echo "<tr>";
echo "<td>Date Admitted: <input type='text' value='" . $ro->getRegistrationDetails_dateRegistered() . "' class='dateAdmitted'> </td>";
echo "</tr>";
echo "<tr>";
echo "<td>Date Discharged: <input type='text' value='" . $ro->getRegistrationDetails_dateUnregistered() . "' class='dateDischarged'> </td>";
echo "</tr>";
$ro->clinicalCoverSheet_atteding($registrationNo);
echo "<tr>";
echo "<td>Admitting Diagnosis: <input type='text' value='" . $ro->getRegistrationDetails_IxDx() . "' class='admittingDiagnosis'> </td>";
echo "</tr>";
echo "<tr>";
echo "<td><font color='white'>Admitting Diagnosis:</font> <input type='text' value='' class='admittingDiagnosis'> </td>";
echo "</tr>";
if ($ro->selectNow("patientICD", "diagnosis", "registrationNo", $registrationNo) != "") {
    echo "<tr>";
    echo "<td><font>Final Diagnosis:</font> <input type='text' value='" . substr($ro->clinicalCoverSheet_finalDiagnosis($registrationNo), 0, 56) . "' class='finalDiagnosis'> </td>";
    echo "</tr>";
    if (strlen($ro->clinicalCoverSheet_finalDiagnosis($registrationNo)) > 56) {
        echo "<tr>";
        echo "<td><font color='white'>Final Diagnosis:</font> <input type='text' value='" . substr($ro->clinicalCoverSheet_finalDiagnosis($registrationNo), 56, 56) . "' class='finalDiagnosis'> </td>";
        echo "</tr>";
    } else {
        echo "<tr>";
        echo "<td><font color='white'>Final Diagnosis:</font> <input type='text' value='' class='finalDiagnosis'> </td>";
        echo "</tr>";
    }
    if (strlen($ro->clinicalCoverSheet_finalDiagnosis($registrationNo)) > 112) {
        echo "<tr>";
        echo "<td><font color='white'>Final Diagnosis:</font> <input type='text' value='" . substr($ro->clinicalCoverSheet_finalDiagnosis($registrationNo), 112, 56) . "' class='finalDiagnosis'> </td>";

예제 #23

0

파일 보기

파일: editResultForm.php 프로젝트: rickyx12/protacio

include "../../../myDatabase1.php";
$title = $_GET['title'];
$templateNo = $_GET['templateNo'];
$ro = new database1();
$ro->coconutDesign();
echo "<br>";
echo "<font size=4>TITLE:&nbsp;</font>";
$ro->coconutFormStart("post", "editResultForm1.php");
$ro->coconutTextBox("title", $title);
$ro->coconutHidden("templateNo", $templateNo);
?>

<script type="text/javascript" src="/ckeditor/ckeditor.js"></script>

<?php 
echo "<textarea id='formTemplate' name='formTemplate'>" . $ro->selectNow("labResultList", "template", "templateNo", $templateNo) . "</textarea>";
$ro->coconutFormStop();
?>

<script type="text/javascript">
			
			CKEDITOR.replace( 'formTemplate',
	{
		enterMode : CKEDITOR.ENTER_BR,
		skin : 'office2003',
		extraPlugins:'autogrow'
	});
		

</script>

예제 #24

0

파일 보기

파일: patientProfile_right_oct_4_2012.php 프로젝트: rickyx12/protacio

echo "<br><font class='informationLabel'>Civil Status:</font>&nbsp;" . $ro->getPatientRecord_civilStatus();
echo "<br><font class='informationLabel'>Birth Date:</font>&nbsp;" . $ro->getPatientRecord_Birthdate();
echo "<br><font class='informationLabel'>Contact No#:</font>&nbsp;" . $ro->getPatientRecord_contactNo();
echo "<br><font class='informationLabel'>Senior:</font>&nbsp;" . $ro->getPatientRecord_senior();
echo "<br><font class='informationLabel'>PhilHealth:</font>&nbsp;" . $ro->getPatientRecord_phic();
echo "<br><font class='informationLabel'>PhilHealth Type:</font>&nbsp;" . $ro->getPHICtype_patientRecord();
echo "<br><font class='informationLabel'>Company:</font>&nbsp;" . $ro->getRegistrationDetails_company();
echo "<br><font class='informationLabel'>Time Registered:</font>&nbsp;" . $ro->getRegistrationDetails_timeRegistered();
echo "<br><font class='informationLabel'>Date Registered:</font>&nbsp;" . $ro->getRegistrationDetails_dateRegistered();
echo "<br><font class='informationLabel'>Branch Registered:</font>&nbsp;" . $ro->getRegistrationDetails_branch();
echo "<br><font class='informationLabel'>Case Type:</font>&nbsp;<a href='#' style='text-decoration:none; color:black;'>" . $ro->getRegistrationDetails_caseType() . "</a>";
echo "<br><font class='informationLabel'>Package:</font>&nbsp;<a href='#' style='text-decoration:none; color:black;'>" . $ro->getRegistrationDetails_package() . "</a>";
echo "<br><font class='informationLabel'>Room:</font>&nbsp;" . $room[0];
echo "<br><font class='informationLabel'>Address:</font>&nbsp;" . $ro->getPatientRecord_address();
echo "<br><font class='informationLabel'>Registered By:</font>&nbsp;" . $ro->getRegistrationDetails_registeredBy();
if ($ro->selectNow("reportHeading", "information", "reportName", "Credit Limit") == "Activate" and $ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo) == "IPD") {
    echo "<br><font class='informationLabel' color=blue>Allowed Balance:</font>&nbsp;" . number_format($ro->selectNow("registrationDetails", "LimitCASH", "registrationNo", $registrationNo), 2);
    echo "<br><font class='informationLabel' color=red>Current Balance:</font>&nbsp;" . number_format($ro->may_naibayad_naba_ang_patient($registrationNo), 2);
} else {
}
if ($ro->getRegistrationDetails_dateUnregistered() != "") {
    echo "<br><font class='informationLabel'>Time Discharged:</font>&nbsp;" . $ro->getRegistrationDetails_timeUnregistered();
    echo "<br><font class='informationLabel'>Discharged:</font>&nbsp;" . $ro->getRegistrationDetails_dateUnregistered();
} else {
    echo "";
}
echo "<br><br><font size=2 color=red><b>VITAL SIGN</b></font>";
echo "<br><font class='informationLabel'>Height:</font>&nbsp;" . $ro->getRegistrationDetails_height();
echo "<br><font class='informationLabel'>Weight:</font>&nbsp;" . $ro->getRegistrationDetails_weight();
echo "<br><font class='informationLabel'>Blood Pressure:</font>&nbsp;" . $ro->getRegistrationDetails_bloodPressure();
echo "<br><font class='informationLabel'>Temperature:</font>&nbsp;" . $ro->getRegistrationDetails_temperature();

예제 #25

0

파일 보기

파일: radioReportSettings.php 프로젝트: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$description = $_GET['description'];
$branch = $_GET['branch'];
$ro = new database1();
$ro->coconutDesign();
echo "<br><br><br>";
$ro->getPatientProfile($registrationNo);
if ($ro->selectNow("radioSavedReport", "itemNo", "itemNo", $itemNo) != "") {
    echo "{$description} <font color=red> is For Approval of " . $ro->selectNow("radioSavedReport", "physician", "itemNo", $itemNo) . "</font>";
} else {
    //$ro->coconutFormStart("get","radioReport.php");
    echo "<form method='get' action='radioReport.php' target='_blank'>";
    $ro->coconutHidden("registrationNo", $registrationNo);
    $ro->coconutHidden("itemNo", $itemNo);
    $ro->coconutHidden("description", $description);
    echo "<center><font color=red>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</font>";
    $ro->coconutBoxStart("500", "145");
    echo "<br>";
    echo "<table border=0>";
    echo "<tr>";
    echo "<td>Report</td>";
    echo "<td>";
    $ro->coconutComboBoxStart_long("report");
    $ro->showOption_radio();
    $ro->coconutComboBoxStop();
    echo "</td>";
    echo "</tr>";

예제 #26

0

파일 보기

파일: consumePackage.php 프로젝트: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$ro = new database1();
echo "<br><Br><br>";
echo "<font color=blue><b>PhilHealth Package</b></font>:&nbsp;" . number_format($ro->selectNow("package", "price", "description", $ro->selectNow("registrationDetails", "package", "registrationNo", $registrationNo)), 2);
echo "<Br>";
echo "<font color=green><b>Total PhilHealth Covered</b></font>:&nbsp;" . number_format($ro->getTotal_paidVia($registrationNo, "phic"), 2);
$descrepancy = $ro->selectNow("package", "price", "description", $ro->selectNow("registrationDetails", "package", "registrationNo", $registrationNo)) - $ro->getTotal_paidVia($registrationNo, "phic");
echo "<br>";
echo "<font color=red><b>Descrepancy:</b></font>&nbsp;" . number_format($descrepancy, 2);
echo "<br><br>";
$misc = $ro->getTotal("cashUnpaid", "MISCELLANEOUS", $registrationNo);
$nsCharges = $ro->getTotal("cashUnpaid", "NURSING-CHARGES", $registrationNo);
$medicine = $ro->getTotal("cashUnpaid", "MEDICINE", $registrationNo);
$supplies = $ro->getTotal("cashUnpaid", "SUPPLIES", $registrationNo);
if ($descrepancy > $misc) {
    echo "MISCELLANEOUS:&nbsp;" . number_format($ro->getTotal("cashUnpaid", "MISCELLANEOUS", $registrationNo), 2);
} else {
    if ($descrepancy > $nsCharges) {
        echo "NURSING-CHARGES:&nbsp;" . number_format($ro->getTotal("cashUnpaid", "NURSING-CHARGES", $registrationNo), 2);
    } else {
        if ($descrepancy > $medicine) {
            echo "MEDICINE:&nbsp;" . number_format($ro->getTotal("cashUnpaid", "MEDICINE", $registrationNo), 2);
        } else {
            if ($descrepancy > $supplies) {
                echo "SUPPLIES:&nbsp;" . number_format($ro->getTotal("cashUnpaid", "SUPPLIES", $registrationNo), 2);
            } else {
            }
        }

예제 #27

0

파일 보기

파일: unknownPatient.php 프로젝트: rickyx12/mendero

$from = $_GET['from'];
$ro = new database1();
/*
$ro->getRegistrationNo();
$myFile = $ro->getReportInformation("homeRoot")."/COCONUT/trackingNo/registrationNo.dat";
$fh = fopen($myFile, 'r');
$registrationNo = fread($fh, 100);
fclose($fh);

$ro->getPatientID();
$myFile = $ro->getReportInformation("homeRoot")."/COCONUT/trackingNo/patientID.dat";
$fh = fopen($myFile, 'r');
$patientNo = fread($fh, 100);
fclose($fh);
*/
$registrationNo = $ro->selectNow("trackingNo", "value", "name", "registrationNo");
$patientNo = $ro->selectNow("trackingNo", "value", "name", "patientNo");
$incrementRegistrationNo = $ro->selectNow("trackingNo", "value", "name", "registrationNo") + 1;
$incrementPatientNo = $ro->selectNow("trackingNo", "value", "name", "patientNo") + 1;
$ro->editNow("trackingNo", "name", "registrationNo", "value", $incrementRegistrationNo);
$ro->editNow("trackingNo", "name", "patientNo", "value", $incrementPatientNo);
$ro->coconutDesign();
?>

<link rel="stylesheet" type="text/css" href="http://<?php 
echo $ro->getMyUrl();
?>
/COCONUT/flow/rickyCSS1.css" />

<script type='text/javascript'>
$("#breadcrumbs a").hover(

예제 #28

0

파일 보기

파일: editPromisorry.php 프로젝트: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$username = $_GET['username'];
$registrationNo = $_GET['registrationNo'];
$ro = new database1();
echo "<script type='text/javascript' src='/ckeditor/ckeditor.js'></script>";
$ro->coconutDesign();
$startDate = preg_split("/\\_/", $ro->selectNow("promisorryNote", "startDate", "registrationNo", $registrationNo));
$dueDate = preg_split("/\\_/", $ro->selectNow("promisorryNote", "dueDate", "registrationNo", $registrationNo));
$ro->coconutFormStart("post", "editPromisorry1.php");
echo "<table border=0>";
echo "<tr>";
echo "<td>Date&nbsp;</tD>";
echo "<td>";
$ro->coconutComboBoxStart_short("month");
echo "<option value='" . $startDate[0] . "'>" . $startDate[0] . "</option>";
echo "<option value='Jan'>Jan</option>";
echo "<option value='Feb'>Feb</option>";
echo "<option value='Mar'>Mar</option>";
echo "<option value='Apr'>Apr</option>";
echo "<option value='May'>May</option>";
echo "<option value='Jun'>Jun</option>";
echo "<option value='Jul'>Jul</option>";
echo "<option value='Aug'>Aug</option>";
echo "<option value='Sep'>Sep</option>";
echo "<option value='Oct'>Oct</option>";
echo "<option value='Nov'>Nov</option>";
echo "<option value='Dec'>Dec</option>";
$ro->coconutComboBoxStop();
echo "&nbsp;";

예제 #29

0

파일 보기

파일: patientProfile_left_oct_4_2012.php 프로젝트: rickyx12/protacio

<?php

include "../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->getBatchNo();
$myFile = $ro->getReportInformation("homeRoot") . "/COCONUT/trackingNo/batchNo.dat";
$fh = fopen($myFile, 'r');
$batchNo = fread($fh, 100);
fclose($fh);
echo "\r\n\r\n<style type='text/css'>\r\na \r\n{ \r\ntext-decoration:none;\r\ncolor:black;\r\nfont-weight:bold;\r\n }\r\nul { list-style-type:none; }\r\ndisplay: block;\r\n</style>\r\n\r\n";
$ro->getPatientProfile($registrationNo);
if ($ro->selectNow("registeredUser", "module", "username", $ro->getRegistrationDetails_registeredBy()) == "MI") {
    echo "<br><hr><font size=2 color=blue>" . $ro->getPatientRecord_lastName() . " " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . ".</font><hr>";
} else {
    echo "<br><hr><font size=2 color=red>" . $ro->getPatientRecord_lastName() . " " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "</font><hr>";
}
echo "<ul>";
echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_right.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "' target='rightFrame'><font size=2>Information</font></a></li>";
if ($ro->getRegistrationDetails_caseType() != "") {
    echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/show_phicLimit.php?registrationNo={$registrationNo}&casetype=" . $ro->getRegistrationDetails_caseType() . "' target='rightFrame'><font size=2>Credit Limit</font></a></li>";
} else {
    echo "";
}
/*
if($ro->getRegistrationDetails_room() != "OPD_OPD") {
echo "<li><a href='http://".$ro->getMyUrl()."/COCONUT/patientProfile/creditLimit/viewCreditLimit.php?registrationNo=$registrationNo&username=$username' target='rightFrame'><font size=2>Credit Limit</font></a></li>";
}else {
echo "";
}

예제 #30

0

파일 보기

파일: addMisc.php 프로젝트: rickyx12/protacio

<?php

include "../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->coconutDesign();
echo "\n<style type='text/css'>\n\n.txtArea {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 380px;\n\twidth: 690px;\n\tpadding:4px 4px 4px 5px;\n\tfont-size:15px;\n}\n\n</style>\n";
echo "<br>";
echo "<b>" . $ro->selectNow("patientCharges", "description", "itemNo", $itemNo) . "</b>";
echo "<br><Br>";
echo "<b><b>";
$ro->coconutFormStart("get", "addMisc1.php");
$ro->coconutHidden("examName", $ro->selectNow("patientCharges", "description", "itemNo", $itemNo));
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("itemNo", $itemNo);
$ro->coconutHidden("username", $username);
echo "<textarea name='examResult' class='txtArea'></textarea>";
echo "<br><br>";
$ro->coconutButton("Proceed");
$ro->coconutFormStop();

PHP database1::selectNow 예제들