Server IP : 162.240.98.243 / Your IP : 3.21.98.207 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 ?>