phalcon框架中的聚合

phalcon 框架 的分组 在参数中绑定

$conditions = array(

    'group' => "hotel_id"

);

而各种聚合运算都有相应的方法；

计总Count；

$conditions = array(

    'group' => "hotel_id"

);

$boxlist = HotleBox::count($conditions);

累加Sum

$array = array(

    "column" => "hotel_id",

);

$data = HotleBox::sum($array);

var_dump($data);

平均数Average

$array = array(

    "column" => "hotel_id",

);

$data = HotleBox::Average($array);

最小最大值minimum maxmum

$array = array(

    "column" => "hotel_id",

);

$data = HotleBox::minimum($array);

$array = array(

    "column" => "hotel_id",

);

$data = HotleBox::maximum($array);

var_dump($data);

本人新手，本文仅做笔记。如果有什么不对的地方请指正！