* @version $id SVN * @access public * @license http://opensource.org/licenses/gpl-3.0.html */ include_once(themePath('../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 */ if(!function_exists('DisplayListProject')) { function DisplayListProject($statut, $filter, $id_filter, $debut) { if ($statut == 'public') { $pas = 100; $suffix = ''; } else $pas = SELECT_LIMIT; if ($statut == 'archives_p') $suffix = ' "'.strtolower(_t('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 . ' ' . _t('project','name') . $suffix . '

' . END_LINE; $content = '

' . _t('project','list') . '

' . END_LINE; if ($data != 0) { // echo $bdd_nb_com_display; // affichage du nombre d'enregistrements $current_link = array('rub' => $GLOBALS['links'][U_L]['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'][U_L]['project']['linkvalue'], 'id' => $data[$i]['project_id'], 'name' => $data[$i]['project_name']); $link_scale = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'filter' => $GLOBALS['filters'][U_L]['scale']['linkvalue'], 'id' => $data[$i]['project_scale_id'], 'name' => $data[$i]['scale_denomination']); $link_priority = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'filter' => $GLOBALS['filters'][U_L]['priority']['linkvalue'], 'id' => $data[$i]['priority_id'] , 'name' => $data[$i]['priority_name']); $link_user = array('rub' => $GLOBALS['links'][U_L]['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($data[$i]['project_description'], '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'); $project_theme_id = $data[$i]['project_theme_id']; if($project_theme_id != 0) { $project_theme = formatText($data[$i]['sdtheme_name'], '2HTML'); $link_theme = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'filter' => $GLOBALS['filters'][U_L]['theme']['linkvalue'], 'id' => $data[$i]['theme_sd_theme'], 'name' => $project_theme); } $content .= '

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

' . END_LINE; $content .= '

' . END_LINE; $content .= _t('statut','published_on') . ' ' . $project_posted_on . ' '; $content .= _t('divers','by').' ' . $project_posted_by . ''; $content .= '

' . END_LINE; $content .= '

' . $project_description . '

' . END_LINE; $content .= '

'; $content .= _t('project','priority') . ' : '; $content .= ' ' . $project_priority . ' ' . END_LINE; $content .= _t('divers','scale') . ' : '; $content .= ' ' . $scale_denomination . '' . END_LINE; if($project_theme_id != 0) { $content .= ' ' . _t('divers','themeref') . ' : '; $content .= '' . $project_theme . '' . END_LINE; } $content .= '

'.END_LINE; if($i'; } echo $content; } } /** * DisplayOneProject() * Affichage d'un projet en détail * * @param integer $project_id * @return string $stat status name */ if(!function_exists('DisplayOneProject')) { 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'][U_L]['project']['linkvalue'], 'filter' => $GLOBALS['filters'][U_L]['scale']['linkvalue'], 'id' => $data[0]['project_scale_id'], 'name' => $data[0]['scale_denomination']); $link_priority = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'filter' => $GLOBALS['filters'][U_L]['priority']['linkvalue'], 'id' => $data[0]['project_priority_id'], 'name' => $data[0]['project_priority']); $link_user = array('rub' => $GLOBALS['links'][U_L]['user-profile']['linkvalue'], 'id' => $data[0]['project_posted_by'], 'name' => $data[0]['user_login']); $link_parent = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'id' => $data[0]['project_parent_id'], 'name' => $data[0]['parent_name']); $link_self = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'id' => $project_id); $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'); $workshop_id = formatText(empty_nc($data[0]['project_workshop_id']), '2HTML'); $workshop_name = formatText(empty_nc($data[0]['workshop_denomination']), '2HTML'); $scale_id = $data[0]['project_scale_id']; $project_theme_id = $data[0]['project_theme_id']; if($project_theme_id != 0) { $project_theme = formatText($data[0]['sdtheme_name'], '2HTML'); $link_theme = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'filter' => $GLOBALS['filters'][U_L]['theme']['linkvalue'], 'id' => $data[0]['theme_sd_theme'], 'name' => $project_theme); } $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 .= _t('statut','published_on') . ' ' . $project_posted_on . ' '; $content .= _t('divers','by').' ' . $project_posted_by . ''; if ($project_status == 'PA') { $content .= ' (' . _t('statut','archived_on') . ' ' . $project_modify_on . ')'; } $content .= formatted_permalink($link_self, ' - '); $content .= '

' . END_LINE; if($data[0]['project_parent_id'] != 0) { $content .= '
' . END_LINE; $content .= _t('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 .= getAssociatedIndicators($project_id, $scale_id); $content .= getAssociatedWorkshop($workshop_id, $workshop_name); $content .= '

' . END_LINE; $content .= _t('project','priority') . ' : '; $content .= '' . $project_priority . ' ' . END_LINE; $content .= ' ' . _t('divers','scale') . ' : '; $content .= '' . $project_scale . '' . END_LINE; if($project_theme_id != 0) { $content .= ' ' . _t('divers','themeref') . ' : '; $content .= '' . $project_theme . '' . END_LINE; } $content .= '

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

'._t('project','sub-projects').' :

'.END_LINE; } return $content; } } /** * GetStatusName() * * @param $status * @return $stat Status name */ if(!function_exists('GetStatusName')) { 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 */ if(!function_exists('getScheduleTable')) { 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 .= '
'._t('project','begin_date').''._t('project','estimated_date').''._t('project','end_date').'
'.formatText(empty_nc($s_date)).''.formatText(empty_nc($es_date)).''.formatText(empty_nc($e_date)).'
'.END_LINE; return $content; } } /** * getAssociatedWorkshop() * * @param $id * @return string */ if(!function_exists('getAssociatedWorkshop')) { function getAssociatedWorkshop($wid, $wname) { $content = ''; if($wid != 0) { $link = array('rub' => $GLOBALS['links'][U_L]['workgroup']['linkvalue'], 'id' => $wid, 'name' => $wname); $content .= '
'.END_LINE; $content .= '

'.ucfirst(_t('project','workshop')).' : ' . $wname . '

' .END_LINE; $content .= '
'.END_LINE; } return $content; } } /** * getAssociatedWorkshop() * * @param $id * @return string */ if(!function_exists('getAssociatedIndicators')) { function getAssociatedIndicators($id, $scale_id) { $data = $GLOBALS['sql_object']->DBSelect(SQL_getProjectSdi($id)); $content = ''; if (count($data) != 0 && $data[0]!=0) { $content .= '
'.END_LINE; $content .= '

'.ucfirst(_t('project','sdi')).' :

'.END_LINE; $content .= '
'.END_LINE; } return $content; } } ?>