def report_index(self, request):
report = dict()
report['have_report'] = False
occurrence = ""
if request.method == 'POST':
R_form = ReportForm(request.POST)
C_form = CancelForm(request.POST)
if R_form.is_valid():
occurrence = R_form.cleaned_data['occurrence']
report['tickets'] = Ticket.objects.filter(occurrence=occurrence).order_by('person_name')
report['how_many_sold'] = occurrence.tickets_sold()
report['how_many_left'] = occurrence.maximum_sell-occurrence.tickets_sold()
report['percentage'] = (report['how_many_sold']/float(occurrence.maximum_sell))*100
report['have_report'] = True
elif C_form.is_valid():
ticket_id = C_form.cleaned_data['ticket']
occurrence_id = C_form.cleaned_data['occurrence']
ticket = Ticket.objects.get(unique_code=ticket_id)
ticket.cancelled = True
ticket.save()
occurrence = Occurrence.objects.get(unique_code=occurrence_id)
report['tickets'] = Ticket.objects.filter(occurrence=occurrence).order_by('person_name')
report['how_many_sold'] = occurrence.tickets_sold()
report['how_many_left'] = occurrence.maximum_sell-occurrence.tickets_sold()
report['percentage'] = (report['how_many_sold']/float(occurrence.maximum_sell))*100
report['have_report'] = True
R_form = ReportForm(initial={'occurrence': occurrence})
else:
pass
else:
R_form = ReportForm()
C_form = CancelForm()
return render_to_response('admin/tickets_index.html', {
'R_form': R_form,
'C_form': C_form,
'occurrence': occurrence,
'report': report,
}, context_instance=RequestContext(request))
def report_index(self, request):
report = dict()
report["have_report"] = False
occurrence = ""
if request.method == "POST":
R_form = ReportForm(request.POST) # Report Form
C_form = CancelForm(request.POST) # Cancellation Form
D_form = DownloadForm(request.POST) # Download Form
if R_form.is_valid():
occurrence = R_form.cleaned_data["occurrence"]
report["tickets"] = Ticket.objects.filter(occurrence=occurrence).order_by("person_name")
report["how_many_sold"] = occurrence.tickets_sold()
report["how_many_left"] = occurrence.maximum_sell - occurrence.tickets_sold()
report["percentage"] = (report["how_many_sold"] / float(occurrence.maximum_sell)) * 100
report["have_report"] = True
elif C_form.is_valid():
ticket_id = C_form.cleaned_data["ticket"]
occurrence_id = C_form.cleaned_data["occurrence"]
ticket = Ticket.objects.get(unique_code=ticket_id)
ticket.cancelled = True
ticket.save()
occurrence = Occurrence.objects.get(unique_code=occurrence_id)
report["tickets"] = Ticket.objects.filter(occurrence=occurrence).order_by("person_name")
report["how_many_sold"] = occurrence.tickets_sold()
report["how_many_left"] = occurrence.maximum_sell - occurrence.tickets_sold()
report["percentage"] = (report["how_many_sold"] / float(occurrence.maximum_sell)) * 100
report["have_report"] = True
R_form = ReportForm(initial={"occurrence": occurrence})
elif D_form.is_valid():
occurrence_id = D_form.cleaned_data["occurrence"]
occurrence = Occurrence.objects.get(unique_code=occurrence_id)
tickets = Ticket.objects.filter(occurrence=occurrence).order_by("person_name")
response = HttpResponse(content_type="text/csv")
response["Content-Disposition"] = "attachment; filename=Reservation_Report.csv"
writer = csv.writer(response)
writer.writerow(
[
occurrence.show.name,
occurrence.day_formatted(),
occurrence.time_formatted(),
"Total Reserved: " + str(occurrence.tickets_sold()),
"Out of: " + str(occurrence.maximum_sell),
]
)
writer.writerow(["Person Name", "Quantity Reserved", "TimeStamp", "Cancelled?", "Collected?"])
for tick in tickets:
writer.writerow([tick.person_name, tick.quantity, tick.stamp, tick.cancelled, tick.collected])
report["tickets"] = Ticket.objects.filter(occurrence=occurrence).order_by("person_name")
report["how_many_sold"] = occurrence.tickets_sold()
report["how_many_left"] = occurrence.maximum_sell - occurrence.tickets_sold()
report["percentage"] = (report["how_many_sold"] / float(occurrence.maximum_sell)) * 100
report["have_report"] = True
R_form = ReportForm(initial={"occurrence": occurrence})
return response
else:
pass
else:
R_form = ReportForm()
C_form = CancelForm()
D_form = DownloadForm()
return render_to_response(
"admin/tickets_index.html",
{"R_form": R_form, "C_form": C_form, "D_form": D_form, "occurrence": occurrence, "report": report},
context_instance=RequestContext(request),
)
def report_index(self, request):
report = dict()
report['have_report'] = False
occurrence = ""
if request.method == 'POST':
R_form = ReportForm(request.POST) # Report Form
C_form = CancelForm(request.POST) # Cancellation Form
D_form = DownloadForm(request.POST) # Download Form
if R_form.is_valid():
occurrence = R_form.cleaned_data['occurrence']
report['tickets'] = Ticket.objects.filter(
occurrence=occurrence).order_by('person_name')
report['how_many_sold'] = occurrence.tickets_sold()
report['how_many_left'] = occurrence.maximum_sell - \
occurrence.tickets_sold()
report['percentage'] = (report['how_many_sold'] /
float(occurrence.maximum_sell)) * 100
report['have_report'] = True
elif C_form.is_valid():
ticket_id = C_form.cleaned_data['ticket']
occurrence_id = C_form.cleaned_data['occurrence']
ticket = Ticket.objects.get(unique_code=ticket_id)
ticket.cancelled = True
ticket.save()
occurrence = Occurrence.objects.get(unique_code=occurrence_id)
report['tickets'] = Ticket.objects.filter(
occurrence=occurrence).order_by('person_name')
report['how_many_sold'] = occurrence.tickets_sold()
report['how_many_left'] = occurrence.maximum_sell - \
occurrence.tickets_sold()
report['percentage'] = (report['how_many_sold'] /
float(occurrence.maximum_sell)) * 100
report['have_report'] = True
R_form = ReportForm(initial={'occurrence': occurrence})
elif D_form.is_valid():
occurrence_id = D_form.cleaned_data['occurrence']
occurrence = Occurrence.objects.get(unique_code=occurrence_id)
tickets = Ticket.objects.filter(
occurrence=occurrence).order_by('person_name')
response = HttpResponse(content_type='text/csv')
response[
'Content-Disposition'] = 'attachment; filename=Reservation_Report.csv'
writer = csv.writer(response)
writer.writerow([
occurrence.show.name,
occurrence.day_formatted(),
occurrence.time_formatted(),
'Total Reserved: ' + str(occurrence.tickets_sold()),
'Out of: ' + str(occurrence.maximum_sell)
])
writer.writerow([
'Person Name', 'Quantity Reserved', 'TimeStamp',
'Cancelled?', 'Collected?'
])
for tick in tickets:
writer.writerow([
tick.person_name, tick.quantity, tick.stamp,
tick.cancelled, tick.collected
])
report['tickets'] = Ticket.objects.filter(
occurrence=occurrence).order_by('person_name')
report['how_many_sold'] = occurrence.tickets_sold()
report['how_many_left'] = occurrence.maximum_sell - \
occurrence.tickets_sold()
report['percentage'] = (report['how_many_sold'] /
float(occurrence.maximum_sell)) * 100
report['have_report'] = True
R_form = ReportForm(initial={'occurrence': occurrence})
return response
else:
pass
else:
R_form = ReportForm()
C_form = CancelForm()
D_form = DownloadForm()
return render_to_response('admin/tickets_index.html', {
'R_form': R_form,
'C_form': C_form,
'D_form': D_form,
'occurrence': occurrence,
'report': report,
},
context_instance=RequestContext(request))
