if($_SESSION["VLADMIN"]) { $serverAddress=0; $serverAddress=$_SESSION["VLADMIN"]; } //who's the user? $user=0; $user=($_SESSION["VLADMIN"]?"admin: ".$_SESSION["VLADMIN"]:"visitor: $ipAddress $serverAddress"); $c=0; $c=$default_country; /** * date/time defaults * at 11:00hrs hostmonster mysql time == 20:00hrs Ug time * 20:00hrs Ug time (+3 GMT) == 17:00hrs GMT * hostmonster == -6 GMT */ $datetime=0; $datetime=getDualInfoWithAlias("now()","datetime"); //$curDate=0; //$curDate=gmdate("d-M-Y"); $icurDate=0; $icurDate=getRawFormattedDateLessDay($datetime); $curTime=0; $curTime=getFormattedTime($datetime); //free memory clearstatcache(); ?>
//is this Envelopes's envelopeNumber unique if(getDetailedTableInfo2("vl_envelopes","envelopeNumber='$envelopeNumber' and id!='$modify' limit 1","id")) { $error.="<br />Another Envelope with the same Envelope Number <strong>$envelopeNumber</strong> already exists.<br />Kindly provide an alternative Envelope Number<br />"; } //is this Batch's batchNumber unique if(getDetailedTableInfo2("vl_envelopes","batchNumber='$batchNumber' and id!='$modify' limit 1","id")) { $error.="<br />Another Envelope with the same Batch Number <strong>$batchNumber</strong> already exists.<br />Kindly provide an alternative Batch Number<br />"; } //input data if(!$error) { //formate date $currentDateTime=0; $currentDateTime="$receivedDateYear-$receivedDateMonth-$receivedDateDay ".getFormattedTime(getDetailedTableInfo2("vl_envelopes","id='$modify' limit 1","created")); //log changes logTableChange("vl_envelopes","envelopeNumber",$modify,getDetailedTableInfo2("vl_envelopes","id='$modify'","envelopeNumber"),$envelopeNumber); logTableChange("vl_envelopes","batchNumber",$modify,getDetailedTableInfo2("vl_envelopes","id='$modify'","batchNumber"),$batchNumber); logTableChange("vl_envelopes","districtID",$modify,getDetailedTableInfo2("vl_envelopes","id='$modify'","districtID"),$districtID); logTableChange("vl_envelopes","hubID",$modify,getDetailedTableInfo2("vl_envelopes","id='$modify'","hubID"),$hubID); logTableChange("vl_envelopes","facilityID",$modify,getDetailedTableInfo2("vl_envelopes","id='$modify'","facilityID"),$facilityID); logTableChange("vl_envelopes","created",$modify,getDetailedTableInfo2("vl_envelopes","id='$modify'","created"),$currentDateTime); mysqlquery("update vl_envelopes set envelopeNumber='$envelopeNumber', batchNumber='$batchNumber', districtID='$districtID', hubID='$hubID', facilityID='$facilityID',
//is this Envelopes's envelopeNumber unique if(getDetailedTableInfo2("vl_envelopes","envelopeNumber='$envelopeNumber' limit 1","id")) { $error.="<br />Another Envelope with the same Envelope Number <strong>$envelopeNumber</strong> already exists.<br />Kindly provide an alternative Envelope Number<br />"; } //is this Batch's batchNumber unique if(getDetailedTableInfo2("vl_envelopes","batchNumber='$batchNumber' limit 1","id")) { $error.="<br />Another Envelope with the same Batch Number <strong>$batchNumber</strong> already exists.<br />Kindly provide an alternative Batch Number<br />"; } //input data if(!$error) { //formate date $currentDateTime=0; $currentDateTime="$receivedDateYear-$receivedDateMonth-$receivedDateDay ".getFormattedTime($datetime); //log issue mysqlquery("insert into vl_envelopes (envelopeNumber,batchNumber,districtID,hubID,facilityID,created,createdby) values ('$envelopeNumber','$batchNumber','$districtID','$hubID','$facilityID','$currentDateTime','$trailSessionUser')"); //redirect to home with updates on the tracking number go("/envelopes/success/"); } } ?> <script Language="JavaScript" Type="text/javascript"> <!-- function validate(envelopes) {
} } } } if(!empty($abbott_insert_values)) insertVLResults("abbott", $abbott_insert_values, $log_repeat_values, $merged_values); fclose($file); //log the $runStartTime and $runCompletionTime if(!getDetailedTableInfo2("vl_results_abbott_runtimes","worksheetID='$worksheetID' limit 1","id")) { mysqlquery("insert into vl_results_abbott_runtimes (worksheetID,runStartTime,runCompletionTime, created,createdby) values ('$worksheetID','".getRawFormattedDateLessDay($runStartTime)." ".getFormattedTime($runStartTime)."','".getRawFormattedDateLessDay($runCompletionTime)." ".getFormattedTime($runCompletionTime)."', '$datetime','$trailSessionUser')"); } } } } else { $error.="<br>File could not be uploaded. Consider contacting your Systems Administrator."; } //redirect go("/worksheets/success/".($added?$added:0)."/".($modified?$modified:0)."/"); } } ?> <script Language="JavaScript" Type="text/javascript"> <!--
if($scount%2) { $scolor="#FFFFFF"; } else { $scolor="#F4F4F4"; } ?> <tr bgcolor="<?php echo $scolor; ?> "> <td><?php echo $sq["who"]; ?> </td> <td><?php echo getFormattedDate($sq["at"]) . " at " . getFormattedTime($sq["at"]); ?> </td> </tr> <? } } else { ?> <tr> <td colspan="2">No statistics available for this query.</td> </tr> <? } ?> <tr> <td colspan="2">[ <a href="../admin/?act=statistics&nav=statistics">return to statistics</a> ]</td> </tr> </table></td>
<? //security check if(!$GLOBALS['vlDC']) { die("<font face=arial size=2>Job 38:11</font>"); } ?> <table width="80%" border="0" class="vl"> <tr> <td> <? //read the required details echo "<b>Welcome $_SESSION[VLADMIN]</b><br>"; echo "Last login: "******"vl_admins","email='$_SESSION[VLADMIN]'","login"))." at ".getFormattedTime(getDetailedTableInfo2("vl_admins","email='$_SESSION[VLADMIN]'","login"))."<br>"; echo "Current Date, Time: ".getFormattedDate($datetime).", ".getFormattedTime($datetime)."<br>"; ?> </td> </tr> <tr> <td> </td> </tr> <tr> <td class="vl_tdsub" style="padding-left:14px"><strong>Appendices</strong></td> </tr> <tr> <td> <div style="height: 300px; border: 1px solid #ccccff; overflow: auto; padding:0px 0px 0px 5px"> <table width="95%" border="0" cellspacing="0" cellpadding="0" class="trailanalytics"> <tr> <td class="vl_tdstandard"><a href="?act=aarvadherence">ARV Adherence</a></td> </tr>