def add_acc_validity_date(request):
if request.user.is_authenticated():
json_obj = json.loads(request.body)
start_year = json_obj['start_year']
accountingyears = AccountingYear.objects.filter(user__id=request.user.id)
for i in accountingyears:
if i.start_date.year == start_year:
return HttpResponse(json.dumps({'validation':"This year for Financial transactions is already used by you...Please select another year..","status":False}), content_type="application/json")
end_year = start_year + 1
start_date = datetime.datetime(start_year, 04, 01, 00, 00, 00)
end_date = datetime.datetime(end_year, 03, 31, 23, 59, 59)
user_obj = User.objects.get(id=request.user.id)
accountingyear_obj = AccountingYear(start_date=start_date,end_date=end_date,duration=1,user=user_obj)
accountingyear_obj.save()
return HttpResponse(json.dumps({'validation':"New Financial Year created for your transactions...","redirecturl":"#/myAccMaster","status":True}), content_type="application/json")
else:
return HttpResponse(json.dumps({"validation":"You are not logged in yet.Please login to continue."}), content_type="application/json")
def transaction_for_account(request):
if request.user.is_authenticated():
json_obj = json.loads(request.body)
data = json_obj['data']
Acc_list = data.get("Acc_list")
transaction_date = data.get("transaction_date")
transactiontype = data.get("transactiontype")
transactiontype_obj = TransactionType(optionType=transactiontype)
transactiontype_obj.save()
user_obj = User.objects.get(id=request.user.id)
transaction_date = datetime.datetime.fromtimestamp(transaction_date/1000)
description = data.get("description")
try:
accountingyear_obj = AccountingYear.objects.get(start_date__lte=transaction_date,end_date__gte=transaction_date,user__id=request.user.id)
except AccountingYear.DoesNotExist:
if transaction_date <= datetime.datetime(transaction_date.year, 03, 31, 23, 59, 59):
start_date = datetime.datetime(transaction_date.year-1, 04, 01, 00, 00, 00)
end_date = datetime.datetime(transaction_date.year, 03, 31, 23, 59, 59)
user_obj = User.objects.get(id=request.user.id)
accountingyear_obj = AccountingYear(start_date=start_date,end_date=end_date,duration=1,user=user_obj)
accountingyear_obj.save()
else:
year = int(transaction_date.year)
start_date = datetime.datetime(transaction_date.year, 04, 01, 00, 00, 00)
end_date = datetime.datetime(transaction_date.year+1, 03, 31, 23, 59, 59)
user_obj = User.objects.get(id=request.user.id)
accountingyear_obj = AccountingYear(start_date=start_date,end_date=end_date,duration=1,user=user_obj)
accountingyear_obj.save()
transaction_obj = Transaction(transaction_date=transaction_date,description=description,transactiontype=transactiontype_obj,user=user_obj)
transaction_obj.save()
accountingyear_obj.transaction.add(transaction_obj)
accountingyear_obj.save()
for i in Acc_list:
amount = i['amount']
account = i['account']
account_id = account.get("id")
is_debit = i['is_debit']
print is_debit.capitalize()
if is_debit == "D":
is_debit = True
else:
is_debit = False
account_obj = Account.objects.get(id=account_id)
print account_obj
transactionrecord_queries = TransactionRecord(amount=amount,is_debit=is_debit,account=account_obj)
transactionrecord_queries.save()
transaction_obj.transaction_record.add(transactionrecord_queries)
transaction_obj.save()
print "Transaction saved Successfully..."
return HttpResponse(json.dumps({"validation":"Transaction Saved Successfully","status":True}), content_type="application/json")
def add_acc_validity_date(request):
if request.user.is_authenticated():
json_obj = json.loads(request.body)
start_year = json_obj['start_year']
accountingyears = AccountingYear.objects.filter(
user__id=request.user.id)
for i in accountingyears:
if i.start_date.year == start_year:
return HttpResponse(json.dumps({
'validation':
"This year for Financial transactions is already used by you...Please select another year..",
"status": False
}),
content_type="application/json")
end_year = start_year + 1
start_date = datetime.datetime(start_year, 04, 01, 00, 00, 00)
end_date = datetime.datetime(end_year, 03, 31, 23, 59, 59)
user_obj = User.objects.get(id=request.user.id)
accountingyear_obj = AccountingYear(start_date=start_date,
end_date=end_date,
duration=1,
user=user_obj)
accountingyear_obj.save()
return HttpResponse(json.dumps({
'validation':
"New Financial Year created for your transactions...",
"redirecturl": "#/myAccMaster",
"status": True
}),
content_type="application/json")
else:
return HttpResponse(json.dumps({
"validation":
"You are not logged in yet.Please login to continue."
}),
content_type="application/json")
def transaction_for_account(request):
if request.user.is_authenticated():
json_obj = json.loads(request.body)
data = json_obj['data']
Acc_list = data.get("Acc_list")
transaction_date = data.get("transaction_date")
transactiontype = data.get("transactiontype")
transactiontype_obj = TransactionType(optionType=transactiontype)
transactiontype_obj.save()
user_obj = User.objects.get(id=request.user.id)
transaction_date = datetime.datetime.fromtimestamp(transaction_date /
1000)
description = data.get("description")
try:
accountingyear_obj = AccountingYear.objects.get(
start_date__lte=transaction_date,
end_date__gte=transaction_date,
user__id=request.user.id)
except AccountingYear.DoesNotExist:
if transaction_date <= datetime.datetime(transaction_date.year, 03,
31, 23, 59, 59):
start_date = datetime.datetime(transaction_date.year - 1, 04,
01, 00, 00, 00)
end_date = datetime.datetime(transaction_date.year, 03, 31, 23,
59, 59)
user_obj = User.objects.get(id=request.user.id)
accountingyear_obj = AccountingYear(start_date=start_date,
end_date=end_date,
duration=1,
user=user_obj)
accountingyear_obj.save()
else:
year = int(transaction_date.year)
start_date = datetime.datetime(transaction_date.year, 04, 01,
00, 00, 00)
end_date = datetime.datetime(transaction_date.year + 1, 03, 31,
23, 59, 59)
user_obj = User.objects.get(id=request.user.id)
accountingyear_obj = AccountingYear(start_date=start_date,
end_date=end_date,
duration=1,
user=user_obj)
accountingyear_obj.save()
transaction_obj = Transaction(transaction_date=transaction_date,
description=description,
transactiontype=transactiontype_obj,
user=user_obj)
transaction_obj.save()
accountingyear_obj.transaction.add(transaction_obj)
accountingyear_obj.save()
for i in Acc_list:
amount = i['amount']
account = i['account']
account_id = account.get("id")
is_debit = i['is_debit']
print is_debit.capitalize()
if is_debit == "D":
is_debit = True
else:
is_debit = False
account_obj = Account.objects.get(id=account_id)
print account_obj
transactionrecord_queries = TransactionRecord(amount=amount,
is_debit=is_debit,
account=account_obj)
transactionrecord_queries.save()
transaction_obj.transaction_record.add(transactionrecord_queries)
transaction_obj.save()
print "Transaction saved Successfully..."
return HttpResponse(json.dumps({
"validation": "Transaction Saved Successfully",
"status": True
}),
content_type="application/json")