【Layui】带查询条件的分页
【摘要】
author：咔咔
wechat：fangkangfk
这个前端UI框架是真的让人又爱又恨呐！想了很久的方案才行的通
这是全部源码：
{include file="../../../application/admin/view/public/head" /} <div class="page-container p...
author：咔咔
wechat：fangkangfk
这个前端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.onload= 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标签
还有一个点就是在点击查询后，获取的数据是根据条件查的，在把分页初始化一次即可
其余的操作跟做跟做分页是一样的
文章来源: blog.csdn.net，作者：咔咔-，版权归原作者所有，如需转载，请联系作者。
原文链接：blog.csdn.net/fangkang7/article/details/85233164
【版权声明】本文为华为云社区用户转载文章，如果您发现本社区中有涉嫌抄袭的内容，欢迎发送邮件进行举报，并提供相关证据，一经查实，本社区将立刻删除涉嫌侵权内容，举报邮箱：
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论（0）