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(); } }
public function product() { $goods_id = $_GET['goods_id'] + 0; $p = $_GET['p'] + 0; //库存入库 if (IS_POST) { $goods_id = I('post.goods_id'); $goods_number = I('post.goods_number'); $attr = I('post.attr'); //修改库存,就是删除旧的数据,增加新的数据 //取出已经存在的库存数据,如果有就删除 $kcdata = M('Product')->where("goods_id={$goods_id}")->select(); if ($kcdata) { M('Product')->where("goods_id={$goods_id}")->delete(); } //计算出总的库存 $kc = 0; foreach ($goods_number as $k => $v) { $a = array(); foreach ($attr as $k1 => $v1) { $a[] = $v1[$k]; } M('Product')->add(array('goods_id' => $goods_id, 'goods_number' => $v, 'goods_attr_id' => implode(',', $a))); //计算总的库存 $kc += $v; } //修改总的库存 M('Goods')->where("goods_id={$goods_id}")->setField('goods_number', $kc); $this->success('添加库存成功', U('showlist', array('p' => $p)), 1); exit; } //修改库存,先把设置的库存取出来显示 $kcdata = M('Product')->where("goods_id={$goods_id}")->select(); $this->assign('kcdata', $kcdata); $goods_model = new \Model\GoodsModel(); $goods_info = $goods_model->field("goods_name")->find($goods_id); $this->assign('goods_info', $goods_info); //取出设置库存的属性id和属性名及值 $data = $goods_model->getRadio($goods_id); //为了方便遍历,转换成三维数组 $radiodata = array(); foreach ($data as $v) { $radiodata[$v['attr_id']][] = $v; } $this->assign('goods_id', $goods_id); $this->assign('radiodata', $radiodata); $this->display(); }