File Source for list.php

<?php
/**
* @package linea21.modules
* @subpackage newsletter
* @author linea21 <info@linea21.com>
* @version $id SVN
* @access public
* @license http://opensource.org/licenses/gpl-3.0.html
*/
// ////////// Check Inclusion de pages ////////////
if (!class_exists('auth')) {
include_once("../lib/lib_common.php");
ReloadIndex('admin');
}
// //////////
//////////// Check Droits utilisateur ////////////
if (!$l21auth->isSuperAdmin()) ReloadIndex('admin');
////////////
if (!isset($_GET['statut']) || $_GET['statut'] == -1) $statut = -1;
elseif ($_GET['statut'] != -1) $statut = $_GET['statut'];
if (!isset($_GET['debut'])) $debut = 0;
else $debut = $_GET['debut'];
$mask_statut_1 = '';
$mask_statut_2 = '';
$mask_statut_3 = '';
if ($statut == 'public') $mask_statut_1 = 'selected="selected"';
if ($statut == 'draft') $mask_statut_2 = 'selected="selected"';
if ($statut == 'waiting') $mask_statut_3 = 'selected="selected"';
// Nombre d'enregistrement total dans la bdd
$result_nb_req = $sql_object->DBSelect(SQL_getCountNewsletterList(-1));
$bdd_nb_news = $result_nb_req[0]['num_rows'];
$bdd_nb_news_display = $bdd_nb_news . " " . _t('newsletter','nb_total') . "<br />\n";
if ($statut != -1) {
$link_back = "<div class=\"filter\"><a href=\"" . $rub_link . "&todo=list\">" . _t('newsletter','all') . "</a></div>";
$req_count_news = SQL_getCountNewsletterList($statut);
$result_nb_req = $sql_object->DBSelect($req_count_news);
$count_request = $result_nb_req[0]['num_rows'];
$req_list_newsletter = SQL_getNewsletterList($debut, SELECT_LIMIT, $statut);
$result_newsletter_list = $sql_object->DBSelect($req_list_newsletter);
} else {
$link_back = '';
$count_request = $bdd_nb_news;
$req_list_newsletter = SQL_getNewsletterList($debut, SELECT_LIMIT, $statut);
$result_newsletter_list = $sql_object->DBSelect($req_list_newsletter);
}
if ($count_request <= 1) $count_request_display = _t('divers','query_result') . " : " . $count_request . " " . _t('divers','record') . "<br />\n";
else $count_request_display = _t('divers','query_result') . " : " . $count_request . " " . _t('divers','records') . "<br />\n";
$link_sup = $rub_link . "&todo=sup&id=";
$link_mod = $rub_link . "&todo=mod&id=";
$link_det = $rub_link . "&todo=det&id=";
$link_statut = $rub_link . "&todo=list&statut=";
$link_self = $link_statut . $statut;
// Liste des statuts disponibles
$select_statut = "<select name=\"statut_filter\" id=\"statut_filter\" onchange=\"ChangeLocation(this)\">\n";
$select_statut .= "<option value=\"-1\">" . _t('newsletter','statut_filter') . "</option>\n";
$select_statut .= "<option value=\"" . $link_statut . "public\"" . $mask_statut_1 . ">"._t('statut','public')."</option>\n";
$select_statut .= "<option value=\"" . $link_statut . "draft\"" . $mask_statut_2 . ">"._t('statut','draft')."</option>\n";
$select_statut .= "<option value=\"" . $link_statut . "waiting\"" . $mask_statut_3 . ">"._t('statut','W')."</option>\n";
$select_statut .= "</select>\n";
?>
<div id="chemin">
<ul>
<li><a href="index.php" class="chemin_home"><?php echo _t('way','home'); ?></a></li>
<li><a href="<?php echo $rub_link; ?>" id="chemin_<?php echo $rub; ?>" class="chemin_rub"><?php echo _t('menu','newsletter'); ?></a></li>
<li><span><?php echo formatNavTitle(_t('newsletter','list')); ?></span></li>
</ul>
</div>
<?php
include_once(THEME_ADMIN_PATH."quickicons.php");
?>
<div class="contentcontainer"><?php include_once(override($dir.'/menurub.php', THEME_ADMIN_PATH));
?>
<div id="content">
<?php
echo $link_back;
?>
<div class="filterselect"><?php echo $select_statut; ?></div>
<p>
<?php
echo $bdd_nb_news_display;
echo $count_request_display;
?>
</p>
<?php
echo linkin_page($link_self, $count_request, $debut);
if ($result_newsletter_list != 0) {
echo "<table cellspacing=\"0\" cellpadding=\"3\">\n";
echo "<thead>\n";
echo "<tr>\n";
echo "<td>" . mb_ucfirst(_t('newsletter','title')) . "</td>\n";
echo "<td>".mb_ucfirst(_t('divers','date_crea'))."</td>\n";
echo "<td>".cutText(mb_ucfirst(_t('divers','date_publi')), 13, 1, '')."</td>\n";
echo "<td> <span class=\"semnone\">" . mb_ucfirst(_t('divers','actions')) . "</span></td>\n";
echo "</tr>\n";
echo "</thead>\n";
echo "<tbody>\n";
for($i = 0; $i < count($result_newsletter_list); $i++) {
$newsletter_title = formatText(cutText($result_newsletter_list[$i]['newsletter_title'], 53), '2HTML');
$newsletter_status = $result_newsletter_list[$i]['newsletter_statut'];
$newsletter_published_date = $newsletter_status=='P' ? $result_newsletter_list[$i]['newsletter_published_date_display'] : _t('statut','draft');
echo "<tr>\n";
echo "<td><a href=\"" . $link_det . $result_newsletter_list[$i]['newsletter_id'] . "\" title=\"" . _t('newsletter','det') . "\">" . $newsletter_title . "</a></td>\n";
echo "<td>" . $result_newsletter_list[$i]['newsletter_date_crea_display'] . "</td>\n";
echo "<td>" . $newsletter_published_date . "</td>\n";
echo "<td style=\"width:50px\">\n";
if ($newsletter_status != 'P') {
echo "<div class=\"iconetab\">";
echo "\t<a href=\"" . $link_sup . $result_newsletter_list[$i]['newsletter_id'] . "\" class=\"ico_sup\" title=\"" . _t('newsletter','sup') . "\"></a>\n";
echo "\t<a href=\"" . $link_mod . $result_newsletter_list[$i]['newsletter_id'] . "\" class=\"ico_mod\" title=\"" . _t('newsletter','mod') . "\"></a>\n";
echo "</div>";
} else echo ' ';
echo "</td>\n";
echo "</tr>\n";
}
echo "</tbody>";
echo "</table>";
} else {
echo "<div class=\"info\">" . _t('newsletter','noresult') . "</div>";
}
echo linkin_page($link_self, $count_request, $debut);
?></div>
<?php include_once(override($dir.'/help.php', THEME_ADMIN_PATH)); ?></div>

Source for file list.php