<?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">';
}

?><?php
include("dbConfig.php");

if(is_array($_POST['Particulars'])){
	$part=$_POST['Particulars'];
	$qty=$_POST['Quantity'];
$size=sizeof($part);
$Total=0;
$Amount[]=0;
$disamount=0;
for($i=0;$i<$size;$i++){
	$qu3=mysqli_query($db,"SELECT * FROM particulars where Description='$part[$i]'");
	while ($row=$qu3->fetch_assoc()) {
		$price[$i]=$row['Price'];
		$Amount[$i]=$price[$i]*$qty[$i];
	}
	$Total+=$Amount[$i];
}

$patid=$_POST['patid'];
$billtype=$_POST['billtype'];
$InsuranceName=$_POST['InsuranceName'];
$InsuranceNo=$_POST['InsuranceNo'];
$bdate=$_POST['bdate'];
$btime=$_POST['btime'];
$payable=$Total-$disamount;
}
else if(is_array($_POST['Epart'])){
$part=$_POST['Epart'];
$qty=$_POST['qty'];
$price=$_POST['price'];
$size=$_POST['size'];
$patid=$_POST['patid'];
$billtype=$_POST['billtype'];
$InsuranceName=$_POST['InsuranceName'];
$InsuranceNo=$_POST['InsuranceNo'];
$bdate=$_POST['bdate'];
$btime=$_POST['btime'];
$Total=0;
for($i=0;$i<$size;$i++){
$Amount[$i]=$price[$i]*$qty[$i];
$Total+=$Amount[$i];

}
$payable=$Total-$disamount;

}

$advanceAmount=0;
$advance=mysqli_query($db,"SELECT * FROM advance WHERE PatId='$patid'");
while($row=$advance->fetch_assoc()){
    $advanceAmount+=$row['Amount'];
}


$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'];
$ipd = "IN";
} 
}
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>
<style>
body{
    font-weight:bold;
}
.table td, .table th {
    padding: 2px;
}
 @media print {
  #printPageButton, #index {
    display: none;
  }
}

 @media print
{
  .button
  {
    display: none;
  }
}
</style>

</head>
<body>

<section>
    <button  type="button" id="printPageButton" class="btn btn-primary" onclick="window.print()" >Print</button> &nbsp;&nbsp;&nbsp;
            <a href="index.php"><button type="button" id="index" class="btn btn-primary">Home</button></a>
	<div class="row">
	    
		<div class="col-md-1"></div>
		<div class="col-md-10">
			

	<div class="">
		<div class="row">
			<div class="col-md-3">
				<img src="assets/img/logo.png" style="width:196px">
			</div>
			
			<div class="col-md-6">
			<p style="text-align:center;margin:0px">
	  <label style="font-size: 19pt;"> <b>Vidyaranya Hospital PVt LTD.</b> </label><br/>
	  <label> 2876, 4th Cross, NS Road, Chamundipuram,<br> Mysuru, Karnataka 570004/label><br/>
	  <label><b>Ph no:</b> +91-821 233 1655, +91-821 233 0555, +91 9035933963</label><br/>
	  <label style="font-size:15pt"><b><?php if($ipd == 'IN'){ echo $ipd; }else{ echo "OUT"; } ?> PATIENT BILL</b></label>
	  </p>
			
			<!--<table>
			<tr>
				<td valign="top">Address</td>
			    <td>:4th Cross Road, 7th Main Road, #13, KRS Rd, Brindavan Extension, Mysuru, Karnataka 570020</td>
			</tr>
			<tr>
				<td valign="top">Website</td>
				<td>:www.newpriyadarshinihospital.com</td>
			</tr>
			<tr>
				<td valign="top">Contact</td>
				<td>:+91-76194 27745, 0821- 2413976</td>
			</tr>
			<tr>
				<td>Unit</td>
				<td>:Mysore</td>
			</tr>

		</table>-->
			</div>
			<div class="col-md-3"></div>
		</div>
<hr style="margin-top:0px;margin-bottom:0px">
<div class="row">
	<div class="col-md-6">
		<table id="_editable_table">
		<tr data-row-id="<?php echo $patid;?>">
			<td valign="top"><b>Patient Id</b></td>
			<td valign="top">: <? echo $patid;?></td>
		</tr>
	<tr >
		<td valign="top"><b>Name</b></td>
		<td valign="top" class="editable-col" contenteditable="true" col-index='0' oldVal="<?php echo $title . ' ' . $Pname; ?>">: <?php echo $title . ' ' . $Pname; ?></td>

	</tr>
	<tr>
		<td valign="top"><b>Contact No.</b></td>
		<td valign="top">: <? echo $contact1;?></td>
	</tr>
	<!--<tr>
		<td valign="top"><b>Email Id</b></td>
		<td valign="top">: <? echo $email;?></td>
	</tr>-->
	<tr>
		<td valign="top"><b>Address</b></td>
		<td valign="top">: <? echo $Address;?></td>
	</tr>

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

	<tr>
		<td valign="top"><b>Consultant</b></td>
		<td valign="top">: <? echo $Consultant;?></td>
		
	</tr>
	<tr>
		<td valign="top"><b>Patient Type</b></td>
		<td valign="top">: <? echo $PatientType;?></td>
	</tr>
	<tr>
		<td valign="top"><b>Admit Date/Time</b></td>
		<td valign="top">: <? echo $AdmitDate.", ".$AdmitTime;?></td>
	</tr>
	<tr>
	    <td valign="top"><b>Bill Type:</b></td>
	    <td valign="top">: <? echo $billtype?></td>
	</tr>
	<tr>
	    <td valign="top"><b>Bill Date-Time:</b></td>
	    <td valign="top">: <? echo $bdate.", ".$btime;?></td>
	</tr>
	<!--<tr>-->
	<!--	<td valign="top"><b>Bill Type/Bill Date-Time</b></td>-->
	<!--	<td valign="top">: <? echo $billtype."/ ".$bdate.", ".$btime;?></td>-->
	<!--</tr>	-->
		<?if($billtype=="Insurance"){
    	echo "<tr><td style='font-weight: bolder;'>Insurance Name:</td>";
    	echo "<td valign='top'>:$InsuranceName</td></tr>";
    	
    	echo "<tr><td style='font-weight: bolder;'>Insurance Number:</td>";
    	echo "<td valign='top'>$InsuranceNo</td></tr>";
    	}?>
</table>
	</div>
<?}else{?>
		<div class="col-md-6">
		<table>		
	<tr>
		<td valign="top"><b>Gender/Age</b></td>
		<td valign="top">: <? echo $gender."/ ".$age;?></td>
	</tr>

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




</div>

<table class="table table-hover mt-5">
	<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>
		<th scope="col">Amount</th>
	</thead>
	<tbody>
		<?
		for($i=0;$i<$size;$i++){
			$j=$i+1;
			echo "<tr><td>$j</td>";
			echo "<td class='editable-col' contenteditable='true' col-index='0' oldVal =".$part.">$part[$i]</td>";
			echo "<td class='editable-col' contenteditable='true' col-index='0' oldVal =".$Consultant.">$Consultant</td>";
			echo "<td class='editable-col' contenteditable='true' col-index='0' oldVal =".$qty.">$qty[$i]</td>";
			echo "<td class='editable-col' contenteditable='true' col-index='0' oldVal =".$price.">$price[$i]</td>";
			echo "<td class='editable-col' contenteditable='true' col-index='0' oldVal =".$Amount.">$Amount[$i]</td>";
			 //"<td><a type='button' class='btn btn-primary edit' data-toggle='modal' data-target='#exampleModal'>Edit</a></td>";
		echo "</tr>";
	
		}
	?>	

		<tr>
			<td></td>
			<td></td>
			<td></td>
			<td></td>
			<td>Sub Total</td>
			<td class="editable-col" contenteditable="true" col-index='0' oldVal ="<?php echo $Total;?>"><? echo $Total;?></td>
		</tr>
	


	</tbody>
</table>
<div class="row">
	<div class="col-md-6"></div>
	<div class="col-md-5">
		<table class="table" style="
    width: 65%;
    margin-left: 175px;
">
	<tr>
		<td><b>Total Bill Amount:</b></td>
		<td><b class="editable-col" contenteditable="true" col-index='0' oldVal ="<?php echo $Total;?>"><? echo $Total;?></b></td>
	</tr>
	
	<tr>
		<td><b>Advance :</b></td>
		<td class="editable-col" contenteditable="true" col-index='0' oldVal ="<?php echo $advanceAmount;?>"><b>
		    <? echo $advanceAmount;?>
		    </b></td>
	</tr>
    <?php
   
        function getIndianCurrency(float $number)
        {
            $decimal = round($number - ($no = floor($number)), 2) * 100;
            $hundred = null;
            $digits_length = strlen($no);
            $i = 0;
            $str = array();
            $words = array(0 => '', 1 => 'one', 2 => 'two',
                3 => 'three', 4 => 'four', 5 => 'five', 6 => 'six',
                7 => 'seven', 8 => 'eight', 9 => 'nine',
                10 => 'ten', 11 => 'eleven', 12 => 'twelve',
                13 => 'thirteen', 14 => 'fourteen', 15 => 'fifteen',
                16 => 'sixteen', 17 => 'seventeen', 18 => 'eighteen',
                19 => 'nineteen', 20 => 'twenty', 30 => 'thirty',
                40 => 'forty', 50 => 'fifty', 60 => 'sixty',
                70 => 'seventy', 80 => 'eighty', 90 => 'ninety');
            $digits = array('', 'hundred','thousand','lakh', 'crore');
            while( $i < $digits_length ) {
                $divider = ($i == 2) ? 10 : 100;
                $number = floor($no % $divider);
                $no = floor($no / $divider);
                $i += $divider == 10 ? 1 : 2;
                if ($number) {
                    $plural = (($counter = count($str)) && $number > 9) ? 's' : null;
                    $hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
                    $str [] = ($number < 21) ? $words[$number].' '. $digits[$counter]. $plural.' '.$hundred:$words[floor($number / 10) * 10].' '.$words[$number % 10]. ' '.$digits[$counter].$plural.' '.$hundred;
                } else $str[] = null;
            }
            $Rupees = implode('', array_reverse($str));
            $paise = ($decimal > 0) ? "." . ($words[$decimal / 10] . " " . $words[$decimal % 10]) . ' Paise' : '';
            return ($Rupees ? $Rupees . 'Rupees ' : '') . $paise;
        }
        
    ?>
	
	<tr>
		<td><b>Patient Payable Amount :</b></td>
		<td contenteditable="true" col-index='0' oldVal ="<?php echo $final;?>"><b><? echo $final =$payable-$advanceAmount;?></b></td>
	</tr>
</table>
<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Modal title</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
        ...
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        <button type="button" class="btn btn-primary">Save changes</button>
      </div>
    </div>
  </div>
</div>

	</div>
	<div class="col-md-1">
	    
	</div>
	<div>
      <h6 style="font-weight:bold; margin-left:15px" contenteditable="true" col-index='0' oldVal ="<?php echo getIndianCurrency($final);?>"><?php echo getIndianCurrency($final); ?></h6>
  </div>
</div>
<br><br>
<p>Prepared by <? echo $name?></p><br><br>
<div class="row">
	<div class="col-md-1"></div>
	<div class="col-md-7">
	</div>
	<div class="col-md-4">

		<h6 style="
    font-weight: bolder;
">Authorized Signatory</h6>
	</div>
</div>
<br><br><br><br>

		</div>
		<div class="col-md-1"></div>
		
	</div>
</div>
    <div class="row justify-content-center">
        <div class="col-md-6">
            <button  type="button" id="printPageButton" class="btn btn-primary" onclick="window.print()" >Print</button> &nbsp;&nbsp;&nbsp;
            <a href="index.php"><button type="button" id="index" class="btn btn-primary">Home</button></a>
        </div>
    </div>
<div class="row">
	

<form action="store.php" method="POST">
	<?
	foreach($part as $value)
{
    echo '<input type="hidden" name="part[]" value="'. $value. '">';
}
	foreach($qty as $value)
{
    echo '<input type="hidden" name="qty[]" value="'. $value. '">';
}
	foreach($Amount as $value)
{
    echo '<input type="hidden" name="Amount[]" value="'. $value. '">';
}
	foreach($price as $value)
{
    echo '<input type="hidden" name="price[]" value="'. $value. '">';
}
?>
	<input type="hidden" name="size" value="<? echo $size;?>">
	<input type="hidden" name="Total" value="<? echo $Total;?>">
	<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="payable" value="<? echo $payable;?>">
	<input type="hidden" name="patienttype" value="<? echo $PatientType;?>">
	<input type="hidden" name="preparedby" value="<? echo $name;?>">
	<input type="hidden" name="InsuranceName" value="<? echo $InsuranceName;?>">
	 <input type="hidden" name="InsuranceNo" value="<? echo $InsuranceNo;?>">

<div style="text-align: center;">
	

	 <!--<button type="submit" class="btn btn-primary">Confirm and Save</button>-->
</div>
</form>
<form action="EditBill.php" method="POST">
	<?
	foreach($part as $value)
{
    echo '<input type="hidden" name="part[]" value="'. $value. '">';
}
	foreach($qty as $value)
{
    echo '<input type="hidden" name="qty[]" value="'. $value. '">';
}
	foreach($Amount as $value)
{
    echo '<input type="hidden" name="Amount[]" value="'. $value. '">';
}
	foreach($price as $value)
{
    echo '<input type="hidden" name="price[]" value="'. $value. '">';
}
?>
	<input type="hidden" name="size" value="<? echo $size;?>">
	<input type="hidden" name="Total" value="<? echo $Total;?>">
	<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="payable" value="<? echo $payable;?>">
	<input type="hidden" name="patienttype" value="<? echo $PatientType;?>">
	<input type="hidden" name="preparedby" value="<? echo $name;?>">
	<input type="hidden" name="InsuranceName" value="<? echo $InsuranceName;?>">
	 <input type="hidden" name="InsuranceNo" value="<? echo $InsuranceNo;?>">

<div style="text-align: center;">
	


    
</div>
</form>

</div>


</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>
  <script>
      $(document).ready(function(){
          $('td.editable-col').on('focusout', function() {
            data = {};
            data['val'] = $(this).text();
            data['id'] = $(this).parent('tr').attr('data-row-id');
            data['index'] = $(this).attr('col-index');
              
            
          });
          
          
            $('.edit').on('click', function(){

                $('#edit_category').modal('show');

                $tr = $(this).closest('tr');
                var data = $tr.children("td").map(function(){                
                    return $(this).text();
                }).get();
                console.log(data);
                $("#category_id").val(data[1]);
                $("#edit_category_name").val(data[2]);
            });
      });
  </script>
</body>
</html>
