Laravel連表クエリーマルチテーブルクエリーleftjoin

1043 ワード

// start                              
   $speceal_order=\App\BaseOrderModel::leftjoin('ys_sub_order','ys_sub_order.base_id','=','ys_base_order.id')
     ->leftjoin('ys_order_goods','ys_sub_order.id','=','ys_order_goods.sub_id')
     ->leftjoin('ys_goods','ys_goods.id','=','ys_order_goods.goods_id')
     ->leftjoin('ys_goods_class','ys_goods_class.id','=','ys_goods.class_id')
      ->where('ys_base_order.state',1)
      ->where('ys_sub_order.receive_state',1)
      ->where('ys_sub_order.all_rebate','>',0)
      ->where('ys_sub_order.back_state',0)
      ->groupBy('ys_base_order.user_id')
       ->select('ys_order_goods.*','ys_goods.class_id','ys_goods_class.first_id')
       ->get();

       @file_put_contents($path.'/speceal_order.txt', print_r($speceal_order,true));