book_admin/application/admin/controller/auth/Userrechargecount.php

<?php

namespace app\admin\controller\auth;

use app\main\constants\AdminConstants;
use think\Log;

class Userrechargecount extends UserDetailBase
{
    public function _initialize()
    {
        parent::_initialize();
    }

    public function index()
    {
        $params = $this->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();
    }
}