<?php // +---------------------------------------------------------------------- // | bronet [ 以客户为中心 以奋斗者为本 ] // +---------------------------------------------------------------------- // | Copyright (c) 2013-2017 http://www.bronet.cn All rights reserved. // +---------------------------------------------------------------------- // | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 ) // +---------------------------------------------------------------------- namespace app\portal\controller; use cmf\controller\WeChatBaseController; use think\Db; class GoodsdetailsController extends WeChatBaseController{ /** * 商品详情页 */ public function Goods_details(){ $goods_id = $this -> request -> param(); $data = Db::name('goods') -> alias('a') -> join('classification b','a.classify_id = b.id','LEFT') -> where('a.id',$goods_id['goods_id']) -> find(); $price = explode('.',$data['price']); $pricing = explode('.',$data['pricing']); $data['price0'] = $price[0]; $data['price1'] = $price[1]; $data['pricing0'] = $pricing[0]; $data['pricing1'] = $pricing[1]; $data['det_img'] = json_decode($data['det_img'],true); $this -> assign('det_img',$data['det_img']); $this -> assign('data',$data); $data_label = Db::name('label') -> alias('a') -> field("a.*,b.goods_id,b.label_id") -> join('goods_label b','a.id=b.label_id','LEFT') -> where("b.goods_id = ".$goods_id['goods_id']) -> select(); $this -> assign('data_label',$data_label); //相关推荐 $data_recomm = Db::name('goods') -> where('classify_id',$data['classify_id']) -> limit(3) -> select(); $this -> assign('data_recomm',$data_recomm); return $this -> fetch(); } }