<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",
Beispiel #2
0
          &nbsp;
            <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>
          &nbsp;
        </td>
        <td>
          &nbsp;
            <?php 
        echo $ro4->formatDate($ro->selectNow('registrationDetails', 'dateRegistered', 'registrationNo', $registrationNo));
        ?>
          &nbsp;
        </td>
        <td>
          &nbsp;
            <?php 
        if ($ro->selectNow('registrationDetails', 'dateUnregistered', 'registrationNo', $registrationNo) == "") {
        } else {
            echo $ro4->formatDate($ro->selectNow('registrationDetails', 'dateUnregistered', 'registrationNo', $registrationNo));
        }
        ?>
          &nbsp;
        </td>
        <td>
          &nbsp;
							<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 
Beispiel #5
0
<?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({
Beispiel #8
0
$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 
Beispiel #11
0
					<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>
Beispiel #12
0
<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>
Beispiel #13
0
}
?>
					<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>
Beispiel #14
0
					});

				<?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();
				}


			});
Beispiel #15
0
        ?>
									</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;
        ?>
Beispiel #16
0
		<div class="container">
			<div class="col-md-3">
				<table class="table table-hover">
					<thead>
						<tr>
							<th>Date</th>
							<th>&nbsp</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);
Beispiel #18
0
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) {
Beispiel #21
0
<!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>
Beispiel #22
0
	</div>

	<div class='headerContainer'>
		<font class='data'><b>Reg#</b></font>
		&nbsp;
		<font class='data'><?php 
echo $ro->selectNow('registrationDetails', 'registrationNo', 'registrationNo', $registrationNo);
?>
</font>
	</div>

	<div class='headerContainer'>
		<font class='data'><b>Birthday</b></font>
		&nbsp;
		<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>
		&nbsp;
		<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>
Beispiel #23
0
        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 
Beispiel #24
0
<?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>&nbsp;&nbsp;<font class='informationLabel'>Px Count:</font>&nbsp;<font color=red>" . $ro->selectNow("registrationDetails", "pxCount", "registrationNo", $registrationNo) . "</font><br />";
echo "&nbsp;&nbsp;<font class='informationLabel'>PIN#:</font>&nbsp;<font color=red>" . $ro->selectNow("patientRecord", "manual_patientNo", "patientNo", $ro->getRegistrationDetails_patientNo()) . "</font><br>";
echo "&nbsp;&nbsp;<font class='informationLabel'>Registration#:</font>&nbsp;<font color=red>" . $registrationNo . "</font>";
if ($ro->getRegistrationDetails_type() == "OPD") {
    echo "";
} else {
    echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Admission#:</font>&nbsp;<font color='blue'>" . $ro->selectNow("registrationDetails", "manual_registrationNo", "registrationNo", $ro->getRegistrationDetails_registrationNo()) . "</font>";
}
//echo "<br><font class='informationLabel'>System#:</font>&nbsp;".$ro->getRegistrationDetails_patientNo();
//echo "<br><font class='informationLabel'>Registration#:</font>&nbsp;".$ro->getRegistrationDetails_registrationNo();
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Age:</font>&nbsp;" . $ro->getPatientRecord_age();
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Gender:</font>&nbsp;" . $ro->getPatientRecord_gender();
//echo "<br><font class='informationLabel'>Civil Status:</font>&nbsp;".$ro->getPatientRecord_civilStatus();
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Birth Date:</font>&nbsp;" . $ro4->formatDate($ro->getPatientRecord_Birthdate());
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Contact No#:</font>&nbsp;" . $ro->getPatientRecord_contactNo();
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Senior:</font>&nbsp;" . $ro->getPatientRecord_senior();
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Senior ID#:</font>&nbsp;" . $ro->selectNow("registrationDetails", "seniorID", "registrationNo", $registrationNo);
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>PhilHealth:</font>&nbsp;" . $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>&nbsp;".$ro->getPHICtype_patientRecord();
echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Company:</font>&nbsp;" . $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>&nbsp;&nbsp;<font class='informationLabel'>Company1:</font>&nbsp;" . $ro->selectNow("registrationDetails", "company1", "registrationNo", $registrationNo);
} else {
}
if ($ro->selectNow("registrationDetails", "company2", "registrationNo", $registrationNo) != "") {
    echo "<br>&nbsp;&nbsp;<font class='informationLabel'>Company2:</font>&nbsp;" . $ro->selectNow("registrationDetails", "company2", "registrationNo", $registrationNo);
} else {
}
//echo "<br><font class='informationLabel'>Mother's Name:</font>&nbsp;".$ro->selectNow("patientRecord","mothersName","patientNo",$ro->getRegistrationDetails_patientNo());
Beispiel #27
0
						<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>&nbsp;<font size=3>-</font>&nbsp;</td>";
    echo "<td><font size=3>" . $ro4->formatDate($ro->selectNow("inventory", "dateAdded", "inventoryCode", $inventoryCode)) . "</font></td>";
    echo "<tr>";
}
echo "</table>";
Beispiel #29
0
        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">
Beispiel #30
0
								<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>