* @version $id SVN * @access public * @license http://opensource.org/licenses/gpl-3.0.html */ include_once('../project/' . SQL . '.inc.php'); /** * DisplayListProject() * Affichage de la liste des projets publics * * @param string $statut * @param integer $filter * @param string $id_filter * @param integer $debut * @return string $content */ function DisplayListProject($statut, $filter, $id_filter, $debut) { if ($statut == 'public') { $pas = 100; $suffix = ''; } else $pas = SELECT_LIMIT; if ($statut == 'archives_p') $suffix = ' "'.strtolower($GLOBALS['lang']['statut']['PA']).'"'; $data = $GLOBALS['sql_object']->DBSelect(SQL_getProjectsList($debut, $pas, $statut, $filter, $id_filter)); $datacount = $GLOBALS['sql_object']->DBSelect(SQL_getCountProjectsList($statut, $filter, $id_filter)); $bdd_nb_com = $datacount[0]['num_rows']; $bdd_nb_com_display = '

' . $bdd_nb_com . ' ' . $GLOBALS['lang']['project']['name'] . $suffix . '

' . END_LINE; $content = '

' . $GLOBALS['lang']['project']['list'] . '

' . END_LINE; if ($data != 0) { // echo $bdd_nb_com_display; // affichage du nombre d'enregistrements $current_link = array('rub' => $GLOBALS['links'][LANGUAGE]['project']['linkvalue']); Display_linkin_page($current_link, $bdd_nb_com, $debut, $pas); for($i = 0; $i < count($data); $i++) { $link_detail = array('rub' => $GLOBALS['links'][LANGUAGE]['project']['linkvalue'], 'id' => $data[$i]['project_id'], 'name' => $data[$i]['project_name']); $link_scale = array('rub' => $GLOBALS['links'][LANGUAGE]['project']['linkvalue'], 'filter' => $GLOBALS['filters'][LANGUAGE]['scale']['linkvalue'], 'id' => $data[$i]['project_scale_id'], 'name' => $data[$i]['scale_denomination']); $link_priority = array('rub' => $GLOBALS['links'][LANGUAGE]['project']['linkvalue'], 'filter' => $GLOBALS['filters'][LANGUAGE]['priority']['linkvalue'], 'id' => $data[$i]['priority_id'] , 'name' => $data[$i]['priority_name']); $link_user = array('rub' => $GLOBALS['links'][LANGUAGE]['user-profile']['linkvalue'], 'id' => $data[$i]['project_posted_by'], 'name' => $data[$i]['user_login']); $project_name = formatText($data[$i]['complete_project_name'], '2HTML'); $project_description = formatText(cutText($data[$i]['project_description'], 300), '2HTML'); $scale_denomination = formatText($data[$i]['scale_denomination'], '2HTML'); $project_posted_on = formatText($data[$i]['project_published_date_display'], '2HTML'); $project_posted_by = formatText($data[$i]['user_login'], '2HTML'); $project_priority = formatText($data[$i]['priority_name'], '2HTML'); $content .= '

' . $project_name . '' . END_LINE; $content .= '

' . END_LINE; $content .= '

' . END_LINE; $content .= $GLOBALS['lang']['statut']['published_on'] . ' ' . $project_posted_on . ' '; $content .= $GLOBALS['lang']['divers']['by'].' ' . $project_posted_by . ''; $content .= '

' . END_LINE; $content .= '

' . $project_description . '

' . END_LINE; $content .= '

'; $content .= $GLOBALS['lang']['project']['priority'] . ' : '; $content .= ' ' . $project_priority . ' ' . END_LINE; $content .= $GLOBALS['lang']['divers']['scale'] . ' : '; $content .= ' ' . $scale_denomination . '

' . END_LINE; if($i'; } echo $content; } /** * DisplayOneProject() * Affichage d'un projet en détail * * @param integer $project_id * @return string $stat status name */ function DisplayOneProject($project_id) { $data = $GLOBALS['sql_object']->DBSelect(SQL_getoneCompleteProject($project_id)); $content = ''; if (count($data) != 1) exit; else { $link_scale = array('rub' => $GLOBALS['links'][LANGUAGE]['project']['linkvalue'], 'filter' => $GLOBALS['filters'][LANGUAGE]['scale']['linkvalue'], 'id' => $data[0]['project_scale_id'], 'name' => $data[0]['scale_denomination']); $link_priority = array('rub' => $GLOBALS['links'][LANGUAGE]['project']['linkvalue'], 'filter' => $GLOBALS['filters'][LANGUAGE]['priority']['linkvalue'], 'id' => $data[0]['project_priority_id'], 'name' => $data[0]['project_priority']); $link_user = array('rub' => $GLOBALS['links'][LANGUAGE]['user-profile']['linkvalue'], 'id' => $data[0]['project_posted_by'], 'name' => $data[0]['user_login']); $link_parent = array('rub' => $GLOBALS['links'][LANGUAGE]['project']['linkvalue'], 'id' => $data[0]['project_parent_id'], 'name' => $data[0]['parent_name']); $project_name = formatText($data[0]['project_name'], '2HTML'); $project_description = linkin_content(formatText($data[0]['project_description'], '2HTML')); $project_body = linkin_content(formatText($data[0]['project_body'], '2HTML')); $project_parent = formatText($data[0]['parent_name'], '2HTML'); $project_scale = formatText($data[0]['scale_denomination'], '2HTML'); $project_priority = formatText($data[0]['project_priority'], '2HTML'); $project_begin_date = formatText(empty_nc($data[0]['project_begin_date_display']), '2HTML'); $project_estimated_date = formatText(empty_nc($data[0]['project_estimated_date_display']), '2HTML'); $project_end_date = formatText(empty_nc($data[0]['project_end_date_display']), '2HTML'); $schedule_table = getScheduleTable($data[0]['project_begin_date_display'], $data[0]['project_estimated_date_display'], $data[0]['project_end_date_display']); $project_posted_on = formatText($data[0]['project_published_date_display'], '2HTML'); $project_modify_on = formatText($data[0]['project_last_modify_display'], '2HTML'); $project_posted_by = formatText($data[0]['user_login'], '2HTML'); $project_status = $data[0]['project_statut']; $content .= '

' . $project_name . '

' . END_LINE; $content .= '

' . END_LINE; $content .= $GLOBALS['lang']['statut']['published_on'] . ' ' . $project_posted_on . ' '; $content .= $GLOBALS['lang']['divers']['by'].' ' . $project_posted_by . ''; if ($project_status == 'PA') { $content .= ' (' . $GLOBALS['lang']['statut']['archived_on'] . ' ' . $project_modify_on . ')'; } $content .= '

' . END_LINE; if($data[0]['project_parent_id'] != 0) { $content .= '
' . END_LINE; $content .= $GLOBALS['lang']['project']['parent'] . ' : '; $content .= '' . $project_parent . ' '; $content .= '
' . END_LINE; } $content .= '

' . $project_description . '

' . END_LINE; $content .= '
' . $schedule_table . '
' . END_LINE; $content .= '

' . $project_body . '

' . END_LINE; $content .= getProjectChildren($project_id); $content .= '

' . END_LINE; $content .= $GLOBALS['lang']['project']['priority'] . ' : '; $content .= '' . $project_priority . ' ' . END_LINE; $content .= ' ' . $GLOBALS['lang']['divers']['scale'] . ' : '; $content .= '' . $project_scale . '' . END_LINE; $content .= '

' . END_LINE; } echo $content; return GetStatusName($project_status); } /** * GetProjectChildren() * * @param $id * @return string */ function getProjectChildren($id) { $data = $GLOBALS['sql_object']->DBSelect(SQL_getProjectChildren($id)); $content = ''; if (count($data) != 0 && $data[0]!=0) { $content .= '
'.END_LINE; $content .= '

'.$GLOBALS['lang']['project']['sub-projects'].' :

'.END_LINE; } return $content; } /** * GetStatusName() * * @param $status * @return $stat Status name */ function GetStatusName($status) { switch ($status) { case 'P': $stat = 'public'; break; case 'PA': $stat = 'archives_p'; break; case 'AA': $stat = 'archives_a'; break; default: $stat = 'public'; } return $stat; } /** * getScheduleTable() * * @param string $s_date * @param string $es_date * @param string $e_date * @return string $content */ function getScheduleTable($s_date, $es_date, $e_date) { $es_date_class = 'nothing'; $e_date_class = 'nothing'; if(!isNullDate($es_date)) { if(!isNullDate($e_date)) $es_date_class = date_compare($e_date, $es_date, '>') ? 'warn' : 'good'; else $es_date_class = date_compare(date("Y-m-d"), $es_date, '>') ? 'bad' : 'good'; } if(!isNullDate($e_date)) { if(!isNullDate($es_date)) $e_date_class = date_compare($e_date, $es_date, '>') ? 'bad' : 'good'; else $e_date_class = 'good'; } else { if(!isNullDate($es_date)) { $e_date_class = date_compare(date("Y-m-d"), $es_date, '>') ? 'warn' : 'nothing'; } } $content = ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= ''.END_LINE; $content .= '
'.$GLOBALS['lang']['project']['begin_date'].''.$GLOBALS['lang']['project']['estimated_date'].''.$GLOBALS['lang']['project']['end_date'].'
'.formatText(empty_nc($s_date)).''.formatText(empty_nc($es_date)).''.formatText(empty_nc($e_date)).'
'.END_LINE; return $content; } ?>