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'); }