| Server IP : 162.240.98.243 / Your IP : 18.189.180.43 Web Server : Apache System : Linux server.bti.yaw.mybluehostin.me 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : btiyawmy ( 1003) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/btiyawmy/public_html/login.easenup.in/ |
Upload File : |
<?php
session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
include("header.php");
include("dbconnection.php");
include 'workdeskmenu.php';
?>
<div class="content-wrapper">
<section class="content-header">
<!DOCTYPE html>
<html lang="en">
<head>
<link rel="stylesheet" href="select2.min.css" />
<style>
/* Automatic Serial Number Row */
.css-serial {
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>
<link rel="stylesheet" href="assets/style.css">
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="Dashboard">
<meta name="keyword" content="Dashboard, Bootstrap, Admin, Template, Theme, Responsive, Fluid, Retina">
<title>In House Patient</title>
<body>
<center> <h3 class='code'> Imaging Report </h3>
<a href="#" style="float:right;font-size:20px;margin-top:-23px;"><i class="fa fa-info-circle" aria-hidden="true" ></i></a></center>
</head>
<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">
<label>Click to Filter</label> <br>
<button type="submit" class="btn btn-primary">Filter</button>
</div>
</div>
</div>
</form>
<table id="example2" class="order-table table table-bordered table-hover css-serial">
<tr>
<th>SR No</th>
<th>Patient Details</th>
<th>Summary</th>
<th>Details </th>
</tr>
<br>
<?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 * FROM tat WHERE hospital_id='$re[entered_by]' AND type='Opd_Emergency' AND start_date BETWEEN '$from_date' AND '$to_date' ";
$result45=mysqli_query($con,$sql78);
$row1=mysqli_fetch_array($result45);
echo"<p align='right' style='color:red; font-size:20px;'><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
if (isset($_GET['page_no']) && $_GET['page_no']!="") {
$page_no = $_GET['page_no'];
} else {
$page_no = 1;
}
$total_records_per_page = 10;
$offset = ($page_no-1) * $total_records_per_page;
$previous_page = $page_no - 1;
$next_page = $page_no + 1;
$adjacents = "2";
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'];
}
$result_count = mysqli_query($con,"SELECT COUNT(*) As total_records FROM investigation WHERE entered_by='$re[entered_by]'");
$total_records = mysqli_fetch_array($result_count);
$total_records = $total_records['total_records'];
$total_no_of_pages = ceil($total_records / $total_records_per_page);
$second_last = $total_no_of_pages - 1; // total page minus 1
$investigation ="SELECT * FROM investigation WHERE entered_by='$re[entered_by]' AND Investigation_type='Radiology' AND date(AdmittedDate) BETWEEN '$from_date' AND '$to_date' ORDER BY`id` DESC ";
$qinvestigation = mysqli_query($con,$investigation);
while($Rowinvestigation = mysqli_fetch_array($qinvestigation)){
$addaspatient ="SELECT * FROM addaspatient WHERE entered_by='$re[entered_by]' AND patientid='$Rowinvestigation[patientid]'";
$q_addaspatient = mysqli_query($con,$addaspatient);
$r_addaspatient = mysqli_fetch_array($q_addaspatient);
$sql4 ="SELECT * FROM patient WHERE patientid='$Rowinvestigation[patientid]'";
$qsql4 = mysqli_query($con,$sql4);
$rp = mysqli_fetch_array($qsql4);
$request=$con->query("SELECT * FROM request_for_admission WHERE patientid='$Rowinvestigation[patientid]' AND entered_by='$re[entered_by]' AND (Reason_for_Admission='Emergency' OR Reason_for_Admission='Treatment & Observation')");
$RowRFA=$request->fetch_array();
$labreports=$con->query("SELECT * FROM labreports WHERE patientid='$Rowinvestigation[patientid]' AND prescriptionid='$Rowinvestigation[prescriptionid]' AND requesttestid='$Rowinvestigation[id]'");
$Rowlabreports=$labreports->fetch_array();
$Collect_Sample =$con->query("SELECT * FROM Collect_Sample WHERE patientid='$Rowinvestigation[patientid]' AND Container_Number='$Rowinvestigation[id]'");
$RowCollect_Sample = $Collect_Sample->fetch_array();
$datetime_1 = $Rowinvestigation['TimeIn'];
if($Rowinvestigation['Result']=='Done'){
$datetime_2 = $Rowinvestigation['TimeOut'];
$date = $Rowinvestigation['updated_at'];
$a='Reported At';
}if($Rowlabreports['requesttestid']==$Rowinvestigation['id']){
$datetime_2 = $Rowlabreports['TimeOut'];
$date = $Rowlabreports['created_at'];
$a='Report Genarated At';
}
$from_time = strtotime($datetime_1);
$to_time = strtotime($datetime_2);
$diff_minutes = round(abs($from_time - $to_time) / 60,2). " minutes";
$start_date = new DateTime($datetime_1);
$since_start = $start_date->diff(new DateTime($datetime_2));
// $since_start->days.' days total<br>';
// $since_start->y.' years<br>';
// $since_start->m.' months<br>';
// $since_start->d.' days<br>';
// echo $since_start->h.' hours<br>';
// echo $since_start->i.' minutes<br>';
// echo $since_start->s.' seconds<br>';
echo "
<tr>
<td> </td>
<td><b>UHID :</B>$rp[patientid]
<br>
<b>Patient Name :</b> $rp[patientname]<br>
<b>Type :</b>$r_addaspatient[typevisit]<br>
<b>
Investigation :</b>";
if (is_numeric($Rowinvestigation[Category]))
{
$sql1 ="SELECT * FROM labdepartment WHERE labdepartmentid='$Rowinvestigation[Category]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
echo "$rh1[lab_department_name]";
}
if (is_numeric($Rowinvestigation[Sub_Category]))
{
$sql1 ="SELECT * FROM radiobodypart WHERE radiobodypartid='$Rowinvestigation[Sub_Category]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
echo "- $rh1[bodypart]";
}
if (is_numeric($Rowinvestigation[Sub_Category]))
{
$sql1 ="SELECT * FROM list_Investigation WHERE ivid='$Rowinvestigation[Investigation]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
echo "- $rh1[Investigation]";
}
echo " <br>
<b>Container Number :</b>$Rowinvestigation[id]
</td>
<td>
<br><b>Requested At :</b>$Rowinvestigation[created_at]<br>
<b>$a :</b>
$date
<br>
<b>Duration :</b>$since_start->h hours. $since_start->i minutes . $since_start->s seconds<br>";
echo "</td><td><a href='#.php?patientid=$rp[patientid]&prescriptionid=$RowRequest[prescriptionid]'> <i class='fa fa-eye' style='color:green; font-size:20px;'></i></a>
</td>
</tr>
";
}
}
?>
</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>