* @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->hasRight('project')) ReloadIndex('admin');
////////////
include_once(override('../level/display.php'));
include_once(override('../project/display.php'));
include_once('../class/class.tag.php');
include_once(override('../vote/display.php'));
// getting tags menu filter
$otag = new tag();
$tags =$otag->getTags('project', -1, false);
$finalities = $GLOBALS ['sql_object']->DBSelect ( SQL_getFinalities ( false ) );
$scales = $GLOBALS ['sql_object']->DBSelect ( SQL_getScales () );
$priorities = $GLOBALS ['sql_object']->DBSelect ( SQL_getPriorities() );
$filter_menu = getMenuFilter($tags, $finalities, $scales, $priorities);
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"';
$link_statut=$rub_link."&todo=list";
if(isset($_REQUEST['view'])) $link_statut.="&view=".$_REQUEST['view'];
$current_list = $link_statut;
$link_statut.="&statut=";
$link_self=$link_statut.'&statut='.$statut;
// 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')."'._t('project', 'completion-percentage').'
', ''.round($comp[0]['completion'], 0).' ');
else $completion_dynamic_display = '';
if($count_request<=1) $count_request_display = _t('divers','query_result')." : ".$count_request." "._t('divers','record')."'.PHP_EOL;
$actors_content .= '
' . _t('project','modify_actors_notice') .'
'.PHP_EOL;
if(is_array($actors_list)) {
foreach ($actors_list as $a) {
$actors_content .= '
'.$a['actor_name'].'
('.$a['actor_occ'].') ';
}
}
else {
$actors_content .= "
" . _t('divers','nodata') . "
".PHP_EOL;
}
$actors_content .= "
\n";
$select_statut.=""._t('project','statut_filter')." \n";
$select_statut.="".display_statut('P')." \n";
$select_statut.="".display_statut('D')." \n";
$select_statut.="".display_statut('PA')." \n";
$select_statut.="".display_statut('AA')." \n";
$select_statut.=" \n";
$js = " $('#statut_filter').change(function() {
if($(this).val() != -1) window.location = $(this).val();
});";
footerAddInlineJS($js);
?>
DBSelect ( SQL_getFinalities ( false ) );
if (! isset ( $finalities [0] ['finality_id'] )) return false;
foreach ( $finalities as $finality ) {
$title = '' . $finality ['finality_name'] . ' ' . PHP_EOL;
$html .= '';
$html .='';
$html .= '';
$projects = $GLOBALS ['sql_object']->DBSelect ( SQL_getProjectsList ( 0, 999, $statut, 'FINALITY', $finality['finality_id'] ) );
if (isset ( $projects [0] ['complete_project_name'] )) {
$html .= "
\n";
$html .= "\n";
$html .= "\n";
$html .= "" . mb_ucfirst ( _t ( 'project', 'name' ) ) . " \n";
if(voteEnabled('project')) {
$html .= "" . mb_ucfirst(_t('like', 'likes')) . " \n";
}
$html .= "" . mb_ucfirst ( _t ( 'project', 'priority' ) ) . " \n";
$html .= "" . mb_ucfirst ( _t ( 'project', 'progression' ) ) . " \n";
$html .= "" . mb_ucfirst ( _t ( 'divers', 'date_crea' ) ) . " \n";
// $html .= "".cutText(mb_ucfirst(_t('divers','date_publi')), 13, 1, '')." \n";
$html .= " " . mb_ucfirst ( _t ( 'divers', 'actions' ) ) . " \n";
$html .= " \n";
$html .= " \n";
$html .= "\n";
for($i = 0; $i < count ( $projects ); $i ++) {
$project_name = formatText ( cutText ( $projects [$i] ['complete_project_name'], 70 ), '2HTML' );
$complete_project_name = $projects [$i] ['complete_project_name'];
$project_owner = $projects [$i] ['project_posted_by'];
$project_statut = $projects [$i] ['project_statut'];
$project_published_date = $project_statut == 'D' ? _t ( 'statut', 'draft' ) : $projects [$i] ['project_published_date_display'];
// we get managers
$manager = getAssociatedManagers($projects[$i]['project_id']);
// getting votes number
if(voteEnabled('project')) {
$nbVotes = getNbVotes(array('module' => 'project', 'module_id' => $projects [$i] ['project_id']));
}
// getting tags
$otag = new tag ();
$display_tags = $otag->getTags ( 'project', $projects [$i] ['project_id'], true, ';' );
// getting finalities
$display_finalities = get_finalities($projects[$i]['project_id'], true, ';');
if($projects [$i] ['project_parent_id'] != 0) {
$class='sub-project';
$parentName = '[' . mb_ucfirst(_t('project','parent')) . ' : ' . $projects [$i] ['parent_project_name'] . ']';
} else {
$class = 'project';
$parentName = '';
}
if($l21auth->isProjectManager($l21auth->GetSessionElement( 'id' ), $sql_object, $projects[$i]['project_id'])) $pclass = 'is-mine'; else $pclass = 'is-not-mine';
$html .= "\n";
$html .= "";
$html .= "".$project_name." ";
if(!empty($display_tags)) $html .= " \n";
if(voteEnabled('project')) {
$html .= "".$nbVotes." ";
}
$html .= "" . $projects [$i] ['priority_name'] . " \n";
$html .= "" . $projects [$i] ['project_completed'] . " %
" . $projects [$i] ['project_date_crea_display'] . " \n";
// $html .= "".$project_published_date." \n";
$html .= "\n";
if ($l21auth->isProjectManager ( $l21auth->GetSessionElement ( 'id' ), $sql_object, $projects [$i] ['project_id'] ) || $l21auth->isSuperAdmin ()) {
$html .= "\n";
}
$html .= " \n";
$html .= " \n";
}
$html .= " ";
$html .= "
";
} else {
$html .= "
"._t('project','noresult')."
";
}
$html .= '
';
if(isset($projects[0]['project_posted_by'])) {
$html .="
\n";
$html .="\n";
$html .="\n";
$html .="".mb_ucfirst(_t('project','name'))." \n";
if(voteEnabled('project')) {
$html .= "" . mb_ucfirst(_t('like', 'likes')) . " \n";
}
$html .="".mb_ucfirst(_t('project','priority'))." \n";
$html .="".mb_ucfirst(_t('project','progression'))." \n";
$html .="".mb_ucfirst(_t('divers','date_crea'))." \n";
// $html .="".cutText(mb_ucfirst(_t('divers','date_publi')), 13, 1, '')." \n";
$html .=" ".mb_ucfirst(_t('divers','actions'))." \n";
$html .=" \n";
$html .=" \n";
$html .="\n";
for($i=0; $i 'project', 'module_id' => $projects [$i] ['project_id']));
}
if($projects [$i] ['project_parent_id'] != 0) {
$class='sub-project';
$parentName = '[' . mb_ucfirst(_t('project','parent')) . ' : ' . $projects [$i] ['parent_project_name'] . ']';
} else {
$class = 'project';
$parentName = '';
}
// we display only wanted status
if($status == -1 || $project_statut == get_sql_status($status)) {
// getting tags
$otag = new tag();
$display_tags =$otag->getTags('project', $projects[$i]['project_id'], true, ';' );
// getting finalities
$display_finalities = get_finalities($projects[$i]['project_id'], true, ';');
if($l21auth->isProjectManager($l21auth->GetSessionElement( 'id' ), $sql_object, $projects[$i]['project_id'])) $pclass = 'is-mine'; else $pclass = 'is-not-mine';
$html .="\n";
$html .="".$project_name." ";
if(!empty($display_tags)) $html .= "".$nbVotes." ";
}
$html .="".$projects[$i]['priority_name']." \n";
$html .="".$projects[$i]['project_completed']." %
".$projects[$i]['project_date_crea_display']." \n";
// $html .="".$project_published_date." \n";
$html .="\n";
if ($l21auth->isProjectManager($l21auth->GetSessionElement('id'), $sql_object, $projects[$i]['project_id']) || $l21auth->isSuperAdmin()) {
$html .="\n";
} else $html .='';
$html .=" \n";
$html .=" \n";
}
}
$html .=" ";
$html .="
";
} else {
$html .="
"._t('project','noresult')."
";
}
$html .="
' . formatText($level_label, '2HTML') . ' ';
$projects = $GLOBALS['sql_object']->DBSelect(SQL_getProjectsList(0, 999, $statut, 'LEVEL', $item['level_id']));
// // we sort values on level names
// // Obtain a list of columns
// foreach ($projects as $key => $row) {
// $level[$key] = $row['level_name'];
// }
// // Sort the data with level descending
// // Add $projects as the last parameter, to sort by the common key
// array_multisort($level, SORT_DESC, $projects);
if(isset($projects[0]['complete_project_name'])) {
$html .= "
\n";
$html .= "\n";
$html .= "\n";
$html .= "".mb_ucfirst(_t('project','name'))." \n";
if(voteEnabled('project')) {
$html .= "" . mb_ucfirst(_t('like', 'likes')) . " \n";
}
$html .= "".mb_ucfirst(_t('project','priority'))." \n";
$html .= "".mb_ucfirst(_t('project','progression'))." \n";
$html .= "".mb_ucfirst(_t('divers','date_crea'))." \n";
//$html .= "".cutText(mb_ucfirst(_t('divers','date_publi')), 13, 1, '')." \n";
$html .= " ".mb_ucfirst(_t('divers','actions'))." \n";
$html .= " \n";
$html .= " \n";
$html .= "\n";
for($i=0; $i 'project', 'module_id' => $projects [$i] ['project_id']));
}
// getting tags
$otag = new tag();
$display_tags = $otag->getTags('project', $projects[$i]['project_id'], true, ';' );
// getting finalities
$display_finalities = get_finalities($projects[$i]['project_id'], true, ';');
if($projects [$i] ['project_parent_id'] != 0) {
$class='sub-project';
$parentName = '[' . mb_ucfirst(_t('project','parent')) . ' : ' . $projects [$i] ['parent_project_name'] . ']';
} else {
$class = 'project';
$parentName = '';
}
if($l21auth->isProjectManager($l21auth->GetSessionElement( 'id' ), $sql_object, $projects[$i]['project_id'])) $pclass = 'is-mine'; else $pclass = 'is-not-mine';
$html .= "\n";
$html .= "".$project_name." ";
if(!empty($display_tags)) $html .= "".$nbVotes." ";
}
$html .= "".$projects[$i]['priority_name']." \n";
$html .= "".$projects[$i]['project_completed']." %
".$projects[$i]['project_date_crea_display']." \n";
// $html .= "".$project_published_date." \n";
$html .= "\n";
if ($l21auth->isProjectManager($l21auth->GetSessionElement('id'), $sql_object, $projects[$i]['project_id']) || $l21auth->isSuperAdmin()) {
$html .= "\n";
}
$html .= " \n";
$html .= " \n";
}
$html .= " ";
$html .= "
";
}
// call this funcion recursively
// with the next level ($item)
// it will figure out again whether that level has numeric children as well
// returns a new complete set, if applicable, otherwise an empty string
if(isset($item['children'])) $html .= generate_html_recursive($item['children'], $statut, $filter, $id_filter, $depth+1);
$html .= '
isSuperAdmin()) echo $actors_content;
// 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);
?>
isSuperAdmin()) {
footerAddJS('../lib/js/TableDnD/dist/jquery.tablednd.1.0.5.min.js');
dragTableSettings();
}
?>