Mercurial > gemma
diff pkg/controllers/importqueue.go @ 3776:6521c962a7b6
Add 'cc' parameter to search imports for a comma separated list of country codes for the the importing person.
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Tue, 02 Jul 2019 16:44:04 +0200 |
| parents | 4c254651d80b |
| children | 80bdcd137a1d |
line wrap: on
line diff
--- a/pkg/controllers/importqueue.go Tue Jul 02 11:43:12 2019 +0200 +++ b/pkg/controllers/importqueue.go Tue Jul 02 16:44:04 2019 +0200 @@ -112,6 +112,14 @@ query, query, query, query) } + if cc := req.FormValue("cc"); cc != "" { + codes := sliceToTextArray(splitUpper(cc)) + cond(" username IN "+ + "(SELECT username FROM internal.user_profiles "+ + "WHERE country = ANY($%d)) ", + codes) + } + if st := req.FormValue("states"); st != "" { states := toTextArray(st, imports.ImportStateNames) cond(" state = ANY($%d) ", states)