首页 > 开发 > JS > 正文

Layui实现带查询条件的分页

2024-05-06 16:53:42
字体:
来源:转载
供稿:网友

本文实例为大家分享了Layui实现带查询条件的分页,供大家参考,具体内容如下

这个前端UI框架是真的让人又爱又恨呐!想了很久的方案才行的通

这是全部源码:

{include file="../../../application/admin/view/public/head" /} <div class="page-container p10">   <form class="layui-form " method="post" id="pageListForm">    <div class="layui-input-inline w150">      <div class="layui-btn-group">        <a data-full="1" data-href="{:url('addBanner')}" rel="external nofollow" class="layui-btn layui-btn-primary j-iframe"><i class="layui-icon"></i>添加广告</a>      </div>     </div>     <div class="layui-input-inline w150">      <select name="vt_id" class="vt_id">        <option value="">视频类型</option>        {foreach name='subject' item='v'}        <option value="{$v['vt_id']}" >{$v['vt_name']}</option>        {/foreach}      </select>    </div>      <div class="layui-input-inline w150">      <select name="b_targetType" class="b_targetType">        <option value="">是否跳出</option>        <option value="1">是</option>        <option value="2">否</option>      </select>    </div>    <div class="layui-input-inline">      <input type="text" autocomplete="off" placeholder="请输入搜索条件" id="content" class="layui-input" name="b_title" value="">    </div>     <a class="layui-btn mgl-20 .j-kaka" id="query"> 查询</a>      <table class="layui-table" lay-size="sm">    <thead>      <tr >        <th width="25">ID</th>        <th width="50">分类</th>        <th width="100">对应视频</th>        <th width="40">缩略图</th>        <th width="80">点击url</th>        <th width="30">排序</th>        <th width="100">展示类型</th>        <th width="100">是否跳出2是1否</th>        <th width="100">标题</th>        <th width="100">内容页模版</th>        <th width="100">链接列表</th>        <th width="130">操作</th>      </tr>    </thead>      <tbody id="tab_list">       </tbody>    </table>  </form></div> <div id="pages" class="center"></div> {include file="../../../application/admin/view/public/foot" /} <script type="text/javascript">   window.οnlοad= function () {    loadData() //请求数据    getPage()   //分页操作  }  var page=1; //设置首页页码  var limit=3; //设置一页显示的条数  var total;  //总条数  function loadData(){    $.ajax({      type:"post",      url:"{url(Banner/index)}",//对应controller的URL      async:false,      dataType: 'json',      data:{        "page_index":page,        "page_size":limit,      },      success:function(ret){        total=ret.total_count;         var data1=ret.data;        var html= '';        for(var i=0;i<data1.length;i++){          html+='<tr>';          html+='<td>'+ data1[i].b_id +'</td>';          html+='<td>'+ data1[i].b_id +'</td>';          html+='<td>'+ data1[i]['banner_vs_video_name']['vi_title'] +'</td>';          html+='<td>'+ data1[i]['b_thumbnailUrl'] +'</td>';          html+='<td>'+ data1[i]['b_linkUrl'] +'</td>';          html+='<td>'+ data1[i]['b_sort'] +'</td>';          html+='<td>'+ data1[i]['b_showType'] +'</td>';          html+='<td>'+ data1[i]['b_targetType'] +'</td>';          html+='<td>'+ data1[i]['b_title'] +'</td>';          html+='<td>'+ data1[i]['b_slaveTitle'] +'</td>';          html+='<td>'+ data1[i]['b_linkUrlList']+'</td>';          html+='<td>';          html+='<a class="layui-badge-rim j-iframe" data-full="1" data-href='+ROOT_PATH+'/index.php/admin/banner/editBanner?b_id='+data1[i]['b_id']+' href="javascript:;" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow"          html+='<a class="layui-badge-rim j-tr-del del" data-href='+ROOT_PATH+'/index.php/admin/banner/delBanner?b_id='+data1[i]['b_id']+' href="javascript:;" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow"          html+='</td>';           html+='</tr>';        }        $("#tab_list").html(html);      }    });  }    // 查询  $('#query').click(function(){    var content = $('#content').val();    var vt_id = $('.vt_id').val();    var b_targetType = $('.b_targetType').val();     if(!content && !vt_id && !b_targetType){      layer.msg('查询条件不能为空');      return false    }     $.ajax({      type:"post",      url:"{url(Banner/index)}",//对应controller的URL      async:false,      dataType: 'json',      data:{        "page_index":page,        "page_size":limit,        "b_title":content,        "vt_id":vt_id,        "b_targetType":b_targetType      },      success:function(ret){        total=ret.total_count;        getPage();         var data1=ret.data;        var html= '';        for(var i=0;i<data1.length;i++){          html+='<tr>';          html+='<td>'+ data1[i].b_id +'</td>';          html+='<td>'+ data1[i].b_id +'</td>';          html+='<td>'+ data1[i]['banner_vs_video_name']['vi_title'] +'</td>';          html+='<td>'+ data1[i]['b_thumbnailUrl'] +'</td>';          html+='<td>'+ data1[i]['b_linkUrl'] +'</td>';          html+='<td>'+ data1[i]['b_sort'] +'</td>';          html+='<td>'+ data1[i]['b_showType'] +'</td>';          html+='<td>'+ data1[i]['b_targetType'] +'</td>';          html+='<td>'+ data1[i]['b_title'] +'</td>';          html+='<td>'+ data1[i]['b_slaveTitle'] +'</td>';          html+='<td>'+ data1[i]['b_linkUrlList']+'</td>';          html+='<td>';          html+='<a class="layui-badge-rim j-iframe" data-full="1" data-href='+ROOT_PATH+'/index.php/admin/banner/editBanner?b_id='+data1[i]['b_id']+' href="javascript:;" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow"          html+='<a class="layui-badge-rim j-tr-del del" data-href='+ROOT_PATH+'/index.php/admin/banner/delBanner?b_id='+data1[i]['b_id']+' href="javascript:;" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow"          html+='</td>';           html+='</tr>';        }        $("#tab_list").html(html);      }    });  });    function getPage(){    layui.use('laypage', function(){      var laypage = layui.laypage        , layer = layui.layer;      laypage.render({        elem: 'pages'        ,count: total //数据总数,从服务端得到        ,limit:limit        ,jump: function(obj, first){          page=obj.curr; //改变当前页码          limit=obj.limit;          if(!first){            loadData()          }        }      });    });  }      // 点击删除  $(document).on('click','.del',function(){    var that = $(this),      href = !that.attr('data-href') ? that.attr('href') : that.attr('data-href');    layer.confirm('删除之后无法恢复,您确定要删除吗?', {title:false, closeBtn:0}, function(index){      if (!href) {        layer.msg('请设置data-href参数');        return false;      }      $.get(href, function(res){        layer.msg(res.msg);        if (res.code == 1) {          that.parents('tr').remove();        }      });      layer.close(index);    });    return false;  })    /**   * 更改数据顺序   */  layui.use('laypage', function(){    var laypage = layui.laypage      , layer = layui.layer,      $ = layui.$;     $(document).on('blur','.sort',function(){      var that = $(this),        b_sort = that.val();      var b_id = that.attr('b_id');       $.post("{:url('banner/editSort')}",{b_sort:b_sort,b_id:b_id},function(res){        if(res == 1){          loadData()        }      });    })  });    </script></body></html> 

这个业务只有一个问题那就是button,我们需要把button的标签换了,换成a标签

Layui,查询条件,分页

还有一个点就是在点击查询后,获取的数据是根据条件查的,在把分页初始化一次即可

Layui,查询条件,分页

其余的操作跟做跟做分页是一样的

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持VeVb武林网。


注:相关教程知识阅读请移步到JavaScript/Ajax教程频道。
发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表