PHP database::getRegistrationDetails_patientNo Exemples

Exemple #1

Fichier : editSoap.php Projet : rickyx12/protacio

<?php

include "../../../myDatabase.php";
$itemNo = $_GET['itemNo'];
$registrationNo = $_GET['registrationNo'];
$subjective = $_GET['subjective'];
$objective = $_GET['objective'];
$assessment = $_GET['assessment'];
$plan = $_GET['plan'];
$username = $_GET['username'];
$ro = new database();
$ro->getPatientProfile($registrationNo);
$ro->getSOAP($itemNo, $registrationNo);
$ro->editNow("SOAP", "soapNo", $ro->soap_soapNo(), "subjective", $subjective);
$ro->editNow("SOAP", "soapNo", $ro->soap_soapNo(), "objective", $objective);
$ro->editNow("SOAP", "soapNo", $ro->soap_soapNo(), "assessment", $assessment);
$ro->editNow("SOAP", "soapNo", $ro->soap_soapNo(), "plan", $plan);
$ro->editNow("SOAP", "soapNo", $ro->soap_soapNo(), "patientNo", $ro->getRegistrationDetails_patientNo());
echo "\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/Doctor/doctorModule/soapView.php?itemNo={$itemNo}&registrationNo={$registrationNo}&username={$username}';\n</script>\n\n";

Exemple #2

Fichier : patientProfile_right_homepage.php Projet : rickyx12/protacio

<?php

include "../../myDatabase.php";
$registrationNo = $_GET['registrationNo'];
$ro = new database();
$ro->getPatientProfile($registrationNo);
$ro->setPatientRecord($ro->getRegistrationDetails_patientNo());
echo "\n<style type='text/css'>\n.informationLabel {\nfont-size:15px;\nfont-weight:bold;\n}\n\n.initialDiagnosis {\n\tborder: 1px solid #CCC;\n\tcolor: #000;\n\theight:80px;\n\twidth: 350px;\n\tpadding:4px 4px 4px 2px;\n}\n\n\n</style>";
$room = preg_split("/\\_/", $ro->getRegistrationDetails_room());
echo "<br>";
if ($ro->getRegistrationDetails_dateUnregistered() == "") {
    echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/discharged/discharged.php?registrationNo={$registrationNo}&protoType=Discharged'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/unlock.jpeg'></a>&nbsp;&nbsp;<font size=2 color=red><b>" . $ro->getRegistrationDetails_type() . "</b></font><br>";
} else {
    echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/discharged/discharged.php?registrationNo={$registrationNo}&protoType=Undischarged'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/locked1.jpeg'></a>&nbsp;&nbsp;<font size=2 color=red><b>" . $ro->getRegistrationDetails_type() . "</b></font><br>";
}
echo "<font class='informationLabel'>Patient No:</font>&nbsp;" . $ro->getRegistrationDetails_patientNo();
echo "<br><font class='informationLabel'>Registration No:</font>&nbsp;" . $ro->getRegistrationDetails_registrationNo();
echo "<br><font class='informationLabel'>Age:</font>&nbsp;" . $ro->getPatientRecord_age();
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'>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'>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->getRegistrationDetails_dateUnregistered() != "") {

Exemple #3

Fichier : ptNotes.php Projet : rickyx12/protacio

$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database();
$ro->getPatientProfile($registrationNo);
?>


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

<?php 
echo "\n<style type='text/css'>\n\n.txtArea {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 80px;\n\twidth: 470px;\n\tpadding:4px 4px 4px 5px;\n}\n\n</style>\n";
echo "<form method='get' action='ptNotes_insert.php'>";
echo "<input type=hidden name='patientNo' value='" . $ro->getRegistrationDetails_patientNo() . "'>";
echo "<input type=hidden name='registrationNo' value='{$registrationNo}'>";
echo "<input type=hidden name='username' value='{$username}'>";
echo "<br><center><font size=2></font><center><div style='border:1px solid #000000; width:600px; height:485px; border-color:black black black black;'>";
echo "<br>";
echo "<table border=0>";
echo "<tr>";
echo "<td><font size=4 color=red>S</font><font size=3>ubjective</font><br><textarea name='subjective' class='txtArea'></textarea></td>";
echo "</tr>";
echo "<tr>";
echo "<td><font size=4 color=red>O</font><font size=3>bjective</font><br><textarea name='objective' class='txtArea'></textarea></td>";
echo "</tr>";
echo "<tr>";
echo "<td><font size=4 color=red>A</font><font size=3>ssessment</font><br><textarea name='assessment' class='txtArea'></textarea></td>";
echo "</tr>";
echo "<tr>";

Exemple #4

Fichier : editInformation.php Projet : rickyx12/mendero

<?php

include "../../myDatabase.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database();
$ro->getPatientProfile($registrationNo);
$ro->setPatientRecord($ro->getRegistrationDetails_patientNo());
$bday = preg_split("/\\-/", $ro->getPatientRecord_Birthdate());
echo "\n<style type='text/css'>\n.txtBox {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 30px;\n\twidth: 320px;\n\tpadding:4px 4px 4px 5px;\n}\n\n.shortField {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 30px;\n\twidth: 120px;\n\tpadding:4px 4px 4px 5px;\n}\n.labelz {\nfont-size:13px;\n}\n\n.comboBox {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 30px;\n\twidth: 320px;\n\tpadding:4px 4px 4px 5px;\n}\n\n\n.comboBoxShort {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 30px;\n\twidth: 65px;\n\tpadding:4px 4px 4px 5px;\n}\n\n.panz{\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 18px;\n\twidth: 20px;\n\tborder-color:white black black black;\n\tfont-size:18px;\n\ttext-align:center;\n}\n\n.panz1{\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 18px;\n\twidth: 20px;\n\tborder-color:white black black white;\n\tfont-size:18px;\n\ttext-align:center;\n}\n.Arial10RedBold {font-family: Arial;font-size: 10px;color: #FF0000;font-weight: bold;}\n\n</style>";
echo "<form method='get' action='editInformation1.php'>";
echo "<input type=hidden name='patientNo' value='" . $ro->getRegistrationDetails_patientNo() . "'>";
echo "<input type=hidden name='registrationNo' value='" . $registrationNo . "'>";
echo "<input type=hidden name='username' value='" . $username . "'>";
echo "<center><br><div style='border:1px solid #000000; width:500px; height:auto; border-color:black black black black;'>";
echo "<br>";
echo "<table border=0 cellpadding=0 cellspacing=0>";
echo "<tr>";
echo "<td>Last name&nbsp;</td>";
if ($ro->selectNow("registeredUser", "module", "username", $username) == "ER" || $ro->selectNow("registeredUser", "module", "username", $username) == "ADMITTING") {
    echo "<td><input type=text name='lastname'class='txtBox' value='" . $ro->getLastName_patientRecord() . "'></td>";
} else {
    if ($ro->selectNow("registeredUser", "module", "username", $username) == "LABORATORY" && $ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo) == "OPD") {
        echo "<td><input type=text name='lastname'class='txtBox' value='" . $ro->getLastName_patientRecord() . "'></td>";
    } else {
        echo "<td><input type=text name='lastname'class='txtBox' value='" . $ro->getLastName_patientRecord() . "' readonly></td>";
    }
}
echo "</tr>";
if ($ro->getFirstName_patientRecord() == "N/A" && $ro->getMiddleName_patientRecord() == "N/A" || $ro->getFirstName_patientRecord() == "n/a" && $ro->getMiddleName_patientRecord() == "n/a") {
} else {

Exemple #5

Fichier : patientProfile_left_sept24.php Projet : rickyx12/protacio

        //enable charges
        //echo "<li><a href='http://".$ro->getMyUrl()."/COCONUT/availableCharges/searchCharges.php?registrationNo=".$ro->getRegistrationDetails_registrationNo()."&username=$username&room=".$ro->getRegistrationDetails_room()."&batchNo=$batchNo' target='rightFrame'><font size=2>Add Charges</font></a></li>";
        //echo "<li><a href='http://".$ro->getMyUrl()."/COCONUT/Doctor/searchDoctor.php?registrationNo=".$ro->getRegistrationDetails_registrationNo()."&username=$username&room=".$ro->getRegistrationDetails_room()."&batchNo=$batchNo' target='rightFrame'><font size=2>Add Doctor</font></a></li>";
        //echo "<li><a href='http://".$ro->getMyUrl()."/COCONUT/availableMedicine/searchMedicine.php?registrationNo=".$ro->getRegistrationDetails_registrationNo()."&username=$username&inventoryFrom=PHARMACY&room=".$ro->getRegistrationDetails_room()."&batchNo=$batchNo' target='rightFrame'><font size=2>Add Medicine</font></a></li>";
        //echo "<li><a href='http://".$ro->getMyUrl()."/COCONUT/availableSupplies/searchSupplies.php?registrationNo=".$ro->getRegistrationDetails_registrationNo()."&username=$username&inventoryFrom=CSR&batchNo=$batchNo' target='rightFrame'><font size=2>Add Supplies</font></a></li>";
        //echo "<li><a href='http://".$ro->getMyUrl()."/COCONUT/patientProfile/ECART/cartHandler.php?registrationNo=".$ro->getRegistrationDetails_registrationNo()."&username=$username&room=".$ro->getRegistrationDetails_room()."&batchNo=$batchNo' target='rightFrame'><font size=2>Charges Cart</font></a></li>";
    } else {
        //disable charges
        echo "<li><a href='#'><font size=1 color=red>Limit Exceeded</font> <img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/locked1.jpeg'></a></li>";
    }
} else {
    //kung wLang creditLimit as "PATIENT" don't execute the creditLimit otherwise tuLuy Lng ang charging
    //echo "<li><a href='http://".$ro->getMyUrl()."/COCONUT/availableCharges/searchCharges.php?registrationNo=".$ro->getRegistrationDetails_registrationNo()."&username=$username&room=".$ro->getRegistrationDetails_room()."&batchNo=$batchNo' target='rightFrame'><font size=2>Add Charges</font></a></li>";
    //echo "<li><a href='http://".$ro->getMyUrl()."/COCONUT/Doctor/searchDoctor.php?registrationNo=".$ro->getRegistrationDetails_registrationNo()."&username=$username&room=".$ro->getRegistrationDetails_room()."&batchNo=$batchNo' target='rightFrame'><font size=2>Add Doctor</font></a></li>";
    //echo "<li><a href='http://".$ro->getMyUrl()."/COCONUT/availableMedicine/searchMedicine.php?registrationNo=".$ro->getRegistrationDetails_registrationNo()."&username=$username&inventoryFrom=PHARMACY&room=".$ro->getRegistrationDetails_room()."&batchNo=$batchNo' target='rightFrame'><font size=2>Add Medicine</font></a></li>";
    //echo "<li><a href='http://".$ro->getMyUrl()."/COCONUT/availableSupplies/searchSupplies.php?registrationNo=".$ro->getRegistrationDetails_registrationNo()."&username=$username&inventoryFrom=CSR&batchNo=$batchNo' target='rightFrame'><font size=2>Add Supplies</font></a></li>";
    if ($ro->selectNow("registrationDetails", "mgh", "registrationNo", $registrationNo) == "") {
        // enable charges kung hindi pa MGH
        echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/ECART/cartHandler.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "&username={$username}&room=" . $ro->getRegistrationDetails_room() . "&batchNo={$batchNo}' target='rightFrame'><font size=2>Charges Cart</font></a></li>";
    } else {
    }
}
echo "</ul>";
echo "<ul>";
echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/soaOption.php?registrationNo={$registrationNo}&username={$username}' target='rightFrame'><font size=2>S.O.A</font></a></li>";
echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/Doctor/doctorModule/soapListed.php?registrationNo={$registrationNo}&username={$username}' target='rightFrame'><font size=2>S.O.A.P</font></a></li>";
echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/Results/clinicalChemistry/view_labTest_done.php?registrationNo={$registrationNo}' target='rightFrame'><font size=2>Lab Results</font></a></li>";
echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/Results/Radiology/radioResult_list.php?registrationNo={$registrationNo}&username={$username}' target='rightFrame'><font size=2>Radio Results</font></a></li>";
echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientNotes/viewNote.php?noteType=Comments&username={$username}&registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "' target='rightFrame'><font size=2>Comments</font></a></li>";
echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/oldRecord/showRecord.php?patientNo=" . $ro->getRegistrationDetails_patientNo() . "&username={$username}' target='rightFrame'><font size=2>Record's</font></a></li>";
echo "</ul>";

Exemple #6

Fichier : labFormPrint2.php Projet : rickyx12/mendero

        $timeCharge = $afetch['timeCharge'];
        $chargeBy = $afetch['chargeBy'];
    }
}
$birthDatefmt = date("m/d/Y", strtotime($ro->getPatientRecord_birthDate()));
$birthDate = explode("/", $birthDatefmt);
$age = date("md", date("U", mktime(0, 0, 0, $birthDate[0], $birthDate[1], $birthDate[2]))) > date("md") ? date("Y") - $birthDate[2] - 1 : date("Y") - $birthDate[2];
if ($ro->getRegistrationDetails_room() == "") {
    $widthroom = "150";
} else {
    $widthroom = "auto";
}
if ($ro->getRegistrationDetails_company() == "") {
    $widthcom = "150";
} else {
    $widthcom = "auto";
}
echo "\n<div align='left'>\n  <table width='100%' border='0' cellpadding='0' cellspacing='0'>\n    <tr>\n      <td><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n        <tr>\n          <td width='50%'><div align='left'><table border='0' cellspacing='0' cellpadding='0'>\n            <tr>\n              <td width='auto'><div align='left' class='couriernew13black'>Patient ID</div></td>\n              <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n              <td width='auto' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . $ro->getRegistrationDetails_patientNo() . "</div></td>\n            </tr>\n          </table></div></td>\n          <td width='50%'><div align='right'><table border='0' cellspacing='0' cellpadding='0'>\n            <tr>\n              <td width='auto'><div align='left' class='couriernew13black'>Date-Time Printed</div></td>\n              <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n              <td width='auto' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . date("m/d/Y H:i") . "</div></td>\n            </tr>\n          </table></div></td>\n        </tr>\n      </table></td>\n    </tr>\n    <tr>\n      <td height='6'></td>\n    </tr>\n    <tr>\n      <td><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n        <tr>\n          <td width='auto'><div align='left'><table border='0' cellspacing='0' cellpadding='0'>\n            <tr>\n              <td width='auto'><div align='left' class='couriernew13black'>Patient Name</div></td>\n              <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n              <td width='auto' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "</div></td>\n            </tr>\n          </table></div></td>\n          <td width='auto'><div align='right'><table border='0' cellspacing='0' cellpadding='0'>\n            <tr>\n              <td width='auto'><div align='left' class='couriernew13black'>Date-Time Requested</div></td>\n              <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n              <td width='auto' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . date("m/d/Y", strtotime($dateCharge)) . " " . date("H:i", strtotime($timeCharge)) . "</div></td>\n            </tr>\n          </table></div></td>\n        </tr>\n      </table></td>\n    </tr>\n    <tr>\n      <td height='6'></td>\n    </tr>\n    <tr>\n      <td><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n        <tr>\n          <td width='auto'><div align='left'><table border='0' cellspacing='0' cellpadding='0'>\n            <tr>\n              <td width='auto'><div align='left' class='couriernew13black'>Date Of Birth</div></td>\n              <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n              <td width='auto' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . date("M d, Y", strtotime($ro->getPatientRecord_birthDate())) . "</div></td>\n            </tr>\n          </table></div></td>\n          <td width='auto'><div align='right'><table border='0' cellspacing='0' cellpadding='0'>\n            <tr>\n              <td width='auto'><div align='left' class='couriernew13black'>Requested By</div></td>\n              <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n              <td width='150' class='table1Bottom'><div align='left' class='couriernew15blackbold'>{$chargeBy}</div></td>\n            </tr>\n          </table></div></td>\n        </tr>\n      </table></td>\n    </tr>\n    <tr>\n      <td height='6'></td>\n    </tr>\n    <tr>\n      <td><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n        <tr>\n          <td width='auto'><div align='left'><table border='0' cellspacing='0' cellpadding='0'>\n            <tr>\n              <td width='auto'><div align='left' class='couriernew13black'>Age</div></td>\n              <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n              <td width='30' class='table1Bottom'><div align='left' class='couriernew15blackbold'>{$age}</div></td>\n              <td width='10'></td>\n              <td width='auto'><div align='left' class='couriernew13black'>Gender</div></td>\n              <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n              <td width='80' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . strtoupper($ro->getPatientRecord_Gender()) . "</div></td>\n            </tr>\n          </table></div></td>\n          <td width='auto'><div align='right'><table border='0' cellspacing='0' cellpadding='0'>\n            <tr>\n              <td width='auto'><div align='left' class='couriernew13black'>Physician</div></td>\n              <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n              <td width='auto' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . $ro->getAttendingDoc($registrationNo, "ATTENDING") . "</div></td>\n            </tr>\n          </table></div></td>\n        </tr>\n      </table></td>\n    </tr>\n    <tr>\n      <td height='6'></td>\n    </tr>\n    <tr>\n      <td><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n        <tr>\n          <td width='auto'><div align='left'><table border='0' cellspacing='0' cellpadding='0'>\n            <tr>\n              <td width='auto'><div align='left' class='couriernew13black'>Room</div></td>\n              <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n              <td width='{$widthroom}' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . $ro->getRegistrationDetails_room() . "</div></td>\n            </tr>\n          </table></div></td>\n          <td width='auto'><div align='right'><table border='0' cellspacing='0' cellpadding='0'>\n            <tr>\n              <td width='auto'><div align='left' class='couriernew13black'>Company</div></td>\n              <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n              <td width='{$widthcom}' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . $ro->getRegistrationDetails_company() . "</div></td>\n            </tr>\n          </table></div></td>\n        </tr>\n      </table></td>\n    </tr>\n    <tr>\n      <td height='20'></td>\n    </tr>\n    <tr>\n      <td><div align='left' class='couriernew15black'>REQUEST/S</div></td>\n    </tr>\n    <tr>\n      <td height='10'></td>\n    </tr>\n    <tr>\n      <td><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n        <tr>\n          <td width='auto'><div align='left' class='couriernew12black'>DESCRIPTION</div></td>\n        </tr>\n";
$asql = mysql_query("SELECT description, timeCharge, remarks, chargeBy, status FROM patientCharges WHERE registrationNo = '{$registrationNo}' AND departmentStatus = '' AND title = 'LABORATORY' AND status NOT LIKE 'DELETED_%%%%%%' AND dateCharge='{$dateCharge}' ");
while ($afetch = mysql_fetch_array($asql)) {
    echo "\n        <tr>\n          <td><div align='left' class='couriernew16blackbold'>" . $afetch['description'] . "</div></td>\n        </tr>\n";
    if ($afetch['remarks'] != "") {
        echo "\n        <tr>\n          <td valign='top'><div align='left' class='couriernew12black'>(" . $afetch['remarks'] . ")</div></td>\n        </tr>\n";
    }
}
echo "\n      </table></td>\n    </tr>\n  </table></td>\n</div>\n";
?>

</body>
</html>

Exemple #7

Fichier : labFormPrint3.php Projet : rickyx12/mendero

.astyle {text-decoration: none;}
.table1Bottom {border-bottom: 1px solid #000000;}
</style>
</head>

<body>
<?php 
include "../../myDatabase2.php";
$ro = new database();
$registrationNo = $_GET['registrationNo'];
$dateCharge = $_GET['dateCharge'];
mysql_connect($ro->myHost(), $ro->getUser(), $ro->getPass());
mysql_select_db($ro->getDB());
$ro->getPatientProfile($registrationNo);
$birthDatefmt = date("m/d/Y", strtotime($ro->getPatientRecord_birthDate()));
$birthDate = explode("/", $birthDatefmt);
$age = date("md", date("U", mktime(0, 0, 0, $birthDate[0], $birthDate[1], $birthDate[2]))) > date("md") ? date("Y") - $birthDate[2] - 1 : date("Y") - $birthDate[2];
echo "\n<div align='left'>\n  <table width='345' border='0' cellpadding='0' cellspacing='0' bordercolor='#000000'>\n    <tr>\n      <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0' bordercolor='#000000'>\n        <tr>\n          <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n            <tr>\n              <td height='6' colspan='6'></td>\n            </tr>\n            <tr>\n              <td width='80'><div align='left' class='couriernew11black'>&nbsp;Patient ID</div></td>\n              <td width='6'><div align='center' class='couriernew11black'>:</div></td>\n              <td width='75'><div align='left' class='couriernew13blackbold'><u>" . $ro->getRegistrationDetails_patientNo() . "</u></div></td>\n              <td width='35'><div align='left' class='couriernew11black'>Date</div></td>\n              <td width='6'><div align='center' class='couriernew11black'>:</div></td>\n              <td width='auto'><div align='right' class='couriernew10blackbold'><u>" . date("m/d/Y - H:i:s") . "</u>&nbsp;</div></td>\n            </tr>\n            <tr>\n              <td height='6' colspan='6'></td>\n            </tr>\n          </table></td>\n        </tr>\n        <tr>\n          <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n            <tr>\n              <td height='10'><div align='left' class='couriernew12black'>&nbsp;Patient Name:</div></td>\n            </tr>\n            <tr>\n              <td width='auto'><div align='left' class='couriernew14blackbold'>&nbsp;<u>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "&nbsp;</u></div></td>\n            </tr>\n          </table></td>\n        </tr>\n        <tr>\n          <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n            <tr>\n              <td height='10' colspan='6'></td>\n            </tr>\n            <tr>\n              <td width='45'><div align='left' class='couriernew12black'>&nbsp;B-Date</div></td>\n              <td width='6'><div align='center' class='couriernew12black'>:</div></td>\n              <td width='196'><div align='left' class='couriernew12blackbold'><u>" . $ro->getPatientRecord_birthDate() . "</u></div></td>\n              <td width='50'><div align='left' class='couriernew12black'>Age/Sex</div></td>\n              <td width='6'><div align='center' class='couriernew12black'>:</div></td>\n              <td width='auto'><div align='right' class='couriernew12blackbold'><u>{$age}/" . strtoupper($ro->getPatientRecord_Gender()) . "</u>&nbsp;</div></td>\n            </tr>\n          </table></td>\n        </tr>\n        <tr>\n          <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n            <tr>\n              <td height='6' colspan='3'></td>\n            </tr>\n            <tr>\n              <td width='55'><div align='left' class='couriernew12black'>&nbsp;Physician</div></td>\n              <td width='6'><div align='center' class='couriernew12black'>:</div></td>\n              <td width='auto'><div align='left' class='couriernew12blackbold'><u>" . $ro->getAttendingDoc($registrationNo, "ATTENDING") . "</u></div></td>\n            </tr>\n          </table></td>\n        </tr>\n        <tr>\n          <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n            <tr>\n              <td height='6' colspan='3'></td>\n            </tr>\n            <tr>\n              <td width='30'><div align='left' class='couriernew12black'>&nbsp;Room</div></td>\n              <td width='6'><div align='center' class='couriernew12black'>:</div></td>\n              <td width='auto'><div align='left' class='couriernew12blackbold'><u>" . $ro->getRegistrationDetails_room() . "</u>&nbsp;</div></td>\n            </tr>\n          </table></td>\n        </tr>\n        <tr>\n          <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n            <tr>\n              <td height='20'></td>\n            </tr>\n            <tr>\n              <td><div align='center'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n                <tr>\n                  <td width='auto'><div align='left' class='couriernew10blackbold'>&nbsp;Description&nbsp;</div></td>\n                </tr>\n";
$asql = mysql_query("SELECT description,timeCharge,remarks,chargeBy,status FROM patientCharges WHERE registrationNo = '{$registrationNo}' AND departmentStatus = '' AND title = 'LABORATORY' AND status NOT LIKE 'DELETED_%%%%%%' AND dateCharge='{$dateCharge}' ");
while ($afetch = mysql_fetch_array($asql)) {
    echo "\n                <tr>\n                  <td valign='top'><div align='left' class='couriernew14blackbold'>&nbsp;" . $afetch['description'] . "&nbsp;</div></td>\n                </tr>\n";
    if ($afetch['remarks'] != "") {
        echo "\n                <tr>\n                  <td valign='top'><div align='left' class='couriernew11black'>&nbsp;(" . $afetch['remarks'] . ")&nbsp;</div></td>\n                </tr>\n";
    }
}
echo "\n              </table></div></td>\n            </tr>\n          </table></td>\n        </tr>\n      </table></td>\n    </tr>\n  </table>\n</div>\n";
?>

</body>
</html>

Exemple #8

Fichier : addDiscount.php Projet : rickyx12/protacio

        echo "<td>";
        $ro->coconutTextBox("discount", "");
        echo "</td>";
        echo "</tr>";
        echo "<tr>";
        echo "<td>Discount Company</td>";
        echo "<td>";
        $ro->coconutTextBox("companyDiscount", "");
        echo "</td>";
        echo "</tr>";
    } else {
        $ro->coconutHidden("discount", "");
        $ro->coconutHidden("companyDiscount", "");
    }
    echo "<Tr>";
    echo "<td>Discount Type</td>";
    echo "<td>";
    $ro->coconutComboBoxStart_long("discountType");
    $ro->showOption("discountType", "discountType");
    $ro->coconutComboBoxStop();
    echo "</td>";
    echo "</tr>";
} else {
    echo $ro->coconutHidden("discount", "");
    echo $ro->coconutHidden("companyDiscount", "");
    echo $ro->coconutHidden("discountType", "");
}
echo "\n  <tr>\n    <td>&nbsp;</td>\n  </tr>\n  <tr>\n    <td>&nbsp;</td>\n    <td><input type=submit value='        Edit        ' style='border:1px solid #000000; background:#3b5998 no-repeat 4px 4px; color:white;'></td>\n  </tr>\n</table>\n<br />\n</div>\n</center>\n<input type='hidden' name='patientNo' value='" . $ro->getRegistrationDetails_patientNo() . "'>\n<input type='hidden' name='registrationNo' value='{$registrationNo}'>\n<input type='hidden' name='username' value='{$username}'>\n</form>\n";
?>
</body>
</html>