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>";
