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); }
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; } }