duanlaiyin2356 2017-06-19 07:21
浏览 67
已采纳

无法在laravel 5.1中获得很多表格

I am having problem in getting the hasmany relationship data in Laravel eloquent.

AModel hasmany BModel AModel hasmany CModel

AModel has function:

Public function bmodels(){
    return hasMany('BModel');
}

Public function cmodels(){
    return hasMany('CModel');
}

BModel has function:

Public function bmodels(){
    return belongsTo('AModel', amodel_id);
}

CModel has function:

Public function cmodels(){
    return belongsTo('AModel',amodel_id);
}

Now i am trying to get it like this

$amodels = AModel::with('bmodels','cmodels')
        ->where('status_id','2200')
        ->whereIn('eventstatus_id',['1','2'])
        ->get();

and now i want to test this in the for loop.

foreach($amodels as $amodel){
    $bmodels = $model->bmodels();
    if ($amodel && $amodel->end < Carbon::now()){
        foreach ($bmodels as $bmodel){
            $cmodels = $amodel->cmodels();
            foreach($cmodels as $cmodel){
                if ($bmodel->id !== $cmodel->reservation_id || $cmodel->reservation_id != null ){
                    array_push($reservation_needed_to_enter,$bmodel->id);
                }
            }

        }
    }
}
  • 写回答

3条回答 默认 最新

  • duana1021 2017-06-19 12:34
    关注

    You should make changes in your Models, use $this to use belongsTo and hasMany,like

    public function bmodels(){
        return $this->belongsTo('App\AModel','amodel_id');
    }
    public function bmodels(){
        return $this->hasMany('App\BModel');
    }
    

    Just Edited your foreach loop, use $amodel->bmodels instead of $amodel->bmodels()

     foreach($amodels as $amodel){
            $bmodels = $amodel->bmodels;
            if ($amodel && $amodel->end < Carbon::now()){
                foreach ($bmodels as $bmodel){
                    $cmodels = $amodel->cmodels;
                    foreach($cmodels as $cmodel){
                        if ($bmodel->id !== $cmodel->reservation_id || $cmodel->reservation_id != null ){
                            array_push($reservation_needed_to_enter,$bmodel->id);
                        }
                    }
    
                }
            }
        }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥50 随机森林与房贷信用风险模型
  • ¥50 buildozer打包kivy app失败
  • ¥30 在vs2022里运行python代码
  • ¥15 不同尺寸货物如何寻找合适的包装箱型谱
  • ¥15 求解 yolo算法问题
  • ¥15 虚拟机打包apk出现错误
  • ¥15 用visual studi code完成html页面
  • ¥15 聚类分析或者python进行数据分析
  • ¥15 三菱伺服电机按启动按钮有使能但不动作
  • ¥15 js,页面2返回页面1时定位进入的设备