<?php echo _MAIL_VALIDATION;?>

* @author Loīc Vinet */ // $table_prefix = "pre_val_"; $table_suffix = "post_val_"; require("class_functions.php"); require_once("class_db.php"); require_once("class_diffusion.php"); include("session.php"); require_once("class_letterbox.php"); require_once("class_domains.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; unset($_SESSION['new_emet']); unset($_SESSION['new_exp']); unset($_SESSION['emet_id']); unset($_SESSION['exp_id']); 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; $db = new dbquery(); $db->connect(); //Analyse les posts // if( isset($_POST) && count($_POST) > 0 ) { if( $_POST['delete'] ) { $db->query("DELETE FROM ".$table_prefix."res_x WHERE res_id = '".$_GET['id']."'"); $db->query("DELETE FROM ".$table_prefix."listinstance WHERE res_id = '".$_GET['id']."'"); $db->query("DELETE FROM ".$table_prefix."notes WHERE record_id = '".$_GET['id']."'"); $db->query("DELETE FROM ".$table_suffix."res_x WHERE res_id = '".$_GET['id']."'"); $db->query("DELETE FROM ".$table_suffix."listinstance WHERE res_id = '".$_GET['id']."'"); $db->query("DELETE FROM ".$table_suffix."notes WHERE record_id = '".$_GET['id']."'"); ?> release($_GET['id'],$table_prefix."res_x"); ?> 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, DEST_USER, DESTINATION, IDENTIFIER, date_format(custom_d2, '%d') as DAY_LIM , date_format(custom_d2, '%m') as MONTH_LIM ,year(custom_d2) as YEAR_LIM , PRIORITY, FORMAT, SOCIETE, IS_INGOING, COLL_ID, WAIT_ACTION, SENDER_ID, CUSTOM_T9, CUSTOM_T10, CUSTOM_T11, CUSTOM_T12, CUSTOM_T13, COVERAGE FROM ".$table."res_x where RES_ID = ".$id); //$db->show(); $line = $db->fetch_object(); $session['courrier']['id'] = $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']['type_courrier'] = $line->TYPE_ID; $session['courrier']['service'] = $line->DESTINATION; $session['courrier']['dest_user'] = $line->DEST_USER; $session['courrier']['identifier'] = $line->IDENTIFIER; $session['courrier']['prio'] = $line->PRIORITY; $session['courrier']['format'] = $line->FORMAT; $session['courrier']["entity"] = $line->COLL_ID; $session['courrier']["wait_action"] = $line->WAIT_ACTION; $session['courrier']["domain"] = $line->COVERAGE; if($line->LIM != NULL ) { $session['courrier']["jour_limite"] = $line->DAY_LIM; $session['courrier']["mois_limite"] = $line->MONTH_LIM; $session['courrier']["annee_limite"] = $line->YEAR_LIM; $session['courrier']["date_limite"] = $db->inverse_date($line->LIM); $session['courrier']['chk_date_limite'] = 'Y'; } else { $session['courrier']['chk_date_limite'] = 'N'; } if($line->IS_INGOING == 'Y') { $session['courrier']["is_ingoing"]= TRUE; //Emetteur if($line->SENDER_ID != 0) { $session['emet_id'] = $line->SENDER_ID; } else { $session['new_emet']['LASTNAME'] = $line->AUTHOR; $session['new_emet']['FIRSTNAME'] = $line->CUSTOM_T4; $session['new_emet']['CIVILITY'] = $line->CUSTOM_T3; //fonction en mode corporate $session['new_emet']['SOCIETY'] = $line->SOCIETE; $session['new_emet']['FUNCTION'] = $line->CUSTOM_T9; //CUSTOM_T9 $session['new_emet']['STREET_NUM'] = $line->CUSTOM_T10; //CUSTOM_T10 $session['new_emet']['STREET'] = $line->CUSTOM_T11; //CUSTOM_T11 $session['new_emet']['TOWN'] = $line->CUSTOM_T12; //CUSTOM_T12 $session['new_emet']['CP'] = $line->CUSTOM_T13; //CUSTOM_T13 } } else { $session['courrier']["is_ingoing"]= FALSE; //Expediteur if($line->SENDER_ID != 0) { $session['exp_id'] = $line->SENDER_ID; } else { $session['new_exp']['LASTNAME'] = $line->AUTHOR; $session['new_exp']['FIRSTNAME'] = $line->CUSTOM_T4; $session['new_exp']['CIVILITY'] = $line->CUSTOM_T3; //fonction en mode corporate $session['new_exp']['SOCIETY'] = $line->SOCIETE; $session['new_exp']['FUNCTION'] = $line->CUSTOM_T9; //CUSTOM_T9 $session['new_exp']['STREET_NUM'] = $line->CUSTOM_T10; //CUSTOM_T10 $session['new_exp']['STREET'] = $line->CUSTOM_T11; //CUSTOM_T11 $session['new_exp']['TOWN'] = $line->CUSTOM_T12; //CUSTOM_T12 $session['new_exp']['CP'] = $line->CUSTOM_T13; //CUSTOM_T13 } } if($line->WAIT_ACTION == 'Y') { $session['courrier']["wait_action"]= true; } else { $session['courrier']["wait_action"]= false; } $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)); } //Extract Diffusion List $session["diffusion"] = new diffusion($db,$_SESSION['user']['UserId'],$_SESSION['user']['delete_copy_rights'],$_SESSION['config']['modifycopylist'], $_SESSION['config']['redirect_list'],$_SESSION['config']['tag100_for_copy']); $session["diffusion"]->load_from_db_val($table."res_x",$id,$table."listinstance"); //$session["diffusion"]->load_from_db("res_x",$id); //Notes $db->query("SELECT i.ID, i.INFO, i.DATE, i.USER_ID, u.LASTNAME, u.FIRSTNAME FROM ".$table.$_SESSION['tablename']['notes']." i INNER JOIN ".$_SESSION['tablename']['users']." u on i.USER_ID = u.USER_ID WHERE RECORD_ID = ".$id." AND ((i.ACCESS_SERVICES = 'all' AND i.ACCESS_USERS = 'all') OR (i.ACCESS_USERS = 'not' AND i.ACCESS_SERVICES LIKE '%".$_SESSION['user']['department']."%') OR (i.ACCESS_SERVICES = 'not' AND i.ACCESS_USERS LIKE '%".$_SESSION['user']['UserId']."%') OR (i.USER_ID ='".$_SESSION['user']['UserId']."')) ORDER BY DATE desc"); //$db->show(); $session["notes"] = array(); $i=0; while( $res = $db->fetch_object() ) { $session["notes"][$i]['FIRSTNAME'] = $res->FIRSTNAME; $session["notes"][$i]['LASTNAME'] = $res->LASTNAME; $session["notes"][$i]['INFO'] = $res->INFO; $session["notes"][$i]['DATE'] = $res->DATE; $i++; } return $session; } function raz_session() { $_SESSION["courrier"] = array(); $_SESSION["new_emet"] = array(); $_SESSION["new_exp"] = array(); unset($_SESSION["exp_id"]); $_SESSION["diffusion"] = array(); $_SESSION["notes"] = array(); } if( isset($_GET['id']) && !empty($_GET['id']) ) { raz_session(); $_SESSION = load_session($_SESSION,$db,$table_prefix,$_GET['id']); $locked = false; if($_SESSION['current_basket']['is_global'] == "Y") { $locktime = $_SESSION['current_basket']['locktime']; $courr = new LetterBox(); $locked = $courr->is_locked($_GET['id'],$table_prefix."res_x", $locktime); } } else { $_SESSION['error'] = _ID.' '._MISSING; } ?> <?php echo _MAIL_VALIDATION;?> "; } else { echo "\">"; } ?>

show_array($_COOKIE); ?>

POST

show_array($_POST); ?>

SESSION

show_array($_SESSION); ?>

Debug Mode

n°

n°