$gMessage->show($gL10n->get('SYS_DELETE_DATA'));
} elseif ($getMode === 5) {
// Rolle wieder aktiv setzen
$return_code = $role->setActive();
if ($return_code < 0) {
$gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
$gMessage->setForwardUrl($gNavigation->getUrl());
$gMessage->show($gL10n->get('ROL_ROLE_SET_MODE', $role->getValue('rol_name'), $gL10n->get('SYS_ACTIVE')));
} elseif ($getMode === 6) {
// Fragen, ob die inaktive Rolle geloescht werden soll
$gMessage->setForwardYesNo($g_root_path . '/adm_program/modules/roles/roles_function.php?rol_id=' . $getRoleId . '&mode=4');
$gMessage->show($gL10n->get('ROL_ROLE_DELETE_DESC', $role->getValue('rol_name')));
} elseif ($getMode === 7) {
$role->setValue('rol_visible', 0);
$role->save();
$gMessage->setForwardUrl($gNavigation->getUrl(), 2000);
$gMessage->show($gL10n->get('ROL_ROLE_SET_MODE', $role->getValue('rol_name'), $gL10n->get('SYS_INVISIBLE')));
} elseif ($getMode === 8) {
$role->setValue('rol_visible', 1);
$role->save();
$gMessage->setForwardUrl($gNavigation->getUrl(), 2000);
$gMessage->show($gL10n->get('ROL_ROLE_SET_MODE', $role->getValue('rol_name'), $gL10n->get('SYS_VISIBLE')));
} elseif ($getMode === 9) {
if ($role->hasFormerMembers()) {
echo '1';
} else {
echo '0';
}
exit;
}
$sql = 'SELECT rol_id, rol_name
FROM ' . TBL_ROLES . '
INNER JOIN ' . TBL_CATEGORIES . '
ON cat_id = rol_cat_id
WHERE rol_id IN (' . $sqlRoleIds . ')
' . $sqlParticipationRoles . '
ORDER BY rol_name ASC';
$rolesStatement = $gDb->query($sql);
$rolesArray = $rolesStatement->fetchAll();
foreach ($rolesArray as $roleArray) {
// Rollenobjekt anlegen
$role = new TableRoles($gDb);
$role->setArray($roleArray);
$list[] = array('groupID: ' . $roleArray['rol_id'], $roleArray['rol_name'], $gL10n->get('SYS_ROLES') . ' (' . $gL10n->get('LST_ACTIVE_MEMBERS') . ')');
$listRoleIdsArray[] = $roleArray['rol_id'];
if ($role->hasFormerMembers() > 0 && $gPreferences['mail_show_former'] == 1) {
// list role with former members
$listFormer[] = array('groupID: ' . $roleArray['rol_id'] . '-1', $roleArray['rol_name'] . ' ' . '(' . $gL10n->get('SYS_FORMER_PL') . ')', $gL10n->get('SYS_ROLES') . ' (' . $gL10n->get('LST_FORMER_MEMBERS') . ')');
// list role with active and former members
$listActiveAndFormer[] = array('groupID: ' . $roleArray['rol_id'] . '-2', $roleArray['rol_name'] . ' ' . '(' . $gL10n->get('MSG_ACTIVE_FORMER_SHORT') . ')', $gL10n->get('SYS_ROLES') . ' (' . $gL10n->get('LST_ACTIVE_FORMER_MEMBERS') . ')');
}
}
$list = array_merge($list, $listFormer, $listActiveAndFormer);
$listVisibleRoleArray = array_intersect($listRoleIdsArray, $gCurrentUser->getAllVisibleRoles());
}
if ($getRoleId === 0 && count($listVisibleRoleArray) > 0) {
// if no special role was preselected then list users
$sql = 'SELECT usr_id, first_name.usd_value as first_name, last_name.usd_value as last_name,
rol_mail_this_role, rol_id, mem_begin, mem_end
FROM ' . TBL_MEMBERS . '
INNER JOIN ' . TBL_ROLES . '
$gMessage->show($gL10n->get('SYS_DELETE_DATA'));
} elseif ($getMode == 5) {
// Rolle wieder aktiv setzen
$return_code = $role->setActive();
if ($return_code < 0) {
$gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
$gMessage->setForwardUrl($gNavigation->getUrl());
$gMessage->show($gL10n->get('ROL_ROLE_SET_MODE', $role->getValue('rol_name'), $gL10n->get('SYS_ACTIVE')));
} elseif ($getMode == 6) {
// Fragen, ob die inaktive Rolle geloescht werden soll
$gMessage->setForwardYesNo($g_root_path . '/adm_program/modules/roles/roles_function.php?rol_id=' . $getRoleId . '&mode=4');
$gMessage->show($gL10n->get('ROL_ROLE_DELETE_DESC', $role->getValue('rol_name')));
} elseif ($getMode == 7) {
$role->setValue('rol_visible', 0);
$role->save();
$gMessage->setForwardUrl($gNavigation->getUrl(), 2000);
$gMessage->show($gL10n->get('ROL_ROLE_SET_MODE', $role->getValue('rol_name'), $gL10n->get('SYS_INVISIBLE')));
} elseif ($getMode == 8) {
$role->setValue('rol_visible', 1);
$role->save();
$gMessage->setForwardUrl($gNavigation->getUrl(), 2000);
$gMessage->show($gL10n->get('ROL_ROLE_SET_MODE', $role->getValue('rol_name'), $gL10n->get('SYS_VISIBLE')));
} elseif ($getMode == 9) {
if ($role->hasFormerMembers() == true) {
echo '1';
} else {
echo '0';
}
exit;
}
$act_number = '-1';
} elseif ($act_or === 2) {
$act_group = $gL10n->get('SYS_ROLES') . ' (' . $gL10n->get('LST_ACTIVE_FORMER_MEMBERS') . ')';
$act_group_short = '(' . $gL10n->get('MSG_ACTIVE_FORMER_SHORT') . ')';
$act_number = '-2';
} else {
$act_group = $gL10n->get('SYS_ROLES') . ' (' . $gL10n->get('LST_ACTIVE_MEMBERS') . ')';
$act_number = '';
}
// list array with all roles where user is allowed to send mail to
$send_roles = $gCurrentUser->getAllMailRoles();
foreach ($send_roles as &$allowed_role) {
// Rollenobjekt anlegen
$role = new TableRoles($gDb);
$role->readDataById($allowed_role);
if ($act_number == '' || $role->hasFormerMembers($allowed_role) > 0 && $gPreferences['mail_show_former'] == 1) {
$list[] = array('groupID: ' . $allowed_role . $act_number, $role->getValue('rol_name') . ' ' . $act_group_short, $act_group);
$list_rol_id_array[] = $allowed_role;
}
}
}
foreach (array_unique($list_rol_id_array) as $key) {
if (isset($list_rol_id)) {
$list_rol_id .= ", '" . $key . "'";
} else {
$list_rol_id = "'" . $key . "'";
}
}
// select Users
$sql = 'SELECT usr_id, first_name.usd_value as first_name, last_name.usd_value as last_name,
rol_mail_this_role, rol_id, mem_begin, mem_end
