SystemSettings = $SystemSettings;
if(isset($nemo))
$this->SystemSettings = $nemo->SystemSettings;
//$this->db = new NemoDatabase("");
}
private function __autoload()
{
}
public function setSecurityGroup($SGID)
{
$this->SystemSettings[USER]->SECURITYGROUPID = $SGID;
}
public function getControl()
{
return $this->Control;
}
public function BuildMenu()
{
$xdb = new NemoDatabase("",null,null,0);
$rst1 = $xdb->doQuery("
SELECT sysMenuLevel1.MenuLevel1ID AS ID, sysMenuLevel1.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.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.strMenuLevel2 AS Label, sysMenuLevel2.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.strMenuLevel2";
$xdb->doQuery($sql);
if($xdb->num_rows($xdb->doQuery($sql)) > 0)
{
$strMenu .= "
"; //NB! YOU NEED THE FUCKING NL/CR BEFORE THE UL ELSE IE FUCKING PREMATURELY RENDERS IT LIKE A HIGHSCHOOL PUSSYBOUY 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()
{
$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->strMenuSidebar;
}
$sideMenu .= "- $strMenuSidebar
";
}
$sideMenu .= "
";
return $sideMenu;
}
}
?>