| @@ -149,15 +149,16 sub RedmineDSN { | |||||
| 149 | $self->{RedmineDSN} = $arg; |
|
149 | $self->{RedmineDSN} = $arg; | |
| 150 | my $query = "SELECT |
|
150 | my $query = "SELECT | |
| 151 | hashed_password, salt, auth_source_id, permissions |
|
151 | hashed_password, salt, auth_source_id, permissions | |
| 152 |
FROM |
|
152 | FROM projects, users, roles | |
| 153 | WHERE |
|
153 | WHERE | |
| 154 |
|
|
154 | users.login=? | |
| 155 | AND member_roles.member_id=members.id |
|
155 | AND projects.identifier=? | |
| 156 | AND users.id=members.user_id |
|
|||
| 157 | AND roles.id=member_roles.role_id |
|
|||
| 158 | AND users.status=1 |
|
156 | AND users.status=1 | |
| 159 |
AND |
|
157 | AND ( | |
| 160 | AND identifier=? "; |
|
158 | roles.id IN (SELECT member_roles.role_id FROM members, member_roles WHERE members.user_id = users.id AND members.project_id = projects.id AND members.id = member_roles.member_id) | |
|
|
159 | OR | |||
|
|
160 | (roles.builtin=1 AND cast(projects.is_public as CHAR) IN ('t', '1')) | |||
|
|
161 | ) "; | |||
| 161 | $self->{RedmineQuery} = trim($query); |
|
162 | $self->{RedmineQuery} = trim($query); | |
| 162 | } |
|
163 | } | |
| 163 |
|
164 | |||
General Comments 0
You need to be logged in to leave comments.
Login now