douji3426 2017-10-22 22:43
浏览 34
已采纳

创建模型方法以从另一个模型获取数据

I have the following tables :

Locations:
id
name

areas:
id
name

buildings:
id
name

Reports:
id
content
FK | building_id

How can i write a relationship method in App\Report Model file that allow me to show the report (location) <- from \App\Location Model.

I tried with this, in Report model :

public function location()
    {
        return Location::whereHas('areas', function($q){
            $q->whereHas('observations',function ($q){
                $q->where('observations.id',$this->id);
            });
        })->get();
    }

But it returned an error :

ErrorException (E_ERROR) Call to undefined method App\Location::whereHas() (View:

  • 写回答

1条回答 默认 最新

  • dongpa3109 2017-10-22 23:04
    关注

    Your Location model should extends Eloquent

    use Illuminate\Database\Eloquent\Model;
    
    class Location extends Model
    {
        ...
    

    Also it's better to use Laravel relationships for that. You will end up with a code like this

    public function location()
    {
        return $this->building->area->location;
    }
    

    You will need something like this

    class Report extends Model
    {
        public function location()
        {
            return $this->building->area->location;
        }
    
        public function building()
        {
            return $this->belongsTo(App\Building::class);
        }
    }
    
    class Building extends Model
    {
        public function area()
        {
            return $this->belongsTo(App\Area::class);
        }
    }
    
    class Area extends Model
    {
        public function location()
        {
            return $this->belongsTo(App\Location::class);
        }
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 (希望可以解决问题)ma和mb文件无法正常打开,打开后是空白,但是有正常内存占用,但可以在打开Maya应用程序后打开场景ma和mb格式。
  • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
  • ¥20 腾讯企业邮箱邮件可以恢复么
  • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
  • ¥15 错误 LNK2001 无法解析的外部符号
  • ¥50 安装pyaudiokits失败
  • ¥15 计组这些题应该咋做呀
  • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?
  • ¥15 让node服务器有自动加载文件的功能
  • ¥15 jmeter脚本回放有的是对的有的是错的