$time_where = [];
if (empty($starttime) && !empty($endtime)) {
$time_where[] = ['time','<= time',$endtime];
}
if (!empty($starttime) && empty($endtime)) {
$time_where[] = ['time','>= time',$starttime];
}
if (!empty($starttime) && !empty($endtime)) {
if (strtotime($starttime) > strtotime($endtime)) {
$this->error('开始时间不能大于结束时间');
}
$time_where[] = ['time','between time',[$starttime,$endtime]];
}
dump($time_where);
// 分页并修改分页后的数据
$list = Db::table('usertable')->alias('p1')
->leftJoin('admins p2','p1.code=p2.code')
->where($where)
->where($user_where)
->field('p1.*,p2.username as admin_user')
->order('p1.uid','desc')
->paginate(15)->each(function($item, $key){
$zjmoney = db('ordertable')->where('uid',$item['uid'])->sum('zjmoney'); // 总中奖金额
$tzmoney = db('ordertable')->where('uid',$item['uid'])->sum('money'); // 总投注金额
$item['losses'] = bcsub($zjmoney,$tzmoney,2); // 总盈亏
// 充值与提现
dump($time_where);
$time_where[] = ['uid','=',$item['uid']];
$time_where[] = ['status','=',1];
dump($time_where);die;
$czjl = db('czjl')->where($time_where)->sum('money'); // 总充值金额
$txrecord = db('txrecord')->where($time_where)->sum('txmoney'); // 总提现金额
$item['czjl'] = $czjl;
$item['txrecord'] = $txrecord;
return $item;
});如上面代码 我要在循环内获取$time_where 应该怎么获取? 最佳答案
