yunjing_master/app/admin/controller/LiveshutController.php

<?php

/**
 * 禁言列表
 */
namespace app\admin\controller;
use cmf\controller\AdminBaseController;
use think\facade\Db;
use think\db\Query;

class LiveshutController extends AdminbaseController {
    function index(){

        $lists = Db::name('user_live_shut')
            ->where(function (Query $query) {
                $data = $this->request->param();

                $start_time=isset($data['start_time']) ? $data['start_time']: '';
                $end_time=isset($data['end_time']) ? $data['end_time']: '';
                
                if (!empty($start_time)) {
                    $query->where('addtime', '>=' , strtotime($start_time));
                }
                if (!empty($end_time)) {
                    $query->where('addtime', '<=' ,strtotime($end_time));
                }
                
                if (!empty($start_time) && !empty($end_time)) {
                    $query->where('addtime', 'between' , [strtotime($start_time),strtotime($end_time)]);
                }

                $keyword=isset($data['keyword']) ? $data['keyword']: '';
                
                if (!empty($keyword)) {
                    $query->where('uid|liveuid|actionid', 'like', "%$keyword%");
                }
            })
            ->order("addtime DESC")
            ->paginate(20);


        $lists->each(function($v,$k){
           $uidinfo=getUserInfo($v['uid']);
           $liveinfo=getUserInfo($v['liveuid']);
           $actioninfo=getUserInfo($v['actionid']);
           $v['uidinfo']= $uidinfo;
           $v['liveinfo']= $liveinfo;
           $v['actioninfo']= $actioninfo;
            
            return $v;
            
        });

        //分页-->筛选条件参数
        $data = $this->request->param();
        $lists->appends($data); 
            
        // 获取分页显示
        $page = $lists->render();
			
    	$this->assign('lists', $lists);
    	$this->assign("page", $page);
    	
    	return $this->fetch();
    }
		
	public function del(){

        $id=$this->request->param('id',0,'intval');
        if($id){
            $info=Db::name("user_live_shut")->where(["id"=>$id])->find();
            $result=Db::name("user_live_shut")->where(["id"=>$id])->delete();				
            if($result){
                hDel($info['liveuid'] . 'shutup',$info['uid']);
                $this->success('删除成功');
            }else{
                $this->error('删除失败');
            }			
        }else{				
            $this->error('数据传入失败！');
        }								  			
	}		


    
}