后台模糊搜索+分页

public function index(){
//导入分页第三方文件
import('Org.Util.Page');

$where = array();
$find_after = array();
//关键字(模糊搜索)
$kwd = trim($_GET['kwd']);
if($kwd){
$lk_arr = array('ct_title','contract_id','task_id');
$like_arr = array();
foreach($lk_arr as $val){
      $like_arr[]=$val." like '%$kwd%'";
     }
$where[] = "(".implode(' or ', $like_arr).")";

$wh['username']=array('like',"%$kwd%");
$find_id = M('user')->field('sysid')->where($wh)->select();
foreach($find_id as $v){
$find_after[] = $v['sysid'];
}
if($find_id){
$lk_array = array('tk_uid','ds_uid');
foreach($lk_array as $val){
foreach($find_after as $v){
$like_arr[]=$val." like '%$v%'";
}
}
$where[0] = "(".implode(' or ', $like_arr).")";
}
}
// 排序
$_GET['sort'] = $sort = $_GET['sort']==2?2:1;
if($sort==1){
$order = 'time_create asc';
}else{
$order = 'time_create desc';
}

//分页
$page = new \Page(M('order_contract')->where($where)->count(),20);
$list = M('order_contract')
->limit($page->num_offset.','.$page->num_limit)
//->join(array('ds_order_contract'=>'order_contract'))
->field('...')
->where($where)
->order($order)
->select();

if(empty($list)){
$this->error('没有您要查找的东西!',U('Contract/index'));
}
//转换各种状态
$res = $this->contract_status($list);

$this->assign('page',$page->fpage());
$this->assign('list',$res);
$this->assign('formget',$_GET);
$this->display('index');
}
posted @ 2016-06-13 11:24  微醺的汤姆  阅读(361)  评论(0编辑  收藏  举报