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

    $qu1 = mysqli_query($db, "SELECT * FROM bill where BillNo='$billno'");
    while ($row = $qu1->fetch_assoc()) {
      $patid = $row['PatientId'];
      $disamount = $row['DiscountAmount'];
      $Total = $row['TotAmount'];
      $payable = $row['PayableAmount'];
      $billtype = $row['PaymentMode'];
      $iname = $row['InsuranceName'];
      $ino = $row['InsuranceNo'];
      $bdate = $row['BDate'];
      $btime = $row['BTime'];
    }

    $qu4 = mysqli_query($db, "SELECT * FROM patientdetails WHERE PatId='$patid'");
    while ($row = $qu4->fetch_assoc()) {
      $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'];
    }

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

  ?>
<!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;
      }
    }

    .table {
      border: 2px solid black;
    }



    .table td,
    .table th {
      padding: 2px;
    }

    .table td,
    .patient_details {
      font-weight: bold;
      font-size: 1em;
    }

    .tabel-first tr td {
      border: 2px solid black;
    }

    .tabel-first thead tr th {
      border-bottom: 2px solid black;
      border: 2px solid black;
    }

    .total-b tr td {
      border: 2px solid black;
    }

    #patient_details {
      font-weight: bold;
      font-size: 1em;
    }
  </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-3"></div>
        <div class="col-md-6">
          <table class="patient_details">
            <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- 2330113</td>
            </tr>
            <tr>
              <td>Unit</td>
              <td>:Mysore</td>
            </tr>

          </table>
        </div>
      </div>
      <div class="row">
        <div class="col-md-12 text-center">
          <?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>';
          }
          ?>
        </div>
      </div>

      <hr>
      <div class="row">
        <div class="col-md-6">
          <table class="patient_details">
            <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 $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 class="patient_details">
            <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</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 tabel-first">
        <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>

            </tr>

          <?php
            $i++;
          }

          ?>

          <tr>

            <td colspan="4"></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 total-b">
            <tr>
              <td>Total Bill Amount</td>
              <td><?php echo $Total; ?></td>
            </tr>


            <tr>
              <td>Patient Payable Amount</td>
              <td><?php echo $payable ?></td>
            </tr>
          </table>


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

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


<?php
  }
?>