laravel 5.4 can i use custom method inside a where clause

I'm trying to call a method inside a custom model function during query building but getting error.This way is it possible.Actually i'm trying to break the query in two function because filterData may be long.

In model, i wrote like this

public function get_filter_sql2($query, $filterData){

        if( count($filterData) > 0 ){   

            foreach($filterData as $key=>$value){   

                if( $value!=''){

                    if( $key == 'title' ){
                        $query->where('b.title', 'LIKE', '%'.$value.'%');
                    }
                    if( $key == 'bannercatID' ){
                        $query->where('b.bannercatID', '=', $value);
                    }
                    if( $key == 'status' ){
                        $query->where('b.status', '=', $value);
                    }

                }
            }
        }   
        return $query; 
    }



function scopeGet_all_records2($query,$filterData, $per_page){ 
        //DB::enableQueryLog();
        $result = DB::table('banner as b')
                ->leftJoin('banner_category as bc', 'bc.bannercatID', '=', 'b.bannercatID')    
                ->select('*')           
                ->where( function ($query) use ($filterData){               
                    $this->get_filter_sql2($query, $filterData);
                 })         
                ->orderBy('b.bannercatID', 'ASC')
                ->paginate($per_page)
                ;
        //$result = DB::getQueryLog(); 
        //print_r($result);
        if( count($result) > 0 ){
            $result = $result;
        }
        else{
            $result = false;
        }       
        return $result;             

    }

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2hrXW38
via IFTTT