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(); ?>
Service date |
---|
Problem Type |
---|
Visit By |
---|
Problem brief |
---|
Urgency |
Counselling done |
---|
If required |
---|
Activate |
---|
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(); ?> |
---|