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>
