<?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(isset($_GET['PatId'])){
$patientId=$_GET['PatId'];

  $query=mysqli_query($db,"SELECT * FROM patientdetails WHERE PatId='$patientId' ");
if(mysqli_num_rows($query)==0){
  echo "<script>alert('Incorrect Patient ID or Contact Number!')</script>"; 
    $url="https://vidyaranyahospital.in/Billing/FinaleBillId.php";
echo "<meta http-equiv=\"refresh\" content=\"0;url=$url\" />";
}
else{
    



 while($row=$query->fetch_assoc()){
$patid=$row['PatId'];
$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=$row['PatientType'];
$CaseType=$row['CaseType'];
$AdmitDate=$row['AdmitDate'];
$AdmitTime=$row['AdmitTime'];
$discount=$row['DiscountAmount'];

}
$advanceAmount=0;
$advance=mysqli_query($db,"SELECT * FROM advance WHERE PatId='$patid'");
while($row=$advance->fetch_assoc()){
    $advanceAmount+=$row['Amount'];
}
$res1=mysqli_query($db,"SELECT * FROM bill where PatientId='$patid'");
if(mysqli_num_rows($res1)!=0){
  while($row=$res1->fetch_assoc()){
    $BillNo[]=$row['BillNo'];
  }
}

?>
<!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 type="text/css">
.nav-menu a {
    padding: 3px 3px;
}

.footer {
   position: fixed;
   left: 0;
   bottom: 0;
   width: 100%;
   background-color: #efe8e8;
   color: black;
   text-align: center;
   padding:4px;
   font-size:12px;
}.footer a{
  font-weight: bold;
  color:#0c0c67;
}
  .hide {
  display: none;
}
h4{
  padding-top: 5px;
  padding-bottom: 0px;
  color:#1abfbf;
  font-weight: bold;
}
hr{
  background-color:#1abfbf;
}
</style>

</head>
<body>
    <div class="row" id="printPageButton" style="margin:5%">
  <button  type="button" class="btn btn-primary" onclick="window.print()" >Print</button> &nbsp;&nbsp;&nbsp;
<button type="button" class="btn btn-primary" onclick="history.back()">Back</button>&nbsp;&nbsp;&nbsp;
</div> 
  <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-6 col-sm-6">
                <h3> <img src="assets/img/logo.png" style="width:90px;">Vidyaranya Hospital PVt LTD</h3>
              </div>
              <!--<div class="col-md-1"></div>-->
              <div class="col-md-6  col-sm-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>: vidhyaranyahospital.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>
    <div class="row">
	      <div class="col-md-12 text-center mt-3">
	           <? if($PatientType=="OPD"){
       echo '<label style="font-size:15pt"><b>OUT PATIENT BILL</b></label>';
      
  }
		elseif($PatientType=="IPD"){
		echo '<label style="font-size:15pt"><b>IN PATIENT BILL</b></label>';
		}
		else{
		echo '<label style="font-size:15pt"><b>PATIENT BILL</b></label>';
		}
  ?>
	      </div>
	  </div>
	  <!--<label style="font-size:15pt"><b>OUT PATIENT BILL</b></label>-->
	  </p>
<hr>
<div class="row">
  <div class="col-md-6">
    <table>
    <tr>
      <td valign="top">Patient Id</td>
      <td valign="top">: <?php echo $patid;?></td>
    </tr>
  <tr>
    <td valign="top">Name</td>
    <td valign="top">: <?php echo $Pname;?></td>
  </tr>
  <tr>
    <td valign="top">Contact No.</td>
    <td valign="top">: <?php echo $contact1;?></td>
  </tr>
  <?php if($email!=""){?>
  <tr>
    <td valign="top">Email Id</td>
    <td valign="top">: <?php echo $email;?></td>
  </tr>
  <?php }?>
  <tr>
    <td valign="top">Address</td>
    <td valign="top">: <?php echo $Address;?></td>
  </tr>

</table>
  </div>
  <div class="col-md-6">
    <table>   
  <tr>
    <td valign="top">Gender/Age/Blood Group</td>
    <td valign="top">: <?php echo $gender."/ ".$age." Years/ ".$blood;?></td>
  </tr>

  <tr>
    <td valign="top">Consultant</td>
    <td valign="top">: <?php echo $Consultant;?></td>
  </tr>
  <tr>
    <td valign="top">Patient Type/Case Type</td>
    <td valign="top">: <?php echo $PatientType."/ ".$CaseType;?></td>
  </tr>
  <tr>
    <td valign="top">Admit Date/Time</td>
    <td valign="top">: <?php echo $AdmitDate.", ".$AdmitTime;?></td>
  </tr>
  <tr>
    <td valign="top">Payment Mode/Discharge Date-Time</td>
    <td valign="top">: <?php echo $paymentmode."/ ".$disDate.", ".$disTime;?></td>
  </tr>  
  <?php if($paymentmode=="Insurance"){
  echo "<tr><td>Insurance Name / Number</td>";
  echo "<td>:$InsuranceName, $InsuranceNo</td></tr>";
  }?>
</table>
  </div>
</div>
<br>


<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">Amount</th>
  </thead>
  
    <?php
        $i=1;
        $advance2=mysqli_query($db,"SELECT * FROM advance WHERE PatId='$patid'");
        while($row=$advance2->fetch_assoc()){
            $advanceAmount2+=$row['Amount'];
        
    ?>
    <tr>
        <td><?php echo $i; ?></td>
        <td><?php echo "Advance"; ?></td>
        <td><?php echo $Consultant; ?></td>
        <td><?php echo $row['Amount']; ?></td>
    </tr>
    <?php
    $i++;
        } 
    ?>

    <!--<tr>-->
    <!--  <td></td>-->
    <!--  <td></td>-->
    <!--  <td></td>-->
    <!--  <td>Sub Total</td>-->
    <!--  <td><?php echo $total;?></td>-->
    <!--</tr>-->
  </tbody>
</table>

<div class="row">
  <div class="col-md-6"></div>
  <div class="col-md-6">
    <table class="table table-bordered">
  
   <tr>
    <td>Advance Amount</td>
    <td><?php echo $advanceAmount2;?></td>
  </tr>
  
</table>
    <?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;
        }
        
    ?>

  </div>
</div>
<div>
      <h6 style="font-weight:bold"><?php echo getIndianCurrency($advanceAmount2)." only/-"; ?></h6>
    </div>
<br><br><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>

<form action="store.php" method="POST">
  <input type="hidden" name="FPatientId" value="<?php echo $patid;?>">
  <input type="hidden" name="AdmitDate" value="<?php echo $AdmitDate;?>">
  <input type="hidden" name="AdmitTime" value="<?php echo $AdmitTime;?>">
  <input type="hidden" name="DischargeDate" value="<?php echo $disDate;?>">
  <input type="hidden" name="DischargeTime" value="<?php echo $disTime;?>">
  <input type="hidden" name="DiscountAmount" value="<?php echo $discount;?>">
  <input type="hidden" name="FAdvanceAmount" value="<?php echo $advanceAmount;?>">
  <input type="hidden" name="paymentmode" value="<?php echo $paymentmode;?>">
  <input type="hidden" name="TotalAmount" value="<?php echo $total;?>">
  <input type="hidden" name="PayableAmount" value="<?php echo $payable;?>">
  <input type="hidden" name="preparedby" value="<?php echo $name;?>">
   <input type="hidden" name="InsuranceName" value="<?php echo $InsuranceName;?>">
   <input type="hidden" name="InsuranceNo" value="<?php echo $InsuranceNo;?>">
  
  </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>
<?php

}}
?>