php - 我想从客户表中获取名字

Question

我想从客户表中获取名字。在我的数据库中有 2 个表，第一个是 Customerlifecycle，有 1 个列名是 customer_id，第二个表是 customer，有 2 个列，第一个是 id，第二个是名字。

 $criteria = new CDbCriteria;
            $criteria->join = 'LEFT OUTER JOIN customer AS C ON C.id = t.customer_id AND C.store_id=' . Yii::app()->session['store_id'];
            $criteria->select = 'C.firstname as firstname';
            $criteria->group = 'C.firstname';
            $criteria->condition = 'store_id=\'' . Yii::app()->session['store_id'] . '\'';

            $list = CustomerLifecycle::model()->findAll($criteria);

我无法获取名字请帮助我

Answer 1

请尝试下面的代码

        $criteria            = new CDbCriteria;
        $criteria->select    = 'C.firstname as customer_id';
        $criteria->condition = 't.store_id= '. Yii::app()->session['store_id'];
        $criteria->join      = 'LEFT OUTER JOIN customer AS C ON C.id = t.customer_id';
        $criteria->group     = 'C.firstname';
        $list                = CustomerLifecycle::model()->findAll($criteria);