2021年1月1日星期五

Laravel 8 using group by in view/blade by foreach

I have this code in my controller:

public function videoGallery()  {      $videoLinksRecord = VideoLinks::all()->sortBy('video_category_id')->groupBy('video_catetgory_id');        return view('video.gallery')->with('videoLinksRecord', $videoLinksRecord);  }  

which return this query:

{      "1": [          {"id":1,"video_category_id":1,"name":"Laszlo - Supernova","link":"PKfxmFU3lWY","description":"one loud banger!","home_video":null,"created_at":"2020-12-31T14:12:13.000000Z","updated_at":"2020-12-31T14:12:13.000000Z","deleted_at":null},          {"id":2,"video_category_id":1,"name":"Subtact - Restart","link":"M5A46A2txC4","description":"one loud banger!","home_video":null,"created_at":"2020-12-31T14:12:13.000000Z","updated_at":"2020-12-31T14:12:13.000000Z","deleted_at":null},          {"id":3,"video_category_id":1,"name":"Sushi Killer & Kevin Villeco - Anime Bae","link":"YHHjfYxLyuA","description":"one loud banger!","home_video":null,"created_at":"2020-12-31T14:12:13.000000Z","updated_at":"2020-12-31T14:12:13.000000Z","deleted_at":null},          {"id":4,"video_category_id":1,"name":"Hyper Potions & Subtact - Adventures","link":"TKZUhs9Gcdo","description":"one loud banger!","home_video":null,"created_at":"2020-12-31T14:12:13.000000Z","updated_at":"2020-12-31T14:12:53.000000Z","deleted_at":null}      ],      "2": [          {"id":5,"video_category_id":2,"name":"Laszlo - Supernova","link":"PKfxmFU3lWY","description":"one loud banger!","home_video":null,"created_at":"2020-12-31T14:12:13.000000Z","updated_at":"2020-12-31T14:12:13.000000Z","deleted_at":null},          {"id":6,"video_category_id":2,"name":"Subtact - Restart","link":"M5A46A2txC4","description":"one loud banger!","home_video":null,"created_at":"2020-12-31T14:12:13.000000Z","updated_at":"2020-12-31T14:12:13.000000Z","deleted_at":null},          {"id":7,"video_category_id":2,"name":"Sushi Killer & Kevin Villeco - Anime Bae","link":"YHHjfYxLyuA","description":"one loud banger!","home_video":null,"created_at":"2020-12-31T14:12:13.000000Z","updated_at":"2020-12-31T14:12:13.000000Z","deleted_at":null}      ]  }  

I want to display the result grouped by its video category similar to this blade:

  <h2 class="poppins-medium text-lg text-darkergreen text-center">Video Category Name Here</h2>  <div class="container-fluid">      <div class="row">          <div class="col-4"></div>          <div class="col-4 borderline-darkergreen-md"></div>          <div class="col-4"></div>      </div>  </div>    <div class="container-fluid">      <div class="row d-flex justify-content-center px-0">          <div class="col col-lg-2 d-none d-lg-block d-xl-none"></div>          <div class="col col-xl-2 d-none d-xl-block"></div>                    <div class="col-12 col-md-6 col-lg-4 container-fluid d-flex justify-content-center spacer-md">              <div class="row d-flex justify-content-center">                  <div class="col-12 d-flex justify-content-center container-fluid px-0">                                            <div class="video-box-border position-relative spacer-md">                            <a href="">                                                            <div class="video-image position-absolute"></div>                                                            <div class="video-card"></div>                          </a>                      </div>                  </div>                  <div class="container-fluid">                      <div class="row">                          <div class="col-2 px-0"></div>                          <div class="col-8 borderline-darkergreen-sm px-0"></div>                          <div class="col-2 px-0"></div>                      </div>                  </div>                                    <p class="poppins-normal text-md text-gray text-center">Video Name Here                  </p>              </div>          </div>      </div>  </div>  

How should I use the $videoLinksRecord in a foreach logic to display it by its groupBy logic? This is my first time grouping query result so I do not know how to construct the logic for the said desired result.

https://stackoverflow.com/questions/65535552/laravel-8-using-group-by-in-view-blade-by-foreach January 02, 2021 at 10:30AM

没有评论:

发表评论