1 ##############################################################################
2 # Copyright (c) 2016 Max Breitenfeldt and others.
4 # All rights reserved. This program and the accompanying materials
5 # are made available under the terms of the Apache License, Version 2.0
6 # which accompanies this distribution, and is available at
7 # http://www.apache.org/licenses/LICENSE-2.0
8 ##############################################################################
11 from django.contrib.auth.models import User
12 from django.db import models
14 from jira import JIRAError
16 from dashboard.models import Resource
17 from django.conf import settings
20 class Booking(models.Model):
21 id = models.AutoField(primary_key=True)
22 user = models.ForeignKey(User, models.CASCADE) # delete if user is deleted
23 resource = models.ForeignKey(Resource, models.PROTECT)
24 start = models.DateTimeField()
25 end = models.DateTimeField()
26 jira_issue_id = models.IntegerField(null=True)
27 jira_issue_status = models.CharField(max_length=50)
29 purpose = models.CharField(max_length=300, blank=False)
34 def get_jira_issue(self):
36 jira = JIRA(server=settings.JIRA_URL,
37 basic_auth=(settings.JIRA_USER_NAME, settings.JIRA_USER_PASSWORD))
38 issue = jira.issue(self.jira_issue_id)
43 def authorization_test(self):
45 Return True if self.user is authorized to make this booking.
48 # Check if User is troubleshooter / admin
49 if user.has_perm('booking.add_booking'):
51 # Check if User owns this resource
52 if user == self.resource.owner:
56 def save(self, *args, **kwargs):
58 Save the booking if self.user is authorized and there is no overlapping booking.
59 Raise PermissionError if the user is not authorized
60 Raise ValueError if there is an overlapping booking
62 if not self.authorization_test():
63 raise PermissionError('Insufficient permissions to save this booking.')
64 if self.start >= self.end:
65 raise ValueError('Start date is after end date')
66 # conflicts end after booking starts, and start before booking ends
67 conflicting_dates = Booking.objects.filter(resource=self.resource).exclude(id=self.id)
68 conflicting_dates = conflicting_dates.filter(end__gt=self.start)
69 conflicting_dates = conflicting_dates.filter(start__lt=self.end)
70 if conflicting_dates.count() > 0:
71 raise ValueError('This booking overlaps with another booking')
72 return super(Booking, self).save(*args, **kwargs)
75 return str(self.resource) + ' from ' + str(self.start) + ' until ' + str(self.end)