if (!$enabledMetrics[$provider_name] || !array_key_exists('score_column', $provider)) {
not_found();
}
# building a query to select all beacon data in one swoop
$query = "SELECT urls.id AS url_id, urls.url as url, UNIX_TIMESTAMP(last_update) AS t,";
$query .= "\n\t" . $provider['table'] . '_last_id, UNIX_TIMESTAMP(' . $provider['table'] . '.timestamp) AS ' . $provider_name . '_timestamp';
foreach ($provider['metrics'] as $section_name => $section) {
foreach ($section as $metric) {
$query .= ",\n\t\t" . $provider['table'] . '.' . $metric[1] . ' AS ' . $provider_name . '_' . $metric[1];
}
}
$query .= "\nFROM urls";
$query .= "\n\tLEFT JOIN " . $provider['table'] . ' ON urls.' . $provider['table'] . '_last_id = ' . $provider['table'] . '.id';
$query .= "\nWHERE urls.id = " . mysql_real_escape_string($urlid);
#echo $query; exit;
$result = mysql_query($query);
if (!$result) {
error_log(mysql_error());
}
$row = mysql_fetch_assoc($result);
mysql_free_result($result);
$score = $row[$provider_name . '_' . $provider['score_column']];
if (!is_null($score)) {
$pretty_score = prettyScore($score);
if (array_key_exists('output', $_GET) && $_GET['output'] == 'color') {
$colors = array(1 => '#EE0000', 2 => '#EE2800', 3 => '#EE4F00', 4 => '#EE7700', 5 => '#EE9F00', 6 => '#EEC600', 7 => '#EEEE00', 8 => '#C6EE00', 9 => '#9FEE00', 10 => '#77EE00', 11 => '#4FEE00', 12 => '#28EE00', 13 => '#00EE00');
echo $colors[scoreColorStep($score)];
} else {
echo $score;
}
}
?>
<td class="score" title="Current dynaTrace score: <?php
echo prettyScore($row['dt_o']);
?>
(<?php
echo $row['dt_o'];
?>
)"><?php
echo prettyScore($row['dt_o']);
?>
(<?php
echo $row['dt_o'];
?>
)</td>
<td title="Current dynaTrace score: <?php
echo prettyScore($row['dt_o']);
?>
(<?php
echo $row['dt_o'];
?>
)"><div class="gbox"><div style="width: <?php
echo $row['dt_o'] + 1;
?>
px" class="bar c<?php
echo scoreColorStep($row['dt_o']);
?>
"/></div></td>
<?php
}
}
?>
}
?>
</td><?php
$value = $row[$provider_name . '_' . $metric[1]];
if (is_null($value)) {
?>
<td class="na">n/a</td>
<td><span id="details_<?php
echo $provider_name . '_' . $metric[1];
?>
" class="details"></span></td>
<td></td>
<?php
} else {
if ($metric[2] == PERCENT_GRADE) {
$pretty_score = prettyScore($value);
?>
<td class="value"><?php
echo $pretty_score;
?>
(<i><?php
echo htmlentities($value);
?>
</i>%)</td>
<td><span id="details_<?php
echo $provider_name . '_' . $metric[1];
?>
" class="details"></span></td>
<td><div class="gbox" title="Current <?php
echo $provider['score_name'];
?>
