CONFIG as $CONFIG)
{
$_SESSION['config']['databaseserver'] = utf8_decode((string) $CONFIG->databaseserver);
$_SESSION['config']['databasename'] = utf8_decode((string) $CONFIG->databasename);
$_SESSION['config']['databaseuser'] = utf8_decode((string) $CONFIG->databaseuser);
$_SESSION['config']['databasepassword'] = utf8_decode((string) $CONFIG->databasepassword);
$_SESSION['config']['lang'] = utf8_decode((string) $CONFIG->lang);
$_SESSION['config']['mail'] = utf8_decode((string) $CONFIG->mailfrom);
$_SESSION['config']['debug'] = utf8_decode((string) $CONFIG->debug);
$_SESSION['config']['Unix'] = utf8_decode((string) $CONFIG->UNIXserver);
$_SESSION['config']['MaarchDirectory'] = utf8_decode((string) $CONFIG->MaarchDirectory);
$_SESSION['config']['MaarchURL'] = utf8_decode((string) $CONFIG->MaarchURL);
}
$i=0;
foreach($xmlconfig->RESOURCES as $RESOURCES)
{
$_SESSION['ressources'][$i] = array("tablename" => utf8_decode((string) $RESOURCES->tablename),
"comment" => utf8_decode((string) $RESOURCES->comment),
);
$i++;
}
$table = $_SESSION['ressources'][0]['tablename'];
foreach($xmlconfig->TABLENAME as $TABLENAME)
{
$_SESSION['tablename']['doctypes'] = utf8_decode((string) $TABLENAME->doctypes);
$_SESSION['tablename']['history'] = utf8_decode((string) $TABLENAME->history);
$_SESSION['tablename']['listinstance'] = utf8_decode((string) $TABLENAME->listinstance);
$_SESSION['tablename']['users'] = utf8_decode((string) $TABLENAME->users);
$_SESSION['tablename']['user_abs'] = utf8_decode((string) $TABLENAME->user_abs);
$_SESSION['tablename']['services'] = utf8_decode((string) $TABLENAME->services);
}
include("fr.php");
/*if(file_exists($_SESSION['config']['lang'].'.php'))
{
include($_SESSION['config']['lang'].'.php');
}
else
{
$_SESSION['error'] = "Language file missing...
";
}*/
//notification des courriers crées dans la journée.
//Les utilisateurs sont ainsi au courant des documents indexés dans la journée.
//Envoi de la notification à 18H il est donc important dans la requete de verifier les mails de la veille apres 18h...
require_once($_SESSION['config']['MaarchDirectory']."class_functions.php");
require_once($_SESSION['config']['MaarchDirectory']."class_db.php");
$func = new functions();
$db = new dbquery();
$db->connect();
$db2 = new dbquery();
$db2->connect();
$db->query("SELECT DISTINCT USER_ID, MAIL, LASTNAME, FIRSTNAME FROM ".$_SESSION['tablename']['users']." where ENABLED = 'Y'");
$datedujour=date("Y-m-d") ;
$datedujourfr=date("d-m-Y") ;
$date = Array('annee'=>date('Y'), 'mois'=>date('m'), 'jour'=>date('d'));
$N = -1;
$time = mktime(00, 00, 00, $date['mois'], $date['jour']+$N, $date['annee']);
$dansNjours = date('Y-m-d', $time);
$dansNjours = str_replace("-", "", $dansNjours );
$time18= "22:00:00";
$date = $dansNjours.$time18;
$date = str_replace(":", "", $date);
$users = array();
$the_res = array();
while($res = $db->fetch_object())
{
//on vérifie que l'user n'est pas absent
$db2->query("select u.MAIL, ua.NEW_USER from ".$_SESSION['tablename']['users']." u, ".$_SESSION['tablename']['user_abs']." ua where u.USER_ID = ua.NEW_USER and ua.USER_ABS = '".$res->USER_ID."'");
if($db2->nb_result() < 1)
{
array_push($users, array( 'ID' => $res->USER_ID, 'MAIL' => $res->MAIL, 'NOM' => $res->LASTNAME, 'PRENOM' => $res->FIRSTNAME,'IS_ABS' => false));
}
else
{
$res2 = $db2->fetch_object();
array_push($users, array( 'ID' => $res->USER_ID, 'MAIL' => $res->MAIL, 'NOM' => $res->LASTNAME, 'PRENOM' => $res->FIRSTNAME, 'IS_ABS' => true, 'MAIL_ACTIF' => $res2->MAIL, 'ID_ACTIF' => $res2->NEW_USER));
}
}
if($_SESSION['config']['debug'] == "true")
{
//print_r($users);
//echo "\n";
}
for($i=0; $i < count($users); $i++)
{
$db->query("select l.SEQUENCE, r.CUSTOM_T3, r.AUTHOR, r.CUSTOM_T4, r.DESTINATION, r.TYPE_ID, r.DESCRIPTION, date_format(date(r.CUSTOM_D2), '%d-%m-%Y') as DATE_LIM, r.DEST_USER, r.RES_ID, date_format(date(r.CREATION_DATE), '%d-%m-%Y') as DATE_CREA from ".$table." r, ".$_SESSION['tablename']['listinstance']." l where
r.RES_ID=l.RES_ID and l.USER_ID='".$users[$i]['ID']."' AND r.CREATION_DATE > ".$date." and r.FLAG_NOTIF = 'N' and r.status <> 'END' and r.status <> 'VAL'");
if($_SESSION['config']['debug'] == "true")
{
$db->show();
echo "\n nb resultat : ".$db->nb_result()."\n";
}
if($db->nb_result() > 0)
{
if($users[$i]['IS_ABS'])
{
$mail_trait = "
"._MAIL_TO_PROCESS." "._OF." ".$datedujourfr." (".$users[$i]['NOM']." ".$users[$i]['PRENOM'].")
"._HELLO.", "._LIST_OF_MAIL_TO_PROCESS." "._OF." ".$users[$i]['NOM']." ".$users[$i]['PRENOM']." :
";
}
else
{
$mail_trait = "
"._MAIL_TO_PROCESS." "._OF." ".$datedujourfr."
"._HELLO.", "._LIST_OF_MAIL_TO_PROCESS." :
";
}
//#339933 : vert bezons
$mail_copies = "
"._MAIL_COPIES_TO." ".$datedujourfr."
"._HELLO.", "._MAIL_COPIES_LIST." :
";
$res_copies = "";
$res_trait = "";
while($res = $db->fetch_object())
{
//mail en copie
if($res->SEQUENCE > 1)
{
$nom = "";
$db2 ->query("select LASTNAME, FIRSTNAME from ".$_SESSION['tablename']['users']." where USER_ID = '".$res->DEST_USER."'");
$res2 = $db2->fetch_object();
$nom = $res2->FIRSTNAME." ".$res2->LASTNAME;
$res_copies .= "- "._THE_MAIL_NUM.$res->RES_ID." "._OF_TYPE." ".$res->TYPE_ID." ("._OBJECT." : ".$res->DESCRIPTION.") "._RECEIVED_THE." ".$res->DATE_CREA." "._SEND_BY." ".$res->CUSTOM_T3." ".$res->AUTHOR." ".$res->CUSTOM_T4." "._WAS_SENT_TO." ".$nom." Service (".$res->DESTINATION.") "._WHO_MUST_PROCESS_BEFORE." ".$res->DATE_LIM." :
RES_ID."' >"._SEE_MAIL."
";
array_push($the_res, $res->RES_ID);
}
// mail traitement
else if($res->SEQUENCE == 1)
{
$res_trait .= "- "._THE_MAIL_NUM.$res->RES_ID." "._OF_TYPE." ".$res->TYPE_ID." ("._OBJECT." : ".$res->DESCRIPTION.") "._RECEIVED_THE." ".$res->DATE_CREA." "._SEND_BY." ".$res->CUSTOM_T3." ".$res->AUTHOR." ".$res->CUSTOM_T4." "._MUST_BE_PROCESSED_BEFORE." ".$res->DATE_LIM." Service (".$res->DESTINATION.") : ";
// RES_ID."' >
$res_trait .= ""._ACCESS_TO_MAIL_TO_PROCESS."
";
array_push($the_res, $res->RES_ID);
}
}
if(!empty($res_trait))
{
$mail_trait .= $res_trait."
"._ORIGINAL_PAPERS_ALREADY_SEND.". ("._WARNING." : "._YOU_MUST_BE_LOGGED.".)
";
if($users[$i]['IS_ABS'])
{
$mail = $users[$i]['MAIL_ACTIF'];
}
else
{
$mail = $users[$i]['MAIL'];
}
if($_SESSION['config']['debug'] == "true")
{
$msg = "\nUser : ".$users[$i]['NOM']." ".$users[$i]['PRENOM']."\nMail : ".$mail."\nMail traitement : \n".$mail_trait."\n";
echo $msg;
}
if (mail($users[$i]['MAIL'], _MAIL_TO_PROCESS_LIST, $mail_trait , "From: ".$_SESSION['config']['mail']."\nReply-To: ".$_SESSION['config']['mail']." \nContent-Type: text/html; charset=\"iso-8859-1\"\n"))
{
for ($z=0; $z< count($the_res_mail); $z++)
{
$db->query("UPDATE res_x set FLAG_NOTIF = 'Y' where RES_ID= '".$the_res_mail[$z]."'");
}
}
else
{
echo _MAIL_NO_SENDED;
}
}
if(!empty($res_copies))
{
$mail_copies .= $res_copies."
("._WARNING." : "._YOU_MUST_BE_LOGGED.".)
";
if($_SESSION['config']['debug'] == "true")
{
$msg = "\nUser : ".$users[$i]['NOM']." ".$users[$i]['PRENOM']."\nMail : ".$users[$i]['MAIL']."\nMail copies : \n".$mail_copies."\n";
echo $msg;
}
if (mail($users[$i]['MAIL'], _COPIES_MAIL_LIST, $mail_copies , "From: ".$_SESSION['config']['mail']."\r\nReply-To: ".$_SESSION['config']['mail']." \nContent-Type: text/html; charset=\"iso-8859-1\"\n"))
{
for ($z=0; $zquery("UPDATE res_x set FLAG_NOTIF = 'Y' where RES_ID= '".$the_res[$z]."'");
}
}
else
{
echo _MAIL_NO_SENDED;
}
}
}
}
}
?>