$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 COMPOSITION echo "<table width=100%><tr valign=top><td width=2.5%></td><td width=95%>"; //agrégats $ncolumns=2; $count=count($cluster);$columns=array();$increment=0; $percolumn=ceil($count/$ncolumns);$widthcolumn=floor(100/$ncolumns)-3; for($i=1;$i<$ncolumns;$i++){$columns[$i]=array($increment,$increment+$percolumn-1);$increment+=$percolumn;}
$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); //on affiche les flèches pour se ballader dans les périodes display_arrow_periodes($my_period, $total_list_periods); echo '<form action="global.php" method="get" style="display:inline;">'; echo '<select name="periode">'; for ($i = 0; $i < count($list_of_periods); $i++) { echo '<option value=' . $list_of_periods[$i]; if ($list_of_periods[$i] == $my_period) { echo " selected"; } echo '>'; echo get_string_periode($list_of_periods[$i]); echo '</option>'; } echo '</select>'; echo '<input type="submit" value="' . $selecteur_periode . '">'; echo ' </form>'; echo "</td>"; echo '</tr></table>'; echo '</td><td width=2.5%></td>'; echo '</tr>'; echo "<tr valign=top>"; echo "<td width=2.5%></td>"; echo "<td width=95%>"; if (strlen($projection) > 0) { //$mapgexf = "http://maps.sciencemapping.com/temporaire.gexf"; } else {
//$clusters contient la liste des clusters, par periodes. echo "<table width=100%><tr valign=top><td width=2.5%></td><td width=95%>"; echo "<table width=100% class=specialsubbanner cellspacing=0>"; echo '<tr style="color:black; font-weight:bold;"><td align=left>'; echo "désambiguïsation"; echo "</td><td align=right>période sélectionnée: "; echo '<form action="meta12.php" method="get" style="display:inline";>'; echo '<select name="periode">'; foreach ($periodes as $periode) { echo '<option value='.arrange_periode($periode); if ($periode==arrange_periode($my_period)) echo(" selected"); echo '>'; echo get_string_periode(arrange_periode($periode)); echo '</option>'; } echo '</select>'; echo '<input type="hidden" value="'.$label1.'" name="label1">'; 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>";
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']).'>'; $href='<a '.$hrefh; $href12='<a href=meta12.php?label1='.$label1.'&label2='.$label2.'&periode='.$my_period.'>'; $ktmp='<b>'.$dico_termes[$label1].'</b> - '.$dico_termes[$label2]; //if ($lettre=="") $lettre="-"; $arrows="";
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']; }
function FTInfo($jscriptmp, $id_partition, $color_link) { $query = "select * FROM partitions WHERE id_partition=" . $id_partition; $resultat = mysql_query($query) or die("<b>Requête non exécutée (récupération de info de partition)</b>."); $partition_infos = mysql_fetch_array($resultat); // global $imagestar; $imagestar = imagestar($id_partition); $linkstarString = linkstarString($partition_infos[id_partition], $imagestar); // Construit le popup d'info d'un champs thématique $last_period_clusters = getPartitionLastPeriodClusters($id_partition); //// préparation des liens de fils thématiques $jscriptmp .= "\n\$('#dialogfilThematique" . $id_partition . "')\n.dialog({ autoOpen: false, stack: true, resizable: false, modal:true, width:600, closeOnEscape:true})\n.click(function () { \$('#dialogfilThematique" . $id_partition . "').dialog('close'); });\n\n\$('#openerfilThematique" . $id_partition . "').click(function(e) {\nif (!\$('#dialogfilThematique" . $id_partition . "').dialog('isOpen'))\n\$('#dialogfilThematique" . $id_partition . "').dialog('option','position', [\$(this).position().left+25,25]).dialog('open');\nelse\n\$('#dialogfilThematique" . $id_partition . "').dialog('close');\nreturn false;\n});"; if (strcmp($last_period_clusters[0][periode], $partition_infos[periodWithMaxScore]) == 0) { if (count($last_period_clusters) > 1) { $cluster_Link_html .= 'Ce fil thématique atteint le maximum de sa popularité sur sa période la plus récente (' . get_string_periode(str_replace(' ', '-', $last_period_clusters[0][periode])) . ') avec les champs suivants :<ul>'; for ($i = 0; $i < count($last_period_clusters); $i++) { $cluster_Link_html .= '<li><a href="' . $last_period_clusters[$i][attribut] . '"> <font color=blue>' . str_replace('---', '/', remove_popo($last_period_clusters[$i][label])) . '</font></a></li>'; } $cluster_Link_html .= '</ul>'; } else { $cluster_Link_html .= 'Ce fil thématique atteint le maximum de sa popularité sur sa période la plus récente avec le champ ' . '<a href="' . $last_period_clusters[0][attribut] . '"> <font color=blue>' . str_replace('---', '/', remove_popo($last_period_clusters[0][label])) . '</font></a> (période ' . get_string_periode(str_replace(' ', '-', $last_period_clusters[0][periode])) . ')'; } } else { $cluster_Link_html = '<p>' . $linkstarString . '</p>'; if (count($last_period_clusters) > 1) { $cluster_Link_html .= 'Ce fil thématique comporte plusieurs champs en dernière période (' . get_string_periode(str_replace(' ', '-', $last_period_clusters[0][periode])) . ') :<ul>'; for ($i = 0; $i < count($last_period_clusters); $i++) { $cluster_Link_html .= '<li><a href="' . $last_period_clusters[$i][attribut] . '"> <font color=blue>' . str_replace('---', '/', remove_popo($last_period_clusters[$i][label])) . '</font></a></li>'; } $cluster_Link_html .= '</ul>'; } else { $cluster_Link_html .= 'Le champ le plus récent de ce fil thématique est ' . '<a href="' . $last_period_clusters[0][attribut] . '"> <font color=blue>' . str_replace('---', '/', remove_popo($last_period_clusters[0][label])) . '</font></a> (période ' . get_string_periode(str_replace(' ', '-', $last_period_clusters[0][periode])) . ')'; } } $fils_thematique_html = '<a href scr=# id="openerfilThematique' . $id_partition . '"> <font color=' . $color_link . '>' . substr(remove_popo($partition_infos[label]), 0, -1) . '</font></a>'; echo '<span id="dialogfilThematique' . $id_partition . '" style="display:none;" title="' . str_replace('lpopostrophe ', "l'", $partition_infos[label]) . '">'; echo '<p>' . $cluster_Link_html . '</p>'; echo '<br/><b>Caractéristiques de ce fil thématique :</b>'; echo '<ul> <li type=circle>Couverture : du <span style="font-size: small;" >' . get_date("2009-12-31", $partition_infos[first_period]) . '</span> au <span style="font-size: small;" >' . get_date("2009-12-31", $partition_infos[last_period]) . '</span>' . '<li type=circle>' . $partition_infos['nb_period_covered'] . ' périodes couvertes,' . '<li type=circle>' . $partition_infos['nb_fields'] . ' champs thématiques au total, ' . '<li type=circle>' . $partition_infos['nb_terms'] . ' termes employés.' . '</ul>'; echo '</span>'; return array($jscriptmp, $fils_thematique_html); }