我在Document模型中有一个名称为" author_id "的字段。我想通过advanced search搜索admin页面中的一些记录。但是，我希望author_id字段可以由文本值填充。我该怎么做呢?
这是Document模型:
public function rules()
{
return array(
array('title, content', 'required'),
array('author_id', 'numerical', 'integerOnly'=>true),
array('title, content, author_id', 'safe'),
array('title, content, author_id', 'safe', 'on'=>'search'),
);
}
public function relations()
{
return array(
'author' => array(self::BELONGS_TO, 'User', 'author_id'),
);
}
public function attributeLabels()
{
return array(
'id' => 'ID',
'title' => 'Title',
'content' => 'Content',
'author_id' => 'Author',
);
}
public function search()
{
$criteria=new CDbCriteria;
$criteria->compare('id',$this->id);
$criteria->compare('title',$this->pertanyaan,true);
$criteria->compare('content',$this->penanya_id, true);
$criteria->compare('author_id',$this->author_id);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
我认为这是_search.php。
<?php $form=$this->beginWidget('booster.widgets.TbActiveForm',array(
'action'=>Yii::app()->createUrl($this->route),
'method'=>'get',
)); ?>
<div class="box-body">
<div class="col-sm-6">
<?php echo $form->textFieldGroup($model,'title', array('widgetOptions'=>array('htmlOptions'=>array('class'=>'span8')))); ?>
<?php echo $form->textAreaGroup($model,'content', array('widgetOptions'=>array('htmlOptions'=>array('rows'=>6, 'cols'=>50, 'class'=>'span8')))); ?>
<?php echo $form->textFieldGroup($model,'author_id',array('widgetOptions'=>array('htmlOptions'=>array('class'=>'span5')))); ?>
</div>
</div>
<div class="box-footer clearfix no-border pull-right">
<?php $this->widget(
'bootstrap.widgets.TbButton',
array(
'encodeLabel'=>false,
'buttonType' => 'submit',
'label' => '<span class="glyphicon glyphicon-search"></span> Search Document!',
'context' => 'primary',
)
); ?>
<?php $this->widget(
'bootstrap.widgets.TbButton',
array('buttonType' => 'reset', 'label' => 'Reset')
); ?>
</div>
<div class="clearfix"></div>
<?php $this->endWidget(); ?>
谢谢你
在Document模型中，
为rules()的搜索条件添加author_name
public function rules()
{
return array(
...,
array('title, content, author_id,author_name', 'safe', 'on'=>'search'),
);
}
Search()函数，
public function search()
{
$criteria=new CDbCriteria;
$criteria->compare('id',$this->id);
$criteria->compare('title',$this->pertanyaan,true);
$criteria->compare('content',$this->penanya_id, true);
$criteria->compare('author_id',$this->author_id);
// Add search on author name
$criteria->with = array('author','author2');
$criteria->compare('auther_name',$this->author_id);
$criteria->compare('auther_name2',$this->author_id2);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}