function updateFileNameInAll($old_name, $new_name) { # nur diese pfade werden unterstüzt # dir/kategorie/CAT # dir/kategorie/CAT/PAGE # dir/kategorie/CAT/dateien/FILE # dir/galerien/GALLERY $oldnew = array("old" => array("url" => array()), "new" => array("url" => array())); # Kategorie Inhaltseite/Datei if (strstr($old_name, "/" . CONTENT_DIR_NAME . "/") and substr($old_name, -EXT_LENGTH) != EXT_LINK) { $old_name = str_replace(CONTENT_DIR_REL, "", $old_name); $new_name = str_replace(CONTENT_DIR_REL, "", $new_name); # es ist eine Datei if (strstr($old_name, "/" . CONTENT_FILES_DIR_NAME . "/")) { $old_name = str_replace("/" . CONTENT_FILES_DIR_NAME . "/", ":", $old_name); $new_name = str_replace("/" . CONTENT_FILES_DIR_NAME . "/", ":", $new_name); $oldnew["old"]["url"][0] = FILE_START . $old_name . FILE_END; $oldnew["new"]["url"][0] = FILE_START . $new_name . FILE_END; # es wurde die Kategorie oder Inhaltseite geändert } else { # es wurde nur die Inhaltseite geändert if (strstr($old_name, "/")) { $old_name = str_replace(array("/", EXT_PAGE, EXT_HIDDEN, EXT_DRAFT), array(":"), $old_name); $new_name = str_replace(array("/", EXT_PAGE, EXT_HIDDEN, EXT_DRAFT), array(":"), $new_name); $oldnew["old"]["url"][0] = FILE_START . $old_name . FILE_END; $oldnew["new"]["url"][0] = FILE_START . $new_name . FILE_END; # es wurde die Kategorie geändert } else { global $CMS_CONF; if ($CMS_CONF->get("defaultcat") == $old_name) { $CMS_CONF->set("defaultcat", $new_name); } $tmp_dir = CONTENT_DIR_REL . $new_name; $oldnew["old"]["url"][0] = FILE_START . $old_name . FILE_END; $oldnew["new"]["url"][0] = FILE_START . $new_name . FILE_END; # alle Inhaltseiten foreach (getDirAsArray($tmp_dir, array(EXT_PAGE, EXT_HIDDEN, EXT_DRAFT)) as $page) { $page = str_replace(array(EXT_PAGE, EXT_HIDDEN, EXT_DRAFT), "", $page); $oldnew["old"]["url"][] = FILE_START . $old_name . ":" . $page . FILE_END; $oldnew["new"]["url"][] = FILE_START . $new_name . ":" . $page . FILE_END; } # alle Dateien foreach (getDirAsArray($tmp_dir . "/" . CONTENT_FILES_DIR_NAME, "file") as $file) { $oldnew["old"]["url"][] = FILE_START . $old_name . ":" . $file . FILE_END; $oldnew["new"]["url"][] = FILE_START . $new_name . ":" . $file . FILE_END; } } } # Gallery } elseif (strstr($old_name, "/" . GALLERIES_DIR_NAME . "/")) { $old_name = str_replace(GALLERIES_DIR_REL, "", $old_name); $new_name = str_replace(GALLERIES_DIR_REL, "", $new_name); $oldnew["old"]["url"][0] = FILE_START . $old_name . FILE_END; $oldnew["new"]["url"][0] = FILE_START . $new_name . FILE_END; } else { return; } $oldnew["old"]["str"] = array_map('rawurldecode', $oldnew["old"]["url"]); $oldnew["new"]["str"] = array_map('rawurldecode', $oldnew["new"]["url"]); # Inhaltseiten foreach (getDirAsArray(CONTENT_DIR_REL, "dir") as $cat) { if (substr($cat, -EXT_LENGTH) == EXT_LINK) { continue; } foreach (getDirAsArray(CONTENT_DIR_REL . $cat, array(EXT_PAGE, EXT_HIDDEN, EXT_DRAFT)) as $page) { updateFileName(CONTENT_DIR_REL . $cat . "/" . $page, $oldnew); } } # alle template.html und gallerytemplate.html dateien foreach (getDirAsArray(BASE_DIR . LAYOUT_DIR_NAME, "dir") as $template_dir) { if (file_exists(BASE_DIR . LAYOUT_DIR_NAME . "/" . $template_dir . "/template.html")) { updateFileName(BASE_DIR . LAYOUT_DIR_NAME . "/" . $template_dir . "/template.html", $oldnew); } if (file_exists(BASE_DIR . LAYOUT_DIR_NAME . "/" . $template_dir . "/gallerytemplate.html")) { updateFileName(BASE_DIR . LAYOUT_DIR_NAME . "/" . $template_dir . "/gallerytemplate.html", $oldnew); } } # Plugins Conf foreach (getDirAsArray(BASE_DIR . PLUGIN_DIR_NAME, "dir") as $plugin_dir) { if (file_exists(BASE_DIR . PLUGIN_DIR_NAME . "/" . $plugin_dir . "/plugin.conf.php")) { changeCatPageInConf(BASE_DIR . PLUGIN_DIR_NAME . "/" . $plugin_dir . "/plugin.conf.php", $oldnew); } } }
$sql = "UPDATE rrhh.rbc_busquedascorporativas SET bc_fechamodif = SYSDATE, bc_fechavigenciadesde = TO_DATE(:fechavigenciadesde, 'DD/MM/YYYY'), bc_fechavigenciahasta = TO_DATE(:fechavigenciahasta, 'DD/MM/YYYY'), bc_idempresa = :idempresa, bc_idestado = :idestado, bc_puesto = :puesto, bc_usumodif = :usumodif WHERE bc_id = :id"; DBExecSql($conn, $sql, $params, OCI_DEFAULT); } if ($_FILES["archivo"]["name"] != "") // Si existe el archivo, lo subo.. if (uploadFile($_FILES["archivo"], DATA_BUSQUEDAS_CORPORATIVAS_PATH, $_POST["id"], $archPath)) updateFileName($_POST["id"], $archPath); else throw new Exception("Ocurrió un error al guardar el archivo."); DBCommit($conn); } catch (Exception $e) { DBRollback($conn); ?> <script language="JavaScript" src="/js/functions.js"></script> <script type='text/javascript'> showError(unescape('<?php echo rawurlencode($e->getMessage()); ?> '), window.parent); </script>
$sql = "SELECT MAX(bi_id) FROM rrhh.rbi_busquedasinternas"; $id = ValorSql($sql, "", array(), 0); $msg = "alert('Se generó la búsqueda interna Nº " . $id . "');"; } if ($_REQUEST["tipoOp"] == "M") { // Modificación.. $id = $_POST["id"]; $sql = "UPDATE rrhh.rbi_busquedasinternas\n\t\t\t\t\tSET bi_cantidadpostulantes = :cantidadpostulantes,\n \t\t\t\t\tbi_designados = :designados,\n \t\t\t\t\tbi_fechamodif = SYSDATE,\n \t\t\t\t\tbi_idestado = :idestado,\n\t\t\t\t\t\t\tbi_puesto = :puesto,\n\t\t\t\t\t \t\tbi_usumodif = :usumodif\n \t\t\t WHERE bi_id = :id"; $params = array(":cantidadpostulantes" => nullIsEmpty($_POST["cantidadPostulantes"]), ":designados" => $_POST["designados"], ":idestado" => $_POST["estado"], ":puesto" => $_POST["puesto"], ":usumodif" => GetWindowsLoginName(true), ":id" => $id); DBExecSql($conn, $sql, $params, OCI_DEFAULT); } if ($_POST["tipoOp"] == "A" or $_POST["tipoOp"] == "M") { if ($_FILES["archivo"]["name"] != "") { // Si existe el archivo, lo subo.. if (uploadFile($_FILES["archivo"], DATA_BUSQUEDAS_INTERNAS_PATH, $id, $archPath)) { updateFileName($id, $archPath); } else { exit; } } } if ($_REQUEST["tipoOp"] == "B") { // Baja.. $sql = "UPDATE rrhh.rbi_busquedasinternas\n\t\t\t\t\tSET bi_fechabaja = SYSDATE,\n\t\t\t\t\t\t\tbi_usubaja = :usubaja\n\t\t\t WHERE bi_id = :id"; $params = array(":usubaja" => GetWindowsLoginName(true), ":id" => $_POST["id"]); DBExecSql($conn, $sql, $params, OCI_DEFAULT); } DBCommit($conn); } catch (Exception $e) { DBRollback($conn); echo "<script>alert(unescape('" . rawurlencode($e->getMessage()) . "'));</script>";