$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">
