tp5-搜索分页3级联动简化版
php
public function index()
{
$post=Request::instance()->request();
$post['set']=isset($post['set'])?$post['set']:'10';
$post['name']=isset($post['name'])?$post['name']:'';
$where=[];
if($post['name']!=''){
$where['a.name']=['like','%'.$post['name'].'%'];
}
if(isset($post['grade_id']) && ($post['grade_id']!='')){
$where['a.grade_id']=['=',$post['grade_id']];
}
if(isset($post['serie_id']) && ($post['serie_id']!='')){
$where['a.serie_id']=['=',$post['serie_id']];
}
if(isset($post['category_id']) && ($post['category_id']!='')){
$where['a.category_id']=['=',$post['category_id']];
}
$data=Db::table('cable_cc_type')->alias('a')
->join('cable_species_grades b','b.id = a.grade_id')
->join('cable_species_series c','c.id = a.serie_id')
->join('cable_species_category d','d.id = a.category_id')
->where('a.deleted_at','null')
->where($where)
->field('a.*,b.name names,c.name namess,d.name namesss')
->order('a.sort')
->paginate($post['set'],false,['query'=>$post]);
// var_dump($post);
//分类
$arr=Db::name('cc_category')->where('deleted_at','null')->field('name,id,sort')->order('sort')->select();
$this->assign('arr',$arr);
if(isset($post['category_id'])){
$list=Db::name('cc_series')->where('category_id',$post['category_id'])->where('deleted_at','null')->field('id,name,category_id,sort')->order('sort')->select();
$this->assign('list',$list);
}
//电压
if(isset($post['serie_id'])){
$ste=Db::name('cc_series')->where('id',$post['serie_id'])->value('grade_id');
$ste=explode(',',$ste);
$str='';
foreach($ste as $k=>$v){
$str[$k]=Db::name('cc_grades')->where('id',$v)->field('id,name')->find();
}
$this->assign('ste',$str);
}
$post=isset($post)?$post:'';
$page=$data->render();
$this->assign('data',$data);
$this->assign('page',$page);
$this->assign('post',$post);
return $this->fetch('model/quota_model');
}
html
<form action="/index/Model/index" method="post" class="form form-horizontal" id="form-system-config-add">
<select class="input-text" name="category_id" id="select1">
<option value="" selected="">请选择规格分类</option>
{foreach name="arr" id="ve"}
<option value="{$ve.id}"{if isset($post['category_id'])} {if condition="$post['category_id'] eq $ve['id']"}selected="selected"{/if}{/if}>{$ve.name}</option>
{/foreach}
</select>
<select class="input-text" name="serie_id" id="course">
<option value="" >请选择产品系列</option>
{if isset($post['serie_id'])}
{foreach name="list" id="vl"}
<option value="{$vl.id}" {if condition="$post['serie_id'] eq $vl['id']"}selected="selected"{/if} >{$vl.name}</option>
{/foreach}
{/if}
</select>
<select class="input-text" name="grade_id" id="grade">
<option value="" selected="">请选择电压等级</option>
{if isset($post['grade_id'])}
{foreach name="ste" id='vs'}
<option value="{$vs.id}" {if condition="$post['grade_id'] eq $vs['id']"}selected="selected"{/if} >{$vs.name}</option>
{/foreach}
{/if}
</select>
<input type="text" class="input-text" value="{$post.name}" placeholder="关键字" id="" name="name">
<input type="hidden" id="pc" name="set">
<button class="btn btn-success radius" ><i class="Hui-iconfont"></i> 查询</button>
<button type="reset" class="btn btn-success radius" id="" name="" onclick="cus_prog_add('添加产品型号','/index/Model/add')"> 新增</button>
<!-- <button type="reset" class="btn btn-success radius" id="" name=""> 导入</button>-->
<a href="/index/Model/indexs" class="btn btn-danger radius" id="" name="" style="float:right;"> 回收站</a>
</form>
js
$("#select1").change(function(){
console.log($(this).val());
var classid = $(this).val();
var html='<option value="">请选择/option>';
var html1='<option value="">请选择</option>';
var html2='<option value="">请选择</option>';
if(classid){
$.ajax({
url:"/indexs/Species/serise?id="+classid,
type:"get",
success:function(res){
console.log(res);
var data = res;
//alert(data);
console.log(data.length);
for(var i=0;i<data.length;i++){
html+='<option value="'+data[i].id+'">'+data[i].name+'</option>'
}
$("#course").html(html);
$("#grade").html(html1);
$("#course1").html(html2);
},
error:function(e){
console.log('请求失败');
}
})
}else{
$("#course").html(html);
$("#grade").html(html1);
$("#course1").html(html2);
}
})
$("#course").change(function(){
console.log($(this).val());
var classids = $(this).val();
var html='<option value="">请选择电压等级</option>';
if(classids){
$.ajax({
url:"/indexS/Species/grade?id="+classids,
type:"get",
success:function(res){
console.log(res);
var data = res;
//alert(data);
console.log(data.length);
for(var i=0;i<data.length;i++){
html+='<option value="'+data[i].id+'">'+data[i].name+'</option>'
}
$("#grade").html(html);
},
error:function(e){
console.log('请求失败');
}
})
}else{
$("#grade").html(html);
}
})
</script>
