| Server IP : 162.240.98.243 / Your IP : 18.216.44.143 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("../LoginManager.php");
require_once("../DBManager.php");
include("dashboarddocument.php");
include("header.php");
?>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<?php session_start();
require_once("../patientmanager.php");
require_once("../DBManager.php");
if(isset($_POST[investig])) {
PatientManager::nayainvestigation("$_GET[prescriptionid]","$_GET[patientid]","$_POST[hospital_id]","$_POST[Raised_at]","$_POST[Investigation_type]","$_POST[Category]","$_POST[Sub_Category]","$_POST[Priority_slip]","$_POST[Investigation]","$_POST[ivid]","$_POST[Result]","$_POST[Evidence]","$_POST[enteredby]");
}
?>
<?php
include("dbconnection.php");
if(isset($_GET[delid]))
{
$sql ="DELETE FROM investigation WHERE id='$_GET[delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
?>
<script>
function myFunction2() {
var checkBox = document.getElementById("myCheck2");
var text = document.getElementById("text2");
if (checkBox.checked == true){
text.style.display = "block";
} else {
text.style.display = "none";
}
}
function myFunction3() {
var checkBox = document.getElementById("myCheck3");
var text = document.getElementById("text3");
if (checkBox.checked == true){
text.style.display = "block";
} else {
text.style.display = "none";
}
}
</script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$('#myForm').submit(function() {
$('#loaderImg').show();
return true;
});
});
$(document).ready(function(){
$('#myForm2').submit(function() {
$('#loaderImg').show();
return true;
});
});
</script>
<style>
#loaderImg {
position: absolute;
top: 0;
bottom: 0;
left: 0;
right: 0;
margin: auto;
border: 10px solid grey;
border-radius: 50%;
border-top: 10px solid black;
width: 100px;
height: 100px;
animation: spin 1s linear infinite;
z-index:1000000;
}
@keyframes spin {
0% {
-webkit-transform: rotate(0deg);
transform: rotate(0deg);
}
100% {
-webkit-transform: rotate(360deg);
transform: rotate(360deg);
}
}
</style>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/js/standalone/selectize.min.js" integrity="sha256-+C0A5Ilqmu4QcSPxrlGpaZxJ04VjsRjKu+G82kl5UJk=" crossorigin="anonymous"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/css/selectize.bootstrap3.min.css" integrity="sha256-ze/OEYGcFbPRmvCnrSeKbRTtjG4vGLHXgOqsyLFTRjg=" crossorigin="anonymous" />
<div class='center'>
<link rel="stylesheet" href="select2.min.css" />
<style>
.select2-dropdown {top: 22px !important; left: 8px !important;}
</style>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<h3 align="center">Investigation</h3>
<div style = "display:none;" id = "loaderImg"> <div class="loader"> </div> </div>
<form name="investig" method="post" id="myForm" >
<table id="example2" class="table table-bordered table-hover">
<thead>
<input type='hidden' name='Raised_at' value='Opd Slip'>
<tr>
<td>
<input type="checkbox" name="Investigation_type" value='Radiology' id="myCheck2" onclick="myFunction2()">
<td><span>Radiology</span></td>
</td>
</tr>
</thead>
</table>
<div id="text2" style="display:none">
<table id="example2" class="table table-bordered table-hover">
<tr> <td></td>
<td>
<select onchange="LOADivnvi(this.value)" name="Investigation" style='width:25%;float:right;'>
<option value="">Search</option>
<?php
session_start();
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))
{
$sql ="SELECT * FROM list_Investigation Where labdepartmentid='Unspecified' AND adminid='$re[entered_by]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "<option value='$rs[ivid]'>$rs[Investigation]</option>";
}
}
?>
</td>
</select>
</tr>
</table>
<div id='preinvID'>
<table id="example2" class="table table-bordered table-hover">
<tr>
<td>Select Investigation</td>
<td>
<select onchange="BODYPARLOAD(this.value)" name="Category">
<option value="" selected="selected">Select Investigation</option>
<option value="10">Ultrasound & Doppler</option>
<option value="11">MRI</option>
<option value="12">CT + 3D</option>
<option value="13">X RAYS</option>
<option value="14">Fluoroscopy</option>
<option value="15">Mammography</option>
<option value="16">Biometry</option>
</select>
</td></tr>
<tr><td>Body Part</td><td id='BODYPARTID'>
</td></tr>
<tr>
<td>Request Investigation</td>
<td id='RADIOBODYID'>
</td></tr>
</table>
</div>
</div>
<table id="example2" class="table table-bordered table-hover">
<tr>
<td>Priority slip </td>
<td><select name="Priority_slip">
<option value="">Priority slip </option>
<option value="Urgent">Urgent </option>
<option value="Normal" selected="selected">Normal </option>
</td>
</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))
{
echo"
<input type='hidden' name='hospital_id' value='$re[entered_by]'>
";
}
?>
<tr><td></td><td>
<input type="submit" value="Add" name="investig" class='btn btn-info'></td></tr>
</form>
</div>
</table>
<div style = "display:none;" id = "loaderImg"> <div class="loader"> </div> </div>
<form name="investig" method="post" id="myForm2" >
<table id="example2" class="table table-bordered table-hover">
<thead>
<input type='hidden' name='Raised_at' value='Opd Slip'>
<tr>
<td>
<input type="checkbox" name="Investigation_type" value='Pathology' id="myCheck3" onclick="myFunction3()">
</td>
<td><span>Pathology</span></td>
</tr>
</thead>
</table>
<div id="text2" style="display:none">
<table id="example2" class="table table-bordered table-hover">
<tr> <td></td>
<td>
<select onchange="LOADivnvi(this.value)" name="Investigation">
<option value="">Search</option>
<?php
session_start();
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))
{
$sql ="SELECT * FROM list_Investigation Where labdepartmentid='Unspecified' AND adminid='$re[entered_by]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "<option value='$rs[ivid]'>$rs[Investigation]</option>";
}
}
?>
</td>
</select>
</tr>
</table>
<div id='preinvID'>
<table id="example2" class="table table-bordered table-hover">
<tr>
<td>Select Investigation</td>
<td>
<select onchange="BODYPARLOAD(this.value)" name="Category">
<option value="" selected="selected">Select Investigation</option>
<option value="10">Ultrasound & Doppler</option>
<option value="11">MRI</option>
<option value="12">CT + 3D</option>
<option value="13">X RAYS</option>
<option value="14">Fluoroscopy</option>
<option value="15">Mammography</option>
<option value="16">Biometry</option>
</select>
</td></tr>
<tr><td>Body Part</td><td id='BODYPARTID'>
</td></tr>
<tr>
<td>Request Investigation</td>
<td id='RADIOBODYID'>
</td></tr>
</table>
</div>
</div> <div id="text3" style="display:none">
<table id="example2" class="table table-bordered table-hover">
<tr> <td>Request Investigation</td>
<td>
<select name="ivid">
<option value="">Investigation</option>
<?php
include("dbconnection.php");
$sqlpatient1 = "SELECT * FROM list_Investigation";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo "<option value='$rsn[ivid]'>$rsn[Investigation]</option>";
}
?>
</td>
</select>
</tr>
</table>
</div>
<table id="example2" class="table table-bordered table-hover">
<tr>
<td>Priority slip </td>
<td><select name="Priority_slip">
<option value="">Priority slip </option>
<option value="Urgent">Urgent </option>
<option value="Normal" selected="selected">Normal </option>
</td>
</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))
{
echo"
<input type='hidden' name='hospital_id' value='$re[entered_by]'>
";
}
?>
<tr><td></td><td>
<input type="submit" value="Add" name="investig" class='btn btn-info'></td></tr>
</form>
</div>
</table>
<table id="example2" id ="demo" class="table table-bordered table-hover">
<thead>
<tr>
<div id="listingTable">
<div class='card-header d-flex p-0'>
<ul class='nav nav-pills ml-auto p-2'>
<th><strong>Date Time</strong></th>
<th><strong>Investigation</strong></th>
<th><strong>Result</strong></th>
<th><strong>Evidence</strong></th>
<th><strong>Action</strong></th>
</tr>
</thead>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM investigation WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo " <tbody>
<tr> <td> $rs[created_at]</td>
<td> ";
if (is_numeric($rs[Category]))
{
$sql1 ="SELECT * FROM labdepartment WHERE labdepartmentid='$rs[Category]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
echo "$rh1[lab_department_name]";
}
if (is_numeric($rs[Sub_Category]))
{
$sql1 ="SELECT * FROM radiobodypart WHERE radiobodypartid='$rs[Sub_Category]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
echo "- $rh1[bodypart]";
}
if (is_numeric($rs[Sub_Category]))
{
$sql1 ="SELECT * FROM list_Investigation WHERE ivid='$rs[Investigation]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
echo "- $rh1[Investigation]";
}
$sqlpatient1 = "SELECT * FROM list_Investigation WHERE ivid='$rs[ivid]' OR ivid='$rs[Investigation]' AND labdepartmentid='Unspecified'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
/* Check file exenstion.*/
$evedance="-";
if(!empty($rs['Evidence'])){
$info = pathinfo($rs['Evidence']);
if(in_array($info["extension"],array("jpg","jpeg","png"))){
$evedance="<a href='uploads/".$rs['Evidence']."' target='_blank' />".$rs['Evidence']."</a>";
}
}
/* Check file exenstion.*/
//<td><a href='opdset.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[id]'>Delete</a></td>
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo"
$rsn[Investigation]"; }
echo"</b></td>
<td>$rs[Result]</td>
<td> $evedance</td>
<td><a href='testopdslip2.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[id]'>Delete</a></td>
</tr>
";
}
?>
</tbody>
</table>
</div>
<div class='container'>
<div class='row'>
<div class='col-sm-12'>
<center><a href='testopdslip3.php?prescriptionid=<?php echo $_GET['prescriptionid'] ?>&patientid=<?php echo $_GET['patientid'] ?>' style='text-align:center;margin:12px;' class='btn btn-info'>Next Page</a></center>
</div>
</div>
</div>
<script>
function BODYPARLOAD(BODYid)
{
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("BODYPARTID").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","loadiv.php?BODYid="+BODYid,true);
xmlhttp.send();
}
</script>
<script>
function RADIOBODYLOAD(RADIOBODY)
{
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("RADIOBODYID").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","loadbodyiv.php?RADIOBODY="+RADIOBODY,true);
xmlhttp.send();
}
$(document).ready(function () {
$('select').selectize({
sortField: 'text'
});
});
</script>
<script>
function LOADivnvi(invid)
{
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("preinvID").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","loadinvi.php?invid="+invid,true);
xmlhttp.send();
}
</script>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/js/standalone/selectize.min.js" integrity="sha256-+C0A5Ilqmu4QcSPxrlGpaZxJ04VjsRjKu+G82kl5UJk=" crossorigin="anonymous"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/css/selectize.bootstrap3.min.css" integrity="sha256-ze/OEYGcFbPRmvCnrSeKbRTtjG4vGLHXgOqsyLFTRjg=" crossorigin="anonymous" />
</head>
<script>
$(document).ready(function () {
$('select12').selectize({
sortField: 'text'
});
});
</script>