def clientsetacc(request, id, id1):
if request.method == 'POST':
acc = request.POST.get('acc')
cursor.execute(
"select bank_name,bank_acc_name,bank_acc_number,bank_acc_type,bank_address,ifsc_code,swift_code,branch_name from Company where id =?",
id1)
result = cursor.fetchall()
li = list(result[0])
li1 = []
for i in li:
li1.append(i.split(sep="| "))
li = li1
ind = li[2].index(acc)
result = []
for i in li:
result.append(i[ind])
result.append(id)
sql = '''update Client set cbank_name = ?, cbank_acc_name=?, cbank_acc_number=?, cbank_acc_type=?,
cbank_address=?, cifsc_code=?, cswift_code=?, cbranch_name=? where id=?'''
cursor.execute(sql, result)
cursor.commit()
return redirect('/clientset')
else:
cursor.execute('select bank_acc_number from Company where id = {}'.format(id1))
li = cursor.fetchall()
li = list(li[0])
li = li[0].split(sep='| ')
result = []
for i in li:
result.append(i)
cursor.execute("select name from Client where id = {}".format(id))
name = cursor.fetchall()
return render(request, 'setclientaccount.html', {'accounts': result, 'client': name})
********************************************************************************************************