@login_requireddef scoredetail(request):
data = {
'Score':Score.objects.all(),
'score_list': Scorelist(),
'title': 'оплаты',
}
if request.method =="POST":
score_list = Scorelist(
request.POST)
if score_list.is_valid():
with connections['api_db'].cursor() as cursor:
department_name = score_list . cleaned_data [ 'department' ]
abonent_id = score_list . cleaned_data [ 'abonent_id' ]
department_id = Department.objects.get(name=department_name)
query = f"EXEC GetPobutAbonentPays
@DepartmentId='{department_id.id}' ,
@Abonentid='{abonent_id}' ,
@startdate='1.08.2019' ,
@Enddate='1.09.2019';"
cursor.execute(query)
data["abonents"] = dictfetchall(cursor)
messages.success(request, f'Ваши оплаты ')
query = f"EXEC GetPobutAbonentSaldo
@DepartmentId='{department_id.id}' ,
@Abonentid='{abonent_id}' ,
@startdate='1.01.2019' ,
@Enddate='1.09.2019';"
cursor.execute(query)
data["abonentsaldo"] = dictfetchall(cursor)
messages.success(request, f'Ваш баланс ')
return render(request, 'users/scoredetail.html', data)