Laravel设置了自动WHERE子句

Question

I use models that extend a generic_model, which in turn extends Eloquent (so that I have several crud methods I use already set to be inherited).

A lot of the tables I use invoke soft delete, which needs a WHERE clause of...

WHERE deleted = 0

Is there a way to make Laravel behave in such a way that this WHERE clause is automatically included in all queries and all queries to objects that are related to one another?

e.g.

pages where id = 5 and deleted = 0

and then...

images where page_id = 5 and deleted = 0

Answer 1

if you're using laravel 3 this is what you needs

on your model

public function query()
{

    $query = parent::query();

    $query->where('deleted','=','0');

    return $query;
}

if you're using laravel 4 just change the method query for newQuery

public function newQuery()
{

    $query = parent::newQuery();

    $query->where('deleted','=','0');

    return $query;
}

reference