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

1	<?php
2
3	namespace common\models;
4
5	use Yii;
6
7	/**
8	* Generic implementation of interface
9	*/
10	trait GenericSurveyQuery {
11	private $subQueryJoined = false;
12
13	/**
14	* Select only active surveys right now
15	*/
16	public function active()
17	{
18	$this->andWhere(
19	['AND',
20	['OR',
21	'available_from <= :time',
22	'available_from IS NULL',
23	],
24	['OR',
25	'available_to >= :time',
26	'available_to IS NULL',
27	],
28	], [
29	':time' => date('Y-m-d H:i:s'),
30	]
31	);
32	return $this;
33	}
34
35	protected $subQuery;
36	protected $foreignColumn;
37	protected function userSelector($user_id)
38	{
39	return ['user_id' => $user_id];
40	}
41
42	/**
43	* Select only available surveys for user
44	*/
45	public function availableForUser($user_id)
46	{
47	$this->subQuery->select([$this->foreignColumn]);
48	$this->subQuery->andWhere($this->userSelector($user_id));
49	if(!$this->subQueryJoined)
50	{
51	$class = $this->modelClass;
52	$tableName = $class::tableName();
53	$this->andWhere(['NOT IN', $tableName . '.[[id]]', $this->subQuery]);
54	$this->subQueryJoined = true;
55	}
56	return $this;
57	}
58	}