Laravel嵌套循环过滤：子表数据不达标则跳过对应子循环

Got it, let's tackle this problem. You want to skip calculating and displaying grades for a term (like firstTerm) if any of its records have a subject number below 32, right? Here are two solid solutions you can use in Laravel, depending on how you prefer to structure your code:

方案一：模型层封装逻辑（推荐，符合Laravel最佳实践） #

This approach keeps your data logic in the model where it belongs, making your views cleaner and easier to maintain later.

Step 1: Add helper methods to your Students model #

Open up your Students model and add these methods to handle term validation and filtered grades:

// Keep your existing relationships as-is
public function firstTerm()
{
    return $this->hasMany(FirstTerm::class);
}

public function secondTerm()
{
    return $this->hasMany(SecondTerm::class);
}

public function finalTerm()
{
    return $this->hasMany(FinalTerm::class);
}

// Check if a term has any invalid grades (number < 32)
public function hasInvalidGrades($term)
{
    return $this->{$term}()->where('number', '<', 32)->exists();
}

// Get only valid grades (number >= 32) for a term
public function getValidTermGrades($term)
{
    return $this->{$term}()->where('number', '>=', 32)->get();
}

Step 2: Optimize controller preloading (optional, for better performance) #

To avoid N+1 database queries, you can preload only the valid grades when fetching students. Update your controller method like this:

public function classWiseResult(Request $request)
{ 
    $students = Students::where('class', $request->class)
        ->with(['firstTerm' => function($query) {
            $query->where('number', '>=', 32);
        }])
        ->with(['secondTerm' => function($query) {
            $query->where('number', '>=', 32);
        }])
        ->with(['finalTerm' => function($query) {
            $query->where('number', '>=', 32);
        }])
        ->get(); 

    return view('admin.showResult.show', compact('students')); 
}

Step 3: Update your view to use the model methods #

Now your view can easily check for invalid grades and skip calculation if needed:

@foreach($students as $student)
    <tr>
        <td>{{ $student->id }}</td>
        <td>{{ $student->fname }}</td>
        
        {{-- Handle First Term --}}
        @if(!$student->hasInvalidGrades('firstTerm'))
            <?php 
                $Ftotal = 0; 
                $Fcount = 0; 
                foreach($student->getValidTermGrades('firstTerm') as $first) {
                    $Fcount++;
                    $Ftotal += gradePoint($first->number);
                }
                $fttp = gpa($Ftotal, $Fcount);
            ?>
            <td>{{ $fttp }}</td>
            <td>{{ letterGrade($fttp) }}</td>
        @else
            {{-- Show placeholder if term has invalid grades --}}
            <td>-</td>
            <td>-</td>
        @endif

        {{-- Handle Second Term (same pattern) --}}
        @if(!$student->hasInvalidGrades('secondTerm'))
            <?php 
                $Stotal = 0; 
                $Scount = 0; 
                foreach($student->getValidTermGrades('secondTerm') as $second) {
                    $Scount++;
                    $Stotal += gradePoint($second->number);
                }
                $sttp = gpa($Stotal, $Scount);
            ?>
            <td>{{ $sttp }}</td>
            <td>{{ letterGrade($sttp) }}</td>
        @else
            <td>-</td>
            <td>-</td>
        @endif

        {{-- Handle Final Term (same pattern) --}}
        @if(!$student->hasInvalidGrades('finalTerm'))
            <?php 
                $Ttotal = 0; 
                $Tcount = 0; 
                foreach($student->getValidTermGrades('finalTerm') as $final) {
                    $Tcount++;
                    $Ttotal += gradePoint($final->number);
                }
                $tttp = gpa($Ttotal, $Tcount);
            ?>
            <td>{{ $tttp }}</td>
            <td>{{ letterGrade($tttp) }}</td>
        @else
            <td>-</td>
            <td>-</td>
        @endif
    </tr>
@endforeach

方案二：直接在视图中判断（快速实现） #

If you don't want to modify your model or controller right now, you can handle the check directly in the view using Laravel's collection methods:

@foreach($students as $student)
    <tr>
        <td>{{ $student->id }}</td>
        <td>{{ $student->fname }}</td>
        
        {{-- First Term Check --}}
        @if(!$student->firstTerm->where('number', '<', 32)->count())
            <?php 
                $Ftotal = 0; 
                $Fcount = 0; 
            ?>
            @foreach($student->firstTerm->where('number', '>=', 32) as $first)
                <?php 
                    $Fcount++;
                    $Ftotal += gradePoint($first->number); 
                ?>
            @endforeach
            <?php $fttp = gpa($Ftotal, $Fcount) ;?>
            <td>{{ $fttp }}</td>
            <td>{{ letterGrade($fttp) }}</td>
        @else
            <td>-</td>
            <td>-</td>
        @endif

        {{-- Second Term Check --}}
        @if(!$student->secondTerm->where('number', '<', 32)->count())
            <?php 
                $Stotal = 0; 
                $Scount = 0; 
            ?>
            @foreach($student->secondTerm->where('number', '>=', 32) as $second)
                <?php 
                    $Scount++;
                    $Stotal += gradePoint($second->number); 
                ?>
            @endforeach
            <?php $sttp = gpa($Stotal, $Scount) ;?>
            <td>{{ $sttp }}</td>
            <td>{{ letterGrade($sttp) }}</td>
        @else
            <td>-</td>
            <td>-</td>
        @endif

        {{-- Final Term Check --}}
        @if(!$student->finalTerm->where('number', '<', 32)->count())
            <?php 
                $Ttotal = 0; 
                $Tcount = 0; 
            ?>
            @foreach($student->finalTerm->where('number', '>=', 32) as $final)
                <?php 
                    $Tcount++;
                    $Ttotal += gradePoint($final->number); 
                ?>
            @endforeach
            <?php $tttp = gpa($Ttotal, $Tcount) ;?>
            <td>{{ $tttp }}</td>
            <td>{{ letterGrade($tttp) }}</td>
        @else
            <td>-</td>
            <td>-</td>
        @endif
    </tr>
@endforeach

Quick Notes #

• 方案一 is better for long-term maintenance—if you ever need to change the threshold (like from 32 to 30), you only have to update one place in the model.
• 方案二 is faster to implement but keeps logic in the view, which can get messy if you have more terms or complex rules later.

内容的提问来源于stack exchange，提问作者Taslim