def result(request):
user = Customer.objects.get(user=request.user)
amount = request.POST.get("amount")
acc = request.POST.get("acc")
acc = str(acc)
t = Transaction(previous_balance=Decimal(user.balance))
t.amount = Decimal(amount)
user2 = Customer.objects.get(account_no=acc)
u2 = User.objects.get(username=user2.user.username)
print(type(u2))
amount = Decimal(amount)
t2 = Transaction(previous_balance=Decimal(user2.balance))
t2.amount = Decimal(amount)
a = user.get_balance(amount, 1)
if a == -1:
messages.error(request, "No Balance!")
return HttpResponseRedirect(reverse('customer:profile'))
else:
user.balance = a
user2.balance = user2.get_balance(amount, 2)
user2.save()
t2.current_balance = Decimal(user2.balance)
t2.user = u2
t2.save()
t2.transaction_id = t2.get_transaction_id()
t2.type = 'Account Transfer'
t2.save()
user.save()
t.current_balance = Decimal(user.balance)
t.user = request.user
t.save()
t.transaction_id = t.get_transaction_id()
t.type = 'Account Transfer'
t.save()
return HttpResponseRedirect(reverse('customer:profile'))
def add_impress(request,firm_id):
#delete_all()
firm = Firm.objects.get(id=int(firm_id))
firm_id = int(firm_id)
if 'name' in request.session:
ledger_name = request.session['name']
del request.session['name']
return render(request, 'transaction/add_impress.html',
{'name': firm.name, 'year': firm.year, 'id': firm.id, 'ledger_name': ledger_name})
if request.user.is_authenticated():
if request.method == 'POST':
ledger = Ledger.objects.filter(firm_id=int(firm_id), name=request.POST['ledger'])[0]
input_impress = Transaction()
input_impress.ledger_id = ledger.id
input_impress.amount = request.POST['amount']
input_impress.mode = request.POST['mode']
v_no = request.POST['voucher_no']
ledgers = Ledger.objects.filter(firm_id=firm_id)
data = check_voucher_no(v_no, firm_id)
if data[0]:
obj = Transaction.objects.filter(voucher__voucher_no=v_no,ledger__firm_id=firm_id)[0]
return render(request, 'transaction/add_impress.html',
{'name': firm.name, 'year': firm.year, 'id': firm.id,
'failure': 'True', 'obj': obj,
'input_impress':input_impress,'v_no':v_no
})
for ledger in ledgers:
if ledger.name == request.POST['ledger']:
voucher_new = Voucher()
voucher_new.voucher_no = request.POST['voucher_no']
voucher_new.save()
impress = Transaction()
impress.ledger_id = ledger.pk
impress.amount = request.POST['amount']
impress.mode = request.POST['mode']
impress.description = request.POST['description']
impress.voucher_id = voucher_new.pk
impress.type = 'Credit'
impress.voucher_type = 'Impress'
impress.save()
cash = Transaction()
CASH = Ledger.objects.filter(firm_id=int(firm_id), name='Cash')[0]
cash.ledger_id = CASH.id
cash.voucher_type = 'Journal'
cash.description = impress.description
cash.amount = impress.amount
cash.mode = impress.mode
cash.type = 'Debit'
cash.save()
message = "Imprest Data has been saved !"
impresses = Transaction.objects.filter(ledger__firm_id=int(firm_id),voucher_type='Impress')
return render(request, 'transaction/impress_home.html', {'impresses':impresses,'message': message,'name':firm.name,'year':firm.year,'id':firm.id})
return render(request, 'transaction/impress_home.html',{'name':firm.name,'year':firm.year,'id':firm.id})
else:
return render(request,'transaction/add_impress.html',{'name':firm.name,'year':firm.year,'id':firm.id})
else:
return redirect('/login')
def add_firm(request):
if request.user.is_authenticated():
if request.method == 'POST':
print('INside POSt')
name = request.POST['firm_name']
year = request.POST['firm_year']
password = request.POST['pass']
password_1 = request.POST['pass_1']
if password == password_1:
firm = Firm()
firm.name = name
firm.year = year
firm.password = password
firm.save()
print('Firm Data saved')
ledger = Ledger()
ledger.name = 'Cash'
ledger.address = 'none'
ledger.mobile_no = 'none'
ledger.pan_no = 'none'
ledger.type = 'Personal'
ledger.firm_id = firm.id
ledger.save()
if request.POST['cash'] != "True":
amount = request.POST['balance']
type = request.POST['type']
entry = Transaction()
entry.ledger_id = ledger.id
entry.description = "opening balance entered"
if type == 'D':
entry.type = 'Debit'
else:
entry.type = 'Credit'
voucher = Voucher()
voucher.voucher_no = -1
voucher.save()
entry.voucher_id = voucher.id
entry.voucher_type = 'Opening'
entry.amount = amount
entry.save()
return redirect('/firm/firm_login')
else:
print('no opening balance')
return redirect('/firm/firm_login')
else:
return render(request, 'firm/add_firm.html',
{'message': 'Your passwords do not match !'})
else:
return render(request, 'firm/add_firm.html')
else:
return redirect('/login')
def amount2(request):
user = Customer.objects.get(user=request.user)
t = Transaction(previous_balance=Decimal(user.balance))
amount = request.POST.get('deposit')
t.amount = Decimal(amount)
user.balance = user.get_balance(amount, 2)
t.current_balance = Decimal(user.balance)
t.user = request.user
t.save()
t.transaction_id = t.get_transaction_id()
t.type = 'Deposit'
t.save()
user.save()
return HttpResponseRedirect(reverse('customer:profile'))
def amount(request):
user = Customer.objects.get(user=request.user)
t = Transaction(previous_balance=Decimal(user.balance))
withdraw = request.POST.get('withdraw')
t.amount = Decimal(withdraw)
a = user.get_balance(withdraw, 1)
if a == -1:
messages.error(request, "No Balance!")
else:
user.balance = a
t.current_balance = Decimal(user.balance)
t.user = request.user
t.save()
t.transaction_id = t.get_transaction_id()
t.type = 'Withdrawal'
t.save()
user.save()
return HttpResponseRedirect(reverse('customer:profile'))
def add_ledger(request, firm_id):
if request.user.is_authenticated():
form = LedgerForm(request.POST or None)
if form.is_valid():
ledger = form.save(commit=False)
ledger.firm_id = int(firm_id)
if (ledger.mobile_no == ""):
ledger.mobile_no = "XXXXXXXXXX"
if (ledger.pan_no == ""):
ledger.pan_no = "XXXXXX"
if (ledger.address == ""):
ledger.address = "Not Specified"
ledger.save()
ledgers = Ledger.objects.filter(firm_id=int(firm_id))
if request.POST['amount'] != '':
amount = request.POST['amount']
type = request.POST['mode']
open = Transaction()
open.ledger_id = ledger.id
open.amount = float(amount)
open.type = type
voucher = Voucher()
voucher.voucher_no = -1
voucher.save()
open.voucher_id = voucher.id
open.voucher_type = 'Opening'
open.save()
url = "/home/" + str(firm_id) + "/ledger_home"
return redirect(url)
else:
return render(request, 'home/add_ledger.html', {
'form': form,
'id': firm_id
})
else:
return render(request, 'login/login_admin.html')
def transaction_add(request,firm_id,ledger_id):
if request.method == 'POST':
amount = request.POST['amount']
v_no = request.POST['voucher']
description = request.POST['description']
type = request.POST['type']
date = request.POST['date']
voucher = Transaction.objects.filter(ledger__firm__id=int(firm_id),voucher__voucher_no=int(v_no))
if len(voucher) > 0 :
amount = 0.0
type = 'Credit'
firm = Firm.objects.get(id=int(firm_id))
firm_id = int(firm_id)
ledger = Ledger.objects.get(id=int(ledger_id))
transactions = Transaction.objects.filter(ledger__firm_id=firm_id, ledger__name=ledger.name)
transactions = sorted(transactions, key=lambda x: x.created,reverse=True)
for transaction in transactions:
if transaction.type == 'Credit':
amount += transaction.amount
else:
amount -= transaction.amount
if amount < 0.0:
amount = float(0 - amount)
type = 'Debit'
return render(request, 'transaction/ledger_details.html', {'transactions': transactions,
'name': firm.name, 'year': firm.year,'id':firm.id,
'error':'Voucher number already exists',
'ledger': ledger, 'amount': amount, 'type': type
})
ledger = Ledger.objects.get(id=int(ledger_id))
transaction = Transaction()
transaction.ledger_id = ledger.id
voucher = Voucher()
voucher.voucher_no = v_no
voucher.save()
transaction.voucher_id = voucher.id
transaction.amount = float(amount)
transaction.voucher_type = type
transaction.description = description
transaction.save()
if type=='Impress' or type == 'Expense':
transaction.type = 'Credit'
cash_ledger = Ledger.objects.filter(name="Cash",firm_id=int(firm_id))[0]
cash = Transaction()
voucher = Voucher()
voucher.voucher_no = -1
voucher.save()
cash.voucher_id = voucher.id
cash.ledger_id = cash_ledger.id
cash.amount = float(amount)
cash.type = 'Debit'
cash.save()
else:
transaction.type = 'Debit'
cash_ledger = Ledger.objects.filter(name="Cash", firm_id=int(firm_id))[0]
cash = Transaction()
voucher = Voucher()
voucher.voucher_no = -1
voucher.save()
cash.voucher_id = voucher.id
cash.ledger_id = cash_ledger.id
cash.amount = float(amount)
cash.type = 'Credit'
cash.save()
if date != '':
transaction.created = date
transaction.save()
amount = 0.0
type = 'Credit'
firm = Firm.objects.get(id=int(firm_id))
firm_id = int(firm_id)
ledger = Ledger.objects.get(id=int(ledger_id))
transactions = Transaction.objects.filter(ledger__firm__id=firm_id, ledger__name=ledger.name)
transactions = sorted(transactions, key=lambda x: x.created,reverse=True)
for transaction in transactions:
if transaction.type == 'Credit':
amount += transaction.amount
else:
amount -= transaction.amount
if amount < 0.0:
amount = float(0 - amount)
type = 'Debit'
return render(request, 'transaction/ledger_details.html', {'transactions': transactions,
'name': firm.name, 'year': firm.year, 'id': firm.id,
'ledger': ledger, 'amount': amount, 'type': type,
'error':"Success"
})
else:
url = "/home/" + str(firm_id) + "/ledger_home"
return redirect(url)
def add_journal(request,firm_id):
if request.method == 'POST':
ledger_main = request.POST['ledger_main']
try:
ledger = Ledger.objects.filter(firm_id=int(firm_id),name=ledger_main)[0]
except Exception as e:
print(e)
return render(request, 'transaction/add_journal.html',
{'id': int(firm_id), 'message': 'Main Ledger does not exist'})
description_main = request.POST['description_main']
type_main = request.POST['type_main']
names = request.POST.getlist('name')
vouchers = request.POST.getlist('voucher')
dates = request.POST.getlist('date')
del vouchers[len(names)-1]
amounts = request.POST.getlist('amount')
descriptions = request.POST.getlist('description')
transactions = Transaction.objects.filter(ledger__firm__id=int(firm_id),voucher__voucher_no__in=vouchers)
if len(transactions) > 0 :
return render(request, 'transaction/add_journal.html',
{'id': int(firm_id), 'message': 'A Voucher Number already exists'})
for i in range(len(names)-1): #check if all ledgers are valid
try:
ledger = Ledger.objects.filter(firm_id=int(firm_id),name=names[i])[0]
except Exception as e:
print(e)
return render(request,'transaction/add_journal.html', {'id': int(firm_id),'message':'Ledger does not exist'})
print('ready to save journal entry')
amount = 0.0
type = 'Credit'
if type_main != 'Debit' :
type = 'Debit'
for i in range(len(vouchers)):
amount += float(amounts[i])
ledger = Ledger.objects.filter(firm_id=int(firm_id),name=names[i])[0]
transaction = Transaction()
transaction.ledger_id = ledger.id
transaction.type = type
transaction.description = descriptions[i]
voucher = Voucher()
voucher.voucher_no = vouchers[i]
voucher.save()
transaction.voucher_id = voucher.id
transaction.amount = amounts[i]
transaction.save()
if dates[i] != '':
transaction.created = dates[i]
transaction.save()
ledger = Ledger.objects.filter(firm_id=int(firm_id), name=ledger_main)[0]
transaction = Transaction()
transaction.ledger_id = ledger.id
transaction.type = type_main
transaction.description = description_main
voucher = Voucher()
voucher.voucher_no = -1
voucher.save()
transaction.voucher_id = voucher.id
transaction.amount = amount
transaction.save()
return render(request, 'transaction/add_journal.html', {'id': int(firm_id), 'message': 'Success. Transactions have been saved'})
else:
if request.user.is_authenticated():
return render(request,'transaction/add_journal.html',{'id':int(firm_id)})
else:
return redirect('/login')
