将同一类别类型的项目分组

Question

我有此方法返回所提供的服务

public function order_services(){
    
    $services = DB::select('select * from services');
    return view('guests/services',['services'=>$services]);;

}

，并且我像这样显示

<ul class="list-group" id="myUl">
   @foreach ($services as $service)
   <li class="list-group-item d-flex justify-content-between align-items-center border border-danger"><span  style="font-size:24px; color:red
      "><i class="bi bi-check-circle font-weight-bold "></i></span> <span style="font-weight:bold" id="service_category">{{ $service->service_category }}</span><span><u><i class="bi bi-magic"></i></u></span></li>
   <li class="list-group-item d-flex justify-content-between align-items-center"><span class="product_name" style="font-size:24px; color:#870FD1" data-price="349.34"><i class="bi bi-plus-circle"></i></span> <span class="product_name" id="service_name" data-price="{{ $service->service_price }}" data-category="{{ $service->service_category }}" >{{ $service->service_name }}</span><span class="text-success"><u>Available</u></span></li>
   @endforeach
</ul>

我的表具有service_name and service_category

我想显示service> servication_category as标题和该类别下的所有服务。这可以在刀片中完成，还是需要首先格式化控制器中的结果？

Answer 1

您可以将列表与php（在Blade的控制器中为@PHP指令）分组：

$list = [];
foreach($services as $item) {
  $list[$item->service_category][] = $item;
}

更新的方法

public function order_services(){
    

    $services=  DB::table('services')
            ->selectRaw('id,service_name,service_category,service_price')
            ->orderBy('service_category')
            ->get();
            
    $list = [];
    foreach($services as $item) {
      $list[$item->service_category][] = $item;
    }
    
    return view('guests/services',['list'=>$list]);

}

，您可以在Blade中使用$ list以显示结果：

@foreach ($list as $category => $item)
  <h2>{{ $category }}</h2>
   <ul class="list-group" id="myUl">
     @foreach ($item as $service)
       <li class="list-group-item d-flex justify-content-between align-items-center border border-danger"><span  style="font-size:24px; color:red
      "><i class="bi bi-check-circle font-weight-bold "></i></span> <span style="font-weight:bold" id="service_category">{{ $service->service_category }}</span><span><u><i class="bi bi-magic"></i></u></span></li>
       <li class="list-group-item d-flex justify-content-between align-items-center"><span class="product_name" style="font-size:24px; color:#870FD1" data-price="349.34"><i class="bi bi-plus-circle"></i></span> <span class="product_name" id="service_name" data-price="{{ $service->service_price }}" data-category="{{ $service->service_category }}" >{{ $service->service_name }}</span><span class="text-success"><u>Available</u></span></li>
     @endforeach
   </ul>
@endforeach