id = $db->clean($id); } function setGroups($groups){ global $db; $this->groups = $db->clean($groups); } function setAccessId($aid){ global $db; $this->aid = $db->clean($aid); } function getAccessGroup(){ global $db; $agarray = array(); $dbag = $db->fetch_all("SELECT * FROM accessed ORDER BY menuorder"); if (sizeof($dbag) > 0){ foreach ($dbag as $dbg){ if (!in_array($dbg['accessgroup'],$agarray)){ array_push($agarray,$dbg['accessgroup']); } } } return $agarray; } function getListAccess($mode){ global $db; $sqls = array(); if ($mode == 'partial'){ array_push($sqls,'STATUS = 1'); } if (!empty($this->groups)){ array_push($sqls,'accessgroup=\''.$this->groups.'\''); } $sql = ''; if (sizeof($sqls) > 0){ $sql = ' WHERE '.implode(' AND ',$sqls); } $dbaccess = $db->fetch_all("SELECT * FROM accessed".$sql." ORDER BY accessid"); return $dbaccess; } function getAccessDetail(){ global $db; if (!empty($this->aid)){ $dbaccess = $db->fetch_all("SELECT * FROM accessed WHERE accessid IN (".$this->aid.") AND STATUS = 1 ORDER BY MENUORDER"); return $dbaccess; } } function generateParentMenu(){ global $db, $arrallaccessid, $useraccess; $allparent = $db->fetch_all("SELECT accessid, accessname, menulabel, jsaction, ismenu FROM accessed WHERE parentid = -1 AND status = 1 ORDER BY menuorder"); $allmenu = ''; if (sizeof($allparent) > 0){ foreach ($allparent as $parent){ if (in_array($parent['accessid'],$arrallaccessid)){ $texttoprint = ''; $useraccess[$parent['accessname']] = 1; if ($parent['ismenu'] == 1){ /* if (!empty($parent['jsaction'])){ $texttoprint = '
  • '.htmlspecialchars($parent['menulabel']).''; } else{ */ $texttoprint = '
  • '.htmlspecialchars($parent['menulabel']).' '; $child_menu = $this->generateChildMenu($parent['accessid']); if(!empty($child_menu)) { $allmenu .= $texttoprint.''; } else{ $allmenu .= $texttoprint.'
    • '; } /* } $allmenu .= '
  • '.$texttoprint.$this->generateChildMenu($parent['accessid']).'
    • '; */ } } } } return $allmenu; } function generateChildMenu($parentid){ global $db, $arrallaccessid, $useraccess; $allchild = $db->fetch_all("SELECT accessid, accessname, menulabel, jsaction, ismenu FROM accessed WHERE parentid = '".$db->clean($parentid)."' AND status = 1 ORDER BY menuorder"); $allchildmenu = ''; $returnfromchildall = ''; if (sizeof($allchild) > 0){ foreach ($allchild as $child){ if (in_array($child['accessid'],$arrallaccessid)){ $texttoprint = ''; $useraccess[$child['accessname']] = 1; if ($child['ismenu'] == 1){ $returnfromchild = $this->generateChildMenu($child['accessid']); if (empty($returnfromchild)){ /* if (!empty($child['jsaction'])){ $texttoprint = '
  • '.htmlspecialchars($child['menulabel']).'
    • '; } else{ */ $texttoprint = '
  • '.htmlspecialchars($child['menulabel']).'
    • '; /* } */ $allchildmenu .= $texttoprint; } else{ /* if (!empty($child['jsaction'])){ $texttoprint = '
  • '.htmlspecialchars($child['menulabel']).'
    • '; } else{ */ $texttoprint = '
  • '.htmlspecialchars($child['menulabel']).'
    • '; /* } */ $allchildmenu .= $texttoprint; } $returnfromchildall .= $returnfromchild; } } } if (!empty($allchildmenu)){ /* $allchildmenu = ''; */ $allchildmenu .= $returnfromchildall; } } return $allchildmenu; } function generateParentMenuOnUserGroup(){ global $db, $thisugaccess; $allparent = $db->fetch_all("SELECT accessid, accesslabel, menulabel, jsaction FROM accessed WHERE parentid = -1 AND status = 1 ORDER BY menuorder"); $allmenu = ''; $this->depth = 1; $perRow = 4; $width = 100 / $perRow; $counter = 1; if (sizeof($allparent) > 0){ $allmenu = '
    '; foreach ($allparent as $parent){ $allmenu .= '
    '.htmlspecialchars($parent['accesslabel']).'
    '.$this->generateChildMenuOnUserGroup($parent['accessid']).'
    '; if($counter % $perRow == 0)$allmenu .= '
    '; $counter++; } $allmenu .= '
    '; } return $allmenu; } function generateChildMenuOnUserGroup($parentid){ global $db, $thisugaccess; $allchild = $db->fetch_all("SELECT accessid, accesslabel, menulabel, jsaction, ismenu FROM accessed WHERE parentid = '".$db->clean($parentid)."' AND status = 1 ORDER BY menuorder"); $allchildmenu = ''; if (sizeof($allchild) > 0){ foreach ($allchild as $child){ $prefix = str_repeat(' ',$this->depth * 5); /* if ($child['ISMENU'] == 1 && $child['MENULABEL'] != $child['ACCESSLABEL']){ $allchildmenu .= '
    '.$prefix.'• '.htmlspecialchars($child['MENULABEL']).'
    '; } */ $this->depth++; $allchildmenu .= '
    '.$prefix.'
    '.$this->generateChildMenuOnUserGroup($child['accessid']).' '; $this->depth--; } } return $allchildmenu; } } ?>