php - 计算有多少笔付款是通过 cashondelivery、paypal、payu 等方式进行的？

Question

我想从订单表中统计 cashondelivery、paypal、payu、ccavenue 的总数。

订单表中有 payment_method 列。该栏中有多种付款方式。

我想计算有多少笔付款是通过 cashondelivery、paypal、payu 等......(使用 yii framwork 时)。

        $list = Order::model()->findAll(payment_method=cashondelivery);
        var_dump($list);
            exit;

我怎样才能做到这一点，以便我的输出如下

cashondelivery = 50
paypal =         25
payu =           35 

Answer 1

试试这个:

$CodCount = Order::model()->countByAttributes(array(
                'payment_method'=>'cashondelivery'
));
echo $CodCount; //returns number of cashondelivery
....//similarly for other payment types

或者，

$CodCount = Order::model()->count("payment_method=:val", array("val" => "cashondelivery"));
echo $CodCount; //returns number of cashondelivery
....//similarly for other payment types

或者，

$dbCommand = Yii::app()->db->createCommand("
               SELECT payment_method,COUNT(*) as tot FROM `order` GROUP BY `payment_method`
            ");
$data = $dbCommand->queryAll();

foreach($data AS $val) {
        echo "Payment Method: ".$val["payment_method"]." total: ".$val["tot"]."<br/>";
    }

输出:

Payment Mode: cashondelivery total: 50
Payment Mode: paypal total: 25
Payment Mode: payu total: 35