CODEWITHSUNDEEP
phplaravelforeachrelation
slickness
slickness

Reputation: 246

How can I display other data in foreach?

In my show function in which you can watch every single group, I load all articles with the same tags. And the article with the most votes will be displayed separately at the top. In addition, I indicate the average rating of the items in this group. This is how my function looks like:

public function show($id)
    {
        $group = group::find($id);

            $tagIdArray = $group->tags->pluck('id')->all();

            $mostvotedarticle = Article::where('type', 4)->whereIn('privacy', [1, 3])
                ->whereHas('tags', function($query) use ($tagIdArray) {
                    $query->whereIn('tags.id', $tagIdArray);
                }, '>=', count($tagIdArray))
                ->orderByVotes()->first();

            $articledown = Article::where('status', 1)->whereHas('tags', function($query) use ($tagIdArray) {
                $query->whereIn('tags.id', $tagIdArray);
            }, '>=', count($tagIdArray))->downVotesAll()->count();

            $articleup = Article::where('status', 1)->whereHas('tags', function($query) use ($tagIdArray) {
                $query->whereIn('tags.id', $tagIdArray);
            }, '>=', count($tagIdArray))->upVotesAll()->count();

            $ratio = null;

            if($articleup + $articledown == 0) {
                $ratio = 0;
            } else {
                $ratio = ($articleup*100)/($articleup + $articledown);
            }

    return view('singlegroup',compact('groups','mostvotedarticle', 'ratio'));
}

On a overview page, the individual groups are displayed with a foreach loop:

function:

public function index()
    {
        $user = Auth::user();
        $groups = $user->groups()->latest()->with('tags')->paginate(20);

        return view('groups', compact('groups'));
    }

view:

@foreach ($groups as $group)
        {{$group->name}}                      
        <img src="-----load mostvotedarticle that is in this group------" alt="" />
        <div class="progress-bar-primary" style="width:{{$ratio}}%;">
@endforeach

How can I have the mostvotedarticle and group ratings displayed in the foreach loop?

Article Model

public function scopeOrderByVotes($query)
    {
        $query->leftJoin('Article_activities', 'Article_activities.article_id', '=', 'articles.id')
            ->selectRaw('articles.*, count(Article_activities.id) as aggregate')
            ->groupBy('articles.id')
            ->orderBy('aggregate', 'desc');
    }

    public function scopeDownVotesAll($query)
    {
        $query->leftJoin('Article_activities', 'Article_activities.article_id', '=', 'articles.id')
            ->selectRaw('articles.*, count(Article_activities.id) as aggregate')
            ->where('Article_activities.activity', '=', '0');
    }

    public function scopeUpVotesAll($query)
    {
        $query->leftJoin('Article_activities', 'Article_activities.article_id', '=', 'articles.id')
            ->selectRaw('articles.*, count(Article_activities.id) as aggregate')
            ->where('Article_activities.activity', '=', '1');
    }

Upvotes: 0

Views: 139

Answers (1)

Alexander Villalobos
Alexander Villalobos

Reputation: 461

you need put all inside your foreach groups

public function index() 
{ 
 $user = Auth::user(); 
 $groups = $user->groups()->latest()->with('tags')->paginate(20); 
 $ratio = null; 
 foreach($groups as $key => $group) 
 { 
  $tagIdArray = $group->tags->pluck('id')->all(); 
  $mostvotedarticle = Article::where('type', 4)->whereIn('privacy', [1, 3]) 
  ->whereHas('tags', function($query) use ($tagIdArray) { 
  $query->whereIn('tags.id', $tagIdArray); 
  }, '>=', count($tagIdArray)) 
  ->orderByVotes()->first(); 

 $articledown = Article::where('status', 1)->whereHas('tags', function($query) use 
 ($tagIdArray) { 
 $query->whereIn('tags.id', $tagIdArray); 
 }, '>=', count($tagIdArray))->downVotesAll()->count(); 

$articleup = Article::where('status', 1)->whereHas('tags', function($query) use 
($tagIdArray) { 
$query->whereIn('tags.id', $tagIdArray); 
}, '>=', count($tagIdArray))->upVotesAll()->count(); 


if($articleup + $articledown == 0) { 
$ratio = 0; 
} else { 
$ratio = ($articleup*100)/($articleup + $articledown); 
} 

$group->mostVote = $mostvotedarticle; 
$group->ratio = $ratio; 
 } 
  return view('groups', compact('groups')); 
}

Upvotes: 1

Related Questions