model relations 如何获取关联表的字段值和排序呢?
表 admin (id int, group_id int, name varchar[10])
表 group (id int, name varchar[10])
models/Admin.php
public function relations()
{
return array(
'group' => array(self::BELONGS_TO, 'Group', 'group_id', 'alias' => 'group', 'select' => 'group.name as group_name'),
);
}
models/Group.php
public function relations()
{
return array(
'admin' => array(self::HAS_MANY, 'Admin', 'id');
);
}
$rows = Admin::model()->with(‘group’)->findAll(array(‘order’ => ‘id asc’));
此时如何输出group的名称呢?? $row[‘group_name’] ?? 在Admin模型里找不到这个属性啊!
还有findAll时如何去按admin的id排序呢? order => t.id asc ??