<center> <table > <tr> 水果名称<input type="text" name="f_name" class="f_name"> 水果分类 <select name="t_id" id="" class="t_id"> <option value="">请选择分类</option> {foreach name='type' item='vo'} <option value="{$vo.t_id}">{$vo.t_name}</option> {/foreach} </select> 上架状态 <select name="is_show" class="is_show"> <option value="">请选择上架状态</option> <option value="1">上架</option> <option value="0">未上架</option> </select> 活动状态 <select name="is_hot" class="is_hot"> <option value="">请选择活动状态</option> <option value="1">参与活动</option> <option value="0">未参与活动</option> </select> <input type="button" value="搜索" class="sou"> </tr> </table> </center> <table id="sample-table-1" class="table table-striped table-bordered table-hover"> <thead> <tr> <th class="center"> <label> <input type="checkbox" class="ace" /> <span class="lbl"></span> </label> </th> <th>商品编号</th> <th>商品名称</th> <th>商品图片</th> <th>所属分类</th> <th>水果重量</th> <th>水果库存</th> <th>已销售量</th> <th>产地</th> <th>销售价</th> <th>会员价</th> <th>是否上架</th> <th>是否参与活动</th> <th>操作</th> </tr> </thead> <tbody class="body"> {foreach name='data' item='v'} <tr> <td class="center"> <label> <input type="checkbox" class ='box' name="box" alt="{$v.f_id}"/> <span class="lbl"></span> </label> </td> <td>{$v.f_id}</td> <td>{$v.f_name}</td> <td><img src="<?php echo $v['f_img'];?>" alt="" width="50"></td> <td>{$v.t_name}</td> <td>{$v.f_weight}</td> <td>{$v.f_surplus}</td> <td>{$v.f_sale}</td> <td>{$v.f_place}</td> <td>{$v.m_price}</td> <td>{$v.v_price}</td> <td> {if condition="$v.is_show == 1"} 上架 {else /} 下架 {/if} </td> <td> {if condition="$v.is_hot== 1"} 参与活动 {else /} 不参与活动 {/if} </td> <td> <a href="{:url('index/Goods/modify')}?fid={$v.f_id}">编辑</a> <button class="del" alt="{$v.f_id}">删除</button> </td> </tr> {/foreach} </tbody> </table> <center> <table > <div><div class="pages">{$page}</div> <input type="button" class="quan" value="全选"> <input type="button" class="fan" value="反选"> <input type="button" class="pishan" value="批删"> <input type="text" class="pa" value="{$num}"></div> </table> </center> </div><!-- /.table-responsive --> </div><!-- /span --> </div><!-- /row --> <script src="js/jq.js"></script> <script> var obj= new Object(); $('.sou').click(function(){ obj['f_name']=$('.f_name').val(); obj['t_id']=$('.t_id').val(); obj['is_show']=$('.is_show').val(); obj['is_hot']=$('.is_hot').val();// alert(obj['t_id']); obj['id']=2 page(1); }) //分页 function page(p){ var html=''; $.each(obj,function(k,v){ html+=k+'='+v+'&'; }); var num=$('.pa').val(); var str=''; $.ajax({ type: "POST",// url: "index.php/index/goods/page", url: "{:url('index/Goods/page')}", data: html+"p="+p+"&num="+num, dataType:'json', success: function(msg){ $('.pages').html(msg.page); $('.pa').val(num); var is_show=''; var is_hot=''; $.each( msg.list, function(k, v){ if(v.is_show==1){ is_show='上架' }else { is_show='下架' } if(v.is_hot==1){ is_hot='参与活动' }else { is_hot='不参与活动' } str+='<tr><td class="center"><label><input type="checkbox" class ="box" name="box" alt="'+ v.f_id+'"/><span class="lbl"></span></label></td>'; str+='<td>'+v.f_id+'</td><td>'+v.f_name+'</td><td><img src="'+ v.f_img+'" alt="" width="50"></td><td>'+v.t_name+'</td><td>'+v.f_weight+'</td><td>'+v.f_surplus+'</td><td>'+v.f_sale+'</td><td>'+v.f_place+'</td><td>'+v.m_price+'</td><td>'+v.v_price+'</td>'; str+='<td>'+is_show+'</td><td>'+is_hot+'</td><td><a href="index.php/index/Goods/modify?fid='+v.f_id+'">编辑</a><button class="del" alt="'+v.f_id+'">删除</button></td></tr>';// str+='<tr><td>'+v.user_id+'</td><td>'+v.username+'</td><td>'+v.sex+'</td><td>'+v.age+'</td><td><'+v.lasttime+'</td></tr>'; }); $('.body').html(str); } }); } public function lists(){//商品关联分类查询 普通展示//$data = db('sg_fruits')//->join('sg_type', 'sg_fruits.t_id = sg_type.t_id')//->select();//$this->view->engine->layout(true);//$this->assign('data', $data);//return view('lists');//////分页展示//总条数$count=db('sg_fruits') ->join('sg_type','sg_fruits.t_id = sg_type.t_id')->count(); //默认当前页1//每页显示条数$p=1;$num=5;$limit=($p-1)*$num;$fruits=new Fruits();$page=$fruits->fen($count,$p,$num);$data=db('sg_fruits')->join('sg_type','sg_fruits.t_id = sg_type.t_id')->limit($limit,$num)->select();//查询分类$type= db('sg_type')->select();// 把分页数据赋值给模板变量list$this->view->engine->layout(true);$this->assign('data', $data);$this->assign('page', $page);$this->assign('type', $type);$this->assign('num', $num);// 渲染模板输出 return $this->fetch();}//分页2往后public function page(){if(isset($_POST['id'])){$arr=$_POST;//var_dump($arr);die;$where[]='1=1';if(!empty($arr['is_hot'])){$a = $arr['is_hot'];$where[]= 'is_hot ='."$a";}if(!empty($arr['is_show'])) {$b = $arr['is_show'];$where[] = 'is_show =' . "$b";}if(!empty($arr['t_id'])) {$d = $arr['t_id'];$where[] = 'sg_fruits.t_id ='."$d";}if(!empty($arr['f_name'])) {$c = $arr['f_name'];$where[] = 'f_namelike \'%' . "$c".'%\'';}$wh=implode(' AND ',$where);//echo $wh;die;$num=$_POST['num'];$p=$_POST['p'];$fruits=new Fruits();//总条数$count=db('sg_fruits')->join('sg_type','sg_fruits.t_id = sg_type.t_id')->where($wh)->count();$data['page']=$fruits->fen($count,$p,$num);$limit=($p-1)*$num;$data['list']=db('sg_fruits')->join('sg_type','sg_fruits.t_id = sg_type.t_id')->where($wh)->limit($limit,$num)->select();echo json_encode($data);}else{$num=$_POST['num'];$p=$_POST['p'];$fruits=new Fruits();//总条数$count=db('sg_fruits')->join('sg_type','sg_fruits.t_id = sg_type.t_id')->count();$data['page']=$fruits->fen($count,$p,$num);$limit=($p-1)*$num;$data['list']=db('sg_fruits')->join('sg_type','sg_fruits.t_id = sg_type.t_id')->limit($limit,$num)->select();echo json_encode($data);}
<?phpnamespace app\index\model;use think\Model;class Fruits{ public function fen($count,$p,$num) { //分页数据 $pageSum=ceil($count/$num);//总页数 $prevPage=$p-1>1?$p-1:1;//上一页 $nextPage=$p+1<$pageSum?$p+1:$pageSum;//下一页; $str=''; $str.='<a href="javascript:page(1)">首页</a>'; $str.='<a href="javascript:page('.$prevPage.')">上一页</a>'; $str.=$p.'/'.$pageSum; $str.='<a href="javascript:page('.$nextPage.')">下一页</a>'; $str.='<a href="javascript:page('.$pageSum.')">末页</a>'; return $str; }}?>
</script>
0 0
