免费观看又色又爽又黄的忠诚|免费看黄a级毛片成人片|免费看三级片久久|免费鲁丝无码一级|免费全部黄A片免费播放|免费人成视频在线

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

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