php - Laravel 中 Controller 查询 foreach 循环出现问题

Question

大家好，

任何人都可以帮我解决这个代码吗？

public function submitranking(Request $req){
    $dataCandidate = Candidate::all();

    foreach($dataCandidate as $Candidate){
        $judgeRate = Score::where('canId',$Candidate->id )
        ->where('catId',$req->catId )
        ->where('judgeId',$req->judgeId)
        ->sum('score');
        dd($judgeRate);
    }

}

当我dd($judgeRate)时，它应该显示所有考生的分数，但它只显示一条记录？我怎样才能让它循环显示所有考生的总分...请帮助

Answer 1

你应该尝试这个:

public function submitranking(Request $req){

    $dataCandidate = Candidate::get();

    foreach($dataCandidate as $Candidate){
        $judgeRate = Score::where('canId',$Candidate->id )
        ->where('catId',$req->catId )
        ->where('judgeId',$req->judgeId)
        ->sum('score');

        print('<pre style="color:red;">');
        print_r($judgeRate);
        print('</pre>');
    }
    exit;  
}

或者你应该尝试这个:

public function submitranking(Request $req){

    $dataCandidate = Candidate::get();

    foreach($dataCandidate as $Candidate){
        $judgeRate = Score::select('score_id',DB::raw("SUM(score) as score"))
        ->where('canId',$Candidate->id )
        ->where('catId',$req->catId )
        ->where('judgeId',$req->judgeId)
        ->get();

        print('<pre style="color:red;">');
        print_r($judgeRate);
        print('</pre>');
    }
    exit;    
}