public function index()
{
$category = new \Model\CategoryModel();
$goods = new \Model\GoodsModel();
//商品信息
//给商品实现分页
$total = $goods->count();
//model里的__call封装
$per = 8;
$page = new \Tool\Page($total, $per);
//sql语句获得每页商品信息
$sql = "SELECT a . * , b.cat_name\nFROM sw_goods AS a\nLEFT JOIN sw_category AS b ON a.goods_category_id = b.cat_id order by goods_id desc " . $page->limit;
$goods_info = $goods->query($sql);
//制作页码表
$pagelist = $page->fpage();
$this->assign('pagelist', $pagelist);
$goods_info1 = $goods->where("is_hot=1")->select();
//分类信息
$cate_info = $category->select();
$this->assign('cate_info', $cate_info);
$this->assign('goods_info', $goods_info);
$this->assign('goods_info1', $goods_info1);
$this->assign('user_id', $_SESSION['user_id']);
$this->display();
}
public function Category()
{
$cat_model = new \Model\CategoryModel();
$goods_model = new \Model\GoodsModel();
//精品推荐
$this->goods_best_list = $goods_model->getGoodsByType('best', 3);
//判断栏目是否是顶级栏目,是就查出该栏目下所有子栏目的商品
$cat_id = $_GET['cat_id'] + 0;
$ids = $cat_model->getChild($cat_id);
if (empty($ids)) {
//代表自身是子栏目,将自身加入到数组中
$ids[] = $cat_id;
}
$ids = implode(',', $ids);
//总记录数
$count = $goods_model->where("cat_id in ({$ids})")->count();
$pagesize = 2;
//总页数
$pagecount = ceil($count / $pagesize);
//获取页码
$pageno = isset($_GET['pageno']) ? $_GET['pageno'] : 1;
if ($pageno < 1) {
$pageno = 1;
}
if ($pageno > $pagecount) {
$pageno = $pagecount;
}
$goods_cat_list = $goods_model->field('goods_id,goods_name,shop_price,goods_thumb')->where("cat_id in ({$ids})")->page($pageno, $pagesize)->select();
if (isset($_GET['pageno'])) {
$this->ajaxReturn($goods_cat_list);
exit;
} else {
$this->assign('goods_cat_list', $goods_cat_list);
$this->assign('pagecount', $pagecount);
$this->assign('pageno', $pageno);
$this->assign('cat_id', $cat_id);
$this->display();
}
}
