示例#1
0
 function onCommonGetNavs($type = '')
 {
     switch ($type) {
         case 'footer':
             $navtype = 1;
             break;
         case 'space':
             $navtype = 2;
             break;
         case 'my':
             $navtype = 3;
             break;
         case 'header':
             $navtype = 0;
             break;
     }
     $navs = array();
     $sql = "SELECT * FROM " . DB::table('common_nav');
     if ($type) {
         $sql .= " WHERE navtype = '{$navtype}'";
     }
     $sql .= ' ORDER BY displayorder';
     $query = DB::query($sql);
     $navs = $subNavs = array();
     while ($nav = DB::fetch($query)) {
         if (!$nav['parentid']) {
             $navs[$nav['id']] = SearchHelper::convertNav($nav);
         } else {
             $subNavs[$nav['id']] = $nav;
         }
     }
     foreach ($subNavs as $k => $v) {
         $navs[$v['parentid']]['navs'][$v['id']] = SearchHelper::convertNav($v);
     }
     return $navs;
 }