Skip to content

Instantly share code, notes, and snippets.

@julianwachholz
Created May 4, 2015 11:10
Show Gist options
  • Save julianwachholz/6fb35cbee8cc7b98d362 to your computer and use it in GitHub Desktop.
Save julianwachholz/6fb35cbee8cc7b98d362 to your computer and use it in GitHub Desktop.
Python/Django written by a PHP developer
def tadastaffregister(request):
if request.method == "POST":
start_date = request.POST['start_date']
end_date = request.POST['end_date']
result = []
date = 0
staff_member = []
staff = []
list_item = []
total = 0
for team in SuspenseClearance.objects.filter(clear_date__range =\
(start_date,end_date)).values('field_testing_staff','voucher_no',\
'clear_date'):
date = team['voucher_no']
list_item.append(team['voucher_no'])
for order_id in VoucherId.objects.filter(voucher_no = \
team['voucher_no']).values('purchase_order_of_session', \
'purchase_order_id'):
list_item.append(order_id['purchase_order_of_session'])
for order in PurchaseOrder.objects.filter(id = \
order_id['purchase_order_id']).values('buyer_id'):
for user_name in User.objects.filter(id = \
order['buyer_id']).values('first_name','last_name'):
list_item.append(user_name['first_name']+","+ \
user_name['last_name'])
for username in Address.objects.filter(id = \
order['buyer_id']).values('street_address','district'):
list_item.append(username['street_address']+" " \
+username['district'])
for team_member in team['field_testing_staff'].split(","):
for team_details in Staff.objects.filter(code = \
team_member).values('name','daily_ta_da','code'):
staff_member.append(team_details['name'])
staff_member.append(team_details['daily_ta_da'])
staff_member.append(team_details['code'])
total = total + team_details['daily_ta_da']
staff.append(staff_member)
staff_member = []
list_item.append(team['clear_date'])
list_item.append(staff)
result.append(list_item)
list_item.append(total)
total = 0
list_item = []
staff = []
return render(request,'reports/tada_staff_register.html', \
{'data':result})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment