| Rushabh Mehta | ad45e31 | 2013-11-20 12:59:58 +0530 | [diff] [blame] | 1 | # Copyright (c) 2013, Web Notes Technologies Pvt. Ltd. and Contributors |
| Rushabh Mehta | e67d1fb | 2013-08-05 14:59:54 +0530 | [diff] [blame] | 2 | # License: GNU General Public License v3. See license.txt |
| Anand Doshi | 60666a2 | 2013-04-12 20:19:53 +0530 | [diff] [blame] | 3 | |
| 4 | from __future__ import unicode_literals |
| 5 | import webnotes |
| 6 | from webnotes import _ |
| 7 | |
| 8 | @webnotes.whitelist() |
| 9 | def get_leave_approver_list(): |
| 10 | roles = [r[0] for r in webnotes.conn.sql("""select distinct parent from `tabUserRole` |
| 11 | where role='Leave Approver'""")] |
| 12 | if not roles: |
| 13 | webnotes.msgprint(_("No Leave Approvers. Please assign 'Leave Approver' Role to atleast one user.")) |
| 14 | |
| 15 | return roles |
| 16 | |
| 17 | |
| 18 | @webnotes.whitelist() |
| 19 | def get_expense_approver_list(): |
| 20 | roles = [r[0] for r in webnotes.conn.sql("""select distinct parent from `tabUserRole` |
| 21 | where role='Expense Approver'""")] |
| 22 | if not roles: |
| 23 | webnotes.msgprint("No Expense Approvers. Please assign 'Expense Approver' \ |
| 24 | Role to atleast one user.") |
| 25 | return roles |