DBSelect(SQL_getListtheme());
$result_sdi = $GLOBALS['sql_object'] -> DBSelect(SQL_getListSdi("P", $valueparam = 0));
$listing = "";
$a='';
$current_sdtheme = '';
for ($i = 0;$i < count($result);$i++) {
if ($result[$i]['sdtheme_id'] != $current_sdtheme && $current_sdtheme <> '') {
$listing .= "" . END_LINE;
$listing .= "" . END_LINE;
}
if ($result[$i]['sdtheme_id'] != $current_sdtheme) {
$a++;
$current_sdtheme = $result[$i]['sdtheme_id'];
$listing .= "" . formatText($result[$i]['sdtheme_name'], '2HTML') . "
".END_LINE;
$listing .= '' . END_LINE;
$listing .= '' . END_LINE;
$listing .= '' . END_LINE;
$listing .= '| '.$GLOBALS['lang']['dashboard']['graphic_value'].' | ' . END_LINE;
//$listing .= ''.$GLOBALS['lang']['dashboard']['numeric_value'].' | ' . END_LINE;
$listing .= ''.$GLOBALS['lang']['dashboard']['tendencies_value'].' | ' . END_LINE;
$listing .= ''.$GLOBALS['lang']['dashboard']['label_value'].' | ' . END_LINE;
$listing .= '
' . END_LINE;
$listing .= '' . END_LINE;
$listing .= '' . END_LINE;
}
for ($j = 0;$j < count($result_sdi);$j++) {
if ($result[$i]['theme_id'] == $result_sdi[$j]['sdii_theme']) {
$link_det_sdi= array('rub'=> $GLOBALS['links']['tableau-de-bord-idd']['linkvalue'],'id'=>$result_sdi[$j]['sdii_id'], 'parentid'=> $id_filter );
$listing .= "" . END_LINE;
$aff_bare = aff_barre($id_filter, $filter, $result_sdi[$j]['sdii_id'], $result_sdi[$j]['sdii_max_value'], $result_sdi[$j]['sdii_min_value'], $result_sdi[$j]['sdii_threshold_value'], $result_sdi[$j]['sdii_unit'], $result_sdi[$j]['sdii_threshold_relative'], $link_det_sdi);
$listing .= $aff_bare;
$listing .= "| " . formatText(cutText($result_sdi[$j]['sdii_name'], 53), '2HTML') . " | " . END_LINE;
$listing .= "
" . END_LINE;
}
}
}
$listing .= "" . END_LINE;
$listing .= "
" . END_LINE;
echo $listing;
}
/**
* value_barre()
* traitement de la valeur d'un IDD pour valeur du curseur en CSS
* @param $value
* @param $max_value
* @param $min_value
* @param $threshold_value
* @param $threshold_relative
* @return
**/
function value_barre ($value, $max_value, $min_value, $threshold_value, $threshold_relative)
{
if ($max_value == 0) $max_value = 0.000001;
if ($min_value == 0) $min_value = 0.000001;
if ($threshold_relative == 'Y') {
$unitup = 50 / ($max_value - $threshold_value);
$unitdown = 50 / ($threshold_value - $min_value);
if ($value > $threshold_value) $result = 50 + (($value - $threshold_value) * $unitup);
else $result = 50 - (($threshold_value - $value) * $unitdown);
} else {
$unitdown = 50 / ($max_value - $threshold_value);
$unitup = 50 / ($threshold_value - $min_value);
if ($value > $threshold_value) $result = 50 - (($value - $threshold_value) * $unitdown);
else $result = 50 + (($threshold_value - $value) * $unitup);
}
return (int)$result;
}
/**
* aff_barre()
* affichage du curseur et compteur pour un IDD
* @param integer $scale_id
* @param $filter
* @param $id
* @param $max_value
* @param $min_value
* @param $threshold_value
* @param $unit
* @param $threshold_relative
* @param $link_det_sdi
* @return
**/
function aff_barre($scale_id = 1, $filter, $id, $max_value, $min_value, $threshold_value, $unit, $threshold_relative, $link_det_sdi)
{
$result_value = $GLOBALS['sql_object'] -> DBSelect(SQL_getAllValue("SCD", $scale_id, $id));
if ($result_value <> false) {
$value_cursor1 = value_barre ($result_value[0]['sdiv_value'], $max_value, $min_value, $threshold_value, $threshold_relative);
$value_cursor = 116 - $value_cursor1;
} else $value_cursor1 = "";
if ($result_value == false) {
$listing = "![\"".$GLOBALS['lang']['dashboard']['novalue']."\"](\"../gfx/default/images/admin/barre_gris.gif\" "\\"\".$GLOBALS['lang']['dashboard']['novalue'].\"\\"") | " . END_LINE;
$listing .= " | " . END_LINE;
//$listing .= " | " . END_LINE;
} else {
$listing = "![\"".$GLOBALS['lang']['dashboard']['value'].":](\"../gfx/default/images/admin/barre.gif\") ".$GLOBALS['lang']['dashboard']['value'].": ".$result_value[0]['sdiv_value']." ".$unit.
"
".$GLOBALS['lang']['sdi']['min_value'].": ".$min_value." ".$unit.
"
".$GLOBALS['lang']['sdi']['threshold_value'].": ".$threshold_value." ".$unit.
"
".$GLOBALS['lang']['sdi']['max_value'].": ".$max_value." ".$unit.
"" . END_LINE;
$listing .= "![\"".$GLOBALS['lang']['dashboard']['barre']."\"/](\"../gfx/default/images/admin/cursor.gif\" "\\"\"") | " . END_LINE;
if (isset($result_value[1]['sdiv_value'])) {
if ($result_value[0]['sdiv_value'] >= $result_value[1]['sdiv_value']) $listing .= "![\"".$GLOBALS['lang']['dashboard']['value_tendance'].'](\"../gfx/default/images/admin/ico_asc.gif\") | " . END_LINE;
else $listing .= "![\"".$GLOBALS['lang']['dashboard']['value_tendance'].'](\"../gfx/default/images/admin/ico_desc.gif\") | " . END_LINE;
} else $listing .= " | " . END_LINE;
//$listing .= " (" . (int)$result_value[0]['sdiv_value'] . ") | " . END_LINE;
}
return $listing;
}
/**
* DisplayOneSdi()
* affichage d'un indicateur et infos résumé
* @param $sdi_id
* @param $scale_id
* @return
**/
function DisplayOneSdi($sdi_id, $scale_id)
{
echo GetSdiTitle($sdi_id, $scale_id);
echo DisplaySwitchAffichagedet($sdi_id,$scale_id);
echo GetAllValue($sdi_id, $scale_id);
echo GetOneSdiInfo($sdi_id);
}
/**
* DisplayOneSdirules()
* affichage d'un indicateur et toutes ses infos
* @param $sdi_id
* @param $scale_id
* @return
**/
function DisplayOneSdirules($sdi_id, $scale_id)
{
echo GetSdiTitle($sdi_id, $scale_id);
echo DisplaySwitchAffichagedet($sdi_id,$scale_id);
echo GetOneSdiRules($sdi_id);
}
/**
* DisplayOneSdievaluation()
* affichage d'un indicateur et toutes ses infos
* @param $sdi_id
* @param $scale_id
* @return
**/
function DisplayOneSdievaluation($sdi_id, $scale_id)
{
echo GetSdiTitle($sdi_id, $scale_id);
echo DisplaySwitchAffichagedet($sdi_id,$scale_id);
echo GetOneSdiEvaluation($sdi_id);
}
/**
* DisplayOneSdiprovider()
* affichage d'un indicateur et toutes ses infos
* @param $sdi_id
* @param $scale_id
* @return
**/
function DisplayOneSdiprovider($sdi_id, $scale_id)
{
echo GetSdiTitle($sdi_id, $scale_id);
echo DisplaySwitchAffichagedet($sdi_id,$scale_id);
echo GetOneSdiProvider($sdi_id);
}
/**
* GetAllValue()
* afficahge de l'ensemble des valeurs publiques d'un IDD
* @param $sdi_id
* @param $scale_id
* @return
**/
function GetAllValue($sdi_id, $scale_id)
{
$result_value = $GLOBALS['sql_object'] -> DBSelect(SQL_getAllValue("SCD", $scale_id, $sdi_id));
$result_sdi_value = $GLOBALS['sql_object'] -> DBSelect(SQL_getInfoSdiforvalue($sdi_id));
$content = '' . END_LINE;
$content .= '
'.$GLOBALS['lang']['dashboard']['historic'].'
' . END_LINE;
$content .= '
'.$GLOBALS['lang']['sdi']['threshold_value'].' : '.$result_sdi_value[0]['sdii_threshold_value'].' '.$result_sdi_value[0]['sdii_unit'].'
' . END_LINE;
if ($result_value <> false) {
if (count($result_value) > 2) {
$content .= '
'.$GLOBALS['lang']['dashboard']['rep_graph'].'
' . END_LINE;
$content .= "
![\"".$GLOBALS['lang']['dashboard']['rep_graph']."\"/](\"../dashboard/graph.php?id=")
" . END_LINE;
}
//$content .= '
'.$GLOBALS['lang']['dashboard']['value'].' ('.$GLOBALS['lang']['sdi']['threshold_value'].' : '.$result_sdi_value[0]['sdii_threshold_value'].' '.$result_sdi_value[0]['sdii_unit'].')
' . END_LINE;
$content .= '
'.$GLOBALS['lang']['dashboard']['value'].'
' . END_LINE;
$content .= '
' . END_LINE;
$content .= '' . END_LINE;
$content .= '' . END_LINE;
$content .= "| ".$GLOBALS['lang']['dashboard']['date']." | " . END_LINE;
$content .= "".$GLOBALS['lang']['dashboard']['value']." (".$result_sdi_value[0]['sdii_unit'].") | " . END_LINE;
$content .= "
" . END_LINE;
$content .= "" . END_LINE;
$content .= "" . END_LINE;
for ($i = 0;$i < count($result_value);$i++) {
$content .= "" . END_LINE;
$content .= "| " . formatText($result_value[$i]['date_p'], '2HTML') . " | " . END_LINE;
$content .= "" . formatText($result_value[$i]['sdiv_value'], '2HTML') . " | " . END_LINE;
$content .= "
" . END_LINE;
}
$content .= "" . END_LINE;
$content .= "
" . END_LINE;
$content .= '
' . $sdi_name . '
' . END_LINE;
$content .= '' . $sdi_description . '
' . END_LINE;
$content .= ' échelle : ' . $scale_name . '
' . END_LINE;
return $content;
}
/**
* GetOneSdiInfo()
* récupération des infos générales d'un indicateur
* @param $sdi_id
* @return
**/
function GetOneSdiInfo($sdi_id)
{
$data = $GLOBALS['sql_object'] -> DBSelect(SQL_getInfoSdi($sdi_id));
$sdi_name = formatText($data[0]['sdii_name'], '2HTML');
$sdi_theme = formatText(cutText($data[0]['theme_name'], 150), '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 = '' . END_LINE;
// $content.='
'.$sdi_name.'
'.END_LINE;
$content .= '
'.$GLOBALS['lang']['dashboard']['det_sdi2'].'
' . END_LINE;
//$content .= '
'.$GLOBALS['lang']['divers']['sousthemeref'].'
' . END_LINE;
//$content .= '
' . $sdi_theme . '
' . END_LINE;
//$content .= '
'.$GLOBALS['lang']['sdi']['description'].'
' . END_LINE;
//$content .= '
' . $sdi_description . '
' . END_LINE;
//$content .= '
'.$GLOBALS['lang']['sdi']['comment'].'
' . END_LINE;
//$content .= '
' . $sdi_comment . '
' . END_LINE;
$content .= '
'.$GLOBALS['lang']['sdi']['goal_public'].'
' . END_LINE;
$content .= '
' . $sdi_goal . '
' . END_LINE;
$content .= '
'.$GLOBALS['lang']['sdi']['consulting_public'].'
' . END_LINE;
$content .= '
' . $sdi_consulting . '
' . END_LINE;
$content .= '
' . END_LINE;
return $content;
}
/**
* GetOneSdiRules()
* récupération des réglementations d'un indicateur
* @param $sdi_id
* @return
**/
function GetOneSdiRules($sdi_id)
{
$result_r = $GLOBALS['sql_object'] -> DBSelect(SQL_getRules($sdi_id, $GLOBALS['sql_object'], -1));
$r_title = formatText($result_r[0]['sdir_title'], '2HTML');
$r_body = formatText($result_r[0]['sdir_body'], '2HTML');
$URL = "" . formatText($result_r[0]['sdir_mask_uri'], '2HTML') . "";
$content = '' . END_LINE;
$content .= '
'.$GLOBALS['lang']['sdi']['r_body'].'
' . END_LINE;
if ($result_r[0]['sdir_title'] == "") {
$content .= "
".$GLOBALS['lang']['divers']['nodata']."
" . END_LINE;
} else {
$content .= "
" . $r_title . "
" . END_LINE;
$content .= "
" . $r_body . "
" . END_LINE;
$content .= "
" . $URL . "
" . END_LINE;
}
$content .= '
' . END_LINE;
$content .= '
'.$GLOBALS['lang']['sdi']['e_title'].'
' . END_LINE;
$content .= '
' . END_LINE;
$content .= '' . END_LINE;
$content .= '' . END_LINE;
$content .= "| ".$GLOBALS['lang']['sdi']['e_scale_compare']." | " . END_LINE;
$content .= "".$GLOBALS['lang']['sdi']['e_fiability']." | " . END_LINE;
$content .= "".$GLOBALS['lang']['sdi']['e_accessibility']." | " . END_LINE;
$content .= "".$GLOBALS['lang']['sdi']['e_lisibility']." | " . END_LINE;
$content .= "".$GLOBALS['lang']['sdi']['e_relevance']." | " . END_LINE;
$content .= "".$GLOBALS['lang']['sdi']['e_global_performance']." | " . END_LINE;
$content .= "
" . END_LINE;
$content .= "" . END_LINE;
$content .= "" . END_LINE;
$content .= "" . END_LINE;
$content .= "| " . $result_e[0]['sdie_scale_compare'] . " | " . END_LINE;
$content .= "" . $result_e[0]['sdie_fiability'] . " | " . END_LINE;
$content .= "" . $result_e[0]['sdie_accessibility'] . " | " . END_LINE;
$content .= "" . $result_e[0]['sdie_lisibility'] . " | " . END_LINE;
$content .= "" . $result_e[0]['sdie_relevance'] . " | " . END_LINE;
$content .= "" . $result_e[0]['sdie_global_performance'] . " | " . END_LINE;
$content .= "
" . END_LINE;
$content .= "" . END_LINE;
$content .= "
" . END_LINE;
$content .= '
' . END_LINE;
$content .= '
'.$GLOBALS['lang']['sdi']['p_title'].'
' . END_LINE;
if ($result_p[0]['sdip_name'] == "") {
$content .= "
".$GLOBALS['lang']['divers']['nodata']."
" . END_LINE;
} else {
$content .= '
' . $p_name . '
' . END_LINE;
$content .= '
' . $p_description . '
' . END_LINE;
$content .= '
' . END_LINE;
$content .= '
'.$GLOBALS['lang']['dashboard']['mode_aff'].' : ';
if ($GLOBALS['links'][$GLOBALS['activeitem']]['linkvalue'] == $GLOBALS['links']['tableau-de-bord-idd']['linkvalue'])
$content .= '
'.$GLOBALS['lang']['dashboard']['mode_aff_class'].' ' . END_LINE;
else $content .= '
'.$GLOBALS['lang']['dashboard']['mode_aff_class'].' ' . END_LINE;
if ($GLOBALS['links'][$GLOBALS['activeitem']]['linkvalue'] == $GLOBALS['links']['tableau-de-bord-idd-anim']['linkvalue'])
$content .= '
'.$GLOBALS['lang']['dashboard']['mode_aff_young'].' ' . END_LINE;
else $content .= '
'.$GLOBALS['lang']['dashboard']['mode_aff_young'].' ' . END_LINE;
$content .= '
". END_LINE;
$content .="
". END_LINE;
$content .="
' . END_LINE;
if ($GLOBALS['links'][$GLOBALS['activeitem']]['linkvalue'] == $GLOBALS['links']['tableau-de-bord-idd']['linkvalue'])
$content .= '
'.$GLOBALS['lang']['dashboard']['mode_aff_res'].' ' . END_LINE;
else $content .= '
'.$GLOBALS['lang']['dashboard']['mode_aff_res'].' ' . END_LINE;
if ($GLOBALS['links'][$GLOBALS['activeitem']]['linkvalue'] == $GLOBALS['links']['tableau-de-bord-idd-detail']['linkvalue'])
$content .= '
'.$GLOBALS['lang']['dashboard']['mode_aff_det'].' ' . END_LINE;
else $content .= '
'.$GLOBALS['lang']['dashboard']['mode_aff_det'].' ' . END_LINE;
$content .= '