Created
May 4, 2015 11:10
-
-
Save julianwachholz/6fb35cbee8cc7b98d362 to your computer and use it in GitHub Desktop.
Python/Django written by a PHP developer
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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