";
$result=sqlquery($s);
while ($row=$result->fetch_assoc())
{
$menuid=$row['menuid'];
$accessgranted[$menuid]=1;
$fav[$menuid]=$row['fav'];
}
//print "$mybirthday";
$birthday=date("dm");
$s="SELECT * FROM building_temperatures where locationid='150394' order by id desc limit 0,1";
$result=sqlquery($s);
while ($row=$result->fetch_assoc())
{
$curtemp="$row[temperature] °"."C";
}
$s="SELECT ISO_quality_manual_user_read.docid as docid FROM intrastatmenu , ISO_quality_manual_user_read
where ISO_quality_manual_user_read.userid='$vui' and
ISO_quality_manual_user_read.docid = intrastatmenu.docid and ISO_quality_manual_user_read.docid<>'0'
";
$result=sqlquery($s);
$num=$result->num_rows;
while ($row=$result->fetch_assoc())
{
$docid=$row['docid'];
$userread[$docid]=1;
//print "$docid ";
}
if ( $myfluff==1 and $mybirthday==$birthday)
{
$usebackgroundimage="birthday.jpg";
print " ";
}
if ($usebackgroundimage=='')
{
$usebackgroundimage="background.jpg";
//print " ";
print '';
}
$submenu=safetext2(isset($_GET['submenu']) ? $_GET['submenu'] : '');
if ($localname<>'Blah' and $usersecurity<>''){
$cata='o';
$r= "SELECT * FROM viamedagendahistory WHERE investigateby='$localname' and completed='' and investigatedcomplete='' and (hide_until<'$nowis' or hide_until='' ) order by createdate ";
$result = sqlquery($r);
$iout=$result->num_rows;
$nowis=date('U');
$r= "SELECT * FROM viamedagendahistory WHERE investigateby='$localname' and completed='' and investigatedcomplete='' and viewed ='' and (hide_until<'$nowis' or hide_until='' ) order by createdate ";
$result = sqlquery($r);
$ivout=$result->num_rows;
$r= "SELECT * FROM viamedagendahistory WHERE investigateby='$localname' and completed='' and investigatedcomplete='' and autoissueid>'0' order by createdate ";
$result = sqlquery($r);
$isotaskout=$result->num_rows;
$s="SELECT * FROM tellog where currentuser='$vui' and completedon='0'";
$result=sqlquery($s);
$calls=$result->num_rows;
$x=getsecurity();
if ($calls >0)
{
$callinfo .= "";
$callinfo .= "";
$callinfo .= "$calls Calls";
} else
{
$callinfo="";
}
if ($vui==2)
{
$s="SELECT * FROM intrastat_access_failed where reviewed='0'";
$result=sqlquery($s);
$num=$result->num_rows;
if ($num>0)
{
$callinfo .= " ($num) Failed Login Attempts ";
}
}
$s="SELECT * FROM user_groups_linked where userid='$vui'";
$result=sqlquery($s);
while ($row=$result->fetch_assoc())
{
$usergroupid=$row['groupid'];
$user_groups[$usergroupid]=1;
}
// AI_load_active_users_AI003 – updated to mysqli/sqlquery compatible
$s = "SELECT * FROM pw WHERE active = '1'";
$result = sqlquery($s);
while ($row = $result->fetch_assoc()) {
$usenamed = ucwords($row['username']);
$useractive[$usenamed] = 1;
$showhideholidaybar[$usenamed] = $row['showhideholiday'];
if ($row['id'] == $vui) {
$myhelper = $row['helper'];
}
}
print "";
// TEST LINE GOING IN HERE
$usetxt="";
$usetxt .= $callinfo;
if ($iout>0)
{
$usetxt="$usetxt $iout Issues";
}
if ($ivout>0)
{
$usetxt="$usetxt $ivoutUnread $isotaskout ISO Tasks";
}
$s="SELECT * FROM holvmemphollog_new where userinformed='0' and userid='$vui' limit 0,1";
$result = sqlquery($s);
$numhol=$result->num_rows;
if ($numhol > 0 ) {
$usetxt="$usetxt | My Requests";
}
if ($localname=='Derek Lamb' OR $localname=='Steve Nixon' OR $localname=='steve nixon' OR $localname=='Helen Lamb') {
$useraccess=0;
$s="SELECT * FROM pw_companys where vui='$vui'";
$result=sqlquery($s);
$num=$result->num_rows;
while ($row=$result->fetch_assoc())
{
if ($row['updatestaff']==1) {
$useraccess=1;
}
}
if ($useraccess==1) {
//print "h";
$s="SELECT * FROM holvmemphollog_new where authorisedon='0' limit 0,1";
$result = sqlquery($s);
$numhol=$result->num_rows;
if ($numhol > 0 ) {
$usetxt="$usetxt | New Holiday";
}
}
}
// END OF TEST LINE
print "
";
// main external links should go here
// end of main external links
echo "
";
include ("../../databases/menu/get_static_links.php");
echo "
";
echo "
";
?>
";
?>
";
$ref_url = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http");
$ref_url .= "://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
// Get just the filename (e.g. something.php)
$ref_file = basename($_SERVER['PHP_SELF']);
// Build safe query string (urlencode for reliability)
$update_link = "../intrastats_md/update_page.php".$x."&ref_url=" . urlencode($ref_url) . "&ref_file=" . urlencode($ref_file);
if ($vui==2) {
echo "";
}
print "";
?>
".getcurrentname($vui)."";
if ($docstoread=='1')
{
?>
&submenu=">Required Reading
$curtemp";
//print" ";
// END OF TITLE BAR
//// New Search Box
$searchoptions = "";
$s="SELECT * FROM ATLAS_searchoptions where usersecurity < '$usersecurity' order by description";
$result=sqlquery($s);
while ($row=$result->fetch_assoc())
{
if ($row['id']==$menusearchtype) {
$searchoptions .= "";
} else {
$searchoptions .= "";
}
}
if ($menuallowed==1) {
?>
![](\"/intranet/images/admin.png\" "\\"Add"){kind=small}
![](\"/intranet/images/menu/staron.png\" "\\"Favorites\\""){kind=small}
";
?>
".getcurrentname($vui)."";
if ($docstoread=='1')
{
?>
&submenu=">Required Reading
$curtemp";
//print"
