如何从加入请求向模型添加属性(Yii1)


How to add attribute to model from join request (Yii1)?

我的代码是:

$criteria = new MyCDbCriteria;                
$criteria->select = 't.id, acc.server_account, t.registration_date, lac.login, t.summ, t.input, t.output, t.lot, t.options_sum, t.profit';
$criteria->join = 'join `accounts` acc on (t.account_id = acc.id) join `users` u on (acc.user_id = u.id) join `leads_and_clients` lac on (u.login = lac.login)';
$records = PartnersReport::model()->findAll($criteria);
foreach ($records as $record) {
    foreach ($record->attributes as $key => $val) {
        $return['values'][$record->id][$key] = $val;
    }
}

问题是:$record->attributes中没有像server_account这样的"联接"属性。如何添加?

创建一个属性PartnersReport::server_account并将其用作SELECT中的别名:

$criterias->select="t.id,acc.server_account AS server_account,t.registration_date,lac.login,t.summ,t.input,t.output,t.lot,t.options_sum,t.profit";