| Server IP : 162.240.98.243 / Your IP : 3.22.61.218 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/www/login.easenup.in/FO/ |
Upload File : |
<table id="dynamic-table" class="table table-striped table-bordered table-hover">
<thead>
<tr>
<th>SR No</th>
<th>Admitted_Under</th>
<th>Patient Details</th>
<th>Details </th>
</tr>
</thead>
<tbody>
<?php
$today = date('Y-m-d');
$sql91 ="SELECT * FROM site_users WHERE userno='$_GET[drid]'";
$qsql91 = mysqli_query($con,$sql91);
if($re91 = mysqli_fetch_array($qsql91))
{
//$sql21 ="SELECT * FROM discharge WHERE hospital_id='$re91[entered_by]' AND typevisit='OPD' AND date(admissiondate) = '$today' ORDER BY id DESC";
$sql21 ="SELECT * FROM discharge WHERE hospital_id='$re91[entered_by]' AND date(admissiondate) = '$today' AND (typevisit='OPD' OR typevisit='Opd_Emergency' OR typevisit='OPD_Routine' )";
$qsql21 = mysqli_query($con,$sql21);
while($rs1 = mysqli_fetch_array($qsql21))
{
$sql31 ="SELECT * FROM addaspatient WHERE prescriptionid='$rs1[prescriptionid]' AND Admitted_Under='$re91[userno]'";
$qsql31 = mysqli_query($con,$sql31);
while($rsr1 = mysqli_fetch_array($qsql31))
{
$sql41 ="SELECT * FROM patient WHERE patientid='$rsr1[patientid]'";
$qsql41 = mysqli_query($con,$sql41);
while($rp1 = mysqli_fetch_array($qsql41))
{
if($rsr1[triage] == 'Immediate_Care'){
echo "
<tr style='background-color:#cd3301'>
<td> </td>
<td>UHID :$rp1[patientid]
<br>
Patient Name<br>$rp1[patientname]</td>
<td> $re91[name]<br> ($rsr1[casetype])</td>
<td><a href='treatment_timline.php?prescriptionid=$rs1[prescriptionid]&patientid=$rs1[patientid]'>View</td>
</tr>
";
}
elseif($rsr1[triage] == 'Urgent_Care'){
echo "
<tr style='background-color:#ffff00'>
<td> </td>
<td>UHID :$rp1[patientid]
<br>
Patient Name<br>$rp1[patientname]</td>
<td> $re91[name] <br> ($rsr1[casetype])</td>
<td><a href='treatment_timline.php?prescriptionid=$rs1[prescriptionid]&patientid=$rs1[patientid]'>View</td>
</tr>
";
}
else
{
echo "
<tr style='background-color:#00fe81'>
<td> </td>
<td>UHID :$rp1[patientid]
<br>
Patient Name<br>$rp1[patientname]</td>
<td> $re91[name] <br> ($rsr1[casetype])</td>
<td><a href='treatment_timline.php?prescriptionid=$rs1[prescriptionid]&patientid=$rs1[patientid]'>View</td>
</tr>
";
}
}
}
}
}
?>
</tbody>
<tfoot>
</tfoot>
</table>