Agenda
Ecouter l'émission Agenda
/*
# Custom Bloc par HUSSON kévin
# LaNetScouade -> 21/10/2008
# Agenda
*/
$listeUsingCoord = array();
function testCoord($lat,$lon){
global $listeUsingCoord;
if(count($listeUsingCoord) > 0){
foreach($listeUsingCoord as $id => $array){
if($lat == $array['lat']){
$lat += 0.004;
}
if($lon == $array['lon']){
$lon += 0.002;
}
}
}
$listeUsingCoord[]['lat'] = $lat;
$listeUsingCoord[]['lon'] = $lon;
return $lat.’ », »‘.$lon;
}
function getImageggm($fieldValue){
if($fieldValue == ‘science_po’){
$img = ‘orange.png’;
$color = ‘orange’;
}
elseif($fieldValue ==’partenaire’){
$img = ‘bleu.png’;
$color = ‘blue’;
}
else{
$img = ‘vert.png’;
$color = ‘green’;
}
return array($img,$color);
}
?>
- Evenements RSP/Science Po
- Evenements des partenaires
- Evenements Autres Ecoles
$listAgenda2 = db_query('SELECT nr.teaser, cta.field_date_de_lvnement_value, cta.field_departement_value, cta.field_type_evenement_value, cta.field_lieu_value, n.nid, n.title FROM {node} n, {node_revisions} nr, {content_type_agenda} cta WHERE nr.nid = n.nid AND cta.nid = n.nid AND n.type = "agenda" AND cta.field_type_evenement_value="science_po" ');
if(db_num_rows($listAgenda2)){
while($res2 = db_fetch_array($listAgenda2)){
$date2 = strtotime(str_replace('T',' ',$res2['field_date_de_lvnement_value']));
$jour2 = date("d",$date2);
$mois2 = t(date("F",$date2));
$annee2 = date("Y",$date2);
$statutImg2 = getImageggm($res2['field_type_evenement_value']);
?>
}
}
else
echo 'Aucun Evènement.';
?>
$listAgenda3 = db_query('SELECT nr.teaser, cta.field_date_de_lvnement_value, cta.field_departement_value, cta.field_type_evenement_value, cta.field_lieu_value, n.nid, n.title FROM {node} n, {node_revisions} nr, {content_type_agenda} cta WHERE nr.nid = n.nid AND cta.nid = n.nid AND n.type = "agenda" AND cta.field_type_evenement_value="partenaire"');
if(db_num_rows($listAgenda3)){
while($res3 = db_fetch_array($listAgenda3)){
$date3 = strtotime(str_replace('T',' ',$res3['field_date_de_lvnement_value']));
$jour3 = date("d",$date3);
$mois3 = t(date("F",$date3));
$annee3 = date("Y",$date3);
$statutImg3 = getImageggm($res3['field_type_evenement_value']);
?>
}
}
else
echo 'Aucun Evènement.';
?>
$listAgenda4 = db_query('SELECT nr.teaser, cta.field_date_de_lvnement_value, cta.field_departement_value, cta.field_type_evenement_value, cta.field_lieu_value, n.nid, n.title FROM {node} n, {node_revisions} nr, {content_type_agenda} cta WHERE nr.nid = n.nid AND cta.nid = n.nid AND n.type = "agenda" AND cta.field_type_evenement_value="autreecole"');
if(db_num_rows($listAgenda4)){
while($res4 = db_fetch_array($listAgenda4)){
$date4 = strtotime(str_replace('T',' ',$res4['field_date_de_lvnement_value']));
$jour4 = date("d",$date4);
$mois4 = t(date("F",$date4));
$annee4 = date("Y",$date4);
$statutImg4 = getImageggm($res4['field_type_evenement_value']);
?>
}
}
else
echo 'Aucun Evènement.';
?>
$agendaSQL = db_query('SELECT n.title, n.nid, cta.field_date_de_lvnement_value, cta.field_type_evenement_value, cta.field_lieu_value, nr.teaser FROM {content_type_agenda} cta, {node} n, {node_revisions} nr WHERE nr.nid = n.nid AND n.nid=cta.vid AND n.type = "agenda" AND n.status = 1');
if(db_num_rows($agendaSQL)){
while($res5 = db_fetch_array($agendaSQL)){
$date5 = strtotime(str_replace('T',' ',$res5['field_date_de_lvnement_value']));
$jour5 = date('d',$date5);
$mois5 = t(date("F",$date5));
$annee5 = date("Y",$date5);
/* format_date(strtotime($res5['field_date_de_lvnement_value']),'custom','d/m/Y')*/
$statutImg5 = getImageggm($res5['field_type_evenement_value']);
?>
}
}
else
echo 'Aucun Evènements pour le moment.';
?>