request->param(); $rechargeCountWhere = []; if($this->group != AdminConstants::ADMIN_GROUP_ID_CUSTOMER_SERVICE){ $rechargeCountWhere = [ 'dd' => '0' ]; } $where_condition = []; if(isset($params['rechargetype'])){ $rechargetype = implode(',', $params['rechargetype']); $where_condition['type'] = ['in', $rechargetype]; }else{ $rechargetype = ''; } if(!empty($params['createtime'])){ $createtime_arr = explode(' - ', $params['createtime']); $begin_time = strtotime($createtime_arr[0] . ' 00:00:00'); $end_time = strtotime($createtime_arr[1] . ' 23:59:59'); $where_condition['createtime'] = ['between', [$begin_time, $end_time]]; $this->assignconfig('begin_time', $createtime_arr[0]); $this->assignconfig('end_time', $createtime_arr[1]); }else{ $this->assignconfig('begin_time', ''); $this->assignconfig('end_time', ''); } $ids = $params['ids']; if ($this->request->isAjax()) { list($where, $sort, $order, $offset, $limit) = $this->buildparams(); $data = model('recharge')->setConnect($ids)->where(['user_id'=>$ids]) ->where($where_condition) ->where($rechargeCountWhere) ->order('createtime desc') ->limit($offset, $limit)->select(); $total = model('recharge')->setConnect($ids)->where(['user_id'=>$ids]) ->where($where_condition) ->where($rechargeCountWhere) ->order('createtime desc')->count(); foreach ($data as $key => $item) { $createtime_date = date('Y-m-d H:i:s', $item['createtime']); $createtime_time = $item['createtime']; $data[$key]['createtime'] = $createtime_date; $data[$key]['vip_createtime'] = '--'; $data[$key]['vip_endtime'] = '--'; if($item['type']=='1'){ if(empty($item['free_endtime'])){ $data[$key]['type'] = '看点充值'; }else{ $data[$key]['type'] = '赠送看点'; } }elseif(in_array($item['type'], ['2', '4'])){ if($item['type'] == '2'){ $data[$key]['type'] = 'VIP充值'; }else{ $data[$key]['type'] = '系统操作vip'; } $days = $item['day'] ?? 0; $hour = $item['hour'] ?? 0; if($this->group == AdminConstants::ADMIN_GROUP_ID_CUSTOMER_SERVICE){ $vip_starttime = $item['vip_starttime'] ?? strtotime($item['createtime']); }else{ $vip_starttime = $item['channel_vip_starttime'] ?? strtotime($item['createtime']); } $data[$key]['vip_createtime'] = date('Y-m-d H:i:s', $vip_starttime); $data[$key]['vip_endtime'] = date('Y-m-d H:i:s', strtotime("+{$days} days {$hour} hours", $vip_starttime)); }elseif($item['type']=='3'){ $data[$key]['type'] = '系统操作看点'; } elseif ($item['type']=='6') { $data[$key]['type'] = '赠币活动'; }else{ $data[$key]['type'] = '签到'; } } $result = array("total" => $total, "rows" => $data); return json($result); } $this->assignconfig('rechargetype', $rechargetype); $this->view->assign('rechargetype', $rechargetype); $this->view->assign('title', '充值记录'); $this->view->assign('type', 'userrechargecount'); return $this->view->fetch(); } }