";
}
require("class_functions.php");
require("test_page.php");
require_once("class_db.php");
require_once("pre_emet_exp.php");
require_once("class_letterbox.php");
$courr = new LetterBox();
if(isset($_REQUEST['cancel']) && $_REQUEST['cancel'] == _CANCEL)
{
$courr->release($_SESSION['courrier']['res_id'],"res_x");
$_SESSION['courrier'] = array();
?>
release($_SESSION['courrier']['res_id'],"res_x");
function update_gid($gid)
{
if ($gid <> '')
{
$_SESSION['tmp_gid_id'] = $_SESSION['gid_id'] + 1;
$_SESSION['gid_id'] = $_SESSION['gid_id'] + 1;
}
}
$_SESSION['indexation'] = false;
$func = new functions();
$_SESSION['tablechoice'] = $_SESSION['ressources'][0]['tablename'];
$_SESSION['error'] = "";
$nom = "";
$prenom = "";
$civ = "";
$conn = new dbquery();
$conn->connect();
$conn_type = new dbquery();
$conn_type->connect();
$db_gdi = new dbquery();
$db_gdi -> connect();
$action ="";
if(isset($_REQUEST['diffuser']))
{
$action = "diff";
}
elseif(isset($_REQUEST['add_to_mail']))
{
$action = "attach";
}
else if(isset($_REQUEST['valider']))
{
$action = "val";
}
$type = "";
if ( ( !isset($_SESSION['courrier']['type_courrier']) || empty($_SESSION['courrier']['type_courrier'])) )
{
$_SESSION['error'] .= _DOCTYPE_MISSING.".
";
header("location: qualif_frame.php?id=".$_SESSION['courrier']['res_id']);
exit();
}
else
{
$type = $_SESSION['courrier']['type_courrier'];
}
if($_POST['gid_id'] <> '')
{
$_SESSION['gid_id'] = $_POST['gid_id'];
}
//print_r($_REQUEST);
if(isset($_REQUEST['res_id']) && !empty($_REQUEST['res_id']))
{
$res_id = $_REQUEST['res_id'];
}
else
{
$_SESSION['error'] .= _ID.' '._MISSING.".
";
header("location: qualif_frame.php?id=".$_SESSION['courrier']['id']);
exit();
}
//GID , verification de l'inexistance de la valeur
if($_SESSION['config']['gdi_index'] == "true")
{
if (!$_POST['valid_gdi'])
{
if($_SESSION['gid_id'] <> '')
{
$db_gdi -> query("select count(*) as nb from res_x where GID_ID = '".$_SESSION['gid_id']."' ");
$res_gdi = $db_gdi -> fetch_object();
if($res_gdi -> nb <> 0)
{
$_SESSION['error'] .= _GID_ID_EXISTS.".
";
}
}
}
}
// courrier sortant et pas piece jointe
if(!$_SESSION['courrier']["is_ingoing"] && !$_SESSION['courrier']['attach'])
{
if($_SESSION['config']['corporate'] == "true")
{
if(!isset($_SESSION['courrier']['sender_nom']) || empty($_SESSION['courrier']['sender_nom']) || trim($_SESSION['courrier']['sender_nom']) == html_entity_decode(_DEFAULT_LASTNAME, ENT_NOQUOTES, 'UTF-8'))
{
$_SESSION['error'] .= _SENDER_CORPORATE_ERROR.".
";
}
else
{
$nom = trim($_SESSION['courrier']['sender_nom']);
}
if(isset($_SESSION['courrier']['sender_prenom']) && !empty($_SESSION['courrier']['sender_prenom']) && trim($_SESSION['courrier']['sender_prenom']) <> html_entity_decode(_DEFAULT_FIRSTNAME, ENT_NOQUOTES, 'UTF-8'))
{
$prenom = trim($_SESSION['courrier']['sender_prenom']);
}
if(isset($_SESSION['courrier']['sender_function']) && !empty($_SESSION['courrier']['sender_function']) && trim($_SESSION['courrier']['sender_function']) <> html_entity_decode(_DEFAULT_FIRSTNAME, ENT_NOQUOTES, 'UTF-8'))
{
$civ = $_SESSION['courrier']['sender_function'];
}
if(isset($_SESSION['courrier']['sender_society']) && !empty($_SESSION['courrier']['sender_society']) && trim($_SESSION['courrier']['sender_society']) <> html_entity_decode(_DEFAULT_FIRSTNAME, ENT_NOQUOTES, 'UTF-8'))
{
$societe = $_SESSION['courrier']['sender_society'];
}
}
else
{
if(!isset($_SESSION['courrier']['sender_nom']) || empty($_SESSION['courrier']['sender_nom']) || trim($_SESSION['courrier']['sender_nom']) == html_entity_decode(_DEFAULT_LASTNAME, ENT_NOQUOTES, 'UTF-8'))
{
$_SESSION['error'] .= _SENDER_NON_CORPORATE_ERROR.".
";
}
else
{
$nom = trim($_SESSION['courrier']['sender_nom']);
}
if(isset($_SESSION['courrier']['sender_prenom']) && !empty($_SESSION['courrier']['sender_prenom']) && trim($_SESSION['courrier']['sender_prenom']) <> html_entity_decode(_DEFAULT_FIRSTNAME, ENT_NOQUOTES, 'UTF-8'))
{
$prenom = trim($_SESSION['courrier']['sender_prenom']);
}
if(isset($_SESSION['courrier']['sender_society']) && !empty($_SESSION['courrier']['sender_society']) && trim($_SESSION['courrier']['sender_society']) <> html_entity_decode(_DEFAULT_FIRSTNAME, ENT_NOQUOTES, 'UTF-8'))
{
$societe = $_SESSION['courrier']['sender_society'];
}
$civ = $_SESSION['courrier']['sender_civilite'];
}
}
// courrier entrant
elseif ($_SESSION['courrier']["is_ingoing"])
{
if(isset($_SESSION['courrier']['emetteur']) && !empty($_SESSION['courrier']['emetteur']) && $_SESSION['courrier']['emetteur'] <> "dest")
{
$nom = trim($_SESSION['courrier']['emetteur']);
$societe = trim($_SESSION['courrier']['emetteur_societe']);
}
else
{
if($_SESSION['config']['corporate'] == "true")
{
if(!isset($_SESSION['courrier']['emetteur']) || empty($_SESSION['courrier']['emetteur']))
{
$_SESSION['error'] .= _SHIPPER_CORPORATE_ERROR.".
";
}
elseif ( (!isset($_REQUEST['nom']) || empty($_REQUEST['nom']) || trim($_REQUEST['nom']) == html_entity_decode(_DEFAULT_LASTNAME, ENT_NOQUOTES, 'UTF-8')) && (!isset($_REQUEST['societe']) || empty($_REQUEST['societe']) || trim($_REQUEST['societe']) == html_entity_decode(_DEFAULT_SOCIETY, ENT_NOQUOTES, 'UTF-8')))
{
$_SESSION['error'] .= _SHIPPER_CORPORATE_ERROR.".
";
}
elseif((strlen(trim($_REQUEST["nom"])) < 1 || trim($_REQUEST['nom']) == html_entity_decode(_DEFAULT_LASTNAME, ENT_NOQUOTES, 'UTF-8')) && trim($_REQUEST['societe'])<> html_entity_decode(_DEFAULT_SOCIETY, ENT_NOQUOTES, 'UTF-8'))
{
$nom = trim($_REQUEST['societe']);
$societe = trim($_REQUEST['societe']);
$_SESSION['courrier']['societe'] = $societe;
}
else
{
$nom = trim($_REQUEST['nom']);
if(trim($_REQUEST['societe'])<> html_entity_decode(_DEFAULT_SOCIETY, ENT_NOQUOTES, 'UTF-8'))
{
$societe = trim($_REQUEST['societe']);
$_SESSION['courrier']['societe'] = $societe;
}
else
{
$societe = '';
$_SESSION['courrier']['societe'] = '';
}
$_SESSION['courrier']['nom'] = $nom;
}
}
else
{
if(!isset($_REQUEST['nom']) || empty($_REQUEST['nom']) || trim($_REQUEST['nom']) == html_entity_decode(_DEFAULT_LASTNAME, ENT_NOQUOTES, 'UTF-8'))
{
$_SESSION['error'] .= _SHIPPER_NON_CORPORATE_ERROR.".
";
}
else
{
$nom = trim($_REQUEST['nom']);
$_SESSION['courrier']['nom'] = $nom;
}
if(trim($_REQUEST['societe'])<> html_entity_decode(_DEFAULT_SOCIETY, ENT_NOQUOTES, 'UTF-8'))
{
$societe = trim($_REQUEST['societe']);
$_SESSION['courrier']['societe'] = $societe;
}
else
{
$societe = '';
$_SESSION['courrier']['societe'] = '';
}
}
}
if(isset($_REQUEST['civilite']) && !empty($_REQUEST['civilite']) && trim($_REQUEST['civilite']) <> html_entity_decode(_DEFAULT_FUNCTION, ENT_NOQUOTES, 'UTF-8'))
{
$civ = trim($_REQUEST['civilite']);
$_SESSION['courrier']['civ'] = $civ;
}
if(isset($_REQUEST['prenom']) && !empty($_REQUEST['prenom']) && trim($_REQUEST['prenom']) <> html_entity_decode(_DEFAULT_FIRSTNAME, ENT_NOQUOTES, 'UTF-8'))
{
$prenom = trim($_REQUEST['prenom']);
$_SESSION['courrier']['prenom'] = $prenom;
}
$courrier_date = "";
$jour_courrier = "01";
if (strlen(trim($_REQUEST["jour_courrier"])) > 0)
{
$jour_courrier = trim($_REQUEST["jour_courrier"]);
}
$mois_courrier = "01";
if (strlen(trim($_REQUEST["mois_courrier"])) > 0)
{
$mois_courrier = trim($_REQUEST["mois_courrier"]);
}
$annee_courrier = date("Y");
if (strlen(trim($_REQUEST["annee_courrier"])) > 0)
{
$annee_courrier = trim($_REQUEST["annee_courrier"]);
}
if ($jour_courrier > 31)
{
$_SESSION['error'] .= _MAIL_DATE_DAY_INFERIOR_TO_31.".
";
}
if ($mois_courrier > 12)
{
$_SESSION['error'] .= _MAIL_DATE_MONTH_INFERIOR_TO_12.".
";
}
if (strlen($annee_courrier) < 4 && strlen($annee_courrier) > 0)
{
$_SESSION['error'] .= _MAIL_DATE_YEAR_WRONG_FORMAT.".
";
}
}
// courrier sortant pas pièce jointe
if(!$_SESSION['courrier']["attach"] && $_SESSION['courrier']["is_ingoing"])
{
$arrivee_date = "NULL";
if (strlen(trim($_REQUEST["jour_arrivee"])) < 1)
{
$_SESSION['error'] .= _START_DATE_MISSING.".
";
}
if (strlen(trim($_REQUEST["mois_arrivee"])) < 1)
{
$_SESSION['error'] .= _START_DATE_MONTH_MISSING.".
";
}
if (strlen(trim($_REQUEST["annee_arrivee"])) < 1)
{
$_SESSION['error'] .= _START_DATE_YEAR_MISSING.".
";
}
if ($_REQUEST["jour_arrivee"] > 31)
{
$_SESSION['error'] .= _START_DATE_DAY_INFERIOR_TO_31.".
";
}
if ($_REQUEST["mois_arrivee"] > 12)
{
$_SESSION['error'] .= _START_DATE_MONTH_INFERIOR_TO_12.".
";
}
if (strlen(trim($_REQUEST["annee_arrivee"])) < 4 && strlen(trim($_REQUEST["annee_arrivee"])) > 0)
{
$_SESSION['error'] .= _START_DATE_YEAR_WRONG_FORMAT.".
";
}
}
//nouvelle affaire
if (($_SESSION['courrier']['new_folder'] == TRUE ) && ($_SESSION['courrier']['chk_date_limite'] == 'Y'))
{
$date_limite = "NULL";
if (strlen(trim($_SESSION['courrier']["jour_limite"])) < 1)
{
$_SESSION['error'].=_LIMIT_DATE_DAY_MISSING.".
";
}
if (strlen(trim($_SESSION['courrier']["mois_limite"])) < 1)
{
$_SESSION['error'].= _LIMIT_DATE_MONTH_MISSING.".
";
}
if (strlen(trim($_SESSION['courrier']["annee_limite"])) < 1)
{
$_SESSION['error'] .= _LIMIT_DATE_YEAR_MISSING.".
";
}
if ($_SESSION['courrier']["jour_limite"] > 31)
{
$_SESSION['error'].= _LIMIT_DATE_DAY_INFERIOR_TO_31.".
";
}
if ($_SESSION['courrier']["mois_limite"] > 12)
{
$_SESSION['error'] .= _LIMIT_DATE_MONTH_INFERIOR_TO_12.".
";
}
if (strlen(trim($_SESSION['courrier']["annee_limite"])) < 4 && strlen(trim($_SESSION['courrier']["annee_limite"])) > 0)
{
$_SESSION['error'] .= _LIMIT_DATE_YEAR_WRONG_FORMAT.".
";
}
}
// courrier départ pas pièce jointe ou courrier arrivé
if((!$_SESSION['courrier']["is_ingoing"] && !$_SESSION['courrier']['attach']) || $_SESSION['courrier']['is_ingoing'])
{
$nature_doc = "";
if (strlen(trim($_REQUEST["nature"])) < 1)
{
$_SESSION['error'].= _INVOICE_TYPE_MISSING.".
";
}
else
{
$nature_doc = trim($_REQUEST["nature"]);
}
$type = "";
if ( !isset($_SESSION['courrier']['type_courrier']) || empty($_SESSION['courrier']['type_courrier']) )
{
$_SESSION['error'] .= _DOCTYPE_MISSING.".
";
}
else
{
$type = $_SESSION['courrier']['type_courrier'];
}
// nouvelle affaire
if ($_SESSION['courrier']['new_folder'] == TRUE)
{
$coll_id = $_SESSION['courrier']['entity'];
$service = "";
if (!isset($_SESSION['courrier']["service"]) || empty($_SESSION['courrier']["service"]))
{
$_SESSION['error'] .= _DEPARTMENT_MISSING.".
";
}
else
{
$service = $_SESSION['courrier']["service"];
}
}
$courrier_date = "";
$jour_courrier = "01";
if (strlen(trim($_REQUEST["jour_courrier"])) > 0)
{
$jour_courrier = trim($_REQUEST["jour_courrier"]);
}
$mois_courrier = "01";
if (strlen(trim($_REQUEST["mois_courrier"])) > 0)
{
$mois_courrier = trim($_REQUEST["mois_courrier"]);
}
$annee_courrier = date("Y");
if (strlen(trim($_REQUEST["annee_courrier"])) > 0)
{
$annee_courrier = trim($_REQUEST["annee_courrier"]);
}
if ($jour_courrier > 31)
{
$_SESSION['error'] .= _MAIL_DATE_DAY_INFERIOR_TO_31.".
";
}
if ($mois_courrier > 12)
{
$_SESSION['error'] .= _MAIL_DATE_MONTH_INFERIOR_TO_12.".
";
}
if (strlen($annee_courrier) < 4 && strlen($annee_courrier) > 0)
{
$_SESSION['error'] .= _MAIL_DATE_YEAR_WRONG_FORMAT.".
";
}
$objet = "";
if(isset($_REQUEST['objet']) && !empty($_REQUEST['objet']))
{
$objet = trim($_REQUEST['objet']);
$_SESSION['courrier']['objet'] = $objet;
}
// pas une pièce jointe
if(!$_SESSION['courrier']['attach'])
{
$priority = "";
if(!isset($_REQUEST['priority']) )
{
$_SESSION['error'] = _PRIORITY_MANDATORY.".
";
}
else
{
$priority = $_REQUEST['priority'];
}
}
}
// courrier départ et pièce jointe
if(!$_SESSION['courrier']['ingoing'] && $_SESSION['courrier']['attach'])
{
if(!isset($_SESSION['courrier']['attach_num']) || empty($_SESSION['courrier']['attach_num']))
{
$_SESSION['error'] .= _GED_NUM_MISSING.".
";
}
else
{
if(!ereg('^[0-9]+$', $_SESSION['courrier']['attach_num']))
{
$_SESSION['error'] .= _THE_GED_NUM._WRONG_FORMAT.".
";
}
else
{
$where2 = '';
for($i=0; $i < count($_SESSION['user']['security']); $i++)
{
if($_SESSION['tablename'] == $_SESSION['user']['security'][$i]['table'] && !empty($_SESSION['user']['security'][$i]['where']))
{
$where2 = " and ( ".$_SESSION['user']['security'][$i]['where']." ) ";
}
}
$conn->query("select RES_ID from ".$_SESSION['ressources'][0]['tablename']." where RES_ID = ".$_SESSION['courrier']['attach_num']." ".$where2);
if($conn->nb_result() < 1 )
{
$_SESSION['error'] .= _NO_DOC_GED_NUM." ".$_SESSION['courrier']['attach_num']." "._EXISTS_OR_RIGHT.".
";
}
}
}
if(!isset($_REQUEST['title']) || empty($_REQUEST['title']))
{
$_SESSION['error'] .= _TITLE_MISSING.".
";
}
else
{
$_SESSION['courrier']['title'] = trim($_REQUEST['title']);
}
}
$arrivee_date = "NULL";
if( isset($_REQUEST["jour_arrivee"]) && isset($_REQUEST["mois_arrivee"]) && isset($_REQUEST["annee_arrivee"]) )
{
$arrivee_date = $func->valid_date($_REQUEST["jour_arrivee"],$_REQUEST["mois_arrivee"],$_REQUEST["annee_arrivee"]);
if( $arrivee_date == NULL)
{
$_SESSION['error'] .= _START_DATE_INVALID."
";
$arrivee_date = "NULL";
}
}
if( isset($jour_courrier) && isset($mois_courrier) && isset($annee_courrier) )
{
$courrier_date = $func->valid_date($jour_courrier,$mois_courrier,$annee_courrier);
if( $courrier_date == NULL )
{
$courrier_date = "NULL";
$_SESSION['error'] .= _MAIL_DATE_INVALID."
";
}
}
//courrier attaché à une affaire
if(!isset($_SESSION['courrier']['new_folder']) )
{
$_SESSION['error'] .= _ERROR_INDEXATION.".
";
}
else
{
if($_SESSION['config']['gdi_index'] == "true")
{
if(!$_POST['valid_gdi'])
{
if($_SESSION['gid_id'] <> '')
{
$db_gdi -> query("select count(*) as nb from res_x where GID_ID = '".$_SESSION['gid_id']."' ");
$res_istres = $db_gdi -> fetch_object();
if($res_gdi -> nb <> 0)
{
$_SESSION['error'] .= _GID_ID_EXISTS.".
";
}
}
}
}
if(!$_SESSION['courrier']['new_folder'])
{
if(empty($_SESSION['courrier']['folder_id']) || !isset($_SESSION['courrier']['folder_id']))
{
$_SESSION['error'].= _NUM_FOLDER_MISSING."
";
}
else
{
$is_folder = 'N';
$folder_id = $_SESSION['courrier']['folder_id'];
$_SESSION["FILE"]["identifier"] = $_SESSION['courrier']['folder_chrono'];
$conn->query("select destination, coll_id from ".$_SESSION['tablechoice']." where is_folder='Y' and res_id = ".$folder_id);
$res = $conn->fetch_object();
$service = $res->destination;
$coll_id = $res->coll_id;
}
if(($_SESSION['config']['update_limit_date'] == true) && ($_SESSION['courrier']["is_ingoing"]))
{
include_once($_SESSION['config']['includedir']."/addon_update_limit_date.php");
$new_limit_date = post_control_update_limit_date($_REQUEST['new_limit_date']);
}
}
// nouvelle affaire
else
{
$is_folder = 'Y';
$key1 = "CHRONO";
$key2 = "";
$key3 = date("Y");
$chrono_value=$func->update_parameter($key1,$key2,$key3);
if(empty($chrono_value))
{
$conn->query("INSERT INTO ".$_SESSION['tablename']['param']." (KEY1,KEY2,KEY3,VALUE,LIB_PARAM) VALUES ( '".$key1."', '".$key2."', '".$key3."', '1', '')");
$chrono_value = "1";
}
$_SESSION["FILE"]["identifier"]=date("dmY")."/".$_SESSION['user']['department']."/".sprintf("%06d",$chrono_value);
}
}
// nouvelle affaire
if ($_SESSION['courrier']['new_folder'] == TRUE)
{
if( $action == "diff")
{
if($_SESSION['diff']< 1)
{
$_SESSION['error'] .= _DIFFUSION_LIST_EMPTY.".
";
}
}
}
if( empty($action) || !empty($_SESSION['error']))
{
header("location: qualif_frame.php?id=".$_SESSION['courrier']['res_id']);
exit();
}
else
{
// courrier arrivé
if($_SESSION['courrier']["is_ingoing"])
{
$relance1 = "NULL";
$relance2 = "NULL";
$arrivee_date = "NULL";
if( isset($_REQUEST["jour_arrivee"]) && isset($_REQUEST["mois_arrivee"]) && isset($_REQUEST["annee_arrivee"]) )
{
$arrivee_date = $func->valid_date($_REQUEST["jour_arrivee"],$_REQUEST["mois_arrivee"],$_REQUEST["annee_arrivee"]);
if( $arrivee_date == NULL)
{
$_SESSION['error'] .= _START_DATE_INVALID."
";
$arrivee_date = "NULL";
}
}
$date_limite = "NULL";
if( isset($_SESSION['courrier']["jour_limite"]) && isset($_SESSION['courrier']["mois_limite"]) && isset($_SESSION['courrier']["annee_limite"]) )
{
$date_limite = $func->valid_date($_SESSION['courrier']["jour_limite"],$_SESSION['courrier']["mois_limite"],$_SESSION['courrier']["annee_limite"]);
if( $date_limite == NULL )
{
$_SESSION['error'] .= _LIMIT_DATE_INVALID."
";
$date_limite = "NULL";
}
}
}
if( isset($jour_courrier) && isset($mois_courrier) && isset($annee_courrier) )
{
$courrier_date = $func->valid_date($jour_courrier,$mois_courrier,$annee_courrier);
if( $courrier_date == NULL )
{
$courrier_date = "NULL";
$_SESSION['error'] .= _MAIL_DATE_INVALID."
";
}
}
if( !empty($_SESSION['error']) )
{
header("location: qualif_frame.php?id=".$_SESSION['courrier']['res_id']);
exit();
}
if( $action <> "attach")
{
$status = 'NEW';
if($action == "val")
{
$status = 'VAL';
}
if($_SESSION['courrier']['wait_action'] == true)
{
$wait_action = 'Y';
if($action <> "val")
{
$status = 'WAI';
$cpmlt_custom_d6 = ' , CUSTOM_D6 = now() , ';
}
}
else
{
$wait_action = 'N';
$cpmlt_custom_d6 = ' , CUSTOM_D6 = NULL , ';
}
$dest = $_SESSION['diff'][0]['UserID'];
// courrier arrivé
if($_SESSION['courrier']["is_ingoing"])
{
if($is_folder == 'Y')
{
$conn->query("update ".$_SESSION['tablechoice']." set description = '".$objet."', doc_date = '".$courrier_date."',
identifier = '".$_SESSION["FILE"]["identifier"]."', status = '".$status."', typist = '".$_SESSION['user']['UserId']."',
type_id = '".addslashes($type)."', custom_t2 = '".$nature_doc."', custom_t3 = '".addslashes($_REQUEST['civilite'])."', custom_t4 = '".addslashes($prenom)."',
author = '".addslashes($nom)."', custom_d1 = ".$arrivee_date.", custom_d2 =".$date_limite." , destination = '".$service."',
coll_id = '".$coll_id."', dest_user = '".$dest."', is_ingoing = 'Y', priority = ".$priority.", is_folder = '".$is_folder."',
societe = '".addslashes($_REQUEST['societe'])."', gid_id = 'E".date('Y').$_SESSION['gid_id']."' , wait_action = '".$wait_action."' ".$cpmlt_custom_d6."
SENDER_ID = ".$emet_id.", CUSTOM_T9 = '".addslashes($_REQUEST['FUNCTION'])."', CUSTOM_T10 = '".addslashes($_REQUEST['STREET_NUM'])."',
CUSTOM_T11 = '".addslashes($_REQUEST['STREET'])."',CUSTOM_T12 = '".addslashes($_REQUEST['TOWN'])."',CUSTOM_T13 = '".addslashes($_REQUEST['CP'])."'
where res_id = ".$res_id );
}
else
{
$conn->query("update ".$_SESSION['tablechoice']." set description = '".$objet."', doc_date = '".$courrier_date."',
identifier = '".$_SESSION["FILE"]["identifier"]."', status = '".$status."', typist = '".$_SESSION['user']['UserId']."',
type_id = '".addslashes($type)."', custom_t2 = '".$nature_doc."', custom_t3 = '".addslashes($_REQUEST['civilite'])."', custom_t4 = '".addslashes($prenom)."',
author = '".addslashes($nom)."', custom_d1 = ".$arrivee_date.", custom_d2 =".$date_limite." , destination = '".$service."',
coll_id = '".$coll_id."', is_ingoing = 'Y', priority = ".$priority.", is_folder = '".$is_folder."', societe = '".addslashes($_REQUEST['societe'])."',
gid_id = 'E".date('Y').$_SESSION['gid_id']."', folder_id = '".$folder_id."' , wait_action = '".$wait_action."' ".$cpmlt_custom_d6."
SENDER_ID = ".$emet_id.", CUSTOM_T9 = '".addslashes($_REQUEST['FUNCTION'])."', CUSTOM_T10 = '".addslashes($_REQUEST['STREET_NUM'])."',
CUSTOM_T11 = '".addslashes($_REQUEST['STREET'])."',CUSTOM_T12 = '".addslashes($_REQUEST['TOWN'])."',CUSTOM_T13 = '".addslashes($_REQUEST['CP'])."'
where res_id = ".$res_id );
}
update_gid($_SESSION['gid_id']);
//On efface tout ce qui concerne la liste emetteurs et expediteurs
clear_session_exp_emet();
//On enleve la reservation sur le courrier
$courr->release($res_id,"res_x");
}
else // courrier sortant
{
if($is_folder == 'Y')
{
$conn->query("update ".$_SESSION['tablechoice']." set description = '".$objet."', doc_date = '".$courrier_date."',
identifier = '".$_SESSION["FILE"]["identifier"]."', status = '".$status."', typist = '".$_SESSION['user']['UserId']."',
type_id = '".addslashes($type)."', custom_t2 = '".$nature_doc."', custom_t3 = '".addslashes($_REQUEST['civilite'])."', custom_t4 = '".addslashes($prenom)."',
author = '".addslashes($nom)."', custom_d1 = ".$arrivee_date.", custom_d2 =".$date_limite." , destination = '".$service."',
coll_id = '".$coll_id."', dest_user = '".$dest."', is_ingoing = 'Y', priority = ".$priority.", is_folder = '".$is_folder."',
societe = '".addslashes($_REQUEST['societe'])."', gid_id = 'E".date('Y').$_SESSION['gid_id']."' , wait_action = '".$wait_action."' ".$cpmlt_custom_d6."
SENDER_ID = ".$emet_id.", CUSTOM_T9 = '".addslashes($_REQUEST['FUNCTION'])."', CUSTOM_T10 = '".addslashes($_REQUEST['STREET_NUM'])."',
CUSTOM_T11 = '".addslashes($_REQUEST['STREET'])."',CUSTOM_T12 = '".addslashes($_REQUEST['TOWN'])."',CUSTOM_T13 = '".addslashes($_REQUEST['CP'])."'
where res_id = ".$res_id );
}
else
{
$conn->query("update ".$_SESSION['tablechoice']." set description = '".$objet."', doc_date = '".$courrier_date."',
identifier = '".$_SESSION["FILE"]["identifier"]."', status = '".$status."', typist = '".$_SESSION['user']['UserId']."',
type_id = '".addslashes($type)."', custom_t2 = '".$nature_doc."', custom_t3 = '".addslashes($_REQUEST['civilite'])."', custom_t4 = '".addslashes($prenom)."',
author = '".addslashes($nom)."', custom_d1 = ".$arrivee_date.", custom_d2 =".$date_limite." , destination = '".$service."',
coll_id = '".$coll_id."', dest_user = '".$dest."', is_ingoing = 'Y', priority = ".$priority.", is_folder = '".$is_folder."',
societe = '".addslashes($_REQUEST['societe'])."', gid_id = 'E".date('Y').$_SESSION['gid_id']."', folder_id = '".$folder_id."' ,
wait_action = '".$wait_action."' ".$cpmlt_custom_d6.",
SENDER_ID = ".$emet_id.", CUSTOM_T9 = '".addslashes($_REQUEST['FUNCTION'])."', CUSTOM_T10 = '".addslashes($_REQUEST['STREET_NUM'])."',
CUSTOM_T11 = '".addslashes($_REQUEST['STREET'])."',CUSTOM_T12 = '".addslashes($_REQUEST['TOWN'])."',CUSTOM_T13 = '".addslashes($_REQUEST['CP'])."'
where res_id = ".$res_id );
}
update_gid($_SESSION['gid_id']);
//On efface tout ce qui concerne la liste emetteurs et expediteurs
clear_session_exp_emet();
//On enleve la reservation sur le courrier
$courr->release($res_id,"res_x");
}
$conn->query("DELETE FROM ".$_SESSION['tablename']['listinstance']." WHERE res_id = ".$res_id);
for($i=0;$iquery("INSERT INTO ".$_SESSION['tablename']['listinstance']." (RES_TABLE, RES_ID, SEQUENCE,USER_ID,BY_USER_ID)
VALUES ('".$_SESSION['ressources'][0]['tablename']."', ".$res_id.", ".$k.", '".$_SESSION['diff'][$i]['UserID']."', '".$_SESSION['user']['UserId']."')");
}
if($_SESSION['history']['resadd'] == true)
{
require("class_history.php");
$hist = new history();
$mes = _DOC_QUALIFIED." (".$res_id.") ";
$hist->add($_SESSION['tablechoice'], $res_id ,"ADD", $mes);
if($is_folder =='N')
{
if($_SESSION['courrier']["is_ingoing"])
{
$mes = _NEW_INGOING_DOC." (".$res_id.") "._ADDED_TO_FOLDER.$folder_id;
}
else
{
$mes = _NEW_ONGOING_DOC." (".$type.") "._ADDED_TO_FOLDER.$folder_id;
}
$hist->add($_SESSION['tablechoice'], $folder_id ,"ADD", $mes);
}
}
if($_SESSION['courrier']["is_ingoing"])
{
$conn = new dbquery();
$conn->connect();
$conn->query("select date(creation_date) as date from ".$_SESSION['tablechoice']." where res_id = ".$res_id );
$res = $conn->fetch_object();
$dateenr = $res->date;
$conn->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($conn->nb_result() == 0)
{
$_SESSION['error']= _DOCTYPE." "._UNKNOWN;
header("location: qualif_frame.php?id=".$_SESSION['courrier']['res_id']);
exit;
}
else
{
$res = $conn->fetch_object();
if( $res->RELANCE1 != NULL)
$relance1 = "'".$res->RELANCE1."'";
if( $res->RELANCE2 != NULL)
$relance2 = "'".$res->RELANCE2."'";
}
$conn->query("UPDATE ".$_SESSION['tablechoice']." SET CUSTOM_D4 = ".$relance1.", CUSTOM_D5 = ".$relance2." WHERE RES_ID = ".$res_id);
}
if($action == "diff " && $_SESSION['history']['qualification'])
{
$hist->add($_SESSION['tablename']['listinstance'], $res_id , 'DIF', _DOC." n° ".$res_id." "._SEND." : ".$_SESSION['diff'][0]['UserID']." ("._RECIPIENT.")");
for($i=1; $i < count($_SESSION['diff']); $i++)
{
$hist->add($_SESSION['tablename']['listinstance'], $res_id, 'DIF', _DOC." n° ".$res_id." "._SEND." : ".$_SESSION['diff'][$i]['UserID']." ("._TO_CC.")");
}
}
$_SESSION['indexation'] = true;
$_SESSION['diff'] = array();
if($is_folder == 'N')
{
$id = $folder_id;
}
$_SESSION['indexation_id'] = $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 = ".$res_id);
}
$_SESSION['courrier'] = array();
?>
query("select DESCRIPTION, DOC_DATE, TYPE_ID, CUSTOM_T3, CUSTOM_T4, AUTHOR, CUSTOM_D1, CUSTOM_D2, DESTINATION, DEST_USER, IDENTIFIER, COLL_ID from ".$_SESSION['tablechoice']." where RES_ID = ".$_SESSION['courrier']['attach_num']);
$res = $conn->fetch_object();
$desc = $res->DESCRIPTION;
$date = $res->DOC_DATE;
$type = $res->TYPE_ID;
$civ = $res->CUSTOM_T3;
$prenom = $res->CUSTOM_T4;
$author = $res->AUTHOR;
$date_ar = $res->CUSTOM_D1;
$date_lim = $res->CUSTOM_D2;
$dest = $res->DESTINATION;
$dest_user = $res->DEST_USER;
$identifier = $res->IDENTIFIER;
$coll_id = $res->COLL_ID;
if($is_folder == 'Y')
{
$conn->query("update ".$_SESSION['tablechoice']." set title = '".addslashes($_SESSION['courrier']['title'] )."', relation = '".$_SESSION['courrier']['attach_num']."' , description = '".addslashes($desc)."', doc_date = '".$date."', identifier = '".$identifier."', status = 'REP', typist = '".$_SESSION['user']['UserId']."', type_id = '".addslashes($type)."', custom_t3 = '".addslashes($civ)."', custom_t4 = '".addslashes($prenom)."', author = '".addslashes($author)."', custom_d1 = '".$date_ar."', custom_d2 ='".$date_lim."' , destination = '".$dest."', coll_id = '".$coll_id."', dest_user = '".$dest."', is_ingoing = 'N', is_folder = '".$is_folder."', gid_id = 'E".date('Y').$_SESSION['gid_id']."', source = 'Local File' where res_id = ".$res_id );
update_gid($_SESSION['gid_id']);
}
else
{
$conn->query("update ".$_SESSION['tablechoice']." set title = '".addslashes($_SESSION['courrier']['title'] )."', relation = '".$_SESSION['courrier']['attach_num']."' , description = '".addslashes($desc)."', doc_date = '".$date."', identifier = '".$identifier."', status = 'REP', typist = '".$_SESSION['user']['UserId']."', type_id = '".addslashes($type)."', custom_t3 = '".addslashes($civ)."', custom_t4 = '".addslashes($prenom)."', author = '".addslashes($author)."', custom_d1 = '".$date_ar."', custom_d2 ='".$date_lim."' , destination = '".$dest."', coll_id = '".$coll_id."', dest_user = '".$dest."', is_ingoing = 'N', is_folder = '".$is_folder."', gid_id = 'E".date('Y').$_SESSION['gid_id']."', source = 'Local File', folder_id = '".$folder_id."' where res_id = ".$res_id );
update_gid($_SESSION['gid_id']);
if($_SESSION['courrier']["is_ingoing"])
{
// SI XML Permet la modification de la date limite de traitement et SI La date limite peut être modifiée
if($_SESSION['config']['update_limit_date'] == true) // update_limit_date_in xml
{
//Modification du document parent pour les dates limites de traitement CUSTOM D2, CUSTOM_D4, CUSTOM_D5
module_update_limit_date($folder_id, $new_limit_date);
}
}
if (($_SESSION['config']['mail_for_answer_by_index_file'] <> "false"))
{
$date = date("d-m-Y");
$mail_answer = "
"._ONE_ANSWER_JOINED." ".$_SESSION['courrier']['attach_num']."
"._HELLO.",
"._AN_ANSWER_HAS_BEEN_JOINED_TO_THE_DOC." ".$_SESSION['courrier']['attach_num']." "._ACTUALLY."...
"._ACCESS_MAIL_TO_PROCESS."
";
$conn->query("select MAIL from ".$_SESSION['tablename']['users']." where USER_ID = '".$dest_user."'");
$res = $conn->fetch_object();
$mail = $res->MAIL;
mail($mail, _ANSWER_JOINED_TITLE_MAIL, $mail_answer , "From: ".$_SESSION['config']['adminmail']."\nReply-To: ".$_SESSION['config']['adminmail']." \nContent-Type: text/html; charset=\"iso-8859-1\"\n");
}
}
$courr->release($res_id,"res_x");
$conn->query("update ".$_SESSION['tablechoice']." set STATUS = 'COU' where RES_ID = ".$_SESSION['courrier']['attach_num']);
if($_SESSION['history']['resadd'] == "true")
{
require_once("class_history.php");
$users = new history();
$users->add($_SESSION['tablechoice'], $_SESSION['courrier']['attach_num'],"ADD", _NEW_ANSWER_ADDED." : ".$identifier." (".$type.")");
}
$_SESSION['indexation'] = true;
$_SESSION['indexation_id'] = $_SESSION['courrier']['attach_num'];
if($is_folder =='N')
{
$res_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 = ".$res_id);
}
?>