// 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';
}
} catch (AdmException $e) {
$e->showText();
$gNavigation->addUrl(CURRENT_URL, $headline);
// UserField-objekt anlegen
$category = new TableCategory($gDb);
if ($getCatId > 0) {
$category->readDataById($getCatId);
// Pruefung, ob die Kategorie zur aktuellen Organisation gehoert bzw. allen verfuegbar ist
if ($category->getValue('cat_org_id') > 0 && $category->getValue('cat_org_id') != $gCurrentOrganization->getValue('org_id')) {
$gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
}
if (isset($_SESSION['categories_request'])) {
// durch fehlerhafte Eingabe ist der User zu diesem Formular zurueckgekehrt
// nun die vorher eingegebenen Inhalte ins Objekt schreiben
$category->setArray($_SESSION['categories_request']);
if (!isset($_SESSION['categories_request']['show_in_several_organizations'])) {
$category->setValue('cat_org_id', $gCurrentOrganization->getValue('org_id'));
}
unset($_SESSION['categories_request']);
}
// create html page object
$page = new HtmlPage($headline);
// add back link to module menu
$categoryCreateMenu = $page->getMenu();
$categoryCreateMenu->addItem('menu_item_back', $gNavigation->getPreviousUrl(), $gL10n->get('SYS_BACK'), 'back.png');
// show form
$form = new HtmlForm('categories_edit_form', $g_root_path . '/adm_program/modules/categories/categories_function.php?cat_id=' . $getCatId . '&type=' . $getType . '&mode=1', $page);
// systemcategories should not be renamed
$fieldPropertyCatName = FIELD_REQUIRED;
if ($category->getValue('cat_system') == 1) {
$fieldPropertyCatName = FIELD_DISABLED;
}
