* @author Loïc Vinet */ include("session.php"); require("class_functions.php"); require_once("class_diffusion.php"); require_once("class_db.php"); require_once("class_workflow.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...
"; } $func = new functions(); if(isset($_GET['id'])) { $s_id = $_GET['id']; } /*if ($s_id == '') { $s_id = $_GET['gen']; }*/ $_SESSION['courrier'] = array(); $_SESSION["popup_suite"] = false; $table = "res_x"; $db = new dbquery(); $courr = new LetterBox(); $workf = new workflow(); if($_SESSION['config']['workflow'] == "true"){ $workf->loardWorkflowParameters(); } $db->connect(); $db->query("SELECT CUSTOM_T16, CUSTOM_T17, CUSTOM_T2, CUSTOM_T3, CUSTOM_T4, DESTINATION, DEST_USER, RES_ID, IDENTIFIER, date (CUSTOM_D1) as D1, date (CUSTOM_D2) as D2, date (CREATION_DATE) as D3,AUTHOR, TYPE_ID, DESCRIPTION, date(DOC_DATE) as DC, CUSTOM_T5, CUSTOM_T6, CUSTOM_T7, CUSTOM_T8, CUSTOM_T15, CUSTOM_T1, CUSTOM_T9, CUSTOM_T10, CUSTOM_T11, CUSTOM_T12, CUSTOM_T13, CUSTOM_T14, date(CREATION_DATE) as CD, PRIORITY, SOCIETE, GID_ID, COLL_ID, STATUS, date(CUSTOM_D6) as D6, CUSTOM_T18, CUSTOM_T19, CUSTOM_T20, CUSTOM_T21, COVERAGE, MAIL_ACTION FROM ".$table." WHERE RES_ID=".$s_id); $line = $db->fetch_object(); $_SESSION['courrier']['res_id'] = $line->RES_ID; $_SESSION['courrier']['identifier'] = $line->IDENTIFIER; $_SESSION['courrier']['author'] = stripslashes($line->AUTHOR); $_SESSION['courrier']['type_id'] = $line->TYPE_ID; $_SESSION['courrier']['description'] = stripslashes($line->DESCRIPTION); $_SESSION['courrier']['identifier'] = $line->IDENTIFIER; $_SESSION['courrier']['date_arrivee'] = $db->inverse_date($line->D1); $_SESSION['courrier']['date_creation'] = $db->inverse_date($line->D3); $_SESSION['courrier']['date_limite'] = $db->inverse_date($line->D2); $_SESSION['courrier']['doc_date'] = $db->inverse_date($line->DC); $_SESSION['courrier']['rep_courrier_simple'] = $line->CUSTOM_T5; $_SESSION['courrier']['rep_AR'] = $line->CUSTOM_T15; $_SESSION['courrier']['rep_direct'] = $line->CUSTOM_T6; $_SESSION['courrier']['rep_mail'] = $line->CUSTOM_T7; $_SESSION['courrier']['rep_autre'] = $line->CUSTOM_T8; $_SESSION['courrier']['rep_fax'] = $line->CUSTOM_T16; $_SESSION['courrier']['no_rep'] = $line->CUSTOM_T17; $_SESSION['courrier']['notes'] = stripslashes($line->CUSTOM_T1); $_SESSION['courrier']['qualite'] = stripslashes($line->CUSTOM_T9); $_SESSION['courrier']['num_rue'] = stripslashes($line->CUSTOM_T10); $_SESSION['courrier']['rue'] = stripslashes($line->CUSTOM_T11); $_SESSION['courrier']['ville'] = stripslashes($line->CUSTOM_T12); $_SESSION['courrier']['code'] = $line->CUSTOM_T13; $_SESSION['courrier']['quartier'] = stripslashes($line->CUSTOM_T14); $_SESSION['courrier']['nature'] = stripslashes($line->CUSTOM_T2); $_SESSION['courrier']['civ'] = stripslashes($line->CUSTOM_T3); $_SESSION['courrier']['prenom'] = stripslashes($line->CUSTOM_T4); $_SESSION['courrier']['service'] = $line->DESTINATION; $_SESSION['courrier']['dest'] = $line->DEST_USER; $_SESSION['courrier']['prio'] = $line->PRIORITY; $_SESSION['courrier']['mail_action'] = $line->MAIL_ACTION; $_SESSION['courrier']['theme'] = $line->COVERAGE; $_SESSION['courrier']['societe'] = stripslashes($line->SOCIETE); $_SESSION['courrier']['arrondissement'] = html_entity_decode($line->CUSTOM_T18); $_SESSION['courrier']['canton'] = html_entity_decode($line->CUSTOM_T19); $_SESSION['courrier']['epci'] = html_entity_decode($line->CUSTOM_T20); $_SESSION['courrier']['epci_type'] = html_entity_decode($line->CUSTOM_T21); $_SESSION['gid_id'] = $line->GID_ID; $_SESSION['courrier']['entity'] = $line->COLL_ID; $_SESSION['courrier']['status'] = $line->STATUS; $_SESSION['courrier']['waitingdoc_startdate'] = $db->inverse_date($line->D6); $db->query("select service from ".$_SESSION['tablename']['services']." where ID = '".$_SESSION['courrier']['service']."'" ); $line = $db->fetch_object(); $_SESSION['courrier']['service_label'] = $line->service; $db->query("select description from ".$_SESSION['tablename']['doctypes']." where TYPE_ID = '".$_SESSION['courrier']['type_id']."'" ); $line = $db->fetch_object(); $_SESSION['courrier']['type_label'] = $line->description; /* $_SESSION['courrier']['reponses'] = array(); $db->query("select RES_ID, TITLE, CREATION_DATE, SOURCE from ".$table." where RELATION = '".$s_id."' order by CREATION_DATE asc "); while($line = $db->fetch_object()) { array_push($_SESSION['courrier']['reponses'], array( "ID" => $line->RES_ID, "TITRE" => stripslashes($line->TITLE), "DATE" => $line->CREATION_DATE, 'SOURCE' => $line->SOURCE)); }*/ $locked = false; if($_SESSION['current_basket']['is_global'] == "Y") { $locktime = $_SESSION['current_basket']['locktime']; //$courr = new LetterBox(); $locked = $courr->is_locked($_SESSION['courrier']['res_id'], $table, $locktime, 'true'); } //Load 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($table,$s_id); ?> <?php echo _TITLE_PROCESS;?> 0) { $_SESSION['reload'] = true; echo "onLoad=\"window.parent.opener.location.href = break_cache(break_get(window.parent.opener.location.href)); setTimeout(function(){ window.parent.opener.location.href = break_cache(break_get(window.parent.opener.location.href)); window.parent.close();},".($_SESSION['current_basket']['locktime'] * 60 * 1000).");\""; } ?> >
'COU' && $_SESSION['courrier']['status'] <> 'NEW' && $_SESSION['courrier']['status'] <> 'RSV' && $_SESSION['courrier']['status'] <> 'WAI' && $_SESSION['courrier']['status'] <> 'RJT' && $_SESSION['courrier']['status'] <> 'RJV' && $_SESSION['courrier']['status'] <> 'FVA') { ?>


      have_mail_send($_SESSION['courrier']['res_id'])){ ?>           

:

/>

/>

/>

/>

/>

/>

"false") {echo "checked=\"checked\"";}?> /> " onfocus="if(this.value==''){this.value='';}" />

query(" SELECT gdd.id, gdd.titre_demande, gtd.abreviation, gdd.annee, gdd.numero, gdd.date_creation, u.firstname, u.lastname, gdd.demande_cloturer FROM gdd_demande gdd, gdd_type_demande gtd, users u WHERE gdd.fkid_courrier = ".$_SESSION['courrier']['res_id']." AND gdd.fkid_type_demande = gtd.id AND gdd.fkid_user_createur = u.user_id ORDER BY gdd.id DESC "); $Vli_nbre_demande = $db->nb_result(); ####################################################### echo"
"; if ($_SESSION['user']['gdd_creation']==1) { echo" "; } echo "

\"\" "._GDD." :

\"\" "._ADD_GDD."      
"; if($cpt_nbre_demande==1) { echo "
\""._GDD_PRECEDENT."\"
"; ###################################################################### ### Affichage du carrousel ###################################################################### echo "
"; $cpt_slide=1; $cpt_nbre_demande = 1; $gdd = new gdd(); while($val_liste_demande = $db->fetch_array()) { $Vli_id_demande = $val_liste_demande[0]; $Vls_titre_demande = $val_liste_demande[1]; $Vls_abr_type_demande = $val_liste_demande[2]; $Vls_annee_demande = $val_liste_demande[3]; $Vls_num_demande = $val_liste_demande[4]; $Vld_date_creation_demande = $val_liste_demande[5]; $Vls_prenom_createur = $val_liste_demande[6]; $Vls_nom_createur = $val_liste_demande[7]; $Vls_demande_cloturer = $val_liste_demande[8]; ################################################ $gdd->set_chiffre($Vls_num_demande); $gdd->set_annee($Vls_annee_demande); $gdd->set_type_label($Vls_abr_type_demande); ################################################ if($Vls_demande_cloturer=="Y") { $Vls_image_demande_cloturer = " \""._GDD_DEMANDE_CLOSE."\" "; } else { $Vls_image_demande_cloturer = ""; } ################################################ $Vls_tableau_demande = "
".date_sans_heure($Vld_date_creation_demande)." ".$gdd->afficher_numero_gdd()." ".$Vls_image_demande_cloturer."".tronque_chaine($Vls_titre_demande, 40)." afficher_numero_gdd()."\" alt=\""._GDD_OPEN." ".$gdd->afficher_numero_gdd()."\" onclick=\"\" />
$Vls_tableau_demande "; $cpt_nbre_demande++; } elseif($cpt_nbre_demande==4) { echo " $Vls_tableau_demande
"._GDD_DATE_CREATION." "._GDD_NUMERO_DEMANDE." "._GDD_TITLE."
"; $cpt_nbre_demande = 1; $cpt_slide++; } else { echo " $Vls_tableau_demande "; $cpt_nbre_demande++; } } ################################################################################################## ### On ferme le tableau et le div si le nombre total de demande n'est pas un multiple de 3 ################################################################################################## if($cpt_nbre_demande!=1 AND $Vli_nbre_demande!=0) { echo "
"; } if($Vli_nbre_demande==0) { echo"
"._GDD_DATE_CREATION." "._GDD_NUMERO_DEMANDE." "._GDD_TITLE."
"; } /* ############################################# ### création du contenu news echo "
page 1
page 2
page 3
page 4
"; $cpt++; */ echo"
"; ############################################################################ echo "
\""._GDD_SUIVANT."\"

"; } ############################################################################# ?>

:

      

:


:

test_reserved_time($_SESSION['courrier']['res_id'], $table); $db->query("select firstname, lastname from ".$_SESSION['tablename']['users']." where user_id = '".$by_user_id."'"); if($db->nb_result() > 0) { $resu = $db->fetch_object(); $locking_user = $resu->firstname.' '.$resu->lastname; } ?>

.







COOKIE
show_array($_COOKIE); ?>
POST
show_array($_POST); ?>
SESSION
show_array($_SESSION); ?>
Debug Mode