query("INSERT INTO ".$_SESSION['tablename']['listinstance']." (RES_TABLE, RES_ID, SEQUENCE,
USER_ID)
VALUES ('".$_SESSION['ressources'][0]['tablename']."', ".$id.", ".$k."
, '".$_SESSION['diff'][$i]['UserID']."')");
}
if($_SESSION['history']['resadd'] == true)
{
require("class_history.php");
$users = new history();
if($_SESSION['courrier']["is_ingoing"])
{
$mes = _NEW_INGOING_DOC." (".$type.") ";
}
else
{
$mes = _NEW_ONGOING_DOC." (".$type.") ";
}
$users->add($_SESSION['tablechoice'], $id ,"ADD", $mes);
if($is_folder =='N')
{
if($_SESSION['courrier']["is_ingoing"])
{
$mes = _NEW_INGOING_DOC." (".$id.") "._ADDED_TO_FOLDER.$folder_id;
}
else
{
$mes = _NEW_ONGOING_DOC." (".$type.") "._ADDED_TO_FOLDER.$folder_id;
}
$users->add($_SESSION['tablechoice'], $folder_id ,"ADD", $mes);
}
}
//$_SESSION['FILE']['taille_fichier'] = $_FILES['file']['size'];
$conn->query("SELECT PATH_TEMPLATE FROM ".$_SESSION['tablename']['docservers']." WHERE DOCSERVER_ID='".$docserver_id."'");
// $conn->show();
$res = $conn->fetch_object();
$md5fichier = "";
$md5fichier = $res->PATH_TEMPLATE;
$conn->query("SELECT RES_ID as ID, PATH, FILENAME, CREATION_DATE FROM ".$_SESSION['tablechoice']." WHERE RES_ID = ".$id);
//$conn->show();
$res = $conn->fetch_object();
$tmp = $res->PATH;
$dateenr = $res->CREATION_DATE;
$id = $res->ID;
/*if ($_SESSION['config']['system'] == "true")
{
$tmp = str_replace('#','/',$tmp);
}
else
{
$tmp = str_replace('#','\\',$tmp);
}*/
$tmp = str_replace('#',DIRECTORY_SEPARATOR,$tmp);
$md5fichier .= $tmp;
$filename = $res->FILENAME;
$extemp = strtolower(substr($filename, -4));
$filename = ereg_replace("[.A-Z]{4}$",$extemp, $filename);
$md5fichier .= $filename;
$md5 = md5_file($md5fichier);
// courrier arrivé
if($_SESSION['courrier']["is_ingoing"])
{
$conn2 = new dbquery();
$conn2->connect();
$conn2->query("select TYPE_ID, ADDDATE('".$dateenr."', INTERVAL DELAI_RELANCE1 DAY) as RELANCE1, ADDDATE('".$date_limite."', INTERVAL DELAI_RELANCE2 DAY) as RELANCE2 from ".$_SESSION['tablename']['doctypes']." where TYPE_ID = '".$_SESSION['courrier']['type_courrier']."' and RES_TABLE = '".$_SESSION['tablechoice']."'");
//$conn->show();
if($conn2->nb_result() == 0)
{
$_SESSION['error']= _DOCTYPE." "._UNKNOWN;
header("location: enregistrement_doc.php");
exit;
}
else
{
$res = $conn2->fetch_object();
$relance1 = $res->RELANCE1;
$relance2 = $res->RELANCE2;
}
$conn->query("UPDATE ".$_SESSION['tablechoice']." SET FINGERPRINT='".$md5."', CUSTOM_D4 = '".$relance1."', CUSTOM_D5 = '".$relance2."' WHERE RES_ID = ".$id);
}
// courrier départ
else
{
$conn->query("UPDATE ".$_SESSION['tablechoice']." SET FINGERPRINT='".$md5."' WHERE RES_ID = ".$id);
}
if($action == "diff " && $_SESSION['history']['diffusion'])
{
$hist->add($_SESSION['tablename']['listinstance'], $id , 'DIF', _DOC." n° ".$id." "._SEND." : ".$_SESSION['diff'][0]['UserID']." ("._RECIPIENT.")");
for($i=1; $i < count($_SESSION['diff']); $i++)
{
$hist->add($_SESSION['tablename']['listinstance'], $id, 'DIF', _DOC." n° ".$id." "._SEND." : ".$_SESSION['diff'][$i]['UserID']." ("._TO_CC.")");
}
}
if(file_exists($_SESSION['config']['tmpdir'].'\tmp_file_'.$_SESSION['user']['UserId'].'.'.$the_ext))
{
unlink($_SESSION['config']['tmpdir'].'\tmp_file_'.$_SESSION['user']['UserId'].'.'.$the_ext);
}
$_SESSION['indexation'] = true;
// $_SESSION['diff'] = array();
$_SESSION['FILE'] = array();
if($is_folder =='N')
{
$id = $folder_id;
}
if ($_SESSION['courrier']['chk_date_limite'] == 'N')
{
$conn->query("UPDATE ".$_SESSION['tablechoice']." SET CUSTOM_D2=NULL, CUSTOM_D4=NULL, CUSTOM_D5=NULL WHERE RES_ID = ".$id);
}
$_SESSION['indexation_id'] = $id;
$_SESSION['courrier']['objet'] = '';
$_SESSION['courrier']['emetteur'] = '';
$_SESSION['courrier']['nom'] = '';
$_SESSION['courrier']['prenom'] = '';
$_SESSION['courrier']['civ'] ='';
$_SESSION['courrier']['emetteur_societe']= '';
$_SESSION['courrier']['emetteur_name']= '';
$_SESSION['courrier']['emetteur_prenom']= '';
$_SESSION['courrier']['emetteur_fonction']= '';
//$_SESSION['courrier']["service"] = '';
$_SESSION['courrier']['index_sender_liste'] = '';
$_SESSION['courrier']['sender_nom'] = '';
$_SESSION['courrier']['sender_prenom'] = '';
$_SESSION['courrier']['sender_civilite'] = '';
$_SESSION['courrier']['sender_society'] = '';
$_SESSION['courrier']['sender_function'] = '';
unset ($_SESSION['courrier']['entity']);
unset ($_SESSION['courrier']['id_expediteur']);
?>
"._MAIL_TO_PROCESS."
"._HELLO.",
"._NEED_PROCESS_LETTER." :
- "._LETTER_N."".$id." "._TO_TYPE." ".$type." ("._OBJECT." : ".$objet.") "._RECEIVE_THE." ".$date." "._RECEIVE_FROM." ".$emetteur." "._LIMIT_PROCESS." ".$date_limite." :
"._ACCESS_MAIL_TO_PROCESS."