Example #1
0
 public function category_list($id = 0)
 {
     $lang = model('lang')->current_lang();
     $sql = "\r\n        SELECT A.*,B.model,B.name as mname,B.admin_category,B.admin_content\r\n        FROM {$this->model->pre}category A \r\n        LEFT JOIN {$this->model->pre}model B ON A.mid = B.mid\r\n        WHERE A.lang={$lang['id']}\r\n        ORDER BY A.sequence DESC,A.cid ASC\r\n        ";
     $data = $this->model->query($sql);
     $cat = new Category(array('cid', 'pid', 'name', 'cname'));
     return $cat->getTree($data, $id);
 }
Example #2
0
 public function getcat($cid)
 {
     $id = $cid;
     $data = $this->model->field('cid,pid,name')->table('category')->select();
     $cat = new Category(array('cid', 'pid', 'name', 'cname'));
     //初始化无限分类
     $cat_for = $cat->getTree($data, $id);
     //获取分类数据树结构
     if (empty($cat_for)) {
         return $id;
     }
     foreach ($cat_for as $v) {
         $cat_id .= $v['cid'] . ",";
     }
     if (!empty($cat_id)) {
         return $cat_id . $id;
     } else {
         return $id;
     }
 }