<?php
include("dbConfig.php");
session_start();
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['amount'])) {
  $amount = $_GET['amount'];
  $patid = $_GET['PatId'];
  $date = $_GET['addate'];
  $mode = $_GET['mode'];
  $iname = $_GET['iname'];
  $ino = $_GET['ino'];
  $card = $_GET['card'];
  $bank = $_GET['bank'];
  $upi = $_GET['upi'];
  $cash = $_GET['cash'];
  $upiid = $_GET['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'];
  }
}



?>
<!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>
    .finaltable {
      border-top: 1px solid black;
      border: 1px solid black;
    }

    .finaltable th {
      border-top: 1px solid black;
      border: 1px solid black;
    }

    .finaltable td {
      border-top: 1px solid black;
      border: 1px solid black;
    }

    .finaltable thead tr {
      border-bottom: 3px solid black;

    }

    @media print {
      #printPageButton {
        display: none;
      }
    }

    .spanfont {
      font-size: 20px;
    }
  </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;
      <a href="index.php"><button type="button" class="btn btn-primary">Home</button></a>
    </div>

    <div style="margin:5%">
      <div class="row">
        <div class="col-md-6 col-sm-6">
          <img src="assets/img/logo.png">
          <span class="spanfont"><b>Vidhyaranya Hospital PVT LTD.</b></span>
        </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>:www.vidhyaranya</td>
            </tr>
            <tr>
              <td valign="top">Contact</td>
              <td>:+91-821 233 1655, +91-821 233 0555, +91 9035933963</td>
            </tr>
            <tr>
              <td>Unit</td>
              <td>:Mysore</td>
            </tr>

          </table>
        </div>
      </div>


      <div class="row text-center mt-3">
        <div class="col-md-12">
          <label style="font-size:15pt"><b>IN PATIENT BILL</b></label>
        </div>
      </div>
      <hr>
      <div class="row d-flex justify-content-between">
        <div class="col-md-6 col-sm-6 row1 text-left">
          <hr />
          <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 $title . ' ' . $Pname; ?></td>
            </tr>
            <tr>
              <td valign="top">Contact</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>
<?php
// Fetch BillNo
$AdvanceAmount = $_GET['amount'];
$query = "SELECT BillNo FROM advance WHERE PatId = '$patid' AND Amount = '$AdvanceAmount' ORDER BY AdvanceDate DESC, advanceTime DESC LIMIT 1";
$result = mysqli_query($db, $query);

if ($row = mysqli_fetch_assoc($result)) {
    $BillNo = $row['BillNo'];
} else {
    $BillNo = "Not Found"; // Fallback if no BillNo is found
}
?>

    <tr>
        <td valign="top"><b>Bill Number</b></td>
        <td valign="top">:<b> <?php echo $BillNo; ?></b></td>
    </tr>


          </table>
        </div>
        <div class="col-md-6 col-sm-6 row2">
          <table>
            <hr />
            <tr>
              <td valign="top">Gender/Age/Blood Group</td>
              <td valign="top">: <?php echo $gender . "/ " . $age . " / " . $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 . ", " . date("H:i A", strtotime($AdmitTime)); ?></td>
            </tr>
            <?php
            $AdvanceAmount = $_GET['amount'];
            $query = "SELECT AdvanceDate, advanceTime FROM advance WHERE PatId = '$patid' AND Amount = '$AdvanceAmount' ORDER BY AdvanceDate DESC, advanceTime DESC LIMIT 1";
            $result = mysqli_query($db, $query);

            // Check if the result is fetched
            if ($row = mysqli_fetch_assoc($result)) {
              $advanceDate = $row['AdvanceDate'];
              $advanceTime = $row['advanceTime'];
              $modeAndDate = $mode . " / " . $advanceDate . " " . date("H:i A", strtotime($advanceTime));
            } else {
              $modeAndDate = $mode . " / Not Found"; // Fallback if no data is found
            }
            ?>
            <tr>
              <td valign="top">Payment Mode/Bill Date</td>
              <td valign="top">: <?php echo $modeAndDate; ?></td>
            </tr>
            <?php if ($mode == "Insurance") {
              echo "<tr><td>Insurance Name / Number</td>";
              echo "<td>:$iname, $ino</td></tr>";
            }

            if ($mode == "Card") {
              echo "<tr><td>Bank Name / Card Number</td>";
              echo "<td>:$bank, $cardno</td></tr>";
            }

            if ($mode == "Cash and UPI") {
              echo "<tr><td>Upi Amount / Cash Amount</td>";
              echo "<td>:$upi, $cash</td></tr>";
            }
            ?>
          </table>
        </div>
      </div>

      <br /><br />
      <table class="table table-hover finaltable">
        <thead>
          <th scope="col">Sl No.</th>
          <th scope="col">Particulars</th>
          <th scope="col">Consultant</th>
          <th scope="col">Amount</th>
        </thead>
        <tbody>
          <?php
          $i = 1;
          echo "<tr><td>$i</td>";
          echo "<td>Advance</td>";
          echo "<td>$Consultant</td>";
          echo "<td>$amount</td>";
          echo "</tr>";
          $i++;


          ?>
          <tr></tr>
          <tr>


            <td></td>
            <td></td>
            <td style="text-align:right;"><strong>Amount Paid</strong></td>
            <td><strong><?php echo $amount; ?></strong></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;
          }

          ?>

        </tbody>
      </table>



      <br>
      <div>
        <h6 style="font-weight:bold"><?php echo getIndianCurrency($amount) . " only/-"; ?></h6>
      </div>
      <div class="row mt-5">

        <div class="col-md-3">

        </div>
        <div class="col-md-6"></div>
        <div class="col-md-3">
          Authorized Signatory</h6>
          <br><br>
          <h6>Prepared by <?php echo $name ?></h6>
        </div>
      </div>


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