<script src='../js/jquery-2.1.4.min.js'></script> <script src='../js/table2excel/dist/jquery.table2excel.min.js'></script> <link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link> <script> $(document).ready(function(){ var isChrome = /Chrome/.test(navigator.userAgent) && /Google Inc/.test(navigator.vendor); console.log(isChrome); if( isChrome == true ) { $("#export").click(function() { var data='<table>'+$("#supplies").html().replace(/<a\/?[^>]+>/gi, '')+'</table>'; var reportName = '<?php echo 'Supplies Cost [' . $ro4->formatDate(date('Y-m-d')) . ']'; ?> '; /* $('body').prepend("<form method='post' action='../../export-to-excel/exporttoexcel.php' style='display:none' id='ReportTableData'><input type='text' name='tableData' value='"+data+"' ><input type='text' name='reportName' value='"+reportName+"'></form>"); */ $('body').prepend("<form method='post' action='../../export-to-excel/exporttoexcel.php' style='display:none' id='ReportTableData'><textarea name='tableData'>"+data+"</textarea><input type='text' name='reportName' value='"+reportName+"'></form>"); $('#ReportTableData').submit().remove(); return false; /* $("#supplies").table2excel({ name: "Supplies",
<a href="#" id="name<?php echo $registrationNo; ?> " style="text-decoration:none; color:black"> <?php $patientNo = $ro->selectNow('registrationDetails', 'patientNo', 'registrationNo', $registrationNo); echo $ro->selectNow('patientRecord', 'completeName', 'patientNo', $patientNo); ?> </a> </td> <td> <?php echo $ro4->formatDate($ro->selectNow('registrationDetails', 'dateRegistered', 'registrationNo', $registrationNo)); ?> </td> <td> <?php if ($ro->selectNow('registrationDetails', 'dateUnregistered', 'registrationNo', $registrationNo) == "") { } else { echo $ro4->formatDate($ro->selectNow('registrationDetails', 'dateUnregistered', 'registrationNo', $registrationNo)); } ?> </td> <td>
<th>Date</th> <th>Patient</th> <th>Amount</th> </tr> </thead> <tbody> <?php foreach ($ro4->inpatient_discharged_registrationNo() as $registrationNo) { ?> <?php if ($ro4->inpatient_phic_total($registrationNo) > 0) { ?> <tr> <td> <?php echo $ro4->formatDate($ro->selectNow("registrationDetails", "dateUnregistered", "registrationNo", $registrationNo)); ?> </td> <td> <?php $patientNo = $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo); $lastName = $ro->selectNow("patientRecord", "lastName", "patientNo", $patientNo); $firstName = $ro->selectNow("patientRecord", "firstName", "patientNo", $patientNo); echo $lastName . ", " . $firstName; ?> </td> <td> <?php $phicTotal += $ro4->inpatient_phic_total($registrationNo);
<?php if ($ro4->search_laboratory_result_savedNo() != "") { ?> <?php foreach ($ro4->search_laboratory_result_savedNo() as $savedNo) { ?> <tr> <td> <?php $registrationNo = $ro->selectNow("labSavedResult", "registrationNo", "savedNo", $savedNo); echo strtoupper($ro->selectNow("labSavedResult", "patientName", "savedNo", $savedNo)); ?> </td> <td> <?php echo $ro4->formatDate($ro->selectNow("labSavedResult", "date", "savedNo", $savedNo)); ?> </td> <td> <?php echo $ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo); ?> </td> <td> <?php $itemNo = $ro->selectNow("labSavedResult", "itemNo", "savedNo", $savedNo); echo $ro->selectNow("patientCharges", "description", "itemNo", $itemNo); ?> </td> <td> <button id="result<?php
<?php include "../../myDatabase.php"; include "../../myDatabase4.php"; $month = $_GET['month']; $day = $_GET['day']; $year = $_GET['year']; $month1 = $_GET['month1']; $day1 = $_GET['day1']; $year1 = $_GET['year1']; $username = $_GET['username']; $ro = new database(); $ro4 = new database4(); $date = $year . "-" . $month . "-" . $day; $date1 = $year1 . "-" . $month1 . "-" . $day1; $dates = $ro4->formatDate($date); $dates1 = $ro4->formatDate($date1); echo "Near Expiry<Br>"; echo $dates . " - " . $dates1; $ro->expiration($month, $day, $year, $month1, $day1, $year1, $username);
<html> <head> <meta charset="UTF-8"> <title></title> <script src="../js/jquery-2.1.4.min.js"></script> <link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link> <script> $(document).ready(function(){ var isChrome = /Chrome/.test(navigator.userAgent) && /Google Inc/.test(navigator.vendor); if( isChrome == true ) { $("#export").click(function(){ var data='<table>'+$("#paidInvoice").html().replace(/<a\/?[^>]+>/gi, '')+'</table>'; var reportName = '<?php echo 'Check Paid Invoice [' . $ro4->formatDate($date1) . ' to ' . $ro4->formatDate($date2) . ']'; ?> '; /* $('body').prepend("<form method='post' action='../../export-to-excel/exporttoexcel.php' style='display:none' id='ReportTableData'><input type='text' name='tableData' value='"+data+"' ><input type='text' name='reportName' value='"+reportName+"'></form>"); */ $('body').prepend("<form method='post' action='../../export-to-excel/exporttoexcel.php' style='display:none' id='ReportTableData'><textarea name='tableData'>"+data+"</textarea><input type='text' name='reportName' value='"+reportName+"'></form>"); $('#ReportTableData').submit().remove(); return false; }); }else { $("#export").hide(); }
<title></title> <script src='../js/jquery-2.1.4.min.js'></script> <script src='../js/table2excel/dist/jquery.table2excel.min.js'></script> <link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link> <script> $(document).ready(function(){ var isChrome = /Chrome/.test(navigator.userAgent) && /Google Inc/.test(navigator.vendor); console.log(isChrome); if( isChrome == true ) { $("#export").click(function() { var data='<table>'+$("#medicine").html().replace(/<a\/?[^>]+>/gi, '')+'</table>'; var reportName = '<?php echo 'Medicine Cost [' . $ro4->formatDate(date('Y-m-d')) . ']'; ?> '; /* $('body').prepend("<form method='post' action='../../export-to-excel/exporttoexcel.php' style='display:none' id='ReportTableData'><input type='text' name='tableData' value='"+data+"' ><input type='text' name='reportName' value='"+reportName+"'></form>"); */ $('body').prepend("<form method='post' action='../../export-to-excel/exporttoexcel.php' style='display:none' id='ReportTableData'><textarea name='tableData'>"+data+"</textarea><input type='text' name='reportName' value='"+reportName+"'></form>"); $('#ReportTableData').submit().remove(); return false; /* $("#medicine").table2excel({
$ro4->laboratory_senior_patient($date1, $date2, "OPD", $title); ?> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <link rel="stylesheet" href="/bower_components/bootstrap/dist/css/bootstrap.min.css"> </head> <body> <div class="container"> <h3> <?php echo $title; ?> </h3> <h5><?php echo $ro4->formatDate($date1); ?> - <?php echo $ro4->formatDate($date2); ?> </h5> <div class="col-md-2"> </div> <div class="col-md-8"> <table class="table table-hover"> <thead> <tr> <th>Patient</th> <th>Age</th>
<!DOCTYPE html> <html lang="en"> <head> <title>Daily Transaction</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="../..//bootstrap-3.3.6/css/bootstrap.min.css"> <script src="/bootstrap-3.3.6/js/bootstrap.min.js"></script> </head> <body> <div class="container"> <h2>Daily Transaction</h2> <p><?php echo $ro->formatDate($date); ?> </p> <table class="table table-hover"> <thead> <tr> <th></th> <th>Patient</th> <th></th> <th>Total</th> <th>Discount</th> <th>Balance</th> <th>HMO</th> <th>Cash</th> <th>Cr.Card</th> </tr>
<style> @media print { a[href]:after { content: ""; } } </style> </head> <body> <div class="container"> <div class="row"> <h3>Transaction Summary</h3> <Br> <h5><?php echo $ro4->formatDate($date1) . " - " . $ro4->formatDate($date2); ?> </h5> <div class="col-xs-5"> <h4>Outpatient</h4> <table class="table table-hover "> <thead> <tr> <th>Account Title</th> <th>Debit</th> <th>Credit</th> </tr> </thead> <tbody> <?php
<table class="table table-hover"> <thead> <tr> <th>Date</th> <th>Patients</th> </tr> </thead> <tbody> <?php for ($x = 1; $x <= 31; $x++) { ?> <tr> <td> <?php echo $ro4->formatDate($year . "-" . $month . "-" . $x); ?> </td> <?php if ($x < 10) { ?> <?php $totalOPD += $ro4->get_last_register($year . "-" . $month . "-" . "0" . $x); ?> <td> <?php echo $ro4->get_last_register($year . "-" . $month . "-" . "0" . $x); ?> </td>
<body> <h5>Edit History</h5> <table class="table"> <thead> <tr> <th>Date</th> <th>Orig. QTY</th> <th>User</th> </tr> </thead> <?php foreach ($ro4->edited_inventory_editNo() as $editNo) { ?> <tr> <td><?php echo $ro4->formatDate($ro->selectNow("editedInventory", "date", "editNo", $editNo)); ?> </td> <td class="text-center"><?php echo $ro->selectNow("editedInventory", "quantity", "editNo", $editNo); ?> </td> <td><?php echo $ro->selectNow("editedInventory", "username", "editNo", $editNo); ?> </td> </tr> <?php } ?> </table>
} ?> <th>Description</th> <th>Bank</th> <th>Vattable</th> <th>vat</th> <th>W/ Tax</th> <th>Amount</th> <th>User</th> </tr> </thead> <tbody> <tr> <td> <?php echo $ro4->formatDate($ro->selectNow("vouchers", "date", "invoiceNo", $invoiceNo)); ?> </td> <td> <?php echo $ro->selectNow("vouchers", "paymentMode", "invoiceNo", $invoiceNo); ?> </td> <?php if ($ro->selectNow("vouchers", "paymentMode", "invoiceNo", $invoiceNo) == "check") { ?> <td> <?php echo $ro->selectNow("vouchers", "checkedNo", "invoiceNo", $invoiceNo); ?> </td>
}); <?php } ?> var isChrome = /Chrome/.test(navigator.userAgent) && /Google Inc/.test(navigator.vendor); console.log(isChrome); if( isChrome == true ) { $("#export").click(function() { var data='<table>'+$("#charges").html().replace(/<a\/?[^>]+>/gi, '')+'</table>'; var reportName = '<?php echo $title . ' Census [' . $ro4->formatDate($date1) . ' - ' . $ro4->formatDate($date2) . ']'; ?> '; $('body').prepend("<form method='post' action='../../../export-to-excel/exporttoexcel.php' style='display:none' id='ReportTableData'><textarea name='tableData'>"+data+"</textarea><input type='text' name='reportName' value='"+reportName+"'></form>"); $('#ReportTableData').submit().remove(); return false; }); }else { $("#export").hide(); } });
?> </td> <td> <?php echo strtoupper($ro->selectNow("uploadedFiles", "patientName", "fileNo", $fileNo)); ?> </td> <td> <?php $itemNo = $ro->selectNow("uploadedFiles", "itemNo", "fileNo", $fileNo); echo $ro->selectNow("patientCharges", "description", "itemNo", $itemNo); ?> </td> <td> <?php echo $ro4->formatDate($ro->selectNow("uploadedFiles", "dateUploaded", "fileNo", $fileNo)); ?> </td> <td> <a href="../../<?php echo $ro->selectNow("uploadedFiles", "fileUrl", "fileNo", $fileNo); ?> " style="color:black" download="<?php echo $ro->selectNow("uploadedFiles", "fileName", "fileNo", $fileNo); ?> "><i class="glyphicon glyphicon-cloud-download"></i> Download</a> </td> <td> <a href="#" id="remove<?php echo $fileNo; ?>
<div class="container"> <div class="col-md-3"> <table class="table table-hover"> <thead> <tr> <th>Date</th> <th> </th> </tr> </thead> <tbody> <?php foreach ($ro4->census_list_patient_id() as $id) { ?> <tr> <td><?php echo $ro4->formatDate($ro->selectNow("ipdCensus", "date", "id", $id)); ?> </td> <td><input type="button" id="remove<?php echo $id; ?> " class="btn btn-danger" value="Remove"></td> </tr> <?php } ?> </tbody> </table> </div> </div> </body>
<?php include "../../myDatabase.php"; include "../../myDatabase4.php"; $inventoryCode = $_POST['inventoryCode']; $ro = new database(); $ro4 = new database4(); echo "Invoice#: " . $ro->selectNow("inventory", "invoiceNo", "inventoryCode", $inventoryCode); echo "<br>"; echo "Stock#: " . $ro->selectNow("inventory", "stockCardNo", "inventoryCode", $inventoryCode); echo "<br>"; echo "Added: " . $ro4->formatDate($ro->selectNow("inventory", "dateAdded", "inventoryCode", $inventoryCode)); echo "<Br>"; echo "User: "******"inventory", "addedBy", "inventoryCode", $inventoryCode);
for ($a = 0, $b = 0, $c = 0, $d = 0; $a < $countLastName, $b < $countFirstName, $c < $countRegistrationNo, $d < $countDateUnregistered; $a++, $b++, $c++, $d++) { ?> <?php $companyBalance = $ro->aging_of_accounts_details_amount($registrationNo[$c]) - $ro->aging_of_accounts_details_payment($registrationNo[$c]); ?> <tr> <?php if ($companyBalance > 0) { ?> <td><?php echo $lastName[$a] . ", " . $firstName[$b]; ?> <br><?php echo $ro->formatDate($dateUnregistered[$d]); ?> </td> <?php if ($ro->calculateDays($dateUnregistered[$d], date("Y-m-d")) <= 30) { $_30days += $companyBalance; ?> <td><?php echo number_format($companyBalance, 2); ?> </td> <?php } else { ?> <td></td>
$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> </html>
$ro4->inpatient_discharged($date1, $date2); ?> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title></title> <link rel="stylesheet" href="../../../bootstrap-3.3.6/css/bootstrap.css"></link> </head> <body> <div class="container"> <h3>Philhealth Receivables</h3> <h5>Inpatient</h5> <h5><?php echo $ro4->formatDate($date1) . " - " . $ro4->formatDate($date2); ?> </h5> <div class="col-md-8"> <table class="table table-hover"> <thead> <tr> <th>Patient</th> <th>Admitted</th> <th>Receivables</th> </tr> </thead> <tbody> <?php foreach ($ro4->inpatient_discharged_registrationNo() as $registrationNo) {
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title></title> <script src="../js/jquery-2.1.4.min.js"></script> <link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link> <script> $(document).ready(function(){ var isChrome = /Chrome/.test(navigator.userAgent) && /Google Inc/.test(navigator.vendor); if( isChrome == true ) { $("#export").click(function(){ var data='<table>'+$("#chargesList").html().replace(/<a\/?[^>]+>/gi, '')+'</table>'; var reportName = '<?php echo $title . ' [' . $ro4->formatDate(date('Y-m-d')) . ']'; ?> '; $('body').prepend("<form method='post' action='../../export-to-excel/exporttoexcel.php' style='display:none' id='ReportTableData'><input type='text' name='tableData' value='"+data+"' ><input type='text' name='reportName' value='"+reportName+"'></form>"); $('#ReportTableData').submit().remove(); return false; }); }else { $("#export").hide(); } }); </script> </head> <body>
</div> <div class='headerContainer'> <font class='data'><b>Reg#</b></font> <font class='data'><?php echo $ro->selectNow('registrationDetails', 'registrationNo', 'registrationNo', $registrationNo); ?> </font> </div> <div class='headerContainer'> <font class='data'><b>Birthday</b></font> <font class='data'><?php echo $ro4->formatDate($ro->selectNow('patientRecord', 'Birthdate', 'patientNo', $patientNo)); ?> </font> </div> <div class='headerContainer'> <font class='data'><b>Date</b></font> <font class='data'><?php echo $ro4->formatDate($ro->selectNow('registrationDetails', 'dateRegistered', 'registrationNo', $registrationNo)); ?> </font> </div> <div class='headerContainerFullWidth'> <font class='data'><b>Room</b></font>
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 } ?> </tbody> </table> <?php
<?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 "<Br><font size=3>($branch)</font>"; ?> <script src="../../js/jquery-2.1.4.min.js"></script> <script src="../../js/open.js"></script> <script> $(document).ready(function(){ var isChrome = /Chrome/.test(navigator.userAgent) && /Google Inc/.test(navigator.vendor); if( isChrome == true ) { $("#export").click(function(result){ var data='<table>'+$("#census").html().replace(/<a\/?[^>]+>/gi, '')+'</table>'; var reportName = '<?php echo 'Census ' . $type . ' [' . $ro4->formatDate($fromRegistered) . ' to ' . $ro4->formatDate($toRegistered) . ' ]'; ?> '; /* $('body').prepend("<form method='post' action='../../../export-to-excel/exporttoexcel.php' style='display:none' id='ReportTableData'><input type='text' name='tableData' value='"+data+"' ><input type='text' name='reportName' value='"+reportName+"'></form>"); */ $('body').prepend("<form method='post' action='../../../export-to-excel/exporttoexcel.php' style='display:none' id='ReportTableData'><textarea name='tableData'>"+data+"</textarea><input type='text' name='reportName' value='"+reportName+"'></form>"); $('#ReportTableData').submit().remove(); return false; }); }else { $("#export").hide(); }
} //echo "<img src='http://".$ro->getMyUrl()."/COCONUT/myImages/verified.jpeg'>"; echo "<br> <font class='informationLabel'>Px Count:</font> <font color=red>" . $ro->selectNow("registrationDetails", "pxCount", "registrationNo", $registrationNo) . "</font><br />"; echo " <font class='informationLabel'>PIN#:</font> <font color=red>" . $ro->selectNow("patientRecord", "manual_patientNo", "patientNo", $ro->getRegistrationDetails_patientNo()) . "</font><br>"; echo " <font class='informationLabel'>Registration#:</font> <font color=red>" . $registrationNo . "</font>"; if ($ro->getRegistrationDetails_type() == "OPD") { echo ""; } else { echo "<br> <font class='informationLabel'>Admission#:</font> <font color='blue'>" . $ro->selectNow("registrationDetails", "manual_registrationNo", "registrationNo", $ro->getRegistrationDetails_registrationNo()) . "</font>"; } //echo "<br><font class='informationLabel'>System#:</font> ".$ro->getRegistrationDetails_patientNo(); //echo "<br><font class='informationLabel'>Registration#:</font> ".$ro->getRegistrationDetails_registrationNo(); echo "<br> <font class='informationLabel'>Age:</font> " . $ro->getPatientRecord_age(); echo "<br> <font class='informationLabel'>Gender:</font> " . $ro->getPatientRecord_gender(); //echo "<br><font class='informationLabel'>Civil Status:</font> ".$ro->getPatientRecord_civilStatus(); echo "<br> <font class='informationLabel'>Birth Date:</font> " . $ro4->formatDate($ro->getPatientRecord_Birthdate()); echo "<br> <font class='informationLabel'>Contact No#:</font> " . $ro->getPatientRecord_contactNo(); echo "<br> <font class='informationLabel'>Senior:</font> " . $ro->getPatientRecord_senior(); 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());
<input type="text" id="from" name="from" class="form-control date" placeholder="Click Me"> <span class="input-group-addon">To</span> <input type="text" id="to" name="to" class="form-control date" placeholder="Click Me"> <span class="input-group-btn"> <button id="purchasesBtn" class="btn btn-info">View Purchases</button> </span> </div> </div> <br> <div class="row"> <div class="col-md-7"> <?php if ($ro4->view_purchases_siNo() != "") { ?> <h5><?php echo $ro4->formatDate($formatFromDate) . " - " . $ro4->formatDate($formatToDate); ?> </h5> <table class="table table-hover"> <thead> <tr> <th>Date</th> <th>Invoice#</th> <th>Supplier</th> <th>Amount</th> </tr> </thead> <tbody> <?php foreach ($ro4->view_purchases_siNo() as $siNo) { ?>
<?php include "../../myDatabase.php"; include "../../myDatabase4.php"; $stockCardNo = $_POST['stockCardNo']; $ro = new database(); $ro4 = new database4(); $ro4->unitcost_list($stockCardNo); echo "<font size=4><b>IPD Price</b></font><Br>"; echo "<Table>"; foreach ($ro4->unitcost_list_inventoryCode() as $inventoryCode) { echo "<Tr>"; echo "<td><font size=3>" . number_format($ro->selectNow("inventory", "ipdPrice", "inventoryCode", $inventoryCode), 2) . "</font></td>"; echo "<td> <font size=3>-</font> </td>"; echo "<td><font size=3>" . $ro4->formatDate($ro->selectNow("inventory", "dateAdded", "inventoryCode", $inventoryCode)) . "</font></td>"; echo "<tr>"; } echo "</table>";
echo $x; ?> </td> <td> <?php echo $ro->selectNow("salesInvoice", "terms", "siNo", $siNo); ?> </td> <td> <?php $date = $ro->selectNow("salesInvoice", "recievedDate", "siNo", $siNo); $year = substr($date, 0, 4); $month = substr($date, 4, 2); $day = substr($date, 6, 2); $formatDate = $year . "-" . $month . "-" . $day; echo $ro4->formatDate($formatDate); ?> </td> <td> <?php echo $ro->selectNow("salesInvoice", "encodedBy", "siNo", $siNo); ?> </td> <?php if ($ro->selectNow("vouchers", "controlNo", "invoiceNo", $invoiceNo) != "") { ?> <td> <span id="paid<?php echo $invoiceNo; ?> " class="label label-success">
<td> <?php $patientNo = $ro->selectNow('registrationDetails', 'patientNo', 'registrationNo', $registrationNo); $lastName = $ro->selectNow('patientRecord', 'lastName', 'patientNo', $patientNo); $firstName = $ro->selectNow('patientRecord', 'firstName', 'patientNo', $patientNo); echo strtoupper($lastName . ", " . $firstName); ?> </td> <td> <?php echo $ro->selectNow('registrationDetails', 'room', 'registrationNo', $registrationNo); ?> </td> <td> <?php echo $ro4->formatDate($ro->selectNow('registrationDetails', 'dateRegistered', 'registrationNo', $registrationNo)); ?> </td> <td> <button class="btn btn-success" data-toggle="modal" data-target="#dispenseModal<?php echo $registrationNo; ?> "> View </button> </td> </tr> <?php } ?> </tbody>