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


?>
<!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 type="text/css">
.nav-menu a {
    padding: 3px 3px;
}

#viewbtn{
    padding: 6px 20px;
    margin-top: 32px;
}
  .hide {
  display: none;
}
h4{
  padding-top: 5px;
  padding-bottom: 0px;
  color:#1abfbf;
  font-weight: bold;
}
hr{
  background-color:#1abfbf;
}
.footer {
   position: fixed;
   left: 0;
   bottom: 0;
   width: 100%;
   background-color: #efe8e8;
   color: black;
   text-align: center;
   padding:4px;
   font-size:12px;
}.footer a{
  font-weight: bold;
  color:#0c0c67;
}
</style>
<script type="text/javascript">
  function validateForm() {
  var x = document.forms["checkForm"]["PatientId"].value;
  var y = document.forms["checkForm"]["con"].value;
  if (x == "" && y=="") {
    alert("Patient ID or Phone Number must be filled out");
    return false;
  }
}
</script>
</head>
<body>
  <div style="text-align: center">
     <img src="assets/img/logo.png" width="100px" height="100px">
  </div>
      <header id="header">     

    <div class="container">
    <nav id="nav-menu-container">
        <ul class="nav-menu">
      <li class="menu-active">
        <a class="nav-link" style="padding:2;font-size:14px" href="index.php">Home</a>
      </li>
            <li class="menu-has-children">
        <a class="nav-link" style="padding:2;font-size:14px" href="#">IPD Patients</a>
        <ul>
              <li><a href="AddPatient.php">IPD Patient Registration</a></li>
              <li><a href="AddAdvance.php">IPD add Advance</a></li>
              <li><a href="UpdateWard.php">Update Ward</a></li>
              <li><a href="IPDPatients.php">View IPD Patients</a></li>
              
        </ul>
      </li>
      <li class="menu-has-children">
        <a class="nav-link" style="padding:2;font-size:14px" href="#">OPD Patients</a>
        <ul>
            <li><a href="OPDRegistration.php">OPD Patient Registration</a></li>
            <li><a href="OPDPatientsList.php">View OPD Patients Lists</a></li>
            <li><a href="OPDPatients.php">View OPD Patients Bills</a></li>
        </ul>
      </li>
      <li class="menu-has-children">
        <a class="nav-link" style="padding:2;font-size:14px" href="#">Staff</a>
        <ul>
              <li><a href="AddStaff.php">Add Staff</a></li>
              <li><a href="StaffList.php">Staff List</a></li>
        </ul>
      </li>
      <li class="menu-has-children">
        <a class="nav-link" style="padding:2;font-size:14px" href="#">Billing</a>
        <ul>
              <li><a href="billingId.php">Generate Consolidate Bill</a></li>
              <li><a href="InvestigationId.php">Generate Investigation Bill</a></li>
              <li><a href="FinaleBillId.php">Generate Discharge Bill</a></li>
              <li><a href="SearchBill.php">Search Bill</a></li>
        </ul>
      </li>
      <li class="menu-has-children">
        <a class="nav-link" style="padding:2;font-size:14px" href="#">Particular</a>
        <ul>
              <li><a href="AddParticulars.php">Add Particulars</a></li>
              <li><a href="ViewParticulars.php">View Particulars</a></li>
        </ul>
      </li>
      <li class="menu-has-children">
        <a class="nav-link" style="padding:2;font-size:14px" href="#">Report</a>
        <ul>
               <li><a href="UploadReport.php">Upload Patient Report</a></li>
              <li><a href="DailyTrans.php">Transactions</a></li>
              <li><a href="userTrans.php">User Transactions</a></li>
              <li><a href="ViewReport.php">View Patient Reports</a></li>
              
        </ul>
      </li>
      <li class="menu-has-children">
        <a class="nav-link" style="padding:2;font-size:14px" href="#" style="font-size:15px"><? echo $name?></a>
        <ul>
               <li><a href="logout.php">Logout</a></li>
              <li><a href="ResetPassword.php">Reset Password</a></li>              
        </ul>
      </li>
        </ul>
      </nav><!-- #nav-menu-container -->
    </div>
  </header><!-- End Header -->     
  <section>
      <div class="row justify-content-center ml-5 mb-5">
          <div class="col-md-3 justify-content-center">
              <button type='button' class='btn btn-primary' data-toggle='modal' data-target='#addDoc'>Add Docotor</button>
          </div>
      </div>
  <div class="row">
<div class="col-md-2"></div> 
<div class="col-md-8">
<div class="shadow p-3 mb-5 bg-light rounded">
    <?php
    // Check for session messages and display alerts
    if (isset($_SESSION['Updated'])) {
        echo "<script>alert('Updated Sucessfully');</script>";
    }
    unset($_SESSION['Updated']);

    if (isset($_SESSION['added'])) {
        echo "<script>alert('Added Sucessfully');</script>";
    }
    unset($_SESSION['added']);

    // SQL query to fetch doctors list
    $sql = "SELECT * FROM `docotorsList` ORDER BY doc_id DESC";
    $query1 = mysqli_query($db, $sql);

    // Check if the query was successful
    if ($query1) {
        if (mysqli_num_rows($query1) > 0) {
            // Display the table if there are records
    ?>
            <table class="table table-striped">
                <thead>
                    <tr>
                        <th style="display:none">ID</th>
                        <th>Sl No.</th>
                        <th>Doctor NAME</th>
                        <th>Specialization</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                    <?php 
                    $i = 1;
                    while ($row = $query1->fetch_assoc()) {
                    ?>
                        <tr>
                            <td style="display:none"><?php echo $row['doc_id']; ?></td>
                            <td><?php echo $i; ?></td>
                            <td><?php echo $row['doc_name']; ?></td>
                            <td><?php echo $row['doc_specialization']; ?></td>
                            <td>
                                <button type="button" class="btn btn-primary docbtn" data-toggle="modal" data-target="#exampleModal">Edit</button>
                            </td>
                        </tr>
                    <?php 
                        $i++;
                    }
                    ?>
                </tbody>
            </table>
    <?php
        } else {
            // No records found
            echo "<h4>No Doctor Details to Show</h4>";
        }
    } else {
        // Query failed
        echo "<h4>Error fetching doctor details: " . mysqli_error($db) . "</h4>";
    }
    ?>
</div>

<div class="modal fade" id="editdocmodal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
      <div class="modal-dialog" role="document">
        <div class="modal-content">
          <div class="modal-header">
            <h5 class="modal-title" id="exampleModalLabel">Edit Doctor</h5>
            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
              <span aria-hidden="true">&times;</span>
            </button>
          </div>
          <div class="modal-body">
            <form action="doctorsControllers.php" method="post">
                <div class="form-group">
                    <label for="">Doctor Name</label>
                    <input type="text" class="form-control" id="doc_name" name="doc_name" placeholder="Doctor Name" oninput="this.value = this.value.toUpperCase()">
                </div>
                <div class="form-group">
                    <label for="">Doctor Specialization</label>
                    <input type="text" class="form-control" id="doc_specialization" name="doc_specialization" placeholder="Doctor Specialization" oninput="this.value = this.value.toUpperCase()">
                </div>
                <div class="form-group">
                    <input type="hidden" class="form-control" id="doc_id" name="doc_id" placeholder="Doctor Name">
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                    <input type="submit" class="btn btn-secondary"  name="edit" id="edit" />
                </div>
            </form>
          </div>
        </div>
      </div>
    </div>
</div>
<div class="col-md-2"></div> 
</div>
<div class="modal fade" id="addDoc" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
      <div class="modal-dialog" role="document">
        <div class="modal-content">
          <div class="modal-header">
            <h5 class="modal-title" id="exampleModalLabel">Add Doctor</h5>
            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
              <span aria-hidden="true">&times;</span>
            </button>
          </div>
          <div class="modal-body">
            <form action="doctorsControllers.php" method="post">
                <div class="form-group">
                    <label for="">Doctor Name</label>
                    <input type="text" class="form-control" id="doc_name" name="doc_name" placeholder="Doctor Name" oninput="this.value = this.value.toUpperCase()">
                </div>
                <div class="form-group">
                    <label for="">Doctor Specialization</label>
                    <input type="text" class="form-control" id="doc_specialization" name="doc_specialization" placeholder="Doctor Specialization" oninput="this.value = this.value.toUpperCase()">
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                    <input type="submit" class="btn btn-secondary"  name="addDoc" id="addDoc" />
                </div>
            </form>
          </div>
        </div>
      </div>
    </div>
</div>



  </section>
  <div class="footer">
        &copy; Copyright 2024 All Rights Reserved <strong>Vidyaranya Hospital PVt LTD.</strong>. | Designed by <a href="http://www.vatsinsoft.in/">Vatsin Soft</a>
      </div>
 <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>
  <script type="text/javascript">
        $(document).ready(function(){
            $('.docbtn').on('click', function(){
                // alert("dd");
    
              $('#editdocmodal').modal('show');
    
              $tr = $(this).closest('tr');
              var data = $tr.children("td").map(function(){
                // alert(data);
                return $(this).text();
              }).get();
              console.log(data);
              $('#doc_id').val(data[0]);
              $('#doc_name').val(data[2]);
              $('#doc_specialization').val(data[3]);
              
            });
            
            $('#doc_name,#doc_name').on('keypress', function (event) {   
                  var regex = new RegExp("^[a-zA-Z ]+$");
                  var key = String.fromCharCode(!event.charCode ? event.which : event.charCode);
                  if (!regex.test(key)) {
                     event.preventDefault();
                     return false;
                  }
              
            });
        });
    </script>
</body>
</html>