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

if(isset($_GET['Billno'])) {
    $billno = $_GET['Billno'];

    $qu1 = mysqli_query($db, "SELECT * FROM bill WHERE BillNo='$billno'");
    
    if ($qu1 && mysqli_num_rows($qu1) > 0) {
        $row = $qu1->fetch_assoc();

        // Checking and assigning variables
        $patid = $row['PatientId'] ?? null;
        $disamount = $row['DiscountAmount'] ?? 0; // Default to 0 if not set
        $Total = $row['TotAmount'] ?? 0;
        $payable = $row['PayableAmount'] ?? 0;
        $billtype = $row['PaymentMode'] ?? '';
        $iname = $row['InsuranceName'] ?? '';
        $ino = $row['InsuranceNo'] ?? '';
         $bank = $row['bank'] ?? '';
        $card = $row['card'] ?? '';
         $upi = $row['upi'] ?? '';
        $cash = $row['cash'] ?? '';
        $bdate = $row['BDate'] ?? '';
        $btime = $row['BTime'] ?? '';
    } else {
        echo "No bill found with BillNo: $billno";
        exit;
    }

    $qu4 = mysqli_query($db, "SELECT * FROM patientdetails WHERE PatId='$patid'");
    
    if ($qu4 && mysqli_num_rows($qu4) > 0) {
        $row = $qu4->fetch_assoc();
        
        // Assign patient details
        
         $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 = $row['PatientType'] ?? '';
        $AdmitDate = $row['AdmitDate'] ?? '';
        $AdmitTime = $row['AdmitTime'] ?? '';
    } else {
        echo "No patient details found for PatientId: $patid";
        exit;
    }
  }
?>

<!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>
    @media print {
  #printPageButton {
    display: none;
  }
  #edt{
    display:none;
      
  }
  }
}
</style>
</head>
<body>

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

  <div style="margin:5%">
    <div class="row">
      <div class="col-md-3">
        <img src="assets/img/logo.png">
      </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> #13, 4th Cross Road, 7th Main Road,<br/>KRS Rd, Brindavan Extension, Mysuru, Karnataka 570020</label><br/>
	  <label><b>Ph no:</b> +91-821 233 1655</label><br/>

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

	  <!--<label style="font-size:15pt"><b>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>
<div class="row">
<div class="col-md-6">
    <table>
        <tr>
            <td valign="top">Bill Number</td>
            <td valign="top">: <?php echo $billno; ?></td>
        </tr>
        <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 $title . ' ' . $Pname; ?></td>
        </tr>
        <tr>
            <td valign="top">Contact No.</td>
            <td valign="top">: <?php echo $contact1; ?></td>
        </tr>
        <tr>
            <td valign="top">Email Id</td>
            <td valign="top">: <?php echo $email; ?></td>
        </tr>
        <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</td>
            <td valign="top">: <?php echo $PatientType; ?></td>
        </tr>
        <tr>
            <td valign="top">Admit Date/Time</td>
            <td valign="top">: <?php echo $AdmitDate . ", " . $AdmitTime; ?></td>
        </tr>
        <tr>
            <td valign="top"><!--Bill Type/Bill Date-Time-->Payment Mode/Discharge Date-Time</td>
            <td valign="top">: <?php echo $billtype . "/ " . $bdate . ", " . $btime; ?></td>
        </tr>  
        <?php
        if ($billtype == "Insurance") {
            echo "<tr><td>Insurance Name / Number</td>";
            echo "<td>: $iname, $ino</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">Quantity</th>
        <th scope="col">Unit Price</th>
        <th scope="col">Amount</th>
    </thead>
    <tbody>
        <?php
        $i = 1;
        $qu2 = mysqli_query($db, "SELECT * FROM billparticulars WHERE BillNo='$billno'");
        while ($row = $qu2->fetch_assoc()) {
        ?>
            <tr>
                <td><?php echo $i; ?></td>
                <td><?php echo $row['Particulars']; ?></td>
                <td><?php echo $row['consultant']; ?></td>
                <td><?php echo $row['Quantity']; ?></td>
                <td><?php echo $row['UnitPrice']; ?></td>
                <td><?php echo $row['Amount']; ?></td>
                 <td id="edt"><a href="editbills.php?sl=<?php echo $row['SlNo']; ?>&Billno=<?php echo $billno; ?>">Edit</a></td> 
            </tr>
        <?php
            $i++;
        }
        ?>
        <tr>
            <td></td>
            <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>Total Bill Amount</td>
                <td><?php echo $Total; ?></td>
            </tr>
            <tr>
                <td>Insurance Claim</td>
                <td><?php echo $disamount; ?></td>
            </tr>
            <tr>
                <td>Patient Payable Amount</td>
                <td><?php echo $payable; ?></td>
            </tr>
        </table>
    </div>
</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">

     <h6>Authorized Signatory</h6>
     <br>
<h6>Prepared by <?php echo $name; ?></h6>
  </div>
</div>
<br><br><br><br>

    </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>
</body>
</html>


<?

?>

