Breaking News: Grepper is joining You.com. Read the official announcement!

php Yii2 relation with junction table

Luciano I. answered on November 30, 2022 Popularity 1/10 Helpfulness 1/10

answer php Yii2 relation with junction table

php Yii2 relation with junction table

Comment

class Ruolo extends \yii\db\ActiveRecord {
//Ruolo has many RuoloOperazione
//each RuoloOperazione hasOne Operazione
 
 
//ruolo (id)=> (ruolo_id) ruolo_operazione (operazione_id) <= (id)operazione
public function getOperazioni() {
        return $this->hasMany(Operazione::className(), ['id' => 'operazione_id'])
                        ->viaTable('vlt_ruolo_operazione', ['ruolo_id' => 'id'])
                        ->orderBy(['vlt_sala_operazione.sort_id' => SORT_ASC]);
    }
 
}
 
 
//IMPORTANT ============================================== !!!!!!!!!!!!
//if the result of hasMany is immediately interrogated in  the function, it needs to be
//eagerly loaded, so add all() or one(), or else it will return only a query to be
//tested in the function and not and array !
//ex:
$casse = $this->hasMany(Cassa::className(), ['sala_id' => 'id'])
                ->where(['not', ['vlt_sala_cassa.controller_id' => null]])
                ->orderBy(['sort_id' => SORT_ASC, 'cassa' => SORT_ASC])
                ->all();
 
return count($casse) > 0 ? $casse : null;

Popularity 1/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: junction-table php relation yii2

Link to this answer
Share Copy Link

Contributed on Nov 30 2022

Luciano I.

0 Answers Avg Quality 2/10

php Yii2 relation with junction table

Contents

More Related Answers

php Yii2 relation with junction table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.