登录
当前位置： 首页 > 工具软件 > ThinkPHP-5.1-Auth > 使用案例 >

Thinkphp5.1分页

童铭晨
2023-12-01 
controller:
public function show_question(Request $request){
    $userinfo = helper('Auth')->user();
    $user_group_id = $userinfo['user_group_id'];
    $user_id = $userinfo['id'];
    app('think\\Route')->setConfig(['default_ajax_return' => 'html']);
    $page = $request->param('page');
    $question = $request->param('question');

    $where = [];
    $lawyerid= $request->param('lawyerid');

    if($lawyerid){
        $where[] = ['B.userid','=',$lawyerid];
    }
    if($question){
        $where[] = ['B.question','LIKE','%'.trim($question).'%'];
    }
    if($user_group_id == 3 || $user_id = '410784'){
        $Rownum = Db::connect($this->_db_config)->table('fa_ai_question')->alias('B')
            ->leftJoin('test.zf_member C','B.userid = C.user_id')
            ->field('B.id,B.userid,B.question,C.nickname')
            ->where($where)
            ->group('B.id')
            ->order('B.id', 'desc')
            ->count();
    }else{
        $where[] = ['C.user_id','=',$user_id];
        $Rownum = Db::connect($this->_db_config)->table('fa_ai_question')->alias('B')
            ->leftJoin('test.zf_member C','B.userid = C.user_id')
            ->field('B.id,B.userid,B.question,C.nickname')
            ->where($where)
            ->group('B.id')
            ->order('B.id', 'desc')
            ->count();
    }
    $listRows = 30;
    $total = ceil($Rownum/$listRows);
    if($page<0){
        $page = 1;
    }
    if($page > $total){
        $page = 1;
    }
    if($user_group_id == 3 || $user_id = '410784'){
        $user = Db::connect($this->_db_config)->table('fa_ai_question')->alias('A')
            ->field('userid')
            ->group('userid')
            ->order('userid', 'ASC')
            ->select();
        foreach ($user as $k => $v){
            $arr[]['userid'] = $v['userid'];
        }
        $userid = array_column($arr,'userid','id');
    }else{
        $userid = $user_id;
    }
    $wheres[]  = ['userid','in', $userid];

    $cusarr = Db::connect($this->_db_config)->table('fa_ai_question B')
        ->leftJoin('test.zf_member C','B.userid = C.user_id')
        ->field('*')
        ->where($wheres)
        ->group('B.userid')
        ->select();
    $total = array();
    foreach ($cusarr as $key => $value){
        $total[ $value['userid']]['nickname'] = $value['nickname'];
        $sum = Db::connect($this->_db_config)->table('fa_ai_question')
            ->field('userid')
            ->where('userid','in', $value['userid'])
            ->count();
        $print_count = Db::connect($this->_db_config)->table('fa_ai_question')
            ->field('userid')
            ->where(['userid'=> $value['userid'],'tag_status'=>1])
            ->count();
        $total[ $value['userid']]['print_count'] = $print_count;
        $total[ $value['userid']]['count'] = $sum;
    }

    $this->assign("question", $question);
    $this->assign('Rownum',intval($Rownum));
    $this->assign("page", $page);
    $this->assign("total", $total);
    $this->assign("lawyerid", $lawyerid);
    $this->assign("aid", $aid);
    $this->assign("user_group_id", $user_group_id);
    $this->assign->addCss('lawyer/lists.css?t='.time());
    $this->assign->addJs('lawyer/report.js?t='.time(), true);
    $this->assign->addCss('ai/question.css?t='.time());
   // $this->fetch = true;
    return $this->fetch = "show_question";
}

.
view:
{extends file="…/manage_base.html"}
{block name=“head”}
< div id=“header” style=“float: left;width: 100%;”>
< div class=“wrap clearfix” id=“usernav”>
< div id=“Menu”>
< ul class=“list”>
< li >< a class=“javascript” rel=“login_box” href="">登录< /a>
< li>< a href="{url(‘lawyer/User/logout’)}">退出< /a>
< /ul>
< /div>
< /div>

< /div>
{/block}
{block name=“content”}
< body style=“width: 100%;height:1500px;background: white;overflow: auto”>
< div style=“float: left;overflow-y: auto;overflow-x: auto;height: 91%;”>
< div class=“aaa” style=“height: 140px;width:100%;float:left;background-color: white”>
< div style=“width: 80%;height: 100px;float: left”>
{foreach $total as i n f o i d = > info_id=> infoi​d=>infoList}
< ul style=“width: 80px;height:70px;float: left”>

  • {KaTeX parse error: Expected 'EOF', got '}' at position 21: …ist['nickname']}̲</li> …infoList[‘count’]}条

  • 已打{$infoList[‘print_count’]}条

  • < /ul>
    {/foreach}
    < /div> 

        <div style="width: 10%;height: 100px;float: left">
        <li style="float: right; width: 60px;padding: 30px 20px;"><a class="javascript" id="searchBtn" href="javascript://;" style="font-size: 20px; line-height: 20px;">搜索</a></li>

    </div>

</div>
<ul class="user-list-area user-list-nav-bg" style="text-align: center;">
    <ul class="user-list-content h90">
    <li class="col21">ID</li>
    <li class="col31">问题</li>
    <li class="col21">分配人</li>
    <li class="col21">状态</li>
    <li class="col21">时间</li>
     <li class="col21">时间</li>
    <li class="col21">时间</li>
    <li class="col21">时间</li>
    <li class="col21">时间</li>
    <li class="col21">时间</li>    
     <li class="col21">时间</li>     
     <li class="col21">时间</li>     
     <li class="col21">时间</li>    
      <li class="col21">时间</li>    
       <li class="col21">时间</li>
    </li>
</ul>

    {/block}

    public function show_get_question(Request $request){
    app('think\\Route')->setConfig(['default_ajax_return' => 'html']);
    $userinfo = helper('Auth')->user();
    $user_group_id = $userinfo['user_group_id'];
    $user_id = $userinfo['id'];
    $page = $request->param('page');

    $where = [];
    $lawyerid= $request->param('lawyerid');

    if($lawyerid){
        $where[] = ['B.userid','=',$lawyerid];
    }

    if($user_group_id == 3 || $user_id = '410784'){
        $Rownum = Db::connect($this->_db_config)->table('fa_ai_question')->alias('B')
            ->leftJoin('test.zf_member C','B.userid = C.user_id')
            ->field('B.id,B.userid,B.question,C.nickname')
            ->where($where)
            ->group('B.id')
            ->order('B.id', 'desc')
            ->count();
    }else{
        $where[] = ['C.user_id','=',$user_id];
        $Rownum = Db::connect($this->_db_config)->table('fa_ai_question')->alias('B')
            ->leftJoin('test.zf_member C','B.userid = C.user_id')
            ->field('B.id,B.userid,B.question,C.nickname')
            ->where($where)
            ->group('B.id')
            ->order('B.id', 'desc')
            ->count();
    }
    $listRows = 30;
    $total = ceil($Rownum/$listRows);

    if($page<0){
        $page = 1;
    }
    if($page > $total){
        $page = 1;
    }
    if($user_group_id == 3 || $user_id = '410784'){
        $user = Db::connect($this->_db_config)->table('fa_ai_question')->alias('A')
            ->field('userid')
            ->group('userid')
            ->order('userid', 'ASC')
            ->select();
        foreach ($user as $k => $v){
            $arr[]['userid'] = $v['userid'];
        }
        $userid = array_column($arr,'userid','id');
    }else{
        $userid = $user_id;
    }
    $wheres[]  = ['userid','in', $userid];

    $cusarr = Db::connect($this->_db_config)->table('fa_ai_question B')
        ->leftJoin('test.zf_member C','B.userid = C.user_id')
        ->field('*')
        ->where($wheres)
        ->group('B.userid')
        ->select();
    $total = array();
    foreach ($cusarr as $key => $value){
        $total[ $value['userid']]['nickname'] = $value['nickname'];
        $sum = Db::connect($this->_db_config)->table('fa_ai_question')
            ->field('userid')
            ->where('userid','in', $value['userid'])
            ->count();
        $print_count = Db::connect($this->_db_config)->table('fa_ai_question')
            ->field('userid')
            ->where(['userid'=> $value['userid'],'tag_status'=>1])
            ->count();
        $total[ $value['userid']]['print_count'] = $print_count;
        $total[ $value['userid']]['count'] = $sum;
    }
    if($page>=1){
        $question = Db::connect($this->_db_config)->table('fa_ai_question')->alias('B')
            ->leftJoin('test.zf_member C','B.userid = C.user_id')
            ->field('B.id,B.userid,B.question,C.nickname,B.tag_status,B.tag_status,B.sex,B.marriage,B.custody,B.assets,B.house_property,B.debt,B.id AS id')
            ->where($where)
            ->limit(($page - 1) * $listRows, $listRows)
            ->group('B.id')
            ->order('B.id', 'desc')
            ->select();
        foreach ($question as $key => $value){
            $res_max_id= Db::connect($this->_db_config)->table('fa_ai_tag')->alias('a')
                ->field('MAX(a.id) AS id ')
                ->leftJoin('fa_ai_question b','a.qid = b.id ' )
                ->where('a.qid','=',$value['id'])
                ->select();

            //获取最新的标签的时间
            $marktime= Db::connect($this->_db_config)->table('fa_ai_tag a')
                ->field('*')
                -> where('a.id','=',$res_max_id[0]['id'])
                ->order('a.id', 'desc')
                ->select();

            $question[$key]['createtime'] = $marktime[0]['createtime'];
            $id = $value['id'];
            $aid_res = Db::connect($this->_db_config)->table('fa_ai_tag')->field('aid')->where(['qid'=>$id])->group('aid')->select();
            foreach ($aid_res as $k => $v){
                if($v['aid'] == 2){
                    $aid[$id]['sex'] = '1';
                }
                if($v['aid'] == 1){
                    $aid[$id]['marriage'] = '1';
                }
                if($v['aid'] == 3){
                    $aid[$id]['custody'] = '1';
                }
                if($v['aid'] == 4){
                    $aid[$id]['assets'] = '1';
                }
                if($v['aid'] ==5){
                    $aid[$id]['house_property'] = '1';
                }
                if($v['aid'] == 6){
                    $aid[$id]['debt'] = '1';
                }
                if($v['aid'] == 7){
                    $aid[$id]['jurisdiction'] = '1'; 
                }
                if($v['aid'] == 8){
                    $aid[$id]['maintenance_Fee'] = '1'; 
                }
                if($v['aid'] == 9){
                    $aid[$id]['betrothal_gifts'] = '1';  
                }
            }
        }
    }else{
        if($page<=0){
            $page = 1;
        }
        $question = Db::connect($this->_db_config)->table('fa_ai_question')->alias('B')
            ->leftJoin('test.zf_member C','B.userid = C.user_id')
            ->field('B.id,B.userid,B.question,C.nickname,B.tag_status,B.tag_status,B.sex,B.marriage,B.custody,B.assets,B.house_property,B.debt,B.id AS id')
            ->where($where)
            ->limit(($page - 1) * $listRows, $listRows)
            ->group('B.id')
            ->order('B.id', 'desc')
            ->select();

        //获取最新标签的id,通过id查最新的时间
        foreach ($question as $key => $value){
            $res_max_id= Db::connect($this->_db_config)->table('fa_ai_tag')->alias('a')
                ->field('MAX(a.id) AS id ')
                ->leftJoin('fa_ai_question b','a.qid = b.id ' )
                ->where('a.qid','=',$value['id'])
                ->select();

            //获取最新的标签的时间
            $marktime= Db::connect($this->_db_config)->table('fa_ai_tag a')
                ->field('*')
                -> where('a.id','=',$res_max_id[0]['id'])
                ->order('a.id', 'desc')
                ->select();

            $question[$key]['createtime'] = $marktime[0]['createtime'];

            $id = $value['id'];
            $aid_res = Db::connect($this->_db_config)->table('fa_ai_tag')->field('aid')->where(['qid'=>$id])->group('aid')->select();
            foreach ($aid_res as $k => $v){
                if($v['aid'] == 2){
                    $aid[$id]['sex'] = '1';
                }
                if($v['aid'] == 1){
                    $aid[$id]['marriage'] = '1';
                }
                if($v['aid'] == 3){
                    $aid[$id]['custody'] = '1';
                }
                if($v['aid'] == 4){
                    $aid[$id]['assets'] = '1';
                }
                if($v['aid'] ==5){
                    $aid[$id]['house_property'] = '1';
                }
                if($v['aid'] == 6){
                    $aid[$id]['debt'] = '1';
                }
                if($v['aid'] == 7){
                    $aid[$id]['jurisdiction'] = '1';
                }
                if($v['aid'] == 8){
                    $aid[$id]['maintenance_Fee'] = '1'; 
                }
                if($v['aid'] == 9){
                    $aid[$id]['betrothal_gifts'] = '1';  
                }
            }
        }
    }

    $this->assign("question", $question);
    $this->assign("question", $question);
    $this->assign('Rownum',intval($Rownum));
    $this->assign("page", $page);
    $this->assign("total", $total);
    $this->assign("lawyerid", $lawyerid);
    $this->assign("aid", $aid);
    $this->assign("user_group_id", $user_group_id);
    $this->assign->addCss('lawyer/lists.css?t='.time());
    $this->assign->addJs('lawyer/report.js?t='.time(), true);
    $this->assign->addCss('ai/question.css?t='.time());
    return $this->fetch = true;

}
 类似资料：

相关阅读

ASP.NET 分页ThinkPHP 3.2 数据分页代码分享不区分ROW_NUMBER（）的SQL Server DISTINCT分页ajax实现分页和分页查询分页和细分之间的区别

相关文章

MyBatis分页按需分页分页技术分库分表：ShardingSphere主成分分析 PCA

相关问答

Laravel Livewire分页Spring靴分页ElasticSearch-聚合/分组依据：排序和分页html分区与分区API分页标准

相关文档

分布式 JavaStack Overflow 关于 Python 的部分高分问题Tendermint 源码分析Java 经验分享Memcached 源码分析
快捷导航： 新手教程 算法原理 架构设计 Java进阶 数据库进阶 大厂专栏 面试经验 编程笔记 编程问答 所有专题 文档资料 工具软件 电子书籍 小牛导航
在线工具： 房贷计算器 个税计算器 Linux命令查询 Json格式化 正则表达式 颜色转换 AES加解密 SHA1加密 MD5加密 毒鸡汤 字数统计 随机密码生成 进制转换 Base64编解码 励志句子
Copyright © 2019-2024 小牛知识库@xnip.cn. All Rights Reserved.