Hello everybody,
I'm developping an extension to manage reservation on a museum here in Malmedy. malmundarium.
Actually, the contao version of the site isn't online, it'll be in a few weeks I hope.
I'm encountering some tricky problems with the extension I developped. I'd like to show, in the backend, some values from some "linking" table.
In fact, I've got several tables, which are connected to another using table containing their primary keys.
In order to make the connection using the backend, I've configured the DCA like :
Code:
'idlangue' => array
(
'label' => &$GLOBALS['TL_LANG']['rs_maitrise']['idlangue'],
'exclude' => true,
'inputType' => 'select',
'foreignKey' => 'rs_langue.lg', // code of the language e.g. FR / NL / DE / EN / SP / instead of the id 1 / 2 / 3 / ...
'eval' => array('mandatory'=>true, 'maxlength'=>2)
),
'idguide' => array
(
'label' => &$GLOBALS['TL_LANG']['rs_maitrise']['idguide'],
'exclude' => true,
'inputType' => 'select',
'foreignKey' => 'rs_guide.CONCAT(nom,\' \',prenom)', // name of the person e.g. "Wayne John" instead of id "1"
'eval' => array('mandatory'=>true, 'maxlength'=>3)
)
Now, when showing the data in the resuming table, I'd like to show the the same information as in the "select menus" when creating a new connection.
I don't know if some can understand me, because my english is awefull.
Bookmarks