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>
