Yii cgridview using dynamic active record model

Question

I'm using the Yii-dynamic-active-record model class to get and put data to various database tables. Now I'd like to use cgridview to quickly build some views of this data, but I'm getting hung-up on writing a search function for this class.

I know that I could always do a foreach loop within the view and make my own html table, but if I could get the Yii way working that would be great for DRY.

*All the db tables have a ID column and this is the only column that really needs to be displayed... if you could get all the columns that would just be bonus points.

Thanks :)

Model

public function search()
{
    $criteria=new CDbCriteria;
    $criteria->compare('ID',$this->ID);

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

View

$this->widget('zii.widgets.grid.CGridView', array(
'id'=>'entry-grid',
'dataProvider'=>$model->search(),
'filter'=>$model,
'columns'=>array(
    'ID',
),
));

Controller

$tablename=$_GET['tname'];
$table=Entry::forTable($tablename);
$model=$table->findAll();
if(isset($_GET['Entry']))
    $model->attributes=$_GET['Entry'];

$this->render('all',array(
    'model'=>$model,
));

Answer 1

I am a little confused by what you have done here, however I think I have a solution. First off, in line 3 of your controller code, you call $model = $table->findAll(); this is likely not what you intended, as it will provide you with an ActiveRecord[]. What you want to do is to pass your $table into the gridview. So your controller code would look like this:

$tablename=$_GET['tname'];
$model=Entry::forTable($tablename);
if(isset($_GET['Entry']))
    $model->attributes=$_GET['Entry'];

$this->render('all',array(
    'model'=>$model,
));

you then need to pass in the table name to the CActiveDataProvider in your model:

public function search()
{
    $criteria=new CDbCriteria;
    $criteria->compare('ID',$this->ID);

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

now for the "yucky" part, you need to edit the static model method of CActiveRecord to this:

if(isset(self::$_models[$className]))
return self::$_models[$className];
else
{
   if(class_exists($className)){
      $model=self::$_models[$className]=new $className(null);
      $model->_md=new CActiveRecordMetaData($model);
      $model->attachBehaviors($model->behaviors());
   }
   else{
      $model = Entry::forTable($className);
    }
    return $model;
}

This tells it to load from the Entry table when a class of that name does not exist. This practice is discouraged, however its the only way I see of getting around your issue.