<?php

class Formulas extends CActiveRecord
{
    public function tableName()
    {
        return 'configuracion.formulas';
    }

    public function rules()
    {
        return [];
    }

    public function relations()
    {
        return [];
    }

    public function attributeLabels()
    {
        return [];
    }

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

    public static function obtenerFormula($id)
    {
        return self::model()->findByPk($id)->formula;
    }

    public static function formulaArray($id)
    {
        $formula = str_split(
            str_replace(['*', '-', '(', ')'], '', self::obtenerFormula($id))
        );
        return array_combine($formula, $formula);
    }

    public static function getAll()
    {
        return CHtml::listData(self::model()->findAll([
            'select' => 'id, concat(descripcion, \' - \', formula) as descripcion',
            'condition' => 'blnborrado is false'
        ]), 'id', 'descripcion');
    }
}