| Rushabh Mehta | 3966f1d | 2012-02-23 12:35:32 +0530 | [diff] [blame] | 1 | # ERPNext - web based ERP (http://erpnext.com) |
| 2 | # Copyright (C) 2012 Web Notes Technologies Pvt Ltd |
| 3 | # |
| 4 | # This program is free software: you can redistribute it and/or modify |
| 5 | # it under the terms of the GNU General Public License as published by |
| 6 | # the Free Software Foundation, either version 3 of the License, or |
| 7 | # (at your option) any later version. |
| 8 | # |
| 9 | # This program is distributed in the hope that it will be useful, |
| 10 | # but WITHOUT ANY WARRANTY; without even the implied warranty of |
| 11 | # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
| 12 | # GNU General Public License for more details. |
| 13 | # |
| 14 | # You should have received a copy of the GNU General Public License |
| 15 | # along with this program. If not, see <http://www.gnu.org/licenses/>. |
| 16 | |
| Anand Doshi | 486f9df | 2012-07-19 13:40:31 +0530 | [diff] [blame] | 17 | from __future__ import unicode_literals |
| Brahma K | d7db2ea | 2011-07-26 19:04:13 +0530 | [diff] [blame] | 18 | |
| Rushabh Mehta | 55fd5f3 | 2012-09-26 19:00:02 +0530 | [diff] [blame^] | 19 | import webnotes |
| Brahma K | d7db2ea | 2011-07-26 19:04:13 +0530 | [diff] [blame] | 20 | |
| Rushabh Mehta | 55fd5f3 | 2012-09-26 19:00:02 +0530 | [diff] [blame^] | 21 | def get_fiscal_year_from_date(date): |
| 22 | from webnotes.utils import formatdate |
| 23 | fy = webnotes.conn.sql("""select name from `tabFiscal Year` |
| 24 | where %s between year_start_date and adddate(year_start_date, |
| 25 | interval 1 year)""", date) |
| 26 | |
| 27 | if not fy: |
| 28 | webnotes.msgprint("""%s not in any Fiscal Year""" % formatdate(date), raise_exception=1) |
| 29 | |
| 30 | return fy[0][0] |