... this week, 1 for the week before, 2 for the week before that...
$timesheet_query_per_user="
SELECT DISTINCT
s.StaffUserID AS 'UserID',
(
SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) ...
... Users u ON u.UserID=s.StaffUserID
INNER JOIN Resources r ON r.ThisResourceID=s.CategoryID
INNER JOIN Teams t ON t.TeamID=s.TeamID
GROUP BY
s.LogID
ORDER BY
s.TeamID, u.Username, s.DateTimeCreated, ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.