create_concept_string();
//bloc recuperation infos cluster
$resultat=mysql_query("SELECT label_1,label_2,periode,concept FROM cluster WHERE id_cluster=".$id_cluster." AND periode=\"".derange_periode($periode)."\" ORDER by periode,concept") or die ("Requête non executée.");
while ($ligne=mysql_fetch_array($resultat)) $cluster[]=$ligne;
//bloc recuperation infos termes
$resultat=mysql_query("select id,forme_principale FROM concepts ORDER by forme_principale") or die ("Requête non executée.");
while ($ligne=mysql_fetch_array($resultat)) $liste_termes[$ligne['id']] = $ligne['forme_principale'];
//bloc recuperation infos phylogenie
$sql="SELECT id_cluster_2,periode_2 FROM phylo WHERE id_cluster_1=\"".$id_cluster."\" AND periode_1=\"".derange_periode($periode)."\"";
$resultat=mysql_query($sql) or die ("Requête non executée.");
while ($ligne=mysql_fetch_array($resultat)) {$periode_avant_temp = $ligne['periode_2']; if (intval($periode_avant_temp)< intval($periode)){$predecesseur[] = $ligne['id_cluster_2']; $periode_avant =$periode_avant_temp; } }
$sql="SELECT id_cluster_1,periode_1 FROM phylo WHERE id_cluster_2=\"".$id_cluster."\" AND periode_2=\"".derange_periode($periode)."\"";
$resultat=mysql_query($sql) or die ("Requête non executée.");
while ($ligne=mysql_fetch_array($resultat)) {$periode_apres_temp = $ligne['periode_1'];if (intval($periode_apres_temp)> intval($periode)) {$successeur[] = $ligne['id_cluster_1']; $periode_apres = $ligne['periode_1']; }}
//on ferme l'acces à la base de donnees
mysql_close();
echo '<p><table width=100% class=tableitems>';
echo '<tr valign=top><td width=2.5%></td><td><h2 class=subtitle>champ thématique "<i>'.$dico_termes[$cluster[0]["label_1"]].'</i><i style="font-weight:normal;"> - '.$dico_termes[$cluster[0]["label_2"]].'"</i> <i style="font-size:x-small; font-weight:normal;">(#'.$id_cluster.')</i></h2></td><td width=2.5%></td></tr>';
echo '<table width=100%>';
echo '<tr valign=top><td width=2.5%></td><td><div class=subbanner>période '.get_string_periode($periode).'</div></td><td width=2.5%></td></tr>';
echo '</table>';
}
//*******************************************
//bloc récupération des sources
//*******************************************
//$resultat=mysql_query("select id,auteurs FROM auteurs ORDER by auteurs") or die ("Reque non executée.");
$resultat = mysql_query("SELECT auteurs.id, auteurs\nFROM socsem, auteurs\nWHERE auteurs.id = socsem.auteur\nGROUP BY socsem.auteur ORDER by auteurs\n") or die("Requête non executée sur socsem.");
// $resultat=mysql_query("SELECT id, auteurs
// FROM auteurs ORDER by auteurs
// ") or die ("Requête non executée sur socsem.");
while ($ligne = mysql_fetch_array($resultat)) {
$nom_auteurs[] = $ligne["auteurs"];
$id_auteurs[] = $ligne["id"];
$dico_auteurs[$ligne["id"]] = $ligne["auteurs"];
}
$id_auteurs_reduit = array();
$sql = "select id_auteur FROM biparti WHERE periode ='" . derange_periode($my_period) . "' GROUP by id_auteur ";
$resultat = mysql_query($sql) or die("Reqe non executée.");
while ($ligne = mysql_fetch_array($resultat)) {
$champ_aut_id = $ligne["id_auteur"];
if ($champ_aut_id[0] = '[') {
$champ_aut_id = str_replace('[', '', $champ_aut_id);
$champ_aut_id = str_replace(']', '', $champ_aut_id);
$champ_aut_id = explode(', ', $champ_aut_id);
for ($i = 0; $i < count($champ_aut_id); $i++) {
$id_auteurs_reduit[] = $champ_aut_id[$i];
$dico_auteurs_reduit[$champ_aut_id[$i]] = $dico_auteurs[$champ_aut_id[$i]];
}
} else {
$id_auteurs_reduit[] = $champ_aut_id;
$dico_auteurs_reduit[$champ_aut_id] = $dico_auteurs[$champ_aut_id];
}
echo $orphan_filter;
foreach ($periodes as $per )
{
$clusters_pertinents=array();
if ($list_of_periods[count($list_of_periods)-1]==$per)
{$clause_fils_pere = '';}
else
{$clause_fils_pere = ' AND nb_sons+nb_fathers>='.$orphan_filter;}
$quer="select id_cluster FROM cluster WHERE periode ='".derange_periode($per)."'".$clause_fils_pere." GROUP by id_cluster ORDER by id_cluster";
echo "<br>";
echo $quer;
$resultat=mysql_query($quer) or die ("<b>Requête non exécutée</b>.");
while ($ligne=mysql_fetch_array($resultat)){
$clusters_pertinents[] = $ligne['id_cluster'];}
echo '<br> clusters pertinents:<br>';
print_r($clusters_pertinents);
echo '<br>';
$carte_per =$mapgexf.$per."_gs.gexf";
// echo '<br>';
echo '<br>';
echo $carte_per;
echo '<br>';
echo '<input type="hidden" value="'.$label2.'" name="label2">';
echo '<input type="submit" value="Changer">';
echo '</form>';
echo "</tr></table>";
echo '<td width=2.5%></td></tr></table>';
echo "<p>";
//AFFICHAGE CONTENU DES CLUSTERS
echo "<table width=100% class=tableitems><tr valign=top><td width=2.5%></td><td width=95%>";
$my_clusters_all=$clusters[derange_periode($my_period)];
foreach ($my_clusters_all as $kmy=>$my) {
$my_clusters[$kmy]=$my["ids"];
$my_letters[$kmy]=$my["info"];
}
ksort($my_clusters);
echo '<table width=100% class=commentitems><tr valign=top><td width=100% style="font-style:italic;">';
echo 'Il existe en effet plusieurs champs thématiques désignés par cette paire d\'étiquettes "terme générique - </b>terme spécifique<b>"</b><br>Voici la liste des termes communs à tous ces champs thématiques:</td></tr></table>';
//echo 'IL EXISTE EN EFFET PLUSIEURS CHAMPS THÉMATIQUES DÉSIGNÉS PAR CETTE PAIRE D\'ÉTIQUETTES "<b>TERME GÉNÉRIQUE - </b>TERME SPÉCIFIQUE"</b><br>VOICI LA LISTE DES TERMES COMMUNS À TOUS CES CHAMPS THÉMATIQUES:</td></tr></table>';
echo '<table width=100% class=tableitems><tr valign=top><td width=100% style="font-size:10pt; font-style:italic; font-variant:small-caps;"><b>';
echo 'termes communs aux champs thématiques étiquetés par "'.$dico_termes[$label1].' - </b>'.$dico_termes[$label2].'<b>"</b></td></tr></table>';
//echo "<h2 class=inverted>\"</h2>";
<?
include("login_check.php");
include("include/header.php");
//connexion a la base de donnees
include("banner.php");
include("parametre.php");
include("library/fonctions_php.php");
if( isset( $_GET['id_label'] ) ) $id_label = ( $_GET['id_label'] );//id du label du noeud
if( isset( $_GET['id_label1'] ) ) $id_label1 = ( $_GET['id_label1'] );//id du label du noeud
if( isset( $_GET['id_label2'] ) ) $id_label2 = ( $_GET['id_label2'] );//id du label du noeud
if( isset( $_GET['type'] ) ) $type = ( $_GET['type'] );//type de labellisation generique/specifique
if( isset( $_GET['periode'] ) ) $my_period =derange_periode($_GET['periode']);// periode
else $my_period = '-1';
connexion_base($server,$user,$password,$database);
//bloc recuperation infos du noeud de la carte:
//un noeud= un ensemble de clusters qui partagent le même label.
$resultat=mysql_query("select id,forme_principale FROM concepts ORDER by forme_principale") or die ("Requête non executée.");
while ($ligne=mysql_fetch_array($resultat)) $liste_termes[$ligne['id']] = $ligne['forme_principale'];
create_concept_string();
if ($type=="s")
{
$sql ="select id_cluster FROM cluster WHERE periode = \"".$my_period."\" and label_2 = \"".$id_label."\" GROUP by id_cluster";//on s'attache à extraire l'ensemble des clusters associés au label specifique donné
}
elseif ($type=="g")
echo "</div>";
}
else {
echo '<table class=tableitems width=100% rules=groups>';
echo '<tr style="font-variant:small-caps; font-size:small; margin-top:2px; margin-bottom:-2px;">';
echo '<td>nom du champ auquel participe la source</td>';
echo '<td width=45pt></td>';
echo '<td>↑/↓</td>';
echo '<td width=5%></td>';
echo '<td>numéros des billets';
//echo '<br>(voir aussi l\'onglet "billets")';
echo '</td>';
echo '</tr>';
foreach ($periode_a_faire as $pp) {
$pp=derange_periode($pp);
$c=$clusters[$pp];
$cstr=array();
if (count($c)>0){ //y-a-t-il au moins des clusters pour la periode?
if ($my_period==-1)
echo "<tr><td class=small>période ".get_string_periode(arrange_periode($pp))."</td></tr>";
foreach ($c['clusters'] as $cp) {
$resultat=mysql_query("SELECT label_1,label_2,lettre,nb_sons,nb_fathers FROM cluster WHERE id_cluster=".$cp['id']." AND periode=\"".$cp['periode']."\" ORDER by periode,concept") or die ("Requête non executée.");
while ($ligne=mysql_fetch_array($resultat)) $clu_tmp[]=$ligne;
$clu_tmp=end($clu_tmp);
$label1=$clu_tmp['label_1'];
$label2=$clu_tmp['label_2'];
$lettre=$clu_tmp['lettre'];
$nbsons=$clu_tmp['nb_sons'];
$nbfathers=$clu_tmp['nb_fathers'];
$hrefh='href=cluster.php?id_cluster='.$cp['id'].'&periode='.arrange_periode($cp['periode']).'>';
if (in_array($identifiant_unique,$clusterdeja)) {echo '<br>deja vu<br>';}
else
{
$list_of_concepts=array();
$periode=$lignede['periode'];
echo $id_cluster."<br>";
$periode = str_replace(' ','-',$periode);
echo $periode."<br>";
$list_of_concepts=array();
$sql="SELECT concept FROM cluster WHERE id_cluster=".$id_cluster." AND periode=\"".derange_periode($periode)."\"";
//echo $sql;
$resultat=mysql_query($sql) or die ("Requête non executée.");
while ($ligne=mysql_fetch_array($resultat)) $list_of_concepts[]=$ligne['concept'];
//// BLOC COMPOSITION
$liste_of_posts = scan_billet($list_of_concepts,$periode);
$temps_fin3 = microtime_float();
function display_cluster_title ($s, $direction) {
global $dico_termes,$mainloc,$arraykey,$last_display_periode,$jscriptmp,$my_period,$nav;
$label1=$s['label1'];
$label2=$s['label2'];
$lettre=$s['lettre'];
$shref='cluster.php?id_cluster='.$s['id']."&periode=".arrange_periode($s['periode']).'&nav='.$nav;
$speriode=get_short_string_periode(arrange_periode($s['periode']),0,1);
$stitle='"<b>'.remove_popo($dico_termes[$label1]).'</b> - '.remove_popo($dico_termes[$label2]).'"';
// $periodchange indique si on a un changement de période par rapport au dernier champ thématique affiché
$periodchange=($last_display_periode!=$s['periode']);
$ecart=floor(abs(compute_periode(derange_periode($my_period))-compute_periode($s['periode']))/7001000);
//if ($periodchange && $last_display_periode!="")
// echo '<tr style="background:white;"><td></td><td></td><td></td><td><hr class="dashed"></td></tr>';
//else
{ //if (!$periodchange)
echo '<tr style="height:4px;font-size:0pt;'.($ecart>0?' background:white;':'').'"><td> </td><td></td><td></td><td></td></tr>';
}
echo '<tr width=100% valign=top'.($ecart>0?' style="background:white;"':'').'>';
echo '<td class=commentitems style="font-size:xx-small;">';
if ($ecart>0 && $periodchange) echo ("<b>...</b> ");
echo '</td>';
echo '<td class=commentitems style="font-size:xx-small;">';
if ($last_display_periode!=$s['periode']) echo $speriode." ";
if ($ecart>0 && $periodchange) echo "<br/><b> [".($direction=="succ"?"+":"-").($ecart+1)." sem.] </b>";
echo '</td>';
$sbox=selective_column_tt($arraykey,$s['termes'],$s['plus'],$s['minus']);
$sid=$s['id']."_".str_replace(" ","_",$s['periode']);
if ($direction=="succ")
{ if (intval($s['fils'])>0) $sarrow='↓ '; }
else
{ if (intval($s['pere'])>0) $sarrow='↑ '; }
echo '<td>';
$jscriptmp.=display_helper('(période '.get_string_periode(arrange_periode($s['periode'])).')','<div style="font-variant:small-caps;"><a href='.$shref.'>'.$sarrow.$stitle.'</a></div><br>'.$sbox,$sid,"magnify-wide.png","resizable: true");
echo '</td>';
echo '
<td class=tableitems style="font-variant:small-caps; size:small; font-style:italic;">';
echo '
<span onMouseOver="ShowContent(\'box'.$sid.'\'); ShowContent(\'title'.$sid.'\'); HideContent(\'mainbox\'); HideContent(\'maintitle\');"
onMouseOut="HideContent(\'box'.$sid.'\'); HideContent(\'title'.$sid.'\'); ShowContent(\'mainbox\'); ShowContent(\'maintitle\');">';
echo '<a id="'.$sid.'" href="'.$shref.'">';
echo '<span style="font-style:normal;">'.$sarrow.'</span>'.$stitle;
if ($lettre!="") echo ' ('.$lettre.')';
echo '</a>';
echo '</span>';
//echo '<a id="'.$sid.'" class="questionMark jTip jTip_element_'.$sid.'S jTip_width_300" name="Détails" href="'.$shref.'">';
//echo '<span id="'.$sid.'S" class="JT_hidden">';
//echo $sbox;
//echo '</span>';
echo '</td>';
echo '</tr>';
echo '<tr style="height:4px;font-size:0pt;'.($ecart>0?' background:white;':'').'"><td> </td><td></td><td></td><td></td></tr>';
echo '</td>';
$last_display_periode=$s['periode'];
}
if (intval($fils[$i])>0) $arrows=$arrows.'↓';
if (!array_key_exists($titre,$groupes_clusters)) $groupes_clusters[$titre]=array("titre"=>$titre,"id"=>$id,"homos"=>array(),"label"=>$liste_termes_brute_id[$i],"href"=>"");
$groupes_clusters[$titre]["homos"][]=array("id"=>$id,"arrows"=>$arrows);
}
uksort($groupes_clusters,"strcasecmpcam");
foreach ($groupes_clusters as $key => $value) {
if (count($value["homos"])>1) {
$tmp="";
for ($i=0;$i<count($value["homos"]);$i++){
$h=$value["homos"][$i];
$tmp.='<a class="dead" href="cluster.php?id_cluster='.$h["id"].'&periode='.$my_period.'">'.chr($i+65).$h["arrows"].'</a>';
$letter = chr($i+65);
$sql_update = "UPDATE cluster SET lettre ='".$letter."' where id_cluster=".$h["id"]." AND periode='".derange_periode($my_period)."'";
echo $sql_update;
mysql_query($sql_update);
if ($i!=count($value["homos"])-1) $tmp.=', ';
}
$groupes_clusters[$key]["href"]='<a href="meta12.php?label1='.$value["label"][0].'&label2='.$value["label"][1].'&periode='.$my_period.'">'.$value["titre"].'</a> ('.$tmp.')';
}
else
{
$href='href="cluster.php?id_cluster='.$value["id"].'&periode='.$my_period.'"';
$groupes_clusters[$key]["href"]='<a '.$href.'>'.$value["titre"].'</a> <a class="dead" '.$href.'>'.$value["homos"][0]["arrows"].'</a>';
}
<? // $query="SELECT slider_val FROM tbl_slider WHERE user='******'ID_my_site']."'"; // echo $query; // $result=mysql_query($query); // $row=mysql_fetch_array($result); // $pertinence = $row['slider_val']; // $pertinence =intval($pertinence)/100; $commande_sql_pert = "SELECT id_billet,overlap_size,billet_size from biparti where cluster = '".$id_cluster."' AND periode = '".derange_periode($my_period)."' AND overlap_size/cluster_size/log10(10+billet_size-overlap_size)>=".$pertinence.' and overlap_size/cluster_size>0.1 '.' ORDER BY overlap_size/cluster_size/log10(10+billet_size-overlap_size) DESC'; // echo $commande_sql_pert; $res_temp = mysql_query($commande_sql_pert); $liste_of_posts=array(); $liste_of_size=array(); //echo "\n<p><table width=100%><tr valign=top><td width=95%>"; echo ' <table class=tableitems width=100% cellspacing=0 cellpadding=1 style="font-variant:small-caps;">'; echo '<tr valign=top>'; // PANEL DE GAUCHE: PERIODES PRECEDENTES left_panel($p,$pred,$nopred,$backdarker,$backdark); echo '<td width=1%></td>';
$check2 = mysql_num_rows($resultat);
if ($check2==0) {
echo "<div class=subbanner><b>nb: ce terme n'apparaît dans aucun champ thématique pour la période ".get_string_periode(arrange_periode($periode))."</b></div>";
}
while( $row = mysql_fetch_array ( $resultat ))
{
$id_cluster = $row [ 'id_cluster' ];
$ids_cluster[] = $id_cluster;
$periodevar = arrange_periode($row [ 'periode' ]);
}
$concepts_voisins = export_concepts($ids_cluster,derange_periode($periode));
$concepts_voisins_string = get_concept_string($concepts_voisins);
echo "<td width=2.5%></td></tr></table>";
//on extrait d'abord la liste totale des périodes: $total_list_periods
$commande_sql = "SELECT periode from cluster GROUP BY periode";
$total_periode_sql=mysql_query($commande_sql);
while ($total_periode_sql_i=mysql_fetch_array($total_periode_sql))
{
$total_periods_raw[]=$total_periode_sql_i['periode'];
}
$total_list_periods=sort_periods($total_periods_raw);
while ($billes2=mysql_fetch_array($resultat2))
{
$label_1 = $billes2['forme_principale'];
}
$commande_sql2 = "SELECT forme_principale from concepts where id = '".$billes['label_2']."'";
$resultat2=mysql_query($commande_sql2);
while ($billes2=mysql_fetch_array($resultat2))
{
$label_2 = $billes2['forme_principale'];
}
$cluster_name =$label_1.' - '.$label_2.' ('.$id_cluster.', '.$my_period.')';
}
$commande_sql = "SELECT id_billet from biparti where cluster = '".$id_cluster."' AND periode = '".derange_periode($my_period)."'";
$resultat=mysql_query($commande_sql);
while ($billes=mysql_fetch_array($resultat))
{
$billet_index = $billes['id_billet'];
$sql_auteur = "SELECT auteur_id,site from billets where id = '$billet_index'";
$res_auteur=mysql_query($sql_auteur);
while ($sql_auteurs=mysql_fetch_array($res_auteur))
{
$auteurs[] = $sql_auteurs['auteur_id'];
$legende[$sql_auteurs['auteur_id']]=$sql_auteurs['site'];
}
}
$aut_occ = array_count_values($auteurs);
//print_r($aut_occ);
$d_c=date("Y-m-d", strtotime($newd));
//commentaire
echo "<td>";
echo $dt."</td><td width=40%>".'"<i>'.'<a href="'.$row['vue'].'">'.$row['commentaire'].'</a>'.'"</i>' ;
//type d'objet
echo "<td width=15%>";
if (intval($row['blog'])>0){
echo '<i>source</i>: '.$dictionaire_sources[$row['blog']];
}
if (intval($row['concept'])>0){
echo '<i>concept</i>: '.$dictionaire_termes[$row['concept']];
}
if (intval($row['cluster'])>0){
$resultats=mysql_query("select label_1, label_2 FROM cluster WHERE id_cluster=".$row['cluster']." AND periode = '".derange_periode($row['periode'])."' GROUP BY identifiant_unique") or die ("Requête non executée.");
while ($lignes=mysql_fetch_array($resultats)){
$cluster_name=$dictionaire_termes[$lignes['label_1']].'-'.$dictionaire_termes[$lignes['label_2']];}
echo '<i>cluster</i>: '.$cluster_name;
}
if (intval($row['cluster'])+intval($row['concept'])+intval($row['blog'])==0){
$urs = explode("?", $row['vue']);
$vue = $urs[0];
$urs = explode("/", $vue);
$vue = end($urs);
if ($vue=="entree_sources.php") $vue_txt='liste des sources';
if ($vue=="entree_clusters.php") $vue_txt='liste des clusters';
if ($vue=="entree_termes.php") $vue_txt='liste des termes';
if ($vue=="phylo.php") $vue_txt='liste des fils thématiques';
if ($vue=="global.php") $vue_txt='carte';
<?
//$commande_sql_pert = "SELECT id_billet,overlap_size,billet_size,cluster_size from biparti where cluster = '".$id_cluster."' AND periode = '".derange_periode($my_period)."' AND overlap_size/cluster_size/log10(10+billet_size-overlap_size)>=".$pertinence.' and overlap_size/cluster_size>0.1 '.' ORDER BY overlap_size/cluster_size/log10(10+billet_size-overlap_size) DESC';
//$commande_sql_pert = "SELECT id_billet,overlap_size,billet_size,cluster_size from biparti where cluster = '".$id_cluster."' AND periode = '".derange_periode($my_period)."' AND overlap_size/cluster_size/log10(10+billet_size-overlap_size)>=0.1 AND overlap_size/cluster_size>0.1 ORDER BY overlap_size/cluster_size/log10(10+billet_size-overlap_size) DESC";
$commande_sql_pert = "SELECT id_billet,overlap_size,billet_size,cluster_size from biparti where cluster = '".$id_cluster."' AND periode = '".derange_periode($my_period)."' AND overlap_size/cluster_size/log10(10+billet_size-overlap_size)>=0.1";
$res_temp = mysql_query($commande_sql_pert);
$liste_of_posts=array();
$liste_of_size=array();
echo '
<table class=tableitems width=100% cellspacing=0 cellpadding=1 style="font-variant:small-caps;">';
echo '<tr style="height:20px;"><td></td></tr>';
echo '<tr><td width=100% style="height:1px;background-color:SlateGray;"></td></tr>';
echo '<tr style="height:10px;"><td></td></tr>';
echo '<tr valign=top>';
echo '<td align=left width=100%>';
/////////////////////////////////////////////
///// ///// ///// ///// ///// /////
///// DEBUT DE L'AFFICHAGE DES BILLETS /////
///// ///// ///// ///// ///// /////
/////////////////////////////////////////////
echo '<table class=tableitems width=100% cellspacing=0 cellpadding=3>';
echo '<tr>';
echo '<td align=left style="font-variant:small-caps; font-size:x-small; font-weight:bold;">ENSEMBLE DES BILLETS ASSOCIÉS AU CHAMP AU-DELÀ DU SEUIL DE PERTINENCE</td>';
echo '<td width=5%></td>';
$jscriptmp.='
var select = $( "#pertinence" );
var slider = $( "#slider" ).slider({
if(isset( $_GET['periode'])) $my_period=$_GET['periode']; else $my_period=arrange_periode(end($list_of_periods));
$titleheader="liste des champs (".get_short_string_periode($my_period).")";
include("include/header.php");
include("banner.php");
//clause qui signale qu'on est à la dernière période
if ($list_of_periods[count($list_of_periods)-1]==$my_period)
{$clause_fils_pere = '';}
else
{$clause_fils_pere = ' AND nb_sons+nb_fathers>='.$orphan_filter;}
$quer="select id_cluster,label_1,label_2,periode, nb_sons,nb_fathers FROM cluster WHERE periode ='".derange_periode($my_period)."'".$clause_fils_pere." GROUP by id_cluster ORDER by periode, label_1, label_2, id_cluster";
$resultat=mysql_query($quer) or die ("<b>Requête non exécutée (mysql query)</b>.");
while ($ligne=mysql_fetch_array($resultat)){
$periode=arrange_periode($ligne['periode']);
$liste_termes_brute[] = "<b>".$dico_termes[$ligne['label_1']]."</b> - ".$dico_termes[$ligne['label_2']];
$liste_termes_brute_id[]=array($ligne['label_1'],$ligne['label_2']);
$id_termes_brute[] = $ligne['id_cluster'];
$fils[] = $ligne['nb_sons'] ;
$pere[] = $ligne['nb_fathers'] ;
}
$resultat=mysql_query("select periode FROM cluster GROUP by periode ORDER by periode") or die ("<b>Requête non exécutée</b>.");
while ($ligne=mysql_fetch_array($resultat)){
$periode_termes_brute[]=$ligne['periode'];}
echo '<table width=100% class=tableitems>';
echo '<tr valign=top><td width=2.5%></td>';
echo '<td width=95%>';
$jscriptmp.="$('.bigscrollPane').scrollbar;";
echo '<div class="bigscrollPane">';
echo '<table width=100% class=tableitems><tr>';
echo '<td width='.$widthcolumn.'%>';
if ($my_period!=-1) {
if ($clause_fils_pere=='')
$query_extension="WHERE periode ='".derange_periode($my_period)."'";
else
$query_extension="WHERE periode ='".derange_periode($my_period)."' AND ".$clause_fils_pere;
}
else {
if ($clause_fils_pere=='')
$query_extension="";
else
$query_extension="WHERE ".$clause_fils_pere;
}
$resultat=mysql_query("select concept FROM cluster ".$query_extension) or die ("Requête non exécutée.");
$liste_terme_cluster=array();
while ($ligne=mysql_fetch_array($resultat)){
if (!in_array($dico_termes[$ligne['concept']],$liste_terme_cluster))
{$liste_terme_cluster[]=$dico_termes[$ligne['concept']];}
}
