// 1. Find the patient in Joomla-database, table: #__users
// We need: user_id of the just created patient
 
$patname = $db->escape($_POST['form']['Accountnaam']);
 
// retrieve user_id of newly created user
 
$db =& JFactory::getDBO();
$query = $db->getQuery(true);
$query
->select('id')
->from($db->quoteName('#__users'))
->where($db->quoteName('username')." = ".$db->quote($patname));  
 
$db->setQuery($query);
$patuser_id = $db->loadResult();
 
// 2. Read the ACL-group from the dropdown-field of the patient/disease-groep
// The doctor chooses the diagnosis-area and this choice determines which forms are displayed when the new patient logs in. 
// Therefor, the patient (Joomla-user) must be in the correct ACL-group.
// In this website, the ACL-group's for patients are configured like this:
// group_id=9 | Deelnemers_Onderzoek
// group_id=10 | Bekkenbodem-spreekuur
// group_id=15 | Seksuologie-spreekuur
 
$patgroup_id = intval($_POST['form']['aclgroup'][0]);
 
// 3. Now create a record in table #__user_usergroup_map
// Fill in two fields: user_id en group_id
// Fill in user_id = patuser_id, retrieved in step 1
// Fill in group_id = patgroup_id, retrieved in step 2
 
$query = $db->getQuery(true);
 
$columns = array('user_id', 'group_id');
$values = array($patuser_id, $patgroup_id);
$query
  ->insert($db->quoteName('#__user_usergroup_map'))
  ->columns($db->quoteName($columns))
  ->values(implode(',', $values));
 
$db->setQuery($query);
$db->query();
 
// 4. Show the Thank-You message.
// In there display the important variables of this script.
 
$thankYouMessage .= '<h2>Test voor Script called after form has been processed: </h2>'.'<p>Patientname is : '.$patname.'</p><p>User-ID is : '.$patuser_id.'</p><p>ACL-Group-no: '.$patgroup_id.'</p>'.'<h3>SQL-query : </h3><p>'.$query.'</p>';

$user = JFactory::getUser();
$usr_id = $user->get('id');

JUserHelper::addUserToGroup($usr_id, insert_id_of_group_to_be_added);

JUserHelper::removeUserFromGroup($usr_id, insert_id_of_group_to_be_removed);