TemplateLocation.php
1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<?php
namespace app\models;
class TemplateLocation extends \yii\db\ActiveRecord
{
public static function tableName()
{
return 'template_location';
}
public function findFreeLocationForBanner ($template_location_id = false)
{
return TemplateLocation::find()
->where('
template_location_id NOT IN
(
SELECT template_location_id
FROM banner
'.($template_location_id ? 'WHERE template_location_id != '.$template_location_id : '').'
)
AND is_banner = 1
')
->all();
}
public function findFreeLocationForSlider ()
{
return TemplateLocation::find()
->where('
template_location_id NOT IN
(
SELECT template_location_id
FROM slider
)
AND is_slider = 1
')
->all();
}
}