dsw8292301 2016-02-16 08:55
浏览 148

使用Eloquent Model在Laravel中基于父级到子级获取子子级

I have products with products category with Multiple Level. I have used elequont model to get the first level of the category. But i am not able to get the sub sub category of the products. Here is how my model looks like:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Services extends Model
{
    //
    protected $fillable = [
        'servicename', 'serviceslug', 'service_id','priceinr', 'priceusd','details', 'footertext','user_id'
    ];

    public function parent()
    {
        return $this->belongsTo('App\Services', 'service_id');
    }

    public function children()
    {
        return $this->hasMany('App\Services', 'service_id');
    }
}

Table structure looks like this: enter image description here

And this is how my controller looks like:

public function show($id)
    {
        $services = Services::where('service_id', 0)->with('children')->get();
        //return $services;

        return view('services.edit')->with('services', $services);
    }

And in view its normal dropdown.

<select class="form-control" name="service_id">
                                <option value="">Select...</option>
                                @foreach($services as $service)
                                @if($service->service_id == 0)
                                <option value="{{$service->id}}">{{$service->servicename}}</option>
                                @else
                                <option value="{{$service->id}}">&nbsp;&nbsp;&nbsp;{{$service->servicename}}</option>
                                @endif
                            @endforeach
                            </select>

I am able to get this:

Cloths
   Mens
      Shirt    //Not able to get shirt and below level
      trousers    //Not able to get trousers and below level
   Womens
      Tshirt   //Not able to get Tshirt and below level
      Jeans    //Not able to get Jeans and below level

Any solution will be helpful here. I want to get the values in dropdown which can look nested.

Thank you! (In advance)

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 mmocr的训练错误,结果全为0
    • ¥15 python的qt5界面
    • ¥15 无线电能传输系统MATLAB仿真问题
    • ¥50 如何用脚本实现输入法的热键设置
    • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
    • ¥30 深度学习,前后端连接
    • ¥15 孟德尔随机化结果不一致
    • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
    • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
    • ¥15 谁有desed数据集呀