通過其中一些不是來自用戶請求的值在laravel控制器中創建json物件回應-有解無憂

我有這個方法我想在 JSON 物件中顯示值，并且一些值是從陣列中獲取的，并通過 for 回圈通過 DB 查詢傳遞，以便檢查陣列中的每個值，但答案之后只顯示一個值通過回圈，但我想根據在 for 回圈中傳遞的每個等級做出回應

public function  TODreport($school_id, $date){
$school = School::where('id', $school_id)->first();
$school_education_level = $school->educationLevel;
$levels =[];
$grade = null;

if($school_education_level == 'Secondary'){
    array_push($levels, 'Form One', 'Form Two', 'Form Three', 'Form Four');
       
    foreach($levels as $level){

        $total_students = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
        ->where('school_id', $school_id)
        ->where('grade', $level )
        ->count();

        $total_boys_present_in_class = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
        ->where('school_id', $school_id)
        ->where('attendance_id' , "1")
        ->where('grade', $level )
        ->whereHas('student' , function($query){
            return $query->where('gender', 'male');
        })
        ->count();

        $total_girls_present_in_class = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
        ->where('school_id', $school_id)
        ->where('attendance_id' , "1")
        ->where('grade', $level )
        ->whereHas('student' , function($query){
            return $query->where('gender', 'female');
        })
        ->count();

        $total_boys_absent_in_class = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
        ->where('school_id', $school_id)
        ->where('attendance_id' , "2")
        ->where('grade', $level )
        ->whereHas('student' , function($query){
            return $query->where('gender', 'male');
        })
        ->count();
        
        $total_girls_absent_in_class = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
        ->where('school_id', $school_id)
        ->where('attendance_id' , "2")
        ->where('grade', $level )
        ->whereHas('student' , function($query){
            return $query->where('gender', 'female');
        })
        ->count();

    }
    $grade = $level;


  

}else{
   array_push($levels,'Standard One','Standard Two', 'Standard Three','Standard Four','Standard Five', 'Standard Six', 'Standard Seven');
  
   foreach($levels as $level){
    $grade = $level;

    $total_students = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
    ->where('school_id', $school_id)
    ->where('grade', $level )
    ->count();
    $total_boys_present_in_class = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
    ->where('school_id', $school_id)
    ->where('attendance_id' , "1")
    ->where('grade', $level )
    ->whereHas('student' , function($query){
        return $query->where('gender', 'male');
    })
    ->count();

    $total_girls_present_in_class = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
    ->where('school_id', $school_id)
    ->where('attendance_id' , "1")
    ->where('grade', $level )
    ->whereHas('student' , function($query){
        return $query->where('gender', 'female');
    })
    ->count();

    $total_boys_absent_in_class = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
    ->where('school_id', $school_id)
    ->where('attendance_id' , "2")
    ->where('grade', $level )
    ->whereHas('student' , function($query){
        return $query->where('gender', 'male');
    })
    ->count();
    
    $total_girls_absent_in_class = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
    ->where('school_id', $school_id)
    ->where('attendance_id' , "2")
    ->where('grade', $level )
    ->whereHas('student' , function($query){
        return $query->where('gender', 'female');
    })
    ->count();
}

}

 

//-------total number of students called in attendance in that date-------//
$attendanceschool_fetched  = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
                                                ->where('school_id', $school_id)
                                                ->get();
$total_students_in_school = $attendanceschool_fetched->count();
//-------total number of students called in attendance in that date-------//

//--------total present students fetched in that date-------------------------------//
$attendance_fetched_present = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
                                                ->where('school_id', $school_id)
                                                ->where('attendance_id' , "1")->get();
$total_present_students = $attendance_fetched_present->count();
//--------total present students fetched in that date-------------------------------//


//---------total present boys-----------------------------------------------------//
$total_boys_present = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
                                        ->where('school_id', $school_id)
                                        ->where('attendance_id' , "1")
                                        ->whereHas('student' , function($query){
                                            return $query->where('gender', 'male');
                                        })
                                        ->count();

//---------total present girls-----------------------------------------------------//
$total_girls_present = AttendanceStudent::where('created_at', 'LIKE', $date.'%')   
                                            ->where('school_id', $school_id)
                                            ->where('attendance_id' , "1")
                                            ->whereHas('student' , function($query){
                                                return $query->where('gender', 'female');
                                            })
                                            ->count();

//---------------total absent students in a school-------------------------------//
$attendance_fetched_absent = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
                                                ->where('school_id', $school_id)
                                                ->where('attendance_id' , "2")
                                                ->get();
$total_absent_students = $attendance_fetched_absent->count();

//------------total absent boys in a school---------------------------------//
$total_boys_absent = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
                                        ->where('school_id', $school_id)
                                        ->where('attendance_id' , "2")
                                        ->whereHas('student' , function($query){
                                        return $query->where('gender', 'male');
                                        })
                                        ->count();

//-----------------total absent girls in a school ---------------------------//
$total_girls_absent = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
                                            ->where('school_id', $school_id)
                                            ->where('attendance_id' , "2")
                                            ->whereHas('student' , function($query){
                                            return $query->where('gender', 'female');
                                            })
                                            ->count();






return response()->json([
    'message'=> 'Attendance Report in School',
    $grade => [
        'TotalStudents' => $total_students,
        'TotalPresentBoys'=> $total_boys_present_in_class,
        'TotalPresentGirls'=> $total_girls_present_in_class,
        'TotalAbsentBoys'=> $total_boys_absent_in_class,
        'TotalAbsentGirls'=> $total_girls_absent_in_class
    ]
    ,
    'TotalStudents'=> $total_students_in_school,
    'TotalPresentStudents'=> $total_present_students,
    'TotalAbsentStudents'=> $total_absent_students,
    'TotalPresentBoys'=> $total_boys_present,
    'TotalPresentGirls'=> $total_girls_present,
    'TotalAbsentBoys'=> $total_boys_absent,
    'TotalAbsentGirls'=> $total_girls_absent
]);

}

這給了我下面的 JSON 正文，它只是一個等級值資料

{
"message": "Attendance Report in School",
"Standard Seven": {
    "TotalStudents": 0,
    "TotalPresentBoys": 0,
    "TotalPresentGirls": 0,
    "TotalAbsentBoys": 0,
    "TotalAbsentGirls": 0
},
"TotalStudents": 1,
"TotalPresentStudents": 0,
"TotalAbsentStudents": 1,
"TotalPresentBoys": 0,
"TotalPresentGirls": 0,
"TotalAbsentBoys": 1,
"TotalAbsentGirls": 0

}

但我希望它能夠顯示所有成績而不是回圈中的最后一個成績，如下所示

{
"message": "attendance report in school",
"Standard One": 
         {
       "total_students": 10,
        "total_present_students": 10,
        "total_boys_present": 5,
        "total_girls_present": 5,
         "total_absent_students": 5,
         "total_girls_absent": 5,
         "total_boys_absent": 5
         },
 "Standard Three":
{
       "total_students": 10,
        "total_present_students": 10,
        "total_boys_present": 5,
        "total_girls_present": 5,
         "total_absent_students": 5,
         "total_girls_absent": 5,
         "total_boys_absent": 5
         },
          "Standard Four":
{
       "total_students": 10,
        "total_present_students": 10,
        "total_boys_present": 5,
        "total_girls_present": 5,
         "total_absent_students": 5,
         "total_girls_absent": 5,
         "total_boys_absent": 5
         },
          "Standard Two":
{
       "total_students": 10,
        "total_present_students": 10,
        "total_boys_present": 5,
        "total_girls_present": 5,
         "total_absent_students": 5,
         "total_girls_absent": 5,
         "total_boys_absent": 5
         },

"total students in a school": 200,
"total number of present in a school": 100,
"total number of absent in a school": 22,
"total number of present boys in a school": 22,
"total number of present girls in a school": 22

}

uj5u.com熱心網友回復：

public function TODreport($school_id, $date)
{
    $school = School::where('id', $school_id)->first();
    $school_education_level = $school->educationLevel;
    $result =['message' => 'Attendance Report in School'];
    $levels = [
        'Standard One','Standard Two', 'Standard Three','Standard Four',
        'Standard Five', 'Standard Six', 'Standard Seven',
    ];

    if($school_education_level == 'Secondary') {
        $levels = ['Form One', 'Form Two', 'Form Three', 'Form Four'];
    }

    foreach($levels as $level) {
        $result[$level] = [];

        $result[$level]['total_students'] = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
            ->where('school_id', $school_id)
            ->where('grade', $level )
            ->count();

        $result[$level]['total_boys_present_in_class'] = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
            ->where('school_id', $school_id)
            ->where('attendance_id' , "1")
            ->where('grade', $level )
            ->whereHas('student' , function($query){
                return $query->where('gender', 'male');
            })
            ->count();

        $result[$level]['total_girls_present_in_class'] = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
            ->where('school_id', $school_id)
            ->where('attendance_id' , "1")
            ->where('grade', $level )
            ->whereHas('student' , function($query){
                return $query->where('gender', 'female');
            })
            ->count();

        $result[$level]['total_boys_absent_in_class'] = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
            ->where('school_id', $school_id)
            ->where('attendance_id' , "2")
            ->where('grade', $level )
            ->whereHas('student' , function($query){
                return $query->where('gender', 'male');
            })
            ->count();

        $result[$level]['total_girls_absent_in_class'] = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
            ->where('school_id', $school_id)
            ->where('attendance_id' , "2")
            ->where('grade', $level )
            ->whereHas('student' , function($query){
                return $query->where('gender', 'female');
            })
            ->count();
    }

    //-------total number of students called in attendance in that date-------//
    $result['attendanceschool_fetched']  = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
        ->where('school_id', $school_id)
        ->get();
    $result['total_students_in_school'] = $result['attendanceschool_fetched']->count();
    //-------total number of students called in attendance in that date-------//
    
    //--------total present students fetched in that date-------------------------------//
    $result['attendance_fetched_present'] = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
        ->where('school_id', $school_id)
        ->where('attendance_id' , "1")
        ->get();
    $result['total_present_students'] = $result['attendance_fetched_present']->count();
    //--------total present students fetched in that date-------------------------------//
    
    
    //---------total present boys-----------------------------------------------------//
    $result['total_boys_present'] = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
        ->where('school_id', $school_id)
        ->where('attendance_id' , "1")
        ->whereHas('student' , function($query) {
            return $query->where('gender', 'male');
        })
        ->count();
    
    //---------total present girls-----------------------------------------------------//
    $result['total_girls_present'] = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
        ->where('school_id', $school_id)
        ->where('attendance_id' , "1")
        ->whereHas('student' , function($query) {
            return $query->where('gender', 'female');
        })
        ->count();
    
    //---------------total absent students in a school-------------------------------//
    $result['attendance_fetched_absent'] = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
        ->where('school_id', $school_id)
        ->where('attendance_id' , "2")
        ->get();
    $result['total_absent_students'] = $result['attendance_fetched_absent']->count();
    
    //------------total absent boys in a school---------------------------------//
    $result['total_boys_absent'] = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
        ->where('school_id', $school_id)
        ->where('attendance_id' , "2")
        ->whereHas('student' , function($query) {
            return $query->where('gender', 'male');
        })
        ->count();

    //-----------------total absent girls in a school ---------------------------//
    $result['total_girls_absent'] = AttendanceStudent::where('created_at', 'LIKE', $date.'%')
        ->where('school_id', $school_id)
        ->where('attendance_id' , "2")
        ->whereHas('student' , function($query) {
            return $query->where('gender', 'female');
        })
        ->count();

    return response()->json($result);
}

使用分組可以減少查詢的數量。而且這個方法最好拆分成幾個，因為這樣的代碼很難看懂

轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/528155.html

標籤：json拉拉维尔api后端回复

上一篇：@RequestBody中的RestAPIJson有效負載與資料大小為3MB的Json檔案上傳

下一篇：將標頭發送到客戶端后無法設定。不使用兩種回應