public function getAll()
{
$count = $this->join('category c', 'article.cid', '=', 'c.id')->count('article.id');
$page = Page::row(5)->pageNum(5)->make($count);
$data = $this->table('article a')->field('a.title,a.id,c.catname,a.addtime')->join('category c', 'a.cid', '=', 'c.id')->limit(Page::limit())->get();
// $data[] = $this->where('notice',1)->get();
return array('page' => $page, 'data' => $data);
}
public function getDelAll()
{
$cate_id = Q('cate_id');
if ($cate_id) {
$page = Page::row(20)->make($this->where('cate_id', $cate_id)->where('is_delete', 1)->count());
$data = $this->where('cate_id', $cate_id)->where('is_delete', 1)->limit(Page::limit())->get();
} else {
$page = Page::row(20)->make($this->where('is_delete', 1)->count());
$data = $this->where('is_delete', 1)->limit(Page::limit())->get();
}
foreach ($data as $k => $v) {
$brand = Db::table('shop_brand')->where('brand_id', $v['brand_id'])->first();
$data[$k]['brand'] = $brand;
$cate = Db::table('shop_cate')->where('cate_id', $v['cate_id'])->first();
$data[$k]['cate'] = $cate;
}
$goods['data'] = $data;
$goods['page'] = $page;
return $goods;
}
