Yii all HAS_MANY relation condition?

Question

Yii

Greetings
There is a Project
model Attributes: id, name
There is a Task
model Attributes: id, project_id, name, accepted
HAS_MANY relation (relation name - "tasks") from Task to (project_id => id) is added to Project.
The question is how to form a query using ActiveRecord in the search() method (you need to form a dataProvider for CListView + CPagination), which would select all Projects that have all tasks.accepted = 1 ?
PS
The whole difficulty lies in taking into account projects for which ALL tasks have been completed (and not at least one task)
Thank you for your attention :)

Answer 1

The easiest option:

SELECT p.id, p.name, COUNT(t.id) as non_accepted_tasks FROM projects p 
LEFT JOIN tasks t ON t.project_id=p.id AND t.accepted <> 1 
GROUP BY t.project_id
HEAVING non_accepted_tasks = 0;

something like that.
There are also options with subqueries and inner join.

Answer 2

public function getMembers($count = 100){
    return $this->hasMany(User::className(), ['id'=>'user_id'])
      ->limit($count)
      ->viaTable('users_clubs', ['club_id'=>'id'], function($query){
        $query->where(['status'=>User::STATUS_CLUB_JOINED_APPROVED]);
      });
  }

hasMany has a third callback parameter.
$this->hasMany(User::className(), ['id'=>'user_id'], function($query){ $query->where(['id'=>1]); })