linea21-modules
[ class tree: linea21-modules ] [ index: linea21-modules ] [ all elements ]
Packages:
linea21-core
linea21-externals
linea21-languages
linea21-modules
linea21-utils

Source for file list.php

Documentation is available at list.php

  1. <?php
  2. /**
  3.  * @package linea21.modules
  4.  * @subpackage publication
  5.  * @author linea21 <info@linea21.com>
  6.  * @version $id SVN
  7.  * @access public
  8.  * @license http://opensource.org/licenses/gpl-3.0.html
  9.  */
  10.  
  11. //////////// Check Inclusion de pages ////////////
  12. if (!class_exists('auth')) {
  13.   include_once("../lib/lib_common.php");
  14.   ReloadIndex('admin');
  15. }
  16. ////////////
  17.  
  18. //////////// Check Droits utilisateur ////////////
  19. if (!$l21auth->hasRight('publication')) ReloadIndex('admin');
  20. ////////////
  21.  
  22. if(!isset($_GET['statut']) || $_GET['statut']==-1) $statut=-1;
  23. elseif($_GET['statut']!=-1) $statut=$_GET['statut'];
  24.  
  25.  
  26. if(!isset($_GET['debut'])) $debut=0;
  27. else $debut=$_GET['debut'];
  28.  
  29. $mask_statut_1='';
  30. $mask_statut_2='';
  31. $mask_statut_3='';
  32. $mask_statut_4='';
  33. if($statut=='public') $mask_statut_1='selected="selected"';
  34. if($statut=='draft') $mask_statut_2='selected="selected"';
  35. if($statut=='archives_p') $mask_statut_3='selected="selected"';
  36. if($statut=='archives_a') $mask_statut_4='selected="selected"';
  37.  
  38. // Nombre d'enregistrement total dans la bdd
  39. $req_count_publi=SQL_getCountPublicationList();
  40. $result_nb_req=$sql_object->DBSelect($req_count_publi);
  41. $bdd_nb_publi=$result_nb_req[0]['num_rows'];
  42. $bdd_nb_publi_display = $bdd_nb_publi." "._t('publication','nb_total')."<br />\n";
  43.  
  44. if($statut!=-1) {
  45.   $link_back="<div class=\"filter\"><a href=\"".$rub_link."&amp;todo=list\">"._t('publication','all')."</a></div>";
  46.   $req_count_publi=SQL_getCountPublicationList($statut);
  47.   $result_nb_req=$sql_object->DBSelect($req_count_publi);
  48.   $count_request=$result_nb_req[0]['num_rows'];
  49.   $req_list_publi=SQL_getPublicationList($debut, SELECT_LIMIT, $statut);
  50.   $result_publi_list=$sql_object->DBSelect($req_list_publi);
  51. } else {
  52.   $link_back='';
  53.   $count_request=$bdd_nb_publi;
  54.   $req_list_publi=SQL_getPublicationList($debut, SELECT_LIMIT, $statut);
  55.   $result_publi_list=$sql_object->DBSelect($req_list_publi);
  56. }
  57.  
  58. if($count_request<=1) $count_request_display = _t('divers','query_result')." : ".$count_request." "._t('divers','record')."<br />\n";
  59. else $count_request_display = _t('divers','query_result')." : ".$count_request." "._t('divers','records')."<br />\n";
  60.  
  61.  
  62. $link_sup=$rub_link."&amp;todo=sup&amp;id=";
  63. $link_mod=$rub_link."&amp;todo=mod&amp;id=";
  64. $link_det=$rub_link."&amp;todo=det&amp;id=";
  65. $link_statut=$rub_link."&amp;todo=list&amp;statut=";
  66. $link_self=$link_statut.$statut;
  67.  
  68.  
  69. // Liste des statuts disponible
  70. $select_statut="<select name=\"statut_filter\" id=\"statut_filter\">\n";
  71. $select_statut.="<option value=\"-1\">"._t('publication','statut_filter')."</option>\n";
  72. $select_statut.="<option value=\"".$link_statut."public\"".$mask_statut_1.">".display_statut('P')."</option>\n";
  73. $select_statut.="<option value=\"".$link_statut."draft\"".$mask_statut_2.">".display_statut('D')."</option>\n";
  74. $select_statut.="<option value=\"".$link_statut."archives_p\"".$mask_statut_3.">".display_statut('PA')."</option>\n";
  75. $select_statut.="<option value=\"".$link_statut."archives_a\"".$mask_statut_4.">".display_statut('AA')."</option>\n";
  76. $select_statut.="</select>\n";
  77.  
  78. $js = "    $('#statut_filter').change(function() {
  79.                     window.location = $(this).val();
  80.                 });";
  81.  
  82. footerAddInlineJS($js);
  83. ?>
  84. <div id="chemin">
  85. <ul>
  86.     <li><a href="index.php" class="chemin_home"><?php echo _t('way','home'); ?></a></li>
  87.     <li><a href="<?php echo $rub_link; ?>" id="chemin_<?php echo $rub; ?>" class="chemin_rub"><?php echo _t('menu','publication'); ?></a></li>
  88.     <li><span><?php echo formatNavTitle(_t('publication','list')) ?></span></li>
  89. </ul>
  90. </div>
  91. <!--end barre haute -->
  92. <?php
  93. include_once(THEME_ADMIN_PATH."quickicons.php");
  94. ?>
  95. <div class="contentcontainer"><?php    include_once(override($dir.'/menurub.php', THEME_ADMIN_PATH));    ?>
  96. <div id="content">
  97. <?php echo $link_back; ?>
  98. <div class="filterselect"><?php echo $select_statut; ?></div>
  99. <p>
  100.     <?php
  101.     echo $bdd_nb_publi_display;
  102.     echo $count_request_display;
  103.     ?>
  104. </p>
  105. <?php
  106. echo linkin_page($link_self, $count_request, $debut);
  107.  
  108. if($result_publi_list!=0) {
  109.   echo "<table cellspacing=\"0\" cellpadding=\"3\" class=\"sortable multisort\" id=\"sort-table\">\n";
  110.   echo "<thead>\n";
  111.   echo "<tr>\n";
  112.   echo "<td>".mb_ucfirst(_t('publication','title'))."</td>\n";
  113.   echo "<td>".mb_ucfirst(_t('publication','author'))."</td>\n";
  114.   echo "<td>".mb_ucfirst(_t('divers','date_crea'))."</td>\n";
  115.   echo "<td>".cutText(mb_ucfirst(_t('divers','date_publi')), 13, 1, '')."</td>\n";
  116.   echo "<td class=\"sorter-false\">&nbsp;<span class=\"semnone\">".mb_ucfirst(_t('divers','actions'))."</span></td>\n";
  117.   echo "</tr>\n";
  118.   echo "</thead>\n";
  119.  
  120.  
  121.   echo "<tbody>";
  122.   for($i=0; $i<count($result_publi_list); $i++) {
  123.     $publi_title=formatText(cutText($result_publi_list[$i]['publi_title'],50), '2HTML');
  124.     $publi_owner=$result_publi_list[$i]['publi_posted_by'];
  125.     $publi_statut=$result_publi_list[$i]['publi_statut'];
  126.     $publi_published_date = $publi_statut=='D' ? _t('statut','draft') : $result_publi_list[$i]['publi_published_date_display'];
  127.     echo "<tr id=\"publi-".$result_publi_list[$i]['publi_id']."\">\n";
  128.     echo "<td><a href=\"".$link_det.$result_publi_list[$i]['publi_id']."\" title=\""._t('publication','det')."\">".$publi_title."</a></td>\n";
  129.     echo "<td>".$result_publi_list[$i]['user_login']."</td>\n";
  130.     echo "<td>".$result_publi_list[$i]['publi_date_crea_display']."</td>\n";
  131.     echo "<td>".$publi_published_date."</td>\n";
  132.     echo "<td style=\"width:80px\">\n";
  133.     if ($l21auth->GetSessionElement('id') == $publi_owner || $l21auth->isSuperAdmin()) {
  134.       echo "<div class=\"iconetab\">";
  135.       echo "\t<a href=\"".$link_sup.$result_publi_list[$i]['publi_id']."\" class=\"ico_sup\" title=\""._t('publication','sup')."\"><i class=\"icon-trash\"></i><span>" . _t('publication','sup') . "</span></a>\n";
  136.       echo "\t<a href=\"".$link_mod.$result_publi_list[$i]['publi_id']."\" class=\"ico_mod\" title=\""._t('publication','mod')."\"><i class=\"icon-pencil\"></i><span>" . _t('publication','mod') . "</span></a>\n";
  137.       echo "</div>";
  138.     } else echo '';
  139.     echo "</td>\n";
  140.     echo "</tr>\n";
  141.   }
  142.  
  143.   echo "</tbody>";
  144.   echo "</table>";
  145. } else {
  146.   echo "<div class=\"info\">"._t('publication','noresult')."</div>";
  147. }
  148. echo linkin_page($link_self, $count_request, $debut);
  149.  
  150. ?></div>
  151.  
  152. <?php
  153. // Ability to sort table
  154. addDynamicCSS('../lib/js/jquery.tablesorter/theme.default.css');
  155. footerAddJS('../lib/js/jquery.tablesorter/jquery.tablesorter.min.js');
  156. $str = '$("table.multisort").tablesorter({    });';
  157. footerAddInlineJS($str);
  158.  
  159. // Ability to drag'n drop items
  160. if ($l21auth->isSuperAdmin()) {
  161.     footerAddJS('../lib/js/jquery.tablednd_0_5.js');
  162.     dragTableSettings();
  163. }
  164. ?>
  165. <?php include_once(override($dir.'/help.php', THEME_ADMIN_PATH)); ?></div>
Documentation generated on Thu, 20 Mar 2014 16:48:37 +0100 by phpDocumentor 1.4.1