计算有多少付款是通过现金交付，贝宝，payu等.

Question

我想从订单表中计算现金交付、贝宝、payu、ccavenue的总数。

订单表中有payment_method列。在该栏中有多种付款选项。

我想数一下有多少付款通过现金交付，贝宝，payu等…（同时使用yii框架）。

        $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