Merge branch 'master' of github.com:webnotes/erpnext
diff --git a/hr/doctype/expense_claim/expense_claim.js b/hr/doctype/expense_claim/expense_claim.js
index 4c9a5c5..b06398e 100644
--- a/hr/doctype/expense_claim/expense_claim.js
+++ b/hr/doctype/expense_claim/expense_claim.js
@@ -33,7 +33,9 @@
callback: function(r) {
cur_frm.set_df_property("exp_approver", "options", r.message);
}
- });
+ });
+
+ cur_frm.fields_dict.employee.get_query = erpnext.utils.employee_query;
}
cur_frm.cscript.clear_sanctioned = function(doc) {
diff --git a/selling/doctype/sales_common/sales_common.py b/selling/doctype/sales_common/sales_common.py
index 8a1bce8..e672abf 100644
--- a/selling/doctype/sales_common/sales_common.py
+++ b/selling/doctype/sales_common/sales_common.py
@@ -17,12 +17,12 @@
from __future__ import unicode_literals
import webnotes
-from webnotes.utils import add_days, cint, cstr, default_fields, flt, getdate, now, nowdate
+from webnotes.utils import add_days, cint, cstr, default_fields, flt, getdate, now, nowdate, formatdate
from webnotes.model import db_exists
from webnotes.model.doc import addchild
from webnotes.model.wrapper import getlist, copy_doclist
from webnotes.model.code import get_obj
-from webnotes import form, msgprint
+from webnotes import form, msgprint, _
get_value = webnotes.conn.get_value
@@ -604,14 +604,15 @@
exact_outstanding = flt(tot_outstanding) + flt(grand_total)
get_obj('Account',acc_head[0][0]).check_credit_limit(acc_head[0][0], obj.doc.company, exact_outstanding)
- def validate_fiscal_year(self,fiscal_year,transaction_date,dn):
- fy=webnotes.conn.sql("select year_start_date from `tabFiscal Year` where name='%s'"%fiscal_year)
- ysd=fy and fy[0][0] or ""
- yed=add_days(str(ysd),365)
- if str(transaction_date) < str(ysd) or str(transaction_date) > str(yed):
- msgprint("%s not within the fiscal year"%(dn))
- raise Exception
-
+ def validate_fiscal_year(self, fiscal_year, transaction_date, label):
+ from accounts.utils import get_fiscal_year
+ if get_fiscal_year(transaction_date)[0] != fiscal_year:
+ msgprint(("%(label)s '%(posting_date)s': " + _("not within Fiscal Year") + \
+ ": '%(fiscal_year)s'") % {
+ "label": label,
+ "posting_date": formatdate(transaction_date),
+ "fiscal_year": fiscal_year
+ }, raise_exception=1)
# get against document date self.prevdoc_date_field
#-----------------------------
diff --git a/utilities/cleanup_data.py b/utilities/cleanup_data.py
index 95e1b84..6f790da 100644
--- a/utilities/cleanup_data.py
+++ b/utilities/cleanup_data.py
@@ -34,8 +34,6 @@
for t in webnotes.conn.sql("select options from tabDocField where parent='%s' and fieldtype='Table'" % d):
webnotes.conn.sql("delete from `tab%s`" % (t))
webnotes.conn.sql("delete from `tab%s`" % (d))
- webnotes.conn.sql("COMMIT")
- webnotes.conn.sql("START TRANSACTION")
print "Deleted " + d
@@ -101,8 +99,6 @@
webnotes.conn.sql("delete from `tab%s`" % (t))
lst = '"'+'","'.join(masters[d])+ '"'
webnotes.conn.sql("delete from `tab%s` where name not in (%s)" % (d, lst))
- webnotes.conn.sql("COMMIT")
- webnotes.conn.sql("START TRANSACTION")
print "Deleted " + d
@@ -131,8 +127,6 @@
for t in webnotes.conn.sql("select options from tabDocField where parent='%s' and fieldtype='Table'" % d):
webnotes.conn.sql("delete from `tab%s`" % (t))
webnotes.conn.sql("delete from `tab%s`" % (d))
- webnotes.conn.sql("COMMIT")
- webnotes.conn.sql("START TRANSACTION")
print "Deleted " + d
@@ -171,6 +165,7 @@
def run():
webnotes.connect()
+ webnotes.conn.begin()
# Confirmation from user
confirm = ''
@@ -192,14 +187,17 @@
delete_transactions()
if cleanup_type == '1':
+ print "Reset Transaction Series"
reset_transaction_series()
else:
delete_masters()
+ print "Reset All Series"
reset_all_series()
delete_main_masters()
reset_global_defaults()
print "System cleaned up succesfully"
+ webnotes.conn.commit()
webnotes.conn.close()