<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>
