<?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();
    }
}