yunjing_master/app/admin/controller/HotliveorderController.php

<?php

/**
 * 上热门订单列表
 */
namespace app\admin\controller;

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

class HotliveorderController extends AdminbaseController {
    

	protected function getStatus($k=''){
        $status=array(
            '-1'=>'未使用',
            '0'=>'使用中',
            '1'=>'已使用'
        );
        if($k===''){
            return $status;
        }

        return isset($status[$k]) ? $status[$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];
        }
        
        
        $uid=isset($data['uid']) ? $data['uid']: '';
        if($uid!=''){
            $map[]=['uid','=',$uid];
        }

        $status=isset($data['status']) ? $data['status']: '';
        if($status!=''){
            $map[]=['status','=',$status];
        }
        
        $lists = Db::name("hotlive_orders")
            ->where($map)
			->order("addtime desc")
			->paginate(20);
        
        $lists->each(function($v,$k){
			$v['userinfo']=getUserInfo($v['uid']);
            $v['addtime']=date("Y-m-d H:i:s",$v['addtime']);
            if($v['starttime']){
                $v['starttime']=date("Y-m-d H:i:s",$v['starttime']);
            }else{
                $v['starttime']="--";
            }

            if($v['endtime']){
                $v['endtime']=date("Y-m-d H:i:s",$v['endtime']);
            }else{
               $v['endtime']="--"; 
            }

            return $v;           
        });

        
        $lists->appends($data);
        $page = $lists->render();

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

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

        $configpub=getConfigPub();
        $this->assign('name_coin',$configpub['name_coin']?$configpub['name_coin']:'');
        $this->assign("status",$this->getStatus());
    	return $this->fetch();
    }
	
	
	
	//钻石消费记录
	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];
        }
        
        
        $uid=isset($data['uid']) ? $data['uid']: '';
        if($uid!=''){
            $map[]=['uid','=',$uid];
        }

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

        $xlsName  = "上热门订单记录";
		$lists = Db::name("hotlive_orders")
            ->where($map)
			->order("id desc")
			->select()
            ->toArray();
        
      
		foreach($lists as $k=>$v){
			$userinfo=getUserInfo($v['uid']);
            $v['user_nickname']=$userinfo['user_nickname']."(".$v['uid'].")";
            $v['addtime']=date("Y-m-d H:i:s",$v['addtime']);
            if($v['starttime']){
                $v['starttime']=date("Y-m-d H:i:s",$v['starttime']);
            }else{
                $v['starttime']="--";
            }

            if($v['endtime']){
                $v['endtime']=date("Y-m-d H:i:s",$v['endtime']);
            }else{
               $v['endtime']="--"; 
            }

            $v['status']=$this->getStatus($v['status']);
             
            $lists[$k]=$v;     

		}

        $configpub=getConfigPub();
        $name_coin=$configpub['name_coin'];

        $cellName = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N');
        $xlsCell  = array(
            array('id','序号'),
            array('user_nickname','会员 (ID)'),
            array('coin','花费'.$name_coin),
            array('exposure','预计曝光值'),
            array('real_exposure','实际曝光值'),
            array('user_min_num','预计最低人数'),
            array('user_max_num','预计最高人数'),
            array('real_user_num','实际总人数'),
            array('showid','直播标识'),
            array('starttime','直播开始时间'),
            array('endtime','直播结束时间'),
            array('addtime','订单生成时间'),
            array('back_coin','退回'.$name_coin),
            array('status','订单状态'),
        );
        exportExcel($xlsName,$xlsCell,$lists,$cellName);
    }
     


}