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条)

报告相同问题?

悬赏问题

  • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行
  • ¥15 Python3.5 相关代码写作
  • ¥20 测距传感器数据手册i2c
  • ¥15 RPA正常跑,cmd输入cookies跑不出来
  • ¥15 求帮我调试一下freefem代码
  • ¥15 matlab代码解决,怎么运行
  • ¥15 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗