我有两个表,表名和字段列在下面
company(tbl_id,sales_id,user_id,assigned_on)
users(user_id,user_name)
我想执行以下查询
SELECT assigned_on,u.user_name FROM company c LEFT JOIN users u ON c.user_id=u.user_id WHERE c.`sales_id`=2
我有一个模型Company.php,我定义了以下关系
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(
'company'=>array(self::HAS_MANY,'Users',array('user_id'=>'user_id'))
);
}
,在相应的函数中我写了代码
$criteria=new CDbCriteria;
$criteria->select = "user_id,assigned_on";
$criteria->compare('t.sales_id',$salePersonID);
$criteria->with=array(
'company'
);
$criteria->together = true;
$provider = new CActiveDataProvider($this, array(
'criteria'=>$criteria,
'pagination'=>array('pageSize'=>'25')
));
return $provider;
我将提供程序传递给视图。在视图文件中,我编写了以下代码
<?php $this->widget('bootstrap.widgets.TbGridView',array(
'type'=>'striped bordered condensed',
'id'=>'users-grid',
'dataProvider'=>$provider,
'template'=>"<table style='width: 100%'><tr><td>{pager}</td><td style='vertical-align:bottom;text-align: right;'>{summary}</td></table>'n{items}'n{pager}",
'columns'=>array(
array(
'name'=>'assigned_on',
'header'=>'Assigned On',
'htmlOptions'=>array('class'=>'cname'),
),
array(
'name'=>'user_name',
'value'=>'$data->company->user_name',
'header'=>'Contact Person',
'htmlOptions'=>array('class'=>'cname'),
)
)
));
但是第二个表的字段(user_name)的值没有显示在清单中。我搜索了很多,尝试了很多选择。有人能告诉我这个问题的解决方法吗提前感谢
'value'=>'$data->company->user_name'
,
'value'=>'$data->company->user->user_name',
company没有user_name。