yii if condition within query builder

Question

class Retailjob extends CFormModel {

    public function getReatilProducts() {

        $condition=false;
        $user = Yii::app()->db->createCommand()
            ->select('tbl_retailjob.retailjobmaster_id, tbl_retailjob.joborderflag, tbl_retailjoborder.retailjob_id, tbl_retailjoborder.retailjobsub_id, tbl_retailjoborder.filename,tbl_retailpostpressjoborder.retailpostpressjo_id,tbl_retailpostpressjoborder.retailjobsub_id,tbl_retailpostpressjoborder.retailpostpresssub_id')
            ->from('tbl_retailjob')
            ->join('tbl_retailjoborder', 'tbl_retailjob.retailjobmaster_id=tbl_retailjoborder.retailjobmaster_id')
            ->join('tbl_retailpostpressjoborder', 'tbl_retailjob.retailjobmaster_id=tbl_retailpostpressjoborder.retailjobmaster_id')           
            ->where('tbl_retailjob.retailjobmaster_id=:id', array(':id' => 7))
            ->queryAll();
        return $user;
    }
}

this is my model file what i want to achieve is if $condition is truethen the where condition should be avoide and if it is false it should be included

can i achieve it like this

public function getReatilProducts() {

    $condition=true;
    $user = Yii::app()->db->createCommand()
        ->select('tbl_retailjob.retailjobmaster_id, tbl_retailjob.joborderflag, tbl_retailjoborder.retailjob_id, tbl_retailjoborder.retailjobsub_id, tbl_retailjoborder.filename,tbl_retailpostpressjoborder.retailpostpressjo_id,tbl_retailpostpressjoborder.retailjobsub_id,tbl_retailpostpressjoborder.retailpostpresssub_id')
        ->from('tbl_retailjob')
        ->join('tbl_retailjoborder', 'tbl_retailjob.retailjobmaster_id=tbl_retailjoborder.retailjobmaster_id')
        ->join('tbl_retailpostpressjoborder', 'tbl_retailjob.retailjobmaster_id=tbl_retailpostpressjoborder.retailjobmaster_id')
    if ($condition !=true) {
        ->where('tbl_retailjob.retailjobmaster_id=:id', array(':id' => 7))
    }
    ->queryAll();
    return $user;   
}
}

Alexander Yancharuk · Accepted Answer · 2013-08-15 17:24:34Z

2

Try this:

public function getReatilProducts() {    
    $condition=true;
    $command = Yii::app()->db->createCommand()
        ->select('tbl_retailjob.retailjobmaster_id, tbl_retailjob.joborderflag, tbl_retailjoborder.retailjob_id, tbl_retailjoborder.retailjobsub_id, tbl_retailjoborder.filename,tbl_retailpostpressjoborder.retailpostpressjo_id,tbl_retailpostpressjoborder.retailjobsub_id,tbl_retailpostpressjoborder.retailpostpresssub_id')
        ->from('tbl_retailjob')
        ->join('tbl_retailjoborder', 'tbl_retailjob.retailjobmaster_id=tbl_retailjoborder.retailjobmaster_id')
        ->join('tbl_retailpostpressjoborder', 'tbl_retailjob.retailjobmaster_id=tbl_retailpostpressjoborder.retailjobmaster_id');
    if ($condition !=true) {
        $command->where('tbl_retailjob.retailjobmaster_id=:id', array(':id' => 7));
    }
    $user = $command->queryAll();
    return $user;   
}

edited Aug 15, 2013 at 17:24

answered Aug 15, 2013 at 16:58

Alexander Yancharuk

14.7k5 gold badges60 silver badges57 bronze badges

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

1 Comment

rajesh Over a year ago

ya its worked fine buddy but we need a semicolon with in the if condition

Collectives™ on Stack Overflow

yii if condition within query builder

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related