Language = $Lang;
}
public function BuildMenu()
{
$xdb = new NemoDatabase("",null,null,0);
$rst1 = $xdb->doQuery("
SELECT sysMenuLevel1.MenuLevel1ID AS ID, sysMenuLevel1.".$this->Language."_strMenuLevel1 AS Label, sysMenuLevel1.strUrl AS URL, Count(sysMenuLevel2.MenuLevel2ID) as Children, sysMenuLevel1.intOrder AS 'Order'
FROM (sysSecurity INNER JOIN (sysMenuLevel2 INNER JOIN sysMenuLevel1 ON sysMenuLevel2.MenuLevel1ID = sysMenuLevel1.MenuLevel1ID) ON sysSecurity.refMenulevel2ID = sysMenuLevel2.MenuLevel2ID) INNER JOIN sysSecurityGroup ON sysSecurity.refSecurityGroupID = sysSecurityGroup.SecurityGroupID
WHERE sysSecurityGroup.blnActive=1 AND sysSecurity.blnView=1
GROUP BY sysSecurityGroup.SecurityGroupID, sysMenuLevel1.MenuLevel1ID, sysMenuLevel1.strMenuLevel1, sysMenuLevel1.strUrl, sysMenuLevel1.intOrder
HAVING sysSecurityGroup.SecurityGroupID='". $this->SystemSettings[USER]->SECURITYGROUPID ."'
ORDER BY sysMenuLevel1.intOrder, sysMenuLevel1.".$this->Language."_strMenuLevel1");
$strMenu .= "";
while($row1 = $xdb->fetch($rst1))
{
//print_rr($row1);
if(file_exists($row1->strUrl) || $row1->Children > 0)
{
$strMenu .= "- ";
/*if(file_exists($row1->URL))
$strMenu .= "$row1->Label";
else
$strMenu .= "$row1->Label";*/
$strMenu .= "$row1->Label";
$this->Tier1[$row1->ID] = $row1;
$sql = "SELECT sysMenuLevel2.MenuLevel1ID as Tier1ID, sysMenuLevel2.MenuLevel2ID AS ID, sysMenuLevel2.".$this->Language."_strMenuLevel2 AS Label, sysMenuLevel2.".$this->Language."_strEntity AS Entity, sysMenuLevel2.strUrl AS URL, sysSecurity.blnView, sysSecurity.blnDelete, sysSecurity.blnSave, sysSecurity.blnSpecial, sysMenuLevel2.blnDivider, sysMenuLevel2.intOrder AS 'Order'
FROM sysSecurity INNER JOIN sysMenuLevel2 ON sysSecurity.refMenulevel2ID = sysMenuLevel2.MenuLevel2ID
WHERE (((sysMenuLevel2.MenuLevel1ID)=$row1->ID) AND ((sysMenuLevel2.blnMenuItem)=1) AND refSecurityGroupID = '".$_SESSION['USER']->SECURITYGROUPID."' )
GROUP BY sysMenuLevel2.MenuLevel1ID, sysMenuLevel2.MenuLevel2ID, sysMenuLevel2.intOrder, sysMenuLevel2.strMenuLevel2, sysMenuLevel2.strEntity, sysMenuLevel2.strUrl, sysSecurity.blnView, sysSecurity.blnDelete, sysSecurity.blnSave, sysSecurity.blnSpecial, sysMenuLevel2.blnDivider
HAVING (((sysSecurity.blnView)=1))
ORDER BY sysMenuLevel2.intOrder, sysMenuLevel2.".$this->Language."_strMenuLevel2";
$xdb->doQuery($sql);
if($xdb->num_rows($xdb->doQuery($sql,0)) > 0)
{
$strMenu .= "
"; //NB! YOU NEED THE FUCKING NL/CR BEFORE THE UL ELSE IE FUCKING RENDERS PREMATURELY LIKE ITS A HIGHSCHOOL PUSSYBOY FFS!
while($row2 = $xdb->fetch())
{
$this->Tier2[$row2->ID] = $row2;
$strMenu .= "- ";
if($row2->blnDivider == 1)
{
$strMenu .= "";
}
if(file_exists($row2->URL))
$strMenu .= "$row2->Label";
else
$strMenu .= "$row2->Label";
//$strMenu .= "$row2->Label";
$strMenu .= "
"; //l2
}
$strMenu .= "
"; //l2
}
$strMenu .= " "; //l1
}
}
$strMenu .= "
"; //l1
$this->Control = $strMenu;
}
## side bar
###############################################################
public function BuildSidebar()
{
$_MenuSidebar = $this->Language."_strMenuSidebar";
//$strMenuSidebar = "strMenuSidebar";
$xdb = new NemoDatabase("",null,null,0);
$rstSidebar = $xdb->doQuery("SELECT * FROM sysMenuSidebar WHERE blnActive = 1 ORDER BY intOrder ASC ");
$sideMenu = "";
while($rowSidebar = $xdb->fetch_object($rstSidebar))
{
if(function_exists($rowSidebar->strFunctionName))
{
$strMenuSidebar = call_user_func($rowSidebar->strFunctionName, $rowSidebar->arrFunctionArgs);
}
else
{
$strMenuSidebar = $rowSidebar->$_MenuSidebar;
}
$sideMenu .= "- $strMenuSidebar
";
}
$sideMenu .= "
";
return $sideMenu;
}
}
?>