cakephp - Cakephp 中的连接和计数字段

Question

我试图在我的字段中查找计数并连接该计数，但它给出错误消息，因为找不到 make_count 并且我在上面创建了相同的字段。

$this->Car->virtualFields['make_count'] = 'COUNT(Car.car_make)';
$this->Car->virtualFields['make_concat']='CONCAT(Car.car_make,Car.make_count)';

$models = array_unique($this->Car->find('list',array(  
                'fields' => array('Car.car_make', 'Car.make_concat'),
                'conditions'=>array('Car.ad_status'=>'saved'),
                'order'=>array('Car.car_make'=>'Asc'),
                'contain'=>false,
                'group'=>array('Car.car_make')
            )
));

Answer 1

Try:
$this->Car->virtualFields['make_concat']='CONCAT(Car.car_make,COUNT(Car.car_make))';

$models = array_unique($this->Car->find('list',array(  
                'fields' => array('Car.car_make', 'Car.make_concat'),
                'conditions'=>array('Car.ad_status'=>'saved'),
                'order'=>array('Car.car_make'=>'Asc'),
                'contain'=>false,
                'group'=>array('Car.car_make')
            )
));