X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=WEB-INF%2Flib%2FttTimesheetHelper.class.php;h=0583265746c5080bc51a3a62d710aac55fda1622;hb=c14bc01ae221ece2c5b78c9c39b4902cb25154d6;hp=21e75a96ddd81b3279ce95d34334b27c6d9861a1;hpb=e5486346ac0574517a4fd118f03616ec455df9a9;p=timetracker.git 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')) {