$where = [];
        $where[] = ['member_status','=',1];
        $whereor = [];

        $where1 = [];

//相同字段不同条件

        $where1 = [['member_name','like','%'.$param['smember_name'].'%'], ['member_name','like','%'.$param['labels'].'%']];
//不同字段相同条件
        if(!empty($param['smember_name'])){
            $whereor[] = ['member_name|labels|remarks','like','%'.$param['smember_name'].'%'];
        }
        if(!empty($param['smember_phone'])){
            $where[] =[ 'member_phone','=',$param['smember_phone']];
        }
        if(!empty($param['category'])){
            $where[] =['member_category','=',$param['category']];
        }

        if(!empty($param['start'])){
            $where[] = ['member_regtime','>=',strtotime($param['start'].' 00:00:00') ];
        }

        if(!empty($param['end'])){
            $where[] = ['member_regtime','<=',strtotime($param['end'].' 23:59:59') ];
        }
        
         if(empty($param['smember_name']) && empty($param['smember_phone'])){
            $where[] = ['member_shop','=',session('posshop')];
        }
       // var_dump($where);

        if(empty($param['limit'])){
            $param['limit'] = 20;
        }

        
        $data = Db::view('member','id,member_code,member_name,member_sname,member_phone,member_regtime,member_category,member_sex,member_birth,member_year,labels,remarks')
            ->view('mcategory',['mcategory_name'],'member.member_category=mcategory.id','LEFT')
            ->view('member_card',['card_money'],'member.id=member_card.member_id','LEFT')
            ->where($where)
            ->where($where1)
            ->where($whereor)
            ->where(function($query) use ($where1){$query->whereOr($where1);})
            ->order('member_regtime','desc')
            ->paginate($param['limit']);
            echo Db::getLastSql();
            exit();