*/
session_name('LetterBox2');
session_start();
if(file_exists($_SESSION['config']['lang'].'.php'))
{
include($_SESSION['config']['lang'].'.php');
}
else
{
$_SESSION['error'] = "Language file missing...
";
}
require("class_functions.php");
require("test_page.php");
require_once("class_db.php");
function update_gid($gid)
{
if ($gid <> '')
{
$_SESSION['tmp_gid_id'] = $_SESSION['courrier']['gid_id'] + 1;
$_SESSION['courrier']['gid_id'] = $_SESSION['courrier']['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();
if(isset($_REQUEST['cancel']))
{
if(isset($_SESSION['upfile']['format']) && !empty($_SESSION['upfile']['format']))
{
$ext = strtolower($_SESSION['upfile']['format']);
if(file_exists('ftp/tmp_file_'.$_SESSION['user']['UserId'].'.'.$ext))
{
unlink('ftp/tmp_file_'.$_SESSION['user']['UserId'].'.'.$ext);
}
}
$_SESSION['upfile'] = array();
?> "validation" )
{
$_SESSION['error'] .= _DOCTYPE_MISSING.".
";
header("location: enregistrement_doc.php");
exit();
}
elseif($action <> "validation")
{
$type = $_SESSION['courrier']['type_courrier'];
}
elseif($action == "validation" && (empty($_REQUEST['type_id']) || !isset($_REQUEST['type_id'])))
{
$_SESSION['error'] .= _DOCTYPE_MISSING.".
";
header("location: validation.php&id=".$_REQUEST['id']);
exit();
}
else
{
$type = $_REQUEST['type_id'];
}
*/
if ( ( !isset($_SESSION['courrier']['type_courrier']) || empty($_SESSION['courrier']['type_courrier'])) )
{
$_SESSION['error'] .= _DOCTYPE_MISSING.".
";
if($action == "validation")
{
header("location: validation.php&id=".$_REQUEST['id']);
}
else
{
header("location: enregistrement_doc.php");
}
exit();
}
else
{
$type = $_SESSION['courrier']['type_courrier'];
}
$conn_type -> query("SELECT GENERATE, MODEL from ".$_SESSION['tablename']['doctypes']." WHERE TYPE_ID = '".$type."' ");
$res_type = $conn_type -> fetch_object();
if($_POST['gid_id'] <> '')
{
$_SESSION['courrier']['gid_id'] = $_POST['gid_id'];
}
// courrier = fichier importé
if($res_type->GENERATE == 'N' && !empty($type))
{
// courrier sortant et pas piece jointe
//GID , verification de l'inexistance de la valeur
if($_SESSION['config']['gdi_index'] == "true")
{
if (!$_POST['valid_gdi'])
{
if($_SESSION['courrier']['gid_id'] <> '')
{
$db_gdi -> query("select count(*) as nb from res_x where GID_ID = '".$_SESSION['courrier']['gid_id']."' ");
$res_gdi = $db_gdi -> fetch_object();
if($res_gdi -> nb <> 0)
{
$_SESSION['error'] .= _GID_ID_EXISTS.".
";
}
}
}
}
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']);
}
$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(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 = "";
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['chk_date_limite'] == 'Y'))
{
$date_limite = "";
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)
{
$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']) || empty($_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
{
$title = trim($_REQUEST['title']);
}
}
}
// courrier généré
elseif($res_type -> GENERATE == "Y")
{
if($_SESSION['config']['gdi_index'] == "true")
{
if(!$_POST['valid_gdi'])
{
if($_SESSION['courrier']['gid_id'] <> '')
{
$db_gdi -> query("select count(*) as nb from res_x where GID_ID = '".$_SESSION['courrier']['gid_id']."' ");
$res_gdi = $db_gdi -> fetch_object();
if($res_gdi -> nb <> 0)
{
$_SESSION['error'] .= _GID_ID_EXISTS.".
";
}
}
}
}
if($action == "validation")
{
$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.".
";
}
}
$priority = "";
if(!isset($_REQUEST['priority']) || empty($_REQUEST['priority']))
{
$_SESSION['error'] = _PRIORITY_MANDATORY.".
";
}
else
{
$priority = $_REQUEST['priority'];
}
$arrivee_date = "";
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.".
";
}
if(isset($_SESSION['courrier']['emetteur']) && !empty($_SESSION['courrier']['emetteur']) && $_SESSION['courrier']['emetteur'] <> "dest")
{
$nom = trim($_SESSION['courrier']['emetteur']);
}
else
{
if($_SESSION['config']['corporate'] == "true")
{
if(!isset($_SESSION['courrier']['emetteur']) || empty($_SESSION['courrier']['emetteur']))
{
$_SESSION['error'] .= _SHIPPER_CORPORATE_ERROR.".
";
}
else if ( (!isset($_REQUEST['societe']) || empty($_REQUEST['societe']) || 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'))
{
$_SESSION['error'] .= _SHIPPER_CORPORATE_ERROR.".
";
}
elseif((strlen(trim($_REQUEST["nom"])) < 1 || trim($_REQUEST['nom']) == html_entity_decode(_DEFAULT_LASTNAME, ENT_NOQUOTES, 'UTF-8') ) &&trim(utf8_encode($_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'] = $societe;
}
$_SESSION['courrier']['nom'] = $nom;
}
}
else
{
}
if(isset($_REQUEST['civilite']) && !empty($_REQUEST['civilite']) && trim($_REQUEST['civilite']) <> html_entity_decode(_DEFAULT_SOCIETY, 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;
}
}
//nouvelle affaire
if (($_SESSION['courrier']['new_folder'] == TRUE)&&($_SESSION['chk_date_limite'] == 'Y'))
{
$date_limite = "";
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.".
";
}
}
$objet = "";
if(isset($_REQUEST['objet']) && !empty($_REQUEST['objet']))
{
$objet = trim($_REQUEST['objet']);
$_SESSION['courrier']['objet'] = $objet;
}
$service = "";
//nouvelle affaire
if ($_SESSION['courrier']['new_folder'] == TRUE)
{
if (!isset($_SESSION['courrier']["service"]) || empty($_SESSION['courrier']["service"]))
{
$_SESSION['error'] .= _DEPARTMENT_MISSING.".
";
}
else
{
$service = $_SESSION['courrier']["service"];
}
}
}
if($_SESSION['origin'] == "file" && !empty($type) && $res_type -> GENERATE == "N")
{
if(!isset($_SESSION['upfile']['size']) || empty($_SESSION['upfile']['size']))
{
$_SESSION['error'] .= _FILE_MISSING."!
";
}
}
elseif($res_type -> GENERATE == "Y" && $action <> "validation")
{
if(!isset($_SESSION['model_content']) || empty($_SESSION['model_content']))
{
$_SESSION['error'] .= _ERROR_EMPTY_MODEL."!
";
}
}
$arrivee_date = trim($_REQUEST["annee_arrivee"]).trim($_REQUEST["mois_arrivee"]).trim($_REQUEST["jour_arrivee"]);
$courrier_date = $annee_courrier.$mois_courrier.$jour_courrier;
//courrier attaché à une affaire
if(!isset($_SESSION['courrier']['new_folder']) )
{
$_SESSION['error'] .= _ERROR_INDEXATION.".
";
}
else
{
//courrier attaché à une affaire
if($_SESSION['config']['gdi_index'] == "true")
{
if(!$_POST['valid_gdi'])
{
if($_SESSION['courrier']['gid_id'] <> '')
{
$db_gdi -> query("select count(*) as nb from res_x where GID_ID = '".$_SESSION['courrier']['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'];
}
}
// nouvelle affaire
else
{
$is_folder = 'Y';
$key1 = "CHRONO";
$key2 = "";
$key3 = date("Y");
$chrono_value=$func->update_parameter($key1,$key2,$key3);
if(empty($chrono_value))
{
$db->query("INSERT INTO ".$_SESSION['tablename']['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 == "validation" || $action == "diff")
{
if($_SESSION['diff']< 1)
{
$_SESSION['error'] .= _DIFFUSION_LIST_EMPTY.".
";
}
}
}
if( empty($action) || !empty($_SESSION['error']))
{
if($action == "validation")
{
header("location: validation.php?id=".$_REQUEST['id']);
exit;
}
else
{
header("location: enregistrement_doc.php");
exit;
}
}
else
{
// courrier généré
if($res_type -> GENERATE == "Y")
{
// courrier arrivé
if($_SESSION['courrier']["is_ingoing"] || $action =="validation")
{
$relance1 = "";
$relance2 = "";
$arrivee_date = trim($_REQUEST["annee_arrivee"]).trim($_REQUEST["mois_arrivee"]).trim($_REQUEST["jour_arrivee"]);
$date_limite = trim($_SESSION['courrier']["annee_limite"]).trim($_SESSION['courrier']["mois_limite"]).trim($_SESSION['courrier']["jour_limite"]);
}
if($action <> "validation")
{
$conn->query("select VALUE from parameters where KEY1 = 'FILE_NUMBER'");
$res = $conn->fetch_object();
if ($_SESSION['config']['system'] == "true")
{
$path_tmp = $_SESSION['config']['ftphomedir'].'/tmp'.$res->VALUE.".maarch";
//$path_tmp = 'ftp/tmp'.$res->VALUE.".maarch";
}
else
{
$path_tmp = $_SESSION['config']['ftphomedir'].'\\tmp'.$res->VALUE.".maarch";
//$path_tmp = 'ftp\\tmp'.$res->VALUE.".maarch";
}
//echo $path.'
';
$myfile = fopen($path_tmp, "w");
if(!$myfile)
{
$_SESSION['error'] .= _FILE_OPEN_ERROR.'.
';
header("location: enregistrement_doc.php");
exit;
}
fwrite($myfile, $_SESSION['model_content']);
fclose($myfile);
$new_value = $res->VALUE +1;
$conn->query("update parameters set VALUE = '".$new_value."' where KEY1 = 'FILENUMBER'");
$conn->query("SELECT DOCSERVER_ID, PATH_TEMPLATE, SIZE_LIMIT, ACTUAL_SIZE FROM ".$_SESSION['tablename']['docservers']." WHERE IS_READONLY = 'N' AND ENABLED = 'Y' ");
if($conn->nb_result() == 0)
{
$_SESSION['error'] .= _NO_AVAILABLE_DOCSERVER."."._MORE_INFOS." : ".$_SESSION['config']['adminname'].".
";
}
else
{
$info = $conn->fetch_object();
$docserver_id = $info->DOCSERVER_ID;
$file_size = filesize($path_tmp);
$docserver_size = $info->ACTUAL_SIZE + $file_size;
if($info->SIZE_LIMIT > 0 && $docserver_size >= $info->SIZE_LIMIT)
{
$_SESSION['error'] .= _NOT_ENOUGH_DISK_SPACE."."._MORE_INFOS." : ".$_SESSION['config']['adminname'].".
";
header("location: enregistrement_doc.php");
exit;
}
else
{
$path_template = $info->PATH_TEMPLATE;
require("class_docserver.php");
$docserver = new docserver();
$docinfo = $docserver->filename(trim($info->PATH_TEMPLATE));
$destination_rept = $docinfo['destination_rept'];
$file_destination_name = $docinfo['file_destination_name'];
if(file_exists($destination_rept.$file_destination_name.".maarch"))
{
$_SESSION['error'] = _FILE_ALREADY_EXISTS.". "._MORE_INFOS." : ".$_SESSION['config']['adminname'].".";
header("location: enregistrement_doc.php");
exit;
}
if(!copy($path_tmp,$destination_rept.$file_destination_name.".maarch"))
{
$_SESSION['error'] = _FILE_SEND_ERROR.". "._TRY_AGAIN.". "._MORE_INFOS." : ".$_SESSION['config']['adminname'].".
";
header("location: enregistrement_doc.php");
exit;
}
else
{
if(!empty($path_tmp))
{
unlink($path_tmp);
}
$conn->query("UPDATE ".$_SESSION['tablename']['docservers']." SET ACTUAL_SIZE=".$docserver_size." WHERE DOCSERVER_ID='".$docserver_id."'");
$destination_rept = substr($destination_rept,strlen($path_template),4);
if ($_SESSION['config']['system'] == "true")
{
$destination_rept = str_replace('/','#',$destination_rept);
}
else
{
$destination_rept = str_replace('\\','#',$destination_rept);
}
$dest = $_SESSION['diff'][0]['UserID'];
$status = 'NEW';
if($action == "val")
{
$status = 'VAL';
}
// nouvelle affaire
if($is_folder =='Y')
{
$conn->query("INSERT INTO ".$_SESSION['tablechoice']." ( DESCRIPTION, FORMAT, CREATION_DATE, DOCSERVER_ID, PATH, FILENAME, FILESIZE, IDENTIFIER, STATUS, TYPIST, TYPE_ID, CUSTOM_T3, CUSTOM_T4, AUTHOR, CUSTOM_D1, CUSTOM_D2, DESTINATION, DEST_USER, IS_INGOING, PRIORITY, IS_FOLDER, SOCIETE, DOC_DATE, GID_ID)
VALUES
('".addslashes($objet)."','MAARCH', now() , '".$docserver_id."','"
.$destination_rept."','".$file_destination_name.".maarch',".$file_size.",'".$_SESSION["FILE"]["identifier"]
."','".$status."','".$_SESSION['user']['UserId']
."','".addslashes($type)."','".addslashes($civ)."', '".addslashes($prenom)."', '".addslashes($nom)."','".$arrivee_date."', '".$date_limite."' , '".$service."', '".$dest."', 'Y', ".$priority.", '".$is_folder."','".addslashes($societe)."', CURDATE(),'E".date('Y').$_SESSION['courrier']['gid_id']."')");
update_gid($_SESSION['courrier']['gid_id']);
}
// courrier attaché à une affaire
else
{
$conn->query("INSERT INTO ".$_SESSION['tablechoice']." ( DESCRIPTION, FORMAT, CREATION_DATE, DOCSERVER_ID, PATH, FILENAME, FILESIZE, IDENTIFIER, STATUS, TYPIST, TYPE_ID, CUSTOM_T3, CUSTOM_T4, AUTHOR, CUSTOM_D1, CUSTOM_D2, DESTINATION, DEST_USER, IS_INGOING, PRIORITY, IS_FOLDER, FOLDER_ID, SOCIETE, DOC_DATE, GID_ID)
VALUES
('".addslashes($objet)."','MAARCH', now() , '".$docserver_id."','"
.$destination_rept."','".$file_destination_name.".maarch',".$file_size.",'".$_SESSION["FILE"]["identifier"]
."','".$status."','".$_SESSION['user']['UserId']
."','".addslashes($type)."','".addslashes($civ)."', '".addslashes($prenom)."', '".addslashes($nom)."','".$arrivee_date."', '".$date_limite."' , '".$service."', '".$dest."', 'Y', ".$priority.", '".$is_folder."', '".$folder_id."','".addslashes($societe)."', CURDATE() ,'E".date('Y').$_SESSION['courrier']['gid_id']."' )");
update_gid($_SESSION['courrier']['gid_id']);
}
$conn->query("SELECT RES_ID as ID from ".$_SESSION['tablechoice']." where IDENTIFIER = '".$_SESSION["FILE"]["identifier"]."' AND DESCRIPTION = '".addslashes($objet)."' and FORMAT = 'MAARCH' and DATE(CREATION_DATE) = CURDATE() and DOCSERVER_ID = '".$docserver_id."' and PATH = '".$destination_rept."' and FILENAME = '".$file_destination_name.".maarch' and FILESIZE = ".$file_size." and TYPIST = '".$_SESSION['user']['UserId']."'");
$line = $conn->fetch_object();
$id = "";
$id = $line->ID;
if($_SESSION['history']['resadd'] == true)
{
require("class_history.php");
$users = new history();
$mes = _NEW_GENERATED_DOC." : ".$id;
$users->add($_SESSION['tablechoice'], $id ,"ADD", $mes);
if($is_folder =='N')
{
$mes = _NEW_GENERATED_DOC." (".$id.") "._ADDED_TO_FOLDER.$folder_id;
$users->add($_SESSION['tablechoice'], $folder_id ,"ADD", $mes);
}
}
for($i=0;$iquery("INSERT INTO ".$_SESSION['tablename']['listinstance']." (RES_TABLE, RES_ID, SEQUENCE,
USER_ID)
VALUES ('".$_SESSION['ressources'][0]['tablename']."', ".$id.", ".$k."
, '".$_SESSION['diff'][$i]['UserID']."')");
}
$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);
}
$md5fichier .= $tmp;
$filename = $res->FILENAME;
$extemp = strtolower(substr($filename, -4));
$filename = ereg_replace("[.A-Z]{4}$",$extemp, $filename);
$md5fichier .= $filename;
$md5 = md5_file($md5fichier);
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();
$relance1 = $res->RELANCE1;
$relance2 = $res->RELANCE2;
}
$conn->query("UPDATE ".$_SESSION['tablechoice']." SET FINGERPRINT='".$md5."', CUSTOM_D4 = '".$relance1."', CUSTOM_D5 = '".$relance2."' WHERE RES_ID = ".$id);
}
else
{
$conn->query("UPDATE ".$_SESSION['tablechoice']." SET FINGERPRINT='".$md5."' WHERE RES_ID = ".$id);
}
if($action == "diff " && $_SESSION['history']['diffusion'])
{
$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.")");
}
}
$_SESSION['indexation'] = true;
$_SESSION['diff'] = array();
$_SESSION['upfile'] = array();
$_SESSION['courrier'] = array();
if ($_SESSION['chk_date_limite'] == 'N')
{
$conn->query("UPDATE ".$_SESSION['tablechoice']." SET CUSTOM_D2=NULL, CUSTOM_D4=NULL, CUSTOM_D5=NULL WHERE RES_ID = ".$id);
}
if($is_folder =='N')
{
$id = $folder_id;
}
$_SESSION['indexation_id'] = $id;
?>
doc_date : '.$courrier_date;
//exit();
$identifier = $_REQUEST['identifier'];
if($_SESSION['config']['enablechangenotif'] == "true")
{
if( $_SESSION['is_diff'])
{
$date = date("d-m-Y");
$mail_trait = "
"._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."
";
$mail_copie = "
"._MAIL_IN_COPY."
"._HELLO.",
"._YOU_HAVE_MAIL_COPY." :
";
$nom_dest = "";
$conn->query("select LASTNAME, FIRSTNAME from ".$_SESSION['tablename']['users']." where USER_ID = '".$_SESSION['diff'][0]['UserID']."'");
$res = $conn->fetch_object();
$nom_dest = $res->FIRSTNAME." ".$res->LASTNAME;
$emetteur = $civ." ".$nom." ".$prenom;
$mail_copie .= "- "._LETTER_N."".$id." "._TO_TYPE." ".$type." ("._OBJECT." : ".$objet.") "._RECEIVE_THE." ".$date." "._RECEIVE_FROM." ".$emetteur." "._HAS_BEEN_TRANSFERED_BY." ".$nom_dest." "._HAS_BEEN_PROCESSED_BEFORE." ".$date_limite." :
"._SHOW_MAIL."
\n\n";
}
for($i=0;$iquery("select MAIL from ".$_SESSION['tablename']['users']." where USER_ID = '".$_SESSION['diff'][$i]['UserID']."'");
$res = $conn->fetch_object();
$mail = $res->MAIL;
if( $_SESSION['is_diff'] && $i==0)
{
mail($mail, _PROCESS_MAIL, $mail_trait , "From: ".$_SESSION['config']['mail']."\r\nReply-To: ".$_SESSION['config']['mail']." \r\nContent-Type: text/html; charset=\"iso-8859-1\"\r\n");
}
elseif($_SESSION['is_diff'] && $i > 0)
{
mail($mail, _FIRST_WARNING_TXT, $mail_copie , "From: ".$_SESSION['config']['mail']."\r\nReply-To: ".$_SESSION['config']['mail']." \r\nContent-Type: text/html; charset=\"iso-8859-1\"\r\n");
}
}
}
$conn->query("DELETE from ".$_SESSION['tablename']['listinstance']." where RES_TABLE = 'res_x' and RES_ID = ".$id);
$j = 0;
for($i=0;$iquery("INSERT into ".$_SESSION['tablename']['listinstance']." (RES_TABLE, RES_ID, SEQUENCE, USER_ID) values ('".$_SESSION['tablechoice']."',
".$id.", ".$j.", '".$_SESSION['diff'][$i]['UserID']."');");
}
$conn->query(" UPDATE ".$_SESSION['tablechoice']." SET DESCRIPTION = '".addslashes($objet)."', DOC_DATE = '".$courrier_date."',
TYPE_ID = '".addslashes($type)."', CUSTOM_T2 = '".$nature_doc."', CUSTOM_T3 = '".addslashes($civ)."', CUSTOM_T4 = '".addslashes($prenom)."'
, AUTHOR = '".addslashes($nom)."', CUSTOM_D1 = '".$arrivee_date."', CUSTOM_D2 = '".$date_limite."', DEST_USER = '".$_SESSION['diff'][0]['UserID']."',
DESTINATION = '".$service."', APPROVER = '".$_SESSION['user']['UserId']."', VALIDATION_DATE = now(), status = 'NEW', PRIORITY = ".$priority."
WHERE RES_ID = '".$id."'");
$conn->query("SELECT RES_ID, CREATION_DATE FROM ".$_SESSION['tablechoice']." WHERE IDENTIFIER = '".$_REQUEST['identifier']."'");
$line = $conn->fetch_object();
$id = $line->RES_ID;
$dateenr = $line->CREATION_DATE;
if($_SESSION['history']['resup'] == true)
{
require("class_history.php");
$users = new history();
$users->add($_SESSION['tablechoice'], $id ,"VAL", _DOC_VALIDATED." : ".$id." (".$type.")");
}
$conn2 = new dbquery();
$conn2->connect();
$conn2->query("select TYPE_ID, ADDDATE('".$dateenr."', INTERVAL DELAI_RELANCE1 DAY) as RELANCE1, SUBDATE('".$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();
$relance1 = $res->RELANCE1;
$relance2 = $res->RELANCE2;
}
$conn->query('update '.$_SESSION['tablechoice']." set CUSTOM_D4 = '".$relance1."', CUSTOM_D5 = '".$relance2."' WHERE RES_ID = ".$id);
// $conn->show();
if($action == "diff " && $_SESSION['history']['diffusion'])
{
$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.")");
}
}
$_SESSION['courrier'] = array();
$_SESSION['diff'] = array();
?>
"validation")
{
$extension = explode(".",$_SESSION['upfile']['name']);
$count_level = count($extension)-1;
$the_ext = $extension[$count_level];
$the_ext = strtolower($the_ext);
//$old_file_name = substr($_SESSION['upfile']['name'], 0, count($_SESSION['upfile']['name'])-count($the_ext)+1);
require("load_extensions.php");
$ext_ok = false;
for($i=0;$i "validation" && $action <> "attach")
{
$conn->query("SELECT DOCSERVER_ID, PATH_TEMPLATE, SIZE_LIMIT, ACTUAL_SIZE FROM ".$_SESSION['tablename']['docservers']." WHERE IS_READONLY = 'N' AND ENABLED = 'Y' ");
if($conn->nb_result() == 0)
{
$_SESSION['error'] = _NO_AVAILABLE_DOCSERVER.". "._MORE_INFOS." : ".$_SESSION['config']['adminname'].".";
header("location: enregistrement_doc.php");
exit;
}
else
{
$info = $conn->fetch_object();
$docserver_id = $info->DOCSERVER_ID;
$docserver_size = $info->ACTUAL_SIZE + $_FILES['file']['size'];
if($info->SIZE_LIMIT > 0 && $docserver_size >= $info->SIZE_LIMIT)
{
$_SESSION['error'] = _NOT_ENOUGH_DISK_SPACE.". "._MORE_INFOS." : ".$_SESSION['config']['adminname'].".";
header("location: enregistrement_doc.php");
exit;
}
else
{
/*if(!is_uploaded_file($_FILES['file']['tmp_name']))
{
$_SESSION['error'] = _FILE_NOT_SEND.". "._TRY_AGAIN.". "._MORE_INFOS." : ".$_SESSION['config']['adminname']."";
header("location: enregistrement_doc.php");
exit;
}
else
{*/
$path_template = $info->PATH_TEMPLATE;
require("class_docserver.php");
$docserver = new docserver();
$docinfo = $docserver->filename($info->PATH_TEMPLATE);
$destination_rept = $docinfo['destination_rept'];
$file_destination_name = $docinfo['file_destination_name'];
//if(!move_uploaded_file($_FILES['file']['tmp_name'],$destination_rept.$file_destination_name.".".$the_ext))
//echo $_SESSION['config']['ftphomedir'].'\tmp_file_'.$_SESSION['user']['UserId'].'.'.$the_ext;
//echo '
'.$destination_rept.$file_destination_name.".".$the_ext;
//exit;
if($_SESSION['config']['system'] == "true")
{
$path_tmp = $_SESSION['config']['ftphomedir'].'/tmp_file_'.$_SESSION['user']['UserId'].'.'.$the_ext;
}
else
{
$path_tmp = $_SESSION['config']['ftphomedir'].'\tmp_file_'.$_SESSION['user']['UserId'].'.'.$the_ext;
}
if(file_exists($destination_rept.$file_destination_name.".".$the_ext))
{
$_SESSION['error'] = _FILE_ALREADY_EXISTS.". "._MORE_INFOS." : ".$_SESSION['config']['adminname'].".";
header("location: enregistrement_doc.php");
exit;
}
if (!copy($path_tmp, $destination_rept.$file_destination_name.".".$the_ext))
//if (!copy($_SESSION['upfile']['local_path'], $destination_rept.$file_destination_name.".".$the_ext))
{
$_SESSION['error'] = _FILE_SEND_ERROR.". "._TRY_AGAIN."."._MORE_INFOS." : ".$_SESSION['config']['adminname']."";
exit();
?>
update_parameter($key1,$key2,$key3);
if(empty($chrono_value))
{
$db->query("INSERT INTO ".$_SESSION['tablename']['param']." VALUES ( '".$key1."', '".$key2."', '".$key3."', '1', '')");
$chrono_value = "1";
}
$_SESSION["FILE"]["identifier"]=date("dmY")."/".$_SESSION['user']['department']."/".sprintf("%06d",$_SESSION["chrono_value"]);
}
else
{
$_SESSION["FILE"]["identifier"] = $_SESSION['courrier']['folder_chrono'];
}*/
$conn->query("UPDATE ".$_SESSION['tablename']['docservers']." SET ACTUAL_SIZE=".$docserver_size." WHERE DOCSERVER_ID='".$docserver_id."'");
$dest = $_SESSION['diff'][0]['UserID'];
$status = 'NEW';
if($action == "val")
{
$status = 'VAL';
}
if ($_SESSION['config']['system'] == "true")
{
$size = filesize($_SESSION['config']['ftphomedir'].'/tmp_file_'.$_SESSION['user']['UserId'].'.'.$the_ext);
}
else
{
$size = filesize($_SESSION['config']['ftphomedir'].'\tmp_file_'.$_SESSION['user']['UserId'].'.'.$the_ext);
}
// courrier arrivé
if($_SESSION['courrier']["is_ingoing"])
{
// nouvelle affaire
if($is_folder == 'Y')
{
$conn->query("INSERT INTO ".$_SESSION['tablechoice']." ( DESCRIPTION, FORMAT, CREATION_DATE, DOC_DATE, DOCSERVER_ID, PATH, FILENAME, FILESIZE, IDENTIFIER, STATUS, TYPIST, TYPE_ID, CUSTOM_T2, CUSTOM_T3, CUSTOM_T4, AUTHOR, CUSTOM_D1, CUSTOM_D2, DESTINATION, DEST_USER, IS_INGOING, PRIORITY, IS_FOLDER, SOCIETE, GID_ID)
VALUES
('".$objet."', '".strtoupper($the_ext)."', now() , '".$courrier_date."','".$docserver_id."','"
.$destination_rept."','".$file_destination_name.".".strtolower($the_ext)."',".$size.",'".$_SESSION["FILE"]["identifier"]
."','".$status."','".$_SESSION['user']['UserId']
."','".addslashes($type)."','".$nature_doc
."','".addslashes($civ)."', '".addslashes($prenom)."', '".addslashes($nom)."','".$arrivee_date."', '".$date_limite."' , '".$service."', '".$dest."', 'Y', ".$priority.", '".$is_folder."','".addslashes($societe)."','E".date('Y').$_SESSION['courrier']['gid_id']."')");
update_gid($_SESSION['courrier']['gid_id']);
}
// courrier attaché à une affaire
else
{
$conn->query("INSERT INTO ".$_SESSION['tablechoice']." ( DESCRIPTION, FORMAT, CREATION_DATE, DOC_DATE, DOCSERVER_ID, PATH, FILENAME, FILESIZE, IDENTIFIER, STATUS, TYPIST, TYPE_ID, CUSTOM_T2, CUSTOM_T3, CUSTOM_T4, AUTHOR, CUSTOM_D1, CUSTOM_D2, DESTINATION, DEST_USER, IS_INGOING, PRIORITY, IS_FOLDER, FOLDER_ID, SOCIETE, GID_ID)
VALUES
('".$objet."', '".strtoupper($the_ext)."', now() , '".$courrier_date."','".$docserver_id."','"
.$destination_rept."','".$file_destination_name.".".strtolower($the_ext)."',".$size.",'".$_SESSION["FILE"]["identifier"]
."','".$status."','".$_SESSION['user']['UserId']
."','".addslashes($type)."','".$nature_doc
."','".addslashes($civ)."', '".addslashes($prenom)."', '".addslashes($nom)."','".$arrivee_date."', '".$date_limite."' , '".$service."', '".$dest."', 'Y', ".$priority.", '".$is_folder."', '".$folder_id."','".addslashes($societe)."','E".date('Y').$_SESSION['courrier']['gid_id']."')");
update_gid($_SESSION['courrier']['gid_id']);
}
}
else // courrier sortant
{
if($is_folder == 'Y') // Nouvelle affaire
{
$conn->query("INSERT INTO ".$_SESSION['tablechoice']." ( DESCRIPTION, FORMAT, CREATION_DATE, DOC_DATE, DOCSERVER_ID, PATH, FILENAME, FILESIZE, IDENTIFIER, STATUS, TYPIST,
TYPE_ID, CUSTOM_T2, AUTHOR, DESTINATION, DEST_USER, IS_INGOING, PRIORITY, IS_FOLDER, SOCIETE, CUSTOM_T3, CUSTOM_T4, GID_ID)
VALUES
('".addslashes($objet)."', '".strtoupper($the_ext)."', now() , '".$courrier_date."','".$docserver_id."','"
.$destination_rept."','".$file_destination_name.".".strtolower($the_ext)
."',".$size
.",'".$_SESSION["FILE"]["identifier"]
."','NEW','".$_SESSION['user']['UserId']
."','".addslashes($type)."','".$nature_doc
."', '".addslashes($nom)."' , '".$service."', '".$dest."', 'N', ".$priority.", '".$is_folder."','".addslashes($societe)."','".addslashes($prenom)."','".addslashes($civ)."','S".date('Y').$_SESSION['courrier']['gid_id']."')");
update_gid($_SESSION['courrier']['gid_id']);
}
else // attaché à une affaire
{
$conn->query("INSERT INTO ".$_SESSION['tablechoice']." ( DESCRIPTION, FORMAT, CREATION_DATE, DOC_DATE, DOCSERVER_ID, PATH, FILENAME, FILESIZE, IDENTIFIER, STATUS, TYPIST,
TYPE_ID, CUSTOM_T2, AUTHOR, DESTINATION, DEST_USER, IS_INGOING, PRIORITY, IS_FOLDER, FOLDER_ID, SOCIETE, CUSTOM_T3, CUSTOM_T4, GID_ID)
VALUES
('".addslashes($objet)."', '".strtoupper($the_ext)."', now() , '".$courrier_date."','".$docserver_id."','"
.$destination_rept."','".$file_destination_name.".".strtolower($the_ext)
."',".$size
.",'".$_SESSION["FILE"]["identifier"]
."','OUT','".$_SESSION['user']['UserId']
."','".addslashes($type)."','".$nature_doc
."', '".addslashes($nom)."' , '".$service."', '".$dest."', 'N', ".$priority.", '".$is_folder."', '".$folder_id."','".addslashes($societe)."','".addslashes($prenom)."','".addslashes($civ)."','S".date('Y').$_SESSION['courrier']['gid_id']."')");
update_gid($_SESSION['courrier']['gid_id']);
}
}
// $conn->show();
$conn->query("SELECT RES_ID as ID from ".$_SESSION['tablechoice']." where IDENTIFIER = '".$_SESSION["FILE"]["identifier"]."' AND DESCRIPTION = '".$objet."' and FORMAT = '".strtoupper($the_ext)."' and DATE(CREATION_DATE) = CURDATE() and DOCSERVER_ID = '".$docserver_id."' and PATH = '".$destination_rept."' and FILENAME = '".$file_destination_name.".".strtolower($the_ext)."' and FILESIZE = ".$size." and TYPIST = '".$_SESSION['user']['UserId']."'");
$line = $conn->fetch_object();
$id = "";
//$conn->show();
$id = $line->ID;
for($i=0;$iquery("INSERT INTO ".$_SESSION['tablename']['listinstance']." (RES_TABLE, RES_ID, SEQUENCE,
USER_ID)
VALUES ('".$_SESSION['ressources'][0]['tablename']."', ".$id.", ".$k."
, '".$_SESSION['diff'][$i]['UserID']."')");
}
if($_SESSION['history']['resadd'] == true)
{
require("class_history.php");
$users = new history();
if($_SESSION['courrier']["is_ingoing"])
{
$mes = _NEW_INGOING_DOC." (".$id.") ";
}
else
{
$mes = _NEW_ONGOING_DOC." (".$id.") ";
}
$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['upfile']['size'] = $_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);
}
$md5fichier .= $tmp;
$filename = $res->FILENAME;
$extemp = strtolower(substr($filename, -4));
$filename = ereg_replace("[.A-Z]{4}$",$extemp, $filename);
$md5fichier .= $filename;
$md5 = md5_file($md5fichier);
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();
$relance1 = $res->RELANCE1;
$relance2 = $res->RELANCE2;
}
$conn->query("UPDATE ".$_SESSION['tablechoice']." SET FINGERPRINT='".$md5."', CUSTOM_D4 = '".$relance1."', CUSTOM_D5 = '".$relance2."' WHERE RES_ID = ".$id);
}
else
{
$conn->query("UPDATE ".$_SESSION['tablechoice']." SET FINGERPRINT='".$md5."' WHERE RES_ID = ".$id);
}
if($action == "diff " && $_SESSION['history']['diffusion'])
{
$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.")");
}
}
if(file_exists($_SESSION['config']['ftphomedir'].'\tmp_file_'.$_SESSION['user']['UserId'].'.'.$the_ext))
{
unlink($_SESSION['config']['ftphomedir'].'\tmp_file_'.$_SESSION['user']['UserId'].'.'.$the_ext);
}
$_SESSION['indexation'] = true;
$_SESSION['diff'] = array();
$_SESSION['upfile'] = array();
if($is_folder == 'N')
{
$id = $folder_id;
}
$_SESSION['indexation_id'] = $id;
$_SESSION['courrier'] = array();
if ($_SESSION['chk_date_limite'] == 'N')
{
$conn->query("UPDATE ".$_SESSION['tablechoice']." SET CUSTOM_D2=NULL, CUSTOM_D4=NULL, CUSTOM_D5=NULL WHERE RES_ID = ".$id);
}
?>
"._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."