$offset=0; $offset=($pg-1)*$rowsToDisplay; //proceed with query $query=0; $query=mysqlquery("select * from vl_patients ".($patientID?"where uniqueID like '%$patientID%' or artNumber like '%$patientID%' or otherID like '%$patientID%'":"")." order by created desc limit $offset, $rowsToDisplay"); $xquery=0; $xquery=mysqlquery("select * from vl_patients ".($patientID?"where uniqueID like '%$patientID%' or artNumber like '%$patientID%' or otherID like '%$patientID%'":"")." order by created desc"); //number pages $numberPages=0; $numberPages=ceil(mysqlnumrows($xquery)/$rowsToDisplay); if(mysqlnumrows($query)) { //how many pages are there? if($numberPages>1) { echo "<tr><td style=\"padding:0px 0px 10px 0px\" class=\"vls_grey\"><strong>Pages:</strong> ".displayPagesLinks("/samples/manage.patients/pg/",1,$numberPages,($pg?$pg:1),$default_radius)."</td></tr>"; } ?> <tr> <td style="padding:0px 0px 10px 0px" class="vls_grey"><strong><?php echo mysqlnumrows($xquery); ?> </strong> Patient<?php echo mysqlnumrows($xquery) != 1 ? "s" : ""; ?> to Manage</td> </tr> <tr> <td> <div style="height: 250px; width: 100%; overflow: auto; padding:5px; border: 1px solid #d5e6cf"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
$offset=0; $offset=($pg-1)*$rowsToDisplay; //proceed with query $query=0; $query=mysqlquery("select * from vl_forms_clinicalrequest where (formNumber='$searchQuery' or refNumber='$searchQuery') order by created limit $offset, $rowsToDisplay"); $xquery=0; $xquery=mysqlquery("select * from vl_forms_clinicalrequest where (formNumber='$searchQuery' or refNumber='$searchQuery') order by created"); //number pages $numberPages=0; $numberPages=ceil(mysqlnumrows($xquery)/$rowsToDisplay); if(mysqlnumrows($query)) { //how many pages are there? if($numberPages>1) { echo "<tr><td style=\"padding:0px 0px 10px 0px\" class=\"vls_grey\"><strong>Pages:</strong> ".displayPagesLinks("/generateforms/search/".vlEncrypt($searchQuery)."/",1,$numberPages,($pg?$pg:1),$default_radius)."</td></tr>"; } ?> <tr> <td style="padding:10px 0px 10px 0px" class="vls_grey"><strong><?php echo mysqlnumrows($xquery); ?> </strong> form<?php echo mysqlnumrows($xquery) != 1 ? "s" : ""; ?> found while searching for <strong><?php echo $searchQuery; ?> </strong></td> </tr> <tr>
echo $modified == 1 ? "" : "s"; ?> modified within the "dispatched" list.</div> </td> </tr> <tr> <td> </td> </tr> <? } ?> <tr> <td> <table width="100%" border="0" class="vl" cellspacing="0" cellpadding="0"> <? //how many pages are there? if($numberPages>1) { echo "<tr><td style=\"padding:0px 0px 10px 0px\" class=\"vls_grey\"><strong>Pages:</strong> ".displayPagesLinks(($worksheetID || $facilityID?"/results/$machineType/".($worksheetID?"$worksheetID/":"0/").($facilityID?"$facilityID/":"0/").($showPrinted?"printed/":"")."pg/":"/results/$machineType/".($showPrinted?"printed/":"")."pg/"),1,$numberPages,($pg?$pg:1),$default_radius)."</td></tr>"; } ?> <tr> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="90%" valign="bottom"><table border="0" cellspacing="0" cellpadding="0"> <tr> <? if(!$showPrinted) { ?> <td class="bluetab_active"><?php echo "Not Yet Printed (" . number_format((double) $resultsNotPrinted) . ")"; ?> </td> <? } else { ?> <td class="bluetab_inactive"><a href="/results/"> <?php
<? //security check if(!$GLOBALS['vlDC'] || !$_SESSION["VLEMAIL"]) { die("<font face=arial size=2>You must be logged in to view this page.</font>"); } ?> <table width="100%" border="0" class="vl"> <tr> <td> <table width="100%" border="0" class="vl" cellspacing="0" cellpadding="0"> <? //how many pages are there? if($numberPages>1) { echo "<tr><td style=\"padding:0px 0px 10px 0px\" class=\"vls_grey\"><strong>Pages:</strong> ".displayPagesLinks("/reports/$statisticsType/pg/",1,$numberPages,($pg?$pg:1),$default_radius)."</td></tr>"; } ?> <tr> <td><table border="0" cellspacing="0" cellpadding="0"> <tr> <? if(!$statisticsType || $statisticsType=="national") { ?> <td class="bluetab_active">National Statistics</td> <? } else { ?> <td class="bluetab_inactive"><a href="/reports/national/">National Statistics</a></td> <? } ?> <td bgcolor="#C4CCCC"><img src="/images/spacer.gif" width="1" height="1" /></td> <? if($statisticsType=="district") { ?> <td class="bluetab_active">District Statistics</td> <? } else { ?> <td class="bluetab_inactive"><a href="/reports/district/">District Statistics</a></td> <? } ?> <td bgcolor="#C4CCCC"><img src="/images/spacer.gif" width="1" height="1" /></td>
} } //number pages $numberPages=0; $query=myQuery($condns,$offset,$rowsToDisplay); $the_count=mysqlquery("SELECT count(id) AS num FROM vl_samples WHERE $condns LIMIT 1"); $num_res=mysqlfetcharray($the_count); $num_rows=$num_res['num']; $numberPages=ceil($num_rows/$rowsToDisplay); if(mysqlnumrows($query)) { //how many pages are there? if($numberPages>1) { echo "<tr><td style=\"padding:0px 0px 10px 0px\" class=\"vls_grey\"><strong>Pages:</strong> ".displayPagesLinks("/verify/".($approvedstatus=="search"?"search/$encryptedSample":$approvedstatus)."/pg/",1,$numberPages,($pg?$pg:1),$default_radius)."</td></tr>"; } $numberOfRelevantSamples=0; $numberOfRelevantSamples=getDetailedTableInfo3("vl_samples","verified=0","count(id)","num"); $resultsPending=0; $resultsPending=$numberOfRelevantSamples; $resultsProcessed=0; $resultsProcessed=getDetailedTableInfo3("vl_samples"," verified=1","count(id)","num"); $resultsSearch=0; $resultsSearch=mysqlnumrows($query); ?> <tr>
$offset=0; $offset=($pg-1)*$rowsToDisplay; //proceed with query $query=0; $query=mysqlquery("select distinct refNumber from vl_forms_clinicalrequest order by created desc limit $offset, $rowsToDisplay"); $xquery=0; $xquery=mysqlquery("select distinct refNumber from vl_forms_clinicalrequest order by created desc"); //number pages $numberPages=0; $numberPages=ceil(mysqlnumrows($xquery)/$rowsToDisplay); if(mysqlnumrows($query)) { //how many pages are there? if($numberPages>1) { echo "<tr><td style=\"padding:0px 0px 10px 0px\" class=\"vls_grey\"><strong>Pages:</strong> ".displayPagesLinks("/generateforms/dispatch/pg/",1,$numberPages,($pg?$pg:1),$default_radius)."</td></tr>"; } ?> <tr> <td style="padding:10px 0px 10px 0px" class="vls_grey"><strong><?php echo mysqlnumrows($xquery); ?> </strong> Batch<?php echo mysqlnumrows($xquery) != 1 ? "es" : ""; ?> </td> </tr> <tr> <td> <div style="height: 250px; width: 100%; overflow: auto; padding:5px; border: 1px solid #d5e6cf"> <table width="100%" border="0" cellspacing="0" cellpadding="0">