. */ /** * @brief Modify a structure * * * @file * @author Claire Figueras * @date $date$ * @version $Revision$ * @ingroup admin */ require "core" . DIRECTORY_SEPARATOR . "class" . DIRECTORY_SEPARATOR . "class_history.php"; $core = new core_tools(); $core->test_admin('admin_architecture', 'apps'); $core->load_lang(); $db = new dbquery(); $db->connect(); $desc = ""; $id = ""; $cssStyle = "default_style"; //$fontColor = '#000000'; // Black by default $foldertypesArr = array(); $folderModuleLoaded = false; if ($core->is_module_loaded('folder') == true) { $folderModuleLoaded = true; } if (isset($_GET['id']) && ! empty($_GET['id'])) { $id = $_GET['id']; $db->query( "select doctypes_first_level_label, css_style from " . $_SESSION['tablename']['doctypes_first_level'] . " where doctypes_first_level_id = " . $id ); $res = $db->fetch_object(); $desc = $db->show_string($res->doctypes_first_level_label); if (isset($res->css_style)) { $cssStyle = $db->show_string($res->css_style); } if ($folderModuleLoaded) { $db->query( 'select ffdl.foldertype_id, f.foldertype_label from ' . $_SESSION['tablename']['fold_foldertypes_doctypes_level1'] . " ffdl, " . $_SESSION['tablename']['fold_foldertypes'] . " f where ffdl.doctypes_first_level_id = " . $id . " and ffdl.foldertype_id = f.foldertype_id" ); //$_SESSION['m_admin']['loaded_foldertypes']= array(); while ($res = $db->fetch_object()) { //array_push($_SESSION['m_admin']['loaded_foldertypes'], $res->foldertype_id); array_push($foldertypesArr, $res->foldertype_id); } } } $mode = ""; if (isset($_REQUEST['mode']) && ! empty($_REQUEST['mode'])) { $mode = $_REQUEST['mode']; $_SESSION['m_admin']['mode'] = $mode; } $erreur = ""; if (isset($_REQUEST['valid'])) { if (isset($_REQUEST['desc_structure']) && ! empty($_REQUEST['desc_structure']) ) { $desc = $db->protect_string_db($_REQUEST['desc_structure']); } else { $erreur .= _DESC_STRUCTURE_MISSING . ".
"; } if (isset($_REQUEST['css_style']) && !empty($_REQUEST['css_style'])) { $cssStyle = $db->protect_string_db($_REQUEST['css_style']); } else { $erreur .= _FONT_COLOR. ' ' . _MISSING . '.
'; } if ($folderModuleLoaded) { if (! isset($_REQUEST['foldertypes']) || count($_REQUEST['foldertypes']) == 0 ) { $erreur .= _FOLDERTYPE_MISSING . ".
"; } } if (empty($erreur)) { $db->connect(); $db->query( "select * from ".$_SESSION['tablename']['doctypes_first_level'] . " where doctypes_first_level_label = '" . $desc . "' and enabled = 'Y'" ); if ($db->nb_result() > 0 && $mode <> 'up') { $erreur .= _THE_STRUCTURE . ' ' . _ALREADY_EXISTS . "."; } else { if ($mode == "up") { $db->connect(); if (isset($_REQUEST['ID_structure']) && ! empty($_REQUEST['ID_structure']) ) { $id = $_REQUEST['ID_structure']; $db->query( "UPDATE " . $_SESSION['tablename']['doctypes_first_level'] . " set doctypes_first_level_label = '" . $desc . "', css_style = '" . $cssStyle. "' " . "WHERE doctypes_first_level_id = " . $id ); if ($folderModuleLoaded) { $db->query( "delete from " . $_SESSION['tablename']['fold_foldertypes_doctypes_level1'] . " where doctypes_first_level_id = " . $id . "" ); for ($i = 0; $i < count($_REQUEST['foldertypes']); $i ++) { $db->query( "insert into " . $_SESSION['tablename']['fold_foldertypes_doctypes_level1'] . " values (" . $_REQUEST['foldertypes'][$i] . ", " . $id . ")" ); } } if ($_SESSION['history']['structureup'] == "true") { $hist = new history(); $hist->add( $_SESSION['tablename']['doctypes_first_level'], $id, "UP", _STRUCTURE_MODIF . " " . strtolower(_NUM) . $id . " (" . $info . ")", $_SESSION['config']['databasetype'] ); } $_SESSION['error'] .= _STRUCTURE_MODIF . " : " . $id . "
"; } else { $erreur .= _ID_STRUCTURE_PB . "."; } } else { $db->connect(); $desc = $db->protect_string_db($_REQUEST['desc_structure']); $db->query( "INSERT INTO " . $_SESSION['tablename']['doctypes_first_level'] . " ( doctypes_first_level_label, css_style) VALUES ( '" . $desc . "', '" . $cssStyle . "')" ); $db->query( "select doctypes_first_level_id from " . $_SESSION['tablename']['doctypes_first_level'] . " where doctypes_first_level_label = '" . $desc . "'" ); $res = $db->fetch_object(); $id = $res->doctypes_first_level_id; if ($folderModuleLoaded) { for ($i = 0; $i < count($_REQUEST['foldertypes']); $i ++) { $db->query( "insert into " . $_SESSION['tablename']['fold_foldertypes_doctypes_level1'] . " values (" . $_REQUEST['foldertypes'][$i] . ", " . $id . ")" ); } } if ($_SESSION['history']['structureadd'] == "true") { $hist = new history(); $hist->add( $_SESSION['tablename']['doctypes_first_level'], $id, "ADD", _NEW_STRUCTURE_ADDED . " (" . $desc . ")", $_SESSION['config']['databasetype'] ); } $_SESSION['error'] .= _NEW_STRUCTURE . " : " . $desc . "
"; } } } if (empty($erreur)) { unset($_SESSION['m_admin']); ?> false) { foreach ($xml->color as $color) { array_push( $fontColors, array( 'id' => (string) $color->id, 'label' => (string) $color->label, ) ); } } array_push( $fontColors, array( 'id' => '#000000', 'label' => _BLACK, ) ); function cmpColors($a, $b) { return strcmp(strtolower($a['label']), strtolower($b['label'])); } usort($fontColors, 'cmpColors'); */ $core->load_html(); if ($mode == "up") { $title = _STRUCTURE_MODIF; } else { $title = _NEW_STRUCTURE_ADDED; } $core->load_header($title, true, false); $time = $core->get_session_time_expire(); ?>

load_js();?>