Code Coverage for C:\Web\root-users\meeting\common\models\MeetingSurveyQuery.php

1	<?php
2
3	namespace common\models;
4
5	use Yii;
6
7	/**
8	* This is the query model class for table "{{%meeting_survey}}".
9	*/
10	class MeetingSurveyQuery extends \yii\db\ActiveQuery implements ISurveyQuery
11	{ use GenericSurveyQuery;
12	/**
13	* @inheritdoc
14	* Set up GenericSurveyQuery
15	*/
16	public function __construct($config = [])
17	{
18	parent::__construct($config);
19
20	$this->subQuery = MeetingSurveyLock::find();
21	$this->foreignColumn = '[[meeting_survey_id]]';
22	}
23
24	protected function userSelector($user_id){
25	$participantsSubQuery = Participant::find()
26	->select('[[id]]')
27	->where(['[[user_id]]' => $user_id]);
28	return ['IN', '[[participant_id]]', $participantsSubQuery];
29	}
30
31	protected function meetingSelector($meeting_id){
32	return ['meeting_id' => $meeting_id];
33	}
34
35	/**
36	* Select only available surveys for meeting
37	*/
38	public function availableForMeeting($meeting_id)
39	{
40	$this->subQuery->select([$this->foreignColumn]);
41	$this->subQuery->andWhere($this->meetingSelector($meeting_id));
42	if(!$this->subQueryJoined)
43	{
44	$class = $this->modelClass;
45	$tableName = $class::tableName();
46	$this->andWhere(['NOT IN', $tableName . '.[[id]]', $this->subQuery]);
47	$this->subQueryJoined = true;
48	}
49	return $this;
50	}
51	}