如何在cakephp中使用聚合函数SUM？

我有这个查询，我想用数量的总和来排序。 我必须在paginate中使用此结果，请帮助我..

SELECT (SUM( OrderItem.quantity )) AS qty, `OrderItem`.`item_name` , 
`OrderItem`.`size` FROM `order_items` AS `OrderItem` WHERE 1 =1 
GROUP BY `OrderItem`.`item_name` , `OrderItem`.`size` 
ORDER BY (SUM( OrderItem.quantity )) DESC

我试过了下面的代码，但它不起作用

$this->paginate = array('fields'=>array('(SUM(OrderItem.quantity)) as qty',
                                        'OrderItem.item_name',
                                    'OrderItem.size'),
                        'group'=>array('OrderItem.item_name','OrderItem.size'),
                        'order' => array('(SUM(OrderItem.quantity))'=>'DESC'));

---

你可以使用“自定义查询分页¶”按照下面的链接：

http://book.cakephp.org/2.0/en/core-libraries/components/pagination.html#custom-query-pagination

在你的模型中使用它：

 public function paginate($conditions, $fields, $order, $limit, $page = 1, $recursive = null, $extra = array()) {
        $page--;
        $offset=$limit*$page;
        $result= $this->find('all',array('fields'=>array('(SUM(OrderItem.quantity)) as qty',
            'OrderItem.item_name',
            'OrderItem.size'),'group'=>array('OrderItem.item_name','OrderItem.size'),'order' => array('qty'=>'DESC'),'conditions'=>$conditions,'limit'=>$limit, 'offset'=>$offset));
       return $result;

    }

链接地址: http://www.djcxy.com/p/71179.html

上一篇: How to use aggregate function SUM in cakephp?

下一篇: Google Trends in R