query("SELECT * FROM labtesttypes")) { while ($row = $result->fetch_assoc() ) { $stss=$stss. ""; } } $connect->close(); ?> Lab
Dashboard   

Reports       
Client history

Requisition   
='$date' AND LABVIST ='1' AND TESTSTATUS ='COMPLETED' GROUP BY NTIHCNO ORDER BY TIMESTAMP"); while($res = mysqli_fetch_array($result)) { $dtsxxc = $res['RID']."***".$res['NTIHCNO']."***".$res['AGE1']."***".$res['AGE_GROUP']."***".$res['SEX']."***".$res['RSVNID']."***".$res['DATECREATED']; echo ""; echo ""; echo ""; echo ""; echo ''; echo ""; } ?>
VIST DATE NTIHC.NO CLIENT NAME ACTION
".$res['TIMESTAMP']."".$res['NTIHCNO']."".$res['CLIENTNAME']."          CLICK
"; echo ""; echo ""; echo ""; echo ''; } ?>
DATE NTIHC.NO. NAME ACTION
".$res['TIMESTAMP']."".$res['NTIHCNO']."".$res['CLIENTNAME']."  
Clients due for Testing prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND LABVIST ='1' AND TESTSTATUS ='NOT STARTED' ORDER BY NTIHCNO DESC"); $result->execute(); $rowcount1 = $result->rowcount(); ?> No. completed clients prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND LABVIST ='1' AND TESTSTATUS ='COMPLETED' AND LABOREDRSTATUS='NULL' GROUP BY NTIHCNO ORDER BY DATECREATED"); $result->execute(); $rowcount2 = $result->rowcount(); ?>
Clients Management - Laboratory

Test date Requesting unit
Initiated by Vist type

* SPECIMEN HEAMATOLOGY/SEROLOGY MALARIA STOOL MICROSCOPY URINE MICROSCOPY SWABS.TYPE WET.PREP GRAM STAIN


Lab technician Title



Clients due for urgent results    prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND LABVIST ='1' AND TESTSTATUS ='PROGRESSING' GROUP BY NTIHCNO ORDER BY DATECREATED"); $result->execute(); $rowcount5 = $result->rowcount(); ?>
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ''; echo ""; } ?>
VIST DATE NTIHC NO. CLIENT NAME REQUESTED BY SUB UNIT STATUS ACTION
".$res['TIMESTAMP']."".$res['NTIHCNO']."".$res['CLIENTNAME']."".$res['SERVICEPROVIDER']."".$res['REQUESTINGUNIT']."".$res['TESTSTATUS']."          Add results