HavePermission($Permission)) {
exit;
}
$startDate = array_key_exists("startDate", $_POST) ? $_POST["startDate"] : \CommFunc\CalcToStrDateTime("-7 days", "Y-m-d");
$endDate = array_key_exists("endDate", $_POST) ? $_POST["endDate"] : date("Y-m-d");
// 只显示成功的订单； 1-成功；2-失败
$match = array("Channel" => $spid, "State" => 1, "PayTime" => array('$gte' => $startDate . " 00:00:00", '$lte' => $endDate . " 23:59:59"));
$ret = \DBOper\Aggregate("PayOrder", array(
array(
'$match' => $match,
),
array(
'$group' => array(
'_id' => array('AccountID' => '$AccountID'),
'total' => array('$sum' => '$OrderAmount'),
),
),
), $retInfo);
$payCount = 0;
$payTotal = 0;
$payUserCount = 0;
$ARPPU = 0;
if (isset($retInfo)) {
$payUserCount = count($retInfo);
foreach ($retInfo as $info) {
$payTotal += floatval($info["total"]);
}
if ($payTotal > 0 && $payUserCount > 0) {
$ARPPU = round($payTotal / $payUserCount, 2);
}
}
$payCount = \DBOper\Count("PayOrder", $match);
?>
<?php echo \Lang\gettext("充值总览"); ?>
";
echo "| " . \Lang\gettext("充值总额") . " | " . $payTotal . " |
";
echo "| " . \Lang\gettext("充值人数") . " | " . $payUserCount . " |
";
echo "| " . "" . \Lang\gettext("ARPPU") . ""
. " | " . "" . $ARPPU . " |
";
echo "| " . \Lang\gettext("充值条数") . " | " . $payCount . " |
";
echo "";
?>