如何在Eloquent中设置连接作为每个查询的默认值？

Question

I have an existing database with a rather bad architecture which I cant change. I want to use it via Eloquent. While using this database I need to add couple of joints to all queries, something like this:

<?php
class SomeModel extends Eloquent {

    protected $table      = 'users';
    protected $primaryKey = 'index';
    public    $timestamps = FALSE;

    function __construct($attributes = array())
    {
        parent::__construct($attributes);

        $this->leftJoin('sites', 'sites.Siteindex', '=', 'users.index');

        $this->leftJoin(DB::raw('(`lookups` `l`)'), function($join){
            $join->on('l.value', '=', 'users.type')->where('l.fieldname', '=', 'user_type');
        });
    }
}

Is it possible?

Answer 1

Instead of using a __construct function in the User Model, create a scope.

public function scopeGetSiteIndex($query) {
    return $query->leftJoin('sites', 'sites.Siteindex', '=', 'users.index');
}

Then you can call it from the controller

$siteIndex = User::getSiteIndex()->get();