"._ALL."
";
#########################################################
### Compte le nombre de résultat pour la requête
#########################################################
if($_SESSION['config']['mail_count'] == "true")
{
//On cree une requete imbrique
$req_imbrique = "
SELECT
$Vls_select
FROM
$Vls_from
";
if($Vls_where!="")
{
$req_imbrique .= "
WHERE
$Vls_where
";
}
if($Vls_group_by!="")
{
$req_imbrique .= "
GROUP BY
$Vls_group_by
";
}
$query_nbre_resultat_basket =
"SELECT ".$Vls_nom_champ_requete.", COUNT(".$Vls_nom_champ_requete.") AS CPT
FROM (".$req_imbrique.") temp
GROUP BY temp.".$Vls_nom_champ_requete;
$query = $db->query($query_nbre_resultat_basket);
while( $query_result = $db->fetch_object( $query ) )
{
$Vli_nbre_resultat_services[$query_result->$Vls_nom_champ_requete] = $query_result->CPT;
}
}
for($i=0; $i < count($services);$i++)
{
#########################################################
if("= '".$services[$i]['ID']."'" == $Vls_champs_actuel)
{
$Vls_selected = "selected";
}
else
{
$Vls_selected = "";
}
if( $_SESSION['config']['mail_count'] == "true" && isset($Vli_nbre_resultat_services[$services[$i]['ID']]) && is_numeric($Vli_nbre_resultat_services[$services[$i]['ID']]) )
{
$Vli_nbre_resultat = "(".$Vli_nbre_resultat_services[$services[$i]['ID']].")";
}
else if( $_SESSION['config']['mail_count'] == "true" )
{
$Vli_nbre_resultat = "(0)";
}
else
{
$Vli_nbre_resultat = "";
}
$Vls_affichage_tri .= "
";
}
##############################################
return $Vls_affichage_tri;
}
##############################################################################################
### tri_theme
###
### Permet de trier par theme
### Affiche la liste des themes que la personne a
###
##############################################################################################
function tri_theme($Vls_champs_actuel,$Vls_nom_champ_requete)
{
GLOBAL $_SESSION;
$db = new dbquery();
$db->connect();
$db2 = new dbquery();
$db2->connect();
######################################################
$Vli_id_service_user = $_SESSION['user']['department'];
######################################################
### Récupération de la requête
######################################################
$Vls_select = $_SESSION['gtb']['gtb_select'];
$Vls_from = $_SESSION['gtb']['gtb_from'];
$Vls_where = $_SESSION['gtb']['gtb_where'];
$Vls_group_by = $_SESSION['gtb']['gtb_group_by'];
$Vls_order_by = $_SESSION['gtb']['gtb_order_by'];
$Vls_limit = $_SESSION['gtb']['gtb_limit'];
######################################################
### Récupération de la liste des thèmes dont
### l'utilisateur à les droits
######################################################
$query_liste_theme = "
SELECT
d.id,
d.label
FROM
domains d,
domain_service ds
WHERE
ds.id_service = \"$Vli_id_service_user\"
AND ds.id_domain = d.id
";
$db->query($query_liste_theme);
######################################################
### Création du menu déroulant
######################################################
$Vls_affichage_tri = "
";
//On cree une requete imbrique
$req_imbrique = "
SELECT
$Vls_select
FROM
$Vls_from
";
if($Vls_where!="")
{
$req_imbrique .= "
WHERE
$Vls_where
";
}
if($Vls_group_by!="")
{
$req_imbrique .= "
GROUP BY
$Vls_group_by
";
}
$query_nbre_resultat_theme =
"SELECT ".$Vls_nom_champ_requete.", COUNT(".$Vls_nom_champ_requete.") AS CPT
FROM (".$req_imbrique.") temp
GROUP BY temp.".$Vls_nom_champ_requete;
$query_theme = $db2->query( $query_nbre_resultat_theme );
while( $resultat_query_theme = $db2->fetch_object($query_theme) )
{
$Vli_nbre_resultat_theme[$resultat_query_theme->$Vls_nom_champ_requete] = $resultat_query_theme->CPT;
}
while( $var_liste_theme = $db->fetch_array() )
{
$Vli_id_theme = $var_liste_theme[0];
$Vls_nom_theme = $var_liste_theme[1];
if(" = '".$Vli_id_theme."'" == $Vls_champs_actuel)
{
$Vls_selected = "selected";
}
else
{
$Vls_selected = "";
}
if( isset($Vli_nbre_resultat_theme[$Vli_id_theme]) && is_numeric($Vli_nbre_resultat_theme[$Vli_id_theme]) )
$Vli_nbre_resultat = "(".$Vli_nbre_resultat_theme[$Vli_id_theme].")";
else
$Vli_nbre_resultat = "(0)";
$Vls_affichage_tri .= "
";
}
##############################################
return $Vls_affichage_tri;
}
##############################################################################################
### tri_motif_redirection
###
### Permet de trier par motif de redirection
###
##############################################################################################
function tri_motif_redirection($Vls_champs_actuel,$Vls_nom_champ_requete)
{
GLOBAL $_SESSION;
$letterbox_xml_path = "xml/letterbox.xml";
$db = new dbquery();
$db->connect();
######################################################
### Récupération de la requête
######################################################
$Vls_select = $_SESSION['gtb']['gtb_select'];
$Vls_from = $_SESSION['gtb']['gtb_from'];
$Vls_where = $_SESSION['gtb']['gtb_where'];
$Vls_group_by = $_SESSION['gtb']['gtb_group_by'];
$Vls_order_by = $_SESSION['gtb']['gtb_order_by'];
$Vls_limit = $_SESSION['gtb']['gtb_limit'];
######################################################
### Récupération de la liste des motifs de redirection
######################################################
if( $letterbox_xml = @DOMDocument::load($letterbox_xml_path) )
{
$xp_letterbox = new domxpath($letterbox_xml);
foreach( $xp_letterbox->query("/ROOT/MAIL_ACTION/ACTION/ID") as $ID )
{
if( $LABEL = $xp_letterbox->query("/ROOT/MAIL_ACTION/ACTION[ID='".$ID->nodeValue."']/LABEL")->item(0)->nodeValue )
{
if( strcasecmp(mb_detect_encoding($LABEL),"UTF-8") == 0 )
$LABEL = utf8_encode(utf8_decode($LABEL));
$liste_motif[$ID->nodeValue] = utf8_decode($LABEL);
}
}
}
######################################################
### Création du menu déroulant
######################################################
//Tous Motifs (par défaut)
$Vls_affichage_tri = "
";
//On cree une requete imbrique
$req_imbrique = "
SELECT
$Vls_select
FROM
$Vls_from
";
if($Vls_where!="")
{
$req_imbrique .= "
WHERE
$Vls_where
";
}
if($Vls_group_by!="")
{
$req_imbrique .= "
GROUP BY
$Vls_group_by
";
}
$query_nbre_resultat_tri =
"SELECT ".$Vls_nom_champ_requete.", COUNT(*) AS CPT
FROM (".$req_imbrique.") temp
GROUP BY temp.".$Vls_nom_champ_requete;
$query_tri = $db->query( $query_nbre_resultat_tri );
while( $resultat_query_tri = $db->fetch_object($query_tri) )
{
$Vli_nbre_resultat_tri[$resultat_query_tri->$Vls_nom_champ_requete] = $resultat_query_tri->CPT;
}
//Aucun Motif
$query_null = $db->query( " SELECT COUNT(*) AS CPT
FROM (".$req_imbrique.") temp
WHERE temp.".$Vls_nom_champ_requete." IS NULL");
if( $resultat_query_null = $db->fetch_object($query_null) )
{
$Vli_nbre_resultat = "(".$resultat_query_null->CPT.")";
}
else
{
$Vli_nbre_resultat = "(0)";
}
//Aucun Motif
if( " IS NULL " == $Vls_champs_actuel )
{
$Vls_selected = "selected";
}
$Vls_affichage_tri .= "
";
foreach( $liste_motif as $k_lm => $v_lm )
{
if( " = '".$k_lm."'" == $Vls_champs_actuel)
{
$Vls_selected = "selected";
}
else
{
$Vls_selected = "";
}
$Vli_nbre_resultat = "";
if($_SESSION['config']['mail_count'] == "true")
{
if( isset($Vli_nbre_resultat_tri[$k_lm]) && is_numeric($Vli_nbre_resultat_tri[$k_lm]) )
{
$Vli_nbre_resultat = "(".$Vli_nbre_resultat_tri[$k_lm].")";
}
else
{
$Vli_nbre_resultat = "(0)";
}
}
$Vls_affichage_tri .= "
";
}
##############################################
return $Vls_affichage_tri;
}
?>