<?php

session_start();
include("dbConfig.php");
if(isset($_SESSION['username']) && isset($_SESSION['name']))
{
    $username=$_SESSION['username'];
    $name=$_SESSION['name'];
}
else
{
     echo '<META http-equiv="refresh" content="0;logout.php">';
}

if(is_array($_POST['part'])){
	$part=$_POST['part'];
	$consultant=$_POST['consultant'];
	$qty=$_POST['qty'];
// 	$optionlab=$_POST['optionlab'];
	$Price=$_POST['price'];
	$size=$_POST['size'];
$patid=$_POST['patid'];
$billtype=$_POST['billtype'];
$bdate=$_POST['bdate'];
$btime=$_POST['btime'];
$payable=$_POST['payable'];
$preparedby=$_POST['preparedby'];
$InsuranceName=$_POST['InsuranceName'];
$InsuranceNo=$_POST['InsuranceNo'];
$bank=$_POST['bank'];
$cardno=$_POST['cardno'];
$upi=$_POST['upi'];
$cash=$_POST['cash'];
$upiid=$_POST['upiid'];

$qu4=mysqli_query($db,"SELECT * FROM patientdetails WHERE PatId='$patid'");
if(mysqli_num_rows($qu4)!=0){
   while($row=$qu4->fetch_assoc()){
       $title=$row['title'];
$Pname=$row['Name'];
$contact1=$row['Contact'];
$email=$row['Email'];
$dob=$row['Dob'];
$age=$row['Age'];
$gender=$row['Gender'];
$blood=$row['BloodGroup'];
$Address=$row['Address'];
$Consultant=$row['Consultant'];
$PatientType="IPD";
$AdmitDate=$row['AdmitDate'];
$AdmitTime=$row['AdmitTime'];
} 
}
else{
    $qu5=mysqli_query($db,"SELECT * FROM opdpatientregister WHERE PatientId='$patid'");
while($row=$qu5->fetch_assoc()){
       $title=$row['title'];
$Pname=$row['Name'];
$contact1=$row['Contact'];
$email=$row['Email'];
$age=$row['Age'];
$gender=$row['Gender'];
$Address=$row['Address'];
$Consultant=$row['Consultant'];
$PatientType="OPD";
}
}
}
?>
<!DOCTYPE html>
<html>
<head>
  <title>
    
  </title>
  <meta charset="UTF-8">
  <link href="assets/img/favicon.png" rel="icon">
  <link href="assets/img/apple-touch-icon.png" rel="apple-touch-icon">
  <script src='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js'></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js'></script>
<link href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.0.3/css/font-awesome.css'>
<link href='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css'>
  <!-- Google Fonts -->
  <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,700,700i|Raleway:300,400,500,700,800|Montserrat:300,400,700" rel="stylesheet">
<link href='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css'>
<link href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.0.3/css/font-awesome.css'>

  <!-- Vendor CSS Files -->
  <link href="assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  <link href="assets/vendor/ionicons/css/ionicons.min.css" rel="stylesheet">
  <link href="assets/vendor/animate.css/animate.min.css" rel="stylesheet">
  <link href="assets/vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet">
  <link href="assets/vendor/venobox/venobox.css" rel="stylesheet">
  <link href="assets/vendor/owl.carousel/assets/owl.carousel.min.css" rel="stylesheet">
  <link href="assets/vendor/boxicons/css/boxicons.min.css" rel="stylesheet">
  <script src="https://code.jquery.com/jquery.min.js"></script>
  <script src="jquery.dependent.fields.js"></script>
  <!-- Template Main CSS File -->
  <link href="assets/css/style.css" rel="stylesheet">
  <script src="https://code.jquery.com/jquery.min.js"></script>
<script src="jquery.dependent.fields.js"></script>
</head>
<body>

<section>
	<div class="row">
		<div class="col-md-1"></div>
		<div class="col-md-10">
			

	<div class="shadow p-3 mb-5 bg-light rounded">
		<div class="row">
			<div class="col-md-3">
				<img src="assets/img/logo.png">
			</div>
			<div class="col-md-3"></div>
			<div class="col-md-6">
			<table>
			<tr>
				<td valign="top">Address</td>
			    <td>:2876, 4th Cross, NS Road, Chamundipuram, Mysuru, Karnataka 570004</td>
			</tr>
			<tr>
				<td valign="top">Website</td>
				<td>:www.vidhyaran.com</td>
			</tr>
			<tr>
				<td valign="top">Contact</td>
				<td>:+91-821 233 1655</td>
			</tr>
			<tr>
				<td>Unit</td>
				<td>:Mysore</td>
			</tr>

		</table>
			</div>
		</div>
<hr>
<div class="row">
	<div class="col-md-6">
		<table>
		<tr>
			<td valign="top">Patient Id</td>
			<td valign="top">: <? echo $patid;?></td>
		</tr>
	<tr>
		<td valign="top">Name</td>
		<td valign="top">: <?php echo $title . ' ' . $Pname; ?></td>
	</tr>
	<tr>
		<td valign="top">Contact No.</td>
		<td valign="top">: <? echo $contact1;?></td>
	</tr>
	<tr>
		<td valign="top">Email Id</td>
		<td valign="top">: <? echo $email;?></td>
	</tr>
	<tr>
		<td valign="top">Address</td>
		<td valign="top">: <? echo $Address;?></td>
	</tr>

</table>
	</div><?
if($PatientType=="IPD"){?>
		<div class="col-md-6">
		<table>		
	<tr>
		<td valign="top">Gender/Age/Blood Group</td>
		<td valign="top">: <? echo $gender."/ ".$age." / ".$blood;?></td>
	</tr>

	<tr>
		<td valign="top">Consultant</td>
		<td valign="top">: <? echo $Consultant;?></td>
	</tr>
	<tr>
		<td valign="top">Patient Type</td>
		<td valign="top">: <? echo $PatientType;?></td>
	</tr>
	<tr>
		<td valign="top">Admit Date/Time</td>
		<td valign="top">: <? echo $AdmitDate.", ".$AdmitTime;?></td>
	</tr>
	<tr>
		<td valign="top">Bill Type/Bill Date-Time</td>
		<td valign="top">: <? echo $billtype."/ ".$bdate.", ".$btime;?></td>
	</tr>	
		<?if($billtype=="Insurance"){
	echo "<tr><td>Insurance Name / Number</td>";
	echo "<td>:$InsuranceName, $InsuranceNo</td></tr>";
	}
	
	if($billtype=="Card"){
	echo "<tr><td>Bank Name / Card Number</td>";
	echo "<td>:$bank, $cardno</td></tr>";
	}
		if($billtype=="Cash and UPI"){
	echo "<tr><td>Cash Amount / UPI Amount</td>";
	echo "<td>:$cash, $upi</td></tr>";
	}
	?>
</table>
	</div>
<?}else{?>
		<div class="col-md-6">
		<table>		
	<tr>
		<td valign="top">Gender/Age</td>
		<td valign="top">: <? echo $gender."/ ".$age;?></td>
	</tr>

	<tr>
		<td valign="top">Consultant</td>
		<td valign="top">: <? echo $Consultant;?></td>
	</tr>
	<tr>
		<td valign="top">Patient Type</td>
		<td valign="top">: <? echo $PatientType;?></td>
	</tr>
	<tr>
		<td valign="top">Bill Type/Bill Date-Time</td>
		<td valign="top">: <? echo $billtype."/ ".$bdate.", ".$btime;?></td>
	</tr>
</table>
	</div>
<?}?>




</div>
<br>
<form action="editedBillprev.php" method="POST">
<table class="table table-hover">
	<thead>
		<th scope="col">Sl No.</th>
		<th scope="col">Particulars</th>
		<th scope="col">Consultant</th>
		<th scope="col">Quantity</th>
		<th scope="col">Unit Price</th>
	</thead>
	<tbody>
		<?
		for($i=0;$i<$size;$i++){
			$j=$i+1;
			echo "<tr><td>$j</td>";
		
			echo "<td>$part[$i]</td>";
			


	echo "<td><input type=\"text\" name=\"consultant[$i]\" value=\"$consultant[$i]\"></td>";
			echo "<td><input type=\"number\" name=\"qty[$i]\" value=\"$qty[$i]\"></td>";
			echo "<td><input type=\"number\" name=\"price[$i]\" value=\"$Price[$i]\"></td>";
		echo "</tr>";
	
		}
	?>	
	


	</tbody>
</table>

<br><br>
<!--<div class="input-group control-group after-add-more">         -->
<!-- <button class="btn btn-success add-more" type="button"><i class="glyphicon glyphicon-plus"></i>Add Particulars</button>-->
<!--</div><br>-->

<br>
<div class="row">
	<div class="col-md-1"></div>
	<div class="col-md-7"></div>
	<div class="col-md-4">
	    <br>
<h6>Prepared by <? echo $name?></h6><br>
		<h6>Authorized Signatory</h6>
	</div>
</div>
<br><br><br><br>

		</div>
		<div class="col-md-1"></div>
		
	</div>
</div>


	<?
	foreach($part as $value)
{
    echo '<input type="hidden" name="Epart[]" value="'. $value. '">';
}
	
		foreach($consultant as $value)
{
    echo '<input type="hidden" name="consultant[]" value="'. $value. '">';
}
// 	foreach($optionlab as $value)
// {
//     echo '<input type="hidden" name="optionlab[]" value="'. $value. '">';
// }
?>
	<input type="hidden" name="size" value="<? echo $size;?>">
	<input type="hidden" name="patid" value="<? echo $patid;?>">
	<input type="hidden" name="billtype" value="<? echo $billtype;?>">
	<input type="hidden" name="bdate" value="<? echo $bdate;?>">
	<input type="hidden" name="btime" value="<? echo $btime;?>">
	<input type="hidden" name="preparedby" value="<? echo $name;?>">
	<input type="hidden" name="InsuranceName" value="<? echo $InsuranceName;?>">
	 <input type="hidden" name="InsuranceNo" value="<? echo $InsuranceNo;?>">
	 	<input type="hidden" name="bank" value="<? echo $bank;?>">
	 <input type="hidden" name="cardno" value="<? echo $cardno;?>">
	 	<input type="hidden" name="upi" value="<? echo $upi;?>">
	 <input type="hidden" name="cash" value="<? echo $cash;?>">
	 <input type="hidden" name="upiid" value="<? echo $upiid;?>">
<div style="text-align: center;">
	

	 <button type="submit" class="btn btn-primary">Preview Bill</button>
    
	
</div>
</form>



 
</section>


<!---->
 <script src='https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js'></script>
  <script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js'></script>
  <script src="assets/vendor/jquery/jquery.min.js"></script>
  <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="assets/vendor/jquery.easing/jquery.easing.min.js"></script>
  <script src="assets/vendor/php-email-form/validate.js"></script>
  <script src="assets/vendor/wow/wow.min.js"></script>
  <script src="assets/vendor/venobox/venobox.min.js"></script>
  <script src="assets/vendor/owl.carousel/owl.carousel.min.js"></script>
  <script src="assets/vendor/jquery-sticky/jquery.sticky.js"></script>
  <script src="assets/vendor/superfish/superfish.min.js"></script>
  <script src="assets/vendor/hoverIntent/hoverIntent.js"></script>
  <script src="assets/vendor/isotope-layout/isotope.pkgd.min.js"></script>
  <script src="assets/js/main.js"></script>
</body>
</html>
