3回答

singwa

2017-04-26

代码贴下

0

0

菜鸟猴子

提问者

2017-04-27

比如这样的搜索  在一个页面的时候 是有的  如果有分页 在进入第二页的时候 就会变成这样 

0

0

菜鸟猴子

提问者

2017-04-27

这是控制器的代码

public function index(){
   $data = input('get.');
   $sdata = [];
   if(!empty($data['start_time']) && !empty($data['end_time']) &&
       strtotime($data['end_time'])>strtotime($data['start_time']) )
   {
       $sdata['create_time'] = [
           ['gt',strtotime($data['end_time'])],
           ['lt',strtotime($data['end_time'])],
       ];
   }
   if(!empty($data['category_id'])){
       $sdata['category_id'] = $data['category_id'];
   }
   if(!empty($data['city_id'])){
       $sdata['city_id'] = $data['city_id'];
   }
   if(!empty($data['name'])){
       $sdata['name']=['like','%'.$data['name'].'%'];
   }
   $deals = $this->obj->getNormalDeals($sdata);

   $categorys = model('Category')->getCategoryByParentId();
   //获取城市ID对应的名称
   $categoryArr = $cityArr =[];
   foreach($categorys as $v){
       $categoryArr[$v->id] = $v->name;
   }
   $citys = model('City')->getNormalCitys();

   //获取城市ID对应的名称
   foreach($citys as $v){
       $cityArr[$v->id] = $v->name;
   }
   return $this->fetch('',['categorys'=>$categorys,'citys'=>$citys,'deals'=>$deals,
    'category_id'=> empty($data['category_id']) ? '':$data['category_id'],
    'city_id'=> empty($data['city_id']) ? '':$data['city_id'],
    'name'=> empty($data['name']) ? '':$data['name'],
    'start_time'=> empty($data['start_time']) ? '':$data['start_time'],
    'end_time'=> empty($data['end_time']) ? '':$data['end_time'],
    'categoryArr'=>  $categoryArr,
    'cityArr' =>$cityArr,
   ]);
}

model代码：

class Deal extends BisModel{
   public function getNormalDeals($data=[]){
       $data['status'] = 1;
       $order = [
           'id'=>'desc',
       ];
       $result = $this->where($data)->order($order)->paginate(1);
       //echo $this->getLastSql();
       return $result;
   }
}

0

0