PHP database2::getRegistrationDetails_company 예제들

예제 #1

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

echo "<tr>";
echo "<td><font class='labelz'><b>Name:</b></font></td><td><font size=2>" . $ro->getPatientRecord_completeName() . "</font></td>";
echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>";
echo "<Td><font class='labelz'><b>Registration#:</b></font></td>";
echo "<td><font size=2>" . $ro->getRegistrationDetails_registrationNo() . "</td>";
echo "</tr>";
echo "<tr>";
echo "<Td><font class='labelz'><B>Age:</b></td>";
echo "<Td><font size=2>" . $ro->getPatientRecord_age() . " yrs Old</font></td>";
echo "<Td>&nbsp;</td>";
echo "<td><font class='labelz'><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Senior:</b></font></td>";
echo "<td><font size=2>" . $ro->getPatientRecord_senior() . "</font></td>";
echo "</tr>";
echo "<tr>";
echo "<Td><font class='labelz'><b>Company:</b></font></td>";
echo "<td><font size=2>" . $ro->getRegistrationDetails_company() . "</font></tD>";
echo "<td><font class='labelz'>Diagnosis:</font></td>";
echo "<tD><font class='labelz'>" . $ro->soap_assessmentz() . " &nbsp;&nbsp; " . $ro->selectNow("registrationDetails", "finalDiagnosis", "registrationNo", $registrationNo) . "</font></tD>";
echo "</tr>";
echo "</table>";
echo "<hr>";
echo "<Table border=0 cellpadding=0 cellspacing=0>";
echo "<tr>";
echo "<th>&nbsp;<font class='heading'><b>DATE</b></font>&nbsp;</th>";
//echo  "<th>&nbsp;<font class='heading'><b>Ref#</b></font>&nbsp;</th>";
echo "<th width='30%'>&nbsp;<font class='heading'><b>Particulars</b></font>&nbsp;</th>";
echo "<th>&nbsp;<font class='heading'><b>QTY</b></font>&nbsp;</th>";
echo "<th>&nbsp;<font class='heading'><b>Price</b></font>&nbsp;</th>";
echo "<th>&nbsp;<font class='heading'><b>Charges</b></font>&nbsp;</th>";
echo "<th>&nbsp;<font class='heading'><b>Credit</b></font>&nbsp;</th>";
echo "<th>&nbsp;<font class='heading'><b>Bal</b></font>&nbsp;</th>";

예제 #2

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

echo "<td>&nbsp;Room:&nbsp;" . $room1[0] . " </td>";
echo "</tr>";
echo "<tr>";
echo "<td>Name:&nbsp;</td><td>&nbsp;<a href='#' onClick='printF(printData)' style='text-decoration:none; color:black;'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</a></td>";
echo "<td align='right'>&nbsp;&nbsp;" . $ro->coconutText("Physician") . " : </td><td>&nbsp;" . $ro->getAttendingDoc($registrationNo, "Attending") . "</td>";
echo "<td>&nbsp;Case: " . $ro->selectNow("registrationDetails", "privateORhouse_case", "registrationNo", $registrationNo) . "</td>";
echo "</tr>";
echo "<tr>";
echo "<Td>" . $ro->coconutText("Admitted") . ":&nbsp;</td><td>&nbsp;" . $ro->getRegistrationDetails_dateRegistered() . "@" . $ro->getRegistrationDetails_timeRegistered() . "</td>";
//echo "<td>CaseType:</td><TD>".$ro->getRegistrationDetails_caseType()."</tD>";
echo "<Td align='right'>&nbsp;&nbsp;" . $ro->coconutText("Discharged") . ":&nbsp;</td><td>&nbsp;" . $ro->getRegistrationDetails_dateUnregistered() . "@" . $ro->getRegistrationDetails_timeUnregistered() . "</td>";
echo "</tr>";
if ($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) != "") {
    $hmoLimit = number_format($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo), 2);
} else {
    if ($ro->selectNow("Company", "type", "companyName", $ro->getRegistrationDetails_company()) == "insurance") {
        //check kung insurance..
        $hmoLimit = number_format(2000, 2);
    } else {
        $hmoLimit = "";
    }
}
if ($ro->selectNow("registrationDetails", "company", "registrationNo", $registrationNo) != "") {
    echo "<tr>";
    echo "<td>Company:</td>";
    echo "<td>" . $ro->getRegistrationDetails_company() . " - {$hmoLimit} </td>";
    echo "<td>&nbsp;</td>";
    echo "<td></td>";
    echo "<td></td>";
    echo "</tr>";
} else {

예제 #3

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

    echo "";
} else {
    echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Admission#:</font>&nbsp;<font color='blue'>" . $ro->selectNow("registrationDetails", "manual_registrationNo", "registrationNo", $ro->getRegistrationDetails_registrationNo()) . "</font>";
}
//echo "<br><font class='informationLabel'>System#:</font>&nbsp;".$ro->getRegistrationDetails_patientNo();
//echo "<br><font class='informationLabel'>Registration#:</font>&nbsp;".$ro->getRegistrationDetails_registrationNo();
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Age:</font>&nbsp;" . $ro->getPatientRecord_age();
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Gender:</font>&nbsp;" . $ro->getPatientRecord_gender();
//echo "<br><font class='informationLabel'>Civil Status:</font>&nbsp;".$ro->getPatientRecord_civilStatus();
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Birth Date:</font>&nbsp;" . $ro4->formatDate($ro->getPatientRecord_Birthdate());
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Contact No#:</font>&nbsp;" . $ro->getPatientRecord_contactNo();
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Senior:</font>&nbsp;" . $ro->getPatientRecord_senior();
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Senior ID#:</font>&nbsp;" . $ro->selectNow("registrationDetails", "seniorID", "registrationNo", $registrationNo);
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>PhilHealth:</font>&nbsp;" . $ro->getPatientRecord_phic() . " <a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/phicPayment_selection.php?registrationNo={$registrationNo}&username={$username}' style='text-decoration:none;'><font color='red' size=2>[Payment]</font></a>";
//echo "<br><font class='informationLabel'>Religion:</font>&nbsp;".$ro->getPHICtype_patientRecord();
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Company:</font>&nbsp;" . $ro->getRegistrationDetails_company() . " <a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/companyPayment_selection.php?registrationNo={$registrationNo}&username={$username}' style='text-decoration:none;'><font color='red' size=2>[Payment]</font></a>";
if ($ro->selectNow("registrationDetails", "company1", "registrationNo", $registrationNo) != "") {
    echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Company1:</font>&nbsp;" . $ro->selectNow("registrationDetails", "company1", "registrationNo", $registrationNo);
} else {
}
if ($ro->selectNow("registrationDetails", "company2", "registrationNo", $registrationNo) != "") {
    echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Company2:</font>&nbsp;" . $ro->selectNow("registrationDetails", "company2", "registrationNo", $registrationNo);
} else {
}
//echo "<br><font class='informationLabel'>Mother's Name:</font>&nbsp;".$ro->selectNow("patientRecord","mothersName","patientNo",$ro->getRegistrationDetails_patientNo());
//echo "<br><font class='informationLabel'>Father's Name:</font>&nbsp;".$ro->selectNow("patientRecord","fathersName","patientNo",$ro->getRegistrationDetails_patientNo());
if ($ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo) == "OPD") {
    echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Time Registered:</font>&nbsp;" . $ro4->formatTime($ro->getRegistrationDetails_timeRegistered());
    echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Date Registered:</font>&nbsp;" . $ro4->formatDate($ro->getRegistrationDetails_dateRegistered());
} else {
    echo "<br><font class='informationLabel'>Time Registered:</font>&nbsp;" . $ro4->formatTime($ro->getRegistrationDetails_timeRegistered());

예제 #4

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

echo "<td>&nbsp;<b>" . number_format($gross - $ro->getRegistrationDetails_discount() + $pf_cash, 2) . "</b>&nbsp;</tD>";
echo "</tr>";
$grandTotalz = $gross - $ro->getRegistrationDetails_discount() + $pf_cash;
//$ro->getPaymentHistory_showUp_returnPaid_setter($registrationNo);
//$netTotal = (  ( ($gross - $ro->getRegistrationDetails_discount()   ) - $ro->getPaymentHistory_showUp_returnPaid() ) -  $ro->sumPartial($registrationNo) );
//if( $netTotal < 0 ) $netTotal=0;
//echo "<Tr>";
//echo "<td>&nbsp;<b>Payment's</b></tD>";
//echo "<td>&nbsp;</tD>";
//echo "<td>&nbsp;</tD>";
//echo "<td>&nbsp;</tD>";
//echo "<td>&nbsp;<b>".number_format( $ro->getPaymentHistory_showUp_returnPaid() ,2)."</b>&nbsp;</tD>";
//echo "</tr>";
//$paidz1 = (( $ro->sumPartial_new($registrationNo,"amountPaid") + $ro->sumPartial_new($registrationNo,"pf")) + $ro->sumPartial_new($registrationNo,"admitting") );
$ro->descPartialPayment($registrationNo, $username);
$ro->getCompanyPayment($registrationNo, $ro->getRegistrationDetails_company());
$ro->getPHICPayment($registrationNo);
echo "<Tr>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
//echo "<td>&nbsp;<b>".number_format( $ro->sumPartial_new($registrationNo) ,2)."</b>&nbsp;</tD>";
echo "</tr>";
$refund = $ro->doubleSelectNow("patientPayment", "amountPaid", "registrationNo", $registrationNo, "paymentFor", "REFUND");
echo "<tr>";
echo "<Td>&nbsp;<b>REFUND</b></td>";
echo "<TD></tD>";
echo "<td></td>";
echo "<td></td>";

예제 #5

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

    // enable room
    echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=Room And Board&username={$username}&show=&desc=' target='rightFrame'><font size=2>Room</font></a></li>";
} else {
    //disable room
    echo "";
}
echo "</ul>";
echo "<ul>";
/////////// LOCKED ACCOUNT KAPAG CONSUMED NA UNG LIMIT ////////////////////////
if ($ro->selectNow("registrationDetails", "mgh", "registrationNo", $registrationNo) == "") {
    // enable charges kung hindi pa MGH
    if ($ro->getRegistrationDetails_type() == "OR/DR" || $ro->getRegistrationDetails_type() == "OPD") {
        echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/chargesCartPassword.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "&username={$username}&room=" . $ro->getRegistrationDetails_room() . "&batchNo={$batchNo}' target='rightFrame'><font size=2>Charges Cart</font></a></li>";
    } else {
        $totalBalanceNow = $ro->getTotal("cashUnpaid", "", $registrationNo) - $ro->getAllPayment($registrationNo);
        if ($ro->getRegistrationDetails_company() != "") {
            //kpg may hmo
            if ($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) != "") {
                //meron hmo limit
                if ($totalBalanceNow >= $ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo)) {
                    //mas mataas n ung total balance kaysa sa hmo limit
                    if ($ro->selectNow("registeredUser", "module", "username", $username) == "PHARMACY" || $ro->selectNow("registeredUser", "module", "username", $username) == "CASHIER") {
                        //kpg pharmacy or cashier pwede mag charge
                        echo "<li>" . $ro->coconutImages_return("locked1.jpeg") . "<a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/chargesCartPassword.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "&username={$username}&room=" . $ro->getRegistrationDetails_room() . "&batchNo={$batchNo}' target='rightFrame'><font size=2 color=red>Charges Cart</font></a></li>";
                    } else {
                        if ($ro->checkPermission($registrationNo) != "") {
                            echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/chargesCartPassword.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "&username={$username}&room=" . $ro->getRegistrationDetails_room() . "&batchNo={$batchNo}' target='rightFrame'><font size=2>Charges Cart</font></a></li>";
                        } else {
                            //kpg ndi pharmacy or cashier ndi pde mag charge
                            echo $ro->coconutImages_return("locked1.jpeg") . "<font size=2 color=blue>[LOCKED ACCOUNT]</font><br><font size=2 color=red>" . $ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) . " Limit of " . $ro->getRegistrationDetails_company() . " for this Patient is Already Consumed</font>";
                        }

예제 #6

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

if ($ro->selectNow("registrationDetails", "verified", "registrationNo", $registrationNo) != "" && $ro->selectNow("registrationDetails", "certified", "registrationNo", $registrationNo) == "") {
    echo "<img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/verified.jpeg'>";
} else {
    if ($ro->selectNow("registrationDetails", "verified", "registrationNo", $registrationNo) == "" && $ro->selectNow("registrationDetails", "certified", "registrationNo", $registrationNo) != "") {
        echo "<img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/certified.jpeg'>";
    } else {
        if ($ro->selectNow("registrationDetails", "verified", "registrationNo", $registrationNo) != "" && $ro->selectNow("registrationDetails", "certified", "registrationNo", $registrationNo) != "") {
            echo "<img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/verified.jpeg'>";
            echo "&nbsp;&nbsp;&nbsp;&nbsp;";
            echo "<img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/certified.jpeg'>";
        } else {
            echo "";
        }
    }
}
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'>Diet</font>&nbsp;" . $ro->selectNow("dietList", "dietName", "dietNo", $ro->selectNow("registrationDetails", "diet", "registrationNo", $registrationNo));
//selectNow($table,$cols,$identifier,$identifierData)
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("nbs", "motherRegistrationNo", "motherRegistrationNo", $registrationNo) != "") {
    echo "<br>" . $ro->coconutImages_return("mother.jpeg");
    $ro->getBabies($registrationNo);
    echo "<br><a href='/COCONUT/patientProfile/nbs/searchBaby.php?registrationNo={$registrationNo}&username={$username}' style='text-decoration:none;'><font class='informationLabel' color=red>[+1 Baby]</font></a>&nbsp;";
} else {
    if ($ro->selectNow("nbs", "motherRegistrationNo", "babyRegistrationNo", $registrationNo) != "") {

예제 #7

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

echo "<tr>";
echo "<td>Tax</td>";
echo "<td>";
$ro->coconutTextBox_short("tax", "");
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>Discount</td>";
echo "<td>";
$ro->coconutTextBox_short("discount", "");
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>Company</td>";
echo "<td>";
$ro->coconutTextBox_readonly("company", $ro->getRegistrationDetails_company());
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>Date</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>";

예제 #8

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

include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$dateCharge = $_GET['dateCharge'];
$ro = new database2();
$ro->getPatientProfile($registrationNo);
echo "<Br>";
echo "<table border=0 width='70%'>";
echo "<Tr>";
echo "<td><b>Patient ID:</b>&nbsp;" . $ro->getRegistrationDetails_patientNo() . "</td>";
echo "<TD><b>Registration#:</b>&nbsp;{$registrationNo}</tD>";
echo "</tr>";
echo "<Tr>";
echo "<td><b>Patients Name:</b>&nbsp;" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "</td>";
echo "<td><b>Age:</b>&nbsp;" . $ro->getPatientRecord_Age() . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>D.O.B:</b>&nbsp;" . $ro->getPatientRecord_birthDate() . "</td>";
echo "<tD><b>Sex:</b>&nbsp;" . $ro->getPatientRecord_Gender() . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>Physician:</b>&nbsp;" . $ro->getAttendingDoc($registrationNo, "ATTENDING") . "</td>";
echo "<td><b>Room:</b>&nbsp;" . $ro->getRegistrationDetails_room() . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>Company</b>&nbsp;" . $ro->getRegistrationDetails_company() . "</td>";
echo "<td></td>";
echo "</tr>";
echo "</table>";
echo "<br>";
$ro->printLabRequest($registrationNo, $dateCharge);

예제 #9

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

echo "<td>&nbsp;<span class='txtSize'>Room:</span>&nbsp;<span class='txtSize'>" . $room1[0] . "</span></td>";
echo "</tr>";
echo "<tr>";
echo "<td><span class='txtSize'>Name:</span>&nbsp;</td><td>&nbsp;<a href='#' style='text-decoration:none; font-size:12px; color:black;'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</a></td>";
echo "<td align='left'>&nbsp;&nbsp;<span class='txtSize'>Physician:</span> </td><td>&nbsp;<span class='txtSize'>" . $ro->getAttendingDoc($registrationNo, "Attending") . "</span></td>";
echo "<td>&nbsp;<span class='txtSize'>Case:" . $ro->selectNow("registrationDetails", "privateORhouse_case", "registrationNo", $registrationNo) . "</span></td>";
echo "</tr>";
echo "<tr>";
echo "<Td><span class='txtSize'>Admitted:</span>&nbsp;</td><td>&nbsp;<span class='txtSize'>" . $ro->getRegistrationDetails_dateRegistered() . "@" . $ro->getRegistrationDetails_timeRegistered() . "</span></td>";
//echo "<td>CaseType:</td><TD>".$ro->getRegistrationDetails_caseType()."</tD>";
echo "<Td align='left'>&nbsp;&nbsp;<span class='txtSize'>Discharged:</span>&nbsp;</td><td>&nbsp;<span class='txtSize'>" . $ro->getRegistrationDetails_dateUnregistered() . "@" . $ro->getRegistrationDetails_timeUnregistered() . "</span></td>";
echo "</tr>";
if ($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) != "") {
    $hmoLimit = number_format($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo), 2);
} else {
    if ($ro->selectNow("Company", "type", "companyName", $ro->getRegistrationDetails_company()) == "insurance") {
        //check kung insurance..
        $hmoLimit = number_format(2000, 2);
    } else {
        $hmoLimit = "";
    }
}
if ($ro->selectNow("registrationDetails", "company", "registrationNo", $registrationNo) != "") {
    echo "<tr>";
    echo "<td><span class='txtSize'>Company:</span></td>";
    echo "<td><span class='txtSize'>" . $ro->getRegistrationDetails_company() . " - {$hmoLimit}</span> </td>";
    echo "<td>&nbsp;</td>";
    echo "<td></td>";
    echo "<td></td>";
    echo "</tr>";
} else {