| Server IP : 162.240.98.243 / Your IP : 18.223.170.63 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/uploads/ |
Upload File : |
<?php
include 'workdeskmenu.php';
include 'header.php';
?>
<form name='signup' method='post'>
<div class='content-wrapper'>
<!-- Content Header (Page header) -->
<div class='center'>
<table id='example2' width='100%' class='table table-bordered table-hover'>
<tr>
<td width='50%'> Total Number Of OPD's : </td>
<td width='50%'>
<?php
session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
include("dbconnection.php");
$today = date('Y-m-d');
$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql1 = mysqli_query($con,$sql1);
if($re = mysqli_fetch_array($qsql1))
{
$sql="select count(*) from addaspatient WHERE hospitalid='$re[entered_by]' AND date(admintedDate) = '$today' AND typevisit='OPD' OR hospitalid='$re[entered_by]' AND date(admintedDate) = '$today' AND typevisit='Opd_Emergency' OR hospitalid='$re[entered_by]' AND date(admintedDate) = '$today' AND typevisit='OPD_Routine'";
$result=mysqli_query($con,$sql);
$row=mysqli_fetch_array($result);
echo "<b>$row[0]</b>";
mysqli_close($con);
}
?>
</span></td>
</tr>
<tr>
<td width='50%'> Total Amount Collection From OPD's
: </td>
<td width='50%'>
</td>
</tr>
<?php
session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
include("dbconnection.php");
$today = date('Y-m-d');
$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql1 = mysqli_query($con,$sql1);
if($re = mysqli_fetch_array($qsql1))
{
$sql12 ="SELECT * FROM site_users WHERE entered_by='$re[entered_by]' AND usertype='Doctor'";
$qsql12 = mysqli_query($con,$sql12);
while($re2 = mysqli_fetch_array($qsql12))
{
echo"
<tr>
<td width='50%'> Number Of OPD's Under <b>$re2[name]</b>
: </td>
<td width='50%'>";
$sql="select count(*) from patient_invace WHERE entered_by='$re2[userno]' AND date(updated_at) = '$today' AND discription='Consultant_fees'";
$result=mysqli_query($con,$sql);
$row=mysqli_fetch_array($result);
echo "<b>$row[0]</b>";
mysqli_close($con);
echo"
</td>
</tr>
";
}
}
?>
<tr>
<td width='50%'> Amount Collected For OPD's Under Dr.
: </td>
<td width='50%'>
</td>
</tr>
<tr>
<td width='50%'> Total Number of Medico legal OPD Patient
: </td>
<td width='50%'>
<?php
session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
include("dbconnection.php");
$today = date('Y-m-d');
$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql1 = mysqli_query($con,$sql1);
if($re = mysqli_fetch_array($qsql1))
{
$sql="select count(*) from patient_invace WHERE entered_by='$re2[userno]' AND date(updated_at) = '$today' AND discription='Consultant_fees'";
$result=mysqli_query($con,$sql);
if($re123 = mysqli_fetch_array($result))
{
$sql123="select count('prescriptionid') from mlc WHERE prescriptionid ='$re123[prescriptionid]'";
$result123=mysqli_query($con,$sql123);
$row=mysqli_fetch_array($result123);
echo "<b>$row[0]</b>";
mysqli_close($con);
}
}
?>
</td>
</tr>
<tr>
<td width='50%'> Total Number of Emergency procedure OPD Patient
: </td>
<td width='50%'>
<?php
session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
include("dbconnection.php");
$today = date('Y-m-d');
$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql1 = mysqli_query($con,$sql1);
if($re = mysqli_fetch_array($qsql1))
{
$sql="select count('prescriptionid') from discharge WHERE hospital_id='$re[entered_by]' AND date(admissiondate) = '$today' AND typevisit='Opd_Emergency'";
$result=mysqli_query($con,$sql);
$row=mysqli_fetch_array($result);
echo "<b>$row[0]</b>";
mysqli_close($con);
}
?>
</span></td>
</tr>
<tr>
<td width='50%'> Total Number Of IPD Admissions - Emergency
: </td>
<td width='50%'>
<?php
session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
include("dbconnection.php");
$today = date('Y-m-d');
$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql1 = mysqli_query($con,$sql1);
if($re = mysqli_fetch_array($qsql1))
{
$sql12 ="SELECT * FROM ward WHERE adminid='$re[entered_by]' AND ward_type='Emergency and Accidental'";
$qsql12 = mysqli_query($con,$sql12);
while($re2 = mysqli_fetch_array($qsql12))
{
$sql="select count('$re2[ward_type]') from request_for_admission";
$result=mysqli_query($con,$sql);
$row=mysqli_fetch_array($result);
echo "<b>$row[0]</b>";
mysqli_close($con);
}
}
?>
</span></td>
</tr>
</div>
</table>
<html>
<head>
<style>
.center {
border: 1px solid grey;
text-align:;
}
h2 {
color: #4287f5;
}
</style>
</head>