
  <?php
include("dbconfig.php");

// Check if the bill number is passed in the URL
if (isset($_GET['billno'])) {
    $billno = $_GET['billno'];

    // Fetch all records for this BillNo
    $sql = "SELECT `PatId`, `created_at`, `Particulars`, `Quantity`, `UnitPrice`, `Amount`, `consultant`
            FROM `examination`
            WHERE `BillNo` = '$billno'";
    $result = $db->query($sql);

    // Fetch patient details using PatId
    $sql_patient = "SELECT `title`, `Name` FROM `patientdetails` WHERE `PatId` = (SELECT `PatId` FROM `examination` WHERE `BillNo` = '$billno' LIMIT 1)";
    $patient_result = $db->query($sql_patient);
    $patient_row = $patient_result->fetch_assoc();
    $patient_name = $patient_row['title'] . ' ' . $patient_row['Name'];
    
    // Calculate the grand total
    $sql_total = "SELECT SUM(`Amount`) AS grand_total FROM `examination` WHERE `BillNo` = '$billno'";
    $total_result = $db->query($sql_total);
    $total_row = $total_result->fetch_assoc();
    $grand_total = $total_row['grand_total'];
} else {
    // If no BillNo is passed, redirect to the previous page
    header("Location: index.php");  // or any default page
    exit;
}
?>


    <!DOCTYPE html>
    <html lang="en">
    <meta http-equiv="content-type" content="text/html;charset=UTF-8" />
    <head>
    <title>VH-Amdin</title>

    <link rel="icon" href="images/logo.png" type="image/x-icon" class="abc">
    
    <link rel="icon" type="image/icon" href="images/logo.png" />
    
    <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,400,600,700,800" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css?family=Quicksand:500,700" rel="stylesheet">
    
    <link rel="stylesheet" type="text/css" href="../files/bower_components/bootstrap/css/bootstrap.min.css">
    
    <link rel="stylesheet" href="../files/assets/pages/waves/css/waves.min.css" type="text/css" media="all">
    
    <link rel="stylesheet" type="text/css" href="../files/assets/icon/feather/css/feather.css">
    
    <link rel="stylesheet" type="text/css" href="../files/assets/css/font-awesome-n.min.css">
    
    <link rel="stylesheet" href="../files/bower_components/chartist/css/chartist.css" type="text/css" media="all">
    
    <link rel="stylesheet" type="text/css" href="../files/assets/css/style.css">
    <link rel="stylesheet" type="text/css" href="../files/assets/css/widget.css">
    
    <style>
        .img-fluid {
    max-width: 66%;
    height: auto;
    margin-left: -47px;
}
.pcoded li.pcoded-hasmenu[dropdown-icon=style1]>a:after {
    content: none;
}
.pcoded[theme-layout=vertical] .pcoded-navbar .pcoded-item[item-border=true][item-border-style=solid] li>a {
    border-bottom-style: solid;
    height: 53px;
}
div#c1 {
    background-color: cadetblue;
}
div#c2 {
    background-color: slategrey;
}
div#c3 {
    background-color: salmon;
}
div#c4 {
    background-color: #a549a5;
}
{
    padding-left: 10px;
    font-size: 20px;
}
.pcoded-inner-content{
    font-size:13px;
}
    </style>

    </head>
    <body>
    
    <div class="loader-bg">
    <div class="loader-bar"></div>
    </div>
    
    <div id="pcoded" class="pcoded">
    <div class="pcoded-overlay-box"></div>
    <div class="pcoded-container navbar-wrapper">
    
    <nav class="navbar header-navbar pcoded-header">
    <div class="navbar-wrapper">
    <div class="navbar-logo">
    <a href="index.php">
     <h5>Admin</h5>
    </a>
    <a class="mobile-menu" id="mobile-collapse" href="#!">
    <i class="feather icon-menu icon-toggle-right"></i>
    </a>
    <a class="mobile-options waves-effect waves-light">
    <i class="feather icon-more-horizontal"></i>
    </a>
    </div>
    <div class="navbar-container container-fluid">
    <ul class="nav-left">
    <li class="header-search">
    <div class="main-search morphsearch-search">
    <div class="input-group">

    <input type="text" class="form-control" placeholder="Enter Keyword">

    </div>
    </div>
    </li>
    
    </a>
    </li>
    </ul>
    <ul class="nav-right">
    <li class="header-notification">
    <div class="dropdown-primary dropdown">
   
    <ul class="show-notification notification-view dropdown-menu" data-dropdown-in="fadeIn" data-dropdown-out="fadeOut">
    
    <li>
   
    </li>
    <li>
    
    </li>
    <li>
   
    </li>
    </ul>
    </div>
    </li>
   
    <li class="user-profile header-notification">
    <div class="dropdown-primary dropdown">
    <div class="dropdown-toggle" data-toggle="dropdown">
    <img src="../files/assets/images/avatar-4.jpg" class="img-radius" alt="User-Profile-Image">
    <span>Admin</span>
    <i class="feather icon-chevron-down"></i>
    </div>
    <ul class="show-notification profile-notification dropdown-menu" data-dropdown-in="fadeIn" data-dropdown-out="fadeOut">
   
    <!--<li>-->
    <!--<a href="#">-->
    <!--<i class="feather icon-user"></i> Profile-->
    <!--</a>-->
    <!--</li>-->
    <li>
    <a href="logout.php">
    <i class="feather icon-log-out"></i> Logout
    </a>
    </li>
    </ul>
    </div>
    </li>
    </ul>
    </div>
    </div>
    </nav>
    
    
    
  
   
    <div class="pcoded-main-container">
    <div class="pcoded-wrapper">
    
    <nav class="pcoded-navbar">
    <div class="nav-list">
    <div class="pcoded-inner-navbar main-menu">
    <div class="pcoded-navigation-label">Navigation</div>
    <ul class="pcoded-item pcoded-left-item">
        
    <li class="pcoded-hasmenu ">
        <a href="index.php" class="waves-effect waves-dark">
            <span class="pcoded-micon"><i class="feather icon-home"></i></span>
            <span class="pcoded-mtext">Dashboard</span>
        </a>
    </li>
    
    <li class="pcoded-hasmenu active pcoded-trigger">
        <a href="PatientDetails.php" class="waves-effect waves-dark">
            <span class="pcoded-micon"><i class="fa fa-registered"></i></span>
            <span class="pcoded-mtext">Patient Details</span>
        </a>
    </li>
        <li class="pcoded-hasmenu">
        <a href="StaffDetails.php" class="waves-effect waves-dark">
            <span class="pcoded-micon"><i class="fa fa-registered"></i></span>
            <span class="pcoded-mtext">Staff Details</span>
        </a>
    </li>
                             <li class="pcoded-hasmenu ">
        <a href="javascript:void(0)" class="waves-effect waves-dark">
            <span class="pcoded-micon"><i class="fa fa-users"></i></span>
            <span class="pcoded-mtext">Users</span>
        </a>
            <ul class="pcoded-submenu">
 <li class="">
        <a href="CreateUsers.php" class="waves-effect waves-dark">
           
            <span class="pcoded-mtext">Create Billing Users</span>
        </a>
    </li>
                <li class="">
                    <a href="ViewUsers.php" class="waves-effect waves-dark">
                        <span class="pcoded-mtext">View Billing Users</span>
                    </a>
                </li>
            </ul> 
    </li>
    </ul>
    </div>
    </div>
    </nav>

    <div class="pcoded-content">
            <div class="page-header card">
    <div class="row align-items-end">
    <div class="col-lg-8">
    <div class="page-header-title">
    <i class="feather icon-inbox bg-c-blue"></i>
    <div class="d-inline">
    <h5>Search Bills</h5>
    </div>
    </div>
    </div>
    <div class="col-lg-4">
    <div class="page-header-breadcrumb">
    <ul class=" breadcrumb breadcrumb-title">
    <li class="breadcrumb-item">
    <a href="index.php"><i class="feather icon-home"></i></a>
    </li>
    <li class="breadcrumb-item"><a href="#!">Home</a>
    </li>
    <li class="breadcrumb-item"><a href="#!">Search Bills</a>
    </li>
    
    
    
    
    </ul>
    </div>
    </div>
    </div>
    </div>

    <div class="pcoded-inner-content">
      
    <div class="container mt-5">
        <h2>Examination Details - Bill No: <?php echo $billno; ?></h2>

        <h4>Patient: <?php echo $patient_name; ?></h4>

        <?php
        if ($result && $result->num_rows > 0) {
            // Display the examination records in a table
            echo "<table class='table table-hover table-bordered'>";
            echo "<thead>
                    <tr>
                        <th>Patient ID</th>
                        <th>Bill Date</th>
                        <th>Particulars</th>
                        <th>Quantity</th>
                        <th>Unit Price</th>
                        <th>Consultant</th>
                        <th>Amount</th>
                    </tr>
                  </thead>";
            echo "<tbody>";

            // Loop through all the records for the BillNo
            while ($row = $result->fetch_assoc()) {
                echo "<tr>";
                echo "<td>" . $row['PatId'] . "</td>";
                echo "<td>" . $row['created_at'] . "</td>";
                echo "<td>" . $row['Particulars'] . "</td>";
                echo "<td>" . $row['Quantity'] . "</td>";
                echo "<td>" . $row['UnitPrice'] . "</td>";
                echo "<td>" . $row['consultant'] . "</td>";
                echo "<td>" . $row['Amount'] . "</td>";
                echo "</tr>";
            }

            echo "</tbody>";

            // Display the Grand Total at the bottom of the table
            echo "<tfoot>
                    <tr>
                        <td colspan='6' class='text-right'><strong>Grand Total</strong></td>
                        <td><strong>" . number_format($grand_total, 2) . "</strong></td>
                    </tr>
                  </tfoot>";

            echo "</table>";
        } else {
            echo "<p>No records found for Bill No: $billno.</p>";
        }
        ?>

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



    
    <script type="a0935012553127c718007911-text/javascript" src="../files/bower_components/jquery/js/jquery.min.js"></script>
    <script type="a0935012553127c718007911-text/javascript" src="../files/bower_components/jquery-ui/js/jquery-ui.min.js"></script>
    <script type="a0935012553127c718007911-text/javascript" src="../files/bower_components/popper.js/js/popper.min.js"></script>
    <script type="a0935012553127c718007911-text/javascript" src="../files/bower_components/bootstrap/js/bootstrap.min.js"></script>

    <script src="../files/assets/pages/waves/js/waves.min.js" type="a0935012553127c718007911-text/javascript"></script>

    <script type="a0935012553127c718007911-text/javascript" src="../files/bower_components/jquery-slimscroll/js/jquery.slimscroll.js"></script>

    <script type="a0935012553127c718007911-text/javascript" src="../files/bower_components/modernizr/js/modernizr.js"></script>
    <script type="a0935012553127c718007911-text/javascript" src="../files/bower_components/modernizr/js/css-scrollbars.js"></script>

    <script src="../files/assets/pages/waves/js/waves.min.js" type="a0935012553127c718007911-text/javascript"></script>

    <script src="../files/bower_components/datatables.net/js/jquery.dataTables.min.js" type="a0935012553127c718007911-text/javascript"></script>
    <script src="../files/bower_components/datatables.net-buttons/js/dataTables.buttons.min.js" type="a0935012553127c718007911-text/javascript"></script>
    <script src="../files/assets/pages/data-table/js/jszip.min.js" type="a0935012553127c718007911-text/javascript"></script>
    <script src="../files/assets/pages/data-table/js/pdfmake.min.js" type="a0935012553127c718007911-text/javascript"></script>
    <script src="../files/assets/pages/data-table/js/vfs_fonts.js" type="a0935012553127c718007911-text/javascript"></script>
    <script src="../files/bower_components/datatables.net-buttons/js/buttons.print.min.js" type="a0935012553127c718007911-text/javascript"></script>
    <script src="../files/bower_components/datatables.net-buttons/js/buttons.html5.min.js" type="a0935012553127c718007911-text/javascript"></script>
    <script src="../files/bower_components/datatables.net-bs4/js/dataTables.bootstrap4.min.js" type="a0935012553127c718007911-text/javascript"></script>
    <script src="../files/bower_components/datatables.net-responsive/js/dataTables.responsive.min.js" type="a0935012553127c718007911-text/javascript"></script>
    <script src="../files/bower_components/datatables.net-responsive-bs4/js/responsive.bootstrap4.min.js" type="a0935012553127c718007911-text/javascript"></script>

    <script src="../files/assets/pages/data-table/js/data-table-custom.js" type="a0935012553127c718007911-text/javascript"></script>
    <script src="../files/assets/js/pcoded.min.js" type="a0935012553127c718007911-text/javascript"></script>
    <script src="../files/assets/js/vertical/vertical-layout.min.js" type="a0935012553127c718007911-text/javascript"></script>
    <script src="../files/assets/js/jquery.mCustomScrollbar.concat.min.js" type="a0935012553127c718007911-text/javascript"></script>
    <script type="a0935012553127c718007911-text/javascript" src="../files/assets/js/script.js"></script>

    <script async src="https://www.googletagmanager.com/gtag/js?id=UA-23581568-13" type="a0935012553127c718007911-text/javascript"></script>
    <script type="a0935012553127c718007911-text/javascript">
      window.dataLayer = window.dataLayer || [];
      function gtag(){dataLayer.push(arguments);}
      gtag('js', new Date());

      gtag('config', 'UA-23581568-13');
    </script>
    <script src="rocket-loader.min.js" data-cf-settings="a0935012553127c718007911-|49" defer=""></script></body>

    </html>

