点击搜索跳转到当前页面并刷新table内容
如下图:当我们点击搜索时,跳转到当前页面并刷新table内容
可以这样来做:
<script>
$('.searchA').click(function () {
var product_name = $('.product_name').val()
var role_name = $('.role_name').val();
window.location.href="userlist"+"&product_name="+product_name+"&role_name="+role_name;
})
</script>
带上搜索时的参数即可。当跳转到后台后自动按条件去搜索内容,然后输出table中不一样的数据。
后台代码:
public function userList()
{
// print_r(request()->param());
$product_name = request()->param()['product_name']??'';
$role_name = request()->param()['role_name']??'';
$user_info = db('user')->alias('u')
->join('role r','u.role_id=r.id')
->field('u.id, u.name,u.phone,u.email,u.remarks,u.create_time,r.name as role_name')
->order('u.id aec');
if(!empty($product_name)){
$user_info = $user_info->where('u.name','like','%'.$product_name.'%');
}
if(!empty($role_name)){
$user_info = $user_info->where('u.role_id',$role_name);
}
$user_info = $user_info->where(['u.is_del'=>0])
->paginate(10);
$role_info = db('role')
->field('id, name')
->where(['is_del'=>0])
->select();
$this->assign('role_info', $role_info);
$this->assign('user_info', $user_info);
return view('user/userlist');
}
还没有评论,来说两句吧...