6338
Hi,
First of all, congratulations on this superb piece of software which I’m using to get myself into the MVC (and OO PHP) world.
To give myself a tough beginning I’m trying to develop a historical database (world cultures and related bibliography), part of its ER diagram you may find attached to this post.
The central piece is table Costumbre which has a many-to-many relationship to table Bibliografia by means of table auxiliar_costumbre_bibliografia which in turn also holds additional fields as "observaciones" and "pagina_inicial" (starting page) as the same tradition referred to in the same book may appear in different pages (so three primary keys are defined for this intermediate table).
First question:
Is this schema a proper base to be managed by Yii2? I would like to use a common form to enter data for Costumbres and complementary fields in auxiliar_costumbre_bibliografia so I’m hesitating about this way of planning things.
Second question:
In order to speed queries up I created a MySQL view spanning all these tables to show some of the most relevant fields. Then I created a VistaCostumbreBibliografia and VistaCostumbreBibliografiaSearch models to handle this view from CostumbreController and they work fine except when choosing to view a particular model in DetailView. As per the Yii2 documentation, a primaryKey function is needed in the VistaCostumbreBibliografia model so I did:
public static function primaryKey()
{
return ['vcostumbre_id', 'vbibliografia_id', 'vpagina_inicial'];
}
which should return an array with the three primary keys of the intermediate table auxiliar_costumbre_bibliografia and feed it into the Gii-generated CostumbreController, specifically:
public function actionView($id)
{
return $this->render('view', [
'model' => $this->findModel($id),
]);
}
.....
protected function findModel($id)
{
if (($model = VistaCostumbreBibliografia::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
However it throws a Bad Request (mssing ‘id’). What should I do about this?
Thanks in advance for any help.
Antonio