* @version $Id$
* @access public
* @license http://opensource.org/licenses/gpl-3.0.html
*/
include_once(override('../project/' . SQL . '.inc.php'));
/**
* DisplayListProjectByThemes()
* Affichage de la liste des projets publics par themes
*
* @param string $statut
* @param integer $filter
* @param string $id_filter
* @param integer $debut
* @return string $content
*/
if(!function_exists('DisplayListProjectByThemes')) {
function DisplayListProjectByThemes($statut, $filter, $id_filter, $debut)
{
if ($statut == 'public') {
$pas = 100;
$suffix = '';
} else $pas = SELECT_LIMIT;
if ($statut == 'archives_p') $suffix = ' "'.strtolower(_t('statut','PA')).'"';
// we retrieve main themes
if($filter != 'THEME') {
$themes = $GLOBALS['sql_object']->DBSelect(SQL_getSDThemes());
} else {
$themes = $GLOBALS['sql_object']->DBSelect(SQL_getOneSDTheme($id_filter));
}
$content = '';
// we loop on main themes
for($j = 0; $j < count($themes); $j++) {
// print_r($themes[$j]);
// echo "
";
// we pass the theme ID to the SQL query
if($filter == 'TAG') {
$data = $GLOBALS['sql_object']->DBSelect(SQL_getProjectsList($debut, $pas, $statut, 'THEME_TAG', $themes[$j]['sdtheme_id'], $id_filter));
} else {
$data = $GLOBALS['sql_object']->DBSelect(SQL_getProjectsList($debut, $pas, $statut, 'THEME', $themes[$j]['sdtheme_id']));
}
// // we sort values on theme names
// // Obtain a list of columns
// foreach ($data as $key => $row) {
// $theme[$key] = $row['theme_name'];
// }
// // Sort the data with theme descending
// // Add $data as the last parameter, to sort by the common key
// array_multisort($theme, SORT_DESC, $data);
$theme_name = formatText($themes[$j]['sdtheme_name'], '2HTML');
$link_theme = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'filter' => $GLOBALS['filters'][U_L]['theme']['linkvalue'], 'id' => $themes[$j]['sdtheme_id'], 'name' => $theme_name);
// print_r($data);
$content .= '
' . PHP_EOL;
$content .= '' . $theme_name . '' . PHP_EOL;
$content .= '
' . PHP_EOL;
// $content .= '' . formatText($themes[$j]['sdtheme_description'], '2HTML') . '
' . PHP_EOL;
if ($data != 0) {
$content .= '' . PHP_EOL;
$current_link = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue']);
$current_theme = '';
for($i = 0; $i < count($data); $i++) {
if($current_theme != $data[$i]['project_theme_id']) {
$content .= '
' . formatText($data[$i]['theme_name'], '2HTML') . '
' . PHP_EOL;
$current_theme = $data[$i]['project_theme_id'];
}
$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'];
$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 .= '
' . PHP_EOL;
$content .= '' . $project_name . '' . PHP_EOL;
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
} else {
$content .= '' . _t('divers','nodata') . '
';
}
}
echo $content;
}
}
/**
* 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)
{
// getting tags
include_once('../class/class.tag.php');
if ($statut == 'public') {
$pas = 100;
$suffix = '';
} else $pas = SELECT_LIMIT;
$sep = ' / ';
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 . '
' . PHP_EOL;
$content = '';
if ($data != 0) {
// echo $bdd_nb_com_display; // affichage du nombre d'enregistrements
$current_link = array('rub' => $GLOBALS['links'][U_L][ActiveItemKey($GLOBALS['activeitem'])]['linkvalue']);
$content .= get_linkin_page($current_link, $bdd_nb_com, $debut, $pas);
for($i = 0; $i < count($data); $i++) {
$link_detail = array('rub' => $GLOBALS['links'][U_L][ActiveItemKey($GLOBALS['activeitem'])]['linkvalue'], 'id' => $data[$i]['project_id'], 'name' => $data[$i]['project_name']);
$link_scale = array('rub' => $GLOBALS['links'][U_L][ActiveItemKey($GLOBALS['activeitem'])]['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][ActiveItemKey($GLOBALS['activeitem'])]['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']);
$link_tag = array('rub' => $GLOBALS['links'][U_L][ActiveItemKey($GLOBALS['activeitem'])]['linkvalue'], 'filter' => 'tag');
$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][ActiveItemKey($GLOBALS['activeitem'])]['linkvalue'], 'filter' => $GLOBALS['filters'][U_L]['theme']['linkvalue'], 'id' => $data[$i]['theme_sd_theme'], 'name' => $project_theme);
}
$otag = new tag();
$tags = $otag->getTags('project', $data[$i]['project_id'], false);
$content .= '' . PHP_EOL;
$content .= '' . $project_name . '' . PHP_EOL;
$content .= '
' . PHP_EOL;
$content .= '' . PHP_EOL;
$content .= ''._t('statut','published_on') . ' ' . $project_posted_on . ' ';
$content .= _t('divers','by').' ' . $project_posted_by . '';
$content .= '
' . PHP_EOL;
$content .= '' . $project_description . '
' . PHP_EOL;
$content .= ''._t('btn', 'read_more').'';
$content .= '';
$content .= mb_ucfirst(_t('project','priority')) . ' :
' . mb_ucfirst($project_priority) . '' . $sep . PHP_EOL;
$content .= _t('divers','scale') . ' :
' . $scale_denomination . '' . $sep . PHP_EOL;
if($project_theme_id != 0) {
$content .= ' ' . _t('divers','themeref') . ' : ';
$content .= '
' . $project_theme . '' . PHP_EOL;
}
if(!empty($tags)) {
$content .= '
' . PHP_EOL;
$content .= mb_ucfirst(_t('tag','name')) . ' : ' . $otag->linkTags($tags, $link_tag). PHP_EOL;
$content .= '
' . PHP_EOL;
}
$content .= '
'.PHP_EOL;
if($i';
}
$content .= get_linkin_page($current_link, $bdd_nb_com, $debut, $pas);
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, array('P', 'PA')));
$content = '';
if($data == 0) error_redirect();
// getting tags
include_once('../class/class.tag.php');
$otag = new tag();
$tags = $otag->getTags('project', $project_id, false);
$sep = ' / ';
if (count($data) != 1) exit;
else {
$link_scale = array('rub' => $GLOBALS['links'][U_L][ActiveItemKey($GLOBALS['activeitem'])]['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][ActiveItemKey($GLOBALS['activeitem'])]['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][ActiveItemKey($GLOBALS['activeitem'])]['linkvalue'], 'id' => $project_id);
$link_tag = array('rub' => $GLOBALS['links'][U_L][ActiveItemKey($GLOBALS['activeitem'])]['linkvalue'], 'filter' => 'tag');
$project_coordinator = empty_nc(getAssociatedActors($project_id, 'coordinator'));
$project_partners = empty_nc(getAssociatedActors($project_id, 'partner'));
$project_managers = empty_nc(getAssociatedManagers($project_id));
$project_name = formatText($data[0]['project_name'], '2HTML');
$project_goal = formatText($data[0]['project_goal'], '2HTML');
$project_description = linkin_content(formatText($data[0]['project_description'], '2HTML'));
$project_body = linkin_content(formatText($data[0]['project_body'], '2HTML'));
$project_budget = formatText(empty_nc(fnumber_format($data[0]['project_budget'], 0, false)), '2HTML');
$project_budget_comment = formatText($data[0]['project_budget_comment'], '2HTML');
$project_team = formatText($data[0]['project_team'], '2HTML');
$project_elected = formatText($data[0]['project_elected'], '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');
$project_progression = $data[0]['project_completed'];
$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'];
if(commentEnabled('project')) {
postCommentAction(array('module'=> ActiveItemKey($GLOBALS['activeitem']), 'module_id'=> $project_id));
$content .= ''.PHP_EOL;
}
$content .= '' . $project_name . '
' . PHP_EOL;
$content .= '' . PHP_EOL;
$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 .= '
' . PHP_EOL;
if($data[0]['project_parent_id'] != 0) {
$content .= '' . PHP_EOL;
$content .= mb_ucfirst(_t('project','parent')) . ' : ';
$content .= '
' . $project_parent . ' ';
$content .= '
' . PHP_EOL;
}
if(!empty($project_goal)) $content .= ''.mb_ucfirst(_t('project', 'goal')).' : ' . $project_goal . '
' . PHP_EOL;
$content .= '' . PHP_EOL;
$content .= '
' . PHP_EOL;
$content .= '
' . $schedule_table . '
' . PHP_EOL;
$content .= '
'.mb_ucfirst( _t('project','progression')). '
' .getDynamicProgressbar($project_progression, 80). '
' . PHP_EOL;
$content .= '
' . PHP_EOL;
$content .= '
' . PHP_EOL;
$content .= '' . $project_description . '
' . PHP_EOL;
if(!empty($project_body)) $content .= '' . $project_body . '
' . PHP_EOL;
$content .= '';
$content .= '
';
$content .= '
';
$content .= '
' . _t('project','steering_title') . '
';
$content .= mb_ucfirst(_t('project','elected')) . ' :
' . empty_nc($project_elected) . '';
$content .= mb_ucfirst(_t('project','coordinator')) . ' :
' . $project_coordinator . '' . mb_ucfirst(_t('project','partners')) . ' :
' . $project_partners .'';
$content .= mb_ucfirst(_t('project','manager')) . ' :
' . $project_managers . '';
$content .= mb_ucfirst(_t('project','team')) . ' :
' . empty_nc($project_team) . '
';
$content .= '
';
$content .= '
';
$content .= '
' . _t('project','budget_title') . '
';
$content .= mb_ucfirst(_t('project','budget')). ' :
' . $project_budget . '';
if(!empty($project_budget_comment)) $content .= '
' . $project_budget_comment . '
';
$content .= '
';
$content .= '
' . PHP_EOL;
$content .= '
' . PHP_EOL;
$content .= getProjectChildren($project_id);
//$content .= getAssociatedIndicators($project_id, $scale_id);
$content .= getAssociatedIndicatorsValues($project_id, $scale_id);
$content .= getAssociatedWorkshop($workshop_id, $workshop_name);
$content .= '' . PHP_EOL;
$content .= mb_ucfirst(_t('project','priority')) . ' : ';
$content .= '
' . mb_ucfirst($project_priority) . '' . $sep . PHP_EOL;
$content .= ' ' . _t('divers','scale') . ' :
' . $project_scale . '' . $sep . PHP_EOL;
if($project_theme_id != 0) {
$content .= ' ' . _t('divers','themeref') . ' :
' . $project_theme . '' . PHP_EOL;
}
if(!empty($tags)) {
$content .= '
' . PHP_EOL;
$content .= ' ' . mb_ucfirst(_t('tag','name')) . ' : ' . $otag->linkTags($tags, $link_tag). PHP_EOL;
$content .= '
' . PHP_EOL;
}
$content .= '
' . PHP_EOL;
}
// including sparkline code
footerAddJS('../lib/js/jquery.sparkline.min.js');
footerAddInlineJS("$('.inlinebar').sparkline('html', {type: 'bar', barColor: '#8DA8CB'} );");
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 .= ''.PHP_EOL;
$content .= '
'.mb_ucfirst(_t('project','sub-projects')).' :
'.PHP_EOL;
for($i = 0; $i < count($data); $i++) {
$link = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'id' => $data[$i]['project_id'], 'name' => $data[$i]['project_name']);
$name = formatText($data[$i]['project_name'], '2HTML');
$content .= '- ' . $name . '
' .PHP_EOL;
}
$content .= '
'.PHP_EOL;
}
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 = ''.PHP_EOL;
$content .= ''.PHP_EOL;
$content .= ''.PHP_EOL;
$content .= ''.mb_ucfirst(_t('project','begin_date')).' | '.PHP_EOL;
$content .= ''.mb_ucfirst(_t('project','estimated_date')).' | '.PHP_EOL;
$content .= ''.mb_ucfirst(_t('project','end_date')).' | '.PHP_EOL;
$content .= '
'.PHP_EOL;
$content .= ''.PHP_EOL;
$content .= ''.PHP_EOL;
$content .= ''.PHP_EOL;
$content .= ''.formatText(empty_nc($s_date)).' | '.PHP_EOL;
$content .= ''.formatText(empty_nc($es_date)).' | '.PHP_EOL;
$content .= ''.formatText(empty_nc($e_date)).' | '.PHP_EOL;
$content .= '
'.PHP_EOL;
$content .= ''.PHP_EOL;
$content .= '
'.PHP_EOL;
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 .= ''.PHP_EOL;
$content .= '
'.ucfirst(_t('project','workshop')).'
'.PHP_EOL;
$content .= '
' . $wname . '
' .PHP_EOL;
$content .= '
'.PHP_EOL;
}
return $content;
}
}
/**
* getAssociatedActors()
*
* @param $id
* @param $type
* @return string
*/
if(!function_exists('getAssociatedActors')) {
function getAssociatedActors($id, $type)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_getAssociatedActors($id, $type));
$content = '';
$sep = '';
if (count($data) != 0 && $data[0]!= 0) {
for($i = 0; $i < count($data); $i++) {
$name = formatText($data[$i]['actor_name'], '2HTML');
$content .= $sep.$name;
$sep =', ';
}
}
return $content;
}
}
/**
* getAssociatedManagers()
*
* @param $id
* @return string
*/
if(!function_exists('getAssociatedManagers')) {
function getAssociatedManagers($id)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_getAssociatedManagers($id));
$content = '';
$sep = '';
if (count($data) != 0 && $data[0]!= 0) {
for($i = 0; $i < count($data); $i++) {
$name = formatText($data[$i]['user_login'], '2HTML');
$content .= $sep.$name;
$sep =', ';
}
}
return $content;
}
}
/**
* getAssociatedWorkshop()
*
* @param $id
* @return string
*/
if(!function_exists('getAssociatedIndicators')) {
function getAssociatedIndicators($id, $scale_id, $linkto = true)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_getProjectSdi($id));
$content = '';
if (count($data) != 0 && $data[0]!=0) {
$content .= ''.PHP_EOL;
$content .= '
'.ucfirst(_t('project','sdi')).'
'.PHP_EOL;
$content .= '
'.PHP_EOL;
for($i = 0; $i < count($data); $i++) {
$link = array('rub' => $GLOBALS['links'][U_L]['dashboard']['linkvalue'], 'id' => $data[$i]['sdii_id'], 'parentid' => $scale_id, 'name' => $data[$i]['sdii_name']);
$name = formatText($data[$i]['sdii_name'], '2HTML');
if($linkto) {
$content .= '- ' . $name . '
' .PHP_EOL;
} else {
$content .= '- ' . $name . '
' .PHP_EOL;
}
}
$content .= '
'.PHP_EOL;
}
return $content;
}
}
/**
* getAssociatedWorkshop()
*
* @param $id
* @return string
*/
if(!function_exists('getAssociatedIndicatorsValues')) {
function getAssociatedIndicatorsValues($id, $cursorcssposition = 0)
{
include_once('../dashboard/display.php');
include_once('../dashboard/mysql.inc.php');
$result_sdi = $GLOBALS['sql_object']->DBSelect(SQL_getProjectSdiValues($id));
$content = '';
$id_filter= 1; // scale id value
if (count($result_sdi) != 0 && $result_sdi[0]!=0) {
$content .= ''.PHP_EOL;
$content .= '
'.ucfirst(_t('project','sdi')).'
'.PHP_EOL;
// table header
$content .= '
' . PHP_EOL;
$content .= '' . PHP_EOL;
$content .= '' . PHP_EOL;
$content .= ''.mb_ucfirst(_t('dashboard','graphic_value')).' | ' . PHP_EOL;
//$content .= ''.mb_ucfirst(_t('dashboard','numeric_value')).' | ' . PHP_EOL;
$content .= ''.mb_ucfirst(_t('dashboard','label_value')).' | ' . PHP_EOL;
$content .= '
' . PHP_EOL;
$content .= '' . PHP_EOL;
$content .= '' . PHP_EOL;
for ($j = 0;$j < count($result_sdi);$j++) {
// setting $threshold_value
// By default initial value
$threshold_value = $result_sdi[$j]['sdii_threshold_value'];
// if set, we get the latest for the given scale
$r = $GLOBALS['sql_object'] -> DBSelect(SQL_getlastInsertByPublicationDate($result_sdi[$j]['sdii_id'], 1));
if(isset($r[0]['sdiv_value']) && !is_null($r[0]['sdiv_threshold'])) {
$threshold_value = $r[0]['sdiv_threshold'];
}
if(CURRENT_APP == 'admin') {
$link_det_sdi = './index.php?rub=dashboard&todo=det&id='.$result_sdi[$j]['sdii_id'].'&scale_id='.$id_filter;
} else {
$link_det_sdi= HrefMaker(array('rub'=> $GLOBALS['links'][U_L]['dashboard']['linkvalue'],'id'=>$result_sdi[$j]['sdii_id'], 'parentid'=> $id_filter, 'name' => $result_sdi[$j]['sdii_name']));
}
$content .= "" . PHP_EOL;
$content .= "";
$content .= getViz($GLOBALS['sql_object'], $id_filter, $result_sdi[$j], $threshold_value, null, $cursorcssposition);
$content .= " | ";
$content .= "" . formatText(cutText($result_sdi[$j]['sdii_name'], 53), '2HTML') . " | " . PHP_EOL;
$content .= "
" . PHP_EOL;
}
$content .= "" . PHP_EOL;
$content .= "
" . PHP_EOL;
$content .= "
" . PHP_EOL;
}
$js = '';
footerAddInlineJS($js, 'default', false);
return $content;
}
}
?>