<?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 (!function_exists('AuthenthificationProcess')) {
    include_once("../lib/lib_common.php");
    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 . "&amp;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 . "&amp;todo=sup&amp;id=";
$link_mod = $rub_link . "&amp;todo=mod&amp;id=";
$link_det = $rub_link . "&amp;todo=det&amp;id=";
$link_statut = $rub_link . "&amp;todo=list&amp;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_<? echo $rub; ?>" class="chemin_rub"><?php echo _t('menu','newsletter');
?></a>
		</li>
		<li>
			<span><?php echo formatNavTitle(_t('newsletter','list'));
?></span>
		</li>
	</ul>
</div>
  <!--end barre haute -->
<?php
include_once(THEME_ADMIN_PATH."quickicons.php");

?>
<div class="contentcontainer">
<?php include_once($dir . "/menurub.php");
?>
<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>" . _t('newsletter','title') . "</td>\n";
    echo "<td>"._t('divers','date_crea')."</td>\n";
	echo "<td>".cutText(_t('divers','date_publi'), 13, 1, '')."</td>\n";
    echo "<td>&nbsp;<span class=\"semnone\">" . _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 '&nbsp;';
        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($dir . "/help.php");
?>
</div>
  
