| Server IP : 162.240.98.243 / Your IP : 18.223.206.225 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");
if(isset($_POST['save'])){
//$count=count($_POST['prescriptionid']);
foreach($_POST['prescriptionid'] as $i => $value)
{
$created_at=date("F d, Y / h:i:s A");
$ReportDate= date("Y-m-d");
$TimeIn= date('H:i:s');
$pathreportfinal=$con->query("INSERT INTO `pathreportfinal`(`prescriptionid`,`patientid`,`requesttestid`,`testid`,`unit`,`result`,`min`,`max`, `ReportDate`, `TimeOut`,`entered_by`,`created_at`) VALUES ('{$_POST['prescriptionid'][$i]}','{$_POST['patientid'][$i]}','{$_POST['requesttestid'][$i]}','{$_POST['testid'][$i]}','{$_POST['unit'][$i]}','{$_POST['result'][$i]}','{$_POST['min'][$i]}','{$_POST['max'][$i]}','$ReportDate','$TimeIn','{$_POST['entered_by'][$i]}','$created_at')");
}
if($pathreportfinal==1){
echo "<script>alert('Records Save Successfully..');</script>";
}
}
?>
<?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);
while($re = mysqli_fetch_array($qsql1))
{
$sql2 ="SELECT * FROM site_users WHERE entered_by='$re[entered_by]' AND usertype='Hospital'";
$qsql2 = mysqli_query($con,$sql2);
if($re1 = mysqli_fetch_array($qsql2))
{
if(Hospital==$re1[usertype])
{
?>
<?php
include 'dashboarddocument.php';
?>
<?php
}
}
}
?>
<?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);
while($re = mysqli_fetch_array($qsql1))
{
$sql2 ="SELECT * FROM site_users WHERE entered_by='$re[entered_by]' AND usertype='LABORATORY'";
$qsql2 = mysqli_query($con,$sql2);
if($re1 = mysqli_fetch_array($qsql2))
{
if(LABORATORY==$re1[usertype])
{
?>
<?php
include 'patient_menu.php';
?>
<?php
}
}
}
?>
<?php
session_start();
$DisplayForm=True;
$sql ="SELECT * FROM investigation WHERE id='$_GET[id]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
$sql1 ="SELECT * FROM pathreportfinal WHERE requesttestid='$rs[id]'";
$qsql1 = mysqli_query($con,$sql1);
if($rh1 = mysqli_fetch_array($qsql1))
{
$DisplayForm=False;
echo "";
}
if(!$DisplayForm)
{
echo "<script>window.location='upate_report.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]'</script>;</script>";
} else{
?>
<style>
.center {
border: 1px solid grey;
text-align:;
}
.center2 {
border: 5px solid grey;
text-align:;
}
</style>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<div class='center'>
<form method="POST">
<table id='example2' class='table table-bordered table-hover'>
<tr>
<th>Test Description </th>
<th>Unit </th>
<th>Result </th>
<th>Normal Value </th>
</tr>
<?php
session_start();
include("dbconnection.php");
$sql ="SELECT * FROM investigation WHERE Investigation_type='Pathology' AND id='$_GET[id]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$sql ="SELECT * FROM Test_Description_final WHERE ivid='$rs[ivid]'";
$qsql = mysqli_query($con,$sql);
while($rspi = mysqli_fetch_array($qsql))
{
$sql1 ="SELECT * FROM patient WHERE patientid='$rs[patientid]'";
$qsql1 = mysqli_query($con,$sql1);
while($rspi1 = mysqli_fetch_array($qsql1))
{
$age=$rspi1['dob'];
$sex=$rspi1['gendor'];
echo" <tr> <td>$rspi[Test_Description]<input type='hidden' name='prescriptionid[]' value='$_GET[prescriptionid]'>
<input type='hidden' name='patientid[]' value='$_GET[patientid]'>
<input type='hidden' name='requesttestid[]' value='$rs[id]'>
<input type='hidden' name='testid[]' value='$rspi[testdesid]'></td>
<td><input type='text' size='2' name='unit[]' value='$rspi[Unit]'></td>
<td><input size='2' type='text' name='result[]' ></td>
<td>";
if($sex == 'Male'){
if($rspi[all_min] == ''){
if($age>=65)
{
echo "<span>Min</span><input type='text' name='min[]' size='2' value='$rspi[mold_min]'><span>Max</span><input type='text' name='max[]' size='2' value='$rspi[mold_max]'>";
}
elseif ($age>=1 && $age<14)
{
echo "<span>Min</span><input type='text' name='min[]' size='2' value='$rspi[mChild_min]'><span>Max</span><input type='text' name='max[]' size='2' value='$rspi[mChild_max]'>" ;
}
elseif ($age>=15 && $age <24)
{
echo "<span>Min</span><input type='text' name='min[]' size='2' value='$rspi[mSenior_Citizen_min]'><span>Max</span><input type='text' name='max[]' size='2' value='$rspi[mSenior_Citizen_max]'>";
}
elseif ($age>=25 && $age <64)
{
echo "<div class='checkbox'><span>Min</span><input type='text' name='min[]' size='2' value='$rspi[mAdult_min]'><span>Max</span><input type='text' name='max[]' size='2' value='$rspi[mAdult_max]'></div>";
}
else
{
echo "<span>Min</span><input type='text' name='min[]' size='2' value='$rspi[mNewborn_min]'><span>Max</span><input type='text' name='max[]' size='2' value='$rspi[mNewborn_max]'>";
}
}
else{
echo "<span>Min</span><input type='text' name='min[]' size='2' value='$rspi[all_min]'><span>Max</span><input type='text' name='max[]' size='2' value='$rspi[all_max]'>";
}
}
else{
if($rspi[all_min] == ''){
if($age>=65)
{
echo "<span>Min</span><input type='text' name='min[]' size='2' value='$rspi[fold_min]'><span>Max</span><input type='text' name='max[]' size='2' value='$rspi[fold_max]'>";
}
elseif ($age>=1 && $age<14)
{
echo "<span>Min</span><input type='text' name='min[]' size='2' value='$rspi[fChild_min]'><span>Max</span><input type='text' name='max[]' size='2' value='$rspi[fChild_min]'>" ;
}
elseif ($age>=15 && $age <24)
{
echo "<span>Min</span><input type='text' name='min[]' size='2' value='$rspi[fSenior_Citizen_min]'><span>Max</span><input type='text' name='max[]' size='2' value='$rspi[fSenior_Citizen_max]'>";
}
elseif ($age>=25 && $age <64)
{
echo "<div class='checkbox'><span>Min</span><input type='text' name='min[]' size='2' value='$rspi[fAdult_min]'><span>Max</span><input type='text' name='max[]' size='2' value='$rspi[fAdult_max]'></div>";
}
else
{
echo "<span>Min</span><input type='text' name='min[]' size='2' value='$rspi[fNewborn_min]'><span>Max</span><input type='text' name='max[]' size='2' value='$rspi[fNewborn_max]'>";
}
}
else{
echo "<span>Min</span><input type='text' name='min[]' size='2' value='$rspi[all_min]'><span>Max</span><input type='text' name='max[]' size='2' value='$rspi[all_max]'>";
}
}
echo"
<input size='2' name='entered_by[]' type='hidden' value='$rs[entered_by]'>
</td>
</tr>";
}
}
}
?>
</table>
<input type="submit" value="Submit" name='save'>
</form>
<?php
$sql ="SELECT * FROM Test_Description_final WHERE ivid='$_GET[ivid]'";
$qsql = mysqli_query($con,$sql);
if($rspi = mysqli_fetch_array($qsql))
{
echo"
<p align='right'> <a href='add_test_description.php?ivid=$rspi[ivid]' >Add Value</a></p>
";
}
?>
</div>
<?php
}
}
?>
<?php
?>