Multi tool use

Yii2 Gridview error

I want to display column from another table in gridview.

In my controller actionIndex:

public function actionIndex()
{
$user_id = Yii::$app->user->identity->id;
$queryFile = PowerGen::find();
$queryFile ->select(['submitted_by','filename.file_name','filename.submitted_by'])
->joinWith('filename')//Tells Yii to use the complains relation that we define below. By default it is an inner join
->where(['filename.submitted_by' => $this->user_id]);

$dataProvider= new ActiveDataProvider([
'query' => $query,
'pagination' => false,
]);

return $this->render('index', ['dataProvider4'=>$dataProvider]);
}


In my model:

public function fileName()
{
$user_id = Yii::$app->user->identity->id;
return $this->hasMany(Filename::className(), 'submitted_by' => $this->user_id);
}


Error is:

Error
PHP Parse Error – yiibaseErrorException
syntax error, unexpected '=>' (T_DOUBLE_ARROW)


What is the error in the line..

Thank you

3 Answers
3

Use hasMany() like

public function fileName()
{
$user_id = Yii::$app->user->identity->id;
return $this->hasMany(Filename::className(), ['submitted_by' => $this->user_id]);
}


$this->user_id

First i think your function must be like this:

public function fileName()
{
return $this->hasMany(Filename::className(), ['submitted_by' => 'user_id']);
}


And your query like this:

$user_id = Yii::$app->user->identity->id;
$queryFile = PowerGen::find();
$queryFile ->select(['submitted_by','filename.file_name','filename.submitted_by'])
->joinWith('filename')
->where(['filename.submitted_by' => $user_id]);


You are declaring the variable $user_id

$user_id

$user_id = Yii::$app->user->identity->id;

but you are not using it anywhere.

You're defining your relation in a wrong way:

get

getFileName()

hasMany()

Yii::$app->user->identity->id

public function getFileName() {
return $this->hasMany(Filename::className(), ['submitted_by' => 'user_id']);
}


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.