/** * function to randomly encrypt a string * generate random string * append to vl encrypted string * base64_encrypt the string */ function vlRencrypt($string) { //return encrypted string return generateRandomString().vlEncrypt($string); }
<td class="vl_tdsub" width="10%"><strong>Other ID</strong></td> <td class="vl_tdsub" width="5%" align="center"><strong>Samples</strong></td> <td class="vl_tdsub" width="70%"><strong>Facility</strong></td> <td class="vl_tdsub" width="4%"><strong>Options</strong></td> </tr> <? $count=0; $count=$offset; $q=array(); while($q=mysqlfetcharray($query)) { $count+=1; $numberSamples=0; $numberSamples=getDetailedTableInfo3("vl_samples","patientID='$q[id]'","count(id)","num"); $sampleURL=0; if($numberSamples==1) { $sampleURL="href=\"/samples/find.and.edit/search/".vlEncrypt(getDetailedTableInfo2("vl_samples","patientID='$q[id]'","vlSampleID"))."/\""; } elseif($numberSamples>1) { $sampleURL="href=\"#rn\" onclick=\"iDisplayMessage('/samples/preview/$q[id]/')\""; } ?> <tr onMouseover="this.bgColor='#f0e6dd'" onMouseout="this.bgColor='#FFFFFF'"> <td class="<?php echo $count < mysqlnumrows($xquery) ? "vl_tdstandard" : "vl_tdnoborder"; ?> "><?php echo $count; ?> </td> <td class="<?php echo $count < mysqlnumrows($xquery) ? "vl_tdstandard" : "vl_tdnoborder"; ?>
<tr> <td style="padding:5px 0px 0px 0px"><a href="#" onclick="sendPassword(this)" class="vl_brown_link">Forgotten password?</a></td> </tr> </table> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td bgcolor="#cccccc" style="padding:20px; border-top: 1px #b3b3b3 solid; background-image:url(/images/login.bg.prelogin.jpg); background-repeat: no-repeat; background-position: center right"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="vl"> <tr> <td><input type="submit" name="Submit" value="login" class="button" /> <input name="redirect" type="hidden" id="redirect" value="<?php echo $redirect ? $redirect : vlEncrypt($_SERVER['REQUEST_URI']); ?> " /> <input name="login" type="hidden" id="login" value="1" /> </td> </tr> </table></td> </tr> </table> </form> </td> <td background="/images/bg.right.gif"><img src="/images/spacer.gif" width="11" height="11"></td> </tr> </table></td> </tr> <tr>
go("/samples/manage.patients/search/".vlEncrypt($searchQuery)."/"); break; case "VerifySamples": go("/verify/search/".vlEncrypt($searchQuery)."/"); break; case "unVerifySamples": go("/verify/search.unverified/".vlEncrypt($searchQuery)."/"); break; case "Worksheets": go("/worksheets/manage/search/".vlEncrypt($searchQuery)."/"); break; case "GeneratedForms": go("/generateforms/search/".vlEncrypt($searchQuery)."/1/"); break; case "Results": go("/results/search/".vlEncrypt($searchQuery)."/"); break; case advanced: include "tpl.search.advanced.php"; break; } } break; case generateforms: include "tpl.generateforms.php"; break; case worksheets: include "tpl.worksheets.php"; break; case reports: include "tpl.reports.php";
$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>
?> </div> </td> </tr> </table> <!-- End Printed/Not Printed Items --> </td> </tr> <tr> <td style="padding:10px 0px 10px 0px"> <input type="hidden" name="rawQuery" id="rawQuery" value="<?php echo vlEncrypt($rawQuery); ?> " /> <input type="hidden" name="xRawQuery" id="xRawQuery" value="<?php echo vlEncrypt($xRawQuery); ?> " /> <input type="hidden" name="machineType" id="machineType" value="<?php echo $machineType; ?> " /> <input type="hidden" name="sampleIDField" id="sampleIDField" value="<?php echo $sampleIDField; ?> " /> <input type="submit" name="printResults" id="printResults" class="button" value=" Print Selected Results " onclick="document.pressed=this.value" /> <input type="submit" name="dispatchResults" id="dispatchResults" class="button" value=" Dispatch Selected Results " onclick="document.pressed=this.value" /> <? if(($facilityID || $worksheetID) && $numberPages>1) { ?><input type="submit" name="dispatchResults" id="dispatchResults" class="button" value=" Dispatch All <?php echo number_format((double) $numberRecords); ?>
'$machineType','".preg_replace("/,/s","",preg_replace("/</is","<",$result))."','".(getDetailedTableInfo2("vl_samples_verify","sampleID='$q[id]' and outcome='Accepted' and created!='' limit 1","id")?getRawFormattedDateLessDay(getDetailedTableInfo2("vl_samples_verify","sampleID='$q[id]' and outcome='Accepted' limit 1","created")):"")." ".(getDetailedTableInfo2("vl_samples_verify","sampleID='$q[id]' and outcome='Accepted' and created!='' limit 1","id")?getFormattedTimeLessS(getDetailedTableInfo2("vl_samples_verify","sampleID='$q[id]' and outcome='Accepted' limit 1","created")):"")."', '".(getDetailedTableInfo2("vl_samples_verify","sampleID='$q[id]' and outcome='Rejected' and created!='' limit 1","id")?getRawFormattedDateLessDay(getDetailedTableInfo2("vl_samples_verify","sampleID='$q[id]' and outcome='Rejected' limit 1","created")):"")." ".(getDetailedTableInfo2("vl_samples_verify","sampleID='$q[id]' and outcome='Rejected' and created!='' limit 1","id")?getFormattedTimeLessS(getDetailedTableInfo2("vl_samples_verify","sampleID='$q[id]' and outcome='Rejected' limit 1","created")):"")."', '".preg_replace("/'/s","\'",preg_replace("/,/s","",getDetailedTableInfo2("vl_appendix_samplerejectionreason","id='".getDetailedTableInfo2("vl_samples_verify","sampleID='$q[id]' and outcome='Rejected' limit 1","outcomeReasonsID")."' limit 1","appendix")))."','".(getDetailedTableInfo2("vl_samples_worksheet","sampleID='$q[id]' and created!='' limit 1","id")?getRawFormattedDateLessDay(getDetailedTableInfo2("vl_samples_worksheet","sampleID='$q[id]' order by created desc limit 1","created")):"")." ".(getDetailedTableInfo2("vl_samples_worksheet","sampleID='$q[id]' and created!='' limit 1","id")?getFormattedTimeLessS(getDetailedTableInfo2("vl_samples_worksheet","sampleID='$q[id]' order by created desc limit 1","created")):"")."', '".($dateLatestResultsUploaded?getRawFormattedDateLessDay($dateLatestResultsUploaded):"")." ".($dateLatestResultsUploaded?getFormattedTimeLessS($dateLatestResultsUploaded):"")."','".($dateLatestResultsPrinted?getRawFormattedDateLessDay($dateLatestResultsPrinted):"")." ".($dateLatestResultsPrinted?getFormattedTimeLessS($dateLatestResultsPrinted):"")."', '".getRawFormattedDateLessDay($q["receiptDate"])." 10:00','".($dateFirstPrinted?getRawFormattedDateLessDay($dateFirstPrinted):"")." ".($dateFirstPrinted?getFormattedTimeLessS($dateFirstPrinted):"")."','".getRawFormattedDateLessDay($q["created"])." ".getFormattedTimeLessS($q["created"])."')"); } } //to avoid conflicts, remove file if exists if(file_exists("$path"."$downloadFileName")) { unlink("$path"."$downloadFileName"); } //export the file mysqlquery("select distinct * into outfile '$path"."$downloadFileName' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' from vl_output_samplescsv"); go("/reports/downloads/success/".vlEncrypt("$pathURL"."$downloadFileName")."/"); break; case "samplesreceivedexcel": //filename of the excel file to be downloaded $filename=0; $filename="excel.samplesreceived.".getFormattedDateCRB($datetime).".xls"; //create an instance of the class $xls = new ExportXLS($filename); //period $from=0; $from="$fromYear-$fromMonth-$fromDay"; $to=0; $to="$toYear-$toMonth-$toDay";
$result=0; $rawResult=0; if($type=="roche") { $rawResult=getDetailedTableInfo2("vl_results_roche","worksheetID='$worksheetID' and SampleID='$sampleNumber' order by created desc limit 1","Result"); } elseif($type=="abbott") { $rawResult=getDetailedTableInfo2("vl_results_abbott","worksheetID='$worksheetID' and sampleID='$sampleNumber' order by created desc limit 1","result"); } $result=getVLResult($type,$worksheetID,$sampleNumber,$factor); $contents[]="<div align=\"center\" class=\"vls\">$i</div> <div align=\"center\" class=\"vls\" style=\"padding:3px 0px 0px 0px\">Patient ART #: $patientART</div> <div align=\"center\" class=\"vls\" style=\"padding:3px 0px 0px 0px\">Other ID: $otherID</div> <div align=\"center\" class=\"vls\" style=\"padding:1px 0px 0px 0px\">Sample #: $sampleNumber</div> ".($locationID?"<div align=\"center\" class=\"vls\" style=\"padding:1px 0px 0px 0px\">Location ID: $locationID</div> ":"")." <div align=\"center\" class=\"vls\" style=\"padding:1px 0px 0px 0px\">Form #: $formNumber</div> <div align=\"center\" style=\"padding:5px 0px\"><img src=\"/worksheets/image/".vlEncrypt($sampleNumber)."/\" /></div> ".($rawResult?"<div align=\"center\" class=\"vls\" style=\"padding:5px 0px 0px 0px; border-top: 1px dashed #cccccc\">Result: $result</div>":""); //log printed status if(!getDetailedTableInfo2("vl_logs_worksheetsamplesviewed","sampleID='$sampleID' and worksheetID='$worksheetID' limit 1","id")) { mysqlquery("insert into vl_logs_worksheetsamplesviewed (sampleID,worksheetID,created,createdby) values ('$sampleID','$worksheetID','$datetime','$trailSessionUser')"); } } } ?> <div class="vl" style="padding:0px 0px 10px 0px; border-bottom: 1px dashed #cccccc"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="vls"> <!--
'".($viralLoadTestingIndication=="vlTestingSuspectedTreatmentFailure"?$suspectedTreatmentFailureLastVLDate:"")."', '".($viralLoadTestingIndication=="vlTestingSuspectedTreatmentFailure"?$suspectedTreatmentFailureValue:"")."', '".($viralLoadTestingIndication=="vlTestingSuspectedTreatmentFailure"?$suspectedTreatmentFailureSampleTypeID:"")."', '$lrCategory','$lrEnvelopeNumber','$lrNumericID', '$datetime','$trailSessionUser')"); if(mysqlerror()) die("3: ".mysqlerror()); //review logs and fix any duplicates fixDuplicateSampleIDs(); //redirect accordingly go("/samples/success/".vlEncrypt(getDetailedTableInfo2("vl_samples","createdby='$trailSessionUser' order by created desc limit 1","vlSampleID"))."/"); } else { $error.="<br /><strong>Duplicate Data Entry</strong><br /> Patient with ART Number <strong>$artNumber</strong> from <strong>".getDetailedTableInfo2("vl_facilities","id='$facilityID' limit 1","facility")."</strong> has already been entered with Form Number <strong>$formNumber</strong>.<br /> Kindly input this record with an alternative Form or ART Number.<br />"; } } } ?> <script Language="JavaScript" Type="text/javascript"> <!-- function validate(samples) { //check for missing information if(!document.samples.lrCategory.value) { alert('Missing Mandatory Field: Location/Rejection ID'); document.samples.lrCategory.focus(); return (false); }