cant display all result from 2 table join with pivot table

Question

I have managed to join between 2 tables by using 1 pivot table(I have to), but I cant loop my way to get all of joined result, Bellow are:

Models App.php

belongsToMany(Role::class,'bas_role_app','app_id','role_id');
    }

}

Role.php

belongsToMany('App\User','bas_user_role','role_id','user_id')
        ->withPivot('id');
    }

    public function apps()
    {
    //     return $this->belongsToMany(App::class,'bas_role_app','role_id','app_id')
    //     ->withPivot('id','priv_access','priv_insert','priv_delete',
    // 'priv_update','priv_export','priv_print','app_name');
    return $this->belongsToMany(App::class,'bas_role_app','role_id','app_id');
    }

}

RoleApp.php

belongsToMany(App::class);
    }

    public function b_role() {
        return $this->belongsToMany(Role::class);
    }
}

Controller RoleAppController.php

    namespace App\Http\Controllers;
    
    use Illuminate\Http\Request;
    use Illuminate\Support\Facades\Validator;
    use Illuminate\Support\Facades\Auth;
    use Carbon\Carbon;
    use Illuminate\Support\Facades\Route;
    use App\User;
    use App\Role;
    use App\App;
    use App\ActivityLog;
    use App\RoleApp;
    use Illuminate\Support\Facades\Input;
    use DB;
    
    class RoleAppController extends Controller
    {
        public function __construct()
        {
            $this->middleware('auth');
        }
    
        public function display(Request $request)
        {
             $routes =  preg_match('/([a-z]*)@([a-z]*)/i', Route::currentRouteAction(), $matches);
             $routes = $matches[0];
             $action = $matches[2];
    
            if (Auth::check()) {
                DB::beginTransaction();
    
                try {
                $id = Auth::id();
                $profile_data = User::find($id);
                $RoleApp = Role::all();
            //$RoleApp->apps;
          //  dd($RoleApp);
          
    
                     ActivityLog::create([
    
                         'inserted_date' => Carbon::now()->TimeZone('asia/jakarta'),
                         'username' => $profile_data->username,
                         'application' => $routes,
                         'creator' => "System",
                         'ip_user' => $request->ip(),
                         'action' => $action,
                       'description' => "admin is looking at the role and application management",
                         'user_agent' => $request->server('HTTP_USER_AGENT')
                     ]);
    
                     DB::commit();
                 } catch (\Exception $ex) {
                     DB::rollback();
                 return response()->json(['error' => $ex->getMessage()], 500);
    
                 }
              //  return view('RoleApp', ['RoleApp' => $RoleApp]);
               return view('RoleApp', ['RoleApp' => $RoleApp]);
             } else {
                 return view("login");
             }
        }
}

View RoleApp.blade.php

@extends('layouts.master')
@section('title','Display-RoleApp')
@section('content')



    
        
            @if($errors->any())
            
                {{ implode(', ', $errors->all(':message')) }}
                
            
            @endif
            
                
            




   
   
    
        
            
                Insert User
                
            
            
                
                    {{ csrf_field() }}

                    
                        role name:
                        
                    

                    
                        app name:
                        
                    

            
            
                
                
            
            
        
    



                
            
                    @foreach ($RoleApp->apps as $rp)
                    
                    @endforeach
                
                
                    
                        Role Name
                        App Name
                        Action
                        Action
                    
                
                

                        {{$RoleApp->name}}
                        {{$rp->app_name}}

                        
                            
                        
                        
                            
                        
                    
            
        
    




@endsection

Any suggestion? I have tried various way and its still not working. I suspect that something is wrong in

$RoleApp = Role::all();

or

  @foreach ($RoleApp->apps as $rp)
                        
    
                            {{$RoleApp->name}}
                            {{$rp->app_name}}
    
                            
                                
                            
                            
                                
                            
                        
                        @endforeach

if I try it with $RoleApp = Role::find(2); it will still work, but when i use get or all, it wont work.

user_13257968 · Answer

without eager loading.

$roles = Role::all();

with eager loading

$roles = Role::with('apps')->get();

$roles is a collection of model instances of Role Model. You can't access a property or relation of a model, on a collection. That is the reason it works when you use find(given model instance), and doesn't work for all or get(give collection).

You need to iterate over the collection and then access the relation like this.

foreach($roles as $role){
    // name of each role.
    $role->name;

   
    foreach($role->apps as $app){
       // name of each app associated with the $role.
       $app->name;
    }
}

cant display all result from 2 table join with pivot table

1 Answers