Free and open source ticket system written in python
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175from django.shortcuts import render, redirectfrom django.contrib.auth.decorators import login_requiredfrom django.shortcuts import get_object_or_404from .models import Ticket, Template, FileAttachmentfrom django.core.paginator import Paginator, EmptyPage, PageNotAnIntegerfrom django.db.models import Qfrom .forms import CommentForm, TicketForm, TemplateForm, TeamAssignmentForm, CategoryAssignmentFormfrom django.http import Http404, FileResponsefrom django.conf import settingsimport os
@login_requireddef show_tickets(request): tickets = Ticket.get_open_tickets(request.user).order_by("priority", "-updated_at") return render(request, "ticketing/tickets.html", {"tickets": tickets})
@login_requireddef show_tickets_history(request): qs = Ticket.get_closed_tickets(request.user).order_by("priority", "-updated_at")
per_page = int(request.GET.get("per_page") or 20) paginator = Paginator(qs, per_page)
page_number = request.GET.get("page") or 1 try: page_obj = paginator.page(page_number) except PageNotAnInteger: page_obj = paginator.page(1) except EmptyPage: # Show last page if page is out of range page_obj = paginator.page(paginator.num_pages)
context = { "tickets": page_obj.object_list, "page_obj": page_obj, "paginator": paginator, "is_paginated": page_obj.paginator.num_pages > 1, "per_page": per_page, } print(paginator, page_obj) return render(request, "ticketing/tickets_history.html", context)
@login_requireddef show_ticket(request, ticket_id): ticket = get_object_or_404(Ticket, pk=ticket_id) can_edit = ticket.can_edit(request.user) # comment_templates = Template.objects.filter(category=ticket.category)
if not ticket.can_open(request.user): return redirect("all_tickets")
form, template_form, team_assignment_form, category_assignment_form = CommentForm( ), TemplateForm(), TeamAssignmentForm(), CategoryAssignmentForm()
if request.method == "POST": if 'apply_template' in request.POST and can_edit: template_form = TemplateForm(request.POST) if template_form.is_valid(): template = template_form.cleaned_data["template_select"] form = CommentForm(initial={"text": template.content}) elif 'assign_to_team' in request.POST and can_edit: team_assignment_form = TeamAssignmentForm(request.POST) if team_assignment_form.is_valid(): ticket.assign_to_team( team_assignment_form.cleaned_data["team_select"]) elif 'assign_to_category' in request.POST and can_edit: category_assignment_form = CategoryAssignmentForm(request.POST) if category_assignment_form.is_valid(): ticket.category = category_assignment_form.cleaned_data["category_select"] ticket.save() elif 'assign_self' in request.POST and can_edit: ticket.assigned_to = request.user ticket.save() elif 'reopen_ticket' in request.POST and can_edit: ticket.status = Ticket.Status.IN_PROGRESS ticket.save() else: form = CommentForm(request.POST, request.FILES) if form.is_valid(): ticket.comment_set.create( user=request.user, ticket=ticket, text=form.cleaned_data["text"], is_only_for_staff=form.cleaned_data["hidden_from_client"] ) # Add attachments if form.cleaned_data["attachments"]: for file in form.cleaned_data["attachments"]: ticket.fileattachment_set.create(file=file)
if 'close' in request.POST and can_edit: ticket.close_ticket() return redirect("ticket_detail", ticket_id=ticket.id)
comments = ticket.comment_set.all() context = { "ticket": ticket, "comments": comments, "attachments": ticket.fileattachment_set.all(), "form": form, "template_form": template_form, "team_assignment_form": team_assignment_form, "category_assignment_form": category_assignment_form, "can_edit": can_edit } return render(request, "ticketing/ticket_detail.html", context)
@login_requireddef create_ticket(request):
has_closed_tickets = Ticket.objects.filter( user=request.user, status=Ticket.Status.CLOSED).exists()
if request.method == "POST": form = TicketForm(request.user, request.POST, request.FILES) if form.is_valid(): ticket = form.save(commit=False) ticket.user = request.user ticket.save()
# Add attachments if form.cleaned_data["attachments"]: for file in form.cleaned_data["attachments"]: ticket.fileattachment_set.create(file=file)
return redirect("ticket_detail", ticket_id=ticket.id) else: form = TicketForm(request.user) return render(request, "ticketing/create_ticket.html", {"form": form, "has_closed_tickets": has_closed_tickets})
@login_requireddef dashboard(request):
tickets = Ticket.objects.all().order_by("-created_at") open_tickets = tickets.filter(status=Ticket.Status.OPEN) in_progress_tickets = tickets.filter(status=Ticket.Status.IN_PROGRESS) closed_tickets = tickets.filter(status=Ticket.Status.CLOSED) return render(request, "ticketing/dashboard.html", {"tickets": tickets, "open_tickets": open_tickets, "in_progress_tickets": in_progress_tickets, "closed_tickets": closed_tickets})
@login_requireddef download_attachment(request, attachment_id): """ View that checks if the user has permission to access the ticket before serving the file. """ attachment = get_object_or_404(FileAttachment, pk=attachment_id) ticket = attachment.ticket if not ticket.can_open(request.user): raise Http404("File not found") if not attachment.file: raise Http404("File not found") try: file = attachment.file.open('rb') response = FileResponse(file, content_type='application/octet-stream') filename = os.path.basename(attachment.file.name) response['Content-Disposition'] = f'inline; filename="{filename}"' return response except (ValueError, IOError, OSError): # backwards compatibility try: old_path = os.path.join(settings.MEDIA_ROOT, attachment.file.name) if os.path.exists(old_path): file = open(old_path, 'rb') response = FileResponse(file, content_type='application/octet-stream') filename = os.path.basename(attachment.file.name) response['Content-Disposition'] = f'inline; filename="{filename}"' return response except (ValueError, IOError, OSError): pass raise Http404("File not found")