format('Y')); $db = DBConnection::getInstance(); $s = "select * from staticValue WHERE type='info' and YEAR(`date`)='".$year."'"; $r = $db->query($s, array()); $info = array( "nbCon"=> array( "total" => 0, "authService" => array( "VCS" => 0, "google" => 0, "facebook" => 0, "github" => 0, "instagram" => 0, "stackoverflow" => 0, "linkedin" => 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" ) { $tmp = json_decode($a->value); $info["nbCon"]["authService"][$tmp->authService] ++; $info["nbCon"]["total"] ++; $info["byMonth"][$month]['dataCon']['raw'][] = $a; $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 "

Year : ".$year."

"; echo '

'; for( $i=2010; $i <= $nowDate->format('Y'); $i++ ) { echo ''.$i.''; if( $i != $nowDate->format('Y') ) echo ' - '; } //2010 - 2011 - 2012 echo '

'; 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']['total']."
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']."

(Nb connexion per auth Service : Google => ".$info["nbCon"]["authService"]["google"]."; Facebook => ".$info["nbCon"]["authService"]["facebook"]."; Github => ".$info["nbCon"]["authService"]["github"]."; Instagram => ".$info["nbCon"]["authService"]["instagram"]."; Stackoverflow => ".$info["nbCon"]["authService"]["stackoverflow"]."; Linkedin => ".$info["nbCon"]["authService"]["linkedin"]."; VCS => ".$info["nbCon"]["authService"]["VCS"]."; )
"; 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 : ".utf8_decode($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]."

"; } ?>