ppypp伦理天堂,91手机在线视频,免费在线观看黄色毛片,夜夜穞天天穞狠狠穞AV美女按摩

聯系官方銷售客服

1835022288

028-61286886

投訴 分享 獲取本月的第一天和最后一天以及本月的消費收入待付款的總額 9 0
迅睿CMS版本:4.3.4

獲取本月的第一天和最后一天,以及本月的消費收入待付款的總額

<?php
$now = time();
//獲取類似2020-01-01和2020-01-31
        $month_audit_num = 0;
        $month_use_num = 0;
        $beginTime = strtotime(date('Y-m-d 00:00:00', mktime(0, 0, 0, date('m', $now), '1', date('Y', $now))));
        $endTime = strtotime(date('Y-m-d 23:39:59', mktime(0, 0, 0, date('m', $now), date('t', $now), date('Y', $now))));


$rt = \Phpcmf\Service::M()->db->table("member_paylog")->select('sum(value) as xiaofei')->where('value <', '0')->where('uid', $member.id)->where('inputtime >', $beginTime)->where('inputtime <', $endTime)->where('status',1)->get();

if ($rt) {
    $rows = $rt->getRowArray();
    $xiaofei = $rows['xiaofei']*-1;
}

$rts = \Phpcmf\Service::M()->db->table("member_paylog")->select('sum(value) as shouyi')->where('value >', '0')->where('uid', $member.id)->where('inputtime >', $beginTime)->where('inputtime <', $endTime)->where('status',1)->get();

if ($rts) {
    $rows = $rts->getRowArray();
    $shouyi = $rows['shouyi'];
}

$rtf = \Phpcmf\Service::M()->db->table("member_paylog")->select('sum(value) as shouyi')->where('value >', '0')->where('uid', $member.id)->where('inputtime >', $beginTime)->where('inputtime <', $endTime)->where('status',0)->get();

if ($rtf) {
    $rows = $rtf->getRowArray();
    $daifk = $rows['daifk'];
}
?>
解決方案