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();
}
public function index()
{
$goods = D('Goods');
$category = new \Model\CategoryModel();
$cat_id = $_GET['category_id'];
$catslist = $category->getTopIds($cat_id);
$cate_info = $category->select();
$goods_info1 = $goods->where("is_hot=1")->select();
//给商品实现分页
$per = 8;
//sql语句获得每页商品信息
if ($cat_id == "") {
$total = $goods->count();
$page = new \Tool\Page($total, $per);
$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;
} else {
$total = $goods->where("goods_category_id='{$cat_id}'")->count();
$page = new \Tool\Page($total, $per);
$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 where a.goods_category_id='{$cat_id}' order by goods_id desc " . $page->limit;
}
$info = $goods->query($sql);
//制作页码表
$pagelist = $page->fpage();
$this->assign('cat_id', $cat_id);
$this->assign('pagelist', $pagelist);
//把商品信息传递给模板
$this->assign('goods_info1', $goods_info1);
$this->assign('cate_info', $cate_info);
$this->assign('catslist', $catslist);
$this->assign('info', $info);
$this->display();
}
function __construct()
{
parent::__construct();
$goods = D('Goods');
$category = new \Model\CategoryModel();
$goods_info1 = $goods->where("is_hot=1")->select();
$this->assign('goods_info1', $goods_info1);
$this->assign('cate_info', $cate_info);
$cats = $category->frontCats();
$this->assign('cats', $cats);
}
public function _initialize()
{
//获取购物车中的总商品数和总价格
$cart_model = new \Model\CartModel();
$total = $cart_model->getTotal();
$this->assign('total', $total);
//取出顶级栏目，用于导航显示
$cat_model = new \Model\CategoryModel();
$nav_list = $cat_model->getNav();
$this->assign('nav_list', $nav_list);
}
public function update($cat_id)
{
$cat_id = (int) $cat_id;
$model = new \Model\CategoryModel();
if (IS_POST) {
if ($data = $model->create(I('post.'), 2)) {
//查找自身和下级的cat_id，防止修改表单恶意提交（将自身或者下级作为自身的父级）
$ids = $model->getChild($cat_id);
$ids[] = $cat_id;
$parent_id = (int) I('post.parent_id');
if (in_array($parent_id, $ids)) {
$this->error('不能讲自身和下级栏目作为自身的父级');
}
if ($model->save($data) !== false) {
$this->success('修改成功', U('showlist'), 1);
exit;
} else {
$this->error('修改失败');
}
} else {
$this->error($model->getError());
}
}
//取出要修改栏目的信息
$info = $model->find($cat_id);
$this->assign('info', $info);
//取出要修改的栏目的自身和下级栏目，在修改界面不显示
$ids = $model->getChild($cat_id);
$ids[] = $cat_id;
$this->assign('ids', $ids);
//取出商品栏目
$cat_list = $model->getTree();
$this->assign('cat_list', $cat_list);
$this->display();
}
public function detail()
{
$goods_id = $_GET['goods_id'] + 0;
$goods_model = new \Model\GoodsModel();
$goods_info = $goods_model->find($goods_id);
//如果没有商品则跳转到首页
if (empty($goods_info)) {
header('location:/index.php');
}
//取出商品属性
$attrdata = M('GoodsAttr')->field("a.id,a.attr_id,a.attr_value,b.attr_type,b.attr_name")->join("a left join it_attribute b using(attr_id)")->where("goods_id={$goods_id}")->select();
//重置数组，把单选属性过滤出来，方便遍历
$radiodata = array();
foreach ($attrdata as $v) {
if ($v['attr_type'] == 1) {
$radiodata[$v['attr_id']][] = $v;
}
}
$this->assign('radiodata', $radiodata);
//取出栏目家谱树，用做面包屑导航
$cat_model = new \Model\CategoryModel();
$cat_family = $cat_model->getFamily($goods_info['cat_id']);
$this->assign('cat_family', $cat_family);
$this->assign('goods_info', $goods_info);
$this->display();
}
public function catupdate($cat_id)
{
$category = new \Model\CategoryModel();
if (!empty($_POST)) {
//收集表单数据
$info = $category->create();
$result = $category->save($info);
if ($result) {
//跳转
$this->redirect('category', array(), 2, '修改分类成功');
}
}
$par_info = $category->where("parent_id=0")->select();
$this->assign('par_info', $par_info);
$info = $category->find($cat_id);
$this->assign('info', $info);
$this->display();
}
