<?php
session_start();
include("dbconfig.php");
if(isset($_SESSION['username']) && isset($_SESSION['password']))
{
    $username=$_SESSION['username'];
    $pass=$_SESSION['password'];
}
else
{
     echo '<META http-equiv="refresh" content="0;logout.php">';
}

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

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

        // Assigning variables with null checks and default values
        $patid = $row['PatientId'] ?? null;
        $disamount = $row['DiscountAmount'] ?? 0;
        $Total = $row['TotAmount'] ?? 0;
        $payable = $row['PayableAmount'] ?? 0;
        $billtype = $row['PaymentMode'] ?? '';
        $iname = $row['InsuranceName'] ?? '';
        $ino = $row['InsuranceNo'] ?? '';
        $bdate = $row['BDate'] ?? '';
        $btime = $row['BTime'] ?? '';
    } else {
        echo "No bill found with BillNo: $billno";
        exit;
    }

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

?>




    <!DOCTYPE html>
    <html lang="en">
    <meta http-equiv="content-type" content="text/html;charset=UTF-8" />
    <head>
    <title>VH-Admin</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;
}
    </style>

 <script type="text/javascript">
  function validateForm() {
  var x = document.forms["checkForm"]["Con"].value;
  var y = document.forms["checkForm"]["PatientId"].value;
  if (x == "" && y == "") {
    alert("Patient ID or Phone Number must be filled out");
    return false;
  }
}
</script>
</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 Patient Details</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="#!">Staff Details</a>
    </li>
    
    
    
    
    </ul>
    </div>
    </div>
    </div>
    </div>

    <div class="pcoded-inner-content" style="margin:0% 20%;">
   

  <div style="margin:5%">
   <div class="row">
	
			

	<div class="">
		<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>
			<tr>
				<td valign="top">Address</td>
			    <td>:4th Cross Road, 7th Main Road, #13, KRS Rd,<br> Brindavan Extension, Mysuru, Karnataka 570020</td>
			</tr>
			<tr>
				<td valign="top">Website</td>
				<td>:https://vidyaranyahospital.in/</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>
<hr>
<div class="row">
	<div class="col-md-6">
	<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 $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>
	

<?php if ($PatientType == "IPD") { ?>
    <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</td>
                <td valign="top">: <?php echo $billtype . " / " . $bdate . ", " . $btime; ?></td>
            </tr>
            <?php if ($billtype == "Insurance") { ?>
            <tr>
                <td>Insurance Name / Number</td>
                <td>: <?php echo $iname . ", " . $ino; ?></td>
            </tr>
            <?php } ?>
        </table>
    </div>
<?php } else { ?>
    <div class="col-md-6">
        <table>
            <tr>
                <td valign="top">Gender/Age</td>
                <td valign="top">: <?php echo $gender . " / " . $age; ?></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">Bill Type/Bill Date-Time</td>
                <td valign="top">: <?php echo $billtype . " / " . $bdate . ", " . $btime; ?></td>
            </tr>
        </table>
    </div
    
<?php } ?>




</div>
<br>
<form action="editedBillprev.php" method="POST">
    <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>
                </tr>
            <?php
                $i++;
            }
            ?>
            <tr>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td>Sub Total</td>
                <td><?php echo $Total; ?></td>
            </tr>
        </tbody>
    </table>

    <p>Prepared by <?php echo $PreparedBy; ?></p>

    <!-- Hidden inputs for form submission -->
    <?php foreach($part as $value) { ?>
        <input type="hidden" name="Epart[]" value="<?php echo $value; ?>">
    <?php } ?>
    
    <input type="hidden" name="size" value="<?php echo $size; ?>">
    <input type="hidden" name="patid" value="<?php echo $patid; ?>">
    <input type="hidden" name="billtype" value="<?php echo $billtype; ?>">
    <input type="hidden" name="bdate" value="<?php echo $bdate; ?>">
    <input type="hidden" name="btime" value="<?php echo $btime; ?>">
    <input type="hidden" name="preparedby" value="<?php echo $name; ?>">
    <input type="hidden" name="InsuranceName" value="<?php echo $iname; ?>">
    <input type="hidden" name="InsuranceNo" value="<?php echo $ino; ?>">

    <div style="text-align: center;">
        <!-- Proper submit button without anchor -->
        <button type="submit" class="btn btn-primary">Save</button>
    </div>
</form>

<br><br><br><br>

    </div>
  

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

