Alexander Makarov

icon indicating a website link https://asapirl.com/ icon indicating an email [email protected]

icon company Twindo, Yii, Codeception, PHP-FIG icon location Earth icon location Engineer having fun, lead of Yii framework. PGP: 6A325E4A

Results 1736 comments of Alexander Makarov

DB CASE WHEN in SELECT

Oh... It could be multi-level.

DB CASE WHEN in SELECT

@mariuszkrzaczkowski ``` php $case = new \yii\db\Case()) ->when('lead.status IS NULL || lead.status = ""')->then('') ->else('lead.status'); $query->select([ 'leadstatus' =>$case, ]); ```

DB CASE WHEN in SELECT

Parameters are already handled on query level so I don't think there's a need to add special support at `CaseQuery` level.

DB CASE WHEN in SELECT

@cebe yes, a good name.

DB CASE WHEN in SELECT

Which file?

DB CASE WHEN in SELECT

In our heads. We're just thinking loud.

DB CASE WHEN in SELECT

No only in orderBy. It should be everywhere.

DB CASE WHEN in SELECT

``` php $case = new \yii\db\CaseExpression()) ->when(['org.size' => [0, 1]])->then('

DB CASE WHEN in SELECT

> Also, PHP < 7 does not allow method else(). `orElse`?

DB CASE WHEN in SELECT

@SilverFire is it possible to implement such a thing with your recent proposal?