CODEWITHSUNDEEP
phplaravel
Kin
Kin

Reputation: 4596

Is it possible to split query builder in Laravel?

Is it possible to split queries somehow like this?

public function getStatuses($dates)
{
    $query = DB::table('tickets');

    if ($dates['from'])
        $query = $query->where('from', $dates['from']);

    if ($dates['to'])
        $query = $query->where('to', $dates['to']);

    $query = $query->select('Active');

    return $query->get()->toArray();
}

Upvotes: 1

Views: 5203

Answers (3)

Prince
Prince

Reputation: 31

In Laravel Eloquent :

$query = ModelName::where('status',1);

if($userId){
 $query->where('user_id',$userId);
}

if($limit){
 $query->limit($limit);
}    

$result = $query->get();

Upvotes: 1

JacobRossDev
JacobRossDev

Reputation: 413

In Laravel 4, its necessary to assign the get method to a variable

public function scopeGetPosts($query, $this_user = NULL){
    $results = DB::table('post')
                ->select('*')
                ->where('post_status','=','publish');

    if( $this_user != NULL ){
        $results->where('post_author','=',$this_user->user_id);
    }

        $data = $results->orderBy('created_at', 'desc')
                ->get(); 

        if( empty( $results ) )
            $data = 'no results';

    return $data;
}

Upvotes: 2

Damien Pirsy
Damien Pirsy

Reputation: 25435

Yes, it's possibile. But don't reassign to the same variable or you risk messing it up:

public function getStatuses($dates)
{
    $query = DB::table('tickets');
    if ($dates['from'])
        $query->where('from', $dates['from']);
    if ($dates['to'])
        $query->where('to', $dates['to']);
    $query->select('Active');
    return $query->get()->toArray();
}

Upvotes: 4

Related Questions