weekly report excludes last day

[Elvin Risti]

when making Custom Fields Weekly Report and selecting Report Type as 'Weekly' then date selection is example
Nov 28th - Dec 4th

now criteria will be between '2011-11-28' AND '2011-12-04'
as the sql field type is datetime then this would be like '2011-11-28 00:00' AND '2011-12-04 00:00' which means the last day (2011-12-04) is excluded.

criteria should be then '2011-11-28 00:00' AND '2011-12-04 23:59'

[Elan Ruusamäe (glen666)]

the query it makes is:

 SELECT
                    iss_id,
                    SUM(ttr_time_spent) ttr_time_spent_sum,
                    iss_summary,
                    iss_customer_id,
                    iss_private

                 FROM
                    eventum.eventum_time_tracking,
                        eventum.eventum_issue
                    WHERE
                        iss_prj_id=1 AND
                        ttr_created_date BETWEEN '2014-10-13' AND '2014-10-19' AND
                        ttr_iss_id = iss_id AND

                        ttr_iss_id = iss_id

                    GROUP BY
                    iss_id

[Elan Ruusamäe (glen666)]

changed to:

                        ttr_created_date BETWEEN '2014-10-13 00:00:00' AND '2014-10-19 23:59:59' AND

[Elan Ruusamäe (glen666)]

fixed

https://github.com/eventum/eventum/commit/920bfed997529a38bd3f70fb5b893b745bead754