| Server IP : 162.240.98.243 / Your IP : 3.128.173.53 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/FrontOffice/ |
Upload File : |
<?php
session_start();
require_once('../../patientmanager_Reg.php');
if(!isset($_SESSION['uname']))
{
echo "<script>alert('Session Expired..');</script><script>window.location='../index.php';</script>";
}
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql = mysqli_query($con,$sql);
$rs = mysqli_fetch_array($qsql);
$sql ="SELECT * FROM hco WHERE adminid='$rs[entered_by]'";
$qsql = mysqli_query($con,$sql);
$rs1 = mysqli_fetch_array($qsql);
$usertype=$rs1['adminid'];
date_default_timezone_set("Asia/Calcutta"); //India time (GMT+5:30)
$Today= date('Y-m-d');
$TotalPatient=$con->query("SELECT count(*) FROM `addaspatient` WHERE entered_by='$harilal'");
$OutPatient=$con->query("SELECT count(*) FROM `addaspatient` WHERE entered_by='$harilal' AND admintedDate='$Today'");
$InPatient=$con->query("SELECT count(*) FROM `addaspatient` WHERE entered_by='$harilal' AND typevisit='IPD' AND admintedDate='$Today'");
$TotalAmt = $con->query("select SUM(grand_total) AS total from patient_invace WHERE date(updated_at) = '$Today' AND status='Paid' AND (TypeOfVisit='OPD' OR TypeOfVisit='Opd_Emergency' OR TypeOfVisit='OPD_Routine')");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<meta charset="utf-8" />
<title>Dashboard</title>
<meta name="description" content="Restyling jQuery UI Widgets and Elements" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" />
<!-- bootstrap & fontawesome -->
<link rel="stylesheet" href="assets/css/bootstrap.min.css" />
<link rel="stylesheet" href="assets/font-awesome/4.5.0/css/font-awesome.min.css" />
<!-- page specific plugin styles -->
<link rel="stylesheet" href="assets/css/jquery-ui.min.css" />
<!-- text fonts -->
<link rel="stylesheet" href="assets/css/fonts.googleapis.com.css" />
<!-- ace styles -->
<link rel="stylesheet" href="assets/css/ace.min.css" class="ace-main-stylesheet" id="main-ace-style" />
<!--[if lte IE 9]>
<link rel="stylesheet" href="assets/css/ace-part2.min.css" class="ace-main-stylesheet" />
<![endif]-->
<link rel="stylesheet" href="assets/css/ace-skins.min.css" />
<link rel="stylesheet" href="assets/css/ace-rtl.min.css" />
<!--[if lte IE 9]>
<link rel="stylesheet" href="assets/css/ace-ie.min.css" />
<![endif]-->
<!-- inline styles related to this page -->
<!-- ace settings handler -->
<script src="assets/js/ace-extra.min.js"></script>
<!-- HTML5shiv and Respond.js for IE8 to support HTML5 elements and media queries -->
<!--[if lte IE 8]>
<script src="assets/js/html5shiv.min.js"></script>
<script src="assets/js/respond.min.js"></script>
<![endif]-->
<!-- page specific plugin styles -->
<link rel="stylesheet" href="assets/css/jquery-ui.custom.min.css" />
<link rel="stylesheet" href="assets/css/jquery.gritter.min.css" />
</head>
<body class="no-skin">
<?php include('includes/header.php') ?>
<div class="main-container ace-save-state" id="main-container">
<script type="text/javascript">
try{ace.settings.loadState('main-container')}catch(e){}
</script>
<div id="sidebar" class="sidebar responsive ace-save-state">
<script type="text/javascript">
try{ace.settings.loadState('sidebar')}catch(e){}
</script>
<!--<div class="sidebar-shortcuts" id="sidebar-shortcuts">-->
<!-- <div class="sidebar-shortcuts-large" id="sidebar-shortcuts-large">-->
<!-- <button class="btn btn-success">-->
<!-- <i class="ace-icon fa fa-signal"></i>-->
<!-- </button>-->
<!-- <button class="btn btn-info">-->
<!-- <i class="ace-icon fa fa-pencil"></i>-->
<!-- </button>-->
<!-- <button class="btn btn-warning">-->
<!-- <i class="ace-icon fa fa-users"></i>-->
<!-- </button>-->
<!-- <button class="btn btn-danger">-->
<!-- <i class="ace-icon fa fa-cogs"></i>-->
<!-- </button>-->
<!-- </div>-->
<!-- <div class="sidebar-shortcuts-mini" id="sidebar-shortcuts-mini">-->
<!-- <span class="btn btn-success"></span>-->
<!-- <span class="btn btn-info"></span>-->
<!-- <span class="btn btn-warning"></span>-->
<!-- <span class="btn btn-danger"></span>-->
<!-- </div>-->
<!--</div>-->
<!-- /.sidebar-shortcuts -->
<?php include('includes/sidebar.php') ?>
<div class="sidebar-toggle sidebar-collapse" id="sidebar-collapse">
<i id="sidebar-toggle-icon" class="ace-icon fa fa-angle-double-left ace-save-state" data-icon1="ace-icon fa fa-angle-double-left" data-icon2="ace-icon fa fa-angle-double-right"></i>
</div>
</div>
<div class="main-content">
<div class="main-content-inner">
<div class="breadcrumbs ace-save-state" id="breadcrumbs">
<ul class="breadcrumb">
<li>
<i class="ace-icon fa fa-home home-icon"></i>
<a href="#">Home</a>
</li>
<li class="active">Dashboard</li>
</ul><!-- /.breadcrumb -->
<div class="nav-search" id="nav-search">
<form class="form-search">
<span class="input-icon">
<input type="text" placeholder="Search ..." class="nav-search-input" id="nav-search-input" autocomplete="off" />
<i class="ace-icon fa fa-search nav-search-icon"></i>
</span>
</form>
</div><!-- /.nav-search -->
</div>
<div class="page-content">
<!-- /.ace-settings-container -->
<div class="page-header">
<h1>
Home
<small>
<i class="ace-icon fa fa-angle-double-right"></i>
Dashboard
</small>
</h1>
</div><!-- /.page-header -->
<div class="row">
<div class="col-xs-12">
<!-- PAGE CONTENT BEGINS -->
<div class="alert alert-block alert-success">
<button type="button" class="close" data-dismiss="alert">
<i class="ace-icon fa fa-times"></i>
</button>
<i class="ace-icon fa fa-check green"></i>
Welcome
<strong class="green">
<?php echo $rs['name']; ?> - <?php echo $rs['usertype']; ?> - Member since <?php echo $rs['created_at']; ?>
</strong>
</div>
<!-- /.row -->
<div class="row">
<div class="col-xs-12">
<!-- PAGE CONTENT BEGINS -->
<div class='row'>
<div class="col-sm-12">
<div class="col-sm-7 infobox-container">
<div class="infobox infobox-green">
<div class="infobox-icon">
<i class="ace-icon fa fa-users"></i>
</div>
<div class="infobox-data">
<span class="infobox-data-number">
<?php
if($RowPatient=$TotalPatient->fetch_assoc()){
echo $RowPatient['count(*)'];
}
?>
</span>
<div class="infobox-content">Total Patient</div>
</div>
<!--<div class="stat stat-success">8%</div>-->
</div>
<div class="infobox infobox-blue">
<div class="infobox-icon">
<i class="ace-icon fa fa-user"></i>
</div>
<div class="infobox-data">
<span class="infobox-data-number">
<?php
if($RowDay=$OutPatient->fetch_assoc()){
echo $RowDay['count(*)'];
}
?>
</span>
<div class="infobox-content">Out Patient</div>
</div>
<!--<div class="badge badge-success">-->
<!-- +32%-->
<!-- <i class="ace-icon fa fa-arrow-up"></i>-->
<!--</div>-->
</div>
<div class="infobox infobox-blue">
<div class="infobox-icon">
<i class="ace-icon fa fa-user"></i>
</div>
<div class="infobox-data">
<span class="infobox-data-number">
<?php
if($RowDay=$InPatient->fetch_assoc()){
echo $RowDay['count(*)'];
}
?>
</span>
<div class="infobox-content">In Patient</div>
</div>
<!--<div class="badge badge-success">-->
<!-- +32%-->
<!-- <i class="ace-icon fa fa-arrow-up"></i>-->
<!--</div>-->
</div>
<div class="infobox infobox-pink">
<div class="infobox-icon">
<i class="ace-icon fa fa-user-md"></i>
</div>
<div class="infobox-data">
<span class="infobox-data-number">
<?php
$today = date('Y-m-d');
$sql3="select * from addaspatient WHERE hospitalid='$rs[entered_by]' AND date(admintedDate) = '$today' AND typevisit='OPD' OR hospitalid='$rs[entered_by]' AND date(admintedDate) = '$today' AND typevisit='Opd_Emergency' OR hospitalid='$rs[entered_by]' AND date(admintedDate) = '$today' AND typevisit='OPD_Routine' OR hospitalid='$rs[entered_by]' AND date(admintedDate) = '$today' AND typevisit='IPD'";
$qsql3 = mysqli_query($con,$sql3);
while($rsr = mysqli_fetch_array($qsql3)){
$sql12 ="SELECT * FROM patient_invace WHERE prescriptionid='$rsr[prescriptionid]' AND status='Paid'";
$qsql12 = mysqli_query($con,$sql12);
$re2 = mysqli_fetch_array($qsql12);
?>
<input type='hidden' id='grand_total' class='grand_total' value='<?php echo $re2['grand_total'] ?>'>
<?php
}
echo "<b><i class='fa fa-inr'></i> <span align='right' id='grand_totalValue'></span></b>";
?>
</span>
<div class="infobox-content">Total Fee</div>
</div>
<!--<div class="stat stat-important">4%</div>-->
</div>
<div class="space-6"></div>
<!--<div class="infobox infobox-green infobox-small infobox-dark">-->
<!-- <div class="infobox-progress">-->
<!-- <div class="easy-pie-chart percentage" data-percent="61" data-size="39">-->
<!-- <span class="percent">61</span>%-->
<!-- </div>-->
<!-- </div>-->
<!-- <div class="infobox-data">-->
<!-- <div class="infobox-content">Task</div>-->
<!-- <div class="infobox-content">Completion</div>-->
<!-- </div>-->
<!--</div>-->
<!--<div class="infobox infobox-blue infobox-small infobox-dark">-->
<!-- <div class="infobox-chart">-->
<!-- <span class="sparkline" data-values="3,4,2,3,4,4,2,2"></span>-->
<!-- </div>-->
<!-- <div class="infobox-data">-->
<!-- <div class="infobox-content">Earnings</div>-->
<!-- <div class="infobox-content">$32,000</div>-->
<!-- </div>-->
<!--</div>-->
<!--<div class="infobox infobox-grey infobox-small infobox-dark">-->
<!-- <div class="infobox-icon">-->
<!-- <i class="ace-icon fa fa-download"></i>-->
<!-- </div>-->
<!-- <div class="infobox-data">-->
<!-- <div class="infobox-content">Downloads</div>-->
<!-- <div class="infobox-content">1,205</div>-->
<!-- </div>-->
<!--</div>-->
</div>
</div>
</div>
<div class="row">
<div class="col-sm-12">
<h3 class="row header smaller lighter blue">
<!-- /.col -->
<!-- /.col -->
</h3>
<div id="accordion" class="accordion-style1 panel-group">
<div class="panel panel-default">
<div class="panel-heading">
<h4 class="panel-title" style='width:100%;'>
<a class="accordion-toggle" data-toggle="collapse" data-parent="#accordion" href="#collapseOne">
<i class="ace-icon fa fa-angle-down bigger-110" data-icon-hide="ace-icon fa fa-angle-down" data-icon-show="ace-icon fa fa-angle-right"></i>
Bed Occupancy Index
</a>
</h4>
</div>
<div class="panel-collapse collapse" id="collapseOne">
<div class="panel-body">
<?php include("showbed.php"); ?>
</div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-heading">
<h4 class="panel-title">
<a class="accordion-toggle collapsed" data-toggle="collapse" data-parent="#accordion" href="#collapseTwo">
<i class="ace-icon fa fa-angle-right bigger-110" data-icon-hide="ace-icon fa fa-angle-down" data-icon-show="ace-icon fa fa-angle-right"></i>
In Patient
</a>
</h4>
</div>
<div class="panel-collapse collapse" id="collapseTwo">
<div class="panel-body">
<?php include("IPD.php"); ?>
</div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-heading">
<h4 class="panel-title">
<a class="accordion-toggle collapsed" data-toggle="collapse" data-parent="#accordion" href="#collapseThree">
<i class="ace-icon fa fa-angle-right bigger-110" data-icon-hide="ace-icon fa fa-angle-down" data-icon-show="ace-icon fa fa-angle-right"></i>
Out Patient
</a>
</h4>
</div>
<div class="panel-collapse collapse" id="collapseThree">
<div class="panel-body">
<?php include("opd.php"); ?>
</div>
</div>
</div> </div>
</div>
</div><!-- /.col -->
<!-- ./row -->
</div></div>
<!-- PAGE CONTENT ENDS -->
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.page-content -->
</div>
</div><!-- /.main-content -->
<?php include('includes/footer.php') ?>
<a href="#" id="btn-scroll-up" class="btn-scroll-up btn btn-sm btn-inverse">
<i class="ace-icon fa fa-angle-double-up icon-only bigger-110"></i>
</a>
</div><!-- /.main-container -->
<!-- basic scripts -->
<!--[if !IE]> -->
<script src="assets/js/jquery-2.1.4.min.js"></script>
<!-- <![endif]-->
<!--[if IE]>
<script src="assets/js/jquery-1.11.3.min.js"></script>
<![endif]-->
<script type="text/javascript">
if('ontouchstart' in document.documentElement) document.write("<script src='assets/js/jquery.mobile.custom.min.js'>"+"<"+"/script>");
</script>
<script src="assets/js/bootstrap.min.js"></script>
<!-- page specific plugin scripts -->
<script src="assets/js/jquery-ui.min.js"></script>
<script src="assets/js/jquery.ui.touch-punch.min.js"></script>
<!-- ace scripts -->
<script src="assets/js/ace-elements.min.js"></script>
<script src="assets/js/ace.min.js"></script>
<script src="assets/js/jquery-ui.custom.min.js"></script>
<script src="assets/js/bootbox.js"></script>
<script src="assets/js/jquery.easypiechart.min.js"></script>
<script src="assets/js/jquery.gritter.min.js"></script>
<script src="assets/js/spin.js"></script>
<!-- ace scripts -->
<!-- inline scripts related to this page -->
<script type="text/javascript">
jQuery(function($) {
/**
$('#myTab a[data-toggle="tab"]').on('shown.bs.tab', function (e) {
//console.log(e.target.getAttribute("href"));
})
$('#accordion').on('shown.bs.collapse', function (e) {
//console.log($(e.target).is('#collapseTwo'))
});
*/
$('#myTab a[data-toggle="tab"]').on('shown.bs.tab', function (e) {
//if($(e.target).attr('href') == "#home") doSomethingNow();
})
/**
//go to next tab, without user clicking
$('#myTab > .active').next().find('> a').trigger('click');
*/
$('#accordion-style').on('click', function(ev){
var target = $('input', ev.target);
var which = parseInt(target.val());
if(which == 2) $('#accordion').addClass('accordion-style2');
else $('#accordion').removeClass('accordion-style2');
});
//$('[href="#collapseTwo"]').trigger('click');
///////////
$(document).one('ajaxloadstart.page', function(e) {
$.gritter.removeAll();
$('.modal').modal('hide');
});
});
</script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).ready(function () {
setInterval( function() {
$("#myMainDiv").load(location.href + " #myRefreshDiv");
}, 1000 );
setInterval( function() {
$("#myIPD_Div").load(location.href + " #IPD_Div");
}, 1000 );
});
var table = document.getElementById("myTable"), sumVal5 = 0;
$(".grand_total").each(function() {
sumVal5 += Number($(this).val());
});
var sum_v5=sumVal5.toFixed(2);
document.getElementById("grand_totalValue").innerHTML = "" + sum_v5;
$('#total_value').val(sumVal5);
</script>
</body>
</html>