将查询结果加入到“调用成员函数leftJoin（）null”

问题描述：

我想从我的控制器上运行laravel的联接查询，但我得到了“调用成员函数leftJoin（）null”将查询结果加入到“调用成员函数leftJoin（）null”

public function tracking_groupindividual(Request $request) 
{ 
    $user_id = $request->user_id; 
    $group_id = $request->group_id; 

    $get_group_individual_details = DB::table('group_usermapping as gu') 
     ->select(
      'um.user_id', 
      'um.user_name', 
      'um.image_path', 
      'um.mobile_number', 
      'ul.latitude', 
      'ul.longitude', 
      'um.isnearby_on', 
      'gu.isadmin', 
      'um.profile_status', 
      'ul.timedout' 
     ) 
     ->join('user_master as um','gu.user_id','=','um.user_id') 
     ->join('groupusers_location as ul','ul.user_id','=','um.user_id','ul.group_id','=','gu.group_id') 
     ->where(function ($query) use ($group_id) { 
      $query->where('gu.group_id', '=', $group_id) 
       ->where('gu.isactive','=','1')->where('um.isactive','=','1'); 
     })->get(); 

     return $get_group_individual_details; 
    }

答

我在第二个连接中发现的问题和固定它

public function tracking_groupindividual(Request $request) 
{ 
    $user_id = $request->user_id; 
    $group_id = $request->group_id; 

    $get_group_individual_details = DB::table('group_usermapping as gu') 
     ->select(
      'um.user_id', 
      'um.user_name', 
      'um.image_path', 
      'um.mobile_number', 
      'ul.latitude', 
      'ul.longitude', 
      'um.isnearby_on', 
      'gu.isadmin', 
      'um.profile_status', 
      'ul.timedout' 
     ) 
     ->join('user_master as um','gu.user_id','=','um.user_id') 
     ->join('groupusers_location as ul', function ($join) { 
      $join->on('ul.user_id','=','um.user_id') 
       ->where('ul.group_id','=','gu.group_id'); 
     }) 
     ->where(function ($query) use ($group_id) { 
      $query->where('gu.group_id', '=', $group_id) 
       ->where('gu.isactive','=','1')->where('um.isactive','=','1'); 
     })->get(); 

     return $get_group_individual_details; 
    }

现在在选择“调用成员函数select（）null”时出现相同的错误“@Morteza Rajabi – Akumar

使用Use Illuminate \ Support \ Facades \ DB在我的控制器中导入数据库类 – Akumar

答

尝试使用DB ::生（）的别名！

$get_group_individual_details = DB::table(DB::raw('group_usermapping as gu')) 
           ->join(DB::raw('user_master as um'),DB::raw('gu.user_id'),'=',DB::raw('um.user_id')) 
           ->join(DB::raw('groupusers_location as ul'),DB::raw('ul.user_id'),'=',DB::raw('um.user_id'),DB::raw('ul.group_id'),'=',DB::raw('gu.group_id')) 
           ->select(DB::raw('um.user_id'),DB::raw('um.user_name'),DB::raw('um.image_path'),DB::raw('um.mobile_number'),DB::raw('ul.latitude'),DB::raw('ul.longitude'),DB::raw('um.isnearby_on'),DB::raw('gu.isadmin'),DB::raw('um.profile_status'),DB::raw('ul.timedout')) 
           ->where(function ($query) use ($group_id) { 
             $query->where(DB::raw('gu.group_id'), '=', $group_id)->where(DB::raw('gu.isactive'),'=','1')->where(DB::raw('um.isactive'),'=','1'); 
             })->get(); 

return $get_group_individual_details;

和替换使用照亮的\ Support \外立面\ DB;与使用DB;

将查询结果加入到“调用成员函数leftJoin（）null”

相关推荐