无效列错误-必须存在于表中，或者是别名为(Yii 1.x)的表达式

Question

在模型中，我有以下逻辑：

$criteria = new CDbCriteria();
$criteria->select = 'COALESCE(oca.reason, ocd.reason) AS reward_name, SUM(t.points) AS points, COUNT(t.redeemed_code_id) AS totalCount';
$criteria->join = 'LEFT JOIN organisation_classroom_deductions ocd ON ocd.deduction_id = t.order_product_id AND t.type = 1
                   LEFT JOIN organisation_classroom_achievements oca ON oca.achievement_id = t.order_product_id AND t.type = 2
                   LEFT JOIN myuser ON (myuser.user_id = t.myuser_id)';
$criteria->condition = 'myuser.organisation_id ='. user()->data->organisation->organisation_id;
$criteria->group = 't.order_product_id, t.type';

这有以下SQL查询-

SELECT COALESCE (oca.reason, ocd.reason) AS reward, SUM(t.points) AS points, COUNT(t.redeemed_code_id) AS totalCount
FROM
`organisation_classroom_redeemed_codes` `t`
  LEFT JOIN organisation_classroom_deductions ocd ON ocd.deduction_id = t.order_product_i AND t.type = 1 LEFT JOIN organisation_classroom_achievements oca ON oca.achievement_id = t.order_product_id AND t.type = 2 LEFT JOIN myuser ON (myuser.user_id = t.myuser_id)
  WHERE myuser.organisation_id = 37383
  GROUP BY t.order_product_id, t.type

当直接在数据库中运行时，此查询工作正常，并返回预期的数据。然而，问题是当我将条件逻辑运行到我的CAtiveDataProvider（）中时，我会得到错误。

    return new CActiveDataProvider($this, array(
        'criteria' => $criteria
    ));

有人能建议如何解决这个问题，使其与我的CActiveDataProvider协同工作吗？

Answer 1

如下指定您的选择：

$criteria->select = array(
    'COALESCE(oca.reason, ocd.reason) AS reward_name',
    'SUM(t.points) AS points',
    'COUNT(t.redeemed_code_id) AS totalCount'
);

您的代码失败的原因是，在CActiveFinder的第917行（至少在我使用的Yii 1.14中）使用以下逻辑来处理字符串选择语句：

if(is_string($select))
    $select=explode(',',$select);

如果表达式中有逗号，那么在select语句中的爆炸会失败得很惨。将所选内容格式化为数组，如上所示，以避免出现此问题。