How to pull related records with a condition?

Question

Yii

It's me again :)
There is a table with orders (orders) and a table with order logs (orders_log)
in the logs there are fields action (event name) order_id (on which order it worked) and date (when)
i.e. for one order there can be several events in chronological order (arrived, issued, sent, received).
in the search model, it pulls the first available status. but you need to pull one with the maximum date (well, that is, the most current status). how can this be checked? to keep the filter working.
$query->joinWith(['logs'])->with('logs');

Answer 1

Good afternoon.
Try like this

->joinWith([
     'logs' => function(ActiveQuery $query){
           $query->where(/* тут условие */);
     }
 ])

Answer 2

If you get your orders_log in the model, by a method that implies a relation, like

public function getLogs()
{
    return $this->hasMany(Log::className(), ['order_id' => 'id']);
}

Then in the search method of the search model, you can do this

$query->joinWith(['logs'])
//фильтры
//$query->filterWhere(какой-то фильтр)
//...
//после всех фильтров
$query->orderBy([Log::tablename().'.date'=>SORT_DESC])->limit(1);