<?php

class CategoriasVariables extends CActiveRecord
{
    public function tableName()
    {
        return 'contable.categorias_variables';
    }

    public function rules()
    {
        return array(
            array('id_categoria, id_variable, id_usuario', 'numerical', 'integerOnly' => true),
            array('blnborrado', 'boolean'),
            array('id_categoria, id_variable, id_usuario, blnborrado', 'safe', 'on' => 'search'),
        );
    }

    public function relations()
    {
        return array(
        );
    }

    public function attributeLabels()
    {
        return array(
        );
    }

    public function search()
    {
        $criteria = new CDbCriteria;

        return new CActiveDataProvider($this, array(
            'criteria' => $criteria,
        ));
    }

    public static function model($className = __class__)
    {
        return parent::model($className);
    }

    public static function checkVariable($idCategoria, $idVariable)
    {
        return Yii::app()->getDb()->createCommand('
            SELECT exists
                (SELECT 1
                FROM contable.categorias_variables
                WHERE id_categoria=:categoria
                        AND id_variable=:variable
                        AND blnborrado is false) AS res
        ')->bindValues([
            'categoria' => $idCategoria,
            'variable' => $idVariable
        ])->queryRow()['res'];
    }
}