echo $batchNo; ?> </td> <td> <?php echo $ro->selectNow("inventoryManager", "requestingDepartment", "batchNo", $batchNo); ?> </td> <td> <?php echo $ro->selectNow("inventoryManager", "requestingUser", "batchNo", $batchNo); ?> </td> <td> <?php echo $ro4->formatTime($ro->selectNow("inventoryManager", "timeRequested", "batchNo", $batchNo)); ?> </td> <td> <?php echo $ro4->formatDate($ro->selectNow("inventoryManager", "dateRequested", "batchNo", $batchNo)); ?> </td> <td> <button class="btn btn-success col-sm-9" data-toggle="modal" data-target="#requestModal<?php echo $batchNo; ?> ">View Request</button> </td> </tr> <?php
$patientNo = $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo); $lastName = $ro->selectNow("patientRecord", "lastName", "patientNo", $patientNo); $firstName = $ro->selectNow("patientRecord", "firstName", "patientNo", $patientNo); echo $registrationNo . " - " . strtoupper($lastName) . ", " . strtoupper($firstName); ?> </td> <td> <?php $total = $ro->selectNow("patientCharges", "total", "itemNo", $itemNo); $total > 0 ? $x = number_format($total, 2) : ($x = ""); echo $x; ?> </td> <td> <?php echo $ro4->formatTime($ro->selectNow("patientCharges", "timeCharge", "itemNo", $itemNo)); ?> </td> <td> <?php echo $ro4->formatDate($ro->selectNow("patientCharges", "dateCharge", "itemNo", $itemNo)); ?> </td> </tr> <?php } ?> </tbody> </table> </div> </body>
echo "<br> <font class='informationLabel'>Senior ID#:</font> " . $ro->selectNow("registrationDetails", "seniorID", "registrationNo", $registrationNo); echo "<br> <font class='informationLabel'>PhilHealth:</font> " . $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> ".$ro->getPHICtype_patientRecord(); echo "<br> <font class='informationLabel'>Company:</font> " . $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> <font class='informationLabel'>Company1:</font> " . $ro->selectNow("registrationDetails", "company1", "registrationNo", $registrationNo); } else { } if ($ro->selectNow("registrationDetails", "company2", "registrationNo", $registrationNo) != "") { echo "<br> <font class='informationLabel'>Company2:</font> " . $ro->selectNow("registrationDetails", "company2", "registrationNo", $registrationNo); } else { } //echo "<br><font class='informationLabel'>Mother's Name:</font> ".$ro->selectNow("patientRecord","mothersName","patientNo",$ro->getRegistrationDetails_patientNo()); //echo "<br><font class='informationLabel'>Father's Name:</font> ".$ro->selectNow("patientRecord","fathersName","patientNo",$ro->getRegistrationDetails_patientNo()); if ($ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo) == "OPD") { echo "<br> <font class='informationLabel'>Time Registered:</font> " . $ro4->formatTime($ro->getRegistrationDetails_timeRegistered()); echo "<br> <font class='informationLabel'>Date Registered:</font> " . $ro4->formatDate($ro->getRegistrationDetails_dateRegistered()); } else { echo "<br><font class='informationLabel'>Time Registered:</font> " . $ro4->formatTime($ro->getRegistrationDetails_timeRegistered()); echo "<br><div class='col-xs-3 input-group'>\n\t\t\t\t<span class='input-group-addon'><i class='glyphicon glyphicon-time'></i> Admitted</span>\n\t\t\t\t<input type='text' class='form-control' id='timeAdmission' placeholder='click to add time'>\n\t\t\t\t<span class='input-group-btn'>\n\t\t\t\t\t<button id='saveTimeBtn' class='" . $buttonClass . "'>\n\t\t\t\t\t\tSave\n\t\t\t\t\t</button>\n\t\t\t\t</span>\n\t\t\t</div>"; echo "<font class='informationLabel'>Date Registered:</font> " . $ro4->formatDate($ro->getRegistrationDetails_dateRegistered()); } //echo "<br><font class='informationLabel'>Branch Registered:</font> ".$ro->getRegistrationDetails_branch(); echo "<br> <font class='informationLabel'>Case Type:</font> <a href='#' style='text-decoration:none; color:black;'>" . $ro->selectNow("registrationDetails", "privateORhouse_case", "registrationNo", $registrationNo) . "</a>"; //selectNow($table,$cols,$identifier,$identifierData) echo "<br> <font class='informationLabel'>Room:</font> " . $room[0]; echo "<br> <font class='informationLabel'>Address:</font> " . $ro->getPatientRecord_address(); echo "<br> <font class='informationLabel'>Email:</font> " . $ro->selectNow("patientRecord", "email", "patientNo", $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo)); echo "<br> <font class='informationLabel'>Registered By:</font> " . $ro->getRegistrationDetails_registeredBy(); if ($ro->getRegistrationDetails_type() == "IPD") { if ($ro->selectNow("nbs", "motherRegistrationNo", "motherRegistrationNo", $registrationNo) != "") {
<?php include "../../myDatabase.php"; include "../../myDatabase4.php"; $registrationNo = $_GET['registrationNo']; $date = $_GET['date']; $ro = new database(); $ro4 = new database4(); $patientNo = $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo); $ro4->get_previous_visit($patientNo, $date); $data = []; foreach ($ro4->get_previous_visit_registrationNo() as $registrationNo) { if ($ro4->get_previous_visit_doctor($registrationNo, "Consultation") != "") { array_push($data, ["registrationNo" => $registrationNo, "dateRegistered" => $ro4->formatDate($ro->selectNow("registrationDetails", "dateRegistered", "registrationNo", $registrationNo)), "timeRegistered" => $ro4->formatTime($ro->selectNow("registrationDetails", "timeRegistered", "registrationNo", $registrationNo)), "type" => $ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo), "doctor" => $ro->selectNow("patientCharges", "description", "itemNo", $ro4->get_previous_visit_doctor($registrationNo, "Consultation"))]); } else { } } $json = json_encode($data); echo $json;
echo "<tr>"; echo "<td><font class='labelz'><b>Name:</b></font></td><td><font size=2>" . $ro->getPatientRecord_completeName() . "</font></td>"; echo "<td> </td>"; echo "<Td><font class='labelz'><b>Patient ID#:</b></font></td>"; echo "<td><font size=2>" . $manualPatientNo . "</td>"; echo "</tr>"; echo "<tr>"; echo "<Td><font class='labelz'><B>Age:</b></td>"; echo "<Td><font size=2>" . $ro->getPatientRecord_age() . "</font></td>"; echo "<Td> </td>"; echo "<td><font class='labelz'><b>Senior:</b></font></td>"; echo "<td><font size=2>" . $ro->getPatientRecord_senior() . "</font></td>"; echo "</tr>"; echo "<tr>"; if ($admtime != "") { echo "<td><font class='labelz'><b>Date of Admission:</b></font></td><td><font size=2>" . $admdatefmt . " - " . $ro4->formatTime($admtime) . " </font></td>"; } else { echo "<td><font class='labelz'><b>Date of Admission:</b></font></td><td><font size=2>" . $admdatefmt . " </font></td>"; } echo "<Td> </td>"; $disdate = $ro->selectNow("registrationDetails", "dateUnregistered", "registrationNo", $registrationNo); $disdatestr = strtotime($disdate); $disdatefmt = date("M d, Y"); if ($showdate == 1) { if ($disdate == '') { echo "<td><font class='labelz'><b>Discharged Date:</b></font></td><td><a href='manualdate.php?registrationNo={$registrationNo}&username={$username}&show={$show}&chargesCode={$chargesCode}&showdate={$showdate}'><font size=2 color=black>" . date("M d, Y") . "</font></a></td>"; } else { echo "<td><font class='labelz'><b>Discharge Date:</b></font></td><td><a href='manualdate.php?registrationNo={$registrationNo}&username={$username}&show={$show}&chargesCode={$chargesCode}&showdate={$showdate}'><font size=2 color=black>" . $ro->formatDate($disdate) . "</font></a></td>"; } } else { if ($showdate == 2) {
<?php } ?> </td> <td> <?php echo $ro->selectNow('patientCharges', 'quantity', 'itemNo', $itemNo); ?> </td> <td> <?php echo $ro4->formatDate($ro->selectNow('patientCharges', 'dateCharge', 'itemNo', $itemNo)); ?> <h6> <?php echo $ro4->formatTime($ro->selectNow('patientCharges', 'timeCharge', 'itemNo', $itemNo)); ?> </h6> </td> <td> <?php echo $ro->selectNow('patientCharges', 'chargeBy', 'itemNo', $itemNo); ?> </td> <td> <input type="checkbox" name="itemNo" class="form-control" value="<?php echo $itemNo; ?> " checked="true"> </td> </tr>