php – Yii框架：使用相关Active Record模型中的数据进行搜索

以下是我的两张桌子.订单和用户

我有订单/管理页面,默认生成的代码只提供搜索订单表数据.我想在搜索条件中关联用户表名称字段.

这是搜索页面的初始外观.

我想将从其他表中提交的用户名集成到此搜索中.然后最后的样子将如下.

所以这些是我做的步骤.

首先在订单模型中,我有以下关系

public function relations()
        {
            // NOTE: you may need to adjust the relation name and the related
            // class name for the relations automatically generated below.
            return array(

                'user' => array(self::BELONGS_TO,);
        }
This is generated by Yii framework,i did nothing :)

Then,i changed the search method as follows

public function search()
    {
        // Warning: Please modify the following code to remove attributes that
        // should not be searched.

        $criteria=new CDbCriteria;


        $criteria->compare('t.order_create_date',true);
        $criteria->compare('t.price',true);
        $criteria->compare('t.bank_account_number',true);
        $criteria->compare('t.hardwaredetail_Id',$this->hardwaredetail_Id);
        //$criteria->compare('user_id',$this->user_id);

        $criteria->compare('t.order_update_date',true);
        $criteria->compare('t.is_received',$this->is_received);
        $criteria->compare('t.order_received_date',true);
        $criteria->compare('t.is_notify_by_email',$this->is_notify_by_email);
        $criteria->compare('t.warehouse_offered_price',true);
        $criteria->compare('t.warehouse_offered_price_date',true);
        $criteria->compare('t.orderstatus_id',$this->orderstatus_id);
        $criteria->together = true; 
        $criteria->compare('t.id',$this->id,true);
        $criteria->with = array('user');
        $criteria->compare('name',true,"OR");
        return new CActiveDataProvider($this,));
    }

如果您的Order表主键字段(如果两者都具有保存名称),则将t放在t前面是很重要的.在我的情况下它是id和id,所以我不得不把t.

其他的是元素的顺序

$criterial-> togeter = true;应该出现在关系元素之前.

然后你更新到Order表中的规则方法.我添加了用户归档和名称归档到安全属性.

public function rules()
    {
        // NOTE: you should only define rules for those attributes that
        // will receive user inputs.
        return array(
            //array(' orderstatus_id','required'),array('hardwaredetail_Id,user_id,is_received,is_notify_by_email,orderstatus_id','numerical','integerOnly'=>true),array('price,warehouse_offered_price','length','max'=>10),array('bank_account_number','max'=>100),array('order_create_date,order_update_date,order_received_date,warehouse_offered_price_date,user,name','safe'),// The following rule is used by search().
            // Please remove those attributes that should not be searched.
            array('id,order_create_date,price,bank_account_number,hardwaredetail_Id,warehouse_offered_price,'safe','on'=>'search'),);
    }

最后更新您的UI代码.

<?php $this->widget('zii.widgets.grid.CGridView','filter'=>$model,'value'=>'$data->user->name'
        )
)); ?>

我更新了订单管理员

array(
                'name'=>'user','value'=>'$data->user->name'
            )

这就是我所做的,它对我有用.问你是否需要帮助.感谢每个人都在关注这个问题.