query("SELECT * FROM labtesttypes")) { while ($row = $result->fetch_assoc() ) { $stss=$stss. ""; } } $connect->close(); ?> query("SELECT DISTINCT MEDICALTOPIC FROM medicalproblems")) { while ($row = $result->fetch_assoc() ) { $stssb=$stssb. ""; } } $connect->close(); ?> query("SELECT * FROM medicalproblems WHERE MEDICALTOPIC ='ART'")) { while ($row = $result->fetch_assoc() ) { $art=$art. ""; } } $connect->close(); ?> query("SELECT * FROM medicalproblems WHERE MEDICALTOPIC ='BODY CHANGES'")) { while ($row = $result->fetch_assoc() ) { $bcs=$bcs. ""; } } $connect->close(); ?> query("SELECT * FROM medicalproblems WHERE MEDICALTOPIC ='GENERAL'")) { while ($row = $result->fetch_assoc() ) { $genn=$genn. ""; } } $connect->close(); ?> query("SELECT * FROM medicalproblems WHERE MEDICALTOPIC ='GYNAECOLOGICAL CONDITIONS'")) { while ($row = $result->fetch_assoc() ) { $gyn=$gyn. ""; } } $connect->close(); ?> query("SELECT * FROM medicalproblems WHERE MEDICALTOPIC ='PREGNANCY'")) { while ($row = $result->fetch_assoc() ) { $pre=$pre. ""; } } $connect->close(); ?> query("SELECT * FROM medicalproblems WHERE MEDICALTOPIC ='SGBV CASES'")) { while ($row = $result->fetch_assoc() ) { $sgb=$sgb. ""; } } $connect->close(); ?> query("SELECT * FROM medicalproblems WHERE MEDICALTOPIC ='SIDE EFFECTS DRUG TOXICITIES ON ART'")) { while ($row = $result->fetch_assoc() ) { $sed=$sed. ""; } } $connect->close(); ?> query("SELECT * FROM medicalproblems WHERE MEDICALTOPIC ='STI/STD'")) { while ($row = $result->fetch_assoc() ) { $sti=$sti. ""; } } $connect->close(); ?> treatment room
Dashboard   

Reports       
PAC  

PNC  
Enrollment

Logout  
='$date' AND SERVICETYPE ='OTHER SERVICES' AND INSVCSTATUS ='NO' AND DATATYPE = 'ON SITE' GROUP BY NTIHCNO ORDER BY TIMESTAMP"); while($res = mysqli_fetch_array($result)) { $dtsxxc = $res['NTIHCNO']."***".$res['RID']."***".$res['AGE1']."***".$res['AGE_GROUP']."***".$res['SEX']."***".$res['RSVNID']."***".$res['DATECREATED']; echo ""; echo ""; echo ""; echo ""; echo ''; } ?>
VIST DATE NTIHC.NO CLIENT NAME ACTION
".$res['TIMESTAMP']."".$res['NTIHCNO']."".$res['CLIENTNAME']."  
='$date' GROUP BY NTIHCNO ORDER BY DATECREATED"); while($res = mysqli_fetch_array($result)) { $dtsget = $res['NTIHCNO']."***".$res['DATECREATED']."***".$res['DATECREATED']."***".$res['EID']; echo ""; echo ""; echo ""; echo ""; echo ''; echo ""; } ?>
DATE NTIHC.NO. NAME VIEW ACTION
".$res['DATECREATED']."".$res['NTIHCNO']."".$res['CLIENTNAME']."       Results | Prescribe

Clients due for medical services prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND SERVICETYPE ='MEDICAL SERVICES' AND INSVCSTATUS ='NO' GROUP BY NTIHCNO ORDER BY NTIHCNO DESC"); $result->execute(); $rowcount1 = $result->rowcount(); ?> No. clients served prepare("SELECT * FROM clientsexamination WHERE TIMESTAMP >='$date' AND REGISTERACCOUNT='$rm' GROUP BY NTIHCNO ORDER BY DATECREATED"); $result->execute(); $rowcount2 = $result->rowcount(); ?>
CLIENT MANAGEMENT - TREATMENT ROOM

Service date

Problem Type

Visit By

Problem brief
Urgency
Counselling done

HCG
If required

Referral
Activate

Follow up
If required

Action taken

Other services
Service status
Lab request
User lab tracker ='$date' AND TESTSTATUS ='NOT STARTED' AND MEDICAL ='1' AND LABVIST ='1' AND LABRESULTREVIEW ='NOTAPPLICABLE' AND USERINITIAL ='$nameofuser' GROUP BY NTIHCNO ")) { $row_cnt = mysqli_num_rows($result); printf("%d \n", $row_cnt); mysqli_free_result($result); } mysqli_close($link); ?> ='$date' AND TESTSTATUS ='COMPLETED' AND MEDICAL ='1' AND LABVIST ='1' AND LABRESULTREVIEW ='NOTAPPLICABLE' AND USERINITIAL ='$nameofuser' GROUP BY NTIHCNO")) { $row_cnt = mysqli_num_rows($result); printf("%d \n", $row_cnt); mysqli_free_result($result); } mysqli_close($link); ?>
User initials
Service provider

Pending lab requests prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND TESTSTATUS ='NOT STARTED' AND MEDICAL ='1' AND LABVIST ='1' AND LABRESULTREVIEW ='NOTAPPLICABLE' GROUP BY NTIHCNO"); $result->execute(); $rowcount5 = $result->rowcount(); ?> Completed lab orders prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND TESTSTATUS ='COMPLETED' AND MEDICAL ='1' AND LABVIST ='1' AND LABRESULTREVIEW ='NOTAPPLICABLE' GROUP BY NTIHCNO"); $result->execute(); $rowcount6 = $result->rowcount(); ?>

Internal referrals / Clients recommended for medical attention

='$date' AND SERVICEEXTENTIONSTATUS ='NULL' AND SERVICEEXTENTION = 'MEDICAL' GROUP BY NTIHCNO ORDER BY TIMESTAMP"); while($res = mysqli_fetch_array($result)) { $dtexplosion = $res['NTIHCNO']."***".$res['RID']."***".$res['AGE1']."***".$res['AGE_GROUP']."***".$res['SEX']."***".$res['DATECREATED']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ''; echo ""; } ?>
VIST DATE NTIHC.NO CLIENT NAME REQUESTING UNIT SENT BY TIME IN SERVICE ACTION
".$res['DATECREATED']."".$res['NTIHCNO']."".$res['CLIENTNAME']."".$res['INSVCSTATUS']."".$res['USERINITIAL']."".$res['TIMEOUT']."               Results | Prescribe
List of clients processed from outreach "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ''; } ?>
VIST DATE NTIHC.NO CLIENT NAME SERVICE INFO PROCESSED BY TIME IN ACTION
".$res['DATECREATED']."".$res['NTIHCNO']."".$res['CLIENTNAME']."".$res['SERVICETYPE']."".$res['USERINITIAL']."".$res['CHECKIN']."