| 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 |
| Rushabh Mehta | 793ba6b | 2014-02-14 15:47:51 +0530 | [diff] [blame] | 5 | import frappe |
| 6 | from frappe import _ |
| Anand Doshi | 60666a2 | 2013-04-12 20:19:53 +0530 | [diff] [blame] | 7 | |
| Rushabh Mehta | 793ba6b | 2014-02-14 15:47:51 +0530 | [diff] [blame] | 8 | @frappe.whitelist() |
| Anand Doshi | 60666a2 | 2013-04-12 20:19:53 +0530 | [diff] [blame] | 9 | def get_leave_approver_list(): |
| Anand Doshi | e9baaa6 | 2014-02-26 12:35:33 +0530 | [diff] [blame] | 10 | roles = [r[0] for r in frappe.db.sql("""select distinct parent from `tabUserRole` |
| Anand Doshi | 60666a2 | 2013-04-12 20:19:53 +0530 | [diff] [blame] | 11 | where role='Leave Approver'""")] |
| 12 | if not roles: |
| Rushabh Mehta | 793ba6b | 2014-02-14 15:47:51 +0530 | [diff] [blame] | 13 | frappe.msgprint(_("No Leave Approvers. Please assign 'Leave Approver' Role to atleast one user.")) |
| Anand Doshi | 60666a2 | 2013-04-12 20:19:53 +0530 | [diff] [blame] | 14 | |
| 15 | return roles |
| 16 | |
| 17 | |
| Rushabh Mehta | 793ba6b | 2014-02-14 15:47:51 +0530 | [diff] [blame] | 18 | @frappe.whitelist() |
| Anand Doshi | 60666a2 | 2013-04-12 20:19:53 +0530 | [diff] [blame] | 19 | def get_expense_approver_list(): |
| Anand Doshi | e9baaa6 | 2014-02-26 12:35:33 +0530 | [diff] [blame] | 20 | roles = [r[0] for r in frappe.db.sql("""select distinct parent from `tabUserRole` |
| Anand Doshi | 60666a2 | 2013-04-12 20:19:53 +0530 | [diff] [blame] | 21 | where role='Expense Approver'""")] |
| 22 | if not roles: |
| Rushabh Mehta | 793ba6b | 2014-02-14 15:47:51 +0530 | [diff] [blame] | 23 | frappe.msgprint("No Expense Approvers. Please assign 'Expense Approver' \ |
| Anand Doshi | 60666a2 | 2013-04-12 20:19:53 +0530 | [diff] [blame] | 24 | Role to atleast one user.") |
| 25 | return roles |