Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

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

Proposal for 1-5 contacts/"speakers" per event 7 months 2 weeks ago #25769

  • jose45
  • jose45's Avatar Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 47
  • Karma: 1
  • 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 7 months 2 weeks ago #25771

  • Egnarts
  • Egnarts's Avatar
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 263
  • Karma: -3
  • Thank you received: 113
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".
Take a look at the responsive version of JEM: The Responsive JEM

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

Proposal for 1-5 contacts/"speakers" per event 7 months 1 week 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).
JEM 2.2.3 - Joomla! 3.9.x - PHP 7.2.x - Dev Spanish
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 7 months 1 week 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.

Proposal for 1-5 contacts/"speakers" per event 5 months 4 weeks ago #26039

  • jose45
  • jose45's Avatar Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 47
  • Karma: 1
  • 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
j.

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

Proposal for 1-5 contacts/"speakers" per event 5 months 4 weeks ago #26043

  • jojo12
  • jojo12's Avatar
  • Offline
  • Moderator
  • Moderator
  • Posts: 3098
  • Karma: 45
  • Thank you received: 331
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.
Testing JEM 2.3.0 beta3 local on clean latest Joomla (3.9.11) Protostar php7.3.8 (no mails)
The following user(s) said Thank You: jose45

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

  • Page:
  • 1
  • 2
Time to create page: 0.218 seconds

Donate

If you find JEM useful and if you use it on your site, please consider a donation to the project.

Private Messages

You are not logged in.

Follow us......