| 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 | 9f0d625 | 2014-04-14 19:20:45 +0530 | [diff] [blame] | 13 | frappe.msgprint(_("No Leave Approvers. Please assign 'Leave Approver' Role to atleast one user")) |
| 14 | |
| Anand Doshi | 60666a2 | 2013-04-12 20:19:53 +0530 | [diff] [blame] | 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 | 9f0d625 | 2014-04-14 19:20:45 +0530 | [diff] [blame] | 23 | frappe.msgprint(_("No Expense Approvers. Please assign 'Expense Approver' Role to atleast one user")) |
| Anand Doshi | 60666a2 | 2013-04-12 20:19:53 +0530 | [diff] [blame] | 24 | return roles |
| Anand Doshi | c280d06 | 2014-05-30 14:43:36 +0530 | [diff] [blame^] | 25 | |
| 26 | def set_employee_name(doc): |
| 27 | if doc.employee and not doc.employee_name: |
| 28 | doc.employee_name = frappe.db.get_value("Employee", doc.employee, "employee_name") |