Layui实现带查询条件的分页

更新时间：2020-09-06 01:18:01 作者：startmvc

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

本文实例为大家分享了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')}" 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:;" title="编辑">编辑</a>';
 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:;" title="删除">删除</a>';
 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:;" title="编辑">编辑</a>';
 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:;" title="删除">删除</a>';
 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标签