tp5项目后台比赛界面

//篮球比赛界面
    public function blist(){
        $list = db('list')->where('fid',0)->select();
        foreach ($list as $key => $val){
            $list[$key]['zlist'] = db('list')->where('fid',$val['id'])->select();
        }
        $this->assign('list',$list);
        //从数据库中查找导航列表父级元素及其子级元素
        $keywords = input('keywords');
        $blist = db('basgame')->where('team1','like',"%".$keywords."%")->whereOr('contest','like',"%".$keywords."%")
        ->whereOr('team2','like',"%".$keywords."%")->whereOr('state','like',"%".$keywords."%")->order('time')->paginate(5);
        $this->assign('blist',$blist);
        //根据查找条件查找并用时间给比赛分页排序,然后使用循环标签在view中打印
        return $this->fetch();
    }
视图
导航
    public function bajax(){
        $id = input('id');
        $arr = [];
        $a = db('basgame')->where('id',$id)->select();
        if($a) {
            $arr['code'] = 1;
            db('basgame')->where('id',$id)->delete();
            db('basguess')->where('gid',$id)->delete();
        }
        return $arr;
        //通过Ajax,将传过来的比赛id在数据库中查询,如果有结果,则在比赛和竞猜数据库中都删除掉该记录,再返回数组来确定是否删除成功
    }
列表
<div class="layui-body">
            <div class="layui-content">
                <div class="layui-row">
                    <div class="layui-card">
                        <div class="layui-card-body">
                            <div class="form-box">
                                <div class="layui-form layui-form-item">
                                  <form action="" method="get">
                                    <div class="layui-inline">
                                        <div class="layui-form-mid">比赛:</div>
                                        <div class="layui-input-inline" style="width: 100px;">
                                          <input type="text" autocomplete="off" class="layui-input" name="keywords">
                                        </div>
                                        <button class="layui-btn layui-btn-blue">查询</button>
                                        <button class="layui-btn layui-btn-primary">重置</button>
                                    </div>
                                  </form>  
                                </div>
                                <button class="layui-btn layui-btn-blue"><i class="layui-icon"><a href="{:url('add/addbasgame')}">新增</a></button>
                                <table class="layui-table">
                                  <thead>
                                    <tr>
                                      <th>队伍一</th>
                                      <th>赛事</th>
                                      <th>时间</th>
                                      <th>队伍二</th>
                                      <th>状态</th>
                                      <th>操作</th>
                                    </tr>
                                  </thead>
                                  <tbody>
                                    {volist name="blist" id="vo"}
                                      <tr>
                                        <td>
                                          <img src="{$vo.img1}" alt="">
                                          {$vo.team1}
                                        </td>
                                        <td>
                                          {$vo.contest}
                                        </td>
                                        <td>
                                          {$vo.time}
                                        </td>
                                        <td>
                                          <img src="{$vo.img2}" alt="">
                                          {$vo.team2}
                                        </td>
                                        <td>
                                          {$vo.state}
                                        </td>
                                        <td>
                                          <a class="layui-btn" href="{:url('admin/edit/editbasgame',['id'=>$vo.id])}">编辑比赛</a>
                                          <a class="layui-btn layui-btn-normal" href="{:url('admin/add/addbasguess',['id'=>$vo.id])}">编辑竞猜</a>
                                          <button class="del layui-btn layui-btn-danger" data-id="{$vo.id}">删除</button>
                                        </td>
                                      </tr>
                                    {/volist}
                                  </tbody>
                                </table> 
                                {$blist->render()}
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
 
posted @ 2020-08-13 14:36  HighKK  阅读(206)  评论(0编辑  收藏  举报