isSuperAdmin() && defined('API_RETRIEVE') && API_RETRIEVE == 1) { ?>
";?>
hasRight('sdi')) {
echo "
";?>
false) { ?>
= $minChartValues) {?>
safeTruncate(50)->slugify(). '.png';
$js_dlChart = "
$( 'div.chart-container')
.on( 'mouseenter', function() {
$('.download-chart').fadeIn(100);
})
.on( 'mouseleave', function() {
$('.download-chart').fadeOut( 500 );
});";
footerAddInlineJS($js_dlChart);
?>
".mb_ucfirst(_t('dashboard','date'))."\n";
echo "".mb_ucfirst(_t('divers','by'))." \n";
echo "".mb_ucfirst(_t('dashboard','multivalue_value'))." (".formatText($result_sdii[0]['sdii_unit'], '2HTML').")"." \n";
if($result_sdii[0]['sdii_value_type'] == 'multiple') echo "".mb_ucfirst(_t('dashboard','multivalue_distribution'))." \n";
if($result_sdii[0]['sdii_value_type'] == 'unique' && $result_sdii[0]['sdii_unique_mode'] == 'cumulative') echo "".mb_ucfirst(_t('dashboard','cumulative_value'))." \n";
echo "".mb_ucfirst(_t('dashboard','threshold_value'))." \n";
echo "".mb_ucfirst(_t('dashboard','rate'))." \n";
echo "".mb_ucfirst(_t('dashboard','comment'))." \n";
echo " \n";
?>
';
if (!empty($val['label'])) $current_val .= '' . formatText($val['label'], '2HTML') . ' : ';
if(!is_null($val['value'])) {
$current_val .= '' . fnumber_format($val['value'], 'auto', false) . ' ';
if ($indicator_multiple_type == 'sum') $current_val .= ' (' . fnumber_format($val['_percentage'], 2, false) . ' %) ';
} else {
$current_val .= '' . _t('dashboard', 'no_data') . ' ';
}
$current_val .= '';
$raw_multivalue .= formatText($val['label'], '2HTML') . ' : ' . $val['value'] . '';
if(!is_null($data[0]['_total'])) {
$current_val .= mb_ucfirst(_t('dashboard', 'multivalue_total')) . ' : ' . fnumber_format($data[0]['_total'], 'auto', false) . ' ';
$current_val .= '
';
$current_val_raw = $data[0]['_total'];
}
// we display the total if $indicator_multiple_type == 'mean'
if($indicator_multiple_type == 'mean') {
$current_val .= '';
if(!is_null($data[0]['_mean'])) {
$current_val .= mb_ucfirst(_t('dashboard', 'multivalue_mean')) . ' : ' . fnumber_format($data[0]['_mean'], 2, false) . ' ';
} else {
$current_val .= mb_ucfirst(_t('dashboard', 'multivalue_mean')) . ' : ' . _t('dashboard', 'no_data') . '';
}
$current_val .= '
';
$current_val_raw = $data[0]['_mean'];
}
// we display the total if $indicator_multiple_type == 'none'
if($indicator_multiple_type == 'none') {
$current_val .= '';
$current_val_raw = _t('sdi', 'multiple_type_none');
}
if($indicator_multiple_type != 'none') {
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($indicator_multiple_type == 'mean') $rate_field = '_mean'; else $rate_field = '_total';
if(isset($result_value[$i+1]['sdiv_multivalue']) && $indicator_multiple_type != 'none') {
$dataPlusOne = unserialize($result_value[$i+1]['sdiv_multivalue']);
if($dataPlusOne[0][$rate_field] != 0) {
$evol = ($data[0][$rate_field] - $dataPlusOne[0][$rate_field]) / $dataPlusOne[0][$rate_field] * 100;
// _debug('rate : '. fnumber_format($evol, 2). ' % - details : ('.$data[0][$rate_field]. ' - ' . $dataPlusOne[0][$rate_field]. ') / '. $dataPlusOne[0][$rate_field]);
$evol = fnumber_format($evol, 2). ' %';
} else {
$evol = empty_nc('');
}
} else {
$evol = empty_nc('');
}
// indicator is NOT multivalues
} else {
// If indicator is boolean or qualitative
if($result_sdii[0]['sdii_nature'] == 'boolean' || $result_sdii[0]['sdii_nature'] == 'qualitative') {
$a = getBooleanValues($result_sdii[0]);
if($a) {
$index = array();
foreach ($a as $key => $value) {
array_push($index, $key);
}
if(is_null($result_value[$i]['sdiv_value'])) {
$current_val .= _t('dashboard', 'no_data');
$current_val_raw = $result_value[$i]['sdiv_value'];
} else {
$current_val .= $a[$result_value[$i]['sdiv_value']];
$current_val_raw = $result_value[$i]['sdiv_value'];
}
$maskminvalue = $a[min($index)];
$maskmaxvalue = $a[max($index)];
if(is_null($result_value[$i]['sdiv_threshold'])) $threshold = empty_none('');
else $threshold = $a[$result_value[$i]['sdiv_threshold']];
} else {
if(is_null($result_value[$i]['sdiv_value'])) {
$current_val .= mb_ucfirst(_t('dashboard', 'no_data'));
$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 {
if(is_null($result_value[$i]['sdiv_value'])) {
$current_val .= mb_ucfirst(_t('dashboard', 'no_data'));
$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']) && $result_value[$i+1]['sdiv_value'] != 0) {
if(!is_null($result_value[$i+1]['sdiv_value']) && !is_null($result_value[$i]['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('');
} else {
$evol = empty_nc('');
}
}
}
$threshold_raw = $default_threshold;
// default threshold values
if($result_sdii[0]['sdii_nature'] == 'quantitative') {
$threshold = empty_none(fnumber_format($default_threshold, 'auto', false));
} else {
if(is_null($default_threshold)) {
$threshold = empty_none('');
} else {
$threshold = $a[$default_threshold];
}
}
// if set, we get it from the table
if(!is_null($result_value[$i]['sdiv_threshold'])) {
if($result_sdii[0]['sdii_nature'] == 'boolean' || $result_sdii[0]['sdii_nature'] == 'qualitative') {
$threshold = $a[$result_value[$i]['sdiv_threshold']];
$threshold_raw = $result_value[$i]['sdiv_threshold'];
} else {
$threshold = fnumber_format($result_value[$i]['sdiv_threshold'], 'auto', false);
$threshold_raw = $result_value[$i]['sdiv_threshold'];
}
} else {
$threshold = empty_none('');
$threshold_raw = '';
}
($result_value[$i]['sdiv_comment_display'] == 'Y') ? $comment_status = _t('dashboard', 'public') : $comment_status = _t('dashboard', 'private');
$history = getIndicatorValueContributors($result_value[$i], $sql_object);
if(!empty($history)) $history = sprintf('
', _t('dashboard', 'history_edition'), $history);
if(!empty($result_value[$i]['sdiv_comment'])) {
$comment = '';
}
echo "\n";
echo "". formatText($result_value[$i]['date_p'], '2HTML'). $history." \n";
echo "". $result_value[$i]['user_login'] ." \n";
echo "". formatText($current_val, '2HTML');
if($result_sdii[0]['sdii_value_type'] == 'unique' && $result_sdii[0]['sdii_unique_mode'] == 'cumulative') echo " ". formatText(fnumber_format($result_value[$i]['sdiv_cumulative_value'], 'auto', false), '2HTML');
if(!empty($result_value[$i]['sdiv_analysis'])) {
$analysis = '';
echo $analysis;
}
if($result_sdii[0]['sdii_value_type'] == 'multiple') echo " ".$raw_multivalue." \n";
if ($result_value[$i]['sdiv_statut']=='D') {
echo "".mb_ucfirst(_t('statut','draft'))." ";
}
echo "\n";
echo "". $threshold." \n";
echo "". $evol." \n";
echo "". $comment." \n";
echo " \n";
}
// 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);
?>
safeTruncate(50)->slugify();
$str = '$("#export-values li a").click(function() {
var format = $(this).attr("data-format");
var ignoreCol = []; // set columns to ignore
// we clone element and we ignore unwanted column
$el = $("#indicator-values").clone().attr("id", "indicator-values-clone"); // we create a clone
$el.find( ".no-export" ).remove(); // we remove unwanted elements inside $el
ignoreCol.push(7);
$el.insertAfter("#export-values"); // if not displayed, the export does not work
// if is multi-values table we dynamically change the content
if( $("#indicator-values").hasClass("multi-values") && format != "png") {
$el.find( "td.value" ).each(function( index ) {
// we replace all values by "data-value" attribute content
$( this ).text( $(this).attr("data-value") );
});
$el.insertAfter("#export-values"); // if not displayed, the export does not work
}
if(format == "png") $("html, body").scrollTop(0);
$el.tableExport(
{tableName:"'.mb_ucfirst($result_sdii[0]['sdii_name'] . ' - ' .$result_sdii[0]['sdii_unit'] . ' / '. $resultscale2[0]['scale_denomination']). '",type:format,escape:\'false\',ignoreColumn: ignoreCol,displayTableName:\'true\',htmlContent:\'false\',fileName:\'' . $slug_name . '\'});
return false;
});';
footerAddInlineJS($str);
?>
"._t('dashboard','novalue').": ".formatText($resultscale2[0]['scale_denomination'], '2HTML')."
";
?>
:
isSuperAdmin() && $result_sdii[0]['sdii_level'] != 0)
echo "".$disp_level_name." ";
else echo $disp_level_name;
?>
:
:
:
".mb_ucfirst(_t('sdi','min_value'))." (".formatText($result_sdii[0]['sdii_unit'], '2HTML').")"."\n";
echo "".mb_ucfirst(_t('sdi','max_value'))." (".formatText($result_sdii[0]['sdii_unit'], '2HTML').")"." \n";
echo "".mb_ucfirst(_t('sdi','initial_threshold_value'))." (".formatText($result_sdii[0]['sdii_unit'], '2HTML').")"." \n";
echo "".mb_ucfirst(_t('sdi','frequency'))." \n";
?>
\n";
echo "". $display_min." \n";
echo "". $display_max." \n";
echo "". $display_threshold ." \n";
echo "". formatText(fnumber_format($result_sdii[0]['sdii_frequency'], 'auto', false), '2HTML')." \n";
echo "\n";
?>
isUrl()) $display_api_url = sprintf('
%s ', $display_api_url, $display_api_url);
$display_api_datefield = formatText(empty_nc($result_sdii[0]['sdii_api_datefield']), '2HTML');
$display_api_valuefield = formatText(empty_nc($result_sdii[0]['sdii_api_valuefield']), '2HTML');
if($result_sdii[0]['sdii_value_type'] == 'multiple') {
$form_api_multimapping = unserialize($result_sdii[0]['sdii_api_multimapping']);
$form_api_multimapping_field = '';
if(is_array($form_api_multimapping)) {
foreach ($form_api_multimapping as $k => $v) {
$form_api_multimapping_field .= '
';
$form_api_multimapping_field .= ''.mb_ucfirst($k). ' ⬌ '. $v. ' ';
$form_api_multimapping_field .= '
';
}
}
$display_api_valuefield = $form_api_multimapping_field;
}
?>
'._t('sdi', 'api-globally-disabled').'';
?>
:
:
:
:
:
:
:
".mb_ucfirst(_t('sdi','e_scale_compare'))."\n";
echo "".mb_ucfirst(_t('sdi','e_fiability'))." \n";
echo "".mb_ucfirst(_t('sdi','e_accessibility'))." \n";
echo "".mb_ucfirst(_t('sdi','e_lisibility'))." \n";
echo "".mb_ucfirst(_t('sdi','e_relevance'))." \n";
echo "".mb_ucfirst(_t('sdi','e_global_performance'))." \n";
?>
\n";
echo "". empty_nc($result_e[0]['sdie_scale_compare'])." \n";
echo "". empty_nc($result_e[0]['sdie_fiability'])." \n";
echo "". empty_nc($result_e[0]['sdie_accessibility'])." \n";
echo "". empty_nc($result_e[0]['sdie_lisibility'])." \n";
echo "". empty_nc($result_e[0]['sdie_relevance'])." \n";
echo "". empty_nc($result_e[0]['sdie_global_performance'])." \n";
echo "\n";
?>
"._t('divers','nodata')."";
}else {?> ".formatText(empty_nc($result_r[0]['sdir_mask_uri']), '2HTML')."";
}
?>
:
"; ?>