carom-server/billard/models.py

113 lines
5.1 KiB
Python
Raw Permalink Normal View History

2017-02-26 12:03:18 +01:00
import logging
2018-02-11 10:56:44 +01:00
import uuid
2017-02-04 06:51:09 +01:00
from django.contrib.auth.models import User
2017-02-06 19:11:32 +01:00
from django.contrib.auth.models import User
2018-02-11 10:56:44 +01:00
from django.db import models
2017-01-03 19:26:51 +01:00
2017-02-26 12:03:18 +01:00
log = logging.getLogger(__name__)
2017-01-03 19:26:51 +01:00
2017-02-01 13:51:15 +01:00
class LocationData(models.Model):
2017-02-10 20:49:38 +01:00
client_id = models.UUIDField(blank=False, null=False, verbose_name="Client-ID")
2017-02-10 19:55:31 +01:00
desk_no = models.IntegerField(blank=False, null=False, verbose_name="Tischnummer")
2017-02-06 20:27:11 +01:00
tst = models.DateTimeField(blank=False, null=False, verbose_name="Zeitstempel")
on_off = models.BooleanField(blank=False, null=False, verbose_name="Ein/Ausgebucht")
processed = models.BooleanField(default=False, verbose_name="Verarbeitet")
2017-02-06 20:29:35 +01:00
error_msg = models.TextField(blank=True, null=True, verbose_name="Fehlermeldung")
2017-01-03 19:26:51 +01:00
2017-01-06 18:53:26 +01:00
def __str__(self):
2017-02-10 20:49:38 +01:00
return str(self.client_id)
2017-01-06 18:53:26 +01:00
2017-02-06 19:19:28 +01:00
class Meta:
verbose_name = "Standortlog"
verbose_name_plural = "Standortlogs"
2017-01-03 20:13:47 +01:00
2017-02-01 13:51:15 +01:00
class Location(models.Model):
2017-02-06 20:27:11 +01:00
users = models.ManyToManyField(User, related_name='locations', verbose_name="Benutzer")
code = models.CharField(max_length=16, unique=True, verbose_name="Code")
name = models.CharField(max_length=64, unique=True, verbose_name="Name")
street = models.CharField(max_length=64, blank=True, null=True, verbose_name="Straße")
plz = models.CharField(max_length=8, blank=True, null=True, verbose_name="Postleitzahl")
city = models.CharField(max_length=64, blank=True, null=True, verbose_name="Stadt")
phone = models.CharField(max_length=64, blank=True, null=True, verbose_name="Telefon")
email = models.EmailField(blank=True, null=True, verbose_name="Email")
url = models.URLField(blank=True, null=True, verbose_name="URL")
happy_hour_start = models.TimeField(blank=True, null=True, verbose_name='Happy Hour Start')
happy_hour_end = models.TimeField(blank=True, null=True, verbose_name='Happy Hour Ende')
2017-01-03 19:26:51 +01:00
2017-01-06 18:53:26 +01:00
def __str__(self):
return self.name
2017-02-06 19:19:28 +01:00
class Meta:
verbose_name = "Standort"
verbose_name_plural = "Standorte"
2017-01-06 18:53:26 +01:00
2017-01-03 20:13:47 +01:00
2017-02-01 13:51:15 +01:00
class Client(models.Model):
2017-02-06 20:27:11 +01:00
uuid = models.UUIDField(unique=True, default=uuid.uuid4, verbose_name="Identifier")
2018-02-11 10:59:45 +01:00
location = models.ForeignKey(Location, related_name="clients", verbose_name="Standort", on_delete=models.CASCADE)
2018-02-11 10:56:44 +01:00
report_user = models.ForeignKey(User, blank=True, null=True, verbose_name="Reporting Benutzer",
related_name='reporting_clients', on_delete=models.DO_NOTHING)
last_seen = models.DateTimeField(blank=True, null=True, verbose_name="Letzter Update")
2017-02-01 20:25:33 +01:00
def __str__(self):
2017-02-04 12:39:28 +01:00
return '{}, {}'.format(self.location.name, self.uuid)
2017-02-01 20:25:33 +01:00
2017-02-06 19:19:28 +01:00
class Meta:
verbose_name = "Client"
verbose_name_plural = "Clienten"
2017-02-01 20:25:33 +01:00
class Desk(models.Model):
2018-02-11 10:59:45 +01:00
client = models.ForeignKey(Client, verbose_name='Client', related_name='desks', on_delete=models.CASCADE)
desk_no = models.IntegerField(verbose_name='Tischnummer')
name = models.CharField(max_length=32, blank=True, null=True, verbose_name='Tischbezeichnung')
enabled = models.BooleanField(verbose_name='Tisch aktiv')
2017-02-20 18:49:55 +01:00
prize = models.DecimalField(max_digits=5, decimal_places=2, default=0.0, verbose_name="Normalpreis")
prize_hh = models.DecimalField(max_digits=5, decimal_places=2, blank=True, null=True,
verbose_name="Preis Happy Hour")
def __str__(self):
return '{}, {}'.format(self.client.uuid, self.name)
class Meta:
verbose_name = "Tisch"
verbose_name_plural = "Tische"
2017-02-01 20:25:33 +01:00
class Accounting(models.Model):
2018-02-11 10:59:45 +01:00
desk = models.ForeignKey(Desk, verbose_name="Tisch", on_delete=models.CASCADE)
2017-02-06 20:27:11 +01:00
time_from = models.DateTimeField(verbose_name="Beginn")
time_to = models.DateTimeField(blank=True, null=True, verbose_name="Ende")
prize = models.DecimalField(max_digits=6, decimal_places=2, blank=True, null=True, verbose_name="Preis")
2017-02-11 10:23:03 +01:00
billed = models.BooleanField(default=False, verbose_name="Abgerechnet")
2017-02-27 07:58:06 +01:00
reporter_uuid = models.UUIDField(blank=True, null=True, verbose_name='Reporter UUID')
2018-02-11 10:56:44 +01:00
prize_normal = models.DecimalField(max_digits=5, decimal_places=2, blank=True, null=True,
verbose_name="Preis Normalzeit")
prize_hh = models.DecimalField(max_digits=5, decimal_places=2, blank=True, null=True,
verbose_name="Preis Happy Hour")
2017-04-26 10:17:19 +02:00
account_user = models.CharField(blank=True, null=True, max_length=128, verbose_name="Abr. Benutzer")
2017-04-29 11:15:26 +02:00
account_tst = models.DateTimeField(blank=True, null=True, verbose_name="Abr. TST")
2017-02-01 20:25:33 +01:00
2017-01-06 18:53:26 +01:00
def __str__(self):
2017-02-11 10:23:03 +01:00
return '{}: {} -> {}, {}, {}'.format(self.desk, self.time_from, self.time_to, self.prize, self.billed)
2017-01-06 18:53:26 +01:00
2017-02-01 20:25:33 +01:00
class Meta:
ordering = ['-time_from']
2017-02-06 19:19:28 +01:00
verbose_name = "Buchhaltungseintrag"
2017-02-06 19:11:32 +01:00
verbose_name_plural = "Buchhaltungseinträge"
class ClientData(models.Model):
uuid = models.UUIDField(verbose_name="Identifier")
last_seen = models.DateTimeField(verbose_name="Letzter Update")
def __str__(self):
return '{}, {}'.format(self.uuid, self.last_seen)
class Meta:
verbose_name = "Client Data logs"
verbose_name_plural = "Client Data logs"