Yii2 console relation comes empty

1

Hello
I have an issue with a relation on a model thru console.
The relation comes empty thru console but when running thru web controller it comes with the related rows.
Both controllers executes the same module function. Do you know what is happening?

Here is the code:

class CContractController extends Controller
{
    public function actionUpdate()
    {
        $module= \Yii::$app->getModule('contrato');
        $result=$module->UpdateList();

        if($result!==false){
            return ExitCode::OK;
        } else {
            return ExitCode::DATAERR;
        }
    }
}

class AlarmdotcomModule extends \yii\base\Module
{
    public function UpdateList(){
       
        $list= Sites::find()->with('contrato')->all();
        
        echo "without:".count($list)."-";
          
        foreach ($list as $site){ 
            if(isset($site->contrato)){ 
                if($site->contrato->MATRICULA!=""){
                    $ii++;
                    $site->MATRICULA=$site->contrato->MATRICULA;
                    $site->save();
                }
            }
        }
        echo "updated:".$ii;
}

class Sites extends \yii\db\ActiveRecord
{
   //...
    /** relation
     * @return \yii\db\ActiveQuery
     */
    public function getContrato()
    {
        return $this->hasOne(Contratos::className(), ['id' => 'contrato_id'])->alias('contrato');
    }
}
2

Should not matter if it’s console or not. Have you checked what’s the difference in the AR object?

3

Hi Alexander
Sorry found the issue, I had the problem on ContratosSearch
It was filtering the records based on the user.

so we can close this.
thanks

4