* @version $Id$
* @access public
* @license http://opensource.org/licenses/gpl-3.0.html
*/
if(!function_exists('getPositionfromValue')) {
function getPositionfromValue ($value, $indicator, $threshold_value){
if ($indicator['sdii_max_value']==0) {
$max_value=0.000001;
} else {
$max_value=$indicator['sdii_max_value'];
}
if ($indicator['sdii_min_value']==0) {
$min_value=0.000001;
} else {
$min_value=$indicator['sdii_min_value'];
}
if ($indicator['sdii_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{
if(($max_value - $threshold_value) <> 0) $unitdown = 50 / ($max_value - $threshold_value);
if(($threshold_value - $min_value) <> 0) $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;
}
}
if(!function_exists('getIndicatorInfoBox')) {
function getIndicatorInfoBox($current_value, $indicator, $threshold_value, $class= '') {
$content = "".ucfirst(_t('dashboard','value'))." : ".fnumber_format($current_value, 'auto', false)." (".formatText($indicator['sdii_unit']).")
".
"
".ucfirst(_t('sdi','min_value'))." : ".empty_nc($indicator['sdii_min_value'])."
".
"
".ucfirst(_t('sdi','max_value'))." : ".empty_nc($indicator['sdii_max_value'])."
".
"
".ucfirst(_t('sdi','threshold_value'))." : ".empty_nc($threshold_value)."
".
"
![\"".ucfirst(_t('dashboard','value'))."](\"")
";
$listing .= getIndicatorInfoBox($current_value, $indicator, $threshold_value, $class);
$listing .= "
";
$listing .= getTendency($result_value);
$listing .= "\t
(".strtolower($current_value).")\n";
$listing .= "\t
\n";
return $listing;
}
}
if(!function_exists('getRawViz')) {
function getRawViz($sql_object, $scale_id, $indicator, $threshold_value) {
$req_sdiav=SQL_getAllValue("SCA", $scale_id, $indicator['sdii_id']);
$result_value = $sql_object -> DBSelect($req_sdiav);
$str = '';
// there is no value
if ($result_value==false) {
$str .= '-';
$current_value = _t('dashboard','novalue');
$class="indicator-no-data";
// some values are there
} else {
// we handle multivalues
if(!empty($result_value[0]['sdiv_multivalue'])) {
$data = unserialize($result_value[0]['sdiv_multivalue']);
$str .= ''.fnumber_format($data[0]['_total'], 'auto', false).'';
$current_value = $data[0]['_total'];
// we handle simple values
} else {
$a = getBooleanValues($indicator);
if($result_value[0]['sdiv_value'] == 0) $class= " boolean-false";
else $class= " boolean-true";
if($a && $indicator['sdii_type'] == 'boolean') {
$current_value = $a[$result_value[0]['sdiv_value']];
$classbmask = ' boolean-mask';
} else {
$classbmask = '';
$current_value = fnumber_format($result_value[0]['sdiv_value'], 'auto', false);
}
$str .= ''.$current_value.'';
}
$class="";
}
$str .= getIndicatorInfoBox($current_value, $indicator, $threshold_value, $class);
$str .= ''.formatText($indicator['sdii_unit']).'';
$str .= '
';
$str .= getTendency($result_value);
return $str;
}
}
if(!function_exists('getSparklineViz')) {
function getSparklineViz($sql_object, $scale_id, $indicator, $threshold_value) {
// getting all values
$req_sdiav=SQL_getAllValue("SCA", $scale_id, $indicator['sdii_id']);
$result_value = $sql_object -> DBSelect($req_sdiav);
$str = '';
// there is no value
if ($result_value==false) {
$str .= '
-';
// some values are there
} else {
$data = array();
// we reverse the array to display eldest first
$values = array_reverse($result_value);
foreach($values as $value) {
// we handle multivalues
if(!empty($value['sdiv_multivalue'])) {
$dataindic = unserialize($value['sdiv_multivalue']);
array_push($data, $dataindic[0]['_total']);
// we handle simple values
} else {
array_push($data, $value['sdiv_value']);
}
}
$str .= '
'.join(',',$data).'
';
}
$str .= '
';
// we handle multivalues
// if there is a previous value
if(!empty($values[1]['sdiv_multivalue'])) {
$data = unserialize($values[0]['sdiv_multivalue']);
$dataPlusOne = unserialize($values[1]['sdiv_multivalue']);
$percentage = ($data[0]['_total'] - $dataPlusOne[0]['_total']) / $dataPlusOne[0]['_total'] * 100;
$evolution = ' ('.round($percentage, 0). '%)';
if ($data[0]['_total'] >= $dataPlusOne[0]['_total']) {
$tendency.="
";
} else {
$tendency.="
";
}
// we handle simple values
// if there is a previous value
} elseif(isset($values[1]['sdiv_value'])) {
$percentage = ($values[0]['sdiv_value'] - $values[1]['sdiv_value']) / $values[1]['sdiv_value'] * 100;
$evolution = ' ('.round($percentage, 0). '%)';
if ($values[0]['sdiv_value'] >= $values[1]['sdiv_value']) {
$tendency.="
";
} else {
$tendency.="
";
}
}
$tendency .= '