联系官方销售客服
QQ1835022299
028-61286886
分享经验
版主：论坛审计组
获取本月的第一天和最后一天以及本月的消费收入待付款的总额
获取本月的第一天和最后一天，以及本月的消费收入待付款的总额
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'];
}
?>
Booid.com
$rtf = \Phpcmf\Service::M()->db->table("member_paylog")->select('sum(value) as daifk')->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']; }$rt = \Phpcmf\Service::M()->db->table("member_paylog"); $rt->select('sum(value) as xiaofei'); $rt->where('value <', '0'); $rt->where('uid', $member.id); $rt->where('inputtime >', $beginTime); $rt->where('inputtime <', $endTime); $rt->where('status',1); $rt->get();