// create html page object
$page = new HtmlPage($headline);
$page->addJavascriptFile('adm_program/modules/profile/profile.js');
$page->addJavascript('var profileJS = new profileJSClass();');
// add back link to module menu
$rolesMenu = $page->getMenu();
$rolesMenu->addItem('menu_item_back', $gNavigation->getPreviousUrl(), $gL10n->get('SYS_BACK'), 'back.png');
}
// show headline of module
$html .= '<form id="roles_assignment_form" action="' . $g_root_path . '/adm_program/modules/profile/roles_save.php?usr_id=' . $getUserId . '&new_user='******'&inline=' . $getInline . '" method="post">';
// Create table
$table = new HtmlTable('role_assignment_table');
$columnHeading = array(' ', $gL10n->get('SYS_ROLE'), $gL10n->get('SYS_DESCRIPTION'), $gL10n->get('SYS_LEADER'));
$table->addRowHeadingByArray($columnHeading);
$table->setColumnAlignByArray(array('center', 'left', 'left', 'left'));
$table->setColumnsWidth(array('10%', '30%', '45%', '15%'));
if ($gCurrentUser->manageRoles()) {
// Benutzer mit Rollenrechten darf ALLE Rollen zuordnen
$sql = 'SELECT cat_id, cat_name, rol_name, rol_description, rol_id, rol_visible, rol_leader_rights,
mem_rol_id, mem_usr_id, mem_leader
FROM ' . TBL_ROLES . '
INNER JOIN ' . TBL_CATEGORIES . '
ON cat_id = rol_cat_id
LEFT JOIN ' . TBL_MEMBERS . '
ON rol_id = mem_rol_id
AND mem_usr_id = ' . $getUserId . '
AND mem_begin <= \'' . DATE_NOW . '\'
AND mem_end > \'' . DATE_NOW . '\'
WHERE rol_valid = 1
AND rol_visible = 1
AND ( cat_org_id = ' . $gCurrentOrganization->getValue('org_id') . '
