// define link to create new profile field
$fieldsMenu->addItem('menu_item_new_field', $g_root_path . '/adm_program/modules/preferences/fields_new.php', $gL10n->get('ORG_CREATE_PROFILE_FIELD'), 'add.png');
// define link to maintain categories
$fieldsMenu->addItem('menu_item_maintain_category', $g_root_path . '/adm_program/modules/categories/categories.php?type=USF', $gL10n->get('SYS_MAINTAIN_CATEGORIES'), 'application_double.png');
$sql = 'SELECT * FROM ' . TBL_CATEGORIES . ', ' . TBL_USER_FIELDS . '
WHERE cat_type = \'USF\'
AND usf_cat_id = cat_id
AND ( cat_org_id = ' . $gCurrentOrganization->getValue('org_id') . '
OR cat_org_id IS NULL )
ORDER BY cat_sequence ASC, usf_sequence ASC ';
$statement = $gDb->query($sql);
// Create table
$table = new HtmlTable('tbl_profile_fields', $page, true);
$table->setMessageIfNoRowsFound('ORG_NO_FIELD_CREATED');
// create array with all column heading values
$columnHeading = array($gL10n->get('SYS_FIELD') . HtmlForm::getHelpTextIcon('ORG_FIELD_DESCRIPTION'), ' ', $gL10n->get('SYS_DESCRIPTION'), '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/eye.png" alt="' . $gL10n->get('ORG_FIELD_NOT_HIDDEN') . '" title="' . $gL10n->get('ORG_FIELD_NOT_HIDDEN') . '" />', '<img class="admidio-icon-info" data-html="true" src="' . THEME_PATH . '/icons/textfield_key.png" alt="' . $gL10n->get('ORG_FIELD_DISABLED', $gL10n->get('ROL_RIGHT_EDIT_USER')) . '" title="' . $gL10n->get('ORG_FIELD_DISABLED', $gL10n->get('ROL_RIGHT_EDIT_USER')) . '" />', '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/asterisk_yellow.png" alt="' . $gL10n->get('ORG_FIELD_REQUIRED') . '" title="' . $gL10n->get('ORG_FIELD_REQUIRED') . '" />', $gL10n->get('ORG_DATATYPE'), ' ');
$table->addRowHeadingByArray($columnHeading);
$categoryId = 0;
$userField = new TableUserField($gDb);
// Intialize variables
$description = '';
$hidden = '';
$disable = '';
$mandatory = '';
$usfSystem = '';
while ($row = $statement->fetch()) {
$userField->clear();
$userField->setArray($row);
if ($categoryId != $userField->getValue('cat_id')) {
$block_id = 'admCategory' . $userField->getValue('usf_cat_id');
$table->addTableBody();
}
$downloadOverview->addRowByArray($columnValues, 'row_file_' . $nextFile['fil_id']);
}
}
// Create download table
$downloadOverview->setDatatablesColumnsHide(array(1));
$downloadOverview->setDatatablesOrderColumns(array(1, 3));
$htmlDownloadOverview = $downloadOverview->show(false);
/**************************************************************************/
// Add Admin table to html page
/**************************************************************************/
// If user is download Admin show further files contained in this folder.
if ($gCurrentUser->editDownloadRight()) {
// Check whether additional content was found in the folder
if (isset($folderContent['additionalFolders']) || isset($folderContent['additionalFiles'])) {
$htmlAdminTableHeadline = '<h2>' . $gL10n->get('DOW_UNMANAGED_FILES') . HtmlForm::getHelpTextIcon('DOW_ADDITIONAL_FILES') . '</h2>';
// Create table object
$adminTable = new HtmlTable('tbl_downloads', $page, true);
$adminTable->setColumnAlignByArray(array('left', 'left', 'left', 'right'));
// create array with all column heading values
$columnHeading = array('<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/download.png" alt="' . $gL10n->get('SYS_FOLDER') . ' / ' . $gL10n->get('DOW_FILE_TYPE') . '" title="' . $gL10n->get('SYS_FOLDER') . ' / ' . $gL10n->get('DOW_FILE_TYPE') . '" />', $gL10n->get('SYS_NAME'), $gL10n->get('SYS_SIZE'), ' ');
$adminTable->addRowHeadingByArray($columnHeading);
// Get folders
if (isset($folderContent['additionalFolders'])) {
for ($i = 0; $i < count($folderContent['additionalFolders']); ++$i) {
$nextFolder = $folderContent['additionalFolders'][$i];
$columnValues = array('<img src="' . THEME_PATH . '/icons/download.png" alt="' . $gL10n->get('SYS_FOLDER') . '" title="' . $gL10n->get('SYS_FOLDER') . '" />', $nextFolder['fol_name'], '', '<a class="admidio-icon-link" href="' . $g_root_path . '/adm_program/modules/downloads/download_function.php?mode=6&folder_id=' . $getFolderId . '&name=' . urlencode($nextFolder['fol_name']) . '">
<img src="' . THEME_PATH . '/icons/database_in.png" alt="' . $gL10n->get('DOW_ADD_TO_DATABASE') . '" title="' . $gL10n->get('DOW_ADD_TO_DATABASE') . '" /></a>');
$adminTable->addRowByArray($columnValues);
}
}
$actualOrganization = 0;
$role = new TableRoles($gDb);
while ($row = $roleStatement->fetch()) {
// if roles of new organization than read the rights of this organization
if ($actualOrganization != $row['org_id']) {
$gCurrentUser->setOrganization($row['org_id']);
$actualOrganization = $row['org_id'];
}
// check if current user has right to view the role of that organization
if ($gCurrentUser->hasRightViewRole($row['rol_id'])) {
$role->clear();
$role->setArray($row);
if (!$showRolesOtherOrganizations) {
$page->addHtml('
<div class="panel panel-default" id="profile_other_orga_roles_box">
<div class="panel-heading">' . $gL10n->get('PRO_ROLE_MEMBERSHIP_OTHER_ORG') . HtmlForm::getHelpTextIcon('PRO_VIEW_ROLES_OTHER_ORGAS') . '
</div>
<div class="panel-body" id="profile_other_orga_roles_box_body">
<ul class="list-group admidio-list-roles-assign">');
$showRolesOtherOrganizations = true;
}
$startDate = new DateTimeExtended($row['mem_begin'], 'Y-m-d');
// jede einzelne Rolle anzeigen
$page->addHtml('
<li class="list-group-item">
<span>' . $row['org_shortname'] . ' - ' . $role->getValue('cat_name') . ' - ' . $role->getValue('rol_name'));
if ($row['mem_leader'] == 1) {
$page->addHtml(' - ' . $gL10n->get('SYS_LEADER'));
}
$page->addHtml('
</span>