<?php
session_start();
require_once("../LoginManager.php");
require_once("../DBManager.php");
include("workdeskmenu.php");
include("header.php");
?>
  <style>
 .p{
     color: black;
          font-weight: 900;
 }
/* Automatic Serial Number Row */
.css-serial {
     font-weight: 900;
       color: black;
 counter-reset: serial-number; /* Set the serial number counter to 0 */
}
.css-serial td:first-child:before {
 counter-increment: serial-number; /* Increment the serial number counter */
 content: counter(serial-number); /* Display the counter */
}
</style>
 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
    <script>
function myFunction11() {
  var checkBox = document.getElementById("myCheck11");
  var text = document.getElementById("text11");
  if (checkBox.checked == true){
    text.style.display = "block";
  } else {
     text.style.display = "none";
  }
}
function myFunction12() {
  var checkBox = document.getElementById("myCheck12");
  var text = document.getElementById("text12");
  if (checkBox.checked == true){
    text.style.display = "block";
  } else {
     text.style.display = "none";
  }
}
</script>
 	<style>
    form{
        margin: 20px 0;
    }
    form input, button{
        padding: 5px;
    }
    table{
        width: 100%;
        margin-bottom: 20px;
		border-collapse: collapse;
    }
    table, th, td{
        border: 1px solid #cdcdcd;
    }
    table th, table td{
        padding: 10px;
        text-align: left;
    }
	<style>
           
			table{
    border: solid 1px gray;
    width: 100%;
  }
  </style>
 

    
        <br> <br>	  
                         
     <div class="checkbox"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  
     <input name="Addiction" id="myCheck11" class="shopitem-list" onclick="myFunction11()" type="checkbox">
     
     <span>Single Date </span>
     
</div>
<div id="text11" style="display:none" >
          
              <input type="date" onchange="dateloadipd(this.value)">
                        </div>
                        
                         <div class="checkbox"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  <input name="Addiction" id="myCheck12" onclick="myFunction12()" class="shopitem-list" type="checkbox"><span>Custom Date </span>
</div>
<div id="text12" style="display:none" >
            
                 
                         
            <form action="" method="GET">
                            <div class="row">
                                <div class="col-md-4">
                                    <div class="form-group">
                                        <label>From Date</label>
                                        <input type="date" name="from_date" value="<?php if(isset($_GET['from_date'])){ echo $_GET['from_date']; } ?>" class="form-control">
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <div class="form-group">
                                        <label>To Date</label>
                                        <input type="date" name="to_date" value="<?php if(isset($_GET['to_date'])){ echo $_GET['to_date']; } ?>" class="form-control">
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <div class="form-group">
                                         <br>
                                      <button type="submit" class="btn btn-primary">Apply</button>
                                    </div>
                                </div>
                            </div>
                        </form>
                         </div>
                        
                        
                               
                                 <button style='height:40px;width:200px' onclick="location.href='ipd_Admission_and_Discharge.php'" type="button"> <span style="color:white">    Reset</span></button>
                                 </section>
                                <div id="PrintContent">  
                                 <?php
                                 include'hsprofileworkdesk.php';
                                 ?>
                                 
   <link rel="stylesheet" href="assets/style.css">                   
                      <center>	<h3 class='code'>  IPD General	</h3>
           	
          <a href="#" style="float:right;font-size:20px;margin-top:-23px;"><i class="fa fa-info-circle" aria-hidden="true" ></i></a></center>                                
                                 
                                 
          <div id='divdripd'> 
           
        <table border="1" class="order-table  css-serial">
      <tbody>
                   
                                  <tr>
                                           <th>SR No</th>
          <th>Created </th>
             <th>Patient Details</th>
        <th>Details </th>
               </tr>
               
               <?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");

                          
	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
		if($re = mysqli_fetch_array($qsql1))
		{
		       if(isset($_GET['from_date']) && isset($_GET['to_date']))
                                {
                                    $from_date = $_GET['from_date'];
                                    $to_date = $_GET['to_date'];
}
$sql78="SELECT count('id') FROM discharge WHERE hospital_id='$re[entered_by]'  AND typevisit='IPD' AND date(admissiondate) BETWEEN '$from_date' AND '$to_date'";
$result45=mysqli_query($con,$sql78);
$row1=mysqli_fetch_array($result45);
echo "Total Patient : <b>$row1[0]</b>";
echo"<p align='right'><b>From Date</b> $_GET[from_date] -<b>TO</b> $_GET[to_date]</p>";
if($row1[0]=='0')
{

    echo"<h1 align='center'>
  No Record Found</h1>";
}

mysqli_close($con);
}
?>
    
<?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
		if($re = mysqli_fetch_array($qsql1))
		{
		       if(isset($_GET['from_date']) && isset($_GET['to_date']))
                                {
                                    $from_date = $_GET['from_date'];
                                    $to_date = $_GET['to_date'];
                                }
		$sql2 ="SELECT * FROM discharge WHERE hospital_id='$re[entered_by]'  AND typevisit='IPD' AND date(admissiondate) BETWEEN '$from_date' AND '$to_date'   ";
		$qsql2 = mysqli_query($con,$sql2);
		while($rs = mysqli_fetch_array($qsql2))
		{
		    $sql3 ="SELECT * FROM addaspatient WHERE  prescriptionid='$rs[prescriptionid]'";
		$qsql3 = mysqli_query($con,$sql3);
		while($rsr = mysqli_fetch_array($qsql3))
		{
		    	$sqldoctor= "SELECT * FROM site_users WHERE userno='$rsr[Admitted_Under]'";
			$qsqldoctor = mysqli_query($con,$sqldoctor);
			while($rsdoctor = mysqli_fetch_array($qsqldoctor))
			{
	    
		    	$sql4 ="SELECT * FROM patient WHERE patientid='$rs[patientid]'";
		$qsql4 = mysqli_query($con,$sql4);
		while($rp = mysqli_fetch_array($qsql4))
		{
        echo " 
	                <tr>
                 <td>&nbsp;</td>
                 <td><b>Created at:</b> $rs[created_at]
                 <br><b>Created By:</b> $re[name] 
                 <br><b>Under Doctor :</b> $rsdoctor[name]</td>
                 <td><b>UHID :</b> $rp[patientid]
                 <br><b>Patient Name</b> $rp[patientname]<b>
                 <br>Age :</b> $rp[dob]<br>
                 <b>Gender :</b> $rp[gendor]<br><b>Guardian :</b>  $rp[HusbandName]</td>
                                                 						<td><a href='treatment_timline.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]'>View</td>
                					  
          </tr>                   
          
          ";


}
		    
		}
	    
	    
	}
		}
	
}

?>    
        </table>
</div>
 </div>
   
          
          </div>
  
            <script type="text/javascript">
	    $('.shopitem-list').on('change', function() {
		    $('.shopitem-list').not(this).prop('checked', false);  
		});
    </script>
 <script>
 function dateloadipd(dateipd)
{
	    if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (this.readyState == 4 && this.status == 200) {
                document.getElementById("divdripd").innerHTML = this.responseText;
            }
        };
        xmlhttp.open("GET","loadadmissionipd.php?dateipd="+dateipd,true);
        xmlhttp.send();
}
            
     
</script>
<?php
if(isset($_SESSION[doctorid]))
{
?>  
<hr>
	<table>
		<tr>
			<td>
			<div align="center"><strong><a href="prescription.php?patientid=<?php echo $_GET[patientid]; ?>&appid=<?php echo $rsappointment[appointmentid]; ?>">Add Prescription records</a></strong></div>
			</td>
		</tr>
	</table>
	<script>
  $(function () {
    $("#example1").DataTable({
      "responsive": true,
      "autoWidth": false,
    });
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
    });
  });
</script>

<?php
}
?>

</table>
     <script src="https://code.jquery.com/jquery-3.5.1.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/js/bootstrap.bundle.min.js"></script>