help to better help you:

Please: add always Joomla / JEM version and details to your posts, so we can try to reproduce your issue!

Proposal for 1-5 contacts/"speakers" per event

Proposal for 1-5 contacts/"speakers" per event

5 years 9 months ago - 5 years 9 months ago
#25769
I need more contacts for one event - because several speakers per event needed, from the com_contact. How would you best achieve this? With a link table #_jem-events_contacts or use these "custom#-fields" and enter a heron contact-ID in one of them?
thx, j.
(JEM 2.2.3, J! 3.9.3)
Last edit: 5 years 9 months ago by jose45.

Please Log in or Create an account to join the conversation.

Re: Proposal for 1-5 contacts/"speakers" per event

5 years 9 months ago
#25771
I think the simples solution is to use the custom fields to insert links to the speakers.
Use language overrides for changing the name "Custom Field X" to "Speaker X".

Please Log in or Create an account to join the conversation.

Re: Proposal for 1-5 contacts/"speakers" per event

5 years 9 months ago
#25805
Idea: It could be a FMR to multiple contacts for events. Only change code to select multiple contacts, and save these ids into contactid field of __jem_events table.

Custom filed are global for all events. For example if you use custom field, you custom label for this custom field. If the custom field is empty, not shown, but you need more custom field, for example 5 more for contact, I don't have or not change label for one event, if you change the label of custom fields is for all events. If you had not used custom fields, then it's a alternative solution but the speaker name don't link to contact (could be use the link to contact, but it's not the same).
The following user(s) said Thank You: jojo12

Please Log in or Create an account to join the conversation.

Re: Proposal for 1-5 contacts/"speakers" per event

5 years 9 months ago
#25809
Thanks to you!
The custom fields are a super-innovation and almost all of them are already in use.
I think to do this (again) like 10 years ago in the old eventList (hope I can do it again): a field with comma separated ID's from com_contact. The ID order then also shows the output of the speakers (-group of the com_contact).
Greetings

Please Log in or Create an account to join the conversation.

Re: Proposal for 1-5 contacts/"speakers" per event

5 years 7 months ago
#26039
contact-IDs separated by spaces are entered in a custom field and in the, from the default.php loaded template-file #__contact_details-query, retrieved ...
Code:
for($x=0;$x<count($array);$x++) { // ---- #_contact_details ---- $db = JFactory::getDbo(); // Create a new query object. $query = $db->getQuery(true); $query ->select(array('b.id', 'b.name', 'b.suburb', 'b.user_id', 'b.published')) ->from($db->quoteName('#__contact_details', 'b')) ->where($db->quoteName('b.id') . ' LIKE '. $db->quote($array[$x])) ; $db->setQuery($query); $dataset = $db->loadObjectList(); // --- unspool events speakers, with link ---- if ($nextRow) { print ",&nbsp;"; } $nextRow = TRUE; if(!empty($dataset[0]->name)) { $author = $dataset[0]->name; } if(!empty($dataset[0]->suburb)) { $author .= "&nbsp;(" . $dataset[0]->suburb . ")"; } if ( isset($dataset[0]->published) AND $dataset[0]->published > 0) { echo JHtml::_('link', JRoute::_('index.php?option=com_contact&view=contact&id='.$dataset[0]->id),$author); } else { echo $author; } } // end for
j.

Please Log in or Create an account to join the conversation.

Re: Proposal for 1-5 contacts/"speakers" per event

5 years 7 months ago
#26043
Hi, I fear, I will get problems if JEM is changed like that.
Because I am using the contact for addressing attending forms for those who aren't registered in Joomla but want to participate.
How does the user knows, to which person he should contact. There must be only one contact to collect all attendings. If not there will be chaotic, I think.
The following user(s) said Thank You: jose45

Please Log in or Create an account to join the conversation.

Time to create page: 0.473 seconds