FROM ' . TBL_CATEGORIES . '
WHERE ( cat_org_id = ' . $gCurrentOrganization->getValue('org_id') . '
OR cat_org_id IS NULL )
AND cat_type = \'' . $getType . '\'
ORDER BY cat_sequence ASC';
$categoryStatement = $gDb->query($sql);
$flagTbodyWritten = false;
$flagTbodyAllOrgasWritten = false;
$category = new TableCategory($gDb);
// Get data
while ($cat_row = $categoryStatement->fetch()) {
$category->clear();
$category->setArray($cat_row);
if ($category->getValue('cat_system') == 1 && $getType === 'USF') {
// da bei USF die Kategorie Stammdaten nicht verschoben werden darf, muss hier ein bischen herumgewurschtelt werden
$categoriesOverview->addTableBody('id', 'cat_' . $category->getValue('cat_id'));
} elseif ($category->getValue('cat_org_id') == 0 && $getType === 'USF') {
// Kategorien über alle Organisationen kommen immer zuerst
if (!$flagTbodyAllOrgasWritten) {
$flagTbodyAllOrgasWritten = true;
$categoriesOverview->addTableBody('id', 'cat_all_orgas');
}
} else {
if (!$flagTbodyWritten) {
$flagTbodyWritten = true;
$categoriesOverview->addTableBody('id', 'cat_list');
}
}
$htmlMoveRow = ' ';
if ($category->getValue('cat_system') == 0 || $getType !== 'USF') {
$htmlMoveRow = '<a class="admidio-icon-link" href="javascript:moveCategory(\'up\', ' . $category->getValue('cat_id') . ')"><img
} elseif ($getMode === 'html' || $getMode === 'print') {
$table->setColumnAlignByArray($columnAlign);
$table->addRowHeadingByArray($columnValues);
} elseif ($getMode === 'pdf') {
$table->setColumnAlignByArray($columnAlign);
$table->addTableHeader();
$table->addRow();
$table->addAttribute('align', 'center');
$table->addColumn($headline, array('colspan' => count($arrValidColumns)));
$table->addRow();
// Write valid column headings
for ($column = 0; $column < count($arrValidColumns); ++$column) {
$table->addColumn($arrValidColumns[$column], array('style' => 'text-align: ' . $columnAlign[$column] . ';font-size:14;background-color:#C7C7C7;'), 'th');
}
} else {
$table->addTableBody();
}
$lastGroupHead = -1;
// Mark for change between leader and member
$listRowNumber = 1;
foreach ($membersList as $member) {
if ($getMode !== 'csv') {
// in print preview and pdf we group the role leaders and the members and
// add a specific header for them
if ($lastGroupHead != $member['mem_leader'] && ($member['mem_leader'] != 0 || $lastGroupHead != -1)) {
if ($member['mem_leader'] == 1) {
$title = $gL10n->get('SYS_LEADERS');
} else {
// if list has leaders then initialize row number for members
$listRowNumber = 1;
$title = $gL10n->get('SYS_PARTICIPANTS');
$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();
$table->addRow('', array('class' => 'admidio-group-heading'));
$table->addColumn('<span id="caret_' . $block_id . '" class="caret"></span>' . $userField->getValue('cat_name'), array('id' => 'group_' . $block_id, 'colspan' => '8'), 'td');
$table->addTableBody('id', $block_id);
$categoryId = $userField->getValue('usf_cat_id');
}
// cut long text strings and provide tooltip
if (strlen($userField->getValue('usf_description')) > 22) {
$description = substr($userField->getValue('usf_description', 'database'), 0, 22) . '
<a data-toggle="modal" data-target="#admidio_modal"
href="' . $g_root_path . '/adm_program/system/msg_window.php?message_id=user_field_description&message_var1=' . $userField->getValue('usf_name_intern') . '&inline=true"><span data-html="true" data-toggle="tooltip" data-original-title="' . str_replace('"', '\'', $userField->getValue('usf_description')) . '">[..]</span></a>';
} elseif ($userField->getValue('usf_description') === '') {
$description = ' ';
} else {
$description = $userField->getValue('usf_description');
}
