Yii2 ActiveQuery use OR in Link array

Question

I want to use OR operator in $link array in hasMany function in class extended by ActiceRecord. For example, I want to get transactions which related whith user account. In sql it would be something like SELECT * FROM transactions WHERE fromAccountId = :id OR toAccountId = :id But how I can wrote this using Yii2

    public function getTransactions() {
        return $this->hasMany(Transaction::className(), [
            'fromAccountId' => 'id',
            'toAccountId' => 'id'
        ]);
    }

Evgeniy Tkachenko · Accepted Answer · 2015-05-06 07:39:59Z

Link ActiveQuery works with the keys of the array as name column, values - as value of column.

The array keys must be columns of the table for this relation, and the array values must be the corresponding columns from the primary table

Because the code doesn't work (where (fromAccountId, toAccountId) IN ('id','id')):

[
    'fromAccountId' => 'id',
    'toAccountId' => 'id'
]

You can rewrite hasMany behavior in getTransactions()

public function getTransactions() {
    $query = Transaction::find();
    $query->multiple = true;
    return $query->where(['OR',
        ['fromAccountId' => $this->id],
        ['toAccountId' => $this->id]
    ]);
}

It supports native behavior, as expected:

$model->getTransactions() // return as \yii\db\ActiveQuery
$model->transactions // return as array of Transactions models

But doesn't work for $model->find()->with('transactions'), because with require setting $query->link. Instead with need to use join....

Adam Fentosi · Accepted Answer · 2014-10-16 10:16:57Z

0

You can use the find(), it's not as nice, but do the work:

return $this->find()->join('LEFT JOIN', 'transaction', 'fromAccountId = id OR toAccountId = id')->all();

Maybe you have to use tablename.id!

answered Oct 16, 2014 at 10:16

Adam Fentosi

1,26811 silver badges10 bronze badges

Comments

Mihai P. · Accepted Answer · 2014-10-14 23:02:08Z

-2

I have not tried this, but you could try something like

public function getTransactions() {
        return $this->hasMany(Transaction::className(), ['1' => '1'])->where('fromAccountId = id OR toAccountId = id');
    }

The idea is to create a join without a condition (or with a dummy condition) then use where to get the actual results you want. This might mean a massive performance problem.

answered Oct 14, 2014 at 23:02

Mihai P.

9,3673 gold badges40 silver badges50 bronze badges

2 Comments

Evgeniy Tkachenko Over a year ago

['1' => '1'] Getting unknown property: Model::1

Shaig Khaligli Over a year ago

Getting unknown property : Model ::1

Collectives™ on Stack Overflow

Yii2 ActiveQuery use OR in Link array

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related