DBSelect(SQL_getNewsList($debut, $pas, $statut, $filter, $id_filter)); $datacount = $GLOBALS['sql_object']->DBSelect(SQL_getCountNewsList($statut, $filter, $id_filter)); $bdd_nb_com = $datacount[0]['num_rows']; $bdd_nb_com_display = '

' . $bdd_nb_com . ' ' . $GLOBALS['lang']['news']['name2'] . $suffix . '

' . END_LINE; $content = '

' . $GLOBALS['lang']['news']['list'] . '

' . END_LINE; if ($data != 0) { echo $bdd_nb_com_display; $current_link = array('rub' => $GLOBALS['links']['actualite-archives']['linkvalue']); Display_linkin_page($current_link, $bdd_nb_com, $debut, $pas); for($i = 0; $i < count($data); $i++) { $link_detail = array('rub' => $GLOBALS['links']['actualite']['linkvalue'], 'id' => $data[$i]['news_id']); $link_theme = array('rub' => $GLOBALS['links']['actualite']['linkvalue'], 'filter' => $GLOBALS['filter']['theme']['linkvalue'], 'id' => $data[$i]['sdtheme_id']); $link_level = array('rub' => $GLOBALS['links']['actualite']['linkvalue'], 'filter' => $GLOBALS['filter']['niveau']['linkvalue'], 'id' => $data[$i]['news_level']); $link_scale = array('rub' => $GLOBALS['links']['actualite']['linkvalue'], 'filter' => $GLOBALS['filter']['echelle']['linkvalue'], 'id' => $data[$i]['news_scale']); $link_user = array('rub' => $GLOBALS['links']['profil-utilisateur']['linkvalue'], 'id' => $data[$i]['news_posted_by']); $news_title = formatText($data[$i]['complete_news_title'], '2HTML'); $news_header = formatText(cutText($data[$i]['news_header'], 150), '2HTML'); $news_sdtheme = formatText($data[$i]['sdtheme_name'], '2HTML'); $level_name = formatText($data[$i]['level_name'], '2HTML'); $scale_denomination = formatText($data[$i]['scale_denomination'], '2HTML'); $news_posted_on = formatText($data[$i]['news_published_date_display'], '2HTML'); $news_posted_by = formatText($data[$i]['user_login'], '2HTML'); $content .= '

' . $news_title . '' . END_LINE; $content .= '

' . END_LINE; $content .= '

' . $news_header . '

' . END_LINE; $content .= '

' . END_LINE; $content .= ' ' . $GLOBALS['lang']['statut']['published_on'] . ' ' . $news_posted_on . ' '; $content .= $GLOBALS['lang']['divers']['by'].' ' . $news_posted_by . ''; $content .= '' . END_LINE; $content .= '

' . END_LINE; $content .= '

' . $level_name . ' ' . END_LINE; $content .= ' ' . $news_sdtheme . '' . END_LINE; $content .= ' ' . $scale_denomination . '

' . END_LINE; $content .= '
' . END_LINE; } } else { $content .= '

' . $GLOBALS['lang']['divers']['nodata'] . '

'; } echo $content; } /** * DisplayOneNews() * Affichage d'une actualté en détail * * @param $news_id * @return $stat Nom du statut + echo content */ function DisplayOneNews($news_id) { $data = $GLOBALS['sql_object']->DBSelect(SQL_getoneCompleteNews($news_id)); $content = ''; if (count($data) != 1) exit; else { $link_theme = array('rub' => $GLOBALS['links']['actualite']['linkvalue'], 'filter' => $GLOBALS['filter']['theme']['linkvalue'], 'id' => $data[0]['theme_sd_theme']); $link_level = array('rub' => $GLOBALS['links']['actualite']['linkvalue'], 'filter' => $GLOBALS['filter']['niveau']['linkvalue'], 'id' => $data[0]['news_level']); $link_scale = array('rub' => $GLOBALS['links']['actualite']['linkvalue'], 'filter' => $GLOBALS['filter']['echelle']['linkvalue'], 'id' => $data[0]['news_scale']); $link_user = array('rub' => $GLOBALS['links']['profil-utilisateur']['linkvalue'], 'id' => $data[0]['news_posted_by']); $news_title = formatText($data[0]['news_title'], '2HTML'); $news_header = linkin_content(formatText($data[0]['news_header'], '2HTML')); $news_body = linkin_content(formatText($data[0]['news_body'], '2HTML')); $news_template = $data[0]['news_template']; $news_photo_uri = $data[0]['news_photo_uri']; $news_sdtheme = formatText($data[0]['sdtheme_name'], '2HTML'); $news_scale_denomination = formatText($data[0]['scale_denomination'], '2HTML'); $news_theme = formatText($data[0]['theme_name'], '2HTML'); $news_level = formatText($data[0]['level_name'], '2HTML'); $news_posted_on = formatText($data[0]['news_published_date_display'], '2HTML'); $news_modify_on = formatText($data[0]['news_last_modify_display'], '2HTML'); $news_posted_by = formatText($data[0]['user_login'], '2HTML'); $news_statut = $data[0]['news_statut']; $contents = TemplateFormat($news_title, $news_header, $news_body, $news_template, $news_photo_uri); $content .= '

' . $news_title . '

' . END_LINE; $content .= $contents; $content .= '

' . END_LINE; $content .= ' ' . $GLOBALS['lang']['statut']['published_on'] . ' ' . $news_posted_on . ' '; $content .= $GLOBALS['lang']['divers']['by'].' ' . $news_posted_by . ''; if ($news_statut == 'PA') { $content .= ' (' . $GLOBALS['lang']['statut']['archived_on'] . ' ' . $news_modify_on . ')'; } $content .= '' . END_LINE; $content .= '

' . END_LINE; $content .= '
'; $content .= '

' . $GLOBALS['lang']['divers']['level'] . ' : ' . $news_level . ' ' . END_LINE; $content .= '' . $GLOBALS['lang']['divers']['themeref'] . ' : ' . $news_sdtheme . ' ' . $GLOBALS['lang']['divers']['sousthemeref'] . ' :' . $news_theme . END_LINE; $content .= '' . $GLOBALS['lang']['divers']['scale'] . ' : ' . $news_scale_denomination . '' . END_LINE; $content .= '

' . END_LINE; } echo $content; return GetStatutName($news_statut); } /** * GetStatutName() * * @param $statut * @return $stat Nom du statut */ function GetStatutName($statut) { switch ($statut) { case 'P': $stat = 'public'; break; case 'PA': $stat = 'archives_p'; break; case 'AA': $stat = 'archives_a'; break; default: $stat = 'public'; } return $stat; } /** * DisplayLinkNews() * Affiche ou non 1 lien vers les news a venir ou qui précéde. * * @param $current_news * @param $direction * @param $statut * @return echo content */ function DisplayLinkNews($current_news, $direction, $statut) { if ($direction == 'NEXT') { $requete = SQL_getNextNews($current_news, $statut); $class = 'next'; $prefix = '> > '; $suffix = ''; $title = $GLOBALS['lang']['news']['next_news']; } if ($direction == 'PREVIOUS') { $requete = SQL_getPreviousNews($current_news, $statut); $class = 'previous'; $prefix = ''; $suffix = ' < <'; $title = $GLOBALS['lang']['news']['prev_news']; } $data = $GLOBALS['sql_object']->DBSelect($requete); if ($data == false || count($data) != 1) $content = ''; else { $link_news = array('rub' => $GLOBALS['links']['actualite']['linkvalue'], 'id' => $data[0]['news_id']); $news_title = formatText(cutText($data[0]['news_title'], 50), '2HTML'); $content = '
' . END_LINE; $content .= $prefix; $content .= '' . $news_title . ''; $content .= $suffix; $content .= '
' . END_LINE; } echo $content; } /** * TemplateFormat() * Mise en page de l'actualité suivant son format * * @param $title * @param $header * @param $body * @param $template * @param $photouri * @return $content */ function TemplateFormat($title, $header, $body, $template, $photouri) { // '3' Template 2 photos if ($template == 3) { list($photo1_src, $photo2_src) = GetAllPhotoUri($photouri); list($body, $body2) = cutBody($body); } if ($template == 1 || $template == 2) list($photo1_src) = GetAllPhotoUri($photouri); if ($template == 1) $style = ' class="tplimgleft"'; if ($template == 2 || $template == 3) $style = ' class="tplimgright"'; $content = '
'; if ($template != 4) $content .= EnlargeImage('../' . $photo1_src, $style, 'visuel ' . $title); $content .= '

' . $header . '

' . END_LINE; $content .= '

' . $body . '

' . END_LINE; if ($template == 3) { $style = ' class="tplimgleft"'; $content .= EnlargeImage('../' . $photo2_src, $style, 'visuel ' . $title); $content .= '

' . $body2 . '

' . END_LINE; } $content .= '
'; $content .= '
'; return $content; } ?>