* @version $Id$ * @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') . "
\n"; if ($statut != -1) { $link_back = "
" . _t('newsletter','all') . "
"; $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') . "
\n"; else $count_request_display = _t('divers','query_result') . " : " . $count_request . " " . _t('divers','records') . "
\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 = "\n"; $js = " $('#statut_filter').change(function() { if($(this).val() != -1) window.location = $(this).val(); });"; footerAddInlineJS($js); ?>

\n"; echo "\n"; echo "\n"; echo "" . mb_ucfirst(_t('newsletter','title')) . "\n"; echo "".mb_ucfirst(_t('divers','date_crea'))."\n"; echo "".mb_ucfirst(_t('divers','date_publi'))."\n"; echo " " . mb_ucfirst(_t('divers','actions')) . "\n"; echo "\n"; echo "\n"; echo "\n"; for($i = 0; $i < count($result_newsletter_list); $i++) { $newsletter_title = formatText(cutText($result_newsletter_list[$i]['newsletter_title'], 70), '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'); if($newsletter_status == 'W') $newsletter_published_date = _t('newsletter','scheduled') . ' '; echo "\n"; echo "" . $newsletter_title . "\n"; echo "" . $result_newsletter_list[$i]['newsletter_date_crea_display'] . "\n"; echo "" . $newsletter_published_date . "\n"; echo "\n"; echo "
"; echo "\t" . _t('newsletter','sup') . "\n"; echo "\t" . _t('newsletter','mod') . "\n"; echo "
"; echo "\n"; echo "\n"; } echo "".PHP_EOL; echo "".PHP_EOL; } else { echo "
" . _t('newsletter','noresult') . "
".PHP_EOL; } echo linkin_page($link_self, $count_request, $debut); // Get subscribers list for displaying in colorbox if link is clicked // récupération des emails $emails_batch = $sql_object->DBSelect(SQL_GetEmails4Sending()); $count_emails_display = _t('divers','query_result') . " : " . count($emails_batch) . " " . _t('divers','records') . "
".PHP_EOL; $subscribers = '
'.PHP_EOL; $subscribers .= "

" . mb_ucfirst(_t('newsletter','subscribers_list')) . "

".PHP_EOL; $subscribers .= "

".$count_emails_display."

".PHP_EOL; if (!is_array($emails_batch)) { $subscribers .= "
" . _t('divers','nodata') . "
".PHP_EOL; } else { // Calling JS directly into code // using footerAddInlineJS() creat an error echo '​'.PHP_EOL; $subscribers .= "".PHP_EOL; $subscribers .= "".PHP_EOL; $subscribers .= "".PHP_EOL; $subscribers .= "".PHP_EOL; $subscribers .= "\n"; $subscribers .= "\n"; $subscribers .= "\n"; $subscribers .= "\n"; $subscribers .= "\n"; $subscribers .= "\n"; for($k = 0; $k < count($emails_batch); $k++) { $email_id = $emails_batch[$k]['emailcol_id']; $email_recipient = $emails_batch[$k]['emailcol_email']; $email_date_crea = $emails_batch[$k]['emailcol_date_crea_display']; // echo $email_id . ' '. $email_recipient. '
'; $subscribers .= "".PHP_EOL; $subscribers .= "".PHP_EOL; $subscribers .= "".PHP_EOL; $subscribers .= "".PHP_EOL; $subscribers .= "".PHP_EOL; } $subscribers .= "".PHP_EOL; $subscribers .= "
" . mb_ucfirst(_t('newsletter','email_address')) . "".mb_ucfirst(_t('divers','date_crea'))." " . mb_ucfirst(_t('divers','actions')) . "
".$email_recipient."".$email_date_crea."
".PHP_EOL; $subscribers .= "" . _t('newsletter','unsubscribe') . "".PHP_EOL; $subscribers .= "
".PHP_EOL; } $subscribers .= '
'.PHP_EOL; echo $subscribers; // Ability to sort table addDynamicCSS('../lib/js/jquery.tablesorter/theme.default.css'); footerAddJS('../lib/js/jquery.tablesorter/jquery.tablesorter.min.js'); $str = '$("table.multisort").tablesorter({ });'; footerAddInlineJS($str); // Newsletter Subscribers - Colorbox $str = 'var cboxOptions = { inline:true, innerWidth: "85%", innerHeight: "85%", maxWidth: "80%", maxHeight: "80%" } $("#subscribers").colorbox(cboxOptions); $(window).resize(function(){ $.colorbox.resize({ width: window.innerWidth > parseInt(cboxOptions.maxWidth) ? cboxOptions.maxWidth : cboxOptions.width, height: window.innerHeight > parseInt(cboxOptions.maxHeight) ? cboxOptions.maxHeight : cboxOptions.height }); }); '; $str .= '$("#subscribers-container").wrap(\'
<\/div>\');'; footerAddInlineJS($str); // // ajax code for unsubscribe user echo ''; ?>