File Source for list.php

<?php
/**
* @package linea21.modules
* @subpackage project
* @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');
}
////////////
//////////// Check Droits utilisateur ////////////
if (!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='';
$mask_statut_4='';
if($statut=='public') $mask_statut_1='selected="selected"';
if($statut=='draft') $mask_statut_2='selected="selected"';
if($statut=='archives_p') $mask_statut_3='selected="selected"';
if($statut=='archives_a') $mask_statut_4='selected="selected"';
// Nombre d'enregistrement total dans la bdd
$result_nb_req=$sql_object->DBSelect($req_count_projects);
$bdd_nb_projects=$result_nb_req[0]['num_rows'];
$bdd_nb_projects_display = $bdd_nb_projects." "._t('project','nb_total')."<br />\n";
if($statut!=-1) {
$link_back="<div class=\"filter\"><a href=\"".$rub_link."&todo=list\">"._t('project','all')."</a></div>";
$req_count_projects=SQL_getCountProjectsList($statut);
$result_nb_req=$sql_object->DBSelect($req_count_projects);
$count_request=$result_nb_req[0]['num_rows'];
$req_list_projects=SQL_getProjectsList($debut, SELECT_LIMIT, $statut);
$result_projects_list=$sql_object->DBSelect($req_list_projects);
} else {
$link_back='';
$count_request=$bdd_nb_projects;
$req_list_projects=SQL_getProjectsList($debut, SELECT_LIMIT, $statut);
$result_projects_list=$sql_object->DBSelect($req_list_projects);
}
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."&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="<select name=\"statut_filter\" id=\"statut_filter\" onchange=\"ChangeLocation(this)\">\n";
$select_statut.="<option value=\"-1\">"._t('project','statut_filter')."</option>\n";
$select_statut.="<option value=\"".$link_statut."public\"".$mask_statut_1.">".display_statut('P')."</option>\n";
$select_statut.="<option value=\"".$link_statut."draft\"".$mask_statut_2.">".display_statut('D')."</option>\n";
$select_statut.="<option value=\"".$link_statut."archives_p\"".$mask_statut_3.">".display_statut('PA')."</option>\n";
$select_statut.="<option value=\"".$link_statut."archives_a\"".$mask_statut_4.">".display_statut('AA')."</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_<?php echo $rub; ?>"
class="chemin_rub"><?php echo _t('menu','project'); ?></a></li>
<li><span><?php echo formatNavTitle(_t('project','list')); ?></span></li>
</ul>
</div>
<?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_projects_display;
echo $count_request_display;
?></p>
<?php
echo linkin_page($link_self, $count_request, $debut);
if($result_projects_list!=0) {
echo "<table cellspacing=\"0\" cellpadding=\"3\" class=\"sortable\" id=\"sort-table\">\n";
echo "<thead>\n";
echo "<tr>\n";
echo "<td>"._t('project','name')."</td>\n";
echo "<td>"._t('project','priority')."</td>\n";
echo "<td>"._t('divers','date_crea')."</td>\n";
echo "<td>".cutText(_t('divers','date_publi'), 13, 1, '')."</td>\n";
echo "<td> <span class=\"semnone\">"._t('divers','actions')."</span></td>\n";
echo "</tr>\n";
echo "</thead>\n";
echo "<tbody>\n";
for($i=0; $i<count($result_projects_list); $i++) {
$project_name=formatText(cutText($result_projects_list[$i]['project_name'],50), '2HTML');
$complete_project_name = $result_projects_list[$i]['complete_project_name'];
$project_owner=$result_projects_list[$i]['project_posted_by'];
$project_statut=$result_projects_list[$i]['project_statut'];
$project_published_date = $project_statut=='D' ? _t('statut','draft') : $result_projects_list[$i]['project_published_date_display'];
echo "<tr id=\"project-".$result_projects_list[$i]['project_id']."\">\n";
echo "<td><a href=\"".$link_det.$result_projects_list[$i]['project_id']."\" title=\""._t('project','det')." ".formatText($complete_project_name, '2ALT')."\">".$project_name."</a></td>\n";
echo "<td>".$result_projects_list[$i]['priority_name']."</td>\n";
echo "<td>".$result_projects_list[$i]['project_date_crea_display']."</td>\n";
echo "<td>".$project_published_date."</td>\n";
echo "<td style=\"width:50px\">\n";
if (IsSuperAdmin()) {
echo "<div class=\"iconetab\">\n";
echo "<a href=\"".$link_sup.$result_projects_list[$i]['project_id']."\" class=\"ico_sup\" title=\""._t('project','sup')."\"></a>\n";
echo "<a href=\"".$link_mod.$result_projects_list[$i]['project_id']."\" class=\"ico_mod\" title=\""._t('project','mod')."\"></a>\n";
echo "</div>\n";
} else echo '';
echo "</td>\n";
echo "</tr>\n";
}
echo "</tbody>";
echo "</table>";
} else {
echo "<div class=\"info\">"._t('project','noresult')."</div>";
}
echo linkin_page($link_self, $count_request, $debut);
?>
</div>
<?php
// Ability to drag'n drop items
footerAddJS('../lib/js/jquery.tablednd_0_5.js');
dragTableSettings();
?>
<?php
include_once($dir."/help.php");
?>
</div>

Source for file list.php