PHP database2::coconutTableData示例

示例#1

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

echo "<center>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/individualPayment/paidItems.php");
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("username", $username);
$ro->coconutTableStart();
$ro->coconutTableRowStart();
$ro->coconutTableHeader("");
$ro->coconutTableHeader("Description");
$ro->coconutTableHeader("QTY;");
$ro->coconutTableHeader("Price");
$ro->coconutTableHeader("Discount");
$ro->coconutTableHeader("Total");
$ro->coconutTableRowStop();
for ($x = 0; $x < $countz; $x++) {
    $ro->coconutTableRowStart();
    $ro->coconutTableData("<input type='checkbox' name='itemNo[]' value='" . $itemNo[$x] . "' checked>");
    $ro->coconutTableData($ro->doubleSelectNow("patientCharges", "description", "itemNo", $itemNo[$x], "registrationNo", $registrationNo));
    $ro->coconutTableData($ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo[$x], "registrationNo", $registrationNo));
    $ro->coconutTableData($ro->doubleSelectNow("patientCharges", "sellingPrice", "itemNo", $itemNo[$x], "registrationNo", $registrationNo));
    $ro->coconutTableData($ro->doubleSelectNow("patientCharges", "discount", "itemNo", $itemNo[$x], "registrationNo", $registrationNo));
    $ro->coconutTableData($ro->doubleSelectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo[$x], "registrationNo", $registrationNo));
    $discount += $ro->doubleSelectNow("patientCharges", "discount", "itemNo", $itemNo[$x], "registrationNo", $registrationNo);
    $total += $ro->doubleSelectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo[$x], "registrationNo", $registrationNo);
    $ro->coconutTableRowStop();
}
$ro->coconutTableRowStart();
$ro->coconutTableData("&nbsp;");
$ro->coconutTableData("&nbsp;<b>PHARMACY</b>");
$ro->coconutTableData("&nbsp;");
$ro->coconutTableData("&nbsp;");
$ro->coconutTableData("&nbsp;");

示例#2

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

echo "<th>Date</th>";
echo "<th>Examinations</th>";
echo "<th>Total</th>";
echo "<th>Rebate</th>";

$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->getPxNameByAttendingDoctor($doctorCode,$date,$date1,"IPD");
$ro->coconutTableRowStop();
$ro->coconutTableStop();
*/
echo "OPD Patients";
$ro->coconutTableStart();
$ro->coconutTableRowStart();
echo "<th>Patient</th>";
echo "<th>Date</th>";
echo "<th>Examinations</th>";
echo "<th>Total</th>";
echo "<th>Rebate</th>";
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->getPxNameByAttendingDoctor($doctorCode, $date, $date1, "OPD", $title);
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Total</b>");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("&nbsp;" . number_format($ro->getPxChargesByHorizontal_grandTotal(), 2));
$ro->coconutTableData("&nbsp;" . number_format($ro->getPxNameBasedOnDateCharged_rebateTotal(), 2));
$ro->coconutTableRowStop();
$ro->coconutTableStop();

示例#3

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

$ro->coconutTableStart();
$ro->coconutTableRowStart();
$ro->coconutTableHeader(" ");
$ro->coconutTableHeader("Patient");
$ro->coconutTableHeader("LABORATORY");
$ro->coconutTableHeader("RADIOLOGY");
$ro->coconutTableHeader("MEDICINE");
$ro->coconutTableHeader("SUPPLIES");
$ro->coconutTableHeader("BLOODBANK");
$ro->coconutTableHeader("NBS");
$ro->coconutTableHeader("MISCLLANEOUS");
$ro->coconutTableHeader("NURSING CARE");
$ro->coconutTableHeader("ECG");
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData(" ");
$ro->coconutTableData(" ");
$ro->coconutTableData(" ");
$ro->coconutTableData(" ");
$ro->coconutTableData(" ");
$ro->coconutTableData(" ");
$ro->coconutTableData(" ");
$ro->coconutTableData(" ");
$ro->coconutTableData(" ");
$ro->coconutTableData(" ");
$ro->coconutTableData(" ");
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("&nbsp;<B>Discharged</b>");
$ro->coconutTableData("&nbsp;<font color=red><b>Charge To Bill</b></font>");
$ro->coconutTableData("&nbsp;");

示例#4

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

        }
    }
}
$ro = new database2();
$totalz = 0;
echo "<Center><font size=4><B>{$description}</b></font><br><font size=2>({$monthWord} {$year})</font> <br>";
echo "<Br><font color=red>Consumed by Patient</font>";
$ro->coconutTableStart();
$ro->coconutTableRowStart();
$ro->coconutTableHeader("Date");
$ro->coconutTableHeader("Quantity");
$ro->coconutTableRowStop();
for ($x = 1; $x < 32; $x++) {
    if ($x < 10) {
        $ro->coconutTableRowStart();
        $ro->coconutTableData($monthWord . " {$x}," . $year);
        $ro->coconutTableData($ro->getFastMovingChart($month, "0" . $x, $year, $description, "All", $inventoryCode));
        $totalz += $ro->getFastMovingChart($month, "0" . $x, $year, $description, "All", $inventoryCode);
        $ro->coconutTableRowStop();
    } else {
        $ro->coconutTableRowStart();
        $ro->coconutTableData($monthWord . " {$x}," . $year);
        $ro->coconutTableData($ro->getFastMovingChart($month, $x, $year, $description, "All", $inventoryCode));
        $totalz += $ro->getFastMovingChart($month, $x, $year, $description, "All", $inventoryCode);
        $ro->coconutTableRowStop();
    }
}
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>TOTAL</b>");
$ro->coconutTableData($totalz);
$ro->coconutTableRowStop();

示例#5

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

<?php

include "../../myDatabase2.php";
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$month1 = $_GET['month1'];
$day1 = $_GET['day1'];
$year1 = $_GET['year1'];
$ro = new database2();
echo "<br><Br>";
echo "<center><font size=5>PhilHealth Receivable for PHARMACY</font></center>";
echo "<center><font size=3>( {$month} {$day}, {$year} - {$month1} {$day1}, {$year1} )</font></center>";
echo "<Br>";
echo "<center>";
$ro->coconutTableStart();
$ro->coconutTableRowStart();
$ro->coconutTableHeader("Discharged");
$ro->coconutTableHeader("Patient");
$ro->coconutTableHeader("MEDICINE");
$ro->coconutTableHeader("SUPPLIES");
$ro->coconutTableRowStop();
$ro->discharged_name($month, $day, $year, $month1, $day1, $year1);
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>TOTAL</b>");
$ro->coconutTableData("");
$ro->coconutTableData("&nbsp;<B>" . number_format($ro->discharged_name_medicine(), 2) . "</b>");
$ro->coconutTableData("&nbsp;<B>" . number_format($ro->discharged_name_supplies(), 2) . "</b>");
$ro->coconutTableRowStop();
$ro->coconutTableStop();