*/
include("session.php");
require_once("class_functions.php");
require_once("class_db.php");
if(file_exists($_SESSION['config']['lang'].'.php'))
{
include($_SESSION['config']['lang'].'.php');
}
else
{
$_SESSION['error'] = "Language file missing...
";
}
if(isset($_POST['yes']))
{
$db = new dbquery();
$db->connect();
//rattachement des notes
$db->query("UPDATE ".$_SESSION['tablename']['notes']." SET RECORD_ID = '".$_SESSION['doc_to_update']."' WHERE RECORD_ID = '".$_SESSION['doc_to_attach']."'");
//Mise à jour de l'historique
if($_SESSION['history']['notesattach'])
{
require_once("class_history.php");
$hist = new history();
$hist->add($_SESSION['tablechoice'], $_SESSION['doc_to_update'], "UP", _NOTE_ATTACH ." (".$_SESSION['doc_to_attach'].") " ._ADDED_TO_FOLDER ." ".$_SESSION['doc_to_update']);
}
//rattachement des reponses
$db->query("UPDATE ".$_SESSION['tablechoice']." SET RELATION = '".$_SESSION['doc_to_update']."', IS_FOLDER = 'N' WHERE RELATION = '".$_SESSION['doc_to_attach']."'");
//Mise à jour de l'historique
if($_SESSION['history']['resup'])
{
require_once("class_history.php");
$hist = new history();
$hist->add($_SESSION['tablechoice'], $_SESSION['doc_to_update'], "UP", _ATTACHED_ANSWERS ." (".$_SESSION['doc_to_attach'].") " ._ADDED_TO_FOLDER ." ".$_SESSION['doc_to_update']);
}
//rattachement de l'affaire
$db->query("UPDATE ".$_SESSION['tablechoice']." SET FOLDER_ID = '".$_SESSION['doc_to_update']."', IS_FOLDER = 'N' WHERE RES_ID = '".$_SESSION['doc_to_attach']."'");
//Mise à jour de l'historique
if($_SESSION['history']['resup'])
{
require_once("class_history.php");
$hist = new history();
$hist->add($_SESSION['tablechoice'], $_SESSION['doc_to_update'], "UP", _ATTACHED_FOLDERS ." (".$_SESSION['doc_to_attach'].") " ._ADDED_TO_FOLDER ." ".$_SESSION['doc_to_update']);
}
//Liste Instance
$db->query("SELECT MAX(SEQUENCE) AS NBR FROM ".$_SESSION['tablename']['listinstance']." WHERE RES_ID = '".$_SESSION['doc_to_update']."' ");
$max = $db->fetch_object();
$db->query("SELECT * FROM ".$_SESSION['tablename']['listinstance']." WHERE RES_ID = '".$_SESSION['doc_to_attach']."' AND USER_ID NOT IN (SELECT USER_ID FROM ".$_SESSION['tablename']['listinstance']." WHERE RES_ID = '".$_SESSION['doc_to_update']."') ");
$i = 1;
$db2 = new dbquery();
$db2->connect();
$db2->query("DELETE FROM ".$_SESSION['tablename']['listinstance']." WHERE RES_ID = '".$_SESSION['doc_to_attach']."' ");
while($line = $db->fetch_object()){
$sequence = $max->NBR + $i;
$i++;
$db2->query("INSERT INTO ".$_SESSION['tablename']['listinstance']." (RES_TABLE, RES_ID, SEQUENCE, USER_ID, VIEWED, BY_USER_ID) VALUE ('".$line->RES_TABLE."', '".$_SESSION['doc_to_update']."', '".$sequence."', '".$line->USER_ID."', '".$line->VIEWED."', '".$_SESSION['user']['UserId']."') ");
}
$db->query("DELETE FROM ".$_SESSION['tablename']['listinstance']." WHERE RES_ID = '".$_SESSION['doc_to_attach']."' ");
$_SESSION['info'] = _DOC_ATTACH_SUCCELY;
?>
connect();
//rattachement des notes
$db->query("UPDATE ".$_SESSION['tablename']['notes']." SET RECORD_ID = '".$_SESSION['doc_to_update']."' WHERE RECORD_ID = '".$_SESSION['doc_to_attach']."'");
//Mise à jour de l'historique
if($_SESSION['history']['notesattach'])
{
require_once("class_history.php");
$hist = new history();
$hist->add($_SESSION['tablechoice'], $_SESSION['doc_to_update'], "UP", _NOTE_ATTACH ." (".$_SESSION['doc_to_attach'].") " ._ADDED_TO_FOLDER ." ".$_SESSION['doc_to_update'] );
}
//rattachement des reponses
$db->query("UPDATE ".$_SESSION['tablechoice']." SET RELATION = '".$_SESSION['doc_to_update']."', IS_FOLDER = 'N' WHERE RELATION = '".$_SESSION['doc_to_attach']."'");
//Mise à jour de l'historique
if($_SESSION['history']['resup'])
{
require_once("class_history.php");
$hist = new history();
$hist->add($_SESSION['tablechoice'], $_SESSION['doc_to_update'], "UP", _ATTACHED_ANSWERS ." (".$_SESSION['doc_to_attach'].") " ._ADDED_TO_FOLDER ." ".$_SESSION['doc_to_update']);
}
//rattachement de l'affaire
$db->query("UPDATE ".$_SESSION['tablechoice']." SET FOLDER_ID = '".$_SESSION['doc_to_update']."', IS_FOLDER = 'N' WHERE RES_ID = '".$_SESSION['doc_to_attach']."'");
//Mise à jour de l'historique
if($_SESSION['history']['resup'])
{
require_once("class_history.php");
$hist = new history();
$hist->add($_SESSION['tablechoice'], $_SESSION['doc_to_update'], "UP", _ATTACHED_ANSWERS ." (".$_SESSION['doc_to_attach'].") " ._ADDED_TO_FOLDER ." ".$_SESSION['doc_to_update']);
}
//Liste Instance
$db->query("DELETE FROM ".$_SESSION['tablename']['listinstance']." WHERE RES_ID = '".$_SESSION['doc_to_attach']."' ");
$_SESSION['info'] = _DOC_ATTACH_SUCCELY;
?>
<?php echo $_SESSION['config']['applicationname']; ?>