X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/a6f6687b468a81a0f96c108faefbfc69dd607acf..b14cf15f563feabc7015e3af99ea8cb7a1903dc1:/WEB-INF/lib/ttTimesheetHelper.class.php diff --git a/WEB-INF/lib/ttTimesheetHelper.class.php b/WEB-INF/lib/ttTimesheetHelper.class.php index 21e75a96..05832657 100644 --- a/WEB-INF/lib/ttTimesheetHelper.class.php +++ b/WEB-INF/lib/ttTimesheetHelper.class.php @@ -336,7 +336,7 @@ class ttTimesheetHelper { $sql = "select u.id, u.name, u.email". " from tt_users u". " left join tt_roles r on (r.id = u.role_id)". - " where u.status = 1 and u.email is not null". + " where u.status = 1 and u.email is not null and u.group_id = $group_id and u.org_id = $org_id". " and (r.rights like '%approve_all_timesheets%' or (r.rank > $rank and r.rights like '%approve_timesheets%'))"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) {