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

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

// Check if the user is logged in
if (isset($_SESSION['username']) && isset($_SESSION['password'])) {
    $username = $_SESSION['username'];
    $pass = $_SESSION['password'];
} else {
    echo '<META http-equiv="refresh" content="0;logout.php">';
    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;
}
    </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>Doctor Daily Transaction</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.html"><i class="feather icon-home"></i></a>
    </li>
    <li class="breadcrumb-item"><a href="#!">Home</a>
    </li>
    <li class="breadcrumb-item"><a href="#!">Doctor Daily Transaction</a>
    </li>
    
    
    
    
    </ul>
    </div>
    </div>
    </div>
    </div>

    <div class="pcoded-inner-content" style="margin:0% ;">
  <h2 style="text-align: center;font-weight: bold;color:#fff;background-color: #279480;padding:10px;">List of Bills</h2><br>
  <!--<h1 style="color:red">Under Construction</h1>-->

<!-- HTML Form -->
<?php


// Handle form submission
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $doctorName = $_POST['billuser'];
    $billDate = $_POST['billdate'];

    // Fetch IPD and OPD patients for the selected doctor and date
    $ipdQuery = "SELECT p.PatientId, p.Name, f.TotalAmount 
                 FROM patientdetails p 
                 JOIN finalbill f ON p.SlNo = f.PatientId 
                 WHERE p.Consultant = '$doctorName' AND f.AdmitDate = '$billDate'";
    
    $opdQuery = "SELECT o.PatientId, o.Name, b.TotAmount 
                 FROM opdpatientregister o 
                 JOIN bill b ON o.SlNo = b.PatientId 
                 WHERE o.Consultant = '$doctorName' AND b.BDate = '$billDate'";

    $ipdResult = mysqli_query($db, $ipdQuery);
    $opdResult = mysqli_query($db, $opdQuery);

    // Initialize totals
    $totalIPD = 0;
    $totalOPD = 0;
    $ipdPatients = [];
    $opdPatients = [];

    if ($ipdResult && mysqli_num_rows($ipdResult) > 0) {
        while ($row = mysqli_fetch_assoc($ipdResult)) {
            $ipdPatients[] = $row;
            $totalIPD += $row['TotalAmount'];
        }
    }

    if ($opdResult && mysqli_num_rows($opdResult) > 0) {
        while ($row = mysqli_fetch_assoc($opdResult)) {
            $opdPatients[] = $row;
            $totalOPD += $row['TotAmount'];
        }
    }
}
?>

<!-- HTML Form -->
<form method="POST">
    <div class="row">
        <div class="form-group col">
            <label for="billuser">Select Doctor</label>
            <select class="form-control" name="billuser" id="billuser" required>
                <option value="">Choose Doctor</option>
                <?php
                // Fetch doctor names from the doctorslist table
                $qu = mysqli_query($db, "SELECT doc_name FROM docotorslist");
                if (!$qu) {
                    echo "Error fetching doctors: " . mysqli_error($db);
                } else {
                    while ($row = mysqli_fetch_assoc($qu)) {
                        $doc_name = htmlspecialchars($row['doc_name']);
                        echo "<option value=\"$doc_name\">$doc_name</option>";
                    }
                }
                ?>
            </select>
        </div>

        <div class="form-group col">
            <label for="billdate">Select Date</label>
            <input class="form-control" type="date" name="billdate" id="billdate" required>
        </div>
    </div>
    <button type="submit" class="btn btn-primary">Proceed</button>
</form>

<?php if ($_SERVER["REQUEST_METHOD"] == "POST"): ?>
    <h3>Patients Checked on <?php echo htmlspecialchars($billDate); ?> by Dr. <?php echo htmlspecialchars($doctorName); ?></h3>

    <h4>IPD Patients</h4>
    <?php if (!empty($ipdPatients)): ?>
        <table class="table">
            <thead>
                <tr>
                    <th>Patient ID</th>
                    <th>Name</th>
                    <th>Total Amount</th>
                </tr>
            </thead>
            <tbody>
                <?php foreach ($ipdPatients as $patient): ?>
                    <tr>
                        <td><?php echo htmlspecialchars($patient['PatientId']); ?></td>
                        <td><?php echo htmlspecialchars($patient['Name']); ?></td>
                        <td><?php echo htmlspecialchars($patient['TotalAmount']); ?></td>
                    </tr>
                <?php endforeach; ?>
            </tbody>
        </table>
        <strong>Total IPD Amount: <?php echo $totalIPD; ?></strong>
    <?php else: ?>
        <p>No IPD patients found.</p>
    <?php endif; ?>

    <h4>OPD Patients</h4>
    <?php if (!empty($opdPatients)): ?>
        <table class="table">
            <thead>
                <tr>
                    <th>Patient ID</th>
                    <th>Name</th>
                    <th>Total Amount</th>
                </tr>
            </thead>
            <tbody>
                <?php foreach ($opdPatients as $patient): ?>
                    <tr>
                        <td><?php echo htmlspecialchars($patient['PatientId']); ?></td>
                        <td><?php echo htmlspecialchars($patient['Name']); ?></td>
                        <td><?php echo htmlspecialchars($patient['TotAmount']); ?></td>
                    </tr>
                <?php endforeach; ?>
            </tbody>
        </table>
        <strong>Total OPD Amount: <?php echo $totalOPD; ?></strong>
    <?php else: ?>
        <p>No OPD patients found.</p>
    <?php endif; ?>

<?php endif; ?>

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

