| index : archweb32 | |
| Archlinux32 website | gitolite user |
| summaryrefslogtreecommitdiff |
| -rw-r--r-- | buildmaster/statistics.php | 108 |
diff --git a/buildmaster/statistics.php b/buildmaster/statistics.php index 097be80..f867973 100644 --- a/buildmaster/statistics.php +++ b/buildmaster/statistics.php @@ -1,59 +1,59 @@ <?php -require_once "../init.php"; -require_once BASE . "/lib/mysql.php"; +require_once '../init.php'; +require_once BASE . '/lib/mysql.php'; -if (array_key_exists("from", $_GET)) - $min_time="from_base64(\"" . base64_encode("-".$_GET["from"]) . "\")"; +if (array_key_exists('from', $_GET)) + $min_time = 'from_base64("' . base64_encode('-' . $_GET['from']) . '")'; else - $min_time="\"-7 00:00:00\""; + $min_time='"-7 00:00:00"'; -if (array_key_exists("arch", $_GET)) - $arch_filter = arch_filter_query("architectures"); +if (array_key_exists('arch', $_GET)) + $arch_filter = arch_filter_query('architectures'); else - $arch_filter = "1"; + $arch_filter = '1'; $column_list = array( - "pending_tasks_count", - "pending_packages_count", - "staging_packages_count", - "testing_packages_count", - "tested_packages_count", - "broken_tasks_count", - "dependency_loops_count", - "dependency_looped_tasks_count", - "locked_tasks_count", - "blocked_tasks_count", - "next_tasks_count" + 'pending_tasks_count', + 'pending_packages_count', + 'staging_packages_count', + 'testing_packages_count', + 'tested_packages_count', + 'broken_tasks_count', + 'dependency_loops_count', + 'dependency_looped_tasks_count', + 'locked_tasks_count', + 'blocked_tasks_count', + 'next_tasks_count' ); function combine_column($name) { - return "SUM(`statistics`.`" . $name . "`) AS `" . $name . "`"; + return 'SUM(`statistics`.`' . $name . '`) AS `' . $name . '`'; } $result = mysql_run_query( - "SELECT DISTINCT". - " UNIX_TIMESTAMP(`statistics`.`date`) AS `date`," . - implode(",", array_map("combine_column", $column_list)) . - " FROM `statistics`" . - " JOIN `architectures` ON `statistics`.`architecture`=`architectures`.`id`" . - " WHERE `statistics`.`date`>=ADDDATE(NOW()," . $min_time . ")" . - " AND " . $arch_filter . - " GROUP BY `statistics`.`date`" . - " ORDER BY `statistics`.`date`" + 'SELECT DISTINCT'. + ' UNIX_TIMESTAMP(`statistics`.`date`) AS `date`,' . + implode(',', array_map('combine_column', $column_list)) . + ' FROM `statistics`' . + ' JOIN `architectures` ON `statistics`.`architecture`=`architectures`.`id`' . + ' WHERE `statistics`.`date`>=ADDDATE(NOW(),' . $min_time . ')' . + ' AND ' . $arch_filter . + ' GROUP BY `statistics`.`date`' . + ' ORDER BY `statistics`.`date`' ); $t_min = -1; $t_max = -1; $val_max = -1; -while($vals = $result->fetch_assoc()) { +while($vals = $result -> fetch_assoc()) { if ($t_min == -1) - $t_min = $vals["date"]; - $t_max = $vals["date"]; + $t_min = $vals['date']; + $t_max = $vals['date']; foreach ($vals as $column => $val) - if ($column != "date") { - $values[$column][$vals["date"]] = $val; - $val_max = max($val_max,$val); + if ($column != 'date') { + $values[$column][$vals['date']] = $val; + $val_max = max($val_max, $val); } }; $print_columns = array_keys($values); @@ -72,7 +72,7 @@ $legend_line_length = 10; $legend_height = 2 * ImageFontHeight(5) + $legend_line_length; $im = @ImageCreate ($width + $legend_line_length + $max_len * ImageFontWidth(5), $height + $legend_height) - or die ("Cannot create new gd-image-stream"); + or die ('Cannot create new gd-image-stream'); $background_color = ImageColorAllocate ($im, 255, 255, 255); $foreground_color = ImageColorAllocate ($im, 0, 0, 0); @@ -115,10 +115,10 @@ function print_graph($data, $color) { if ($last_t != -1) ImageLine( $im, - scale($last_t,$t_min,$t_max,$width-2*$border,false)+$border+$legend_line_length, - scale($last_val,0,$val_max,-$height+2*$border,array_key_exists("log", $_GET))+$border, - scale($t,$t_min,$t_max,$width-2*$border,false)+$border+$legend_line_length, - scale($val,0,$val_max,-$height+2*$border,array_key_exists("log", $_GET))+$border, + scale($last_t, $t_min, $t_max, $width - 2*$border, false) + $border + $legend_line_length, + scale($last_val, 0, $val_max, -$height + 2*$border, array_key_exists('log', $_GET)) + $border, + scale($t, $t_min, $t_max, $width - 2*$border, false) + $border + $legend_line_length, + scale($val, 0, $val_max, -$height + 2*$border, array_key_exists('log', $_GET)) + $border, $color ); $last_t = $t; @@ -127,20 +127,20 @@ function print_graph($data, $color) { ImageString( $im, 5, - $width+$legend_line_length, - scale($last_val,0,$val_max,-$height+2*$border,array_key_exists("log", $_GET))+$border - ImageFontHeight(5)/2, - " ".$data[$t_max], + $width + $legend_line_length, + scale($last_val, 0, $val_max, -$height + 2*$border, array_key_exists('log', $_GET)) + $border - ImageFontHeight(5)/2, + ' ' . $data[$t_max], $color ); }; -ImageRectangle($im, $legend_line_length, 0, $width-1+$legend_line_length, $height-1, $foreground_color); +ImageRectangle($im, $legend_line_length, 0, $width-1 + $legend_line_length, $height-1, $foreground_color); $xpos = $legend_line_length; foreach ($print_columns as $column) { print_graph($values[$column], $colors[$column]); ImageString($im, 5, $xpos, $height + $legend_line_length + ImageFontHeight(5), substr($column,0,-strlen("_count")), $colors[$column]); - $xpos += (strlen($column) - strlen("_count") + 1.75) * ImageFontWidth(5); + $xpos += (strlen($column) - strlen('_count') + 1.75) * ImageFontWidth(5); } ImageString($im, 5, $legend_line_length, $height + $legend_line_length, date('Y-m-d H:i', $t_min), $foreground_color); @@ -157,27 +157,25 @@ for ($t=ceil($t_min/24/60/60); $t<=floor($t_max/24/60/60); $t++) $foreground_color ); -for ($val=0; $val<=$val_max;) { +for ($val = 0; $val <= $val_max;) { ImageLine( $im, 0, - scale($val,0,$val_max,-$height+2*$border,array_key_exists("log", $_GET))+$border, + scale($val, 0, $val_max, -$height + 2*$border, array_key_exists('log', $_GET)) + $border, $legend_line_length, - scale($val,0,$val_max,-$height+2*$border,array_key_exists("log", $_GET))+$border, + scale($val, 0, $val_max, -$height + 2*$border, array_key_exists('log', $_GET)) + $border, $foreground_color ); - if (! array_key_exists("log", $_GET)) - $val+=pow(10,round(log($val_max)/log(10))-1); - elseif ($val==0) + if (! array_key_exists('log', $_GET)) + $val+=pow(10, round(log($val_max) / log(10)) - 1); + elseif ($val == 0) $val++; else - $val=$val*10; + $val = $val*10; } // ImageString ($im, 1, 5, 5, "Test-String ".rand(), $foreground_color); -header ("Content-type: image/png"); +header ('Content-type: image/png'); ImagePNG ($im); - -?> |