How to return results by ignoring empty sql conditions?

Question

Yii

$result = Company::model()->with(
                'staffs',
                'staffs.phoneStaffs',
                'staffs.emailStaffs'
                )->findAll(array(
                    'condition'=> 'staffs.client_id=:idClientId '
                    . 'and phoneStaffs.client_id=:idClientId '
                    . 'and emailStaffs.client_id=:idClientId',
                    'params'=>  array(':idClientId' => $idClientId)));

With such a query, the result will be empty if no emailStaffs.client_id=:idClientId is found. How, then, to ignore the empty condition and return the result, but without the presence of emailStaffs in the resulting selection? Yii2 has filterWhere() for this case.

Answer 1

$result = Company::find()
  ->with(['staffs', 'staffs.phoneStaffs', 'staffs.emailStaffs'])
  ->filterWhere([
    'staffs.client_id' => $idClientId,
    'phoneStaffs.client_id' => $idClientId,
    'emailStaffs.client_id' => $idClientId,
  ])->all();