下面是我寫的查詢語句，可愁死我了，功能實(shí)現(xiàn)倒是實(shí)現(xiàn)了，寫的太難受了，重復(fù)好多，請(qǐng)問我該如何簡(jiǎn)化呢，或者該怎么傳入變量查詢，或者有什么其他方法簡(jiǎn)化，請(qǐng)舉例，或演示部分，謝謝publicfunctionpostTreat(Request$request){$_page=$request->input("_page");//頁碼$_path=$request->input("_path");//第三級(jí)path$_sortType=$request->input("_sortType");//綜合類別$_sales=$request->input("_sales");//銷售優(yōu)先$_priceSmall=$request->input("_priceSmall");//最低價(jià)$_priceBig=$request->input("_priceBig");//最高價(jià)$page=($_page-1)*4;//是否有價(jià)格區(qū)間限制if(empty($_priceSmall)&&empty($_priceBig)){//是否按銷量排序if(empty($_sales)){//是否有綜合排序判斷綜合類別if($_sortType=="composite"||$_sortType==""){//綜合或沒有$data=DB::table('shop_goods')->where('goods_cid',$_path)->where('goods_status',1)//0未審核1審核通過2審核未通過->where('goods_state',0)//0已上架1已下架->where('goods_recycle',0)//0正常1回收站->skip($page)->take(4)->get();}elseif($_sortType=="price_up"){//價(jià)格最低$data=DB::table('shop_goods')->where('goods_cid',$_path)->where('goods_status',1)//0未審核1審核通過2審核未通過->where('goods_state',0)//0已上架1已下架->where('goods_recycle',0)//0正常1回收站->orderBy('goods_price','asc')//價(jià)格最低->skip($page)->take(4)->get();}elseif($_sortType=="price_down"){//價(jià)格最高$data=DB::table('shop_goods')->where('goods_cid',$_path)->where('goods_status',1)//0未審核1審核通過2審核未通過->where('goods_state',0)//0已上架1已下架->where('goods_recycle',0)//0正常1回收站->orderBy('goods_price','desc')//價(jià)格最高->skip($page)->take(4)->get();}elseif($_sortType=="assess_down"){//評(píng)價(jià)最多//只有在走這個(gè)區(qū)間的時(shí)候,才需要關(guān)聯(lián)查詢?cè)u(píng)價(jià)的數(shù)量$data=DB::table('shop_goods')->leftJoin('shop_assess','shop_goods.goods_id','=','shop_assess.assess_gcode')->selectRaw('shop_goods.*,COUNT(shop_assess.assess_id)asassess_num')->where('shop_goods.goods_cid',$_path)->where('shop_goods.goods_status',1)//0未審核1審核通過2審核未通過->where('shop_goods.goods_state',0)//0已上架1已下架->where('shop_goods.goods_recycle',0)//0正常1回收站->groupBy('shop_goods.goods_id')->orderBy('assess_num','desc')->get();}elseif($_sortType=="publish_new"){//最新發(fā)布$data=DB::table('shop_goods')->where('goods_cid',$_path)->where('goods_status',1)//0未審核1審核通過2審核未通過->where('goods_state',0)//0已上架1已下架->where('goods_recycle',0)//0正常1回收站->orderBy('goods_time','desc')//最新發(fā)布->skip($page)->take(4)->get();}}else{$data=DB::table('shop_goods')->where('goods_cid',$_path)->where('goods_status',1)//0未審核1審核通過2審核未通過->where('goods_state',0)//0已上架1已下架->where('goods_recycle',0)//0正常1回收站->orderBy('goods_num','desc')//銷售倒序排列->skip($page)->take(4)->get();}}else{//是否按銷量排序if(empty($_sales)){//是否有綜合排序判斷綜合類別if($_sortType=="composite"||$_sortType==""){$data=DB::table('shop_goods')->where('goods_cid',$_path)->where('goods_status',1)//0未審核1審核通過2審核未通過->where('goods_state',0)//0已上架1已下架->where('goods_recycle',0)//0正常1回收站->whereBetween('goods_price',[$_priceSmall,$_priceBig])//價(jià)格區(qū)間->skip($page)->take(4)->get();}elseif($_sortType=="price_up"){$data=DB::table('shop_goods')->where('goods_cid',$_path)->where('goods_status',1)//0未審核1審核通過2審核未通過->where('goods_state',0)//0已上架1已下架->where('goods_recycle',0)//0正常1回收站->whereBetween('goods_price',[$_priceSmall,$_priceBig])//價(jià)格區(qū)間->orderBy('goods_price','asc')//價(jià)格最低->skip($page)->take(4)->get();}elseif($_sortType=="price_down"){$data=DB::table('shop_goods')->where('goods_cid',$_path)->where('goods_status',1)//0未審核1審核通過2審核未通過->where('goods_state',0)//0已上架1已下架->where('goods_recycle',0)//0正常1回收站->whereBetween('goods_price',[$_priceSmall,$_priceBig])//價(jià)格區(qū)間->orderBy('goods_price','desc')//價(jià)格最高->skip($page)->take(4)->get();}elseif($_sortType=="assess_down"){$data=DB::table('shop_goods')->leftJoin('shop_assess','shop_goods.goods_id','=','shop_assess.assess_gcode')->selectRaw('shop_goods.*,COUNT(shop_assess.assess_id)asassess_num')//統(tǒng)計(jì)評(píng)價(jià)的數(shù)量->where('shop_goods.goods_cid',$_path)->where('shop_goods.goods_status',1)//0未審核1審核通過2審核未通過->where('shop_goods.goods_state',0)//0已上架1已下架->where('shop_goods.goods_recycle',0)//0正常1回收站->whereBetween('shop_goods.goods_price',[$_priceSmall,$_priceBig])//價(jià)格區(qū)間->groupBy('shop_goods.goods_id')->orderBy('assess_num','desc')->get();}elseif($_sortType=="publish_new"){$data=DB::table('shop_goods')->where('goods_cid',$_path)->where('goods_status',1)//0未審核1審核通過2審核未通過->where('goods_state',0)//0已上架1已下架->where('goods_recycle',0)//0正常1回收站->whereBetween('goods_price',[$_priceSmall,$_priceBig])//價(jià)格區(qū)間->orderBy('goods_time','desc')//最新發(fā)布->skip($page)->take(4)->get();}}else{$data=DB::table('shop_goods')->where('goods_cid',$_path)->where('goods_status',1)//0未審核1審核通過2審核未通過->where('goods_state',0)//0已上架1已下架->where('goods_recycle',0)//0正常1回收站->whereBetween('goods_price',[$_priceSmall,$_priceBig])->orderBy('goods_num','desc')->skip($page)->take(4)->get();}}foreach($dataas$key=>$value){if($value->goods_num>10000){$value->goods_num=round(($value->goods_num)/10000,1).'萬';//將銷量轉(zhuǎn)換}}return$data;}