Laravel / Lumen模型查询::和where：如何做到这一点？

Question

Hey there in Laravel/Lumen I have got a Model "Article". The following works:

    $article = Article::with('ArticleTranslations',
       'ArticleTranslations.Terms','Category','Category.CategoryTranslations')
        ->where('tbl_article.a_id',$id)
        ->first();

However the following fails with an Exception:

    $article = Article::with('ArticleTranslations',
        'ArticleTranslations.Terms','Category','Category.CategoryTranslations')
        ->where('tbl_article.a_id',$id)
        ->where('tbl_articleTranslation.at_languageId',$language->getKey())
        ->where('tbl_categoryTranslation.ct_languageId',$language->getKey())
        ->first();

... while the Exception is like this:

(3/3) QueryException SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tbl_articleTranslation.at_languageId' in 'where clause' (SQL: select * from tbl_article where tbl_article.a_id = 1 and tbl_articleTranslation.at_languageId = 2 and tbl_categoryTranslation.ct_languageId = 2 limit 1) in Connection.php (line 664) at Connection->runQueryCallback('select * from tbl_article where tbl_article.a_id = ? and tbl_articleTranslation.at_languageId = ? and tbl_categoryTranslation.ct_languageId = ? limit 1', array('1', 2, 2), object(Closure)) in Connection.php (line 624)

However I am sure that tbl_articleTranslation.at_languageId exists. Where may I be going wrong and is there a more correct way to do it?

Answer 1

If you want to filter the related records that get loaded with your Article, you need to apply constraints to the relations.

In order to load all articles but include only translations for given language, do the following:

$article = Article::with(
  'ArticleTranslations' => function($query) use ($language) {
    $query->where('at_languageId', $language->getKey());
  },       
  'ArticleTranslations.Terms',
  'Category',
  'Category.CategoryTranslations' => function($query) use ($language) {
    $query->where('ct_languageId', $language->getKey());
  }
)->findOrFail(id);