PHP database1 Examples

Example #1

File: editResultForm.php Project: rickyx12/protacio

<?php

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'
	});
		

Example #2

File: addPackage.php Project: rickyx12/protacio

<?php

include "../../myDatabase1.php";
$ro = new database1();
$ro->coconutDesign();
echo "<br><br><br><br><br>";
$ro->coconutFormStart("get", "addPackage1.php");
$ro->coconutBoxStart("500", "80");
echo "<Br>";
echo "<table border=0>";
echo "<tr>";
echo "<Td>Package Name&nbsp;</tD>";
echo "<td>";
$ro->coconutTextBox("packageName", "");
echo "</td>";
echo "</tr>";
echo "</table>";
echo "<br>";
$ro->coconutButton("Proceed");
$ro->coconutBoxStop();
$ro->coconutFormStop();

Example #3

File: annualPHIC_receivables.php Project: rickyx12/protacio

 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 * 
 */
/**
 * Multiple line chart demonstration.
 *
 */
include "../../../COCONUT/libchart/libchart/classes/libchart.php";
$chart = new revenueLineChart("1500", "500");
$ro = new database1();
$serie1 = new XYDataSet();
$serie1->addPoint(new Point("Jan {$year}", $ro->getPHICReceivablesAnnual("Jan", $year) / 1000));
$serie1->addPoint(new Point("Feb {$year}", $ro->getPHICReceivablesAnnual("Feb", $year) / 1000));
$serie1->addPoint(new Point("Mar {$year}", $ro->getPHICReceivablesAnnual("Mar", $year) / 1000));
$serie1->addPoint(new Point("Apr {$year}", $ro->getPHICReceivablesAnnual("Apr", $year) / 1000));
$serie1->addPoint(new Point("May {$year}", $ro->getPHICReceivablesAnnual("May", $year) / 1000));
$serie1->addPoint(new Point("Jun {$year}", $ro->getPHICReceivablesAnnual("Jun", $year) / 1000));
$serie1->addPoint(new Point("Jul {$year}", $ro->getPHICReceivablesAnnual("Jul", $year) / 1000));
$serie1->addPoint(new Point("Aug {$year}", $ro->getPHICReceivablesAnnual("Aug", $year) / 1000));
$serie1->addPoint(new Point("Sep {$year}", $ro->getPHICReceivablesAnnual("Sep", $year) / 1000));
$serie1->addPoint(new Point("Oct {$year}", $ro->getPHICReceivablesAnnual("Oct", $year) / 1000));
$serie1->addPoint(new Point("Nov {$year}", $ro->getPHICReceivablesAnnual("Nov", $year) / 1000));
$serie1->addPoint(new Point("Dec {$year}", $ro->getPHICReceivablesAnnual("Dec", $year) / 1000));
$serie2 = new XYDataSet();
$serie2->addPoint(new Point("Jan {$year}", $ro->getPHICReceivablesAnnual_package("Jan", $year) / 1000));

Example #4

File: unremit.php Project: rickyx12/protacio

<?php

include "../../myDatabase1.php";
$itemNo = $_GET['itemNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->editNow("patientCharges", "itemNo", $itemNo, "departmentStatus", "");
echo "Pls Click the Patient's Name to view his/her Laboratories..";

Example #5

File: radioReport_edit.php Project: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$reports = $_POST['reports'];
$itemNo = $_POST['itemNo'];
$registrationNo = $_POST['registrationNo'];
$description = $_POST['description'];
$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>";

Example #6

File: resultList.php Project: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$username = $_GET['username'];
$registrationNo = $_GET['registrationNo'];
$chargesCode = $_GET['chargesCode'];
$itemNo = $_GET['itemNo'];
$ro = new database1();
$ro->getLabFormList($username, $registrationNo, $itemNo, $chargesCode);

Example #7

File: addPackage1.php Project: rickyx12/protacio

<?php

include "../../myDatabase1.php";
$packageName = $_GET['packageName'];
$packagePrice = $_GET['packagePrice'];
$phicPrice = $_GET['phicPrice'];
$ro = new database1();
if ($packageName == "") {
    $ro->getBack("Pls Type the Package Name");
} else {
    if ($packagePrice == "") {
        $ro->getBack("Pls Type the Package Price");
    } else {
        echo "\n\n<frameset cols='150%,150%' framespacing='0' border='1'>\n   <frame src='http://" . $ro->getMyUrl() . "/COCONUT/hospitalPackage/searchCharges.php?packageName={$packageName}&packagePrice={$packagePrice}&phicPrice={$phicPrice}'  scrolling=no frameborder=1 framespacing=1 name='selection' />\n   <frame src='http://" . $ro->getMyUrl() . "/COCONUT/hospitalPackage/showAddedPackage_update.php?packageName={$packageName}' />\n\n</frameset>\n\n\n";
    }
}

Example #8

File: applyPackage_oct_4_2012.php Project: 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";

Example #9

File: selectOption.php Project: rickyx12/protacio

<?php

include "../../myDatabase1.php";
$username = $_GET['username'];
$ro = new database1();
$ro->coconutDesign();
echo "<br><br><Br>";
$ro->coconutFormStart("get", "cashCollection.php");
$ro->coconutHidden("username", $username);
$ro->coconutBoxStart("400", "115");
echo "<br>";
echo "<table border=0>";
echo "<tr>";
echo "<td>Date&nbsp;</td>";
echo "<td>";
$ro->coconutComboBoxStart_short("month");
echo "<option value='" . date("M") . "'>" . date("M") . "</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;";

Example #10

File: monthlyChart_front.php Project: rickyx12/protacio

<?php

include "../../myDatabase1.php";
$description = $_GET['description'];
$chargesCode = $_GET['chargesCode'];
$ro = new database1();
$ro->coconutDesign();
echo "<Br><Br><Br>";
$ro->coconutFormStart("post", "http://" . $ro->getMyUrl() . "/COCONUT/graphicalReport/bestSelling/fastMovingChart.php");
$ro->coconutHidden("description", $description);
$ro->coconutHidden("chargesCode", $chargesCode);
$ro->coconutBoxStart("500", "119");
echo "<br>";
echo "<table border=0>";
echo "<tr>";
echo "<Td>Month&nbsp;</tD>";
echo "<td>";
$ro->coconutComboBoxStart_short("month");
echo "<option value='" . date("m") . "'>" . date("M") . "</option>";
echo "<option value='01'>Jan</option>";
echo "<option value='02'>Feb</option>";
echo "<option value='03'>Mar</option>";
echo "<option value='04'>Apr</option>";
echo "<option value='05'>May</option>";
echo "<option value='06'>Jun</option>";
echo "<option value='07'>Jul</option>";
echo "<option value='08'>Aug</option>";
echo "<option value='09'>Sep</option>";
echo "<option value='10'>Oct</option>";
echo "<option value='11'>Nov</option>";
echo "<option value='12'>Dec</option>";

Example #11

File: annualGenderCensus.php Project: rickyx12/protacio

 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 * 
 */
/**
 * Multiple line chart demonstration.
 *
 */
include "../../../COCONUT/libchart/libchart/classes/libchart.php";
$chart = new LineChart("1500", "500");
$ro = new database1();
$serie1 = new XYDataSet();
$serie1->addPoint(new Point("Jan {$year}", $ro->getGenderAnnual("01", $year, "male", "OPD")));
$serie1->addPoint(new Point("Feb {$year}", $ro->getGenderAnnual("02", $year, "male", "OPD")));
$serie1->addPoint(new Point("Mar {$year}", $ro->getGenderAnnual("03", $year, "male", "OPD")));
$serie1->addPoint(new Point("Apr {$year}", $ro->getGenderAnnual("04", $year, "male", "OPD")));
$serie1->addPoint(new Point("May {$year}", $ro->getGenderAnnual("05", $year, "male", "OPD")));
$serie1->addPoint(new Point("Jun {$year}", $ro->getGenderAnnual("06", $year, "male", "OPD")));
$serie1->addPoint(new Point("Jul {$year}", $ro->getGenderAnnual("07", $year, "male", "OPD")));
$serie1->addPoint(new Point("Aug {$year}", $ro->getGenderAnnual("08", $year, "male", "OPD")));
$serie1->addPoint(new Point("Sep {$year}", $ro->getGenderAnnual("09", $year, "male", "OPD")));
$serie1->addPoint(new Point("Oct {$year}", $ro->getGenderAnnual("10", $year, "male", "OPD")));
$serie1->addPoint(new Point("Nov {$year}", $ro->getGenderAnnual("11", $year, "male", "OPD")));
$serie1->addPoint(new Point("Dec {$year}", $ro->getGenderAnnual("12", $year, "male", "OPD")));
$serie2 = new XYDataSet();
$serie2->addPoint(new Point("Jan {$year}", $ro->getGenderAnnual("01", $year, "female", "OPD")));

Example #12

File: addSupplier1.php Project: rickyx12/protacio

<?php

include "../myDatabase1.php";
$supplierName = $_GET['supplierName'];
$address = $_GET['address'];
$contactPerson = $_GET['contactPerson'];
$contactNo = $_GET['contactNo'];
$description = $_GET['description'];
$ro = new database1();
$ro->addSupplier($supplierName, $address, $contactPerson, $contactNo, $description);

Example #13

File: revenuePie_dec5.php Project: rickyx12/protacio

 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 * 
 */
/**
 * Pie chart demonstration
 *
 */
include "../../../COCONUT/libchart/libchart/classes/libchart.php";
$chart = new PieChart();
$ro = new database1();
$dataSet = new XYDataSet();
$dataSet->addPoint(new Point("OPD (" . number_format($ro->getPxRevenueDaily_opd($fromMonth, $fromDay, $fromYear), 2) . ")", $ro->getPxRevenueDaily_opd($fromMonth, $fromDay, $fromYear)));
$dataSet->addPoint(new Point("IPD (" . number_format($ro->getPxRevenueDaily_ipd($fromMonth, $fromDay, $fromYear), 2) . ")", $ro->getPxRevenueDaily_ipd($fromMonth, $fromDay, $fromYear)));
$chart->setDataSet($dataSet);
$chart->setTitle("Collection Report For {$fromMonth} {$fromDay}, {$fromYear} ");
$chart->render("../../../COCONUT/graphicalReport/chartList/dailyRevenue.png");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title></title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />
</head>
<body>
	<img alt="Pie chart"  src="/COCONUT/graphicalReport/chartList/dailyRevenue.png" style="border: 1px solid gray;"/>

Example #14

File: annualRevenue.php Project: rickyx12/protacio

 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 * 
 */
/**
 * Multiple line chart demonstration.
 *
 */
include "../../../COCONUT/libchart/libchart/classes/libchart.php";
$chart = new revenueLineChart("1500", "500");
$ro = new database1();
$serie1 = new XYDataSet();
$serie1->addPoint(new Point("Jan {$year}", $ro->getAnnualRevenue_opd("01", $year)));
$serie1->addPoint(new Point("Feb {$year}", $ro->getAnnualRevenue_opd("02", $year)));
$serie1->addPoint(new Point("Mar {$year}", $ro->getAnnualRevenue_opd("03", $year)));
$serie1->addPoint(new Point("Apr {$year}", $ro->getAnnualRevenue_opd("04", $year)));
$serie1->addPoint(new Point("May {$year}", $ro->getAnnualRevenue_opd("05", $year)));
$serie1->addPoint(new Point("Jun {$year}", $ro->getAnnualRevenue_opd("06", $year)));
$serie1->addPoint(new Point("Jul {$year}", $ro->getAnnualRevenue_opd("07", $year)));
$serie1->addPoint(new Point("Aug {$year}", $ro->getAnnualRevenue_opd("08", $year)));
$serie1->addPoint(new Point("Sep {$year}", $ro->getAnnualRevenue_opd("09", $year)));
$serie1->addPoint(new Point("Oct {$year}", $ro->getAnnualRevenue_opd("10", $year)));
$serie1->addPoint(new Point("Nov {$year}", $ro->getAnnualRevenue_opd("11", $year)));
$serie1->addPoint(new Point("Dec {$year}", $ro->getAnnualRevenue_opd("12", $year)));
$serie2 = new XYDataSet();
$serie2->addPoint(new Point("Jan {$year}", $ro->getAnnualRevenue_ipd("01", $year)));

Example #15

File: addVoucher1.php Project: rickyx12/mendero

<?php

include "../../../myDatabase1.php";
$voucherNo = $_GET['voucherNo'];
$paymentMode = $_GET['paymentMode'];
$description = $_GET['description'];
$amount = $_GET['amount'];
$payee = $_GET['payee'];
$payee1 = $_GET['payee1'];
$dateIssued = $_GET['dateIssued'];
$timeIssued = $_GET['timeIssued'];
$accountTitle = $_GET['accountTitle'];
$userz = $_GET['username'];
$ro = new database1();
if ($payee != "") {
    $ro->addVoucher($voucherNo, $paymentMode, $description, $amount, $payee, $dateIssued, $timeIssued, $accountTitle, $userz);
} else {
    $ro->addVoucher($voucherNo, $paymentMode, $description, $amount, $payee1, $dateIssued, $timeIssued, $accountTitle, $userz);
}

Example #16

File: bestSellingChart.php Project: rickyx12/protacio

 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 * 
 */
/**
 * Multiple horizontal bar chart demonstration.
 *
 */
include "../../../COCONUT/libchart/libchart/classes/libchart.php";
$chart = new hundredsBarChart(4000, 1500);
$ro = new database1();
$serie1 = new XYDataSet();
$serie1->addPoint(new Point("{$month} 31", number_format($ro->getBestSellingChart_opd($month, "31", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 30", number_format($ro->getBestSellingChart_opd($month, "30", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 29", number_format($ro->getBestSellingChart_opd($month, "29", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 28", number_format($ro->getBestSellingChart_opd($month, "28", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 27", number_format($ro->getBestSellingChart_opd($month, "27", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 26", number_format($ro->getBestSellingChart_opd($month, "26", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 25", number_format($ro->getBestSellingChart_opd($month, "25", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 24", number_format($ro->getBestSellingChart_opd($month, "24", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 23", number_format($ro->getBestSellingChart_opd($month, "23", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 22", number_format($ro->getBestSellingChart_opd($month, "22", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 21", number_format($ro->getBestSellingChart_opd($month, "21", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 20", number_format($ro->getBestSellingChart_opd($month, "20", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 19", number_format($ro->getBestSellingChart_opd($month, "19", $year, $description) / 100, 2)));
$serie1->addPoint(new Point("{$month} 18", number_format($ro->getBestSellingChart_opd($month, "18", $year, $description) / 100, 2)));

Example #17

File: monthlyRevenue.php Project: rickyx12/protacio

 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 * 
 */
/**
 * Multiple horizontal bar chart demonstration.
 *
 */
include "../../../COCONUT/libchart/libchart/classes/libchart.php";
$chart = new VerticalBarChart(8000, 600);
$ro = new database1();
$serie1 = new XYDataSet();
$serie1->addPoint(new Point("{$month} 1, {$year}", number_format($ro->getPxRevenueDaily_opd($month, "01", $year), 2)));
$serie1->addPoint(new Point("{$month} 2, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "02", $year), 2)));
$serie1->addPoint(new Point("{$month} 3, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "03", $year), 2)));
$serie1->addPoint(new Point("{$month} 4, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "04", $year), 2)));
$serie1->addPoint(new Point("{$month} 5, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "05", $year), 2)));
$serie1->addPoint(new Point("{$month} 6, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "06", $year), 2)));
$serie1->addPoint(new Point("{$month} 7, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "07", $year), 2)));
$serie1->addPoint(new Point("{$month} 8, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "08", $year), 2)));
$serie1->addPoint(new Point("{$month} 9, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "09", $year), 2)));
$serie1->addPoint(new Point("{$month} 10, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "10", $year), 2)));
$serie1->addPoint(new Point("{$month} 11, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "11", $year), 2)));
$serie1->addPoint(new Point("{$month} 12, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "12", $year), 2)));
$serie1->addPoint(new Point("{$month} 13, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "13", $year), 2)));
$serie1->addPoint(new Point("{$month} 14, {$year} ", number_format($ro->getPxRevenueDaily_opd($month, "14", $year), 2)));

Example #18

File: showPaid.php Project: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->voidOPD_payment($registrationNo, $username);

Example #19

File: addResultForm.php Project: rickyx12/mendero

<?php

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

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

<?php 
echo "<textarea id='formTemplate' name='formTemplate'></textarea>";
$ro->coconutFormStop();
?>

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

</script>

Example #20

File: radioReportSettings.php Project: 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>";

Example #21

File: cashCollection.php Project: rickyx12/protacio

<?php

include "../../myDatabase1.php";
$username = $_GET['username'];
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$dept = $_GET['dept'];
$ro = new database1();
echo "<br>";
echo "<Center>";
$ro->coconutTableStart();
$ro->coconutTableRowStart();
$ro->coconutTableHeader("Patient");
$ro->coconutTableHeader("Description");
$ro->coconutTableHeader("Balance");
$ro->coconutTableHeader("PhilHealth");
$ro->coconutTableHeader("Company");
$ro->coconutTableRowStop();
$ro->getCollectionPerDept($username, $month, $day, $year, $dept);
$ro->getCollectionPerDept1($username, $month, $day, $year, $dept);
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Total</b>");
$ro->coconutTableData("");
$ro->coconutTableData(number_format($ro->getCollectionPerDept_total, 2));
$ro->coconutTableData(number_format($ro->getCollectionPerDept_phic, 2));
$ro->coconutTableData(number_format($ro->getCollectionPerDept_company, 2));
$ro->coconutTableRowStop();
$ro->coconutTableStop();

Example #22

File: monthlyRegistrationCensus.php Project: rickyx12/protacio

 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 * 
 */
/**
 * Multiple horizontal bar chart demonstration.
 *
 */
include "../../../COCONUT/libchart/libchart/classes/libchart.php";
$chart = new VerticalBarChart(4000, 500);
$ro = new database1();
$serie1 = new XYDataSet();
$serie1->addPoint(new Point("{$month} 1, {$year}", $ro->getPxCensusMonth($month, "01", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 2, {$year} ", $ro->getPxCensusMonth($month, "02", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 3, {$year} ", $ro->getPxCensusMonth($month, "03", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 4, {$year} ", $ro->getPxCensusMonth($month, "04", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 5, {$year} ", $ro->getPxCensusMonth($month, "05", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 6, {$year} ", $ro->getPxCensusMonth($month, "06", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 7, {$year} ", $ro->getPxCensusMonth($month, "07", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 8, {$year} ", $ro->getPxCensusMonth($month, "08", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 9, {$year} ", $ro->getPxCensusMonth($month, "09", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 10, {$year} ", $ro->getPxCensusMonth($month, "10", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 11, {$year} ", $ro->getPxCensusMonth($month, "11", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 12, {$year} ", $ro->getPxCensusMonth($month, "12", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 13, {$year} ", $ro->getPxCensusMonth($month, "13", $year, "OPD")));
$serie1->addPoint(new Point("{$month} 14, {$year} ", $ro->getPxCensusMonth($month, "14", $year, "OPD")));

Example #23

File: unknownPatient.php Project: rickyx12/mendero

<?php

include "../../myDatabase1.php";
$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" />

Example #24

File: phicQTY.php Project: rickyx12/mendero

$registrationNo = $_GET['registrationNo'];
$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>";

Example #25

File: patientProfile_left_oct_4_2012.php Project: 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 "";
}

Example #26

File: byBatch1.php Project: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$dispensedNo = $_GET['dispensedNo'];
$ro = new database1();
$ro->getPatientProfile($registrationNo);
echo "<center><b><font size=4>" . $ro->getReportInformation("hmoSOA_name") . "</font></b></center>";
echo "<center><b><font size=2>" . $ro->getReportInformation("hmoSOA_address") . "</font></b></center>";
echo "<center><font size=2>Tel No. (062) 2143237</font></center>";
echo "<br>";
echo "Reg#:&nbsp;" . $registrationNo . "&nbsp;&nbsp;&nbsp;&nbsp;Batch#:&nbsp;" . $dispensedNo;
echo "<br>";
echo "Name:&nbsp;" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName();
echo "<br>";
echo "Date Print:&nbsp;" . date("M d, Y");
echo "<br>";
echo "PhilHealth:&nbsp;" . $ro->getPatientRecord_phic();
echo "<br><br>";
$ro->getBatchMeds($registrationNo, $dispensedNo);

Example #27

File: manualSearch1.php Project: rickyx12/protacio

<?php

include "../../myDatabase1.php";
$patientName = $_GET['patientName'];
$username = $_GET['username'];
$ro = new database1();
$ro->searchRecord($patientName, $username);

Example #28

File: readyTransmit.php Project: rickyx12/protacio

<?php

include "../../myDatabase1.php";
$regNo = $_GET['regNo'];
$countz = count($regNo);
$ro = new database1();
for ($x = 0; $x < $countz; $x++) {
    $ro->phicTransmit($regNo[$x]);
}

Example #29

File: deleteHospital1.php Project: rickyx12/protacio

<?php

include "../../../myDatabase1.php";
$headingNo = $_GET['headingNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->deleteNow("radioHeading", "headingNo", $headingNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Results/Radiology/radioHeadingMasterfile.php?username={$username}");

Example #30

File: radioReport_insert.php Project: 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) . "");