<?php 
session_start();
require_once 'config.php';
require_once 'auth.php';
$MainPage="IPD";
$Page = "Dischage-Card";
?>
<!DOCTYPE html>

<html lang="en" class="default-style">

<head>
    <title><?php echo $Proj_Title; ?></title>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=no, minimum-scale=1.0, maximum-scale=1.0">
    <meta name="description" content="" />
    <meta name="keywords" content="">
    <meta name="author" content="Codedthemes" />
    <?php include_once 'header_script.php'; ?>
    <link rel="stylesheet" href="assets/libs/datatable-buttons/buttons.dataTables.min.css">
</head>

<body>
  
    <!-- [ Layout wrapper ] Start -->
  <div class="layout-wrapper layout-1 layout-without-sidenav">
        <div class="layout-inner">
         
         <?php //include 'sidenavi.php'; ?>

<div class="layout-container">
                 <div class="layout-content">

                    <!-- [ content ] Start -->
                    <div class="container-fluid flex-grow-1 container-p-y">
                     

                        <div class="row">
                            <!-- customar project  start -->
                            <div class="col-xl-12">
                                <div class="card">
                                    <div class="card-body">
                                        

 

      
<h4 class="font-weight-bold py-3 mb-0">Deleted Patient Record List</h4>

    <div class="table-responsive">
         <table id="example" class="table table-bordered table-striped mb-0">
            <thead>
             <tr>
                <th>#</th>
                <th>Mrd. No</th>
                <th>Patient Name</th>
                <th>Age/Gender</th>
                <th>Address</th>   
                <th>Phone</th>   
                <th>Marrital Status</th>  
                <th>Diagnosis</th> 
                <th>Visit Date</th>
            </tr>
            </thead>
            <tbody>
          <?php 
          $i=1;
          $sql3 = "SELECT * FROM tbl_consultant WHERE DeleteFlag=1";
          $row3 = getList($sql3);
          foreach($row3 as $result){
           ?>      
                <tr>
                    <td><?php echo $i; ?></td>
                    <td><?php echo $result['MrdNo']; ?></td>
                   
                    <td><?php echo $result['PatientName']; ?></td>
                    <td><?php echo $result['Age']."/".$result['Gender']; ?></td>
                  
                    <td><?php echo $result['Address']; ?></td>
                    <td><?php echo $result['Phone']; ?></td>
                    <td><?php echo $result['MarritalStatus']; ?></td>
                    
                    <td><?php echo $result['Diagnosis']; ?></td>
                    <td><?php echo date("d/m/Y", strtotime(str_replace('-', '/',$result['VisitDate']))); ?></td>
                   
                    
                   
               </tr>
           <?php $i++;} ?>
            </tbody>
        </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <!-- customar project  end -->
                        </div>
                    </div>
                    <!-- [ content ] End -->
                    <!-- [ Layout footer ] Start -->
                   <?php //include 'footer.php'; ?>
                    <!-- [ Layout footer ] End -->
                </div>

                
                <!-- [ Layout content ] Start -->
            </div>
            <!-- [ Layout container ] End -->
        </div>
        <!-- Overlay -->
        <div class="layout-overlay layout-sidenav-toggle"></div>
    </div>


    <!-- [ Layout wrapper] End -->



<?php include_once 'footer_script.php'; ?>
<script src="assets/js/dataTables.buttons.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<!-- <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script> -->
<script src="assets/js/buttons.html5.min.js"></script>

   <script type="text/javascript">
 function printCard(ipdno){
     window.open('print-discharge-card.php?ipdno='+ipdno);
     //window.open('print-discharge-card2.php?ipdno='+ipdno);
 }

    $(document).ready(function() {
    $('#example').DataTable({
      
       "scrollX": true,
        dom: 'Bfrtip',
        buttons: [
            
            'excelHtml5'
           
        ]
    });
});
</script>
</body>

</html>
