成年人的在线免费视频,婷婷91精品国产91久久综合,人妻精品人妻888,性感美女视频一区二区三区,国产熟女精品视频免费看,国内精品九九久久精品小草,中文字幕日韩精品欧美丝袜,午夜精品久久久久蜜桃毛片,91久久在线视频观看

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

<?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'];
}
?>