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',
|
