*/ session_name('LetterBox2');
session_start();
require("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...
";
}
$_SESSION['origin'] = "validation";
$_SESSION["popup_suite"] = false;
$_SESSION['change_model'] = false;
if(isset($_GET['id']))
{
$s_id = $_GET['id'];
}
else
{
$s_id = "";
}
//$s_id = $_GET['id'];
$func = new functions();
$_SESSION['courrier'] = array();
$_SESSION['courrier']['new_folder'] = TRUE;
//$_SESSION['courrier']["is_ingoing"]= TRUE;
if(isset($_GET['id']) && !empty($_GET['id']))
{
$table = "res_x";
$db = new dbquery();
$db->connect();
$db->query("select date_format(DOC_DATE, '%d') as DOC_DAY, date_format(DOC_DATE, '%m') as DOC_MONTH, year(DOC_DATE) as DOC_YEAR, date_format(CREATION_DATE, '%d') as ARRIVEE_DAY, date_format(CREATION_DATE, '%m') as ARRIVEE_MONTH, year(CREATION_DATE) as ARRIVEE_YEAR, CUSTOM_T3, AUTHOR, CUSTOM_T4, CUSTOM_T2, DESCRIPTION, date(CUSTOM_D2) as LIM, TYPE_ID, DESTINATION, IDENTIFIER, PRIORITY, FORMAT, SOCIETE, IS_INGOING from ".$table." where RES_ID = ".$_GET['id']);
//$db->show();
$line = $db->fetch_object();
$_SESSION['courrier']['id'] = $_GET['id'];
$_SESSION['courrier']['jour_courrier'] = $line->DOC_DAY;
$_SESSION['courrier']['mois_courrier'] = $line->DOC_MONTH;
$_SESSION['courrier']['annee_courrier'] = $line->DOC_YEAR;
$_SESSION['courrier']['jour_arrivee'] = $line->ARRIVEE_DAY;
$_SESSION['courrier']['mois_arrivee'] = $line->ARRIVEE_MONTH;
$_SESSION['courrier']['annee_arrivee'] = $line->ARRIVEE_YEAR;
$_SESSION['courrier']['civ'] = $line->CUSTOM_T3;
$_SESSION['courrier']['nom'] = $line->AUTHOR;
$_SESSION['courrier']['prenom'] = $line->CUSTOM_T4;
$_SESSION['courrier']['nature'] = $line->CUSTOM_T2;
$_SESSION['courrier']['societe'] = $line->SOCIETE;
$_SESSION['courrier']['objet'] = stripslashes($line->DESCRIPTION);
$_SESSION['courrier']["date_limite"] = $db->inverse_date($line->LIM);
$_SESSION['courrier']['type_courrier'] = $line->TYPE_ID;
$_SESSION['courrier']['service'] = $line->DESTINATION;
$_SESSION['courrier']['identifier'] = $line->IDENTIFIER;
$_SESSION['courrier']['prio'] = $line->PRIORITY;
$_SESSION['courrier']['format'] = $line->FORMAT;
if($line->IS_INGOING == 'Y')
{
$_SESSION['courrier']["is_ingoing"]= TRUE;
}
else
{
$_SESSION['courrier']["is_ingoing"]= FALSE;
}
$is_emetteur = false;
if(!empty($_SESSION['courrier']['nom']))
{
for($i=0; $i < count($_SESSION['emetteur']); $i++)
{
if($_SESSION['emetteur'][$i]['NOM'] == $_SESSION['courrier']['nom'])
{
$is_emetteur = true;
break;
}
}
}
$doctypes = array();
if($_SESSION['courrier']['format'] == 'MAARCH')
{
$query = "select TYPE_ID, DESCRIPTION from ".$_SESSION['tablename']['doctypes']." where GENERATE = 'Y' and ENABLED = 'Y'";
}
else
{
$query = "select TYPE_ID, DESCRIPTION from ".$_SESSION['tablename']['doctypes']." where GENERATE = 'N' and ENABLED = 'Y'";
}
$db->query($query);
while($res = $db->fetch_object())
{
array_push($doctypes, array('ID' => $res->TYPE_ID, 'LABEL' => $res->DESCRIPTION));
}
}
else
{
$_SESSION['error'] = _ID.' '._MISSING;
}
?>
<? echo _MAIL_VALIDATION;?>
show_array($_COOKIE);
?>
show_array($_POST);
?>
show_array($_SESSION);
?>