Laravel SQL query on condition

Question

suppose i have a function like bellow (in Laravel 4.2):

public static function getResult($class_id,$section_id,$session,$term,$setTerm = ture)
{
     $result = self::with('Student','Student.getClass','Student.getSection')
        ->where('class_id',$class_id)
        ->where('section_id',$section_id)
        ->where('exam_year',$session)
        ->where('term',$term)
        ->orderBy('class_roll','ASC')->get();

    return $result;

}

so if $setTerm is set to false then (->where('term',$term)) should not be executed.

How to do that conditional things in Laravel during query building ?

Thanks

Michael Jaros · Accepted Answer · 2015-03-09 12:35:24Z

1

Please try it, this should work:

public static function getResult($class_id,$section_id,$session,$term,$setTerm = ture)
{
     $result = self::with('Student','Student.getClass','Student.getSection')
        ->where('class_id',$class_id)
        ->where('section_id',$section_id)
        ->where('exam_year',$session);

     if($setTerm){ 
        $result->where('term',$term);
     }

     $result->orderBy('class_roll','ASC')->get();

     return $result;

}

edited Mar 9, 2015 at 12:35

Michael Jaros

4,6991 gold badge27 silver badges41 bronze badges

answered Mar 1, 2015 at 9:36

Jay Dhameliya

1,70912 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Laurence · Accepted Answer · 2015-03-01 11:32:25Z

1

You can change the function to be this:

public static function getResult($class_id,$section_id,$session,$term,$setTerm = true)
{
     $query = self::with('Student','Student.getClass','Student.getSection')
        ->where('class_id',$class_id)
        ->where('section_id',$section_id)
        ->where('exam_year',$session);

    if ($setTerm) {
        $query->where('term',$term);
    }

    return $query->orderBy('class_roll','ASC')->get();    
}

edited Mar 1, 2015 at 11:32

answered Mar 1, 2015 at 9:33

Laurence

60.3k22 gold badges178 silver badges215 bronze badges

1 Comment

lukasgeiter Over a year ago

One little flaw, you have to assign the return value of get() to $query or return it directly. Otherwise getResult() will return a query builder instance and not the actual result.

Collectives™ on Stack Overflow

Laravel SQL query on condition

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related