query("INSERT INTO ".$_SESSION['tablename']['listinstance']." (RES_TABLE, RES_ID, SEQUENCE,
USER_ID, BY_USER_ID, MAIL_ACTION)
VALUES ('".$_SESSION['ressources'][0]['tablename']."', ".$id.", ".$k."
, '".$_SESSION['diff'][$i]['UserID']."', '".$_SESSION['user']['UserId']."',
'".$_SESSION['diff'][$i]['MailAction']."')");
}
*/
/*
$_SESSION["diffusion"]->set_ressource($_SESSION['tablechoice'],$id);
*/
//$_SESSION["diffusion"]->store();
if($_SESSION['history']['resadd'] == true)
{
require_once("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 = preg_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();
if( $res->RELANCE1 != NULL)
$relance1 = "'".$res->RELANCE1."'";
if( $res->RELANCE2 != NULL)
$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'])
{
if( $_SESSION["diffusion"]->get_dest_user() )
$to = $_SESSION["diffusion"]->get_dest_user();
else
$to = $_SESSION["diffusion"]->get_destination();
$hist->add($_SESSION['tablename']['listinstance'], $id , 'DIF', _DOC." n° ".$id." "._SEND." : ".$to." ("._RECIPIENT.")");
foreach(array_slice($_SESSION["diffusion"]->get_diffusion(),1) as $key_diff => $diffusion)
{
if( isset($diffusion["USER"]) )
{
$hist->add($_SESSION['tablename']['listinstance'], $id, 'DIF', _DOC." n° ".$id." "._SEND." : ".$diffusion["USER"]["USER_ID"]." ("._TO_CC.")");
}
else
{
$hist->add($_SESSION['tablename']['listinstance'], $id, 'DIF', _DOC." n° ".$id." "._SEND." : ".$diffusion["USER"]["SERVICE_ID"]." ("._TO_CC.")");
}
}
/*
$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.")");
}
*/
}
unset($_SESSION["diffusion"]);
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' && $_SESSION['courrier']['is_ingoing'] == true)
{
$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'] = '';
$_SESSION['courrier']['domain'] = '';
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."