* @version $Id$
* @access public
* @license http://opensource.org/licenses/gpl-3.0.html
*/
include_once(override('../dashboard/' . SQL . '.inc.php'));
include_once(override('../project/' . SQL . '.inc.php'));
include_once(override('../dashboard/common.php'));
include_once(override("../dashboard/chart-prepare.php"));
/**
* DisplayListValuesByLevelsAlt()
* affichage du tableau de bord alternatif
* @param integer $id_filter
* @param integer $filter
* @return
**/
if(!function_exists('DisplayListValuesByLevelsAlt')) {
function DisplayListValuesByLevelsAlt($id_filter = -1, $filter = -1)
{
$firstlevels = $GLOBALS['sql_object'] ->DBSelect(SQL_getLevelsList(true));
// quick and dirty ....
// selecting indicators by tags will remove scale filter
if(isset($_REQUEST['filter']) && $_REQUEST['filter'] == 'tag') {
$sdi = $GLOBALS['sql_object'] -> DBSelect(SQL_getListSdi("TAG", $_REQUEST['id']));
} else {
$sdi = $GLOBALS['sql_object'] -> DBSelect(SQL_getListSdi("P", $valueparam = 0));
}
if(!isset($sdi[0]['sdii_id'])) return false;
$sdi = add_root_level($sdi, 'sdii_level', 'level_root'); // we add extra field with level root
$listing = "";
$a = array(); // do not display an indicator twice
$current_level = '';
for ($i = 0;$i < count($firstlevels);$i++) {
if ($firstlevels[$i]['level_id'] != $current_level && $current_level <> '') {
$listing .= " " . PHP_EOL;
}
if ($firstlevels[$i]['level_id'] != $current_level) {
$current_level = $firstlevels[$i]['level_id'];
$listing .= "" . formatText($firstlevels[$i]['level_name'], '2HTML') . "
".PHP_EOL;
$listing .= '' . PHP_EOL;
}
for ($j = 0;$j < count($sdi);$j++) {
if ($firstlevels[$i]['level_id'] == $sdi[$j]['level_root']) {
// we display the value only if attached to dashboard
// and if not yet displayed
if ($sdi[$j]['sdii_to_dashboard']=='Y' && !in_array($sdi[$j]['sdii_id'], $a)) {
// setting $threshold_value
// By default initial value
$threshold_value = $sdi[$j]['sdii_threshold_value'];
// if set, we get the latest for the given scale
$r = $GLOBALS['sql_object'] -> DBSelect(SQL_getlastInsertByPublicationDate($sdi[$j]['sdii_id'], $id_filter));
if(isset($r[0]['sdiv_value']) && !is_null($r[0]['sdiv_threshold'])) {
$threshold_value = $r[0]['sdiv_threshold'];
}
if($sdi[$j]['sdii_type'] != 'not-set') $typecontent = '
'.formatText(mb_ucfirst($GLOBALS['lang']['sdi']['select_type'][$sdi[$j]['sdii_type']]), '2HTML').'';
else $typecontent ='';
$link_det_sdi= array('rub'=> $GLOBALS['links'][U_L]['dashboard']['linkvalue'],'id'=>$sdi[$j]['sdii_id'], 'parentid'=> $id_filter, 'name' => $sdi[$j]['sdii_name']);
$listing .= "
" . PHP_EOL;
$listing .= getViz($GLOBALS['sql_object'], $id_filter, $sdi[$j], $threshold_value);
$listing .= "
" . formatText($sdi[$j]['sdii_name'], '2HTML') . "" . PHP_EOL;
$listing .= "
" . formatText($sdi[$j]['level_label'], '2HTML') . " : " . formatText($sdi[$j]['level_name'], '2HTML') . "
". PHP_EOL;
$listing .= $typecontent . PHP_EOL;
$listing .= "
" . PHP_EOL;
array_push($a, $sdi[$j]['sdii_id']); // we add the id into array for not displaying it twice
}
}
}
}
$listing .= "
" . formatText($firstlevels[$i]['level_name'], '2HTML') . "
".PHP_EOL;
$listing .= '' . PHP_EOL;
$listing .= '' . PHP_EOL;
$listing .= '' . PHP_EOL;
$listing .= '| '.mb_ucfirst(_t('dashboard','graphic_value')).' | ' . PHP_EOL;
$listing .= ''.mb_ucfirst(_t('dashboard','label_value')).' | ' . PHP_EOL;
$listing .= '
' . PHP_EOL;
$listing .= '' . PHP_EOL;
$listing .= '' . PHP_EOL;
}
for ($j = 0;$j < count($sdi);$j++) {
if ($firstlevels[$i]['level_id'] == $sdi[$j]['level_root']) {
// we display the value only if attached to dashboard
// and if not yet displayed
if ($sdi[$j]['sdii_to_dashboard']=='Y' && !in_array($sdi[$j]['sdii_id'], $a)) {
// setting $threshold_value
// By default initial value
$threshold_value = $sdi[$j]['sdii_threshold_value'];
// if set, we get the latest for the given scale
$r = $GLOBALS['sql_object'] -> DBSelect(SQL_getlastInsertByPublicationDate($sdi[$j]['sdii_id'], $id_filter));
if(isset($r[0]['sdiv_value']) && !is_null($r[0]['sdiv_threshold'])) {
$threshold_value = $r[0]['sdiv_threshold'];
}
if($sdi[$j]['sdii_type'] != 'not-set') $typecontent = ''.formatText(mb_ucfirst($GLOBALS['lang']['sdi']['select_type'][$sdi[$j]['sdii_type']]), '2HTML').'';
else $typecontent ='';
$link_det_sdi= array('rub'=> $GLOBALS['links'][U_L]['dashboard']['linkvalue'],'id'=>$sdi[$j]['sdii_id'], 'parentid'=> $id_filter, 'name' => $sdi[$j]['sdii_name']);
$listing .= "" . PHP_EOL;
$listing .= "| ";
$listing .= getViz($GLOBALS['sql_object'], $id_filter, $sdi[$j], $threshold_value);
$listing .= " | ";
$listing .= "" . formatText($sdi[$j]['sdii_name'], '2HTML') . "".$typecontent." | " . PHP_EOL;
$listing .= "
" . PHP_EOL;
array_push($a, $sdi[$j]['sdii_id']); // we add the id into array for not displaying it twice
}
}
}
}
$listing .= "" . PHP_EOL;
$listing .= "
" . PHP_EOL;
hoverJsBox();
// including sparkline code
footerAddJS('../lib/js/jquery.sparkline.min.js');
footerAddInlineJS("$('.inlinebar').sparkline('html', {type: 'bar', barColor: '#8DA8CB'} );");
echo $listing;
}
}
/**
* DisplayListProjectByLevelsWithIndicators()
* Affichage de la liste des projets publics par niveaux
*
* @param string $statut
* @param integer $filter
* @param string $id_filter
* @param integer $debut
* @return string $content
*/
if(!function_exists('DisplayListProjectByLevelsWithIndicators')) {
function DisplayListProjectByLevelsWithIndicators($statut, $filter, $id_filter)
{
$data = $GLOBALS['sql_object']->DBSelect(SQL_getLevelsList());
// we retrieve main levels
if($filter != 'LEVEL') {
$data = getLevelChildren($data, 0); // 0 is parentid
$sublevels = $id_filter;
$depth = 0;
} else {
$current = $GLOBALS['sql_object']->DBSelect(SQL_getoneLevel($id_filter));
$data = getLevelChildren($GLOBALS['sql_object']->DBSelect(SQL_getLevelsList()), $id_filter);
$sublevels = array_extract($data, 'level_id', true, 'children');
// if there is no sub-menu, we are working on last levels
// we emulate a level by passing choosen level but 'level_parent' is not set
if(count($sublevels) == 0) {
$sublevels = array($id_filter);
$data = $current;
}
$content = '' . $current[0]['level_name'] . '
' . PHP_EOL;
$content .= '' . $current[0]['level_desc_project'] . '
' . PHP_EOL;
$depth = 1;
}
echo '';
if(isset($content)) echo $content;
echo generate_html_recursive_with_indicators($data, $statut, $filter, $sublevels, $depth);
echo '
';
// including sparkline code
footerAddJS('../lib/js/jquery.sparkline.min.js');
footerAddInlineJS("$('.inlinebar').sparkline('html', {type: 'bar', barColor: '#8DA8CB'} );");
hoverJsBox();
return true;
}
}
/**
* getAssociatedIndicatorsValues()
*
* @param $id
* @return string
*/
if(!function_exists('getAssociatedIndicatorsValues')) {
function getAssociatedIndicatorsValues($id, $orderedIndicators, $extraclass ='', $cursorcssposition = 0, $addvalues = false)
{
global $l21auth;
global $sql_object;
$result_sdi = $GLOBALS['sql_object']->DBSelect(SQL_getProjectSdiValues($id));
$content = '';
$id_filter= 1; // scale id value
if (CURRENT_APP == 'admin' && ($l21auth->isProjectManager($l21auth->GetSessionElement('id'), $sql_object, $id) || $l21auth->hasRight('sdi'))) {
$displayLink = true;
} else {
$displayLink = false;
}
if (is_array($result_sdi) && $result_sdi[0]!= 0) {
$ordered_indics = array();
// we prepare ordered data if given
// 1 - first data stored in $orderedIndicators, then all data
if(!is_null($orderedIndicators)) $tmp = unserialize($orderedIndicators);
if(is_array($tmp)) {
foreach($tmp as $k => $v) {
if(is_integer($k)) array_push($ordered_indics, $k); // to be sure it is not empty
}
}
// 2 - then, we iterate on all indicators thare are not already in $ordered_indics
foreach($result_sdi as $sdi) {
if($sdi['sdii_statut'] == 'P' && !in_array($sdi['sdii_id'], $ordered_indics)) array_push($ordered_indics, $sdi['sdii_id']); // to be sure it is not empty
}
$content .= '" . PHP_EOL;
}
return $content;
}
}
/**
* generate_html_recursive_with_indicators()
*
* @see : http://stackoverflow.com/questions/7577396/php-walking-and-print-multi-dimensional-array
* @param unknown $data
* @return string
*/
/**
*
* @param array $data
* @param unknown $statut
* @param unknown $filter
* @param unknown $id_filter
* @param unknown $depth
* @param unknown $display_first
* @return string
*/
if(!function_exists('generate_html_recursive_with_indicators')) {
function generate_html_recursive_with_indicators($data, $statut, $filter, $id_filter, $depth, $workshop_id =-1)
{
// begin with an empty html string
$html = '';
// loop through all items in this level
foreach($data as $key => &$item)
{
// echo "$key
";
// where only interested in numeric items
// as those are the actual children
if( !is_numeric( $key ) )
{
// otherwise continue
continue;
}
// 'level_parent' attribute is not set when there is no children level
if(isset($item['level_parent'])) {
// we display link only on main levels
$link_level = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'filter' => $GLOBALS['filters'][U_L]['level']['linkvalue'], 'id' => $item['level_id'], 'name' => $item['level_name']);
if($item['level_parent'] == 0) {
// $html .= '' . PHP_EOL;
$html .='';
} else {
$html .='';
}
$html .= '';
}
// echo "
";
// print_r($data[$j]);
// echo "
";
// we pass the level ID to the SQL query
// Dirty but it works .....
// PRIORITY and SCALE filters are handle later when choosing to displaying or not the project
// See on the '$projects' loop
if($filter == 'TAG') {
$projects = $GLOBALS['sql_object']->DBSelect(SQL_getProjectsList(0, 999, $statut, 'LEVEL_TAG', $item['level_id'], $id_filter, $workshop_id));
} else {
$projects = $GLOBALS['sql_object']->DBSelect(SQL_getProjectsList(0, 999, $statut, 'LEVEL', $item['level_id'], $workshop_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 ($projects != 0) {
$current_link = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue']);
$current_level = '';
// $html .= '
'.mb_ucfirst(_t('project','name')).'
'.PHP_EOL;
// $html .= '
// $html .= '
' . PHP_EOL;
for($i = 0; $i < count($projects); $i++) {
$count = $GLOBALS['sql_object']->DBSelect(SQL_getProjectSdiValuesNumber($projects[$i]['project_id']));
if($count[0]['number'] > 0) {
$html .= '
' . PHP_EOL;
$link_detail = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'id' => $projects[$i]['project_id'], 'name' => $projects[$i]['project_name']);
$project_name = formatText($projects[$i]['complete_project_name'], '2HTML');
if($projects [$i] ['project_parent_id'] != 0) $class='sub-project'; else $class = 'project';
$html .= '
' . PHP_EOL;
$html .= '
' . PHP_EOL;
$html .= getAssociatedIndicatorsValues($projects[$i]['project_id'], $projects[$i]['project_indic_order'], $extraclass ='', $cursorcssposition = 0, $addvalues = false);
$html .= '
';
$html .= '
' . PHP_EOL; // ferme grid-6-small-3
}
} // boucle projet
} // test si projet
// $html .= '
' . PHP_EOL;
// 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_with_indicators($item['children'], $statut, $filter, $id_filter, $depth+1);
$html .= '
';
if(in_array(true, $display_flags)) echo getDashboardNavigation($sdi_id, $scale_id, $display_flags);
echo GetOneSdiInfoAndValues($sdi_id, $scale_id);
if($display_flags['rules']) echo GetOneSdiRules($sdi_id, $result_r);
if($display_flags['assessment']) echo GetOneSdiEvaluation($sdi_id, $result_e);
if($display_flags['provider']) echo GetOneSdiProvider($sdi_id, $result_p);
echo '
';
}
}
/**
* GetAllValue()
* afficahge de l'ensemble des valeurs publiques d'un IDD
* @param $sdi_id
* @param $scale_id
* @return
**/
if(!function_exists('GetAllValue')) {
function GetAllValue($sdi_id, $scale_id)
{
if(defined('CLIENT_CHARTS') && CLIENT_CHARTS == 1) {
footerAddJS('../lib/js/Highcharts-7.0.3/code/highcharts.js');
// https://www.highcharts.com/docs/export-module/export-module-overview
footerAddJS('../lib/js/Highcharts-7.0.3/code/modules/exporting.js');
footerAddJS('../lib/js/Highcharts-7.0.3/code/modules/offline-exporting.js');
footerAddJS('../lib/js/generate-chart.js');
// footerAddJS('../lib/js/Highcharts-7.0.3/code/themes/grid-light.js');
}
$result_value = $GLOBALS['sql_object'] -> DBSelect(SQL_getAllValue("SCD", $scale_id, $sdi_id));
$result_sdi_value = $GLOBALS['sql_object'] -> DBSelect(SQL_getInfoSdiforvalue($sdi_id));
// Préparation de la génération des graphiques
// we create an array to populate and send to javascript
$obj = [];
$obj['site-language'] = U_L;
$obj['indicator-name'] = formatText($result_sdi_value[0]['sdii_name'], '2HTML');
$obj['indicator-type'] = $result_sdi_value[0]['sdii_value_type'];
$obj['indicator-default-vis'] = $result_sdi_value[0]['sdii_detail_viz'];
$obj['indicator-wanted-vis'] = $result_sdi_value[0]['sdii_detail_viz'];
$obj['indicator-wanted-year'] = null;
$obj['indicator-serie-name'] = formatText(_t('dashboard', 'value'), '2HTML');
$obj['indicator-threshold-name'] = formatText(_t('dashboard', 'threshold_value'), '2HTML');
$obj['indicator-unit'] = $result_sdi_value[0]['sdii_unit'];
$obj['indicator-negative-notice'] = formatText(_t('dashboard', 'negative_values_notice'));
$obj['dates'] = array();
$obj['data'] = array();
$obj['thresholds'] = array();
if($obj['indicator-wanted-vis'] == 'donut') {
$obj['indicator-wanted-vis'] = 'pie';
$obj['vis-pie-size'] = '60%';
}
$cdata = prepare_chart_data($result_sdi_value, $obj, $result_value);
// setting $default_threshold value
// By default initial value
$default_threshold = $result_sdi_value[0]['sdii_threshold_value'];
$req_sdii=SQL_getInfoSdi($sdi_id);
$result_sdii = $GLOBALS['sql_object'] -> DBSelect($req_sdii);
// we init javascript vars for generating charts
?>
' . PHP_EOL;
$content .= ''._t('dashboard','historic').'
' . PHP_EOL;
if ($result_value <> false) {
if(defined('CHART_MIN_VALUES') && is_numeric(CHART_MIN_VALUES)) $minChartValues = CHART_MIN_VALUES; else $minChartValues = 2;
if (count($result_value) >= $minChartValues) {
$content .= ''._t('dashboard','rep_graph').'
' . PHP_EOL;
if($result_sdi_value[0]['sdii_nature'] == 'quantitative') {
if(!defined('CLIENT_CHARTS') || CLIENT_CHARTS != 1) {
$graph_path = override('../dashboard/graph.php');
$content .= "![\"".formatText(_t('dashboard','rep_graph'),](\"".$graph_path."?id=")
" . PHP_EOL;
} else {
$content .= '';
}
}
if($result_sdi_value[0]['sdii_nature'] == 'qualitative') $content .= getQualitativeViz($result_value, $result_sdi_value[0]);
}
$content .= ''.mb_ucfirst(_t('dashboard','all_value')).'
' . PHP_EOL;
$content .= '' . PHP_EOL;
$content .= '' . PHP_EOL;
$content .= '' . PHP_EOL;
$content .= "| ".mb_ucfirst(_t('dashboard','date'))." | " . PHP_EOL;
$content .= "".mb_ucfirst(_t('dashboard','value'))." (".$result_sdi_value[0]['sdii_unit'].") | " . PHP_EOL;
$content .= "".mb_ucfirst(_t('dashboard','threshold_value'))." | " . PHP_EOL;
$content .= "".mb_ucfirst(_t('dashboard','rate'))." | " . PHP_EOL;
$content .= "".mb_ucfirst(_t('dashboard','comment'))." | " . PHP_EOL;
$content .= "
" . PHP_EOL;
$content .= "" . PHP_EOL;
$content .= "" . PHP_EOL;
for ($i = 0;$i < count($result_value);$i++) {
$comment = '';
$current_val = '';
$data_pie = '';
// indicator is multivalues
if(!empty($result_value[$i]['sdiv_multivalue'])) {
$data = unserialize($result_value[$i]['sdiv_multivalue']);
foreach($data as &$val) {
$current_val .= '';
if(!empty($val['label'])) $current_val .= ''.formatText($val['label'], '2HTML'). ' : ';
$current_val .= ''.fnumber_format($val['value'], 'auto', false). ' ('.fnumber_format($val['_percentage'], 2, false).' %)';
$current_val .= '
';
}
// we display the total
if(!defined('CLIENT_CHARTS') || CLIENT_CHARTS != 1) {
$chartlink = override('../dashboard/pie.php').'?id='.$sdi_id.'&value='.$result_value[$i]['sdiv_id'].'&display=true';
} else {
$chartlink = SITE_ROOT_URL .'public/get-chart.php?id='.$sdi_id.'&type=donut&year='.substr(formatDate($result_value[$i]['date_p'], true), 0, 4).'&alternatives=all';
}
$current_val .= '';
$current_val .= mb_ucfirst(_t('dashboard', 'multivalue_total')) . ' : ' . fnumber_format($data[0]['_total'], 'auto', false);
$current_val .= ' '._t('dashboard', 'to_detail_chart').'';
$current_val .= '
';
$current_val_raw = $data[0]['_total'];
if($i == 0) {
$lastValue = $current_val_raw; // we store data to compute TCAM and global rate
$year_end = substr(formatDate($result_value[$i]['date_p'], true), 0, 4);
}
if($i == count($result_value)-1) {
$firstValue = $current_val_raw; // we store data to compute TCAM and global rate
$year_start = substr(formatDate($result_value[$i]['date_p'], true), 0, 4);
}
// we compute rate
if(isset($result_value[$i+1]['sdiv_multivalue'])) {
$dataPlusOne = unserialize($result_value[$i+1]['sdiv_multivalue']);
$evol = ($data[0]['_total'] - $dataPlusOne[0]['_total']) / $dataPlusOne[0]['_total'] * 100;
//_debug('rate : '. fnumber_format($evol, 2). ' % - details : ('.$data[0]['_total']. ' - ' . $dataPlusOne[0]['_total']. ') / '. $dataPlusOne[0]['_total']);
$evol = fnumber_format($evol, 2). ' %';
} else {
$evol = empty_nc('');
}
// indicator is NOT multivalues
} else {
// If indicator is boolean
if($result_sdi_value[0]['sdii_nature'] == 'boolean' || $result_sdi_value[0]['sdii_nature'] == 'qualitative') {
$a = getBooleanValues($result_sdi_value[0]);
if($a) {
$current_val .= $a[$result_value[$i]['sdiv_value']];
$current_val_raw = $result_value[$i]['sdiv_value'];
} else {
$current_val .= fnumber_format($result_value[$i]['sdiv_value'], 'auto', false);
$current_val_raw = $result_value[$i]['sdiv_value'];
}
} else {
$current_val .= fnumber_format($result_value[$i]['sdiv_value'], 'auto', false);
$current_val_raw = $result_value[$i]['sdiv_value'];
if($i == 0) {
$lastValue = $current_val_raw; // we store data to compute TCAM and global rate
$year_end = substr(formatDate($result_value[$i]['date_p'], true), 0, 4);
}
if($i == count($result_value)-1) {
$firstValue = $current_val_raw; // we store data to compute TCAM and global rate
$year_start = substr(formatDate($result_value[$i]['date_p'], true), 0, 4);
}
}
$evol = empty_nc('');
// we compute rate
if($result_sdii[0]['sdii_nature'] == 'quantitative') {
if(isset($result_value[$i+1]['sdiv_value']) && is_numeric($result_value[$i+1]['sdiv_value'])) {
$evol = ($result_value[$i]['sdiv_value'] - $result_value[$i+1]['sdiv_value']) / $result_value[$i+1]['sdiv_value'] * 100;
// _debug('rate : '. fnumber_format($evol, 2). ' % - details : ('.$result_value[$i]['sdiv_value']. ' - ' . $result_value[$i+1]['sdiv_value']. ') / '. $result_value[$i+1]['sdiv_value']);
$evol = fnumber_format($evol, 2). ' %';
} else {
$evol = empty_nc('');
}
}
}
// if set, we get it from the table
$threshold_raw = $default_threshold;
if(!is_null($result_value[$i]['sdiv_threshold'])) {
if($result_sdi_value[0]['sdii_nature'] == 'quantitative') {
$threshold = fnumber_format($result_value[$i]['sdiv_threshold'], 'auto', false);
$threshold_raw = $result_value[$i]['sdiv_threshold'];
} else {
$threshold = $a[$result_value[$i]['sdiv_threshold']];
$threshold_raw = $result_value[$i]['sdiv_threshold'];
}
} else {
$threshold = empty_none(fnumber_format($default_threshold, 'auto', false));
$threshold_raw = $default_threshold;
}
if(!empty($result_value[$i]['sdiv_comment']) && $result_value[$i]['sdiv_comment_display']=='Y') {
$comment = '';
}
$content .= "" . PHP_EOL;
$content .= "| " . formatText($result_value[$i]['date_p'], '2HTML') . " | " . PHP_EOL;
$content .= "" . formatText($current_val, '2HTML') . " | " . PHP_EOL;
$content .= "" . formatText($threshold, '2HTML') . " | " . PHP_EOL;
$content .= "". $evol. " | " . PHP_EOL;
$content .= "". $comment. " | " . PHP_EOL;
$content .= "
" . PHP_EOL;
}
$content .= "" . PHP_EOL;
$content .= "
" . PHP_EOL;
if($result_sdii[0]['sdii_nature'] == 'quantitative') $content .= getRates($firstValue, $lastValue, $year_start, $year_end);
if(!empty($default_threshold)) $content .= ''.mb_ucfirst(_t('sdi','initial_threshold_value')).' : '.$result_sdi_value[0]['sdii_threshold_value'].' '.$result_sdi_value[0]['sdii_unit'].'
' . PHP_EOL;
$content .= '' . PHP_EOL;
return $content;
}
}
}
/**
* GetSdiTitle()
* affichage nom d'un indicateur
* @param $sdi_id
* @param $scale_id
* @return
**/
if(!function_exists('GetSdiTitle')) {
function GetSdiTitle($sdi_id, $scale_id)
{
// getting tags
include_once('../class/class.tag.php');
$otag = new tag();
$tags = $otag->getTags('indicator', $sdi_id, false);
$link_tag = array('rub' => $GLOBALS['links'][U_L][ActiveItemKey($GLOBALS['activeitem'])]['linkvalue'], 'filter' => 'tag');
$link_self= array('rub'=> $GLOBALS['links'][U_L]['dashboard']['linkvalue'],'id' => $sdi_id, 'parentid' => $_REQUEST['parentid']);
$data_sdi = $GLOBALS['sql_object'] -> DBSelect(SQL_getOnesdiname($sdi_id, array('P')));
if($data_sdi == 0) error_redirect();
$data_scale = $GLOBALS['sql_object'] -> DBSelect(SQL_getonescale($scale_id));
$sdi_name = formatText($data_sdi[0]['sdii_name'], '2HTML');
$sdi_description = formatText($data_sdi[0]['sdii_description'], '2HTML');
$scale_name = formatText(cutText($data_scale[0]['scale_denomination'], 150), '2HTML');
$content = '' . PHP_EOL;
$content .= '
' . mb_ucfirst($sdi_name) . '
' . PHP_EOL;
$content .='
'.PHP_EOL;
$content .= formatted_permalink($link_self);
$content .='
'.PHP_EOL;
$content .= '
' . $sdi_description . '
' . PHP_EOL;
$content .= '
';
$content .= _t('divers', 'scale').' :
' . $scale_name . '' . 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 .= '
';
$content .= '
' . PHP_EOL;
$content .= GetAllValue($sdi_id, $scale_id);
$content .= GetOneSdiInfo($sdi_id);
$content .= '
' . PHP_EOL;
return $content;
}
}
/**
* GetOneSdiInfo()
* récupération des infos générales d'un indicateur
* @param $sdi_id
* @return
**/
if(!function_exists('GetOneSdiInfo')) {
function GetOneSdiInfo($sdi_id)
{
$data = $GLOBALS['sql_object'] -> DBSelect(SQL_getInfoSdi($sdi_id));
$sdi_name = formatText($data[0]['sdii_name'], '2HTML');
$sdi_description = formatText($data[0]['sdii_description'], '2HTML');
$sdi_comment = formatText($data[0]['sdii_comment'], '2HTML');
$sdi_goal = formatText($data[0]['sdii_goal'], '2HTML');
$sdi_consulting = formatText($data[0]['sdii_consulting'], '2HTML');
$content ='';
if(!empty($sdi_goal) || !empty($sdi_consulting)) {
$content .= '' . PHP_EOL;
$content .= '
'.mb_ucfirst(_t('dashboard','det_sdi2')).'
' . PHP_EOL;
$content .= '
'.mb_ucfirst(_t('sdi','goal_public')).'
' . PHP_EOL;
$content .= '
' . $sdi_goal . '
' . PHP_EOL;
$content .= '
'.mb_ucfirst(_t('sdi','consulting_public')).'
' . PHP_EOL;
$content .= '
' . $sdi_consulting . '
' . PHP_EOL;
$content .= '
' . PHP_EOL;
$content .= '
'.mb_ucfirst(_t('sdi','r_body')).'
' . PHP_EOL;
if ($result_r[0]['sdir_title'] == "") {
$content .= "
"._t('divers','nodata')."
" . PHP_EOL;
} else {
$content .= "
" . $r_title . "
" . PHP_EOL;
$content .= "
" . $r_body . "
" . PHP_EOL;
if(isset($url)) {
$content .= "
" . $url . "
" . PHP_EOL;
}
}
$content .= '
' . PHP_EOL;
$content .= '
'.mb_ucfirst(_t('sdi','e_title')).'
' . PHP_EOL;
$content .= '
' . PHP_EOL;
$content .= '' . PHP_EOL;
$content .= '' . PHP_EOL;
$content .= "| "._t('sdi','e_scale_compare')." | " . PHP_EOL;
$content .= ""._t('sdi','e_fiability')." | " . PHP_EOL;
$content .= ""._t('sdi','e_accessibility')." | " . PHP_EOL;
$content .= ""._t('sdi','e_lisibility')." | " . PHP_EOL;
$content .= ""._t('sdi','e_relevance')." | " . PHP_EOL;
$content .= ""._t('sdi','e_global_performance')." | " . PHP_EOL;
$content .= "
" . PHP_EOL;
$content .= "" . PHP_EOL;
$content .= "" . PHP_EOL;
$content .= "" . PHP_EOL;
$content .= "| " . $result_e[0]['sdie_scale_compare'] . " | " . PHP_EOL;
$content .= "" . $result_e[0]['sdie_fiability'] . " | " . PHP_EOL;
$content .= "" . $result_e[0]['sdie_accessibility'] . " | " . PHP_EOL;
$content .= "" . $result_e[0]['sdie_lisibility'] . " | " . PHP_EOL;
$content .= "" . $result_e[0]['sdie_relevance'] . " | " . PHP_EOL;
$content .= "" . $result_e[0]['sdie_global_performance'] . " | " . PHP_EOL;
$content .= "
" . PHP_EOL;
$content .= "" . PHP_EOL;
$content .= "
" . PHP_EOL;
$content .= '
' . PHP_EOL;
$content .= '
'.mb_ucfirst(_t('sdi','p_title')).'
' . PHP_EOL;
if ($result_p[0]['sdip_name'] == "") {
$content .= "
"._t('divers','nodata')."
" . PHP_EOL;
} else {
$content .= '
' . $p_name . '
' . PHP_EOL;
$content .= '
' . $p_description . '
' . PHP_EOL;
}
$content .= '
';
$str .= '
'.$msg.''.PHP_EOL;
$str .= '
';
$comment .= '