1、控制器
class Goods extends Base
{
public function index($id){
$goodsModel = new goodsModel;
$goods = $goodsModel->getCatGoods($id);
$cat_name = $goodsModel->getCatName($id);
$this->assign('goods',$goods);
$this->assign('cat_name',$cat_name);
return $this->fetch('list');
}
//商品详情
public function detail($id){
$goodsModel = new goodsModel;
$goods = $goodsModel->getGoodsDetail($id);
$goods['goods_color'] = explode('|', $goods['goods_color']);
$goods['goods_type'] = explode('|',$goods['goods_type']);
$this->assign('goods',$goods);
return $this->fetch('detail');
}
}
2、模型
class Goods extends Model
{
public function getCatGoods($id){
return $this->where('cat_id',$id)->where('is_on',1)
->field(['goods_name','goods_img','id','original_price','pro_price'])
->select();
}
public function getCatName($id){
return Db::name('category')->where('id',$id)->value('cat_name');
}
public function getGoodsDetail($id){
return $this->where('id',$id)->find();
}
public function getIndexGoods($cat_id){
return $this->where('cat_id',$cat_id)->where('is_on',1)
->field(['id','goods_name','goods_img','pro_price'])
->limit(6)
->order('id desc')
->select();
}
public function getHotGoods($cat_id){
return $this->where('cat_id',$cat_id)->where('is_on',1)->where('is_hot',1)
->field(['id','goods_name','goods_img','pro_price'])
->limit(4)
->order('id desc')
->select();
}
public function getCartGoods($id){
return $this->where('id',$id)->field(['goods_img','goods_name','pro_price','original_price'])->find();
}
} 最佳答案
