// 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') . '