<?php

class FormulaDetalle extends CActiveRecord
{
    public $descripcion;

    public function tableName()
    {
        return 'configuracion.formula_detalle';
    }

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

    public static function getAll($filtros)
    {
        return Yii::app()->getDb()->createCommand("
            SELECT fd.id,
                   fd.nombre,
                   coalesce(cast(fp.id_letra AS boolean), FALSE) AS checked
            FROM configuracion.formula_detalle fd
            LEFT JOIN (
                SELECT cast(json_array_elements_text(configuracion->:letra) AS INTEGER) AS id_letra
                FROM configuracion.formula_proceso
                WHERE id_formula=:formula AND id_proceso=:proceso
            ) AS fp ON fp.id_letra=fd.id
            WHERE fd.id_formula_global=:global AND blnborrado IS FALSE
            ORDER BY fd.id
        ")->bindValues($filtros)->queryAll();
    }
}