tools/kpi.inc - gerrit/www.eclipse.org/projects - Git at Google

 <?php
 /**
  * *****************************************************************************
  * Copyright (c) 2016,2017 Eclipse Foundation and others.
  * All rights reserved. This program and the accompanying materials
  * are made available under the terms of the Eclipse Public License v1.0
  * which accompanies this distribution, and is available at
  * http://www.eclipse.org/legal/epl-v10.html
  * *****************************************************************************
  */
 require_once dirname ( __FILE__ ) . '/charts.inc';
 require_once dirname ( __FILE__ ) . '/../classes/database.inc';

 // function renderMonthlyTop10Chart() {
 // 	global $App;

 // 	$period = date ( 'Ym', strtotime ( '-1 month' ) );

 // 	$sql = "
 // 		select project, count
 // 		from SubprojectCommitActivity
 // 		where period='$period'
 // 		order by count desc
 // 		limit 10;";

 // 	$rows = array ();
 // 	query ( 'dashboard', $sql, array (), function ($row) use (&$rows) {
 // 		$id = $row ['project'];
 // 		$project = get_project_from_pmi ( $id );
 // 		$name = $project ? $project->getName () : $id;

 // 		$count = $row ['count'];

 // 		$rows [] = array (
 // 				$name,
 // 				$count
 // 		);
 // 	} );

 // 	$period = asYearMonth ( $period );
 // 	echo "<p>The determination of &quot;Top 10&quot; is based on commits made
 // 		against the project in $period.</p>";

 // 	$columns = array (
 // 			array (
 // 					'label' => 'Project',
 // 					'type' => 'string'
 // 			),
 // 			array (
 // 					'label' => 'Commits',
 // 					'type' => 'number'
 // 			)
 // 	);
 // 	drawPieChart ( 'Top10Monthly', "Top Ten Projects by Contributor Count ($period)", $columns, $rows );
 // }

 function renderIPTeamVelocityChart($age = 5) {
  global $App;

  $start = date ( 'Y-m-01', strtotime ( "- $age years" ) );
  $end = date ( 'Y-m-t', strtotime ( "- 1 month" ) );

  $sql = "
    select
     date_format(ba.bug_when, '%Y-%m') as period,
     count(distinct c.id) as projects,
     count(distinct date(ba.bug_when)) as days,
     count(distinct ba.bug_id) as bugs
    from bugs_activity as ba
     join bugs as b on ba.bug_id=b.bug_id
     join components as c on b.component_id=c.id
    where
     added='RESOLVED'
     and ba.bug_when between date('$start') and date('$end')
     and b.short_desc not regexp '\((PB( Orbit)?)\s*\d*\)'
     and b.short_desc not regexp '\(ATO\s*\d*\)'
     and b.cf_type not in ('Type_A')
     and c.name not in ('IP_Discussion')
    group by date_format(ba.bug_when, '%Y-%m')
    ";

  $rows = array ();
  query ( 'ipzilla', $sql, array (), function ($row) use (&$rows) {
   $period = $row ['period'];
   $projects = $row ['projects'];
   $days = $row ['days'];
   $bugs = $row ['bugs'];

   $period = asYearMonth ( $period );

   $rows [] = array (
     $period,
     $bugs / $days
   );
  } );

   $start = asYearMonth ( $start );
   $end = asYearMonth ( $end );
   echo "<p>Based on CQ state between $start and $end.</p>";
   $columns = array (
     array (
       'label' => 'Month',
       'type' => 'string'
     ),
     array (
       'label' => 'CQs Resolved/Day',
       'type' => 'number'
     )
   );
   $options = array (
     'curveType' => 'function',
     'vAxis' => array (
       'viewWindowMode' => 'explicit',
       'viewWindow' => array (
         'min' => 0
       )
     )
   );
   drawLineChart ( 'IPTeamVelocity', "Average IP Team Velocity Between $start and $end", $columns, $rows, $options );
 }

 function renderByProjectIPChart() {
 	global $App;

 	$now = date ( 'Y-m' );
 	$last = date ( 'Y-m', strtotime ( "-1 months" ) );

 	$sql = "
         SELECT
             CMP.name as project,
             count(BUG.bug_id) as count
         FROM (SELECT DISTINCT date_format(creation_ts, \"%Y-%m\") AS Month FROM bugs) AS DAT
             INNER JOIN bugs as BUG ON date_format(BUG.creation_ts, \"%Y-%m\") <= Month
             INNER JOIN products AS PRD ON PRD.id = BUG.product_id
             INNER JOIN components AS CMP ON CMP.id = BUG.component_id
             LEFT JOIN bugs_activity AS ACT on ACT.bug_id = BUG.bug_id
                 AND ACT.added = \"RESOLVED\"
         WHERE BUG.resolution != \"INVALID\"
             AND PRD.name != \"IP\"
             AND BUG.keywords not like '%historical%'
             AND CMP.name != \"tools.orbit\"
             AND (ACT.bug_when IS NULL OR date_format(ACT.bug_when,\"%Y-%m\")  > Month)
             AND DAT.Month >= \"$last\"
             AND DAT.Month < \"$now\"
         GROUP BY CMP.name
         ORDER BY count desc
         LIMIT 15";

 	$rows = array ();
 	query ( 'ipzilla', $sql, array (), function ($row) use (&$rows) {
 		$project = Project::getProject ( $row ['project'] );
 		$rows [] = array (
 				$project == null ? $row ['project'] : $project->getNickName (),
 				$row ['count']
 		);
 	} );

 	$date = date ( 'M Y' );

 	$columns = array (
 			array (
 					'label' => 'Project',
 					'type' => 'string'
 			),
 			array (
 					'label' => 'CQs',
 					'type' => 'number'
 			)
 	);
 	drawPieChart ( 'ProjectCQs', "CQ Breakdown by Project (Top 15) $date", $columns, $rows );
 }

 /*
  * select date, name as project, count(bug_id) from (select
  * date_format(ba.bug_when, "%Y-%m") as date, b.bug_id, p.name, b.short_desc
  * from bugs_activity as ba join bugs as b on ba.bug_id=b.bug_id join products
  * as p on b.product_id=p.id where ba.added='RESOLVED' and p.name not in ('IP'))
  * as cqs group by date, project;
  */
 function renderQuarterlyTop10Chart() {
 	global $App;

 	list ( $quarter, $start, $end ) = getLastQuarter ( time () );

 	$sql = "
 		select project, count
 		from SubprojectCommitActivity
 		where period between $start and $end
 		group by project
 		order by count desc";

 	$rows = array ();
 	query ( 'dashboard', $sql, array (), function ($row) use (&$rows) {
 		$project = Project::getProject ( $row ['project'] );

 		$count = $row ['count'];

 		$rows [] = array (
 				$project ? $project->getNickName () : $row['project'],
 				$count
 		);
 	} );

 	echo "<p>Based on commits between $start and $end.</p>";

 	$columns = array (
 			array (
 					'label' => 'Project',
 					'type' => 'string'
 			),
 			array (
 					'label' => 'CQs',
 					'type' => 'number'
 			)
 	);
 	drawPieChart ( 'Top10Quarterly', "Top Ten Projects by Contribution Count ($quarter)", $columns, $rows );
 }
 function renderQuarterlyTop10ContributorsChart() {
 	global $App;

 	list ( $quarter, $start, $end ) = getLastQuarter ( time () );

 	$sql = "
 		select
 			project, Authors-Committers as count
 		from ProjectQuarterlySummary
 		where quarter='$quarter'
 			and Authors-Committers >= (
 				select Authors-Committers as count
 				from ProjectQuarterlySummary
 				where quarter='$quarter'
 				order by count desc limit 10, 1)
 		order by count desc";

 	$rows = array ();
 	query ( 'dashboard', $sql, array (), function ($row) use (&$rows) {
 		$project = Project::getProject ( $row ['project'] );

 		$count = $row ['count'];

 		$rows [] = array (
 				$project ? $project->getNickName () : $row['project'],
 				$count
 		);
 	} );

 	echo "<p>Based on commits between $start and $end.</p>";

 	$columns = array (
 			array (
 					'label' => 'Project',
 					'type' => 'string'
 			),
 			array (
 					'label' => 'Commits',
 					'type' => 'number'
 			)
 	);
 	drawPieChart ( 'Top10ContributorsQuarterly', "Top \"Ten\" Projects by Contributor Count ($quarter)", $columns, $rows );
 }
 function renderFileTypesChart() {
 	global $App;

 	list ( $quarter, $start, $end ) = getLastQuarter ( time () );

 	$sql = "select extension, count from FileTypes order by count desc limit 15";

 	$rows = array ();
 	query ( 'dashboard', $sql, array (), function ($row) use (&$rows) {
 		$id = $row ['extension'];
 		$name = getExtensionName ( $id );

 		$count = $row ['count'];

 		$rows [] = array (
 				$name,
 				$count
 		);
 	} );

 	$columns = array (
 			array (
 					'label' => 'File Type',
 					'type' => 'string'
 			),
 			array (
 					'label' => 'Number of projects',
 					'type' => 'number'
 			)
 	);
 	drawPieChart ( 'fileTypesChart', "File types by project use", $columns, $rows );
 }
 function renderLicensesInUseChart() {
  global $App;

  $now = date ( 'Y-m' );

  $sql = "
   SELECT
    license, count(project) as count
   from (
    SELECT
     p.ProjectId as project,
     group_concat(
      if(LicenseId='EPL1.0','EPL-1.0',
       if(LicenseId='EPL2.0','EPL-2.0',
        if(LicenseId='EDL1.0','EDL-1.0',
         if(LicenseId='ASL2.0','Apache-2.0',
          if(LicenseId='CCBY3','CC-BY-3.0',
           LicenseId)))))
      ORDER BY LicenseId separator ' OR ') as license
    FROM ProjectLicenses as pl
     JOIN Projects as p on pl.ProjectId=p.ProjectId
      AND p.IsActive group by p.ProjectId
   ) as ProjectsAndLicenses
   group by license
   order by count desc";

  $rows = array ();
  query ( 'foundation', $sql, array (), function ($row) use (&$rows) {
   $rows [] = array (
     $row ['license'],
     $row ['count']
   );
  } );

   $columns = array (
     array (
       'label' => 'License',
       'type' => 'string'
     ),
     array (
       'label' => 'Count',
       'type' => 'number'
     )
   );
   drawPieChart ( 'LicenseUse', "Licenses in use by Eclipse Projects on $now", $columns, $rows );
 }
 ?>
	<?php
	/**
	* *****************************************************************************
	* Copyright (c) 2016,2017 Eclipse Foundation and others.
	* All rights reserved. This program and the accompanying materials
	* are made available under the terms of the Eclipse Public License v1.0
	* which accompanies this distribution, and is available at
	* http://www.eclipse.org/legal/epl-v10.html
	* *****************************************************************************
	*/
	require_once dirname ( __FILE__ ) . '/charts.inc';
	require_once dirname ( __FILE__ ) . '/../classes/database.inc';

	// function renderMonthlyTop10Chart() {
	// global $App;

	// $period = date ( 'Ym', strtotime ( '-1 month' ) );

	// $sql = "
	// select project, count
	// from SubprojectCommitActivity
	// where period='$period'
	// order by count desc
	// limit 10;";

	// $rows = array ();
	// query ( 'dashboard', $sql, array (), function ($row) use (&$rows) {
	// $id = $row ['project'];
	// $project = get_project_from_pmi ( $id );
	// $name = $project ? $project->getName () : $id;

	// $count = $row ['count'];

	// $rows [] = array (
	// $name,
	// $count
	// );
	// } );

	// $period = asYearMonth ( $period );
	// echo "<p>The determination of "Top 10" is based on commits made
	// against the project in $period.</p>";

	// $columns = array (
	// array (
	// 'label' => 'Project',
	// 'type' => 'string'
	// ),
	// array (
	// 'label' => 'Commits',
	// 'type' => 'number'
	// )
	// );
	// drawPieChart ( 'Top10Monthly', "Top Ten Projects by Contributor Count ($period)", $columns, $rows );
	// }

	function renderIPTeamVelocityChart($age = 5) {
	global $App;

	$start = date ( 'Y-m-01', strtotime ( "- $age years" ) );
	$end = date ( 'Y-m-t', strtotime ( "- 1 month" ) );

	$sql = "
	select
	date_format(ba.bug_when, '%Y-%m') as period,
	count(distinct c.id) as projects,
	count(distinct date(ba.bug_when)) as days,
	count(distinct ba.bug_id) as bugs
	from bugs_activity as ba
	join bugs as b on ba.bug_id=b.bug_id
	join components as c on b.component_id=c.id
	where
	added='RESOLVED'
	and ba.bug_when between date('$start') and date('$end')
	and b.short_desc not regexp '\((PB( Orbit)?)\s\d\)'
	and b.short_desc not regexp '\(ATO\s\d\)'
	and b.cf_type not in ('Type_A')
	and c.name not in ('IP_Discussion')
	group by date_format(ba.bug_when, '%Y-%m')
	";

	$rows = array ();
	query ( 'ipzilla', $sql, array (), function ($row) use (&$rows) {
	$period = $row ['period'];
	$projects = $row ['projects'];
	$days = $row ['days'];
	$bugs = $row ['bugs'];

	$period = asYearMonth ( $period );

	$rows [] = array (
	$period,
	$bugs / $days
	);
	} );

	$start = asYearMonth ( $start );
	$end = asYearMonth ( $end );
	echo "<p>Based on CQ state between $start and $end.</p>";
	$columns = array (
	array (
	'label' => 'Month',
	'type' => 'string'
	),
	array (
	'label' => 'CQs Resolved/Day',
	'type' => 'number'
	)
	);
	$options = array (
	'curveType' => 'function',
	'vAxis' => array (
	'viewWindowMode' => 'explicit',
	'viewWindow' => array (
	'min' => 0
	)
	)
	);
	drawLineChart ( 'IPTeamVelocity', "Average IP Team Velocity Between $start and $end", $columns, $rows, $options );
	}

	function renderByProjectIPChart() {
	global $App;

	$now = date ( 'Y-m' );
	$last = date ( 'Y-m', strtotime ( "-1 months" ) );

	$sql = "
	SELECT
	CMP.name as project,
	count(BUG.bug_id) as count
	FROM (SELECT DISTINCT date_format(creation_ts, \"%Y-%m\") AS Month FROM bugs) AS DAT
	INNER JOIN bugs as BUG ON date_format(BUG.creation_ts, \"%Y-%m\") <= Month
	INNER JOIN products AS PRD ON PRD.id = BUG.product_id
	INNER JOIN components AS CMP ON CMP.id = BUG.component_id
	LEFT JOIN bugs_activity AS ACT on ACT.bug_id = BUG.bug_id
	AND ACT.added = \"RESOLVED\"
	WHERE BUG.resolution != \"INVALID\"
	AND PRD.name != \"IP\"
	AND BUG.keywords not like '%historical%'
	AND CMP.name != \"tools.orbit\"
	AND (ACT.bug_when IS NULL OR date_format(ACT.bug_when,\"%Y-%m\") > Month)
	AND DAT.Month >= \"$last\"
	AND DAT.Month < \"$now\"
	GROUP BY CMP.name
	ORDER BY count desc
	LIMIT 15";

	$rows = array ();
	query ( 'ipzilla', $sql, array (), function ($row) use (&$rows) {
	$project = Project::getProject ( $row ['project'] );
	$rows [] = array (
	$project == null ? $row ['project'] : $project->getNickName (),
	$row ['count']
	);
	} );

	$date = date ( 'M Y' );

	$columns = array (
	array (
	'label' => 'Project',
	'type' => 'string'
	),
	array (
	'label' => 'CQs',
	'type' => 'number'
	)
	);
	drawPieChart ( 'ProjectCQs', "CQ Breakdown by Project (Top 15) $date", $columns, $rows );
	}

	/*
	* select date, name as project, count(bug_id) from (select
	* date_format(ba.bug_when, "%Y-%m") as date, b.bug_id, p.name, b.short_desc
	* from bugs_activity as ba join bugs as b on ba.bug_id=b.bug_id join products
	* as p on b.product_id=p.id where ba.added='RESOLVED' and p.name not in ('IP'))
	* as cqs group by date, project;
	*/
	function renderQuarterlyTop10Chart() {
	global $App;

	list ( $quarter, $start, $end ) = getLastQuarter ( time () );

	$sql = "
	select project, count
	from SubprojectCommitActivity
	where period between $start and $end
	group by project
	order by count desc";

	$rows = array ();
	query ( 'dashboard', $sql, array (), function ($row) use (&$rows) {
	$project = Project::getProject ( $row ['project'] );

	$count = $row ['count'];

	$rows [] = array (
	$project ? $project->getNickName () : $row['project'],
	$count
	);
	} );

	echo "<p>Based on commits between $start and $end.</p>";

	$columns = array (
	array (
	'label' => 'Project',
	'type' => 'string'
	),
	array (
	'label' => 'CQs',
	'type' => 'number'
	)
	);
	drawPieChart ( 'Top10Quarterly', "Top Ten Projects by Contribution Count ($quarter)", $columns, $rows );
	}
	function renderQuarterlyTop10ContributorsChart() {
	global $App;

	list ( $quarter, $start, $end ) = getLastQuarter ( time () );

	$sql = "
	select
	project, Authors-Committers as count
	from ProjectQuarterlySummary
	where quarter='$quarter'
	and Authors-Committers >= (
	select Authors-Committers as count
	from ProjectQuarterlySummary
	where quarter='$quarter'
	order by count desc limit 10, 1)
	order by count desc";

	$rows = array ();
	query ( 'dashboard', $sql, array (), function ($row) use (&$rows) {
	$project = Project::getProject ( $row ['project'] );

	$count = $row ['count'];

	$rows [] = array (
	$project ? $project->getNickName () : $row['project'],
	$count
	);
	} );

	echo "<p>Based on commits between $start and $end.</p>";

	$columns = array (
	array (
	'label' => 'Project',
	'type' => 'string'
	),
	array (
	'label' => 'Commits',
	'type' => 'number'
	)
	);
	drawPieChart ( 'Top10ContributorsQuarterly', "Top \"Ten\" Projects by Contributor Count ($quarter)", $columns, $rows );
	}
	function renderFileTypesChart() {
	global $App;

	list ( $quarter, $start, $end ) = getLastQuarter ( time () );

	$sql = "select extension, count from FileTypes order by count desc limit 15";

	$rows = array ();
	query ( 'dashboard', $sql, array (), function ($row) use (&$rows) {
	$id = $row ['extension'];
	$name = getExtensionName ( $id );

	$count = $row ['count'];

	$rows [] = array (
	$name,
	$count
	);
	} );

	$columns = array (
	array (
	'label' => 'File Type',
	'type' => 'string'
	),
	array (
	'label' => 'Number of projects',
	'type' => 'number'
	)
	);
	drawPieChart ( 'fileTypesChart', "File types by project use", $columns, $rows );
	}
	function renderLicensesInUseChart() {
	global $App;

	$now = date ( 'Y-m' );

	$sql = "
	SELECT
	license, count(project) as count
	from (
	SELECT
	p.ProjectId as project,
	group_concat(
	if(LicenseId='EPL1.0','EPL-1.0',
	if(LicenseId='EPL2.0','EPL-2.0',
	if(LicenseId='EDL1.0','EDL-1.0',
	if(LicenseId='ASL2.0','Apache-2.0',
	if(LicenseId='CCBY3','CC-BY-3.0',
	LicenseId)))))
	ORDER BY LicenseId separator ' OR ') as license
	FROM ProjectLicenses as pl
	JOIN Projects as p on pl.ProjectId=p.ProjectId
	AND p.IsActive group by p.ProjectId
	) as ProjectsAndLicenses
	group by license
	order by count desc";

	$rows = array ();
	query ( 'foundation', $sql, array (), function ($row) use (&$rows) {
	$rows [] = array (
	$row ['license'],
	$row ['count']
	);
	} );

	$columns = array (
	array (
	'label' => 'License',
	'type' => 'string'
	),
	array (
	'label' => 'Count',
	'type' => 'number'
	)
	);
	drawPieChart ( 'LicenseUse', "Licenses in use by Eclipse Projects on $now", $columns, $rows );
	}
	?>