<?php
/**
 * Gentoo stats
 * Written by Meir Kriheli <mksoft@gentoo.org>
 * Based on gentoo-stats by Maik Schreiber <blizzy@gentoo.org>
 *
 * $Id: cpus.php,v 1.2 2003/05/09 10:01:08 mksoft Exp $
 *
 * vim: set tabstop=4 shiftwidth=4:
 */

require_once('stats.inc.php');

$total_cpus = getTotalCPUs();

if ($total_cpus) {
	$sql = "SELECT count(cv.cv_id) as cv_count, cv.cv_name  " .
		"FROM t_cpu_vendors cv, t_users2cpus uc, t_users u " .
		"WHERE (cv.cv_id = uc.cv_id) AND (u.u_id = uc.u_id) " .
		"AND (u_last_update IS NOT NULL) " .
		"AND (TO_DAYS(NOW()) - TO_DAYS(u_last_update) <= $active_days) " .
		"GROUP BY cv.cv_id " .
		"ORDER BY cv.cv_name ";
	
	$cpu_vendors = $db->getAll($sql,DB_FETCHMODE_ASSOC);
	if (!DB::isError($cpu_vendors)) {
		for ($i=0;$i<count($cpu_vendors);$i++) {
			$count = $cpu_vendors[$i]['cv_count'];
			$cpu_vendors[$i]['cv_name'] = htmlspecialchars($cpu_vendors[$i]['cv_name']);
			$cpu_vendors[$i]['cv_count'] = number_format($count);
			$cpu_vendors[$i]['cv_percent'] = number_format($count * 100 / $total_cpus,2);
			$cpu_vendors[$i]['bar_width'] = (int)($count * $bar_width/$total_cpus);
			$cpu_vendors[$i]['bar_empty_width'] = $bar_width - $cpu_vendors[$i]['bar_width'];
		}
		$smarty->assign('cpu_vendors',$cpu_vendors); 
	}

	$sql = "SELECT count(cm.cm_id) as cm_count, cm.cm_name  " .
		"FROM t_cpu_modelnames cm, t_users2cpus uc, t_users u " .
		"WHERE (cm.cm_id = uc.cv_id) AND (u.u_id = uc.u_id) " .
		"AND (u_last_update IS NOT NULL) " .
		"AND (TO_DAYS(NOW()) - TO_DAYS(u_last_update) <= $active_days) " .
		"GROUP BY cm.cm_id " .
		"ORDER BY cm.cm_name ";
	$cpu_models = $db->getAll($sql,DB_FETCHMODE_ASSOC);

	if (!DB::isError($cpu_models)) {
		for ($i=0;$i<count($cpu_vendors);$i++) {
			$count = $cpu_models[$i]['cm_count'];
			$cpu_models[$i]['cm_name'] = htmlspecialchars($cpu_models[$i]['cm_name']);
			$cpu_models[$i]['cm_count'] = number_format($count);
			$cpu_models[$i]['cm_percent'] = number_format($count * 100 / $total_cpus,3);
			$cpu_models[$i]['bar_width'] = (int)($count * $bar_width/$total_cpus);
			$cpu_models[$i]['bar_empty_width'] = $bar_width - $cpu_models[$i]['bar_width'];
		}
		$smarty->assign('cpu_models',$cpu_models); 
	}
}

$smarty->assign('page_title','CPUs');
$smarty->assign('total_cpus',number_format($total_cpus));
$smarty->display('cpus.tpl');
?>