screen/application/admin/controller/Finance.php

<?php

namespace app\admin\controller;

use app\admin\model\AdminMoneyLog;
use app\admin\model\Refund;
use app\common\controller\Backend;

/**
 * 资讯管理
 *
 * @icon fa fa-info
 */
class Finance extends Backend
{
    public function amount_statistics(){
        list($time,$timeArr)=$this->rangeTime();
        $this->assign('time',$time);
        $payed=\app\admin\model\Orders::payed()
            ->whereBetween('create_time',$timeArr)
            ->sum('amount_pay');
        $refund=Refund::filterRefund()->whereBetween('create_time',$timeArr)
            ->sum('amount');
        $this->assign('sellAmount',bcsub($payed,$refund));
        $this->assign('payAmount',$payed);
        $this->assign('refundAmount',$refund);
        $commissionAmount=AdminMoneyLog::whereBetween('create_time',$timeArr)->filterTypeCommission()->sum('amount');
        $this->assign('commissionAmount',$commissionAmount);
        return $this->fetch();
    }
}