* @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'); //////////// include_once(override('../vote/display.php')); if(isset($_GET['statut']) && $_GET['statut'] != -1) { $status=$_GET['statut']; $status_q=array($_GET['statut']); } else { $status = -1; $status_q = array('P', 'D', 'E'); } if(isset($_GET['module']) ) { $module=$_GET['module']; } else { $module= 'all'; } if(!isset($_GET['debut'])) $debut=0; else $debut=$_GET['debut']; $mask_statut_1=''; $mask_statut_2=''; $mask_statut_3=''; $mask_statut_4=''; $mask_statut_5=''; $mask_statut_6=''; $mask_statut_7=''; if($status=='public') $mask_statut_1='selected="selected"'; if($status=='draft') $mask_statut_2='selected="selected"'; // Nombre d'enregistrement total dans la bdd $r = $sql_object->DBSelect(SQL_getTotalCountNumber()); $nb=$r[0]['nb']; $nb_comments = sprintf(_t('comment','nb_total'), $nb); $comm = new comment(); if($module=='all') { // tous les commentaires sont retournés !!! // et la pagination est effectuée ici via array_slice() // @todo Optimiser $data = $data_all = $comm->getAllByModule($status_q, $sql_object, false, 'date'); !is_array($data) ? $nb_q_comments = 0 : $nb_q_comments = count($data); $data = array_slice($data, $debut, SELECT_LIMIT); $html_comments = getMarkup($data, true); } else { $data = $data_all = $comm->getByModule(array('module' => $module, 'status' => $status_q, 'limit' => false), $sql_object); !is_array($data) ? $nb_q_comments = 0 : $nb_q_comments = count($data); if(is_array($data)) $data = array_slice($data, $debut, SELECT_LIMIT); $html_comments = getMarkup($data, true); } echo getAjaxFunction(); // for ajax call if($module != 'all' || $status != -1) { $link_back="
"._t('comment','all')."
"; } else { $link_back=''; } if($nb_q_comments<=1) $query_count = _t('divers','query_result')." : ".$nb_q_comments." "._t('divers','record'); else $query_count = _t('divers','query_result')." : ".$nb_q_comments." "._t('divers','records'); // handle comments exports if(isset($data[0]['comment_id'])) { $content = ''; // if vote is enabled on contribution and it is a contribution if(defined('MOD_VOTE') && MOD_VOTE == 1) { $voteFlag = true; } else { $voteFlag = false; } foreach ($data_all as $c) { if($voteFlag) $likes_number = getNbVotes(array('module' => $c['comment_module'], 'module_id' => $c['comment_id'])); $cdate = $c['comment_date_crea_display']; $cdateshort = substr($c['comment_date_crea_display'], 0, 10); $ctitle = formatText($c['comment_title']); $cbody = formatText($c['comment_body']); $cname= $c['user_login']; $item = itemMapping($c['comment_module']); // status if($c['comment_status']== 'E') { $cstatus = _t('comment', 'disapproved'); } if($c['comment_status']== 'P') { $cstatus= _t('comment', 'approved'); } if($c['comment_status']== 'D') { $cstatus= _t('comment', 'awaiting'); } // get fullname if(!empty($c['profile_firstname']) || !empty($c['profile_lastname'])) { $cname .= ' ('.$c['profile_firstname']. ' '.$c['profile_lastname'].')'; } else { $cname .= $c['comment_name']; } if($c['comment_user_id']!=0) { $dataU = $GLOBALS['sql_object']->DBSelect(SQL_getUserInfo($c['comment_user_id'])); $cemail = $dataU[0]['profile_email']; $cregistered = _t('divers', 'yes'); } else { $cemail = $c['comment_email']; $cregistered = _t('divers', 'no'); } $content .=''; $content .= '' . $item['name']. ''; $content .= '' . $c['item_title'] . ' [id : ' . $c['comment_module_id'] . ']'; $content .= '' . $cname. ''; $content .= '' . $cregistered. ''; $content .= '' . $cemail. ''; $content .= '' . $ctitle. ''; $content .= '' . $cbody. ''; if($voteFlag) $content .= '' . $likes_number. ''; $content .= '' . $cdate. ''; $content .= '' . mb_ucfirst($cstatus). ''; $content .=''; } $table_export = ''; $table_export .= ''; $table_export .= ''; $table_export .= ''; $table_export .= ''; $table_export .= ''; $table_export .= ''; $table_export .= ''; $table_export .= ''; $table_export .= ''; if($voteFlag) $table_export .= ''; $table_export .= ''; $table_export .= ''; $table_export .= ''; $table_export .= ''; $table_export .= ''; $table_export .= $content; $table_export .= ''; $table_export .= ''; // Insert Javascript instructions to allow client Excel export footerAddJS('../lib/js/tableExport.jquery.plugin/tableExport.min.js'); footerAddJS('../lib/js/tableExport.jquery.plugin/libs/html2canvas/html2canvas.min.js'); $str = '$("#export-values li a").click(function() { var format = $(this).attr("data-format"); var ignoreCol = []; // set columns to ignore $el = $("#export-comments"); $el.tableExport( {tableName:"'.mb_ucfirst(_t('comment', 'section') . ' : ' . $nb_comments. ' '. $query_count). '",type:format,escape:\'false\',ignoreColumn: ignoreCol,displayTableName:\'true\',htmlContent:\'false\',fileName:\'' . _t('comment', 'section') . '\'}); return false; });'; footerAddInlineJS($str); } $link_status=$rub_link."&todo=list&module=".$module."&statut="; $link_module=$rub_link."&todo=list&statut=".$status."&module="; $link_self=$rub_link."&todo=list&statut=".$status."&module=".$module; // Liste des modules disponibles if($module=='news') $mask_statut_1 = 'selected="selected"'; if($module=='project') $mask_statut_2 = 'selected="selected"'; if($module=='publication') $mask_statut_3 = 'selected="selected"'; if($module=='report') $mask_statut_4 = 'selected="selected"'; if($module=='indicator') $mask_statut_5 = 'selected="selected"'; if($module=='files') $mask_statut_6 = 'selected="selected"'; if($module=='contribute') $mask_statut_7 = 'selected="selected"'; $select_module="\n"; $js = "$('#statut_filter').change(function() { if($(this).val() != -1) window.location = $(this).val(); });"; footerAddInlineJS($js); ?>
\n"; ?>
'; echo linkin_page($link_self, $nb_q_comments, $debut); echo '
'; if(!empty($html_comments)) echo $html_comments; else echo "
"._t('comment','noresult')."
"; echo '
'; echo linkin_page($link_self, $nb_q_comments, $debut); ?>