[WTF CVS] wtf/lib/WTF SQL.pm,1.15,1.16

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

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

Modified Files:
	SQL.pm 
Log Message:
Bug fix 1640358: Copy Last Data function doesn't save correctly

Index: SQL.pm
===================================================================
RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/SQL.pm,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -d -r1.15 -r1.16
*** SQL.pm	21 Mar 2007 17:26:31 -0000	1.15
--- SQL.pm	21 Mar 2007 18:30:15 -0000	1.16
***************
*** 367,373 ****
  
  	'max_work_day' => q{
! 		SELECT IF( MAX(w.work_day) > MAX(n.work_day), MAX(w.work_day), MAX(n.work_day) ) AS last_date
! 		FROM work AS w, notes AS n
! 		WHERE w.employee_id = ? AND w.work_day < ? AND n.employee_id = ? AND n.work_day < ?
  	},
  
--- 367,380 ----
  
  	'max_work_day' => q{
! 		SELECT IF(
! 			MAX(w.work_day) > MAX(n.work_day),
! 			IF( MAX(w.work_day) > MAX(s.work_day), MAX(w.work_day), MAX(s.work_day) ),
! 			IF( MAX(n.work_day) > MAX(s.work_day), MAX(n.work_day), MAX(s.work_day) )
! 		) AS last_date
! 		FROM work AS w, notes AS n, summary AS s
! 		WHERE
! 			w.employee_id = ? AND w.work_day < ? AND
! 			n.employee_id = ? AND n.work_day < ? AND
! 			s.employee_id = ? AND s.work_day < ?
  	},