}
// falls eine Kategorie von allen Orgas auf eine Bestimmte umgesetzt wurde oder anders herum,
// dann muss die Sequenz fuer den alle Kategorien dieses Typs neu gesetzt werden
if (isset($_POST['cat_org_id']) && $_POST['cat_org_id'] != $cat_org_merker) {
$sequenceCategory = new TableCategory($gDb);
$sequence = 0;
$sql = 'SELECT *
FROM ' . TBL_CATEGORIES . '
WHERE cat_type = "' . $getType . '"
AND ( cat_org_id = ' . $gCurrentOrganization->getValue('org_id') . '
OR cat_org_id IS NULL )
ORDER BY cat_org_id ASC, cat_sequence ASC';
$categoriesStatement = $gDb->query($sql);
while ($row = $categoriesStatement->fetch()) {
++$sequence;
$sequenceCategory->clear();
$sequenceCategory->setArray($row);
$sequenceCategory->setValue('cat_sequence', $sequence);
$sequenceCategory->save();
}
}
$gNavigation->deleteLastUrl();
unset($_SESSION['categories_request']);
header('Location: ' . $gNavigation->getUrl());
exit;
} elseif ($getMode === 2) {
// delete category
try {
if ($category->delete()) {
echo 'done';
}
$columnHeading = array($gL10n->get('SYS_TITLE'), ' ', $htmlIconLoginUser, '<img class="admidio-icon-info" src="' . THEME_PATH . '/icons/star.png" alt="' . $gL10n->get('CAT_DEFAULT_VAR', $getTitle) . '" title="' . $gL10n->get('CAT_DEFAULT_VAR', $getTitle) . '" />', ' ');
$categoriesOverview->setColumnAlignByArray(array('left', 'left', 'left', 'left', 'right'));
$categoriesOverview->addRowHeadingByArray($columnHeading);
$sql = 'SELECT *
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');
}
