[WTF CVS] wtf/lib/WTF SQL.pm,1.8,1.9

[Gryphon S. <gry...@us...>]

Update of /cvsroot/wtf-tracker/wtf/lib/WTF
In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv24976/lib/WTF

Modified Files:
	SQL.pm 
Log Message:
Additional data exposure in the Activity Summary screen

Index: SQL.pm
===================================================================
RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/SQL.pm,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** SQL.pm	2 Dec 2006 00:09:09 -0000	1.8
--- SQL.pm	3 Dec 2006 23:03:42 -0000	1.9
***************
*** 337,340 ****
--- 337,355 ----
  	},
  
+ 	'activity_summary_totals' => q{
+ 		SELECT
+ 			COUNT( DISTINCT s.employee_id ) AS total_emp,
+ 			COUNT( DISTINCT s.id ) AS total_emp_days,
+ 			SUM(asm.percentage) AS total_avg
+ 		FROM summary AS s
+ 		INNER JOIN activity_summary AS asm ON s.id = asm.summary_id
+ 		WHERE s.work_day BETWEEN ? AND ? + INTERVAL 1 MONTH
+ 	},
+ 
+ 	'activity_summary_vacation_sick' => q{
+ 		SELECT SUM(vacation) AS vacation, SUM(sick) AS sick
+ 		FROM summary WHERE work_day BETWEEN ? AND ? + INTERVAL 1 MONTH
+ 	},
+ 
  	'table_data_team' => 'SELECT id, team_id AS parent_id, name, ordering FROM team ORDER BY ordering',
  	'table_data_area' => 'SELECT id, name, description, active, ordering FROM area ORDER BY ordering',