yunjing_master/app/admin/controller/VotesrecordController.php

<?php

/**
 * 收入记录
 */
namespace app\admin\controller;

use cmf\controller\AdminBaseController;
use think\facade\Db;

class VotesrecordController extends AdminbaseController {
    
    protected function getType($k=''){
        $type=array(
            '1'=>'邀请用户',
            '2'=>'每天观看规定时长视频奖励',
            '3'=>'收费视频收入',
            '4'=>'视频送礼物',
            '5'=>'直播间送礼物',
            '6'=>'开通守护',
            '7'=>'每观看60秒视频奖励',
        );
        if($k===''){
            return $type;
        }

        return isset($type[$k]) ? $type[$k] : '';
    }
    
    function index(){
        $data = $this->request->param();
        $map=[];
        
        $start_time=isset($data['start_time']) ? $data['start_time']: '';
        $end_time=isset($data['end_time']) ? $data['end_time']: '';
        
        if($start_time!=""){
           $map[]=['addtime','>=',strtotime($start_time)];
        }

        if($end_time!=""){
           $map[]=['addtime','<=',strtotime($end_time) + 60*60*24];
        }
        
        $type=isset($data['type']) ? $data['type']: '';
        if($type!=''){
            $map[]=['action','=',$type];
        }
        
        $uid=isset($data['uid']) ? $data['uid']: '';
        if($uid!=''){
            
            $map[]=['uid','=',$uid];
            
        }

        $touid=isset($data['touid']) ? $data['touid']: '';
        if($touid!=''){
            
            $map[]=['touid','=',$touid];
            
        }
        
        $lists = Db::name("votes_record")
            ->where($map)
			->order("addtime desc")
			->paginate(20);
        
        $lists->each(function($v,$k){
			$v['touserinfo']=getUserInfo($v['touid']);
            if($v['uid']){
                $v['userinfo']=getUserInfo($v['uid']);
            }else{
                $v['userinfo']=[];
            }
            
            return $v;           
        });
        
        $lists->appends($data);
        $page = $lists->render();

    	$this->assign('lists', $lists);

    	$this->assign("page", $page);

        $configpub=getConfigPub();
        $this->assign('name_votes',$configpub['name_votes']?$configpub['name_votes']:'');

        $this->assign('type',$this->getType());
    	
       
    	return $this->fetch();
    }
     
    
    function del(){
        $id = $this->request->param('id', 0, 'intval');

        if($id){
            $rs=DB::name('votes_record')->where("id={$id}")->delete();
            if(!$rs){
                $this->success("删除成功！");
            }
        }else{
            $this->error('数据传入失败！');
        }
                    
        							  			
    }

    function export(){
    
        $data = $this->request->param();
        $map=[];
        
        $start_time=isset($data['start_time']) ? $data['start_time']: '';
        $end_time=isset($data['end_time']) ? $data['end_time']: '';
        
        if($start_time!=""){
           $map[]=['addtime','>=',strtotime($start_time)];
        }

        if($end_time!=""){
           $map[]=['addtime','<=',strtotime($end_time) + 60*60*24];
        }
        
        $type=isset($data['type']) ? $data['type']: '';
        if($type!=''){
            $map[]=['type','=',$type];
        }
        
        $uid=isset($data['uid']) ? $data['uid']: '';
        if($uid!=''){
            
            $map[]=['uid','=',$uid];
            
        }

        $touid=isset($data['touids']) ? $data['touid']: '';
        if($touid!=''){
            
            $map[]=['touid','=',$touid];
            
        }

        $configpub=getConfigPub();
        $name_coin=$configpub['name_coin'];
        
        
        $xlsName  = "收入记录";

        $xlsData=Db::name("votes_record")
            ->where($map)
            ->order('id desc')
			->select()
            ->toArray();
        foreach ($xlsData as $k => $v){

            if($v['uid']){
                $userinfo=getUserInfo($v['uid']);
            }else{
                $userinfo=[];
            }
            
            $touserinfo=getUserInfo($v['touid']);

            $xlsData[$k]['touser_nickname']= $touserinfo['user_nickname']."(".$v['touid'].")";
            $xlsData[$k]['user_nickname']= !empty($userinfo)?$userinfo['user_nickname']."(".$v['uid'].")":"系统奖励";
            $xlsData[$k]['addtime']=date("Y-m-d H:i:s",$v['addtime']); 
            $xlsData[$k]['type']=$this->getType($v['action']);
            $xlsData[$k]['addtime']=date("Y-m-d H:i:s",$v['addtime']);
        }

        
        $cellName = array('A','B','C','D','E','F');
        $xlsCell  = array(
            array('id','序号'),
            array('type','收支行为'),
            array('touser_nickname','会员(ID)'),
            array('user_nickname','对方会员(ID)'),
            array('votes',$name_coin),
            array('addtime','时间'),
           
        );
        exportExcel($xlsName,$xlsCell,$xlsData,$cellName);
    }

}