linea21-modules
[ class tree: linea21-modules ] [ index: linea21-modules ] [ all elements ]

Source for file list_com.php

Documentation is available at list_com.php

  1. <?php
  2. /**
  3.  * @package linea21.modules
  4.  * @subpackage workshop
  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('workshop'&& !$l21auth->isSuperAdmin())
  20.     ReloadIndex('admin');
  21. ////////////
  22.  
  23. if(!isset($_GET['statut']|| $_GET['statut']==-1$statut=-1;
  24. elseif($_GET['statut']!=-1$statut=$_GET['statut'];
  25.  
  26. if (isset($_POST['id'])) $id $_POST['id'];
  27. if (isset($_GET['id'])) $id $_GET['id'];
  28.  
  29. $req_det SQL_getoneCompleteWorkshop($id);
  30. $result $sql_object -> DBSelect($req_det);
  31. $workshop_denomination formatText($result[0]['workshop_denomination']'2HTML');
  32.  
  33. if(!isset($_GET['debut'])) $debut=0;
  34. else $debut=$_GET['debut'];
  35.  
  36. // Nombre d'enregistrement total dans la bdd
  37. $req_count_com SQL_getcountnbcom($id);
  38. $result_nb_com=$sql_object->DBSelect($req_count_com);
  39. $bdd_nb_com=$result_nb_com[0]['num_rows'];
  40. $bdd_nb_com_display $bdd_nb_com." "._t('workshop','nb_total_com')."<br />\n";
  41.  
  42. $link_back='';
  43. $count_request=$bdd_nb_com;
  44. $req_list_workcom=SQL_getWorkcomList($debutSELECT_LIMIT$id);
  45. $result_workcom_list=$sql_object->DBSelect($req_list_workcom);
  46.  
  47. if($count_request<=1$count_request_display _t('divers','query_result')." : ".$count_request." "._t('divers','record')."<br />\n";
  48. else $count_request_display _t('divers','query_result')." : ".$count_request." "._t('divers','records')."<br />\n";
  49.  
  50.  
  51. $link_sup_com=$rub_link."&amp;todo=sup_com&amp;id=".$id."&amp;com_id=";
  52. $link_mod_com=$rub_link."&amp;todo=mod_com&amp;id=".$id."&amp;com_id=";
  53. $link_det=$rub_link."&amp;todo=det&amp;id=";
  54. $link_det_user="index.php?rub=user&amp;todo=det&amp;id=";
  55. $link_statut=$rub_link."&amp;todo=list&amp;statut=";
  56. $link_add_com=$rub_link."&amp;todo=add_com&amp;id=".$id."&amp;com_id=";
  57. $link_list_com=$rub_link."&amp;todo=list_com&amp;id=".$id;
  58. $link_self=$link_list_com;
  59. $link_det_com=$rub_link."&amp;todo=det_com&amp;id=".$id."&amp;com_id=";
  60. $navtitle=_t('workshop','list_com')." : ".$workshop_denomination;
  61. $titleh2=_t('workshop','name')." : ".$workshop_denomination;
  62. ?>
  63. <div id="chemin">
  64. <ul>
  65.     <li><a href="index.php" class="chemin_home"><?php echo _t('way','home'?></a></li>
  66.     <li><a href="<?php echo $rub_link?>" id="chemin_<?php echo $rub?>" class="chemin_rub"><?php echo _t('menu','workshop')?></a></li>
  67.     <li><span><?php echo formatnavTitle($navtitle)?></span></li>
  68. </ul>
  69. </div>
  70. <!--end barre haute -->
  71. <?php
  72. include_once(THEME_ADMIN_PATH."quickicons.php");
  73. ?>
  74. <div class="contentcontainer"><?php    include_once(override($dir.'/menurub.php'THEME_ADMIN_PATH));    ?>
  75. <div id="content">
  76. <?php afflinkbar($todo,$id$lang)?> 
  77. <?php
  78. echo "<h2>" formatTitleh2($titleh2)"</h2>\n";
  79. ?> 
  80. <?php
  81. echo $link_back;
  82. ?>
  83. <p><?php
  84. echo $bdd_nb_com_display;
  85. echo $count_request_display;
  86. if ($l21auth->isWorkgroupOrganiser ($l21auth->GetSessionElement('id')$sql_object$id|| $l21auth->isSuperAdmin())
  87. echo "<a href=\"" $link_add_com."0\" title=\"" _t('workshop','add_com'"\" class=\"ico_add2\" style=\"margin-right:20px;\"><i class=\"icon-plus-circled\"></i><span>".  _t('workshop','add_com')."</span></a>";
  88. ?></p>
  89. <?php
  90. echo linkin_page($link_self$count_request$debut);
  91.  
  92. if($result_workcom_list!=0{
  93.   echo "<table cellspacing=\"0\" cellpadding=\"3\" class=\"table2 multisort\">\n";
  94.   echo "<thead>\n";
  95.   echo "<tr>\n";
  96.   echo "<td>".mb_ucfirst(_t('workshop','com_statut'))."</td>\n";
  97.   echo "<td>".mb_ucfirst(_t('workshop','com_subject'))."</td>\n";
  98.   echo "<td>".mb_ucfirst(_t('workshop','com_author'))."</td>\n";
  99.   echo "<td>".mb_ucfirst(_t('workshop','com_nb_rep'))."</td>\n";
  100.   echo "<td>".mb_ucfirst(_t('workshop','com_date_last'))."</td>\n";
  101.   echo "<td class=\"sorter-false\"><span class=\"semnone\">".mb_ucfirst(_t('divers','actions'))."</span></td>\n";
  102.   echo "</tr>\n";
  103.   echo "</thead>\n";
  104.   echo "<tbody>\n";
  105.  
  106.  
  107.   for($i=0$i<count($result_workcom_list)$i++{
  108.  
  109.     $req_workcom_det=SQL_getWorkcom_detList($result_workcom_list[$i]['workcom_id']);
  110.     $result_workcom_det=$sql_object->DBSelect($req_workcom_det);
  111.  
  112.     $workcom_title=formatText(cutText($result_workcom_list[$i]['workcom_subject']901)'2HTML');
  113.     $workcom_user=formatText(cutText($result_workcom_list[$i]['user_login']101)'2HTML');
  114.  
  115.     echo "<tr>\n";
  116.     if ($result_workcom_list[$i]['workcom_statut']=='C'{
  117.       echo "<td><i class=\"icon-lock\" title=\"".$result_workcom_list[$i]['workcom_statut']."\"></i></td>\n";
  118.     }
  119.     else echo "<td width=\"5%\">&nbsp;</td>\n";
  120.     echo "<td width=\"45%\"><a href=\"".$link_det_com.$result_workcom_list[$i]['workcom_id']."\" title=\""._t('workshop','com')."\">".$workcom_title."</a></td>\n";
  121.     if ($l21auth->isSuperAdmin())
  122.     echo "<td width=\"15%\"><a href=\"".$link_det_user.$result_workcom_list[$i]['workcom_user_id']."\" title=\""._t('workshop','com_author')."\">".$workcom_user."</a></td>\n";
  123.     else     echo "<td width=\"15%\"><span>".$workcom_user."</span></td>\n";
  124.     if ($result_workcom_det[0]['nb_rep']==""{
  125.       echo "<td width=\"10%\"><span class=\"date_table\">0</span></td>\n";
  126.     }
  127.     else echo "<td width=\"10%\"><span class=\"nb_rep_table\">".$result_workcom_det[0]['nb_rep']."</span></td>\n";
  128.     if ($result_workcom_det[0]['workcom_date_crea_display']==""{
  129.       echo "<td width=\"15%\"><span class=\"date_table\">".$result_workcom_list[$i]['workcom_date_crea_display']."</span></td>\n";
  130.     }
  131.     else echo "<td width=\"15%\"><span class=\"date_table\">".$result_workcom_det[0]['workcom_date_crea_display']."</span></td>\n";
  132.  
  133.     if ($l21auth->isWorkgroupOrganiser ($l21auth->GetSessionElement('id')$sql_object$id|| $l21auth->isSuperAdmin()){
  134.       echo "<td width=\"15%\"><div class=\"iconetab\"><a href=\"".$link_sup_com.$result_workcom_list [$i]['workcom_id']."&amp;mes_id=".$result_workcom_list [$i]['workcom_id']."\" title=\""._t('workshop','sup_com')."\" class=\"ico_sup\"><i class=\"icon-trash\"></i><span>" _t('workshop','sup_com'"</span></a>\n";
  135.       echo "<a href=\"".$link_mod_com.$result_workcom_list [$i]['workcom_id']."&amp;mes_id=".$result_workcom_list [$i]['workcom_id']."\" title=\""._t('workshop','mod_com')."\" class=\"ico_mod\"><i class=\"icon-pencil\"></i><span>" _t('workshop','mod_com'"</span></a></div></td>";
  136.     }
  137.     else echo "<td width=\"15%\">&nbsp;</td>\n";
  138.     echo "</tr>\n";
  139.   }
  140.  
  141.   echo "</tbody>";
  142.   echo "</table>";
  143. else {
  144.   echo "<div class=\"info\">"._t('workshop','no_com')."</div>";
  145. }
  146. echo linkin_page($link_self$count_request$debut);
  147.  
  148. // Ability to sort table
  149. addDynamicCSS('../lib/js/jquery.tablesorter/theme.default.css');
  150. footerAddJS('../lib/js/jquery.tablesorter/jquery.tablesorter.min.js');
  151. $str '$("table.multisort").tablesorter({    });';
  152.  
  153. ?></div>
  154. <?php include_once(override($dir.'/help.php'THEME_ADMIN_PATH))?>
  155. </div>

Documentation generated on Thu, 20 Mar 2014 16:48:42 +0100 by phpDocumentor 1.4.1