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

// Enable error reporting for debugging (optional)
error_reporting(E_ALL);
ini_set('display_errors', 1);

// Function to convert number to Indian currency format
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;
}

// Retrieve data from the examination table
$patid = isset($_GET['PatId']) ? $_GET['PatId'] : null;
if (!$patid) {
    echo "Patient ID is required.";
    exit();
}

// Fetch patient details
$patientQuery = "SELECT * FROM patientdetails WHERE PatId='$patid'";
$patientResult = mysqli_query($db, $patientQuery);
if (mysqli_num_rows($patientResult) != 0) {
    $patientData = mysqli_fetch_assoc($patientResult);
    $title = $patientData['title'];
    $Pname = $patientData['Name'];
    $contact1 = $patientData['Contact'];
    $email = $patientData['Email'];
    $dob = $patientData['Dob'];
    $age = $patientData['Age'];
    $gender = $patientData['Gender'];
    $blood = $patientData['BloodGroup'];
    $Address = $patientData['Address'];
    $Consultant = $patientData['Consultant'];
    $PatientType = "IPD";
    $AdmitDate = $patientData['AdmitDate'];
    $AdmitTime = $patientData['AdmitTime'];
} else {
    echo "No patient found with the provided ID.";
    exit();
}
$billNo = $_GET['billNo'];
// Fetch examination details
$examQuery = "SELECT * FROM examination WHERE BillNo='$billNo' AND PatId='$patid'";
$examResult = mysqli_query($db, $examQuery);

$examData = [];
while ($row = mysqli_fetch_assoc($examResult)) {
  $examData[] = $row;
}
?>
<!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;
      }
    }
       @media print {
            .finaltable th:nth-child(8),
            .finaltable td:nth-child(8) {
                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:4%">
      <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">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> PATIENT EXAMINATION 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
$examQuery = "SELECT BillNo FROM examination WHERE BillNo='$billNo' AND PatId='$patid' LIMIT 1";
$examResult = mysqli_query($db, $examQuery);

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

    <tr>
        <td valign="top"><b>Bill Number</b></td>
        <td valign="top">:<b> <?php echo $fetchedBillNo; ?></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>
            <tr>
              <td valign="top">Bill Date/Time</td>
              <td valign="top">: <?php
                                  if (!empty($examData[0])) {
                                    $firstRow = $examData[0];
                                    if (!empty($firstRow['BDate']) || !empty($firstRow['BTime'])) {
                                      $bDate = !empty($firstRow['BDate']) ? $firstRow['BDate'] : '';
                                      $bTime = !empty($firstRow['BTime']) ? date('H:i A', strtotime($firstRow['BTime'])) : '';
                                      echo trim($bDate . ($bDate && $bTime ? ', ' : '') . $bTime);
                                    } else {
                                      echo 'No date & time available';
                                    }
                                  }
                                  ?></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">Department</th>
        <th scope="col">Quantity</th>
        <th scope="col">Price</th>
        <th scope="col">Amount</th>
         <th scope="col">Action</th>
    </thead>
    <tbody>
        <?php
        $i = 1;
          $totalAmount = 0;
          foreach ($examData as $row) {
            $SINo = $row['SlNo'];
            $particulars = !empty($row['Particulars']) ? $row['Particulars'] : 'N/A';
            $consultant = $row['consultant'];
            $department = $row['optionlab'];
            $quantity = round($row['Quantity']);
            $price = round($row['UnitPrice']);
            $amount = round($row['Amount']);
            $totalAmount += $amount;

            echo "<tr><td>$i</td>";
            echo "<td>$particulars</td>";
            echo "<td>$consultant</td>";
            echo "<td>$department</td>";
            echo "<td>$quantity</td>";
            echo "<td>$price</td>";
            echo "<td>$amount</td>";
            echo "<td><a href='update_examination.php?SlNo={$row['SlNo']}'>Edit</a>
          </td></tr>";
            $i++;
          }
        ?>
        <tr>
            <td colspan="6" style="text-align:right;"><strong>Total Amount</strong></td>
            <td><strong><?php echo $totalAmount; ?></strong></td>
        </tr>
    </tbody>
</table>
<div>
    <h6 style="font-weight:bold"><?php echo getIndianCurrency($totalAmount) . " 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>
   