TOPIC:

Proposal for 1-5 contacts/"speakers" per event 4 years 1 month ago #25769

jose45 Topic Author Offline Senior Member Posts: 49 Thank you received: 6	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)
	Please Log in or Create an account to join the conversation. Last edit: by jose45.

Proposal for 1-5 contacts/"speakers" per event 4 years 1 month ago #25771

Egnarts Offline Elite Member Posts: 300 Thank you received: 135	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.

Proposal for 1-5 contacts/"speakers" per event 4 years 4 weeks ago #25805

McKillo
Offline
Junior Member
Posts: 29
Thank you received: 8

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.

Proposal for 1-5 contacts/"speakers" per event 4 years 3 weeks ago #25809

mercuri Offline New Member Posts: 4 Thank you received: 0	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.

Proposal for 1-5 contacts/"speakers" per event 3 years 11 months ago #26039

jose45
Topic Author
Offline
Senior Member
Posts: 49
Thank you received: 6

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 ...

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

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

Proposal for 1-5 contacts/"speakers" per event 3 years 11 months ago #26043

jojo12 Offline Administrator Posts: 3542 Thank you received: 404	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.