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 showlist()
{
//取出商品栏目
$cat_model = new \Model\CategoryModel();
$cat_list = $cat_model->getTree();
$this->assign('cat_list', $cat_list);
//取出商品并分页显示
$goods_model = new \Model\GoodsModel();
$pagesize = C('pagesize');
$count = $goods_model->count();
$page = new \Think\Page($count, $pagesize);
//设置分页样式
$page->lastSuffix = false;
//不显示末页
$page->rollPage = 3;
//一次显示三页
$page->setConfig('prev', '【上一页】');
$page->setConfig('next', '【下一页】');
$page->setConfig('first', '【首页】');
$page->setConfig('last', '【末页】');
$page->setConfig('theme', '共 %TOTAL_ROW% 条记录,当前 %NOW_PAGE%/%TOTAL_PAGE%%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$pageinfo = $page->show();
//获取当前页方便跳转
$nowpage = $page->nowPage;
$goods_list = $goods_model->order('goods_id desc')->limit($page->firstRow . ',' . $page->listRows)->select();
$this->assign('goods_list', $goods_list);
$this->assign('pageinfo', $pageinfo);
$this->assign('nowpage', $nowpage);
$this->display();
}
