public function searchCriteria($criteria = null) { $criteria = parent::searchCriteria($criteria); $criteria->compare('t.finv_sys_ccmp_id', Yii::app()->sysCompany->getActiveCompany()); /** * filter date to from */ if (!empty($this->finv_date_range)) { $criteria->AddCondition("t.finv_date >= '" . substr($this->finv_date_range, 0, 10) . "'"); $criteria->AddCondition("t.finv_date <= '" . substr($this->finv_date_range, -10) . "'"); } return $criteria; }