query($s, array()); $info = array( "nbCon"=> 0, "byMonth"=>Array() ); $availableLang = Array(); $availableUser = Array(); while( $a = $r->fetch_object()) { $month = date("m", strtotime($a->date)); $year = date("Y", strtotime($a->date)); // pour les connexions if( $a->field == "login" ) { $info["nbCon"] ++; $info["byMonth"][$month]['dataCon']['raw'][] = $a; //( !isset($info["byMonth"][$month]['nbCon']) ) ? $info["byMonth"][$month]['nbCon']=0 : ''; $info["byMonth"][$month]['nbCon'] ++; $i = json_decode($a->value); $info["byMonth"][$month]['dataCon']['perLang'][$i->lang] ++; $info["byMonth"][$month]['dataCon']['perUser'][$i->user] ++; $availableLang[$i->lang] = 1; $availableUser[$i->user] = 1; } // pour les commit if( $a->field == "commitFiles" ) { $i = json_decode($a->value); $info["byMonth"][$month]['dataCommit']['raw'][] = $i; $info['nbFilesCreate'] += $i->nbFilesCreate; $info['nbFilesDelete'] += $i->nbFilesDelete; $info['nbFilesUpdate'] += $i->nbFilesUpdate; $info["byMonth"][$month]['dataCommit']['nbFilesCreate']['total'] += $i->nbFilesCreate; $info["byMonth"][$month]['dataCommit']['nbFilesDelete']['total'] += $i->nbFilesDelete; $info["byMonth"][$month]['dataCommit']['nbFilesUpdate']['total'] += $i->nbFilesUpdate; $info["byMonth"][$month]['dataCommit']['nbFilesCreate']['perLang'][$i->lang] += $i->nbFilesCreate; $info["byMonth"][$month]['dataCommit']['nbFilesDelete']['perLang'][$i->lang] += $i->nbFilesDelete; $info["byMonth"][$month]['dataCommit']['nbFilesUpdate']['perLang'][$i->lang] += $i->nbFilesUpdate; $info["byMonth"][$month]['dataCommit']['nbFilesCreate']['perUser'][$i->user] += $i->nbFilesCreate; $info["byMonth"][$month]['dataCommit']['nbFilesDelete']['perUser'][$i->user] += $i->nbFilesDelete; $info["byMonth"][$month]['dataCommit']['nbFilesUpdate']['perUser'][$i->user] += $i->nbFilesUpdate; $availableLang[$i->lang] = 1; $availableUser[$i->user] = 1; } } echo '

2010 - 2011

'; echo "

All language

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

	Janvier	Fevrier	Mars	Avril	Mai	Juin	Juillet	Aout	Septembre	Octobre	Novembre	Decembre	=>Total
Nb connexion	".$info['byMonth']['01']['nbCon']."	".$info['byMonth']['02']['nbCon']."	".$info['byMonth']['03']['nbCon']."	".$info['byMonth']['04']['nbCon']."	".$info['byMonth']['05']['nbCon']."	".$info['byMonth']['06']['nbCon']."	".$info['byMonth']['07']['nbCon']."	".$info['byMonth']['08']['nbCon']."	".$info['byMonth']['09']['nbCon']."	".$info['byMonth']['10']['nbCon']."	".$info['byMonth']['11']['nbCon']."	".$info['byMonth']['12']['nbCon']."	".$info['nbCon']."
Nb CreateFile	".$info['byMonth']['01']['dataCommit']['nbFilesCreate']['total']."	".$info['byMonth']['02']['dataCommit']['nbFilesCreate']['total']."	".$info['byMonth']['03']['dataCommit']['nbFilesCreate']['total']."	".$info['byMonth']['04']['dataCommit']['nbFilesCreate']['total']."	".$info['byMonth']['05']['dataCommit']['nbFilesCreate']['total']."	".$info['byMonth']['06']['dataCommit']['nbFilesCreate']['total']."	".$info['byMonth']['07']['dataCommit']['nbFilesCreate']['total']."	".$info['byMonth']['08']['dataCommit']['nbFilesCreate']['total']."	".$info['byMonth']['09']['dataCommit']['nbFilesCreate']['total']."	".$info['byMonth']['10']['dataCommit']['nbFilesCreate']['total']."	".$info['byMonth']['11']['dataCommit']['nbFilesCreate']['total']."	".$info['byMonth']['12']['dataCommit']['nbFilesCreate']['total']."	".$info['nbFilesCreate']."
Nb nbFilesDelete	".$info['byMonth']['01']['dataCommit']['nbFilesDelete']['total']."	".$info['byMonth']['02']['dataCommit']['nbFilesDelete']['total']."	".$info['byMonth']['03']['dataCommit']['nbFilesDelete']['total']."	".$info['byMonth']['04']['dataCommit']['nbFilesDelete']['total']."	".$info['byMonth']['05']['dataCommit']['nbFilesDelete']['total']."	".$info['byMonth']['06']['dataCommit']['nbFilesDelete']['total']."	".$info['byMonth']['07']['dataCommit']['nbFilesDelete']['total']."	".$info['byMonth']['08']['dataCommit']['nbFilesDelete']['total']."	".$info['byMonth']['09']['dataCommit']['nbFilesDelete']['total']."	".$info['byMonth']['10']['dataCommit']['nbFilesDelete']['total']."	".$info['byMonth']['11']['dataCommit']['nbFilesDelete']['total']."	".$info['byMonth']['12']['dataCommit']['nbFilesDelete']['total']."	".$info['nbFilesDelete']."
Nb nbFilesUpdate	".$info['byMonth']['01']['dataCommit']['nbFilesUpdate']['total']."	".$info['byMonth']['02']['dataCommit']['nbFilesUpdate']['total']."	".$info['byMonth']['03']['dataCommit']['nbFilesUpdate']['total']."	".$info['byMonth']['04']['dataCommit']['nbFilesUpdate']['total']."	".$info['byMonth']['05']['dataCommit']['nbFilesUpdate']['total']."	".$info['byMonth']['06']['dataCommit']['nbFilesUpdate']['total']."	".$info['byMonth']['07']['dataCommit']['nbFilesUpdate']['total']."	".$info['byMonth']['08']['dataCommit']['nbFilesUpdate']['total']."	".$info['byMonth']['09']['dataCommit']['nbFilesUpdate']['total']."	".$info['byMonth']['10']['dataCommit']['nbFilesUpdate']['total']."	".$info['byMonth']['11']['dataCommit']['nbFilesUpdate']['total']."	".$info['byMonth']['12']['dataCommit']['nbFilesUpdate']['total']."	".$info['nbFilesUpdate']."

"; while( list($lang, $v) = each($availableLang)) { // Skip anonymous if( trim($lang) == '') continue; echo "

Language : ".$lang." top

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

	Janvier	Fevrier	Mars	Avril	Mai	Juin	Juillet	Aout	Septembre	Octobre	Novembre	Decembre
Nb connexion	".$info['byMonth']['01']['dataCon']['perLang'][$lang]."	".$info['byMonth']['02']['dataCon']['perLang'][$lang]."	".$info['byMonth']['03']['dataCon']['perLang'][$lang]."	".$info['byMonth']['04']['dataCon']['perLang'][$lang]."	".$info['byMonth']['05']['dataCon']['perLang'][$lang]."	".$info['byMonth']['06']['dataCon']['perLang'][$lang]."	".$info['byMonth']['07']['dataCon']['perLang'][$lang]."	".$info['byMonth']['08']['dataCon']['perLang'][$lang]."	".$info['byMonth']['09']['dataCon']['perLang'][$lang]."	".$info['byMonth']['10']['dataCon']['perLang'][$lang]."	".$info['byMonth']['11']['dataCon']['perLang'][$lang]."	".$info['byMonth']['12']['dataCon']['perLang'][$lang]."
Nb CreateFile	".$info['byMonth']['01']['dataCommit']['nbFilesCreate']['perLang'][$lang]."	".$info['byMonth']['02']['dataCommit']['nbFilesCreate']['perLang'][$lang]."	".$info['byMonth']['03']['dataCommit']['nbFilesCreate']['perLang'][$lang]."	".$info['byMonth']['04']['dataCommit']['nbFilesCreate']['perLang'][$lang]."	".$info['byMonth']['05']['dataCommit']['nbFilesCreate']['perLang'][$lang]."	".$info['byMonth']['06']['dataCommit']['nbFilesCreate']['perLang'][$lang]."	".$info['byMonth']['07']['dataCommit']['nbFilesCreate']['perLang'][$lang]."	".$info['byMonth']['08']['dataCommit']['nbFilesCreate']['perLang'][$lang]."	".$info['byMonth']['09']['dataCommit']['nbFilesCreate']['perLang'][$lang]."	".$info['byMonth']['10']['dataCommit']['nbFilesCreate']['perLang'][$lang]."	".$info['byMonth']['11']['dataCommit']['nbFilesCreate']['perLang'][$lang]."	".$info['byMonth']['12']['dataCommit']['nbFilesCreate']['perLang'][$lang]."
Nb nbFilesDelete	".$info['byMonth']['01']['dataCommit']['nbFilesDelete']['perLang'][$lang]."	".$info['byMonth']['02']['dataCommit']['nbFilesDelete']['perLang'][$lang]."	".$info['byMonth']['03']['dataCommit']['nbFilesDelete']['perLang'][$lang]."	".$info['byMonth']['04']['dataCommit']['nbFilesDelete']['perLang'][$lang]."	".$info['byMonth']['05']['dataCommit']['nbFilesDelete']['perLang'][$lang]."	".$info['byMonth']['06']['dataCommit']['nbFilesDelete']['perLang'][$lang]."	".$info['byMonth']['07']['dataCommit']['nbFilesDelete']['perLang'][$lang]."	".$info['byMonth']['08']['dataCommit']['nbFilesDelete']['perLang'][$lang]."	".$info['byMonth']['09']['dataCommit']['nbFilesDelete']['perLang'][$lang]."	".$info['byMonth']['10']['dataCommit']['nbFilesDelete']['perLang'][$lang]."	".$info['byMonth']['11']['dataCommit']['nbFilesDelete']['perLang'][$lang]."	".$info['byMonth']['12']['dataCommit']['nbFilesDelete']['perLang'][$lang]."
Nb nbFilesUpdate	".$info['byMonth']['01']['dataCommit']['nbFilesUpdate']['perLang'][$lang]."	".$info['byMonth']['02']['dataCommit']['nbFilesUpdate']['perLang'][$lang]."	".$info['byMonth']['03']['dataCommit']['nbFilesUpdate']['perLang'][$lang]."	".$info['byMonth']['04']['dataCommit']['nbFilesUpdate']['perLang'][$lang]."	".$info['byMonth']['05']['dataCommit']['nbFilesUpdate']['perLang'][$lang]."	".$info['byMonth']['06']['dataCommit']['nbFilesUpdate']['perLang'][$lang]."	".$info['byMonth']['07']['dataCommit']['nbFilesUpdate']['perLang'][$lang]."	".$info['byMonth']['08']['dataCommit']['nbFilesUpdate']['perLang'][$lang]."	".$info['byMonth']['09']['dataCommit']['nbFilesUpdate']['perLang'][$lang]."	".$info['byMonth']['10']['dataCommit']['nbFilesUpdate']['perLang'][$lang]."	".$info['byMonth']['11']['dataCommit']['nbFilesUpdate']['perLang'][$lang]."	".$info['byMonth']['12']['dataCommit']['nbFilesUpdate']['perLang'][$lang]."

"; } while( list($user, $v) = each($availableUser)) { // Skip anonymous if( substr($user, 0, 11) == 'anonymous #') continue; echo "

User : ".$user." top

	Janvier	Fevrier	Mars	Avril	Mai	Juin	Juillet	Aout	Septembre	Octobre	Novembre	Decembre
Nb connexion	".$info['byMonth']['01']['dataCon']['perUser'][$user]."	".$info['byMonth']['02']['dataCon']['perUser'][$user]."	".$info['byMonth']['03']['dataCon']['perUser'][$user]."	".$info['byMonth']['04']['dataCon']['perUser'][$user]."	".$info['byMonth']['05']['dataCon']['perUser'][$user]."	".$info['byMonth']['06']['dataCon']['perUser'][$user]."	".$info['byMonth']['07']['dataCon']['perUser'][$user]."	".$info['byMonth']['08']['dataCon']['perUser'][$user]."	".$info['byMonth']['09']['dataCon']['perUser'][$user]."	".$info['byMonth']['10']['dataCon']['perUser'][$user]."	".$info['byMonth']['11']['dataCon']['perUser'][$user]."	".$info['byMonth']['12']['dataCon']['perUser'][$user]."
Nb CreateFile	".$info['byMonth']['01']['dataCommit']['nbFilesCreate']['perUser'][$user]."	".$info['byMonth']['02']['dataCommit']['nbFilesCreate']['perUser'][$user]."	".$info['byMonth']['03']['dataCommit']['nbFilesCreate']['perUser'][$user]."	".$info['byMonth']['04']['dataCommit']['nbFilesCreate']['perUser'][$user]."	".$info['byMonth']['05']['dataCommit']['nbFilesCreate']['perUser'][$user]."	".$info['byMonth']['06']['dataCommit']['nbFilesCreate']['perUser'][$user]."	".$info['byMonth']['07']['dataCommit']['nbFilesCreate']['perUser'][$user]."	".$info['byMonth']['08']['dataCommit']['nbFilesCreate']['perUser'][$user]."	".$info['byMonth']['09']['dataCommit']['nbFilesCreate']['perUser'][$user]."	".$info['byMonth']['10']['dataCommit']['nbFilesCreate']['perUser'][$user]."	".$info['byMonth']['11']['dataCommit']['nbFilesCreate']['perUser'][$user]."	".$info['byMonth']['12']['dataCommit']['nbFilesCreate']['perUser'][$user]."
Nb nbFilesDelete	".$info['byMonth']['01']['dataCommit']['nbFilesDelete']['perUser'][$user]."	".$info['byMonth']['02']['dataCommit']['nbFilesDelete']['perUser'][$user]."	".$info['byMonth']['03']['dataCommit']['nbFilesDelete']['perUser'][$user]."	".$info['byMonth']['04']['dataCommit']['nbFilesDelete']['perUser'][$user]."	".$info['byMonth']['05']['dataCommit']['nbFilesDelete']['perUser'][$user]."	".$info['byMonth']['06']['dataCommit']['nbFilesDelete']['perUser'][$user]."	".$info['byMonth']['07']['dataCommit']['nbFilesDelete']['perUser'][$user]."	".$info['byMonth']['08']['dataCommit']['nbFilesDelete']['perUser'][$user]."	".$info['byMonth']['09']['dataCommit']['nbFilesDelete']['perUser'][$user]."	".$info['byMonth']['10']['dataCommit']['nbFilesDelete']['perUser'][$user]."	".$info['byMonth']['11']['dataCommit']['nbFilesDelete']['perUser'][$user]."	".$info['byMonth']['12']['dataCommit']['nbFilesDelete']['perUser'][$user]."
Nb nbFilesUpdate	".$info['byMonth']['01']['dataCommit']['nbFilesUpdate']['perUser'][$user]."	".$info['byMonth']['02']['dataCommit']['nbFilesUpdate']['perUser'][$user]."	".$info['byMonth']['03']['dataCommit']['nbFilesUpdate']['perUser'][$user]."	".$info['byMonth']['04']['dataCommit']['nbFilesUpdate']['perUser'][$user]."	".$info['byMonth']['05']['dataCommit']['nbFilesUpdate']['perUser'][$user]."	".$info['byMonth']['06']['dataCommit']['nbFilesUpdate']['perUser'][$user]."	".$info['byMonth']['07']['dataCommit']['nbFilesUpdate']['perUser'][$user]."	".$info['byMonth']['08']['dataCommit']['nbFilesUpdate']['perUser'][$user]."	".$info['byMonth']['09']['dataCommit']['nbFilesUpdate']['perUser'][$user]."	".$info['byMonth']['10']['dataCommit']['nbFilesUpdate']['perUser'][$user]."	".$info['byMonth']['11']['dataCommit']['nbFilesUpdate']['perUser'][$user]."	".$info['byMonth']['12']['dataCommit']['nbFilesUpdate']['perUser'][$user]."

"; } ?>